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

ekkarill92 answered 1 year ago

Next > < Previous

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

Subjects