Please help with step by step input of solver and parameters: Christian Felb tutor just helped me with another question and was great.

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 warehouses is as follows: The plant at St. Louis can supply 250 tons of carpet per week, and the plant at Richmond can supply 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. Solve this problem using Excel Solver.

3. (15 pt) 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 warehouses is as follows: To 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 supply 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. Solve this problem using Excel Solver