Question: Please Answer for me! Thanks! QUESTION 4 90 points Save Answer Student must use the excel to complete the following four questions and upload a

Please Answer for me! Thanks!

Please Answer for me! Thanks! QUESTION 4 90

QUESTION 4 90 points Save Answer Student must use the excel to complete the following four questions and upload a single excel file to Blackboard. Question 4 20 points Plants A, B, C, and D produce the same item that is demanded by customers W, X, Y, and Z in the amounts shown in the table. The cost to ship one unit between each combination of plants and customers is also shown in the table. The corporation wishes to minimize the total transportation costs of this assignment problem. Decide the amount of assignment by using Excel Solver. Recall "C08 solver.xls" W X Y Z Total Supply A $6 $4 $22 20,000 B $7 $10 $8 $26 19,000 $10 $23 $21 $9 14,000 D $29 $15 $13 $11 17,000 Total Demand 22,000 15,000 18,000 15,000 $12

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 General Management Questions!