{"text_format":"3","workbook":"xlsx","n_sheets":21,"sheets":["Table of Contents","Instructions","Ascensus","BB&T","MetLife","Newport","Narrative Template","TOC","Attachments","Firm Experience and Qualificat.","Assigned Service Team Exp.","Plan Sponsor Services","Participant Services, Experien.","Recordkeeping Systems","Transition and Implementation","Plan Fee-Expense","Proprietary Options","References","Plan Costs","Sample Scorecard","Ind Scorecard"],"not_rendered":{"images":7,"external_links":1,"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"Table of Contents","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"hidden":true,"merged":[[2,0,2,11],[2,12,2,23],[2,24,2,35],[2,36,2,47],[2,48,2,59],[2,60,2,71],[2,72,2,83],[2,84,2,95],[2,96,2,107],[2,108,2,119],[2,120,2,131],[2,132,2,143],[2,144,2,155],[2,156,2,167],[2,168,2,179],[2,180,2,191],[2,192,2,203],[2,204,2,215],[2,216,2,227],[2,228,2,239],[2,240,2,251],[2,252,2,263],[2,264,2,275],[2,276,2,287],[2,288,2,299],[2,300,2,311],[2,312,2,323],[2,324,2,335],[2,336,2,347],[2,348,2,359],[2,360,2,371],[2,372,2,383],[2,384,2,395],[2,396,2,407],[2,408,2,419],[2,420,2,431],[2,432,2,443],[2,444,2,455],[2,456,2,467],[2,468,2,479],[2,480,2,491],[2,492,2,503],[2,504,2,515],[2,516,2,527],[2,528,2,539],[2,540,2,551],[2,552,2,563],[2,564,2,575],[2,576,2,587],[2,588,2,599],[2,600,2,611],[2,612,2,623],[2,624,2,635],[2,636,2,647],[2,648,2,659],[2,660,2,671],[2,672,2,683],[2,684,2,695],[2,696,2,707],[2,708,2,719],[2,720,2,731],[2,732,2,743],[2,744,2,755],[2,756,2,767],[2,768,2,779],[2,780,2,791],[2,792,2,803],[2,804,2,815],[2,816,2,827],[2,828,2,839],[2,840,2,851],[2,852,2,863],[2,864,2,875],[2,876,2,887],[2,888,2,899],[2,900,2,911],[2,912,2,923],[2,924,2,935],[2,936,2,947],[2,948,2,959],[2,960,2,971],[2,972,2,983],[2,984,2,995],[2,996,2,1007],[2,1008,2,1019],[2,1020,2,1031],[2,1032,2,1043],[2,1044,2,1055],[2,1056,2,1067],[2,1068,2,1079],[2,1080,2,1091],[2,1092,2,1103],[2,1104,2,1115],[2,1116,2,1127],[2,1128,2,1139],[2,1140,2,1151],[2,1152,2,1163],[2,1164,2,1175],[2,1176,2,1187],[2,1188,2,1199],[2,1200,2,1211],[2,1212,2,1223],[2,1224,2,1235],[2,1236,2,1247],[2,1248,2,1259],[2,1260,2,1271],[2,1272,2,1283],[2,1284,2,1295],[2,1296,2,1307],[2,1308,2,1319],[2,1320,2,1331],[2,1332,2,1343],[2,1344,2,1355],[2,1356,2,1367],[2,1368,2,1379],[2,1380,2,1391],[2,1392,2,1403],[2,1404,2,1415],[2,1416,2,1427],[2,1428,2,1439],[2,1440,2,1451],[2,1452,2,1463],[2,1464,2,1475],[2,1476,2,1487],[2,1488,2,1499],[2,1500,2,1511],[2,1512,2,1523],[2,1524,2,1535],[2,1536,2,1547],[2,1548,2,1559],[2,1560,2,1571],[2,1572,2,1583],[2,1584,2,1595],[2,1596,2,1607],[2,1608,2,1619],[2,1620,2,1631],[2,1632,2,1643],[2,1644,2,1655],[2,1656,2,1667],[2,1668,2,1679],[2,1680,2,1691],[2,1692,2,1703],[2,1704,2,1715],[2,1716,2,1727],[2,1728,2,1739],[2,1740,2,1751],[2,1752,2,1763],[2,1764,2,1775],[2,1776,2,1787],[2,1788,2,1799],[2,1800,2,1811],[2,1812,2,1823],[2,1824,2,1835],[2,1836,2,1847],[2,1848,2,1859],[2,1860,2,1871],[2,1872,2,1883],[2,1884,2,1895],[2,1896,2,1907],[2,1908,2,1919],[2,1920,2,1931],[2,1932,2,1943],[2,1944,2,1955],[2,1956,2,1967],[2,1968,2,1979],[2,1980,2,1991],[2,1992,2,2003],[2,2004,2,2015],[2,2016,2,2027],[2,2028,2,2039],[2,2040,2,2051],[2,2052,2,2063],[2,2064,2,2075],[2,2076,2,2087],[2,2088,2,2099],[2,2100,2,2111],[2,2112,2,2123],[2,2124,2,2135],[2,2136,2,2147],[2,2148,2,2159],[2,2160,2,2171],[2,2172,2,2183],[2,2184,2,2195],[2,2196,2,2207],[2,2208,2,2219],[2,2220,2,2231],[2,2232,2,2243],[2,2244,2,2255],[2,2256,2,2267],[2,2268,2,2279],[2,2280,2,2291],[2,2292,2,2303],[2,2304,2,2315],[2,2316,2,2327],[2,2328,2,2339],[2,2340,2,2351],[2,2352,2,2363],[2,2364,2,2375],[2,2376,2,2387],[2,2388,2,2399],[2,2400,2,2411],[2,2412,2,2423],[2,2424,2,2435],[2,2436,2,2447],[2,2448,2,2459],[2,2460,2,2471],[2,2472,2,2483],[2,2484,2,2495],[2,2496,2,2507],[2,2508,2,2519],[2,2520,2,2531],[2,2532,2,2543],[2,2544,2,2555],[2,2556,2,2567],[2,2568,2,2579],[2,2580,2,2591],[2,2592,2,2603],[2,2604,2,2615],[2,2616,2,2627],[2,2628,2,2639],[2,2640,2,2651],[2,2652,2,2663],[2,2664,2,2675],[2,2676,2,2687],[2,2688,2,2699],[2,2700,2,2711],[2,2712,2,2723],[2,2724,2,2735],[2,2736,2,2747],[2,2748,2,2759],[2,2760,2,2771],[2,2772,2,2783],[2,2784,2,2795],[2,2796,2,2807],[2,2808,2,2819],[2,2820,2,2831],[2,2832,2,2843],[2,2844,2,2855],[2,2856,2,2867],[2,2868,2,2879],[2,2880,2,2891],[2,2892,2,2903],[2,2904,2,2915],[2,2916,2,2927],[2,2928,2,2939],[2,2940,2,2951],[2,2952,2,2963],[2,2964,2,2975],[2,2976,2,2987],[2,2988,2,2999],[2,3000,2,3011],[2,3012,2,3023],[2,3024,2,3035],[2,3036,2,3047],[2,3048,2,3059],[2,3060,2,3071],[2,3072,2,3083],[2,3084,2,3095],[2,3096,2,3107],[2,3108,2,3119],[2,3120,2,3131],[2,3132,2,3143],[2,3144,2,3155],[2,3156,2,3167],[2,3168,2,3179],[2,3180,2,3191],[2,3192,2,3203],[2,3204,2,3215],[2,3216,2,3227],[2,3228,2,3239],[2,3240,2,3251],[2,3252,2,3263],[2,3264,2,3275],[2,3276,2,3287],[2,3288,2,3299],[2,3300,2,3311],[2,3312,2,3323],[2,3324,2,3335],[2,3336,2,3347],[2,3348,2,3359],[2,3360,2,3371],[2,3372,2,3383],[2,3384,2,3395],[2,3396,2,3407],[2,3408,2,3419],[2,3420,2,3431],[2,3432,2,3443],[2,3444,2,3455],[2,3456,2,3467],[2,3468,2,3479],[2,3480,2,3491],[2,3492,2,3503],[2,3504,2,3515],[2,3516,2,3527],[2,3528,2,3539],[2,3540,2,3551],[2,3552,2,3563],[2,3564,2,3575],[2,3576,2,3587],[2,3588,2,3599],[2,3600,2,3611],[2,3612,2,3623],[2,3624,2,3635],[2,3636,2,3647],[2,3648,2,3659],[2,3660,2,3671],[2,3672,2,3683],[2,3684,2,3695],[2,3696,2,3707],[2,3708,2,3719],[2,3720,2,3731],[2,3732,2,3743],[2,3744,2,3755],[2,3756,2,3767],[2,3768,2,3779],[2,3780,2,3791],[2,3792,2,3803],[2,3804,2,3815],[2,3816,2,3827],[2,3828,2,3839],[2,3840,2,3851],[2,3852,2,3863],[2,3864,2,3875],[2,3876,2,3887],[2,3888,2,3899],[2,3900,2,3911],[2,3912,2,3923],[2,3924,2,3935],[2,3936,2,3947],[2,3948,2,3959],[2,3960,2,3971],[2,3972,2,3983],[2,3984,2,3995],[2,3996,2,4007],[2,4008,2,4019],[2,4020,2,4031],[2,4032,2,4043],[2,4044,2,4055],[2,4056,2,4067],[2,4068,2,4079],[2,4080,2,4091],[2,4092,2,4103],[2,4104,2,4115],[2,4116,2,4127],[2,4128,2,4139],[2,4140,2,4151],[2,4152,2,4163],[2,4164,2,4175],[2,4176,2,4187],[2,4188,2,4199],[2,4200,2,4211],[2,4212,2,4223],[2,4224,2,4235],[2,4236,2,4247],[2,4248,2,4259],[2,4260,2,4271],[2,4272,2,4283],[2,4284,2,4295],[2,4296,2,4307],[2,4308,2,4319],[2,4320,2,4331],[2,4332,2,4343],[2,4344,2,4355],[2,4356,2,4367],[2,4368,2,4379],[2,4380,2,4391],[2,4392,2,4403],[2,4404,2,4415],[2,4416,2,4427],[2,4428,2,4439],[2,4440,2,4451],[2,4452,2,4463],[2,4464,2,4475],[2,4476,2,4487],[2,4488,2,4499],[2,4500,2,4511],[2,4512,2,4523],[2,4524,2,4535],[2,4536,2,4547],[2,4548,2,4559],[2,4560,2,4571],[2,4572,2,4583],[2,4584,2,4595],[2,4596,2,4607],[2,4608,2,4619],[2,4620,2,4631],[2,4632,2,4643],[2,4644,2,4655],[2,4656,2,4667],[2,4668,2,4679],[2,4680,2,4691],[2,4692,2,4703],[2,4704,2,4715],[2,4716,2,4727],[2,4728,2,4739],[2,4740,2,4751],[2,4752,2,4763],[2,4764,2,4775],[2,4776,2,4787],[2,4788,2,4799],[2,4800,2,4811],[2,4812,2,4823],[2,4824,2,4835],[2,4836,2,4847],[2,4848,2,4859],[2,4860,2,4871],[2,4872,2,4883],[2,4884,2,4895],[2,4896,2,4907],[2,4908,2,4919],[2,4920,2,4931],[2,4932,2,4943],[2,4944,2,4955],[2,4956,2,4967],[2,4968,2,4979],[2,4980,2,4991],[2,4992,2,5003],[2,5004,2,5015],[2,5016,2,5027],[2,5028,2,5039],[2,5040,2,5051],[2,5052,2,5063],[2,5064,2,5075],[2,5076,2,5087],[2,5088,2,5099],[2,5100,2,5111],[2,5112,2,5123],[2,5124,2,5135],[2,5136,2,5147],[2,5148,2,5159],[2,5160,2,5171],[2,5172,2,5183],[2,5184,2,5195],[2,5196,2,5207],[2,5208,2,5219],[2,5220,2,5231],[2,5232,2,5243],[2,5244,2,5255],[2,5256,2,5267],[2,5268,2,5279],[2,5280,2,5291],[2,5292,2,5303],[2,5304,2,5315],[2,5316,2,5327],[2,5328,2,5339],[2,5340,2,5351],[2,5352,2,5363],[2,5364,2,5375],[2,5376,2,5387],[2,5388,2,5399],[2,5400,2,5411],[2,5412,2,5423],[2,5424,2,5435],[2,5436,2,5447],[2,5448,2,5459],[2,5460,2,5471],[2,5472,2,5483],[2,5484,2,5495],[2,5496,2,5507],[2,5508,2,5519],[2,5520,2,5531],[2,5532,2,5543],[2,5544,2,5555],[2,5556,2,5567],[2,5568,2,5579],[2,5580,2,5591],[2,5592,2,5603],[2,5604,2,5615],[2,5616,2,5627],[2,5628,2,5639],[2,5640,2,5651],[2,5652,2,5663],[2,5664,2,5675],[2,5676,2,5687],[2,5688,2,5699],[2,5700,2,5711],[2,5712,2,5723],[2,5724,2,5735],[2,5736,2,5747],[2,5748,2,5759],[2,5760,2,5771],[2,5772,2,5783],[2,5784,2,5795],[2,5796,2,5807],[2,5808,2,5819],[2,5820,2,5831],[2,5832,2,5843],[2,5844,2,5855],[2,5856,2,5867],[2,5868,2,5879],[2,5880,2,5891],[2,5892,2,5903],[2,5904,2,5915],[2,5916,2,5927],[2,5928,2,5939],[2,5940,2,5951],[2,5952,2,5963],[2,5964,2,5975],[2,5976,2,5987],[2,5988,2,5999],[2,6000,2,6011],[2,6012,2,6023],[2,6024,2,6035],[2,6036,2,6047],[2,6048,2,6059],[2,6060,2,6071],[2,6072,2,6083],[2,6084,2,6095],[2,6096,2,6107],[2,6108,2,6119],[2,6120,2,6131],[2,6132,2,6143],[2,6144,2,6155],[2,6156,2,6167],[2,6168,2,6179],[2,6180,2,6191],[2,6192,2,6203],[2,6204,2,6215],[2,6216,2,6227],[2,6228,2,6239],[2,6240,2,6251],[2,6252,2,6263],[2,6264,2,6275],[2,6276,2,6287],[2,6288,2,6299],[2,6300,2,6311],[2,6312,2,6323],[2,6324,2,6335],[2,6336,2,6347],[2,6348,2,6359],[2,6360,2,6371],[2,6372,2,6383],[2,6384,2,6395],[2,6396,2,6407],[2,6408,2,6419],[2,6420,2,6431],[2,6432,2,6443],[2,6444,2,6455],[2,6456,2,6467],[2,6468,2,6479],[2,6480,2,6491],[2,6492,2,6503],[2,6504,2,6515],[2,6516,2,6527],[2,6528,2,6539],[2,6540,2,6551],[2,6552,2,6563],[2,6564,2,6575],[2,6576,2,6587],[2,6588,2,6599],[2,6600,2,6611],[2,6612,2,6623],[2,6624,2,6635],[2,6636,2,6647],[2,6648,2,6659],[2,6660,2,6671],[2,6672,2,6683],[2,6684,2,6695],[2,6696,2,6707],[2,6708,2,6719],[2,6720,2,6731],[2,6732,2,6743],[2,6744,2,6755],[2,6756,2,6767],[2,6768,2,6779],[2,6780,2,6791],[2,6792,2,6803],[2,6804,2,6815],[2,6816,2,6827],[2,6828,2,6839],[2,6840,2,6851],[2,6852,2,6863],[2,6864,2,6875],[2,6876,2,6887],[2,6888,2,6899],[2,6900,2,6911],[2,6912,2,6923],[2,6924,2,6935],[2,6936,2,6947],[2,6948,2,6959],[2,6960,2,6971],[2,6972,2,6983],[2,6984,2,6995],[2,6996,2,7007],[2,7008,2,7019],[2,7020,2,7031],[2,7032,2,7043],[2,7044,2,7055],[2,7056,2,7067],[2,7068,2,7079],[2,7080,2,7091],[2,7092,2,7103],[2,7104,2,7115],[2,7116,2,7127],[2,7128,2,7139],[2,7140,2,7151],[2,7152,2,7163],[2,7164,2,7175],[2,7176,2,7187],[2,7188,2,7199],[2,7200,2,7211],[2,7212,2,7223],[2,7224,2,7235],[2,7236,2,7247],[2,7248,2,7259],[2,7260,2,7271],[2,7272,2,7283],[2,7284,2,7295],[2,7296,2,7307],[2,7308,2,7319],[2,7320,2,7331],[2,7332,2,7343],[2,7344,2,7355],[2,7356,2,7367],[2,7368,2,7379],[2,7380,2,7391],[2,7392,2,7403],[2,7404,2,7415],[2,7416,2,7427],[2,7428,2,7439],[2,7440,2,7451],[2,7452,2,7463],[2,7464,2,7475],[2,7476,2,7487],[2,7488,2,7499],[2,7500,2,7511],[2,7512,2,7523],[2,7524,2,7535],[2,7536,2,7547],[2,7548,2,7559],[2,7560,2,7571],[2,7572,2,7583],[2,7584,2,7595],[2,7596,2,7607],[2,7608,2,7619],[2,7620,2,7631],[2,7632,2,7643],[2,7644,2,7655],[2,7656,2,7667],[2,7668,2,7679],[2,7680,2,7691],[2,7692,2,7703],[2,7704,2,7715],[2,7716,2,7727],[2,7728,2,7739],[2,7740,2,7751],[2,7752,2,7763],[2,7764,2,7775],[2,7776,2,7787],[2,7788,2,7799],[2,7800,2,7811],[2,7812,2,7823],[2,7824,2,7835],[2,7836,2,7847],[2,7848,2,7859],[2,7860,2,7871],[2,7872,2,7883],[2,7884,2,7895],[2,7896,2,7907],[2,7908,2,7919],[2,7920,2,7931],[2,7932,2,7943],[2,7944,2,7955],[2,7956,2,7967],[2,7968,2,7979],[2,7980,2,7991],[2,7992,2,8003],[2,8004,2,8015],[2,8016,2,8027],[2,8028,2,8039],[2,8040,2,8051],[2,8052,2,8063],[2,8064,2,8075],[2,8076,2,8087],[2,8088,2,8099],[2,8100,2,8111],[2,8112,2,8123],[2,8124,2,8135],[2,8136,2,8147],[2,8148,2,8159],[2,8160,2,8171],[2,8172,2,8183],[2,8184,2,8195],[2,8196,2,8207],[2,8208,2,8219],[2,8220,2,8231],[2,8232,2,8243],[2,8244,2,8255],[2,8256,2,8267],[2,8268,2,8279],[2,8280,2,8291],[2,8292,2,8303],[2,8304,2,8315],[2,8316,2,8327],[2,8328,2,8339],[2,8340,2,8351],[2,8352,2,8363],[2,8364,2,8375],[2,8376,2,8387],[2,8388,2,8399],[2,8400,2,8411],[2,8412,2,8423],[2,8424,2,8435],[2,8436,2,8447],[2,8448,2,8459],[2,8460,2,8471],[2,8472,2,8483],[2,8484,2,8495],[2,8496,2,8507],[2,8508,2,8519],[2,8520,2,8531],[2,8532,2,8543],[2,8544,2,8555],[2,8556,2,8567],[2,8568,2,8579],[2,8580,2,8591],[2,8592,2,8603],[2,8604,2,8615],[2,8616,2,8627],[2,8628,2,8639],[2,8640,2,8651],[2,8652,2,8663],[2,8664,2,8675],[2,8676,2,8687],[2,8688,2,8699],[2,8700,2,8711],[2,8712,2,8723],[2,8724,2,8735],[2,8736,2,8747],[2,8748,2,8759],[2,8760,2,8771],[2,8772,2,8783],[2,8784,2,8795],[2,8796,2,8807],[2,8808,2,8819],[2,8820,2,8831],[2,8832,2,8843],[2,8844,2,8855],[2,8856,2,8867],[2,8868,2,8879],[2,8880,2,8891],[2,8892,2,8903],[2,8904,2,8915],[2,8916,2,8927],[2,8928,2,8939],[2,8940,2,8951],[2,8952,2,8963],[2,8964,2,8975],[2,8976,2,8987],[2,8988,2,8999],[2,9000,2,9011],[2,9012,2,9023],[2,9024,2,9035],[2,9036,2,9047],[2,9048,2,9059],[2,9060,2,9071],[2,9072,2,9083],[2,9084,2,9095],[2,9096,2,9107],[2,9108,2,9119],[2,9120,2,9131],[2,9132,2,9143],[2,9144,2,9155],[2,9156,2,9167],[2,9168,2,9179],[2,9180,2,9191],[2,9192,2,9203],[2,9204,2,9215],[2,9216,2,9227],[2,9228,2,9239],[2,9240,2,9251],[2,9252,2,9263],[2,9264,2,9275],[2,9276,2,9287],[2,9288,2,9299],[2,9300,2,9311],[2,9312,2,9323],[2,9324,2,9335],[2,9336,2,9347],[2,9348,2,9359],[2,9360,2,9371],[2,9372,2,9383],[2,9384,2,9395],[2,9396,2,9407],[2,9408,2,9419],[2,9420,2,9431],[2,9432,2,9443],[2,9444,2,9455],[2,9456,2,9467],[2,9468,2,9479],[2,9480,2,9491],[2,9492,2,9503],[2,9504,2,9515],[2,9516,2,9527],[2,9528,2,9539],[2,9540,2,9551],[2,9552,2,9563],[2,9564,2,9575],[2,9576,2,9587],[2,9588,2,9599],[2,9600,2,9611],[2,9612,2,9623],[2,9624,2,9635],[2,9636,2,9647],[2,9648,2,9659],[2,9660,2,9671],[2,9672,2,9683],[2,9684,2,9695],[2,9696,2,9707],[2,9708,2,9719],[2,9720,2,9731],[2,9732,2,9743],[2,9744,2,9755],[2,9756,2,9767],[2,9768,2,9779],[2,9780,2,9791],[2,9792,2,9803],[2,9804,2,9815],[2,9816,2,9827],[2,9828,2,9839],[2,9840,2,9851],[2,9852,2,9863],[2,9864,2,9875],[2,9876,2,9887],[2,9888,2,9899],[2,9900,2,9911],[2,9912,2,9923],[2,9924,2,9935],[2,9936,2,9947],[2,9948,2,9959],[2,9960,2,9971],[2,9972,2,9983],[2,9984,2,9995],[2,9996,2,10007],[2,10008,2,10019],[2,10020,2,10031],[2,10032,2,10043],[2,10044,2,10055],[2,10056,2,10067],[2,10068,2,10079],[2,10080,2,10091],[2,10092,2,10103],[2,10104,2,10115],[2,10116,2,10127],[2,10128,2,10139],[2,10140,2,10151],[2,10152,2,10163],[2,10164,2,10175],[2,10176,2,10187],[2,10188,2,10199],[2,10200,2,10211],[2,10212,2,10223],[2,10224,2,10235],[2,10236,2,10247],[2,10248,2,10259],[2,10260,2,10271],[2,10272,2,10283],[2,10284,2,10295],[2,10296,2,10307],[2,10308,2,10319],[2,10320,2,10331],[2,10332,2,10343],[2,10344,2,10355],[2,10356,2,10367],[2,10368,2,10379],[2,10380,2,10391],[2,10392,2,10403],[2,10404,2,10415],[2,10416,2,10427],[2,10428,2,10439],[2,10440,2,10451],[2,10452,2,10463],[2,10464,2,10475],[2,10476,2,10487],[2,10488,2,10499],[2,10500,2,10511],[2,10512,2,10523],[2,10524,2,10535],[2,10536,2,10547],[2,10548,2,10559],[2,10560,2,10571],[2,10572,2,10583],[2,10584,2,10595],[2,10596,2,10607],[2,10608,2,10619],[2,10620,2,10631],[2,10632,2,10643],[2,10644,2,10655],[2,10656,2,10667],[2,10668,2,10679],[2,10680,2,10691],[2,10692,2,10703],[2,10704,2,10715],[2,10716,2,10727],[2,10728,2,10739],[2,10740,2,10751],[2,10752,2,10763],[2,10764,2,10775],[2,10776,2,10787],[2,10788,2,10799],[2,10800,2,10811],[2,10812,2,10823],[2,10824,2,10835],[2,10836,2,10847],[2,10848,2,10859],[2,10860,2,10871],[2,10872,2,10883],[2,10884,2,10895],[2,10896,2,10907],[2,10908,2,10919],[2,10920,2,10931],[2,10932,2,10943],[2,10944,2,10955],[2,10956,2,10967],[2,10968,2,10979],[2,10980,2,10991],[2,10992,2,11003],[2,11004,2,11015],[2,11016,2,11027],[2,11028,2,11039],[2,11040,2,11051],[2,11052,2,11063],[2,11064,2,11075],[2,11076,2,11087],[2,11088,2,11099],[2,11100,2,11111],[2,11112,2,11123],[2,11124,2,11135],[2,11136,2,11147],[2,11148,2,11159],[2,11160,2,11171],[2,11172,2,11183],[2,11184,2,11195],[2,11196,2,11207],[2,11208,2,11219],[2,11220,2,11231],[2,11232,2,11243],[2,11244,2,11255],[2,11256,2,11267],[2,11268,2,11279],[2,11280,2,11291],[2,11292,2,11303],[2,11304,2,11315],[2,11316,2,11327],[2,11328,2,11339],[2,11340,2,11351],[2,11352,2,11363],[2,11364,2,11375],[2,11376,2,11387],[2,11388,2,11399],[2,11400,2,11411],[2,11412,2,11423],[2,11424,2,11435],[2,11436,2,11447],[2,11448,2,11459],[2,11460,2,11471],[2,11472,2,11483],[2,11484,2,11495],[2,11496,2,11507],[2,11508,2,11519],[2,11520,2,11531],[2,11532,2,11543],[2,11544,2,11555],[2,11556,2,11567],[2,11568,2,11579],[2,11580,2,11591],[2,11592,2,11603],[2,11604,2,11615],[2,11616,2,11627],[2,11628,2,11639],[2,11640,2,11651],[2,11652,2,11663],[2,11664,2,11675],[2,11676,2,11687],[2,11688,2,11699],[2,11700,2,11711],[2,11712,2,11723],[2,11724,2,11735],[2,11736,2,11747],[2,11748,2,11759],[2,11760,2,11771],[2,11772,2,11783],[2,11784,2,11795],[2,11796,2,11807],[2,11808,2,11819],[2,11820,2,11831],[2,11832,2,11843],[2,11904,2,11915],[2,11916,2,11927],[2,11964,2,11975],[2,11976,2,11987],[2,11988,2,11999],[2,12000,2,12011],[2,12012,2,12023],[2,12024,2,12035],[2,12036,2,12047],[2,12048,2,12059],[2,12060,2,12071],[2,12072,2,12083],[24,0,24,11]],"merged_total":1367,"flags":["merged_cut"]}
[]
[]
["Table of Contents"]
[]
[]
[]
["Information",null,"Intent to Bid"]
["Information",null,"Scoring Methodology"]
["Information",null,"Vendor Summaries"]
["Scoring",null,"Organization"]
["Scoring",null,"Statistics"]
["Scoring",null,"Client Services"]
["Scoring",null,"Employee Education"]
["Scoring",null,"Operations and Administration"]
["Scoring",null,"Implementation"]
["Scoring",null,"Contact Center and Web"]
["Scoring",null,"Recordkeeping System"]
["Scoring",null,"Recordkeeping and Administration Fees"]
["Information",null,"References"]
["Information",null,"Consolidated Scoring Matrix"]
["Information",null,"Individual Scorecard"]
[]
[]
[]
["This booklet is intended for comparative purposes only and is not meant to replace information contained in the submitted proposals.  If there is a discrepancy in the summarized data, the submitted proposal will prevail."]

{"sheet":"Instructions","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"hidden":true,"merged":[[2,0,2,17],[4,0,4,17],[6,4,6,12],[8,4,8,12],[10,4,10,12],[12,4,12,12]]}
[]
[]
["Scoring Methodology"]
[]
["The following pages contain highlights from the RFP responses and are meant to supplement the evaluation process.  After reviewing all proposals, you may use the following pages to score each vendor based on your individual assessment using the scoring method below.  Once The Bogdahn Group has collected all scorecards, we will combine the results and provide an overall summary to the Committee for your review."]
[]
[null,null,"16-20",75,"Proposal exceeds most, if not all requirements.  Responses leave no doubt the firm will complete and exceed desired objectives"]
[]
[null,null,"11-15",50,"Proposal meets all requirements outlined in the section and in a few cases exceeds them.  Responses are complete and create confidence that the firm can complete the desired objectives"]
[]
[null,null,"6-10",25,"Proposal generally meets most of the requirements outlined in the section.  Response adequately addresses most objectives and creates general credibility that firm can meet desired objectives"]
[]
[null,null,"1-5",0,"Proposal does not meet or barely meets the requirements outlined in the section.  Response is inadequate and creates concern over firm's capabilities with meeting desired objectives"]

{"sheet":"Ascensus","index":2,"n_rows":7,"n_cols":1,"rows_kept":7,"hidden":true,"merged":[[1,14,1,16],[2,0,2,15],[6,0,36,15]]}
[]
[]
["Ascensus"]
[]
[]
["Why We Succeed"]
["DID NOT RESPOND"]

{"sheet":"BB&T","index":3,"n_rows":7,"n_cols":1,"rows_kept":7,"hidden":true,"merged":[[1,14,1,16],[2,0,2,15],[6,0,36,15]]}
[]
[]
["BB&T"]
[]
[]
["Why We Succeed"]
["DID NOT RESPOND"]

{"sheet":"MetLife","index":4,"n_rows":7,"n_cols":1,"rows_kept":7,"hidden":true,"merged":[[1,14,1,16],[2,0,2,15],[6,0,36,15]]}
[]
[]
["MetLife"]
[]
[]
["Why We Succeed"]
["By choosing MetLife, you are choosing a company that has the scale, dedication, and desire to meet and exceed the Authority’s expectations and those of your employees. Our commitment is to provide top quality solutions to help make certain that your retirement plan offers the education and tools needed to achieve financial security.\n\nRecently, MetLife was selected as the exclusive provider for the plans of a hospital system; we immediately began executing the strategy for implementation. As the pre-implementation planning process commenced, we assuaged the client’s concerns regarding the complexity of the client’s organizational structure.\n\nClient Objectives\n- Ensure a smooth transition\n- Reach the largest number of participants during transition\n- Provide a higher level of employee education\n\nResults — The MetLife Difference\nThe key to successfully achieving these objectives centered on the dedicated MetLife AE. The AE led the Implementation Team, coordinated activities of the onsite FSRs, and leveraged resources within MetLife to provide administrative solutions. Through continuous interaction with the client, the AE was able to quickly assess their needs and develop a plan.\n\nOur flexible system allows the AE to accommodate client’s requirements. Based on client direction, the plan set-up involved retaining multiple contacts and established varying access levels. We built new amortization schedules based on converted loans to provide continuity to participants. Lastly, the inkind transfer of assets was addressed and all system requirements detailed and vetted prior to transfer. \n\nIn addition to managing all of the operational aspects of the conversion, the AE also worked with the onsite FSR to develop a comprehensive plan for educating employees about upcoming changes. With the AE’s focus and dedication, the client’s plans were successfully converted to MetLife. The AE continues to proactively work with the client to monitor plan activities, coordinate ongoing onsite education, and offer alternatives for plan enhancements."]

{"sheet":"Newport","index":5,"n_rows":7,"n_cols":1,"rows_kept":7,"hidden":true,"merged":[[1,14,1,16],[2,0,2,15],[6,0,36,15]]}
[]
[]
["The Newport Group"]
[]
[]
["Why We Succeed"]
["Flexible platform/Open architecture. Newport offers a completely open architecture fund/manager platform for investment options, providing access to one of the industry’s largest universe of funds/managers which includes 14,000+ mutual funds and co-mingled trusts. Furthermore, Newport does not have any in-house proprietary investment options, nor do we have relationships with any fund companies or investment managers. This allows us to maintain a fully neutral and objective role.  \n\nFully integrated retirement program. Newport provides the convenience of a seamless plan sponsor and participant experience through our fully integrated defined contribution, defined benefit and non-qualified deferred compensation platform.\n\nInnovative and tailored solutions. Sponsors want a partner who can offer their organization new solutions and ideas, as well as understand each client’s specific goals. We design and deliver a customized solution for every client and draw on our extensive experience to find efficient solutions for complex funding scenarios and unique plan requirements.\n\nClient service. Newport believes that exceptional customer service is critical to helping companies and their participants reach their goals. Our C2F (“Clients Come First”) approach means we proactively deliver solutions centered on the needs of our clients and their participants. This approach to client service is a fundamental part of Newport’s culture as a company. The responsiveness and consistency of Newport’s staff is consistently named “Best in Class” in Plansponsor magazine’s annual survey of sponsor satisfaction with their plan provider.\n\nNote that unlike many of our competitors whose retirement divisions represent a small part of their overall business, we dedicate 100% of our time, effort, and energy to the retirement plan business"]

{"sheet":"Narrative Template","index":6,"n_rows":8,"n_cols":15,"rows_kept":8,"hidden":true,"merged":[[1,14,1,16],[2,0,2,15],[4,0,4,12],[5,0,5,11],[8,0,23,15]]}
[]
[{"$nulls":14},"[INSERT VENDOR LOGO]"]
["[INSERT VENDOR NAME]"]
[]
["~ Commited to the DC Recordkeeping business since "]
["~ Number of employees dedicated to the DC business: "]
[]
["Why We Succeed"]

{"sheet":"TOC","index":7,"n_rows":33,"n_cols":6,"rows_kept":33,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[6,1,6,3],[32,0,33,8]]}
["Indian River County RFP 2022040"]
["Table of Contents"]
[]
[]
[{"$f":"A2","v":"Table of Contents"}]
[]
["Enter Proposer Name: "]
[]
[]
[{"$nulls":5},"Page #:"]
["Background"]
["Selection Criteria"]
["Project Timeline"]
["Plan Details"]
["Attachments"]
["Minimum Requirements Certification"]
["Firm Experience and Qualifications"]
["Assigned Service Team Experience"]
["Plan Sponsor Services"]
["Participant Services and Education"]
["Recordkeeping Systems"]
["Transition and Implementation"]
["Plan Fees/Expenses"]
["Propreitary Products and Services"]
["References"]
["Retirement Health Savings Plan (or Optional Plans)"]
[]
[]
[]
[]
[]
[]
["This document is intended for comparative purposes only and is not to replace information contained in the submitted proposals. In the event of a discrepancy, the submitted proposals will prevail. "]

{"sheet":"Attachments","index":8,"n_rows":67,"n_cols":2,"rows_kept":67,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[6,2,6,4],[6,5,6,7],[6,8,6,10],[8,0,10,10],[12,1,15,10],[17,1,17,10],[19,1,21,10],[38,0,38,10],[39,0,39,10],[40,0,40,10],[44,5,44,7],[44,8,44,10],[46,1,46,10],[48,1,48,10],[50,1,50,10],[52,1,54,10],[56,1,58,10],[60,1,61,10],[63,1,64,10],[66,1,66,10]]}
[{"$f":"TOC!A1","v":"Indian River County RFP 2022040"}]
[{"$f":"TOC!A15","v":"Attachments"}]
[{"$f":"TOC!B7","v":0}]
[]
[{"$f":"A2","v":"Attachments"}]
[]
[]
[]
["Please create the following attachments in the corresponding order below. Please provide a front cover, table of contents, and back cover for the attachments section. If your firm is unable/unwilling to complete any of the following attachments, please note which attachments were omitted and why. "]
[]
[]
[]
["1.","Please include a cover letter that states the name of your company, headquarters’ address, local business address (if any) and the name, title, address, phone number, and email address of the primary contact person for your proposal. Indicate the hours of operation at the local office, if any. You may also include a written response that includes any differentiators and why you believe your firm is the best fit for this client.  (Cover letter may be 5 pages max)"]
[]
[]
[]
[]
["2.","Please attach a separate biography or resume for each team member that will be assigned to this client."]
[]
["3.","Provide an attachment that describes your initial and on-going standard communication and education program (including printed materials, group education meetings, one-on-one participant on-site counseling sessions, employee meetings, training, web-based information sessions, etc.) Please provide samples of your standard materials."]
[]
[]
[]
["4.","Please provide a sample of your written educational & communications calendar/timeline."]
[]
["5.","Provide a sample participant quarterly statement."]
[]
["6.","Provide a sample of the Plan Sponsor Annual Review and Quarterly Trust Statements."]
[]
["7.","Please provide an attachment that details your firm's insurance policies if currently maintained."]
[null,"Errors and Omissions Coverage"]
[null,"Fidelity Bond"]
[null,"Director and Officer Liability"]
[null,"Cyber Security"]
[null,"Fiduciary"]
[]
[]
[]
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Attachments"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A5","v":"Attachments"}]
[]
[]
[]
["8.","Provide an attachment that describes the managed account services that can be provided to the Plans (i.e., Morningstar, Financial Engines, etc.)"]
[]
["9.","Provide an attachment that describes your Self-Directed Brokerage Accounts (“SDBA”) including the type of investment options available through it."]
[]
["10.","Include a suggested transition timeline in your response including your projected “blackout” period and assuming a transition date that appears on the \"Project Timeline\"."]
[]
["11.","Provide an attachment that describes any incident which has occurred within the last 5 years that did or potentially could have jeopardized the security of participant information in your record keeping system. Include data incidents where PII was released, cyber-attacks, theft of unencrypted data or equipment like laptops, etc. provide details on whether any assets have been compromised or left the plan, etc. Explain the measures you took following an incident to prevent a reoccurrence."]
[]
[]
[]
["12.","Please attach a copy of your standard company contract for review, highlighting any conflicts with the terms and conditions of this RFP, along with any other agreements or documents that would require approval and execution should your firm be selected as the winning proposer. The Plan Sponsor reserves the right to consider such conflicts when rating your proposal."]
[]
[]
[]
["13.","Please attach a description of any litigation and its status/final disposition in the past five (5) years involving your company as an administrator, investment provider, or in any other professional capacity with respect to any defined contribution plan. "]
[]
[]
["14.","Please provide a copy of your privacy policy that restricts sharing information with third parties.  Please provide the names of parties that you share information with that do not provide direct services to the plan(s) covered by this RFP here."]
[]
[]
["15.","Please provide a copy of your firms Cyber Security Guarantee."]

