jagomart
digital resources
picture1_Budget Spreadsheet 41640 | Restaurant Monthly Profit And Loss Statement


 205x       Filetype XLSX       File size 0.21 MB       Source: s3-us-west-2.amazonaws.com


File: Budget Spreadsheet 41640 | Restaurant Monthly Profit And Loss Statement
sheet 1 week 1 restaurant profit and loss statement shareholder scores week 1 commencing sales 13 13400 costs 9 36100 net profit 3 77300 net profit 2873 food gross profit ...

icon picture XLSX Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Week 1
RESTAURANT PROFIT AND LOSS STATEMENT


















SHAREHOLDER SCORES


WEEK 1 COMMENCING













Sales
13,134.00








Costs
9,361.00








Net Profit
3,773.00








Net Profit %
28.73 %








Food Gross Profit Margin
72.74 %








Beverage Gross Profit Margin
74.63 %















































COVER DATA Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Breakfast 1,500 1,350 1,480 150.00 20.00




Lunch 112 150 146 -38.00 -34.00




Dinner 650 800 730 -150.00 -80.00

















COVER DATA TOTAL 2,262 2,300 2,356 -38.00 -94.00

















SALES Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Food - Breakfast 3,645.00 4,351.00 3,975.00 -706.00 -330.00




Food - Lunch 2,494.00 2,148.00 2,541.00 346.00 -47.00




Food - Dinner 2,441.00 2,681.00 2,514.00 -240.00 -73.00




Bev 4,143.00 4,110.00 5,147.00 33.00 -1,004.00




Other 411.00 651.00 354.00 -240.00 57.00

















SALES TOTAL 13,134.00 13,941.00 14,531.00 -807.00 -1,397.00

















COSTS Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Managers Salary 800.00 800.00 800.00 - -




Kitchen Labour Cost 1,450.00 1,450.00 1,450.00 - -




Bar Labour Cost 950.00 950.00 950.00 - -




Breakfast Labour Cost 1,200.00 1,200.00 1,200.00 - -




Dinner Labour Cost 1,750.00 1,750.00 1,750.00 - -




Other Labour Cost - - - - -




Food Inventory Opening 3,000.00 2,651.00 3,000.00 -349.00 -




Food Cost 2,451.00 2,401.00 2,451.00 -50.00 -




Food Inventory Closing 3,240.00 2,822.00 3,140.00 -418.00 -100.00




Beverage Inventory Opening 1,744.00 1,845.00 1,914.00 101.00 170.00




Beverage Cost 1,051.00 1,101.00 1,051.00 50.00 -




Beverage Inventory Closing 1,825.00 1,745.00 1,901.00 -80.00 76.00




Cleaning Materials - - - - -




Glassware and Cutlery - - - - -




Kitchen Replacement - - - - -




Guest Supplies - - - - -




Printing and Stationary 30.00 40.00 - 10.00 -30.00




Miscellaneous - - - - -




Music & Entertainment - - - - -




Equipment Hire - - - - -

















COSTS TOTAL 9,361.00 9,621.00 9,525.00 260.00 164.00

















COSTS SHARE DISTRIBUTION Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Food cost 2,451.00 2,401.00 2,451.00 -50.00 -




Food GP% 72.74 % 75.58 % 73.88 % 2.84 % 1.14 %




Beverage cost 1,051.00 1,101.00 1,051.00 50.00 -




Beverage GP% 74.63 % 73.21 % 79.58 % -1.42 % 4.95 %




Labour cost 6,150.00 6,150.00 6,150.00 - -




Labour cost % 46.83 % 44.11 % 42.32 % -2.71 % -4.50 %




Other cost 30.00 40.00 - 10.00 -30.00




Other cost % 0.23 % 0.29 % 0.00 % 0.06 % -0.23 %






























AVERAGE SALE PER COVER Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Beverage 5.44 4.33 5.88 1.11 -0.44




Dinner 6.48 5.08 5.77 1.39 0.71




Breakfast 2.43 3.22 2.69 -0.79 -0.26






























NET PROFIT Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Net Profit 3,773.00 4,320.00 5,006.00 -547.00 -1,233.00




