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
|
|
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
|
|
|
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
|
|
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) |
|