Question

In: Accounting

The monthly and hourly wage schedule for the employees of Quirk, Inc., follows. No employees are...

The monthly and hourly wage schedule for the employees of Quirk, Inc., follows. No employees are due overtime pay. Round your answer to nearest cent. Compute the following for the last monthly pay of the year:

a. The total wages of each part-time employee for December 2018.
b. The OASDI and HI taxable wages for each employee.
c. The FICA taxes withheld from each employee's wages for December.
d. Totals of columns. (Totals should include both full-time and part-time employees.)
e. The employer's FICA taxes for the month.

Employees Total Monthly
Payroll
OASDI Taxable
Wages
OASDI
Tax
HI Taxable
Wages
HI Tax
Full-Time Office:
      Adaiar, Gene $1,380.00           $ $ $ $
      Crup, Jason 1,290.00           
      Essex, Joan 1,805.00           
      Garza, Irma 1,905.00           
      Leason, Mel 1,810.00           
      Pruit, Marne 7,110.00           
      Rubble, Deanne 2,455.00           
      Simpson, Dylan 3,885.00           
      Truap, Ann 5,080.00           
      Wilson, Trudy 1,510.00           


Hours
Worked
Hourly
Rate
Total
Monthly
OASDI Taxable
Wages
OASDI
Tax
HI Taxable
Wages
HI Tax
Part-Time Office:
    Kyle, Judy 119 $8.35     $ $ $ $ $
    Laird, Sharon 115 8.25    
    Maxwell, Sara 88 10.25    
    Nelson, Donna 94 8.00    
    Scott, Kim 107 9.65    
    Totals (all employees) $ $ $ $ $
OASDI HI
Employer's FICA taxes $ $

Solutions

Expert Solution

Employees Total Monthly OASDI Taxable Earnings OASDI Tax HI Taxable Earnings HI Tax
      Adaiar, Gene $              1,380 $                1,380 $              86 $        1,380 $          20
      Crup, Jason $              1,290 $                1,290 $              80 $        1,290 $          19
      Essex, Joan $              1,805 $                1,805 $           112 $        1,805 $          26
      Garza, Irma $              1,905 $                1,905 $           118 $        1,905 $          28
      Leason, Mel $              1,810 $                1,810 $           112 $        1,810 $          26
      Pruit, Marne $              7,110 $                7,110 $           441 $        7,110 $        103
      Rubble, Deanne $              2,455 $                2,455 $           152 $        2,455 $          36
      Simpson, Dylan $              3,885 $                3,885 $           241 $        3,885 $          56
      Truap, Ann $              5,080 $                5,080 $           315 $        5,080 $          74
      Wilson, Trudy $              1,510 $                1,510 $              94 $        1,510 $          22
Hours Hourly Rate Total Monthly OASDI Taxable Earnings OASDI Tax HI Taxable Earnings HI Tax
    Kyle, Judy 119 $                 8.35 $                   994 $                   994 $              62 $           994 $          14
    Laird, Sharon 115 $                 8.25 $                   949 $                   949 $              59 $           949 $          14
    Maxwell, Sara 88 $              10.25 $                   902 $                   902 $              56 $           902 $          13
    Nelson, Donna 94 $                 8.00 $                   752 $                   752 $              47 $           752 $          11
    Scott, Kim 107 $                 9.65 $                1,033 $                1,033 $              64 $        1,033 $          15
    Totals (all employees) $             32,859 $             32,859 $        2,037 $     32,859 $        476
OASDI HI
Employer's FICA taxes $ 2,037 $                  476

FICA OSDI Tax Rate is 6.2%

FICA HI Tax Rate is 1.45%


Dear Student,

Best effort has been made to give quality and correct answer. But if you find any issues please comment your concern. I will definitely resolve your query.


Related Solutions

