payroll_melanielarson (2)

payroll_melanielarson (2) - MelanieLarson 11/8/2009

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Melanie Larson 11/8/2009 Use Excel to complete the data below Sort Alpha Gross Pay with time and a half for overtime Bonus = $50 bonus pay if with company for 5 years or more. Bonus is not taxable or included in an Federal Tax = 15% if Gross Pay less than $500, 20% if greater than or equal to $500 State Tax = 0 if Gross Pay less than $400, 6.5% of Gross Pay if not FICA = 7.6500% Health Insurance = $50  Life Insurance = $0.75 for each year of age Accident insurance = $65 if younger than 27, $45 if 27 or older Retirement = 6.25% of Gross Pay Texas Tax = Texas residents pay $50 Only include Totals and Averages if they make sense Use a nice format Copy the  data to Sheet2 and show all formulas Rename the Sheet tabs appropriately
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ny other deductions
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
First Name Last Name Initial City ST ZIP Area code Sex Arnold Abbott F Las Cruces NM 88003 505 M William Acosta D Las Cruces NM 88005 505 F Barbara Acosta B Las Cruces NM 88001 505 M Karen Acosta A Las Cruces NM 88001 505 F Susan Acosta A Anthony TX 79941 915 F Robert Acosta N Las Cruces NM 88001 505 F Roberta Acosta A Las Cruces NM 88003 505 M Karen Adams T Las Cruces NM 88001 505 M Roberta Adamson M Las Cruces NM 88001 505 F Roberta Adamson E Las Cruces NM 88001 505 F Robert Adamson H Hatch NM 88011 505 M Anna Armstrong B Anthony NM 88021 505 F Cheryl Arnold T Las Cruces NM 88001 505 M Billy Baca V Las Cruces NM 88001 505 M Darlene Baca O Las Cruces NM 88011 505 F Billy Baca R Las Cruces NM 88001 505 F Adam Bailey T Las Cruces NM 88011 505 M Willard Davis F Las Cruces NM 88001 505 M Nelson Erin B El Paso TX 79902 915 M Howard Forsyth J El Paso TX 79902 915 F Susan Franco H Las Cruces NM 88001 505 M Susan Franco K Las Cruces NM 88011 505 M Ann Gomez B Mesilla NM 88047 505 M Barbara Helms S Las Cruces NM 88001 505 F Anna Jaffe L Las Cruces NM 88001 505 F Nelson James N Anthony
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/01/2010 for the course BCIS 110 taught by Professor Nelson during the Fall '09 term at NMSU.

Page1 / 11

payroll_melanielarson (2) - MelanieLarson 11/8/2009

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online