I HAVE DONE MOST OF THE WORK PLEASE READ EVERYTHING CAREFULLY ATTACHMENTS BELOW

Document Preview:

Continuing Problem-A Excel Instructions OASDI HI FICA FIT SIT CIT DEDUCTIONS PAYROLL REGISTER MARITAL STATUS NO. OF W/H ALLOW. TOTAL EARNINGS Totals FUTA SUTA Name: FOR PERIOD ENDING Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 20– DESCRIPTION DATE DEBIT CREDIT JOURNAL EMPLOYEE 11 Carson, Fran M. 12 Wilson, William A. 13 Utley, Harry T. 21 Fife, Lawrence R. 22 Smith, Lucy K. 31 Fay, Gretchen R. 32 Robey, Glenda B. 33 Schork, Thomas K. 51 Hardy, Barbara T. 99 Kipley, Carson C. REGULAR EARNINGS HOURS WORKED RATE PER HOUR AMOUNT KIPLEY COMPANY, INC. January 8, 20 – – OVERTIME EARNINGS SIMPLE INSURANCE HEALTH GROUP NET PAY CHECK NO. TAXABLE EARNINGS Wages and Salaries FICA Taxes Payable – OASDI FICA Taxes Payable – HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable SIMPLE Deductions Payable Group Insurance Premiums Collected Health Insurance Premiums Collected Salaries Payable Jan. 14 Salaries Payable Cash Payroll Taxes FUTA Taxes Payable SUTA Taxes Payable Jan. 12 Jan. 12 Continuing Payroll Problem-A Net Taxable Earnings Rate Net FUTA FUTA Tax SUTA Tax Earnings Excel Instructions using Excel 2010: 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 2. A formula begins with an equals sign (=) and can consist of any of the following elements: Operators such as + (for addition), – (for subtraction), * (for multiplication), and / (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow…