User:Rfs/Other Scratch Page
< User:Rfs
Jump to navigation
Jump to search
Revision as of 13:40, 20 September 2006 by Rfs (talk | contribs) (→Weekly hours scheduled Sept 2006)
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 |