Question: Show work using the data table and step by step instruction on what you entered into the data solver inputs Malloy Milling grinds calcined alumina

Show work using the data table and step by stepShow work using the data table and step by step instruction on what you entered into the data solver inputs

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 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 = 800 R+ 1700 S R+S 2 700 (Total production) RS 5+3 5168 (Time limitation) R2 400 (Demand for regular grind) S2 200 (Demand for super grind) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce 490 tons of regular grind and 210 tons of super grind. This solution gives the maximum possible profit, which is $ 749,000 (Type integers or decimals rounded to two decimal places as needed.) Total production a binding constraint and it has slack. Time limitation a binding constraint and it has slack. Demand for regular grind a binding constraint and it has slack. Demand for super grind a binding constraint and it has slack. (Type integers or decimals rounded to two decimal places as needed.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!