Question

Spreadsheet Accounting 280 Payroll 279 Exercise 9-1: Employee Earnings Record 1 Prepare an employee earnings record for Carol's Surf Shop for the employee shown below. 3211 North Ilikai Boulevard Honolulu, HI 96810 (808) 555-6122 Jackie Scruggs Address Name 433-55-8988 1/10/1973 3/1/1998 SSN Date of Birth Date Hired Telephone Terminated Sex 1 Exemptions Single $12.50 Status Pay Rate The earnings data for Jackie Scruggs is: 2. FIT Total Period Ending Hours Withholdings 1/5/04 1/12/04 1/19/04 1/26/04 2/2/04 2/9/04 27.00 47.00 29.00 26.00 26.00 26.00 22 22 3. Use the following tax information to prepare the employee earning record: Tax Rate Limits State Tax 11.00% FICA Medicare none 6.20% $87,000 1.45% none 4. Setup the page so that the entire document prints on one page. 5 Save the file as Exercise 9-1 6 Print the spreadsheet. Verify these net pay amounts: Jackie Scruggs net pay on 1/26/04, 2/2/04 and 2/9/04 is $197.71. The McGraw-Hill Comua

Answer 1

Exercise 9-1 : Employee Earnings Record for the Given Period
Name Of the Employee : Jackie Scuggs
SSN :- 433-55-5988
Date of Birth : 1/10/1973
Sex : F
Status : Single
Pay Rate : $ 12.50
Date of Hired : 3/1/1998
Address : 3211 North Iiikal
	Boulevard
	Honolulu, Hi 96810
Telephone : (808) 555-6122
Employement Status : Terminated
					FICA
Year	Period ended	Total hours worked in hrs	Pay rate per hour in $	Gross payment for the period in $	Social Security Contribution to be deduted from employee Gross Payments (FICA )		Medicare		Total Deduction for FIFA in $	Sate tax		Deduction for Federal Income Tax in $	Total Deduction in $	Net payment in $
					Rate in %	Deduction amount in $	Rate in %	Deduction amount in $		Rate in %	Deduction amount in $
2004	1/5/2004	20	12.5	250	6.20%	15.5	1.45%	3.63	19.13	11%	27.5	27	73.63	176.38
2004	1/12/2004	45	12.5	562.5	6.20%	34.875	1.45%	8.16	43.03	11%	61.875	47	151.91	410.59
2004	1/19/2004	25	12.5	312.5	6.20%	19.375	1.45%	4.53	23.91	11%	34.375	29	87.28	225.22
2004	1/26/2004	22	12.5	275	6.20%	17.05	1.45%	3.99	21.04	11%	30.25	26	77.29	197.71
2004	2/2/2004	22	12.5	275	6.20%	17.05	1.45%	3.99	21.04	11%	30.25	26	77.29	197.71
2004	2/9/2004	22	12.5	275	6.20%	17.05	1.45%	3.99	21.04	11%	30.25	26	77.29	197.71