ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Please make a copy. Go to File > Make a copy.
2
Revenue Worksheet
3
Account AmountExplanation
4
5
# of Days Open per Week0Number of days per week business is open
6
7
# of Days0Assuming that business is closed on Christmas Day
8
9
Midweek 0Days other than weekend and holiday days
10
Weekend & Holidays0Saturday, Sunday and Holidays
11
12
Average Sales
13
14
Midweek $ - Projected midweek sales
15
Weekend & Holidays $ - Projected weekend and holiday day sales
16
17
Revenue
18
19
Midweek $ - # of midweek days (X) average sales for same
20
Weekend & Holidays $ - # of busy days (X) average weekend and holiday sales for same
21
22
Total Revenue $ - Yearly sales projection
23
24
Average Sales per Day#DIV/0!Yearly sales divided by # of days open
25
26
Sales Mix %
27
28
Food0% Percentage of sales projected in Food sales
29
Beverage0% Percentage of sales projected in Beverage sales
30
31
Sales Mix $
32
33
Food $ - Total Revenue @ 80%
34
Beverage $ - Total Revenue @ 20%
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