1 A You Have Just Been Hired By A Soccer Team That Plays In England Premier League Your Boss Thought There Is A Probl 1 (61.63 KiB) Viewed 39 times
1 A You Have Just Been Hired By A Soccer Team That Plays In England Premier League Your Boss Thought There Is A Probl 2 (74.75 KiB) Viewed 39 times
1 A You Have Just Been Hired By A Soccer Team That Plays In England Premier League Your Boss Thought There Is A Probl 3 (54.77 KiB) Viewed 39 times
1. A. You have just been hired by a soccer team that plays in England premier league. Your boss thought there is a problem in forecasting pizza needs to prepare for every match. Specifically, they serve Nino's Bellissima Pizza, an expensive elegant caviar dressed pizza, exclusively for VIP section. Each pizza costs 90$ and is highly perishable. Knowing this, you have asked for data on last years of historical sales as well as any forecasts, promotions, pricing changes, or competitive analyses made during this time. Your boss laughs and provides you with all the data they have: The actual sales from last 13 games! Game 1 2 3 4 5 6 7 8 00 9 10 11 2 13 Sales 159 161 121 216 122 136 195 210 222 234 246 220 230 H "I
Demand planners! Use the following different time series forecasting methods to develop forecasts for matches 1 to 13 when is applicable. a. Naive b. Simple average c. Moving average Luse 2 period and 3 period lengths for periods used in calculating averages) d. Exponential smoothing (Try alpha=0.1 AND alpha=0.5 AND alpha=0.9) e. Compare methods (a) to (d) using MAD, MSE and MAPE. Is there one method which appears to be best using all 3 different error evaluation methods?
team has suggested that the game importance (5= greatest, 1=lowest) has a positive effect on sales. a. Test if this factor has an influence. Draw the regression. b. What other factors you may consider to have a good regression analysis? Game 1 2 3 4 5 6 7 8 9 10 11 12 13 HINT: Y = AX + B Sales = A Importance + B Sales 159 161 121 216 122 136 195 210 222 234 246 220 230 Importance 3 3 5 2 3 4 s 3 5 4 4 H H
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!