# Starbucks needs to decide how many muffins

QUESTION 1Starbucks 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 muffintakes 3 minutes of labor time and 3 minutes of oven time (of course they are produced inbatches. For simplification I have given you the time per piece). Croissants take 10 minutesof labor time and 1 minute of oven time. Starbuckscan have its labor dedicated for amaximum of 2 hours every day. The oven time is limited to 6 hours during the night. Due tocustomer requests Starbucks produces at least 5 croissants every day….e Solver to find the optimal solution. The optimal number of muffins to be produced in a dayis(keep two decimals) and the optimal number of croissants to be produced in a day is (keep two decimals). QUESTION 2Starbucks 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 muffintakes 3 minutes of labor time and 3 minutes of oven time (of course they are produced inbatches. For simplification I have given you the time per piece). Croissants take 10 minutesof labor time and 1 minute of oven time. Starbuckscan have its labor dedicated for amaximum of 2 hours every day. The oven time is limited to 6 hours during the night. Due tocustomer requests Starbucks produces at least 5 croissants every day.Which of the following statements are TRUE (choose all the correct statements. Choosingwrong answers will incur negative marking)Producing 10 each of muffins and croissants is infeasibleProducing 10 muffins and 8 croissants in a day is feasible but worse than producing 15muffins 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 15muffins and 6 croissants a day.The profit from producing 5 croissants and 5 muffins is $12.5 QUESTION 3Starbucks 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 muffintakes 3 minutes of labor time and 3 minutes of oven time (of course they are produced inbatches. For simplification I have given you the time per piece). Croissants take 10 minutesof labor time and 1 minute of oven time. Starbuckscan have its labor dedicated for amaximum of 2 hours every day. The oven time is limited to 6 hours during the night. Due tocustomer requests Starbucks produces at least 5 croissants every day.Each croissant can only generate a profit of $1.5A maximum of 6 hours of oven time.Each muffin takes 3 minutes of labor time and 3 minutes ofoven timeA maximum of 2 hours of labor timeEach croissants take 10 minutes of labor time and 1 minuteof oven timeStarbucks needs to produce at least 5 croissants every day.Each muffin can only generate a profit of $2 1. QUESTION 4Which 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 enteredin the cell, rather than formulas linking it to other cells in the spreasheet.There can be only ONE optimal solution in an LP problemAt least one decision variable will be present in the objective function and each of thecontraint.A feasible solution is one that satisfies at least one of the constraintsAn optimal solution is any solution that gives the best possible value for the objectivefunctionA feasible solution is one that satisfies ALL the constraintsFor an LP problem, square of the decision variable cannot be part of any of theconstraint as it makes the constraint non-linear. Functions like ABS, MIN and Max can freely be used to define the constraints in an LPproblem4 points 1. QUESTION 5Starbucks needs to decide how many muffins and how many croissants to produceeach day. The profit per muffin is $2 and the profit per croissant is $1.5. On an average, eachmuffin takes 3 minutes of labor time and 3 minutes of oven time (of course they areproduced in batches. For simplification I have given you the time per piece). Croissants take10 minutes of labor time and 1 minute of oven time. Starbucks can have its labor dedicatedfor 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. Thecorrect algebraic form for the constraint on labor time available is: ABCD- 3m + 10c < 1203m + 10c < 210m +3c < 1203m + 3c < 2