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

Menu Per Person, Split Price Reference


A Menu Per Person, Split Price can have a choice of items. The calculations are different from a Menu Per Person, Set Price and are controlled by the Split flag value, which is set to Y.

Example of a Menu Per Person, Split Price

Table 88 shows an example of a menu per person, split price with 10 expected attendees, who order 3 menus with a Chicken entree and 7 menus with a Beef entree.

Table 88. Example of Menu Per Person, Split Price
Par-ent
Child
Quan-tity
Exten-ded Quan-tity
Split Pric-ing
List Price
UOM
Unit Net Price
Nego-tiated Price
Exten-ded Net Price
Dis-count %
Net Dis-count
Per Person Alloc-ation

Menu

Not appli-cable

10

10

Not appli-cable

 

Per Person

50.00

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Chick-en

3

3

Yes

30.00

Per Person

27.00

30.00

81.00

10

9.00

27.00

Beef

7

7

Yes

20.00

Per Person

20.00

20.00

140.00

Not appli-cable

Not appli-cable

20.00

Des-sert

10

10

Not appli-cable

Not appli-cable

Per Person

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

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 Table 88, the Extended Quantity is calculated as shown in Table 89.

Table 89. Extended Quantity Calculations Example
Parent
Child
Split Pricing
Quantity
Calculation for Extended Quantity

Split Menu

Not applicable

Not applicable

10

10

Chicken

Yes

3

3

Beef

Yes

7

7

Dessert

Not applicable

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

Table 90. Unit Net Price Calculations Example
Parent
Child
Split Pricing
List Price
Discount %
Calculation
Unit Net Price

Split Menu

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Not applicable

Chicken

Yes

30.00

10

30 minus (30 multiplied by 0.1)

27.00

Beef

Yes

20.00

Not applicable

20

20.00

Dessert

Not applicable

15.00

Not applicable

Not applicable

Not applicable

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

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

Split Menu

Not applicable

10

50.00

10 multiplied by 50

$500.00

Chicken

3

27.00

3 multiplied by 30

$81.00

Beef

7

20.00

7 multiplied by 20

$140.00

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 Prices of the split menu child items, but not the parent menu.

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