Description
I need this excel assignment completed by March 13, 2018. I have attached instructions. I attached the excel sheet to be completed. Two attachments total
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
See attached. Please inform me if you need any clarification.
Liberty Bank & Trust
Lynchburg, VA Branch
Payroll Data for Week of Jan 1-7
No. of
Name
Dependents
Cortez, Mark
2
Higgins, Judy
1
Howard, Francis
3
Lindsey, Lamar
1
Manning, Joe
1
Meyer, Delores
1
Pittman, Oliver
3
Schultz, Leslie
2
Spencer, Kelly
3
Vasquez, Cassandra
2
Watson, Rosemary
1
Williams, Lynne
2
Totals
22
Hours
Worked
48
48
50
36
40
20
40
44
38
45
28
41
478
Taxable Pay
(weekly)
Assumptions
Base Work Hours
Overtime rate
FICA rate
Deduct per Depend $
Weeks per year
Hourly
Wage
12.95
16.6
26.37
13.02
18.5
11.89
22.08
26.38
13.01
19.56
14.85
20.62
215.83
40
1.5
6.20%
50.00
52
$0
$179
$730
$1,767
$8,013
Regular
Overtime
Pay
Pay
518
155.4
664
199.2
1054.8
395.55
468.72
0
740
0
237.8
0
883.2
0
1055.2
158.28
494.38
0
782.4
146.7
415.8
0
824.8
30.93
8139.1
1086.06
Gross Pay Taxable Pay
673.4
573.4
863.2
813.2
1450.35
1300.35
468.72
418.72
740
690
237.8
187.8
883.2
733.2
1213.48
1113.48
494.38
344.38
929.1
829.1
415.8
365.8
855.73
755.73
9225.16
8125.16
FICA
41.7508
53.5184
89.9217
29.06064
45.88
14.7436
54.7584
75.23576
30.65156
57.6042
25.7796
53.05526
571.95992
Net Pay
545.6392
606.3816
1035.3408
376.85136
590.62
194.8864
645.1416
859.87424
412.07144
664.2208
335.1504
613.74224
6879.92008
Summary Statistics
Tax Rate
10%
15%
25%
28%
33%
Federal
Withholding
Tax
86.01
203.3
325.0875
62.808
103.5
28.17
183.3
278.37
51.657
207.275
54.87
188.9325
1773.28
Average
Highest
Lowest
# of Hours
Net Pay
Gross Pay (yr)
39.83 $
573.33 $
9,225.16
50 $ 1,03...