Sales

Put strategy behind product pricing

Published: January 1, 2008

Microsoft Dynamics CRM includes a pricing engine that you can use to calculate product prices based on a variety of pricing methods. The person who maintains the product catalog, such as the sales manager, can select from different pricing methods for products that are based on a combination of product pricing and price-list configuration.

On This Page
Determine the costs of a product Determine the costs of a product
Select a pricing method Select a pricing method
Add the product to a sales record Add the product to a sales record

For example, by using a pricing method that is based on a percent of your organization's current cost for the product, you can automatically adjust the sales prices on quotes, orders, and invoices when the product cost fluctuates. The combination of product pricing and costing data and pricing method ultimately determines how customer-facing unit prices are calculated on quotes, orders, and invoices.

The Product form includes the following optional price fields:

  • List Price

    Represents the price that you will charge the customer for the product.

  • Standard Cost

    Represents what you typically pay for the product. If you have products with frequently fluctuating costs, the standard cost can be based on an average costing mechanism to determine the final unit price. The standard cost is not updated as frequently as the current cost.

  • Current Cost

    Represents what you are currently paying for the product. For products that have frequently fluctuating costs, the current cost should be updated every time that a new shipment of products is received.

Determine the costs of a product

Adventure Works is a low-cost bicycle retailer that is selling an inexpensive, multi-terrain bicycle. The company imports the parts every month and then assembles the bicycle at the Adventure Works retail store. Typically, Adventure Works pays $50 per bicycle. But the manufacturer has raised the price $10 per bicycle because of a temporary reduction in the manufacturer's inventory. The price and costs for the bicycle are reflected in the Microsoft Dynamics CRM product form.

  • List Price:

    The list price for the multi-terrain bicycle is $100.

  • Standard Cost:

    The parts for the multi-terrain bike normally cost Adventure Works $50.

  • Current Cost:

    Due to the manufacturer's inventory issues, the parts for the multi-terrain bike temporarily cost $60.

Note

Before this product can be added to a sales document, such as a quote, order, or invoice, a price list and price list item must be associated with it. For more information about how to add a price list to a product, see the Microsoft Dynamics CRM Help.

Top of page

Select a pricing method

When you add the product to a price list item, there are six different pricing methods to select from that will determine how the unit price is calculated.

Tip

You create and manage price lists in the Settings area.

In the Navigation Pane, click Settings, click Product Catalog, and then click Price Lists.

The Currency Amount pricing method

When you select the Currency Amount pricing method, the unit price of the product is determined as a fixed amount. This is the simplest pricing method and does not require a percentage or rounding policy. When you select this method, you must provide an amount in the Amount box. Then, Microsoft Dynamics CRM will only use that price and not the prices entered in the List Price, Standard Cost, and Current Cost boxes on the General tab in the Product form.

The Percent of List pricing method

When you select the Percent of List pricing method, the unit price of the product is determined as a percent of the price that was entered in the List Price field on the Product form. For example, when you enter 110 in the Percentage box, the Total Amount field of a single multi-terrain bicycle when it is added to quotes, orders, and invoices is $110.

Microsoft Dynamics CRM calculates the price as shown in the table.

Pricing Method Formula Calculation

Percent of List

List Price X List Price% = Unit Price

$100X110%=$110

The Percent Markup - Current Cost pricing method

When you select the Percent Markup - Current Cost pricing method, the unit price of the product is determined as a percent markup of the current cost that was entered in the Current Cost field on the Product form. For example, when you enter 150 in the Percentage box, the price of the bicycle when it is added to quotes, orders, and invoices is $90. Therefore, the price changes based on the current amount that you pay for the product.

Microsoft Dynamics CRM calculates the price as shown in the table.

Pricing Method Formula Calculation

Percent Markup - Current Cost

Current Cost X Markup% = Unit Price

$60X150%=$90

The Percent Margin - Current Cost pricing method

When you select the Percent Margin - Current Cost pricing method, the unit price of the product is determined as a percent of the profit that you want to receive. This value is based on the current cost that was entered in the Current Cost field on the Product form. For example, when you enter 50 in the Percentage box, the price of the bicycle when it is added to quotes, orders, and invoices is $120. Therefore, the price changes based on the current amount that you pay for the product.

Microsoft Dynamics CRM calculates the price as shown in the table.

Pricing Method Formula Calculation

Percent Margin - Current Cost

[(Current Cost X Percent Margin)/Percent Margin] + Current Cost = Unit Price

[($60X50%)/50%]+$60=$120

The Percent Markup - Standard Cost pricing method

When you select the Percent Markup - Standard Cost pricing method, the unit price of the product is determined as a percent markup of the standard cost that was entered in the Standard Cost field on the Product form. For example, when you enter 175 in the Percentage box, the price of the product when it is added to quotes, orders, and invoices is $87.50. Therefore, the price changes based on the typical amount that you pay for the product.

Microsoft Dynamics CRM calculates the price as shown in the table.

Pricing Method Formula Calculation

Percent Markup - Standard Cost

Standard Cost X Markup% = Unit Price

$50X175%=$87.50

The Percent Margin - Standard Cost pricing method

When you select the Percent Margin - Standard Cost pricing method, the unit price of the product is determined as a percent of the profit that you want to receive. This value is based on the standard cost that was entered in the Standard Cost field on the Product form. For example, when you enter 50 in the Percentage box, the price of the product when it is added to quotes, orders, and invoices is $100. Therefore, the price changes based on the typical amount that you pay for the product.

Microsoft Dynamics CRM calculates the price as shown in the table.

Pricing Method Formula Calculation

Percent Margin - Standard Cost

[(Standard Cost X Percent Margin)/Percent Margin] + Standard Cost = Unit Price

[($50X50%)/50%]+$50=$100

Top of page

Add the product to a sales record

After you have set up a pricing method, and included the list price, current cost, and standard cost data on the Product form, Microsoft Dynamics CRM will automatically calculate the unit price when you add the product to any quote, order, or invoice.

Related Links

Did you find the information that you need?
Yes     No 
If not, what information do you need? (optional)

© 2008 Microsoft Corporation. All rights reserved.