Problem 3 (26 points) Delta Manufacturing makes three components for a furniture company. The three components are processed using two machines: a shaper and a grinder. The times in minutes) required on each machine are as follows: Machine Component Shaper Grinder The shaper is available for 120 hours, and the grinder is available for 110 hours. No more than 200 units of component 3 can be sold, but up to 1000 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, $6, and $9, respectively. a. Formulate an LP model for this problem b. Solve the problem using Solver. c. What are the objective coefficient ranges for the three components? Interpret these ranges for company management. d. What are the range for the right-hand-side of each constraint? Interpret these ranges for company management. e. If more time could be made available on the grinder, how much would it be worth? f. If more units of component 3 can be sold by reducing the sales price by $4, should the company reduce the price