Net Profit % 28.73 % 30.99 % 34.45 % -0.02 -0.06




Net Profit Per Cover 1.67 1.88 2.12 -0.21 -0.46
































Sheet 2: Week 2
RESTAURANT PROFIT AND LOSS STATEMENT


















SHAREHOLDER SCORES


WEEK 2 COMMENCING













Sales
13,134.00








Costs
9,361.00








Net Profit
3,773.00








Net Profit %
28.73 %








Food Gross Profit Margin
72.74 %








Beverage Gross Profit Margin
74.63 %















































COVER DATA Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Breakfast 1,500 1,350 1,480 150.00 20.00




Lunch 112 150 146 -38.00 -34.00




Dinner 650 800 730 -150.00 -80.00

















COVER DATA TOTAL 2,262 2,300 2,356 -38.00 -94.00

















SALES Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Food - Breakfast 3,645.00 4,351.00 3,975.00 -706.00 -330.00




Food - Lunch 2,494.00 2,148.00 2,541.00 346.00 -47.00




Food - Dinner 2,441.00 2,681.00 2,514.00 -240.00 -73.00




Bev 4,143.00 4,110.00 5,147.00 33.00 -1,004.00




Other 411.00 651.00 354.00 -240.00 57.00

















SALES TOTAL 13,134.00 13,941.00 14,531.00 -807.00 -1,397.00

















COSTS Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Managers Salary 800.00 800.00 800.00 - -




Kitchen Labour Cost 1,450.00 1,450.00 1,450.00 - -




Bar Labour Cost 950.00 950.00 950.00 - -




Breakfast Labour Cost 1,200.00 1,200.00 1,200.00 - -




Dinner Labour Cost 1,750.00 1,750.00 1,750.00 - -




Other Labour Cost - - - - -




Food Inventory Opening 3,000.00 2,651.00 3,000.00 -349.00 -




Food Cost 2,451.00 2,401.00 2,451.00 -50.00 -




Food Inventory Closing 3,240.00 2,822.00 3,140.00 -418.00 -100.00




Beverage Inventory Opening 1,744.00 1,845.00 1,914.00 101.00 170.00




Beverage Cost 1,051.00 1,101.00 1,051.00 50.00 -




Beverage Inventory Closing 1,825.00 1,745.00 1,901.00 -80.00 76.00




Cleaning Materials - - - - -




Glassware and Cutlery - - - - -




Kitchen Replacement - - - - -




Guest Supplies - - - - -




Printing and Stationary 30.00 40.00 - 10.00 -30.00




Miscellaneous - - - - -




Music & Entertainment - - - - -




Equipment Hire - - - - -

















COSTS TOTAL 9,361.00 9,621.00 9,525.00 260.00 164.00

















COSTS SHARE DISTRIBUTION Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Food cost 2,451.00 2,401.00 2,451.00 -50.00 -




Food GP% 72.74 % 75.58 % 73.88 % 2.84 % 1.14 %




Beverage cost 1,051.00 1,101.00 1,051.00 50.00 -




Beverage GP% 74.63 % 73.21 % 79.58 % -1.42 % 4.95 %




Labour cost 6,150.00 6,150.00 6,150.00 - -




Labour cost % 46.83 % 44.11 % 42.32 % -2.71 % -4.50 %




Other cost 30.00 40.00 - 10.00 -30.00




Other cost % 0.23 % 0.29 % 0.00 % 0.06 % -0.23 %






























AVERAGE SALE PER COVER Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Beverage 5.44 4.33 5.88 1.11 -0.44




Dinner 6.48 5.08 5.77 1.39 0.71




Breakfast 2.43 3.22 2.69 -0.79 -0.26






























NET PROFIT Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Net Profit 3,773.00 4,320.00 5,006.00 -547.00 -1,233.00




Net Profit % 28.73 % 30.99 % 34.45 % -0.02 -0.06




Net Profit Per Cover 1.67 1.88 2.12 -0.21 -0.46
































Sheet 3: Week 3
RESTAURANT PROFIT AND LOSS STATEMENT


















SHAREHOLDER SCORES


WEEK 3 COMMENCING













