Tuesday, 13 January 2015

Pricing Method in Microsoft Dynamics CRM Product Catalog All in 1 Explanation

When we want to sell the Product in CRM, we offer the Product and the Salesperson will input their offers in the Opportunity Product Line or Quote Product Line before becoming Order and Invoice.

Of course every Product has its own Price, now, how to link it back to the Opportunity Product Line.

Let’s say Marketing or Product Team has defined the Prvaluoduct Pricing, is there any impact in the Sales Processing?

We are expecting that the Salesperson will not be confused and should sell the Product within the expected range analyzed before by the expert Product Catalog Team and Marketing.

The Product Catalog setting will affect the Opportunity Product default Selling Price Thus, we need to understand first, what is the expectations of the Price and Product Master in hoping their salesperson can sell within the amount with good and profitable selling Price. Price List will become the Guide for salesperson to explore and approach the customer and offer them with price that are mutualism, means that all sides are happy, the Product Team, Marketing Team, Sales Team, and also the Customers.

So, the Pricing is very important in the Sales Process Automation.

Mapping the Business Process Pricing to the CRM Pricing Method is not easy unless you understand how it works and how it will affect the CRM Sales Process.

Now, in this post will mainly explain about how the Pricing Method will affect the basic/default Selling Price in the Sales Process and how important to understand it. It would help the Organization to determine the price either by specific amount, expected margin, and suitable profit markup.

Let’s begin reading this post…

Basically, there are 6 methods of pricing in CRM:

image
  1. Currency Amount
  2. Percent of List
  3. Percent Markup – Current Cost
  4. Percent Margin – Current Cost
  5. Percent Markup – Standard Cost
  6. Percent Margin – Standard Cost
We will go through one by one, before that let’s we configure the Product Master record here:

Product Master List Price, Current Cost, and Standard Cost

image

The definition of Current Cost and Standard Cost are based on your own Organization Pricing and Costing.

So my pricing and costing:

Type         Value ($)
List Price899
Current Cost599
Standard Cost549

And then we define the Price List Item here, based on each criteria and let’s see how it works and affect the Opportunity Product (and also Quote Product).

There are two type of pricing, Default or User Provided. Here, we will focus on the Default, eventhough you can change the price later if you choose the “User Provided” type, but by default, CRM will give you a default Price per Unit.

Basically the default Price per Unit of each Opportunity Product will follow the rules:

1. Combination of the Price List (defined in the Opportunity header), the Product itself, and the Unit.
This combination will find the correct Price List Item and get the pricing.

2. If the product does not exist in the Price List defined in the Opportunity then CRM will give price per unit based on the Product default Price List. To know more about Default Price List, please check this link out.

http://missdynamicscrm.blogspot.com/2014/07/10-facts-about-default-price-list-in-CRM2011-2013-that-you-might-not-have-noticed.html

3. If the product does not exist in any price list and does not have the Default Price List, CRM will give 0 value and will cause warning and error, this is to let you know how important the Price List in the CRM Sales process if you want to implement the out of the box CRM sales pricing.

Currency Amount

I will give the $888 with Pricing Method = Currency Amount


image

As you can see the Price Per Unit is not other than $888.00.

We’ve learned how the Currency Amount as one of the CRM pricing method works.
Currency Amount will give exactly the same value from the Amount defined in the respective Product Price List Item

Percent of List

I will set the Pricing Method = Percent of List with Percentage 50 and the Rounding Policy set to None.

image

There will be no amount can be set after you change the Pricing Method to Percent of List, instead, you can only set the Percentage from the base you set as the Product List Price.

As we remember, we have defined the List Price before to $899 Value, it will be the base price.

See the result here:

image

So now it means that the price will be $449.50 was coming from 50% * 899 = 449.50

What if I want to sell higher?

Just put more than 100% like I did here..

image

Percent Markup vs. Percent Margin

What is the difference between Markup and Margin?

Markup and Margin have different calculation, based on this reference, here is the understanding between those two terms:
Margin
The percentage margin is the percentage of the final selling price that is profit.
Markup
A markup is what percentage of the cost price do you add on to get the selling price.
These are different, a selling price with a margin of 25% results in more profit than a selling price with a markup of 25%.

In a merchant situation it is probably better to work with margins. This means you can know what percentage of our total income is profit.

How to Calculate Selling Price based on Markup?
Selling Price = (Cost X Markup /100) + Cost
How to Calculate Selling Price based on Margin?
Selling Price = Cost/((100-Margin)/100)
Thankfully there is a quicker way to work it out.
For a five percent margin, divide the cost price by 0.95.
For a ten percent margin, divide the cost price by 0.9.
For a fifteen percent margin, divide the cost price by 0.85.
For a twenty percent margin, divide the cost price by 0.8.
For a twenty-five percent margin, divide the cost price by 0.75.
For a thirty percent margin, divide the cost price by 0.7.
..and so on…
For a fifty percent margin, divide the cost price by 0.5.

Percent Markup – Current Cost

Now, how about Percent Markup based on Current Cost? Remember the above formula, you will get the Selling Price.

I will set the Pricing Method = Percent Markup – Current Cost with Percentage 50 and the Rounding Policy set to None.

image

Same as the previous one, Percent List, you can only set based on percentage, the amount will be calculated automatically based on the Current Cost.

As we remember, we have defined the Current Cost before to $599 Value, it will be the base price.

See the result here:

image
Selling Price = (Cost X Markup /100)+ Cost

Percent Margin – Current Cost

Now, we are still using the Current Cost, but we want to sell based on Margin.

I will set the Pricing Method = Percent Margin – Current Cost with Percentage 50 and the Rounding Policy set to None.

SNAGHTMLd5389f1

Same as the previous one, Percent List, you can only set based on percentage, the amount will be calculated automatically based on the Current Cost.

As we remember, we have defined the Current Cost before to $599 Value, it will be the base price.

See the result here:

image
Selling Price = Cost/((100-Margin)/100)
For a fifty percent margin, divide the cost price by 0.5.

Percent Markup – Standard Cost

Same as the previous example for the Current Cost, but now, the base is the Standard Cost.

I will set the Pricing Method = Percent Markup – Standard Cost with Percentage 25 and the Rounding Policy set to None.

image

Same as the previous one, Percent List, you can only set based on percentage, the amount will be calculated automatically based on the Standard Cost.

As we remember, we have defined the Standard Cost before to $549 Value, it will be the base price.

See the result here:

image
Selling Price = (Cost X Markup /100)+ Cost

Percent Margin – Standard Cost

Same as the previous example for the Current Cost, but now, the base is the Standard Cost.

Now, we are still using the Standard Cost, but we want to sell based on Margin.

I will set the Pricing Method = Percent Margin – Standard Cost with Percentage 25 and the Rounding Policy set to None.

image

Same as the previous one, Percent List, you can only set based on percentage, the amount will be calculated automatically based on the Current Cost.

As we remember, we have defined the Current Cost before to $599 Value, it will be the base price.

See the result here:

image
Selling Price = Cost/((100-Margin)/100)
For a twenty-five percent margin, divide the cost price by 0.75
I hope you enjoy this post and make it as reference in the future!

Thank you…Enjoy..

12 comments:

  1. Really ,This is a wonderful post. I enjoyed the information lot. I will bookmark this page. Thanks for sharing this important information. Corporate Movie || Corporate Video Production || Ad Films Maker || Training Films

    ReplyDelete
  2. Wow! Great post! The content is very rich, and I really like it. It help me very much to solve some problems. It is very helpful for all the people on the web. Thanks a lot. Ecommerce Product Photography || Ecommerce Product Photoshoot || Products Catalogue

    ReplyDelete
  3. Great! Very informative! Thanks a lot.

    ReplyDelete
  4. Are these formulas or Markup and Margin universal ???

    ReplyDelete
  5. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Microsoft CRM, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Microsoft CRM. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/



    ReplyDelete
  6. Hello Aileen,

    Great article there. I am trying to add a custom field called Margin % which gets calculated and added to the total amount at the Opportunity, Quote or Order level.

    ReplyDelete
    Replies
    1. I have just done this for a client, overall it was straight forward to complete

      Delete
  7. Hi! Great article, I had no idea it worked this way, so thank you for explaining it so well. I can't wait for my dynamics 365 implementation to happen very soon, I'm way too excited ;)
    Cheers!

    ReplyDelete
  8. Hi,
    Let say I have a product A with default price list P and current cost 100$, having pricing method "percent margin of current cost" .When I choose this existing product A in opportunity product the price per unit comes equal to zero and when I open opportunity product record I get a notification showing "Following error has occured: "?

    ReplyDelete
  9. Has anyone ever found a way to do 'Waterfall' price lists in Dynamics?

    ReplyDelete

My Name is..