NEW HERE? USE "AFORUM20" TO GET GET 20 % OFF CLAIM OFFER

UK: +44 748 007-0908 USA: +1 917 810-5386
My Orders
Register
Order Now

The cost per unit to ship

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. What is the minimal transportation cost if all other variables remain equal? What is the minimal cost of transportation if the cost per unit to ship is $7.00 for all origins to all destinations? What are the implications for this business if the total costs to all destinations increase? If the total costs decrease? 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​‌‍‍‍‌‍‍‌‍‌‌‍‍‍‌‍‌‌‌‍​.