Assignment: Forecasting And Demand Planning
Answer the following questions and upload to Canvas. Submit in Word or PDF format. Show your work and upload the Excel sheet as well. All the writing parts must be your original writing, don't quote, write in your own words.
The following table presents the orders of Samson Company for the last 36 months (3 years).
Month Order Year 1 Order Year 2 Order Year 3
January 502 614 712
February 408 592 698
March 491 584 686
April 456 532 644
May 481 599 694
June 511 604 702
July 522 624 724
August 500 612 716
September 510 625 732
October 512 627 740
November 520 650 745
December 536 680 756
1. Use the data in the above table and regression analysis to forecast the orders for the next 12 months (4th year). Include your excel work sheet and your work in your write up. Show the regression equation, values of intercept, slope, correlation coefficient and coefficient determination and the forecast of orders for the next 12 months.
2. Explain how you could make your forecast's results more reliable by incorporating a qualitative research to your quantitative results.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.