Business & Finance assignment

profilejamallsingleton
CleanSweepStudentFileNo.1Fall2023Solution.xlsx
Home>Business & Finance homework help>Business & Finance assignment

DailyData

Clean Sweep Individual Case Assignment, QNT 5160, Fall 2023
File No. 1 (Daily data for week 44 through 5)
Actual
Call
Week Day Volume
44 Mon 1,130
44 Tue 851
44 Wed 589
44 Thur 828
44 Fri 726
45 Mon 1,085
45 Tue 1,042
45 Wed 892
45 Thur 840
45 Fri 799
46 Mon 1,303
46 Tue 1,121
46 Wed 1,003
46 Thur 1,113
46 Fri 1,005
47 Mon 2,652
47 Tue 2,825
47 Wed 1,841
47 Thur 1,851
47 Fri 1,813
48 Mon 1,949
48 Tue 1,507
48 Wed 989
48 Thur 990
48 Fri 1,084
49 Mon 1,260
49 Tue 1,134
49 Wed 941
49 Thur 847
49 Fri 714
50 Mon 1,002
50 Tue 847
50 Wed 922
50 Thur 842
50 Fri 784
51 Mon 823
51 Tue 756
51 Wed 699
51 Thur 401
51 Fri 429
52 Mon 1,209
52 Tue 830
52 Wed 852
52 Thur 1,082
52 Fri 841
1 Mon 1,362
1 Tue 1,174
1 Wed 967
1 Thur 930
1 Fri 853
2 Mon 924
2 Tue 954
2 Wed 1,346
2 Thur 904
2 Fri 758
3 Mon 886
3 Tue 878
3 Wed 802
3 Thur 945
3 Fri 610
4 Mon 910
4 Tue 754
4 Wed 705
4 Thur 729
4 Fri 772
5 Mon 723
5 Tue 677
5 Wed 521
5 Thur 571
5 Fri 498

1130 851 589 828 726 1085 1042 892 840 799 1303 1121 1003 1113 1005 2652 2825 1841 1851 1813 1949 1507 989 990 1084 1260 1134 941 847 714 1002 847 922 842 784 823 756 699 401 429 1209 830 852 1082 841 1362 1174 967 930 853 924 954 1346 904 758 886 878 802 945 610 910 754 705 729 772 723 677 521 571 498

Seasonal Factors

Template for Seasonal Factors
True Range Name Cells
Week Day Value Type of Seasonality SeasonalFactor G10:G21
44 Mon 1,130 Daily TrueValue D5:D69
44 Tue 851 TypeOfSeasonality F5
44 Wed 589
44 Thur 828 Estimate for
44 Fri 726 Day Seasonal Factor
45 Mon 1,085 Mon 1.2272
45 Tue 1,042 Tue 1.0916
45 Wed 892 Wed 0.9335
45 Thur 840 Thur 0.9152
45 Fri 799 Fri 0.832
46 Mon 1,303
46 Tue 1,121
46 Wed 1,003
46 Thur 1,113
46 Fri 1,005
47 Mon 2,652
47 Tue 2,825
47 Wed 1,841
47 Thur 1,851
47 Fri 1,813
48 Mon 1,949
48 Tue 1,507
48 Wed 989
48 Thur 990
48 Fri 1,084
49 Mon 1,260
49 Tue 1,134
49 Wed 941
49 Thur 847
49 Fri 714
50 Mon 1,002
50 Tue 847
50 Wed 922
50 Thur 842
50 Fri 784
51 Mon 823
51 Tue 756
51 Wed 699
51 Thur 401
51 Fri 429
52 Mon 1,209
52 Tue 830
52 Wed 852
52 Thur 1,082
52 Fri 841
1 Mon 1,362
1 Tue 1,174
1 Wed 967
1 Thur 930
1 Fri 853
2 Mon 924
2 Tue 954
2 Wed 1,346
2 Thur 904
2 Fri 758
3 Mon 886
3 Tue 878
3 Wed 802
3 Thur 945
3 Fri 610
4 Mon 910
4 Tue 754
4 Wed 705
4 Thur 729
4 Fri 772
5 723
5 677
5 521
5 571
5 498

