Feb_EOM_FoodCost Monthly Variance_Q1.xlsx

	A	B	C	D	E	F	G	I	J	K
1				Food Cost Monthly Variance Report
2
3	Store: Appleton 10268	Description	Expected Usage	Actual Usage	Variance	Cases	$ Difference
4		Nuggets	108450	114606	-6156	-7.125	($509.72)	Item	Case Cost	Qty
5		Bacon	3141	4554	-1413	-2.2078125	($552.02)	Fries	$32.00	6
6		Ice Cream	98	132	-34	-17	($624.07)	Nuggets	$81.00	864
7		10:01	31200	33881	-2681	-6.981770833	($961.46)	Regular Meat 10:1	$162.00	384
8		Fresh Beef	5917	6236	-319	-5.316666667	($321.29)	4:1 Beef Patty	$72.00	60
9		Mc Chicken			0	0	$0.00	Fish Filet	$80.00	198
10		Cookies	12936	15870	-2934	-6.791666667	($607.99)	Chicken/Mcckn	$75.00	232
11		Fries			0	0	$0.00	McCrispy filet	$128.00	128
12		Fish Filet			0	0	$0.00	Bacon strip	$250.00	640
13		McCrispy filet			0	0	$0.00	Beef steak Pattie	$166.00	128
14		Beef steak Pattie	1945	2178	-233	-1.8203125	($302.17)	Cookies	$95.00	432
15		Breaded Chicken	3034	3719	-685	-2.378472222	($266.39)	Breaded Chicken	$112.00	288
16		Sausage Patty			0	0	$0.00	Sausage Patty	$86.00	324
17		Cheese			0	0	$0.00	Ice Cream Mix	$35.00	2
18		Bun/reg bb 3.1				0	$0.00	Cheese	$95.00	1408
19		Global Quarter Bun			0	0	$0.00	Bun/reg bb 3.1	$10.00	60
20		Bb Big Mac buns			0	0	$0.00	Global Quarter Bun	$11.00	60
21	Total						($3,576.55)	Bb Big Mac buns	$6.00	30
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