Question

In: Accounting

How do I calcuate the FIT for this question? My calculations are wrong.................. Assume during the...

How do I calcuate the FIT for this question? My calculations are wrong..................

Assume during the quarter ending December 31 of the current year, Cox Security Systems had 13 weekly paydays and three monthly paydays. The names of the employees of Cox Security Systems and their regular salaries are shown in the following payroll register. Note that Hall and Short are paid monthly on the last payday, while all others are paid weekly.


Employee Name
Marital
Status
No. of W/H
Allowances
Regular
Earnings
Hall, Michael M 4 $5,000*   
Short, Joy T. S 1 2,750*   
Abbott, Linda S 2 520     
Smith, Joseph S 0 465     
Tols, Sean M. S 3 380     
Gillespie, Michelle S 3 350     
Smart, Jennifer S 4 575     
White, Matthew J. S 4 425     

*Monthly

In addition to the regular salaries, the company pays an annual bonus based on the amount of earnings for the year. For the current year, the bonus amounts to 8% of the annual salary paid to each employee. The bonus is to be paid along with the regular salaries on December 28, but the amount of the bonus and the amount of the regular salary will be shown separately on each employee's earnings statement. Assume that all employees received their regular salary during the entire year.

The payroll register for the period ending December 28th is shown reflecting the following for each employee:

The wage-bracket method is used to withhold federal income tax from the regular salaries.

A flat 25% is withheld on the annual bonus.

Total salaries and bonuses are subject to a 2% state income tax and a 1% city income tax.

For Period Ending December 28, 20--




Employee Name
No. of Earnings Deductions
Marital W/H (a) (b) (c) FICA (d) (e) (f) (g)
Status Allowances Regular Supp'l. Total OASDI HI FIT SIT CIT Net Pay
Hall, Michael M 4 $5,000.00* $4,800.00 $9,800.00 $607.60 $142.10 $1,565.00 $196.00 $98.00 $7,191.30
Short, Joy T. S 1 2,750.00* 2,640.00 5,390.00 334.18 78.16 953.00 107.80 53.90 3,862.96
Abbott, Linda S 2 520.00 2,163.20 2,683.20 166.36 38.91 580.80 53.66 26.83 1,816.64
Smith, Joseph S 0 465.00 1,934.40 2,399.40 148.76 34.79 537.60 47.99 23.99 1,606.27
Tols, Sean M. S 3 380.00 1,580.80 1,960.80 121.57 28.43 406.20 39.22 19.61 1,345.77
Gillespie, Michelle S 3 350.00 1,456.00 1,806.00 111.97 26.19 372.00 36.12 18.06 1,241.66
Smart, Jennifer S 4 575.00 2,392.00 2,967.00 183.95 43.02 622.00 59.34 29.67 2,029.02
White, Matthew J. S 4 425.00 1,768.00 2,193.00 135.97 31.80 449.00 43.86 21.93 1,510.44
    Totals $10,465.00 $18,734.40 $29,199.40 $1,810.36 $423.40 $5,485.60 $583.99 $291.99 $20,604.06

Complete the following form to show:

a. Total earnings paid during the quarter, including both the regular and the supplemental earnings.

b. Total amount of FICA taxes withheld during the quarter.

c. Total amount of federal income taxes withheld during the quarter.

d. Total amount of state income taxes withheld during the quarter.

e. Total amount of city income taxes withheld during the quarter.

f. Total net amount paid each employee during the quarter.

When computing withholding, round each amount to the nearest cent. If applicable, use rounded amount in subsequent computations. And use final rounded amount to determine the total.

My answers:



Solutions

Expert Solution

