Microsoft Dynamics CRM Online 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.
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 Online 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 Online Help.
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 System 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 Online 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 Online 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 Online 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 Online 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 Online 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 Online 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
|
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 Online will automatically calculate the unit price when you add the product to any quote, order, or invoice.
Related Links
Build price lists for multiple customer segments
Reward your customers with quantity discounts
Create a price list to use for a free sample