Siebel Hospitality Guide > Applying Quote and Order Pricing > About Quote Pricing for Meeting Packages >

About Calculating Field Values for Quote Meeting Packages


This topic shows the calculations that Siebel Hospitality uses to derive field values in records for meeting packages and associated items.

  • Expected for functions. Table 120 shows the formulas for calculating the Expected value for functions in a quote meeting package, according to the value options of the Applies To field.
    Table 120. Expected Value Calculations for Functions
    Applies To
    Calculation

    DD

    Expected = Sum of DD for Day N

    CMP

    Expected = ((CMP[Single]) + (2*(CMP[Double])) + (3*(CMP[Triple])) + (4*(CMP[Quad])) for Day N

    DD/CMP

    Expected = (Sum of DD for Day N) + (CMP[Single]) + (2*(CMP[Double])) + (3*(CMP[Triple])) + (4*(CMP[Quad])) for Day N

  • Quantity for function and nonfunction line items. Table 121 shows the formulas for calculating the Quantity values for function line items and nonfunction line items in a quote meeting package, according to the value options of the Applies To and UoM fields.
    Table 121. Quantity Value Calculations for Function Line Items and Nonfunction Line Items
    Applies To
    UoM
    Calculation

    DD

    Per Person

    Qty = (Sum of DD for Day N) * (Qty in Mtg Pkg Admin)

    CMP

    Per Person

    Qty = (CMP[Single] + (2*(CMP[Double])) + (3*(CMP[Triple])) + (4*(CMP[Quad])) for Day n) * (Qty in Mtg Pkg Admin)

    CMP

    Per Room

    Qty = (Sum of sleeping rooms for Day N) * (Qty in Mtg Pkg Admin)

    DD/CMP

    Per Person

    Qty = (Sum of DD for Day N + (CMP[Single])) + (2*(CMP[Double])) + (3*(CMP[Triple])) + (4*(CMP[Quad])) for Day n) * (Qty in Mtg Pkg Admin)

  • Price Per Day for meeting packages. Table 122 shows the formulas for calculating the Price Per Day values for a quote meeting package, according to the value options of the Attendee Type field. In other words, the table describes how the meeting package price per day is calculated for DD attendees, and for CMP attendees by sleeping room type and occupancy.
    Table 122. Price Per Day Value Calculations for Meeting Packages
    Attendee Type
    Calculation

    DD

    Package Price Per Day = (Sum of meeting package allocations for all line items that apply to DD)

    CMP

    (by sleeping room type and occupancy)

    Package Price Per Day = (Sum of "per day/Per person or each" meeting package allocations for all line items for a CMP * Occupancy) + (Sum of "per day/Per room" meeting package allocations for all line items for a CMP) + ((Sum of "per stay/Per person or each" meeting package allocations for all line items for a CMP * Occupancy)/package duration) + (Sum of "per stay/Per room" meeting package allocations for all line items for a CMP/package duration) + (Single Price for the sleeping room type + applicable occupancy offset)

Siebel Hospitality Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.