Malloy Milling grinds calcined alumina to a standard granular size. The mill produces two different size products, regular grind and super grind, from the same raw materials. After reviewing the production rate, demand, and profit for each of the two types of grind, Malloy Milling found the following linear optimization model for profit, where R is the number of tons of regular grind produced and S is the number of tons of super grind produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding constraints, and verify the values of the slack variables. Maximize Profit = 900 R+1600 S R+S≥700 (Total production) R5+S3≤168 (Time limitation) R≥400 (Demand for regular grind) S≥200 (Demand for super grind) Implement the linear optimization model and find an optimal solution.
Malloy Milling grinds calcined alumina to a standard granular size. The mill produces two different size products, regular grind and super grind, from the same raw materials. After reviewing the production rate, demand, and profit for each of the two types of grind, Malloy Milling found the following linear optimization model for profit, where R is the number of tons of regular grind produced and S is the number of tons of super grind produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding constraints, and verify the values of the slack variables.
Maximize Profit
|
=
|
900 R+1600 S
|
|
|
|
R+S≥700
|
(Total production)
|
|
|
R5+S3≤168
|
(Time limitation)
|
|
|
R≥400
|
(Demand for regular grind)
|
|
|
S≥200
|
(Demand for super grind)
|

Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 7 images









