25Applying Quote and Order Pricing
Applying Quote and Order Pricing
This chapter provides conceptual topics and examples that explain typical quote and order pricing processes. It includes the following topics:
About Quote and Order Pricing
Property pricing administrators are responsible for setting prices at each property for products and services that are sold to large groups requiring sleeping rooms, function space and catering products. Prices quoted to customers vary by property, product type, customer, date, day of week, day part, and other factors. A sales representative can apply these prices to sleeping rooms, function space, and other ancillary products (for example food, beverages, and audiovisual services) that are sold during an event. Siebel Hospitality employs a rules-based pricing system that applies prices to a quote according to pricing data that exists in the Siebel Hospitality database. After system-based recommendations appear in the quote, further negotiations with the customer result in a finalized quote (with price overrides). This finalized quote is then converted into an order.
Pricing management involves three primary pricing processes:
Pricing data management and pricing administration. For more information, see Setting Up Pricing and Property Pricing.
Quote and Order Pricing. This chapter cover the basics of quote and order pricing.
Revenue management and profitability analysis. For more information, see Managing Hospitality Revenue.
About Function Space Pricing
Function space pricing is determined by the rental price for the function space and also the profit and revenue thresholds for the function space. These pricing factors are defined by the pricing administrator. This topic describes how function space prices are calculated, and contains the following topics:
Function Space Room Rentals
Function space room rentals are defined for the days of the week, and can change from season to season, as well as by parts of the day. When an administrator sets up function space room rates for a hospitality property, the administrator establishes default rentals for each day of the week as well as the exceptions for different seasons. For more information, see Defining Function Space Pricing Rules.
Users can use function space room rentals as benchmark rental prices for a quote or order, before pricing adjustments are made.
Profit and Revenue Thresholds
Thresholds are predetermined amounts that indicate how much profit must be made by the hospitality property to complete the booking. Some hospitality companies only accept function space business if a predetermined profit threshold amount is met for a property event. This mechanism is used to qualify event opportunities at a property according to the revenue and profit potential of the event.
The Revenue Manager can override the threshold and approve a quote even if it does not meet the threshold or has a negative threshold profit variance.
Thresholds are defined by revenue managers for function space by days and day parts. For more information, see Administering Function Space Pricing.
When thresholds are calculated, the following rules are applied:
Any time a function touches a day part, even for a few minutes, the function space category threshold value for the day part is applicable.
The functions for threshold calculation are considered along with established turntimes.
Example of a Threshold Calculation with Applied Rules
This example explains the threshold calculation that occurs when three functions take place in the same function space called FSC 1. The following table shows the functions and time intervals.
Table Threshold Calculation for Functions in Same Function Space
Function Name | Function Type | Start Time | End Time | Function Space |
---|---|---|---|---|
Function 1 |
Meeting |
5:00 A.M. |
11:59 A.M. |
FSC 1 |
Function 2 |
Lunch |
12:10 P.M. |
1:00 P.M. |
FSC 1 |
Function 3 |
Reception |
3:00 P.M. |
11:00 P.M. |
FSC 1 |
To calculate the required threshold for each function, Siebel Hospitality determines the number of day parts the function covers. The day part is included even if the function only uses a few minutes of the day part.
Siebel Hospitality then determines the threshold associated with each of the day parts listed for the function. The following table shows how day parts are set up for the property.
Table Example Setup of Day Parts for a Property
Day Part Name | Start Time of Day Part | End Time of Day Part |
---|---|---|
Overnight |
12:00 A.M. |
6:00 A.M. |
Morning |
6:00 A.M. |
9:00 A.M. |
Afternoon |
9:00 A.M. |
12:00 P.M. |
Lunch |
12:00 P.M. |
2:00 P.M. |
Evening |
2:00 P.M. |
6:00 P.M. |
Night |
6:00 P.M. |
12:00 P.M. |
The following table shows the thresholds that are in effect. The assumption is that function space category (FSC) 1 and 2 have the same threshold amount.
Table Thresholds in Effect for Day Parts
Day Part | Function Space | Threshold |
---|---|---|
Overnight |
FSC 1, FSC 2 |
100 |
Morning |
FSC 1, FSC 2 |
200 |
Afternoon |
FSC 1, FSC 2 |
500 |
Lunch |
FSC 1, FSC 2 |
300 |
Evening |
FSC 1, FSC 2 |
800 |
Night |
FSC 1, FSC 2 |
800 |
The following table shows how the required threshold calculation occurs, assuming the turntimes are zero.
Table Threshold Calculation for Day Parts and Function Spaces
Function Space | Function | Day Part Touched | Threshold for Function Day Part | Threshold Sum for Function |
---|---|---|---|---|
FSC 1 |
F1 |
Overnight, Morning, Afternoon |
100 plus 200 plus 500 |
800 |
FSC 1 |
F2 |
Lunch |
300 |
300 |
FSC 1 |
F3 |
Evening, Night |
800 plus 800 |
1600 |
Required Threshold |
Not applicable |
Not applicable |
Not applicable |
2700 |
As can be seen from the preceding table, the thresholds are calculated as follows:
Threshold Sum for Function equals Sum of the Thresholds for Function Day Parts
Required Threshold equals Sum of the Threshold Sum for Function
The following exceptions can be applied when the required threshold is calculated:
If two functions (from the same quote) exist within the same day part for the same function space, then the day part is only counted once.
If a customer requests that two functions be booked within the same day part for different specific spaces, then the threshold is counted for each separate room.
If two functions belong to different categories, and both categories share the same component indivisible space as well as a day part, then only the threshold of the larger category is counted.
Function Line Item and Revenue Data Repricing
The user can recalculate the pricing for functions, roll up line item changes, and revise revenue data using the Reprice All and Refresh buttons. The Reprice, Reprice All, and Refresh buttons appear on the following views:
Reprice Button
The Reprice button is used to recalculate the price of individual functions or line items when new functions or line items are added or function space is changed. Multiple functions or line items can be selected and repriced at the same time. If Reprice is started from the Functions list applet in the Orders Functions view or Quotes Functions view, then all the line items in the selected function are repriced and then selected functions are refreshed.
If Reprice is started from the Function Line Items list applet, Siebel Hospitality retrieves the current price for the selected line item.
The Reprice button appears on the following views:
Quotes screen, Functions view
Orders screen, Function Line Items view
Functions screen, Function List view
Users cannot use this button when dealing with nonparticipating properties (NPPs).
Reprice All Button
The Reprice All button is used to recalculate the price of all the functions in the function list. Reprice All is typically used when pricing is required for items that were previously flagged for pricing bypasses or if a new pricing scenario is being explored at the sales prospect stage. If the user starts Reprice All from the Orders Functions view or the Quotes Functions view, all of the line items are repriced at the same time.
When the user clicks Reprice All at the function level, the following actions occur:
The room rental amounts are aggregated for all functions because room rental charges change depending on the day of the week.
The required threshold is calculated.
All catering products for the quote are repriced.
Catering revenue and profit is calculated.
The Profit threshold variance is calculated.
Revenue threshold variance is calculated again.
When the user clicks Reprice All at the function line item level, Siebel Hospitality retrieves the current prices for all the line items in the current function.
The Reprice All button appears on the following views:
Order screen, Function Line Items view
Quotes screen, Functions view
Functions screen, Function list view
Users cannot use this button when dealing with nonparticipating properties (NPPs).
Refresh Button
The Refresh button is used to roll up line item changes and recalculate revenue data that appears in the Quotes screen, Function Revenue Estimates view after changes are made to the line items. If there are no line item changes, no action occurs when the button is clicked.
When a change is made to a line item, the Need Refresh flag appears to remind users that the Refresh button must be clicked for revenue recalculation. Clicking Refresh in the Quotes screen, Functions view rolls up revenues from the line items to the function, and then to the quote. If the Line Item Sum flag is selected, then the sum of the line items is rolled up to the quote level; otherwise, the projected revenue values are rolled up to the quote level.
Clicking Refresh from the Quote Summary view rolls up revenue from sleeping rooms and functions to the quote level.
When a user clicks Refresh at the function level, the following actions occur:
Catering revenue and profit is updated to reflect the updated revenue and profit of the selected functions.
The Profit Threshold Variance is calculated.
The Profit Variance is updated.
The Required Threshold is recalculated.
The Revenue Threshold Variance is recalculated.
The average values are retrieved and aggregated in the Function Revenue Estimates.
Quote Revenue Estimates are retrieved either from the average values or line items depending on the value in the Line Item Sum field.
If the flag in the Line Item Sum field is selected, then the revenue estimates are retrieved from the function line items.
If the flag in the Line Item Sum field is not selected, then the revenue estimates are retrieved from the average values of the functions.
The opportunity revenue is updated with the projected quote revenue.
The Refresh button appears on the following views:
Quote Functions view
Quote Summary view
About Sleeping Room Pricing
Although a benchmark room rate is applied to sleeping rooms, the pricing can vary depending on the following factors:
Room type
Day of week (for example, on Sunday, increase by 5%; on Monday, increase by 15%)
Seasonality (date ranges)
Special Dates (overrides)
The benchmark rate for each room type is defined as an item in the pricing matrix of the property. There are seven benchmark prices for each room type, comprising an individual benchmark price for each day of the week. Additional pricing adjustments to benchmark prices are made using matrix-based pricing factors that detail pricing adjustments such as price overrides, price markup, discount amount, discount %, and % mark up. For more information about matrix pricing, see Setting Up a Matrix Series.
This topic contains the following topics:
Pricing and Room Occupancy
Any time a group sale occurs, the sales user captures occupancy information that is applied to the entire room block. This information includes:
Occupancy Percentage. The percentage of rooms that are single, double, triple, and quads.
Occupancy Price Offsets. The pricing offsets to be applied for each type of occupancy.
The following table shows the contracted value and price for a standard room on three different dates.
Table Example Contracted Value and Price for Standard Room on Different Dates
Room Type | Date | Contracted | Price |
---|---|---|---|
Standard |
Jan. 5 |
100 |
100 |
Standard |
Jan. 6 |
200 |
110 |
Standard |
Jan. 7 |
300 |
120 |
Assume that the following information is entered in the Room Block Info record:
Occupancy %
The following information is entered for Occupancy %:
Single % equals 50
Double % equals 50
Occupancy Price Offset
The following information is entered for Occupancy Price Offset:
Double Price Offset equals 20
The following actions occur during weighted average price calculations:
The room price is retrieved for each room type in the Room Block Line Items list.
The weighted average price is calculated for each room type.
After the weighted average price is calculated, the price offsets are applied.
In this example, the weighted average price for the 50% single-room type occupancy is:
(50 multiplied by 100 plus 100 multiplied by 110 plus 150 multiplied by 120) divided by (50 plus 100 plus 150) equals $113.33
The weighted average price for double rooms occupancy is:
Weighted Average Price (Double Occupancy) equals Weighted Average Price (Single Occupancy) plus Price Offset for double.
Weighted Average Price (Double Occupancy) equals $113.3 plus $20 equals $133.33
Complimentary Room Pricing
Sales representatives and sales managers can specify a number of complimentary sleeping rooms for an event. The complimentary number is not factored in when room availability is checked, but the number is relevant when the weighted average sleeping room rate is calculated. Complimentary rooms also are not factored into the calculation of total revenue that appears in the Quote Summary report.
For example, assume a quote has been generated for a group event, and the information appears in the Quotes screen, Room Blocks view. The specified occupancy for the group is single, and the property does not set different rates for weekends and weekdays.
The complimentary numbers of rooms are included in the contracted, projected and blocked numbers. As the following table shows, on July 5 there are 100 contracted rooms that include 10 complimentary rooms and 90 rooms that are not complimentary.
Table Contracted Rooms Including Complimentary and Noncomplimentary Rooms
Room Type | Contracted | Projected | Blocked | Comp | Single Price | Date |
---|---|---|---|---|---|---|
STD |
100 |
90 |
95 |
10 |
150 |
July 5 |
STD |
130 |
80 |
90 |
20 |
120 |
July 6 |
The total rooms that are contracted and complimentary for this event is taken into account when revenue is calculated, as the following table shows.
Table Calculated Revenue for Contracted and Complimentary Rooms
Date | Contracted | Complimentary | Revenue Calculation # | Single Price | Revenue |
---|---|---|---|---|---|
July 5 |
100 |
10 |
90 |
150 |
150 multiplied by 90 equals 13500 |
July 6 |
130 |
20 |
110 |
120 |
110 X120 equals 13200 |
Using these figures, the calculations for Total Revenue and Total Rooms Nights are:
Total Revenue equals 13500 plus 13200 equals 26700
Total Room Nights equals 100 plus 130 equals 230
The following table shows the Average Rate calculation, including Complimentary rooms.
Table Average Rate Calculation Including Complimentary Rooms
Start Date | End Date | Total Room Nights | Total Revenue | Average Rate with Comp |
---|---|---|---|---|
July 5 |
July 6 |
230 |
26700 |
26700 divided by 230 equals 116 |
The following table shows the Average Rate calculation, excluding Complimentary rooms.
Table Average Rate Calculation Excluding Complimentary Rooms
Start Date | End Date | Total Room Nights | Total Revenue | Average Rate |
---|---|---|---|---|
July 5 |
July 6 |
230 |
30600 |
30600 divided by 230 equals 133 |
The user can view both the Average Rate and the Average Rate with Complimentary Rooms by navigating to the Quotes screen, Room Blocks Negotiation Rates view.
Scenarios for Weekday and Weekend Pricing
Some properties employ business rules that require different rates for weekdays and weekends. This is because the guest profile on weekdays (often business travelers) can be different from the guest profile on weekends (often leisure travelers). In this case, each room block can have a weekday rate and a weekend rate. For properties that do not use different rates for weekdays and weekends, the average rate is always applied to each room type during an event.
This topic gives the following examples of how weekday and weekend pricing might be used. These scenarios illustrate the variances in room revenue for a property that uses different weekday and weekend pricing, and a property that uses the average rate for each day of the week. You might use weekday and weekend pricing differently, depending on your business model.
Applying Weekday and Weekend Pricing
A three-day event is planned, with room blocks booked for Monday, Tuesday and Wednesday. Each property defines weekdays as Monday through Friday, and weekend days as Saturday and Sunday.
Property 1 uses weekday and weekend rates, while Property 2 uses the average rate for each day of the week. Property 2 does not have weekday and weekend rates.
As the following table shows, for Property 1 the total room price for the three days equals $10,000 ($2000 plus $6000 plus $2000). The average weekday rate is calculated as $10,000 divided by 40 total rooms equals $250. The average weekend rate is null, because the event did not continue into the weekend.
The total room price is the same for Property 2, which uses an average rate regardless of the day.
Table Total Room Price Calculation Using Weekend-Weekday Rate and Average Rate
Property 1 and Property 2 | Monday | Tuesday | Wednesday |
---|---|---|---|
Quoted # Standard Rooms |
10 |
20 |
10 |
Price per Room |
200 |
300 |
200 |
Total Room Price per Day |
2000 |
6000 |
2000 |
Applying Average-Rate Pricing
An event lasts two days and requires room blocks for Tuesday and Saturday. In this case, there are weekday and weekend rate for Property 1. The following table shows Property 1 with the following rates:
Average Weekday Rate equals $2000 divided by 10 equals $200
Average Weekend Rate equals $3000 divided by 10 equals $300
Table Weekday and Weekend Rate Calculation for Property 1
Property 1 | Tuesday (Weekday) | Saturday (Weekend) |
---|---|---|
Quoted # Standard Rooms |
10 |
10 |
Price per Room |
200 |
300 |
Total Room Price per Day |
2000 |
3000 |
For Property 2, only one calculation is required to calculate the average rate for each room type as shown in the following calculation:
Average Rate equals $5000 divided by 20 equals $250
In essence, weekend and weekday pricing for sleeping rooms is only weighted average pricing.
Calculating Weighted Average Room Rates
For quotes involving room rates that span multiple days, the weighted average room rate is returned in the Quote Room Block Negotiation Rates view.
To calculate the weighted average room rate, the adjusted benchmark room rates for each room type are retrieved and then summed. The total is then divided by the total room nights for each room type. The value returned to the quote is a weighted average of the various prices over multiple days.
For example, the Weighted Average Room Rate equals the sum of room revenue across multiple days for each room type divided by the sum of room nights for each room type.
Pricing and the Negotiation Floor
The negotiation floor defines the maximum discount that the sales representative or sales manager can give to the customer after all prices have been returned by the pricing engine. The Negotiation Rate and Weekend Negotiation Rate cannot be set to a value less than the Average Floor and Weekend Floor, respectively. If the sales representative or sales manager wants to give a discount which is less than the negotiation floor, then that user can submit a request to the revenue manager to approve the discount. For more information, see Managing Hospitality Revenue.
The following table shows an example of pricing for a property that does not have different rates for weekends and weekdays.
Table Example Pricing for Property with Weekday and Weekend Rates
Date | Room Type | Contracted | Single Price | Day | Floor |
---|---|---|---|---|---|
Jan. 5 |
Standard |
100 |
200 |
Sun |
180 |
Jan. 6 |
Standard |
30 |
150 |
Mon |
135 |
The Floor value displayed in the table is calculated as Single Price minus Negotiation Floor. The Negotiation Floor value is set in the Property Pricing screen. In this case, the Single Price is 200.00 and the Negotiation Floor is 20.00. For more information about the Negotiation Floor value, see Setting Up Rates for Sleeping Rooms.
Given this example, the following table shows the values that appear in the Quote Room Blocks Negotiation Rates view.
Table Values Appearing in Quote Room Blocks Negotiation Rates View
Start Date | End Date | Average Rate | Average Floor | Negotiation Rate |
---|---|---|---|---|
Jan. 5 |
Jan. 6 |
188.46 |
169.62 |
188.46 |
The Average Rate is calculated as:
(100 multiplied by 200 plus 150 multiplied by 30) divided by 130 equals $188.46
The Average Floor is calculated as:
(100 multiplied by 180 plus 30 multiplied by 135) divided by 130 equals $169.62
On occasion, it is possible that the calculated average rate falls below the average floor. In that case, the Average Rate is set to the same as Average Floor. In the example given in the second table in this topic, if the real average rate from the calculation is less than 169.62 (for example, if it is at 165.50), it shows as 169.62.
Minimum and Maximum Price
The user can define the minimum and maximum price for each room type. If minimum and maximum prices are not defined, then the minimum and maximum prices are null as opposed to zero. Setting minimum and maximum prices makes sure pricing does not go beyond or fall short of the set prices after all pricing rules are applied.
About Suite Pricing
The sales representative has the option of booking a suite category as a room block line item and then booking a specific suite if he or she chooses to. In addition, after a specific suite has been booked, the customer can choose to schedule a function within the specific suite. The following example illustrates this situation.
In this case, a specific suite has been booked as a sleeping room and is priced as a sleeping room rather than a function space. The specific suite is booked as a sleeping room from 4 P.M. until 9 A.M. the next morning. If the customer decides to schedule a function from 5 to 6 P.M. within this specific suite, which the customer has paid for, the function is not charged an additional fee. In other words, the customer is not charged twice for using the same space for different purposes.
About Quote Pricing for Meeting Packages
This topic describes how Siebel Hospitality calculates pricing details for quotes that include meeting packages. This topic covers the following subjects:
About Mapping Adjustment Types to Line Item Fields
The following table describes how pricing adjustments are mapped to the applicable line item fields according to the selection options for Adjustment Type field values in the meeting package administration records.
Table Adjustment Type to Line Item Field Mappings
If Adjustment Type is equal to… | Then Value is mapped to this line item field… |
---|---|
Discount Amount |
Discount Amount |
% Discount |
Discount % |
Markup Amount |
Discount Amount. Markups are displayed in parentheses, for example, ($10). |
% Markup |
Discount %. Markups are displayed with a minus sign, for example, -10%. |
Price Override |
Negotiated Price |
Per Person Allocation |
Negotiated Price. In this case, Negotiated Price is equal to Value multiplied by Expected. |
About Mapping Rental Allocations to Function Space Line Items
Rental allocation is a per-person cost. Because multiple function spaces can be assigned to each function, only the primary function space receives the rental allocation. In the primary function space record, the Negotiated Price of the function space line item is calculated as Rental Allocation multiplied by Expected.
If the primary function space is changed to a different function space, the following actions occur.
Previous space. The previous primary function space line item field values are changed as follows:
Negotiated Price is set to null.
Core check box is cleared.
Package is set to null.
New space. The new primary function space line item field values are changed as follows:
Negotiated Price is equal to Rental Allocation multiplied by Expected.
Core check box is selected.
Package is set to the parent function meeting package.
About Split Menus in Meeting Packages
If a split menu is part of a meeting package, then the Quantity fields for the split line items are editable. Siebel Hospitality does not validate that the sum of the child line item quantities is equal to the quantity at the parent menu level.
In the meeting package administration record, the allocation for a split menu is defined at the parent menu level. For a split menu on a quote, each split item is assigned the parent menu allocation set in the meeting package administration record. The non-split child items do not receive revenue allocations. Revenue for a split menu is based on the main course that is selected for each attendee. Consequently, revenue categories for a split menu are based on the revenue categories that are set for the main course split items.
Scenario for Processing a Split Menu in a Quote Meeting Package
This topic gives one example of how a split menu is processed as part of a meeting package in a quote. You might use split menus in meeting packages differently, depending on your business model.
In the meeting package administration record, the allocation for a split menu equals 30.00. When this meeting package is added to a quote, the allocation value is set for each split item of the parent split menu. The line item allocation for a split item is mapped to Negotiated Price. The line item receives the value set at the parent menu level.
The following table shows how a split menu is represented on a quote with an associated meeting package, where the Expected value for this function is 20.
Table Example of a Split Menu in a Quote Meeting Package
Parent Item — Child Item |
Split | Split Price | Negotiated Price | Qty | Ext. Qty | Unit Net Price | Ext. Net Price | Rev. Estimate |
---|---|---|---|---|---|---|---|---|
Split Menu |
NA |
NA |
NA |
20 |
20 |
NA |
NA |
NA |
— Chicken |
Yes |
10.00 |
30.00 |
10 |
10 |
30.00 |
300.00 |
300.00 |
— Steak |
Yes |
10.00 |
30.00 |
10 |
10 |
30.00 |
300.00 |
300.00 |
— Dessert |
No |
NA |
NA |
20 |
20 |
NA |
NA |
NA |
A user enters the Qty values for the split items (Item 1 and Item 2). The Split Price field displays the value set for this product in the property administration record, rather than the meeting package allocation value. Siebel Hospitality ignores the Split Price values for split items that belong to a meeting package. The value in the Negotiated Price overrides these values. Revenue estimates for a split menu are calculated from the split line items of the parent split menu.
Scenario for Processing a Set Menu in a Quote Meeting Package
This topic gives one example of how a set menu that does not include split items is processed as part of a meeting package in a quote. You might use set menus in meeting packages differently, depending on your business model.
The administration record for the Menu Per Person is shown in the following table.
Table Example of a Menu Per Person
Parent Item — Child Item |
Quantity | UOM | List Price |
---|---|---|---|
Menu |
1 |
Per Person |
50.00 |
— Chicken |
1 |
Per Person |
30.00 |
— Salad |
1 |
Per Person |
20.00 |
— Dessert |
2 |
Per Person |
15.00 |
When the menu is associated with a quote meeting package, the line item calculations for a Menu Per Person that does not include split items, with an Expected value of 10, are shown in the following table.
Table Example of a Menu Per Person in a Quote Meeting Package
Parent Item — Child Item |
Quantity | Extended Quantity | List Price | UOM | Unit Net Price | Extended Price |
---|---|---|---|---|---|---|
Menu |
10 |
10 |
50.00 |
Per Person |
50.00 |
500.00 |
— Chicken |
1 |
10 |
30.00 |
Per Person |
Not applicable |
Not applicable |
— Salad |
1 |
10 |
20.00 |
Per Person |
Not applicable |
Not applicable |
— Dessert |
2 |
20 |
15.00 |
Per Person |
Not applicable |
Not applicable |
For each child line item, Extended Quantity is calculated as Parent Quantity multiplied by Item Quantity, regardless of its Unit of Measure. The Parent Quantity value for menus in a meeting package is equal to the Expected value.
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. The following table 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 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. The following table 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 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. The following table 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 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)