Spreadsheet: 63554d1264452475-payroll-taxes-missyreiber3
Sheet: COMPENSATION

 |  |  | 1.45% | 6.20% | 0.113 | 0.17 |  |  | MCR | FICA | 0.113 | 0.17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ID Those |  | ID Those | ID Those |  |  |  | Adjusted
 |  | Net |  |  | Net | Net | Total | W-2 | Tax | Tax | MPPP | MPPP | MPPP $ | FICA $ | 11.3% PP | 17% PP | 17% Gross | 11.3% Gross | 1st MCR | 1st FICA | 1st Pension | 1st Pension | 1st W-2 | 2nd MCR | 2nd FICA | 2nd Pension | 2nd Pension | 2nd W-2 | 3rd MCR | 3rd FICA | 3rd Pension | 3rd Pension | 3rd W-2 | 4th MCR | 4th FICA | 4th Pension | 4th Pension | [NAME] | 5th MCR | 5th FICA | 5th Pension | 5th Pension | 5th W-2 | MCR | FICA | Pension | Pension | 6th W-2 | MCR | FICA | Pension | Pension | 7th W-2 | MCR | FICA | Pension | Pension | 8th W-2 | MCR | FICA | Pension | Pension | 9th W-2 | MCR | FICA | Pension | Pension | 10th W-2 | Maxed or | Amt to | Maxing | FICA Maxed | Amt to | MCR | Pension | Pension | 11th W-2 | MCR | Pension | Pension | 12th W-2 | MCR | Pension | Pension | 13th W-2 | MCR | Pension | Pension | 14th W-2 | MCR | Pension | Pension | 15th W-2 | MCR | Pension | Pension | 16th W-2 | MCR | Pension | Pension | 17th W-2 | MCR | Pension | Pension | 18th W-2 | MCR | Pension | Pension | 19th W-2 | MCR | Pension | Pension | 20th W-2 | MCR | Pension | Pension | 21st W-2
name | Pay # | Comp | MCR Tax | FICA Tax | Pension | Pension | W-2 | Check | Check | Check | Check | Check | Left to [NAME] | Left to [NAME] | Left to [NAME] | Left to [NAME] | Estimate | Estimate | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Maxing (   ) | MPPP | This PP | or Maxing | FICA | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess | Guess | 11.3 Guess | 17%  Guess | Guess
SMITH | 107 | 19096.68 | 210.3131710884847 | 899.2695755643996 | 1017 | 2465.740626554648 | 14504.36 | 0.003373207531694788 | -4.891151533570337e-05 | -0.0007444356004953079 |  | 2465.7412 | 41137 | 6621.6 | 1017 | 41137 | 3246.4356 | 1017 | 215.0820438 | 906.3260660844 | 1017 | 3055.796221319652 | 13902.47566879595 | 201.5858971975413 | 861.9534914653489 | 1017 | 2363.420863695311 | 14652.7197476418 | 212.4644363408061 | 908.4686243537916 | 1017 | 2490.962357099106 | 14467.7845822063 | 209.7828764419913 | 897.0026440967903 | 1017 | 2459.523378975071 | 14513.37110048615 | 210.4438809570492 | 899.8290082301413 | 1017 | 2467.273087082646 | 14502.13402373016 | 210.2809433440874 | 899.1323094712701 | 1017 | 2465.362784034128 | 14504.90396315051 | 210.3211074656824 | 899.3040457153317 | 1017 | 2465.833673735587 | 14504.2211730834 | 210.3112070097093 | 899.2617127311706 | 1017 | 2465.717599424177 | 14504.38948083494 | 210.3136474721067 | 899.2721478117664 | 1017 | 2465.74621174194 | 14504.34799297419 | 210.3130458981257 | 899.2695755643996 | 1017 | 2465.739158805612 | 14504.35821973186 | 0 | 2465.739158805612 | 0 | 0 | 899.2695755643996 | 210.313194186112 | 1017 | 2465.739158805612 | 14504.35807144388 | 210.3131920359362 | 1017 | 2465.740872145459 | 14504.35636025421 | 210.313167223686 | 1017 | 2465.740581243215 | 14504.3566759687 | 210.3131718015462 | 1017 | 2465.74063491468 | 14504.35661771938 | 210.3131709569309 | 1017 | 2465.740625012294 | 14504.35662846638 | 210.3131711127625 | 1017 | 2465.740626839284 | 14504.35662648356 | 210.3131710840116 | 1017 | 2465.740626502205 | 14504.35662684939 | 210.3131710893161 | 1017 | 2465.740626564396 | 14504.35662678189 | 210.3131710883374 | 1017 | 2465.740626552922 | 14504.35662679434 | 210.313171088518 | 1017 | 2465.740626555038 | 14504.35662679205 | 210.3131710884847 | 1017 | 2465.740626554648 | 14504.35662679247
 |  |  | 1.45% on [NAME] | 6.2% on [NAME] | 11.3% on first $9k of W2 | 17% on [NAME]
 |  |  | no maximum | maximum $6621.6 | maximum $1017 | maximum $41137
 |  | Available Limit | 276.90186 | 1183.99416 | 1017 | 935.7412000000002
 |  | Straight % | 203.6791908789996 | 870.9041265171018 | 1587.293004781169 | 2387.962927546892
 |  | Tax | 230.9216094751509 | 987.3889508592661 | 1017 | 935.7412000000002 | 15925.62823966558
 |  |  | 0.0145 | 0.06199999999999999