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$\}$ Completing the Payroll Register

The Employee Payroll Register presents all the computations previously performed as it applies to this payroll period.

Complete the following steps:

$1.$ Record the amount to be withheld for group insurance.

$2.$ Record the amount to be withheld for health insurance.

$3.$ Each worker is to be paid by check. Assign check numbers provided to the correct employee.

$4.$ Compute the net pay for each employee.

$5.$ Total the input columns.

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

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

OLNEY COMPANY, INC. $\backslash \backslash$

Payroll Register $\backslash \backslash$

For Period Ending January $8,20--$

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

$\backslash$hline & EARNINGS & $\backslash$multicolumn$\{13\}\{|$c$|\}\{$DEDUCTIONS$\}$ & $\backslash$multicolumn$\{5\}\{|$c$|\}\{$NET PAY$\}\backslash \backslash$

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

$\backslash$hline Mangino, R$.$ & $\backslash$$$740\mathrm{.}00$ & $\backslash$$$45\mathrm{.}88$ & $\backslash$$$10\mathrm{.}73$ & $\backslash$$$50\mathrm{.}00$ & $\backslash$$$22\mathrm{.}72$ & $\backslash$$$0\mathrm{.}52$ & $\backslash$$$7\mathrm{.}40$ & $\backslash$$$20\mathrm{.}00$ & $\backslash$$ & $0\mathrm{.}85$ & $\backslash (\backslash$checkmark $\backslash )$ & $\backslash$$ & $1\mathrm{.}65$ & $\backslash (\backslash$checkmark $\backslash )$ & $313$ & $\backslash (\backslash$checkmark $\backslash )$ & $\backslash$$ & $575\mathrm{.}33$ & x $\backslash \backslash$

$\backslash$hline Flores, I. & $1,058\mathrm{.}80$ & $65\mathrm{.}65$ & $15\mathrm{.}35$ & $85\mathrm{.}00$ & $32\mathrm{.}51$ & $0\mathrm{.}74$ & $10\mathrm{.}59$ & $50\mathrm{.}00$ & & $0\mathrm{.}85$ & $\backslash (\backslash$checkmark $\backslash )$ & & $1\mathrm{.}65$ & $\backslash (\backslash$checkmark $\backslash )$ & $314$ & $\backslash (\backslash$checkmark $\backslash )$ & & $793\mathrm{.}56$ & x $\backslash \backslash$

$\backslash$hline Palmetto, C$.$ & $685\mathrm{.}30$ & $42\mathrm{.}49$ & $9\mathrm{.}94$ & $12\mathrm{.}00$ & $21\mathrm{.}04$ & $0\mathrm{.}48$ & $6\mathrm{.}85$ & $40\mathrm{.}00$ & & $0$ & $\backslash (\backslash$checkmark $\backslash )$ & & $1\mathrm{.}65$ & $\backslash (\backslash$checkmark $\backslash )$ & $315$ & $\backslash (\backslash$checkmark $\backslash )$ & & $545\mathrm{.}92$ & x $\backslash \backslash$

$\backslash$hline Waters, R$.$ & $1,045\mathrm{.}35$ & $64\mathrm{.}81$ & $15\mathrm{.}16$ & $46\mathrm{.}00$ & $32\mathrm{.}09$ & $0\mathrm{.}73$ & $10\mathrm{.}45$ & $60\mathrm{.}00$ & & $0\mathrm{.}85$ & $\backslash (\backslash$checkmark $\backslash )$ & & $1\mathrm{.}65$ & $\backslash (\backslash$checkmark $\backslash )$ & $316$ & $\backslash (\backslash$checkmark $\backslash )$ & & $806\mathrm{.}71$ & x $\backslash \backslash$

$\backslash$hline Kroll, C$.$ & $952\mathrm{.}00$ & $59\mathrm{.}02$ & $13\mathrm{.}80$ & $75\mathrm{.}00$ & $29\mathrm{.}23$ & $0\mathrm{.}67$ & $9\mathrm{.}52$ & $20\mathrm{.}00$ & & $0\mathrm{.}85$ & $\backslash (\backslash$checkmark $\backslash )$ & & $1\mathrm{.}65$ & $\backslash (\backslash$checkmark $\backslash )$ & $317$ & $\backslash (\backslash$checkmark $\backslash )$ & & $737\mathrm{.}36$ & x $\backslash \backslash$

$\backslash$hline Ruppert, C$.$ & $837\mathrm{.}50$ & $51\mathrm{.}93$ & $12\mathrm{.}14$ & $27\mathrm{.}00$ & $25\mathrm{.}71$ & $0\mathrm{.}59$ & $8\mathrm{.}38$ & $40\mathrm{.}00$ & & $0\mathrm{.}85$ & $\backslash (\backslash$checkmark $\backslash )$ & & $1\mathrm{.}65$ & $\backslash (\backslash$checkmark $\backslash )$ & $318$ & $\backslash (\backslash$checkmark $\backslash )$ & & $664\mathrm{.}34$ & X $\backslash \backslash$

$\backslash$hline

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

Feedback Employee Benefits