A consumer product company makes two types of dishwasher detergents: regular and concentrate. The company has two manufacturing facilities for making detergent products. The first facility has an operating cost of $120 an hour and can produce 300 ounces of regular detergent products per hour and 220 ounces of concentrate detergent per hour. The second facility has an hourly operating cost of $220 and produces 350 ounces of regular detergent and 450 ounces of concentrate detergent per hour. The company received wholesale orders totaling 4,500 ounces of regular detergent and 5,200 ounces of concentrate detergent. a. Formulate and solve the LP model that minimizes costs given the constraints. How many hours should the company operate each facility in order to fulfill the orders and minimize the operating cost? Note: Round your answers to 2 decimal places. The number of hours the company should operate the first facility The number of hours the company should operate the second facility Minimum operating cost b. Identify each binding constraint and report the shadow price and the range of feasibility. Note: Round your answers to 2 decimal places. Regular detergent constraint Concentrate detergent constraint Shadow Price Range of Feasibility From To
A consumer product company makes two types of dishwasher detergents: regular and concentrate. The company has two manufacturing facilities for making detergent products. The first facility has an operating cost of $120 an hour and can produce 300 ounces of regular detergent products per hour and 220 ounces of concentrate detergent per hour. The second facility has an hourly operating cost of $220 and produces 350 ounces of regular detergent and 450 ounces of concentrate detergent per hour. The company received wholesale orders totaling 4,500 ounces of regular detergent and 5,200 ounces of concentrate detergent. a. Formulate and solve the LP model that minimizes costs given the constraints. How many hours should the company operate each facility in order to fulfill the orders and minimize the operating cost? Note: Round your answers to 2 decimal places. The number of hours the company should operate the first facility The number of hours the company should operate the second facility Minimum operating cost b. Identify each binding constraint and report the shadow price and the range of feasibility. Note: Round your answers to 2 decimal places. Regular detergent constraint Concentrate detergent constraint Shadow Price Range of Feasibility From To
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...
Related questions
Question
Transcribed Image Text:A consumer product company makes two types of dishwasher detergents: regular and concentrate. The company has two
manufacturing facilities for making detergent products. The first facility has an operating cost of $120 an hour and can produce 300
ounces of regular detergent products per hour and 220 ounces of concentrate detergent per hour. The second facility has an hourly
operating cost of $220 and produces 350 ounces of regular detergent and 450 ounces of concentrate detergent per hour. The
company received wholesale orders totalling 4.500 ounces of regular detergent and 5.200 ounces of concentrate detergent.
a. Formulate and solve the LP model that minimizes costs given the constraints. How many hours should the company operate each
facility in order to fulfill the orders and minimize the operating cost?
Note: Round your answers to 2 decimal places.
The number of hours the company should operate the first facility
The number of hours the company should operate the second facility
Minimum operating cost
b. Identify each binding constraint and report the shadow price and the range of feasibility.
Note: Round your answers to 2 decimal places.
Regular detergent constraint
Concentrate detergent constraint
Shadow
Price
Range of Feasibility
From
To
Transcribed Image Text:c. If the hourly operating cost of the second facility is reduced to $200, how many hours should the company operate each facility?
What is the minimum operating cost in this scenario?
Note: Round your answers to 2 decimal places.
The number of hours the company should operate the first facility
The number of hours the company should operate the second facility
Minimum operating cost
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.