PLEASE SHOW WHAT TO INPUT INTO EXCEL AND SOLVER FOR OPTIMAL SOLUTION AS WELL

10. Hatcher Enterprises uses a chemical called Rbase in production operations at five divi- sions. Only six suppliers of Rbase meet Hatcher's quality control standards. All six suppli- ers can produce Rbase in sufficient quantities to accommodate the needs of each division. The quantity of Rbase needed by each Hatcher division and the price per gallon charged by cach supplier are as follows: Division Supplier 1 2 Demand (1000s of gallons) 40 45 50 35 45 2 3 4 Price per Gallon ($) 12.60 14.00 10.20 14.20 12.00 13.00 6 Chapter 6 Distribution and Network Models The cost per gallon (S) for shipping from each supplier to each division is provided in the following table: Supplier Division 1 2 3 4 5 6 2.50 2.75 1.00 2 3 2.75 0.80 4.70 2.60 3.40 3.15 5.40 5.30 4.40 5.00 0.20 2.60 1.80 0.40 2.80 1.20 2.80 2.40 1.20 2.75 3.40 6.00 5.00 2.60 5.60 2.80 3.60 5 Hatcher believes in spreading its business among suppliers so that the company will be less affected by supplier problems (e.g., labor strikes or resource availability). Company policy requires that each division have a separate supplier. a. For each supplier-division combination, compute the total cost of supplying the division's demand b. Determine the optimal assignment of suppliers to divisions