HELP PLEASE!!!! Please answer all in excel

Chapter 4 - Linear Programming Applications in Marketing, Finance and Operations Management 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 $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: 1 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. b. Formulate a linear programming model for minimizing total purchasing cost. Solve the linear program formulated in part (a). using the MS Excel Solver. 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 / purchased from supplier /