By using Excel, please solve the following:
Task: The United Aluminum Company of Cincinnati produces three grades (high, medium, low) of aluminum at two mills. Each mill has a different production capacity (in tons per day) for each grade, as follows:
Aluminum Mill
Grade 1 2
High 6 2
Medium 2 2
Low 4 10
The company has contracted with a manufacturer firm to supply at least 12 tons of high-grade aluminum, 8 tons of medium-grade aluminum, and 5 tons of low-grade aluminum, It costs United $6,000 per day to operate mill 1 and $7,000 per day to operate mill 2. The company wants to know the number of days to operate each mill in order to meet the contact at the minimum cost.
Formulate a linear programming model for this problem.
On a separate spreadsheet, using the linear programming model formulated for above, identify the following:
1) Identify and explain the shadow prices for each of the aluminum grade contract requirements.
2) Identify the sensitivity ranges for the objective function coefficients and the constraint quantity values.
3) Would the solution values change if the contract requirements for high-grade aluminum were increased from 12 tons to 20 tons? If yes, what would the new solution values be?