ieRetail GP Calculator Status

The calculator also has a promotional mix calculator which can be used to calculate the mixed margin a product or category will make based on its relative on/off promotion sales mix.  This function is useful for analyzing target margins or sales share mix in a retail environment as well as to predict gross and net margins when mixing different category share and margin numbers.  It can be used to check a store wide margin by using individual department margins and sales contributions, or you can use it to calculate range margins based on segment margin and sales mix.  In other words, it calculates the nett effect of price and margin fluctuations for either a product, range or category.  The calculator also has the ability to calculate mixed or blended margin on a product or category basis.  Changes to promotional mix of sales and margin will result in a new, mixed margin for the category.  What is my store margin based on this mix of category sales and margin contributions?  What cost should I negotiate if I need to sell at this price and make this profit margin?  What margin should I make on this category given the sales mix in the store?  What margin will I make at this sell price based on this cost?  You can therefore use it to calculate sell prices, cost prices, profit margins in percentages or dollars, and you have 4 screens so you can compare scenarios.  What share of sales (internal market share) should I target to achieve this margin?  The GP calculator is a quick calculator for buyers and sellers that calculates GP's, Cost, Sell and Profit on a product by product basis.  What sell price must I set to make this margin at that cost?  Which category makes the greatest/lowest relative contribution to margin (CTM) in my mix?  In this regard the calculator can work on a product basis and the user is able to change 1 variable and note the commensurate changes in all the other variables for that product.