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

  1. 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?

  1. A- Identify the decision variables, objective function and constraints.
  2. B- Solve the problem using QM or Excel Solver.

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!