Worker Comp Calculations 2010

In 2009 Free Geek was audited by our workers compensation provider. As a result some changes to how this work took effect at the beginning of 2010.

ID	Code	Description 5	7380 07	Drivers/Chauffrs/Messengers & Helpr 7	8810 03	Office Clerical 8	5191 01	Computer Dev-Instl/Inspec/Ser/Repr
 * In 2009 we had three categories of jobs as outlined here:

ID	Code	Description 4	3574 02	Computing/Office Machine Mfg-Noc 5	7380 07	Drivers/Chauffrs/Messengers & Helpr 6	8264 10	Recycling Operation 7	8810 03	Office Clerical
 * In 2010 category 8 split into two different categories and the old category 8 no longer applied, so we had four categories:

In all cases each of those categories is tied to a group of jobs that people do. At the outset of 2010 we went through the jobs associated with category 8 and divided them into jobs that were now associated with categories 4 or 6 depending.

Prior to the 2009 audit we were calculating how much payroll money was spent in each category by:
 * 1) Looking at the jobs scheduled for the time period.
 * 2) Comparing the total hours scheduled versus the total hours reported and arriving at a number of unscheduled hours worked.
 * 3) Interviewing staff members about what work they did in their unscheduled time.
 * 4) Classifying scheduled hours based on jobs scheduled.
 * 5) Classifying unscheduled hours based on the interviews.

At the audit we were told we would need to start tracking the categories based on daily reporting by individuals of what jobs were worked. (Alternatively we could count all jobs in the highest rated category.) So we implemented a new hours tracking system in the database which went online on December 1, 2009.

Prior to January 24, 2010 all workers were paid the same (back for several years anyway), so a simple division based on hours in each category could be used to calculate how much salary money was spent in each category. As of January 24, 2010 there were three different pay scales introduced based on worker classification. Therefore, after that time hours needed to be grouped by both worker comp category and worker classification.

To complicate things further, some workers moved between categories at a few points between January 24, 2010 and the end of the next worker comp period on May 31, 2010, so we could not assume that a worker that was in one job class at the beginning of the period was in the same class at the end of it.