Menu Per Person, Set Price Field Behaviors
This topic describes the behaviors and internal calculations that Siebel Hospitality performs for selected fields in a Menu Per Person, Set Price and its child items. These behaviors are typical of the Menu Per Person, Set Price menu type.
Best Attendance Field
If Actual is not null, Best Attendance is equal to Actual. If Actual is null and Guaranteed 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 Field
The Extended Quantity is calculated as the Parent Quantity multiplied by the Item Quantity, where Parent Quantity is equal to Best Attendance, for each child line item regardless of its UOM. You can manually modify the Extended Quantity of the parent and its child items.
For the parent package and static child line items, Siebel Hospitality does not perform this calculation, and Extended Quantity is the same as Quantity. Usually, all products associated with a Menu Per Person, Set Price have UOM is equal to Per Person.
Using values from the table in Example of a Menu Per Person, Set Price, the Unit Net Prices are calculated as shown in the following table.
| Parent | Child | Quantity | Calculation |
|---|---|---|---|
|
Menu |
N/A |
10 |
10 |
|
Menu |
Chicken |
1 |
1 multiplied by 10 |
|
Menu |
Salad |
1 |
1 multiplied by 10 |
|
Menu |
Dessert |
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, Set Price, the Unit Net Prices are calculated as shown in the following table.
| Parent | Child | List Price | Discount % | Calculation | Unit Net Price |
|---|---|---|---|---|---|
|
Menu |
N/A |
50.00 |
10 |
50 minus 5 |
45.00 |
|
Menu |
Chicken |
30.00 |
N/A |
N/A |
N/A |
|
Menu |
Salad |
20.00 |
N/A |
N/A |
N/A |
|
Menu |
Dessert |
15.00 |
N/A |
N/A |
N/A |
Extended Price Field
Extended Price is calculated as Extended Quantity multiplied by Unit Net Price for the parent menu. For the child line items, Extended Price is null and read only.
Using values from the table in Example of a Menu Per Person, Set Price, the Extended Price is calculated as shown in the following table.
| Parent | Child | Extended Quantity | Unit Net Price | Calculation | Extended Price |
|---|---|---|---|---|---|
|
Menu |
N/A |
10 |
45.00 |
10 multiplied by 45 |
$450.00 |
|
Menu |
Chicken |
10 |
N/A |
N/A |
N/A |
|
Menu |
Salad |
10 |
N/A |
N/A |
N/A |
|
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 Price of the parent menu, but not the Extended Net Prices of the child items.