Question: please use excel analytical solver A consumer product company makes two types of dishwasher detergents: regular and concentrate. The company has two manufacturing facilities for

please use excel analytical solverplease use excel analytical solver A consumer

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 $218 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. b. Identify each binding constraint and report the shadow price and the range of feasibility. Note: Round your answers to 2 decimal places. 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!