EARNINGS DEDUCTIONS
( a) ( b ) ( C ) FICA ( d ) ( e ) ( f ) ( g )
EMPLOYEE NAME MARITAL STATUS NO. OF W/H ALLOW. REGULAR SUPP'L. TOTAL OASDI HI FIT SIT CIT NET PAY
Hall, Michael M 4 $5,000.00 $4,800.00 $9,800.00 $607.60 $142.10 $449.25 $196.00 $98.00 $8,307.05
Short, Joy T. S 1 $2,750.00 $2,640.00 $5,390.00 $334.18 $78.16 $855.11 $107.80 $53.90 $3,960.86
Abbott, Linda S 2 $520.00 $2,163.20 $2,683.20 $166.36 $38.91 $745.77 $53.66 $26.83 $1,651.67
Smith, Joseph S 0 $465.00 $1,934.40 $2,399.40 $148.76 $34.79 $537.65 $47.99 $23.99 $1,606.22
Tols, Sean M. S 3 $380.00 $1,580.80 $1,960.80 $121.57 $28.43 $471.45 $39.22 $19.61 $1,280.52
Gillespie, Michelle S 3 $350.00 $1,456.00 $1,806.00 $111.97 $26.19 $435.95 $36.12 $18.06 $1,177.71
Smart, Jennifer S 4 $575.00 $2,392.00 $2,967.00 $183.95 $43.02 $715.39 $59.34 $29.67 $1,935.62
White, Matthew J. S 4 $425.00 $1,768.00 $2,193.00 $135.97 $31.80 $536.89 $43.86 $21.93 $1,422.56
   Totals $10,465.00 $18,734.40 $29,199.40 $1,810.36 $423.39 $4,747.46 $583.99 $291.99 $21,342.21
a. Total earnings paid during the quarter, including both the regular and the supplemental earnings. $29,199.40
b. Total amount of FICA taxes withheld during the quarter. $2,233.75
c. Total amount of federal income taxes withheld during the quarter. $4,747.46
d. Total amount of state income taxes withheld during the quarter. $583.99
e. Total amount of city income taxes withheld during the quarter. $291.99
f. Total net amount paid each employee during the quarter. $21,342.21
(M) monthly pay.
Hall, Michael (Monthly)
Regular wage 5000
Withholding Married = 4 x $337.50 -1350
Taxable Income 3650
Tax = $155.50 + 25%x (3312.5- 2275) 449.25
Add: 25 % x 4800 Bonus 1200
FIT 2330.425
Short (Monthly)
Regular wage 2750
Withholding single = 1x $77.90 -77.9
Taxable Income 2672.1
Tax = 0% + 10% x (2075 - 721) 195.11
Add: 25 % x 2640 Bonus 660
FIT 855.11
Abbott (weekly)
Regular wage 520
Withholding single = 2x $77.90 155.8
Taxable Income 675.8
Tax = $18 + 15%x (597.9-224) 85.77
Add: 25 % x 2640 Bonus 660
FIT 745.77
Smith
Regular wage 465
Withholding single =0x $77.90 0
Taxable Income 465 224
Tax = $18 + 15%x (465-224) 54.15
Add: 25 % x 1934 Bonus 483.5
FIT 537.65
Tols
Regular wage 380
Withholding single =3x $77.90 233.7
Taxable Income 613.7
Tax = $18 + 15%x (613.7-224) 76.45
Add: 25 % x 1580 Bonus 395
FIT 471.45
Gillespie
Regular wage 350
Withholding single =3x $77.90 233.7
Taxable Income 583.7
Tax = $18 + 15%x (583.7-224) 71.95
Add: 25 % x 1456 Bonus 364
FIT 435.95
Smart
Regular wage 575
Withholding single =4x $77.90 311.6
Taxable Income 886.6
Tax = $18 + 15%x (886.6-224) 117.39
Add: 25 % x 2392 Bonus 598
FIT 715.39
White
Regular wage 425
Withholding single =4x $77.90 311.6
Taxable Income 736.6
Tax = $18 + 15%x (736.6-224) 94.89
Add: 25 % x 1768 Bonus 442
FIT 536.89

Related Solutions