{"sheet":"Firm Experience and Qualificat.","index":9,"n_rows":168,"n_cols":5,"rows_kept":168,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[6,2,6,4],[6,5,6,7],[6,8,6,10],[8,1,10,1],[8,2,10,4],[12,1,14,1],[12,2,14,4],[38,0,38,10],[39,0,39,10],[40,0,40,10],[44,2,44,4],[76,0,76,10],[77,0,77,10],[78,0,78,10],[82,2,82,4],[85,2,87,2],[85,3,87,3],[85,4,87,4],[95,2,97,2],[95,3,97,3],[95,4,97,4],[114,0,114,10],[115,0,115,10],[116,0,116,10],[120,2,120,4],[123,2,123,4],[124,2,124,4],[125,2,125,4],[126,1,127,1],[126,2,127,4],[128,2,128,4],[129,2,129,4],[130,2,130,4],[131,2,131,4],[132,2,132,4],[133,2,133,4],[136,2,136,4],[137,2,137,4],[138,2,138,4],[139,1,140,1],[139,2,140,4],[141,2,141,4],[142,2,142,4],[143,2,143,4],[144,2,144,4],[145,2,145,4],[146,2,146,4],[152,0,152,10],[153,0,153,10],[154,0,154,10],[158,2,158,4],[158,5,158,7],[158,8,158,10],[160,1,161,1],[160,2,161,4],[162,2,162,4],[163,2,163,4],[164,2,164,4],[165,2,165,4],[166,2,166,4],[167,2,167,4]]}
[{"$f":"TOC!A1","v":"Indian River County RFP 2022040"}]
[{"$f":"TOC!A17","v":"Firm Experience and Qualifications"}]
[{"$f":"TOC!B7","v":0}]
[]
[{"$f":"A2","v":"Firm Experience and Qualifications"}]
[]
[null,null,"Recordkeeper"]
[]
["1.","What are the total number of defined contribution participants that are on your recordkeeping system?"]
[]
[]
[]
["2.","What are the total assets of defined contribution participants on your recordkeeping system?"]
[]
[]
[]
["3.","What is the breakdown of the number of plans you service by plan type and as a percentage of your total business as of 12/31/2021?  "]
[null,"Type","# of plans","% of plans"]
[null,"401(k):"]
[null,"457(b):"]
[null,"401(a):"]
[null,"403(b):"]
[null,"Taft-Hartley:"]
[null,"Total:",{"$f":"SUM(C19:C23)","v":0},{"$f":"SUM(D19:D23)","v":{"v":0,"d":"0.0%"}}]
[]
["4.","Please provide a summary of Defined Contribution plans in the tables below as of 12/31/2021:"]
[null,"Number of Employees","# of plans","% of plans"]
[null,"Under 100:"]
[null,"100-499:"]
[null,"500-999:"]
[null,"1,000-4,999:"]
[null,"Over 5,000:"]
[null,"Total:",{"$f":"SUM(C28:C32)","v":0},{"$f":"SUM(D28:D32)","v":{"v":0,"d":"0.0%"}}]
[]
[]
[]
[]
[]
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Firm Experience and Qualifications"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A40","v":"Firm Experience and Qualifications"}]
[]
[null,null,{"$f":"C7","v":"Recordkeeper"}]
[]
["4.","Assets (in millions)","# of plans","% of plans"]
[null,"$0-$10M:"]
[null,"$10-$25M:"]
[null,"$25-$100M:"]
[null,"$100-$250M:"]
[null,"$250-$500M:"]
[null,"$500M+:"]
[null,"Total:",{"$f":"SUM(C48:C53)","v":0},{"$f":"SUM(D48:D53)","v":{"v":0,"d":"0.0%"}}]
[]
["5.","Please provide a summary of Governmental 457(b) plans in the tables below as of 12/31/2021:"]
[null,"Number of Employees","# of plans","% of plans"]
[null,"Under 100:"]
[null,"100-499:"]
[null,"500-999:"]
[null,"1,000-4,999:"]
[null,"Over 5,000:"]
[null,"Total:",{"$f":"SUM(C58:C62)","v":0},{"$f":"SUM(D58:D62)","v":{"v":0,"d":"0.0%"}}]
[]
["5.","Assets (in millions)","# of plans","% of plans"]
[null,"$0-$10M:"]
[null,"$10-$25M:"]
[null,"$25-$100M:"]
[null,"$100-$250M:"]
[null,"$250-$500M:"]
[null,"$500M+:"]
[null,"Total:",{"$f":"SUM(C66:C71)","v":0},{"$f":"SUM(D66:D71)","v":{"v":0,"d":"0.0%"}}]
[]
[]
[]
[]
[{"$f":"A39","v":"Indian River County RFP 2022040"}]
[{"$f":"A40","v":"Firm Experience and Qualifications"}]
[{"$f":"A41","v":0}]
[]
[{"$f":"A78","v":"Firm Experience and Qualifications"}]
[]
[null,null,{"$f":"C45","v":"Recordkeeper"}]
[]
["6.","For the 5-year period ending December 31, 2021, complete the following table for your Defined Contribution Clients:\n"]
[null,"Year","# of Clients Gained","# of Clients Lost","Annual Retention Rate"]
[]
[]
[null,2021]
[null,2020]
[null,2019]
[null,2018]
[null,2017]
[]
["7.","For the 5-year period ending December 31, 2021, complete the following table for your Governmental 457(b) Clients:\n"]
[null,"Year","# of Clients Gained","# of Clients Lost","Annual Retention Rate"]
[]
[]
[null,2021]
[null,2020]
[null,2019]
[null,2018]
[null,2017]
{"$rows_empty":11}
[{"$f":"A77","v":"Indian River County RFP 2022040"}]
[{"$f":"A78","v":"Firm Experience and Qualifications"}]
[{"$f":"A79","v":0}]
[]
[{"$f":"A116","v":"Firm Experience and Qualifications"}]
[]
[null,null,{"$f":"C83","v":"Recordkeeper"}]
[]
["8.","Please list the number of people your firm employs in the following functional areas:"]
[null,"Functional Area","Number of Employees"]
[null,"Plan Recordkeeping/Administration:"]
[null,"Client Services:"]
[null,"Participant Education & Communications:"]
[]
[null,"Compliance, Legal, & Regulatory:"]
[null,"Participant Call Center:"]
[null,"IT Systems:"]
[null,"Implementation and Conversion:"]
[null,"Other:"]
[null,"Total:",{"$f":"SUM(C125:E133)","v":0}]
[]
["9.","Please list the number of people your firm employs in the following functional areas that serve Governmental 457(b) Clients:"]
[null,"Functional Area","Number of Employees"]
[null,"Plan Recordkeeping/Administration:"]
[null,"Client Services:"]
[null,"Participant Education & Communications:"]
[]
[null,"Compliance, Legal, & Regulatory:"]
[null,"Participant Call Center:"]
[null,"IT Systems:"]
[null,"Implementation and Conversion:"]
[null,"Other:"]
[null,"Total:",{"$f":"SUM(C138:E146)","v":0}]
[]
[]
[]
[]
[]
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Firm Experience and Qualifications"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A5","v":"Firm Experience and Qualifications"}]
[]
[null,null,{"$f":"C121","v":"Recordkeeper"}]
[]
["10.","Please provide the following sources of revenue by a % of your total revenue.","Percentage (%)"]
[]
[null,"Recordkeeping Fees:"]
[null,"Participant Transactional Fees:"]
[null,"Investment Fees:"]
[null,"Managed Accounts:"]
[null,"Proprietary Investments:"]
[null,"Total:",{"$f":"SUM(C163:E167)","v":{"v":0,"d":"0%"}}]

