Use Excel Solver. Hours available for A is 100, B is 38, and C is 50.

utization, and pecduct profitabilty: (a) Dcvelop a trear progmanmeng moded of the Hartuan company problen. Solve the model to determine the optemal producton quanties of products 1 and 2 . It required, round your arswer to two deamal traces. be schefded in same of the departents, Which depurtiens would you recomment scheduling for overtime? be scheduled in some of the departinents. Which deporments would you recommend scheduing for crertine? What is the upper invt of what you would be willing to pay per hour if avertine in the drpartineit you reconmensed? If required. nound your antwer to two decimal piacis. and what is the revised total cortribution to peofit? If reeucred, round your antwer to two decimal piaces. If reguired, round pour answer to nearest intele number. Totul Pronit : How muth overtime do you recommend uning in rach departinent? If regured, round your answer to two deomal riaces. If you answer is rere, enter "0: What is the increase in the total contribuion to profe if evertme is used? if required, round your anwwer ta neared atwie bumber