Question: is this how we should calculate unit delivery using vlookup? U Ghanchi EUP1501 Assign A B C Pricing Table D Delivery Table E No of

is this how we should calculate unit delivery using vlookup?

is this how we should calculate unit delivery using vlookup? U Ghanchi

U Ghanchi EUP1501 Assign A B C Pricing Table D Delivery Table E No of W N Units Price/ Unit Method R/unit 1 R 70.00 Ship R 10 R 1.00 60.00 Truck R 100 R 1.50 50.00 Road R 200 R 2.00 40.00 Rail R 2.50 500 R 30.00 Air R 1000 R 3.00 20.00 10 Sales Table Delivery 11 Method Units Sold Total Cost Unit Delivery Total Delivery Deli 12 Ship 2 R 140.00 R 2.00 R 142.00 F 13 Rail 12 R 720.00 R 30.00 R 14 Road 750.00 R 150 R 7,500.00 R 300.00 R 7,800.00 R 15 Air 260 R 10,400.00 R 780.00 R 11,180.00 F 16 Truck 580 R 17,400.00 R 870.00 R 17 Truck 1010 R 18,270.00 R 20,200.00 R 1,515.00 R R 18 Ship 21,715.00 679 R 20,370.00 R 679.00 R 19 Road 230 R 21,049.00 R 9,200.00 R 460.00 R 9,660.00 R 20 Rail 125 R 6,250.00 R 312.50 R 6,562.50 R 21 Air 25 R 1,500.00 R 75.00 R 1,575.00 R 22 23 24 25

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!