Restaurant Financial Planning Components

📊 NEW: Detailed P&L Statement

Profit & Loss Statement
June 2018
Total Revenue
$24,008

YTD: $254,988

Gross Profit
$16,088

Margin: 67.0%

Net Income
($7,760)

Margin: -32.3%

Prime Cost
69.4%

Target: <60%

CategoryAmount% of RevenueYTDYTD %
Food Revenue$10,54843.9%$119,54246.9%
Beer Revenue$6,45626.9%$69,46227.2%
Wine Revenue$1,2085.0%$11,5244.5%
Liquor Revenue$3,24913.5%$33,72613.2%
Retail/Merchandise$1,5386.4%$10,2304.0%
Gift Cards$1,0094.2%$10,5044.1%
Total Revenue$24,008100.0%$254,988100.0%
CategoryAmount% of RevenueYTDYTD %
Food Cost$4,13417.2%$50,12519.7%
Beer Cost$2,2079.2%$19,6407.7%
Wine Cost$4591.9%$4,6101.8%
Liquor Cost$9233.8%$10,2304.0%
Non-Alcohol$1970.8%$2,1870.9%
Total COGS$7,92033.0%$86,79234.0%

Gross Profit

$16,088
Margin: 67.0%
CategoryAmount% of RevenueYTDYTD %
Hourly Wages$7,23030.1%$61,65824.2%
Payroll Taxes$1,3055.4%$10,2304.0%
Workers Comp$2040.8%$2,3250.9%
Total Payroll$8,73936.4%$74,21329.1%
CategoryAmount% of RevenueYTDYTD %
Bank/Credit Card Fees$3771.6%$2,0930.8%
Utilities$1,0184.2%$8,7413.4%
Phone/Internet$3961.6%$2,6301.0%
Office Supplies$2,0138.4%$10,2534.0%
Marketing/Advertising$3,47614.5%$14,8925.8%
Repair & Maintenance$3,83216.0%$18,3427.2%
Laundry/Linen Services$1,0304.3%$10,1024.0%
Other Expenses$1,3205.5%$10,7324.2%
Total Operating$15,10962.9%$87,87634.5%

Net Income (Loss)

($7,760)
Margin: -32.3%
YTD Net Income:$6,107
YTD Margin:2.4%

⭐ Break-Even Calculator with Food/Liquor Split

Break-Even Calculator
Excellent
Monthly Break-Even
$40,179

893 covers needed

Daily Break-Even
$1,545

34 covers/day

Hourly Target
3.4

covers per hour

Revenue Mix

$26,116
$14,063

Cost Structure

Impact: $7,313
Impact: $2,813
Impact: $12,054
29.9% of revenue
6.2% of revenue
8.7% of revenue

Operating Assumptions

Key Performance Metrics

Fixed Costs
$18,000
Weighted COGS
25.2%
Contribution Margin
44.8%
Total Variable Cost
55.2%
Target: 15% Profit Margin
Revenue Needed
$60,403
Covers Needed
1,342 monthly

1. Budget Overview

Budget Overview
Monthly Revenue: $100,000
$50k$500k
28%(Optimal: 25%)
$28,000
+3,000 over optimal
20%40%
30%(Optimal: 28%)
$30,000
+2,000 over optimal
20%35%
6%(Optimal: 6%)
$6,000
3%10%
4%(Optimal: 5%)
$4,000
-1,000 under optimal
2%8%
3%(Optimal: 3%)
$3,000
2%6%
10%(Optimal: 10%)
$10,000
5%15%
81.0%
19.0%
Excellent
Monthly Profit$19,000
Annual Profit Projection$228,000

2. Menu Pricing Strategy

Menu Pricing Strategy
Dynamic Pricing Model
Daily Revenue
$2,325

Projected: $69,750/month

Food Cost %
31.8%

Target: 30%

Average Check
$17.88

Target: $45

20%40%
30%
LowHigh
1.2x

Menu Item Analysis

Signature Burger

Mains
Profitability Score
59%
$5.40
70.0% (Good)
45
$567.00
Suggested: $18.00
$11$27
85%

Caesar Salad

Starters
Profitability Score
50%
$3.00
75.0% (Excellent)
30
$270.00
Suggested: $10.00
$6$15
70%

Ribeye Steak

Mains
Profitability Score
51%
$16.00
61.9% (Poor)
20
$520.00
Suggested: $53.33
$32$80
60%

Price Optimization Opportunity

Adjusting to $53.33 could improve margins by 27.0% ($226.60/day)

Chocolate Lava Cake

Desserts
Profitability Score
52%
$2.50
72.2% (Good)
35
$227.50
Suggested: $8.33
$5$13
90%

