I am trying to rate the performance based on a predetermined
percentage weight.

Example:
Bob has a 7% quality rate
Tracy has a 8% quality rate.
Larry has a 9% quality rate.

This particular category has a 30% total weight.

(The other categories - [production etc.] adds up to 70% totaling 100%
effective).

Question:
With a goal of 8%, how do I figure their effectiveness based on a 30%
weight?
Since I'm dealing with quality, the lower the number the higher their
weight.

Example:
Bob has a 7% (cell A2) quality.
The goal is 8% (cell A1).
The weight is in A3, (30%).

HIs effectiveness should be 33.75% (higher than 30).

Larry has a 9% quality rate (cell B2).
The goal is 8%.(cell B1)
The weight is in B3, (30%).

His effectiveness should be less (something like %26.25)

any suggestions?