please please please do all parts of the question
Highl A Read aloud | Draw wwwwwww wwwwwww VIL student must submit the project - be sure to include the names of both students in the group. A local pastry shop is planning their next morning's production. The shop has three main items that they sell cakes, cupcakes, and cannolis. All of these are made in-house with the shop's own ingredients. The recipes for these items are as follows: Cakes: 5 eggs, 2 cups flour, 15 g of sugar, 1 cup of milk Cupcakes: 2 egg, 0.5 cups of flour, 10 g of sugar, 0.25 cup of milk Cannoli: 4 eggs, no flour, 25 g of sugar, 0.25 cup of milk The pastry shop sells cakes for $8, cupcakes for $3, and cannolis for $6. At the moment, there are 150 eggs, 50 cups of flour, 5 kg of sugar, and 4 gallons of milk available. 1. How much of each item should the pastry shop make in order to maximize their potential profit? What is their maximum potential profit? 2. Suppose the shop had to make at least 5 of each item in order to keep a sufficient variety ready? What would be the new optimal combination? What is their maximum potential profit now? 3. Now suppose that tomorrow they are receiving an order of 100 eggs, 35 cups of flour, 3 kg of sugar, and 2 gallons of milk. What production plan maximizes your potential profit for the next two days? What is this maximum potential profit? Remember that they must still make at least 5 of each item every day. Submit an Excel spreadsheet with your name(s), one tab for each question, and your Excel Solver solution; ensure that you clearly identify each answer and that your answers are generated with Excel Solver. In addition, design the commercial bakery mixer shown using SolidWorks, your design should be included on a separate tab on the same Excel spreadsheet. ca Highl A Read aloud | Draw wwwwwww wwwwwww VIL student must submit the project - be sure to include the names of both students in the group. A local pastry shop is planning their next morning's production. The shop has three main items that they sell cakes, cupcakes, and cannolis. All of these are made in-house with the shop's own ingredients. The recipes for these items are as follows: Cakes: 5 eggs, 2 cups flour, 15 g of sugar, 1 cup of milk Cupcakes: 2 egg, 0.5 cups of flour, 10 g of sugar, 0.25 cup of milk Cannoli: 4 eggs, no flour, 25 g of sugar, 0.25 cup of milk The pastry shop sells cakes for $8, cupcakes for $3, and cannolis for $6. At the moment, there are 150 eggs, 50 cups of flour, 5 kg of sugar, and 4 gallons of milk available. 1. How much of each item should the pastry shop make in order to maximize their potential profit? What is their maximum potential profit? 2. Suppose the shop had to make at least 5 of each item in order to keep a sufficient variety ready? What would be the new optimal combination? What is their maximum potential profit now? 3. Now suppose that tomorrow they are receiving an order of 100 eggs, 35 cups of flour, 3 kg of sugar, and 2 gallons of milk. What production plan maximizes your potential profit for the next two days? What is this maximum potential profit? Remember that they must still make at least 5 of each item every day. Submit an Excel spreadsheet with your name(s), one tab for each question, and your Excel Solver solution; ensure that you clearly identify each answer and that your answers are generated with Excel Solver. In addition, design the commercial bakery mixer shown using SolidWorks, your design should be included on a separate tab on the same Excel spreadsheet. ca
