Question: Please answer all the parts if possible. 2- LP Minimization Problem (6 points): MUNCH BAKERY produces two main products on their production line: Vanilla Cupcakes

Please answer all the parts if possible.

Please answer all the parts if possible. 2- LP

2- 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 PL1 PL2 Vanilla 0.7 0.8 Chocolate 0.75 0.9 Labor PL1 Vanilla 0.75 Chocolate 0.75 PL2 1.2 1 The cost of mixing and baking a cupcake of each flavor is shown in the table below: $ Vanilla Chocolate PL1 1.5 0.4 PL2 2.2 4 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

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!