Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

XYZ Chemicals produces three products that are sold as raw materials to companie

ID: 2947266 • Letter: X

Question

XYZ Chemicals produces three products that are sold as raw materials to companies that manufacture plastic dials. Based on an analysis of current inventory levels and potential demand for the next month, the combined production for all three products (A, B, and C) must total at least 750 units. Separately, an order received from a major customer for 295 product C’s must be filled. Product A requires 2 hours of processing time per unit, Product B requires 1.5 hours and Product C requires 2.5 hours. For the coming month, there are 1000 hours of processing time available. XYZ wants to satisfy these requirements at a minimum total production cost. Production costs are estimated as $2 per unit for product A, $3 per unit for product B and $3.75 per unit for product C. Write a linear program that minimizes cost.

Explanation / Answer

constraints

a+b+c >=750

c > =295

2a+1.5b+2.5c<=1000

minimize 2a+3c+3.75c

using excel solver we do not get an optimal solution

so there is no optimal solution wihin these constrains i.e. we will not be able to produce at least 750 units in 1000 hours given c >295