Question

In: Accounting

Our Toy Store has 3 employees. Below are their names, their pay rate and whether or...

Our Toy Store has 3 employees. Below are their names, their pay rate and whether or not they participate in the savings plan. Please complete a payroll register for the last half of December. Begin with a column for gross pay, including a column for each deduction ending with net pay. Each employee can chose whether or not they want to withhold money from their pay to put into a savings plan. If they participate in the savings plan, 2.5% of their gross pay is withheld before taxes. Federal income tax is withheld at 20%, social security tax is 6.2% and Medicare tax is 1.45%. Please round the social security and Medicare to 2 decimal places. Please use an IF command to determine saving participation and FICA taxes. Assume a $100,000 base FICA limit and assume prior earnings for Betty of 99,000.Betty Boss makes $150,000 per year and participates in the saving plan. Carrie Clerk makes $21.85per hour, and worked 86 hours this pay 80 hour pay period and did no savings plan. She gets paid time and a half overtime for hours over 80 hours. Patty Part-timer makes $11.50 per hour, worked 35 hours this pay period and did the savings plan.

Solutions

Expert Solution

Calculation of Wages

SL No.

Name

Rate

Normal Hrs

Overtime Hrs

Basic Wages

Overtime wages

Total Wages

1

Betty Boss (Gross Pay 150000-99000)

-

-

51,000.00

-

$ 51,000.00

2

Carrie Clerk

21.85

80.00

6.00

1,748.00

196.65

$    1,944.65

3

Patty

11.50

35.00

-

402.50

-

$        402.50

Calculation of Gross and Net Pay

SL No.

Name

Gross Salary

Saving Plan [email protected]%

Pay Before Taxes

Fereral Tax @20%( Charged on Gross Pay)

Security Tax @6.2 % ( Charged on Gross Pay

Medicare Tax @1.45% (Charged on Gross Pay)

Total of (Saving+All Taxes)

Net Pay = Gross Pay - Dedections)

1

Betty Boss

$     51,000.00

$           1,275.00

$     49,725.00

$   10,200.00

$                    3,162.00

$           739.50

$               15,376.50

$    35,623.50

2

Carrie Clerk

$        1,944.65

Not Opted

$        1,944.65

$         388.93

$                        120.57

$             28.20

$                     537.70

$      1,406.95

3

Patty

$           402.50

$                 10.06

$           392.44

$           80.50

$                          24.96

$               5.84

$                     121.35

$          281.15

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Pink Corporation has several employees. Their names and salaries are listed below: Judy $470,000 Holly (Judy's...
Pink Corporation has several employees. Their names and salaries are listed below: Judy $470,000 Holly (Judy's daughter) 100,000 Terry (Judy's son) 100,000 Amman (an unrelated third party) 320,000 Holly and Terry are the only shareholders of Pink. Judy and Amman share equally in the management of the company's operations. Holly and Terry are both full-time college students at a university 200 miles away. Pink has substantial E & P and never has distributed a dividend. What are any income tax...
It is only July and we have run short of funds to pay our employees for...
It is only July and we have run short of funds to pay our employees for the remainder of this year. As a result, we need to seek creative ways to help the company weather the storm... get through this problem. However, after conducting a series of brainstorming sessions, we are really no further ahead than we were before, so we have decided to hire an outside consulting firm, i.e. YOU, to help us decide upon the best option to...
Toys is a large discount toy store in Valley Wood Mall. The store typically has slow...
Toys is a large discount toy store in Valley Wood Mall. The store typically has slow sales in the summer months that increase dramatically and rise to a peak at Christmas. During the summer and fall, the store must build up its inventory to have enough stock for the Christmas season. To purchase and build up its stock during the months when its revenues are low, the store borrows money. Following is the store’s projected revenue and liabilities schedule for...
The Good’n’Fresh Grocery Store has two checkout lanes and four employees. Employees are equally skilled, and...
The Good’n’Fresh Grocery Store has two checkout lanes and four employees. Employees are equally skilled, and all are able to either operate a register (checkers) or bag groceries (baggers). The store owner assigns one checker and one bagger to each lane. A lane with a checker and a bagger can check out 46 customers per hour. A lane with a checker only can check out 25 customers per hour. a. In terms of customers checked out per hour, what are...
A toy store has beginning inventory of 20 plastic bouncy balls at a cost of $1.05...
A toy store has beginning inventory of 20 plastic bouncy balls at a cost of $1.05 each. During the year the toy store purchased 2 at $1.40; 4 at $2.00; 6 at $3.00; and 20 at $4.00. By the end of the year, 25 balls were sold. Calculate the following: the number of plastic bouncy balls in stock at the end of the year, the cost of ending inventory under LIFO, the cost of ending inventory under FIFO, and the...
A toy store has beginning inventory of 20 plastic bouncy balls at a cost of $1.05...
A toy store has beginning inventory of 20 plastic bouncy balls at a cost of $1.05 each. During the year the toy store purchased 2 at $1.40; 4 at $2.00; 6 at $3.00; and 20 at $4.00. By the end of the year, 25 balls were sold. Calculate the following: the number of plastic bouncy balls in stock at the end of the year, the cost of ending inventory under LIFO, the cost of ending inventory under FIFO, and the...
A toy store has beginning inventory of 20 plastic bouncy balls at a cost of $1.05...
A toy store has beginning inventory of 20 plastic bouncy balls at a cost of $1.05 each. During the year the toy store purchased 2 at $1.40; 4 at $2.00; 6 at $3.00; and 20 at $4.00. By the end of the year, 25 balls were sold. Calculate the following: the number of plastic bouncy balls in stock at the end of the year, the cost of ending inventory under LIFO, the cost of ending inventory under FIFO, and the...
SHORT ANSWERS CEO pay, in contrast with pay of a company’s employees, has grown exponentially over...
SHORT ANSWERS CEO pay, in contrast with pay of a company’s employees, has grown exponentially over the last several decades in the United States. Compare and contrast the two points of view below: a. Because there exists an agency problem between CEOs, the board of directors, and shareholders, the growing pay gap is reflective of and failure of capitalism and free markets. b. In a globalized world, where scale and scope have created massive companies unseen before the 1990s, the...
Employees earn vacation pay at the rate of one day per month. During the month of...
Employees earn vacation pay at the rate of one day per month. During the month of June, 10 employees qualify for one vacation day each. Their average daily wage is $150 per day. Which of the following is the necessary adjusting journal entry to record the June vacation benefits?
Calculate gross pay for each of the following employees. All are paid an overtime wage rate...
Calculate gross pay for each of the following employees. All are paid an overtime wage rate that is 1.5 times their respective regular wage rates. NOTE: For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation. 1:Anita Workman receives tips from customers as a standard component of her weekly pay. She is paid $2.60/hour by her employer and receives $291 in tips during the most recent 44-hour workweek. Gross...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT