Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
5. [20 points] Following table shows the sales data of printing paper (in reams) for the past 12 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,W12=0.3,Wt3=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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introductory Statistics Exploring The World Through Data

Authors: Robert Gould, Colleen Ryan

2nd Edition

9780321978509, 321978277, 321978501, 978-0321978271

Students also viewed these General Management questions

Question

marketing management application to personal life

Answered: 1 week ago