Problem 5-3A (Algo) The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.40 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee S. Bergstrom C. Pare L. Van der Hooven S. Lightfoot Filing Status, Dependents MJ-0 MJ-2 (<17) S-1 (Other) MJ-0 $ Pay Union Dues per Period 1,750 3,600 $ 3,325 $ $ $ $ 2,950 Garnishment per Period 120 240 $ $ 50 75 100 Net Pay

Problem 5-3A (Algo) The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.40 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee S. Bergstrom C. Pare L. Van der Hooven S. Lightfoot Filing Status, Dependents MJ-0 MJ-2 (<17) S-1 (Other) MJ-0 $ Pay Union Dues per Period 1,750 3,600 $ 3,325 $ $ $ $ 2,950 Garnishment per Period 120 240 $ $ 50 75 100 Net Pay

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter10: Payroll Register (pr)

Section: Chapter Questions

Problem 9R: Click the Chart sheet tab. On the screen is a chart of the four payroll taxes that a company might...

See similar textbooks

Similar questions

Click the Chart sheet tab. On the screen is a chart of the four payroll taxes that a company might incur in total during the year. The four taxes are federal unemployment, state unemployment, Social Security, and Medicare. By the behaviors shown on the chart, identify below which of the four taxes each represents. Series 1 _____ Series 2 _____ Series 3 _____ Series 4 _____ When the assignment is complete, close the file without saving it again. TICKLERS (optional) Worksheet. A new employee was hired during November and was mistakenly omitted from the payroll register. The employees last name is Zuckerman, and his gross pay for November is 1,300. Add the new employee to the PR5 worksheet and include all standard withholding rates in computing net pay. Federal income tax withheld is 101. He is a union member. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as PRT. Chart. Using the PR4 file, prepare a 3-D pie chart to show the percentage of an employees gross pay that is withheld for taxes, Social Security, and so on, and how much is left over as net pay. Use Smith as your example. Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as PR4. Print the chart.
Problem 5-3A (Algo) The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimanthly. Some employees have union dues or gamishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.55 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employes S. Bergstrom C. Pare L. Van der Hoovent S. Lightfoot Filing Status. Dependents MJ-0 MJ-2 (17) S-1 (Other) MJ-O Union Duss per Period Pay $ 1,830 S 3,760 S $ 3,485 $ $ 3,110 120 240 Gamishment per Period $ $ S 50 75 100 Net Pay
ces The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.55 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee S. Bergstrom C. Pare L. Van der Hooven S. Lightfoot Filing Status, Dependents MJ-0 MJ-2 (<17) S-1 (Other) MJ-0 $ $ $ $ Pay Union Dues per Period 1,820 3,740 $ 3,465 $ 3,090 120 240 Garnishment per Period $ $ $ 50 75 100 Net Pay
P Problem 5-3A (Algo) The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.55 percent of taxable pay. No employee has exceeded the maximum FICA limit. (Round your intermediate calculations and final answers to 2 decimal places.) Employee S. Bergstrom C. Pare L. Van der Hooven S. Lightfoot F2 # 3 E JUL 7 80 F3 Filing Status, Dependents MJ-0 MJ-2 ( IM ZA O * 00 8 DII F8 1 ( 9 J K CV BN M F9 O < W F10 L P 4 F11 P
The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix Cito determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.40 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee S. Bergstrom C. Pare L. Van der Hooven S. Lightfoot Filing Status, Dependents MJ-0 MJ-2 (<17) S-1 (Other) MJ-0 Union Dues per Period Pay $ 1,720 $ 3,540 $ $ 3,265 $ $ 2,890 120 240 Garnishment per Period $ $ $ 50 75: 100 Net Pay
The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.55 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee S. Bergstrom C. Pare L Van der Hooven S Lightfoot Filing Status, Dependents MJ-0 MJ-2 (<17) S-1 (Other) MJ-0 Union Dues per Period Pay $ 1,760 $ 3,620 S $ 3,345 $ $ 2,970 Garnishment per Period $ 120 240 $ $ 50 75 100 Net Pay
The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.55 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee S. Bergstrom C. Pare L. Van der Hooven S. Lightfoot Filing Status, Dependents MJ-0 MJ-2 (<17) S-1 (Other) MJ-0 Pay 1,820 $ $ 3,740 $ $ 3,465 3,090 LA A Union Dues per Period $ $ 120 240 Garnishment per Period $ $ $ 50 75 100 Net Pay
The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.55 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee S. Bergstrom C. Pare L. Van der Hooven S. Lightfoot Filing Status, Dependents MJ-0 MJ-2 (<17) S-1 (Other) MJ-0 Answer is complete but not entirely correct. Union Dues per Period Pay $ 1,810 $ 3,720 $ 3,445 S 3,070 $ 120 240 Garnishment per Period 55 H 50 75 100 Net Pay $ 1,489.02 2,906.45 2,575.44 x 2,425.43 ssss $ $ $
The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.40 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee Filing Status, Dependents Pay Union Dues per Period Garnishment per Period Net Pay S. Bergstrom MJ-0 $ 1,810 $ 50 C. Pare MJ-2 (<17) $ 3,720 $ 120 L. Van der Hooven S-1 (Other) $ 3,445 $ 240 $ 75 S. Lightfoot MJ-0 $ 3,070 $ 100
The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.40 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee S. Bergstrom Filing Status, Dependents Union Dues Garnishment Pay per Period per Period Net Pay MJ-0 $ 1,700 $ 50 C. Pare MJ-2 (<17) $ 3,500 $ 120 L. Van der Hooven S-1 (Other) $ 3,225 $ 240 $ 75 S. Lightfoot MJ-0 $ 2,850 $ 100
Problem 10-57 (LO 10-2, 10-4) Lauprechta Incorporated has the following employees on payroll. Assume that all the employees has only one job or that step 2 of Form W-4 is not checked and all dependents are under the age of 17. Also, the employer uses the Percentage Method Tables for Manual Payroll Systems with Forms W-4 from 2020 or Later. Use percentage method tables for a manual payroll systems. Semimonthly Payroll Number of Dependents from Form W- Marital 4 Status Naila Wilfred $ 6,000 3 Married $ 5,300 2 Married Byron $ 3,900 B Single Head of Annie $ 4,500 1 Household Required: Complete the table for taxes to be withheld for each pay period. Note: Round your intermediate computations and final answers to 2 decimal places. Employee Tax Federal Withholding Social Security Tax Medicare Tax Total Taxes Withheld Naila Wilfred Byron Annie
The following salaried employees of Mountain Stone Brewery in Fort Collins, Colorado, are paid semimonthly. Some employees have union dues or garnishments deducted from their pay. You do not need to complete the number of hours. Required: Calculate their net pay using the percentage method for manual payroll systems with Forms W-4 from 2020 or later in Appendix C to determine federal income tax. Assume box 2 is not checked for any employee. Include Colorado income tax of 4.55 percent of taxable pay. No employee has exceeded the maximum FICA limit. Note: Round your intermediate calculations and final answers to 2 decimal places. Employee S. Bergstrom C. Pare L. Van der Hooven S. Lightfoot Filing Status, Dependents MJ-0 MJ-2 (<17) S-1 (Other) MJ-0 Answer is complete but not entirely correct. Union Dues per Period Garnishment per Period S Pay $ 1,810 $ 3,720 $ 3,445 $ 3,070 $ S 120 240 $ $ 50 75 100 $ $ S $ Net Pay 1,489.02 2,906.45 x 2,575.44X 2.425.43