1 Starbucks needs to decide how many muffins and how many croissants to produce each day. The profit per muffin is $1 and the profit per croissant is $1.5. On an average, each muffin takes 3 minutes of labor time and 3 minutes of oven time (of course they are produced in batches. For simplification I have given you the time per piece). Croissants take 10 minutes of labor time and 1 minute of oven time. Starbuckscan have its labor dedicated for a maximum of 2 hours every day. The oven time is limited to 6 hours during the night. Due to customer requests Starbucks produces at least 5 croissants every day. Use Solver to find the optimal solution. The optimal number of muffins to be produced in a day is (keep two decimals) and the optimal number of croissants to be produced in a day is (keep two decimals). QUESTION 2 Starbucks needs to decide how many muffins and how many croissants to produce each day. The profit per muffin is $1 and the profit per croissant is $1.5. On an average, each muffin takes 3 minutes of labor time and 3 minutes of oven time (of course they are produced in batches. For simplification I have given you the time per piece). Croissants take 10 minutes of labor time and 1 minute of oven time. Starbuckscan have its labor dedicated for a maximum of 2 hours every day. The oven time is limited to 6 hours during the night. Due to customer requests Starbucks produces at least 5 croissants every day. Which of the following statements are TRUE (choose all the correct statements. Choosing wrong answers will incur negative marking) Producing 10 each of muffins and croissants is infeasible Producing 10 muffins and 8 croissants in a day is feasible but worse than producing 15 muffins and 6 croissants a day. The profit from producing 5 croissants and 5 muffins is $10 Producing 10 each of muffins and croissants is feasible and the corresponding profit is $25. Producing 10 muffins and 8 croissants in a day is feasible AND better than producing 15 muffins and 6 croissants a day. The profit from producing 5 croissants and 5 muffins is $12.5 QUESTION 3 Starbucks needs to decide how many muffins and how many croissants to produce each day. The profit per muffin is $2 and the profit per croissant is $1.5. On an average, each muffin takes 3 minutes of labor time and 3 minutes of oven time (of course they are produced in batches. For simplification I have given you the time per piece). Croissants take 10 minutes of labor time and 1 minute of oven time. Starbuckscan have its labor dedicated for a maximum of 2 hours every day. The oven time is limited to 6 hours during the night. Due to customer requests Starbucks produces at least 5 croissants every day. Each croissant can only generate a profit of $1.5 A maximum of 6 hours of oven time. Each muffin takes 3 minutes of labor time and 3 minutes of oven time A maximum of 2 hours of labor time Each croissants take 10 minutes of labor time and 1 minute of oven time Starbucks needs to produce at least 5 croissants every day. Each muffin can only generate a profit of $2 1. QUESTION 4 Which of the following statements are TRUE (Choose ALL the true statements, choosing incorrect statements will incur negative marking) A good spreadsheet design is where the final values of constraints are directly entered in the cell, rather than formulas linking it to other cells in the spreasheet. There can be only ONE optimal solution in an LP problem At least one decision variable will be present in the objective function and each of the contraint. A feasible solution is one that satisfies at least one of the constraints An optimal solution is any solution that gives the best possible value for the objective function A feasible solution is one that satisfies ALL the constraints For an LP problem, square of the decision variable cannot be part of any of the constraint as it makes the constraint non-linear. Functions like ABS, MIN and Max can freely be used to define the constraints in an LP problem 4 points 1. QUESTION 5 Starbucks needs to decide how many muffins and how many croissants to produce each day. The profit per muffin is $2 and the profit per croissant is $1.5. On an average, each muffin takes 3 minutes of labor time and 3 minutes of oven time (of course they are produced in batches. For simplification I have given you the time per piece). Croissants take 10 minutes of labor time and 1 minute of oven time. Starbucks can have its labor dedicated for a maximum of 2 hours every day. The oven time is limited to 6 hours during the night. Let m be the number of muffins and c be the number of croissants produced in a day. The correct algebraic form for the constraint on labor time available is: ABCD- 3m + 10c < 120 3m + 10c < 2 10m +3c < 120 3m + 3c < 2