Hotel Sample
Profit and Loss Statement For the Four Months Ending October 31, 2007 This sample shows calculations based on non-financial data, such as room rate and number of occupied rooms Current Month Budget 1,290 890 890 69.0% 69.0% $129.97 $89.67 $43.48 Year to Date Budget 5,160 3,491 3,491 67.7% 67.7% $131.98 $89.29 $44.65
Actual 1,290 878 860 68.1% 66.7% $133.31 $88.88 $42.25
%
%
Var to Bud Available Rooms Total Occupied Rooms Occupied Rooms (Rev) % of Total Occupied % of Occupancy (Rev) Average Rate REVPAR Cost per Occupied Room
Actual 5,160 3,849 3,810 74.6% 73.8% $133.37 $98.47 $41.39
%
%
Var to Bud
(12) (30) -0.9% -2.3% $3.34 ($0.79) $1.78
358 319 6.9% 6.2% $1.38 $9.18 ($3.27)
114,649 15,121 3,533 5,825 1,292 140,420
81.6% 10.8% 2.5% 4.1% 0.9% 100.0%
115,674 12,841 3,813 5,340 490 138,158
83.7% 9.3% 2.8% 3.9% 0.4% 100.0%
(1,025) 2,280 (280) 485 802 2,262
Revenue Rooms F&B Telecommunications Garage Rent & Other Total Revenue Dept Profit Rooms F7B Telecommunications Garage Rent & Other Total Dept Profit Undistributed Depts A&G Sales & Marketing Engineering Utilities Total Undistributed Depts Gross Operating Profit Management Fee Lease Insurance Taxes Total Fixed Charges Net Operating Profit(Loss)
508,125 67,143 13,426 25,410 26,286 640,390
79.3% 10.5% 2.1% 4.0% 4.1% 100.0%
460,746 50,898 14,957 20,946 1,920 549,467
83.9% 9.3% 2.7% 3.8% 0.3% 100.0%
47,379 16,245 (1,531) 4,464 24,366 90,923
74,918 5,037 618 5,825 1,156 87,554
65.3% 33.3% 17.5% 100.0% 89.4% 62.4%
76,979 4,764 1,892 5,340 147 89,122
65.5% 37.1% 49.6% 100.0% 30.0% 64.5%
(2,061) 273 (1,274) 485 1,009 (1,568)
348,830 23,873 5,310 25,410 25,129 428,552
68.7% 35.6% 39.5% 100.0% 95.6% 66.9%
304,859 18,925 7,406 20,946 575 352,711
66.2% 37.2% 49.5% 100.0% 29.9% 64.2%
43,971 4,948 (2,096) 4,464 24,554 75,841
21,186 12,392 9,130 3,360 46,068 41,486 5,621 4,474 1,999 5,974 18,068 23,418
15.1% 8.8% 6.5% 2.4% 32.8% 29.5% 4.0% 3.2% 1.4% 4.3% 12.9% 16.6%
18,070 12,417 7,909 2,811 41,207 47,915 5,460 5,468 1,999 5,516 18,443 29,472
13.1% 9.0% 5.7% 2.0% 29.8% 34.7% 4.0% 4.0% 1.4% 4.0% 13.4% 21.3%
3,116 (25) 1,221 549 4,861 (6,429) 161 (994) (1) 458 (376) (6,053)
89,275 47,105 32,121 14,864 183,365 245,187 25,620 22,919 8,187 24,348 81,074 164,113
13.9% 7.4% 5.0% 2.3% 28.6% 38.3% 4.0% 3.6% 1.3% 3.8% 12.7% 25.6%
72,136 58,204 31,578 11,199 173,117 179,594 21,711 21,872 7,996 23,664 75,243 104,351
13.1% 10.6% 5.7% 2.0% 31.4% 32.7% 4.0% 4.0% 1.5% 4.3% 13.8% 18.9%
17,139 (11,099) 543 3,665 10,248 65,593 3,909 1,047 191 684 5,831 59,762