how do I set this simulation up in excel.

1) what is the profit for 1 day of operations if you take 13 gallons and demand is 4 gallons of hot chocolate

2) ) what is the profit for 1 day of operations if you take 9 gallons and demand is 13 gallons of hot chocolate

3) ) what is the profit for 1 day of operations if you take 4 gallons and demand is 4 gallons of hot chocolate

You are interested in selling gourmet hot chocolate at the entrance to the Shelby County Starry Nights. You have a special family recipe that uses real cream, rich imported cocoa, and other fine ingredients; it tastes amazing but the hot chocolate is only good while it is fresh. This event is expected to run for 28 days. You can further assume there is no difference in demand due to the type of vehicles allowed on different nights. Simulate 300 days of sales to calculate your expected daily profit from this endeavor. According to research from past events, nightly demand in gallons) will follow the distribution shown in the text box below. You plan to sell the hot chocolate in 8 oz cups for $3.00; and according to your estimates it will cost $1.14 per serving to prepare, deliver, and serve the hot chocolate. Nightly Demand for Gallons of Gourmet Hot Chocolate Probability 20 .06 .08 .10 55 60 .09 .03 This project is composed of three separate quizzes. The first is the Simulation Design Test for Simulation Project 2 Part 1. This quiz must be successfully completed with a 100% on the 3 questions before the Simulation Design Test for Simulation Project 2 Part 2 quiz will become available. Only after completing the part 1 and part 2 quizzes successfully will the graded Simulation Project 2 quiz be released. The purpose of the first two quizzes is to encourage you to spend adequate time on the design stage and make sure you can: First, in part 1, "run the company" and correctly calculate the profit for a few days - If we don't understand the operations or how to calculate the profit correctly, then the simulations results will be meaningless. Using paper and pencil and even creating a storyboard will be very helpful in this stage of the project. Second, in part 2, once we understand how the company operates on a day to day basis we will need to identify and generalize the patterns so we can properly set up the simulation. Once you successfully complete the Simulation Design Test for Simulation Project 2, move on to complete the Simulation Project 2 quiz. You should extend your model from a static calculation to the full simulation. There are five questions on that quiz where you will be asked to simulate 300 days of sales, calculate the average daily profit, and answer the following five questions: . 1. A) If you prepare and take 25 gallons of hot chocolate, what is your average daily profit? B) What is your expected daily profit if you prepare and take 35 gallons with you each night? C) What is your expected daily profit if you prepare and take 45 gallons with you each night? D) What is your expected daily profit if you prepare and take 55 gallons with you each night? E) Based on the prior 4 scenarios how many gallons should you prepare and take every night? Because this is a simulation, I recommend you hit F9, 4 or 5 times and take an average of your answers to get the answer you will put into ecourseware. The answer key has a 90% confidence interval - which is why you need to get an average of the answers. You are interested in selling gourmet hot chocolate at the entrance to the Shelby County Starry Nights. You have a special family recipe that uses real cream, rich imported cocoa, and other fine ingredients; it tastes amazing but the hot chocolate is only good while it is fresh. This event is expected to run for 28 days. You can further assume there is no difference in demand due to the type of vehicles allowed on different nights. Simulate 300 days of sales to calculate your expected daily profit from this endeavor. According to research from past events, nightly demand in gallons) will follow the distribution shown in the text box below. You plan to sell the hot chocolate in 8 oz cups for $3.00; and according to your estimates it will cost $1.14 per serving to prepare, deliver, and serve the hot chocolate. Nightly Demand for Gallons of Gourmet Hot Chocolate Probability 20 .06 .08 .10 55 60 .09 .03 This project is composed of three separate quizzes. The first is the Simulation Design Test for Simulation Project 2 Part 1. This quiz must be successfully completed with a 100% on the 3 questions before the Simulation Design Test for Simulation Project 2 Part 2 quiz will become available. Only after completing the part 1 and part 2 quizzes successfully will the graded Simulation Project 2 quiz be released. The purpose of the first two quizzes is to encourage you to spend adequate time on the design stage and make sure you can: First, in part 1, "run the company" and correctly calculate the profit for a few days - If we don't understand the operations or how to calculate the profit correctly, then the simulations results will be meaningless. Using paper and pencil and even creating a storyboard will be very helpful in this stage of the project. Second, in part 2, once we understand how the company operates on a day to day basis we will need to identify and generalize the patterns so we can properly set up the simulation. Once you successfully complete the Simulation Design Test for Simulation Project 2, move on to complete the Simulation Project 2 quiz. You should extend your model from a static calculation to the full simulation. There are five questions on that quiz where you will be asked to simulate 300 days of sales, calculate the average daily profit, and answer the following five questions: . 1. A) If you prepare and take 25 gallons of hot chocolate, what is your average daily profit? B) What is your expected daily profit if you prepare and take 35 gallons with you each night? C) What is your expected daily profit if you prepare and take 45 gallons with you each night? D) What is your expected daily profit if you prepare and take 55 gallons with you each night? E) Based on the prior 4 scenarios how many gallons should you prepare and take every night? Because this is a simulation, I recommend you hit F9, 4 or 5 times and take an average of your answers to get the answer you will put into ecourseware. The answer key has a 90% confidence interval - which is why you need to get an average of the answers