7.5.3. Customer Price List - Cost Plus

This example explains how to set up the discount schema for a Sales Price list where standard prices are a percentage increase from the purchase price.

Assumptions:

• Purchase Price List has been defined with a Standard Price equal to the cost.

• The List Price is equal to the List Price on the Purchase Price List.

• Standard (selling price) is 25% over the cost for Product Category of Bushes and 20% for Product Category of Trees. All other products are 30%.

• Limit (lowest selling price) is 15% over the cost for Product Category of Bushes, 10% for Product Category or Trees. All other products are 20%.

The following table shows the pertinent fields in the discount schema:

When generating the price list version no base price list is used (as the list price used as the base for all calculations is the list price from the product).

Assume the following Products, Product Categories and List and Standard Prices on the Purchase Price List:

The prices calculated using the discount schema above would be:

• Lawn Tillers are in the Tool Category and are priced at 25% over the Standard Price for the Standard Price (50 - (50 * -.25)) and 15% for the Limit Price (50- 50 * -.15));

• Rose Bushes are in the Bush Category and are priced at 20% over the Standard Price for the Standard Price (70 - (70 * -.20)) and 10 % for the Limit Price (70 - (70 * -.10));

• Oak Trees are in the Tree Category and are priced at 30% over the Standard Price for the Standard Price (120 - (120 * -.30)) and 20% for the Limit Price (120 - (120 * -.20)).