A pharmaceutical company produces a sinus medicine. Monthly sales (in thousands of doses) for the past three

Question:

A pharmaceutical company produces a sinus medicine. Monthly sales (in thousands of doses) for the past three years are shown in the table on the next page.8,018 Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec 6,788 8,020 1,848 410 9,384 6,916 5,698 6,940 9,136

a. Develop a regression model that allows for trend and seasonal components. Obtain the Excel output for this model.

b. Calculate a two-period moving-average forecast.

c. Compare the mean absolute deviations for these approaches. 

d. Use one of these models to forecast sales for each month of year 3.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: