question of excel

profilelilaye
unit_9_data_file_1.xlsx
Home>Business & Finance homework help>Accounting homework help>question of excel

Payroll

Hackers Payroll Project
Date Prepared:
Emp. Num. Name Address City St. Zip Telephone Mar. Stat. Dep. Rate Hours Gross Pay Fed Tax Rate Fed Tax MS Fed Tax Dep. Fed. Tax State Tax Rate State Tax MS State Tax Dep. State Tax FICA Misc. Ded. Dues Ded Net Pay Check Numb.
J214 Barnes, N. 123 Lotus St. Carmel In. 46032 (602)123-4567 S 1 6.51 40 2.94 10 101
G852 Bates, H. 21 Smith St. Dartmouth Ma. 12354 (206)765-4321 S 1 7.5 40 3 0 102
A136 Bunny, B. 99 Carrot Way Bunnytown Ca. 97532 (123)675-1234 S 0 6.93 40 2.79 10 103
A149 Bush, G. 1 Main St. Kennybunk Wa. 87653 (402)111-1112 M 3 6.62 40 0 0 104
L781 Carter, J. 23 Peanut Way Stevens Fl. 97234 (215)222-2221 M 3 6.96 42 0 10 105
T154 Duck, D. 90 Oliver St. Smithville Ky. 56472 (345)661-1234 S 3 6.65 40 2.56 10 106
P874 Flintstone, F. 13 Ann Ave. New York Wi. 85347 (804)751-3680 M 3 6.76 41 0 10 107
T132 Hogan, H. 5 Muscle Way Seattle R.I. 64587 (508)998-9500 S 0 6.48 38 0 0 108
M124 Jetson, G. 33 Third St. Springfield Ma. 55545 (617)222-7612 M 4 7.4 42 2.48 10 109
N235 Man, M. 99 Nine St. Boston N.D. 46563 (843)176-6413 M 2 7.4 44 2.74 10 110
H452 Mouse, M. 44 Going My Way Providence Mi. 55460 (418)214-1487 M 3 7.15 40 2.86 10 111
G548 Mouse, S. 66 Sunset Strip Blue Grass Ok. 46032 (843)176-6413 S 0 7.05 37 0 10 112
A634 Nixon, R. 29 Hazel Pk. Hillside Oh. 46587 (823)111-1104 M 2 7.19 40 2.84 10 113
L111 Pig, P. 95 Oean Way Kansas N.Y. 85472 (819)602-4511 S 0 7 43 2.5 0 114
P342 Rabbit, R. 45 Oregon St. Smithville Ca. 12547 (349)-121-1213 M 1 7.55 41 2.82 10 115

LookupTables

TAX WITHHOLDING TABLE MARITAL STATUS hidden bob DEP. STATUS Master
Gross Fed. State S/M Ded. # Dep. Ded.
200 40 20 S 0 0 0
210 42 21 M 0.5 1 0.01
220 44 22 2 0.02
230 46 23 3 0.03
240 48 24 4 0.04
250 50 25 5 0.05
260 52 26
270 54 27
280 56 28
290 58 29
300 60 30
310 62 31
320 64 32
330 66 33
340 68 34
350 70 35
360 72 36
370 74 37
380 76 38
390 78 39
400 80 40
410 82 41
420 84 42
430 86 43
440 88 44
450 90 45
460 92 46
470 94 47
480 96 48
490 98 49
500 100 50

Marital Stats

Stats by Marital Status Master
Marital Status Total Average Count
S
M

Module1