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

Package Per Person Reference


A Package Per Person provides a method of mixing different types of items, such as a Package Each and a Per Person, into one package. In this way, a Package Per Person can show a realistic representation of child menus or packages broken into a per person basis, while taking into account static price items.

Package Per Person Example

In a Package Per Person, 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 44 shows an example of a package per person with an expected quantity of 50.

Table 44. Example of Package Per Person
Parent
Child
Quantity
Extended Quantity1
List Price
UOM
Unit Net Price
Extended Price
Negotiated Price
Discount %
Net Discount
Per Person Allocation

Package

N/A

50

50

60.00

Person

60.00

3000.00

0

0

0

N/A

Menu

1

50

50.00

Person

N/A

N/A

N/A

N/A

N/A

30.00

A/V

1

1

400.00

Each

N/A

N/A

N/A

N/A

N/A

15.00

Ice Sculpture

2

2

100.00

Each

N/A

N/A

N/A

N/A

N/A

15.00

1 Calculated rollup

Package Per Person Field Behaviors

This topic describes the behaviors and the internal calculations that Siebel Hospitality performs for selected fields in a Package Per Person and its child items. These behaviors are typical of the Package Per Person package type.

Quantity

For the parent package, set to the # Guaranteed or Expected, in that order, when either of these fields is changed. If Guaranteed is null, Expected is used. For child items, defaults to the value set up by the administrator.

Extended Quantity

For the parent package and static child items, displays the same value as Quantity. For each child line item that is a per person item (that is, where UoM = Person), Extended Quantity is calculated as parent Quantity * child item Quantity, where parent Quantity = Best Attendance. For the parent package and static child line items, this calculation is not done and the Extended Quantity is the same as Quantity.

The Quantity of the parent item and of the child items can also be manually modified. If the parent is a package per person, the parent Quantity behaves as if the UoM = Person even if this is not explicitly specified on the parent record.

Using example values from Table 44, the Extended Quantity is calculated as shown in Table 45.

Table 45. Extended Quantity Calculations Example
Parent
Child
UOM
Quantity
Calculation
Extended Quantity

Package

N/A

Person

50

50

50

Menu

Person

1

1 * 50

50

A/V

Each

1

1 * 1

 1

Ice Sculpture

Each

2

2 * 1

 2

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 both null and Projected is not null, Best Attendance = Projected. If Actual, Guaranteed, and Projected are all null, Best Attendance = Expected.

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
Extended Net Price

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

Using example values from Table 44, the Extended Price is calculated as shown in Table 46.

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

Package

N/A

50

60.00

50 * 60

$3000.00

Menu

50

50.00

50 * 50

$2500.00

A/V

1

400.00

1 * 400

$400.00

Ice Sculpture

2

100.00

2 * 200

$200.00

Discount %

Percent of the discount to be applied to a line item price. You can specify a Discount % or a Discount Amount, but not both for the same item. If Discount % is specified, Discount Amount is null.

Discount Amount

Amount of the discount to be applied to a line item price. You can specify a Discount % or a Discount Amount, but not both for the same item. If Discount Amount is specified, Discount % is null.

Non Discounted Extended Price

If Negotiated Price is null, the value is calculated as List Price * Extended Qty. If Negotiated Price is not null, the value is calculated as Negotiated Price * Extended Qty.

Net Discount

The value is calculated as Non Discounted Extended Price - Extended Net Price.

Per Person Allocation

For the parent package, this field is read-only and null, because allocations are normally calculated for the child records. For a per person child item, holds the allocated value of the revenue from that item. For child items, this value defaults to the allocations defined by the administrator. For the package, the value equals the Net Price. End users can update the child items' Per Person Allocation fields.

CAUTION:  When a discount is applied to a package, the List Price will not equal the Net Price, so these numbers must be manually adjusted to make sure the child item allocations add up to the Allocated value for the package.

Function Total

The Function Total field is located in the function record, and shows total value of the function. The value in this field includes the extended net prices of the parent package and does not include the extended net prices of the child package items.

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