restaurant monthly profit and loss template
TRANSCRIPT
Restaurant Monthly Profit & Loss StatementFor more small business templates visit:
© 2009 Spreadsheet123.com
SHAREHOLDER SCORES
Budget Sales
£65,670.00 £27,225.00 41% 72.74% 74.63%
Cover data Actual BudgetBreakfast 7,500 6,750Lunch 560 750
Dinner 3,250 4,000 TOTAL 11310 11500
Actual Budget Var. to budget Last YearSales £65,670.00 £64,591.00 £1,079.00 £0.00Costs £38,445.00 £39,980.48 £1,535.48 £0.00Net Profit £27,225.00 £24,610.52 £2,614.48 £0.00Net Profit % 41.46% 38.10% 3.36% 0
Profit per cover sold £2.41 £2.14 £0.27 £0.00
SALES Actual Budget Var. to budget Last YearFood - Breakfast £18,225.00 £21,594.00 £3,369.00 £0.00 Food - Lunch £12,470.00 £3,597.00 £8,873.00 £0.00 Food - Dinner £12,205.00 £16,250.00 £4,045.00 £0.00 Bev £20,715.00 £21,500.00 £785.00 £0.00 Other £2,055.00 £1,650.00 £405.00 £0.00
COSTS Actual Budget Var. to budget Last YearFood cost £12,255.00 £12,065.48 189.52 £0.00 Food GP% 72.74% 72.00% 0.74% 0Liq cost £5,255.00 £5,590.00 335.00 £0.00 Liquor GP% 74.63% 74.00% 0.63% 0Payroll £20,760.00 £21,000.00 240.00 £0.00 Payroll % 31.61% 32.51% -0.90% 0Total Labour cost £20,760.00 £21,000.00 £240.00 £0.00 Labour cost % 31.61% 32.51% -0.90% 0Other cost £175.00 £1,325.00 1,150.00 £0.00
Other cost % 0.27% 2.05% -1.78% 0
Budget Profit £
Budget Profit %
Food Margins GP v's Budget
Liquor Margins GP v's Budget
Average spend per head Actual Budget Var. to budget Last YearLiquor £5.4 £4.5 £0.91 £0.0Dinner £6.5 £4.2 £2.30 £0.0Breakfast £2.4 £3.2 -£0.77 £0.0
F&B Costs
F&B manager £0.00
Kitchen LC £0.00
Bar LC £0.00
Breakfast LC £0.00
Dinner LC £0.00
Other LC £0.00
TOTAL £0.00
Food cost of sales £12,255.00
Liquor cost of sales £5,255.00
Cleaning materials £0.00
Glass wear £0.00
Kitchen replacement £0.00
Guest supplies £0.00
Printing and stationary £0.00
Misc. £0.00
Music & Ent. £0.00
Equipment hire £0.00
TOTAL £17,510.00
Monthly F&B Commentary
Results Associated actionLiquor margin variance £Liquor margin yield %F&B risk ratingInternal QA program score %Customer QA program score
Restaurant Monthly Profit & Loss Statement
© 2009 Spreadsheet123.com
Last year7,400730
3,65011780
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 year12,255.0072.74%
5,255.0074.63%
20,760.0031.61%
20,760.0031.61%175.00
0.27%
Spreadsheet123.com
Buy unlocked version!
Cost: $14.95USD
Var. to last year£5.44£6.48£2.43
Restaurant Weekly Profit & Loss StatementFor more small business templates visit:
© 2009 Spreadsheet123.com
SHAREHOLDER SCORES
Budget Sales
13,134 5,445 41% 72.74% 74.63%
Cover data Actual Budget
Breakfast 1,500 1350
Lunch 112 150
Dinner 650 800
TOTAL 2262 2300
Actual Budget Var. to budget Last Year
Sales £13,134.00 £12,918.20 £215.80 £0.00
Costs £7,689.00 £7,996.10 £307.10 £0.00
Net Profit £5,445.00 £4,922.10 £522.90 £0.00
Net Profit % 41.46% 38.10% 3.36% 0
Profit per cover sold £2.41 £2.14 £0.27 £0.00
SALES Actual Budget Var. to budget Last Year
Food - Breakfast £3,645.00 £4,318.80 £673.80 £0.00
Food - Lunch £2,494.00 £719.40 £1,774.60 £0.00
Food - Dinner £2,441.00 £3,250.00 £809.00 £0.00
Bev £4,143.00 £4,300.00 £157.00 £0.00
Other £411.00 £330.00 £81.00 £0.00
COSTS Actual Budget Var. to budget Last Year
Food cost £2,451.00 £2,413.10 37.90 £0.00
Food GP% 72.74% 72.00% 0.74% 0
Liq cost £1,051.00 £1,118.00 67.00 £0.00
Liquor GP% 74.63% 74.00% 0.63% 0
Payroll £4,152.00 £4,200.00 £48.00 £0.00
Payroll % 31.61% 32.51% -0.90% 0
Total Labour cost £4,152.00 £4,200.00 £48.00 £0.00
Labour cost % 31.61% 32.51% -0.90% 0
Other cost £35.00 £265.00 230.00 £0.00
Other cost % 0.27% 2.05% -1.78% 0
Budget Profit £
Budget Profit %
Food Margins GP v's Budget
Liquor Margins GP v's Budget
Average spend per head Actual Budget Var. to budget Last Year
Liquor £5.44 £4.53 £0.91 £0.00
Dinner £6.48 £4.18 £2.30 £0.00
Breakfast £2.43 £3.20 -£0.77 £0.00
F&B Costs
F&B manager £0.00
Kitchen LC £0.00
Bar LC £0.00
Breakfast LC £0.00
Dinner LC £0.00
Other LC £0.00
TOTAL £0.00
Food cost of sales £2,451.00
Liquor cost of sales £1,051.00
Cleaning materials £0.00
Glass wear £0.00
Kitchen replacement £0.00
Guest supplies £0.00
Printing and stationary £0.00
Misc. £0.00
Music & Ent. £0.00
Equipment hire £0.00
TOTAL £3,502.00
Restaurant Weekly Profit & Loss Statement
© 2009 Spreadsheet123.com
Last year
1480
146
730
2356
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%
Spreadsheet123.comBuy unlocked version!
Cost: $14.95USD
Var. to last year
£5.44
£6.48
£2.43
Restaurant Weekly Profit & Loss StatementFor more small business templates visit:
© 2009 Spreadsheet123.com
SHAREHOLDER SCORES
Budget Sales
13,134 5,445 41% 72.74% 74.63%
Cover data Actual Budget
Breakfast 1,500 1350
Lunch 112 150
Dinner 650 800
TOTAL 2262 2300
Actual Budget Var. to budget Last Year
Sales £13,134.00 £12,918.20 £215.80 £0.00
Costs £7,689.00 £7,996.10 £307.10 £0.00
Net Profit £5,445.00 £4,922.10 £522.90 £0.00
Net Profit % 41.46% 38.10% 3.36% 0
Profit per cover sold £2.41 £2.14 £0.27 £0.00
SALES Actual Budget Var. to budget Last Year
Food - Breakfast £3,645.00 £4,318.80 £673.80 £0.00
Food - Lunch £2,494.00 £719.40 £1,774.60 £0.00
Food - Dinner £2,441.00 £3,250.00 £809.00 £0.00
Bev £4,143.00 £4,300.00 £157.00 £0.00
Other £411.00 £330.00 £81.00 £0.00
COSTS Actual Budget Var. to budget Last Year
Food cost £2,451.00 £2,413.10 37.90 £0.00
Food GP% 72.74% 72.00% 0.74% 0
Liq cost £1,051.00 £1,118.00 67.00 £0.00
Liquor GP% 74.63% 74.00% 0.63% 0
Payroll £4,152.00 £4,200.00 £48.00 £0.00
Payroll % 31.61% 32.51% -0.90% 0
Total Labour cost £4,152.00 £4,200.00 £48.00 £0.00
Labour cost % 31.61% 32.51% -0.90% 0
Other cost £35.00 £265.00 230.00 £0.00
Other cost % 0.27% 2.05% -1.78% 0
Budget Profit £
Budget Profit %
Food Margins GP v's Budget
Liquor Margins GP v's Budget
Average spend per head Actual Budget Var. to budget Last Year
Liquor £5.44 £4.53 £0.91 £0.00
Dinner £6.48 £4.18 £2.30 £0.00
Breakfast £2.43 £3.20 -£0.77 £0.00
F&B Costs
F&B manager £0.00
Kitchen LC £0.00
Bar LC £0.00
Breakfast LC £0.00
Dinner LC £0.00
Other LC £0.00
TOTAL £0.00
Food cost of sales £2,451.00
Liquor cost of sales £1,051.00
Cleaning materials £0.00
Glass wear £0.00
Kitchen replacement £0.00
Guest supplies £0.00
Printing and stationary £0.00
Misc. £0.00
Music & Ent. £0.00
Equipment hire £0.00
TOTAL £3,502.00
Restaurant Weekly Profit & Loss Statement
© 2009 Spreadsheet123.com
Last year
1480
146
730
2356
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%
Spreadsheet123.comBuy unlocked version!
Cost: $14.95USD
Var. to last year
£5.44
£6.48
£2.43
Restaurant Weekly Profit & Loss StatementFor more small business templates visit:
© 2009 Spreadsheet123.com
SHAREHOLDER SCORES
Budget Sales
13,134 5,445 41% 72.74% 74.63%
Cover data Actual Budget
Breakfast 1,500 1350
Lunch 112 150
Dinner 650 800
TOTAL 2262 2300
Actual Budget Var. to budget Last Year
Sales £13,134.00 £12,918.20 £215.80 £0.00
Costs £7,689.00 £7,996.10 £307.10 £0.00
Net Profit £5,445.00 £4,922.10 £522.90 £0.00
Net Profit % 41.46% 38.10% 3.36% 0
Profit per cover sold £2.41 £2.14 £0.27 £0.00
SALES Actual Budget Var. to budget Last Year
Food - Breakfast £3,645.00 £4,318.80 £673.80 £0.00
Food - Lunch £2,494.00 £719.40 £1,774.60 £0.00
Food - Dinner £2,441.00 £3,250.00 £809.00 £0.00
Bev £4,143.00 £4,300.00 £157.00 £0.00
Other £411.00 £330.00 £81.00 £0.00
COSTS Actual Budget Var. to budget Last Year
Food cost £2,451.00 £2,413.10 37.90 £0.00
Food GP% 72.74% 72.00% 0.74% 0
Liq cost £1,051.00 £1,118.00 67.00 £0.00
Liquor GP% 74.63% 74.00% 0.63% 0
Payroll £4,152.00 £4,200.00 £48.00 £0.00
Payroll % 31.61% 32.51% -0.90% 0
Total Labour cost £4,152.00 £4,200.00 £48.00 £0.00
Labour cost % 31.61% 32.51% -0.90% 0
Other cost £35.00 £265.00 230.00 £0.00
Other cost % 0.27% 2.05% -1.78% 0
Budget Profit £
Budget Profit %
Food Margins GP v's Budget
Liquor Margins GP v's Budget
Average spend per head Actual Budget Var. to budget Last Year
Liquor £5.44 £4.53 £0.91 £0.00
Dinner £6.48 £4.18 £2.30 £0.00
Breakfast £2.43 £3.20 -£0.77 £0.00
F&B Costs
F&B manager £0.00
Kitchen LC £0.00
Bar LC £0.00
Breakfast LC £0.00
Dinner LC £0.00
Other LC £0.00
TOTAL £0.00
Food cost of sales £2,451.00
Liquor cost of sales £1,051.00
Cleaning materials £0.00
Glass wear £0.00
Kitchen replacement £0.00
Guest supplies £0.00
Printing and stationary £0.00
Misc. £0.00
Music & Ent. £0.00
Equipment hire £0.00
TOTAL £3,502.00
Restaurant Weekly Profit & Loss Statement
© 2009 Spreadsheet123.com
Last year
1480
146
730
2356
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%
Spreadsheet123.comBuy unlocked version!
Cost: $14.95USD
Var. to last year
£5.44
£6.48
£2.43
Restaurant Weekly Profit & Loss StatementFor more small business templates visit:
© 2009 Spreadsheet123.com
SHAREHOLDER SCORES
Budget Sales
13,134 5,445 41% 72.74% 74.63%
Cover data Actual Budget
Breakfast 1,500 1350
Lunch 112 150
Dinner 650 800
TOTAL 2262 2300
Actual Budget Var. to budget Last Year
Sales £13,134.00 £12,918.20 £215.80 £0.00
Costs £7,689.00 £7,996.10 £307.10 £0.00
Net Profit £5,445.00 £4,922.10 £522.90 £0.00
Net Profit % 41.46% 38.10% 3.36% 0
Profit per cover sold £2.41 £2.14 £0.27 £0.00
SALES Actual Budget Var. to budget Last Year
Food - Breakfast £3,645.00 £4,318.80 £673.80 £0.00
Food - Lunch £2,494.00 £719.40 £1,774.60 £0.00
Food - Dinner £2,441.00 £3,250.00 £809.00 £0.00
Bev £4,143.00 £4,300.00 £157.00 £0.00
Other £411.00 £330.00 £81.00 £0.00
COSTS Actual Budget Var. to budget Last Year
Food cost £2,451.00 £2,413.10 37.90 £0.00
Food GP% 72.74% 72.00% 0.74% 0
Liq cost £1,051.00 £1,118.00 67.00 £0.00
Liquor GP% 74.63% 74.00% 0.63% 0
Payroll £4,152.00 £4,200.00 £48.00 £0.00
Payroll % 31.61% 32.51% -0.90% 0
Total Labour cost £4,152.00 £4,200.00 £48.00 £0.00
Labour cost % 31.61% 32.51% -0.90% 0
Other cost £35.00 £265.00 230.00 £0.00
Other cost % 0.27% 2.05% -1.78% 0
Budget Profit £
Budget Profit %
Food Margins GP v's Budget
Liquor Margins GP v's Budget
Average spend per head Actual Budget Var. to budget Last Year
Liquor £5.44 £4.53 £0.91 £0.00
Dinner £6.48 £4.18 £2.30 £0.00
Breakfast £2.43 £3.20 -£0.77 £0.00
F&B Costs
F&B manager £0.00
Kitchen LC £0.00
Bar LC £0.00
Breakfast LC £0.00
Dinner LC £0.00
Other LC £0.00
TOTAL £0.00
Food cost of sales £2,451.00
Liquor cost of sales £1,051.00
Cleaning materials £0.00
Glass wear £0.00
Kitchen replacement £0.00
Guest supplies £0.00
Printing and stationary £0.00
Misc. £0.00
Music & Ent. £0.00
Equipment hire £0.00
TOTAL £3,502.00
Restaurant Weekly Profit & Loss Statement
© 2009 Spreadsheet123.com
Last year
1480
146
730
2356
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%
Spreadsheet123.comBuy unlocked version!
Cost: $14.95USD
Var. to last year
£5.44
£6.48
£2.43
Restaurant Weekly Profit & Loss StatementFor more small business templates visit:
© 2009 Spreadsheet123.com
SHAREHOLDER SCORES
Budget Sales
13,134 5,445 41% 72.74% 74.63%
Cover data Actual Budget
Breakfast 1,500 1350
Lunch 112 150
Dinner 650 800
TOTAL 2262 2300
Actual Budget Var. to budget Last Year
Sales £13,134.00 £12,918.20 £215.80 £0.00
Costs £7,689.00 £7,996.10 £307.10 £0.00
Net Profit £5,445.00 £4,922.10 £522.90 £0.00
Net Profit % 41.46% 38.10% 3.36% 0
Profit per cover sold £2.41 £2.14 £0.27 £0.00
SALES Actual Budget Var. to budget Last Year
Food - Breakfast £3,645.00 £4,318.80 £673.80 £0.00
Food - Lunch £2,494.00 £719.40 £1,774.60 £0.00
Food - Dinner £2,441.00 £3,250.00 £809.00 £0.00
Bev £4,143.00 £4,300.00 £157.00 £0.00
Other £411.00 £330.00 £81.00 £0.00
COSTS Actual Budget Var. to budget Last Year
Food cost £2,451.00 £2,413.10 37.90 £0.00
Food GP% 72.74% 72.00% 0.74% 0
Liq cost £1,051.00 £1,118.00 67.00 £0.00
Liquor GP% 74.63% 74.00% 0.63% 0
Payroll £4,152.00 £4,200.00 £48.00 £0.00
Payroll % 31.61% 32.51% -0.90% 0
Total Labour cost £4,152.00 £4,200.00 £48.00 £0.00
Budget Profit £
Budget Profit %
Food Margins GP v's Budget
Liquor Margins GP v's Budget
Labour cost % 31.61% 32.51% -0.90% 0
Other cost £35.00 £265.00 230.00 £0.00
Other cost % 0.27% 2.05% -1.78% 0
Average spend per head Actual Budget Var. to budget Last Year
Liquor £5.44 £4.53 £0.91 £0.00
Dinner £6.48 £4.18 £2.30 £0.00
Breakfast £2.43 £3.20 -£0.77 £0.00
F&B Costs
F&B manager £0.00
Kitchen LC £0.00
Bar LC £0.00
Breakfast LC £0.00
Dinner LC £0.00
Other LC £0.00
TOTAL £0.00
Food cost of sales £2,451.00
Liquor cost of sales £1,051.00
Cleaning materials £0.00
Glass wear £0.00
Kitchen replacement £0.00
Guest supplies £0.00
Printing and stationary £0.00
Misc. £0.00
Music & Ent. £0.00
Equipment hire £0.00
TOTAL £3,502.00
Restaurant Weekly Profit & Loss Statement
© 2009 Spreadsheet123.com
Last year
1480
146
730
2356
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
Spreadsheet123.comBuy unlocked version!
Cost: $14.95USD
31.61%
£35.00
0.27%
Var. to last year
£5.44
£6.48
£2.43
END-USER LICENSE AGREEMENTFor more small business templates visit:
© 2009 Spreadsheet123.com
IMPORTANT—READ CAREFULLY:
This End-User License Agreement (”EULA”) is a legal agreement between you and Spreadsheet123.com thatcovers all Microsoft Excel and OpenOffice.org templates or spreadsheets (”TEMPLATES”) made by Spreadsheet123.com.
By downloading, copying, accessing or otherwise using any TEMPLATES, you agree to be bound by the termsof this EULA.
TEMPLATES LICENSE
This TEMPLATE is protected by copyright laws and international copyright treaties, as well as other intellectualproperty laws and treaties. Each TEMPLATE is licensed, not sold.
1. GRANT OF LICENSE.
it for calculations but you may not remove or alter any logo, trademark, copyright, hyperlinks, disclaimers, terms of use,or other proprietary notices within the TEMPLATES.You may not sell, resell, license, rent, lease, lend, or place on the public server (Internet) or otherwise transfer for value
2. TERMINATION.Without prejudice to any other rights, Spreadsheet123.com may terminate this EULA if you fail to comply with theterms and conditions of this EULA. In such event, you must destroy all copies of any TEMPLATE.
3. NOTICE SPECIFIC TO TEMPLATES.SPREADSHEET123.COM MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THE TEMPLATES FOR ANY PURPOSE. ALL TEMPLATES ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND. SPREADSHEET123.COM HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THE TEMPLATES, INCLUDING ALL IMPLIEDWARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLEAND NON-INFRINGEMENT. IN NO EVENT SHALL SPREADSHEET123.COM BE LIABLE FOR ANY SPECIAL,INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS
4. MISCELLANEOUS.Some states do not allow the limitation or exclusion of liability for incidental or consequentialdamages, so the above limitation may not apply to you.
This EULA grants you the right to download the TEMPLATES free of charge for personal use or for your company use.You may customize this Restaurant Monthly Profit & Loss Template with you personal or company information and use
without written permission of SPREADSHEET123.COM
END-USER LICENSE AGREEMENT© 2009 Spreadsheet123.com
IMPORTANT—READ CAREFULLY:
This End-User License Agreement (”EULA”) is a legal agreement between you and Spreadsheet123.com thatcovers all Microsoft Excel and OpenOffice.org templates or spreadsheets (”TEMPLATES”) made by Spreadsheet123.com.
By downloading, copying, accessing or otherwise using any TEMPLATES, you agree to be bound by the termsof this EULA.
TEMPLATES LICENSE
This TEMPLATE is protected by copyright laws and international copyright treaties, as well as other intellectualproperty laws and treaties. Each TEMPLATE is licensed, not sold.
1. GRANT OF LICENSE.
it for calculations but you may not remove or alter any logo, trademark, copyright, hyperlinks, disclaimers, terms of use,or other proprietary notices within the TEMPLATES.You may not sell, resell, license, rent, lease, lend, or place on the public server (Internet) or otherwise transfer for value
2. TERMINATION.Without prejudice to any other rights, Spreadsheet123.com may terminate this EULA if you fail to comply with theterms and conditions of this EULA. In such event, you must destroy all copies of any TEMPLATE.
3. NOTICE SPECIFIC TO TEMPLATES.SPREADSHEET123.COM MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THE TEMPLATES FOR ANY PURPOSE. ALL TEMPLATES ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND. SPREADSHEET123.COM HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THE TEMPLATES, INCLUDING ALL IMPLIEDWARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLEAND NON-INFRINGEMENT. IN NO EVENT SHALL SPREADSHEET123.COM BE LIABLE FOR ANY SPECIAL,INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS
4. MISCELLANEOUS.Some states do not allow the limitation or exclusion of liability for incidental or consequential
Spreadsheet123.com
personal use or for your company use. with you personal or company information and use
Buy unlocked version!
Cost: $14.95USD