Payroll Register

Note : Round your final answers to the nearest cent. Payroll Register

Payroll Register

This is the first task to completing Olney Company's payroll register. Complete the steps outlined below:

$1.$ Record the regular hours and the overtime hours worked for each employee, using the time clerk's report as your reference. For salaried workers, complete the Regular Earnings column and show the hourly overtime rate and earnings only if overtime was worked.

$3.$ Record the Total Earnings for each employee by adding the Regular Earnings and the Overtime Earnings. values to the nearest two decimal places, e$.$g$.,11/2$ to $1\mathrm{.}50.$ Payroll Register

Payroll Register the gross earnings upon which the federal tax to be withheld is determined.

Complete the steps outlined below.

$1.$ Refer to the SIMPLE Plan Contributions and enter each employee's SIMPLE plan deduction.

$2.$ Determine and record the federal income taxes for each employee.

$3.\backslash (\backslash$rightarrow $\backslash )$ Refer to each employee's filing status.

$\backslash (\backslash$rightarrow $\backslash )$ Click the link below to view the Wage$-$Bracket Method tables.

$4.$ Determine and record the state income taxes for each employee using the State of Pennsylvania's rate of $3\mathrm{.}07\backslash \%.$

$5.$ Determine and record the local income taxes for the Chalfont Boro residents at the rate of $\backslash (1\mathrm{.}0\backslash \%\backslash ).$

$6.$ Total each input column.

Note: Round your final answers to the cent. Enter all amounts as positive numbers.

Click here to access the Wage$-$Bracket Method Tables.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{21\}\{|$c$|\}\{\backslash$begin$\{$tabular$\}\{$l$\}$

OLNEY COMPANY, INC. $\backslash \backslash$

Employee Payroll Register $\backslash \backslash$

For Period Ending January $8,20--$

$\backslash$end$\{$tabular$\}\}\backslash \backslash$

$\backslash$hline & EARNINGS & $\backslash$multicolumn$\{17\}\{|$c$|\}\{$DEDUCTIONS$\}$ & $\backslash$multicolumn$\{2\}\{|$r$|\}\{$NET PAY$\}\backslash \backslash$

$\backslash$hline Name & Gross & OASDI & HI & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$FIT$\}$ & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$SIT$\}$ & SUTA & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$CIT$\}$ & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$SIMPLE Ded.$\}$ & Grp$.$ Ins. & Health Ins. & Ck$.$ No$.$ & Amount $\backslash \backslash$

$\backslash$hline Mangino, R$.$ & $\backslash$$$740\mathrm{.}00$ & $\backslash$$$45\mathrm{.}88$ & $\backslash$$$10\mathrm{.}73$ & $\backslash$$ & $55$ & X & $\backslash$$ & $22\mathrm{.}72$ & $\backslash (\backslash$checkmark $\backslash )$ & & $\backslash$$ & $7\mathrm{.}40$ & $\backslash (\backslash$checkmark $\backslash )$ & $\backslash$$ & $20$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Flores, I. & $1,058\mathrm{.}80$ & $65\mathrm{.}65$ & $15\mathrm{.}35$ & & $88$ & x & & $32\mathrm{.}51$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $10\mathrm{.}59$ & $\backslash (\backslash$checkmark $\backslash )$ & & $50$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Palmetto, C$.$ & $685\mathrm{.}30$ & $42\mathrm{.}49$ & $9\mathrm{.}94$ & & $17$ & x & & $21\mathrm{.}04$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $6\mathrm{.}85$ & $\backslash (\backslash$checkmark $\backslash )$ & & $40$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Waters, R$.$ & $1,045\mathrm{.}35$ & $64\mathrm{.}81$ & $15\mathrm{.}16$ & & $53$ & X & & $32\mathrm{.}09$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $10\mathrm{.}45$ & $\backslash (\backslash$checkmark $\backslash )$ & & $60$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline $......-$ & nmennl$|$ & ment & and & I & & $\backslash ($ v $\backslash )$ & I & $30$ & $,$ & & & n n & & & an & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$ Payroll Register

Click nete to access the wage$-$diacket iremiun ladies.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline & & & & & & & & $\backslash$begin$\{$tabular$\}\{$l$\}$

OLN $\backslash \backslash$

Emplo $\backslash \backslash$

or Period

$\backslash$end$\{$tabular$\}$ & & $\backslash$begin$\{$tabular$\}\{$l$\}$

OMPAN $\backslash \backslash$

Payroll $\backslash \backslash$

ling Jan

