Formulate and solve a linear optimization model using solver

Assignment Help Engineering Mathematics

Reference no: EM131439988

Question: 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 available in each department are given in the following table:

Departmemt	Mower	Tractor Housings	Production Have Available
Departmemt	Housings	Tractor Housings	Production Have Available
Stamping	0.03	0.07	200
Drilling	0.09	0.06	300
Assembly	0.15	0.10	300
Painting	0.04	0.06	220
Packaging	0.02	0.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 (e.g., 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: EM131439988

Questions Cloud

Identify any environmental stressors : Identify any environmental stressors that are related to the environmental risk. Conclude with a discussion of your own risk perception of the issue

Explain the two approaches to programming : Compare between Magnetic and Solid-State Storage in terms of advantages and disadvantages. Explain the two approaches to programming. Explain clearly the different category of multimedia development and give the related form for each category.

Determine which site offers the most profitable option : Interest rate is limited to 10% and the extracton period is limited to 5years. Using the conventional Benefit/ Cost ratio method, determine which site offers the most profitable option.

In what ways addictions and continuous stress maladaptive : In what ways are addictions and continuous stress maladaptive? How do these factors alter one's journey along Maslow's hierarchy of needs, towards self-actualization

Formulate and solve a linear optimization model using solver : ne 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 assemb..

How a simple serial number stored in a cookie : 1.) Explain how a simple serial number stored in a cookie can be used to store personal information. 2.) Describe why the argument on whether computers can think has little impact on our daily lives. Use your word processor to answer this.

What are the general jurisdictional rules : Why are the concepts of 'residence' and 'source' important - What are the general jurisdictional rules? Discuss some of the exceptions to these rules and What is a 'tax invoice' and why is it important to hold a tax invoice?

Example of a covert storage channel : Part A) Give one good example of a covert storage channel. Explain how the covert storage channel you described can be mitigated or prevented.

Modify the intervention using rebt techniques : Give three specific examples of how an REBT therapist would modify the intervention using REBT techniques in addition to or instead of the techniques in the video

User Account

All Pages