Question: LP Minimization Problem (6 points): MUNCH BAKERY produces two main products on their production line: Vanilla Cupcakes and Chocolate Cupcakes on two Production Lines (PL
- LP Minimization Problem (6 points): MUNCH BAKERY produces two main products on their production line: Vanilla Cupcakes and Chocolate Cupcakes on two Production Lines (PL 1 and PL 2). The number of hours of production time and labor vary relative to the cupcake flavor and the production line as shown in the below tables:
| PL | VANILLA | CHOCOLATE |
| PL1 | 0.7 | 0.75 |
| PL2 | 0.8 | 0.9 |
| LABOR | VANILLA | CHOCOLATE |
| PL1 | 0.75 | 0.75 |
| PL2 | 1.2 | 1 |
The number of labor hours and production lines time available this month are in the table below:
Hours available
| PL1 | 200 |
| PL2 | 200 |
| LABOR | 400 |
During the month of April, at least 200 Vanilla Cupcakes and 240 Chocolate Cupcakes must be available. Also, at least half of the Vanilla Cupcakes must be mixed and baked on PL1, and at least half of the Chocolate Cupcakes must be mixed and produced on PL2.
How can MUNCH BAKERY minimize the cost of meeting their demand during April?
- A- Identify the decision variables, objective function and constraints.
- B- Solve the problem using QM or Excel Solver.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
