Question: This is a forecasting exercise. please help me find the moving average, exponential smoothing, fit regression. The problem is below: Serious Cereals Inc. Serious Cereals

This is a forecasting exercise. please help me find the moving average, exponential smoothing, fit regression. The problem is below:This is a forecasting exercise. please help me find the moving average,

Serious Cereals Inc. Serious Cereals Inc. had the following monthly sales over the past year: \begin{tabular}{|l|c|} \hline Month & Sales($000) \\ \hline January & 1212 \\ \hline February & 1321 \\ \hline March & 1278 \\ \hline April & 1341 \\ \hline May & 1257 \\ \hline June & 1287 \\ \hline July & 1189 \\ \hline August & 1111 \\ \hline September & 1145 \\ \hline October & 1150 \\ \hline November & 1289 \\ \hline January & 1331 \\ \hline \end{tabular} Input this data into Excel and do the following: 1. Calculate a 4-month moving average forecast. What is your forecast for month 13 ? 2. Use exponential smoothing with a smoothing factor of 0.30 to calculate a forecast for month 13. 3. Fit a regression model to the data to forecast for month 13

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!