Golden Well - Room division - Budget 2018													
																			
	BUDGET		I	 II 	 III 	 IV 	 V 	 VI 	 VII 	 VIII 	 IX 	 X 	 XI 	 XII 	Total				
			 January 	 February 	 March 	 April 	 May 	 June 	 July 	 August 	 September 	 October 	 November 	 December 					
	number of rooms		589 	532 	589 	570 	589 	570 	589 	589 	570 	589 	570 	589 	"6,935 "				
	room ocupancy		22%	43%	54%	70%	68%	74%	71%	73%	82%	69%	51%	65%	62%				
	rooms sold		129 	230 	320 	398 	398 	420 	420 	430 	470 	405 	290 	380 	"4,290 "				
	"number of guest (1,8)"		232 	414 	576 	716 	716 	756 	756 	774 	846 	729 	522 	684 	"7,722 "				
	average roomrate		"5,830 "	"5,220 "	"5,830 "	"6,650 "	"7,795 "	"6,990 "	"6,480 "	"6,390 "	"7,650 "	"6,900 "	"5,200 "	"6,715 "	"6,471 "				
	RevPAR		"1,277 "	"2,257 "	"3,167 "	"4,643 "	"5,267 "	"5,150 "	"4,621 "	"4,665 "	"6,308 "	"4,744 "	"2,646 "	"4,333 "	"4,090 "				
	Rooms Revenue		"752,018 "	"1,200,514 "	"1,865,622 "	"2,646,527 "	"3,102,311 "	"2,935,632 "	"2,721,703 "	"2,747,885 "	"3,595,668 "	"2,794,475 "	"1,508,083 "	"2,551,853 "	"28,422,291 "				
																			
	transport		"17,000 "	"28,000 "	"39,000 "	"49,000 "	"54,000 "	"53,000 "	"54,000 "	"54,000 "	"61,000 "	"56,000 "	"41,000 "	"48,000 "	"554,000 "				
	telecomunication - telefony		50 	50 	50 	50 	50 	50 	50 	50 	50 	50 	50 	50 	600 				
	Fidelio														0 				
	concierge - vstupenky														0 				
	laundry		"2,600 "	"5,500 "	"6,900 "	"12,000 "	"17,000 "	"16,000 "	"15,000 "	"15,000 "	"17,000 "	"16,000 "	"9,000 "	"12,000 "	"144,000 "				
	parking		"4,400 "	"9,100 "	"11,500 "	"19,600 "	"27,800 "	"25,200 "	"24,600 "	"23,500 "	"27,600 "	"26,300 "	"14,400 "	"19,300 "	"233,300 "				
	other		"8,500 "	"16,000 "	"20,000 "	"33,000 "	"46,000 "	"42,000 "	"41,000 "	"39,000 "	"45,000 "	"44,000 "	"24,500 "	"32,000 "	"391,000 "				
															0 				
	Other Revenue		"32,550 "	"58,650 "	"77,450 "	"113,650 "	"144,850 "	"136,250 "	"134,650 "	"131,550 "	"150,650 "	"142,350 "	"88,950 "	"111,350 "	"1,322,900 "				
																			
	Golden Well Rooms Revenue		"784,568 "	"1,259,164 "	"1,943,072 "	"2,760,177 "	"3,247,161 "	"3,071,882 "	"2,856,353 "	"2,879,435 "	"3,746,318 "	"2,936,825 "	"1,597,033 "	"2,663,203 "	"29,745,191 "				
	MV NON OPERATION REVENUE														0 				
																			
																			
																			
	Payroll Golden Well		"536,150 "	"536,150 "	"551,150 "	"579,190 "	"579,190 "	"579,190 "	"579,190 "	"579,190 "	"592,690 "	"592,690 "	"572,690 "	"587,690 "	"6,865,160 "				
	Other expenses	Front Desk	"140,600 "	"205,200 "	"268,500 "	"334,500 "	"355,500 "	"351,500 "	"353,500 "	"353,500 "	"405,500 "	"369,500 "	"265,500 "	"317,500 "	"3,720,800 "				
		Housekeeping	"59,800 "	"108,500 "	"134,000 "	"140,000 "	"203,800 "	"163,800 "	"165,800 "	"135,000 "	"155,000 "	"155,000 "	"118,000 "	"129,000 "	"1,667,700 "				
		Concierge	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 				
		Fitness	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 				
	Total other expenses		"200,400 "	"313,700 "	"402,500 "	"474,500 "	"559,300 "	"515,300 "	"519,300 "	"488,500 "	"560,500 "	"524,500 "	"383,500 "	"446,500 "	"5,388,500 "				
	Total Expenses		"736,550 "	"849,850 "	"953,650 "	"1,053,690 "	"1,138,490 "	"1,094,490 "	"1,098,490 "	"1,067,690 "	"1,153,190 "	"1,117,190 "	"956,190 "	"1,034,190 "	"12,253,660 "				
																			
	Department profit (loss)		"48,018 "	"409,314 "	"989,422 "	"1,706,487 "	"2,108,671 "	"1,977,392 "	"1,757,863 "	"1,811,745 "	"2,593,128 "	"1,819,635 "	"640,843 "	"1,629,013 "	"17,491,531 "				
	Department profit (loss) %		6.12%	32.51%	50.92%	61.83%	64.94%	64.37%	61.54%	62.92%	69.22%	61.96%	40.13%	61.17%	58.80%				
																			
	FrontOffice																		
	payroll cost	salaries and wages	"205,000 "	"205,000 "	"205,000 "	"205,000 "	"205,000 "	"205,000 "	"205,000 "	"205,000 "	"215,000 "	"215,000 "	"215,000 "	"215,000 "	"2,500,000 "				
		related expenses	"71,750 "	"71,750 "	"71,750 "	"71,750 "	"71,750 "	"71,750 "	"71,750 "	"71,750 "	"75,250 "	"75,250 "	"75,250 "	"75,250 "	"875,000 "				
		external contractors	"30,000 "	"30,000 "	"40,000 "	"45,000 "	"45,000 "	"45,000 "	"45,000 "	"45,000 "	"45,000 "	"45,000 "	"40,000 "	"45,000 "	"500,000 "				
	total		"306,750 "	"306,750 "	"316,750 "	"321,750 "	"321,750 "	"321,750 "	"321,750 "	"321,750 "	"335,250 "	"335,250 "	"330,250 "	"335,250 "	"3,875,000 "				
	other expenses	provision - komise	"49,000 "	"80,000 "	"110,000 "	"145,000 "	"150,000 "	"150,000 "	"150,000 "	"150,000 "	"180,000 "	"160,000 "	"100,000 "	"130,000 "	"1,554,000 "				
		spotreba materialu	"2,600 "	"5,200 "	"6,500 "	"6,500 "	"6,500 "	"6,500 "	"6,500 "	"6,500 "	"6,500 "	"6,500 "	"6,500 "	"6,500 "	"72,800 "				
		"Caj o pate, VIP Lounge"	"34,000 "	"54,000 "	"75,000 "	"96,000 "	"107,000 "	"104,000 "	"105,000 "	"105,000 "	"120,000 "	"109,000 "	"80,000 "	"95,000 "	"1,084,000 "				
		transport	"17,000 "	"28,000 "	"39,000 "	"49,000 "	"54,000 "	"53,000 "	"54,000 "	"54,000 "	"61,000 "	"56,000 "	"41,000 "	"48,000 "	"554,000 "				
		Cost of sales - tickets													0 				
		DVD + CD	"1,000 "	"1,000 "	"1,000 "	"1,000 "	"1,000 "	"1,000 "	"1,000 "	"1,000 "	"1,000 "	"1,000 "	"1,000 "	"1,000 "	"12,000 "				
		drobný inventář	"7,000 "	"7,000 "	"7,000 "	"7,000 "	"7,000 "	"7,000 "	"7,000 "	"7,000 "	"7,000 "	"7,000 "	"7,000 "	"7,000 "	"84,000 "				
		"repre, pruvodcovske sluzby"	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"36,000 "				
		parkovné													0 				
		masáže													0 				
		printing and stationery	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"72,000 "				
		repairs and maintainance													0 				
		newspapers	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"48,000 "				
		uniforms	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"24,000 "				
		other expenses	"15,000 "	"15,000 "	"15,000 "	"15,000 "	"15,000 "	"15,000 "	"15,000 "	"15,000 "	"15,000 "	"15,000 "	"15,000 "	"15,000 "	"180,000 "				
	Total other expenses		"140,600 "	"205,200 "	"268,500 "	"334,500 "	"355,500 "	"351,500 "	"353,500 "	"353,500 "	"405,500 "	"369,500 "	"265,500 "	"317,500 "	"3,720,800 "				
	Total Expenses - Front Office		"447,350 "	"511,950 "	"585,250 "	"656,250 "	"677,250 "	"673,250 "	"675,250 "	"675,250 "	"740,750 "	"704,750 "	"595,750 "	"652,750 "	"7,595,800 "				
																			
	Housekeeping																		
	payroll cost	salaries and wages	"160,000 "	"160,000 "	"160,000 "	"166,000 "	"166,000 "	"166,000 "	"166,000 "	"166,000 "	"166,000 "	"166,000 "	"166,000 "	"166,000 "	"1,974,000 "				
		related expenses	"54,400 "	"54,400 "	"54,400 "	"56,440 "	"56,440 "	"56,440 "	"56,440 "	"56,440 "	"56,440 "	"56,440 "	"56,440 "	"56,440 "	"671,160 "				
		external contractors													0 				
		outside contractors - úklid	"15,000 "	"15,000 "	"20,000 "	"35,000 "	"35,000 "	"35,000 "	"35,000 "	"35,000 "	"35,000 "	"35,000 "	"20,000 "	"30,000 "	"345,000 "				
	total		"229,400 "	"229,400 "	"234,400 "	"257,440 "	"257,440 "	"257,440 "	"257,440 "	"257,440 "	"257,440 "	"257,440 "	"242,440 "	"252,440 "	"2,990,160 "				
	other expenses	guest supplies		"25,000 "	"45,000 "	"35,000 "	"55,000 "	"25,000 "	"55,000 "	"25,000 "	"45,000 "	"45,000 "	"30,000 "	"30,000 "	"415,000 "				
		cleaning supplies	"6,000 "	"12,000 "	"15,000 "	"20,000 "	"20,000 "	"20,000 "	"20,000 "	"20,000 "	"20,000 "	"20,000 "	"15,000 "	"15,000 "	"203,000 "				
		flowers and decoration	"8,000 "	"15,000 "	"15,000 "	"15,000 "	"30,000 "	"20,000 "	"20,000 "	"20,000 "	"20,000 "	"20,000 "	"15,000 "	"20,000 "	"218,000 "				
		drobny inventar - equipment	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"6,000 "	"72,000 "				
		linen	"13,000 "	"13,000 "	"13,000 "	"13,000 "	"13,000 "	"13,000 "	"13,000 "	"13,000 "	"13,000 "	"13,000 "	"13,000 "	"13,000 "	"156,000 "				
		laundry service	"15,000 "	"25,000 "	"25,000 "	"35,000 "	"35,000 "	"35,000 "	"35,000 "	"35,000 "	"35,000 "	"35,000 "	"25,000 "	"30,000 "	"365,000 "				
		printing and stationery (kc 5 pokoj)													0 				
		repairs and maintainance													0 				
		uniforms	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"30,000 "	"30,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"2,000 "	"80,000 "				
		"food + bevarage, rozestylka"	"2,800 "	"3,500 "	"6,000 "	"7,000 "	"7,800 "	"7,800 "	"7,800 "	"7,000 "	"7,000 "	"7,000 "	"5,000 "	"6,000 "	"74,700 "				
		material consumption	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"4,000 "	"48,000 "				
		other expenses	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"3,000 "	"36,000 "				
	Total other expenses		"59,800 "	"108,500 "	"134,000 "	"140,000 "	"203,800 "	"163,800 "	"165,800 "	"135,000 "	"155,000 "	"155,000 "	"118,000 "	"129,000 "	"1,667,700 "				
	Total Expenses - Housekeeping		"289,200 "	"337,900 "	"368,400 "	"397,440 "	"461,240 "	"421,240 "	"423,240 "	"392,440 "	"412,440 "	"412,440 "	"360,440 "	"381,440 "	"4,657,860 "				
																			
	Concierge																		
	payroll cost	salaries and wages													0 				
		related expenses													0 				
		external contractors													0 				
	total		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 				
	other expenses	cost of sales (tickets etc) 95%													0 				
		uniforms													0 				
		DVD + CD													0 				
		printing and stationery													0 				
		other expenses													0 				
	Total other expenses		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 				
	Total Expenses - Concierge		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 				
																			
	Fitness																		
	payroll cost	salaries and wages													0 				
		related expenses													0 				
		external contractors													0 				
	total		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 				
	other expenses	material consumotion													0 				
		cleaning supplies													0 				
		linen													0 				
		uniforms													0 				
		repairs and maintainance													0 				
		equipment													0 				
		laundry													0 				
		massage													0 				
		other expenses													0 				
	Total other expenses		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 				
	Total Expenses - Fitness		0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0 	0