power rating using excel

[Guest]

I have been assigned the task of creating a power rating for staff based on a variety of inputs
My boss has said that he wants it to be similar to football power ratings...and i am not a football fan
so, i need a formula to do this
Basically, he wants a rating per staff based on a maximum score of 100
This is a high end restaurant and the staff to be rated are servers
The rating should be based on:
hours worke
sales per shif
sales as a percentage of total sales for the entire restauran
how much is this person over or short per shif
average sale
etc etc et
any other input factors to be considered is greatly appreciate
ti
dex

 

[Peo Sjoblom]

Given your request I would assume you could do a search for
how schools do grades.. Create some point system using all your criteria,
use the point system to grade
the staff using a table like

=VLOOKUP(A1,{0,"NO!";60,"Needs Improvement";70,"Maybe but you could do
better";80,"OK";90,"Employee of the week"},2)

where A1 would hold the total number a staff member score a

to get average sales you can use

=AVERAGE(Sales_Range)

over/short can be

=Sales-Receipts

where Sales is the actual amount and receipts is the expected amount
according to the receipts
which should if course be zero, however a positive value would be over and a
negative short.
Hours worked end_time minus start_time per day, if it is a night club or in
case someone works after midnight
use

=MOD(End-Start,1)

Total the hours =SUM(A2:A9) where A2 is replaced with the cell where you
record this etc.custom format [h]:mm

You will get the percentage

=Individual_Sales/Total_Sales

format as percentage



HTH,

Peo Sjoblom

I have been assigned the task of creating a power rating for staff based on a variety of inputs.
My boss has said that he wants it to be similar to football power

ratings...and i am not a football fan.