Overriding the Average Values for Subfunction Categories

During the initial setup of the average values of a property, the revenue manager assigns average values to the various function types that exist at a property. The revenue manager uses past history to estimate the average revenue contributions associated with each function type.

During the opportunity capture stage, the sales representative might not fill in all information about a function, and might decide to keep the function details at a very high level. As a result, only the details of the main functions might have been added to the event agenda, and not subfunction details.

This means that when the sales representative decides to detail the function by adding subfunctions, the revenue contributions are added twice to the function. This is because some of the categories for the function can be added at both the function level initially and then at the subfunction level when the function is detailed. For example, a Meeting function can be added to an opportunity with an Audio Visual and Coffee Break revenue contribution.

Later, the sales representative might decides to add the Coffee Break as a subfunction of the main function. In this case, the revenue contribution for the function has been added twice. In order to make sure that the revenue contribution is not mistakenly counted twice, an average value override for subfunctions has been put in place in Siebel Hospitality. This average value override is subject to a number of rules as follows:

• Rule 1: The subfunction category revenue estimate takes precedence over the estimate that exists at the parent function level.

• Rule 2: Multiple subfunction revenues of the same category are added together.

• Rule 3: The subfunction category revenue override facility overrides one function level higher than the level at which it exists.

The rules for function category average value overrides are illustrated in the following examples:

• Example 1: One main function that contains two subfunctions

• Example 2: One Main Function that Contains a Subfunction and a Child Subfunction of the Subfunction

Example of a Function with Two Subfunctions

The following table provides the details of the main function.

Function Name	Function Type	Parent Category	Category	Revenue
Function 1	Meeting	Food	(Not applicable)	130 (Total revenue)
			Lunch	100
			Coffee Break	30

The following table provides the details of the first subfunction.

Function Name	Function Type	Parent Category	Category	Revenue
Subfunction 1	Coffee	Food	(Not applicable)	45 (Total revenue)
			Coffee Break	45

If the user indents Subfunction 1 under Function 1, then Rule: 1 applies; The subfunction category revenue estimate takes precedence over the estimate that exists at the parent function level. The following table shows the changes to Function 1 when Subfunction 1 is indented.

Function Name	Function Type	Parent Category	Category	Revenue
Function 1	Meeting	Food	(Not applicable)	100 (Total revenue)
			Lunch	100
			Coffee Break	0

The Coffee Break revenue is overridden and is set to 0 at the parent function level. This means that the revenue estimate that is displayed at the quote level would be as shown in the following table.

Parent Category	Category	Revenue
Food	(Not applicable)	145 (Total revenue)
	Lunch	100
	Coffee Break	45

At this stage, the sales representative decides to add another subfunction to the parent function, Function 1. The following table shows the details of this subfunction.

Function Name	Function Type	Parent Category	Category	Revenue
Subfunction 2	Meeting	Food	(Not applicable)	25 (Total revenue)
			Coffee Break	25

When this subfunction is added, Rule: 2 is applied; Multiple subfunction revenues of the same category are added together. This is shown in the following table.

Function Name	Function Type	Parent Category	Category	Revenue
Subfunction 1 + 2	Meeting	Food	Coffee Break	70
Subfunction 1	Meeting	Food	Coffee Break	45
Subfunction 2	Meeting	Food	Coffee Break	25

The revenue estimate that is now displayed at the quote level is shown in the following table.

Parent Category	Category	Revenue
Food	(Not applicable)	170 (Total revenue)
	Lunch	100
	Coffee Break	70

Example of a Function with a Subfunction and a Child Subfunction

The following table provides the details of the main function.

Function Name	Function Type	Parent Category	Category	Revenue
Function 1	Meeting	Food	(Not applicable)	130 (Total revenue)
			Lunch	100
			Coffee Break	30

The following table provides the details of the subfunction.

Function Name	Function Type	Parent Category	Category	Revenue
Subfunction 1	Coffee	Food	(Not applicable)	45 (Total revenue)
			Coffee Break	45

If the user indents Subfunction 1 under Function 1, then Rule: 1 applies; The subfunction category revenue estimate takes precedence over the estimate that exists at the parent function level. The revenue estimate that is displayed at the quote level would be as shown in the following table.

Parent Category	Category	Revenue
Food	(Not applicable)	145 (Total revenue)
	Lunch	100
	Coffee Break	45

The sales representative then decides to add a child subfunction to the existing function. The details of this child subfunction are shown in the following table.

Function Name	Function Type	Parent Category	Category	Revenue
Child Subfunction 1	Coffee	Food	(Not applicable)	25 (Total revenue)
			Coffee Break	25

The following table shows the changes to the Subfunction 1 when Child Subfunction 1 is indented.

Function Name	Function Type	Parent Category	Category	Revenue
Function 1	Meeting	Food	(Not applicable)	0 (Total revenue)
			Coffee Break	0

Rule 3 is the applied: The subfunction category revenue override facility overrides one function level higher than the level at which it exists. The revenue estimate that is displayed at the quote level would then be as shown in the following table.

Parent Category	Category	Revenue
Food	(Not applicable)	125 (Total revenue)
	Lunch	100
	Coffee Break	25