Restaurant Monthly Profit & Loss Statement
For more small business templates visit: Spreadsheet123.com © 2009 Spreadsheet123.com
SHAREHOLDER SCORES
Budget Sales £65,670.00 Budget Profit £27,225.00 £ Budget Profit Food Margins % GP v's Budget 41% 72.74% Liquor Margins GP v's Budget 74.63%
Cover data Breakfast Lunch Dinner TOTAL
Actual
7,500 560 3,250 11310
Budget
6,750 750 4,000 11500
Last year
7,400 730 3,650 11780
Sales Costs Net Profit Net Profit % Profit per cover sold SALES Food - Breakfast Food - Lunch Food - Dinner Bev Other COSTS
Actual £65,670.00 £38,445.00 £27,225.00 41.46% £2.41 Actual £18,225.00 £12,470.00 £12,205.00 £20,715.00 £2,055.00 Actual £12,255.00 72.74% £5,255.00 74.63% £20,760.00 31.61% £20,760.00 31.61% £175.00 0.27%
Budget £64,591.00 £39,980.48 £24,610.52 38.10% £2.14 Budget £21,594.00 £3,597.00 £16,250.00 £21,500.00 £1,650.00 Budget £12,065.48 72.00% £5,590.00 74.00% £21,000.00 32.51% £21,000.00 32.51% £1,325.00 2.05%
Var. to budget £1,079.00 £1,535.48 £2,614.48 3.36% £0.27 Var. to budget £3,369.00 £8,873.00 £4,045.00 £785.00 £405.00 Var. to budget 189.52 0.74% 335.00 0.63% 240.00 -0.90% £240.00 -0.90% 1,150.00 -1.78%
Last Year £0.00 £0.00 £0.00 0 £0.00 Last Year £0.00 £0.00 £0.00 £0.00 £0.00 Last Year £0.00 0 £0.00 0 £0.00 0 £0.00 0 £0.00 0
Var. to last year £65,670.00 £38,445.00 £27,225.00 41.46% £2.41 Var. to last year £18,225.00 £12,470.00 £12,205.00 £20,715.00 £2,055.00 Var. to last year 12,255.00 72.74% 5,255.00 74.63% 20,760.00 31.61% 20,760.00 31.61% 175.00 0.27%
Food cost
Food GP%
Liq cost Payroll
Liquor GP% Payroll %
Total Labour cost
Labour cost %
Other cost
Other cost %
Average spend per head Liquor Dinner Breakfast F&B Costs F&B manager Kitchen LC Bar LC Breakfast LC Dinner LC Other LC TOTAL Food cost of sales Liquor cost of sales Cleaning materials Glass wear Kitchen replacement Guest supplies Printing and stationary Misc. Music & Ent. Equipment hire TOTAL
Actual £5.4 £6.5 £2.4
Budget £4.5 £4.2 £3.2
Var. to budget £0.91 £2.30 -£0.77
Last Year £0.0 £0.0 £0.0
Var. to last year £5.44 £6.48 £2.43
£0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £12,255.00 £5,255.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £17,510.00
Monthly F&B Commentary
Results Liquor margin variance £ Liquor margin yield % F&B risk rating Internal QA program score % Customer QA program score Associated action
Restaurant Weekly Profit & Loss Statement
For more small business templates visit: Spreadsheet123.com © 2009 Spreadsheet123.com
SHAREHOLDER SCORES
Budget Sales Budget Profit £ Budget Profit Food Margins % GP v's Budget 41% Cover data Breakfast Lunch Dinner TOTAL 72.74%
Liquor Margins GP v's Budget 74.63%
13,134
5,445
Actual
1,500 112 650 2262
Budget
1350 150 800 2300
Last year
1480 146 730 2356
Actual Sales Costs Net Profit Net Profit % Profit per cover sold SALES Food - Breakfast Food - Lunch Food - Dinner Bev Other COSTS £13,134.00 £7,689.00 £5,445.00 41.46% £2.41 Actual £3,645.00 £2,494.00 £2,441.00 £4,143.00 £411.00 Actual £2,451.00 72.74% £1,051.00 74.63% £4,152.00 31.61% £4,152.00 31.61% £35.00 0.27%
Budget £12,918.20 £7,996.10 £4,922.10 38.10% £2.14 Budget £4,318.80 £719.40 £3,250.00 £4,300.00 £330.00 Budget £2,413.10 72.00% £1,118.00 74.00% £4,200.00 32.51% £4,200.00 32.51% £265.00 2.05%
Var. to budget £215.80 £307.10 £522.90 3.36% £0.27 Var. to budget £673.80 £1,774.60 £809.00 £157.00 £81.00 Var. to budget 37.90 0.74% 67.00 0.63% £48.00 -0.90% £48.00 -0.90% 230.00 -1.78%
Last Year £0.00 £0.00 £0.00 0 £0.00 Last Year £0.00 £0.00 £0.00 £0.00 £0.00 Last Year £0.00 0 £0.00 0 £0.00 0 £0.00 0 £0.00 0
Var. to last year £13,134.00 £7,689.00 £5,445.00 41.46% £2.41 Var. to last year £3,645.00 £2,494.00 £2,441.00 £4,143.00 £411.00 Var. to last year £2,451.00 72.74% £1,051.00 74.63% £4,152.00 31.61% £4,152.00 31.61% £35.00 0.27%
Food cost
Food GP%
Liq cost
Liquor GP%
Payroll
Payroll %
Total Labour cost
Labour cost %
Other cost
Other cost %
Average spend per head Liquor Dinner Breakfast F&B Costs F&B manager Kitchen LC Bar LC Breakfast LC Dinner LC Other LC TOTAL Food cost of sales Liquor cost of sales Cleaning materials Glass wear Kitchen replacement Guest supplies Printing and stationary Misc. Music & Ent. Equipment hire TOTAL
Actual £5.44 £6.48 £2.43
Budget £4.53 £4.18 £3.20
Var. to budget £0.91 £2.30 -£0.77
Last Year £0.00 £0.00 £0.00
Var. to last year £5.44 £6.48 £2.43
£0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £2,451.00 £1,051.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £3,502.00
Restaurant Weekly Profit & Loss Statement
For more small business templates visit: Spreadsheet123.com © 2009 Spreadsheet123.com
SHAREHOLDER SCORES
Budget Sales Budget Profit £ Budget Profit Food Margins % GP v's Budget 41% Cover data Breakfast Lunch Dinner TOTAL 72.74%
Liquor Margins GP v's Budget 74.63%
13,134
5,445
Actual
1,500 112 650 2262
Budget
1350 150 800 2300
Last year
1480 146 730 2356
Actual Sales Costs Net Profit Net Profit % Profit per cover sold SALES Food