Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ms. Kathleen Boyd, director of logistics for the Scenic Calendar Company, wishes to evaluate two methods of time series forecasting. She has collected quarterly calendar

Ms. Kathleen Boyd, director of logistics for the Scenic Calendar Company, wishes to evaluate

two methods of time series forecasting. She has collected quarterly calendar sales data from the

years 2003 and 2004.

2003 . 2004

Qtr. Actual Sales Qtr. Actual Sales

1 1200 1 1300

2 800 2 800

3 200 3 250

4 1000 4 1200

a.Use the moving averages technique to find forecasted sales for the third quarter of 2009 based on actual sales from the previous three quarters. (0,5p)

b. Use simple exponential smoothing to forecast each quarters sales in 2009, given that Mr. Clayton qualitatively forecasted 800 calendars for quarter 4, 2008. Mr. Clayton has assigned an alpha factor of 0,1 for time series sensitivity. (0,5p)

c. Repeat the simple exponential smoothing problem above (part 5b) with Mr Clayton employing an alpha factor of 0,8. (0,5p)

d. How well does the moving averages and simple exponential smoothing techniques seem to work in Mr. Claytons situation? In what ways do the techniques appear to fail? Explain. (0,5p)

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

The Municipal Budget Crunch A Handbook For Professionals

Authors: Roger L. Kemp

1st Edition

0786463740, 978-0786463749

More Books

Students also viewed these Finance questions