This is an excel spreadsheet. Download and save to "My Doucments". There are instructions there on how to do this. let me know if you need help.
This is a SNAP if you own a Jewelry point of Sale program that does this:
One of the best places to read up on GMROI is at
Retail Owners Institute
Click on the GMROI words on the oval area. Next page read up and also on the left click on your industry. It says "AUTO", use the down arrow and go to Jewelers. You'll see the stats for an average "good" jewelry store. Use my spreadsheet to get your numbers.
Click filename below to access file