Data Window Help BUAN 2101 06 Exa Excel File Edit View Insert Format Tools AutoSave DOFF DE SU Home Insert Draw Page Layout Formulas Data Arial V 12 ' Paste BIU Review View Tell me 25 Wrap Text General 1:1 lili Merge & Center C16 A K Prescriptive Analytics Q2. Bangs Leisure Inc. produces tables and office chairs for Fairfield University The unit profit for tables and office chairs are: 250 and 150. Each table requires 22 square feet of wood and 14 carpentry hours, whereas office chairs require 18 square feet of wood and 8 carpentry hours. For the next week, Bangs Leisure Inc. has 1200 square feet of wood and 600 hours of labor available. Please use solver to determine how many tables and office chairs Bangs Leisure Inc. should make to maximize its profit. Table Chair Table Chair 23 Numbers Produced 0.00 0.00 24 Unit Profit 15 Used Total Used Constraint 35 Wood 17 Carpentry hours Used available available 29 20 TOTAL PROFIT 21 22 23 24 25 27 28 29 30 31 32 34 35 36 27 38 39 01 Amazon.com les O Bang Leisuren 3 Employee Osta 04 Marta Resorts in Os Cigarette Data Window Help BUAN 2101 06 Exa Excel File Edit View Insert Format Tools AutoSave DOFF DE SU Home Insert Draw Page Layout Formulas Data Arial V 12 ' Paste BIU Review View Tell me 25 Wrap Text General 1:1 lili Merge & Center C16 A K Prescriptive Analytics Q2. Bangs Leisure Inc. produces tables and office chairs for Fairfield University The unit profit for tables and office chairs are: 250 and 150. Each table requires 22 square feet of wood and 14 carpentry hours, whereas office chairs require 18 square feet of wood and 8 carpentry hours. For the next week, Bangs Leisure Inc. has 1200 square feet of wood and 600 hours of labor available. Please use solver to determine how many tables and office chairs Bangs Leisure Inc. should make to maximize its profit. Table Chair Table Chair 23 Numbers Produced 0.00 0.00 24 Unit Profit 15 Used Total Used Constraint 35 Wood 17 Carpentry hours Used available available 29 20 TOTAL PROFIT 21 22 23 24 25 27 28 29 30 31 32 34 35 36 27 38 39 01 Amazon.com les O Bang Leisuren 3 Employee Osta 04 Marta Resorts in Os Cigarette