Bookshelf v8.1/8.2: Revenue Estimate Examples for Menus and Packages

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:

Example 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 63.

Table 63. 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`	`Not appli-cable`	`Not appli-cable`	`75.00`	`375.00`	`1`	`5`	`Not applicable`	`Not appli-cable`	`Not appli-cable`
	`Event Order Item 1`	`Not appli-cable`	`Not appli-cable`	`Not appli-cable`	`10`	`10`	`20.00`	`Audio-visual`	`100.00`
	`Event Order Item 2`	`Not appli-cable`	`Not appli-cable`	`Not appli-cable`	`1`	`1`	`10.00`	`Audio-visual`	`50.00`
	`Event Order Item 3`	`Not appli-cable`	`Not appli-cable`	`Not appli-cable`	`1`	`1`	`30.00`	`Rental`	`150.00`
	`Package 2`	`Not appli-cable`	`Not appli-cable`	`Not appli-cable`	`2`	`2`	`Not applicable`	`Not appli-cable`	`Not appli-cable`
		`Event Order Item 4`	`Not appli-cable`	`Not appli-cable`	`2`	`4`	`5.00`	`Food`	`25.00`
		`Event Order Item 5`	`Not appli-cable`	`Not appli-cable`	`1`	`2`	`10.00`	`Audio-visual`	`50.00`

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

Table 64. Package Per Person or Package Each Example Revenue Estimates
Revenue Categories	Revenue Estimate
`Audiovisual`	`200.00`
`Rental`	`150.00`
`Food`	`25.00`

Example 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 65.

Table 65. 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`	`Not appli-cable`	`Not appli-cable`	`Not appli-cable`	`Not appli-cable`	`1`	`1`	`Not applicable`	`Not appli-cable`	`Not appli-cable`
	`Event Order Item 1`	`Not appli-cable`	`5.00`	`50.00`	`10`	`10`	`Not applicable`	`Audio-visual`	`50.00`
	`Menu`	`Not appli-cable`	`5.00`	`100.00`	`20`	`20`	`Not applicable`	`Food`	`100.00`
		`Menu Item 1`	`Not appli-cable`	`Not appli-cable`	`1`	`20`	`Not applicable`	`Not appli-cable`	`Not appli-cable`
		`Menu Item 2`	`Not appli-cable`	`Not appli-cable`	`1`	`20`	`Not applicable`	`Not appli-cable`	`Not appli-cable`
	`Package 2`		`50.00`	`100.00`	`2`	`2`	`Not applicable`	`Not appli-cable`	`Not appli-cable`
		`Event Order Item 2`	`Not appli-cable`	`Not appli-cable`	`2`	`4`	`40.00`	`Food`	`80.00`
		`Event Order Item 1`	`Not appli-cable`	`Not appli-cable`	`1`	`2`	`10.00`	`Food`	`20.00`

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

Table 66. Package Item Price Example Revenue Estimates
Revenue Categories	Revenue Estimates
`Audiovisual`	`50.00`
`Rental`	`0`
`Food`	`200.00`

Example 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 67.

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

Table 67. Set Price Menu Example Details
Level 1	Level 2	Extended Net Price	Qty	Extended Qty	Per Person Allocation	Revenue Category	Revenue Estimate
`Set Menu`	`Not applicable`	`100.00`	`1`	`20`	`Not applicable`	`Food`	`100.00`
	`Menu Item 1`	`Not applicable`	`1`	`20`	`Not applicable`	`Not applicable`	`Not applicable`
	`Menu Item 2`	`Not applicable`	`1`	`20`	`Not applicable`	`Not applicable`	`Not applicable`

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

Table 68. Set Price Menu Example Revenue Estimates
Revenue Categories	Revenue Estimates
`Audiovisual`	`0`
`Rental`	`0`
`Food`	`100.00`

Example 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 69.

Table 69. 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`	`Not appli-cable`	`Not appli-cable`	`Not appli-cable`	`Not appli-cable`	`1`	`1`	`Not applicable`	`Not appli-cable`	`Not appli-cable`
	`Menu Item 1`	`Yes`	`50.00`	`1000.00`	`20`	`20`	`Not applicable`	`Food`	`1000.00`
	`Menu Item 2`	`Yes`	`40.00`	`1200.00`	`30`	`30`	`Not applicable`	`Food`	`1200.00`

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

Table 70. Split Price Menu Example Revenue Estimates
Revenue Categories	Revenue Estimates
`Audiovisual`	`0`
`Rental`	`0`
`Food`	`2200.00`

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