Revenue Impact Summary

Daily Gross Profit
$1584.50
Monthly Projection
$47,535

3. Staff Planning

Staff Planning & Labor Cost Analysis
Understaffed
Weekly Labor Cost
$12,792.5

$19.83/hour

Total Staff
17

645 hrs/week

Efficiency
88.5%

Target: 90%

Overtime Hours
15

$188 extra/week

MinMax
120%
70%100%
90%

Staff Roles & Scheduling

Head Chef

$35/hr
OT: 5 hrs
Weekly Cost
$1,662.5
$7,198.625/mo
010 staff
1550 hrs
Impact: $83 loss/week
Cost Breakdown
Regular:$1400
Overtime:$263
Per Employee:$1663

Line Cook

$18/hr
Weekly Cost
$2,880
$12,470.4/mo
010 staff
1550 hrs
Impact: $432 loss/week
Cost Breakdown
Regular:$2880
Overtime:$0
Per Employee:$720

Server

$15/hr
Weekly Cost
$3,150
$13,639.5/mo
010 staff
1550 hrs
Impact: $315 loss/week
Cost Breakdown
Regular:$3150
Overtime:$0
Per Employee:$525

Bartender

$20/hr
Weekly Cost
$1,600
$6,928/mo
010 staff
1550 hrs
Impact: $192 loss/week
Cost Breakdown
Regular:$1600
Overtime:$0
Per Employee:$800

Host

$14/hr
Weekly Cost
$840
$3,637.2/mo
010 staff
1550 hrs
Impact: $126 loss/week
Cost Breakdown
Regular:$840
Overtime:$0
Per Employee:$420

Manager

$28/hr
OT: 5 hrs
Weekly Cost
$2,660
$11,517.8/mo
010 staff
1550 hrs
Impact: $213 loss/week
Cost Breakdown
Regular:$2240
Overtime:$420
Per Employee:$1330

Shift Coverage Analysis

Morning (6am-11am)
10 staff needed
$1,000
5 hours
Lunch (11am-3pm)
15 staff needed
$1,200
4 hours
Afternoon (3pm-5pm)
9 staff needed
$360
2 hours
Dinner (5pm-10pm)
17 staff needed
$1,700
5 hours
Late Night (10pm-12am)
5 staff needed
$200
2 hours

Labor Cost Projections

Monthly
$55,391.525
Annual
$665,210
Labor % (at $100k/mo)
55.4%
Revenue Needed (30% Labor)
$184,638.417

4. Marketing Budget

Marketing Budget & ROI Analysis
ROI: 4.0x
Monthly Spend
$10,000

Budget: $10,000

Total Reach
33,000

$303.03 per 1k

Conversions
1136

$8.80 CPA

Net Profit
$30,100

$361,200/year

$10,000
$2k$25k
1x10x
3.5x
$100$500
$250

Channel Performance & Budget Allocation

Social Media

ROI: 4.2x
2.5% CVR
Monthly Profit
$9,600
Revenue: $12,600
15,000
375
$25
$45
Max: $5,000
This Month:$12600
Projected Annual:$151,200
LTV Impact:$93,750

Google Ads

ROI: 3.8x
3.2% CVR
Monthly Profit
$9,800
Revenue: $13,300
8,000
256
$35
$55
Max: $5,000
This Month:$13300
Projected Annual:$159,600
LTV Impact:$64,000

Email Marketing

ROI: 5.5x
4.5% CVR
Monthly Profit
$4,500
Revenue: $5,500
5,000
225
$15
$40
Max: $5,000
This Month:$5500
Projected Annual:$66,000
LTV Impact:$56,250

Local Events

ROI: 2.8x
5% CVR
Monthly Profit
$3,600
Revenue: $5,600
2,000
100
$40
$60
Max: $5,000
This Month:$5600
Projected Annual:$67,200
LTV Impact:$25,000

Mobile App Push

ROI: 6.2x
6% CVR
Monthly Profit
$2,600
Revenue: $3,100
3,000
180
$10
$35
Max: $5,000
This Month:$3100
Projected Annual:$37,200
LTV Impact:$45,000

Active Campaigns

Summer Special
30 days • 10,000 reach
$3,000
Expected ROI: 3.5x
Happy Hour Promo
60 days • 5,000 reach
$2,000
Expected ROI: 4x
New Menu Launch
14 days • 8,000 reach
$1,500
Expected ROI: 2.8x

Marketing Performance Summary

Monthly Revenue
$40,100
Annual Projection
$481,200
Overall ROI
4.0x
Budget Efficiency
100%