Post Reply 3 posts Page 1 of 1
Price levels and Margin Calculator
  • glowfish
    New User
    New User
    Posts: 151
    Joined: Sat Apr 27, 2013 11:35 am

    Price levels and Margin Calculator

    by glowfish » Fri Oct 07, 2016 10:30 am

    Good Morning
    I was putting in a book PO. They often change the percentage received on items and only give you the retail price of the item. I click on the margin calculator but it only goes to cost, not the other way. I often need to put in the retail price and then need to calculate the cost based on the margin. Not sure how to get the calculator to do this. I used a regular calculator but it would have been nice to use the program to do so. Also, what are the different price levels for? I use price 1 to do a sale but I am not sure what the other price levels would be used for or how they would be used.
    Thanks!
    Vanessa
  • User avatar
    RetailEdge Moderator
    Site Admin
    Site Admin
    Posts: 1290
    Joined: Mon Jan 23, 2006 4:02 pm
    Location: Rutland, VT
    Contact:

    Re: Price levels and Margin Calculator

    by RetailEdge Moderator » Fri Oct 07, 2016 11:46 am

    It' a little hidden but I think it will do what you need. We have taken the approach that most of the time,
    your vendors will be giving you a cost from which you can calculate a price based on a desired margin. So in the price calculator you would enter your Cost, then in one of the price fields enter a desired price and press enter, and RetailEdge will calculate your Margin. Or enter a desired margin and press enter and RetailEdge will calculate a Price.

    Sometimes a vendor might only give you a suggested retail price and your cost would be a certain percentage off of Suggested Retail. In that case what you need to do is determine what your percentage off would be in terms of Margin first because that is what RetailEdge uses. So for instance if you were receiving 35% off Suggested Retail, that would equate to a margin of:

    1-.35 = .65
    Margin = 1-Cost/Retail and so in your case, this would be 1-.65/1 or a 35% margin (pretty easy and no reason to have to do the math).

    As discussed above, most of the time we are going to be adjusting your margin of your price. The one exception is if you are in the Suggested Retail column and have a $0 cost. Then if you have a Unit Price and enter a Margin and press Enter, RetailEdge will calculate your cost.

    The price levels are as follows:

    Suggested Retail - Used to imply a discount with Price 1 and to show a Was/Now, Theirs/Our pricing on certain barcode labels
    Price 1 - Normal Selling Price
    Price 2-5 used for discounting items usually in conjunction with a customer discount. So you might have wholesale customers who you want to give a Price Level 2 discount to. This allows you to give a discount that is not just a straight percentage. So if you have a 60% margin on some items you can give more of a discount than on items you have a 35% discount on. We actually use price level discounting here for resellers on software but nothing else (services, hardware, etc.).

    Sometimes it is easier to setup discount Rules for things as well. So you would not need to setup price levels on individual items, but could setup something that would allow you discount all items in one department by 30% and all items in another department by 20% for customers in your loyal customer program.

    That being said percentages don't always work. So if you are giving wholesale customers Cost Plus pricing, and you receive a big discount from a vendor, then your average cost is going to be less than standard costs and so a Price Level discount can prevent you from over discounting in some situations.

    Hope that helps
    Good Morning
    I was putting in a book PO. They often change the percentage received on items and only give you the retail price of the item. I click on the margin calculator but it only goes to cost, not the other way. I often need to put in the retail price and then need to calculate the cost based on the margin. Not sure how to get the calculator to do this. I used a regular calculator but it would have been nice to use the program to do so. Also, what are the different price levels for? I use price 1 to do a sale but I am not sure what the other price levels would be used for or how they would be used.
    Thanks!
    Vanessa
  • glowfish
    New User
    New User
    Posts: 151
    Joined: Sat Apr 27, 2013 11:35 am

    Re: Price levels and Margin Calculator

    by glowfish » Wed Nov 16, 2016 11:02 am

    It does. Thanks
Post Reply 3 posts Page 1 of 1

Who is online

Users browsing this forum: No registered users and 3 guests