Linear Optimization Model
Not what you're looking for?
Please assist me in understanding the linear optimization model in the attached document.
How many of each type of air compressor should the company produce to maximize profit?
a. Formulate and solve a linear optimization model using the auxiliary variable cells method and explain the sensitivity information.
b. Solve the model without the auxiliary variables and explain the relationship between the reduced costs and the shadow prices found in part a.
Purchase this Solution
Solution Summary
This solution shows how a linear optimization model can be used to maximize profit for a company that produces three types of air compressors. The company has to take into account both time contraints and production constraints. The solution has been done using Excel solver.
Solution Preview
Dear Student:
The solution for the problem has been presented in the attached Excel worksheet using Excel solver. Please open the Excel file and then continue to read for some clarifying points:
The linear optimization model for total profit ($) = 20.50*small + 34.00*medium + 42.00*large
where small = the number of small air compressors produced, medium = the number of medium air compressors produced, and large = the number of large air compressors produced. The constants in the model are the equivalent unit profits in dollars, as given in the problem.
The model has constraints for production: ...
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Probability Quiz
Some questions on probability
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.