Problem 8-25 (Algorithmic) Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the and the cost per hour to perform the work are shown here: ber of hours available for the final finishing operation, Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3 Hours required to complete all the oak cabinets Hours required to complete all the cherry cabinets Hours available 40 $32 25 Cost per hour $43 complete 40/50 = 0.8, or 809%, of the oak cal worked only on cherry cabinets. a. Formu leting both projects. Let 01 = P ion of Oak cal 02 = proportion of Oak cabinets assigned to cabinetmaker 2 03 = P ion of Oak cal Ci = proportion of Cherry cabinets assigned to cabinetmaker 1 Cz = proportion of Cherry cabinets assigned to cabinetmaker 2 C3 = proportion of Cherry cabinets assigned to cabinetmaker 3 ours avail. 1 01, 02, 03, C1, C2, C3 2 0 b. Solve the model formulated in part (a). What proportion of the of binets and what proportion of the cherry cabinets should bea places, and for the total cost to two decimal places. Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3 Cherry Ci = Total Cost = $ c. If Cabinetmaker 1 has addition would the optimal solution change? Explain. The input in the box below will not be graded, but may be reviewed and considered by your instructor. d. If Cabinetmaker 2 has additional hours available, would the optimal solution change? Explain . The input in the box below will not be graded, but may be e. Suppose Cabinetmaker 2 reduced its cost to $38 per hour. What effect would this change have on the optimal solution? If imal places, and for the total cost to two decimal places. Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3 * 01 = 02 = 03 = Cherry C1 = C2 = C3= Total Cost = $ Explain The input in the box below will not be graded, but may be reviewed and considered by your instruct