Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The sales of the last 1 2 months in a computer company occur immediately. Respond by giving procedures and answers. MONTH / SALES ( millions

The sales of the last 12 months in a computer company occur immediately. Respond by giving procedures and answers.
MONTH / SALES (millions of $)
January 20
February 24
March 29
April 32
May 37
June 47
July 53
August 62
September 64
October 36
November 23
December 29
a) Use a three-month moving average to forecast sales for January of the following year.
b) Use a four-month moving average to forecast next year's January sales.
c) Compare the performance of the two methods using the mean absolute deviation as the performance criterion. What method would you recommend?
d) Compare the performance of the two methods using the mean percentage error as the performance criterion. What method would you recommend?
Consider the data above:
a) Use a weighted moving average to forecast next year's January sales. Use the weights (3/6),(2/6) and (1/6), giving more weight to the most recent data.
b) Use exponential smoothing with =0.6,0.4,0.2 to forecast the February sale of the next year. Suppose the initial forecast for January was $22 million.

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

Essentials of Strategic Management

Authors: Martyn R Pitt, Dimitrios Koufopoulos

1st edition

978-1849201872, 1849201870, 978-1260092271

More Books

Students also viewed these General Management questions

Question

What were some of the earliest powder metallurgy products?

Answered: 1 week ago

Question

Describe the meaning of a null and an alternative hypothesis.

Answered: 1 week ago