Use Excel to answer these questions.

Outdoors, Inc. has, as one of its product lines, lawn furniture. They currently have three items in that line: a lawn chair, a standard bench, and a table. These products are produced in a two-step manufacturing process involving the tube-bending department and the welding department. The time required by each item in each department is as follows: Product Lawn chair Bench Table Present capacity Tube bending 1.2 1.7 1.2 1000 Welding 0.8 0 2.3 1200 The contribution that Outdoors, Inc. receives from the manufacture and sale of one unit of each product is $3 for a chair, $3 for a bench, and $5 for a table. The company is trying to plan its production mix for the current selling season. It predicts that it can sell any number it produces, but production is further limited by available material, because of a prolonged strike. The company currently has on hands 2000 lbs. of tubing. The three products require the following amounts of this tubing: 2 lbs. per chair, 3 lbs. per bench, and 4.5 lbs. per table. a In order to determine the optimal product mix, the production manager has formulated the following linear program: Label Chair Bench Table Limit 1.2 1.7 1.2 0.8 0 2.3 Bending Welding Material Availability Contribution VI VIVI 1000 1200 2000 2 3 4.5