Answered step by step
Verified Expert Solution
Link Copied!

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!! image text in transcribed
image text in transcribed
. 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

CIA Exam Practice Questions Certified Internal Auditor

Authors: The Internal Audit Foundation

1st Edition

163454045X, 978-1634540452

More Books

Students also viewed these Accounting questions

Question

1. How might volunteering help the employer and the employee?

Answered: 1 week ago