Question: please help! Can you please provide algebric model too please Nash Auto has two plants, two warehouses, and three customers. The plants are in Detroit

please help!

Can you please provide algebric model too please

please help! Can you please provide algebric

Nash Auto has two plants, two warehouses, and three customers. The plants are in Detroit and Atlanta, the warehouses are in Denver and New York, and the customers are in Los Angeles, Chicago, and Philadelphia. Cars are produced at plants, then shipped to warehouses, and finally shipped to customers. No direct shipments are allowed from plants to customers. Detroit can produce 200 cars per week, and Atlanta can produce 160 cars per week. Los Angels requires 80 cars per week, Chicago requires 70, and Philadelphia requires 60. Assume that during a week, at most 75 cars can be shipped from a warehouse to any particular city. The costs of shipping a car between various cities are listed in the table below: To LA Chicago Philly From Detroit Atlanta Denver Denver $1,253 $1,398 NY $637 $841 NY $1,059 $2,786 $996 $1,691 $802 $250 Use Excel model to determine an optimal shipping plan that meets Nash's weekly demands at minimum cost

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!