A company makes two products (X and Y) using two machines (A and B). Each unit o

Question

A company makes two products (X and Y) using two machines (A and B). Each unit of X that is produced requires 50 minutes processing time on machine A and 30 minutes processing time on machine B. Each unit of Y that is produced requires 24 minutes processing time on machine A and 33 minutes processing time on machine B. At the start of the current week there are 30 units of X and 90 units of Y in stock. Available processing time on machine A is forecast to be 40 hours and on machine B is forecast to be 35 hours. The demand for X in the current week is forecast to be 75 units and for Y is forecast to be 95 units. Company policy is to maximize the combined sum of the units of X and the units of Y in stock at the end of the week. • Formulate the problem of deciding how much of each product to make in the current week as a linear program using Excel Solver.

Explanation / Answer

Let X and Y be the number of units to be produced in the week.

Sensitivity Report:

X Y Decision variables 45 5 50 Objective Function 50 Machine A Constraint 50 24 2370 <= 2400 Machine B Constraint 30 39 1545 <= 2100 Demand for X 1 0 45 <= 45 Demand for Y 0 1 5 <= 5

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.