DO THIS PROBLEM USING EXCEL Solver and generate the reports to answer the questions below

Jones Metal Products has recently accepted a contract to deliver three types of flywheels $($Economy$,$ Durabilt,

and Superfly$)$ to a new customer. Quantities required are as follows:

Economy $-1000$ units

Durabilt $-3100$ units

Superfly $-1600$ units

The flywheels are manufactured through a three step process as follows:

The order must be delivered by December $31,$ or Jones Metal is subject to a significant late penalty. Given

the production time requirements, management is concerned that the deadline can't be met using in$-$house

resources only. Fortunately, Jones Metal has a long$-$time relationship with another manufacturer, East

Cincinnati Fabricating, who may be able to produce some of the flywheels. Respective manufacturing costs

are shown below:

Jones Metal wants to fill the order while minimizing costs, what is the optimal solution?

A$)$ Jones Metal was able to add an additional $1,000$ hours of capacity to the cutting process. Does this

change the optimal solution? Why or why not?

B$)$ In order for Jones Metal to reduce the cost of this order and produce more internally what should they do

and why?

C$)$ If the manufacturing costs for the Durabilt flywheel was reduced to $$80\mathrm{.}00,$ does this change the optimal

solution? What information in the report are you using to make this conclusion?

D$)$ If the cost to purchase the Durabilt flywheel from East Cincinnati increases to $$105,$ does this change the

optimal solution? Why or why not?

E$)$ The contract quantity for the Economy flywheel increased by $500$ units. Will this change the

recommended optimal solution and what is the new cost of the order? Please show how you came up

with the new cost?