ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
3
4
5
6
7
8
9
10
11
12
INPUTS
13
Daily Guests20
14
Days open in a month21
15
Guest Average Spend*$20.00
16
Monthly cost of goods sold$5,000.00
17
Monthly fixed costs$6,000.00
18
Monthly controllable costs$6,000.00
19
20
21
2151
22
DAILYWEEKLYMONTHLY
23
GUESTS GOAL20100420
24
SALES GOAL$400.00$1,680.00$8,400.00
25
COST OF GOODS SOLD SPEND$238.10$1,000.00$5,000.00
26
TOTAL EXPENSES$809.52$3,400.00$17,000.00
27
TOTAL PROFIT-$409.52-$1,720.00-$8,600.00
28
29
MARGINS
30
COGS MARGIN60%60%60%
31
PROFIT MARGIN-102%-102%-102%
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