{"sheet":"Assigned Service Team Exp.","index":10,"n_rows":123,"n_cols":3,"rows_kept":123,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[8,1,8,4],[14,1,19,1],[14,2,19,2],[21,1,23,1],[21,2,23,2],[25,1,28,1],[25,2,28,2],[30,1,34,1],[30,2,34,2],[38,0,38,4],[39,0,39,4],[40,0,40,4],[46,1,46,4],[52,1,57,1],[52,2,57,2],[59,1,61,1],[59,2,61,2],[63,1,66,1],[63,2,66,2],[68,1,72,1],[68,2,72,2],[76,0,76,4],[77,0,77,4],[78,0,78,4],[84,1,84,4],[90,1,95,1],[90,2,95,2],[97,1,99,1],[97,2,99,2],[101,1,104,1],[101,2,104,2],[106,1,110,1],[106,2,110,2],[114,0,114,4],[115,0,115,4],[116,0,116,4],[122,1,131,1],[122,2,131,2]]}
[{"$f":"TOC!A1","v":"Indian River County RFP 2022040"}]
[{"$f":"TOC!A18","v":"Assigned Service Team Experience"}]
[{"$f":"TOC!B7","v":0}]
[]
[{"$f":"A2","v":"Assigned Service Team Experience"}]
[]
[null,null,{"$f":"'Firm Experience and Qualificat.'!C7","v":"Recordkeeper"}]
[]
["1.","Please provide the information below for the appropriate team members who will be assigned to this relationship."]
[]
[null,"Relationship Manager (Primary Contact):"]
[null,"Firm tenure:"]
[null,"Industry tenure:"]
[null,"Location:"]
[null,"Applicable designations, licenses, and education:"]
[]
[]
[]
[]
[]
[]
[null,"How many clients are currently managed by the proposed Relationship Manager?"]
[]
[]
[]
[null,"Will the Relationship Manager receive compensation based on moving participant assets to proprietary products or services? (Yes/No)"]
[]
[]
[]
[]
[null,"If your firm responded \"Yes\" to the prior question, what are the sales targets and compensation?"]
{"$rows_empty":7}
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Assigned Service Team Experience"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A5","v":"Assigned Service Team Experience"}]
[]
[null,null,{"$f":"C7","v":"Recordkeeper"}]
[]
["2.","Please provide the information below for the appropriate team members who will be assigned to this relationship."]
[]
[null,"Account Manager (Internal Contact):"]
[null,"Firm tenure:"]
[null,"Industry tenure:"]
[null,"Location:"]
[null,"Applicable designations, licenses, and education:"]
[]
[]
[]
[]
[]
[]
[null,"How many clients are currently managed by the proposed Account Manager?"]
[]
[]
[]
[null,"Will the Account Manager receive compensation based on moving participant assets to proprietary products or services? (Yes/No)"]
[]
[]
[]
[]
[null,"If your firm responded \"Yes\" to the prior question, what are the sales targets and compensation?"]
{"$rows_empty":7}
[{"$f":"A39","v":"Indian River County RFP 2022040"}]
[{"$f":"A40","v":"Assigned Service Team Experience"}]
[{"$f":"A41","v":0}]
[]
[{"$f":"A43","v":"Assigned Service Team Experience"}]
[]
[null,null,{"$f":"C45","v":"Recordkeeper"}]
[]
["3.","Please provide the information below for the appropriate team members who will be assigned to this relationship."]
[]
[null,"Education Representative:"]
[null,"Firm tenure:"]
[null,"Industry tenure:"]
[null,"Location:"]
[null,"Applicable designations, licenses, and education:"]
[]
[]
[]
[]
[]
[]
[null,"How many clients are currently managed by the proposed Educational Representative?"]
[]
[]
[]
[null,"Will the Educational Representative receive compensation based on moving participant assets to proprietary products or services? (Yes/No)"]
[]
[]
[]
[]
[null,"If your firm responded \"Yes\" to the prior question, what are the sales targets and compensation?"]
{"$rows_empty":7}
[{"$f":"A77","v":"Indian River County RFP 2022040"}]
[{"$f":"A78","v":"Assigned Service Team Experience"}]
[{"$f":"A79","v":0}]
[]
[{"$f":"A81","v":"Assigned Service Team Experience"}]
[]
[null,null,{"$f":"C83","v":"Recordkeeper"}]
[]
["4.","Are your education specialists employed solely by your firm? If no, please provide details."]

