Business Scenario – read carefully the information below and the details on each worksheet:
The hotel were you work in London has been approached by an international company to host an incentive trip in July 2025. The company would like to reserve 65 of the hotels 180 rooms for 7 nights and have asked for a room rate £99/night. Check-in 17th & check-out on 24th July .
On Saturday 19th July 2025, the company would like to host a gala dinner awards ceremony for 65 people in one of the hotel’s function rooms. There needs to be a band, 5-course meal, open bar and the company would like to offer each of their employees a gift during the evening – the gift will need to be chosen and bought by the hotel. The company are willing to pay no more than £250 per head.
Using the worksheets in this workbook, the FO Manager has asked you to do. To explain what this coursework is about and outline the tasks involved, you could structure it as follows:
Coursework Overview:
This coursework involves analyzing the feasibility and preparation required for hosting an incentive trip and gala dinner for an international company at a hotel in London. The focus is on using data and financial insights to determine the capability of the hotel to manage the event effectively while maintaining financial stability.
### Scenario Details:
– **Event**: Hosting an incentive trip in July 2025, involving the reservation of 65 out of 180 rooms for 7 nights at a rate of £99/night.
– **Additional Event**: A gala dinner and awards ceremony for 65 people, including a band, 5-course meal, open bar, and gifts for attendees, with a budget of £250 per person.
– **Check-in/Check-out**: 17th July to 24th July 2025.
### Tasks to be Completed:
1. **Analyze Room Availability**: Review the “Rooms” worksheet to confirm room availability for the requested dates and assess how it impacts overall occupancy and revenue.
2. **Financial Assessment**: Use the “Financial Report” worksheet to understand past performance and forecasted financial data to ensure that the room rate and event budget align with projections.
3. **Event Planning**:
– Utilize the “Event Timeline Data” to map out necessary preparations, including booking the function room and arranging meals, entertainment, and gifts.
– Cross-check the “Dynamic Timeline GANTT Chart” for planning timelines.
4. **Cost Analysis**:
– Estimate total potential revenue from room bookings and the gala dinner.
– Compare costs against the provided budget to assess profitability and feasibility.
5. **Logistical Preparation**:
– Refer to the “Production Schedule” and “Production Schedule_setup” sheets to organize staffing, event setup, and execution.
6. **Reporting**: Prepare a summary report outlining your findings, including financial feasibility, potential challenges, and recommendations for the hotel management.
