EUP1501
ASSIGNMENT 8
PORTFOLIO 2022
, Assignment 8: Learning more about Excel
STUDENT NUMBER: 51631253
EXERCISE 1- DETERMINING TOTAL COST
Delivery Unit Total Cost Formula
Method Sold
Ship 2 R 140.00 =LOOKUP(B12,$A$3:$B$8,$B$8)*B12
)
Rail 12 R 720.00 =LOOKUP(B13,$A$3:$B$8,$B$8)*B13
)
Road 150 R 7 500.00 =LOOKUP(B14,$A$3:$B$8,$B$8*B14)
Air 260 R 10 =LOOKUP(B15,$A$3:$B$8,$B$8*B15)
400.00
Truck 580 R 17 =LOOKUP(B16,$A$3:$B$8,$B$8*B16)
400.00
Truck 1010 R 20 =LOOKUP(B17,$A$3:$B$8,$B$8*B17)
200.00
Ship 679 R 20 =LOOKUP(B18,$A$3:$B$8,$B$8*B18)
370.00
Road 230 R 9 200.00 =LOOKUP(B19,$A$3:$B$8,$B$8*B19)
Rail 125 R 6 250.00 =LOOKUP(B20,$A$3:$B$8,$B$8*B20)
Air 25 R 1 500.00 =LOOKUP(B21,$A$3:$B$8,$B$8*B21)
EXERCISE 2 – DETERMINING UNIT DELIVERY
Delivery Unit Formula
Method delivery
Ship 1 =LOOKUP(A12,D3:E7,2,FALSE)
Rail 2.5 =LOOKUP(A13,D4:E8,2,FALSE)
Road 2 =LOOKUP(A14,D4:E9,2,FALSE)
Air 3 =LOOKUP(A15,D3:E7,2,FALSE)
Truck 1.5 =LOOKUP(A16,D3:E7,2,FALSE)
Truck 1.5 =LOOKUP(A17,D4:E8,2,FALSE)
Ship 1 =LOOKUP(A18,D3:E7,2,FALSE)
Road 2 =LOOKUP(A19,D4:E8,2,FALSE)
Rail 2.5 =LOOKUP(A20,D3:E7,2,FALSE)
Air 3 =LOOKUP(A21,D3:E7,2,FALSE)
EXERCISE 3 – DETERMINING TOTAL DELIVERY
Delivery Total Formula
Method deliver