Adjust Assumptions
nights
4 nights7 nights
nights
1 nights4 nights
months
0 months6 months
%
30%80%
seats
18 seats40 seats
x
0.8x2x
($100)
¥10,000¥30,000
%
30%100%
guests
10 guests80 guests
guests
40 guests150 guests
($47)
¥4,000¥15,000
tables
4 tables12 tables
tables
1 tables4 tables
(¥90,000)
$300$1,000
(¥150,000)
$500$2,000
(¥150,000)
$500$2,000
(¥300,000)
$1,000$5,000
%
40%95%
¥
¥
¥
¥
Total Key Hires Cost¥2,000,000 ($13,333)
staff
5 staff25 staff
($2,333)
¥250,000¥500,000
Monthly Full-time Cost¥4,200,000 ($28,000)
staff
0 staff10 staff
($100)
¥10,000¥25,000
Champagne Girls (Club Nights Only)
staff
0 staff6 staff
($133)
¥15,000¥40,000
Monthly Part-time Cost¥3,117,600 ($20,784)
%
0%8%
¥1,262K ($8K)
%
0%5%
¥631K ($4K)
%
0%5%
¥946K ($6K)
Total Marketing9.0% (¥2,839K ($19K))
%
0%6%
¥946K ($6K)
%
0%8%
¥1,262K ($8K)
Total Miss Fish Fees7.0% (¥2,208K ($15K))
Forecast Results
Monthly Revenue
¥31.5M
$210K
Monthly EBITDA
¥4.8M
15.2% margin
Payback Period
28 months
2.3 years
Break-even
¥24.0M
$160K/mo
Key Ratios
Labor %29.5%(target: ≤15%)
Rent %7.6%(target: ≤10%)
Miss Fish Fees7.0%
Monthly Revenue Breakdown
24%
29%
47%
0%
Dinner¥7,482K
Lounge¥9,093K
Tables¥14,964K
Events¥0K
Monthly Staff Costs
Key Hires (4)¥2,000K
Full-time (12)¥4,200K
Daily Staff¥2,338K
Champagne Girls¥779K
Total Staff¥9,318K ($62K)
Monthly Costs Summary
Fixed Costs¥13,218K
Variable Costs¥13,530K
↳ Marketing¥2,839K
↳ Miss Fish Fees¥2,208K
Total Costs¥26,747K ($178K)
Annual Summary
Annual Revenue¥378.5M ($2,523K)
Annual EBITDA¥57.5M ($383K)