Make your own free website on Tripod.com
Double Expotential Smooth


<>
Quarter Sales St1 St2 Alpha
t-12 55 55 55 0.133586243
t-11 60 55 55 1-Alpha
t-10 64 55.66793122 55 0.866413757
t-9 68 56.78098098 55.08922642
t-8 72 58.27968758 55.31522156
t-7 75 60.11253257 55.71123344
t-6 78 62.10129341 56.29918645
t-5 81 64.22514189 57.07426812
t-4 83 66.46603216 58.02952648
t-3 85 68.67474281 59.15652758
t-2 86 70.85557258 60.42803019
t-1 87 72.87865974 61.82100641
Most Recent 88 74.76507654 63.29815677



a 86.2319963
Final Forecast 88
St+m 1
Trial & Error 2.16315E-09



(1-Alpha) 0.866413757
Quarter Sales St1 St2 Alpha used 0.133586243
t-11 60 60 60 a 87.47551686
t-10 64 60 60 b 1.549190903
t-9 68 60.53434497 60
t-8 72 61.53165378 60.07138114 Future Sales Period Future Forcast
t-7 75 62.93008082 60.26645347 1 89.02470776
t-6 78 64.54245598 60.62227744 2 90.57389867
t-5 81 66.34019872 61.14595937 3 92.12308957
t-4 83 68.2985465 61.83983829 4 93.67228047
t-3 85 70.26245844 62.70263285 5 95.22147138
t-2 86 72.23119125 63.71252155 6 96.77066228
t-1 87 74.07051468 64.85049863
Most Recent 88 75.79771605 66.08216593
t+1 89.02470776 77.42777332 67.38002977
t+2 90.57389867
t+3 92.12308957
t+4 93.67228047
t+5 95.22147138
t+6 96.77066228