tools to use : excel QM

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:

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 Vanilla Chocolate PL 0.7 0.75 PL2 0.8 0.9 Labor Vanilla Chocolate PL 0.75 0.75 PL2 1.2 The cost of mixing and baking a cupcake of each flavor is shown in the table below: Vanilla Chocolate PL 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