Worker Comp Calculations 2010 - Revision history

Rfs: /* Calculating salary amounts */

2010-07-01T18:32:51Z

Calculating salary amounts

2010-07-01T18:12:14Z

Method used for reporting 2010 numbers

2010-07-01T17:27:22Z

Method used for reporting 2010 numbers

2010-07-01T17:25:58Z

Method used for reporting 2010 numbers

2010-07-01T17:21:53Z

Algorithm for reporting 2010 numbers

2010-07-01T17:20:54Z

Algorithm for reporting 2010 numbers

2010-07-01T17:12:39Z

Calculating salary amounts

2010-07-01T16:38:18Z

Algorithm for reporting 2010 numbers

2010-07-01T16:33:14Z

Calculating salary amounts

2010-07-01T16:32:35Z

Calculating salary amounts

@@ Line 58: / Line 58: @@
 # We then applied percentages based on these subtotals to the adjusted salary dollars for the same period.
-=== Calculating salary amounts ===
+=== Calculating adjusted salary amounts ===
 To arrive at the salary dollar amounts:
 # Salary numbers are entered into our bookkeeping software and reconciled on a monthly basis.

@@ Line 55: / Line 55: @@
 #* April 19 - May 31 '''(period F)'''
 # For each of those periods, we listed out hours logged by worker. We grouped the workers by worker classification, and then subtotaled hours by both worker comp category and worker classification.
-# We combined the subtotals from periods D, E and F into one set of subtotals for January 25 to May 31.
+# We combined the subtotals from periods D, E and F into one set of hours subtotals for January 25 to May 31. Each of these hours subtotals was multiplied by the regular wage for the corresponding worker class to weight each properly. From this weighted amount we created percentages.
-# We then applied percentages based on these subtotals to the salary dollars for the same period.
+# We then applied percentages based on these subtotals to the adjusted salary dollars for the same period.
 === Calculating salary amounts ===

@@ Line 33: / Line 33: @@
 * For up to November 30, 2009 we used the old worker comp categories (5, 7 and 8).
-** Hours were calculated as outlined above and these percentages were applied to salary dollars for each period, regardless of worker class.
+** Hours were calculated as outlined below and these percentages were applied to salary dollars for each period, regardless of worker class.
 * For December 2009 we also used the old worker comp categories (5, 7 and 8).
 ** Calculations were based on logged hours and these percentages were applied to salary dollars for each period, regardless of worker class.
@@ Line 40: / Line 40: @@
 * For January 25, 2010 forward we used the new worker comp categories (4, 5, 6 and 7).
 ** Calculations were based on logged hours and these percentages were applied to salary dollars for each period, taking into account of worker class.
 # We reviewed the scheduled hours by their worker comp categories for the period of June 1, 2009 to November 30, 2009 '''(period A)'''.

@@ Line 31: / Line 31: @@
 == Method used for reporting 2010 numbers ==
 When reporting the numbers for June 1, 2009 through May 31, 2010, then, a fairly complicated algorithm needed to be employed:
 # We reviewed the scheduled hours by their worker comp categories for the period of June 1, 2009 to November 30, 2009 '''(period A)'''.
@@ Line 40: / Line 50: @@
 #** the "Office Clerical" hours went up, which makes sense since we don't routinely schedule many tasks that happen in the office, for example email correspondence and such.
 #** the "Drivers/Chauffrs/Messengers & Helpr" category dropped slightly, which also makes sense, since we schedule pickups but they do not always happen.
 # For January 1-24 '''(period C)''' calculations were based on logged hours and these percentages were applied to salary dollars for each period, regardless of worker class.
 # We identified period boundaries where workers changed classifications starting on January 24, 2010. This was in anticipation of needing to apply different amounts of salary dollars based on the pay scale for the worker class. This created three periods:

@@ Line 29: / Line 29: @@
 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.
-== Algorithm for reporting 2010 numbers ==
+== Method used for reporting 2010 numbers ==
 When reporting the numbers for June 1, 2009 through May 31, 2010, then, a fairly complicated algorithm needed to be employed:

@@ Line 36: / Line 36: @@
 # We reviewed actual logged hours by their worker comp categories for the period of December 1, 2009 to May 31, 2010 '''(period B)'''.
 #* During this period we ''did'' have a daily hours recording by job in place. This gave us actual reported numbers of hours in each category.
-# We calculated the percentage in each category for period B and then applied it to the total reported hours for period A. This gave us numbers that we could compare to the scheduled hours and we could determine if they were reasonable changes or not. (The most significant change was that the "Office Clerical" hours went up, which makes sense since we don't routinely schedule many tasks that happen in the office, for example email correspondence and such.)
+# We calculated the percentage in each category for period B and then applied it to the total reported hours for period A.
 # For period A we used the old worker comp categories (5, 7 and 8). Hours were calculated as outlined above and these percentages were applied to salary dollars for each period, regardless of worker class.
 # For December 2009 we also used the old worker comp categories (5, 7 and 8). Calculations were based on logged hours and these percentages were applied to salary dollars for each period, regardless of worker class.

@@ Line 52: / Line 52: @@
 To arrive at the salary dollar amounts:
 # Salary numbers are entered into our bookkeeping software and reconciled on a monthly basis.
-# We needed to deduct a portion of the overtime pay where overtime was paid out. (Overtime is a very small amount of our salary expenses, however.)
+# We needed to deduct a portion of the overtime pay where overtime was paid out. (Overtime is a very small amount of our salary expenses, however. 62.9 hours of overtime were reported in the whole year, out of 40,759 total hours reported.)
 #* Overtime is paid at time and a half, therefore we need to deduct half of the regular rate depending on the worker class for the worker who was paid the overtime rate.
 #* In all but one pay period (March 8-21 in period E) all overtime happened within a single job class. That job class has an hourly rate of $13.55 per hour, so the adjustment needed to be $6.78 per hour.
 #* In the pay period of March 8-21 (in period E) all overtime happened within two job classes. 3.25 hours were in the $13.55 job class ($6.78 adjustment rate), and 4.60 hours were in a job class with a hourly rate of $12.55 per hour so that adjustment needed to be $6.28 per hour.