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.

Example of a Package Per Person

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 69 shows an example of a package per person with an expected quantity of 50. In the table, Extended Quantity is the calculated rollup.

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

Pack-age

Not appli-cable

50

50

60.00

Per Person

60.00

3000.00

0

0

0

Not appli-cable

Menu

1

50

50.00

Per Person

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

30.00

Audio-visual

1

1

400.00

Each

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

15.00

Ice Sculp-ture

2

2

100.00

Each

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

15.00

Package Per Person Field Behaviors

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

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, the default value is set up by the administrator.

Extended Quantity Field

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 is equal to Person), Extended Quantity is calculated as parent Quantity multiplied by child item Quantity, where parent Quantity is equal to 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 is equal to Per Person even if this is not explicitly specified on the parent record.

Using example values from Table 69, the Extended Quantity is calculated as shown in Table 70.

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

Package

Not applicable

Per Person

50

50

50

Menu

Per Person

1

1 multiplied by 50

50

Audiovisual

Each

1

1 multiplied by 1

 1

Ice Sculpture

Each

2

2 multiplied by 1

 2

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 both 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.

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

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

Using example values from Table 69, the Extended Price is calculated as shown in Table 71.

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

Package

Not applicable

50

60.00

50 multiplied by 60

$3000.00

Menu

50

50.00

50 multiplied by 50

$2500.00

Audiovisual

1

400.00

1 multiplied by 400

$400.00

Ice Sculpture

2

100.00

2 multiplied by 200

$200.00

Discount % Field

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 Field

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 Field

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

Net Discount Field

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

Per Person Allocation Field

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, the default value is the allocations value defined by the administrator. For the package, the value equals the Net Price. Users can update the Per Person Allocation fields of the child items.

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 Field

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 © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.