Excel File Edit View Format Tools Data Window Help BOX 3 AutoSave GIF Chapter Excel Assignment instruction Template Home Insert Draw Page Layout Formulas Data Review View Share X - 10 AA General Conditioning - 4 B Format sett SD $ % Format M23 B D E H 1 K 1 Accounting 213: Lab #8 for Chapter 9 - Payroll Accounting Ne 3 Instruction 1) use the information in Part A to complete the Payroll Register Tallein Part B. Remember to use formulas when there is a calculatione reference 2) Using the Information in the Payrol Register complete January & December journal entries for both employee wages/ wholdings and employer only tasse cal references) 5 NOTE in the pink cels, we have provided you with the formulas for the first period. Because There is no data in the cells as you begin the gament heeltof the calculation is As you complete the rest of the table, you will see the results in the pink cell change. You will need to copy the formules in the strom the first period into the best periods Part Tax Rates and Maximum Taxable Amounts annual salary of employee subject to tax 13 Social Security - PICA (CASH 63205 $128.400 14 Social Security Medicare 1485 15 16 Unemployment-FUTA 0.6% $7.000 17 Unemployment SUTA 5.4 57.000 19 formation for Employee Irma Wallpald: 20 Monthly gross pay $100 21 Monthly tax table $2.200 $700 23 Monthly health insurance 3450 24 Monthly insurance 550 25 Morby retirement savings $1.200 26 Part 3: Pavol Register 28 Cumulative Name: Irma Welipaid 29 grosspy Withholdings Federal Calendar Life 10 Gross pay Health State subject to income 31 year-to-date Total with Monthly Soc. See Medicare income Insurance Insurance Retirement Sheet Sheet2 Sheet Federal @ B. MacBook DU FB 30 F3 F6 17 Excel File Edit View insert Format Tools Data Help Autes BOR OF Thut 31 0 Window Chapter 9 Excel Assignment Instructions & Template Review View Home Insert Page Layout Formulas Share 10 General Conditional Formatting Formatas Toble- Pa BIU P- $ % ) Tong M23 f D E F G H 1 L M N o P 28 7 Name: Irma Wellgald 0 Federal income Tax Withholdings State Health Life Income Insurance Insurance Retirement tax Premium Premium Monthly Gross pay Monthly Soe. Sec. Medicare tax Monthly 2 Payroll subject to unem- ployment Total with Net pay FUTA fax SUTA ayroll entry for payment to Irma and related withholdings employee pay stub on page 347 in text Record the payroll taxes paid solely by the employer (FICA match & unemploymentes) See example on page 348 intet For January Sheet1 Chapter 9 Excel Assignment 31 A) MacBook ca w 30 DM FB 59 590 F FS FB Excel File Edit View Format Tools Data Window Help BOX 3 AutoSave GIF Chapter Excel Assignment instruction Template Home Insert Draw Page Layout Formulas Data Review View Share X - 10 AA General Conditioning - 4 B Format sett SD $ % Format M23 B D E H 1 K 1 Accounting 213: Lab #8 for Chapter 9 - Payroll Accounting Ne 3 Instruction 1) use the information in Part A to complete the Payroll Register Tallein Part B. Remember to use formulas when there is a calculatione reference 2) Using the Information in the Payrol Register complete January & December journal entries for both employee wages/ wholdings and employer only tasse cal references) 5 NOTE in the pink cels, we have provided you with the formulas for the first period. Because There is no data in the cells as you begin the gament heeltof the calculation is As you complete the rest of the table, you will see the results in the pink cell change. You will need to copy the formules in the strom the first period into the best periods Part Tax Rates and Maximum Taxable Amounts annual salary of employee subject to tax 13 Social Security - PICA (CASH 63205 $128.400 14 Social Security Medicare 1485 15 16 Unemployment-FUTA 0.6% $7.000 17 Unemployment SUTA 5.4 57.000 19 formation for Employee Irma Wallpald: 20 Monthly gross pay $100 21 Monthly tax table $2.200 $700 23 Monthly health insurance 3450 24 Monthly insurance 550 25 Morby retirement savings $1.200 26 Part 3: Pavol Register 28 Cumulative Name: Irma Welipaid 29 grosspy Withholdings Federal Calendar Life 10 Gross pay Health State subject to income 31 year-to-date Total with Monthly Soc. See Medicare income Insurance Insurance Retirement Sheet Sheet2 Sheet Federal @ B. MacBook DU FB 30 F3 F6 17 Excel File Edit View insert Format Tools Data Help Autes BOR OF Thut 31 0 Window Chapter 9 Excel Assignment Instructions & Template Review View Home Insert Page Layout Formulas Share 10 General Conditional Formatting Formatas Toble- Pa BIU P- $ % ) Tong M23 f D E F G H 1 L M N o P 28 7 Name: Irma Wellgald 0 Federal income Tax Withholdings State Health Life Income Insurance Insurance Retirement tax Premium Premium Monthly Gross pay Monthly Soe. Sec. Medicare tax Monthly 2 Payroll subject to unem- ployment Total with Net pay FUTA fax SUTA ayroll entry for payment to Irma and related withholdings employee pay stub on page 347 in text Record the payroll taxes paid solely by the employer (FICA match & unemploymentes) See example on page 348 intet For January Sheet1 Chapter 9 Excel Assignment 31 A) MacBook ca w 30 DM FB 59 590 F FS FB