Menu Per Person, Split Price Field Behaviors
This topic describes the behaviors and internal calculations that Siebel Hospitality performs for selected fields in a Menu Per Person, Split Price and its child items. These behaviors are typical of the Menu Per Person, Split Price menu type.
Quantity Field
In a Menu Per Person, Split Price, the default Quantity value of the menu items is 1. After adding a Menu Per Person, Split Price menu to an event, update the Qty fields manually to reflect the number of menus with that item that the guests want to order.
Best Attendance Field
If Actual is not null, Best Attendance is equal to Actual. If Actual is null and Guarantee is not null, Best Attendance is equal to Guaranteed. If Actual and Guaranteed are null and Projected is not null, Best Attendance is equal to Projected. If Actual, Guaranteed, and Projected are all null, Best Attendance is equal to Expected.
Extended Quantity for Non-Split Items Field
Extended Quantities for non-split menu items and for split menu items are calculated as follows:
Non-split items. Extended Quantity is calculated as Parent Quantity multiplied by Child Item Quantity, where Parent Quantity is equal to Best Attendance, for each child line item that is a per person item. You can manually modify the Quantity of the parent and the child items.
Split items. Extended Quantity is equal to Quantity.
Using values from the table in Example of a Menu Per Person, Split Price, the Extended Quantity is calculated as shown in the following table.
| Parent | Child | Split Pricing | Quantity | Calculation for Extended Quantity |
|---|---|---|---|---|
|
Split Menu |
N/A |
N/A |
10 |
10 |
|
Split Menu |
Chicken |
Yes |
3 |
3 |
|
Split Menu |
Beef |
Yes |
7 |
7 |
|
Split Menu |
Dessert |
N/A |
1 |
1 multiplied by 10 |
Unit Net Price Field
Unit Net Price is calculated as follows:
If Negotiated Price is null, the calculation is one of the following:
List Price minus (List Price multiplied by Discount %)
List Price minus Discount Amount
If Negotiated Price is not null, the calculation is one of the following:
Negotiated Price minus (Negotiated Price multiplied by Discount %)
Negotiated Price minus Discount Amount
Using values from the table in Example of a Menu Per Person, Split Price, the Unit Net Prices are calculated as shown in the following table.
| Parent | Child | Split Pricing | List Price | Discount % | Calculation | Unit Net Price |
|---|---|---|---|---|---|---|
|
Split Menu |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
|
Split Menu |
Chicken |
Yes |
30.00 |
10 |
30 minus (30 multiplied by 0.1) |
27.00 |
|
Split Menu |
Beef |
Yes |
20.00 |
N/A |
20 |
20.00 |
|
Split Menu |
Dessert |
N/A |
15.00 |
N/A |
N/A |
N/A |
Extended Net Price Field
The Extended Net Price is calculated as Extended Quantity multiplied by Unit Net Price for both the parent menu and the child line items.
Using values from the table in Example of a Menu Per Person, Split Price, the Unit Net Prices are calculated as shown in the following table.
| Parent | Child | Extended Quantity | Unit Net Price | Calculation | Extended Net Price |
|---|---|---|---|---|---|
|
Split Menu |
N/A |
10 |
50.00 |
10 multiplied by 50 |
$500.00 |
|
Split Menu |
Chicken |
3 |
27.00 |
3 multiplied by 30 |
$81.00 |
|
Split Menu |
Beef |
7 |
20.00 |
7 multiplied by 20 |
$140.00 |
|
Split Menu |
Dessert |
10 |
N/A |
N/A |
N/A |
Function Total Field
The Function Total field is located in the function record. This field shows the total value of the function. The Function Total field value includes the Extended Net Prices of the split menu child items, but not the parent menu.