D Based on Enclosure A and Enclosure B, we would like to know the optimal production quantity for each product (SC-A, SC-B, SC-C, SC-D, S-10, S-20, S- 30, S-40). The goal is to maximize the total profit. We would also like to do the sensitivity analysis. First, formulate the problem as a linear programming model. Then, solve the problem using Excel and answer the following questions. 1 pts D Question 1 Given the current resources in Enclosure A and the unit profits in Enclosure B, what is the optimal production quantity for SC-A? Please round your answer to the nearest integer and type it below. 0 Question 2 1 pts Recall from the case that the workers could potentially work 5% overtime in D Question 2 1 pts Recall from the case that the workers could potentially work 5% overtime in Finishing. Should the manager use this additional overtime for finishing? Hint: conduct a sensitivity analysis. No O Not enough information to make a judgment O Yes Question 3 1 pts Recall from the case that the workers could potentially work 4% overtime in assembly. Should the manager use this additional overtime for assembly? Hint: conduct a sensitivity analysis. Not enough information to make a judgment Yes No Wood Trim lin. Granite bd.-ft. ft. sq. ft. 27 42 35 52 SemiCustom Line SC-A 125 SC-B 160 0 SC-C 140 0 SC-D 200 Standard Line S-10 60 21 S-20 110 28 135 S-30 200 50 OF 254 S-40 180 43 0 0 176 Available 400,000 140,000 45.000 150,000 400,000 Profit/Unit SemiCustom Line 1 ENCLOSURE A BILLS OF MATERIALS AND LABOR Solid Surface sq. ft. Laminate sq. ft. Finish Assembly Labor Labor hrs. hrs. 37 57 30 35 21 30 27 100,000 SC-A $325 SC-B $575 SC-C $257 SC-D $275 S-10 $175 S-20 $210 S-30 $260 S-40 $230 Standard Line 175 243 0 0 0 160 140 112 ENCLOSURE B: PROFITS 12 25,000