Question

Sound Track Stereos assembles its high-fidelity stereophonic systems at three plants and distributes them from three regional warehouses. The production capacities at each plant, demand at each warehouse, and unit shipping costs are presented in the following table: Sound Track Stereos To From Plant W Plant Y Plant Z Warehouse demand WarchouscA Warchousc B Warchousc C Plant Ca $6 $10 $12 250 S4 S5 S9 S6 S8 200 175 75 001450 100 150 a) Set up this transportation problem by adding a dummy plant. Then, determine the cost of the optimal shipping solution. Total cost- s3950 (enter your response as a whoie number).

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Cost Plant W Plant Y plant Z Warehouse A Warehouse B Warehouse C 4 10 Allocation Warehouse A Warehouse B Warehouse C Plant W Plant Y plant Z Dumm Capacity 0.0 61.0 39.0 0.0 100 100 200 F9 SUM(C9:E9) 175 200.0 0.0 0.0 50.0 0.0 200.0 175 75 10 114.0 36.0 0.0 75 12 13 14 15 16 17Minimize Total cost 50 >0 C13:SUM(C9:C12) 2,750.00 SUMPRODUCT(C3:E5,C9:E11) In this problem, we need to minimize cost, since in business we need to reduce transportation cost. Also, the Dummy plant absorbs 50 units of material moving from Warehouse A which means of the demand of 250 units in A only 200 will be catered since Cost of transportation from Plant W to W/h A is lowest, for others it is higher than moving to any other warehouse 21 23 24Answer. Total cost is $3950

Add a comment
Know the answer?
Add Answer to:
Sound Track Stereos assembles its high-fidelity stereophonic systems at three plants and distributes them from three...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • BADM 3963 Transportation & Assignment models homework Write the formulations for #1, 2, 3 in a Wo...

    BADM 3963 Transportation & Assignment models homework Write the formulations for #1, 2, 3 in a Word document NOTE: for decision variables, you may type them as X11, X12, X13 etc without subscripting format. Solve the transportation problems #4, 5 on the tables in the same Word document- show work on the table as well as reporting the solution and cost. Submit Word file in BB Assignment Due 4/25, 9pm 1. Consider a small company with three sources of supply:...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT