Annabanana
- 1
- 0
Hello! So I'm not sure if this is the right forum or thread to ask this question but I really need help figuring out a formula in a work context. Please help if you are able!
My mother owns a hair salon where the stylists share the help of several assistants. There are 4 stylists and 4 assistants. My mom wants to change the system for paying out the assistants, because currently the assistants make \$12 an hour and the stylists all pay an equal fraction of their wage REGARDLESS of how many hours each stylist worked. So even if a stylist was out sick for a week or if they had a very slow week of work, she is still responsible for paying out a fraction of the assistants' wages.
We are trying to figure out a chart or formula for paying out the assistants based on how many hours were worked that day or that week by the stylist. Where we get stuck is when we try to account for how many stylists are on the floor at any given moment in relation to how many stylists.
For example,
Stylist A: 8AM - 5 PM
Stylist B: 8 AM - 12PM
Stylist C: 10 AM - 12 PM
Stylist D: 10 AM - 4 PM
Assistant 1: 8 AM - 10 AM
Assistant 2: 8 AM - 12PM
Assistant 3: 10 AM - 2 PM
Assistant 4: 12 PM - 3 PMHow do we find a formula/method in whch the stylists are only paying out assistants during the hours the stylists ACTUALLY worked? (Reminder assistants make $12 an hour)
Thank you so much if you took the time to read this and try to help me and my mom! We are both a bit slow with numbers!
- Anna
My mother owns a hair salon where the stylists share the help of several assistants. There are 4 stylists and 4 assistants. My mom wants to change the system for paying out the assistants, because currently the assistants make \$12 an hour and the stylists all pay an equal fraction of their wage REGARDLESS of how many hours each stylist worked. So even if a stylist was out sick for a week or if they had a very slow week of work, she is still responsible for paying out a fraction of the assistants' wages.
We are trying to figure out a chart or formula for paying out the assistants based on how many hours were worked that day or that week by the stylist. Where we get stuck is when we try to account for how many stylists are on the floor at any given moment in relation to how many stylists.
For example,
Stylist A: 8AM - 5 PM
Stylist B: 8 AM - 12PM
Stylist C: 10 AM - 12 PM
Stylist D: 10 AM - 4 PM
Assistant 1: 8 AM - 10 AM
Assistant 2: 8 AM - 12PM
Assistant 3: 10 AM - 2 PM
Assistant 4: 12 PM - 3 PMHow do we find a formula/method in whch the stylists are only paying out assistants during the hours the stylists ACTUALLY worked? (Reminder assistants make $12 an hour)
Thank you so much if you took the time to read this and try to help me and my mom! We are both a bit slow with numbers!
- Anna
Last edited by a moderator: