5_WFM_Forecast_Model.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	WFM Clubs — WFM Forecast Model: Historical Weekly Volume
2	Enter 13 weeks of actual call volume (last 13 weeks). Formulas auto-calculate indices and WMA forecast.
3	Week #	Week Starting	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Weekly Total	vs Prior Week
4	1	07-Oct-24	1,831	1,564	1,603	1,744	1,735	781	478	9,736	—
5	2	14-Oct-24	1,803	1,676	1,646	1,770	1,829	835	471	10,030	3.0%
6	3	21-Oct-24	1,897	1,668	1,670	1,721	1,781	809	499	10,045	0.1%
7	4	28-Oct-24	1,922	1,723	1,702	1,823	1,830	889	563	10,452	4.1%
8	5	04-Nov-24	1,983	1,747	1,785	1,814	1,897	889	525	10,640	1.8%
9	6	11-Nov-24	1,930	1,807	1,785	1,909	1,929	873	535	10,768	1.2%
10	7	18-Nov-24	1,985	1,769	1,895	1,897	1,923	857	558	10,884	1.1%
11	8	25-Nov-24	2,014	1,819	1,875	1,965	1,978	867	613	11,131	2.3%
12	9	02-Dec-24	2,096	1,873	1,878	1,969	1,989	947	567	11,319	1.7%
13	10	09-Dec-24	2,154	1,917	1,943	2,029	2,039	984	548	11,614	2.6%
14	11	16-Dec-24	2,115	1,954	1,959	2,088	2,087	920	579	11,702	0.8%
15	12	23-Dec-24	2,158	1,950	1,998	2,082	2,166	972	580	11,906	1.7%
16	13	30-Dec-24	2,229	1,979	2,022	2,143	2,154	1,031	657	12,215	2.6%
17	AVERAGE		2,009	1,804	1,828	1,920	1,949	896	552	10,957	1.9%
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100