Question

Complete a vertical and horizontal analysis for the summary operating statement.

Summary Operating Statement WN 20x1 20x2 Variance (Horizontal) #/$ 300 79,388 72.5% 183.62 133.12 176.20 300 81,140 74.1% 191.33 141.78 185.65 6 Rooms Available: 7 Rooms Sold: 8 Occupancy: 9 ADR: 10 Rooms RevPAR: 11 Total RevPAR: 12 13 Operating Revenue 14 Rooms 15 Food and Beverage Miscellaneous Income 17 Total Operating Revenue 16 14,577,225 4,444,791 271,725 19,293,741 15,524,516 4,517,064 287,236 20,328,816 18 1 3 19 Departmental Expenses 20 Rooms Food and Beverage 22 Total Departmental Expenses ,848,590 3,272,482 7,121,072 3,943,227 3,329,076 7,272,303 24 Total Departmental Profit 12,172,669 13,056,513 26 Undistributed Operating Expenses Administrative and General Information and Telecommunications Systems 29 Sales and Marketing Property Operation and Maintenance 31 Utilities 32 Total Undistributed Expenses 1,584,062 308,896 1,816,014 793,637 583,641 5,086,250 1,646,634 304,932 1,870,251 813,153 589,536 5,224,506 33 7,086,419 T L 7,832,007 34 Gross Operating Profit 35 36 Management Fees 37 38 Income Before Non-Operating Income and Expenses 578,812 609,864 6,507,607 7,222,143 39 TL 40 Non-Operating Income and Expenses 41 (Income)Loss 42 Property and Other Taxes 43 Insurance 44 Total Non-Operating Income and Fxpenses Summary Operating Statement (2,000) (1,300) 753, 247 7 83,001 152,433 149,298 903 680 930999 Statement of Cash Flow Op Sec 1 Balance Sheet

Answer 1

	20x1			20x2			Variance (Horizontal)
							#/$	%
Rooms available:	300.00			300.00				0.00%
Rooms sold:	79,388.00			81,140.00				2.21%
Occupancy:	72.50%			74.10%				2.21%
ADR:	183.62			191.33			7.71	4.20%
Rooms RevPar:	133.12			141.78			8.66	6.51%
Total RevPar:	176.20			185.65			9.45	5.36%
Operating revenue
Rooms	14,577,225.00	75.55%		15,524,516.00	76.37%		947,291.00	6.50%
Food and beverage	4,444,791.00	23.04%		4,517,064.00	22.22%		72,273.00	1.63%
Misc. income	271,725.00	1.41%		287,236.00	1.41%		15,511.00	5.71%
Total operating revenue	19,293,741.00	100.00%		20,328,816.00	100.00%		1,035,075.00	5.36%
Departmental expenses
Rooms	3,848,590.00	19.95%		3,943,227.00	19.40%		94,637.00	2.46%
Food and beverage	3,272,482.00	16.96%		3,329,076.00	16.38%		56,594.00	1.73%
Total departmental expenses	7,121,072.00	36.91%		7,272,303.00	35.77%		151,231.00	2.12%
Total departmental profit	12,172,669.00	63.09%		13,056,513.00	64.23%		883,844.00	7.26%
Undistributed operating expense
Administrative and General	1,584,062.00	8.21%		1,646,634.00	8.10%		62,572.00	3.95%
Information & Telecommunications Systems	308,896.00	1.60%		304,932.00	1.50%		-          3,964.00	-1.28%
Sales and Marketing	1,816,014.00	9.41%		1,870,251.00	9.20%		54,237.00	2.99%
Property Operation and Maintenance	793,637.00	4.11%		813,153.00	4.00%		19,516.00	2.46%
Utilities	583,641.00	3.03%		589,536.00	2.90%		5,895.00	1.01%
Total undistributed expenses	5,086,250.00	26.36%		5,224,506.00	25.70%		138,256.00	2.72%
Gross operating profit	7,086,419.00	36.73%		7,832,007.00	38.53%		745,588.00	10.52%
Management fees	578,812.00	3.00%		609,864.00	3.00%		31,052.00	5.36%
Income before non-operating income and expenses	6,507,607.00	33.73%		7,222,143.00	35.53%		714,536.00	10.98%
Non-operating Income and expenses
(Income)/Loss	-            2,000.00	-0.01%		-            1,300.00	-0.01%		700.00	-35.00%
Property and other taxes	753,247.00	3.90%		783,001.00	3.85%		29,754.00	3.95%
Insurance	152,433.00	0.79%		149,298.00	0.73%		-          3,135.00	-2.06%
Total non-operating Income and Expenses	903,680.00	4.68%		930,999.00	4.58%		27,319.00	3.02%