Question: Name: Caution: See round rules in Excel Instructions before calculating OT for employees. Enter the appropriate numbers formulas in the shaded (gray) cells. An asterisk


Name: Caution: See "round" rules in Excel Instructions before calculating OT for employees. Enter the appropriate numbers formulas in the shaded (gray) cells. An asterisk (") will appear to the right of an incorrect answer. Continuing Payroll Problem-A FOR 89RICO ENDING January 8, 20 . . REGULAR EARNINGS OVERTIME EARNINGS STATE WORKED RATE FER RATE PER TOTAL FICA EMPLOYEE HOUR AMOUNT HOUR AMOUNT EARNINGS OASO HI 11 Carson, Fran M. 40 $17.50 700.00 30.00 700.00 43.40 10.15 12 Wilson, William A. 517.25 690.00 325 86 207_04 897.04 55.52 # 13.01 13 Udey Harry T. 37.5 $16.10 678.75 678.75 42 08 9.84 21 Fife, Lawrence R. 317.90 716.00 161 10 877.10 54.38 12.72 22 Smith, Lucy K 40 $19.75 790.00 50.00 790.00 48.98 11.46 31 Funy, Gretchen R. 41 25 312.83 515.00 1.25 $19.32 24.15 539.15 33.43 7.82 32 Robey, Glenda B 40 :15.53 623.08 30.00 523.08 38.63 9.03 33 Schork Thomas K. 40 $19.33 773.06 20.00 773.08 47.93 11.21 51 Hardy, Barbara T. 14 $14.43 579.23 $21.72 86.38 565.11 41 30 9.65 99 Kipley, Carson C. $25.00 1 000.00 180.00 30.00 1,000.00 62.00 14.50 Totals 7 065.14 479.17 7,544.31 467.75 109.40 JOURNAL DATE DESCRIPTION DEBIT CREDIT 20
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
