M&D Chemicals produces two products that are sold as raw materials to companies manufacturing bath soap and laundry detergents. Based on an analysis of current inventory levels and potential demand for the coming month, M&D’s management specifies that the combined production for products A and B must total at least 350 gallons. Separately, a major customer’s order for 125 gallons of product A must also be satisfied. Product A requires 2 hours of processing time per gallon, and product B requires 1 hour of processing time per gallon. For the coming month, 600 hours of processing time are available. M&D’s objective is to satisfy these requirements at a minimum total production cost. Production costs are $2 per gallon for product A and $3 per gallon for product B. Develop a Linear Programming Model to determine how many gallons of each product should be produced. (using excel) please be detailed I need to understand how you you got each solution) 1) How many gallons of Product A should be produced? 2) What is the Total Production Cost? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section: Chapter Questions
Problem 73P
icon
Related questions
icon
Concept explainers
Topic Video
Question

M&D Chemicals produces two products that are sold as raw materials to companies manufacturing bath soap and laundry detergents.

Based on an analysis of current inventory levels and potential demand for the coming month, M&D’s management specifies that the combined production for products A and B must total at least 350 gallons. Separately, a major customer’s order for 125 gallons of product A must also be satisfied.

Product A requires 2 hours of processing time per gallon, and product B requires 1 hour of processing time per gallon. For the coming month, 600 hours of processing time are available. M&D’s objective is to satisfy these requirements at a minimum total production cost. Production costs are $2 per gallon for product A and $3 per gallon for product B.

Develop a Linear Programming Model to determine how many gallons of each product should be produced. (using excel) please be detailed I need to understand how you you got each solution)

1) How many gallons of Product A should be produced?
2) What is the Total Production Cost?

Note:-

  • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
  • Answer completely.
  • You will get up vote for sure.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,