Question: Please show how to get these numbers in Microsoft Excel. Malloy Milling grinds calcined alumina to a standard granular size. The mill produces two different

Please show how to get these numbers in MicrosoftPlease show how to get these numbers in Microsoft Excel.

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 = 800 R+ 1800 S R+S2 700 RS 5+3 5 168 (Total production) (Time limitation) (Demand for regular grind) (Demand for super grind) R2 400 S 200 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 $ 770000 (Type integers or decimals rounded to two decimal places as needed.) Total production is a binding constraint and it has 0 slack. Time limitation is a binding constraint and it has 0 slack Demand for regular grind is not a binding constraint and it has 90 slack. Demand for super grind is not a binding constraint and it has 10 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!