Information system in management

weekly_payroll_maggie_gajda_company-2.xls

Sheet1

Maggie Gajda Company
		Weekly hourly payroll for the week of 11/10/08-11/16/08
									Fedral
	Number	Last Name	First Name	Hourly rate	Hours worked	Gross pay	FICA	Subtotal	Taxes Witholding	Additional deductions	Additional premiums	Net Pay	Comments
	1	Adewunmi	Ayodele	$ 12.50	20	$ 250.00	$ 19.13	$ 230.88	$ 23.09			$ 207.79
	2	Barron	Janell	$ 11.00	45	$ 522.50	$ 39.97	$ 482.53	$ 48.25			$ 434.28
	3	Baweja	Jaideep	$ 10.50	18	$ 189.00	$ 14.46	$ 174.54	$ 17.45			$ 157.09
	4	Casiano	Mayra	$ 15.00	50	$ 825.00	$ 63.11	$ 761.89	$ 114.28			$ 647.60
	5	Cheddie	Nigel	$ 11.25	34	$ 382.50	$ 29.26	$ 353.24	$ 35.32	$ 19.13		$ 298.79	5% of his gross pay toward child support
	6	Fields	Janna	$ 12.00	50	$ 660.00	$ 50.49	$ 609.51	$ 91.43			$ 518.08
	7	Gajda	Maggie	$ 18.00	50	$ 990.00	$ 75.74	$ 914.27	$ 137.14			$ 777.13
	8	Garcia	Jonathan	$ 10.50	35	$ 367.50	$ 28.11	$ 339.39	$ 33.94			$ 305.45
	9	Hernandez	Angel	$ 13.25	42	$ 569.75	$ 43.59	$ 526.16	$ 78.92	$ 56.98		$ 390.26	10% of his gross pay toward animal shelter
	10	Hyland	Robert	$ 14.40	31	$ 446.40	$ 34.15	$ 412.25	$ 41.23			$ 371.03
	11	Ince	Sevilay	$ 14.60	15	$ 219.00	$ 16.75	$ 202.25	$ 20.22			$ 182.02
	12	Joseph	Candice	$ 10.25	10	$ 102.50	$ 7.84	$ 94.66	$ 9.47			$ 85.19
	13	Madison	Angela	$ 11.35	29	$ 329.15	$ 25.18	$ 303.97	$ 30.40			$ 273.57
	14	Medugno	Michael	$ 16.00	50	$ 880.00	$ 67.32	$ 812.68	$ 121.90			$ 690.78
	15	Peredes	Patricia	$ 14.30	50	$ 786.50	$ 60.17	$ 726.33	$ 108.95		$ 200.00	$ 817.38	"great worker" bonus
Total	15				529	$ 7,519.80	$ 575.26	$ 6,944.54	$ 912.00	$ 76.10	$ 200.00	$ 6,156.44
					Minimum pay	$ 102.50
					Maximum pay	$ 990.00
					Average	$ 501.32