Instructions:

Calculate how much revenue the hotel will take in from a large group using the following information.

• First, calculate all the revenue (dont forget to add tax for the rooms).
• Then, calculate and add on gratuity to create a final total bill for the event.
• You can calculate it on your own, screen shot/take a photo of it and upload, OR use the Excel spreadsheet with pre-created formulas instead.
• Please note that if you use the Excel spreadsheet, you only type numbers in the yellow highlighted cells or you will delete the formulas that already exist in the grey cells for your convenience.
• Upload your completed spreadsheet of calculated convention data by 11:59pm on the due date.

Group Name: Vista Travel Agents, Inc.

Attendees: 325

Dates: December 1-4 of next year (3 Nights)

See the convention program below for all details about event.

Room Revenue:

190 attendees are staying (single occupancy) in basic level rooms at $119 per night for 3 nights.

20 attendees (single occupancy) are staying in suites costing $199 per night for three nights.

All other attendees (single occupancy) are in economy rooms costing $89 per night for three nights.

Room tax is 7.3% per night. (Hint: 1.073 x room revenue = total)

Conference Room Set Up Revenue:

The client is charged for each individual activity that includes food or beverage at $100 to set up the room.

Audio Visual Revenue:

The meeting planner has requested overhead projector rental in 3 meeting rooms at $50 per projector. The keynote speakers will both need a laptop computer at the cost of $100 rental.

Meal Revenue:

Breakfast $11.25 per person all attend

Lunch $19.75 per person all attend plus an outside speaker

Dinner $25.50 per person 200 attend

Cocktail Party $7.50 per person all attend

Gratuity:

The hotel charges an automatic 10% gratuity based on the total revenue for the event. (Hint: Revenue X 1.10 = Total Bill)

Convention Program

December 1

Registration 4pm-6pm

Opening Cocktail Party 6pm-9pm

December 2

Breakfast (Tiki Tiki Room) 7am-8pm

Sessions 9am-12 noon

Aloha Room: Marketing Workshop

Mahalo Room: Financial Management Workshop

Luau Room: Human Resources Workshop

Lunch (Tiki Tiki Room) 12pm-2pm

Keynote Speaker: Melanie Malikimaki

Sessions 2pm-3pm

Hula Room: Your Ticket to Success

Dinner on Your Own

December 3:

Breakfast (Tiki Tiki Room) 7am-8am

Sessions 9am-12 noon

Aloha Room: Merchandising Magic

Mahalo Room: Economic Issues

Luau Room: Planning for the Future

Lunch (Tiki Tiki Room) 12pm-2pm

Keynote Speaker: Otis Ohaloi

Sightseeing on Your Own

Closing Dinner (Tiki Tiki Room) 8pm-10pm