Room Revenue Forecast for Year 2 Quarter 2 (April, May and June)
There are two documents to be submitted for this group assignment:
1. Create a word document to provide a narrative (a minimum of one pages, single-spaced) for the rationale behind the forecasted numbers:
Part I: Competitive Intelligence: Explain how competitive sales data influences your forecasts
Part II: Market trend and anomalies: Explain what kind of market trend you expect in Year 2 Quarter 2 and any anomalies that expect to affect your forecasts.
|
Year
|
2
|
|
2
|
|
2
|
|
|
Month
|
June
|
|
May
|
|
April
|
|
|
20% more business - GOAL
|
Forecast
|
STLY
|
Forecast
|
STLY
|
Forecast
|
STLY
|
|
Weekday Transient
|
653
|
544
|
763
|
636
|
701
|
584
|
|
Weekend Transient
|
530
|
442
|
580
|
483
|
499
|
416
|
|
Weekday Contract
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Weekend Contract
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Conference (weekday)
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Conference (weekend)
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Groups (weekday)
|
221
|
184
|
188
|
157
|
235
|
196
|
|
Groups (weekend)
|
264
|
220
|
215
|
179
|
280
|
233
|
|
Events (weekday)
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Events (weekend)
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Total Rooms Sold
|
1668
|
1390
|
1746
|
1455
|
1715
|
1429
|
|
Room Occupancy (%)
|
44.48%
|
39.7%
|
46.56%
|
33.3%
|
45.73%
|
40.8%
|
|
ADR ($)
|
$102.24
|
$85.20
|
$108.36
|
$90.30
|
$95.18
|
$79.32
|
|
Weekday
|
$128.86
|
$107.38
|
$131.38
|
$109.48
|
$125.60
|
$104.67
|
|
Weekend
|
$139.20
|
$116.00
|
$136.21
|
$113.51
|
$126.24
|
$105.20
|
|
Contracts
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
|
Conferences
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
|
Groups
|
$25.94
|
$21.62
|
$24.76
|
$20.63
|
$23.66
|
$19.72
|
|
REVPAR ($)
|
$40.61
|
$33.84
|
$36.04
|
$30.03
|
$38.87
|
$32.39
|
|
Total Room Revenue ($)
|
$142,108.80
|
$118,424.00
|
$157,663.20
|
$131,386.00
|
$136,023.60
|
$113,353.00
|
|
Weekday
|
$70,100.40
|
$58,417.00
|
$83,556.00
|
$69,630.00
|
$73,353.60
|
$61,128.00
|
|
Weekend
|
$61,528.80
|
$51,274.00
|
$65,788.80
|
$54,824.00
|
$52,518.00
|
$43,765.00
|
|
Contract
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
|
Conferences
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
$0.00
|
|
Groups
|
$10,479.60
|
$8,733.00
|
$8,318.40
|
$6,932.00
|
$10,152.00
|
$8,460.00
|