Purpose of Assignment

The purpose of this assignment is for students to learn how to apply Operations Forecasting.

Assignment Steps

Resources: Use Microsoft^® Excel^® to do the forecast.

The instructor will provide information and data for this assignment.

Assignment:

1. Write a brief APA paper to analyze and comment on the forecasting system being used by Fork and Hoe. Suggest changes or improvements that you believe are justified. Include a response to question 6 after you have completed the year 5 forecast.

2. Determine if the 4 years of demand data indicate an ANNUAL trend.

3. Determine if the 4 years of demand data indicates MONTHLY seasonality. If so, illustrate how you make the adjustments to your year 5 forecast.

4. Develop an ANNUAL forecast for bow rakes for year 5. Develop a MONTHLY forecast for each month of year 5. Justify your forecast by showing your work.

5. Include an Excel spread sheet with the paper to illustrate the details of your forecasting method.

6. Determine if your year 5 forecast will correct the problems that plague Fork and Hoe..

Format your assignment consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment.