Spreadsheet: 217127d1361989923-why-my-index-formula-not-working-on-the-je-tab-bns-project-0227
Sheet: SUMMARY

January 2013 - Monthly Payroll or Bonus Revenue Accrual |  |  |  |  |  |  |  |  |  |  | Accrual Date: | 2013-01-31 00:00:00
Unit |  | Client | Project | Total Earnings | Benefit % | Bonus adj 50% | Burden | [NAME] | Payroll Accrual
MM |  | WELLS | 10GCS0035865 | 2142 | 192.78 | 1167.39 | 428.4 |  | 1595.79
MM |  | WELLS | 10GCS0038122 | 1583.33 | 142.4997 | 862.91485 | 316.666 |  | 1179.58085
MM |  | WELLS | 10GCS555602C | 1583.33 | 142.4997 | 862.91485 | 316.666 |  | 1179.58085
MM |  | WELLS | 10GCS555603C | 795.6 | 71.604 | 433.602 | 159.12 |  | 592.722
MM |  | WELLS | 10GCS555604C | 0 | 0 | 0 | 0 |  | 0
MM |  | WELLS | 10GCS555605C | 6191.3 | 557.217 | 3374.2585 | 1238.26 |  | 4612.5185
MM |  | WELLS | 10GCS555608C | 2073.89 | 186.6501 | 1130.27005 | 414.7780000000001 |  | 1545.04805
MM |  | WELLS | 10GCS555609C | 2013.63 | 181.2267 | 1097.42835 | 402.7260000000001 |  | 1500.15435
MM |  | WELLS | 10GCS555610C | 1394.24 | 125.4816 | 759.8608 | 278.848 |  | 1038.7088
MM |  | WELLS | 10GCS555611C | 795.6 | 71.604 | 433.602 | 159.12 |  | 592.722
MM |  | WELLS | 10GCS555612C | 1466.67 | 132.0003 | 799.33515 | 293.334 |  | 1092.66915
MM |  | WELLS | 10GCS555613C | 1466.75 | 132.0075 | 799.37875 | 293.35 |  | 1092.72875
MM |  |  |  | 21506.34 | 1935.5706 | 11720.9553 | 2354.87 |  | 16022.2233
HRPM |  | WELLS | 10GCS576501C | 1496.31 | 134.6679 | 815.4889499999999 | 299.262 |  | 1114.75095
HRPM |  | WELLS | 10GCS576505C | 22455.01 | 2020.9509 | 12237.98045 | 4491.002 |  | 16728.98245
HRPM |  | WELLS | 10GCS576506C | 5031.900000000001 | 452.871 | 2742.3855 | 1006.38 |  | 3748.7655
HRPM |  | WELLS | 10GCS576507C | 1781.73 | 160.3557 | 971.04285 | 356.346 |  | 1327.38885
HRPM |  | WELLS | 10GCS576508C | 2549.36 | 229.4424 | 1389.4012 | 509.872 |  | 1899.2732
HRPM |  | WELLS | 10GCS576511C | 6650.72 | 598.5648 | 3624.6424 | 1330.144 |  | 4954.786400000001
HRPM |  | WELLS | 10GCS576514C | 435.61 | 39.2049 | 237.40745 | 87.12200000000001 |  | 324.52945
HRPM |  | WELLS | 10GCS576516C | 5494.21 | 494.4789 | 2994.34445 | 1098.842 |  | 4093.18645
HRPM |  | WELLS | 10GCS576523C | 1200.68 | 108.0612 | 654.3706 | 240.136 |  | 894.5065999999999
HRPM |  | WELLS | 10GCS576524C | 4023.98 | 362.1582 | 2193.0691 | 804.796 |  | 2997.8651
HRPM |  | WELLS | 10GCS576525C | 600 | 54 | 327 | 120 |  | 447
HRPM |  | WELLS | 10GCS576526C | 758.3399999999999 | 68.25059999999999 | 413.2952999999999 | 151.668 |  | 564.9632999999999
HRPM |  | WELLS | 10GCS576527C | 5192.84 | 467.3556 | 2830.0978 | 1038.568 |  | 3868.6658
HRPM |  | WELLS | 10GCS576528C | 1618.33 | 145.6497 | 881.9898499999999 | 323.666 |  | 1205.65585
HRPM |  | WELLS | 10GCS576529C | 5196.38 | 467.6742 | 2832.0271 | 1039.276 |  | 3871.3031
HRPM |  | WELLS | 10GCS576530C | 1139.72 | 102.5748 | 621.1473999999998 | 227.944 |  | 849.0913999999998
HRPM |  | WELLS | 10GCS576531C | 0 | 0 | 0 | 0 |  | 0
HRPM |  | WELLS | 10GCS576532C | 583.33 | 52.4997 | 317.91485 | 116.666 |  | 434.58085
HRPM |  | WELLS | 10GCS576533C | 491.67 | 44.2503 | 267.96015 | 98.334 |  | 366.29415
HRPM |  | WELLS | 10GCS576534C | 541.67 | 48.7503 | 295.21015 | 108.334 |  | 403.54415
HRPM |  | WELLS | 10GCS576535C | 541.67 | 48.7503 | 295.21015 | 108.334 |  | 403.54415
HRPM |  | WELLS | 10GCS576536C | 541.67 | 48.7503 | 295.21015 | 108.334 |  | 403.54415
HRPM |  | WELLS | 10GCS576537C | 0 | 0 | 0 | 0 |  | 0
HRPM |  |  |  | 68325.12999999999 |  |  | 7549.895000000001 |  | 48696.82275000001
PJM |  | WELLS | 10GCS576517C | 8312.03 | 748.0827 |  | 2494.440203000001 | 2701.61755075 | 11554.552903 | Signage Refresh Billable Monthly
PJM |  | WELLS | 10GCS576519C | 1791.67 | 161.2503 |  | 537.6801670000001 | 582.33754175 | 2490.600467 | PMO - ACCRUED MONTHLY
PJM |  |  |  | 10103.7 | 909.3330000000001 | 0 | 3032.120370000001 |  | 14045.15337
TOTAL BONUS SCHEDULE |  |  |  | 99935.17
WELLS ACCOUNT
FM & MM Bonus Burden = 20%
FM & MM Adjust Bonus down by 50% monthly