Question: 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
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: 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
