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

 

 

We can handle this paper for you

We Guarantee ZERO Plagiarism ZERO AI

Done by Professional writers from scratch