Advanced Revenue Management System Forecast Data Exercise

Go to the Individual Weeks tab to get the information needed. Answer these questions for the week of June 24.

1. What is the total capacity for:

M-F 6a-10a?______ M-F 10a-3p?______ M-F 3p-7p?______ Sat 10a-3p?______

2. How many units are booked for:

M-F 6a-10a?______ M-F 10a-3p?______ M-F 3p-7p?______ Sat 10a-3p?______

3. How many units are available for:

M-F 6a-10a?______ M-F 10a-3p?______ M-F 3p-7p?______ Sat 10a-3p?______

4. What is the demand level for:

M-F 6a-10a?______ M-F 10a-3p?______ M-F 3p-7p?______ Sat 10a-3p?______

Use the Flighted Weeks tab to get the needed data. Answer these questions using the weeks of July 8 and 22 combined.

1. What is the rate for:

Monday 10a-3p? _____ M-F 3p-7p? _____ Friday 6a-10a _____ Sat 7p-12m? _____

2. How many units are available for:

Monday 10a-3p? _____ M-F 3p-7p? _____ Friday 6a-10a _____ Sat 7p-12m? _____

3. What is the demand level for:

Monday 10a-3p? _____ M-F 3p-7p? _____ Friday 6a-10a _____ Sat 7p-12m? _____

A client is interested in advertising every week starting August 5 through the end of the year. What rates will you quote for the following configurations? Use the Flighted Weeks tab. (Remember you may use the custom button to create some combo’s.)

M-F 6a-12m _____ M-W 6a-12m _____ W-F 6a-12m _____ Sat-Tues 6a-12m _____
M-F 6a-7p _____ M-W 6a-7p ______ W-F 6a-7p ______ Sat-Tues 6a-7p _____

Go to Chart View to get the following answers.

1. What’s the rate for M-F 6a-7p for week 10? _______


2. What’s the rate for M-F 6a-10a for week 7? _______


3. What’s the rate for Sat 10a-3p for week 4? _______


4. What’s the rate for M-F 7p-12m for week 8? ______

Printing rate cards and units available reports from the Individual Weeks tab:
This takes you step by step through printing a rate card that has rates by week and columns showing average rates for two upcoming months.

1. From the Individual Weeks tab, click on print, and then click on print again.
2. Select the weeks to be included by clicking and dragging. Highlight next week through the end of July. Click on the Individual Report Columns button to move the highlighted weeks over to the right side of the screen.
3. To create an average rate for a full month, highlight all June weeks and click on the Flighted Report Columns button to move all the weeks over as a collected flight (month).
4. Repeat for the month of July.
5. Click on OK, and then answer “yes” to see all combinations.
6. If you want a companion report showing Units Available, click on the drop down menu at the bottom of the page. Select Units Available. Click on Print, then click on Print again. The columns are already set up, so click OK. Answer “yes” and your report will print.