{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["PLAN","List"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":2,"defined_names":132,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PLAN","index":0,"n_rows":53,"n_cols":21,"rows_kept":53,"cut":false,"hidden":false,"merged":[[46,0,46,4],[46,5,46,8],[37,0,37,11],[36,0,36,11],[7,6,7,8],[11,6,11,8],[12,6,12,8],[10,6,10,8],[8,6,8,8],[9,6,9,8],[0,0,0,11],[2,1,2,3],[4,1,4,4],[34,0,34,11],[45,0,45,11],[24,0,24,11],[16,0,16,3],[16,4,16,5],[16,7,16,11],[5,6,6,11]]}
["2023 PRODUCTION COMMITMENT "]
[]
["     SE:","Melissa Westbrook"]
[]
["Agency:"," "]
[{"$nulls":6},"90 DAY REQUIREMENTS"]
["Year:",{"$f":"YEAR(TODAY())","v":2023},"State:","KS"]
[{"$nulls":6},"IntelliDrive",null,null,"Target","Result","Ppt Gap"]
[null,null,"# Months Remaining In Year",12,null,null,"Quote %",null,null,0.95," ",{"$f":"(+J9-K9)*100","v":{"$error":"#VALUE!"}},null,null,null," "]
[{"$nulls":6},"Take Up Rate or Issued % ",null,null,0.5," ",{"$f":"(+J10-K10)*100","v":{"$error":"#VALUE!"}}]
[null,null,"*model uses this NB retention rate",0.91,null,null,"Digital",null,null,"Target","Result","Ppt Gap"]
[{"$nulls":6},"email Capture at NB",null,null,0.95,null,{"$f":"(+J12-K12)*100","v":95}]
[{"$nulls":6},"Digital Quote Proposal",null,null,0.25,null,{"$f":"(+J13-K13)*100","v":25},{"$nulls":4}," "]
[]
[]
[]
["Monthly Commitment",null,null,null,"90 Day Target",null,null,"90 Day Result"]
["LOB","Quotes","Close Rate","BNB","Quote","BNB",null,"LOB","Quote","Quote Gap","BNB","BNB Gap"]
["AUTO",15,0.12,{"$f":"+B19*C19","v":1.7999999999999998},{"$f":"+B19*3","v":45},{"$f":"+D19*3","v":5.3999999999999995},null,"AUTO",null,{"$f":"(+E19-I19)*1","v":45},null,{"$f":"(+F19-K19)*1","v":5.3999999999999995}]
["HOME",15,0.17,{"$f":"+B20*C20","v":2.5500000000000003},{"$f":"+B20*3","v":45},{"$f":"+D20*3","v":7.65},null,"HOME",null,{"$f":"(+E20-I20)*1","v":45},null,{"$f":"(+F20-K20)*1","v":7.65}]
["SPECIALTY",1,0.85,0.85,3,2.5499999999999998,null,"SPECIALTY",null,{"$f":"(+E21-I21)*1","v":3},null,{"$f":"(+F21-K21)*1","v":2.5499999999999998}]
["Total",{"$f":"SUM(B19:B21)","v":31},{"$f":"SUMPRODUCT(B19:B21,C19:C21)/B22","v":0.16774193548387095},{"$f":"SUM(D19:D21)","v":5.1999999999999993},{"$f":"SUM(E19:E21)","v":93},{"$f":"SUM(F19:F21)","v":15.600000000000001},null,"Total",{"$f":"SUM(I19:I21)","v":0},{"$f":"SUM(J19:J21)","v":93},{"$f":"SUM(K19:K21)","v":0},{"$f":"SUM(L19:L21)","v":15.600000000000001}]
[]
[{"$nulls":15}," "]
["Yearly View"]
["Line of Business","Avg Monthly Quotes","Total Quotes","Est \nClose Rate","BNB","Starting PIF","Renewal Retention","Renewed PIF","Total \nPIF","Est. PIF Growth","Avg WP per policy","Est Written Premium",null,"Metric","LOB","Yr 1","Yr 2","Yr 3","Yr 4","Yr 5","Yr 6"]
["AUTO",{"$f":"B19","v":15},{"$f":"B27*$D$9","v":180},0.13,{"$f":"C27*D27","v":23.400000000000002},0,0.85,{"$f":"F27*G27","v":0},{"$f":"(E27*$D$11)+H27","v":21.294000000000004},{"$f":"IF(ISERROR((I27-F27)/F27),0,((I27-F27)/F27))","v":0},{"$f":"IFERROR(VLOOKUP($A27,List!$D$13:$I$13,VLOOKUP(PLAN!$D$7,List!$A$5:$B$9,2,FALSE),FALSE),\"Select State\")","v":1839.2583974392612},{"$f":"K27*I27","v":39165.168315071634},null,"End PIF","auto",{"$f":"I27","v":21.294000000000004},{"$f":"((P$27*$G$27)+($B$27*12*$D$27*$D$11))","v":39.393900000000002},{"$f":"((Q$27*$G$27)+($B$27*12*$D$27*$D$11))","v":54.778815000000002},{"$f":"((R$27*$G$27)+($B$27*12*$D$27*$D$11))","v":67.855992750000013},{"$f":"((S$27*$G$27)+($B$27*12*$D$27*$D$11))","v":78.971593837500023},{"$f":"((T$27*$G$27)+($B$27*12*$D$27*$D$11))","v":88.41985476187503}]
["HOME",{"$f":"B20","v":15},{"$f":"B28*$D$9","v":180},0.18,{"$f":"C28*D28","v":32.4},0,0.85,{"$f":"F28*G28","v":0},{"$f":"(E28*$D$11)+H28","v":29.483999999999998},{"$f":"IF(ISERROR((I28-F28)/F28),0,((I28-F28)/F28))","v":0},{"$f":"IFERROR(VLOOKUP($A28,List!$D$14:$I$14,VLOOKUP(PLAN!$D$7,List!$A$5:$B$9,2,FALSE),FALSE),\"Select State\")","v":1536.2790405652904},{"$f":"K28*I28","v":45295.651232027019},null,"End PIF","home",null,{"$f":"((P$28*$G$28)+($B$28*12*$D$28*$D$11))","v":29.483999999999998},{"$f":"((Q$28*$G$28)+($B$28*12*$D$28*$D$11))","v":54.545400000000001},{"$f":"((R$28*$G$28)+($B$28*12*$D$28*$D$11))","v":75.847589999999997},{"$f":"((S$28*$G$28)+($B$28*12*$D$28*$D$11))","v":93.95445149999999},{"$f":"((T$28*$G$28)+($B$28*12*$D$28*$D$11))","v":109.34528377499998}]
["SPECIALTY",{"$f":"B21","v":1},{"$f":"B29*$D$9","v":12},0.85,{"$f":"C29*D29","v":10.199999999999999},0,0.85,{"$f":"F29*G29","v":0},{"$f":"(E29*$D$11)+H29","v":9.282},0,{"$f":"IFERROR(VLOOKUP($A29,List!$D$15:$I$15,VLOOKUP(PLAN!$D$7,List!$A$5:$B$9,2,FALSE),FALSE),\"Select State\")","v":282.74767750022386},{"$f":"K29*I29","v":2624.4639425570776},null,"End PIF","other",{"$f":"I29","v":9.282},{"$f":"((P29*$G$29)+($B$29*12*$D$29*$D$11))","v":17.171700000000001},{"$f":"((Q29*$G$29)+($B$29*12*$D$29*$D$11))","v":23.877945},{"$f":"((R29*$G$29)+($B$29*12*$D$29*$D$11))","v":29.578253249999999},{"$f":"((S29*$G$29)+($B$29*12*$D$29*$D$11))","v":34.423515262500004},{"$f":"((T29*$G$29)+($B$29*12*$D$29*$D$11))","v":38.541987973125003}]
["TOTAL",{"$f":"B27+B28+B29","v":31},{"$f":"C27+C28+C29","v":372},{"$f":"IF(C30=0,0,E30/C30)","v":0.17741935483870969},{"$f":"E27+E28+E29","v":66},{"$f":"F27+F28+F29","v":0},{"$f":"IF(F30=0,0,H30/F30)","v":0},{"$f":"H27+H28+H29","v":0},{"$f":"I27+I28+I29","v":60.06},0,{"$f":"IF(I30=0,0,L30/I30)","v":1449.971420074188},{"$f":"L27+L28+L29","v":87085.283489655732},null,"Ave WP","auto",{"$f":"K27","v":1839.2583974392612},{"$f":"P30*1.035","v":1903.6324413496352},1970.2595767968724,2039.2186619847628,2110.5913151542295,2184.4620111846275]
[{"$nulls":13},"Ave WP","home",{"$f":"K28","v":1536.2790405652904},1590.0488069850755,1645.700515229553,1703.3000332625872,1762.9155344267776,1824.6175781317147]
[{"$nulls":13},"Ave WP","other",{"$f":"K29","v":282.74767750022386},292.64384621273166,302.88638083017725,313.48740415923345,324.4594633048066,335.81554452047482]
[null,null,null,"Yr 1 WP","Yr 2 WP","Yr 3 WP","Yr 4 WP","Yr 5 WP","Yr 6 WP",{"$nulls":4},"Ttl WP","auto",{"$f":"P27*P30","v":39165.168315071634},74991.506031283396,107928.48485933416,138373.20674330278,166676.76009731481,193149.81376177818]
[null,null,null,{"$f":"P36","v":41789.632257628713},126897.69739044252,204926.18208544824,276836.81914409675,343479.55746234761,405606.13930154033,{"$nulls":4},"Ttl WP","home",0,46880.999025147961,89765.392883402063,129191.20256988707,165633.76207789723,199513.32686166556]
["*model assumes a 3.5% annual written premium inflation and that quotes, close rates and retention stay constant.",{"$nulls":12},"Ttl WP","other",2624.4639425570776,5025.1923340111643,7232.3043427120265,9272.4098309069104,11169.03528713557,12942.998678096565]
[{"$nulls":14},"total WP",{"$f":"SUM(P33:P35)","v":41789.632257628713},126897.69739044252,204926.18208544824,276836.81914409675,343479.55746234761,405606.13930154033]
["Why does the agent want the Travelers Personal Lines contract? "]
[" \n"]
[]
[]
[]
[null,"Agent Signature:"]
[]
[]
[]
["LONG TERM TARGETS FOR SUCCESS"]
["QUOTING BEHAVIOR EXPECTATIONS",{"$nulls":4},"DIGITAL AUTO DISCOUNT",null,null,null,"Umbrella","Target","Result"]
[null,null,null,"Target %","Result","Digital",null,"Target","Result","Take Up Rate",0.4]
["Home:Auto Quote Ratio",null,null,"1:1",null,"eDelivery (paperless)",null,0.75]
["EFT and Paid-In-Full (combined)",null,null,0.85,null,"eBill",null,0.5]
["Limits 100/300/100 or >",null,null,0.85,null,"MyT enrollment",null,0.6]
["Bridge Rate",null,null,0.8]
["Quote to Effective >15 Days",null,null,0.75]

{"sheet":"List","index":1,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":true,"merged":[[12,2,14,2]]}
[]
[]
[]
[]
["AR",2]
["KS",3]
["MO",4]
["OK",5]
["TX",6]
[]
[]
[{"$nulls":4},"AR","KS","MO","OK","TX"]
[null,null,"2021 YE Avg WP","Auto",{"$f":"G30","v":1898.3002027872819},{"$f":"G33","v":1839.2583974392612},{"$f":"G36","v":1872.4498986357607},{"$f":"G39","v":1777.1584534084905},{"$f":"G42","v":2276.7238400029228}]
[null,null,null,"Home",{"$f":"G28","v":1498.2635911052107},{"$f":"G31","v":1536.2790405652904},{"$f":"G34","v":1380.8847577716056},{"$f":"G37","v":1263.1299587977899},{"$f":"G40","v":1727.829207613391}]
[null,null,null,"Specialty",{"$f":"G29","v":436.4555162855163},{"$f":"G32","v":282.74767750022386},{"$f":"G35","v":307.08941679687501},{"$f":"G38","v":370.92519146873479},{"$f":"G41","v":447.59783314889512}]
{"$rows_empty":10}
["Pulled from RPM 1-18-2022"]
["Prime Prd Loc St Cd","Line of Business Nm","Direct WP Amt - CYTD","Direct WP Amt - PYTD","RIF Cnt - CYTD-Hide","RIF Cnt - PYTD","CYTD Avg","PYTD Avg"]
["AR","Homeowners",22571341,16097028.99,15065,10892,{"$f":"C28/E28","v":1498.2635911052107},{"$f":"D28/F28","v":1477.8763303341902}]
["AR","Other Personal Lines",1889415.93,1824126.49,4329,3894,{"$f":"C29/E29","v":436.4555162855163},{"$f":"D29/F29","v":468.44542629686697}]
["AR","Standard Auto",22747331.329999998,17319477.059999999,11983,9135,1898.3002027872819,1895.9471330049259]
["KS","Homeowners",124143636.70999999,112339637.41,80808,75883,1536.2790405652904,1480.4322102447188]
["KS","Other Personal Lines",6316017.6200000001,6246657.9800000004,22338,21198,282.74767750022386,294.6814784413624]
["KS","Standard Auto",105152241.84,100539730.09,57171,53893,1839.2583974392612,1865.5433932050546]
["MO","Homeowners",103411697.73999999,81271942.040000007,74888,59897,1380.8847577716056,1356.8616464931467]
["MO","Other Personal Lines",7861489.0700000003,7873550.3600000003,25600,24721,307.08941679687501,318.49643461025039]
["MO","Standard Auto",103076494.47,87792205.209999993,55049,44573,1872.4498986357607,1969.6274697686938]
["OK","Homeowners",39547335.880000003,35484744.409999996,31309,29452,1263.1299587977899,1204.833098261578]
["OK","Other Personal Lines",2295656.0099999998,2260243.61,6189,6021,370.92519146873479,375.39339146321208]
["OK","Standard Auto",60533571.240000002,60913252.609999999,34062,33142,1777.1584534084905,1837.9473963550781]
["TX","Homeowners",473591074.49000001,389176291.02999997,274096,234405,1727.829207613391,1660.2729934515048]
["TX","Other Personal Lines",25077116.199999999,24289755.579999998,56026,52234,447.59783314889512,465.01810276831179]
["TX","Standard Auto",498554709.75999999,478263576.99000001,218979,203798,2276.7238400029228,2346.7530446324304]