Question: testing and can be sold for a $ 1 5 0 profit. There are 2 6 0 hours of wiring time and 1 4 0
testing and can be sold for a $ profit. There are hours of wiring time and hours of testing time avallable in the next production period and Electrotech wants to maximize profit.
Use Solver to create Answer and Sensitivity Reports for above question and answer the following questions:
a How much excess wiring and testing capacity exists in the optimal solution? If your answer is zero, enter
There i: excess wiring capacity and excess units of testing.
b What is the company's total profit if it has additional hours of wiring capacity?
$
c By how much does the profit on alternators need to increase before their production is justified?
d Does the optimal solution change If the marginal profit on generators decreases by $ and the marginal profit on altemators increases by $ e Suppose the marginal profit on generators decreases by $ What is the maximum profit that can be earned on alternators without changing the optimal solution? Round your answer to one decimal place.
f Suppose the amount of wirina required on alternators is reduced to hours. Does this change the optimal solution?
Select
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
