Need help solving using excel ASAP! Total Shipping cost? Products shipped from B

Question

Need help solving using excel ASAP!

Total Shipping cost?

Products shipped from B to 4?

Total Cost to ship from A to I?

Products shipped from C to 1?

All the info is provided in the screenshot below

Problem 2 15 Points. Enter Answers in Yellow Boxes Total Shipping cost 0 Determine the lowest cost to ship Products shipped from B to 4= Plants Warehouse Stores Total Cost to ship from A to Units Made Demanded Products shipped from C to 1 65 70 B 75 IV 51 FromIo Costs $ 425 $ 350 $ 575 $ 650 $ 450 $ 600 $ 300 FromIo Costs $ 375 2 $ 300 $ 650 $ 500 3 % 400 $ 300 450 $ 600 5 625 $ 600 7 $ 700 5

Explanation / Answer

Total Shipping cost? 2425 Products shipped from B to 4? 900 Total Cost to ship from A to I? 425 Products shipped from C to 1? 1100 Total adding shipping costs 2425 USD To ship from A to I 425 To ship from C to 1 option 1 C to II 600 II to 1 500 Total 1100 To ship from B to 4 option 1 B to III 450 III to 4 450 Total 900 option 2 B to I 650 I to 4 650 Total 1300 option 1 is less expensive 900

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---