Calculate the five-month moving average

Assignment Help Operation Management

Reference no: EM131869682

a. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

Month	Sales (000)Units
Feb.	15
Mar.	16
Apr.	13
May.	20
Jun.	20
Jul.	23
Aug.	25

b. Forecast September sales volume using each of the following:

(1) A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)

Yt thousands

(2) A five-month moving average. (Round your answer to 2 decimal places.)

Moving average thousands

(3) Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 17(000). (Round your intermediate forecast values and final answer to 2 decimal places)

Forecast thousands

(4) The naive approach.

Naive approach thousands

(5) A weighted average using .50 for August, .10 for July, and .40 for June. (Round your answer to 2 decimal places.)

Weighted average thousands

Reference no: EM131869682

Questions Cloud

Describe briefly the life and character of muhammad : Describe briefly the life and character of Muhammad, noting especially his call and role as the last prophet of God.

How many units of each product to produce per day : Define variables and formulate a linear programming (LP) model to determine how many units of each product to produce per day to maximize its total income.

How did the technologies of cinchona bark : Of the many technologies of imperialism, how did the technologies of cinchona bark and maps enable the success of European imperial ventures?

Determine what type of robber committed this offense : You studied violent crimes. The scenario depicted a violent crime that had taken place. That crime was a robbery.

Calculate the five-month moving average : Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 17(000).

What opinions each of women might have on role women play : Biographical information for each woman. What opinions each of the women might have on the role the women should play in society during their lifetimes.

Why are naive forecasts used as a baseline : Why are naive forecasts used as a baseline when evaluating the predictive performance of another method/model?

Explain the commercials you have seen on tv or heard : Name the best two (2) commercials you have seen on TV or heard on the radio lately. What makes them so effective and how might they improve on them?

What might prevent organizations from evaluating systems : What might prevent organizations from evaluating their staffing systems, and what can be done to remove these barriers?

User Account

All Pages