Question
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_l
Employee Carson Wilson Utley Fife Smith Fay Robey Schork Hardy Kipley SUTA 06x Total Earnings 069 x Total Earnings 06% x Tota
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer There is 2 picture : 1 is answer & 2 one show formulas

K L M N o P Q R S НІ FIT SIT SUTA CIT SIMPLE GRP Ins. HLTH Ins. Check #Net Payl 60.00 0.42 21.00 0.85 1.65 521.04 10.15 13.01A B с D E F Hours Rate/ Normal Overtime Rate/ Employee 1 Worked Hour Wage Hours Hour 2 Carson 140 17.5 =B2*C2 3 Wilson 40 17.

Add a comment
Know the answer?
Add Answer to:
may someone help me to find the Net Pay at the second page please!! . Excel...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Help on this problem would be immensely appreciated. Instructions Continuing Payroll Problem: Chapter 3 As you...

    Help on this problem would be immensely appreciated. Instructions Continuing Payroll Problem: Chapter 3 As you learned in the previous chapter, Kipley Company is a small manufacturing firm located in Pittsburgh, Pennsylvania. The company has a workforce of both hourly and salaried employees. In the last chapter, gross wages were computed for each employee. Adjacent to their name, each employee's gross wages are shown in the Payroll Register. The next task is computing the FICA withholding for each employee and...

  • Record the deduction for group insurance. Record the health insurance deduction. Record the check number assigned...

    Record the deduction for group insurance. Record the health insurance deduction. Record the check number assigned to each employee. Compute and record the net pay for each employee. Total the input columns on the Employee Payroll register. On Employer Register, enter total gross earnings. Prepare the journal entries as of January 12 to record the payroll and the payroll taxes for the week ending January 8. Credit Salaries Payable for the total net pay. Prepare the journal entry to record...

  • You have almost completed the Kipley Company's Employee Payroll Register for the pay period ending January...

    You have almost completed the Kipley Company's Employee Payroll Register for the pay period ending January 8, 20--. In this last task, the following steps will be completed. Requirements: Record the deduction for group insurance. Record the health insurance deduction. Record the check number assigned to each employee. Compute and record the net pay for each employee. Total the input columns on the Employee Payroll register. On Employer Register, enter total gross earnings. Prepare the journal entries as of January...

  • Continuing Payroll Problem, 2A: Chapter 2 Kipley Company is a small manufacturing firm located in Pittsburgh,...

    Continuing Payroll Problem, 2A: Chapter 2 Kipley Company is a small manufacturing firm located in Pittsburgh, Pennsylvania. The company has a workforce of both hourly and salaried employees. Each employee is paid for hours actually worked during each week, with the time worked being recorded in quarter-hour increments. The standard workweek consists of 40 hours, with all employees being paid time and one-half for any hours worked beyond the 40 regular hours. Wages are paid every Friday, with one week's...

  • 1. compute and record the employee’s SUTA contributions (employees pay 0.06% on total gross pay 2....

    1. compute and record the employee’s SUTA contributions (employees pay 0.06% on total gross pay 2. Net FUTA tax : since this is the first pay period of tje uear none of the employees are near the $7000 ceiling; therefore each employess gress earnings us subject to the FUTA tax (the employer rate is 0.6%). 3. SUTA tax: Since Kipley Company is new employer, Pennsylvia has assigned the company contribution rate 3.689% on the first $10,000 of each employee’s earnings....

  • The Federal Unemployment Tax Act (or FUTA, I.R.C. ch. 23) is a United States federal law that imp...

    The Federal Unemployment Tax Act (or FUTA, I.R.C. ch. 23) is a United States federal law that imposes a federal employer tax used to help fund state workforce agencies. Employers report this tax by filing an annual Form 940 with the Internal Revenue Service. Complete the following steps: Net FUTA tax: Since this is the first pay period of the year, none of the employees are near the $7,000 ceiling; therefore, each employee’s gross earnings is subject to the FUTA...

  • The Federal Unemployment Tax Act (or FUTA, I.R.C. ch. 23) is a United States federal law...

    The Federal Unemployment Tax Act (or FUTA, I.R.C. ch. 23) is a United States federal law that imposes a federal employer tax used to help fund state workforce agencies. Employers report this tax by filing an annual Form 940 with the Internal Revenue Service. Complete the following steps: Net FUTA tax: Since this is the first pay period of the year, none of the employees are near the $7,000 ceiling; therefore, each employee’s gross earnings is subject to the FUTA...

  • Your assignment is to calculate OASDI, HI tax, FIT, and SIT creating your own payroll register....

    Your assignment is to calculate OASDI, HI tax, FIT, and SIT creating your own payroll register. Then you must calculate FUTA and SUTA (employer taxes). After completing the register, ABC Company asked you to create the payroll accrual journal entry with wages expense and FICA expense to the employer, so they can record the payroll/tax expense in December. You must create your own journal entry form.Your assignment is to calculate OASDI, HI tax, FIT, and SIT creating your own payroll...

  • please help find discrepancy and solve. Park Company had the following partially completed payroll register: (Click...

    please help find discrepancy and solve. Park Company had the following partially completed payroll register: (Click the icon to view the partial payroll register.) (Click the icon to view payroll tax rate information.) Read the requirements. More Info - X Requirement 1. Complete the payroll register. Round to two decimals. (Round all amounts to the nearest cent. Abbreviations used: Beg. = Begin With. = Withholdings; Chk = Check.) Earnings Withholdings For all payroll calculations, use the following tax rates and...

  • can someone please help me out with this? i have to write this in vba excel....

    can someone please help me out with this? i have to write this in vba excel. Question 2: (40 Pointsy) The total cnerey, E. ofa movins hint i comual to energy, E, of a moving object is equal to the sum of its kinetic and potential energieS: where m is the mass (in kg) v is the velocity (in m/s) h is the height of the object (in m) g is the acceleration due to gravity (9.81 m/s') 5 m/s...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT