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 = Y.

Menu Per Person, Split Price Example

Table 61 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 61. Example of Menu Per Person, Split Price
Parent
Child
Quantity
Extended Quantity
Split Pricing
List Price
UOM
Unit Net Price
Negotiated Price
Extended Net Price
Discount %
Net Discount
Per Person Allocation

Menu

N/A

10

10

N/A

 

Person

50.00

N/A

N/A

N/A

N/A

N/A

Chicken

3

3

Y

30.00

Person

27.00

30.00

81.00

10

9.00

27.00

Beef

7

7

Y

20.00

Person

20.00

20.00

140.00

N/A

N/A

20.00

Dessert

10

10

N/A

N/A

Person

N/A

N/A

N/A

N/A

N/A

N/A

Menu Per Person, Split Price Field Behaviors

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

In a Menu Per Person, Split Price, the Quantity of the menu items defaults to 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

If Actual is not null, Best Attendance = Actual. If Actual is null and Guarantee 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 for Non-Split Items

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 * Child Item Quantity, where Parent Quantity = 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 61, the Extended Quantity is calculated as shown in Table 62.

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

Split Menu

N/A

N/A

10

10

Chicken

Y

3

3

Beef

Y

7

7

Dessert

N/A

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

Table 63. Unit Net Price Calculations Example
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

Chicken

Y

30.00

10

30 - (30 x 0.1)

27.00

Beef

Y

20.00

N/A

20

20.00

Dessert

N/A

15.00

N/A

N/A

N/A

Extended Net Price

The Extended Net Price is calculated as Extended Quantity * Unit Net Price for both the parent menu and the child line items.

Using values from Table 61, the Unit Net Prices are calculated as shown in Table 64.

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

Split Menu

N/A

10

50.00

10 * 50

$500.00

Chicken

3

27.00

3 * 30

$81.00

Beef

7

20.00

7 * 20

$140.00

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

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