A donut shop in Boston was having trouble getting the correct staffing levels. It appears that they have staff with a lot of ideal time on few days and on the other days customers must wait a long time to get their donuts. Leo, the manager, felt a quantitative analysis of customer arrival patterns could lead to a better staffing solution. The first step is a reliable forecast for each day's number of arrivals. Leo needs your help in arriving at forecasting and placing the past data for a year following the details below on an excel sheet. It also has the following information: the day of the week, whether the day was a staff or faculty payday, and whether the day was before or after a holiday. Please use this data to develop a forecasting model for Leo. Make recommendations about staffing based on the analysis of your model. (Reminder that this is not asking to forecast the demand for next year).

PS: Please solve in excel

Month	Day of month	Day of week	Staff payday	Faculty payday	After or before holiday	Arrivals
Jan	2	Tue	Yes	Yes	Yes	1825
Jan	3	Wed	No	No	No	1257
Jan	4	Thu	No	No	No	969
Jan	5	Fri	Yes	No	No	1672
Jan	8	Mon	No	No	No	1098
Jan	9	Tue	No	No	No	691
Jan	10	Wed	No	No	No	672
Jan	11	Thu	No	No	No	754
Jan	12	Fri	No	No	No	972
Jan	15	Mon	No	No	No	816
Jan	16	Tue	No	No	No	717
Jan	17	Wed	No	No	No	728
Jan	18	Thu	No	No	No	711
Jan	19	Fri	Yes	No	No	1545
Jan	22	Mon	No	No	No	873
Jan	23	Tue	No	No	No	713
Jan	24	Wed	No	No	No	626
Jan	25	Thu	No	No	No	653
Jan	26	Fri	No	No	No	1080
Jan	29	Mon	No	No	No	650
Jan	30	Tue	No	No	No	644
Jan	31	Wed	No	No	No	803
Feb	1	Thu	No	Yes	No	1282
Feb	2	Fri	Yes	No	No	2043
Feb	5	Mon	No	No	No	1146
Feb	6	Tue	No	No	No	740
Feb	7	Wed	No	No	No	698
Feb	8	Thu	No	No	No	695
Feb	9	Fri	No	No	No	1159
Feb	12	Mon	No	No	No	881
Feb	13	Tue	No	No	No	768
Feb	14	Wed	No	No	No	654
Feb	15	Thu	No	No	No	858
Feb	16	Fri	Yes	No	No	1647
Feb	19	Mon	No	No	No	773
Feb	20	Tue	No	No	No	755
Feb	21	Wed	No	No	No	788
Feb	22	Thu	No	No	No	702
Feb	23	Fri	No	No	No	1037
Feb	26	Mon	No	No	No	931
Feb	27	Tue	No	No	No	719
Feb	28	Wed	No	No	No	811
Mar	1	Thu	No	Yes	No	1383
Mar	2	Fri	Yes	No	No	2022
Mar	5	Mon	No	No	No	1130
Mar	6	Tue	No	No	No	798
Mar	7	Wed	No	No	No	885
Mar	8	Thu	No	No	No	983
Mar	9	Fri	No	No	No	1439
Mar	12	Mon	No	No	No	973
Mar	13	Tue	No	No	No	725
Mar	14	Wed	No	No	No	681
Mar	15	Thu	No	No	No	840
Mar	16	Fri	Yes	No	No	1491
Mar	19	Mon	No	No	No	1050
Mar	20	Tue	No	No	No	779
Mar	21	Wed	No	No	No	686
Mar	22	Thu	No	No	No	663
Mar	23	Fri	No	No	No	1059
Mar	26	Mon	No	No	No	1005
Mar	27	Tue	No	No	No	704
Mar	28	Wed	No	No	No	732
Mar	29	Thu	No	No	No	738
Mar	30	Fri	Yes	Yes	No	1867
Apr	2	Mon	No	No	No	1486
Apr	3	Tue	No	No	No	1155
Apr	4	Wed	No	No	No	871
Apr	5	Thu	No	No	No	832
Apr	6	Fri	No	No	No	1101
Apr	9	Mon	No	No	No	929
Apr	10	Tue	No	No	No	672
Apr	11	Wed	No	No	No	751
Apr	12	Thu	Yes	No	No	1114
Apr	13	Fri	No	No	No	1612
Apr	16	Mon	No	No	No	1267
Apr	17	Tue	No	No	No	825
Apr	18	Wed	No	No	No	729
Apr	19	Thu	No	No	No	836
Apr	20	Fri	No	No	No	1123
Apr	23	Mon	No	No	No	900
Apr	24	Tue	No	No	No	702
Apr	25	Wed	No	No	No	724
Apr	26	Thu	No	No	No	824
Apr	27	Fri	Yes	No	No	1682
Apr	30	Mon	No	No	No	1146
May	1	Tue	No	Yes	No	1488
May	2	Wed	No	No	No	1121
May	3	Thu	No	No	No	1147
May	4	Fri	No	No	No	1455
May	7	Mon	No	No	No	1330
May	8	Tue	No	No	No	819
May	9	Wed	No	No	No	743
May	10	Thu	No	No	No	921
May	11	Fri	Yes	Yes	No	1731
May	14	Mon	No	No	No	1118
May	15	Tue	No	No	No	1064
May	16	Wed	No	No	No	869
May	17	Thu	No	No	No	844
May	18	Fri	No	No	No	1251
May	21	Mon	No	No	No	1187
May	22	Tue	No	No	No	785
May	23	Wed	No	No	No	705
May	24	Thu	No	No	No	890
May	25	Fri	No	No	Yes	1754
May	29	Tue	No	No	Yes	1310
May	30	Wed	No	No	No	937
May	31	Thu	No	No	No	956
Jun	1	Fri	No	No	No	2068
Jun	4	Mon	No	No	No	1383
Jun	5	Tue	No	No	No	842
Jun	6	Wed	No	No	No	923
Jun	7	Thu	No	No	No	959
Jun	8	Fri	Yes	No	No	1820
Jun	11	Mon	No	No	No	1164
Jun	12	Tue	No	No	No	928
Jun	14	Thu	No	No	No	919
Jun	15	Fri	No	No	No	1460
Jun	18	Mon	No	No	No	1081
Jun	19	Tue	No	No	No	993
Jun	20	Wed	No	No	No	862
Jun	21	Thu	No	No	No	900
Jun	22	Fri	Yes	No	No	1769
Jun	25	Mon	No	No	No	1059
Jun	26	Tue	No	No	No	924
Jun	27	Wed	No	No	No	859
Jun	28	Thu	No	No	No	805
Jun	29	Fri	No	No	No	1606
Jul	2	Mon	No	No	No	1648
Jul	3	Tue	No	No	Yes	1372
Jul	5	Thu	No	No	Yes	1283
Jul	6	Fri	Yes	No	No	1740
Jul	9	Mon	No	No	No	1195
Jul	10	Tue	No	No	No	880
Jul	11	Wed	No	No	No	855
Jul	12	Thu	No	No	No	955
Jul	13	Fri	No	No	No	1466
Jul	16	Mon	No	No	No	1290
Jul	17	Tue	No	No	No	968
Jul	18	Wed	No	No	No	831
Jul	19	Thu	No	No	No	838
Jul	20	Fri	Yes	No	No	1747
Jul	23	Mon	No	No	No	1182
Jul	24	Tue	No	No	No	842
Jul	25	Wed	No	No	No	818
Jul	26	Thu	No	No	No	822
Jul	27	Fri	No	No	No	1278
Jul	30	Mon	No	No	No	1184
Jul	31	Tue	No	No	No	989
Aug	1	Wed	No	No	No	1506
Aug	2	Thu	No	No	No	1155
Aug	3	Fri	Yes	No	No	1889
Aug	6	Mon	No	No	No	1235
Aug	7	Tue	No	No	No	957
Aug	8	Wed	No	No	No	891
Aug	9	Thu	No	No	No	1067
Aug	10	Fri	No	No	No	1475
Aug	13	Mon	No	No	No	1051
Aug	14	Tue	No	No	No	742
Aug	15	Wed	No	No	No	903
Aug	16	Thu	No	No	No	793
Aug	17	Fri	Yes	No	No	1515
Aug	20	Mon	No	No	No	1127
Aug	21	Tue	No	No	No	860
Aug	22	Wed	No	No	No	778
Aug	23	Thu	No	No	No	784
Aug	24	Fri	No	No	No	1060
Aug	27	Mon	No	No	No	930
Aug	28	Tue	No	No	No	738
Aug	29	Wed	No	No	No	660
Aug	30	Thu	No	No	No	800
Aug	31	Fri	Yes	Yes	Yes	1897
Sep	4	Tue	No	No	Yes	1491
Sep	5	Wed	No	No	No	859
Sep	6	Thu	No	No	No	810
Sep	7	Fri	No	No	No	1173
Sep	10	Mon	No	No	No	929
Sep	11	Tue	No	No	No	701
Sep	12	Wed	No	No	No	647
Sep	13	Thu	No	No	No	851
Sep	14	Fri	Yes	No	No	1559
Sep	17	Mon	No	No	No	1090
Sep	18	Tue	No	No	No	404
Sep	19	Wed	No	No	No	586
Sep	20	Thu	No	No	No	683
Sep	21	Fri	No	No	No	1124
Sep	24	Mon	No	No	No	953
Sep	25	Tue	No	No	No	697
Sep	26	Wed	No	No	No	727
Sep	27	Thu	No	No	No	678
Sep	28	Fri	Yes	No	No	1761
Oct	1	Mon	No	Yes	No	1615
Oct	2	Tue	No	No	No	1019
Oct	3	Wed	No	No	No	854
Oct	4	Thu	No	No	No	897
Oct	5	Fri	No	No	No	1307
Oct	8	Mon	No	No	No	796
Oct	9	Tue	No	No	No	648
Oct	10	Wed	No	No	No	735
Oct	11	Thu	No	No	No	843
Oct	12	Fri	Yes	No	No	1759
Oct	15	Mon	No	No	No	1151
Oct	16	Tue	No	No	No	752
Oct	17	Wed	No	No	No	693
Oct	18	Thu	No	No	No	649
Oct	19	Fri	No	No	No	1158
Oct	22	Mon	No	No	No	931
Oct	23	Tue	No	No	No	761
Oct	24	Wed	No	No	No	670
Oct	25	Thu	No	No	No	820
Oct	26	Fri	Yes	No	No	1543
Oct	29	Mon	No	No	No	974
Oct	30	Tue	No	No	No	685
Oct	31	Wed	No	No	No	848
Nov	1	Thu	No	Yes	No	1406
Nov	2	Fri	No	No	No	1578
Nov	5	Mon	No	No	No	1004
Nov	6	Tue	No	No	No	742
Nov	7	Wed	No	No	No	685
Nov	8	Thu	No	No	No	800
Nov	9	Fri	Yes	No	No	1454
Nov	12	Mon	No	No	No	890
Nov	13	Tue	No	No	No	693
Nov	14	Wed	No	No	No	693
Nov	15	Thu	No	No	No	914
Nov	16	Fri	No	No	No	1271
Nov	19	Mon	No	No	No	1031
Nov	20	Tue	No	No	No	949
Nov	21	Wed	No	No	Yes	1356
Nov	23	Fri	No	No	Yes	1085
Nov	26	Mon	No	No	No	1063
Nov	27	Tue	No	No	No	797
Nov	28	Wed	No	No	No	632
Nov	29	Thu	No	No	No	698
Nov	30	Fri	No	Yes	No	1691
Dec	3	Mon	No	No	No	1504
Dec	4	Tue	No	No	No	828
Dec	5	Wed	No	No	No	863
Dec	6	Thu	No	No	No	957
Dec	7	Fri	Yes	No	No	1585
Dec	10	Mon	No	No	No	1126
Dec	11	Tue	No	No	No	896
Dec	12	Wed	No	No	No	870
Dec	13	Thu	No	No	No	873
Dec	14	Fri	No	No	No	1471
Dec	17	Mon	No	No	No	1299
Dec	18	Tue	No	No	No	1058
Dec	19	Wed	No	No	No	1104
Dec	20	Thu	No	No	No	1018
Dec	21	Fri	Yes	No	No	1955
Dec	24	Mon	No	No	Yes	941
Dec	26	Wed	No	No	Yes	999
Dec	27	Thu	No	No	No	619
Dec	28	Fri	No	No	No	937
Dec	31	Mon	No	No	No	1146