b

A programming computer package is needed Georgia Cabinets manufactures Kitchen Cabinets that are sold to local dealers thout the Southeast Because of a large backlog of orders for and there, the company decided to content with three smaller caters to do the fingertion for the three cabinetmakers, the number of hours retred to call the skinets, the number of her to cite at the chany cabinets, the number of hours available for the finishing operation, and the cost per hour to perform the work are shown here Cabinetmaker 1 Cabinetmaker 2 Cabinetaker Hours required to complete all the oak cabinets 30 43 30 Hours required to complete all the cherry cabinets 60 35 How available 40 30 35 Cost per hour 155 For emple, Cabriker 1 estimates will take 50 hours to complete the cabinets and 6 hours to come at the cherry Cabinet Cable enly so hours available for final finishing operation. Thus, Cabinetmaker I can only complete 40/50 - 0.00, or of the oak cabinets only on os cabinets. Similar Cabinet I can only compite 40/60-0.61, 674, of the cherry cabinets it worked only on cherry cabinet (A) Formulate la programming model that can be used to determine the percentage of the cabinets and the percentage rechery cabinets at should be to each of the three cabinetmakers in order to minimize the total cost of completing both (le 01 - oktober 1, 02-fokies to cabinetmaker 2,0 percentage of cabinets is to make, CI percentage of cherry cabinets ined tomater, percentage of the signed to cabinetmaker and C) - percentage of cherry cabinets assigned to cabineter 33 Min 11000, +17680,16500, 1000, 2016, 1956 hours available 500,000 x hours available 40,00 hours ava 300, +35C, COM cherry GG-G-1x 01, 02, 03, C1, C2, C320 0) See the model formulated in part ( what percentage of the oak cabinets and what percentage of the cherry cabinets should be assigned to each cabinets What is the total cost on :) completing both projects? (Round your percentage values to three decimal places) 01 02 09 73917 27.083 0 125 35 total cost c) If Cabinetmaker 1 has additional hours available, would the optimal solution change Explain Yes, each additional hour of time for cabinetmaker will reduce the total cost by $5 per hour Yes, each additional hour of time for cabinetmaker 1 will reduce the total cost by 5-1.75 per hour No, cabinetaler has a deck of 26.458 hours, so increasing cabinetmaker i time will not reduce No, cabnutnakert has a stack of 37.5 hours, to increasing cabinetmaker 14 time will not reduce costs (0) I Cameras anal hours avi, would the optimal charge Yolcach actional hour of time for Cabineter 2 wil reduce the total cost by 15 per hour Yes, each one of the brainmaker 2 will reduce the total cost by 1. pero No, cabinetmaker has a deck of 36.456 hours, to increasing betaler time will not reduce No, Gintmaker 2 hack 37.5 Nurs, increasing atas time not reduce e) pose Cabinete reduced costos per hour. What we would this change have on the main plan The new live action code for Care X and spectively. The station and save of