STEP BY STEP USING EXCEL, PLEASE DO NOT SKIP ANY STEPS I AM AN EXCEL BEGINNER

FiberTech makes newsprint for newspapers at three mills, A, B, and C. The cost of producing newsprint is estimated to be $210 at mill A, $225 at B, and $220 at C. Five primary geographical markets are served from these mills. The monthly demand at each market, the shipping cost (per ton) between each mill and market, and the monthly production capacity of each mill are given in the table. Shipping Cost per ton Market Mills 123 A $20 $25 $30 B $30 $20 $32 C $25 $18 $28 4 $15 $28 $23 5 $35 $19 $31 Capacity (tons/month) 1200 1500 900 600 100 500 800 500 Monthly Demand (tons) FiberTech would like to assign production responsibilities to the mills, and also specify how much should be shipped from each plant to each market, so as to minimize total production and distribution costs. a. What is the optimal solution? b. When the optimal solution is obtained, complete the table in the answer sheet showing how much should be shipped from each plant to each market