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.