$5.$ 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:

Production Time Required $($hours$)$ Available Capacity

Economy Durabilt Superfly

Cuttting $1\mathrm{.}51\mathrm{.}52\mathrm{.}58000$ hours

Grinding $233\mathrm{.}510,000$ hours

Finishing $1246,000$ hours

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:

Economy Durabilt Superfly

Jones Metal $$52\mathrm{.}00$ $$83\mathrm{.}00$ $$128\mathrm{.}00$

East Cincinnati $$61\mathrm{.}00$ $$96\mathrm{.}00$ $$145\mathrm{.}00$

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?