Conn O'Scannlain
Hotel at Ballynaraw South								Yes or No
					Gross Pay	Bonus	ER PRSI	Hol Prov	Holidays	ER Pension	Payroll	Cost excl		Allocation		Monthly Allocation of Cost excl Bonus
Rooms Division Payroll					per annum	p.a	10.50%	Required?	@ 8.33%	/Health etc	Cost p.a	Bonus		Check	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
Reception
Front Office Manager					25,000	2,000	2,835	no	0		29,835	27,835		OK	2,320	2,320	2,320	2,320	2,320	2,320	2,320	2,320	2,320	2,320	2,320	2,320	27,835
Receptionist					22,000	2,000	2,520	no	0		26,520	24,520		OK	2,043	2,043	2,043	2,043	2,043	2,043	2,043	2,043	2,043	2,043	2,043	2,043	24,520
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
INSERT EXTRA ROWS ABOVE THIS ONE														OK
					47,000	4,000	5,355	0	0	0	56,355	52,355			4,363	4,363	4,363	4,363	4,363	4,363	4,363	4,363	4,363	4,363	4,363	4,363	52,355
Porters / Security
Day Porter					21,000		2,205	no	0		23,205	23,205		OK	1,934	1,934	1,934	1,934	1,934	1,934	1,934	1,934	1,934	1,934	1,934	1,934	23,205
Night Porter					25,000		2,625	yes	1,833		29,458	29,458		OK	2,455	2,455	2,455	2,455	2,455	2,455	2,455	2,455	2,455	2,455	2,455	2,455	29,458
Part Time Night Porter					10,000		1,050	yes	0		11,050	11,050		OK	921	921	921	921	921	921	921	921	921	921	921	921	11,050
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
INSERT EXTRA ROWS ABOVE THIS ONE
					56,000	0	5,880	0	1,833	0	63,713	63,713			5,309	5,309	5,309	5,309	5,309	5,309	5,309	5,309	5,309	5,309	5,309	5,309	63,713
Restaurant
N/A							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
INSERT EXTRA ROWS ABOVE THIS ONE
					0	0	0	0	0	0	0	0			0	0	0	0	0	0	0	0	0	0	0	0	0
Kitchen
N/A							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
INSERT EXTRA ROWS ABOVE THIS ONE
					0	0	0		0	0	0	0			0	0	0	0	0	0	0	0	0	0	0	0	0
Bar
N/A							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
INSERT EXTRA ROWS ABOVE THIS ONE
					0	0	0		0	0	0	0			0	0	0	0	0	0	0	0	0	0	0	0	0
Maintenance
Handy Man					25,000		2,625	no	0		27,625	27,625		OK	2,302	2,302	2,302	2,302	2,302	2,302	2,302	2,302	2,302	2,302	2,302	2,302	27,625
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
							0		0		0	0		OK	0	0	0	0	0	0	0	0	0	0	0	0	0
INSERT EXTRA ROWS ABOVE THIS ONE
					25,000	0	2,625	0	0	0	27,625	27,625			2,302	2,302	2,302	2,302	2,302	2,302	2,302	2,302	2,302	2,302	2,302	2,302	27,625
Management/Administration
N/A							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
INSERT EXTRA ROWS ABOVE THIS ONE
					0	0	0		0	0	0	0			0	0	0	0	0	0	0	0	0	0	0	0	0
Sales & Marketing
N/A							0		0		0	0		OK													0
							0		0		0	0		OK													0
							0		0		0	0		OK													0
INSERT EXTRA ROWS ABOVE THIS ONE
					0	0	0		0	0	0	0			0	0	0	0	0	0	0	0	0	0	0	0	0
Overall					128,000	4,000	13,860		1,833	0	147,693	143,693			11,974	11,974	11,974	11,974	11,974	11,974	11,974	11,974	11,974	11,974	11,974	11,974	143,693