Answered step by step
Verified Expert Solution
Question
1 Approved Answer
June Company has five salaried employees. Your task is to use the following information to prepare a payroll register to calculate net pay for each
June Company has five salaried employees. Your task is to use the following information to prepare a payroll register to calculate net pay for each employee: (Click the icon to view the information.) Click the icon to view the assumptions.) E: (Click the icon to view the Single Persons - Biweekly Payroll Period federal income tax withholding table.) Prepare a payroll register to calculate net pay for each employee. (Prepare the register for the biweekly payroll period. Round each calculation to the nearest cent as needed. If a box is not used in the table leave the box empty; do not enter a zero. Abbreviations used: Allow. = Allowances, YTD = Year to date, FIT = Federal Income Tax, SIT = State Income Tax, Exp. = Expense, Med. Ins. = Medical Insurance. For the purposes of this problem, we will ignore the "Taxable FUTA and SUTA Earnings as well as the "Expense Account Charged information.) Prior Current * More Info X W-4 Overtime Gross Employee Name Earnings (YTD) 46000 Regular Hours Rate Amount Earnings (YTD) Allow. Salary Hours Rate Amount Pay S-0 1150 Cutting, H. Goodrich, K S-1 28000 1050 Assume the following: 1. FICA OASDI is 6.2% on $127,200; FICA Medicare is 1.45% on all earnings 2. Each employee contributes $30 biweekly for medical insurance. 3. State income tax is 8% of gross pay. 4. FIT is calculated using the federal income tax withholding table included. Ricard, H. S-2 59200 1450 Bard, B. S-2 125900 1750 22000 Barras, L. 9601 960 S-0 SINGLE Persons-BIWEEKLY Payroll Period (For Wages Paid through December 31, 2018) 6360 281100 Print Done And the number of withholding allowances claimed is At least 0 1 2 7 8 9 - X But less than Data Table $800 820 840 860 880 $820 840 860 880 900 $90 93 96 99 102 $67 70 73 76 79 $44 47 50 53 56 $0 0 0 0 0 0 $0 0 0 0 $0 0 0 0 0 Allowance and 0 Marital Status Cumulative Earnings Before This Payroll $ 46,000 28,000 59,200 900 920 940 960 980 Biweekly Salary Department $ 1,150 Customer Service 1,050 Office 920 940 960 980 1,000 105 108 111 114 117 82 85 88 91 94 59 62 65 68 71 3 4 5 6 The amount of income tax to be withheld is $25 $10 $0 $0 27 12 0 0 29 14 o 0 31 16 0 0 33 18 2 0 0 35 20 4 38 22 6 0 41 24 8 0 44 26 10 0 0 47 28 12 0 50 30 14 0 53 32 16 1 56 34 18 3 59 36 20 5 62 39 22 7 0 0 0 0 0 0 0 0 0 S-0 0 0 0 0 0 Employee Cutting, Harriett Goodrich, Kassandra Ricard, Heidi Bard, Brent Barras, Leonardo 0 S-1 S-2 1,450 Office 1,020 1,040 1.060 1,080 1,100 120 123 126 129 132 97 100 103 106 109 74 77 80 83 86 o 0 0 0 0 0 0 0 0 0 0 0 0 0 S-2 125,900 1,750 Customer Service 0 0 S-0 22,000 960 Customer Service 1,000 1,020 1,040 1,060 1,080 1,100 1,120 1,140 1,160 1,180 89 1,120 1.140 1,160 1,180 1,200 135 138 141 145 147 112 115 118 121 124 92 95 98 101 65 68 71 74 77 42 45 48 51 54 24 26 28 30 32 9 11 13 15 17 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 Print Done 1,200 1,220 1 240 1 1,220 1,240 150 153 156 127 130 133 104 107 110 80 83 86 57 60 63 34 36 39 19 21 22 3 5 0 0 0 0 1 260 June Company has five salaried employees. Your task is to use the following information to prepare a payroll register to calculate net pay for each employee: (Click the icon to view the information.) Click the icon to view the assumptions.) E: (Click the icon to view the Single Persons - Biweekly Payroll Period federal income tax withholding table.) Prepare a payroll register to calculate net pay for each employee. (Prepare the register for the biweekly payroll period. Round each calculation to the nearest cent as needed. If a box is not used in the table leave the box empty; do not enter a zero. Abbreviations used: Allow. = Allowances, YTD = Year to date, FIT = Federal Income Tax, SIT = State Income Tax, Exp. = Expense, Med. Ins. = Medical Insurance. For the purposes of this problem, we will ignore the "Taxable FUTA and SUTA Earnings as well as the "Expense Account Charged information.) Prior Current * More Info X W-4 Overtime Gross Employee Name Earnings (YTD) 46000 Regular Hours Rate Amount Earnings (YTD) Allow. Salary Hours Rate Amount Pay S-0 1150 Cutting, H. Goodrich, K S-1 28000 1050 Assume the following: 1. FICA OASDI is 6.2% on $127,200; FICA Medicare is 1.45% on all earnings 2. Each employee contributes $30 biweekly for medical insurance. 3. State income tax is 8% of gross pay. 4. FIT is calculated using the federal income tax withholding table included. Ricard, H. S-2 59200 1450 Bard, B. S-2 125900 1750 22000 Barras, L. 9601 960 S-0 SINGLE Persons-BIWEEKLY Payroll Period (For Wages Paid through December 31, 2018) 6360 281100 Print Done And the number of withholding allowances claimed is At least 0 1 2 7 8 9 - X But less than Data Table $800 820 840 860 880 $820 840 860 880 900 $90 93 96 99 102 $67 70 73 76 79 $44 47 50 53 56 $0 0 0 0 0 0 $0 0 0 0 $0 0 0 0 0 Allowance and 0 Marital Status Cumulative Earnings Before This Payroll $ 46,000 28,000 59,200 900 920 940 960 980 Biweekly Salary Department $ 1,150 Customer Service 1,050 Office 920 940 960 980 1,000 105 108 111 114 117 82 85 88 91 94 59 62 65 68 71 3 4 5 6 The amount of income tax to be withheld is $25 $10 $0 $0 27 12 0 0 29 14 o 0 31 16 0 0 33 18 2 0 0 35 20 4 38 22 6 0 41 24 8 0 44 26 10 0 0 47 28 12 0 50 30 14 0 53 32 16 1 56 34 18 3 59 36 20 5 62 39 22 7 0 0 0 0 0 0 0 0 0 S-0 0 0 0 0 0 Employee Cutting, Harriett Goodrich, Kassandra Ricard, Heidi Bard, Brent Barras, Leonardo 0 S-1 S-2 1,450 Office 1,020 1,040 1.060 1,080 1,100 120 123 126 129 132 97 100 103 106 109 74 77 80 83 86 o 0 0 0 0 0 0 0 0 0 0 0 0 0 S-2 125,900 1,750 Customer Service 0 0 S-0 22,000 960 Customer Service 1,000 1,020 1,040 1,060 1,080 1,100 1,120 1,140 1,160 1,180 89 1,120 1.140 1,160 1,180 1,200 135 138 141 145 147 112 115 118 121 124 92 95 98 101 65 68 71 74 77 42 45 48 51 54 24 26 28 30 32 9 11 13 15 17 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 Print Done 1,200 1,220 1 240 1 1,220 1,240 150 153 156 127 130 133 104 107 110 80 83 86 57 60 63 34 36 39 19 21 22 3 5 0 0 0 0 1 260
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