Difference between revisions of "User:Rfs/Other Scratch Page"
< User:Rfs
Jump to navigation
Jump to search
Line 125: | Line 125: | ||
== Hours Reported (Jan-Aug 2006) == | == Hours Reported (Jan-Aug 2006) == | ||
− | This includes collective members, interns, and substitutes reported hours. | + | This includes collective members, interns, and substitutes reported hours. The 12 month row is an estimate. |
<table border="1"> | <table border="1"> | ||
<tr> | <tr> |
Revision as of 12:39, 20 September 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 |
467.00 | 4.00 | 83.25 | 98.25 | 85.50 | 101.25 | 94.75 |