Spreadsheet: 60602d1261105263-payroll-taxes-missyreiber
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 | 32833.74855619267 | 407.6025857747261 | 0 | 0 | 4315.622813540278 | 28110.52 | -0.003156877661240287 | 4.577472606115407e-05 | -1742.85224 |  | 4778.7884 | 4315.622813540278 | 0 | 0 | 4315.622813540278 | 5581.737254552753 | 0 | 395.1541638737787 | 1665.1251425415 | 0 | 5231.489772462156 | 25541.97947731523 | 370.3587024210709 | 1583.602727593544 | 0 | 4342.13651114359 | 26537.65061503446 | 384.7959339179997 | 1645.334338132136 | 0 | 4511.400604555858 | 26292.21767958668 | 381.2371563540068 | 1630.117496134374 | 0 | 4469.677005529736 | 26352.71689817455 | 382.114395023531 | 1633.868447686822 | 0 | 4479.961872689673 | 26337.80384079264 | 381.8981556914933 | 1632.943838129144 | 0 | 4477.426652934749 | 26341.47990943728 | 381.9514586868406 | 1633.171754385111 | 0 | 4478.051584604338 | 26340.57375851638 | 381.9383194984875 | 1633.115573028015 | 0 | 4477.897538947785 | 26340.79712471838 | 381.9415583084165 | 1633.129421732539 | 0 | 4477.935511202125 | 26340.74206494959 | 381.940759941769 | 1633.126008026874 | 0 | 4477.92615104143 | 26340.7556371826 | -162.3033375011519 | 4315.622813540278 | 4315.622813540278 | -1633.126008026874 | 0 | 381.9409567391477 | 0 | 4315.622813540278 | 28136.18478591324 | 407.974679395742 | 0 | 4315.622813540278 | 28110.15106325665 | 407.5971904172214 | 0 | 4315.622813540278 | 28110.52855223517 | 407.6026640074099 | 0 | 4315.622813540278 | 28110.52307864498 | 407.6025846403522 | 0 | 4315.622813540278 | 28110.52315801203 | 407.6025857911745 | 0 | 4315.622813540278 | 28110.52315686121 | 407.6025857744876 | 0 | 4315.622813540278 | 28110.5231568779 | 407.6025857747296 | 0 | 4315.622813540278 | 28110.52315687766 | 407.602585774726 | 0 | 4315.622813540278 | 28110.52315687766 | 407.6025857747261 | 0 | 4315.622813540278 | 28110.52315687766 | 407.6025857747261 | 0 | 4315.622813540278 | 28110.52315687766
 |  |  | 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 | 1000000000 | 0 | 0 | 4315.622813540278
 |  | Straight % | 401.9327598689688 | 0 | 0 | 4712.315115705152
 |  | Tax | 407.6025857747261 | 0 | 0 | 4315.622813540278