Siebel Hospitality Guide > Managing Property-Specific Menus and Packages >

Revenue Estimate Examples for Menus and Packages


The examples in this topic illustrate several system-calculated revenue estimates, as follows:

Package Per Person or Package Each Revenue Estimate

In this example, the ultimate parent package is a Package Per Person or a Package Each. This ultimate parent package has a unit net price of $75. You must manually set the per person allocations of the child items to equal $75. The quantity of each child item is irrelevant to the revenue estimating process. The line item details of this example are displayed in Table 36.

Table 36. Package Per Person or Package Each Example Details
Level 1
Level 2
Level 3
Unit Net Price
Ext Net Price
Qty
Extended Qty
Per Person Allocation
Revenue Category
Revenue Estimate

Package 1

N/A

N/A

75.00

375.00

1

5

N/A

N/A

N/A

Event Order Item 1

N/A

N/A

N/A

10

10

20.00

A/V

100.00

Event Order Item 2

N/A

N/A

N/A

1

1

10.00

A/V

50.00

Event Order Item 3

N/A

N/A

N/A

1

1

30.00

Rental

150.00

Package 2

N/A

N/A

N/A

2

2

N/A

N/A

N/A

Event Order Item 4

N/A

N/A

2

4

5.00

Food

25.00

Event Order Item 5

N/A

N/A

1

2

10.00

A/V

50.00

The revenue estimates for the various revenue categories are listed in Table 37.

Table 37. Package Per Person or Package Each Example Revenue Estimates
Revenue Categories
Revenue Estimate

A/V

200.00

Rental

150.00

Food

 25.00

Package Item Price Revenue Estimate

In this example, the ultimate parent package is a package item price. Siebel Hospitality does pricing and revenue estimating on each child item individually and ignores the parent package item price. The line item details of this example are displayed in Table 38.

Table 38. Package Item Price Example Details
Level 1
Level 2
Level 3
Unit Net Price
Ext Net Price
Qty
Extended Qty
Per Person Allocation
Revenue Category
Revenue Estimate

Package 1

N/A

N/A

N/A

N/A

1

1

N/A

N/A

N/A

Event Order Item 1

N/A

5.00

50.00

10

10

N/A

A/V

50.00

Menu

N/A

5.00

100.00

20

20

N/A

Food

100.00

Menu Item 1

N/A

N/A

1

20

N/A

N/A

N/A

Menu Item 2

N/A

N/A

1

20

N/A

N/A

N/A

Package 2

50.00

100.00

2

2

N/A

N/A

N/A

Event Order Item 2

N/A

N/A

2

4

40.00

Food

80.00

Event Order Item 1

N/A

N/A

1

2

10.00

Food

20.00

The revenue estimates for the various revenue categories are listed in Table 39.

Table 39. Package Item Price Example Revenue Estimates
Revenue Categories
Revenue Estimates

A/V

 50.00

Rental

  0

Food

200.00

Menu Per Person Set Price Revenue Estimate

In this example, the parent package is a set price menu. The menu has a price and a revenue category. There are no per person allocations. The revenue estimate equals the extended net price of the menu. The line item details of this example are displayed in Table 40.

NOTE:  If the menu is a child item of a Package Each or a Package per Person, it may have a per person allocation. In this case, the revenue estimate is based on the per person allocation.

Table 40. Set Price Menu Example Details
Level 1
Level 2
Extended Net Price
Qty
Extended Qty
Per Person Allocation
Revenue Category
Revenue Estimate

Set Menu

N/A

100.00

1

20

N/A

Food

100.00

Menu Item 1

N/A

1

20

N/A

N/A

N/A

Menu Item 2

N/A

1

20

N/A

N/A

N/A

The revenue estimates for the various revenue categories are listed in Table 41.

Table 41. Set Price Menu Example Revenue Estimates
Revenue Categories
Revenue Estimates

A/V

  0

Rental

  0

Food

100.00

Menu Per Person Split Price Revenue Estimate

In this example, the parent package is a split price menu. The price of the menu depends on the selections the customer makes. Here the customer can either choose Menu Item 1 or Menu Item 2. Each item has a price and a revenue category. The revenue estimate is equal to the extended net price of the split items. The line item details of this example are displayed in Table 42.

Table 42. Split Price Menu Example Details
Level 1
Level 2
Split
Split Price
Extended Price
Qty
Extended Qty
Per Person Allocation
Revenue Category
Revenue Estimate

Split Menu

 

 

N/A

N/A

N/A

N/A

1

1

N/A

N/A

N/A

Menu Item 1

Yes

50.00

1000.00

20

20

N/A

Food

1000.00

Menu Item 2

Yes

40.00

1200.00

30

30

N/A

Food

1200.00

The revenue estimates for the various revenue categories are listed in Table 43.

Table 43. Split Price Menu Example Revenue Estimates
Revenue Categories
Revenue Estimates

A/V

   0

Rental

   0

Food

2200.00

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