Chemical Manufacturing is dedicated to the manufacture of two important solvents:CS-01 and CS-02, mixing three chemical paint thinners. In the following tables, information on daily costs and available resources is presented of the diluents: CHEMICAL THINNERS FOR PAINT 1 MAXIMUM AVAILABLE COST/GALLON ($) (GALLONS) 0.60 600 2 0.70 3 0.94 PRODUCT SPECIFICATIONS CS-01 At most 20% of diluent 1. At least 30% of diluent 2. At most 10% of the diluent 3. CS-02 At least 35% of diluent 1. At most 50% of diluent 2. At least 40% of the diluent 3. 20,000 20,000 Each gallon of CS-01 solvent can be sold for $2.30 and each gallon of CS-02can be sold for $3.20. There is a commitment with the company, in which it agrees to produce at least 10,000 gallons of CS-01. • Formulate a model in which the best production plan that maximizes profits can be determined: A. Identify the decision variables, objective function, and optimal solution. B. Identify model constraints.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
Chemical Manufacturing is dedicated to the manufacture of two important solvents:CS-01 and CS-02, mixing
three chemical paint thinners. In the following tables, information on daily costs and available resources is
presented of the diluents:
CHEMICAL THINNERS
FOR PAINT
1
MAXIMUM AVAILABLE
COST/GALLON ($)
(GALLONS)
0.60
600
2
0.70
3
0.94
PRODUCT
SPECIFICATIONS
CS-01
At most 20% of diluent 1. At
least 30% of diluent 2.
At most 10% of the diluent 3.
CS-02
At least 35% of diluent 1.
At most 50% of diluent 2.
At least 40% of the diluent 3.
20,000
20,000
Each gallon of CS-01 solvent can be sold for $2.30 and each gallon of CS-02can be sold for $3.20. There is a
commitment with the company, in which it agrees to produce at least 10,000 gallons of CS-01.
•
Formulate a model in which the best production plan that maximizes profits can be determined:
A. Identify the decision variables, objective function, and optimal solution.
B. Identify model constraints.
Transcribed Image Text:Chemical Manufacturing is dedicated to the manufacture of two important solvents:CS-01 and CS-02, mixing three chemical paint thinners. In the following tables, information on daily costs and available resources is presented of the diluents: CHEMICAL THINNERS FOR PAINT 1 MAXIMUM AVAILABLE COST/GALLON ($) (GALLONS) 0.60 600 2 0.70 3 0.94 PRODUCT SPECIFICATIONS CS-01 At most 20% of diluent 1. At least 30% of diluent 2. At most 10% of the diluent 3. CS-02 At least 35% of diluent 1. At most 50% of diluent 2. At least 40% of the diluent 3. 20,000 20,000 Each gallon of CS-01 solvent can be sold for $2.30 and each gallon of CS-02can be sold for $3.20. There is a commitment with the company, in which it agrees to produce at least 10,000 gallons of CS-01. • Formulate a model in which the best production plan that maximizes profits can be determined: A. Identify the decision variables, objective function, and optimal solution. B. Identify model constraints.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.