{"sheet":"Plan Sponsor Services","index":11,"n_rows":59,"n_cols":3,"rows_kept":59,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[8,1,9,1],[10,1,11,1],[10,2,11,2],[16,1,18,1],[16,2,18,2],[20,1,21,1],[20,2,21,2],[23,1,27,1],[23,2,27,2],[29,1,32,1],[29,2,32,2],[38,0,38,4],[39,0,39,4],[40,0,40,4],[52,1,53,1],[52,2,53,2],[54,1,55,1],[54,2,55,2]]}
[{"$f":"TOC!A1","v":"Indian River County RFP 2022040"}]
[{"$f":"TOC!A19","v":"Plan Sponsor Services"}]
[{"$f":"TOC!B7","v":0}]
[]
[{"$f":"A2","v":"Plan Sponsor Services"}]
[]
[null,null,{"$f":"'Assigned Service Team Exp.'!C7","v":"Recordkeeper"}]
[]
["1.","Provide a link to a demo plan sponsor website with login and password."]
[]
[null,"Website:"]
[]
[null,"Login:"]
[null,"Password:"]
[null,"Security Codes:"]
[]
["2.","Can plan sponsor web portal access be managed and administered by the plan sponsor?"]
[]
[]
[]
["3.","Can your firm assume the administration of existing loans?"]
[]
[]
["4.","While we do not foresee the need for a custom plan document at this time, in the future is your firm willing and able to draft a custom plan document? If so, what are the additional related costs? "]
[]
[]
[]
[]
[]
["5.","What is the maximum amount of money your company is willing to put at risk for service guarantees? Please include an attachment for specific guarantees."]
{"$rows_empty":8}
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Plan Sponsor Services"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A5","v":"Plan Sponsor Services"}]
[]
[null,null,{"$f":"C7","v":"Recordkeeper"}]
[]
["6.","Please confirm that the Plan Sponsor can outsource the following services. (Y/N)"]
[null,"Service","(Y/N)"]
[null,"Approve outgoing rollover distributions:"]
[null,"Approve incoming rollover contributions:"]
[null,"DRO determination:"]
[null,"QDRO approval and processing:"]
[null,"Approve in-service non-hardship withdrawal approvals:"]
[]
[null,"Approve of in-service hardship withdrawal approvals:"]
[]
[null,"Approve unforeseeable emergency: withdrawals:"]
[null,"Process Loan repayment via payroll:"]
[null,"Process Loan repayment via ACH:"]

