Irene's Scrapbooking World
Payroll Worksheet
For the Pay Period Ended January 29, 2016
Name	SSN	Tax Status	Allowances	Insurance Plan	Contribute to 401K	Pay Rate per Hour	Overtime Rate	Hours Worked	Gross Pay	401K Deduction	Taxable Wages	Health Insurance	Other Deductions	Other Deductions Comments
Anderson, Marsha	501-85-7894	Married	2	Family	TRUE	17.50	26.25	92.00	1,715.00	64.31	1,650.69	101.20	15.00	United Way
Campbell, Titus	502-76-7891	Married	4	Family	TRUE	25.00	37.50	80.00	3,000.00	-	3,000.00	101.20
Franks, Alice	473-75-7789	Single	1	Single	FALSE	19.50	29.25	80.00	2,340.00	-	2,340.00	52.75
Hansen, Belinda	472-85-1237	Maried	3	Family	TRUE	22.50	33.75	72.00	2,430.00	-	2,430.00	101.20
Jackson, Thomas	471-99-4587	Single	1	Single	TRUE	25.00	37.50	87.50	2,281.25	-	2,281.25	52.75
Limesand, Edna	991-87-7789	Single	2	No	TRUE	17.25	8.63	40.00	345.00	-	345.00	#N/A
Petters, Sally	501-45-1298	Divorced	2	FAMLY	FALSE	41.50	62.25	60.00	3,735.00	-	3,735.00	#N/A
Richardson, Denise	502-23-8989	Single	1	Single	TRUE	13.00	19.50	80.00	1,560.00	-	1,560.00	52.75	50.00	Court-ordered child support
Watson, Irene	472-19-6547	Married	4	Family	TRUE	21.50	32.25	102.50	2,445.63	-	2,445.63	101.20	50.00	United Way
Totals
Valid Withholding Tax Statuses:							401K Deduction Percentage:				Health Insurance Plan Options:
Single							3.75%				Plan Type	Deduction per Pay Period
Married											Family	$101.20
											Single	$52.75
											None	$0.00

Case Problems Level 1 Troubleshooting Formulas and Data Entry in a Payroll Data Workbook for Irene's Scrapbooking World Similar to other small businesses, Irene's Scrapbooking World outsources the processing of its payrol to its accounting firm. Twice per month, Irene Watson, the owner of Irene's Scrapbooking World, creates a workbook that contains her employees' payroll information to send to the accounting firm of Wipson & Lynn, LLP. Wipson & Lynn then uses that information to prepare the paychecks for the employees and calculate Irene's Scrapbooking World's payrol liabilities to the government and other entities, and to prepare its payroll-related reports, such as the Federal 941 forms Human Resources Wipson & Lynn charges Irene based on the number of paychecks it processes for her company. A number of Irene's payroll-related workbooks have contained data entry errors that the firm's personnel had to fix before it could process the payrl. Wipson & Lynn also charges Irene for the time it takes to track down and fix those errors Irene has asked you to use the Excel data validation and protection tools to troubleshoot the current payr workbook and set up the workbook to help prevent errors from occurring in the future Case Problems Level 1 Troubleshooting Formulas and Data Entry in a Payroll Data Workbook for Irene's Scrapbooking World Similar to other small businesses, Irene's Scrapbooking World outsources the processing of its payrol to its accounting firm. Twice per month, Irene Watson, the owner of Irene's Scrapbooking World, creates a workbook that contains her employees' payroll information to send to the accounting firm of Wipson & Lynn, LLP. Wipson & Lynn then uses that information to prepare the paychecks for the employees and calculate Irene's Scrapbooking World's payrol liabilities to the government and other entities, and to prepare its payroll-related reports, such as the Federal 941 forms Human Resources Wipson & Lynn charges Irene based on the number of paychecks it processes for her company. A number of Irene's payroll-related workbooks have contained data entry errors that the firm's personnel had to fix before it could process the payrl. Wipson & Lynn also charges Irene for the time it takes to track down and fix those errors Irene has asked you to use the Excel data validation and protection tools to troubleshoot the current payr workbook and set up the workbook to help prevent errors from occurring in the future