Optimization model using solver-recommend production plan

Assignment Help Operation Management

Reference no: EM131486122

One of PLE's manufacturing facilities produces metal engine housings from sheet metal for both mowers and tractors. Production of each product consists of five steps: stamping, drilling, assembly, painting and packaging to ship to its final assembly plant. The production rates in hours per unit and the number of production hours availabile in each department are given in the following table:

Department Mower Housings Tractor Housings Production Hours Available

Stamping .03 .07 200

Drilling .09 .06 300

Assembly .15 .10 300

Painting .04 .06 220

Packaging .02 .04 100

In addition, mower housings require 1.2 square feet of sheet metal per unit and tractor housings require 1.8 square feet per unit, and 2.500 square feet of sheet metal is available. The company would like to maximize the total number of housings they can produce during the planning period. Formulate and solve a linear optimization model using Solver and recommend a production plan. Illustrate the results visually to help explain them in a presentation to Ms. Burke. In addition, conduct whatever what-if analyses (eg run different scenarios and apply parameter analysis) you feel are appropriate to include in your presentation. Summarize your results in a well-written report.

Reference no: EM131486122

Questions Cloud

Multiple server and workstation integration : You are now progressing with your capstone multiple server and workstation integration in a single network project.

Write report about recommendation for tactical allocation : Write a 2-3 pageExecutive Summary-style reportthat gives your recommendation for a "tactical allocation" of the Wetherbe Fund.

Determining the senior it capstone : The statement of work (SOW) is considered the contract for work to be performed. It identifies all of the key aspects of the project.

Improve the learning management system : Assume we are each tasked with finding ways to improve the learning management system (LMS) currently in use.

Optimization model using solver-recommend production plan : Formulate and solve a linear optimization model using Solver and recommend a production plan.

What are the three major trade-offs : In the event of a data breach, why is it wise to request a new card?

Open-source application suite : The management team of HWBS would like to ensure that the following software is installed on each server: an open-source application suite, and an open-source.

Discuss the ethical and legal concerns of brian actions : Review the case in above and discuss the ethical and legal concerns of Brian's actions. What might the ramifications or consequences of his actions be? Why?

What are some warning signs of debt problems : What are the pros and cons of placing a freeze on your credit report as a preventive measure?

User Account

All Pages