$\backslash$end$\{$tabular$\}$ & $\backslash [$

$\backslash$begin$\{$array$\}\{$l$\}$

Y$,\backslash$mathbf$\{$I$\}\backslash \backslash$

$\backslash$operatorname$\{$Res$\}$

$\backslash$end$\{$array$\}$

$\backslash ]$ & & & & & & & & & $\backslash \backslash$

$\backslash$hline & EARNINGS & & & & & & & & & DEDUCT & ION & & & & & & & & NET & PAY $\backslash \backslash$

$\backslash$hline Name & Gross & OASDI & HI & & FIT & & & SIT & & SUTA & & IT & & & SIMPLE Ded. & & Grp$.$ Ins. & Health Ins. & Ck$.$ No$.$ & Amount $\backslash \backslash$

$\backslash$hline Mangino, R$.$ & $\backslash$$$740\mathrm{.}00$ & $\backslash$$$45\mathrm{.}88$ & $\backslash$$$10\mathrm{.}73$ & $\backslash$$ & $55$ & x & $\backslash$$ & $22\mathrm{.}72$ & $\backslash (\backslash$checkmark $\backslash )$ & & $\backslash$$ & $7\mathrm{.}40$ & $\backslash (\backslash$checkmark $\backslash )$ & $\backslash$$ & $20$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Flores, I. & $1,058\mathrm{.}80$ & $65\mathrm{.}65$ & $15\mathrm{.}35$ & & $88$ & X & & $32\mathrm{.}51$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $10\mathrm{.}59$ & $\backslash (\backslash$checkmark $\backslash )$ & & $50$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Palmetto, C$.$ & $685\mathrm{.}30$ & $42\mathrm{.}49$ & $9\mathrm{.}94$ & & $17$ & x & & $21\mathrm{.}04$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $6\mathrm{.}85$ & $\backslash (\backslash$checkmark $\backslash )$ & & $40$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Waters, R$.$ & $1,045\mathrm{.}35$ & $64\mathrm{.}81$ & $15\mathrm{.}16$ & & $53$ & X & & $32\mathrm{.}09$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $10\mathrm{.}45$ & $\backslash (\backslash$checkmark $\backslash )$ & & $60$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Kroll, C$.$ & $952\mathrm{.}00$ & $59\mathrm{.}02$ & $13\mathrm{.}80$ & & $80$ & x & & $29\mathrm{.}23$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $9\mathrm{.}52$ & $\backslash (\backslash$checkmark $\backslash )$ & & $20$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Ruppert, C$.$ & $837\mathrm{.}50$ & $51\mathrm{.}93$ & $12\mathrm{.}14$ & & $32$ & x & & $25\mathrm{.}71$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $8\mathrm{.}38$ & $\backslash (\backslash$checkmark $\backslash )$ & & $40$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Scott, W$.$ & $780\mathrm{.}00$ & $48\mathrm{.}36$ & $11\mathrm{.}31$ & & $26$ & X & & $23\mathrm{.}95$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $7\mathrm{.}80$ & $\backslash (\backslash$checkmark $\backslash )$ & & $50$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Wickman, S$.$ & $807\mathrm{.}69$ & $50\mathrm{.}08$ & $11\mathrm{.}71$ & & $58$ & x & & $24\mathrm{.}80$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $8\mathrm{.}08$ & $\backslash (\backslash$checkmark $\backslash )$ & & $50$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Foley, L$.$ & $1,233\mathrm{.}16$ & $76\mathrm{.}46$ & $17\mathrm{.}88$ & & $80$ & X & & $37\mathrm{.}86$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $12\mathrm{.}33$ & $\backslash (\backslash$checkmark $\backslash )$ & & $30$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline Olney, M$.$ & $1,500\mathrm{.}00$ & $93\mathrm{.}00$ & $21\mathrm{.}75$ & & $106$ & X & & $46\mathrm{.}05$ & $\backslash (\backslash$checkmark $\backslash )$ & & & $15$ & $\backslash (\backslash$checkmark $\backslash )$ & & $80$ & $\backslash (\backslash$checkmark $\backslash )$ & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{2\}\{|$l$|\}\{$Totals$\}$ & $\backslash$$$597\mathrm{.}68$ & $\backslash$$$139\mathrm{.}77$ & $\backslash$$ & $595\mathrm{.}00$ & X & $\backslash$$ & $295\mathrm{.}96$ & $\backslash (\backslash$checkmark $\backslash )$ & & $\backslash$$ & $96\mathrm{.}40$ & $\backslash (\backslash$checkmark $\backslash )$ & $\backslash$$ & $440\mathrm{.}00$