Sales
13,134.00








Costs
9,361.00








Net Profit
3,773.00








Net Profit %
28.73 %








Food Gross Profit Margin
72.74 %








Beverage Gross Profit Margin
74.63 %















































COVER DATA Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Breakfast 1,500 1,350 1,480 150.00 20.00




Lunch 112 150 146 -38.00 -34.00




Dinner 650 800 730 -150.00 -80.00

















COVER DATA TOTAL 2,262 2,300 2,356 -38.00 -94.00

















SALES Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Food - Breakfast 3,645.00 4,351.00 3,975.00 -706.00 -330.00




Food - Lunch 2,494.00 2,148.00 2,541.00 346.00 -47.00




Food - Dinner 2,441.00 2,681.00 2,514.00 -240.00 -73.00




Bev 4,143.00 4,110.00 5,147.00 33.00 -1,004.00




Other 411.00 651.00 354.00 -240.00 57.00

















SALES TOTAL 13,134.00 13,941.00 14,531.00 -807.00 -1,397.00

















COSTS Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Managers Salary 800.00 800.00 800.00 - -




Kitchen Labour Cost 1,450.00 1,450.00 1,450.00 - -




Bar Labour Cost 950.00 950.00 950.00 - -




Breakfast Labour Cost 1,200.00 1,200.00 1,200.00 - -




Dinner Labour Cost 1,750.00 1,750.00 1,750.00 - -




Other Labour Cost - - - - -




Food Inventory Opening 3,000.00 2,651.00 3,000.00 -349.00 -




Food Cost 2,451.00 2,401.00 2,451.00 -50.00 -




Food Inventory Closing 3,240.00 2,822.00 3,140.00 -418.00 -100.00




Beverage Inventory Opening 1,744.00 1,845.00 1,914.00 101.00 170.00




Beverage Cost 1,051.00 1,101.00 1,051.00 50.00 -




Beverage Inventory Closing 1,825.00 1,745.00 1,901.00 -80.00 76.00




Cleaning Materials - - - - -




Glassware and Cutlery - - - - -




Kitchen Replacement - - - - -




Guest Supplies - - - - -




Printing and Stationary 30.00 40.00 - 10.00 -30.00




Miscellaneous - - - - -




Music & Entertainment - - - - -




Equipment Hire - - - - -

















COSTS TOTAL 9,361.00 9,621.00 9,525.00 260.00 164.00

















COSTS SHARE DISTRIBUTION Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Food cost 2,451.00 2,401.00 2,451.00 -50.00 -




Food GP% 72.74 % 75.58 % 73.88 % 2.84 % 1.14 %




Beverage cost 1,051.00 1,101.00 1,051.00 50.00 -




Beverage GP% 74.63 % 73.21 % 79.58 % -1.42 % 4.95 %




Labour cost 6,150.00 6,150.00 6,150.00 - -




Labour cost % 46.83 % 44.11 % 42.32 % -2.71 % -4.50 %




Other cost 30.00 40.00 - 10.00 -30.00




Other cost % 0.23 % 0.29 % 0.00 % 0.06 % -0.23 %






























AVERAGE SALE PER COVER Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Beverage 5.44 4.33 5.88 1.11 -0.44




Dinner 6.48 5.08 5.77 1.39 0.71




Breakfast 2.43 3.22 2.69 -0.79 -0.26






























NET PROFIT Actual Budget Last Year Var vs. Budget Var vs. Last Year

















Net Profit 3,773.00 4,320.00 5,006.00 -547.00 -1,233.00




Net Profit % 28.73 % 30.99 % 34.45 % -0.02 -0.06




Net Profit Per Cover 1.67 1.88 2.12 -0.21 -0.46
































The words contained in this file might help you see if this file matches what you are looking for:

...Sheet week restaurant profit and loss statement shareholder scores commencing sales costs net food gross margin beverage cover data actual budget last year var vs breakfast lunch dinner total bev other managers salary kitchen labour cost bar inventory opening closing cleaning materials glassware cutlery replacement guest supplies printing stationary miscellaneous music amp entertainment equipment hire share distribution gp average sale per...

no reviews yet
Please Login to review.