The file Assign1_Data contains data on the hourly wages (Hourly Wage) of all employees of a...
The file Assign1_Data contains data on the hourly wages (Hourly Wage) of all employees of a grocery chain in the Ottawa region. (a) Treating this set of data as the population, use Minitab to calculate the population mean and the population standard deviation for the Hourly Wage variable. (b) Examine a boxplot and histogram of the population data. Explain if the means of all possible random samples of size 40 from this population would form a normal distribution. (c) Using...
A company is trying to decide to pay employees a fixed salary or an hourly wage....
A company is trying to decide to pay employees a fixed salary or an hourly wage. If the company decides to pay salaries, which statement is true? (2pts) Paying salaries would have no affect on fixed costs or the contribution margin. Salaries decrease the total fixed costs and the contribution margin would be lower. Salaries increase total fixed costs and the contribution margin would be higher. 2) A company is trying to decide to pay employees a fixed salary or...
According to a local business research, the hourly wage of workers in NY state follows a...
According to a local business research, the hourly wage of workers in NY state follows a normal distribution with a standard deviation of $5.00, and a mean $23.00. What is the probability that a randomly selected NY resident has an hourly wage greater than $25.00? What is the probability that the average of 6 randomly selected NY residents is greater than $25.00? What is the probability that all of the 6 people in the randomly selected sample have an hourly...
Suppose the following table was generated from sample data of 20 employees relating hourly wage to...
Suppose the following table was generated from sample data of 20 employees relating hourly wage to years of experience and whether or not they have a college degree. Using statistical software, create an indicator (dummy) variable for the variable "Degree" and find the regression equation. Is there enough evidence to support the claim that on average employees with a college degree have higher hourly wages than those without a college degree at the 0.05 level of significance? If yes, write...
The mean hourly wage for employees in goods-producing industries is currently $24.57 (Bureau of Labour Statistics...
The mean hourly wage for employees in goods-producing industries is currently $24.57 (Bureau of Labour Statistics website, April, 12, 2012). Suppose we take a sample of employees from the manufacturing industry to see if the mean hourly wage differs from the reported mean of $24.57 for the goods-producing industries. a. State the null hypotheses we should use to test whether the population mean hourly wage in the manufacturing industry differs from the population mean hourly wage in the goods-producing industries....
The mean hourly wage for employees in goods-producing industries is currently $24.57 (Bureau of Labor Statistics...
The mean hourly wage for employees in goods-producing industries is currently $24.57 (Bureau of Labor Statistics website, April, 12, 2012). Suppose we take a sample of employees from the manufacturing industry to see if the mean hourly wage differs from the reported mean of $24.57 for the goods-producing industries. a. State the null hypotheses we should use to test whether the population mean hourly wage in the manufacturing industry differs from the population mean hourly wage in the goods-producing industries....
Access the hourly wage data on the below Excel Data File (Hourly Wage). An economist wants...
Access the hourly wage data on the below Excel Data File (Hourly Wage). An economist wants to test if the average hourly wage is less than $28. Assume that the population standard deviation is $8. b-1. Find the value of the test statistic. (Negative value should be indicated by a minus sign. Round intermediate calculations to at least 4 decimal places and final answer to 2 decimal places.) Hourly Wage Education Experience Age Gender 39.00 11 2 40 1 21.02...
After a one-half increase of his current hourly​ wage, a man receives a new hourly wage...
After a one-half increase of his current hourly​ wage, a man receives a new hourly wage of ​$24.02. How much was his hourly wage before the​ increase? The hourly wage before the increase was $ ______. Please explain step by step.
Suppose the following table was generated from sample data of 20 20 employees relating hourly wage...
Suppose the following table was generated from sample data of 20 20 employees relating hourly wage to years of experience and whether or not they have a college degree. Using statistical software, create an indicator (dummy) variable for the variable "Degree" and find the regression equation. Is there enough evidence to support the claim that on average employees with a college degree have higher hourly wages than those without a college degree at the 0.05 0.05 level of significance? If...
A company pays its employees as managers (who receive a fixed weekly salary), hourly workers (who receive a fixed hourly wage for up to the first 40 hours they work and “time- and -a-half “—1.5 times their hourly wage — for overtime hours worked )
USING C++A company pays its employees as managers (who receive a fixed weekly salary), hourly workers (who receive a fixed hourly wage for up to the first 40 hours they work and “time- and -a-half “—1.5 times their hourly wage — for overtime hours worked ), commission workers (who receive $250 plus 5.7 percent of their gross weekly sales), or pieceworkers (who receive a fixed amount of money per item for each of the items they produce). Write a program...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT