The weedwacker Company manufactures two types of lawn trimmers: an electric model and a gas model. The company has contracted to supply a national discount retail chain with a total of 30,000 electric trimmers and 15.000 gas trimmers. However, Weedwacker production capability is limited in three departments, production, assembly and packaging. The following table summarizes the hours of processing time available and the processing time required by each department, for both types of trimmers: Production Assembly Packaging Hours Required per Trimmer Electric Gas Hours Available 0.20 0.40 10.000 0.30 0.50 12.000 0.10 0.10 5,000 The company makes its electric trimmer in-house for $62 and its gas trimmer for $85. Alternatively, it can buy electric and gas trimmers from another source for $67 and $95. respectively. How many gas and electric trimmers should Weedwacker make, and how many should it buy from its competitor in order to fulfill its contract in the least costly manner? Solve each part on a separate worksheet or tab in your EXCEL file if needed. a. Formulate an LP model for this problem. Write out the linear optimization problem being solved. (7 pts) b. Develop a spreadsheet model in EXCEL to solve the problem and solve it. (7 pts) c. What is the optimal solution? (4 pts) Using the Sensitivity Report, answer the following questions: d. How much would gas trimmers have to cost to produce before for the company to consider purchasing them rather than making them? (2 pts) e. If the cost to make electric trimmers increased to $65 per unit, how much would the optimal solution change? (3 pts) f. How much should the company be willing to pay to acquire additional capacity in each production area? (2 pts)