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

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

$2.$ How many hours of slack testing capacity exists in the optimal Solution? $($It is not $40)$

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

$4.$ How much would the addition of $1$ hr of wiring capacity increase profit?

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