Answered step by step
Verified Expert Solution
Question
1 Approved Answer
5. [20 points] Following table shows the sales data of printing paper (in reams) for the past 12 weeks at a stationary retailer: Week 1
5. [20 points] Following table shows the sales data of printing paper (in reams) for the past 12 weeks at a stationary retailer: Week 1 2 3 4 5 6 7 8 9 19 11 12 Sales 908 919 924 909 912 907 882 914 895 917 891 897 a. Calculate the forecast sales for week 13 using four-week moving average [5 points] b. Forecast sales for week 13 using the weighted moving average method. The weights are Wt1=0.5, W2 = 0.3, W3 = 0.2. [5 points] c. If the actual sales for week 13 is 901, calculate the forecasting error for each method (MA and WMA) for week 13. [5 points] d. Which forecasting method is more accurate? Explain why. [5 points] Show all calculations to earn full credit.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started