Siebel Hospitality Guide > Managing Property-Specific Menus and Packages > Menu and Package Types Reference >

Menu Per Person, Set Price Reference


The Menu Per Person, Set Price menu type is used when you can estimate an expected number of guests. The calculations are different from a Menu Per Person, Split Price and are controlled by the Split flag value = N. In Menu Per Person, Set Price, Siebel Hospitality adds the menu prices together and displays them on a per person basis. Actual child line item quantities are reflected in the Extended Quantity fields. The child prices do not roll up to the parent price.

Menu Per Person, Set Price Example

In a Menu Per Person, Set Price, the Unit Net Price, Extended Price, Negotiated Price, Discount %, and Net Discount values apply only to the parent package. For child items, these values are not displayed and the fields are read only.

Table 57 shows an example of a menu per person, set price with an expected quantity of 10.

Table 57. Example of Menu Per Person, Set Price
Parent
Child
Quantity
Extended Quantity
List Price
UOM
Unit Net Price
Negotiated Price
Extended Price
Discount %
Net Discount
Per Person Allocation

Menu

N/A

10

10

50.00

Person

50.00

N/A

500.00

0

0

N/A

Chicken

1

10

30.00

Person

N/A

N/A

N/A

N/A

N/A

25.00

Salad

1

10

20.00

Person

N/A

N/A

N/A

N/A

N/A

12.50

Dessert

1

10

15.00

Person

N/A

N/A

N/A

N/A

N/A

12.50

Menu Per Person, Set Price Field Behaviors

This topic describes the behaviors and the 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

If Actual is not null, Best Attendance = Actual. If Actual is null and Guaranteed is not null, Best Attendance = Guaranteed. If Actual and Guaranteed are null and Projected is not null, Best Attendance = Projected. If Actual, Guaranteed, and Projected are all null, Best Attendance = Expected.

Extended Quantity

The Extended Quantity is calculated as Parent Quantity * Item Quantity, where Parent Quantity = 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 = Person.

Using values from Table 57, the Unit Net Prices are calculated as shown in Table 58.

Table 58. Extended Quantity Calculations Example
Parent
Child
Quantity
Calculation

Menu

N/A

10

10

Chicken

1

1 * 10

Salad

1

1 * 10

Dessert

1

1 * 10

Unit Net Price

Unit Net Price is calculated as follows:

If Negotiated Price is null, the calculation is one of the following:

    • List Price - (List Price * Discount %)
    • List Price - Discount Amount

If Negotiated Price is not null, the calculation is one of the following:

    • Negotiated Price - (Negotiated Price * Discount %)
    • Negotiated Price - Discount Amount

Using values from Table 57, the Unit Net Prices are calculated as shown in Table 59.

Table 59. Unit Net Price Calculations Example
Parent
Child
List Price
Discount %
Calculation
Unit Net Price

Menu

N/A

50.00

10

50 - 5

45.00

Chicken

30.00

N/A

N/A

N/A

Salad

20.00

N/A

N/A

N/A

Dessert

15.00

N/A

N/A

N/A

Extended Price

Extended Price is calculated as Extended Quantity * Unit Net Price for the parent menu. For the child line items, Extended Price is null and read only.

Using values from Table 57, the Extended Price is calculated as shown in Table 60.

Table 60. Extended Price Calculations Example
Parent
Child
Extended Quantity
Unit Net Price
Calculation
Extended Price

Menu

N/A

10

45.00

10 * 45

$450.00

Chicken

10

N/A

N/A

N/A

Salad

10

N/A

N/A

N/A

Dessert

10

N/A

N/A

N/A

Function Total

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.

Siebel Hospitality Guide Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices.