Food and Beverage Sample Worksheet
Revenue Worksheet
Account Amount Explanation
# of Days Open per Week 0 Number of days per week business is open
# of Days 0 Assuming that business is closed on Christmas Day
Midweek 0 Days other than weekend and holiday days
Weekend & Holidays 0 Saturday, Sunday and Holidays
Average Sales
Midweek $ - Projected midweek sales
Weekend & Holidays $ - Projected weekend and holiday day sales
Revenue
Midweek $ - # of midweek days (X) average sales for same
Weekend & Holidays $ - # of busy days (X) average weekend and holiday sales for same
Total Revenue $ - Yearly sales projection
Average Sales per Day #DIV/0! Yearly sales divided by # of days open
Sales Mix %
Food 0% Percentage of sales projected in Food sales
Beverage 0% Percentage of sales projected in Beverage sales
Sales Mix $
Food $ - Total Revenue @ 80%
Beverage $ - Total Revenue @ 20%
Controllables Worksheet
Account Amount
Revenue
Food $ -
Beverage $ -
Total Revenue $ -
Cost of Goods Sold
Cost of Goods Sold %
Food 0%
Beverage 0%
Cost of Goods Sold $s
Food $ -
Beverage $ -
Total Cost of Goods Sold $ -
as a % #DIV/0!
Gross Profit $ -
as a % #DIV/0!
Labor Costs
Labor as a %
Management Fixed
Kitchen 0%
Front of House 0%
Labor as a $
Management $ -
Kitchen $ -
Front of House $ -
Sub Total $ -
Statutory Benefits @ 7% $ -
Total Labor $ -
as a % #DIV/0!
Operational Profit $ -
as a % #DIV/0!
ables Worksheet
Explanation
From Revenue Page
From Revenue Page
From Revenue Page
Targeted cost percentage of Food sold
Targeted cost percentage of Beverages sold
Food Revenue X 30%
Beverage Revenue X 35%
Cost of both Food and Beverage
Cost of Goods Sold divided by Total Revenue
Revenue less Cost of Goods Sold
Gross Profit divided by Total Revenue
Salary of Owner/Operator
Line Cooks and Kitchen Helpers
Cashiers and Counter Helpers
Salary of Owner/Operator
Line cooks and Kitchen Helpers
Cashiers and Counter Helpers
Cost of Labor before Statutory Benefits
Payroll taxes
Labor including payroll taxes
Labor Costs divided by Total Revenue
Gross Profit less Cost of Labor
Operational Profit divided by Total Revenue
Financial Foreca
Total Revenue
Gross Profit
Operating Profit
as a %
Expenses Monthly
Advertising and Promotion 0.00%
Supplies Kitchen 0.00%
Supplies Restaurant 0.00%
Bank Charges $ -
Credit Card Charges 0.0%
Insurance $ -
Legal & Accounting $ -
Maintenance $ -
Office Expense $ -
Rent $ -
Telecommunications $ -
Utilities $ -
Web Maintenance $ -
Total Expenses
Income
as a %
Financial Forecast Worksheet
$ -
$ -
$ -
#DIV/0!
-
-
-
$ -
-
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
#DIV/0!
ncial Forecast Worksheet
From Revenue Worksheet
From Controllable Cost Worksheet
From Controllable Cost Worksheet
From Controllable Cost Worksheet
Monies allocated to promote the business and stated as a % of Total Sales
Supplies required for food preparation and storage and stated as a % of Total Sales
Supplies used by customers and stated as a % of Total Sales
To maintain a current account at the b
Processing fees for customer use of credit and debit cards and stated as a % of Total S
Liability and building insur
For remittance of taxes and review of documents as requ
On equipment, furniture, fixtures and the physical p
Paper, pens, toner
Including
Internet, cell and land
Gas, Water and H
Hosting of Website and email acco
Before Interest, Taxes, Depreciation, Amortization etc.
Income divided by Total Reve
Start-Up Costs
Account Amount
Business Set-up:
Bank Charges $ -
Website Design and Development $ -
Advertising and Marketing $ -
Training Cost $ -
Inventories $ -
POS $ -
Legal & Accounting $ -
Office Expense $ -
Rent $ -
Utility Deposits $ -
Small Wares:
Kitchen $ -
Restaurant $ -
Capital Improvements $ -
Furniture&Fixtures $ -
Equipment $ -
Total Expenses $ -
Working Capital $ -
Total $ -
tart-Up Costs
Explanation
To set up account and debit machine
Including Social Media channels
Pre-Opening
For all staff and management
Foodstuffs and other products
Including printers and subscriptions
To review leases and other documents
To set up bookkeeping
Last month's rent
Gas and/or Hydro
Pots and pans and such
Plates and bowls and cutlery etc.
Estimating $100 per square foot for 1000 sq. ft. space
For seating area
To set up kitchen with mix of used and new equipment
To "get" open
To have as a cushion during initial months of operation
Expenses plus allowance for working capital
