EUP1501 assignment 8 excel

EXERCISE 1:

Exercise 1:

Total Cost
R
140.00
R
720.00
R 1
500.00
R 6
250.00
R 7
500.00
R 9
200.00
R 10
400.00
R 17
400.00
R 20
370.00
R 20
200.00
R 93
680.00




Pricing Table
Price/
No of Units Unit
1 70
10 60
100 50
200 40
500 30
1000 20




Exercise 1:

Delivery Method Unit Sold Total Cost
Ship 2 =VLOOKUP(B14,A4:B9,2,TRUE)*

, B14
=VLOOKUP(B15,A4:B10,2,TRUE)*
Rail 12 B15
=VLOOKUP(B16,A4:B9,2,TRUE)*
Air 25 B16
=VLOOKUP(B17,A4:B9,2,TRUE)*
Rail 125 B17
=VLOOKUP(B18,A4:B9,2,TRUE)*
Road 150 B18
=VLOOKUP(B19,A4:B9,2,TRUE)*
Road 230 B19
=VLOOKUP(B20,A4:B9,2,TRUE)*
Air 260 B20
=VLOOKUP(B21,A4:B9,2,TRUE)*
Truck 580 B21
=VLOOKUP(B22,A4:B9,2,TRUE)*
Ship 679 B22
=VLOOKUP(B23,A4:B9,2,TRUE)*
Truck 1010 B23
=SUM(C14:C23)




Exercise 2:

Delivery Table

Method
Ship
Truck
Road
Rail
Air


Sales Table
Unit Delivery
=VLOOKUP(A14,D4:E8,2,FALSE)
=VLOOKUP(A15,D5:E9,2,FALSE)
=VLOOKUP(A16,D6:E11,2,FALSE)
=VLOOKUP(A17,D7:E12,2,FALSE)
=VLOOKUP(A18,D4:E8,2,FALSE)
=VLOOKUP(A19,D4:E8,2,FALSE)
=VLOOKUP(A20,D4:E8,2,FALSE)
=VLOOKUP(A21,D4:E8,2,FALSE)
=VLOOKUP(A22,D4:E8,2,FALSE)