i'm pretty smart in figuring out how to use excel but i'm having difficulties in trying to figure this out..
I complied a data set to determine how many employees i need per day based on the number of customer serviced per hour for each day. (see attachment).
my next issue is that i'm trying to determine how many employees can service a customer. For example if on 10/1 i serviced 4 customers between 7-8a and 5 between 8-9a for two hours i had 9 customers. I can make assumptions that i need 1 employee between those hours. But can't assume if i had 18 customers within that same period that i only need one employee.
so i guess i'm looking to figure a ratio in excel.. maybe?