Answered step by step
Verified Expert Solution
Question
1 Approved Answer
may someone help me to find the Net Pay at the second page please!! . Excel Project #8: Kipley Company Payroll Register: Download the Excel
may someone help me to find the Net Pay at the second page please!! . Excel Project #8: Kipley Company Payroll Register: Download the Excel file below these instructions and save it as Excel8_lyour initials). Follow the directions for each column, to enter the information in the Payroll Register, using formulas when appropriate Regular Earnings: Employee Hours Worked Rate per Hour Amount Carson, F. 40 17.50 Use a formula to calculate Wilson, W. 40 17 25 Use a formula to calculate Utley, H. 37.5 18.10 Use a formula to calculate Fife, L 40 17.90 Use a formula to calculate Smith, L. 40 19.75 Use a formula to calculate Fay, G. 40 515.00 Robey, G 40 623.08 Schork, T 40 773.08 Hardy. B. 40 579.23 Kipley, 40 1,000.00 Overtime Earnings: Hours Worked Rate per Hour Amount 8 25.88 Use a formula to calculate 6 26.85 Use a formula to calculate Employee Carson Wilson Utley Fife Smith Fay Robey Schork Hardy Kipley 1.25 19.32 Use a formula to calculate 4 21.72 Use a formula to calculate Total Earnings: Use a formula to add the Regular Earnings to the Overtime Earnings. Deductions: Employee OASDI HI FIT SIT Carson 6.2% x Total Earnings 1.45% x Total Earnings 60.00 3.07% x Total Earnings Wilson 6.2% x Total Earnings 1.45% x Total Earnings 91.00 3.07% x Total Earnings Utley 6.2% x Total Earnings 1.45% x Total Earnings 25.00 3.07% Total Earnings Fife 6.2% x Total Earnings 1.45% x Total Earnings 28.00 3.07% x Total Earnings Smith 6.2% x Total Earnings 1.45% x Total Earnings 61.00 3.07% x Total Earnings Fay 6.2% x Total Earnings 1.45% x Total Earnings 3.00 3.07% x Total Earnings Robey 6.2% x Total Earnings 1.45% x Total Earnings 0.00 3.07% x Total Earnings Schork 6.2% x Total Earnings 1.45% x Total Earnings 64.00 3.07% x Total Earnings Hardy 6.2% x Total Earnings 1.45% x Total Earnings 1.00 3.07% x Total Earnings Kipley 6.2% x Total Earnings 1.45% x Total Earnings 13.00 3.07% x Total Earnings Employee Carson Wilson Utley Fife Smith Fay Robey Schork Hardy Kipley SUTA 06x Total Earnings 069 x Total Earnings 06% x Total Earnings 06% x Total Earnings .06% x Total Earnings .06% x Total Earnings .06% x Total Earnings .06% x Total Earnings .06%x Total Earnings .06% Total Earnings CIT 3% x Total Earnings 3% x Total Earnings 3% x Total Earnings 3% x Total Earnings 3% x Total Earnings 3% x Total Earnings 3% x Total Earnings 3% x Total Earnings 3% x Total Earnings 3% x Total Earnings SIMPLE GRP Ins. 20.00 85 50.00 85 40.00 85 50.00 85 20.00 0.00 40.00 85 50.00 .85 60.00 0.00 30.00 .85 80.00 85 HLTH Ins. 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 Check # 313 314 315 316 317 318 319 320 321 322 Net Pay Formula Formula Formula Formula Formula Formula Formula Formula Formula Formula Net Pay: Total Earnings less each deduction
may someone help me to find the Net Pay at the second page please!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started