In final sheet you named cell "Average". I think weighted average is different than average. I am not sure what you need exactly. If you need average only, you can get it creating pivot table and summary field of Average instead of sum. In another hand, if you need "real" weighting, you should calculate it for each row (in a new column), and then summarize it by supervisor.