Complete the questions below. Submit only an Excel spreadsheetwith your name, one tab for each question, and your Excel Solversolution; ensure that you clearly identify each answer.
A local pastry shop is planning their next morning’s production.The shop has three main items that they sell: cakes, cupcakes, andcannolis. All of these are made in-house with the shop’s owningredients. The recipes for these items are as follows:
Cakes: 5 eggs, 2 cups flower, 15 g of sugar, 1 cup of milk
Cupcakes: 2 egg, 0.5 cups of flower, 10 g of sugar, 0.25 cup ofmilk
Cannoli: 4 eggs, no flower, 25 g of sugar, 0.25 cup of milk
The pastry shop sells cakes for $8, cupcakes for $3, andcannolis for $6. At the moment, there are 150 eggs, 50 cups offlower, 5 kg of sugar, and 4 gallons of milk available.
1. How much of each item should the pastry shop make in order tomaximize their potential profit? What is their maximum potentialprofit?
2. Suppose the shop had to make at least 5 of each item in orderto keep a sufficient variety ready? What would be the new optimalcombination? What is their maximum
potential profit now?
3. Now suppose that tomorrow they are receiving an order of 100eggs, 35 cups of flour, 3 kg of sugar, and 2 gallons of milk. Whatproduction plan maximizes your potential profit for the next twodays? What is this maximum potential profit? Remember that theymust still make at least 5 of each item every day.
