Estimating Seasonal Factors A B C D Deseasonalized Seasonal Period Demand Demand Factor t D D Dt (Egn 7.4) (Egn 7.5) St S 8,000 18,963 0.42 D 13,000 19,487 0.67 23,000 20 011 1.15 J O U1 + W N - 34,000 20,535 1.66 10,000 21,059 0.47 18,000 21,583 0.83 23,000 22,107 1.04 8 38,000 22,631 1.68 9 12,000 23,155 0.52 11 10 13,000 23,679 0.55 12 11 32,000 24,203 1.32 13 12 41,000 24,727 1.66 Cell Cell Formula Equation Copied to C2 =18439+A2*524 7.4 C3:C13 D2 =B2/C2 7.5 D3:D13 Figure 7-4