Monthly Income / Daypart
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQR
1
Period $Period %
2
Monthly UnitsDaily UnitsDaily $OPENING COSTSFurniture, Fixtures & Equipment
3
Beverage Revenue$20,00048.00%8,889296$667
4
Food Revenue$20,00048.00%2,00067$667NewUsed
5
Other Revenue$1,6674.00%83328$56Occupancy$7,500Refrigeration5000
6
TOTAL REVENUE$41,667100.00%Yearly Revenue:$500,000FF&E$36,700Register/POS20000
7
Monthly Revenue$41,667Inventory$20,000Tables/Bar5000
8
Beverage Cost of Goods$10,00050.00%Yearly Income-$1,0006 months Wages$57,500Stools1200
9
Food Cost of Goods$6,00030.00%Monthly Income-$836 months Other Operating Expenses$67,000Display Cabinet2000
10
Other Cost of Goods$83350.00%design$50,000Shelving2500
11
NET COST OF GOODS$16,83340.40%yellow cells = adjustableelectric$5,000Lighting1000
12
white cells = fixeddecor$5,000
13
GROSS PROFIT$24,833other$5,000
14
15
Hourly Labor$8,33320.00%TOTAL$253,70036700
16
Management 1$4,16710.00%$50,000
17
Wages Subtotal$12,50030.00%
18
Other Wages$1,250
19
TOTAL PAYROLL EXPENSES$13,75033.00%
20
21
PRIME COSTS$30,58373.40%
22
23
GROSS PROFIT$11,083
24
25
Controllable Expenses$1,6674.00%
26
Admin & General$4171.00%
27
Marketing$2,0835.00%
28
Occupancy$3,0007.20%
29
Loan / Interest$2,5006.00%
30
Other Fixed Costs$1,5003.60%
31
$11,167
32
Income Before Bonus-$83
33
34
Staff Bonus
35
36
Unit Income-$83-0.20%
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
Loading...
 
 
 
INCOME CALCULATOR
DayPart Calculator