|
Proforma 41.4,34
<br />City of Ramsey, MN *; ti's411
<br />j
<br />Number projeetcd and comgaired to aimllat u3iasketsfoz a iote`l vi fie follot ngsoOmaf:3
<br />a
<br />yz'i--c'k
<br />�
<br />January
<br />Febmuv
<br />M4r_Is
<br />. Ayiil.
<br />Max
<br />J8 •
<br />jinx
<br />Anost
<br />Stptemhrr
<br />£molar
<br />November
<br />December
<br />.TOTAI
<br />Lodging Rooms Available
<br />1,860
<br />1,680
<br />1,860
<br />1,800
<br />1,860
<br />1,800
<br />1,860
<br />1,860
<br />/,800
<br />1,860
<br />1,800
<br />1,860
<br />21,900
<br />Lodging Occupancy%
<br />48.4%
<br />49.1% .
<br />53,8%
<br />63.9%
<br />64.5%
<br />722% -
<br />726% '
<br />726%
<br />69.4%
<br />64.5%
<br />47.2%
<br />41.7%
<br />60.0
<br />1'ot.1Om. Rooms
<br />900
<br />825
<br />1,000
<br />1,150 •
<br />1,200
<br />1,300
<br />1,350
<br />1,350
<br />1,250
<br />1,200
<br />850
<br />775
<br />13,150
<br />Average Daily Rate
<br />$103.00
<br />1104.00
<br />1107.00
<br />011600
<br />$116,00
<br />3118.00
<br />$119.00
<br />8119.00
<br />$113.00
<br />$110.00
<br />.$105.00
<br />3100.00
<br />. 811200 .
<br />Revenue Per Available Room (REVPAR)
<br />$49.84
<br />$51.07
<br />$5753
<br />$74.11
<br />$74.84
<br />. $85.22
<br />$86.37
<br />$86.37
<br />$78.47
<br />. $70.97
<br />$49.58
<br />$41.67
<br />$67.25
<br />REVENUE:
<br />-
<br />Guest Rooms
<br />92,700
<br />85,800
<br />107,000
<br />133,400
<br />' 139,7.00
<br />153.400
<br />160,650
<br />160.650
<br />141,250 •
<br />132,000
<br />89,250
<br />77,500
<br />1,472,800.
<br />9&B Revenue
<br />9 000
<br />' 8550
<br />10,000
<br />11,500
<br />' 12,000
<br />13,000
<br />13,500
<br />13,500
<br />12,500
<br />. 12,000
<br />8,500
<br />7,750
<br />131,500
<br />Vending Revenue
<br />2,700
<br />2,475
<br />3,000
<br />3,450 .
<br />3,600
<br />3,900
<br />4,050 •
<br />4,050
<br />3,750.
<br />3,600
<br />2550
<br />2,325
<br />39,450
<br />TOTALHOTEL REVENUE
<br />104,400
<br />- 96,525 '
<br />120,900
<br />148,350
<br />154,800•
<br />170,300
<br />178200
<br />178,200 .
<br />157500 .
<br />147,600
<br />100,300
<br />87,575
<br />1,643,750
<br />HOTEL PAYROLL EXPENSE
<br />.
<br />Hotel Mswger
<br />5,417
<br />. 5,417 •
<br />5,417
<br />5,417
<br />5,417
<br />5,417'
<br />5,417
<br />5,417
<br />5,417
<br />5,417
<br />5,417
<br />5;417
<br />65,000
<br />AstMana8er/SalesManager -
<br />3,750
<br />3,750
<br />3.750
<br />3,750
<br />3.750
<br />3,750
<br />3,750
<br />3550 .
<br />3,750
<br />' 3.750.
<br />3,750
<br />3,750
<br />45,000
<br />Housekeeping
<br />. 4500
<br />4,125
<br />- 5,000
<br />5,750
<br />6,000
<br />6,500
<br />6,750
<br />6,750
<br />6,250
<br />6,000
<br />4,250
<br />' 3.875
<br />65,750
<br />Maintenance
<br />1,854 ` ..
<br />• 1,716
<br />2,140
<br />2,668
<br />2,784
<br />3,068
<br />3,213
<br />3,213
<br />2,825
<br />Z640
<br />1,785
<br />1,550
<br />29,456
<br />Front Desk
<br />6,489
<br />6,006
<br />7,490'.
<br />9,338 -
<br />9,744
<br />10,738
<br />11,246
<br />11,246
<br />- 9,888
<br />9,240
<br />6,248
<br />5,425 ''
<br />103,096
<br />F&B Staffing,
<br />4,950
<br />4,538
<br />5,500
<br />6,325
<br />6,600
<br />7,150
<br />7,425
<br />7,425
<br />6,875
<br />6,600
<br />4,675
<br />4,263
<br />72,325
<br />Breakfast/Social
<br />927
<br />858
<br />1,070
<br />1,334
<br />. 1,392
<br />1,534
<br />1,607
<br />1,607
<br />1,413
<br />1,320
<br />893
<br />775
<br />14,728
<br />Worker Comp I nuance
<br />697
<br />660 .
<br />. 759
<br />865
<br />892
<br />954
<br />• 985
<br />985
<br />910
<br />874
<br />675
<br />626
<br />.9,884
<br />Payroll Tax
<br />• 3,573
<br />3,384
<br />3,891
<br />4,431
<br />4,572
<br />4,889
<br />5,049
<br />5,049
<br />4,666
<br />4,480
<br />3,462
<br />3,210
<br />50,655
<br />TOTAL HOTEL PAYROLL
<br />32,157
<br />30,453
<br />35,017
<br />39,877
<br />41551
<br />43,999
<br />45,441
<br />45,441
<br />• 41,993
<br />40,321
<br />. 31,154
<br />28,891
<br />455,894
<br />HOTEL OPERATING EXPENSE
<br />Cleaning Supplies .
<br />450
<br />413
<br />500
<br />575
<br />600
<br />650
<br />675
<br />675
<br />625
<br />600
<br />425
<br />388
<br />6,575
<br />Laundry Supplies
<br />675
<br />'619
<br />750
<br />863
<br />900
<br />975
<br />1,013
<br />1,013
<br />938
<br />900
<br />638
<br />581 -
<br />9,863
<br />Linens'
<br />900
<br />' 825
<br />1,000
<br />1,150
<br />1,200
<br />1,300
<br />1,350
<br />1,350
<br />1,250
<br />1,200
<br />850
<br />775
<br />13,150
<br />Guest Supplies
<br />1,125
<br />1,031
<br />- 1,250
<br />1,438
<br />1,500
<br />1,625
<br />1,688
<br />• 1,688
<br />1563
<br />1,500 '
<br />1,063
<br />969 •
<br />16,438
<br />Operating Supplies
<br />765
<br />701 .
<br />850
<br />978 .
<br />1,020
<br />1,105
<br />1,148
<br />1,148
<br />1,063
<br />1,020
<br />723
<br />659
<br />11,178
<br />Repeies & Maintenance
<br />695
<br />644
<br />803. •
<br />1,001
<br />1,044
<br />1,151
<br />1,205
<br />1,205
<br />1,059
<br />990
<br />669
<br />581
<br />• 11,046
<br />Swimming Pool
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />1,012
<br />1,042
<br />1,042
<br />1,042
<br />1,042
<br />12,500
<br />Grounds/landscaping
<br />750
<br />1,000
<br />1,000
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />750
<br />7,500
<br />Fmchbe Fee
<br />5,115
<br />4,620
<br />5515
<br />4,950
<br />5,115
<br />4 950
<br />• 5,115
<br />5515
<br />4,950
<br />5,115
<br />4,950
<br />5,115
<br />60,225
<br />properly Mgmt System Exprue
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430
<br />430 .
<br />430
<br />430 .
<br />5,160
<br />Complimentary Breakfast
<br />3,600
<br />3,300
<br />4,000
<br />4,600
<br />4,800
<br />5,200
<br />5,400
<br />5,400
<br />5,000
<br />4800
<br />3,400
<br />3,100
<br />52,600
<br />Travel Agent Fees
<br />. 2,318
<br />2,145
<br />2675
<br />3,335
<br />3,480
<br />3,835
<br />4.016
<br />4,016
<br />3,531
<br />3,300
<br />2,231
<br />1,938 •
<br />36,820
<br />Reservations Expense
<br />750 .
<br />750
<br />750
<br />750
<br />750
<br />750
<br />750
<br />750
<br />750
<br />750
<br />. 750
<br />750
<br />9,000 .
<br />1'&BExpemes
<br />4500
<br />4,125
<br />5,000
<br />5,750
<br />6,000
<br />6,500
<br />6,750
<br />6,750
<br />6,250
<br />6,000
<br />4250
<br />3,875
<br />65,750
<br />Vending Expense'
<br />1,350
<br />1,238
<br />1,500
<br />1,725
<br />1,800
<br />1,950
<br />2,025
<br />2,025
<br />1,875
<br />1,800
<br />1,275
<br />1,163
<br />19,725
<br />Marketing / Advertising
<br />510
<br />. 472
<br />. 589
<br />734
<br />766
<br />844
<br />884
<br />884
<br />777
<br />726
<br />491
<br />426
<br />8,100
<br />Utilities
<br />6,264
<br />5,792
<br />7,200
<br />8,901
<br />9,288
<br />10,218
<br />10,692
<br />10,692
<br />9,450
<br />8,856
<br />6,018.
<br />- 5,255
<br />98,625
<br />54,750
<br />Cable/Inteme6/Phone
<br />4,650
<br />4,200
<br />4,650
<br />4,500
<br />4,650
<br />4,500
<br />4,650
<br />4.650
<br />4,500
<br />4,650
<br />4500
<br />4,650 '
<br />Credit CardExpwe
<br />2,349
<br />2,172
<br />2,700
<br />3,338
<br />3,483
<br />3,832
<br />4,010
<br />4,010
<br />3,544
<br />3,321
<br />2,257
<br />1,970
<br />36,984
<br />Manajeemrnt Fee
<br />6,264
<br />5,792
<br />7,200
<br />8,901
<br />9,288
<br />10,218
<br />10,692
<br />10,692
<br />9,450
<br />8,856
<br />6,018
<br />5,755
<br />98,625
<br />Other Expanse/Frequent Stay
<br />. 225
<br />206
<br />., 250
<br />288
<br />300
<br />325
<br />338
<br />338
<br />313
<br />300
<br />213
<br />194 _
<br />3,288
<br />Accounting Services
<br />400
<br />400 •
<br />. 400
<br />400
<br />. 400
<br />400
<br />400
<br />400
<br />400
<br />400
<br />' 400
<br />400
<br />• 4,800
<br />TOTAL OPERATING EXPENSES
<br />45,126
<br />41,914
<br />49653
<br />56146
<br />58,355
<br />62,299
<br />64,770 -
<br />64,770
<br />59258
<br />57,056
<br />43,091
<br />40,264
<br />642,701
<br />Income Bente Fed Expenses .
<br />27,117
<br />24,158
<br />35,331
<br />57,327
<br />55,294
<br />64,002
<br />67,989
<br />67,989 •
<br />56249
<br />50,223
<br />. 26,055
<br />18,421
<br />.545,155
<br />Gross Operating Profit (GOV)
<br />25.97V.
<br />25.03%
<br />29,44%
<br />35.27%.
<br />35.72%.
<br />37.583 '
<br />38150
<br />38.15%
<br />15.71%
<br />34.03%
<br />25.98%
<br />21.03%
<br />33.17%
<br />RESERVES & FIXED EXPENSES
<br />Debt Service -
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34,394
<br />34594
<br />34,394
<br />•
<br />34,394
<br />34,394
<br />34,394
<br />34594
<br />412,732
<br />Real Ethan Tones(Essmates)
<br />' 9547
<br />9,347
<br />9,347
<br />9,347
<br />9,347
<br />9,347
<br />9,347
<br />9,347
<br />9,347
<br />9,347
<br />9,347 .
<br />9,347
<br />112,161
<br />Insurance
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />2,100,
<br />2,100
<br />2,100
<br />2,100
<br />2,100
<br />25200
<br />Ruowes For Replacement •
<br />1,044'
<br />965
<br />1,200
<br />1,484
<br />1,548
<br />1,703
<br />1,782
<br />1,782
<br />1575
<br />1,476
<br />1,003
<br />876
<br />16,438
<br />.
<br />TOTAL RESERVES&PIKED
<br />. 46,885
<br />46,806
<br />47,041
<br />47,325
<br />.47,389
<br />47,544
<br />47,623
<br />47,623
<br />47.416
<br />47,317
<br />46,844
<br />46,717
<br />566531
<br />NET OPERATING INCOME (N01)
<br />14,626
<br />11,746
<br />22,684
<br />39,397
<br />42299
<br />50,852
<br />54,761
<br />54,761
<br />43,227
<br />37,301
<br />13,606
<br />6,098
<br />391,357
<br />NET CASHFLOW -
<br />(19,768)
<br />(22,649)
<br />(11,710)
<br />5,003
<br />7,904
<br />16,458
<br />20,366
<br />20,366
<br />8,833
<br />2,906
<br />(20,789)
<br />(28,296)
<br />(21,375)
<br />Five YLot Ni i)i iers Projected SArniti<lry+..
<br />Lodging Rooms Available
<br />Lodging Occupancy %
<br />Total Occ, Rooms
<br />Average Daily Rate
<br />DAM
<br />AMOUNT
<br />21,900
<br />60.0%
<br />13,150
<br />/11200
<br />YEAIl2
<br />AMOUNT
<br />21,900
<br />64.8%
<br />14,202
<br />$117.60
<br />xEAgl
<br />AMOUNT
<br />21,900
<br />683%
<br />14,912
<br />$121.13
<br />xeea4
<br />AMOUNT
<br />21,903
<br />71.5%
<br />• 15,658
<br />$124.76
<br />YEAR5
<br />AMOUNT
<br />21,900
<br />74.79S
<br />16,362
<br />5128.50
<br />REVENUE:
<br />Guest Rooms 1,472,800 97.0% 1,670,155 97.0% 1,806,273 97.0% 1,953,484 97.0% 2,102,633 97.1%
<br />MeetngRoom 6,575 0.4% . 8521 0.5% 10,438 0.6% 12526 0.6% 14,726 0.7%
<br />Vending/ Bar Revenue 39,450 26% 42606 25% . 44,736. 2.441. 46,973 23% 49,087 23%
<br />TOTAL HOTEL REVENUE
<br />1,518,825 100.0 1,721,282 100.0 1,861,448 100.0 2,012,983 100.0 2,166,446 100.0
<br />NOT&Th, above infonnnien is .f ,dr kok'vgp.ojection of.miipsed expense. md.p.n6n eid„epal to do, project bated on the prercuional egeriooe o7Cn,e Dietnaim GrwpLLC(COG)participation in ether req.n4,emlm in none Occupancy and ADA proed...dvi.ed
<br />fun ...let d. minds tepomd by Smith 11nel Rematch VTR)in the eructatespromody dorg a-ehta dee oo,h0ping ofbnludaurrourdi,g tooth. This pmj.eonm.id chug due n changes in the rmomy,both lac :ayerd overall, it. @pa,o. oFthe pmicct by Ile Roil coonu:ty
<br />nail pawns and the tin [het CDG has not bus, involved io. project in den sea and n. monidpelityith than denogcphia in the pan Ttxshy, all knatan a denmod and .ckm.kdg that these (amid Imf".gprojectiom ate nu.,omed try COG and am ell*. n charge and
<br />fluctuation
<br />1, t
<br />t ,: 3 12/28/2019
<br />t:;b�� Core Distinction Group, LLC
<br />
|