Last Value with Seasonality

Template for Last-Value Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting ActualForecast G6:G75
Week Day Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H75
44 Mon 1,130 921 Daily MAD K23
44 Tue 851 780 921 1,005 154 MSE K26
44 Wed 589 631 780 728 139 Day Seasonal Factor SeasonalFactor K9:K20
44 Thur 828 905 631 577 251 Mon 1.2272 SeasonallyAdjustedForecast F6:F75
44 Fri 726 872 905 753 27 Tue 1.0916 SeasonallyAdjustedValue E6:E75
45 Mon 1,085 884 872 1,070 15 Wed 0.9335 TrueValue D6:D75
45 Tue 1,042 955 884 965 77 Thur 0.9152 TypeOfSeasonality K6
45 Wed 892 955 955 891 1 Fri 0.8324
45 Thur 840 918 955 875 35 1.053
45 Fri 799 960 918 764 35 0.915
46 Mon 1,303 1,062 960 1,178 125 0.908
46 Tue 1,121 1,027 1,062 1,159 38 1.064
46 Wed 1,003 1,074 1,027 959 44 1.041
46 Thur 1,113 1,216 1,074 983 130 1.018
46 Fri 1,005 1,207 1,216 1,012 7 0.884
47 Mon 2,652 2,161 1,207 1,482 1,170
47 Tue 2,825 2,588 2,161 2,359 466 Mean Absolute Deviation
47 Wed 1,841 1,972 2,588 2,416 575 MAD = 164
47 Thur 1,851 2,022 1,972 1,805 46
47 Fri 1,813 2,178 2,022 1,683 130 Mean Square Error
48 Mon 1,949 1,588 2,178 2,673 724 MSE = 66,916
48 Tue 1,507 1,380 1,588 1,734 227
48 Wed 989 1,059 1,380 1,289 300
48 Thur 990 1,082 1,059 970 20
48 Fri 1,084 1,302 1,082 900 184
49 Mon 1,260 1,027 1,302 1,598 338
49 Tue 1,134 1,039 1,027 1,121 13
49 Wed 941 1,008 1,039 970 29
49 Thur 847 925 1,008 923 76
49 Fri 714 858 925 770 56
50 Mon 1,002 816 858 1,053 51
50 Tue 847 776 816 891 44
50 Wed 922 988 776 724 198
50 Thur 842 920 988 904 62
50 Fri 784 942 920 766 18
51 Mon 823 671 942 1,156 333
51 Tue 756 693 671 732 24
51 Wed 699 749 693 647 52
51 Thur 401 438 749 685 284
51 Fri 429 515 438 365 64
52 Mon 1,209 985 515 632 577
52 Tue 830 760 985 1,075 245
52 Wed 852 913 760 710 142
52 Thur 1,082 1,182 913 835 247
52 Fri 841 1,010 1,182 984 143
1 Mon 1,362 1,110 1,010 1,240 122
1 Tue 1,174 1,075 1,110 1,212 38
1 Wed 967 1,036 1,075 1,004 37
1 Thur 930 1,016 1,036 948 18
1 Fri 853 1,025 1,016 846 7
2 Mon 924 753 1,025 1,258 334
2 Tue 954 874 753 822 132
2 Wed 1,346 1,442 874 816 530
2 Thur 904 988 1,442 1,320 416
2 Fri 758 911 988 822 64
3 Mon 886 722 911 1,118 232
3 Tue 878 804 722 788 90
3 Wed 802 859 804 751 51
3 Thur 945 1,033 859 786 159
3 Fri 610 733 1,033 859 249
4 Mon 910 742 733 899 11
4 Tue 754 691 742 809 55
4 Wed 705 755 691 645 60
4 Thur 729 797 755 691 38
4 Fri 772 927 797 663 109
5 Mon 723 589 927 1,138 415
5 Tue 677 620 664 725 48
5 Wed 521 558 664 620 99
5 Thur 571 624 664 608 37
5 Fri 498 598 664 553 55
Seasonally Adjusted Value 920.79757502273412 779.55845430382328 630.92658591010513 904.67514225329217 872.21229889166955 884.1286450439527 954.52398282559795 955.49493146318139 917.78637619899212 959.91408652127268 1061.7692391633827 1026.8919239419342 1074.3962065667836 1216.0669484636646 1207.4013228459062 2161.0222734161866 2587.8409323246779 1972.0472744660503 2022.4078361242075 2178.1279585269931 1588.1721006365565 1380.4871805356777 1059.3996493465095 1081.6768005202407 1302.3114765820521 1026.7300394058805 1038.8005724800653 1007.9828817341408 925.43459600065034 857.79556667858412 Seasonally Adjusted Forecast 920.79757502273412 779.55845430382328 630.92658591010513 904.67514225329217 872.21229889166955 884.1286450439527 954.52398282559795 955.49493146318139 917.78637619899212 959.91408652127268 1061.7692391633827 1026.8919239419342 1074.3962065667836 1216.0669484636646 1207.4013228459062 2161.0222734161866 2587.8409323246779 1972.0472744660503 2022.4078361242075 2178.1279585269931 1588.1721006365565 1380.4871805356777 1059.3996493465095 1081.6768005202407 1302.3114765820521 1026.7300394058805 1038.8005724800653 1007.9828817341408 925.43459600065034

