Bookshelf Home | Contents | Index | PDF

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