User:Rfs/Other Scratch Page
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 |
Hours Reported (Jan-Aug 2006)
This includes collective members, interns, and substitutes reported hours.
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 |
467.00 | 4.00 | 83.25 | 98.25 | 85.50 | 101.25 | 94.75 |