I do not know why I keep getting this question wrong, I triple checked my work!...
I do not know why I keep getting this question wrong, I triple checked my work! A distribution of values is normal with a mean of 80 and a standard deviation of 18. From this distribution, you are drawing samples of size 23. Find the interval containing the middle-most 40% of sample means: ANSWER HERE Enter your answer using interval notation. In this context, either inclusive or exclusive intervals would be acceptable. Your numbers should be accurate to 1 decimal...
She looked at my calculations and said they were wrong, so only the calculations need to...
She looked at my calculations and said they were wrong, so only the calculations need to be redone. So, you'd look at the Apple pdf.'s, and compare the numbers to my Apple calculations page, and recalculate. Be sure to keep the old answers there, and show recalculations in red For your second project, you will print the Income Statement and Balance Sheet of a real corporation and calculate ratios using financial items from them. Instructions: Print off the income statement...
The Table in my homework question below is completely wrong. I am not sure where I...
The Table in my homework question below is completely wrong. I am not sure where I went wrong in my calculations but coud you rework this question and answer the parts below?? Here are earnings per share for two companies by quarter from the first quarter of 2009 through the second quarter of 2012. Forecast earnings per share for the rest of 2012 and 2013. Use exponential smoothing to forecast the third period of 2012, and the time series decomposition...
hi i do not know what is wrong with my python code. this is the class:...
hi i do not know what is wrong with my python code. this is the class: class Cuboid: def __init__(self, width, length, height, colour): self.__width = width self.__length = length self.__height = height self.__colour = colour self.surface_area = (2 * (width * length) + 2 * (width * height) + 2 * (length * height)) self.volume = height * length * width def get_width(self): return self.__width def get_length(self): return self.__length def get_height(self): return self.__height def get_colour(self): return self.__colour def set_width(self,...
How do I calcuate GDP when Exports and Imports are missing? Components of GDP on the...
How do I calcuate GDP when Exports and Imports are missing? Components of GDP on the Demand If total GDP for this economy is $18.10 trillion for the year shown in the table below, what was the country's trade balance? Round your answer to the nearest hundredth if necessary. Consumption 12.13 Investment 2.82 Government spending 3.15 Exports ? Imports ? Total GDP 18.10
I DO NOT have a specific question, my question here is GENERAL HOW TO DETERMINE IF...
I DO NOT have a specific question, my question here is GENERAL HOW TO DETERMINE IF A COMPOUND IS POLAR OR NONPOLAR? I know how to figure about the number of valence electrons and I KNOW how to draw lewis structure, but then I just mess every thing up. I want to know how to determine if it's polar or not. for example: sicl2f2, co2, xef2, xeo4 ... I KNOW how to draw the lewis structure, but this I CANNOT...
Python I want to name my hero and my alien in my code how do I...
Python I want to name my hero and my alien in my code how do I do that: Keep in mind I don't want to change my code except to give the hero and alien a name import random class Hero:     def __init__(self,ammo,health):         self.ammo=ammo         self.health=health     def blast(self):         print("The Hero blasts an Alien!")         if self.ammo>0:             self.ammo-=1             return True         else:             print("Oh no! Hero is out of ammo.")             return False     def...
I really do not understand how to explain aggregate willingness to pay. This question on my...
I really do not understand how to explain aggregate willingness to pay. This question on my homework is throwing me through a loop. Suppose you want to determine the aggregate willingness to pay among students at your school or employees at your employer for increasing recycling at the school or workplace. How might you do this? Can someone explain aggregate willingness to pay Then how to relate this back to the homework questions.
Hello, I need to do a research and I choose my research question: Do the commercialization...
Hello, I need to do a research and I choose my research question: Do the commercialization and use of civilian drones respect our individual freedoms and privacy? Can you help me with ideas of Research Methodology including: 1. Restatement of research tasks: hypothesis or research questions; 2. Study population and sampling: description of study areas (where? why?), populations and the procedures for the sample selection; 3. Data collection: description of the tools (i.e. the survey instrument) and methods used (i.e....
how to do the tf-idf vectorization in python ? how do we fit the model? i...
how to do the tf-idf vectorization in python ? how do we fit the model? i am trying like this but i am getting confused please explain with complete program vectorizer = Tfidvectorizer() x=vectorizer.fit_transofrm() // what data should be passed here ? do we split it in tokens ?? do we use vocabulary?? do we use s.split() ?? x.toarray() ? == pleae provide complete program with output because i am not understanding
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT