RDPWin

Tutorial - Add a Rate Set

** Refers to new or updated subjects in this tutorial.

Specific references within this tutorial to specific screen displays may differ if data/demo files have not been updated.  It is advised that users get new data files before beginning a tutorial.


Add a Rate Set - LONG

RDPWin's demo data comes loaded with a simple room-only rate plan:  Long.  In order to set up this rate plan at a property, a rate set must be added for long term reservations.  Using the Season Table QL, a rate set is defined for monthly long term rates.

  1. From System | Rates | Rate Sets, select Add to open the Add Rate Sets screen.
  2. Click the Add button near the Rate Set drop-down to access the Add Rate Set Default screen.
    1. Enter Rate Set = LONG
    2. Enter Description = Long Term
    3. Set Season Table to QL - Long Term
    4. Set G/L Account to 40200 - Revenue - Nightly Room Charges
    5. Set Tax Category to 99 - Tax Exempt.  In most cases, reservations over 30 days are not charged tax.
    6. When the property wants to charge extra for weekend room nights, enter that amount here.  For the sake of this example, leave the amount at 0.00.  The form should look like:
  3. Since the LONG rate set default has been set, select LONG - Long Term from the Rate Set drop-down list.
  4. For most properties, a rate set should be set for each room type with different charges based on room type and season.  For purposes of this sample, set Room Type to All.
  5. Set Description as Long Term.
  6. Set the Season Table to QL - Long Term.  The table is set up to designate the month and number of days in the month.  For example, January has 31 days, February has 28 days most years, March has 31 days, and April has 30 days.  Season A represents months with 31 days such as January, March, and May;  Season B represents months with 30 days such as April, June, and September; and Season C is designated as February.  The number of A's in the Special Rate Days column of the table for SubRecord 0001 ("00" being the year 2000, and "01" being the first month January) which is January 2000 represents how many days are in January of 2000.  This becomes especially important when February 2000 (SubRecord 0002) displays 29 C's whereas there are 28 C's for February 2001 (SubRecord 0102).
  7. Using any calculator, determine the daily rate for each season (A=31 days, B=30, C=Feb or 28/29 based on leap year).  For this example, the long term monthly rate for all room types is $1,500.  Use the calculator to determine $1500/31 (Season A), $1500/30 (Season B), $1500/29-29 (Season C).  This gives a daily rate of $48.39 for Season A, $50 for Season B, and $53.57 for Season C in non-leap years and $51.72 in leap-years.
  8. Check the Seasonal Amounts checkboxes for A, B, and C.
  9. Enter Season A amount as $48.39, Season B amount as $50.00, and Season C amount as $53.57.  These are the average daily rates for the room types based on a long term reservation with a monthly rate of $1,500. 
  10. Click the Generate Rates button, save the rates, and click Close.



Click here for Tutorials Index.

Click these links for Frequently Asked Questions or Troubleshooting assistance.

Last Updated 08/05/2008

© 1983-2004 Resort Data Processing, Inc. All rights reserved.