Additional Pricing Options
This section discusses:
Single-tiered pricing rules.
Multiple-tiered pricing rules.
Discounted giveaways and Buy One, Get One free rules.
Different product pricing and ordering units.
Advanced pricing calculation in a price rule.
Tiered pricing enables different pricing on portions of a schedule and is used with quantity or price formula breaks. The formula breaks should not overlap. Tiered rule pricing is only available for price rules with a Price Action Type of Discount/Surcharge and Price Override.
Consider this example: A price rule and schedule is set up for selling sinks.
Price rule: Sinks Rule 1
Price action type: Discount/surcharge
Rollup flag by: Schedule
Tiered Pricing: Yes
Condition: Product ID = 10050 – 10060 (all of these items are sinks)
Formulas:
Formula Range ID |
Minimum and Maximum Quantities |
Discount |
---|---|---|
1 |
1 to 10 |
5 percent |
2 |
11 to 20 |
10 percent |
3 |
21 to 99 |
20 percent |
The schedule line lists a quantity purchase of 25 sinks. A 5 percent discount will be applied to the first 10 sinks, a 10 percent discount will be applied to the next 10 sinks, and a 20 percent discount will be applied to the remaining sinks. Three pricing schedules are generated for the same order schedule.
Multiple-tiered rules can be applied to the same schedule. Because different price rules use different quantity breaks, the quantities are merged by net price. With a cascading adjustment method, subsequent adjustments are applied to the existing price schedules. Additional pricing schedules are created as needed.
For example, using the price rule created in the previous section, now add an additional price rule:
Price rule: Sinks Rule 2
Price action type: Discount/surcharge
Rollup flag by: Schedule
Tiered Pricing: Yes
Condition: Product ID = 10050 – 10060 (all of these items are sinks)
Formulas:
Formula Range ID |
Minimum and Maximum Quantities |
Discount |
---|---|---|
1 |
1 to 15 |
1 percent |
2 |
16 to 30 |
2 percent |
Based on this tiered rule, a 1 percent discount will be applied to the first 15 sinks, and a 2 percent discount will be applied to the remaining sinks. The quantities and the related adjustments from both price rules are calculated first and then merged by net price.
These are the quantities and related adjustments from the price rule "Sinks Rule 1."
Quantity group |
Quantity |
Discount |
Formula |
---|---|---|---|
A |
10 |
5 percent |
1 |
B |
5 |
10 percent |
2 |
C |
5 |
10 percent |
2 |
D |
5 |
20 percent |
3 |
This table lists the quantities and related adjustments for price rule Sinks Rule 2.
Quantity Group |
Quantity |
Discount |
Formula |
---|---|---|---|
E |
10 |
1 percent |
1 |
F |
5 |
1 percent |
1 |
G |
5 |
2 percent |
2 |
H |
5 |
2 percent |
2 |
Comparing the results from both price rules, Sinks Rule 1 will apply a 5 percent discount to the first 10 sinks, and Sinks Rule 2 will apply a 1 percent discount to the first 10 sinks, which sums to total of 6 percent and results in the same net price. Similarly for the next 5 sinks, Sinks Rule 1 applies a 10 percent discount and Sinks Rule 2 applies a 1 percent discount, for a total of 11 percent discount and the same net price. Grouping the quantity by same net price results in the final pricing schedules shown in this table:
Pricing Schedule |
Quantity |
Discount |
Formulas |
Quantity Group |
---|---|---|---|---|
1 |
10 |
–6 percent |
–5 percent Sinks Rule 1, Formula ID 1, and –1 percent Sinks Rule 2, Formula ID 1 |
A and E |
2 |
5 |
–11 percent |
–10 percent Sinks Rule 1, Formula ID 2, and –1 percent Sinks Rule 2, Formula ID 1 |
B and F |
3 |
5 |
–12 percent |
–10 percent Sinks Rule 1, Formula ID 2 and –2 percent Sinks Rule 2, Formula ID 2 |
C and G |
4 |
5 |
–22 percent |
–20 percent Sinks Rule 1, Formula ID 3, and –2 percent Sinks Rule 2, Formula ID 2 |
D and H |
Promotional pricing is used to attract new customers, to encourage customers to try new products, or to liquidate excess inventory. A common promotion is to offer a free or discounted product if the customer purchases a particular product, often called a Buy-One-Get-One or BOGO. Enterprise Pricer enables you create BOGO price rules and also to create price rules that allow the customer to buy one product and get a different product at a discounted rate.
Enterprise Pricer enables you to define complex BOGO and BOGO-like promotions. You can specify the quantity of the giveaway and indicate the discount, surcharge, or price. Sample types of promotional discounts include:
Buy one of product A, get one of product B free.
Buy two of product A, get four of product B at a 50 percent discount, and any additional purchases of product B at 10 percent off.
Buy one of product A, get one of product B at 50 percent discount per line.
Buy six of product A, get three of product B at 10 percent discount per order.
Buy five pounds of product A, get 10 pounds of product B at 20 percent off.
Numerous industries have a different ordering unit of measure and pricing unit of measure. For example, paper industry orders are typically by roll. However, the product is priced per hundred-weight (CWT). Enterprise Pricer enables you to order in one unit of measure, such as roll, but define a different pricing unit of measure for the price rule. The pricing engine is able to calculate the item price using a different unit of measure from the order unit of measure. When the order line is processed, the price based on the order unit of measure appears on the sales order page. Pricing results based on the pricing unit of measure appear on the Pricing Detail page.
Achieving pricing goals specific to the needs of an organization is a crucial element to the success of selling products. Achieving pricing goals sometimes requires the ability to define organization-specific formulas that use a series of different operands. Enterprise Pricer enables you to create mathematical expressions in the price rule that are used to calculate the net price for a given product. Thus, you can define complex promotional discounts in which you specify the adjustment, override price, and giveaway quantity using a custom mathematical expression. For example: a 5 percent discount plus a 5 USD discount for all orders of product number 10050 during the ordering period February 1, 2005, to December 31, 2005.
Enterprise Pricer enables you to:
Define custom mathematical expressions, using the expanded set of pricing operands.
Use the expanded list of variables known to Enterprise Pricer (net price, list price, and so forth).
Define pricing variables for use with one or more price rules.
Cap the mathematical expression calculations, for example, (List Price *.95) or 1000 USD, whichever is smaller.
Using Indexes in Pricing Calculations
In PeopleSoft Contracts, IndexStartValue, IndexEndValue, and IndexStartAmount are pricing variables that are used in the mathematical expression attached to a price formula. They are used for price index calculations. IndexStartValue and IndexEndValue are price index values that are effective on the IndexStartDate and IndexEndDate values that are automatically retrieved from the RT_RATE_TBL table by Enterprise Pricer during the pricing process.
Note: IndexStartValue, IndexEndValue, and IndexStartAmount are used together. If one is used, you cannot use any other pricing variables.
The RT_RATE_TBL table is used to maintain the price indexing data:
Field Name |
Description |
Used by Enterprise Pricer |
---|---|---|
RT_RATE_INDEX |
Market Rate Index |
Identify the index. Its category must be Economic Indicator, as defined in table RT_INDEX_TBL. |
TERM |
Term |
NA |
FROM_CUR |
From Currency Code |
Both currency codes FROM and TO must be the same. They match the currency of the transaction. |
TO_CUR |
To Currency Code |
Both currency codes FROM and TO must be the same. They match the currency of the transaction. |
RT_TYPE |
Rate Type |
NA |
EFFDT |
Effective Date |
Used to select the effective index value. |
RATE_MULT |
Rate Multiplier |
Index value. |
RATE_DIV |
Rate Divisor |
NA |
SYNCID |
Synchronization ID |
NA |
LASTUPDDTTM |
Last Update Date/Time |
NA |
As an example, suppose these market rates exist:
Market Index |
Effective Date |
Rate (Index Value) |
---|---|---|
CPI |
January 1, 2000 |
1200 |
CPI |
July 1, 2000 |
1280 |
CPI |
January 1, 2001 |
1300 |
CPI |
July 1, 2001 |
1320 |
GOV |
January 13, 2000 |
100.20 |
GOV |
June 20, 2000 |
100.40 |
GOV |
December 11, 2000 |
100.80 |
GOV |
March 1, 2001 |
101.10 |
Then, a rate renewal occurs:
Current Offering Amount |
Start Date |
End Date |
Renewal Basis |
Price Index |
Additional Percent |
Price Cap Basis |
Cap Percent |
---|---|---|---|---|---|---|---|
10,000 |
February 1, 2000 |
January 31, 2001 |
Index + additnl percent |
CPI |
2 |
Percent |
5 |
10,000 |
February 1, 2000 |
January 31, 2001 |
Additnl percent |
GOV |
1.5 |
Index + Addtnl percent |
1 |
You can set up price rule formulas to address the rate change:
Formula ID |
Adjustment Flag |
Numeric Value |
Text Value (Math Expression) |
Market Rate Index |
Select Small/Larger |
---|---|---|---|---|---|
1 |
Percentage and Math Expression |
5 |
IndexStartAmount * (1 + (IndexEndValue – IndexStartValue)/IndexStartValue + 2 / 100) |
CPI |
Smaller |
2 |
Percentage and Math Expression |
1.5 |
IndexStartAmount * (1 + (IndexEndValue – IndexStartValue)/IndexStartValue + 1 / 100) |
GOV |
Smaller |
3 |
Percentage and Math Expression |
2 |
IndexStartAmount * (IndexEndValue / IndexStartValue) |
GOV |
Larger |
The starting values are:
IndexStartAmount = 10000.
StartDate = February 1, 2000.
EndDate = January 31, 2001.
The first formula is processed in this manner:
For the CPI market rate index, use the Market Rate Table to find the index values for the start and end dates: 1200 and 1300. The mathematical expression is evaluated as:
IndexStartAmount * (1 + (IndexEndValue – IndexStartValue)/IndexStartValue + 2 / 100) = 10000 * (1 + (1300 – 1200) / 1200 + 2 / 100) = 10000 * (1 + 0.0833 + 0.02) = 11033
The percentage calculation is 10000 * (1 + 5 / 100) = 10500
Because the formula indicates to take the smaller of the two values 11033 and 10500, 10500 is the result of the formula.
The second formula is processed in this manner:
For the GOV market rate index, use the Market Rate Table to find the index values for the start and end dates: 100.20 and 100.80. The mathematical expression is evaluated as:
IndexStartAmount * (1 + (IndexEndValue – IndexStartValue)/IndexStartValue + 1 / 100) = 10000 * (1 + (100.80 – 100.20) / 100.20 + 1 / 100) = 10000 * (1 + 0.0060 + 0.01) = 10160
The percentage calculation is 10000 * (1 + 1.5 / 100) = 10150
Because the formula indicates to take the smaller of the two values 10160 and 10150, 10150 is the result of the formula.
Processing of the third formula uses index values to perform different types of calculations:
For the GOV market rate index, use the Market Rate Table to find the index values for the start and end dates: 100.20 and 100.80. The mathematical expression is evaluated as:
IndexStartAmount * (IndexEndValue / IndexStartValue) = 10000 * (100.80 / 100.20) = 10000 * 1.0060 = 10060
The percentage calculation is 10000 * (1 + 2 / 100) = 10200
Because the formula indicates to take the larger of the two values 10060 and 10200, 10200 is the result of the formula.