FINANCIAL REPORTING - PROFIT & LOSS ACCOUNT (CK) Hotel Golden Well 2018 CURRENT MONTH YEAR TO DATE ACTUAL FORECAST LAST YEAR ACTUAL FORECAST LAST YEAR CZK % CZK % CZK % CZK % CZK % CZK % 65.03% 67.60% 67.23% room ocupancy 45.15% 51.30% 52.10% 383 398 396 rooms sold "1,295" "1,472" "1,495" "6,770" "7,795" "7,791" average roomrate "6,049" "6,265" "6,438" "4,402" "5,267" "5,238" RevPAR "2,731" "3,335" "3,355" "2,592,796" 34.03% "3,102,311" 41.17% "3,085,305" 37.22% REVENUE ROOMS "7,833,954" 35.68% "9,566,992" 42.19% "9,625,328" 38.26% "4,421,039" 58.03% "4,289,000" 56.91% "4,682,538" 56.48% F&B "12,573,134" 57.27% "12,684,000" 55.93% "14,010,915" 55.69% "604,205" 7.93% "144,850" 1.92% "522,420" 6.30% OTHER "1,548,826" 7.05% "427,150" 1.88% "1,521,014" 6.05% "7,618,040" 100.00% "7,536,161" 100.00% "8,290,263" 100.00% TOTAL REVENUE GW "21,955,914" 100.00% "22,678,142" 100.00% "25,157,257" 100.00% "862,502" 20.83% "1,138,490" 25.68% "1,106,907" 25.62% EXPENSES ROOMS "3,850,769" 21.57% "4,732,230" 26.83% "4,217,849" 24.70% "2,670,672" 64.50% "2,619,300" 59.08% "2,650,470" 61.35% F&B "10,371,261" 58.08% "9,901,724" 56.14% "10,242,049" 59.97% "88,246" 2.13% "211,700" 4.77% "119,881" 2.77% ADMINISTRATION "526,093" 2.95% "741,500" 4.20% "564,718" 3.31% "213,745" 5.16% "134,500" 3.03% "94,398" 2.19% SALES "692,511" 3.88% "613,500" 3.48% "507,888" 2.97% "305,638" 7.38% "329,550" 7.43% "348,599" 8.07% MAINTENANCE "2,415,571" 13.53% "1,647,750" 9.34% "1,545,735" 9.05% "4,140,803" 100.00% "4,433,540" 100.00% "4,320,255" 100.00% TOTAL EXPENSES "17,856,205" 100.00% "17,636,704" 100.00% "17,078,239" 100.00% "3,477,237" 45.64% "3,102,621" 41.17% "3,970,008" 47.89% GOP "4,099,709" 18.67% "5,041,438" 22.23% "8,079,018" 32.11% 0 45.64% 0 41.17% 0 47.89% 0 18.67% 0 22.23% 0 32.11% NON OPERATION REVENUE 1 0 "13,000" 0 NON OPERATION COST 0 "65,000" 0 "500,000" "500,000" "500,000" RENTAL "2,500,000" "2,500,000" "2,500,000" "-500,000" -6.56% "-513,000" -6.81% "-500,000" -6.03% TOTAL NON OPERATION "-2,500,000" -11.39% "-2,564,999" -11.31% "-2,500,000" -9.94% "2,977,237" 39.08% "2,589,621" 34.36% "3,470,008" 41.86% EBITDA "1,599,709" 7.29% "2,476,439" 10.92% "5,579,018" 22.18% ##### Sheet/List 2 ##### FINANCIAL REPORTING - PROFIT & LOSS ACCOUNT (CK) Hotel Golden Well 2018 CURRENT MONTH YEAR TO DATE ACTUAL FORECAST LAST YEAR ACTUAL FORECAST LAST YEAR CZK % CZK % CZK % CZK % CZK % CZK % 589 589 589 number of rooms "2,869" "2,869" "2,869" 65% 68% 67% room occupancy 45% 51% 52% 383 398 396 rooms sold "1,295" "1,472" "1,495" 739 716 780 "number of guest (1,55)" "2,326" "2,655" "2,815" "6,770" "7,795" "7,791" average roomrate "6,049" "6,265" "6,438" "4,402" "5,267" "5,238" RevPAR "2,731" "3,335" "3,355" "2,592,796" 81.10% "3,102,311" 95.54% "3,085,305" 85.52% Rooms Revenue "7,833,954" 83.49% "9,566,992" 95.73% "9,625,328" 86.35% "78,440" 2.45% "54,000 " 1.66% "11,656" 0.32% transport "226,009" 2.41% "187,000" 1.87% "16,174" 0.15% 0.00% 50 0.00% 0.00% telecomunication - telefony 0.00% 250 0.00% 0.00% "447,233" 13.99% 0.00% "452,836" 12.55% fidelio "1,092,806" 11.65% 0.00% "1,331,644" 11.95% 0.00% 0.00% 0.00% concierge - vstupenky 0.00% 0.00% 0.00% "13,066" 0.41% "17,000 " 0.52% "14,533" 0.40% laundry "18,574" 0.20% "44,000" 0.44% "37,521" 0.34% "12,405" 0.39% "27,800 " 0.86% "24,157" 0.67% parking "31,992" 0.34% "72,400" 0.72% "69,207" 0.62% "53,061" 1.66% "46,000 " 1.42% "19,238" 0.53% other "177,805" 1.90% "123,500" 1.24% "62,977" 0.57% masaze "1,640" "3,491" "604,205" 18.90% "144,850" 4.46% "522,420" 14.48% Other Revenue "1,548,826" 16.51% "427,150" 4.27% "1,521,014" 13.65% "3,197,001" 100.00% "3,247,161" 100.00% "3,607,725" 100.00% GW Rooms Revenue "9,382,780" 100.00% "9,994,142" 100.00% "11,146,342" 100.00% NON OPERATION REVENUE ##### Sheet/List 3 ##### FINANCIAL REPORTING - PROFIT & LOSS ACCOUNT (CK) Hotel Golden Well 2018 CURRENT MONTH YEAR TO DATE ACTUAL FORECAST LAST YEAR ACTUAL FORECAST LAST YEAR CZK % CZK % CZK % CZK % CZK % CZK % "492,675 " 57.12% "579,190 " 50.87% "486,762 " 43.97% Payroll Golden Well "2,498,264 " 64.88% "2,781,830 " 58.78% "2,480,808 " 58.82% "293,165 " 33.99% "355,500 " 31.23% "366,952 " 33.15% Other expenses Front Desk "980,252 " 25.46% "1,304,300 " 27.56% "1,112,264 " 26.37% "76,662 " 8.89% "203,800 " 17.90% "253,193 " 22.87% Housekeeping "372,253 " 9.67% "646,100 " 13.65% "624,777 " 14.81% 0 0.00% 0 0.00% 0 0.00% Concierge 0 0.00% 0 0.00% 0 0.00% 0 0.00% 0 0.00% 0 0.00% Fitness 0 0.00% 0 0.00% 0 0.00% "369,827 " 42.88% "559,300 " 49.13% "620,145 " 56.03% Total other expenses "1,352,505 " 35.12% "1,950,400 " 41.22% "1,737,041 " 41.18% "862,502 " 100.00% "1,138,490 " 100.00% "1,106,907 " 100.00% Total Expenses "3,850,769 " 100.00% "4,732,230 " 100.00% "4,217,849 " 100.00% "2,334,499 " 73.02% "2,108,671 " 64.94% "2,500,818 " 69.32% Department profit (loss) "5,532,011 " 58.96% "5,261,912 " 52.65% "6,928,493 " 62.16% FrontOffice "193,382 " 30.78% "205,000 " 30.27% "155,255 " 24.67% payroll cost salaries and wages "933,052 " 36.73% "1,025,000 " 35.61% "836,226 " 34.15% "57,661 " 9.18% "71,750 " 10.59% "52,788 " 8.39% related expenses "282,931 " 11.14% "358,750 " 12.47% "282,977 " 11.56% "83,990 " 13.37% "45,000 " 6.64% "54,370 " 8.64% external contractors "343,990 " 13.54% "190,000 " 6.60% "217,375 " 8.88% "335,033 " 53.33% "321,750 " 47.51% "262,413 " 41.69% total "1,559,973 " 61.41% "1,573,750 " 54.68% "1,336,578 " 54.58% "89,068 " 14.18% "150,000 " 22.15% "199,921 " 31.77% other expenses provision - komise "338,687 " 13.33% "534,000 " 18.55% "563,682 " 23.02% "12,220 " 1.95% "6,500 " 0.96% "-3,309 " -0.53% spotreba materialu "31,947 " 1.26% "27,300 " 0.95% "14,492 " 0.59% "90,201 " 14.36% "107,000 " 15.80% "94,756 " 15.06% "caj o pate, VIP" "332,456 " 13.09% "366,000 " 12.72% "394,410 " 16.11% "78,131 " 12.44% "54,000 " 7.97% "1,178 " 0.19% transport "212,745 " 8.38% "187,000 " 6.50% "2,983 " 0.12% 0.00% 0.00% 0.00% Cost of sales - tickets 0.00% 0.00% 0.00% 0.00% "1,000 " 0.15% 0.00% DVD + CD 0.00% "5,000 " 0.17% 0.00% "3,974 " 0.63% "7,000 " 1.03% "1,086 " 0.17% drobný inventář "6,627 " 0.26% "35,000 " 1.22% "1,086 " 0.04% "6,000 " 0.96% "3,000 " 0.44% "9,000 " 1.43% "průvodcovské služby, repre" "6,000 " 0.24% "15,000 " 0.52% "12,000 " 0.49% 0.00% 0.00% 0.00% parkovné 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% masáže 0.00% 0.00% 0.00% "3,522 " 0.56% "6,000 " 0.89% "4,943 " 0.79% printing and stationery "16,232 " 0.64% "30,000 " 1.04% "18,378 " 0.75% 0.00% 0.00% 0.00% repairs and maintainance 0.00% 0.00% 0.00% "1,858 " 0.30% "4,000 " 0.59% "4,111 " 0.65% newspapers "10,485 " 0.41% "20,000 " 0.69% "16,709 " 0.68% 0.00% "2,000 " 0.30% "1,981 " 0.31% uniforms "3,000 " 0.12% "10,000 " 0.35% "1,981 " 0.08% "8,191 " 1.30% "15,000 " 2.21% "53,285 " 8.47% other expenses "22,073 " 0.87% "75,000 " 2.61% "86,543 " 3.53% "293,165 " 46.67% "355,500 " 52.49% "366,952 " 58.31% Total other expenses "980,252 " 38.59% "1,304,300 " 45.32% "1,112,264 " 45.42% "628,198 " 100.00% "677,250 " 100.00% "629,365 " 100.00% Total Expenses - Front Office "2,540,225 " 100.00% "2,878,050 " 100.00% "2,448,842 " 100.00% Housekeeping "118,396 " 50.53% "166,000 " 35.99% "134,104 " 28.08% payroll cost salaries and wages "514,360 " 39.25% "812,000 " 43.79% "765,793 " 43.29% "39,246 " 16.75% "56,440 " 12.24% "45,595 " 9.55% related expenses "170,456 " 13.01% "276,080 " 14.89% "260,067 " 14.70% 0.00% 0.00% 0.00% external contractors 0.00% 0.00% 0.00% 0.00% "35,000 " 7.59% "44,650 " 9.35% outside contractors - úklid "253,475 " 19.34% "120,000 " 6.47% "118,370 " 6.69% "157,642 " 67.28% "257,440 " 55.81% "224,349 " 46.98% total "938,291 " 71.60% "1,208,080 " 65.15% "1,144,230 " 64.68% "5,430 " 2.32% "55,000 " 11.92% "103,909 " 21.76% other expenses guest supplies "65,017 " 4.96% "160,000 " 8.63% "202,315 " 11.44% "12,034 " 5.14% "20,000 " 4.34% "14,567 " 3.05% cleaning supplies "50,241 " 3.83% "73,000 " 3.94% "62,420 " 3.53% "12,217 " 5.21% "30,000 " 6.50% "24,762 " 5.19% flowers and decoration "79,107 " 6.04% "83,000 " 4.48% "88,362 " 5.00% 0.00% "6,000 " 1.30% "63,078 " 13.21% equipment - drobný inventář "33,764 " 2.58% "30,000 " 1.62% "91,108 " 5.15% 0.00% "13,000 " 2.82% 0.00% linen "1,580 " 0.12% "65,000 " 3.51% "4,100 " 0.23% "35,142 " 15.00% "35,000 " 7.59% "35,368 " 7.41% laundry service "111,403 " 8.50% "135,000 " 7.28% "134,480 " 7.60% 0.00% 0.00% 0.00% printing and stationery 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% repairs and maintainance 946 0.07% 0.00% "2,602 " 0.15% 0.00% "30,000 " 6.50% 743 0.16% uniforms 0.00% "38,000 " 2.05% "4,211 " 0.24% "10,220 " 4.36% "7,800 " 1.69% "5,080 " 1.06% food + bevarage "20,624 " 1.57% "27,100 " 1.46% "11,628 " 0.66% 437 0.19% "4,000 " 0.87% "4,747 " 0.99% material consumption "6,985 " 0.53% "20,000 " 1.08% "20,306 " 1.15% "1,182 " 0.50% "3,000 " 0.65% 939 0.20% other expenses "2,586 " 0.20% "15,000 " 0.81% "3,245 " 0.18% "76,662 " 32.72% "203,800 " 44.19% "253,193 " 53.02% Total other expenses "372,253 " 28.40% "646,100 " 34.85% "624,777 " 35.32% "234,304 " 100.00% "461,240 " 100.00% "477,542 " 100.00% Total Expenses - Housekeeping "1,310,544 " 100.00% "1,854,180 " 100.00% "1,769,007 " 100.00% Concierge payroll cost salaries and wages related expenses external contractors 0 0.00% 0 #DIV/0! 0 0.00% total 0 0.00% 0 #DIV/0! 0 0.00% other expenses cost of sales (tickets etc) 95% uniforms DVD + CD printing and stationery other expenses 0 0.00% 0 #DIV/0! 0 0.00% Total other expenses 0 0.00% 0 #DIV/0! 0 0.00% 0 0.00% 0 #DIV/0! 0 0.00% Total Expenses - Concierge 0 0.00% 0 #DIV/0! 0 0.00% Fitness payroll cost salaries and wages related expenses external contractors 0 0.00% 0 #DIV/0! 0 0.00% total 0 0.00% 0 #DIV/0! 0 0.00% other expenses material consumotion cleaning supplies linen uniforms repairs and maintainance equipment laundry massage other expenses 0 0.00% 0 #DIV/0! 0 0.00% Total other expenses 0 0.00% 0 #DIV/0! 0 0.00% 0 0.00% 0 #DIV/0! 0 0.00% Total Expenses - Fitness 0 0.00% 0 #DIV/0! 0 0.00% ##### Sheet/List 4 ##### FINANCIAL REPORTING - PROFIT & LOSS ACCOUNT (CK) Hotel Golden Well 2018 CURRENT MONTH YEAR TO DATE ACTUAL FORECAST LAST YEAR ACTUAL FORECAST LAST YEAR CZK % CZK % CZK % CZK % CZK % CZK % 0.00% 0.00% 0.00% payroll cost salaries and wages 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% related expenses 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% external contractors 0.00% 0.00% 0.00% 0 0.00% 0 0.00% 0 0.00% total payroll 0 0.00% 0 0.00% 0 0.00% "33,400 " 37.85% "37,000 " 17.48% "31,750 " 26.48% other expenses auditors/consultants "168,500 " 32.03% "185,000 " 24.95% "156,200 " 27.66% "2,000 " 2.27% "2,500 " 1.18% "2,000 " 1.67% bank fees "8,000 " 1.52% "12,500 " 1.69% "10,075 " 1.78% "36,742 " 41.64% "130,000 " 61.41% "52,878 " 44.11% CC comission "271,467 " 51.60% "385,000 " 51.92% "293,491 " 51.97% "3,186 " 3.61% "5,000 " 2.36% "3,707 " 3.09% exchange lost "8,116 " 1.54% "25,000 " 3.37% "10,563 " 1.87% 291 0.33% 0.00% "1,266 " 1.06% spotreba materialu "5,625 " 1.07% 0.00% "3,211 " 0.57% 0.00% 0.00% 0.00% "other insurance,urad prace" 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% PHM (pohonné hmoty) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% rent Karmelitská 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% energy Karmelitská 0.00% 0.00% 0.00% 0.00% "3,000 " 1.42% 0.00% TV + Radio fees "11,205 " 2.13% "15,000 " 2.02% 0.00% "9,600 " 10.88% "15,000 " 7.09% "10,980 " 9.16% poplatky magistrat "40,170 " 7.64% "53,000 " 7.15% "47,454 " 8.40% 0.00% "10,000 " 4.72% 0.00% pronájem zahrady 0.00% "20,000 " 2.70% 0.00% "1,278 " 1.45% "2,000 " 0.94% "2,978 " 2.48% postage "3,628 " 0.69% "10,000 " 1.35% "5,734 " 1.02% "1,740 " 1.97% "1,000 " 0.47% 0.00% printing and stationery "4,152 " 0.79% "5,000 " 0.67% 0.00% 0.00% 200 0.09% 0.00% representation cost 0.00% "1,000 " 0.13% 0.00% 0.00% 0.00% 0.00% staff training 0.00% 0.00% 0.00% 0.00% "4,000 " 1.89% "14,208 " 11.85% "OSA, Integram, OAZA" 0.00% "20,000 " 2.70% "33,345 " 5.90% 0.00% 0.00% 0.00% uniformy 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% neuznané náklady 0.00% 0.00% 0.00% 9 0.01% "2,000 " 0.94% 114 0.10% other expenses "5,230 " 0.99% "10,000 " 1.35% "4,645 " 0.82% "88,246 " 100.00% "211,700 " 100.00% "119,881 " 100.00% Total Other Expenses "526,093 " 100.00% "741,500 " 100.00% "564,718 " 100.00% "88,246 " 100.00% "211,700 " 100.00% "119,881 " 100.00% TOTAL ADMINISTRATION EXPENSES "526,093 " 100.00% "741,500 " 100.00% "564,718 " 100.00% #DIV/0! 0.00% #DIV/0! other expenses #DIV/0! 0.00% #DIV/0! #DIV/0! 0.00% #DIV/0! "odpisy, investice" #DIV/0! 0.00% #DIV/0! #DIV/0! "13,000 " 100.00% #DIV/0! building insurance #DIV/0! "65,000 " 100.00% #DIV/0! 0 #DIV/0! "13,000 " 100.00% 0 #DIV/0! TOTAL NON OPERATION COST 0 #DIV/0! "65,000 " 100.00% 0 #DIV/0! ##### Sheet/List 5 ##### FINANCIAL REPORTING - PROFIT & LOSS ACCOUNT (CK) Hotel Golden Well 2018 CURRENT MONTH YEAR TO DATE ACTUAL FORECAST LAST YEAR ACTUAL FORECAST LAST YEAR CZK % CZK % CZK % CZK % CZK % CZK % "53,121" 17.38% "53,000" 16.08% "48,560" 13.93% Payroll cost salaries and wages "254,112" 10.52% "265,000" 16.08% "241,722" 15.64% "18,062" 5.91% "18,550" 5.63% "16,511" 4.74% related expenses "86,401" 3.58% "92,750" 5.63% "82,188" 5.32% 0.00% 0.00% 0.00% external contractors 0.00% 0.00% 0.00% "71,183" 23.29% "71,550" 21.71% "65,071" 18.67% Total "340,513" 14.10% "357,750" 21.71% "323,910" 20.96% Other Expenses 0.00% "8,000" 2.43% "6,500" 1.86% elevators "61,975" 2.57% "40,000" 2.43% "32,500" 2.10% "2,785" 0.91% "10,000" 3.03% "9,981" 2.86% telephones "38,381" 1.59% "50,000" 3.03% "38,510" 2.49% 0.00% 0.00% 0.00% global satelite systems 0.00% 0.00% 0.00% "12,432" 4.07% "10,000" 3.03% "11,998" 3.44% garbage removal "53,924" 2.23% "50,000" 3.03% "48,273" 3.12% 0.00% 0.00% 0.00% painting 0.00% 0.00% 0.00% 0.00% 500 0.15% "3,350" 0.96% printing and stationery "6,810" 0.28% "2,500" 0.15% "3,350" 0.22% "20,178" 6.60% "35,000" 10.62% "49,320" 14.15% repairs end maintanance "957,231" 39.63% "175,000" 10.62% "158,412" 10.25% 0.00% 500 0.15% "1,000" 0.29% uniforms 0.00% "2,500" 0.15% "1,000" 0.06% "13,901" 4.55% "2,000" 0.61% "7,200" 2.07% revize a kontroly "76,889" 3.18% "10,000" 0.61% "10,200" 0.66% 0.00% "15,000" 4.55% "58,762" 16.86% equipment - drobný inventář "45,538" 1.89% "75,000" 4.55% "121,698" 7.87% "5,495" 1.80% "16,000" 4.86% "18,570" 5.33% material consumption "82,595" 3.42% "80,000" 4.86% "81,560" 5.28% "8,458" 2.77% "9,000" 2.73% "8,458" 2.43% WAM Fidelio Kapsch Incad IT - monthly fee "39,634" 1.64% "45,000" 2.73% "33,834" 2.19% "6,000" 1.96% "7,000" 2.12% "6,000" 1.72% Creative IT outsourcing + software "30,000" 1.24% "35,000" 2.12% "30,000" 1.94% 0.00% "5,000" 1.52% "9,676" 2.78% other expenses "4,539" 0.19% "25,000" 1.52% "27,985" 1.81% "69,249" 22.66% "118,000" 35.81% "190,815" 54.74% Total Other expenses "1,397,516" 57.85% "590,000" 35.81% "587,322" 38.00% "105,206" 34.42% "110,000" 33.38% "92,713" 26.60% Utilities electricity "495,548" 20.51% "550,000" 33.38% "488,997" 31.64% 0.00% 0.00% 0.00% gas 0.00% 0.00% 0.00% "60,000" 19.63% "30,000" 9.10% 0.00% water "181,994" 7.53% "150,000" 9.10% "145,506" 9.41% "165,206" 54.05% "140,000" 42.48% "92,713" 26.60% Total "677,542" 28.05% "700,000" 42.48% "634,503" 41.05% "305,638" 100.00% "329,550" 100.00% "348,599" 100.00% Total Expenses - Maintenance & IT "2,415,571" 100.00% "1,647,750" 100.00% "1,545,735" 100.00% ##### Sheet/List 6 ##### FINANCIAL REPORTING - PROFIT & LOSS ACCOUNT (CK) Hotel Golden Well 2018 CURRENT MONTH YEAR TO DATE ACTUAL FORECAST LAST YEAR ACTUAL FORECAST LAST YEAR CZK % CZK % CZK % CZK % CZK % CZK % 0.00% "7,500 " 5.58% "10,000" 10.59% Payroll cost salaries and wages 0.00% "37,500" 6.11% "40,000" 7.88% 0.00% 0.00% 0.00% related expenses 0.00% 0.00% 0.00% 0.00% "8,000 " 5.95% 0.00% external contractors 0.00% "40,000" 6.52% 0.00% 0 0.00% "15,500" 11.52% "10,000" 10.59% Total 0 0.00% "77,500" 12.63% "40,000" 7.88% 0.00% "10,000" 7.43% 0.00% Other expenses advertising 0.00% "20,000" 3.26% 0.00% 0.00% 0.00% 0.00% repre 0.00% 0.00% 0.00% "69,178" 32.36% "32,000" 23.79% "29,721" 31.48% GDS - Campaign "246,593" 35.61% "160,000" 26.08% "172,060" 33.88% "54,403" 25.45% "24,000" 17.84% "17,028" 18.04% PPC - Campaign "129,879" 18.75% "120,000" 19.56% "118,945" 23.42% "61,493" 28.77% "25,000" 18.59% "37,274" 39.49% internet / web "218,815" 31.60% "125,000" 20.37% "174,508" 34.36% "6,508" 3.04% "15,000" 11.15% 375 0.40% memberships "28,360" 4.10% "75,000" 12.22% 375 0.07% 0.00% "3,000" 2.23% 0.00% printing and stationary 0.00% "6,000" 0.98% 0.00% 0.00% 0.00% 0.00% social media and networks 0.00% 0.00% 0.00% "10,416" 4.87% "5,000" 3.72% 0.00% promotional materials "29,556" 4.27% "20,000" 3.26% 0.00% 0.00% 0.00% 0.00% trade shows + travel expenses 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% uniforms 0.00% 0.00% 0.00% "11,747" 5.50% "5,000" 3.72% 0.00% other expenses "39,308" 5.68% "10,000" 1.63% "2,000" 0.39% "213,745 " 100.00% "119,000 " 88.48% "84,398 " 89.41% Total Other expenses "692,511 " 100.00% "536,000 " 87.37% "467,888 " 92.12% "213,745 " 100.00% "134,500 " 100.00% "94,398 " 100.00% Total Expenses - Sales "692,511 " 100.00% "613,500 " 100.00% "507,888 " 100.00% ##### Sheet/List 7 ##### FINANCIAL REPORTING - PROFIT & LOSS ACCOUNT (CK) Hotel Golden Well 2018 CURRENT MONTH YEAR TO DATE ACTUAL FORECAST LAST YEAR ACTUAL FORECAST LAST YEAR CZK % CZK % CZK % CZK % CZK % CZK % "4,414,569" 99.85% "2,950,000" 68.78% "4,675,703" 99.85% Food "12,542,177" 99.75% "8,768,500" 69.13% "13,977,941" 99.76% 0.00% "1,320,000" 30.78% 0.00% Beverage 0.00% "3,846,500" 30.33% 0.00% 0.00% "14,000" 0.33% 0.00% Minibar 0.00% "47,000" 0.37% 0.00% 0.00% "1,000" 0.02% 0.00% Tobacco 0.00% "5,000" 0.04% 0.00% 0.00% "4,000" 0.09% 0.00% Storno poplatky 0.00% "17,000" 0.13% 0.00% "6,470" 0.15% 0.00% "6,835" 0.15% "Other Revenue, Personalky" "30,957" 0.25% 0.00% "32,974" 0.24% "4,421,039 " 100.00% "4,289,000 " 100.00% "4,682,538 " 100.00% Total F&B "12,573,134 " 100.00% "12,684,000 " 100.00% "14,010,915 " 100.00% cost % "1,028,493" 38.51% "926,300" 31.40% "914,134" 34.49% Cost of sales food cost (30%) "3,656,999" 35.26% "2,753,309" 31.40% "3,477,913" 33.96% "418,592" 15.67% "409,200" 31.00% "500,516" 18.88% beverage cost (28%) "1,174,321" 11.32% "1,192,415" 31.00% "1,413,177" 13.80% "8,338" 0.31% "5,600" 0.21% "4,505" 0.17% food cost (minibary) "17,111" 0.16% "18,800" 0.19% "20,451" 0.20% 0.00% 400 0.02% 0.00% tobacco (90%) 0.00% "2,000" 0.02% 0.00% "12,350" 0.00% 0.00% "12,830" 0.00% other (personalka) "51,370" 0.00% 0.00% "55,910" 0.00% 0.00% 0.00% 0.00% 0 0.00% 0.00% 0 0.00% "1,467,773 " 54.96% "1,341,500 " 51.22% "1,431,985 " 54.03% Total Cost of Sales "4,899,801 " 47.24% "3,966,524 " 40.06% "4,967,451 " 48.50% "572,052" 21.42% "620,000" 23.67% "529,140" 19.96% payroll cost salaries and wages "2,724,078" 26.27% "2,980,000" 30.10% "2,428,140" 23.71% "156,842" 5.87% "210,800" 8.05% "169,028" 6.38% related expenses "785,304" 7.57% "1,013,200" 10.23% "797,854" 7.79% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 20% "255,576" 9.57% "195,000" 7.44% "207,600" 7.83% external contractors "1,026,111" 9.89% "890,000" 8.99% "971,299" 9.48% 0.00% "75,000" 2.86% "83,110" 3.14% outside contarctors - úklid "278,915" 2.69% "305,000" 3.08% "297,833" 2.91% "984,470 " 36.86% "1,100,800 " 42.03% "988,878 " 37.31% Total Payrol "4,814,408 " 46.42% "5,188,200 " 52.40% "4,495,126 " 43.89% 43.89% 0.00% 0.00% 0.00% Other cost breakage & spoilage 0.00% 0.00% 0.00% "26,104" 0.98% "37,000" 1.41% "37,587" 1.42% cleaning supplies "107,245" 1.03% "125,000" 1.26% "131,533" 1.28% "11,904" 0.45% "9,000" 0.34% "11,940" 0.45% "flowers, decoration" "39,631" 0.38% "45,000" 0.45% "40,394" 0.39% "3,777" 0.14% "12,000" 0.46% "52,041" 1.96% glass china silver "3,777" 0.04% "60,000" 0.61% "87,287" 0.85% "46,138" 1.73% "20,000" 0.76% "10,736" 0.41% spotřeba materiálu "101,291" 0.98% "100,000" 1.01% "68,138" 0.67% 0.00% "15,000" 0.57% "2,390" 0.09% drobný inventář "63,360" 0.61% "75,000" 0.76% "20,356" 0.20% "34,426" 1.29% "30,000" 1.15% "31,249" 1.18% laundry cost "96,777" 0.93% "92,000" 0.93% "100,758" 0.98% 0.00% "4,000" 0.15% 0.00% linen 0.00% "20,000" 0.20% "3,100" 0.03% 0.00% 0.00% 0.00% "maintenance, repairs" 0.00% 0.00% "104,165" 1.02% 0.00% 0.00% 0.00% "music,audit" 0.00% 0.00% 0.00% "40,466" 1.52% "10,000" 0.38% "8,208" 0.31% commisions - provize "88,956" 0.86% "50,000" 0.50% "8,372" 0.08% 0.00% "2,000" 0.08% 0.00% "printing, stationery" 0.00% "10,000" 0.10% 0.00% 0.00% 0.00% 0.00% newspapers - tisk 0.00% 0.00% 320 0.00% "4,400" 0.16% 0.00% 0.00% "zahrada, pronajem" "4,400" 0.04% 0.00% 0.00% 0.00% 0.00% 0.00% advertising - reklama 0.00% 0.00% "4,249" 0.04% "7,396" 0.28% "3,000" 0.11% "8,960" 0.34% uniforms "14,432" 0.14% "15,000" 0.15% "13,363" 0.13% "10,218" 0.38% "20,000" 0.76% "20,658" 0.78% repre "68,418" 0.66% "90,000" 0.91% "101,515" 0.99% "33,600" 1.26% "15,000" 0.57% "45,838" 1.73% other expenses "68,765" 0.66% "65,000" 0.66% "95,922" 0.94% "218,429 " 8.18% "177,000 " 6.76% "229,607 " 8.66% Total Other Cost "657,052 " 6.34% "747,000 " 7.54% "779,472 " 7.61% "2,670,672 " 100.00% "2,619,300 " 100.00% "2,650,470 " 100.00% Total F&B Expenses "10,371,261 " 100.00% "9,901,724 " 100.00% "10,242,049 " 100.00% "1,750,367 " 39.59% "1,669,700 " 38.93% "2,032,068 " 43.40% Department profit (loss) "2,201,873 " 17.51% "2,782,276 " 21.94% "3,768,866 " 26.90%