Given the following: Assume that the cost per unit to ship is $9.00 for Origin of Cleveland to all four destinations of Boston, Chicago, St. Louis, and Lexington.
1. What is the minimal transportation cost if all other variables remain equal?
2. What is the minimal cost of transportation if the cost per unit to ship is $7.00 for all origins to all destinations?
3. What are the implications for this business if the total costs to all destinations increase? If the total costs decrease?
4. Provide a brief narrative on your transportation problem. Describe the importance of the use of Solver and this Excel file for business and industry. Insert this narrative as a text box in the Excel file.
 
 
Assignment: Transportation Problem
Assignment: Transportation Problem
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeContent
All requirements of the assignment are met. Calculations are correct. 70 pts
Full Marks 0 pts
No Marks
70 pts
This criterion is linked to a Learning OutcomeJustification
Implications for increase/decrease clearly explained.
Narrative content demonstrates sufficient elaboration and explanation of calculations. 20 pts
Full Marks 0 pts
No Marks
20 pts
This criterion is linked to a Learning OutcomeMechanics
File is organized and has a logical sequence 10 pts
Full Marks 0 pts
No Marks