Costs and prices: ro regular time; o overtime Table lamps (T) Floor lamps [F] Ceiling lamps (C ) Pendant lamps (P] Tr To Fr Fo Cr Co Pr Po Celling price 120 120 150 150 100 100 160 160 Material costs 66 56 85 85 50 50 80 80 Production costs 16 18 16 18 12 15 12 Unit profit 38 36 49 47 38 35 68 65 Department 1 Department 2 Decision Variables: Tr To Fr Fo Cr Co Pr Po Units produced 60000 0 21800 55000 24000 35000 T F C P Advertising 0 18000 Objective function: max (Profit) = Constraints: Capacity constraints: LHS RHS Department 1 regular time 81800 1000 00 Department 1 overtime 0 25000 Department 2 regular time 90000 90000 Department 2 overtime 24000 24000 Demand constraints: Table lamps 60000 60000 Floor lamps 21800 21800 Ceiling lamps 79000 100000 Pendant lamps 35000 35000 Advertising constraint 18000 18000Part A. (3 points) Read the case study "Hawley Lighting Company". Download HawleyData.xlex file and complete the model: Calculate Unit Profit for each product (in cells 88:18) and Total Profit (in cell B19) Calculate total capacity required in Department 1 (overtime) in cell 824 and Department 2 (regular and overtime) in cells B25:826 Calculate total units produced of each product family in cells B28:831. Estimate the optimal production plan and run the sensitivity analysis