Corner Bakery
				Payroll Report
				31-Jan-20
Employees	Job position	Hours worked	Hourly wage	Regular pay	Retirement	Pay after pre-tax deduction	Social Security	Federal Tax	Net Pay
Jack Grey	Chef	35	$15.00	$525.00	15.75	$509.25	$28.01	$61.11	$420.13		Assumptions #1 Tax Information
Susan Grey	Chef	40	$15.00	$600.00	18	$582.00	$32.01	$69.84	$480.15		Social Security Tax	5.50%
Mary Wright	Chef	35	$10.00	$350.00	7	$343.00	$18.87	$41.16	$282.98		Federal Tax Annual Income Baseline	$ 34,500.00
John Berry	Cashier	33	$10.00	$330.00	6.6	$323.40	$17.79	$38.81	$266.81		Income Tax Bracket #1	27%
Collyn Bear	Cashier	32	$10.00	$320.00	6.4	$313.60	$17.25	$37.63	$258.72		Income Tax Bracket #2	12%
Chris Hill	Wait Staff	23	$7.00	$161.00	3.22	$157.78	$8.68	$18.93	$130.17
Laura Godwin	Wait Staff	30	$7.00	$210.00	4.2	$205.80	$11.32	$24.70	$169.79		Assumption Box #2
Samantha collins	Wait Staff	34	$7.00	$238.00	4.76	$233.24	$12.83	$27.99	$192.42		Retirement Contribution Scale
Ed Loyd	Wait Staff	25	$7.00	$175.00	3.5	$171.50	$9.43	$20.58	$141.49		Regular Pay	Retirement %
Steve Little	Driver	28	$8.00	$224.00	4.48	$219.52	$12.07	$26.34	$181.10		0	2.0%
Mike Nitsch	Driver	42	$8.00	$336.00	6.72	$329.28	$18.11	$39.51	$271.66		$ 400.00	3.0%
Gwen Manchester	Manager	36	$15.00	$540.00	16.2	$523.80	$28.81	$62.86	$432.14		$ 800.00	4.0%
Stephanie Baker	Manager	45	$15.00	$675.00	20.25	$654.75	$36.01	$78.57	$540.17
Total		438	$134.00	$4,684.00	$117.08	$4,566.92	$251.18	$548.03	$3,767.71
Average		33.69231	$10.31	$360.31	$9.01	$351.30	$19.32	$42.16	$289.82
Maximum		45	$15.00	$675.00	$20.25	$654.75	$36.01	$78.57	$540.17
Minimum		23	$7	$161.00	$3.22	$157.78	$8.68	$18.93	$130.17

6. After using the weekly payroll spreadsheet you would like to slightly modify it to improve its usability.

   1. Move the two rectangles comprising the assumptions area from the right side to the area below the payroll report.

      Use the Audit tool to verify that the cell reference in the formulas have been modified correctly. This step should

      be done on the original payroll sheet.

   2. Modify the payroll spreadsheet to include a column that shows the Social Security and federal taxes combined

      total, right before Net Pay. Create the appropriate formula and modify the Net Pay formula.