http://wiki.freegeek.org/index.php?title=Staff_costs_and_hours&feed=atom&action=history
Staff costs and hours - Revision history
2024-03-28T21:52:42Z
Revision history for this page on the wiki
MediaWiki 1.35.1
http://wiki.freegeek.org/index.php?title=Staff_costs_and_hours&diff=19447&oldid=prev
Rfs at 20:44, 20 September 2006
2006-09-20T20:44:39Z
<p></p>
<p><b>New page</b></p><div>== Staff Costs Report (July 2006) ==<br />
The column for July is based on actuals in the books. The other columns assume July is an average month and are calculations.<br />
<table border="1"><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Staff</td><br />
<td style=""></td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">July</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Yearly Est</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Weekly Avg</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Per Hr of Op</td><br />
<td style=""></td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td style=""></td><br />
<td style=""></td><br />
<td style=""></td><br />
<td style=""></td><br />
<td style=""></td><br />
<td style=""></td><br />
<td style=""></td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Health Care</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 2,763.32 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 33,159.84 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 637.69 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 14.17 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 1.37 </td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Payroll Accounting</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 325.16 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 3,901.92 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 75.04 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 1.67 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 0.16 </td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Payroll Taxes</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 1,949.89 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 23,398.68 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 449.97 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 10.00 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 0.96 </td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">*</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Payroll, Commision</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;"></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 228.07 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 2,736.84 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 52.63 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 1.17 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 0.11 </td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">*</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Payroll, Regular</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 15,643.44 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 187,721.28 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 3,610.02 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 80.22 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 7.73 </td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">*</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Payroll, Substitutes</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 1,704.02 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 20,448.24 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 393.24 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 8.74 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 0.84 </td><br />
</tr><br />
<tr><br />
<td style="">*</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Employee Withholding</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 3,477.21 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 41,726.52 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 802.43 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 17.83 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 1.72 </td><br />
</tr><br />
<tr><br />
<td style=""></td><br />
<td valign="bottom" align="left" style=" font-size:10pt;"><b>Total Payroll</b></td><br />
<td style=""><b></b></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"><b> $21,052.74 </b></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"><b> $252,632.88 </b></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"><b> $4,858.32 </b></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"><b> $107.96 </b></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"><b> $10.40 </b></td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Workers Compensation</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">&#160;&#160;&#160;</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 96.87 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 1,162.44 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 22.35 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 0.50 </td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"> $ 0.05 </td><br />
</tr><br />
<tr><br />
<td colspan="2" valign="bottom" align="left" style=" font-size:10pt;"><b>Total Staff</b></td><br />
<td valign="bottom" align="left" style=" font-size:10pt;"><b>&#160;&#160;&#160;</b></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"><b> $26,187.98 </b></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"><b> $314,255.76 </b></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"><b> $6,043.38 </b></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"><b> $134.30 </b></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;"><b> $12.94 </b></td><br />
</tr><br />
</table><br />
* ''Lines included in Total Payroll are indicated with an asterisk (*).''<br />
<br />
== Hours Reported (Jan-Aug 2006) ==<br />
This includes collective members, interns, and substitutes reported hours. The 12 month row is an estimate.<br />
<table border="1"><br />
<tr><br />
<td style=""></td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">Work</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">Holiday</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">PTO</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">Total</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">8 month</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">12,902.5</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">96.2</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">776.7</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">13,775.4</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">12 month</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">19,353.8</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">144.3</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">1,165.0</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">20,663.0</td><br />
</tr><br />
</table><br />
<br />
== Weekly hours scheduled Sept 2006 ==<br />
<br />
<table border="1"><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">firstname</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">tot</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">monday</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">tuesday</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">wednesday</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">thursday</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">friday</td><br />
<td valign="bottom" align="left" style=" font-size:10pt;">saturday</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Ali</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">35.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Dave</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">35.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Jeff</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">28.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">4.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">4.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">6.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Kathie</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">20.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">4.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">4.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">4.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">4.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">4.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Katrina</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">24.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">4.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">5.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">5.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">5.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">5.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Liane</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">35.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Martin</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">31.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.75</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.75</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.75</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.75</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Michael</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">35.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Nathan</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">35.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Oso</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">35.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Richard</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">35.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Rick</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">28.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Shawn</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">35.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">7.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Sophia</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">24.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">8.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">8.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">8.00</td><br />
</tr><br />
<tr><br />
<td valign="bottom" align="left" style=" font-size:10pt;">Steven</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">32.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">0.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">6.50</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">6.50</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">6.50</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">6.50</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">6.00</td><br />
</tr><br />
<tr><br />
<td style="">TOTAL</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">467.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">4.00</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">83.25</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">98.25</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">85.50</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">101.25</td><br />
<td valign="bottom" align="right" style=" font-size:10pt;">94.75</td><br />
</tr><br />
</table><br />
<br />
[[Category: HR]]</div>
Rfs