TOTAL REVENU
P&L Teaching Hotel Chateau Bethlehem Consolidated € 98.445,16
2019 - 2020 July = revenu rooms + revenu food + revenu beverage + revenu Other + Total revenu minor operated
Month to Date (month end)
Actual % Budget Actual
€ 50.883,97 51,69% Revenue Rooms =26*0,614*102,82*31
=rooms*occupansy STR*ADR STR*days of the month
€ -19.529,08 -38,38% Labor Costs & Related =-4.921.43+-8.464.65+-6143,-
=(front office staff permanent)+(Housekeeping staff flex & permanent)+(front office staff flex)
€ 4.921,43 Front office staff permanent
€ -8.464,65 housekeeping staff flex & permanent
€ -6.143,00 Front office staff flex
€ -3.962,48 -7,79% Other expenses Rooms =50.883,97*-4%+-229,95+-1.788,12+-118,50
=(Revenu rooms*Average fees & commission rooms) + guest supplies, cleaning supplies and small assets rooms + linen & uniforms rooms + decoration & plants r
€ -2.035,36 Revenue rooms(A6)*average fees & commission rooms
€ -229,95 guest supplies, cleaning supplies and small assets rooms
€ -1.788,12 linen & uniforms rooms
€ 118,50 decoration & plants rooms
€ 27.392,41 53,83% Departmantal Profit Rooms =50.833,97+-19.529,08+-3.962,48
=revenue rooms + labor costs & related + other expenses rooms
€ 30.044,86 66,57% Revenue Food =total revenu food
€ 10.907,55 24,17% Revenu Beverage =(30.044,86 + 4.182,42)/75,8(=100-24,17)=451,547..*24,17
=(revenu food+revenue other)/75,8 (% vd totalrevenue F&B- % revenu beverage)= 451,547* 25:25% revenue beverage
€ 4.182,42 9,27% Revenue Other =Function room rental & setup charges
€ 45.134,83 100,00% Total Revenue F&B =30.044,86+10.907,55+4.182,42
=revenue food + revenue beverage + revenue other
€scroll down
-21.367,96 toLabor
-47,34% see Costs the full explenation
& Related =total labour costs & related F&B
=30.044,86*-36,66% +-29,33%*10.907,55
€scroll naar-31,49%
-14.213,13 beneden om de hele uitleg te bekijken
Cost of Sales F&B =revenue food*%costs of sales food + %costs of sales beverage*revenu beverage
=-5,76%*45.134,83
€ -2.601,01 -5,76% Other expenses F&B =45.134,83 + -21,367,96 + -14,213,13 + -2.601,01
=total revenu F&B + labor costs & related + costs of sales F&B + other expenses F&B
€ 6.952,73 15,40% Departmental Profit F&B =45.134,83 + -21.367,96 + -14.213,13 + -2.601,01
=total revenu F&B + labor costs & related + Cost of sales F&B + Other expenses F&B
€ 2.426,36 2,46% Total Revenue Minor Operated = 415.23 + 2.011.13
=revenu shop + bike and equipment rental, miscellaneous minor operated departments
€ -1.973,25 -81,33% Total Cost of Sales Minor Operated =total costs of sales minor operated departments
€ 453,11 18,67% Departmental Minor Operated = 2.426,36 + -1.973,25
= total revenu minor operated + total cost of sales minor operated
€ -10.938,42 -11,11% Labor Costs & Related Adminstration & General =administrative & general total laber costs & related
€ -2.381,97 -2,42% Other expensen A & G =administrative & general other expenses
€ -2.167,13 -2,20% Labor Costs & Related Property Operation & Maintanance =total labour costs & related property, operation & maintanance
€ -1.229,25 -1,25% Other expenses POM =regular & contract and other maintanance, housing provision
=-4.311,46 + -380,89
€ -4.692,35 -4,77% Labor Costs & Related Sales & Marketing =sales & marketing staff permanent + s&m staff flex
=-356,45 + -100,00 + -1,211,30
€ -1.667,75 -1,69% Other expenses S & M = advertisements + newsletters + PR, travel expenses and declaration (S&M) & license tourist board
€ -1.449,00 -1,47% Expenses Information & Telecommunication Systems =infomation & telecommunication systems ecenses
=98.445,16* -0,67%
€ -655,17 -0,67% Expenses Utilities =total revenu*gas, water and electricity expenses
€ -25.181,04 -25,58% Undistributed operating expenses =-10.938,42 + -2.381,97 + -2.167,13 + -1.229,25 + -4.692,35 + -1.667,75 + -1.449,00 + -655,17
P&L Teaching Hotel Chateau Bethlehem Consolidated € 98.445,16
2019 - 2020 July = revenu rooms + revenu food + revenu beverage + revenu Other + Total revenu minor operated
Month to Date (month end)
Actual % Budget Actual
€ 50.883,97 51,69% Revenue Rooms =26*0,614*102,82*31
=rooms*occupansy STR*ADR STR*days of the month
€ -19.529,08 -38,38% Labor Costs & Related =-4.921.43+-8.464.65+-6143,-
=(front office staff permanent)+(Housekeeping staff flex & permanent)+(front office staff flex)
€ 4.921,43 Front office staff permanent
€ -8.464,65 housekeeping staff flex & permanent
€ -6.143,00 Front office staff flex
€ -3.962,48 -7,79% Other expenses Rooms =50.883,97*-4%+-229,95+-1.788,12+-118,50
=(Revenu rooms*Average fees & commission rooms) + guest supplies, cleaning supplies and small assets rooms + linen & uniforms rooms + decoration & plants r
€ -2.035,36 Revenue rooms(A6)*average fees & commission rooms
€ -229,95 guest supplies, cleaning supplies and small assets rooms
€ -1.788,12 linen & uniforms rooms
€ 118,50 decoration & plants rooms
€ 27.392,41 53,83% Departmantal Profit Rooms =50.833,97+-19.529,08+-3.962,48
=revenue rooms + labor costs & related + other expenses rooms
€ 30.044,86 66,57% Revenue Food =total revenu food
€ 10.907,55 24,17% Revenu Beverage =(30.044,86 + 4.182,42)/75,8(=100-24,17)=451,547..*24,17
=(revenu food+revenue other)/75,8 (% vd totalrevenue F&B- % revenu beverage)= 451,547* 25:25% revenue beverage
€ 4.182,42 9,27% Revenue Other =Function room rental & setup charges
€ 45.134,83 100,00% Total Revenue F&B =30.044,86+10.907,55+4.182,42
=revenue food + revenue beverage + revenue other
€scroll down
-21.367,96 toLabor
-47,34% see Costs the full explenation
& Related =total labour costs & related F&B
=30.044,86*-36,66% +-29,33%*10.907,55
€scroll naar-31,49%
-14.213,13 beneden om de hele uitleg te bekijken
Cost of Sales F&B =revenue food*%costs of sales food + %costs of sales beverage*revenu beverage
=-5,76%*45.134,83
€ -2.601,01 -5,76% Other expenses F&B =45.134,83 + -21,367,96 + -14,213,13 + -2.601,01
=total revenu F&B + labor costs & related + costs of sales F&B + other expenses F&B
€ 6.952,73 15,40% Departmental Profit F&B =45.134,83 + -21.367,96 + -14.213,13 + -2.601,01
=total revenu F&B + labor costs & related + Cost of sales F&B + Other expenses F&B
€ 2.426,36 2,46% Total Revenue Minor Operated = 415.23 + 2.011.13
=revenu shop + bike and equipment rental, miscellaneous minor operated departments
€ -1.973,25 -81,33% Total Cost of Sales Minor Operated =total costs of sales minor operated departments
€ 453,11 18,67% Departmental Minor Operated = 2.426,36 + -1.973,25
= total revenu minor operated + total cost of sales minor operated
€ -10.938,42 -11,11% Labor Costs & Related Adminstration & General =administrative & general total laber costs & related
€ -2.381,97 -2,42% Other expensen A & G =administrative & general other expenses
€ -2.167,13 -2,20% Labor Costs & Related Property Operation & Maintanance =total labour costs & related property, operation & maintanance
€ -1.229,25 -1,25% Other expenses POM =regular & contract and other maintanance, housing provision
=-4.311,46 + -380,89
€ -4.692,35 -4,77% Labor Costs & Related Sales & Marketing =sales & marketing staff permanent + s&m staff flex
=-356,45 + -100,00 + -1,211,30
€ -1.667,75 -1,69% Other expenses S & M = advertisements + newsletters + PR, travel expenses and declaration (S&M) & license tourist board
€ -1.449,00 -1,47% Expenses Information & Telecommunication Systems =infomation & telecommunication systems ecenses
=98.445,16* -0,67%
€ -655,17 -0,67% Expenses Utilities =total revenu*gas, water and electricity expenses
€ -25.181,04 -25,58% Undistributed operating expenses =-10.938,42 + -2.381,97 + -2.167,13 + -1.229,25 + -4.692,35 + -1.667,75 + -1.449,00 + -655,17
