**Please include a screen shot of the solutions gotten on Excel Solver for part B.**

Remark: For Excel's Solver, you must include copies of initial table, final table, and answer report along with your precise statement about the solution. 1. (6 points) A company manufactures camping equipment. Their most important four products are tents, chairs, tables and camp beds. The chairs, tables and beds fold up to make them easy to transport. The three main materials used to manufacture these items are metal, nylon and wood. The amount of material needed for each of the items of camping equipment is shown in the table (below). The table also shows the profit (in QR) that the company makes on each piece of camping equipment. Item Tent Metal(feet) 48 Nylon(feet) 100 Wood(feet) 5 Profit(QR) 1,400 18 28 0 110 Chair Table 18 0 10 180 Bed 20 14 10 140 Each week the company can order up to 6000 feet of metal, 9000 feet of nylon and 1000 feet of wood. The main activities that the company engages in to manufacture these items are bending the metal, sewing the nylon and assembling the items. (Very little time is spent cutting the wood so it is not included here.) The number of hours spent on each of these activities for each item is shown in the table (below). Item Bending (hours) Sewing (hours) 5 Assembling (hours) 2 Tent 2 Chair 1 2 1 Table 1 0 1 Bed 1 1 2 The company employs enough workers so that they have 120 hours of bending time, 200 hours of sewing time and 130 hours of assembly time per week. The tables and chairs are often sold in sets of one table and two chairs. The company manufactures at least twice as many chairs as tables. a) Set up a linear programming problem that will help the managers run the company so that they can maximize profits. b) Solve the following optimization problem by using Excel's Solver. Remark: For Excel's Solver, you must include copies of initial table, final table, and answer report along with your precise statement about the solution. 1. (6 points) A company manufactures camping equipment. Their most important four products are tents, chairs, tables and camp beds. The chairs, tables and beds fold up to make them easy to transport. The three main materials used to manufacture these items are metal, nylon and wood. The amount of material needed for each of the items of camping equipment is shown in the table (below). The table also shows the profit (in QR) that the company makes on each piece of camping equipment. Item Tent Metal(feet) 48 Nylon(feet) 100 Wood(feet) 5 Profit(QR) 1,400 18 28 0 110 Chair Table 18 0 10 180 Bed 20 14 10 140 Each week the company can order up to 6000 feet of metal, 9000 feet of nylon and 1000 feet of wood. The main activities that the company engages in to manufacture these items are bending the metal, sewing the nylon and assembling the items. (Very little time is spent cutting the wood so it is not included here.) The number of hours spent on each of these activities for each item is shown in the table (below). Item Bending (hours) Sewing (hours) 5 Assembling (hours) 2 Tent 2 Chair 1 2 1 Table 1 0 1 Bed 1 1 2 The company employs enough workers so that they have 120 hours of bending time, 200 hours of sewing time and 130 hours of assembly time per week. The tables and chairs are often sold in sets of one table and two chairs. The company manufactures at least twice as many chairs as tables. a) Set up a linear programming problem that will help the managers run the company so that they can maximize profits. b) Solve the following optimization problem by using Excel's Solver