Develop a LP and spreadsheet model for Problem $23$ at the end of Chapter $3$ in the Ragsdale portion of your book. The Electrotech Corporation manufactures two industrial$-$sized

electrical devices: generators and alternators. Both of these

products require wiring and testing during the assembly process.

Each generator requires $2$ hours of wiring and $1$ hour of testing

and can be sold for a $$250$ profit. Each alternator requires $3$

hours of wiring and $2$ hours of testing and can be sold for a

$$150$ profit. There are $260$ hours of wiring time and $140$ hours

of testing time available in the next production period and

Electrotech wants to maximize profit. You develop a linear

program to find the product mix that maximizes profit, and find

the profit for this optimal mix is $$32,500.$ The sensitivity

analysis report from Excel for this solution is given below. Use

this report to answer Questions $3-7$ below.

Adjustable Cells

Constraints

How many hours of slack in wiring capacity exists in the optimal solution?

How many hours of slack testing capacity exists in the optimal soluWhat is the company's total profit if it has $10$ additional hours of wiring capacity?What is the minimum transportation cost if the rental car company optimizes shipments between locations?

What is the company's total profit if it has $10$ additional hours of wiring capacity?

By how much does the profit on alternators need to increase before their production is justified?