Purchase Solution

Linear Optimization Model

Not what you're looking for?

Ask Custom Question

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.