Chapter 10, Problem 3PB

1 to 7.

To determine

Prepare payroll register for Company A from the information given.

Explanation of Solution

Payroll: The total payment that a company is required to pay to its employee for the services received is called as payroll.

Payroll withholding deduction: The amounts which the employer withheld from employees’ gross pay to deduct taxes such as federal income tax, state income tax, social security tax, and Medicare tax are called payroll withholding deduction.

Payroll register: A schedule which is maintained by the company to record the earnings, earnings withholdings, and net pay of each employee is referred to as payroll register.

The purpose of payroll register is used to record the following:

• Earnings of each employee.
• Taxes (Social security tax, Medicare tax, and federal income tax) and other withholdings (health insurance, and other) of each employee.
• Net pay of each employee.

Prepare payroll register for Company A as below:

Table (1)

Working notes:

Calculate regular time earnings for Mr. KA.

$\begin{array}{c}\text{Regular time earnings for Mr}\text{. KA = Regular hours worked }\times \text{Hourly wage rate}\\ \text{=40 hours }\times \text{\$10}\text{.50 per hour}\\ =\$420.00\end{array}$

Calculate regular time earnings for Mr. CC.

$\begin{array}{c}\text{Regular time earnings for Mr}\text{. CC = Regular hours worked }\times \text{Hourly wage rate}\\ \text{=36 hours }\times \text{\$10}\text{.25 per hour}\\ =\$369.00\end{array}$

Calculate regular time earnings for Ms. MV.

$\begin{array}{c}\text{Regular time earnings for Ms}\text{. MV = Regular hours worked }\times \text{Hourly wage rate}\\ \text{=40 hours }\times \text{\$29}\text{.75 per hour}\\ =\$1,190.00\end{array}$

Calculate regular time earnings for Ms. HV.

$\begin{array}{c}\text{Regular time earnings for Ms}\text{. HV = Regular hours worked }\times \text{Hourly wage rate}\\ \text{=40 hours }\times \text{\$32}\text{.75 per hour}\\ =\$1,310.00\end{array}$

Calculate overtime earnings for Mr. KA.

$\begin{array}{c}\text{Overtime earnings for Mr}\text{. KA = Overtime hours worked }\times \text{Overtime wage rate}\\ \text{=}\left(\text{43 hours}\text{– 40 hours}\right)\times \left(\$10.50\times 1.5\right)\\ \text{= 3 hours}\times \text{\$15}\text{.75 per hour}\\ \text{= \$47}\text{.25}\end{array}$

Calculate overtime earnings for Ms. MV.

$\begin{array}{c}\text{Overtime earnings for Ms}\text{. MV = Overtime hours worked }\times \text{Overtime wage rate}\\ \text{=}\left(\text{45 hours}\text{– 40 hours}\right)\times \left(\$29.75\times 1.5\right)\\ \text{= 5 hours}\times \text{\$44}\text{.625 per hour}\\ \text{= \$223}\text{.13}\end{array}$

Calculate overtime earnings for Ms. HV.

$\begin{array}{c}\text{Overtime earnings for Ms}\text{. HV = Overtime hours worked }\times \text{Overtime wage rate}\\ \text{=}\left(\text{41 hours}\text{– 40 hours}\right)\times \left(\$32.75\times 1.5\right)\\ \text{= 1 hour}\times \text{\$49}\text{.125 per hour}\\ \text{= \$49}\text{.13}\end{array}$

Calculate social security tax for Mr. KA.

$\begin{array}{c}\text{Social security tax for Mr}\text{. KA = Taxable wages }\times \text{ Social security tax rate}\\ \text{= \$467}\text{.25}\times \text{6}\text{.2\%}\\ \text{=\$28}\text{.97}\end{array}$

Calculate social security tax for Mr. CC.

$\begin{array}{c}\text{Social security tax for Mr}\text{. CC = Taxable wages }\times \text{ Social security tax rate}\\ \text{= \$369}\text{.00}\times \text{6}\text{.2\%}\\ \text{=\$22}\text{.88}\end{array}$

Calculate social security tax for Ms. MV.

$\begin{array}{c}\text{Social security tax for Ms}\text{. MV = Taxable wages }\times \text{ Social security tax rate}\\ \text{= \$1,413}\text{.13}\times \text{6}\text{.2\%}\\ \text{=\$87}\text{.61}\end{array}$

Calculate social security tax for Ms. HV.

$\begin{array}{c}\text{Social security tax for Ms}\text{. HV = Taxable wages }\times \text{ Social security tax rate}\\ \text{= \$1,359}\text{.13}\times \text{6}\text{.2\%}\\ \text{=}\text{\$84}\text{.27}\end{array}$

Calculate Medicare tax for Mr. KA.

$\begin{array}{c}\text{Medicare tax for Mr}\text{. KA = Taxable wages }\times \text{ Medicare tax rate}\\ \text{= \$467}\text{.25}\times \text{1}\text{.45\%}\\ \text{=\$6}\text{.78}\end{array}$

Calculate Medicare tax for Mr. CC.

$\begin{array}{c}\text{Medicare tax for Mr}\text{. CC = Taxable wages }\times \text{ Medicare tax rate}\\ \text{= \$369}\text{.00}\times 1.\text{45\%}\\ \text{=\$5}\text{.35}\end{array}$

Calculate Medicare tax for Ms. MV.

$\begin{array}{c}\text{Medicare tax for Ms}\text{. MV = Taxable wages }\times \text{ Medicare tax rate}\\ \text{= \$1,413}\text{.13}\times 1.\text{45\%}\\ \text{=\$20}\text{.49}\end{array}$

Calculate Medicare tax for Ms. HV.

$\begin{array}{c}\text{Medicare tax for Ms}\text{. HV = Taxable wages }\times \text{ Medicare tax rate}\\ \text{= \$1,359}\text{.13}\times 1.\text{45\%}\\ \text{=}\text{\$19}\text{.71}\end{array}$

Calculate the amount of Federal income tax for Mr. KA.

Mr. KA is married, claims three withholding allowances, and earned weekly salary of $467.25. Hence, by using withholding table (Refer figure 10.2B) his Federal income tax amount would be $13.

Calculate the amount of Federal income tax for Mr. CC.

Mr. CC is single, claims two withholding allowances, and earned weekly salary of $369.00. Hence, by using withholding table (Refer figure 10.2A) his Federal income tax amount would be $22.

Notes:

• Gross earnings are calculated by using the following formula:

$\text{Gross Earnings = Regular}\text{Time Earnings}\text{+}\text{}\text{Overtime}\text{Earnings}$

• Net pay is calculated by using the following formula:

$\text{Net pay = Gross earnings – Social security Tax}–\text{Medicare Tax}–\text{Federal income Tax}$

8.

To determine

Journalize the entry to record the payroll on November 12, 2019.

Explanation of Solution

Journal entry: Journal entry is a set of economic events which can be measured in monetary terms. These are recorded chronologically and systematically.

Debit and credit rules:

• Debit an increase in asset account, increase in expense account, decrease in liability account, and decrease in stockholders’ equity accounts.
• Credit decrease in asset account, increase in revenue account, increase in liability account, and increase in stockholders’ equity accounts.

Prepare general journal entry to record the payroll on November 12, 2019.

General Journal								Page 32
Date			Accounts and Explanation			Post Ref	Debit ($)	Credit ($)
2019			Office Wages Expense				836.25
November		12	Consulting Wages Expense				2,772.26
				Social Security Taxes Payable				223.73
				Medicare Taxes Payable				52.33
				Employees Income Taxes Payable				494.00
				Wages Payable				2,838.45
					(To record wages expense and payroll withholdings)

Table (2)

• Office Wages expense is an expense and it decreases equity value. So, debit it by $836.25.
• Consulting Wages expense is an expense and it decreases equity value. So, debit it by $2,772.26.
• Social security taxes payable is a liability and it is increased. So, credit it by $223.73.
• Medicare taxes payable is a liability and it is increased. So, credit it by $52.33.
• Employee income taxes payable is a liability and it is increased. So, credit it by $494.00.
• Wages payable is a liability and it is increased. So, credit it by $2,838.45.

9.

To determine

Journalize the entry to record the payment of weekly payroll on November 12, 2019.

Explanation of Solution

Prepare general journal entry to record payment of weekly payroll on November 12, 2019.

General Journal							Page 32
Date		Accounts and Explanation			Post Ref	Debit ($)	Credit ($)
2019		Wages Payable				2,838.45
November	12		Cash				2,838.45
				(To record the payment of weekly payroll)

Table (3)

• Wages payable is a liability and it is decreased. So, debit it by $2,838.45.
• Cash is an asset and it is decreased. So, credit it by $2,838.45.

Analyze: The total deductions taken from the employee paychecks on November 12, 2019 is $770.06$\left(\$223.73+\$52.33+\$494.00\right)$.