Estimating Seasonal Factors A B C D Deseasonalized Seasonal Period Demand Demand Factor Dt (Egn 7.4) (Egn 7.5) S - 8,000 18,963 0.42 13,000 19,487 0.67 3 23,000 20,011 1.15 34,000 20,535 1.66 SOONQUAWN 5 10,000 21,059 0.47 6 18,000 21,583 0.83 23,000 22,107 1.04 8 38,000 22.631 1.68 12,000 23,165 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