{"sheet":"Participant Services, Experien.","index":12,"n_rows":99,"n_cols":4,"rows_kept":99,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[6,2,6,3],[8,1,9,1],[10,1,11,1],[10,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[16,1,18,1],[16,2,18,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,1,25,1],[24,2,25,3],[27,1,30,1],[27,2,30,3],[32,1,34,1],[32,2,34,3],[38,0,38,7],[39,0,39,7],[40,0,40,7],[44,2,44,3],[51,1,53,1],[51,2,53,2],[51,3,53,3],[54,1,55,1],[54,2,55,2],[54,3,55,3],[56,1,57,1],[56,2,57,2],[56,3,57,3],[56,4,57,4],[60,1,61,1],[60,2,61,2],[60,3,61,3],[63,1,64,1],[63,2,64,2],[63,3,64,3],[65,1,66,1],[65,2,66,2],[65,3,66,3],[70,1,72,1],[70,2,72,2],[70,3,72,3],[76,0,76,7],[77,0,77,7],[78,0,78,7],[82,2,82,3],[94,2,94,3],[96,2,96,3]]}
[{"$f":"TOC!A1","v":"Indian River County RFP 2022040"}]
[{"$f":"TOC!A20","v":"Participant Services and Education"}]
[{"$f":"TOC!B7","v":0}]
[]
[{"$f":"A2","v":"Participant Services and Education"}]
[]
[null,null,{"$f":"'Plan Sponsor Services'!C7","v":"Recordkeeper"}]
[]
["1.","Provide instructions for accessing a participant web demo."]
[]
[null,"Website:"]
[]
[null,"User name:"]
[null,"Password:"]
[null,"Security Code:"]
[]
["2.","List the hours where live operator assistance is available through your Call Center. Please specify the Time Zone. "]
[]
[]
[]
["3.","Indicate the percentage of abandoned calls to the Call Center:"]
[null,"a. From 1/1/21 through 12/31/21:"]
[null,"b. From 1/1/20 through 12/31/20:"]
[null,"c. From 1/1/19 through 12/31/19:"]
[null,"d. Quarterly average from 1/1/19 through 12/31/21:"]
[]
[]
["4.","If call center related issues occur, are you able to share a transcript or digital recording of the call with the client to address quality control issues? (Y/N)"]
[]
[]
[]
[]
["5.","Are your call center representatives licensed? (Y/N)  If so, what license do they carry?"]
[]
[]
[]
[]
[]
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Participant Services and Education"}]
[{"$f":"A3","v":"00:00:00"}]
[]
[{"$f":"A40","v":"Participant Services and Education"}]
[]
[null,null,{"$f":"C7","v":"Recordkeeper"}]
[]
["6.","Confirm the Participant can complete the following services or access the information through the Participant web portal or application: (Y/N)"]
[null,"Participant Services","Website","Mobile App"]
[null,"Enroll or activate account:"]
[null,"Change contribution percentage/hard dollar:"]
[null,"Change allocation of future contributions:"]
[null,"Select specific payroll period to implement future contribution changes:"]
[]
[]
[null,"Request an in-service non-hardship withdrawal:"]
[]
[null,"Request a hardship withdrawal or unforeseeable emergency withdrawal:"]
[]
[null,"Request a withdrawal/distribution:"]
[null,"Customized distribution schedule(s):"]
[null,"View Vesting percentage:"]
[]
[null,"Obtain statements as of quarter end:"]
[null,"Determine personal rates of return for standard time periods:"]
[]
[null,"Determine personal rates of return for customized time periods:"]
[]
[null,"Change personal address on record:"]
[null,"Change beneficiary information:"]
[null,"Elect automatic rebalancing of account:"]
[null,"Select different automatic rebalancing frequencies (monthly, quarterly, annually):"]
[]
[]
[]
[]
[]
[{"$f":"A39","v":"Indian River County RFP 2022040"}]
[{"$f":"A40","v":"Participant Services and Education"}]
[{"$f":"A41","v":0}]
[]
[{"$f":"A78","v":"Participant Services and Education"}]
[]
[null,null,{"$f":"C45","v":"Recordkeeper"}]
[]
["6.","Confirm the Participant can complete the following services or access the information through the Participant web portal or application: (Y/N)"]
[null,"Participant Services","Website","Mobile App"]
[null,"Review fund descriptions:"]
[null,"Review fund prospectuses:"]
[null,"Review historical fund performance:"]
[null,"Receive general investment education:"]
[null,"Receive personalized investment advice:"]
[null,"Submit an informational request:"]
[null,"Download transactional history (Quicken, excel, other formats):"]
[]
["7.","Who is the Managed account provider?"]
[]
["8.","Who is the custodian of the SDBA?"]
[]
["9.","Does your firm limit the amount that the Participant can direct into and out of their SDBA? (Y/N)"]

