Question: i need help finding the overtime earnings which is hours worked column, rate per hour, amount... then total earnings column, fica section - need help

i need help finding the overtime earnings which is hours worked column, rate per hour, amount... then total earnings column, fica section - need help find OASDI, HI Column and FIT column.. I have to use the excel formula to put in the cells. Please show formula

C D Name: Cautions See "round" rules in Excel Instructions before calculating OT for employees. inter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (") will appear to the right of an incorrect answer, Continuing Payroll Problem-A KIPLEY COMPANY, INC. PAYROLL REGISTER FOR PERIOD ENDING January 8, 20 - REGULAR EARNINGS OVERTIME EARNINGS NO. OF VH RATE RATE STATUS WORKE ALLOW. PER WORKE PER TOTAL FICA EMPLOYEE HOUR AMOUNT HOUR AMOUNT EARNINGS DASDI HI FIT SIT 11 Carson, Fran M. S 40 $17.50 700.00 12 Wilson, William A. 5 0 40 $17.25 690.00 13 Utley, Harry T. 2 37.5 $18.10 678.75 21 Fife, Lawrence R. 40 $17.90 716.00 22 Smith, Lucy K. S 2 40 $19.75 790.00 31 Fay, Gretchen R. M 3 40 515.00 32 Robey, Glenda B. 6 40 623.08 33 Schork, Thomas K. S 40 773.08 51 Hardy, Barbara T. 5 40 579.23 99 Kipley, Carson C. M 40 1,000.00 Totals 7,065.14" Continuing Problem-A iter Type here to search 99+ VOC D Name: Cautions See "round" rules in Excel Instructions before calculating OT for employees. inter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (") will appear to the right of an incorrect answer, Continuing Payroll Problem-A KIPLEY COMPANY, INC. PAYROLL REGISTER FOR PERIOD ENDING January 8, 20 - REGULAR EARNINGS OVERTIME EARNINGS NO. OF VH RATE RATE STATUS WORKE ALLOW. PER WORKE PER TOTAL FICA EMPLOYEE HOUR AMOUNT HOUR AMOUNT EARNINGS DASDI HI FIT SIT 11 Carson, Fran M. S 40 $17.50 700.00 12 Wilson, William A. 5 0 40 $17.25 690.00 13 Utley, Harry T. 2 37.5 $18.10 678.75 21 Fife, Lawrence R. 40 $17.90 716.00 22 Smith, Lucy K. S 2 40 $19.75 790.00 31 Fay, Gretchen R. M 3 40 515.00 32 Robey, Glenda B. 6 40 623.08 33 Schork, Thomas K. S 40 773.08 51 Hardy, Barbara T. 5 40 579.23 99 Kipley, Carson C. M 40 1,000.00 Totals 7,065.14" Continuing Problem-A iter Type here to search 99+ VO\f

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

I need help with the OVERTIME SECTION -- I need the Hours Worked, Rate Per Hour, Amount, Total Earnings Column... FICA SECTION - OASDI, HI, FIT, SIT Column and I have to have the excel formula to be...

Refer to the partially completed payroll register that you worked on at the end of Chapter 4. You will now compute the employer's liability for unemployment taxes (FUTA and SUTA) for the pay of...

3. Record the amount of federal income taxes under the FIT column using the wage-bracket method using table provided for each employee. MARITAL STATUS NO. OF W/H ALLOW. REGULAR EARNINGS OVERTIME...

Can someone help me? Thank you Payroll Accounting 2015 CONTINUING PAYROLL PROBLEMA In this last phase of your work on the Continuing Payroll 6. On a separate sheet of paper: Problem A, you will...

need this done by the 12th. please follow the directions. There are 2 problems. the 2nd problem needs a 941, 940 and OH SUTA form with it. thanks Final Exam - Problem 2 941, SUTA and 940 Tax Return...

CAUTION: Read Appendix B for specific instructions recurg luwese templates. 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (") will appear to the right of an...

Please complete the assignment sheet attached. Thank you! Name: Caution: See "round" rules in Excel Instructions before calculating OT for salaried employees. Enter the appropriate numbers/formulas...

52 2,307.69 3,398.00 3,600.00 4,616.40 20 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT...

write a Program Counter Code in VHDL. 64 bit register that holds the address of the current instruction. Should have 2 inputs, clock (1 bit) and the next instruction address (64 bits), and 1 ouptut,...

Shaw Communications, Inc.* included this information in its 2008 annual report. August 31, 2008, 2007, and 2006 (all amounts in thousands of Canadian dollars except share and per share amounts)...

Factors that are considered in determining the reasonableness of salary include" A . The prevailing rate paid by other companies B . The scarcity of qualified employees C . The size of the company D...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...