Problem 1 United Aluminum Company of Cincinnati produces three grades (high, medium, and low) of aluminum at two mills. Each mill has a different production capacity (in tons per day) for each grade, as follows: Mill Aluminum Grade 1 2 High 6. Medium 2 2 Low 4 10 The company has contracted with a manufacturing 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 to meet the contract at the minimum cost. Formulate a linear programming model for this problem. Solve the linear programming model formulated in Problem 12 for United Aluminum Company by using the computer. a. Identify and explain the shadow prices for each of the aluminum grade contract requirements. b. Identify the sensitivity ranges for the objective function coefficients and the constraint quantity values. c. 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?

College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter6: Linear Systems
Section6.8: Linear Programming
Problem 33E
icon
Related questions
Question
100%
1. Formulate linear programming (clearly state decision variables,
objective, and constraints)
2. Find the optimal solution using Excel Solver
3. Do not solve graphically
4. Answer all questions
5. Attach your solver files and formulations.
Transcribed Image Text:1. Formulate linear programming (clearly state decision variables, objective, and constraints) 2. Find the optimal solution using Excel Solver 3. Do not solve graphically 4. Answer all questions 5. Attach your solver files and formulations.
Problem 1
United Aluminum Company of Cincinnati produces three grades (high, medium, and low) of
aluminum at two mills. Each mill has a different production capacity (in tons per day) for each
grade, as follows:
Mill
Aluminum Grade
1
2
High
6.
Medium
2
2
Low
4
10
The company has contracted with a manufacturing 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 to meet the contract at the minimum cost.
Formulate a linear programming model for this problem.
Solve the linear programming model formulated in Problem 12 for United Aluminum Company
by using the computer.
a. Identify and explain the shadow prices for each of the aluminum grade contract requirements.
b. Identify the sensitivity ranges for the objective function coefficients and the constraint quantity
values.
c. 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?
Transcribed Image Text:Problem 1 United Aluminum Company of Cincinnati produces three grades (high, medium, and low) of aluminum at two mills. Each mill has a different production capacity (in tons per day) for each grade, as follows: Mill Aluminum Grade 1 2 High 6. Medium 2 2 Low 4 10 The company has contracted with a manufacturing 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 to meet the contract at the minimum cost. Formulate a linear programming model for this problem. Solve the linear programming model formulated in Problem 12 for United Aluminum Company by using the computer. a. Identify and explain the shadow prices for each of the aluminum grade contract requirements. b. Identify the sensitivity ranges for the objective function coefficients and the constraint quantity values. c. 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?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Recommended textbooks for you
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning