Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Information for Decisions

Authors: John J. Wild

9th edition

1259917045, 978-1259917042

More Books

Students also viewed these Accounting questions

Question

understand the selection bias in contemporary work psychology;

Answered: 1 week ago