Ranking with multiple criteria and assigning a weight

Good morning,

This is my first time posting on here so if I make a mistake I want to go ahead and apologize. I have am attempting to rank out individuals based on 4 different categories.

QC: goal of 90%; the higher the better; 65% weight
ADH: goal of 95%; the higher the better; 15% weight
ACW: goal of 20 seconds; the lower the better; 15% weight
ABS: goal of 0%; the lower the better; 5% weight

I am going to try and attach a worksheet with some sample data. Any help would be greatly appreciated.