All is good here in Bangkok. I am enjoying Thailand immensely. I hope you are all well too.
Re the Rev Par figures, these should be calculated automatically in the sample form I gave you and discussed last August 18. (COMBINED RESERVATIONS OCC & REV CHART sample--- refer to July page for the suggested format).
If you recall, I asked you (through Jeans) to come up with the production reports so we can track the source of the bookings. (Please see Consolidated Production Reports email dated July 28).
Then on August 7, I sent (through Jeans) a revised reservations chart that would help in tracking the source of the bookings, daily occ, daily adr, daily RevPar and daily revenue in one chart. (See OCC & REV Report email). I called the revised reservations chart COMBINED RESERVATIONS OCC & REV CHART. This format added cells at the bottom and formulas to calculate the figures automatically taking away the OOO rooms in the occupancy and RevPar. The formulas can be adjusted when management finalizes the Comp room and House Use room policies.
The information from the source of bookings can easily be monitored and Sales can use this to track room night production of all sources. (Any banquet revenue can be provided through the separate accounting reports.)
But the latest Reservations Chart dated August 24 does not have the new format. When will you be able to start using the new format?