80.2K

Verified Solution

Link Copied!

1. Wendy Parker works in the sales and marketing department at the Hawthorne Suites. As part of her duties, Wendy updates the hotels group room sales pace reports. The reports record the number of rooms that been sold by month for all upcoming years in which groups have reserved rooms. Wendy prepared such a report for next year at the end of August but because it is now the end of September, that report must be updated to include Septembers group rooms sales results. Help Wendy create an updated group rooms pace report by revising the August report to include the following September sales information given to Wendy by the hotels director of sales and marketing.

September This Year: Group Room Sales

Sale to:	Cancels	Nights Reserved For	Rooms per Night	Total Nights Sold
California Firefighters		2-5 and 2-6	75	150
Antique Cup Collectors		5-2 and 5-3	50	100
NRC Cup		4-15 through 4-20	60	360
Little Sluggers Softball Tournament		6-10 through 6-14	80	400
State Mental Health Advisors		8-2 and 8-3	150	300
Real Estate Investment Seminar		6-6 through 6-9	40	160
Eastern Star Conference		10-31 through 11-2	100	300

Hawthorne Suites Hotel Group Rooms Pace Report For Jan-Dec Next Year

Month	Sold in August (this year)	Total committed group rooms (Jan-Dec next year)
Jan	40	1,250
Feb	60	1,800
March	140	5,620
April		850
May	600	975
June	220	850
July		2,200
Aug.		3,400
Sept.	180	1,900
Oct		2,800
Nov		5,500
Dec	440	620
Total	1,680	27,765

Hawthorne Suites Hotel Group Rooms Pace Report For Jan-Dec Next Year

month	Sold in September (this year)	Total committed group rooms (jan-dec next year)
Jan
Feb
March
April
May
June
July
Aug.
Sept.
Oct
Nov
Dec
Total

Answer & Explanation Solved by verified expert

See Answer