5 Email draft

Email draft to the revenue manager. Built by code from the report and Pam's rate options. Nobody sent it: a person reads it and clicks send.

To: the revenue manager (from the script settings)

Subject: Week of Mon Oct 18: 2 nights below the line, rate options inside

Hi,

Here is the week ahead for HOTEL-001 (fictional data).

• Next 7 nights: 66.6% on the books, +9.3 points on the last 7 nights.
• 2 nights below 63%: Mon Oct 18 (60.4%), Sat Oct 23 (62.7%).

Rate options for each weak night. Pam changes no rate; you decide:

Monday 2027-10-18 · 60.4% on the books, 490 rooms available
Option 1 · Hold RATE-002 at $175.50 for two people. Tonight is the business date, so a lower price reaches few new guests this late.
Option 2 · Offer RATE-002 at $117.00 for one person. It is the lowest price in the list for this date.

Saturday 2027-10-23 · 62.7% on the books, 461 rooms available
Option 1 · Hold RATE-002 at $175.50 for two people. Sunday is strong, so two-night stays can carry Saturday.
Option 2 · Lead with RATE-002 at $117.00 for one person on Saturday only, to fill the gap five days ahead.

The report and the insights are attached.

The revenue team