Green Valley Mills produces carpet at plants in St Louis and Richmond. The plants ship the carpet to two outlets in Chicago and Atlanta. The cost per ton of shipping carpet from each of the two plants to the two warehoused is as follows:
From Chicago Atlanta
St Louis $40 $65
Richmond $70 $30
The plant at St Louis can supply 250 tons of carpet per week, and the plant at Richmond can pull 400 tons per week. The Chicago outlet has a demand of 300 tons per week; the outlet at Atlanta demands 350 tons per week. Company managers want to determine the number of tons of carpet to ship from each plant to each outlet in order to minimize the total shipping cost.
a. solve the model using the computer.
Please help with solving model using the computer.
Excel file contains formulation and optimal solution of linear programming problem.