Creating moving average forecasting model to forecast sales

Assignment Help Operation Management

Reference no: EM13105502

Sales of Hot-Blast heaters have grown steadily during the past five years, as shown in the following table:
YEAR
SALES
1
480
2
525
3
548
4
593
5
614
Using exponential smoothing constants of 0.35 and 0.65, develop forecasts for years 2 through 6. The sales manager had predicted, before the business started, that year 1's sales would be 440 air conditioners. Based on error (MAD, MSE or MAPE: any one of these is fine), which smoothing constant gives the most accurate forecast?
Use a three-year moving average forecasting model to forecast sales of heaters.
Which of the methods analyzed here would you use? Explain your answer.

Reference no: EM13105502

Questions Cloud

Physics majors belong to ethnic minorities : In a certain college, 20% of the physics majors belong to ethnic minorities. If 10 students are selected at random from the physics majors, what is the probability that exactly 2 belong to an ethnic minority?

Determine the upper bound : Customers arrive at a fast food restaurant with one server at a mean rate of 30 per hour. The server has just resigned, and the two candidates for the replacement are X (fast but expensive) and Y (slow but inexpensive).

What is the magnitude of the electric field at a point : Two parallel, uniformly charged, infinitely long wires carry opposite charges with a linear charge density ? = 2.15 ?C/m and are 6.69 cm apart. What is the magnitude of the electric field at a point midway between them and 54.3 cm above the plane ..

Confidence level-number of books : People were polled on how many books they read the previous year. How many subject are needed to estimate the number of books read the previous year within one book with 99% confidence?

Creating moving average forecasting model to forecast sales : Sales of Hot-Blast heaters have grown steadily during the past five years, as shown in the following table, Using exponential smoothing constants of 0.35 and 0.65, develop forecasts for years 2 through 6.

Discuss various factors that affect the demand for bonds : Interpret this graph using the Loan able funds theory. Discuss various factors that affect the demand for bonds and supply of bonds.

Proportion of households with two cars : A researcher wishes to estimate the number of households with two cars. How large a sample is needed in order to be 95% confident that the sample proportion will not differ from the true proportion by more than 4%? A previous study indicates that ..

Mean and margin of error : In a random sample of 26 people, the mean number of books they had read in the past year was 14.93 books and the standard deviation was 16.60 books.

Social issue-vulnerable population affect global community : In a 800 word paper, choose social issue or vulnerable population affecting global community, and analyze nature of population and social issues confronting them, exploring macro practice interventions.

User Account

All Pages