User:Rfs/Other Scratch Page

From FreekiWiki
Jump to navigation Jump to search

Staff Costs Report (July 2006)

The column for July is based on actuals in the books. The other columns assume July is an average month and are calculations.

Staff     July Yearly Est Weekly Avg Per Hr of Op
   
    Health Care     $ 2,763.32 $ 33,159.84 $ 637.69 $ 14.17 $ 1.37
    Payroll Accounting     $ 325.16 $ 3,901.92 $ 75.04 $ 1.67 $ 0.16
    Payroll Taxes     $ 1,949.89 $ 23,398.68 $ 449.97 $ 10.00 $ 0.96
* Payroll, Commision $ 228.07 $ 2,736.84 $ 52.63 $ 1.17 $ 0.11
* Payroll, Regular     $ 15,643.44 $ 187,721.28 $ 3,610.02 $ 80.22 $ 7.73
* Payroll, Substitutes     $ 1,704.02 $ 20,448.24 $ 393.24 $ 8.74 $ 0.84
* Employee Withholding     $ 3,477.21 $ 41,726.52 $ 802.43 $ 17.83 $ 1.72
Total Payroll $21,052.74 $252,632.88 $4,858.32 $107.96 $10.40
    Workers Compensation     $ 96.87 $ 1,162.44 $ 22.35 $ 0.50 $ 0.05
Total Staff     $26,187.98 $314,255.76 $6,043.38 $134.30 $12.94
  • Lines included in Total Payroll are indicated with an asterisk (*).

Hours Reported (Jan-Aug 2006)

This includes collective members, interns, and substitutes reported hours. The 12 month row is an estimate.

Work Holiday PTO Total
8 month 12,902.5 96.2 776.7 13,775.4
12 month 19,353.8 144.3 1,165.0 20,663.0

Weekly hours scheduled Sept 2006

firstname tot monday tuesday wednesday thursday friday saturday
Ali 35.00 0.00 7.00 7.00 7.00 7.00 7.00
Dave 35.00 0.00 7.00 7.00 7.00 7.00 7.00
Jeff 28.00 0.00 4.00 4.00 7.00 7.00 6.00
Kathie 20.00 0.00 4.00 4.00 4.00 4.00 4.00
Katrina 24.00 4.00 5.00 5.00 5.00 5.00 0.00
Liane 35.00 0.00 7.00 7.00 7.00 7.00 7.00
Martin 31.00 0.00 7.75 7.75 0.00 7.75 7.75
Michael 35.00 0.00 7.00 7.00 7.00 7.00 7.00
Nathan 35.00 0.00 7.00 7.00 7.00 7.00 7.00
Oso 35.00 0.00 7.00 7.00 7.00 7.00 7.00
Richard 35.00 0.00 7.00 7.00 7.00 7.00 7.00
Rick 28.00 0.00 0.00 7.00 7.00 7.00 7.00
Shawn 35.00 0.00 7.00 7.00 7.00 7.00 7.00
Sophia 24.00 0.00 0.00 8.00 0.00 8.00 8.00
Steven 32.00 0.00 6.50 6.50 6.50 6.50 6.00
TOTAL 467.00 4.00 83.25 98.25 85.50 101.25 94.75