Question 5 (20 points). Edwards Manufacturing Company purchases two component parts from three different

Question: Question 5 (20 points). Edwards Manufacturing Company purchases two component parts from three different sup- pliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2See the answerSee the answerSee the answer done loadingShow transcribed image text(a) Min Z = total cost = 12 x11 13 x12 14 x13 10 x21 11 x22 10 x23 Subject to, x11 x12 x13 = 1000 [Component-1 requi…View the full answerTranscribed image text: Question 5 (20 points). Edwards Manufacturing Company purchases two component parts from three different sup- pliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $12 $13 $14 2 $10 $11 $10 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: 2 3 Supplier Capacity 600 1000 800 If the Edwards production plan for the next period includes 1000 units of component 1 and 800 units of component 2, what purchases do you recommend? a. Formulate a linear programming model for minimizing total purchasing cost. Solve the linear program formulated in part (a). using the MS Excel Solver. b. Provide screenshots for each excel sheet Your model sheet, excel solver screen (I want to see your inputs to solver), answer report, sensitivity analysis (see Appendix for examples). If you will miss to provide the screenshot for MS Excel Solver Solution, you will be graded for zero for the solution part. That is, how many units of each component should be ordered from each supplier? What is the total purchase cost for the components? Let x₁ = units of component i purchased from supplier /