Competitive intelligence explain how competitive sales data

Question

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