{"sheet":"Recordkeeping Systems","index":13,"n_rows":143,"n_cols":3,"rows_kept":143,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[8,1,10,1],[8,2,10,2],[12,1,15,1],[12,2,15,2],[17,1,20,1],[17,2,20,2],[22,1,26,1],[22,2,26,2],[28,1,33,1],[28,2,33,2],[38,0,38,4],[39,0,39,4],[40,0,40,4],[46,1,50,1],[46,2,50,2],[52,1,55,1],[52,2,55,2],[57,1,59,1],[57,2,59,2],[61,1,63,1],[61,2,63,2],[65,1,67,1],[65,2,67,2],[69,1,71,1],[69,2,71,2],[76,0,76,4],[77,0,77,4],[78,0,78,4],[84,1,85,1],[87,1,88,1],[87,2,88,2],[89,1,90,1],[89,2,90,2],[91,1,92,1],[91,2,92,2],[93,1,94,1],[93,2,94,2],[96,1,97,1],[96,2,97,2],[99,1,100,1],[99,2,100,2],[102,1,106,1],[102,2,106,2],[108,1,109,1],[108,2,109,2],[114,0,114,4],[115,0,115,4],[116,0,116,4],[122,1,123,1],[122,2,123,2],[125,1,127,1],[125,2,127,2],[129,1,130,1],[129,2,130,2],[132,1,135,1],[132,2,135,2],[137,1,140,1],[137,2,140,2],[142,1,145,1],[142,2,145,2]]}
[{"$f":"TOC!A1","v":"Indian River County RFP 2022040"}]
[{"$f":"TOC!A21","v":"Recordkeeping Systems"}]
[{"$f":"TOC!B7","v":0}]
[]
[{"$f":"A2","v":"Recordkeeping Systems"}]
[]
[null,null,{"$f":"'Participant Services, Experien.'!C7","v":"Recordkeeper"}]
[]
["1.","Do you own or lease your recordkeeping platform?"]
[]
[]
[]
["2.","What is the current version of the platform?"]
[]
[]
[]
[]
["3.","Does your company plan to implement or convert to a new recordkeeping platform in the next 24 months?"]
[]
[]
[]
[]
["4.","If applicable, when do you expect to convert to the recordkeeping system?"]
[]
[]
[]
[]
[]
["5.","If applicable, how long will the conversion last? Please provide a timeline under the Attachments section # 10, if applicable."]
{"$rows_empty":9}
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Recordkeeping Systems"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A40","v":"Recordkeeping Systems"}]
[]
[null,null,{"$f":"C7","v":"Recordkeeper"}]
[]
["6.","Who holds the ultimate authority or responsibility to ensure the recordkeeping system remain current to laws, regulations, client needs, etc.?"]
[]
[]
[]
[]
[]
["7.","Does your system allow clients to rebate revenue sharing back to the participants invested in the specific funds that generate the revenue sharing? "]
[]
[]
[]
[]
["8.","Can your system waive fees for participant accounts under a certain account balance?"]
[]
[]
[]
["9.","How many of your plans have fee structures that waive fees for accounts under a threshold?"]
[]
[]
[]
["10.","Can your system cap fees for participant accounts over a certain account balance?"]
[]
[]
[]
["11.","How many of you plans have fee structures that cap fees over a certain threshold?"]
[]
[]
[]
[]
[]
[]
[{"$f":"A39","v":"Indian River County RFP 2022040"}]
[{"$f":"A40","v":"Recordkeeping Systems"}]
[{"$f":"A41","v":0}]
[]
[{"$f":"A43","v":"Recordkeeping Systems"}]
[]
[null,null,{"$f":"C45","v":"Recordkeeper"}]
[]
["12.","Is your system able to administer the following fee policies? (Yes or No)"]
[]
[]
[null,"a. Charged Per Capita (Everyone pays the same $ amount)"]
[]
[null,"b. Charged Pro Rata (Everyone pays the same % of their account)"]
[]
[null,"c. Asset based fees (%) on the participant account"]
[]
[null,"d. Hybrid fee policies ($+%)"]
[]
[]
["13.","Does your firm have a current SOC 1 Report?"]
[]
[]
["14.","Does your firm have a current SOC 2 Report?"]
[]
[]
["15.","Are all personnel who encounter with personally identifiable information trained on adequate protection of the information?"]
[]
[]
[]
[]
[]
["16.","How often is data security training required? "]
[]
[]
[]
[]
[]
[{"$f":"A77","v":"Indian River County RFP 2022040"}]
[{"$f":"A78","v":"Recordkeeping Systems"}]
[{"$f":"A79","v":0}]
[]
[{"$f":"A81","v":"Recordkeeping Systems"}]
[]
[null,null,{"$f":"C83","v":"Recordkeeper"}]
[]
["17.","Do you have a Chief Information Security Officer or equivalent?"]
[]
[]
["18.","Do you require participant and plan sponsor internet users to reset their password? If so, on what frequency?"]
[]
[]
[]
["19.","Do you offer multifactor authentication for Participants and Plan Sponsors?"]
[]
[]
["20.","What is your firms Cyber Security Guarantee and how much per participant will it cover? (This is requested in the Attachments section # 15)"]
[]
[]
[]
[]
["21.","Confirm your ability to offer each of the funds currently in the investment lineup. Note any exceptions."]
[]
[]
[]
[]
["22.","Are your systems able to extract fees for participants that take a full distribution in the middle of a billing cycle?"]

