As the end of year holiday season approaches, Daniel Collins…
Question Answered step-by-step As the end of year holiday season approaches, Daniel Collins… As the end of year holiday season approaches, Daniel Collins already started selling his unique homemade panettones. He uses a secret recipe from his Italian family, and his panettones are popular in his neighborhood. He was thinking of a way to involve his daughter, Kelly Collins, in the family business. He thinks it would be a good idea to ask her help to forecast the panettone sales of the season. Daniel shares with Kelly the data from the last 15 days, as given below: DayDemand 135237324431527629721839927103111231228133214301529Kelly wants to forecast sales for Day 16 using the moving average model. 1. What is the forecast for Day 16 demand if she uses a 3-period moving average model?Round your answer to nearest integer. 2. What is the forecast for Day 16 demand if she uses a 6-period moving average model?Round your answer to the nearest integer. Question 2 Kelly remembers from her courses that the value of data may degrade over time. As she wants to take this into account, she now decides to build a forecast table using a simple exponential smoothing model. She thinks that an alpha = 0.25 is a reasonable choice. What is the forecast for Day 16 demand using this model? Assume that the forecast for Day 1, X?0,1 is 32.Round your answer to the nearest integer Question 3 What is the Root Mean Square Error (RMSE) of the forecasted demand using the 6-period moving average model (as calculated in Question 1)?Round your answer to three decimal places (e.g., if your answer is 20.8723 enter 20.872). What is the Root Mean Square Error (RMSE) of the forecasted demand using the simple exponential smoothing model (as calculated in Question 2)? Round your answer to three decimal places (e.g., if your answer is 20.8723 enter 20.872). Question 4 Daniel has innovated this year and started to sell chocottones, a special type of panettone that replaces the candied fruits and raisins with creamy milk chocolate chunks and is topped with a dark chocolate layer. Although the product sales were not performing well during the first days, Kelly noticed that the amount of chocottones sold seems to be constantly increasing in the last 10 days, after they started to offer free samples of it in the store. She thinks this is a good opportunity to apply the exponential smoothing for level and trend model. If she estimates the value of to be â 10 to be 14 and the trend component bcap10 to be 5, what is the forecast for Day 12 demand? Consider the actual demand of Day 11 to be x11 =25, alpha = 0.15 and beta= 0.10. Accounting Business Financial Accounting MITX: SC1X Share QuestionEmailCopy link Comments (0)