Time Period

Seasonally-Adjusted Value

Averaging with Seasonality

Template for Averaging Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting ActualForecast G6:G75
Week Day Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H75
44 Mon 1,130 921 Daily MAD K23
44 Tue 851 780 921 1,005 154 MSE K26
44 Wed 589 631 850 794 205 Day Seasonal Factor SeasonalFactor K9:K20
44 Thur 828 905 777 711 117 Mon 1.2272 SeasonallyAdjustedForecast F6:F75
44 Fri 726 872 809 673 53 Tue 1.0916 SeasonallyAdjustedValue E6:E75
45 Mon 1,085 884 822 1,008 77 Wed 0.9335 TrueValue D6:D75
45 Tue 1,042 955 832 908 134 Thur 0.9152 TypeOfSeasonality K6
45 Wed 892 955 850 793 99 Fri 0.8324
45 Thur 840 918 863 790 50 1.000
45 Fri 799 960 869 723 76 1.000
46 Mon 1,303 1,062 878 1,077 226 1.000
46 Tue 1,121 1,027 895 977 144 1.000
46 Wed 1,003 1,074 906 846 157 1.000
46 Thur 1,113 1,216 919 841 272 1.000
46 Fri 1,005 1,207 940 782 223 1.000
47 Mon 2,652 2,161 958 1,175 1,477
47 Tue 2,825 2,588 1,033 1,128 1,697 Mean Absolute Deviation
47 Wed 1,841 1,972 1,124 1,050 791 MAD = 304
47 Thur 1,851 2,022 1,172 1,072 779
47 Fri 1,813 2,178 1,216 1,012 801 Mean Square Error
48 Mon 1,949 1,588 1,264 1,552 397 MSE = 177,327
48 Tue 1,507 1,380 1,280 1,397 110
48 Wed 989 1,059 1,284 1,199 210
48 Thur 990 1,082 1,275 1,167 177
48 Fri 1,084 1,302 1,267 1,054 30
49 Mon 1,260 1,027 1,268 1,556 296
49 Tue 1,134 1,039 1,259 1,374 240
49 Wed 941 1,008 1,251 1,167 226
49 Thur 847 925 1,242 1,137 290
49 Fri 714 858 1,231 1,025 311
50 Mon 1,002 816 1,219 1,495 493
50 Tue 847 776 1,206 1,316 469
50 Wed 922 988 1,192 1,113 191
50 Thur 842 920 1,186 1,085 243
50 Fri 784 942 1,178 981 197
51 Mon 823 671 1,171 1,438 615
51 Tue 756 693 1,157 1,264 508
51 Wed 699 749 1,145 1,069 370
51 Thur 401 438 1,134 1,038 637
51 Fri 429 515 1,117 929 500
52 Mon 1,209 985 1,102 1,352 143
52 Tue 830 760 1,099 1,199 369
52 Wed 852 913 1,091 1,018 166
52 Thur 1,082 1,182 1,087 994 88
52 Fri 841 1,010 1,089 906 65
1 Mon 1,362 1,110 1,087 1,334 28
1 Tue 1,174 1,075 1,087 1,187 13
1 Wed 967 1,036 1,087 1,015 48
1 Thur 930 1,016 1,086 994 64
1 Fri 853 1,025 1,085 903 50
2 Mon 924 753 1,084 1,330 406
2 Tue 954 874 1,077 1,176 222
2 Wed 1,346 1,442 1,073 1,002 344
2 Thur 904 988 1,080 989 85
2 Fri 758 911 1,078 898 140
3 Mon 886 722 1,075 1,320 434
3 Tue 878 804 1,069 1,167 289
3 Wed 802 859 1,064 994 192
3 Thur 945 1,033 1,061 971 26
3 Fri 610 733 1,060 883 273
4 Mon 910 742 1,055 1,295 385
4 Tue 754 691 1,050 1,146 392
4 Wed 705 755 1,044 975 270
4 Thur 729 797 1,039 951 222
4 Fri 772 927 1,036 862 90
5 Mon 723 589 1,034 1,269 546
5 Tue 677 620 1,027 1,121 444
5 Wed 521 558 1,021 953 432
5 Thur 571 624 1,014 928 357
5 Fri 498 598 1,009 840 342
Seasonally Adjusted Value 920.79757502273412 779.55845430382328 630.92658591010513 904.67514225329217 872.21229889166955 884.1286450439527 954.52398282559795 955.49493146318139 917.78637619899212 959.91408652127268 1061.7692391633827 1026.8919239419342 1074.3962065667836 1216.0669484636646 1207.4013228459062 2161.0222734161866 2587.8409323246779 1972.0472744660503 2022.4078361242075 2178.1279585269931 1588.1721006365565 1380.4871805356777 1059.3996493465095 1081.6768005202407 1302.3114765820521 1026.7300394058805 1038.8005724800653 1007.9828817341408 925.43459600065034 857.79556667858412 Seasonally Adjusted Forecast 920.79757502273412 850.17801466327865 777.09420507888751 808.98943937248862 821.63401127632483 832.04978357092943 849.54609775016786 862.78970196429452 868.9004435459276 878.00180784346207 894.70793796345492 905.72327012832818 918.69811139282479 939.93874261217047 957.76958129441959 1032.9728745520299 1124.4357014798327 1171.5252333124004 1216.3085281972324 1264.3994997137204 1279.8172426148078 1284.3931488839382 1274.6108228170935 1266.5719052213913 1268.0014880758179 1258.7218169731279 1250.576585695607 1241.9125248398402 1230.9994928109027

