Daily Variance Calculator Updated (3).xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1
2		Ops-Pack Monetary Budget			Providence NE
3
4				Enter hours team member worked
5				Week 1							Week 2
6		Employee Name	Pay Rate	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Totals
7	1	Larry Palmer	11	0	8	8	8	8	8	0	0	8	8	8	8	8	0	80	Hours
8				0	88	88	88	88	88	0	0	88	88	88	88	88	0	880	Pay
9	2	Roeshell Conerson	15	0	8	8	8	0	8	8	8	0	8	8	8	8	0	80	Hours
10				0	120	120	120	0	120	120	120	0	120	120	120	120	0	1200	Pay
11	3	Kevin Enwright	10.75	0	0	8	0	0	0	8	8	0	0	0	0	8	0	32	Hours
12				0	0	86	0	0	0	86	86	0	0	0	0	86	0	344	Pay
13	4	Willie Gibbs	12.12	0	8	8	8	8	8	0	0	8	8	8	8	8	0	80	Hours
14				0	96.96	96.96	96.96	96.96	96.96	0	0	96.96	96.96	96.96	96.96	96.96	0	969.6	Pay
15	5	Jackie Gilmore	12.27	0	4	4	4	4	4	0	0	4	4	4	4	4	0	40	Hours
16				0	49.08	49.08	49.08	49.08	49.08	0	0	49.08	49.08	49.08	49.08	49.08	0	490.8	Pay
17	6	Earl Hayes	12.83	8	0	0	0	8	0	0	0	8	0	0	0	0	8	32	Hours
18				102.64	0	0	0	102.64	0	0	0	102.64	0	0	0	0	102.64	410.56	Pay
19	7	Debra Jolly	13.5	0	8	8	8	8	0	8	8	8	0	8	8	8	0	80	Hours
20				0	108	108	108	108	0	108	108	108	0	108	108	108	0	1080	Pay
21	8	Flora Jordan	13.05	8	8	0	0	8	0	8	8	8	0	0	8	0	8	64	Hours
22				104.4	104.4	0	0	104.4	0	104.4	104.4	104.4	0	0	104.4	0	104.4	835.2	Pay
23	9	Bernell Outen	14.25	0	8	8	8	8	8	0	0	8	8	8	8	8	0	80	Hours
24				0	114	114	114	114	114	0	0	114	114	114	114	114	0	1140	Pay
25	10	Linda Raysor	13.11	8	0	0	0	0	8	0	0	0	8	0	0	0	8	32	Hours
26				104.88	0	0	0	0	104.88	0	0	0	104.88	0	0	0	104.88	419.52	Pay
27	11	Yulonda Riddle	12.81	0	8	8	8	0	8	8	8	0	8	8	8	8	0	80	Hours
28				0	102.48	102.48	102.48	0	102.48	102.48	102.48	0	102.48	102.48	102.48	102.48	0	1024.8	Pay
29	12	Tamara Robinson	9.94	8	8	0	8	8	8	0	0	8	8	8	8	0	8	80	Hours
30				79.52	79.52	0	79.52	79.52	79.52	0	0	79.52	79.52	79.52	79.52	0	79.52	795.2	Pay
31	13	Martha Sims	12.22	8	0	8	8	8	8	0	0	8	8	8	0	8	8	80	Hours
32				97.76	0	97.76	97.76	97.76	97.76	0	0	97.76	97.76	97.76	0	97.76	97.76	977.6	Pay
33	14	Gloria Stroud	11.65	0	4	4	4	4	4	0	0	4	4	4	4	4	0	40	Hours
34				0	46.6	46.6	46.6	46.6	46.6	0	0	46.6	46.6	46.6	46.6	46.6	0	466	Pay
35	15	Andrew Williams	12.17	0	8	8	8	8	8	0	0	8	8	8	8	8	0	80	Hours
36				0	97.36	97.36	97.36	97.36	97.36	0	0	97.36	97.36	97.36	97.36	97.36	0	973.6	Pay
37	16																		Hours
38																			Pay
39	17																		Hours
40																			Pay
41	18																		Hours
42																			Pay
43	19																		Hours
44																			Pay
45	20																		Hours
46																			Pay
47		Daily Totals		40	80	80	80	80	80	40	40	80	80	80	80	80	40	960	Hours
48		Daily Totals		489.2	1006.4	1006.24	999.76	984.32	996.64	520.88	520.88	984.32	996.64	999.76	1006.4	1006.24	489.2	12006.88	Pay
49
50
51				Original Ops-pack Budget:		12,086.88
52						Not including wage adjustments since
53
54
55			AWR =	12.44466667
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