My database is used to calculate piece rate for an apparel manufacture. Employees are paid based on production rather than an hourly rate or salary. At the end of the week, trainees are paid a bonus based on a sliding curve. This curve is based on a job difficulty rating and what week of training they are on. Employees training bonus is the difference between what they produced and their guaranteed rate from the training curve. Additionally, at the end of the week, any employee who did not earn minimum wage is grossed up to minimum wage. The employees weekly gross earnings are “earned pay” + “training bonus” + “minimum wage makeup”.
I can calculate all of the above-mentioned items inside of my employee weekly group footer. I am performing the calculations in VBA using IF statements to evaluate weather or not such bonuses or makeups are necessary. There is not problem on a per employee level, however, because the controls that hold the results of my calculations are “unbound”, I do not know how to create a departmental or company wide summary of this information.
Can any one help me make a little sense of it all?
Phillip Counce
pcounce@tcg.ms
I can calculate all of the above-mentioned items inside of my employee weekly group footer. I am performing the calculations in VBA using IF statements to evaluate weather or not such bonuses or makeups are necessary. There is not problem on a per employee level, however, because the controls that hold the results of my calculations are “unbound”, I do not know how to create a departmental or company wide summary of this information.
Can any one help me make a little sense of it all?
Phillip Counce
pcounce@tcg.ms