Time Period

Seasonally-Adjusted Value

Moving Average with Seasonality

Template for Moving-Average Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Number of previous ActualForecast G6:G75
Week Day Value Value Forecast Forecast Error periods to consider ForecastingError H6:H75
44 Mon 1,130 921 n = 5 MAD K26
44 Tue 851 780 ERROR:#N/A MSE K29
44 Wed 589 631 ERROR:#N/A Type of Seasonality NumberOfPeriods K6
44 Thur 828 905 ERROR:#N/A Daily SeasonalFactor K12:K23
44 Fri 726 872 ERROR:#N/A SeasonallyAdjustedForecast F6:F75
45 Mon 1,085 884 822 1,008 77 Day Seasonal Factor SeasonallyAdjustedValue E6:E75
45 Tue 1,042 955 814 889 153 Mon 1.2272 TrueValue D6:D75
45 Wed 892 955 849 793 99 Tue 1.0916 TypeOfSeasonality K9
45 Thur 840 918 914 837 3 Wed 0.9335
45 Fri 799 960 917 763 36 Thur 0.9152
46 Mon 1,303 1,062 934 1,147 156 Fri 0.8324
46 Tue 1,121 1,027 970 1,059 62 1.000
46 Wed 1,003 1,074 984 919 84 1.000
46 Thur 1,113 1,216 1,008 923 190 1.000
46 Fri 1,005 1,207 1,068 889 116 1.000
47 Mon 2,652 2,161 1,117 1,371 1,281 1.000
47 Tue 2,825 2,588 1,337 1,460 1,365 1.000
47 Wed 1,841 1,972 1,649 1,540 301 1.000
47 Thur 1,851 2,022 1,829 1,674 177
47 Fri 1,813 2,178 1,990 1,657 156 Mean Absolute Deviation
48 Mon 1,949 1,588 2,184 2,681 732 MAD = 221
48 Tue 1,507 1,380 2,070 2,259 752
48 Wed 989 1,059 1,828 1,707 718 Mean Square Error
48 Thur 990 1,082 1,646 1,506 516 MSE = 114,169
48 Fri 1,084 1,302 1,458 1,213 129
49 Mon 1,260 1,027 1,282 1,574 314
49 Tue 1,134 1,039 1,170 1,277 143
49 Wed 941 1,008 1,102 1,029 88
49 Thur 847 925 1,092 999 152
49 Fri 714 858 1,060 883 169
50 Mon 1,002 816 971 1,192 190
50 Tue 847 776 929 1,014 167
50 Wed 922 988 877 818 104
50 Thur 842 920 873 799 43
50 Fri 784 942 872 725 59
51 Mon 823 671 888 1,090 267
51 Tue 756 693 859 938 182
51 Wed 699 749 843 787 88
51 Thur 401 438 795 727 326
51 Fri 429 515 698 581 152
52 Mon 1,209 985 613 752 457
52 Tue 830 760 676 738 92
52 Wed 852 913 690 644 208
52 Thur 1,082 1,182 722 661 421
52 Fri 841 1,010 871 725 116
1 Mon 1,362 1,110 970 1,191 171
1 Tue 1,174 1,075 995 1,086 88
1 Wed 967 1,036 1,058 988 21
1 Thur 930 1,016 1,083 991 61
1 Fri 853 1,025 1,050 874 21
2 Mon 924 753 1,052 1,292 368
2 Tue 954 874 981 1,071 117
2 Wed 1,346 1,442 941 878 468
2 Thur 904 988 1,022 935 31
2 Fri 758 911 1,016 846 88
3 Mon 886 722 993 1,219 333
3 Tue 878 804 987 1,078 200
3 Wed 802 859 973 909 107
3 Thur 945 1,033 857 784 161
3 Fri 610 733 866 721 111
4 Mon 910 742 830 1,019 109
4 Tue 754 691 834 910 156
4 Wed 705 755 811 757 52
4 Thur 729 797 791 724 5
4 Fri 772 927 743 619 153
5 Mon 723 589 782 960 237
5 Tue 677 620 752 821 144
5 Wed 521 558 738 689 168
5 Thur 571 624 698 639 68
5 Fri 498 598 664 552 54
Seasonally Adjusted Value 920.79757502273412 779.55845430382328 630.92658591010513 904.67514225329217 872.21229889166955 884.1286450439527 954.52398282559795 955.49493146318139 917.78637619899212 959.91408652127268 1061.7692391633827 1026.8919239419342 1074.3962065667836 1216.0669484636646 1207.4013228459062 2161.0222734161866 2587.8409323246779 1972.0472744660503 2022.4078361242075 2178.1279585269931 1588.1721006365565 1380.4871805356777 1059.3996493465095 1081.6768005202407 1302.3114765820521 1026.7300394058805 1038.8005724800653 1007.9828817341408 925.43459600065034 857.79556667858412 Seasonally Adjusted Forecast #N/A #N/A #N/A #N/A 821.63401127632483 814.3002252805685 849.2933309849235 914.20700009553877 916.82924688467881 934.36960441059932 969.89772323448528 984.37131145775277 1008.1515664784731 1067.8076809314075 1117.3051281963342 1337.155735046895 1649.3455367234437 1828.8757503032971 1990.1439278354057 2184.289254971623 2069.7192204156972 1828.2484700578971 1645.7189450339888 1457.5727379131954 1282.4094415242071 1170.121029278072 1101.7837076669496 1091.500354144476 1060.2519132405578

Time Period

Seasonally-Adjusted Value

Expon Smoothing with Season

Template for Exponential Smoothing Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Smoothing Constant ActualForecast G6:G75
Week Day Value Value Forecast Forecast Error a = 0.7 Alpha K5
44 Mon 1,130 921 900 1,104 26 ForecastingError H6:H75
44 Tue 851 780 915 998 147 Initial Estimate InitialEstimate K8
44 Wed 589 631 820 766 177 Average = 900 MAD K28
44 Thur 828 905 688 629 199 MSE K31
44 Fri 726 872 840 699 27 Type of Seasonality SeasonalFactor K14:K25
45 Mon 1,085 884 862 1,058 27 Daily SeasonallyAdjustedForecast F6:F75
45 Tue 1,042 955 878 958 84 SeasonallyAdjustedValue E6:E75
45 Wed 892 955 931 870 22 Day Seasonal Factor TrueValue D6:D75
45 Thur 840 918 948 868 28 Mon 1.2272 TypeOfSeasonality K11
45 Fri 799 960 927 772 27 Tue 1.0916
46 Mon 1,303 1,062 950 1,166 137 Wed 0.9335
46 Tue 1,121 1,027 1,028 1,122 1 Thur 0.9152
46 Wed 1,003 1,074 1,027 959 44 Fri 0.8324
46 Thur 1,113 1,216 1,060 970 143 1.000
46 Fri 1,005 1,207 1,169 973 32 1.000
47 Mon 2,652 2,161 1,196 1,468 1,184 1.000
47 Tue 2,825 2,588 1,872 2,043 782 1.000
47 Wed 1,841 1,972 2,373 2,215 374 1.000
47 Thur 1,851 2,022 2,092 1,915 64 1.000
47 Fri 1,813 2,178 2,043 1,701 112 1.000
48 Mon 1,949 1,588 2,138 2,623 674
48 Tue 1,507 1,380 1,753 1,914 407 Mean Absolute Deviation
48 Wed 989 1,059 1,492 1,393 404 MAD = 161
48 Thur 990 1,082 1,189 1,088 98
48 Fri 1,084 1,302 1,114 927 157 Mean Square Error
49 Mon 1,260 1,027 1,246 1,529 269 MSE = 67,478
49 Tue 1,134 1,039 1,092 1,193 59
49 Wed 941 1,008 1,055 985 44
49 Thur 847 925 1,022 935 88
49 Fri 714 858 954 794 80
50 Mon 1,002 816 887 1,088 86
50 Tue 847 776 838 914 67
50 Wed 922 988 794 742 180
50 Thur 842 920 930 851 9
50 Fri 784 942 923 768 16
51 Mon 823 671 936 1,149 326
51 Tue 756 693 750 819 63
51 Wed 699 749 710 663 36
51 Thur 401 438 737 675 274
51 Fri 429 515 528 439 10
52 Mon 1,209 985 519 637 572
52 Tue 830 760 845 923 93
52 Wed 852 913 786 734 118
52 Thur 1,082 1,182 875 800 282
52 Fri 841 1,010 1,090 907 66
1 Mon 1,362 1,110 1,034 1,269 93
1 Tue 1,174 1,075 1,087 1,187 13
1 Wed 967 1,036 1,079 1,007 40
1 Thur 930 1,016 1,049 960 30
1 Fri 853 1,025 1,026 854 1
2 Mon 924 753 1,025 1,258 334
2 Tue 954 874 835 911 43
2 Wed 1,346 1,442 862 805 541
2 Thur 904 988 1,268 1,160 256
2 Fri 758 911 1,072 892 134
3 Mon 886 722 959 1,177 291
3 Tue 878 804 793 866 12
3 Wed 802 859 801 748 54
3 Thur 945 1,033 842 770 175
3 Fri 610 733 975 812 202
4 Mon 910 742 806 989 79
4 Tue 754 691 761 830 76
4 Wed 705 755 712 664 41
4 Thur 729 797 742 679 50
4 Fri 772 927 780 649 123
5 Mon 723 589 883 1,084 361
5 Tue 677 620 677 739 62
5 Wed 521 558 637 595 74
5 Thur 571 624 582 533 38
5 Fri 498 598 611 509 11
Seasonally Adjusted Value 920.79757502273412 779.55845430382328 630.92658591010513 904.67514225329217 872.21229889166955 884.1286450439527 954.52398282559795 955.49493146318139 917.78637619899212 959.91408652127268 1061.7692391633827 1026.8919239419342 1074.3962065667836 1216.0669484636646 1207.4013228459062 2161.0222734161866 2587.8409323246779 1972.0472744660503 2022.4078361242075 2178.1279585269931 1588.1721006365565 1380.4871805356777 1059.3996493465095 1081.6768005202407 1302.3114765820521 1026.7300394058805 1038.8005724800653 1007.9828817341408 925.43459600065034 857.79556667858412 Seasonally Adjusted Forecast 900 914.55830251591397 820.05840876745037 687.66613276730868 839.57243940749709 862.42034104641789 877.61615384469223 931.45163413132627 948.28194226362484 926.93504601838185 950.02037437040553 1028.2445797254895 1027.2977206770008 1060.2666607998488 1169.3268621645198 1195.9789846414901 1871.5092867837775 2372.9414386624076 2092.3155237249575 2043.3801424044325 2137.7036136902252 1753.0315545526571 1492.2504927407715 1189.254902364788 1113.9502310736048 1245.803102929518 1092.4519584629718 1054.8959882749373 1022.0568136963798 954.42126130936924

