P
Prets
Hi everyone
I have been given a project to do but am a little stumped and hopin
someone could give me some assistance/advice
We have several sites and each site is allowed to make up to 1.5% o
errors. As each has various amount of employees, I want to focus on on
at the time
Now this one particular site has 600 employees and they can make up t
1.5% of errors each month otherwise there site bonuses are effected
For example, in a month, this site with 600 employees can make 9 error
max which would equate to 1.5%
Is it possible to create a table that will reduce the number of error
allowed each week. For example, column B is the average amount of error
they can make each week but in Column C, if they made 4 errors in Wee
1, the rest of the week would automatically reduce but still cap th
total at 9
A B
Staff 600
Week1 2
Week2 2
Week3 2
Week4 2
Week5 1
9
I think this is just the starting point to my project but hopefully thi
will help a lot
Any help would be much appreciated
Pr
I have been given a project to do but am a little stumped and hopin
someone could give me some assistance/advice
We have several sites and each site is allowed to make up to 1.5% o
errors. As each has various amount of employees, I want to focus on on
at the time
Now this one particular site has 600 employees and they can make up t
1.5% of errors each month otherwise there site bonuses are effected
For example, in a month, this site with 600 employees can make 9 error
max which would equate to 1.5%
Is it possible to create a table that will reduce the number of error
allowed each week. For example, column B is the average amount of error
they can make each week but in Column C, if they made 4 errors in Wee
1, the rest of the week would automatically reduce but still cap th
total at 9
A B
Staff 600
Week1 2
Week2 2
Week3 2
Week4 2
Week5 1
9
I think this is just the starting point to my project but hopefully thi
will help a lot
Any help would be much appreciated
Pr