Formulate and solve a linear optimization model using Solver, and recommend a production plan. Conduct whatever what-if analyses(run different scenarios and apply parameter analysis) you feel are appropriate to include.
Subject: General Questions / General General Questions
One of PLEs 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:
Department
Mower Housings
Tractor Housings
Production Hours 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
· Tractor housings require 1.8 square feet of sheet metal per unit
· 2500 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. Conduct whatever what-if analyses(run different scenarios and apply parameter analysis) you feel are appropriate to include.
PLACE THIS ORDER OR A SIMILAR ORDER WITH STUDENT HOMEWORKS TODAY AND GET AN AMAZING DISCOUNT
The post Formulate and solve a linear optimization model using Solver, and recommend a production plan. Conduct whatever what-if analyses(run different scenarios and apply parameter analysis) you feel are appropriate to include. appeared first on STUDENT HOMEWORKS .
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