Time Period

Seasonally-Adjusted Value

Expon Smoothing with Season (2

Template for Exponential Smoothing Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Smoothing Constant ActualForecast G6:G75
Week Day Value Value Forecast Forecast Error a = 0.1 Alpha K5
44 Mon 1,130 921 900 1,104 26 ForecastingError H6:H75
44 Tue 851 780 902 985 134 Initial Estimate InitialEstimate K8
44 Wed 589 631 890 831 242 Average = 900 MAD K28
44 Thur 828 905 864 791 37 MSE K31
44 Fri 726 872 868 723 3 Type of Seasonality SeasonalFactor K14:K25
45 Mon 1,085 884 868 1,066 19 Daily SeasonallyAdjustedForecast F6:F75
45 Tue 1,042 955 870 950 92 SeasonallyAdjustedValue E6:E75
45 Wed 892 955 878 820 72 Day Seasonal Factor TrueValue D6:D75
45 Thur 840 918 886 811 29 Mon 1.2272 TypeOfSeasonality K11
45 Fri 799 960 889 740 59 Tue 1.0916
46 Mon 1,303 1,062 896 1,100 203 Wed 0.9335
46 Tue 1,121 1,027 913 997 124 Thur 0.9152
46 Wed 1,003 1,074 924 863 140 Fri 0.8324
46 Thur 1,113 1,216 939 860 253 1.000
46 Fri 1,005 1,207 967 805 200 1.000
47 Mon 2,652 2,161 991 1,216 1,436 1.000
47 Tue 2,825 2,588 1,108 1,210 1,615 1.000
47 Wed 1,841 1,972 1,256 1,173 668 1.000
47 Thur 1,851 2,022 1,328 1,215 636 1.000
47 Fri 1,813 2,178 1,397 1,163 650 1.000
48 Mon 1,949 1,588 1,475 1,810 139
48 Tue 1,507 1,380 1,486 1,623 116 Mean Absolute Deviation
48 Wed 989 1,059 1,476 1,378 389 MAD = 251
48 Thur 990 1,082 1,434 1,313 323
48 Fri 1,084 1,302 1,399 1,164 80 Mean Square Error
49 Mon 1,260 1,027 1,389 1,705 445 MSE = 136,472
49 Tue 1,134 1,039 1,353 1,477 343
49 Wed 941 1,008 1,322 1,234 293
49 Thur 847 925 1,290 1,181 334
49 Fri 714 858 1,254 1,044 330
50 Mon 1,002 816 1,214 1,490 488
50 Tue 847 776 1,174 1,282 435
50 Wed 922 988 1,135 1,059 137
50 Thur 842 920 1,120 1,025 183
50 Fri 784 942 1,100 916 132
51 Mon 823 671 1,084 1,330 507
51 Tue 756 693 1,043 1,138 382
51 Wed 699 749 1,008 941 242
51 Thur 401 438 982 899 498
51 Fri 429 515 927 772 343
52 Mon 1,209 985 886 1,088 121
52 Tue 830 760 896 978 148
52 Wed 852 913 883 824 28
52 Thur 1,082 1,182 886 811 271
52 Fri 841 1,010 915 762 79
1 Mon 1,362 1,110 925 1,135 227
1 Tue 1,174 1,075 943 1,030 144
1 Wed 967 1,036 956 893 74
1 Thur 930 1,016 964 883 47
1 Fri 853 1,025 970 807 46
2 Mon 924 753 975 1,197 273
2 Tue 954 874 953 1,040 86
2 Wed 1,346 1,442 945 882 464
2 Thur 904 988 995 910 6
2 Fri 758 911 994 827 69
3 Mon 886 722 986 1,210 324
3 Tue 878 804 959 1,047 169
3 Wed 802 859 944 881 79
3 Thur 945 1,033 935 856 89
3 Fri 610 733 945 787 177
4 Mon 910 742 924 1,134 224
4 Tue 754 691 906 989 235
4 Wed 705 755 884 825 120
4 Thur 729 797 871 797 68
4 Fri 772 927 864 719 53
5 Mon 723 589 870 1,068 345
5 Tue 677 620 842 919 242
5 Wed 521 558 820 765 244
5 Thur 571 624 794 726 155
5 Fri 498 598 777 646 148
Seasonally Adjusted Value 920.79757502273412 779.55845430382328 630.92658591010513 904.67514225329217 872.21229889166955 884.1286450439527 954.52398282559795 955.49493146318139 917.78637619899212 959.91408652127268 1061.7692391633827 1026.8919239419342 1074.3962065667836 1216.0669484636646 1207.4013228459062 2161.0222734161866 2587.8409323246779 1972.0472744660503 2022.4078361242075 2178.1279585269931 1588.1721006365565 1380.4871805356777 1059.3996493465095 1081.6768005202407 1302.3114765820521 1026.7300394058805 1038.8005724800653 1007.9828817341408 925.43459600065034 857.79556667858412 Seasonally Adjusted Forecast 900 902.07975750227342 889.82762718242839 863.93752305519604 868.01128497500565 868.43138636667197 870.00111223440013 878.45339929351996 886.15755251048608 889.32043487933674 896.37980004353028 912.91874395551554 924.31606195415748 939.32407641542011 966.99836362024462 991.03865954281082 1108.0370209301484 1256.0174120696013 1327.6203983092464 1397.0991420907426 1475.2020237343677 1486.4990314245867 1475.8978463356957 1434.2480266367772 1398.9909040251237 1389.3229612808166 1353.0636690933229 1321.6373594319973 1290.2719116622116 1253.7881800960554

Time Period

Seasonally-Adjusted Value