User:Rfs/Other Scratch Page

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