Company ABC produce three grades of paper. The S plant produces 5 tons of grade A paper, 3 tons of grade B paper, and 7 tons of grade C paper per houn The T plant produces 3 tons of grade A paper, 5 tons of grade B paper, and 6 tons of grade C paper per hour. To satisfy existing contracts, ABC must produce at least 95 tons of grade A paper, 88 tons o grade B paper, and 160 tons of grade C paper per day. It costs $ 200 per hour to operate the operate the S plant and $150 per hour to operate the T plant. ABC would like to determine the numbers of hours per day that each plant should be kept in operation if their paper needs are to be met at minimum cost. o state clearly what are the variables you use to this problem. Solve it by the Excel Solver
Company ABC produce three grades of paper. The S plant produces 5 tons of grade A paper, 3 tons of grade B paper, and 7 tons of grade C paper per houn The T plant produces 3 tons of grade A paper, 5 tons of grade B paper, and 6 tons of grade C paper per hour. To satisfy existing contracts, ABC must produce at least 95 tons of grade A paper, 88 tons o grade B paper, and 160 tons of grade C paper per day. It costs $ 200 per hour to operate the operate the S plant and $150 per hour to operate the T plant. ABC would like to determine the numbers of hours per day that each plant should be kept in operation if their paper needs are to be met at minimum cost. o state clearly what are the variables you use to this problem. Solve it by the Excel Solver
Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter2: Systems Of Linear Equations
Section2.4: Applications
Problem 27EQ
Related questions
Topic Video
Question
Transcribed Image Text:3. Formulate the following problem as a LP model.
(a) Company ABC produce three grades of paper. The S
plant produces 5 tons of grade A paper, 3 tons of
grade B paper, and 7 tons of grade C paper per hour.
The T plant produces 3 tons of grade A paper, 5 tons
of grade B paper, and 6 tons of grade C paper per
hour. To satisfy existing contracts, ABC must
produce at least 95 tons of grade A paper, 88 tons of
grade B paper, and 160 tons of grade C paper per
day. It costs $ 200 per hour to operate the operate
the S plant and $150 per hour to operate the T
plant. ABC would like to determine the numbers of
hours per day that each plant should be kept in
operation if their paper needs are to be met at
minimum cost.
You need to state clearly what are the variables you use to
formulate this problem.
(b) Solve it by the Excel Solver
4.
In the game with the payoff matrix shown below:
2.
4.
First formulate the problem, then use the Excel Solver to
determine the mixed optimal strategies of the row and column
players.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 6 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning