Calculating Allocations for a Two-Item Package with Discounted Price
A sales representative enters a basic package containing two items. This package has a discounted price. The following table shows an example of how Siebel Hospitality might calculate revenue allocations for this type of package. This scenario is similar to Calculating Allocations for a Two-Item Package, except that the customer has negotiated a lower price. Each item in the table has a quantity of 1.
Package Breakdown | List Price | Negotiated Price | Unit Net Price | Formula | Per Person Allocation |
---|---|---|---|---|---|
Package Per Person |
100.00 |
80.00 |
80.00 |
None |
Not applicable |
— Event Order Item |
50.00 |
Not applicable |
Not applicable |
(50/(50+60))*80 |
36.36 |
— Menu Item |
60.00 |
Not applicable |
Not applicable |
(60/(50+60))*80 |
43.64 |
Siebel Hospitality determines the revenue contribution percentage of each item from the list price of the item. The list price of an item divided by the total of the item list prices equals the contribution percentage of that item. Multiply this contribution percentage by the unit net price of the package to determine how much that item contributes to the price of the package.