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:

Allowance and

Cumulative Earnings

Employee

Marital Status

Before This Payroll

Biweekly Salary

Department

Burr, Heidi

S1

$41,000

$1,400

Customer Service

Hunt, Kaniya

S0

36,000

1,350

Office

Sheldon, Hope

S1

56,900

1,150

Office

Blair, Bryce

S2

126,100

2,020

Customer Service

Clinton, Larry

S3

30,000

1,010

Customer Service

Assume the following:

1.

FICA OASDI is on ; FICA Medicare is on all earnings.

2.

Each employee contributes biweekly for medical insurance.

3.

State income tax is of gross pay.

4.

FIT is calculated using the federal income tax withholding table included.

All Company overed myces Your task is to use the floweg Womation to prepare apayroll rester et pay for each more Clotheloon to view the information the contoww the sun Click to conto vew Shole Pensional Pavol Pored the whole More info -X Prepare partieron gay for each anpayee Prepare there for the weekly payroon Arwena w Alio. Aow YTD Year From IT-Steineeme Tak PUTA DUTA Einges will be contre Womation Assume the we 1. PICADAS $127.200 FICAM 140 2 140 for medical 1 comme 4 wenn wir C w4 troy Na Ei (VTOL 4100 Heg Om Hour Anal Amount Famos (V10 A 11 Salary Our 1400 Print Done HR She Circo Ba Data table Marnatus Employee Bus Hot Hart, Mary Sheldon Hoe B Bryce Carton, Bad v Paul 41.000 5.000 50,000 weekly Stary Department 1 140 Custom San 1310 Of 10 OCH 2.000 Service 3.10 Der Serve S-1 Chunkan 13 30.000 Winn G table SINGLE Persons- BIWEEKLY Payroll Period (For Wages Paid through December 31, 201x) And the wages are- At least But less than 2 8 9 10 $820 5800 820 840 850 380 $90 93 96 99 102 $0 0 4 4 And the number of withholding allowances claimed is 3 4 5 6 The amount of income tax to be withheld is $10 $0 12 14 16 0 0 18 2 0 0 4 6 0 3 10 0 47 12 2 0 o 0 4 0 0 0 O B%589% 0 o 0 0 0 0 0 0 0 0 50 14 1 3 o 12 o O 1,000 1.020 1,040 1,050 1.030 1,100 1.120 1,140 1,020 1,040 1,060 1. OBD 1.100 1.120 1,140 1.169 1180 1.200 0 O o 112 goooooooooooooooooooooooooo 0 132 135 138 143 147 150 153 wwwHx ix | 124 127 8 Mobococh 104 102 110 113 116 119 122 nur boo o 11 13 15 Print Done ada -in- # 1 0 | 5 6 o 154 180 183 186 139 192 110 113 116 119 122 9 10 12 14 16 99 157 160 163 166 169 172 175 178 181 184 0 o o d 0 2 4 6 125 134 137 140 143 145 145 152 155 159 161 164 167 170 173 176 102 E 1E 111 114 #4 = 137 1420 1.440 1.446 1,460 1.450 1.480 1.480 1.500 1,500 1,520 1.520 1.540 1540 1.560 1560 1580 1.500 1.600 1600 1,620 1.620 1.640 1,660 1,660 1,660 1.680 1.630 1.700 1.700 1,720 1.720 1.740 1,740 1.760 1760 1780 1.700 1.000 1.800 1820 1120 1.840 1.340 MO 1.800 1.8.80 1 1.000 10 23 187 190 193 195 193 140 143 146 189 152 117 120 123 126 125 12 14 16 10 20 bne 62 60 71 72 220 155 158 151 164 167 170 173 176 179 182 185 188 191 194 197 144 147 150 153 156 159 162 165 10 160 171 174 101 111 114 11 117 120 123 126 129 132 135 13 141 144 147 350 4 = = = = = # # # # A = = = = = = $45 109 112 ( ) Print Done VidTYTYRA a table 0 cc 186 189 192 162 166 169 12 14 16 0 2 4 172 175 178 181 184 149 152 155 158 161 125 128 131 134 137 0 0 10 0 111 114 num% 8%%% 10 33 35 38 41 44 47 50 53 56 59 187 190 164 167 170 140 143 145 149 152 117 120 123 126 129 nan m w 12 14 16 18 20 155 158 161 164 167 192 135 138 141 144 108 111 114 117 120 1,600 1,620 1.640 1.660 1.680 1.700 1.720 1.740 1.760 1780 1.800 1820 1.840 1166 110 1000 1.920 1.940 1960 1,080 2000 2020 2.040 2000 2.000 62 65 60 71 74 =w=%%### = Us nu" Twn 170 173 176 179 218 223 228 233 231 24) PA 253 28 263 260 273 147 150 153 156 159 123 126 129 132 135 1,500 1.620 1140 1.860 1880 1.000 1020 1.040 1.000 1.000 2.000 2,020 2040 2,060 2000 2.100 112 , - ooo 09 Hm**-muno |||| 180 191 194 197 162 165 160 171 174 17. 180 180 138 141 144 147 150 153 156 159 162 165 11 110 121 124 127 130 133 134 139 143 92 95 98 101 104 107 110 113 116 119 95 | Print Done Prepare a payron register to calculate net pay for each employeo (Prepare the register for the biweekly payroll period. Round each calcula table leave the box empty: do not enter a zero. Abbreviations used: Allow. - Allowances, YTD = Year to date, FIT - Federal Income Tax, SIT Insurance. For the purposes of this problem, we will ignore the "Taxable FUTA and SUTA Earnings as well as the "Expense Account Charg Prior Current W-4 Employee Name Overtime Gross Regular Hours Rate Amount Earnings (YTD) 41000 Allow Earnings (YTD) Salary 1400 Hours Rate Amount Pay Burr, H. S-1 Hunt, K S-0 Sheldon. H S-1 Blair, B S-2 Clinton, L. S-3 Data table Allowance and Cumulative Earnings Before This Payroll Marital Status fa box is not se, Med. Ins. S-1 Biweekly Salary 1,400 1,350 41,000 S-0 Employee Burr, Heidi Hunt, Kaniya Sheldon, Hope - Blair, Bryce Clinton, Larry 36,000 56,900 Department Customer Service Office Office Customer Service Customer Service S-1 1,150 2,020 S-2 126,100 30,000 S-3 1,010 Print Done More info est cent as need be Tax, Exp. = E Assume the following: 1. FICA OASDI is 6.2% on $127,200; FICA Medicare is 1.45% on all earnings. 2. Each employee contributes $40 biweekly for medical insurance. 3. State income tax is 9% of gross pay. 4. FIT is calculated using the federal income tax withholding table included. - Print Done All Company overed myces Your task is to use the floweg Womation to prepare apayroll rester et pay for each more Clotheloon to view the information the contoww the sun Click to conto vew Shole Pensional Pavol Pored the whole More info -X Prepare partieron gay for each anpayee Prepare there for the weekly payroon Arwena w Alio. Aow YTD Year From IT-Steineeme Tak PUTA DUTA Einges will be contre Womation Assume the we 1. PICADAS $127.200 FICAM 140 2 140 for medical 1 comme 4 wenn wir C w4 troy Na Ei (VTOL 4100 Heg Om Hour Anal Amount Famos (V10 A 11 Salary Our 1400 Print Done HR She Circo Ba Data table Marnatus Employee Bus Hot Hart, Mary Sheldon Hoe B Bryce Carton, Bad v Paul 41.000 5.000 50,000 weekly Stary Department 1 140 Custom San 1310 Of 10 OCH 2.000 Service 3.10 Der Serve S-1 Chunkan 13 30.000 Winn G table SINGLE Persons- BIWEEKLY Payroll Period (For Wages Paid through December 31, 201x) And the wages are- At least But less than 2 8 9 10 $820 5800 820 840 850 380 $90 93 96 99 102 $0 0 4 4 And the number of withholding allowances claimed is 3 4 5 6 The amount of income tax to be withheld is $10 $0 12 14 16 0 0 18 2 0 0 4 6 0 3 10 0 47 12 2 0 o 0 4 0 0 0 O B%589% 0 o 0 0 0 0 0 0 0 0 50 14 1 3 o 12 o O 1,000 1.020 1,040 1,050 1.030 1,100 1.120 1,140 1,020 1,040 1,060 1. OBD 1.100 1.120 1,140 1.169 1180 1.200 0 O o 112 goooooooooooooooooooooooooo 0 132 135 138 143 147 150 153 wwwHx ix | 124 127 8 Mobococh 104 102 110 113 116 119 122 nur boo o 11 13 15 Print Done ada -in- # 1 0 | 5 6 o 154 180 183 186 139 192 110 113 116 119 122 9 10 12 14 16 99 157 160 163 166 169 172 175 178 181 184 0 o o d 0 2 4 6 125 134 137 140 143 145 145 152 155 159 161 164 167 170 173 176 102 E 1E 111 114 #4 = 137 1420 1.440 1.446 1,460 1.450 1.480 1.480 1.500 1,500 1,520 1.520 1.540 1540 1.560 1560 1580 1.500 1.600 1600 1,620 1.620 1.640 1,660 1,660 1,660 1.680 1.630 1.700 1.700 1,720 1.720 1.740 1,740 1.760 1760 1780 1.700 1.000 1.800 1820 1120 1.840 1.340 MO 1.800 1.8.80 1 1.000 10 23 187 190 193 195 193 140 143 146 189 152 117 120 123 126 125 12 14 16 10 20 bne 62 60 71 72 220 155 158 151 164 167 170 173 176 179 182 185 188 191 194 197 144 147 150 153 156 159 162 165 10 160 171 174 101 111 114 11 117 120 123 126 129 132 135 13 141 144 147 350 4 = = = = = # # # # A = = = = = = $45 109 112 ( ) Print Done VidTYTYRA a table 0 cc 186 189 192 162 166 169 12 14 16 0 2 4 172 175 178 181 184 149 152 155 158 161 125 128 131 134 137 0 0 10 0 111 114 num% 8%%% 10 33 35 38 41 44 47 50 53 56 59 187 190 164 167 170 140 143 145 149 152 117 120 123 126 129 nan m w 12 14 16 18 20 155 158 161 164 167 192 135 138 141 144 108 111 114 117 120 1,600 1,620 1.640 1.660 1.680 1.700 1.720 1.740 1.760 1780 1.800 1820 1.840 1166 110 1000 1.920 1.940 1960 1,080 2000 2020 2.040 2000 2.000 62 65 60 71 74 =w=%%### = Us nu" Twn 170 173 176 179 218 223 228 233 231 24) PA 253 28 263 260 273 147 150 153 156 159 123 126 129 132 135 1,500 1.620 1140 1.860 1880 1.000 1020 1.040 1.000 1.000 2.000 2,020 2040 2,060 2000 2.100 112 , - ooo 09 Hm**-muno |||| 180 191 194 197 162 165 160 171 174 17. 180 180 138 141 144 147 150 153 156 159 162 165 11 110 121 124 127 130 133 134 139 143 92 95 98 101 104 107 110 113 116 119 95 | Print Done Prepare a payron register to calculate net pay for each employeo (Prepare the register for the biweekly payroll period. Round each calcula table leave the box empty: do not enter a zero. Abbreviations used: Allow. - Allowances, YTD = Year to date, FIT - Federal Income Tax, SIT Insurance. For the purposes of this problem, we will ignore the "Taxable FUTA and SUTA Earnings as well as the "Expense Account Charg Prior Current W-4 Employee Name Overtime Gross Regular Hours Rate Amount Earnings (YTD) 41000 Allow Earnings (YTD) Salary 1400 Hours Rate Amount Pay Burr, H. S-1 Hunt, K S-0 Sheldon. H S-1 Blair, B S-2 Clinton, L. S-3 Data table Allowance and Cumulative Earnings Before This Payroll Marital Status fa box is not se, Med. Ins. S-1 Biweekly Salary 1,400 1,350 41,000 S-0 Employee Burr, Heidi Hunt, Kaniya Sheldon, Hope - Blair, Bryce Clinton, Larry 36,000 56,900 Department Customer Service Office Office Customer Service Customer Service S-1 1,150 2,020 S-2 126,100 30,000 S-3 1,010 Print Done More info est cent as need be Tax, Exp. = E Assume the following: 1. FICA OASDI is 6.2% on $127,200; FICA Medicare is 1.45% on all earnings. 2. Each employee contributes $40 biweekly for medical insurance. 3. State income tax is 9% of gross pay. 4. FIT is calculated using the federal income tax withholding table included. - Print Done