{"sheet":"Transition and Implementation","index":14,"n_rows":52,"n_cols":3,"rows_kept":52,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[8,1,8,4],[16,1,18,1],[16,2,18,2],[20,1,22,1],[20,2,22,2],[24,1,27,1],[24,2,27,2],[35,0,35,4],[36,0,36,4],[37,0,37,4],[43,1,45,1],[43,2,45,2],[47,1,49,1],[47,2,49,2],[51,1,53,1],[51,2,53,2]]}
[{"$f":"TOC!A1","v":"Indian River County RFP 2022040"}]
[{"$f":"TOC!A22","v":"Transition and Implementation"}]
[{"$f":"TOC!B7","v":0}]
[]
[{"$f":"A2","v":"Transition and Implementation"}]
[]
[null,null,{"$f":"'Recordkeeping Systems'!C7","v":"Recordkeeper"}]
[]
["1.","Please provide the information below for the Transition Manager who will be assigned to this relationship."]
[]
[null,"Transition Manager:"]
[null,"Firm tenure:"]
[null,"Industry tenure:"]
[null,"Location:"]
[null,"Applicable designations, licenses, and education:"]
[]
[null,"How many clients are currently managed by the proposed Transition Manager?"]
[]
[]
[]
[null,"What percent of the Transition Manager’s time would be available to service the Client?"]
[]
[]
[]
[null,"Will the Transition Manager receive compensation based on moving participant assets to proprietary products or services? (Yes/No)"]
{"$rows_empty":10}
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Transition and Implementation"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A5","v":"Transition and Implementation"}]
[]
[null,null,{"$f":"C7","v":"Recordkeeper"}]
[]
["2.","How many other transitions would the Implementation Lead be involved with during our transition?"]
[]
[]
[]
["3.","How many transitions in the past three years has your firm completed from the incumbent?"]
[]
[]
[]
["4.","Can your firm handle transitions with investments being transferred in-kind?"]

{"sheet":"Plan Fee-Expense","index":15,"n_rows":108,"n_cols":5,"rows_kept":108,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[8,1,12,3],[8,4,12,4],[14,1,17,3],[14,4,17,4],[19,1,21,3],[19,4,21,4],[23,1,23,6],[38,0,38,6],[39,0,39,6],[40,0,40,6],[46,1,46,6],[66,1,72,3],[66,4,72,4],[76,0,76,6],[77,0,77,6],[78,0,78,6],[84,1,85,3],[84,4,85,4],[87,1,90,3],[87,4,90,4],[94,1,94,3],[95,1,95,3],[96,1,96,3],[97,1,97,3],[98,1,98,3],[99,1,99,3],[100,1,100,3],[101,1,101,3],[102,1,102,3],[103,1,104,3],[103,4,104,4],[105,1,105,3],[106,1,106,3],[107,1,107,3]]}
[{"$f":"TOC!A1","v":"Indian River County RFP 2022040"}]
[{"$f":"TOC!A23","v":"Plan Fees/Expenses"}]
[{"$f":"TOC!B7","v":0}]
[]
[{"$f":"A2","v":"Plan Fees/Expenses"}]
[]
[{"$nulls":4},{"$f":"'Transition and Implementation'!C7","v":"Recordkeeper"}]
[]
["1.","Confirm your quoted pricing is not contingent on a vendor fund mapping strategy or reliant on proprietary products or services and that your platform is open architecture."]
[]
[]
[]
[]
[]
["2.","Confirm there are no termination/liquidation costs if the Plan moved to a new recordkeeper/administrator."]
[]
[]
[]
[]
["3.","Confirm that your proposal does not include any start-up or conversion costs."]
[]
[]
[]
["4.","Recordkeeping Fee (as a % of Plan Assets) - Open Investment Architecture with 4 days of annual onsite education:"]
[null,"Plan Type","Assets ($)","Participants (#)","Fee"]
[null,"BOCC",{"v":37839867,"d":"$37,839,867"},555]
[null,"CoC",{"v":4308536,"d":"$4,308,536"},63]
[null,"PA",{"v":2167376,"d":"$2,167,376"},36]
[null,"SoE",{"v":489842,"d":"$489,842"},6]
[null,"TC",{"v":1077811,"d":"$1,077,811"},42]
[]
[null,"Total",{"$f":"SUM(C26:C30)","v":{"v":45883432,"d":"$45,883,432"}},{"$f":"SUM(D26:D30)","v":702}]
[]
[]
[]
[]
[]
[]
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Plan Fees/Expenses"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A5","v":"Plan Fees/Expenses"}]
[]
[{"$nulls":4},{"$f":"E7","v":"Recordkeeper"}]
[]
["5.","Recordkeeping Fee ($ per participant) - Open Investment Architecture with 4 days of annual onsite education:"]
[null,"Plan Type","Assets ($)","Participants (#)","Fee"]
[null,"BOCC",{"v":37839867,"d":"$37,839,867"},555]
[null,"CoC",{"v":4308536,"d":"$4,308,536"},63]
[null,"PA",{"v":2167376,"d":"$2,167,376"},36]
[null,"SoE",{"v":489842,"d":"$489,842"},6]
[null,"TC",{"v":1077811,"d":"$1,077,811"},42]
[]
[null,"Total",{"$f":"SUM(C49:C54)","v":{"v":45883432,"d":"$45,883,432"}},{"$f":"SUM(D49:D53)","v":702},{"$f":"SUM(E49:E53)","v":{"v":0,"d":"$0"}}]
[]
["6.","Please provide Loan Fees:",null,null,"$"]
[null,"New Loans:",21,"Start up Fee:"]
[null,"Total Loans:",63,"Annual Fee:"]
[null,"Total",{"$f":"C59","v":63},null,{"$f":"(E59*C59)+(E58*C58)","v":{"v":0,"d":"$0"}}]
[]
["7.","Please provide Self Directed Brokerage Fees:",null,null,"$"]
[null,"# of Accounts:",356,"Startup Fee:"]
[{"$nulls":3},"Annual Fee:"]
[null,"Total",{"$f":"C63","v":356},null,{"$f":"(E64*C63)","v":{"v":0,"d":"$0"}}]
[]
["8.","Please provide the fee schedule for the Managed Account Services. "]
{"$rows_empty":9}
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Plan Fees/Expenses"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A5","v":"Plan Fees/Expenses"}]
[]
[{"$nulls":4},{"$f":"E45","v":"Recordkeeper"}]
[]
["9.","Will your firm guarantee your fees quoted for the duration of the client contract? (Yes/No)"]
[]
[]
["10.","How many times can the Plan Sponsor make changes to the investment lineup each year without incurring additional fees? What are the additional fees, if any? "]
[]
[]
[]
[]
["11.","Outline any fee ($) assessed on a per participant basis, including but not limited to:"]
[null,"Service",null,null,"$"]
[null,"In-service withdrawal payment:"]
[null,"Distribution event payment:"]
[null,"QDRO Approval:"]
[null,"Hardship withdrawal:"]
[null,"Wire transfer:"]
[null,"Trustee services fees:"]
[null,"Form 1099R or other tax reporting fees:"]
[null,"Return of excess contributions (annual):"]
[null,"Contribution processing:"]
[null,"Plan document (including updates for regulatory changes):"]
[]
[null,"Onsite meeting day:"]
[null,"Webcast:"]
[null,"Hourly charge for special services:"]

