Ch3, Problem 17. Instead of using the computer solution in Figure 3.20 to answer the questions. Generate the optimal solution and sensitivity report from Excel Solver.

d. Suppost change help or hurt profit? Explain. 17. The Porsche Club of America sponsors driver education events that provi performance driving instruction on actual race tracks. Because safety is a p eration at such events, many owners elect to install roll bars in their cars. Deegan Indu manufactures two types of roll bars for Porsches. Model DRB is bolted to thcarse ing holes in the car's frame. Model DRW is a heavier roll bar that must be welded to the car frame. Model DRB requires 20 pounds of a special high alloy steel, 40 minutes of manufa turing time, and 60 minutes of assembly time. Model DRW requires 25 pounds of the s dustries using exist- high alloy steel, 100 minutes of manufacturing time, and 40 minutes of assembl Deegan's steel supplier indicated that at most 40,000 pounds of the high-alloy steel pecial y ti will be available next quarter. In addition, Deegan estimates that 2000 hours of manufacturing time and 1600 hours of assembly time will be available next quarter. The profit contributions are