Just Problem #4

Page 0f 4 0 - zoom *4. Outdoor Furniture produces two products benches and picnic tables. The company has two main resources: its carpenters (labor force) and a supply of redwood. During the next production cycle, the company has 1200 labor hours and 3500 feet of redwood available. Each bench that Outdoor produces brings in a profit of $12 and requires 4 hours of labor and 10 feet of redwood. Each picnic table has a profit of $36 and uses 8 labor hours and 28 feet of redwood. How many benches and tables should Outdoor Furniture produce during the next production cycle to maximize its profit? (a) Formulate the problem as a two-variable Linear Program and solve using Excel making sure to genetate a Sensitivity Report to justify your answers to the questions below. (b) Interpret the optimal solution revious MacBook Pro 9 8.doc Thapter 8.doc (47 KB) Page 0f40 - ZOOM + below (b) Interpret the optimal solution. (c) Would the optimal production plan change if the profit for each table increased from $36 to $45? (d) How many unused labor hours will Outdoor have during the next production cycle according to the optimal solution? (0) What would the effect on the maximum profit be for each additional foot of redwood that Outdoor can obtain? (1) What would the revised maximum profit be if Outdoor were able to obtain an additional 60 feet of redwood? *5. Meadows Metal Company has a contract to produce the nose cones for 260 new fighter jets for the U.S. Air Force. Meadows has two independent welding specialists with the expertise to assemble these nose cones. One welder, Allen Isaacs can assemble 16 nose cones per day, while the other welder Baker Michaels can complete 20 nose cones per day. Meadows pays Isaacs $180 per day and Michaels $200 per ous Next MacBook Pro + 8 9 11