Question: Please provide a step-by-step solution in excel or manual Problems 1. Green Valley Mills produces carpet at plants in St. Louis and Richmond. The carpet

Please provide a step-by-step solution in excel or manualPlease provide a step-by-step solution in excel

Problems 1. Green Valley Mills produces carpet at plants in St. Louis and Richmond. The carpet is then shipped to two outlets, located in Chicago and Atlanta. The cost per ton of shipping carpet from each of the two plants to the two warehouses is as follows: To (cost) From Chicago Atlanta $65 St. Louis Richmond $40 70 30 The plant at St. Louis can supply 250 tons of carpet per week; the plant at Richmond can supply 400 tons per week. The Chicago outlet has a demand of 300 tons per week, and the outlet at Atlanta demands 350 tons per week. The company wants to know the number of tons of carpet to ship from each plant to each outlet in order to minimize the total shipping cost. Solve this transportation

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!