Forecasting and Demand
MarHelperAnswer 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
- 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.
- Explain how you could make your forecast’s results more reliable by incorporating a qualitative research to your quantitative results.
- 4 years ago
- 7
Answer(0)
other Questions(10)
- this assignment is for sky essays
- explain the Telecommunications Reform Act of 1996, aka Communications Decency Act (CDA).
- Case study-Leadership Communication
- disscussion board
- Bob’s Chocolate Chips and More, a bakery specializing in gourmet pizza and chocolate chip cookies, started business on October 1, 2016. The following transactions occurred during the month.
- ! need a 100% original 3-4 page case study
- CIS242 Lab 1
- Management of Human Resources
- Social Media Platform
- due tomorrow 5pm