• Calculate Unit Profit for each product (in cells B8:I8) and Total Profit (in cell B19)
• Calculate total capacity required in Department 1 (overtime) in cell B24 and Department 2 (regular and overtime) in cells B25:B26
• Calculate total units produced of each product family in cells B28:B31.

Table 1 Product Table Floor Ceiling Pendant Material cost $66 85 50 80 Table 2 Regular Time Process Unit Cost $16 12 Capacity 100,000 90,000 Unit Cost 18 15 Capacity 25,000 24,000 Table 3 Selling price Potential sales (000) Advertising effect Table $120 60 12% Floor 150 20 10% Ceiling 100 100 8% 160 35 15% File Insert Page Layout Formulas Data Review View Help Tell me what you want to do AutoSum A Calibr Copy Format Painter Fill Merge & Certer. $. % , . Conditional Format as Cell FormattingTable Styles . .2 . A. . insert Delete Format B 1 u, Sort & Find & Clear FilterSelect Clipboard Font Cells Editing 13 Costs and prices r regular time; oovertime Table lanm Floor lamps (F) Ceiling lamps (C) Pendant lamp To Fo Cr CO Po Celling price Material costs Production costs Unit 120 150 160 160 16 16 12 15 Department 1 Department 2 Decision Variables Units produced Advertising To Fo Co Po 7 I Objective function: max (Profit) - Constraints Capacity constraints: Department 1 regular time Department 1 overtime RHS 0 100000 Insert Page Layout Formulas Data Review View Help Tell me what you want to do Cut Copy AutoSum Calibri 11 A'A.- wrap Text Fill Paste 00 Conditional Format as Cell Insert Delete Format Sort & Find & Filter Select 1 u. Eu, . Merge & Certer . $. % , ..Clear Cells Format Painter Formatting Table Styles Styles Clipboard Alignment Editing 013 11 Decision Variables: 12 13 Units produced 14 15 Advertising 16 17 Objective function: 19 max (Profit) To Fr Fo Cr Co Po 21 Constraints: 22 Capacity constraints: 23 Department 1 regular time 24 Department 1 overtime 25 Department 2 regular time 26 Department 2 overtime 27 Demand constraints 28 Table lamps 29 Floor lamps 30 Ceiling lamps 31 Pendant lamps LHS RHS 0 100000 25000 60000 33 Advertising constraint 34 0 18000