Food and Beverage Cover and Revenue Analysis Day Date Summary Total Covers Dinner Covers Lunch Covers Breakfast Covers Dinner Revenue Food Dinner Revenue Liquor Lunch Revenue Food Lunch Revenue Liquor Breakfast Revenue
FRI
SAT
SUN
MON
10/3/2009
10/4/2009
10/5/2009
10/6/2009
400
500
90
100
50
60
240
340
1900
2000
900
1000
500
600
300
400
2900
3000
Average Dinner Spend Average Dinner Ratio
31.1
#DIV/0!
30.0
#DIV/0!
22.5%
#DIV/0!
20.0%
#DIV/0!
Average Lunch Spend Average Lunch Ratio
16.0
#DIV/0!
16.7
#DIV/0!
12.5%
#DIV/0!
12.0%
#DIV/0!
Average Breakfast Spend Average Breakfast Ratio
12.1
#DIV/0!
8.8
#DIV/0!
60.0%
#DIV/0!
68.0%
#DIV/0!
Total Total as Per POS Inc Breakfast Variance
6500
0
7000
0
6800 -300
0
7000
0
and Revenue Analysis
Food and Beverage Cover and Revenue
TUE
WED
THU
FRI
10/7/2009
10/8/2009
10/9/2009
W1
SAT
SUN
MON
10/10/2009 10/11/2009 10/12/2009 10/13/2009
900 190 110 580 3900 1900 1100 700 5900 #DIV/0!
#DIV/0!
#DIV/0!
30.5
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
21.1%
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
16.4
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
12.2%
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
10.2
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
64.4%
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0
0
0
13500
0
0
0
0
0
0
0
13500
0
0
0
0
everage Cover and Revenue Analysis TUE
WED
Food and Beverage Cover and Revenue
THU
FRI
10/14/2009 10/15/2009 10/16/2009
W2
SAT
SUN
MON
10/17/2009 10/18/2009 10/19/2009 10/20/2009
0 0 0 0 0 0 0 0 0 #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
everage Cover and Revenue Analysis TUE
WED
Food and Beverage Cover and Revenue
THU
FRI
10/21/2009 10/22/2009 10/23/2009
W3
SAT
SUN
MON
10/24/2009 10/25/2009 10/26/2009 10/27/2009
0 0 0 0 0 0 0 0 0 #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
everage Cover and Revenue Analysis TUE
WED
THU
10/28/2009 10/29/2009 10/30/2009
W4 0 0 0 0 0 0 0 0 0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0
0
0
0
0
0
0
0