August 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 loon to view the assumptions.) (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 - X Employee W-4 Earnings Regular Data table Overtime Rate Current Eamings (YTD) Gross Pay Name Allow. (YTD) Salary Hours Rate Amount Hours S-1 S-1 Allowance and Marital Status Cumulative Earnings Before This Payroll Biweekly Salary S-2 Employee S-2 Burby, Harriett Fein, Katie S-1 S-1 S-0 Taxable Earnings Deductions Exp. Account Charged Kent, Helen Connell, Bryce Barras, Liam S-2 S-2 S-0 FUTA/ FICA Med. Ck. SUTA OASDI OASDI Medicare Ins. # Burby, H. Fein, K. Kent, H. Connell, B. Barras, L Employee Name Burby, H. Fein, K. Kent, H. FIT SIT Amount Net Pay S 44,000 34,000 55,600 126,100 30.000 Print $ 1,650 950 1,200 1,790 1,310 Done Department Customer Service Office Office Customer Service Customer Service Employee W-4 Earnings Allow. (YTD) Name Burby, H. S-1 Fein, K. S-1 Kent, H. S-2 Connell, B. S-2 Barras, L. S-0 Taxable Earnings FUTA/ SUTA OASDI Employee Name Burby, H. Fein, K. Kent, H. Connell, B. Barras, L. Regular Salary Hours Rate Amount Deductions FICA OASDI Medicare FIT Overtime Hours Rate Amount Med. Ins. SIT Gross Earnings (YTD) Pay Exp. Account Charged Net Ck. Pay # More info Assume the following: 1. FICA OASDI is 6.2% on $127,200; FICA Medicare is 1.45% on all earnings. 2. Each employee contributes $15 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. Print Done X And the wages are- At least But less than $800 $820 820 840 840 860 860 880 880 900 900 920 920 940 940 960 960 980 980 1,000 1,000 1,020 1,020 1,040 1,040 1,060 1,060 1,080 1,080 1,100 1,100 1,120 1,120 1,140 1,140 1,160 1,160 1,180 1,180 1,200 1,200 1,220 1,220 1,240 1,240 1,260 1,260 1,280 0 $90 93 96 99 102 105 108 111 114 117 120 123 126 129 132 135 138 141 145 147 150 153 156 159 $67 70 73 76 79 82 85 88 91 94 97 100 103 106 109 112 115 118 121 124 127 130 133 136 SINGLE Persons-BIWEEKLY Payroll Period (For Wages Paid through December 31, 201X) 2 $44 47 50 53 56 59 62 65 68 71 74 77 80 83 86 89 92 95 98 101 104 107 110 113 And the number of withholding allowances claimed is 3 4 5 6 7 The amount of income tax to be withheld is- $25 $10 $0 27 12 29 14 31 16 0 33 18 35 20 38 22 41 24 44 26 47 28 50 30 53 32 56 34 59 36 62 39 65 42 68 45 71 48 74 51 77 54 80 57 83 60 86 63 89 66 GOOON To 88 399%d a s a d 2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 39 42 0000 0 5 7 9 11 13 15 17 19 21 23 25 SO 9000000000 0 000 00000 ww - 00 00 00 000 8 m $0 9 $0 10 50 0 0 0 0 0 000 o d 0 000 00000 0 00 00 00 000 0000 000 00 00 000 0000 00000000000000 1,260 1,280 1,300 1,320 1,340 1,360 1,380 1,400 1,420 1.440 1,460 1,480 1,500 1,520 1,540 1.560 1,580 1,600 1,620 1,640 1,660 1,680 1,700 1,720 1,740 1,760 1,780 1,800 1,820 1,840 1,860 1.880 1,280 1,300 1,320 1.340 1,360 1,380 1,400 1,420 1,440 1,460 1,480 1,500 1,520 1,540 1,560 1.580 1,600 1,620 1,640 1,660 1,680 1,700 1,720 1.740 1,760 1,780 1,800 1,820 1.840 1,860 1,880 1.900 www 159 162 165 168 171 174 177 180 183 186 189 192 195 198 201 206 211 216 221 226 231 236 241 246 251 256 261 266 271 276 281 286 136 139 142 145 148 151 154 157 160 163 166 169 172 175 178 181 184 187 190 193 196 199 203 208 213 218 223 228 233 238 243 248 113 116 119 122 125 128 131 134 137 140 143 146 149 152 155 158 161 164 167 170 173 176 179 95 98 101 104 107 110 113 116 119 122 125 128 131 134 137 140 146 149 152 158 161 164 167 170 173 182 87 90 93 102 105 108 111 114 117 120 123 126 129 132 135 138 141 144 147 150 153 156 159 108 111 114 117 120 123 126 129 132 135 55 97 100 103 106 109 112 11 13 15 17 19 21 31 33 35 38 47 50 53 56 59 62 65 68 71 74 77 80 83 86 89 0 0 0 0 10 NAD 000 18 0 0 0 53 56 59 62 65 00 10 0 0 0 0 0 0 0 0 00 00 2468 0 10 0 40000 1,800 1,820 1,840 1,860 1,880 1,900 1,920 1,940 1,960 1,980 2,000 2,020 2,040 2,060 2,080 1,820 1,840 1,860 1,880 1,900 1,920 1,940 1,960 1,980 2,000 2,020 2,040 2,060 2,080 2,100 266 271 276 281 286 291 296 301 306 311 316 321 326 331 336 228 233 238 243 248 253 258 263 268 273 278 283 288 293 298 194 197 200 204 209 214 219 224 229 234 239 244 249 254 259 170 173 176 179 182 185 188 191 194 197 200 205 210 215 220 147 150 153 156 159 162 165 168 171 174 177 180 183 186 189 123 126 129 132 135 138 141 144 147 150 153 156 159 162 165 100 103 106 109 112 115 118 121 124 127 130 133 136 139 142 77 80 83 86 89 92 95 98 101 104 107 110 113 116 119 53 56 59 62 65 68 71 74 77 80 83 86 89 92 95 32 34 36 39 42 45 48 51 54 57 60 63 66 69 72 16 18 20 22 24 26 28 30 32 34 37 40 43 46 49
