In: Statistics and Probability
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 |
450 |
600 |
612 |
February |
418 |
575 |
668 |
March |
490 |
580 |
680 |
April |
451 |
534 |
653 |
May |
466 |
555 |
674 |
June |
511 |
604 |
702 |
July |
522 |
624 |
724 |
August |
500 |
612 |
716 |
September |
502 |
633 |
712 |
October |
523 |
634 |
724 |
November |
533 |
643 |
735 |
December |
534 |
676 |
755 |
ANSWER::
FORMULAS:
Slope |
b1= nE(xy)-ExEy/nE(x2)-(Ex2) |
Intercept | b0=Ey-b1Ex/n |
Regression | n(Exy)-(Ex)(Ey)/sqrt(nEx2-(Ex)2)(nEy2-(Ey)2) |
By including qualitative factors such as customer's preferences, external variables, regulatory changes, one can make the forecast more robust and reduce the error in the forecast. Also, this would lead to better planning and optimizing the inventory in the process.
NOTE:: I HOPR THIS ANSWER IS HELPFULL TO YOU......**PLEASE SUPPORT ME WITH YOUR RATING......
**PLEASE GIVE ME "LIKE".....ITS VERY IMPORTANT FOR,ME......PLEASE SUPPORT ME .......THANK YOU