{"sheet":"Proprietary Options","index":16,"n_rows":69,"n_cols":3,"rows_kept":69,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[8,0,9,4],[13,1,15,1],[13,2,15,2],[21,1,22,1],[21,2,22,2],[24,0,25,4],[27,1,28,1],[27,2,28,2],[32,1,33,1],[32,2,33,2],[38,0,38,4],[39,0,39,4],[40,0,40,4],[46,0,47,4],[58,1,59,1],[61,0,62,4]]}
[{"$f":"TOC!A1","v":"Indian River County RFP 2022040"}]
[{"$f":"TOC!A24","v":"Propreitary Products and Services"}]
[{"$f":"TOC!B7","v":0}]
[]
[{"$f":"A2","v":"Propreitary Products and Services"}]
[]
[null,null,{"$f":"'Plan Fee-Expense'!E7","v":"Recordkeeper"}]
[]
["Please provide your firms recommended proprietary option to replace the current General Account, Stable Value, or Money Market Funds. Please note this is for informational purposes only and does not guarantee the funds will be placed into the investment menu."]
[]
[]
["1.","General Account/Stable Value:"]
[]
[null,"Please indicate the exit provision(s): Market Value Adjustment, 12 Month Put, and/or 5 Year Distribution"]
[]
[]
[]
[null,"Current Crediting Rate:"]
[]
[null,"Product Fee for Stable Value:"]
[]
[null,"Adjusted Recordkeeping Fee (% of Plan Assets):"]
[]
[]
["Please provide your firms recommended proprietary option to replace the current Target Date Funds. Please note this is for informational purposes only and does not guarantee the funds will be placed into the investment menu."]
[]
[]
["2.","Target Date Funds:"]
[]
[]
[null,"Product Fee:"]
[]
[null,"Adjusted Recordkeeping Fee (% of Plan Assets):"]
[]
[]
[]
[]
[]
[{"$f":"A1","v":"Indian River County RFP 2022040"}]
[{"$f":"A2","v":"Propreitary Products and Services"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A5","v":"Propreitary Products and Services"}]
[]
[null,null,"Recordkeeper Response"]
[]
["Please provide your firms recommended proprietary option to for Managed Account Services. Please note this is for informational purposes only and does not guarantee the service will be placed into the Plan."]
[]
[]
["3.","Managed Accounts:"]
[]
[null,"Service Fee Schedule:"]
[]
[]
[]
[]
[]
[]
[null,"Adjusted Recordkeeping Fee (% of Plan Assets):"]
[]
[]
["Please provide your firms recommended proprietary option to replace other Funds. Please note this is for informational purposes only and does not guarantee the funds will be placed into the investment menu."]
[]
[]
["4.","Other Fund Options:"]
[]
[null,"Product Fee:"]
[]
[null,"Adjusted Recordkeeping Fee:"]

{"sheet":"References","index":17,"n_rows":145,"n_cols":3,"rows_kept":145,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[6,0,8,4],[30,1,34,1],[30,2,34,2],[38,0,38,4],[39,0,39,4],[40,0,40,4],[44,0,46,4],[68,1,72,1],[68,2,72,2],[76,0,76,4],[77,0,77,4],[78,0,78,4],[82,0,84,4],[106,1,110,1],[106,2,110,2],[114,0,114,4],[115,0,115,4],[116,0,116,4],[120,0,122,4],[144,1,148,1],[144,2,148,2]]}
[{"$f":"[1]ToC!A1","v":"Indian River County DC Plans - Request for Proposal"}]
[{"$f":"[1]ToC!A22","v":"References"}]
[{"$f":"TOC!B7","v":0}]
[]
[{"$f":"A2","v":"References"}]
[]
["Provide a listing of three current full-service client references that are similar to this client. At least two of the references must be clients managed by the Relationship Manager who would be assigned to this Client. Please submit one reference for a client that terminated your services for reasons other than mergers and acquisitions. Proposer must complete the reference form provided below for each client. "]
[]
[]
[]
[null,null,{"$f":"'[1]Proprietary Options'!C7","v":"Recordkeeper"}]
[]
["1.","Company/Institution Name"]
[]
[null,"Address"]
[]
[null,"Contact Person"]
[]
[null,"Phone Number of Contact"]
[]
[null,"Email of Contact"]
[]
[null,"# of Years as a client"]
[]
[null,"Plan Size: "]
[null,"Assets"]
[null,"Plan Participants"]
[]
[null,"Geographic Location"]
[]
[null,"Services Provided"]
{"$rows_empty":7}
[{"$f":"A1","v":"Indian River County DC Plans - Request for Proposal"}]
[{"$f":"A2","v":"References"}]
[{"$f":"A3","v":0}]
[]
[{"$f":"A5","v":"References"}]
[]
[{"$f":"A7","v":"Provide a listing of three current full-service client references that are similar to this client. At least two of the references must be clients managed by the Relationship Manager who would be assigned to this Client. Please submit one reference for a client that terminated your services for reasons other than mergers and acquisitions. Proposer must complete the reference form provided below for each client. "}]
[]
[]
[]
[null,null,{"$f":"C11","v":"Recordkeeper"}]
[]
["2.","Company/Institution Name"]
[]
[null,"Address"]
[]
[null,"Contact Person"]
[]
[null,"Phone Number of Contact"]
[]
[null,"Email of Contact"]
[]
[null,"# of Years as a client"]
[]
[null,"Plan Size: "]
[null,"Assets"]
[null,"Plan Participants"]
[]
[null,"Geographic Location"]
[]
[null,"Services Provided"]
{"$rows_empty":7}
[{"$f":"A39","v":"Indian River County DC Plans - Request for Proposal"}]
[{"$f":"A40","v":"References"}]
[{"$f":"A41","v":0}]
[]
[{"$f":"A43","v":"References"}]
[]
[{"$f":"A45","v":"Provide a listing of three current full-service client references that are similar to this client. At least two of the references must be clients managed by the Relationship Manager who would be assigned to this Client. Please submit one reference for a client that terminated your services for reasons other than mergers and acquisitions. Proposer must complete the reference form provided below for each client. "}]
[]
[]
[]
[null,null,{"$f":"C49","v":"Recordkeeper"}]
[]
["3.","Company/Institution Name"]
[]
[null,"Address"]
[]
[null,"Contact Person"]
[]
[null,"Phone Number of Contact"]
[]
[null,"Email of Contact"]
[]
[null,"# of Years as a client"]
[]
[null,"Plan Size: "]
[null,"Assets"]
[null,"Plan Participants"]
[]
[null,"Geographic Location"]
[]
[null,"Services Provided"]
{"$rows_empty":7}
[{"$f":"A77","v":"Indian River County DC Plans - Request for Proposal"}]
[{"$f":"A78","v":"References"}]
[{"$f":"A79","v":0}]
[]
[{"$f":"A81","v":"References"}]
[]
[{"$f":"A83","v":"Provide a listing of three current full-service client references that are similar to this client. At least two of the references must be clients managed by the Relationship Manager who would be assigned to this Client. Please submit one reference for a client that terminated your services for reasons other than mergers and acquisitions. Proposer must complete the reference form provided below for each client. "}]
[]
[]
[]
[null,null,{"$f":"C87","v":"Recordkeeper"}]
[]
["4.","Company/Institution Name"]
[]
[null,"Address"]
[]
[null,"Contact Person"]
[]
[null,"Phone Number of Contact"]
[]
[null,"Email of Contact"]
[]
[null,"# of Years as a client"]
[]
[null,"Plan Size: "]
[null,"Assets"]
[null,"Plan Participants"]
[]
[null,"Geographic Location"]
[]
[null,"Services Provided"]

{"sheet":"Plan Costs","index":18,"n_rows":20,"n_cols":11,"rows_kept":20,"hidden":true,"merged":[[19,0,19,10]]}
[]
["Plan Costs"]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Principal preservation fees"]
["Investment costs excluding principal preservation fund"]
[]
["Admin fees (explicit or wrap)",{"$f":"-#REF!","v":{"$error":"#REF!"}},{"$f":"-(#REF!-#REF!)","v":{"$error":"#REF!"}},{"$f":"-233926-18291+#REF!","v":{"$error":"#REF!"}},{"$f":"-#REF!","v":{"$error":"#REF!"}},{"$f":"-#REF!","v":{"$error":"#REF!"}},{"$f":"-#REF!","v":{"$error":"#REF!"}},{"$f":"-#REF!","v":{"$error":"#REF!"}},{"v":-89972,"d":"($89,972)"},{"$f":"-#REF!","v":{"$error":"#REF!"}},{"$f":"-K14-48505+#REF!","v":{"$error":"#REF!"}}]
["Trustee arrangements and associated fees",{"v":0,"d":"$0"},{"v":-850,"d":"($850)"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Other fees or compensation",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":-81627,"d":"($81,627)"},{"v":0,"d":"$0"},{"v":-179943,"d":"($179,943)"},{"v":0,"d":"$0"},{"v":-41506,"d":"($41,506)"}]
["   Total administration related fees ",{"$f":"B8+B9+B10","v":{"$error":"#REF!"}},{"$f":"C8+C9+C10","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"v":-269915,"d":"($269,915)"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["All Expenses, including 20 bp estimate for \"other\"","(*GA-$566,508)",{"$f":"-#REF!+C11+C5+C6","v":{"$error":"#REF!"}},{"$f":"-#REF!+D11+D5+D6","v":{"$error":"#REF!"}},{"$f":"-#REF!+E11+E5+E6","v":{"$error":"#REF!"}},{"$f":"-#REF!+F11+F5+F6","v":{"$error":"#REF!"}},{"$f":"-#REF!+G11+G5+G6","v":{"$error":"#REF!"}},{"$f":"-#REF!+H11+H5+H6","v":{"$error":"#REF!"}},{"$f":"-#REF!+I11+I5+I6","v":{"$error":"#REF!"}},{"$f":"-#REF!+J11+J5+J6","v":{"$error":"#REF!"}},{"$f":"-#REF!+K11+K5+K6","v":{"$error":"#REF!"}}]
["Administrative Fund Offsets",{"v":146326.68,"d":"$146,327"},{"v":171241.75,"d":"$171,242"},{"v":18291,"d":"$18,291"},{"v":263568.47,"d":"$263,568"},{"v":269640,"d":"$269,640"},{"v":299905.57,"d":"$299,906"},{"v":155656.25,"d":"$155,656"},{"v":0,"d":"$0"},{"v":125925.36,"d":"$125,925"},{"v":221634,"d":"$221,634"}]
[]
["Net Flow","(*GA-$420,181)",{"$f":"C13+C14","v":{"$error":"#REF!"}},{"$f":"D13+D14","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["SCORE"]
[]
["* As providers will not disclose expenses or estimates on the \"spread\" between the crediting rate under the contract and the investment return on the insurers' general account, it is difficult to understand whether the plan is being paid sufficiently for its risk in accepting liquidity restrictions, and generally what sort of revenue the insurance company expects to generate over time from the plan.  Notwithstanding insurer insolvency, there is risk in being locked into an investment that is not competitively priced relative to similar investments. It is a risk for which the plan should be properly paid. Where there is not adequate consideration for that risk, the plan's contract  needs to notify the plan of changing rates, and the ability to reasonably get out of the contract if the rates diminish.  From the fiduciary side, the plan should be paid for a long term interest rate risk. If there is insufficient return for that risk, then the contract purchased needs to provide liquidity.  When comparing to more typical GIC or money market funds, the undisclosed expense has been estimated between 1% and 2% industry-wide.  To place this in perspective, 1.5% of $30,434,381 is $456,516, 1% is $304,344, and .5% is $152,172."]

{"sheet":"Sample Scorecard","index":19,"n_rows":17,"n_cols":11,"rows_kept":17,"hidden":true,"merged":[[2,0,2,18],[19,0,20,17]]}
[]
[]
["Consolidated Scoring Matrix"]
[]
[null,"Vendor A","Vendor B","Vendor C","Vendor D","Vendor E","Vendor F","Vendor G","Vendor H","Vendor I","Vendor J"]
["General Questions",20,19,18,17,16,15,14,6,12,3]
["Team and Client Services",10,9,8,7,6,5,4,8,2,9]
["Employee Education",20,19,18,17,16,15,14,4,12,6]
["Operations",10,9,8,7,6,5,4,9,2,7]
["Implementation",20,20,1,2,20,4,5,15,7,1]
["Contact Center & Web",10,9,10,11,12,13,14,19,16,1]
["Recordkeeping System",20,18,19,20,20,2,3,7,5,2]
["Investments",10,20,8,9,10,11,12,6,14,8]
[]
["Average Provider Services",{"$f":"SUM(B6:B13)/8","v":{"v":15,"d":"15.0"}},{"v":15.375,"d":"15.4"},{"v":11.25,"d":"11.3"},{"v":11.25,"d":"11.3"},{"v":13.25,"d":"13.3"},{"v":8.75,"d":"8.8"},{"v":8.75,"d":"8.8"},{"v":9.25,"d":"9.3"},{"v":8.75,"d":"8.8"},{"v":4.625,"d":"4.6"}]
[]
["Plan Costs",1,10,3,8,5,6,7,4,9,2]

{"sheet":"Ind Scorecard","index":20,"n_rows":29,"n_cols":8,"rows_kept":29,"hidden":true,"merged":[[2,0,2,4],[4,0,4,7],[28,0,29,4]]}
["#"]
[]
["Individual Scorecard"]
[]
["Each committee member should take the time to review the proposals and score each section for each vendor following the scoring guidelines on page 5.  The Bogdahn Group will then collect the completed individual scorecards of each committee member and generate a consolidated average score for each vendor.  This process will help lead the discussion on selecting finalists, determining key areas of importance and will serve as documentation for the Committee per fiduciary best practices."]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Organization"]
["Statistics"]
["Client Services"]
["Employee Education"]
["Operations and Administration"]
["Implementation"]
["Contact Center and Web"]
["Recordkeeping System"]
["Recordkeeping and Administration Fees"]
{"$rows_empty":13}
["Name of committee member:"]