Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2] I111 points] i'Iu'lallo1lllr Milling grinds calcined alumina to a standard granular size. The mill produces two different size products from the same raw material.

image text in transcribed
2] I111 points] i'Iu'lallo1lllr Milling grinds calcined alumina to a standard granular size. The mill produces two different size products from the same raw material. Regular Grind can be produced at a rate of 10,000 pounds per hour and has a demand of 400 tons per week with a price per ton of $900. Super Grind can he produced at a rate of 5,000 pounds per hour and has demand of 200 tons per week with a price of 5 1,900 per ton. A minimum of T00 tons has to be ground even]:r week to make room in the raw material storage bins for previouslyr purchased incoming raw material by rail. The mill operates 24! T for a total of 153 hours}Ir week. a) Write the decision variables, objective function, and constraints to maximize revenue. Use Excel to solve the optimization problem. b} 1What impact will changing the required minimum number of tons per week [currentlv T00] have on the solution? c} If the price per ton for Regular Grind is increased to $ 1100, how will the solution be affected? d] If the price per ton for Super Grind is decreased to $ 1400 because of low demand, how will the solution change

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction to the Mathematics of Financial Derivatives

Authors: Ali Hirsa, Salih N. Neftci

3rd edition

012384682X, 978-0123846822

More Books

Students also viewed these Mathematics questions