please Answer questions E to I please

Question 2 CWD Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines a shaper and a grinder. The times (in minutes) required on each machine are as follows: Component Machi 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 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, S6, and $9, respectively. Let C = units of component 1 manufactured C2 = units of component 2 manufactured C; = units of component 3 mamfactured Max s.t. 8C + 6. + 4C + 6C + 40 + 5C + 9C; 4C; S 7200 2C; S 6600 C; S 200 S 1000 S 1000 . C Answer the following questions (1) using the output below please be brief. If there are two possible answers one will suffice. Where necessary a range analysis must be shown (hint convert to minutes) a) What is the optimal solution (in words? (2 marks) b) An additional 4 hours of shaper time became available. Evaluate the effect? Explain ( 3 marks) c) Two hours of Grinder time was lost. Evaluate the effect? (3 marks) d) An additional 20 units of component 3 was requested. Evaluate the effect (3 marks e) The demand for component 2 decreased by 30 units. Evaluate the effect (3 marks) Suppose that the profit contribution of component increases to $9.00 What is the new optimal solution? 2 marks B) Suppose that the profit contribution of component 3 decrease by $2.00. Would the optimal solution change 3 marks h) is the problem degenerate? Explain! (2 marks) D Are there alternative optima in this problem? Explain (2 marks) Microsoft Excel 14.0 Answer Report Report Created: 10/16/2015 2:52:09 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Objective Cell (Max) Cell Name Original Value Final Value SES Profit 0 10800 Variable Cells Cell Name Original Value Final Value Integer 0 0 0 600 Contin 700 Contin 200 Contin $B$2 number of units ci $C$2 number of units c2 $D$2 number of units c3 Constraints Cell Name $E$10 C1 minimum $E$5 Shaper Slack 0 0 300 $E$6 $E$7 Grinder C3 maximum Cell Value Formula Status 600 $E$10>=$G$10 Binding 7200 SE$5