SpringHill Suites Houston Medical Center — January 2025
| Account Description | Actual Jan 2025 Show YTD | % of Total Rev |
|---|---|---|
| Operating Revenue | ||
| Rooms Revenue | $382,000 | 93.1% |
| Food & Beverage | $18,000 | 4.4% |
| Other Operated Departments | $10,281 | 2.5% |
| Total Operating Revenue | $410,281 | 100.0% |
| Departmental Expenses | ||
| Rooms Expense | ($72,000) | 17.5% |
| Rooms Dept Profit | $310,000 | 75.7% |
| F&B Expense | ($28,000) | 6.8% |
| F&B Dept Profit | ($10,000) | -55.6% |
| Other Operated Expenses | ($6,415) | 1.6% |
| Other Dept Profit | $3,866 | 0.9% |
| Total Labor Cost i | ($98,400) | 24.0% |
| Total Departmental Expenses | ($106,415) | 25.9% |
| Departmental Profit | $303,866 | 74.1% |
| Undistributed Operating Expenses | ||
| Administrative & General | ($38,000) | 9.3% |
| Information & Telecom | ($4,500) | 1.1% |
| Sales & Marketing | ($22,000) | 5.4% |
| Property Operations & Maintenance | ($18,000) | 4.4% |
| Utilities | ($20,488) | 5.0% |
| Franchise Fees | ($46,522) | 11.3% |
| Total Undistributed | ($149,510) | 36.4% |
| Gross Operating Profit (GOP) | $154,356 | 37.6% |
| Management Fees | ||
| Management Fees | ($10,257) | 2.5% |
| Fixed Charges | ||
| Insurance | ($12,000) | 2.9% |
| Property Taxes | ($28,764) | 7.0% |
| FF&E Reserve | ($2,000) | 0.5% |
| Total Fixed Charges | ($42,764) | 10.4% |
| Non-Operating Items | ||
| Non-Operating | ($3,356) | 0.8% |
| Net Operating Income (NOI) | $101,335 | 24.7% |
| Account | PY Actual | Budget | Actual | Var $ | Var % | Run-Rate | FTC |
|---|---|---|---|---|---|---|---|
| Operating Revenue | |||||||
| Rooms Revenue | $365,000 | $368,000 | $382,000 | +$14,000 | +3.8% | $382,000 | $383,200 |
| Food & Beverage | $16,800 | $16,500 | $18,000 | +$1,500 | +9.1% | $18,000 | $18,100 |
| Other Operated | $9,500 | $10,500 | $10,281 | ($219) | -2.1% | $10,281 | $10,350 |
| ▶ Total Revenue | $391,300 | $395,000 | $410,281 | +$15,281 | +3.9% | $410,281 | $411,650 |
| Departmental Expenses | |||||||
| Rooms Expense | ($68,000) | ($70,000) | ($72,000) | ($2,000) | -2.9% | ($72,000) | ($71,800) |
| F&B Expense | ($25,000) | ($26,000) | ($28,000) | ($2,000) | -7.7% | ($28,000) | ($27,500) |
| Other Dept Expense | ($5,800) | ($6,000) | ($6,415) | ($415) | -6.9% | ($6,415) | ($6,300) |
| ▶ Total Dept Expenses | ($98,800) | ($102,000) | ($106,415) | ($4,415) | -4.3% | ($106,415) | ($105,600) |
| Departmental Profit | $292,500 | $293,000 | $303,866 | +$10,866 | +3.7% | $303,866 | $306,050 |
| Undistributed Expenses | |||||||
| Admin & General | ($34,000) | ($36,000) | ($38,000) | ($2,000) | -5.6% | ($38,000) | ($37,500) |
| Info & Telecom | ($3,800) | ($4,000) | ($4,500) | ($500) | -12.5% | ($4,500) | ($4,400) |
| Sales & Marketing | ($19,000) | ($20,000) | ($22,000) | ($2,000) | -10.0% | ($22,000) | ($21,800) |
| Property Ops & Maint. | ($16,000) | ($17,000) | ($18,000) | ($1,000) | -5.9% | ($18,000) | ($17,800) |
| Utilities | ($18,500) | ($16,000) | ($20,488) | ($4,488) | -28.1% | ($20,488) | ($20,200) |
| Franchise Fees | ($39,000) | ($40,000) | ($46,522) | ($6,522) | -16.3% | ($46,522) | ($46,000) |
| ▶ Total Undistributed | ($130,300) | ($133,000) | ($149,510) | ($16,510) | -12.4% | ($149,510) | ($147,700) |
| Gross Operating Profit (GOP) | $149,700 | $160,000 | $154,356 | ($5,644) | -3.5% | $154,356 | $158,350 |
| Management Fees | |||||||
| Management Fees | ($9,500) | ($9,875) | ($10,257) | ($382) | -3.9% | ($10,257) | ($10,100) |
| Fixed Charges | |||||||
| Insurance | ($11,000) | ($11,000) | ($12,000) | ($1,000) | -9.1% | ($12,000) | ($12,000) |
| Property Taxes | ($27,500) | ($28,000) | ($28,764) | ($764) | -2.7% | ($28,764) | ($28,764) |
| FF&E Reserve | ($2,000) | ($2,000) | ($2,000) | $0 | 0.0% | ($2,000) | ($2,000) |
| ▶ Total Fixed Charges | ($40,500) | ($41,000) | ($42,764) | ($1,764) | -4.3% | ($42,764) | ($42,764) |
| Non-Operating | |||||||
| Non-Operating | ($3,000) | ($3,000) | ($3,356) | ($356) | -11.9% | ($3,356) | ($3,350) |
| Net Operating Income (NOI) | $96,700 | $106,125 | $101,335 | ($4,790) | -4.5% | $98,979 | $102,136 |
| Account | Method | Rate | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Operating Revenue | |||||||||||||||
| 4100 Rooms Revenue | fixed | — | $368,000 | $352,000 | $390,000 | $385,000 | $370,000 | $345,000 | $320,000 | $310,000 | $355,000 | $395,000 | $380,000 | $410,000 | $4,380,000 |
| 4200 Food & Beverage | fixed | — | $16,500 | $15,800 | $17,200 | $16,900 | $16,100 | $15,000 | $14,000 | $13,800 | $15,500 | $17,500 | $16,800 | $18,000 | $193,100 |
| 4300 Other Revenue | fixed | — | $10,500 | $10,000 | $10,800 | $10,600 | $10,200 | $9,500 | $8,800 | $8,700 | $9,800 | $11,000 | $10,500 | $11,000 | $121,400 |
| Departmental Expenses | |||||||||||||||
| 5110 Front Desk Wages | per_occ | $6.08 | $8,200 | $7,900 | $8,500 | $8,300 | $8,000 | $7,500 | $7,000 | $6,900 | $7,700 | $8,600 | $8,300 | $8,900 | $95,800 |
| 5120 Room Attendants | per_occ | $8.50 | $11,500 | $11,000 | $11,900 | $11,600 | $11,200 | $10,500 | $9,800 | $9,700 | $10,800 | $12,000 | $11,600 | $12,400 | $134,000 |
| 5130 Housekeeping Supv. | fixed | — | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $4,200 | $50,400 |
| Undistributed Expenses | |||||||||||||||
| 6300 Sales & Marketing | pct_rev | 1.14% | $4,500 | $4,300 | $4,760 | $4,700 | $4,520 | $4,210 | $3,900 | $3,790 | $4,340 | $4,830 | $4,650 | $5,000 | $53,500 |
| 6500 Utilities | fixed | — | $16,000 | $17,000 | $14,000 | $13,000 | $15,000 | $18,000 | $22,000 | $23,000 | $19,000 | $15,000 | $14,000 | $16,000 | $202,000 |
| Gross Operating Profit (GOP) | — | — | $142,300 | $136,600 | $155,200 | $152,700 | $146,080 | $131,290 | $116,300 | $112,310 | $137,060 | $161,170 | $152,750 | $163,000 | $1,707,600 |
| Net Operating Income (NOI) | — | — | $108,120 | $102,840 | $119,340 | $117,140 | $110,960 | $96,530 | $80,800 | $77,050 | $101,800 | $126,040 | $118,290 | $128,240 | $1,297,440 |
Min. Dollar Impact
| Severity | Department | Account | Budget | Var $ | Var % | Actions |
|---|---|---|---|---|---|---|
|
Critical
|
Utilities | 6500 | ($16,000) | ($4,488) | -28.1% |
|
|
Critical
|
Franchise Fees | 6600 | ($40,000) | ($6,522) | -16.3% |
|
|
Warning
|
Info & Telecom | 6200 | ($4,000) | ($500) | -12.5% |
|
|
Warning
|
Non-Operating | 8xxx | ($3,000) | ($356) | -11.9% |
Acknowledged ✓
|
|
Warning
|
Sales & Marketing | 6300 | ($20,000) | ($2,000) | -10.0% |
|
|
Warning
|
Insurance | 7100 | ($11,000) | ($1,000) | -9.1% |
|
|
Warning
|
F&B Expense | 5200 | ($26,000) | ($2,000) | -7.7% |
|
|
Watch
|
Other Dept Expense | 5300 | ($6,000) | ($415) | -6.9% |
|
|
Watch
|
Rooms Expense | 5100 | ($70,000) | ($2,000) | -2.9% |
|