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