50 51 7) Consider the recipes for each pastry given in the worksheet "Recipes". 52 How many eggs do you need for week 53 based on your answer to question 6 and the given recipes? Round up to the nearest integer. Forecast for 53 week 53 Number of eggs 54 needed ?G H 4) a) Compute the MAD for each of the appropriate forecasting methods applied to sales data. COMPLETE the worsheets titled MAD-Danish, MAD-Croissant, MAD-Donut b) Summarize your results from part a by filling in the table below. Round to four decimal places. If a forecasting method is not appropriate for a sales data then leave that cell blank. Exp Smoothing Moving Avg Linear MAD TABLE w/ alpha=0.3 (N=10) Regression Danish Sales Croissant Sales Donut Sales 15 ) What is the best forecasting method for each pastry based on your answer to question 4? FILL IN THE TABLE BELOW by selecting from the drop down list: Best Forecasting Method Danish Sales Croissant Sales Donut Sales 6) Forecast sales of each pastry for week 53 given your stated choice in question 5. You will want to use the worksheets MAD-banish, MAD-Croissant, and MAD-Donut to solve this problem. Summarize your results by filling in the table below. Round to one decimal place. Forecast for week 53 Danish Sales Croissant Sales Donut Sales MAD-Donut CONTEXT Prompts Sales Recipes ScatterPlots MAD-Danish MAD-Croissant F Ready Accessibility: Good to go2 ULTIMATE GOAL: Forecast the number of eggs needed for week 53 given the past pastry sales data 3 ANSWER THE FOLLOWING QUESTIONS BELOW: 4 5 1) CREATE a scatter plot of sales data for each pastry type. 6 INCLUDE the scatter plot for each sales data in the worksheet titled ScatterPlots. 8 12) Which of the following forecasting methods are appropriate to use for each of the pastry sales data? 9 *Exponential Smoothing with alpha = 0.3 & use simple naive method to obtain forecast for week 2 10 *Moving Average of order 10 11 *Simple Linear Regression Method 12 FILL IN THE TABLE BELOW by selecting from the drop down list: Exp Smoothing Moving Avg Linear W Appropriate? a/ alpha=0.3 (N=10) Regression Danish Sales 15 Croissant Sales 16 Donut Sales 8 19 3) Explain your reasoning for your answer to question 2. 20 Replace question marks below with your reasoning a) Danish Sales: b) Croissant Sales: c) Donut Sales