How to take three sets of data and ranking them based off a particular weighting

We have three sets of data points that we want to use to rank the stores by results. We want Sales to compromise 50% of the rank, while GM and Turn represent 25% each. This making a total of 100%. Since sales is in Dollars, GM is in % and Turn is a number I am having a hard time finding the right way to rank each item.


Any help would be greatly appreciated.

Thanks
Kevin

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Edited: Didn't see mod post while composing.