inventory margin

Mar 22, 2005 2 Replies

Hello. I just have a question. i their a way in Microoft retail management system to see how much profit margin my entire inventory is on? I would like to see what percantage margin i run my busines on.



for example we make 30% in houseware, 20% in plastics but 60% in stationary and party. so if you average it out i would get 42.5 so can i do that in the pos.



some thing like Average Margin of Profit on entire inventory.



Thanx in advance


You might want to check the Reports Library on Customer Source, I'm not sure if there's a report that includes Profit Margin, but it would be worth checking. It is possible to calculate a value and add it to various reports. I'm not sure that the number you are asking for really has any practical meaning though - you really need to look at actual sales prices, not just the "Price" field for the item - until an item goes onto a transaction, there's no profit to calculate. There are also some more complex calculations that can give you a better understanding of where you stand, such as Inventory Turns and GMROII

formatting link

Anyway, you can get almost any number you want out of RMS - some are harder to get to than others and some require you to take 'snapshots' at certain points in time, but you can get almost anything you want. Ask your reseller for help, or search the news group for hints on writing reports.

Thank You Glenn for all the awesome help you provide us in here and everywhere else. You are awesome!

And specificaly thank you for thinking of

formatting link
You have inspired me to try and make it better... so I am going to try and do that.

Marc Wagner

formatting link

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required