Public records library › 26-262 › allocationInsurance2027.xlsx
Request 26-262
allocationInsurance2027.xlsx
Excel · 418 KB · released by the City of Moscow on request 26-262
Excel file. Download it to open in the matching program.
SHA-256 829c397718e7298ca893982a71e874a5bfa0b12c6b86153fe5dfec69591b35d6
Extracted text
Machine-extracted text layer of the file above, shown verbatim for search and reading. Tables and slides lose their layout. The original file governs.
# allocationInsurance2027.xlsx - path: - path: allocationInsurance2027.xlsx - type: xlsx - size: 418360 bytes - sheets: 9 - extraction method: xlsx (openpyxl, cached values) === Sheet: premiums === | | 2002-2003 | 20003-2004 | | | 2004-2005 | | Actual Premiums | Actual Premiums | | | Est. Premiums Property | | 41448.11 | 48756.34 | 0.33999999999999997 | | 56069.79099999999 General Liability | | 37319.18 | 94644.66 | 0.66 | | 108841.359 Law Enforcement | | 19850.63 | | 0 | | 0 D&O | | 15880.6 | | 0 | | 0 Auto | | 28267.29 | | 0 | | 0 Uninsured Motorist | | 6987.42 | | 0 | | 0 Crime | | 9051.89 | | 0 | | 0 Subtotal Insurance | | 158805.12000000005 | 143401 | 1 | | 164911.15 Deductibles (estimated) | | 22378.03 | 20000 | | | 30000 Fire Department Policies | | 8048 | 8227 | | | 16710 Total Premium | | 189231.15000000014 | 171628 | | | 211621.15 Department Total Expenses less Cap Outlay | | 2004 12 Mo Estimate | | | | Insurance | Insurance | | 14887808 | | | | | 2004 | Premium Allocate | Premiums Distributed | | Annual Deductibles | | Adopted 2005 Insurance Budget | | | | | | 2004 Budget | Year to Date Actual June 2, 2004 Legislative | | 155475 | | 0.010443108884800234 | | 16000 | 4164.55 | 2035.4783623116311 | 16000 | | | | 16000 Executive | | 141922 | | 0.009532766677270422 | | | | 1858.0425157484567 | | | | | 0 Administrative | | 26340 | | 0.0017692329186405414 | | | | 344.8432227900843 | | | | | 0 Finance | | 611881 | | 0.04109946877337483 | | | | 8010.744723007577 | | | | | 0 Legal | | 408475 | | 0.027436879895280757 | | | | 5347.753812801052 | | | | | 0 Human Resources | | 136860 | | 0.009192756918950057 | | | | 1791.7708227430123 | | | | | 0 Building and Grounds | | 185108 | | 0.01243352950279853 | | 10400 | 2706.96 | 2423.4335339493896 | 31295.622196017706 | | | | 21300 Community Development | | 371546 | | 0.024956393849248998 | | | | 4864.279425010049 | | | | | 0 Engineering | | 508307 | | 0.03414250103171669 | | | | 6654.754139968087 | | | | | 0 Police | | 3280178 | | 0.2203264577297074 | | 41000 | 26377.34 | 42944.08325152366 | 36700 | | 5000 | | 41700 Animal Control | | 54800 | | 0.0036808642346811567 | | | | 717.4414809755741 | | | | | 0 Fire | | | | 0 | | 26000 | 23761.78 | 11072.4 | 16710 | | 1000 | | 26000 911 Emergency | | 612640 | | 0.041150450086406276 | | 1100 | 1100 | 8020.681549359047 | | | | | 0 Parking | | 67550 | | 0.004537269690742922 | | | | 884.3644532828473 | | | | | 0 Streets | | 1113019 | | 0.074760434847091 | | 13825 | 3648.43 | 14571.64233054658 | 14572 | | 1000 | | 15755 Parks and Rec | | 2299873 | | 0.15448029689797182 | | 14125 | 3876.51 | 30109.932320725122 | 17125 | | 1000 | | 18125 1912 Center | | 45729 | | 0.0030715737333528214 | | 7520 | 1957.34 | 598.6839686775918 | 5275 | | | | 5275 Arts Commission | | 106725 | | 0.007168617435152307 | | | | 1397.2434681955865 | | | | | 0 Sewer | | 2163867 | | 0.14534490235231406 | | 95400 | 50711 | 28329.34206412724 | 65000 | | 9000 | | 95400 Water | | 2171718 | | 0.14587224660608197 | | 44100 | 41545.48 | 28432.127339075032 | 50500 | | 4500 | | 45000 Sanitation | | | | 0 | | 6000 | 1561.7 | | 6000 | | | | 6000 Fleet | | 425795 | | 0.02860024793441721 | | | | 5574.507215182382 | 0 | | | | 0 Totals | | 14887808 | | 1 | | 275470 | 161411.09 | 205983.54999999996 | 259177.6221960177 | | 21500 | | 290555 [41 non-empty rows] === Sheet: buildings === Description | 2003 Building Value | 2003 Selected Contents Value | 2003 Total Property Values | 2004 Building Value | 2004 Selected Contents Value | 2004 Total Property Values | | | Estimated Building and Contents Premiums for 2003-2004 | Variance 2003 to 2004 Property Values | Proposed 2004 Insurable Values | | Estimated Building and Contents Premiums for 2004-2005 | | | | | | | | | 56069.79099999999 | | | | 56069.79099999999 Well # 6 Pump House | 75000 | 50000 | 125000 | | | 908000 | | 0.002835968897543409 | 159.01218336775932 | 783000 | 908000 | 0.020666481745658567 | 1158.7653121843907 Pumphouse Well #8 | 75000 | 50000 | 125000 | | | 908000 | | 0.002835968897543409 | 159.01218336775932 | 783000 | 908000 | 0.020666481745658567 | 1158.7653121843907 Eggan Youth Center | 294320 | 21000 | 315320 | 105219 | | 105219 | | 0.007153901702187102 | 401.11777327617494 | -210101 | 315320 | 0.007176822713701607 | 402.4029496013018 City Shop | 383760 | 17737 | 401497 | 119434 | | 119434 | | 0.009109064035655888 | 510.7433166848421 | -282063 | 401497 | 0.009138249362815723 | 512.3797318789607 Fire Training Tower | 378560 | 0 | 378560 | | NOF | 0 | | 0.008588675086832262 | 481.5652170855917 | -378560 | 378560 | 0.008616193094313333 | 483.1081460137918 Shop Storage | 29120 | 0 | 29120 | 37566 | | 37566 | | 0.0006606673143717126 | 37.04347823735321 | 8446 | 37566 | 0.0008550187811204952 | 47.94072435850091 Water Treatment Plan | 1381700 | 30000 | 1411700 | | | 866645 | | 0.032028298341296245 | 1795.8199940821269 | -545055 | 1411700 | 0.032130916608310786 | 1801.5737788664144 City Hall | 3072000 | 160000 | 3232000 | 1154026 | | 1154026 | | 0.07332681181488238 | 4111.419013156785 | -2077974 | 3232000 | 0.07356175000216793 | 4124.591948215804 Recyclng Receiving Center | 641680 | 0 | 641680 | 915768 | | 915768 | | 0.014558276177405237 | 816.2795025873904 | 274088 | 915768 | 0.020843284862619223 | 1168.6786260005233 Animal Shelter | 336960 | 1600 | 338560 | 20024 | NBOF | 20024 | | 0.007681165039618372 | 430.68131840790875 | -318536 | 338560 | 0.0077057753962667 | 432.06121596161597 Mall - Lift Station | 100000 | 0 | 100000 | 80000 | | 80000 | | 0.002268775118034727 | 127.20974669420747 | -20000 | 80000 | 0.0018208353960932656 | 102.0938601043516 NE Resevoir Tanks | 2500000 | 0 | 2500000 | 2500000 | | 2500000 | | 0.05671937795086818 | 3180.2436673551865 | 0 | 2500000 | 0.056901106127914554 | 3190.433128260988 Resevoir Tank | 2500000 | 0 | 2500000 | 2000000 | | 2000000 | | 0.05671937795086818 | 3180.2436673551865 | -500000 | 2000000 | 0.045520884902331644 | 2552.34650260879 Resevoir Tank | 2000000 | 0 | 2000000 | 1000000 | | 1000000 | | 0.04537550236069454 | 2544.194933884149 | -1000000 | 1000000 | 0.022760442451165822 | 1276.173251304395 NW Resevoir Tank | 2000000 | 0 | 2000000 | 2000000 | | 2000000 | | 0.04537550236069454 | 2544.194933884149 | 0 | 2000000 | 0.045520884902331644 | 2552.34650260879 Rental Hose Sngl Family Dwelling | 166400 | 0 | 166400 | | NOF | 0 | | 0.0037752417964097857 | 211.6770184991612 | -166400 | 166400 | 0.0037873376238739924 | 212.35522901705133 1912 Building | 4137225 | 25000 | 4162225 | 2879750 | | 2879750 | | 0.09443152515662093 | 5294.755879342977 | -1282475 | 2879750 | 0.06554438414874478 | 3675.0599204438317 Hamilton Aquatic Center - Pool Building | 300000 | 223000 | 523000 | 862509 | | 862509 | | 0.011865693867321623 | 665.306975210705 | 339509 | 862509 | 0.01963108645811258 | 1100.7109148093025 Swimming Pool | 2000000 | | 2000000 | 1886215 | | 1886215 | | 0.04537550236069454 | 2544.194933884149 | -113785 | 1886215 | 0.042931087958025735 | 2407.1371292091194 Hamilton Aquatic Center - Pool Storage | 50000 | 20000 | 70000 | 55427 | | 55427 | | 0.001588142582624309 | 89.04682268594522 | -14573 | 55427 | 0.001261543043740768 | 70.7344548000487 Sewer Treatment Plan | 16500000 | 100000 | 16600000 | 16531125 | | 16531125 | | 0.3766166695937647 | 21116.817951238438 | -68875 | 16531125 | 0.3762557192155286 | 21096.579538969367 City Hall Annex (Police) | 635600 | 225000 | 860600 | 60000 | | 60000 | | 0.019525078665806862 | 1094.7670800503495 | -800600 | 860600 | 0.019587636773473305 | 1098.2747000725624 Library | 856080 | 0 | 856080 | 310658 | | 310658 | | 0.01942253003047169 | 1089.017199499771 | -545422 | 856080 | 0.019484759573594034 | 1092.5063969766663 Bath HSE Ghormley Park | 137280 | 2625 | 139905 | 110000 | | 110000 | | 0.003174129828886485 | 177.97279611253094 | -29905 | 110000 | 0.0025036486696282403 | 140.37905764348346 Taylor Booster Pump Hse | 100000 | 0 | 100000 | 100000 | | 100000 | | 0.002268775118034727 | 127.20974669420747 | 0 | 100000 | 0.002276044245116582 | 127.61732513043951 Well #9 Pump House | 200000 | 150000 | 350000 | 90800 | | 90800 | | 0.007940712913121544 | 445.23411342972605 | -259200 | 90800 | 0.0020666481745658565 | 115.87653121843907 Mann Bldg - Community Development and Engineering | 500000 | 150000 | 650000 | 238439 | | 238439 | | 0.014747038267225726 | 826.8633535123485 | -411561 | 650000 | 0.014794287593257783 | 829.5126133478567 Wells 2&3 and Equipment Storage Building | 200000 | 200000 | 400000 | 1160000 | | 1160000 | | 0.009075100472138909 | 508.83898677682987 | 760000 | 1160000 | 0.026402113243352354 | 1480.3609715130983 Cemetary Well | 150000 | 0 | 150000 | 908000 | | 908000 | | 0.0034031626770520905 | 190.81462004131117 | 758000 | 150000 | 0.003414066367674873 | 191.42598769565924 Ponderosa Booster Station | 100000 | 0 | 100000 | 100000 | | 100000 | | 0.002268775118034727 | 127.20974669420747 | 0 | 100000 | 0.002276044245116582 | 127.61732513043951 White Av Booster Station | 100000 | 0 | 100000 | 100000 | | 100000 | | 0.002268775118034727 | 127.20974669420747 | 0 | 100000 | 0.002276044245116582 | 127.61732513043951 Moser Pump Station | 100000 | 0 | 100000 | 100000 | | 100000 | | 0.002268775118034727 | 127.20974669420747 | 0 | 100000 | 0.002276044245116582 | 127.61732513043951 Vista Booster | 100000 | 0 | 100000 | 80000 | | 80000 | | 0.002268775118034727 | 127.20974669420747 | -20000 | 80000 | 0.0018208353960932656 | 102.0938601043516 South Lift Station | 150000 | 0 | 150000 | 80000 | | 80000 | | 0.0034031626770520905 | 190.81462004131117 | -70000 | 80000 | 0.0018208353960932656 | 102.0938601043516 South East Lift Station | 100000 | 0 | 100000 | 70000 | | 70000 | | 0.002268775118034727 | 127.20974669420747 | -30000 | 70000 | 0.0015932309715816074 | 89.33212759130765 Orchard Lift Station | 100000 | 0 | 100000 | 60000 | | 60000 | | 0.002268775118034727 | 127.20974669420747 | -40000 | 60000 | 0.0013656265470699492 | 76.5703950782637 Joseph Street Lift Station | 100000 | 0 | 100000 | 60000 | | 60000 | | 0.002268775118034727 | 127.20974669420747 | -40000 | 60000 | 0.0013656265470699492 | 76.5703950782637 Indian Hills Booster | 100000 | | 100000 | 100000 | | 100000 | | 0.002268775118034727 | 127.20974669420747 | 0 | 100000 | 0.002276044245116582 | 127.61732513043951 Anderson/Frontier Park | 0 | 0 | 0 | 20000 | | 20000 | | 0 | 0 | 20000 | 20000 | 0.0004552088490233164 | 25.5234650260879 Berman Creekside Park | 0 | 0 | 0 | 40000 | | 40000 | | 0 | 0 | 40000 | 40000 | 0.0009104176980466328 | 51.0469300521758 East City Park | 0 | 0 | 0 | 165000 | | 165000 | | 0 | 0 | 165000 | 165000 | 0.0037554730044423606 | 210.5685864652252 Kiwanis Park | 0 | 0 | 0 | 75000 | | 75000 | | 0 | 0 | 75000 | 75000 | 0.0017070331838374365 | 95.71299384782962 Mt. View Park | 0 | 0 | 0 | 100000 | | 100000 | | 0 | 0 | 100000 | 100000 | 0.002276044245116582 | 127.61732513043951 | 42650685 | 1425962 | 44076647 | | | | | 1 | 56069.79099999999 | -5519042 | 43935877 | 1 | 56069.79099999999 [46 non-empty rows] === Sheet: allocatepremiums2005 === | | 20002-2003 | | | 2003-2004 | | | | | | | | | | | | | | 2003-2004 | 2004-2005 | 2004-2005 | | Actual Premiums | | | Est. Premiums | | | Estimated annual premium Prior to adding in the additional property premiums which resulted from increased property values | | | | | | | | | | | Est. Premiums | Est. Premiums | Est. Premiums Property | | 41448.11 | 0.2609998342622706 | | 75735.97116163508 | | | | | | | | | | | | | | 75735.97116163508 | 78008.05029648414 | 78000 General Liability | | 37319.18 | 0.23499985390899228 | | 40889.97458016466 | | | | | | | | | | | | | | 40889.97458016466 | 44161.17254657783 | 44150 Law Enforcement | | 19850.63 | 0.12499993702973805 | | 21749.98904317442 | | | | | | | | | | | | | | 21749.98904317442 | 22402.488714469655 | 22500 D&O | | 15880.6 | 0.10000055413830483 | | 17400.09642006504 | | | | | | | | | | | | | | 17400.09642006504 | 17922.099312666993 | 17925 Auto | | 28267.29 | 0.1779998654955205 | | 30971.976596220567 | | | | | | | | | | | | | | 30971.976596220567 | 31901.135894107185 | 31900 Uninsured Motorist | | 6987.42 | 0.043999966751701695 | | 7655.994214796095 | | | | | | | | | | | | | | 7655.994214796095 | 7885.674041239978 | 7900 Crime | | 9051.89 | 0.056999988413471786 | | 9917.997983944091 | | | | | | | | | | | | | | 9917.997983944091 | 10215.537923462414 | 10250 | | 158805.12000000005 | 0.9999999999999997 | | 204321.99999999994 | | | | | | | | | | | | | | 204321.99999999994 | 212496.1587290082 | 212625 Fire Department Policies | | 8048 | | | 9000 | | | | | | | | | | | | | | 9000 | 10000 | 10250 Maximum Deductibles <= $25,000 | | | | | 25000 | | | | | | | | | | | | | | 25000 | 25750 | 25750 Total Premium | | 166853.1200000001 | | | 238321.99999999994 | | | | | | | | | | | | | | 238321.99999999994 | 248246.1587290082 | 248625 | | | | | | | | 174000 | | | | | | | | | | Proposed | Mayor,Gary,Don's | Don's | Don's Department | | | | | | | | | | | | | | | | | | 2004 | 2004 | 2004 | 2005 Total Expenses less Cap Outlay | | 12059197.1 | | | Premium Dist. W/O Prop. | | | Property Premiums | | Total Est. Expenses | | Auto | | Deducts | | Total, fleet & deduct | Current | Budget | Insurance | Insurance | Insurance | | | | | | | | | | | | | | | | | Budget | Allocation | Allocation | Allocation | Allocation Legislative | | 136738 | 0.011338897512505207 | | 773.4043037374317 | | | | | 773.4043037374317 | | | | | | 773.4043037374317 | 16000 | 23955.880919810137 | 15600 | 16000 | 16000 Executive | | 24936 | 0.002067799356227456 | | 141.04060113499247 | | | | | 141.04060113499247 | | | | | | 141.04060113499247 Administrative | | 402849 | 0.03340595535999656 | | 2278.5557076768755 | | | | | 2278.5557076768755 | | 724.15 | | 1000 | | 4002.7057076768756 Finance | | 458876 | 0.03805195289494025 | | 2595.450228040616 | | | | | 2595.450228040616 | | | | | | 2595.450228040616 Legal | | 152070 | 0.012610292272277397 | | 860.1236852180904 | | | | | 860.1236852180904 | | | | | | 860.1236852180904 Human Resources | | 117752 | 0.009764497505393622 | | 666.0175194436811 | | | | | 666.0175194436811 | | | | | | 666.0175194436811 Building and Grounds | | 299993 | 0.024876697636860085 | | 1696.791508513386 | 6121 | | 8692.99040936214 | | 10389.781917875527 | | | | | | 10389.781917875527 | 73000 | 10400 | 65000 | 10400 | 21300 Community Development | | 360571 | 0.029900083480682144 | | 2039.426956682923 | | | | | 2039.426956682923 | | 487.93 | | 2000 | | 4527.356956682923 Engineering | | 432103 | 0.035831821672439534 | | 2444.019364462369 | | | | | 2444.019364462369 | | 1026.6200000000001 | | 2000 | | 5470.6393644623695 City Shop | | 324799 | 0.026933716839241312 | | 1837.0968161711746 | | | | | 1837.0968161711746 | | 409.7 | | 2000 | | 4246.796816171174 Police * | | 1904317.1 | 0.1579140870000375 | | 32521.003982845803 | 1038 | | 1474.158478176426 | | 33995.16246102223 | | 5577.17 | | 2500 | | 42072.332461022226 | 36600 | 42072 | 36600 | 30500 | 29100 Campus Police * | | | | | | | | | | | | | | | | | | | | 10500 | 12600 Animal Control | | 58211 | 0.004827104119560332 | | 329.2474507807606 | | | | | 329.2474507807606 | | | | | | 329.2474507807606 Fire * | | 349244 | 0.028960800383634164 | | 10975.360270403806 | 491 | | 697.3138851489643 | | 11672.67415555277 | | 12334.39 | | 2000 | | 26007.06415555277 | 9525 | 26000 | 24700 | 26000 | 26000 911 Emergency | | 191553 | 0.01588439084389789 | | 1083.443626452166 | | | | | 1083.443626452166 | | | | | | 1083.443626452166 | | | | 1100 Parking | | 70832 | 0.005873691209508467 | | 400.63313520988874 | | | | | 400.63313520988874 | | | | | | 400.63313520988874 Streets * | | 713759 | 0.05918793714715883 | | 4037.094899964352 | | | | | 4037.094899964352 | | 7786.62 | | 2000 | | 13823.714899964352 | | 13824 | 15400 | 13825 | 15755 Parks and Rec | | 1203237 | 0.09977753825750141 | | 6805.633212538695 | 3877 | | 5506.081329373797 | | 12311.714541912494 | | 2813.97 | | 2000 | | 17125.684541912495 | | 17125 | 8000 | 17125 | 18125 1912 Center | | 69263 | 0.005743583045010518 | | 391.75870855040836 | 5019 | | 7127.939693610289 | | 7519.698402160698 | | | | | | 7519.698402160698 | | 7519 | | 7520 | 5275 Arts Commission | | 75065 | 0.0062247096035937585 | | 424.57542204837216 | | | | | 424.57542204837216 | | | | | | 424.57542204837216 | | 426 Sewer | | 1101231 | 0.0913187661556672 | | 6228.676701495383 | 22741 | | 32296.568354730345 | | 38525.24505622573 | | 3343.87 | | 4500 | | 46369.11505622573 | 61950 | 49487.37949396925 | 86730 | 75400 | 95400 Water | | 1084184 | 0.08990515628938514 | | 6132.257102219308 | 13267 | | 18841.6768111432 | | 24973.933913362507 | | 4123.54 | | 5000 | | 34097.47391336251 | 29750 | 36449.848840081315 | 29750 | 34100 | 45000 Sanitation | | 2527614 | 0.20960052141448124 | | 14296.446823757733 | 774 | | 1099.2279981777972 | | 15395.67482193553 | | | | | | 15395.67482193553 | | 15395.67482193553 | 6000 | 6000 | 6000 Totals | | | 1 | | 98958.0580273482 | 53328 | | 75735.95695972296 | | 174694.01498707116 | | 38627.96 | | 25000 | | 238321.97498707118 | 226825 | 242654.78407579625 | 287780 | 248470 | 290555 *2003-2004 30% risk reduction [42 non-empty rows] === Sheet: 2008to2010Lossreport === Loss Run for Member - City of Moscow ******CONFIDENTIAL****** Loss Date | Claim No. | Claimant | Claim Type | Claim Status | Total Paid | Description of loss | Department 2008-10-29 00:00:00 | 2009033414 | Cochran | General Liability | File Closed | 944.58 | slipped in water under malfunctioning water founta | Building & Grounds Maintenance | 944.58 2008-08-29 00:00:00 | 2008033075 | Moscow-Pullmon Daily News | General Liability | File Closed | 338.1 | nail gun misfired hit window | Engineer/Surveyors | 338.1 2008-08-07 00:00:00 | 2008033006 | CITY OF MOSCOW | Contents | File Closed | 3730 | runaway trk trailer hit tree & sign | Parks & Recreations 2008-10-12 00:00:00 | 2009034084 | McCollough | General Liability | File Closed | 0 | slipped on black ice and broke patella | Parks & Recreations | 3730 2008-04-17 00:00:00 | 2008032384 | Proctor | Auto Liability | File Closed | 655.86 | veh ran over cvr on hole in ground | Road & Bridge & Street 2008-06-26 00:00:00 | 2008032817 | Chilson | General Liability | File Closed | 0 | Trip & fall | Road & Bridge & Street 2008-08-11 00:00:00 | 2008033078 | Verizon | General Liability | File Closed | 632.83 | buried cable dmg | Road & Bridge & Street 2008-09-22 00:00:00 | 2008034042 | Hazelton | General Liability | File Closed | 0 | hit by veh in intersection | Road & Bridge & Street 2008-11-12 00:00:00 | 2009033540 | City of Moscow | General Liability | File Closed | 1050 | veh hit chip trk which hit tree | Road & Bridge & Street 2008-11-13 00:00:00 | 2009033396 | DeArmond | Auto Liability | File Closed | 2104.6 | Street Sweeper hit parked vehicle | Road & Bridge & Street 2008-12-22 00:00:00 | 2009033715 | Luckstead | Auto Liability | File Closed | 3300 | plow hit parked car | Road & Bridge & Street 2008-12-22 00:00:00 | 2009033716 | Luckstead | Auto Liability | File Closed | 0 | plow slide into veh | Road & Bridge & Street 2008-12-22 00:00:00 | 2009033717 | Robertson | Auto Liability | File Closed | 2183.55 | veh dmg from plow | Road & Bridge & Street 2008-12-27 00:00:00 | 2009033905 | Ricketts | Auto Liability | File Closed | 772.74 | veh rear ended by snow plow | Road & Bridge & Street 2009-01-03 00:00:00 | 2009033814 | McAdoo | Auto Liability | File Closed | 227.63 | plow hit car mirror | Road & Bridge & Street 2009-01-05 00:00:00 | 2009033686 | Hosley | Auto Liability | File Closed | 4067.47 | snowplow collided w veh | Road & Bridge & Street 2009-01-05 00:00:00 | 2009033765 | Preys | Auto Liability | File Closed | 1736.62 | Snowplow scraped bumper of parked vehicle | Road & Bridge & Street 2009-01-12 00:00:00 | 2009033811 | CITY OF MOSCOW | Buildings | File Closed | 524.7 | Snowplow hit new metal on ground for new building | Road & Bridge & Street 2009-01-23 00:00:00 | 2009033897 | Borchardt | Auto Liability | File Closed | 897.2 | Grader hit veh | Road & Bridge & Street | 18153.2 2008-04-11 00:00:00 | 2008032405 | Christiansen | General Liability | File Closed | 293.85 | Sewer backup | Sewer Department 2008-05-27 00:00:00 | 2008032615 | Hatfield | General Liability | File Closed | 2206.18 | sewer back-up | Sewer Department 2008-09-24 00:00:00 | 2008033178 | michalson | General Liability | File Closed | 1846.87 | sewer back-up | Sewer Department | 4346.9 2008-11-01 00:00:00 | 2009033505 | Moscow Moose Family Center | General Liability | File Closed | 16341.85 | Wtr dmg | Water Department | 16341.85 2009-09-22 00:00:00 | 2009035086 | City of Moscow | Buildings | File Closed | 58903.97 | Fire started in womens restroom at park | Building & Grounds Maintenance | 58903.97 2009-09-14 00:00:00 | 2009034984 | Odberg | Errors/Omissions | File Closed | 0 | Failing to prop supervise inspect preparation of | Engineer/Surveyors 2009-08-25 00:00:00 | 2009034953 | City of Moscow | Auto Collision | File Closed | 6590.28 | Police motorcycle involved in head on crash | Law Enforcement Operations | 6590.28 2010-01-15 00:00:00 | 2010035681 | City of Moscow | Auto Collision | File Closed | 0 | bus backed into patrol veh | Law Enforcement Operations 2009-07-03 00:00:00 | 2009034644 | Warren | General Liability | File Closed | 0 | Tree fell on parked truck | Parks & Recreations 2009-04-21 00:00:00 | 2009034193 | Villarreal | General Liability | File Closed | 1555.65 | Vehicle damage from man hole cover | Road & Bridge & Street 2009-07-12 00:00:00 | 2009034667 | Hunt | Auto Liability | File Closed | 867.35 | City backhoe damaged rear bumper of car | Road & Bridge & Street 2009-09-25 00:00:00 | 2009035107 | Davidson | General Liability | File Closed | 1116.22 | ReBar pulled veh front end | Road & Bridge & Street 2009-09-26 00:00:00 | 2009035189 | Robinson | General Liability | File Closed | 601.99 | clmt drove over open manhole | Road & Bridge & Street 2009-09-26 00:00:00 | 2009035379 | City of Moscow | Buildings | File Closed | 3505 | bridge dmg in veh collision | Road & Bridge & Street 2009-09-28 00:00:00 | 2009035085 | Riddle | Auto Collision | File Closed | 2459.18 | manhole collar broken, 3rd party vehicle kicked c | Road & Bridge & Street 2009-10-07 00:00:00 | 2010035237 | City of Moscow | Auto Collision | File Closed | 342.57 | insured hit flower box | Road & Bridge & Street 2009-10-26 00:00:00 | 2010035267 | Strunk | Auto Liability | File Closed | 1371.56 | Insured driver failed to yield right-of-way, hit v | Road & Bridge & Street | 11819.519999999999 2009-04-09 00:00:00 | 2009034205 | McAlister | Auto Liability | File Closed | 292.08 | city trk hit sideview mirror | Sanitation | 292.08 2010-02-09 00:00:00 | 2010035754 | Whybark | General Liability | Open-General File | 0 | Claim for injuries/meds for trip fall over alleg | Sanitation 2009-05-08 00:00:00 | 2009034329 | Crossin | General Liability | File Closed | 20560.45 | Swere flooded basement | Sewer Department 2009-07-17 00:00:00 | 2009034668 | Book People of Moscow | General Liability | File Closed | 129 | Toilet flooded | Sewer Department 2009-08-04 00:00:00 | 2009035087 | Goodson Plumbing Ince,Revolution Motorsports LLC | General Liability | File Closed | 2050.18 | sewer back up | Sewer Department 2009-08-13 00:00:00 | 2009035369 | CMR Claims | General Liability | File Closed | 0 | cable dmg placing sewer ln | Sewer Department 2009-10-06 00:00:00 | 2010035912 | Gritman Medical Center, Inc.,Gritman Medical Park, LLC | General Liability | Open-General File | 0 | Sewer backup | Sewer Department 2009-10-24 00:00:00 | 2010035266 | Pope | General Liability | File Closed | 0 | Sewer back up | Sewer Department 2009-11-23 00:00:00 | 2010035505 | ServiceMaster Building Maintenance | Buildings | File Closed | 641 | sewer overflow | Sewer Department 2010-03-02 00:00:00 | 2010035848 | Jackson,O'neal | General Liability | File Closed | 986.39 | Sewer backup | Sewer Department 2010-03-05 00:00:00 | 2010035833 | Schroeder | General Liability | Open-General File | 9378.04 | Sewer back-up | Sewer Department | 33745.06 2009-06-11 00:00:00 | 2009034515 | Bielejec | General Liability | File Closed | 0 | water leak under house | Water Department 2009-10-21 00:00:00 | 2010035241 | Banner | Auto Liability | File Closed | 1983.67 | Parked vehicle mirror broken off by City vehicle | Waterways Maintenance & Operations | 1983.67 [52 non-empty rows] === Sheet: Allocatepremiums2011 === | | | 2010-2011 Projected Premiums | General Liability & Property | | 209815 | 1 | Total | | 209815 | 1 | | | | 0 | | | | 0 | | | 209815 | 2 | Fire Department Volunteers | | 11270 | Volunteers Policy | Deductibles & Losses | | 80000 | Total Premium | | 301085 | | | | | | | | | | | | | | | | | | | | | | Pay Amount | Department | | | | | | | | | | Combined Loss & | Combined Loss & | Combined Loss & | | Allocated 2011 Insurance | | Adopted 2009 Insurance | | Adopted 2010 Insurance | | Insurance 2011 Allocation | Proposed 2011 Insurance | | Variance 2010 to 2011 | 209814 | | | | | | Premium Dist. Based upon Payroll | Adjustments based upon budget & Property | | Insurance Payout Loss | Deductible Loss | Deductible Allocation based upon Experience Rating | Deductible Allocation Percentages | Deductible & Loss Allocation Account # | | | Audited Payroll FY 2009 | | | | | Volunteers Policy | Losses 2 year Actual | thru April 2009 to March 2010 History 101-010-10-668-10 | Legislative | | 41865 | 0.0054879252535797686 | | 1151.4490370798392 | 11000 | | | | 0 | 0 | 0 | | 12151.44903707984 | 0.041928332201113826 | 11800 | | 11800 | 0.040354052842220635 | 12151.44903707984 | 12150 | 0.040354052842220635 | -351.4490370798394 | 8797.151092444496 | Executive | | 18846 | 0.0024704511962012256 | | 518.3377177309602 | -518.3377177309602 | | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | | 0 | 0 | 0 | Administrative | | 382401 | 0.05012750758137244 | | 10517.503003185659 | -10517.503003185659 | | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | | 0 | 0 | 0 | Finance | | 341959 | 0.04482611804105778 | | 9405.191956784538 | -9405.191956784538 | | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | | 0 | 0 | 0 | Legal | | 205440 | 0.026930356242575604 | | 5650.392695036 | -5650.392695036 | | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | | 0 | 0 | 0 | Human Resources | | 89180 | 0.011690270491203721 | | 2452.7941031119085 | -2452.7941031119085 | | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | | 0 | 0 | 0 101-110-10-668-10 | Building and Grounds | | 121660 | 0.015947951423635844 | | 3346.1194279501547 | 17500 | | | 270 | 270 | 0.0021509488074183836 | 172.07590459347068 | | 21018.195332543626 | 0.07252286319776786 | 19660 | | 20650 | 0.06981417207765249 | 21018.195332543626 | 21020 | 0.06981417207765249 | -368.19533254362614 | 15216.312018976467 | Community Development | | 434872 | 0.05700573344977287 | | 11960.657963764093 | -11960.657963764093 | | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | | 0 | 0 | 0 | Engineering | | 441681 | 0.05789829962800348 | | 12147.931736449551 | -12147.931736449551 | | 0 | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | | 0 | 0 | 0 101-070-20-668-10 | Police * | | 1517606 | 0.19893725767070772 | | 41740.02071817954 | -10000 | | | 11240 | 11240 | 0.08954320220512085 | 7163.456176409668 | | 38903.47689458921 | 0.13423567000423203 | 44100 | | 36000 | 0.12921600212564557 | 38903.47689458921 | 38905 | 0.12921600212564557 | -2903.4768945892065 | 28164.52286626794 | 42455.123706964325 101-073-20-668-10 | Campus Police * | | 696212 | 0.09126381026263651 | | 19148.51635025508 | 591 | | | | 0 | 0 | 0 | | 19739.51635025508 | 0.06811080690848269 | 17445 | | 19150 | 0.0655628809140276 | 19739.51635025508 | 19740 | 0.0655628809140276 | -589.5163502550786 | 14290.600840696387 | Animal Control | | 27259 | 0.003573279696341357 | | 749.7276794878618 | -749.7276794878618 | | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | 0 | 0 101-090-20-668-10 | Fire * | | 356129 | 0.04668360999957266 | | 9794.921632060337 | -5794.921632060337 | | | 1606 | 1606 | 0.012794162165607125 | 1023.53297324857 | | 5023.53297324857 | 0.01733360018898882 | 9450 | | 15100 | 0.05410432269956989 | 5023.53297324857 | 16290 | 0.05410432269956989 | 10076.46702675143 | 3636.8319900525 | 911 Emergency | | 0 | 0 | | 0 | 0 | | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | 0 | 0 | Parking | | 60517 | 0.007932945720073734 | | 1664.4510062572704 | -1664.4510062572704 | | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | 0 | 0 105-150-40-668-10 | Streets * | | 463587 | 0.060769874705154284 | | 12750.431261261947 | -14000 | | 29973 | 3339 | 33312 | 0.26537928397304145 | 21230.342717843316 | | 19980.773979105263 | 0.06894326153818292 | 15250 | | 15250 | 0.06635999800720727 | 19980.773979105263 | 19980 | 0.06635999800720727 | -4730.773979105263 | 14465.26147637231 120-160-30-668-10 | Parks and Rec | | 858258 | 0.11250581039739317 | | 23605.406608529047 | -14800 | | | 2061 | 2061 | 0.016418909229960327 | 1313.5127383968263 | | 10118.919346925873 | 0.03491512910102642 | 18570 | | 7400 | 0.03361177076240929 | 10118.919346925873 | 10120 | 0.03361177076240929 | -2718.9193469258735 | 7325.682897202757 123-190-30-668-10 | 1912 Center | | 0 | 0 | | 0 | 2700 | | | 0 | 0 | 0 | 0 | | 2700 | 0.009316296072802557 | 2585 | | 2585 | 0.008967567298271252 | 2700 | 2700 | 0.008967567298271252 | -115 | 1954.6893442189958 | Arts Fund | | 81601 | 0.01069676791155769 | | 2244.3423593634766 | -2244.3423593634766 | | | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | | 0 | 0 | 0 220-220-70-668-10 | Water | | 628384 | 0.08237249307405874 | | 17282.984634333632 | 28230 | | 18326 | 3125 | 21451 | 0.1708888995108583 | 13671.111960868664 | | 59184.096595202296 | 0.2042135432156483 | 52500 | | 52500 | 0.19657239649932742 | 59184.096595202296 | 59185 | 0.19657239649932742 | -6684.096595202296 | 42846.860356248035 230-230-60-668-10 | Sewer | | 471204 | 0.061768358561753285 | | 12959.928151634265 | 43000 | | 38092 | 16810 | 54902 | 0.43737552379586697 | 34990.04190366936 | | 90949.97005530362 | 0.3138210551287909 | 75000 | | 75000 | 0.30207416510287793 | 90949.97005530362 | 90950 | 0.30207416510287793 | -15949.970055303624 | 65844.05086079214 240-240-50-668-10 | Sanitation | | 27092 | 0.003551388294995416 | | 745.1345351144632 | 3600 | | | 0 | 0 | 0 | 0 | | 4345.134535114463 | 0.01499279992788357 | 4200 | | 4200 | 0.014431140707773552 | 4345.134535114463 | 4345 | 0.014431140707773552 | -145.13453511446278 | 3145.6993240689635 290-290-10-668-10 | Fleet Management | | 188409 | 0.024697826563996432 | | 5181.974480524911 | -715 | | | | 0 | 0 | 0 | | 4466.974480524911 | 0.015413206226008695 | 2100 | | 3800 | 0.014829699254363386 | 4466.974480524911 | 4465 | 0.014829699254363386 | -666.9744805249111 | 3233.906451103788 295-295-10-668-11 | Information Systems | | 174404 | 0.022861963834356288 | | 4796.782941905464 | -4000 | | | 684 | 684 | 0.005449070312126571 | 435.92562497012574 | | 1232.70856687559 | 0.004253436289071529 | | | 0 | | 1232.70856687559 | 1235 | 0.004101831708653703 | -1232.70856687559 | 892.4304815552538 | | | | | | | 0 | | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | 0 | 0 | Totals | | 7628566 | 1 | | 209815 | -0.2518532316607889 | 0 | 86391 | 39135 | 125526 | 1 | 79999.99999999999 | | 289814.7481467683 | 1.0000000000000002 | 272660 | | 263435 | 0.9958981682913463 | 289814.7481467683 | 301085 | 1 | -26379.74814676834 | 209814.00000000003 | | | | | | | | | | | | | | | | | | | 300315.89999999997 | | | | | | | | | Two Year Total | | | | | | | | Building & Grounds Maintenance | 59848.55 | | | | | | | | Engineer/Surveyors | 0 | | | | | | | | Parks & Recreations | 0 | | | | | | | | Road & Bridge & Street | 29972.72 | | | | | | | | Sanitation | 0 | | | | | | | | Water Department | 18325.52 | | | | | | | | Sewer Department | 38091.96 [47 non-empty rows] === Sheet: Vehicles === Year | Make | Model | VIN | Value Range | | Department 1921 | LAFRANCE | PUMPER TRUCK | 3785 | $0 - 10,000 | | Fire Dept 1967 | CHEVROLET | C-50 FLATBED | CS5372 | $0 - 10,000 | | Road & Bridge 1973 | GMC | 1 TON VAN | TPZ353V505198 | $0 - 10,000 | | Fire Dept 1973 | FORD | F660 PUMPER | F66EVR62117 | $0 - 10,000 | | Fire Dept 1975 | INTERNATIONAL | 3 TON DUMP TRUCK | D0522EHA50363 | $0 - 10,000 | | Water Dept 1977 | CHEVROLET | AM TK | CGR3374125521 | $0 - 10,000 | | Law Enforcement 1977 | GMC | 6000 FLATBED | TCS617V592097 | $0 - 10,000 | | Road & Bridge 1978 | CHEVROLET | 1/2 TON PICKUP | CCU148Z124425 | $0 - 10,000 | | Parks & Recreation 1978 | CHEVROLET | 1/2 TON PICKUP | CCU148Z124369 | $0 - 10,000 | | Water Dept 1979 | CHEVROLET | 1/2 TON PICKUP | CCU149J141415 | $0 - 10,000 | | Administrative 1979 | CHEVROLET | 1/2 TON PICKUP | CCU149J141328 | $0 - 10,000 | | Parks & Recreation 1981 | CHEVROLET | PICKUP | 2GCDC14D7B1144549 | $0 - 10,000 | | Administrative 1981 | GMC | 1 TON | 1GDHC34T3BZ506612 | $0 - 10,000 | | Road & Bridge 1982 | CHEVROLET | 2 DR CAM | 1G1AP87H5CL195373 | $0 - 10,000 | | Law Enforcement 1982 | Chevrolet | 1/2 Ton Pickup | 2GCDC14D9C1139788 | $0 - 10,000 | | Parks & Recreation 1982 | GMC | 1 TON | 1GDHC34T8CV565499 | $0 - 10,000 | | Road & Bridge 1984 | Chevrolet | 1/2 Ton Pickup | 2GCDC14D3E1145525 | $0 - 10,000 | | Administrative 1984 | Cadillac | Limo | 1g6am6986e9132142 | $0 - 10,000 | | Parks & Recreation 1984 | CHEVROLET | 1/2 TON PICKUP | 2gcdc14d7e1144958 | $0 - 10,000 | | Water Dept 1984 | CHEVROLET | 1/2 TON PICKUP | 2GCDC14D3E1145525 | $0 - 10,000 | | Water Dept 1985 | CHEVROLET | PICKUP | 2GC0C14N3F1166000 | $0 - 10,000 | | Parks & Recreation 1985 | CHEVROLET | 1 TON | 1GBHC34M5FS174270 | $0 - 10,000 | | Road & Bridge 1985 | CHEVROLET | TRUCK W/AQUATEC | 1GBP7D1GXFV210618 | $0 - 10,000 | | Water Dept 1986 | Ford | Rescue Unit | 1FDKF38LXGT825544 | $20,001 - 30,000 | | Fire Dept 1986 | CHEVROLET | CAVALIER | 1G1JD69PXGK170014 | $0 - 10,000 | | Law Enforcement 1986 | CHEVROLET | C-60 LADDER TRUCK | 1GBE6D1AXGV102796 | $0 - 10,000 | | Road & Bridge 1986 | CHEVROLET | 1/2 TON PICKUP | 2GCDC14N6G1194066 | $0 - 10,000 | | Water Dept 1986 | CHEVROLET | SLUDGE TRUCK | 1GBT7D4Y2GV119380 | $0 - 10,000 | | Water Dept 1987 | CHEVROLET | S-10 PICKUP | 1GCBS14E2H2190656 | $0 - 10,000 | | Administrative 1988 | CHEVROLET | 1/2 TON PICKUP | 1GCDC14Z1JE152610 | $0 - 10,000 | | Administrative 1988 | GMC | 1/2 TON PICKUP | 1GTDC14Z3JZ526482 | $0 - 10,000 | | Water Dept 1989 | NAVISTAR | 4800 4X4 | 1HTSETVN2LH219616 | $0 - 10,000 | | Fire Dept 1989 | TOYOTA | PICKUP | JT4RN81ROK5039164 | $0 - 10,000 | | Law Enforcement 1989 | CHEVROLET | C-70 DUMP TRUCK | 1GBP7D1G5KV107259 | $0 - 10,000 | | Road & Bridge 1990 | NAVESTAR | 4800 4X4 | 1H5E7797M1322459 | $0 - 10,000 | | Fire Dept 1990 | CHEVROLET | 3/4 TON PICKUP | 1GCGC2475LE208375 | $0 - 10,000 | | Parks & Recreation 1990 | CHEVROLET | 1/2 TON PICKUP | 1GCDC14ZXLZ163245 | $0 - 10,000 | | Road & Bridge 1990 | FORD | DUMP TRUCK | 1FDYK84A0LVA12537 | $0 - 10,000 | | Water Dept 1991 | CHEVROLET | CAPRICE | 1G1BL53E4MR127848 | $0 - 10,000 | | Administrative 1991 | CHEVROLET | S10 PICKUP | 1GCCS14A0M0151930 | $0 - 10,000 | | Administrative 1991 | CHEVROLET | CAPRICE | 1G1BL53E0MR127393 | $0 - 10,000 | | Administrative 1991 | JEEP | CHEROKEE | 1J4FJ88S3ML556801 | $0 - 10,000 | | Fire Dept 1991 | FORD | EXPLORER | 1FMDU34X4MUD97463 | $0 - 10,000 | | Law Enforcement 1991 | MAZDA | PICKUP | JM2UF1130M0169550 | $0 - 10,000 | | Parks & Recreation 1991 | EAGLE | 20' FLATBED TRAILER | 1E9E02023M1021282 | $0 - 10,000 | | Parks & Recreation 1991 | CHEVROLET | 3/4 TON PICKUP | 1GCGC24K7ME172807 | $0 - 10,000 | | Water Dept 1991 | FORD | CARGO VAN | 1FTHE25Y0MHB26672 | $0 - 10,000 | | Water Dept 1992 | CHEVROLET | CAPRICE | 1G1BL53E6NR137136 | $0 - 10,000 | | Administrative 1992 | UTILITY | TRAILER | 1 | $0 - 10,000 | | Administrative 1992 | CHEVROLET | CAPRICE | 1G1BL53E4NR136597 | $0 - 10,000 | | Fire Dept 1992 | GMC | 1 TON STENCIL TRUCK | 1GDJC34K9NE525850 | $0 - 10,000 | | Road & Bridge 1992 | FORD | F800 DUMP TRUCK | 1FDYK84A5NVA09748 | $0 - 10,000 | | Road & Bridge 1993 | CHEVROLET | CAPRICE | 1G1BL5370PR132227 | $0 - 10,000 | | Administrative 1993 | CHEVROLET | ASTRO VAN | 1GNDL15W9PB194173 | $0 - 10,000 | | Administrative 1993 | PIERCE | LANCE 6V | 4PCT0202PA000128 | $0 - 10,000 | | Fire Dept 1993 | JEEP | WAGONEER | 1J4G258Y2PC587865 | $20,001 - 30,000 | | Parks & Recreation 1994 | Toyota | Pickup | JT4VD20CR0013183 | $0 - 10,000 | | Administrative 1994 | NAVISTAR | 4800 4X4 | 1HTSEPCR8RH568849 | $0 - 10,000 | | Fire Dept 1994 | CHEVROLET | 1/2 TON EXT CAB PU | 2GCEC19Z2R1163562 | $0 - 10,000 | | Water Dept 1995 | PIERCE | DASH | 4P1CT02DXSA000161 | $0 - 10,000 | | Fire Dept 1995 | FORD | SUPER DUTY 14000 | 1FDLF47G3SEA24929 | $0 - 10,000 | | Fire Dept 1995 | FORD | SUPER DUTY 14000 | LFDLF47GXSEA24930 | $0 - 10,000 | | Fire Dept 1995 | FORD | CROWN VICTORIA | 2FALP7171W8SX168533 | $0 - 10,000 | | Law Enforcement 1995 | FORD | DUMP TRUCK F800 | 1FDYF80CXSVA50819 | $0 - 10,000 | | Road & Bridge 1996 | CHEVROLET | SUBURBAN | 1GNGK26R2TJ396836 | $0 - 10,000 | | Administrative 1996 | CHEVROLET | LUMINA | 2G1WL52M5T9114676 | $0 - 10,000 | | Fire Dept 1996 | FORD | CROWN VICTORIA | 2FALP71WXTX158443 | $0 - 10,000 | | Law Enforcement 1996 | Chevrolet | TRK | 1GNGK26R2TJ396836 | $20,001 - 30,000 | | Parks & Recreation 1996 | CHEVROLET | 1/2 TON PICKUP | 1GCEC14W6TZ138966 | $0 - 10,000 | | Road & Bridge 1996 | CHEVROLET | 1/2 TON PICKUP | 1GCE14W5TZ138697 | $0 - 10,000 | | Water Dept 1997 | TOYOTA | T100 PICKUP | JT4JM11D9V0019380 | $0 - 10,000 | | Administrative 1997 | GMC | S10 Pickup | 1GTCS19W1V8511407 | $10,001 - 20,000 | | Administrative 1997 | FORD | CROWN VICTORIA | 2FALP71W3VX152650 | $0 - 10,000 | | Law Enforcement 1997 | DODGE | INTREPID | 2B3HD46F9VH625401 | $0 - 10,000 | | Law Enforcement 1997 | CHEVROLET | 1/2 TON PICKUP | 1GCEC14W8VZ176217 | $0 - 10,000 | | Parks & Recreation 1997 | gmc | Van | 1GTHG39F1V1046364 | $20,001 - 30,000 | | Parks & Recreation 1997 | GMC | T8500 VAC-ALL | 1GDP7C1J7VJ519059 | $0 - 10,000 | | Road & Bridge 1997 | FORD | L8000 FLUSHER | 1FDYK82E1VVA27654 | $0 - 10,000 | | Road & Bridge 1997 | FORD | F-800 | 1FDWF80C6VVA13648 | $0 - 10,000 | | Water Dept 1997 | CHEVROLET | 3/4 TON CARGO VAN | 1GCGG25W0V1037344 | $0 - 10,000 | | Water Dept 1997 | CHEVROLET | 3/4 TON PICKUP | 1GCGC24RXVZ172470 | $0 - 10,000 | | Water Dept 1998 | CHEVROLET | 4X4 EXT CAB PICKUP | 1GCEK19M1WE210274 | $0 - 10,000 | | Fire Dept 1998 | FREIGHTLINER | FL80 | 1FV6JLCB8WH926053 | $0 - 10,000 | | Fire Dept 1998 | FORD | CROWN VICTORIA | 2FAFP71W7WX160863 | $0 - 10,000 | | Law Enforcement 1998 | FORD | CROWN VICTORIA | 2FAFP71W9WX160864 | $0 - 10,000 | | Law Enforcement 1998 | CHEVROLET | 1/2 TON PICKUP | 1GCEC14W2WZ172925 | $0 - 10,000 | | Road & Bridge 1999 | CHEVROLET | TAHOE | 1GNEC13R3XR103438 | $0 - 10,000 | | Administrative 1999 | Ford | Crown Victoria | 2FAFP71W1XX181533 | $20,001 - 30,000 | | Law Enforcement 1999 | FORD | CROWN VICTORIA | 2FAFP71W3XX181534 | $20,001 - 30,000 | | Law Enforcement 1999 | Chevrolet | 1/2 Ton Pickup | 1GCEC14W5XE158493 | $20,001 - 30,000 | | Parks & Recreation 2000 | Pierce | Dash 105' Aerial | 4PICT02S1YA000315 | $20,001 - 30,000 | | Fire Dept 2000 | FORD | CROWN VICTORIA | 2FAFP71W2YX143004 | $20,001 - 30,000 | | Law Enforcement 2000 | FORD | CROWN VICTORIA | 2FAFP71W6YX143006 | $20,001 - 30,000 | | Law Enforcement 2000 | FORD | CROWN VICTORIA | 2FAFP71W4YX143005 | $20,001 - 30,000 | | Law Enforcement 2000 | CHEVROLET | C20 PICKUP | 1GCGC24R3YR172394 | $10,001 - 20,000 | | Parks & Recreation 2000 | CHEVROLET | C30 FLATBED | 1GBJC34R7YF459805 | $20,001 - 30,000 | | Road & Bridge 2000 | CHEVROLET | C10 PICKUP | 1GCEC14W3YE236920 | $10,001 - 20,000 | | Water Dept 2000 | CHEVROLET | C10 PICKUP | 1GCEC14W0YE239970 | $10,001 - 20,000 | | Water Dept 2000 | CHEVROLET | C10 PICKUP | 1GCEC14WXYE239636 | $10,001 - 20,000 | | Water Dept 2001 | Ford | Crown Victoria | 2FAFP71W61X138880 | $10,001 - 20,000 | | Law Enforcement 2001 | Ford | Crown Victoria | 2FAFP71W61X138880 | $10,001 - 20,000 | | Law Enforcement 2001 | Chevrolet | Impala | 2G1WH55KX19230171 | $10,001 - 20,000 | | Law Enforcement 2001 | Ford | F350 | 1FDWF36L81EB39997 | $20,001 - 30,000 | | Water Dept 2001 | Ford | F350 Truck | 1FDWF36L81B39997 | $20,001 - 30,000 | | Water Dept 2002 | Ford | F150 Truck | 1FTRW08692KB26458 | $20,001 - 30,000 | | Fire Dept 2002 | | RADAR UTILITY TRAILE | 4.50199709171412e+16 | $0 - 10,000 | | Law Enforcement 2002 | Ford | Crown Victoria | 2FAFP71W72X138419 | $10,001 - 20,000 | | Law Enforcement 2002 | HOMEMADE | UTILITY TRAILER | 1 | $0 - 10,000 | | Parks & Recreation 2002 | Ford | F350 | 1FDWF36L42EA46752 | $30,001 - 40,000 | | Parks & Recreation 2002 | Chevrolet | Pickup | 1GCEC14V32Z287356 | $0 - 10,000 | | Parks & Recreation 2002 | | UTILITY TRAILER | 1 | $0 - 10,000 | | Water Dept 2003 | Ford | Crown Victoria | 2FAHP71W03X172051 | $20,001 - 30,000 | | Law Enforcement 2003 | Ford | CROWN VICTORIA | 2FAHP71W23X172052 | $20,001 - 30,000 | | Law Enforcement 2003 | Chevrolet | Silverado | 1GCEC14VX3Z208914 | $20,001 - 30,000 | | Parks & Recreation [115 non-empty rows] === Sheet: AllocationInsurance === | | | 2013-2014 Projected Premiums | General Liability & Property 2014 | | 223339 | Total | | 223339 | Payroll up 4.1% from 2012, Lack of claims and ICRMP Discount 5% | | 0.98 | General Liability & Property Proposed | | 218872.22 | 0.98 | | Increase over last year | Fire Department Volunteers | | 7000 | Volunteers Policy | Deductibles & Losses | | 51000 | Total Premium | | 276872.22 | | | | | | | | | | | | | | | | | | | | | | | | | | | | Pay Amount | Pay Amount | Department | | | | | | | | | | Combined Loss & | Combined Loss & | Combined Loss & | | Allocated 2014 Insurance | | Adopted 2009 Insurance | | Adopted 2010 Insurance | | Adopted 2011 Insurance | | Adopted 2012 Insurance | | Adopted 2013 Insurance | | Adopted 2014 Insurance | Proposed 2014 Insurance | | Budget Variance 2013 to 2014 | 218537 | 218537 | | | | | | Don Adjusted | | | | | | Premium Dist. Based upon Payroll | Adjustments based upon budget & Property | | Insurance Payout Loss | Deductible Loss | Deductible Allocation based upon Experience Rating | Deductible Allocation Percentages | Deductible & Loss Allocation | | | | | | | | | | | | | | Less Deductible & Loss /Volunteer Fire | Less Deductible & Loss /Volunteer Fire | | | | | | | | | Bill Amount | Pay Amount Account # | | | Audited Payroll FY 2012 | | | | | Volunteers Policy | Losses 2 year Actual | thru October 1, 2012 to March 2013 History | | | | | | | | | | | | | | | | | & Loss / Volunteer Fire | & Loss / Volunteer Fire 101-010-10-668-10 | Legislative | | 46121 | 0.005870469847606569 | | 1284.8827679887115 | 12240.01205207676 | | 0 | 0 | 0 | 0 | 0 | | 12240.01205207676 | 0.043492427391600294 | 11800 | | 11800 | | 12150 | 0.04031545600015927 | 12840 | 0.04260684895142023 | 13130 | 0.0454348841635379 | 12240.01205207676 | 12240 | 0.043322066292671706 | -890 | 9467.474401401596 | 10460 | | | | 0.04786374847279866 | | 10460 | Executive | | 21037 | 0.00267767555309077 | | 586.0687927447046 | | | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 | Administrative | | 449732 | 0.057243731608243476 | | 12529.06261818042 | | | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 | Finance | | 373885 | 0.04758961468685376 | | 10416.044615456287 | | | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 | Legal | | 222158 | 0.028277180468866247 | | 6189.089264561397 | | | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 | Human Resources | | 89607 | 0.011405546099054266 | | 2496.357195012347 | | | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 101-110-10-668-10 | Building and Grounds | | 123988 | 0.015781700645368556 | | 3454.175855627249 | 12139.622315200993 | | 1300 | 0 | 1500 | 0.04746835443037975 | 2420.8860759493673 | | 14560.50839115036 | 0.05173784562405287 | 19660 | | 20650 | | 21020 | 0.06974739795253893 | 15000 | 0.049774356251659144 | 14430 | 0.0499333875460664 | 14560.50839115036 | 14560 | 0.05153343833507353 | 130 | 11261.963013431965 | 12760 | | | | 0.0583882820758041 | | 12760 | Community Development | | 417878 | 0.053189223975588944 | | 11641.643531614378 | | | 0 | 0 | 0 | 0 | 0 | | | 0 | | | | | 0 | 0 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 | Engineering | | 521869 | 0.06642562452896929 | | 14538.723905541963 | | | 0 | 0 | 0 | 0 | 0 | | | 0 | | | | | 0 | 0 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 101-070-20-668-10 | Police * | | 2326211 | 0.29608966706425977 | | 64805.802749415416 | 60621.722749415414 | | 22183 | 3907 | 6500 | 0.20569620253164558 | 10490.506329113925 | | 71112.22907852934 | 0.25268304040011325 | 44100 | | 36000 | | 38905 | 0.12909241281367873 | 59645 | 0.19791943190868064 | 67255 | 0.23272834230150355 | 71112.22907852934 | 68300 | 0.24173996142070894 | 1045 | 52829.12594899747 | 47300 | | | | 0.2164393214878945 | | 47300 | | | 0 | 0 | | 0 | | | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | 17445 | | 19150 | | 19740 | 0.06550017295828346 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 | Animal Control | | 0 | 0 | | 0 | | | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 101-090-20-668-10 | Fire * | | 378689 | 0.04820108748986978 | | 10549.879025322027 | 10549.879025322027 | 6900 | 683 | 0 | 750 | 0.023734177215189875 | 1210.4430379746836 | | 18660.322063296713 | 0.06630571105557925 | 9450 | | 15100 | | 16290 | 0.054052574340954285 | 21620 | 0.07174143881072471 | 19615 | 0.06787549526792049 | 18660.322063296713 | 18675 | 0.06609800555683366 | -940 | 14444.859840373758 | 11090 | | | | 0.0507465555031871 | | 11090 | 911 Emergency | | | 0 | | 0 | | | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 | Parking | | 0 | 0 | | 0 | | | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | 0 | | | | 0 | 0 | | | | 0 | | 0 105-150-40-668-10 | Streets * | | 466765 | 0.05941176163608942 | | 13003.584163401723 | 18615.630935967063 | | 2812 | 1908 | 2000 | 0.06329113924050633 | 4599.683544303798 | | 23215.314480270863 | 0.08249096284468393 | 15250 | | 15250 | | 19980 | 0.06629652764470635 | 29650 | 0.09838731085744624 | 26870 | 0.09298060452964686 | 23215.314480270863 | 23215 | 0.0821668111915338 | -3655 | 17956.48841736422 | 19565 | | | | 0.08952717388817455 | | 19565 120-160-30-668-10 | Parks and Rec | | 536687 | 0.06831172028148623 | | 14951.537870027916 | 14951.537870027916 | | 12238 | 2872 | 6000 | 0.189873417721519 | 9683.54430379747 | | 24635.082173825387 | 0.08753582252800288 | 18570 | | 7400 | | 10120 | 0.03357962261083225 | 20120 | 0.0667640031855588 | 21445 | 0.07420800387563369 | 24635.082173825387 | 24635 | 0.08719273718300388 | 3190 | 19054.83920576212 | 15950 | | | | 0.07298535259475512 | | 15950 123-190-30-668-10 | 1912 Center | | 0 | 0 | | 0 | 2988.25 | | 0 | 0 | 0 | 0 | 0 | | 2988.25 | 0.010618146910312744 | 2585 | | 2585 | | 2988.25 | 0.009915445382096785 | 2510 | 0.008328908946110963 | 2745 | 0.009498762911569805 | 2988.25 | 2990 | 0.010582759658095457 | 245 | 2312.724547401207 | 2990 | | | | 0.013681893683907072 | | 2990 | Arts Fund | | 99385 | 0.01265013000161269 | | 2768.762036741573 | 0 | | 0 | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | | | | 0 | | 0 120-160-30-668-10 | Transit Center Fund | | | | | 0 | 1195.83 | | 0 | 0 | 0 | 0 | 0 | | 1195.83 | | | | | | | | | | | | 1195.83 | 1195 | 0.004229564478737148 | 1195 | 924.31633248978 | 1195 | | | | 0.00546818158938761 | | 1195 220-220-70-668-10 | Water | | 631288 | 0.08035292316202718 | | 17587.022675962307 | 40677.79044498266 | | 21839 | 975 | 10500 | 0.3322784810126582 | 16946.20253164557 | | 57623.99297662823 | 0.20475529925028638 | 52500 | | 52500 | | 59185 | 0.1963843838164137 | 42215 | 0.14008162994425272 | 51215 | 0.17722373133553646 | 57623.99297662823 | 57625 | 0.20395703187215744 | 6410 | 44572.15787424567 | 43952 | | | | 0.20111926126925875 | | 43952 230-230-60-668-10 | Sewer | | 660658 | 0.08409125709720215 | | 18405.24012345539 | 41496.00789247574 | | 7346 | 409 | 3500 | 0.11075949367088607 | 5648.734177215189 | | 47144.74206969093 | 0.16751938336644523 | 75000 | | 75000 | | 90950 | 0.3017852447090112 | 91630 | 0.30405495088930184 | 62335 | 0.21570323719224183 | 47144.74206969093 | 51045 | 0.18066788185534535 | -11290 | 39482.61689702161 | 46945 | | | | 0.21481488260569148 | | 46945 240-240-50-668-10 | Sanitation | | 63290 | 0.008055810512673614 | | 1763.193130808212 | 1763.193130808212 | | 0 | 0 | 0 | 0 | 0 | | 1763.193130808212 | 0.006265153080959046 | 4200 | | 4200 | | 4345 | 0.014417337968781238 | 4895 | 0.016243031590124767 | 2915 | 0.01008702873851584 | 1763.193130808212 | 1765 | 0.006247013644327251 | -1150 | 1365.2036207903445 | 1465 | | | | 0.006703670316696944 | | 1465 290-290-10-668-10 | Fleet Management | | 201445 | 0.02564074496327281 | | 5612.046772565338 | 0 | | 1700 | 719 | 850 | 0.02689873417721519 | 0 | | 0 | 0 | 2100 | | 3800 | | 4465 | 0.014815515311992686 | 0 | | | | 0 | 0 | 0 | 0 | 0 | 0 | | | | 0 | | 0 295-295-10-668-11 | Information Systems | | 225748 | 0.02873413037786448 | | 6289.102905572638 | 6289.102905572638 | | 0 | 0 | 0 | 0 | 0 | | 6289.102905572638 | 0.022347065535161047 | | | 0 | | 1235 | 0.004097908490551169 | 1235 | 0.004098088664719936 | 7030 | 0.02432652213782722 | 6289.102905572638 | 6290 | 0.02226272851151185 | -740 | 4865.229900720265 | 4865 | | | | 0.022261676512444116 | | 4865 | Totals | | 7856441 | 0.9999999999999997 | | 218872.21999999997 | 223528.57932184942 | 6900 | 70101 | 10790 | 31600 | 1 | 51000.00000000001 | | 281428.5793218494 | 0.995750857987197 | 272660 | | 263435 | | 301373.25 | 1 | 301360 | 0.9999999999999998 | 288985 | 1 | 281428.5793218494 | 282535 | 0.9999999999999999 | -6450 | 218537 | 218537 | | | | 0.9999999999999999 | 218537 | 218537 | | | | | | | | | | | | | | | 281428.57932184945 | | | | | | | | | | | | | | | | | | | 300315.89999999997 | | | | | | | | | Two Year Total | | | | | | | | Fire | 2584 | | | | | | | | Police | 7883 | | | | | | | | Building & Grounds Maintenance | 58022 | | | | | | | | Engineer/Surveyors | | | | | | | | Parks & Recreations | 2028 | | | | | | | | Road & Bridge & Street | 12992 | | | | | | | | Sanitation | | | | | | | | Water Department | 12511 | | | | | | | | Sewer Department | 33533 | | | | | | | | I/S Department | 684 | | | | | | | | | 127653 | Actual Insurance paid Account # | | | 2011 Losses | | | Actual FY 2012 Insurance | Volunteers | 2012 Premium | 2012 Losses | Actual FY 2013 Insurance | Volunteers | 2013 Premium | TO March 2013 Losses 101-010-10-668-10 | Legislative | | 0 | | | 9556 | | 9556 | | 10673 | | 10673 | Executive | Administrative | Finance | Legal | Human Resources 101-110-10-668-10 | Building and Grounds | | | | | 12465 | | 11165 | 1300 | 11730 | | 11730 | Community Development | Engineering 101-070-20-668-10 | Police * | | 11907 | | | 54670 | | 44394 | 10276 | 50241 | | 46334 | 3907 | Animal Control 101-090-20-668-10 | Fire * | | | | | 14739 | 6352 | 7704 | 683 | 15423 | 6481 | 8942 | 0 | 911 Emergency | Parking 105-150-40-668-10 | Streets * | | 2812 | | | 22119 | | 22119 | | 23830 | | 21922 | 1908 120-160-30-668-10 | Parks and Rec | | 8110 | | | 19103 | | 14975 | 4128 | 20304 | | 17432 | 2872 123-190-30-668-10 | 1912 Center | | 0 | | | 1868 | | 1868 | | 2232 | | 2232 128-190-30-668-11 | Transit Center | Arts Fund 220-220-70-668-10 | Water | | 3211 | | | 50049 | | 31421 | 18628 | 42607 | | 41632 | 975 230-230-60-668-10 | Sewer | | 3768 | | | 71779 | | 68201 | 3578 | 57311 | | 56902 | 409 240-240-50-668-10 | Sanitation | | 0 | | | 3643 | | 3643 | | 2370 | | 2370 290-290-10-668-10 | Fleet Management | | 1700 | | | 919 | | 919 | 0 | 719 | | | 719 295-295-10-668-11 | Information Systems | | 0 | | | 919 | | 919 | | 3252 | | 3252 | Totals | | 31508 | | | 261829 | | 216884 | 38593 | 240692 | 6481 | 223421 | 10790 [78 non-empty rows] === Sheet: Allocation of Premium2017 === | | | 2017-2018 Projected Premiums | | | | | | | | Information comes from Shawn Sullivan at American Insurance across the Street | General Liability & Property 2018 | | 235627.00000000003 | | | | | 208-***-**44 s***@americaninsuranceid.com | | | | | Usually first week of May. | Total | | 235627.00000000003 | | | 1 | General Liability & Property Proposed | | 235627.00000000003 | 1 | Increase over last year | No Allocation for 1912 & Transit CTR | | 6500 | Fire Department Volunteers | | 6900 | Volunteers Policy | Deductibles & Losses | | 60000 | Total Premium | | 309027 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Insurance less Fire | | 2017Insurance | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | with Deductibles | | Insurance less Fire | Department | | | | | | | | Combined Loss & | Combined Loss & | Combined Loss & | | 2017 | | Adopted 2009 Insurance | | Adopted 2010 Insurance | | Adopted 2011 Insurance | | Adopted 2012 Insurance | | Adopted 2013 Insurance | | Adopted 2014 Insurance | | Adopted 2015 Insurance | | Adopted 2016 Insurance | | 2017 | Adopted 2017 Insurance | | Budget Variance 2016to 2017 | | 2016 Insurance | | with Deductibles | | Budget Variance 2014 to 2015 | | | | | Premium Dist. Based upon Payroll | Adjustments based upon budget & Property | | Insurance Payout Loss | Deductible Allocation based upon Experience Rating | Deductible Allocation Percentages | Deductible & Loss Allocation | | | | | | | | | | | | | | | | | | | | Less Deductible & Loss /Volunteer Fire | Less Deductible & Loss /Volunteer Fire | | | | | | Pay Amount Account # | | | Audited Payroll FY 2016 | | | | Volunteers Policy | Losses 1 year Actual | | | | | | | | | | | | | | | | | | | | | | | & Loss / Volunteer Fire | & Loss / Volunteer Fire | | | | | | 235627 101-010-10-668-10 | Legislative | | 50604 | 0.0056112620882091645 | 1322.164852058461 | 12228.368386962853 | | 0 | 0 | 0 | 0 | | 12228.368386962853 | 0.03957055010391601 | 11800 | | 11800 | | 12150 | 0.04030051246330663 | 12840 | 0.04260684895142023 | 13130 | 0.0454348841635379 | 12240 | 0.042711332112012564 | 12440 | 0.04132890365448505 | 12675 | 0.040994210679517445 | 12228.368386962853 | 12230 | 0.03957582994366188 | -445 | | | 0.042069102857711836 | 10412.616499054067 | | -1817.3835009459326 | Executive | | 22682 | 0.0025151104000624507 | 592.6279182355152 | 0 | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 | Administrative | | 477330 | 0.052929091229248285 | 12471.522979074087 | 0 | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 | Finance | | 411832 | 0.04566629689967901 | 10760.212539580667 | 0 | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 | Legal | | 214320 | 0.02376503222561434 | 5599.683248224831 | 0 | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 | Human Resources | | 70148 | 0.007778413029873063 | 1832.8041269899004 | 0 | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 101-110-10-668-10 | Building and Grounds | | 127048 | 0.014087811749719348 | 3319.4688191511214 | 10751.956194365852 | | 0 | 0 | 0 | 0 | | 10751.956194365852 | 0.034792934579715856 | 19660 | | 20650 | | 21020 | 0.0697215450188235 | 15000 | 0.049774356251659144 | 14430 | 0.0499333875460664 | 14560 | 0.050806944080956117 | 14605 | 0.04852159468438538 | 11750 | 0.038002522720657204 | 10751.956194365852 | 10755 | 0.03480278422273782 | -995 | | | 0.03899897109097547 | 11689.210561253278 | | 934.2105612532778 | Community Development | | 471239 | 0.052253686174721335 | 12312.379312291065 | 0 | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 | Engineering | | 600076 | 0.06653987251688014 | 15678.590541534917 | 0 | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 101-070-20-668-10 | Police * | | 2452174 | 0.27191113350510276 | 64069.60465440686 | 64069.60465440686 | | 5885.47 | 5885.47 | 0.14156469290491605 | 8493.881574294963 | | 72563.48622870182 | 0.23481277114524562 | 44100 | | 36000 | | 38905 | 0.12904456274773207 | 59645 | 0.19791943190868064 | 67255 | 0.23272834230150355 | 68300 | 0.23833202477536422 | 72885 | 0.24214285714285713 | 75750 | 0.24499498690125812 | 72563.48622870182 | 72565 | 0.2348176696534607 | -3185 | | | 0.2514188987354376 | 53241.080852334955 | | -19323.919147665045 | | | 0 | 0 | 0 | 0 | | | | | 0 | | 0 | 0 | 17445 | | 19150 | | 19740 | 0.06547589432310065 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 | | | 0 | 0 | 0 | 0 | | | | | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 101-090-20-668-10 | Fire * | | 414356 | 0.04594617251248906 | 10826.15879060026 | 10826.15879060026 | 6900 | 7622 | 7622 | 0.18333388655812874 | 11000.033193487725 | | 28726.191984087985 | 0.09295690015464016 | 9450 | | 15100 | | 16290 | 0.05403253893228519 | 21620 | 0.07174143881072471 | 19615 | 0.06787549526792049 | 18675 | 0.065166186862078 | 19070 | 0.06335548172757476 | 19750 | 0.06387658074323231 | 28726.191984087985 | 28730 | 0.09296922275399884 | 8980 | | | 0.03933087722791995 | 9267.416608583093 | | -19462.583391416905 | 911 Emergency | | | 0 | 0 | 0 | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 | Parking | | | 0 | 0 | 0 | | | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | | | | | | | | 0 | | | 0 | | | | | | 0 105-150-40-668-10 | Streets * | | 447972 | 0.049673707615588404 | 11704.46670433825 | 11704.46670433825 | | 10551.08 | 10551.08 | 0.2537877858548598 | 15227.267151291588 | | 26931.73385562984 | 0.08715009968588452 | 15250 | | 15250 | | 19980 | 0.06627195382854868 | 29650 | 0.09838731085744624 | 26870 | 0.09298060452964686 | 23215 | 0.08100846200820029 | 27380 | 0.09096345514950166 | 27750 | 0.08975063876580744 | 26931.73385562984 | 26950 | 0.0872092082568837 | -800 | | | 0.09210395300209101 | 21702.1781340237 | | -5247.821865976301 120-160-30-668-10 | Parks and Rec | | 964191 | 0.10691503446550633 | 25192.068826003862 | 25192.068826003862 | | 10933.880000000001 | 10933.880000000001 | 0.2629953707111248 | 15779.722242667487 | | 40971.79106867135 | 0.13258320816197727 | 18570 | | 7400 | | 10120 | 0.033567175813058694 | 20120 | 0.0667640031855588 | 21445 | 0.07420800387563369 | 21435 | 0.07479717351478671 | 21620 | 0.07182724252491694 | 22505 | 0.07278695947475662 | 40971.79106867135 | 40942 | 0.13248680536004945 | 18437 | | | 0.07469547611935344 | 19600.270951574894 | | -21341.729048425106 123-190-30-668-10 | 1912 Center | | 0 | 0 | | 3100 | | 0 | 0 | 0 | 0 | | 3100 | 0.010031485921942095 | 2585 | | 2585 | | 3100 | 0.01028243527870375 | 2510 | 0.008328908946110963 | 2745 | 0.009498762911569805 | 1195 | 0.004169938061589462 | 1495 | 0.004966777408637874 | 3100 | 0.010026197483747857 | 3100 | 3100 | 0.010031485921942095 | 0 | | | 0.010289090245278635 | 2924.387467224269 | | -175.61253277573087 | Arts Fund | | 126933 | 0.014075059889389254 | 3316.4641365571224 | | | 0 | 0 | 0 | 0 | | 0 | 0 | | | | | 0 | 0 | 0 | | | 0 | | | | | | 0 | 0 | | 0 | 0 | | | 0 | 0 | | 0 128-198-40-668-10 | Transit Center Fund | | 0 | | | 3400 | | 0 | 0 | 0 | 0 | | 3400 | 0.01100227488213004 | | | | | | | | | | | | | 1195 | 0.003970099667774086 | 3400 | 0.010996474659594423 | 3400 | 3400 | 0.01100227488213004 | 0 | | | 0.011284808656112052 | 1259.0056092137147 | | -2140.9943907862853 220-220-70-668-10 | Water | | 795196 | 0.08817589849607886 | 20776.622434935576 | 42889.41938112007 | | 25 | 25 | 0.0006013312993903462 | 36.07987796342077 | | 42925.49925908349 | 0.1389053359709135 | 52500 | | 52500 | | 59185 | 0.19631159095809078 | 42215 | 0.14008162994425272 | 51215 | 0.17722373133553646 | 57625 | 0.2010817412544709 | 59860 | 0.19887043189368772 | 59270 | 0.1916944273747534 | 42925.49925908349 | 42925 | 0.13890372038689175 | -16345 | | | 0.19672076736698862 | 46352.72425238143 | | 3427.7242523814275 230-230-60-668-10 | Sewer | | 830574 | 0.09209881427658363 | 21700.967311548575 | 43813.76425773307 | | 6219.59 | 6219.59 | 0.14960136545500813 | 8976.081927300487 | | 52789.84618503356 | 0.1708259996215009 | 75000 | | 75000 | | 90950 | 0.3016733834187439 | 91630 | 0.30405495088930184 | 62335 | 0.21570323719224183 | 54245 | 0.18928727209282037 | 54965 | 0.18260797342192692 | 58430 | 0.188977651282383 | 52789.84618503356 | 52790 | 0.170826497361072 | -5640 | | | 0.19393275581665506 | 47595.793454810984 | | -5194.206545189016 240-240-50-668-10 | Sanitation | | 70267 | 0.007791608433171159 | 1835.913320282821 | 1835.913320282821 | | 0 | 0 | 0 | 0 | | 1835.913320282821 | 0.00594094794397519 | 4200 | | 4200 | | 4345 | 0.014411993963215417 | 4895 | 0.016243031590124767 | 2915 | 0.01008702873851584 | 1765 | 0.00615894617464887 | 1865 | 0.006196013289036545 | 1810 | 0.00585400562760762 | 1835.913320282821 | 1835 | 0.0059379924731495955 | 25 | | | 0.006007501078694945 | 1415.5294566696537 | | -419.47054333034635 290-290-10-668-10 | Fleet Management | | 208090 | 0.023074214052949273 | 5436.907834654279 | 5436.907834654279 | | 337.4 | 337.4 | 0.008115567216572112 | 486.9340329943267 | | 5923.841867648606 | 0.019169334290041345 | 2100 | | 3800 | | 4465 | 0.014810023715939433 | 0 | | | | 6290 | 0.021948879002006455 | 6490 | 0.021561461794019934 | 6900 | 0.022316375044471037 | 5923.841867648606 | 5925 | 0.019173081963711907 | -975 | | | 0.022901523449168574 | 5396.217265757244 | | -528.7827342427563 295-295-10-668-11 | Information Systems | | 263260 | 0.02919178043913415 | 6878.371649531863 | 6878.371649531863 | | 0 | 0 | 0 | 0 | | 6878.371649531863 | 0.022258157538117586 | | | 0 | | 1235 | 0.004096389538451333 | 1235 | 0.004098088664719936 | 7030 | 0.02432652213782722 | 7030 | 0.024531100061066038 | 7130 | 0.023687707641196012 | 6100 | 0.019728969242213526 | 6878.371649531863 | 6880 | 0.0222634268203102 | 780 | | | 0.020246274353612797 | 4770.568887118722 | | -2109.431112881278 | Totals | | 9018292 | 1 | 235627.00000000006 | 242127 | 6900 | 41574.420000000006 | 41574.420000000006 | 1 | 60000 | | 309027 | 0.9999999999999999 | 272660 | | 263435 | | 301485 | 1 | 301360 | 0.9999999999999998 | 288985 | 1 | 286575 | 1 | 301000 | 0.9999999999999999 | 309190 | 1 | 309027.00000000006 | 309027 | 1.0000000000000002 | -163 | | 0 | 1 | 235626.99999999997 | | -73400.00000000001 | | | | | | | | | | | | | 309027 | | | | | | | | Two Year Total | | | | | | | Legislative | 0 | | | | | | | Fire | 7622 | | | | | | | Police | 5885.47 | | | | | | | Building & Grounds Maintenance | 0 | | | | | | | Engineer/Surveyors | 0 | | | | | | | Parks & Recreations | 10933.880000000001 | | | | | | | Road & Bridge & Street | 10551.08 | | | | | | | Sanitation | 0 | | | | | | | Water Department | 25 | | | | | | | Sewer Department | 6219.59 | | | | | | | Fleet Fund | 337.4 | | | | | | | I/S Department | 0 | | | | | | | | 41574.420000000006 | Actual Insurance paid | | | | Run Trial Balance Details Account # | | | | 2015 Losses from April on | 2016 Losses to March | Actual FY 2016 Insurance | Volunteers | 2015 Premium | TO March 2015 Losses 101-010-10-668-10 | Legislative | | | | 0 | 10412.62 | | | 0 | Executive | Administrative | Finance | Legal | Human Resources 101-110-10-668-10 | Building and Grounds | | | 0 | 0 | 11689.21 | Community Development | Engineering 101-070-20-668-10 | Police * | | | 1611.5 | 4273.97 | 53241.08 | | | 4273.94 | Animal Control 101-090-20-668-10 | Fire * | | | 6789 | 833 | 9267.42 | 5762.5 | | 833 | 911 Emergency | Parking 105-150-40-668-10 | Streets * | | | 2272.52 | 8278.56 | 21702.18 | | | 8278.56 120-160-30-668-10 | Parks and Rec | | | 9496.94 | 1436.94 | 19600.27 | | | 1436.94 123-190-30-668-10 | 1912 Center | | | | | 2924.39 128-190-30-668-11 | Transit Center | | | | | 1259 | Arts Fund 220-220-70-668-10 | Water | | | 0 | 25 | 46352.72 | | | 25 230-230-60-668-10 | Sewer | | | 2088.12 | 4131.47 | 47595.79 | | | 4131.47 240-240-50-668-10 | Sanitation | | | 0 | | 1415.53 | | | 0 290-290-10-668-10 | Fleet Management | | | 337.4 | | 5396.22 295-295-10-668-11 | Information Systems | | | 0 | | 4770.57 | | | 0 | Totals | | | 22595.48 | 18978.91 | 235627.00000000003 | 5762.5 | 0 | 18978.91 [83 non-empty rows] === Sheet: 2027 === | | | 2026-2027 Projected Premiums | General Liability & Property 2025 | | 532314.54 | | | | | | | Usually first week of May. | Total | | 532314.54 | | | 1.03 | General Liability & Property Proposed | | 548283.9762 | | | 1.03 | Increase over last year | Allocation for Volunteers, 1912 & Transit CTR | | 17000 | Deductibles & Losses | | 36000 | Total Premium | | 601283.9762 | Department | | | | | | | | | | | | | | | | 2025 Insurance Premium Allocation for blue slip | | Budget Variance 2014 to 2015 | | | | | | | General Liability Premium Dist. Based on Payroll & FAs | | | Calculate share of Deductiblel Account # | | | Audited Payroll FY25 | ICRMP Fixed Assets FY26 | TOTAL | | | Volunteers Policy 1912 Center Transit Center | | Losses | % of Losses | Share of Deductible | | 2027 Calculation | 2027 Budget Rounded | % of Total | 266157.27 101-010-668-10 | Legislative | | 75801.32 | 280799.94594404893 | 356601.26594404894 | 0.002607238402038835 | 22388.179991580124 | | | 0 | 0 | 0 | | 22388.179991580124 | 22388.179991580124 | 0.03723395413439944 | 9910.08758371697 | | -12478.092407863154 Allocated | Executive | | 35256.26 | 130603.59222442168 | 165859.8522244217 | 0.0012126602381267153 | | | | 0 | 0 | 0 | | 0 | 0 | | | | 0 Allocated | Administrative | | 503646.07 | 1865724.325205953 | 2369370.395205953 | 0.01732330777536878 | | | | 0 | 0 | 0 | | 0 | 0 | | | | 0 Allocated | Finance | | 572452.67 | 2120615.446438815 | 2693068.116438815 | 0.01968997668557729 | | | | 0 | 0 | 0 | | 0 | 0 | | | | 0 101-050-668-10 | Legal | | 476474.59 | 1662699.9603840676 | 2139174.5503840675 | 0.015640264264514946 | 8575.306279767023 | | | 0 | 0 | 0 | | 8575.306279767023 | 8575.306279767023 | 0.014261657751070174 | 3795.843892699177 | | -4779.462387067846 101-060-668-10 | Human Resources | | 277821.15 | 271357.174780314 | 549178.324780314 | 0.004015237618812175 | 2201.4904470301594 | | | 0 | 0 | 0 | | 2201.4904470301594 | 2201.4904470301594 | 0.0036613156747385142 | 974.485784596611 | | -1227.0046624335484 101-110-668-10 | Buildings & Grounds | | 249249.81 | 14342145.355044095 | 14591395.165044095 | 0.10668286808492645 | 58492.50710602356 | | | 4838.75 | 0.6364598952989767 | 22912.556230763163 | | 81405.06333678673 | 81405.06333678673 | 0.13538538620511925 | 36033.8047902502 | | -45371.25854653653 101-120-668-10 | Community Development | | 1959106.92 | 1173973.116646392 | 3133080.036646392 | 0.02290705998078927 | 12559.573929319036 | | | 0 | 0 | 0 | | 12559.573929319036 | 12559.573929319036 | 0.020887923886967932 | 5559.472797723174 | | -7000.101131595862 101-070-668-10 | Police | | 4629505.59 | 11961736.959999999 | 16591242.549999999 | 0.1213044620001092 | 66509.29275622168 | | | 0 | 0 | 0 | | 66509.29275622168 | 66509.29275622168 | 0.11061211572034187 | 29440.218749050277 | | -37069.0740071714 101-090-668-10 | Fire | | 1103493.32 | 7732769.52 | 8836262.84 | 0.0646050533386818 | 35421.915527145546 | 12000 | | 2129.89 | 0.280152842448636 | 10085.502328150895 | | 57507.417855296444 | 57507.417855296444 | 0.09564102841843942 | 25455.555023844256 | Don’t forget to remove voluteer portion for the two equal payments. Take I24 out of formula. | -32051.86283145219 105-150-668-10 | Streets | | 843664.25 | 4906849.224604757 | 5750513.474604757 | 0.04204404469159597 | 23052.07599903874 | | | 0 | 0 | 0 | | 23052.07599903874 | 23052.07599903874 | 0.03833808468458359 | 10203.959956677581 | | -12848.11604236116 120-160-668-10 | Recreation & Culture | | 1990777.09 | 15520057.56322685 | 17510834.653226852 | 0.12802792620149794 | 70195.66044239746 | | | 0 | 0 | 0 | | 70195.66044239746 | 70195.66044239746 | 0.1167429421386225 | 31071.98277138373 | | -39123.677671013735 123-190-668-10 | 1912 Center | | 0 | 0 | 0 | 0 | | 2500 | | 0 | 0 | 0 | | 2500 | 2500 | 0.00415776920549176 | 1106.620501023756 | | -1393.379498976244 121-185-668-10 | MSDCP | | 60359.76 | 0 | 60359.76 | 0.00044131162516551317 | 241.96409258903157 | | | 0 | 0 | 0 | | 241.96409258903157 | 241.96409258903157 | 0.000402412341200573 | 107.10497014825305 128-198-668-10 | Transit Center Fund | | 0 | 0 | 0 | 0 | | 2500 | | 0 | 0 | 0 | | 2500 | 2500 | 0.00415776920549176 | 1106.620501023756 | | -1393.379498976244 220-220-668-10 | Water | | 1408085.05 | 19957655.189999998 | 21365740.24 | 0.15621250893274924 | 85648.81552982578 | | | 0 | 0 | 0 | | 85648.81552982578 | 85648.81552982578 | 0.14244320307870162 | 37912.29406148282 | | -47736.52146834296 230-230-668-10 | Sewer | | 1457675.38 | 35172227.93 | 36629903.31 | 0.26781422191525794 | 146838.2464746068 | | | 633.96 | 0.08338726225238735 | 3001.9414410859445 | | 149840.18791569275 | 149840.18791569275 | 0.24920036762438635 | 66326.48952990306 | | -83513.69838578968 235-235-668-10 | Stormwater | | 503616 | 76198.28 | 579814.28 | 0.004239227959172997 | 2324.300761473582 | | | 0 | | | | 2324.300761473582 | 2324.300761473582 | 0.0038655624521423634 | 1028.8475492767172 240-240-668-10 | Sanitation | | 202648.61 | 1602569.67 | 1805218.2799999998 | 0.013198591461021255 | 7236.576206488102 | | | 0 | 0 | 0 | | 7236.576206488102 | 7236.576206488102 | 0.012035205481812245 | 3203.2574349281817 | | -4033.31877155992 290-130-668-10 | Fleet Management | | 370516.3 | 251404.40028059477 | 621920.7002805948 | 0.004547082940106178 | 2493.0927145126016 | | | 0 | 0 | 0 | | 2493.0927145126016 | 2493.0927145126016 | 0.004146281645934542 | 1103.5630035330444 | | -1389.5297109795572 295-130-668-10 | Information Systems | | 506814.75 | 517202.82521968597 | 1024017.5752196859 | 0.007486955884487409 | 4104.977941980745 | | | 0 | 0 | 0 | | 4104.977941980745 | 4104.977941980745 | 0.006827020350556192 | 1817.0610987384791 | | -2287.9168432422657 | Totals | | 17226964.89 | 119546590.48 | 136773555.37 | 0.9999999999999999 | 548283.9761999999 | 17000 | | 7602.599999999999 | 1 | 36000 | | 601283.9761999999 | 601283.9761999999 | 0.9999999999999999 | 266157.27 | | -333696.3938653623 | | | | | | | | | | | | | | 601283.9761999999 | 601283.9761999999 | | 532314.54 | Actual Insurance paid | | | | Run a detailed trial balance report of 668-10 for all funds Account # | | | | 2025 Losses from April to October | 2026 Losses October to April | FY 2026 Insurance Budget | Volunteers 101-010-668-10 | Legislative | | | | | 21621.74372137143 | Executive | | | | | 0 | Administrative | | | | | 0 | Finance | | | | | 0 | Legal | | | | | 8103.54384225236 | Human Resources | | | | | 2078.0396240759333 101-110-668-10 | Building and Grounds | | | 0 | 4838.75 | 56151.646220761504 | Community Development | | | | | 11224.707857697851 101-070-668-10 | Police * | | | | 0 | 64057.376038185255 101-090-668-10 | Fire * | | | 2129.89 | | 45203.36265020772 105-150-668-10 | Streets * | | | 0 | | 38035.47790271764 120-160-668-10 | Parks and Rec | | | | | 72296.74157747258 121-185-668-10 | MSDCP | | | | | 2500 123-190-668-10 | 1912 Center | | | | | 241.30935898987155 128-190-668-10 | Transit Center | | | | | 2500 220-220-668-10 | Water | | | 0 | 0 | 79760.61968091557 230-230-668-10 | Sewer | | | 633.96 | | 140619.57291411463 235-235-668-10 | Stormwater | | | | | 2140.6304974700824 240-240-668-10 | Sanitation | | | | | 7035.07660553702 290-290-668-10 | Fleet Management | | | | | 2186.112828780949 295-295-668-10 | Information Systems | | | 0 | | 19121.038679449586 | Totals | | | 2763.85 | 4838.75 | 574876.9999999998 | 0 [59 non-empty rows]