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, which is set to 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.

Example of a Menu Per Person, Set Price

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 84 shows an example of a menu per person, set price with an expected quantity of 10.

Table 84. Example of Menu Per Person, Set Price
Par-ent
Child
Quan-tity
Exten-ded Quan-tity
List Price
UOM
Unit Net Price
Nego-tiated Price
Exten-ded Price
Dis-count %
Net Dis-count
Per Person Allo-cation

Menu

Not appli-cable

10

10

50.00

Per Person

50.00

Not appli-cable

500.00

0

0

Not appli-cable

Chick-en

1

10

30.00

Per Person

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

25.00

Salad

1

10

20.00

Per Person

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

12.50

Des-sert

1

10

15.00

Per Person

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

12.50

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 Table 84, the Unit Net Prices are calculated as shown in Table 85.

Table 85. Extended Quantity Calculations Example
Parent
Child
Quantity
Calculation

Menu

Not applicable

10

10

Chicken

1

1 multiplied by 10

Salad

1

1 multiplied by 10

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 Table 84, the Unit Net Prices are calculated as shown in Table 86.

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

Menu

Not applicable

50.00

10

50 minus 5

45.00

Chicken

30.00

Not applicable

Not applicable

Not applicable

Salad

20.00

Not applicable

Not applicable

Not applicable

Dessert

15.00

Not applicable

Not applicable

Not applicable

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 Table 84, the Extended Price is calculated as shown in Table 87.

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

Menu

Not applicable

10

45.00

10 multiplied by 45

$450.00

Chicken

10

Not applicable

Not applicable

Not applicable

Salad

10

Not applicable

Not applicable

Not applicable

Dessert

10

Not applicable

Not applicable

Not applicable

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.

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