Restaurant Monthly Profit Loss Template - Excel

Document Sample
Restaurant Monthly Profit Loss Template - Excel Powered By Docstoc
					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
				
DOCUMENT INFO
Description: If you are serious about making more money in your restaurant, you have got to know your business running costs and not just once a month, but at the end of every week. By having done so you will win yourself a huge amount of valuable time to act on arising problems. Calculating Profit and Loss is a must for any restaurant serious about making profit. The Restaurant Monthly Profit and Loss Template contains five P&L worksheets for every week of the month. I have also included a Budget Tool that helps to allocate your Prime Cost amounts.
BUY THIS DOCUMENT NOW PRICE: $14.95 100% MONEY BACK GUARANTEED
PARTNER Spreadsheet123 Ltd
Spreadsheet123 is your ultimate guide to the world of Excel. Every template that you could need for business, real estate, budgeting, personal and corporate finance can be found on this site. In addition, there are Excel calculators, tutorials and links. Visit www.spreadsheet123.com for all of your spreadsheet needs.