Calculation of Small Meal Program Benefit from Central Kitchen Model.xlsx

	B	C	D	F	G	H	I	J	K	L
1
2	Calculation of Small Meal Program Benefit from Central Kitchen model
3	REVENUE
4	Lunch	Rate	# of meals	Revenue
5	Free	$ 4.71	150	$ 706.50
6	Reduced	$ 4.31	10	$ 43.10
7	Paid	$ 0.55	25	$ 13.75
8	Total Revenue for meals served			$ 763.35		total
9	Breakfast	Rate	# of meals	Revenue
10	Free	$ 2.94	75	$ 220.50
11	Reduced	$ 2.64	5	$ 13.20
12	Paid	$ 0.40	0	$ -
13	Total Revenue for meals served			$ 233.70		total
14
15	DAILY TOTAL REVENUE			$ 997.05
16
17	EXPENSES				Single Small kitchen with on-site preparation			Single Small kitchen with items received from Central Kitchen
18	Food	40% of total reimbursement				$305.34	Lunch		$305.34	Lunch
19						$93.48	Breakfast		$93.48	Breakfast
20						$398.82			$398.82	Total
21
22	Other	20% of total reimbursement				$152.67	Lunch		$152.67	Lunch
23		(utilities, paper, etc.)				$46.74	Breakfast		$46.74	Breakfast
24						$199.41	Total		$199.41	Total
25
26	Labor	Estimated hours needed per day			22	hours		12	hours
27		$20/hr	Manager		8	$160.00		8	$ 160.00
28		$15/hr	Breakfast and Lunch employee		7	$105.00		0	$ -
29		$15/hr	Prepare Lunch & clean up employee		7	$105.00		4	$ 60.00
30		Total labor costs (no benefits)				$370.00			$ 220.00
31
32	ASSESSMENT				Single Small kitchen with on-site preparation			Single Small kitchen with items received from Central Kitchen
33	Total Revenue received Lunch & Breakfast					$997.05			$997.05
34	Total Food Costs					$398.82			$398.82
35	Total Other Costs					$199.41			$199.41
36	Total Labor Costs					$370.00			$220.00
37	Revenue in excess of expenses daily					$28.82			$178.82
38	Meal Service days					X 180			X 180
39	Revenue in excess of expenses annually					$5,187.60			$32,187.60
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