Total Revenue Management Homework Assignment 6
This assignment is to be complete
Total Revenue Management Homework Assignment 6
This assignment is to be completed in Excel. Open the Excel file entitled “Module 10 Homework”. Then, complete each of the three worksheets as detailed below. Complete the title page. Upload the Excel document as your assignment.
Cover Page – Complete and corresponds to the information on the rest of the sheet. – 2 points
1) Gaming Worksheet: The Table Games Manager would like for you to help with maximizing table game revenue.
Below is a list of the total number of seats occupied during a given hour of the day.
Currently, the minimum wager is $10 all day.
Please make recommendations based on the demand for each time period.
The minimum wagers can be $5, $10, or $25. The game is blackjack. There are 10 tables with 6 seats each.
6 points
2) Golf Worksheet: The Golf Course has a lot of problems with no-shows.
The Golf Course manager asked you to look at the following history of no-shows and forecast for the next 7 days.
Please use the moving average technique used in the forecasting module.
6 points
3) Spa Worksheet: The Spa has a new manager. They would like you to review the emails below and would like for you to review the requests and make suggestions as to which reservations you should book. You have to make sure you have space.
Fill out the worksheet and calculate the total revenue for the week based on your decisions.
Some times are already booked. Those are highlighted in blue and cannot be changed.
6 points
The worksheets must be filled out complete and have your name on the first sheet. The assignment must be turned in before the due date and time on the syllabus.
