The URL can be used to link to this page

Home My WebLink About2017-07-10-J01G ICAP Renewal FY2018jv,o Waukee Vo. , &10 THE KEY TO GOOD LIVING AGENDA ITEM: CITY OF WAUKEE, IOWA CITY COUNCIL MEETING COMMUNICATION MEETING DATE: July 10, 2017 AGENDA ITEM: Renewal with Iowa Communities Assurance: Pool (ICAP) for 07/01/2017 — 06/30/2018 Property, Auto, Professional and Liability insurance. FORMAT: Resolution SYNOPSIS INCLUDING PRO & CON: The attached reports provide detail for the 2017/2018 insurance renewal and annual billing. Even with an increase in vehicle valuations of $483,170 and an increase property valuations of $864,491, our premiums decreased $335.52 or (0.18)% over last year. There was no increase to our overall premium rate structure. Total Member credit — ($19,404.45) compared to prior year of ($14, 861.09) or and increased credit of ($4,543.36). Staff discovered one items that should have been removed from the equipment listing in March; that item will be corrected by ICAP and issued as an additional credit once revisions are completed. This is the first renewal with Holmes Murphy as our agent, and the change to July 1 renewal instead of the prior April 1 renewal. FISCAL IMPACT INCLUDING COST/BENEFIT ANALYSIS: $185,652.52 COMMISSION/BOARDICOMMITTEE COMMENT: STAFF REVIEW AND COMMENT: Staff recommends approving the total payment to ICAP. RECOMMENDATION: Approve the Resolution. ATTACHMENTS: ICAP Renewal paperwork PREPARED BY: Linda Burkhart . b REVIEWED BY: PUBLIC NOTICE INFORMATION — NAME OF PUBLICATION: DATE OF PUBLICATION: THE CITY OF WAUKEE, IOWA RESOLUTION APPROVING PAYMENT TO IOWA COMMUNITIES ASSURANCE POOL (ICAP) FOR 04/O1/2016 — 03/31/2017 PROPERTY, AUTO, PROFESSIONAL & LIABILITY INSURANCE IN THE AMOUNT OF $185,652.52 IN THE NAME AND BY THE AUTHORITY OF THE CITY OF WAUKEE, IOWA WHEREAS, the City of Waukee, Dallas County, State of Iowa, is a duly organized Municipal Organization; AND, WHEREAS, Iowa Communities Assurance Pool (ICAP) provides property, auto, professional and liability insurance services for the City; AND, WHEREAS, ICAP proposes a renewal of policies for the period of July 1, 2017 through June 30, 2018 at a cost of $205,056.97 less member distribution credit of $19,404.45, for a total payment of $185,652.52; AND, WHEREAS, City staff recommend approval of the payment. NOW THEREFORE BE IT RESOLVED by the City Council of the City of Waukee, Iowa on this the 1 Oth day of July, 2017, that it hereby approves payment to Iowa Communities Assurance Pool (ICAP) for 07/01/2017 — 06/30/2018 property, auto, professional & liability insurance in the amount of $185,652.52. William F. Peard, Mayor Attest: Rebecca D. Schuett, City Clerk ROLL CALL VOTE AYE NAY ABSENT ABSTAIN Anna Bergman R. Charles Bottenberg Brian Harrison Shelly Hughes Larry R. Lyon Iowa Communities Assurance Pool INVOICE •; City of Waukee Anniversary Date: 07/01/2017 5701 Greendale Road Johnston,lA 50131 www.icapiowa.com Coverage General Liability Automobile Liability Law Enforcement Liability Public Officials Wrongful Acts Excess Liability Vehicles Property Equipment Breakdown Crime TOTAL CONTRIBUTION L City of Waukee Effective Date: 07/01 /2017 Contribution $37,821.40 $14,074.31 $7,134.08 $7,862.35 $17,085.97 $32,173.96 $88,904.90 Included $0.00 $205,056.97 Limit of Coverage $2,000,000 $2,000,000 $2,000,000 $2,000,000 $6,000,000 $6,715,536 $48,137,223 Included $5,000 Limit of Coverage Excess Liability Options Contribution Liability Effective Excess Liability $18,333.97 $7,000,000 07/01/2017 Excess Liability $19,524.37 $8,000,000 07/01/2017 Retroactive Date 07/01/2017 07/01 /2017 07101 /2017 07/01 /2017 Member Name: Member Address: City, State, Zip: Member #: 59 Iowa Communities Assurance Pool 5701 Greendale Road Johnston, IA 50131 City of Waukee 230 Hickman Waukee, IA 50263-5004 Coverage General Liability Automobile Liability Law Enforcement Liability Public Officials Wrongful Acts Excess Liability Vehicles Property Equipment Breakdown Crime FINAL CONTRIBUTION Anniversary Date: 04/01/2017 Limit of Coverage $2,000,000 $2,000,000 $2,000,000 $2,000,000 $6,000,000 $6,715,536 $48,137,223 Included $5,000 $205,056.97 Contribution $37,821.40 $14.074.31 $7,134.08 $7,862.35 $17,085.97 $32,173.96 $88,904.90 Included $0.00 When you provide a check as payment, you authorize us either to use information from your check to make a one-time electronic fund transfer from your account or to process the payment as a check transaction. When we use information from your check to make an electronic fund transfer, funds may be withdrawn from your account as soon as the same day we receive your payment, and you will not receive your check back from your financial institution. If you have further questions regarding this process or do not wish to participate please call us at 515-276-7557. Iowa Communities Assurance Pool 5701 Greendale Road Johnston, IA 50131 In recognition of continued ICAP membership Number 59 Date 06/13/2017 City of Waukee $ $19,404.45 Nineteen Thousand Four Hundred Four Dollars and Forty Five Cents FOR: Member Distribution Redemption THE ICAP BOARD OF DIRECTORS Not Negotiable Voucher must be applied with current year anniversary invoice May 1, 2017 Tim Moerman, City Administrator Waukee 230 Hickman Waukee, IA 50263 Dear Tim: For the twenty-fifth consecutive year, the [CAP Board of Directors has approved property and casualty credits to ICAP members that have fully funded their Cumulative Reserve Funds (CRF). This program, the CRF return, is in addition to the CRF refund program, which is entering its eleventh year. The ICAP Board is of the opinion the CRF return program, which will benefit 754 Iowa public entities this year, is evidence not only of the strength and viability of the ICAP program, but also of the committed loss control efforts of our members. It is made possible because of you — our members. Your commitment to the program, and to its overall loss experience and financial condition, make for a more stable Pool and, consequently, enable us to continue to give back. This year, ICAP will return a total of $3.7M to the ICAP Membership. Your entity alone will receive $19404.45 in the form of a credit voucher. Please deduct this amount from your invoiced anniversary contribution and return the voucher to our office when you remit your contribution payment (the invoiced amount less the credit listed on your voucher). Please contact your ICAP underwriter if you have questions or require assistance. We appreciate your support and continued participation in the Pool, and we always welcome your feedback regarding the services and offerings ICAP affords. If, at any time, the Board and I can be of assistance to your entity, please let us know. Sincerely, Jody E. Smith, Chairman ICAP Board of Directors JES:jeb CC: Mark Currie INSPRO, Inc. 1\ D Iowa Communities Assurance Pool Commitment to Continue Membership I, City of Waukee, do hereby affix my signature to this form and promise to submit the contribution of $205,056.97 (less attached vouchers if applicable) by -71n6,bn . In order to fulfill this commitment, our check will be received by the Iowa Communities Assurance Pool, at the address on this form, no later than Printed Name L ilda, aurjt�,, - Signature Yirda tl'td Date to- IS-aol`7 Iowa Communities Assurance Pool 5701 Greendale Road Johnston, IA 50131 NEZD Iowa Communities Assurance Pool Anniversary Information Acknowledgement The undersigned representative of the City of Waukee acknowledges that he/she: Reviewed the information provided on all Iowa Communities Assurance Pool applications and all applicable supplemental applications. dReviewed all applicable property and vehicle schedules. 2 Confirms, to the best of his/her knowledge, that all information provided is complete and accurate. dReviewed the optional coverage(s) offered by the Iowa Communities Assurance Pool for increased limits. After consideration of the coverage(s) offered and the contribution for same, City of Waukee has elected to: dWaive any and all coverage(s) and any applicable contribution charges. City of Waukee understands that to add increased limits coverage in the future, it will be subject to Iowa Communities Assurance Pool's approval and underwriting guidelines at the time of the request and that such request must be made in writing. In addition, City of Waukee will not hold the Iowa Communities Assurance Pool responsible for this decision to waive optional coverage(s). Accept the increased limits: (Limit of Liability Accepted) Executed on the 1ST day of ` LAO , in the year ;JD 0 , by the undersigned duly authorized officer of the Governmental Subdivision (City of Waukee) indicated below: BY: 4d,3- r W 4tna4k Title: F JAAO b 4y(Ar Member: City of Waukee Member Number: 59 Anniversary Date: 04/01/2017 Initial Loading Fire Dept. Sewer Dept. Waterworks Dept. DPW Parks and Recreation Gas Utility - Distribution Secondary Loading Ambulances Community Center Receipts EMT (No. of technicians, not including paid EMT's) Fireworks displays Golf Course Golf Course Receipts Herbicide/Pesticide GL Excess Total Public Officials Wrongful Acts Excess Total Law Enforcement Excess Total ommunities Assurance Pool General Liability Breakout City of Waukee Anniversary: 07101 /2017 Total Contribution % of Total $17,387.57 45.97% $1,897.18 5.02% $3,414.38 9.03% $2,752.65 7.28% $1,800.27 4.76% $2,616.18 6.92% $6,628.42 17.53% $267.12 0.71 % $0.35 0.00% $267.12 0.71 % $66.78 0.18% $14.18 0.04% $709.20 1,87% $9,660.41 $47,481.81 $7,862,35 $2,007.60 $9,869.95 $7,134.08 $1,821.36 $8,955.44 )mmunities Assurance Auto Liability Breakout City of Waukee Anniversary: 07/01/2017 Tota I Vehicle Type Contribution # of Vehicles Ambulances $475.58 2 $237.79 Dump Trucks $3,095.98 12 $258.00 Fire Trucks $1,309.47 8 $163.68 Heavy $244.52 1 $244.52 Lt. Med Trucks $1,263.50 8 $157.94 Passenger Car/Vans/Pickups $4,918.08 40 $122.95 Police $2,660.12 12 $221.68 Road Maintenance $107.06 3 $35.69 Trailers $0.00 19 $0.00 Excess $3,596.60 Total $17,670.91 Iowa Communities Assurance Pool Automobile Physical Damage Breakout City of Waukee Anniversary; 07/01/2017 Veh. No, Year Make Model Value Contribution 2 2002 Chevrolet Silverado $24,000 $98.16 3 2005 Chevrolet Pickup/Public Works $24,000 $98.16 4 2006 Chevrolet Silverado $25,000 $102.25 5 2013 Chevrolet Silverado (Strmwtr Dept) $26,498 $108.38 6 2003 Chevrolet Silverado $29,000 $118.61 7 2012 Chevrolet F350 (Street Dept.) $45,000 $184.06 8 2008 Chevrolet Uplander (Park & Rec) $18,125 $74.13 9 2005 GMC Pickup $18,500 $75.67 12 2010 H&H Trailer $1,500 $3.30 14 2000 H&H Trailer $7,500 $16,51 15 1999 Trailer Noma Trailer $12,000 $26.42 17 2014 Trailer Felling Trailer, Model $13,500 $29.72 FT20-2LP 18 2008 Trailer Dolittle Trailer $1,500 $3.30 21 2003 Trailer Kiefer Trailer $10,000 $22,02 23 2005 Trailer Belshe T18-2EP Trailer $6,000 $13.21 24 2006 Trailer Doolittle 8x20 Trailer $7,500 $16.51 25 2005 Trailer McLander Trailer $7,500 $16.51 26 2009 Trailer Belshe Trailer $10,000 $22.02 27 2013 Ford Interceptor AWD w/Eqpt. $40,000 $133.72 28 2013 Ford Interceptor AWD w/Eqpt. $40,000 $133.72 31 2013 Ford Interceptor w/Eqpt. $46,000 $153.77 36 2011 Ford Crown Vic Intcptr w/egpt. $47,500 $158.79 38 2010 Ford Explorerw/Eqpt. $47.500 $158.79 40 2008 Ford Crown Victoria w/Eqpt. $47,500 $158.79 42 2001 International Dump Truck $45,000 $196.63 43 2000 International 4700 Dump Truck $55,000 $240.33 45 2005 International Dump Truck $86,000 $375.79 46 2007 International Dump Truck $108,000 $471.92 47 2010 International Wing Truck $135,000 $589.90 48 2013 International 7300 SFA 4X2 $168,000 $734.10 49 2013 International 7300 SFA 4x2 Dump Truck $169,000 $738.47 50 2012 International Wing Truck $186,000 $812.75 51 1998 International Dump Truck $20,000 $87.39 52 2000 Spartan Firetruck/Toyne Pumper $480,000 $3,445.48 54 2006 Ford w/Crane $20,320 $83.11 55 2012 Ford F550 SD Bucket Truck $95,000 $388.56 56 2004 Ford F450 $25,000 $102.25 58 2012 Chevrolet 3500 HD (Water Dept.) $45,000 $184.06 59 1980 GMC Water Tanker $25,000 $102.25 60 2008 International 4300 (Gas Dept.) $66,000 $269.95 62 2003 Miscellaneous E 1 95' Ladder Truck $800,000 $5,742.46 63 2008 Ford E450Ambulance $170,000 $893.44 64 2011 Ford F450 Ambulance $170,000 $893,44 66 2009 Ford Expedition/Fire Dept. $42,500 $183.26 67 2013 Chevrolet Tahoe w/Eqpt. $54,000 $387.62 68 2013 Chevrolet Silverado $32,999 $142.29 69 1938 Chevrolet Firetruck $8,000 $34.50 71 2010 Ford F350 $28,990 $118.57 74 2012 Ford F250 (Water Dept.) $31,800 $130.07 75 2009 Ford F350 (PW/St. Dept.) $35,000 $143.15 76 2011 Ford F350 XL Pickup $35,000 $143.15 77 2012 Ford F350 (Street Dept.) $45,000 $184.06 78 2012 International Tymco Sweeper, Model $165,000 $720.99 4300M7SBA 81 2007 Ford E350 Cube Van $11,900 $48.67 82 2005 Ford 1/2 Ton Pickup $14,600 $59.72 83 2004 Ford 44 $19,000 $77.71 84 2007 Ford Explorer $21,556 $88.17 85 2009 Ford F150 $22,400 $91.62 86 1999 Ford F-250 Super Cab $24,000 $98.16 Pickup/Public Works 90 2013 Ford Explorer $27,388 $112.02 91 2005 Ford Truck $28,000 $114.52 92 2010 Ford F150 $28,350 $115.95 93 2010 Ford F350 $28,990 $118.57 96 1998 Miscellaneous Road Husky Trailer $1,500 $3.30 97 2013 Trailer Falcon RIME Asphalt Patch $35,000 $77.06 Trailer (Street Dept.) 98 2003 Miscellaneous Spinner Cargo Van $28,000 $114.52 99 2014 International 7300 SFA 4x2 $200,000 $873.93 100 2014 Chevrolet Equinox Sport Utility $25,000 $102.25 101 2014 Trailer EH Wachs Valve $70,000 $154.12 Maintenance Trailer 102 2014 Ford F-150 Pickup $35,000 $143.15 103 2015 Chevrolet Silverado 3500 Pickup $35,000 $143.15 104 2015 Ford F-250 Pickup (Gas Dept.) $35,000 $143.15 105 2015 Ford F-250 Pickup (Water Dept.) $33,000 $134.97 106 2015 International 7300 SFA 4x2 (Street Dept.) $200,000 $873.93 107 2014 Ford F-150 Pickup $24,200 $98.98 109 2013 Chevrolet Impala w/Eqpt. $50,000 $167.14 110 2013 Freightliner E-1 Fire Engine $450,000 $1,940.37 111 2014 Ford Explorerw/Eqpt. $50,000 $167.14 112 2000 Trailer Decatur Galaxy Model RT-50 $10,000 $22.02 Radar Trailer 113 2015 Trailer Sure-Trac Utility Trailer $1,750 $3.85 114 2015 Ford F550 $51,000 $208.60 115 2015 Chevrolet Silverado Pickup $35,000 $143.15 116 2015 Chevrolet Silverado Pickup $35,000 $143.15 117 2016 Ford F-250 Pickup $35,500 $145.20 118 2016 Ford F-250 Pickup $35,000 $143.15 119 2006 International Series 7400 Hydro -Vac Truck $150,000 $655.45 120 2016 Ford Explorerw/Eqpt. $41,000 $294.30 121 2015 Trailer Sprayer Specialties Trailer $20,000 $44.04 122 2015 International 7400 Plow Truck $200,000 $873.93 123 2016 Ford Explorerw/Eqpt. $48,000 $160.46 124 2015 Ford F550 $51,000 $208.60 126 2002 Chevrolet 2500 Pickup $35,000 $143.15 127 2003 H&H UT162 Sign Trailer $2,000 $4.40 129 2011 Miscellaneous Addco Message Board $4,000 $8.81 Trailer/Unit #604 130 2007 Miscellaneous American Signal Message $5,000 $11.01 Board Trailer 131 2016 Ford F-150 4x4 Pickup $24,370 $99.68 132 2017 Chevrolet Silverado 4WD Double Cab $28,600 $116.98 Pickup 133 2017 Ford F-350 4x4 Pickup $40,000 $163.60 134 2017 Chevrolet Silverado K3500 $50,000 $204.51 135 2017 Ford F-150 Supercab 4x4 SS $32,000 $130.88 Pickup 136 2016 Ford Explorerw/Eqpt. $60.600 $202.58 137 2016 Ford Explorerw/Eqpt. $60,600 $202.58 138 2017 International 4300 SBA 4x2 Street $260,000 $1,136.11 Sweeper APD Coverage Extension $175.00 TOTALS $6,715,536 $32,173.96 Communities Assurance Property Breakout City of Waukee Anniversary: 07101 /2017 Location Address Total TIV Contribution 1-1: Centennial Park on University Centennial Park on University $49.436.67 $141.80 Waukee, IA 50263 1-2: Centennial Park on University Centennial Park on University $51,903.54 $76.22 Waukee, IA 50263 1-3: Centennial Park on University Centennial Park on University $51,903,54 $76.22 Waukee, IA 50263 1-36: Centennial Park on Centennial Park on University $99,471.19 $122.85 University Waukee, IA 50263 1-4: Centennial Park on University Centennial Park on University $94,772.84 $271.85 Waukee, IA 50263 1-42: Centennial Park on Centennial Park on University $43,297.29 $53.47 University Waukee, IA 50263 1-49: Centennial Park on Centennial Park on University $31,705.52 $39.16 University Waukee, IA 50263 1-92: Centennial Park on Centennial Park on University $216,486.43 $620.97 University Waukee, IA 50263 2-6: 1205 6th 1205 6th $108,120.80 $310.13 Waukee, IA 50263 2-8: 1205 6th 1205 6th $24,584.95 $70.52 Waukee, IA 50263 3-9: South of Waukee South of Waukee $23,523.25 $29.05 Waukee, IA 50263 4-10: 1215 6th St. 1215 6th St. $111,120.80 $318.74 Waukee, IA 50263 5-13: Water Treatment Water Treatment Facility/1300 4th St. $195,921.62 $241.98 Facility/1300 4th St. Waukee, IA 50263 6-15: 410 6th 410 6th $342,254.26 $422.71 Waukee, IA 50263 12-23: Winfield Park Winfield Park $179,500.00 $514.88 Waukee, IA 50263 12-44: Winfield Park Winfield Park $93,840.00 $115.90 Waukee, IA 50263 13-24: 397 Hwy. 6 397 Hwy. 6 $358,793.16 $443.13 Waukee, IA 50263 13-45: 397 Hwy. 6 397 Hwy. 6 $112.167.33 $321.74 Waukee, IA 50263 14-25: 1300 L.A. Grant Parkway 1300 L.A. Grant Parkway $7,393,773.32 $11,219.49 Waukee, IA 50263 15-26: 50 Little Walnut Creek 50 Little Walnut Creek Drive $43,297.29 $53.47 Drive Waukee, IA 50263 16-27:501 4th St. 501 4th St. $43,297.29 $53.47 Waukee, IA 50263 17-28: 1155 Westbrooke 1155 Westbrooke $43,297.29 $53.47 Waukee, IA 50263 18-29: 701 Boone Drive 701 Boone Drive $43,297.29 $53.47 Waukee, IA 50263 19-30: 600 142nd St. 600 142nd St. $390.270.92 $482.01 Waukee, IA 50263 19-73: 600 142nd St. 600 142nd St. $179,263.75 $221.40 Waukee, IA 50263 20-105: 230 Hickman 230 Hickman $15,918.12 $19.66 Waukee, IA 50263 Waukee, IA 50263 22-109: Hwy R22 Hwy R22 $10,404.00 $12.85 Waukee, IA 50263 22-32: Hwy R22 Hwy R22 $1,589,013.16 $2.333.30 Waukee, IA 50263 24-34: 950 Warrior Lane 950 Warrior Lane $4,649,583.50 $13,414.28 Waukee, IA 50263 24-81: 950 Warrior Lane 950 Warrior Lane $48,960.00 $71.89 Waukee, IA 50263 25-35: 3256 Ashworth Rd. 3256 Ashworth Rd. $43,297.29 $53.47 Waukee, IA 50263 27-37: 31653 Ute 31653 Ute $194,040,04 $284.93 Waukee, IA 50263 27-86: 31653 Ute 31653 Ute $43,297.29 $53.47 Waukee, IA 50263 29-40: 225 University Ave. 225 University Ave. $43,297.29 $53.47 Waukee, IA 50263 30-41: 550 Ashworth Drive, 550 Ashworth Drive, Triangle Park $11,414.25 $32.74 Triangle Park Waukee, IA 50263 30-43: 550 Ashworth Drive, 550 Ashworth Drive, Triangle Park $232,849.56 $233.25 Triangle Park Waukee, IA 50263 30-57: 550 Ashworth Drive, 550 Ashworth Drive, Triangle Park $22,523.25 $33.07 Triangle Park Waukee, IA 50263 31-88: Ridge Pointe Park Ridge Pointe Park $56,308.12 $69.54 Waukee, IA 50263 31-89: Ridge Pointe Park Ridge Pointe Park $11,261.62 $13.91 Waukee, IA 50263 32-47: Southfork Park Southfork Park $25,363.55 $31.33 Waukee, IA 50263 32-48: Southfork Park Southfork Park $31,705.52 $46.56 Waukee, IA 50263 34-50:1300 3rd Street 1300 3rd Street $458.762.34 $673.65 Waukee, IA 50263 35-51: 1080 Westwoods 1080 Westwoods $310,843.13 $456.44 Waukee, IA 50263 37-78: Hickman and Alices Rd. Hickman and Alices Rd. $223,284.11 $275.77 Waukee, IA 50263 - 39-121: 1501 6th St. 1501 6th St. $13,770.00 $20.22 Waukee, [A 50263 39-55: 1501 6th St. 1501 6th St. $682,085.00 $3,415.96 Waukee, IA 50263 39-56:1501 6th St. 1501 6th St. $99,021.39 $122.30 Waukee, IA 50263 39-76:1501 6th St. 1501 6th St. $28,154.06 $34.77 Waukee, IA 50263 41-59: Hickman & N. 10th Hickman & N. 10th $228,282.78 $281.94 Waukee, IA 50263 42-60: Hickman & 4th St. Hickman & 4th St. $228,282.78 $281.94 Waukee, IA 50263 43-61: Hickman & Warner Lane Hickman & Warder Lane $228,282.78 $281.94 Waukee, IA 50263 44-65: Boone Drive & University Boone Drive & University $228,282.78 $281.94 Waukee, IA 50263 45-74: 90 N. 10th St. 90 N. 10th St. $179,263.75 $221.40 Waukee, IA 50263 46-68: Hickman - Alices Road to Hickman - Alices Road to R22 $621,687.33 $767.82 R22 Waukee, IA 50263 48-100: 1255 3rd Street 1255 3rd Street $82,547.59 $112.36 Waukee, IA 50263 Waukee, IA 50263 48-70: 1255 3rd Street 1255 3rd Street $1,874,046.00 $2,314.57 Waukee, IA 50263 49-71: Intersection/Alice's Rd. & Intersection/Alice's Rd. & University $295,800.00 $365.33 University Waukee, IA 50263 50-72: 100 Block of S.E. University 100 Block of S.E. University Ave. $32,987.12 $40.74 Ave. Waukee, IA 50263 52-77: University & L.A. Grant University & L.A. Grant $225,232.48 $278.18 Waukee, IA 50263 53-79: University & SE Florence University & SE Florence $225,232.48 $278.18 Waukee, IA 50263 54-80: University & Waukee University & Waukee School Entrance $225,232.48 $278.18 School Entrance Waukee, IA 50263 55-83: 3107 312th Pl. (West of 3107 312th PI. (West of Gun Club) $420,737.76 $617.81 Gun Club) Waukee, IA 50263 56-84: 106 SE Baytree 106 SE Baytree Dr./Hemmingway $101.176.86 $148.57 Dr,/Hemmingway Waukee, IA 50263 57-85: 1080 SE WestwoodsDr 1080 SE Westwoods Dr $73,440.00 $107.84 Waukee, IA 50263 58-107: Grant Park Grant Park $51,000.00 $60.61 Waukee, IA 50263 58-90: Grant Park Grant Park $60,180.00 $74.33 Waukee, IA 50263 59-120: 805 University Ave. 805 University Ave. $56,610.00 $83.13 Waukee, IA 50263 59-91: 805 University Ave. 805 University Ave. $10,256,742.16 $18,864.84 Waukee, IA 50263 59-93: 805 University Ave. 805 University Ave. $90,092.99 $111.27 Waukee, IA 50263 59-95: 805 University Ave. 805 University Ave. $238,308.12 $862.66 Waukee, IA 50263 60-94: Hickman & 6th Hickman & 6th $225.232.48 $278.18 Waukee, IA 50263 61-96: South Fork Development South Fork Development $563,081.21 $695.44 Waukee, IA 50263 62-102: 955 W. Hickman 955 W. Hickman Rd./Raccoon River Valley $20,977.54 $60.17 Rd,/Raccoon River Valley -- Trailhead -------- --------- - - - - -- - Trailhead Waukee, IA 50263 62-103: 955 W. Hickman 955 W. Hickman Rd./Raccoon River Valley $11,040.81 $13.64 Rd./Raccoon River Valley Trailhead Trailhead Waukee, IA 50263 62-97: 955 W. Hickman 955 W. Hickman Rd./Raccoon River Valley $104,887.68 $129.54 Rd./Raccoon River Valley Trailhead Trailhead Waukee, IA 50263 63-101: 1725 98th St. 1725 98th St. $67,487.71 $93.76 West Des Moines, IA 50263 63-106: 1725 98th St. 1725 98th St. $5,202.00 $5.21 West Des Moines, IA 50263 64-17: 675 Walnut St. 675 Walnut St. $514,941.27 $635.99 Waukee, IA 50263 65-104: 990 Warrior Lane 990 Warrior Lane $447,829.78 $553.10 Waukee, IA 50263 66-110: SE of Sugar Creek Golf BE of Sugar Creek Golf Course on Bike Trail $208,080.00 $256.99 Course on Bike Trail Waukee, IA 50263 67-122: Hickman Rd. & Dartmoor Hickman Rd. & Dartmoor $229,500.00 $283.45 Waukee, IA 50263 68-123: Westown Pkwy & L.A. Westown Pkwy. & L.A. Grant $229,500.00 $283.45 Grant Waukee, IA 50263 69-124: L.A. Grant & Ashworth L.A. Grant & Ashworth $51,000.00 $62.99 Waukee, IA 50263 Waukee, IA 50263 71-126: Westown Pkwy. & Grand Westown Pkwy. & Grand Prairie $295,800.00 $365.33 Prairie Waukee, IA 50263 72-127: Ashworth & Grand Prairie Ashworth & Grand Prairie $295.800.00 $365.33 Waukee, IA 50263 73-128: Grand Prairie Rd. Grand Prairie Rd. $1,027,440.90 $1,268.96 Waukee, IA 50263 74-112: 1300 4th St. 1300 4th St. $1,165,434.66 $1,439.39 Waukee, IA 50263 74-113: 1300 4th St. 1300 4th St. $68.101.32 $84.11 Waukee, IA 50263 74-114: 1300 4th St. 1300 4th St. $456,720.30 $664.08 Waukee, IA 50263 74-115: 1300 4th St. 1300 4th St. $456,720.30 $564.08 Waukee, IA 50263 74-116: 1300 4th St. 1300 4th St. $361,733.82 $446.76 Waukee, IA 50263 74-117: 1300 4th St. 1300 4th St. $363,630.00 $449.11 Waukee, IA 50263 74-118: 1300 4th St. 1300 4th St. $363,630.00 $449.11 Waukee, IA 50263 74-119: 1300 4th St. 1300 4th St. $143,865.90 $211,25 Waukee, IA 50263 75-87: 655 SE Legacy Point Blvd. 655 SE Legacy Point Blvd $255,582.80 $315.66 Waukee, IA 50263 76-53: 1255 E. Hwy. 6 1255 E. Hwy. 6 $277,076.88 $406.86 Waukee, IA 50263 77-55: 1505 6th St. 1505 6th St. $450,311.16 $1,291.67 Waukee, IA 50263 77-67: 1505 6th St. 1505 6th St. $215,762.28 $618.89 Waukee, IA 50263 98-98: Various Locations Various Locations $125,000.00 $626.02 Waukee, IA 50263 99-99: Liability Only Liability Only $0.00 $0.00 Waukee, IA 50263 300-300: Various Locations (as Various Locations (as noted on file) $526,062.03 $1,508.95 noted on file) __ Waukee-IA-50263— Property Coverage Extension $250.00 TOTALS $47,937,223.31 $88.904.90 I Description General Liability Wrongful Acts Liability Law Enforcement Liability Business Auto Liability Excess Liability (+$6M) Property Premium Auto Physical Damage Boiler & Machinery Total Due: Credits $'s: Liability (See Breakdown below) Property Auto Boiler Liability Breakdown: General Wrongful Acts Law Enforcement Business Auto Excess Liability (See Breakdown below) ICAP FY18 - July 2017 - June 2018 Billing first time forJuly 1 far fiscal year invoicing LLL Total Premium Billed Total Credit % Liability Credit % Excess % $37,821.40 41% 45% 57% $7,862.35 9% 12% $7,134.08 8% 11% $14,074.31 17% 21% new 2014 $17,085.97 20% $83,978.11 $88,904.90 43% $32,173.96 16% $0.00 0% $205,056.97 ($19,404.45) $185,652.52', 41% ($7,946.81) 43% ($8,413.03) 16% ($3,044.61) 0% $0.00 ($19,404.45) 45% ($3,579.02) 9% ($744.01) 8% ($675.09) 17% ($1,331.85) 20% ($1,616.84) ($7,946.81) Excess Liability Breakdown: +$6M Invoiced Credit Total Excess Liab General 57% $9,660.56 $ (914.17) $8,746.38 Public Officials 12% $2,008.25 $ (190.04) $1,818.21 Law Enforcement 11% $1,822.23 $ (172.44) $1,649.79 Vehicles 21% $3,594.94 $ (340.19) $3,254.75 100% $17,085.97 $ (1,616.84) $15,469.13 ICAP July 2017 G/L Account Number Detail FY18 Budget Over/(Under) Budget Account # Premium $'s 010.10.1100.290000 $ 1,235.20 $ 1,200.00 010.10.1100.290100 $ 3,236.36 $ 3,000.00 010.10.1100.290300 $ 4,367.85 $ 6,000.00 010.10.1100.290400 $ 8,108.78 $ 16,948.18 $ 8,000.00 $ 18,200.00 $ (1,251.82) 010-10.1110.290300 $ 387.28 $ 387.28 $ 500.00 $ 500.00 $ (112.72) 010.10.1400.290000 $ 2,773.98 $ 2,500.00 010.10.1400.290100 $ 14,404.59 $ 18,000.00 010.10.1400.290300 $ 2,894.97 $ 20,073.54 $ 4,000.00 $ 24,500.00 $ (4,426.46) 010.10.1500.290000 $ 1,224.83 $ 1,230.00 010.10.1500.290100 $ 3,467.11 $ 4,300.00 010.10.1500,290300 $ 2,894.97 $ 7,586.91 $ 4,000.00 $ 9,530.00 $ 1,943.09) 010.10.1900.290000 $ 617.60 $ 700.00 010.10.1900.290100 $ 441.18 $ 1,058.78 $ 600.00 $ 1,300.00 $ (241.22) 010.40.3100.290000 $ 617.60 $ 1,200.00 010.40.3100.290300 $ 12,144.89 $ 12,762.49 $ 5,000.00 $ 6,200.00 $ 6,562.49 010.40.4100.290000 $ 2,180.71 $ 21000.00 010.40.4100.290100 $ 1,373.27 $ 1,000.00 010.40.4100.290300 $ 3,034.07 $ 6,588.05 $ 4,000.00 $ 7,000.00 $ (411.95) 010.40.4200.290000 $ 2,104.41 $ 2,200.00 010.40.4200.290100 $ 561.67 $ 2,666.08 $ 600.00 $ 21800.00 $ 133.92) 010.40.4300.290000 $ 617.60 $ 1,000.00 010.40.4300.290300 $ 958.52 $ 1,576.11 $ 1,000.00 $ 2,000.00 $ (423.89) 010.20.6000.290000 $ 3,281.43 $ 3,200.00 010.20.6000.290100 $ 334.24 $ 500.00 010.20.6000.290300 $ $ 3,615.67 $ - $ 3,700.00 $ (84.33) 010.20.6010.290300 $ 17,180.43 $ 17,180.43 $ 21,000.00 $ 21,000.00 $ (3,819.57) 010.20.6150.290100 $ 209.88 $ 209.88 $ 300.00 $ 300.00 $ (90.12) 010.60.8100.290000 $ 8,936.55 $8,936.55 $ 8,500.00 $ 81500.00 $ 436.55 010.60.8200.290000 $ 617.60 $ 617.60 $ - $ - $ 617.60 010.60.8300.290000 $ 617.60 $ 1,600.00 010.60.8310.290300 $ 8,576.72 $ 9,194.32 $ 11,000.00 $ 12,600.00 $ (3,405.68) O10.60.8350.290000 $ 617.60 $ 617.60 $ 600.00 $ 600.00 $ 17.60 010.60.8400.290000 $ 617.60 $ 617.60 $ 650.00 $ 650.00 $ (32.40) 010.50.8500.290000 $ 617.60 $ 617.60 $ 750.00 $ 750.00 $ (132.40) 010.50.8700.290000 $ 617.60 $ 617.60 $ 600.00 $ 600.00 $ 17.60 010-60.8800.290000 $ 617.60 $ 617.60 $ $ - $ 617.60 010.20.8900.290000 $ 617.60 $ 600.00 010.20,8900.290100 $ 698.61 $ 1,316.21 $ 11000.00 $ 1,600.00 $ (283.79) 010.20.8950.290000 $ 617.60 $ 600.00 010.20.8950.290100 $ - $ 617.60 $ - $ 600.00 $ 17.60 060.30.1600.290350 $ 3,274.41 $ 3,650.00 $ 3,650.00 $ (3,650.00) 060.30.1610.290350 $ 4,500.04 $ 4,000.00 $ 4,000.00 $ (4,000.00) 060.30.7100.290000 $ 2,041.29 $ 3,500.00 060.30.7100.290100 $ 12,903.38 $ 12,000.00 060.30.7100.290300 $ 1,414.23 $ 24,133.35 $ 1,500.00 $ 17,000.00 $ 7,133.35 510.30,6510.290000 $ 4,363.93 $ 3,500.00 510.30.6510.290100 $ 1,066.44 $ 1,000.00 510,30.6510.290300 $ 4,865.87 $ 10,296.24 $ 6,000.00 $ 10,500.00 $ (203.76) 520.30.6520.290000 $ 5,116.07 $ 4,500.00 520.30.6520.290100 $ 2,075.82 $ 2,400.00 520.30.6520.290300 $ 8,247.42 $ 15,439.30 $ 81500.00 $ 15,400.00 $ 39.30 540.30.6540.290000 $ 8,769.24 $ 10,000.00 540.30.6540.290100 $ 852.49 $ 11500.00 540.30.6540.290300 $ 767.23 $ 10,388.96 $ 1,000.00 $ 12,500.00 $ (2,111.04) 560.80.5300.290000 $ 1,235.20 $ 1,400.00 560.80.5300.290100 $ 3,357.62 $ 1,700.00 560.80.5300.290300 $ - $ 4,592.81 $ $ 3,100.00 $ 1,492.81 750.80.8750.290000 $ 1,251.31 $ 6,000.00 750.80.8750.290100 $ 143.92 $ 200.00 750.80.8750.290300 $ 4,982.99 $ 6,378.22 $ 5,000.00 $ 11,200.00 $ (4,821.78) $ 185,652.52 $ 185,652,52 $ 200,280.00 $ 200,280.00 $ (14,627.48) General Fund Over/(Under) Budget $ (8,393.63) O O a a Li 0 N o rn W .+ ry N N o n v W a m m ry a 0 n n n a m a rl rl Oi N M ei N VL N to V1V! Vl V� N V� V�V�NV1 �A V? Vl 1/� C O N N m N N. N 4 W W O W M O n W N N rn n n n n rl O' O O N W 01 n O y W N N W W O rl rn N e4 N'la O n T n W rn Imon W M N vl d' < V' d' O O V It M W N W r1 rl l0 t0 rl N m m O N O O O 01 W e'I N O m e'I V V n n 01 M M m m N 'I M M T M M N d' n n n N M N 0 N n W N p N M C N tO N N 01 '1 N N N N W N O N 1 n M N n W N l0 R m mm N ?. N rl tO O M n W N V N n V V m V V 'E v m 0i ai o? ri r.i U o 3 h a V�NV�VL VY VI V�HN N4�V�. YR N VY aA.. HNVI aA aAN V�VY aAN i/i VT Vl V� t/�V�Vf V�+/�N VY i/� �/1 �/1ti Z O N N M n W b Wa n mO O O O O n M O W N O O O O O O O O O NWO O O O O O C n fl rl W N n Of W O V N O O O O O t M O W W O O W N O O O O O N O.6�4O N N Ogid O O o O O O O N m 0 n N 0 V N N O 00ei S O . m e1 S m 0 0 S O M N ei ei e4 �y M M M ro V o ry rl m M N .i .. vi m rl a Di rci nrnn ni o0 N N.+n o m rn ni m m m ae a v o ai rn n�o 0i c vi N.in o 0i o W,� ai o0 v e m `v c T u = m m E LL m v u a E 0 a m a E w u a > o v E u L a m « c m U c 0 a O d c O W O v m 0 a o N '- 0 a v m N a a a EST, LL « W A O ��, CI i v T T = 3 4 6 y a s Y a a O m ry N O O L a� °ie3 N N > cw `° °' v o°o 1 ti o `" 3 v z 3 rnnm o 0 o 00 11 3 3 N N . N ti r NN.+n �a �o rvN xx rnrn 00 l0 W N N cl M N N N O N N N V M M N O N N N N N �O n W M n Of a1 m O M N N M W1 O V t a v v a v v n n in 1n 1n in 1n � L 1n '^ L a a a o It OR a n ry M M M 01 m n m lO N m N M m N O1 N m n n t0 N e n N 01 N m N V1 V� Vl Vl �A V1 1/� Vl 1A n m n O n Q vt n l0 Q rl 1!1 M W T N Q n n t0 O n N Q Ol Q Q Q n N O O N 01 V' m N M tD a n n m M n N m v med ni ry rri mai aimm .+ion m 10 vi vi viN e0 N w Nm N m m mm �0 .+m m Qn n N n n .y Nmry N m N N tp Q N N Q M m 1/) N VY VT 1M1 iA V� Vl VY 1/� V! N Ah Vl Vi N V� N V1 N N V� N 41 �A a a'aa x aaa0 aaa'0 aa`0 o 00 aaea°a 0 10 e o n rvo o o 0 m m Q N N Q o o o m n o M1oo Q m a N0 o 0 0 0 0 0 0 o 00 n m N n mo e�0 o .7050 0 v wand 0 rci 16o 6 vi 0 0 00 ry I o m.+o o m o m..o eNS o 0 o m.�+ T OQi OQ1 OQ1 OV OR M M n [O c0 m c0 N t0 M m Q N N N N N n Q M N rn rn m rn Q m N m Q M m n N N N N N n M rl Q m N N S S S S S S 00 S S S 0 0 0 0 0 0 m Q 0 0 0 S S 1 'i e1 1 N 1 11 1-1 eY C � a O c c v v v E E v E N 9 m N N N N 1n 9 L t N� m m m m a � i V. N ei :� _m m O Y L W W W a tt tt V tt i+ O S U_ N c o m a m a \aa c a_ c v c o c 0 c o vv1= c a n o m c o r 0 0 s r r r �° ti 0 m in in in u i= a a a d O 1n � t9 a � 1Ti 1n 1n N � � CL � u'�i u'�i v�i a a c O V Q Q❑ d a L' L' N � � W W W W Y Y) 0 3 v v a 0 0 o 7 L O M OYJ N1 10 N N O O M M M O N < < k 0 d i0 sL o 3 `�, >, l0 t0 10 l0 E E E c > N m vmi vmi 5 5 0 .-1 .1 .. .1 z 1n 1n 1n m N m 10 0 0 0 o m o 0 0 0 m �_ u_ 0 N N N N-1 o N M m m g vv'i vu'i vu'i c z c voi v0i ti x x .Ni .Ni .�i .i x x x m° rn x3N-1 ti a o0m m m eo Q e e N m m m e Q N N N n N N n ti 1n m m n 10 n 0 0 n n a+ N n n 01 O O O rl 11 rl N N Q N n n Of 01 Ot N M Q N 10 W 01 O '1 N N N N M M M M M M M M M M M M M M M m Q Q e Q Q Q e a Q Q N N L L L 00 m 00 m m m a uri w m ad ad oc n 1 0 v � O m Uf 1A N h V1 V} H N a o n N N N �a ei rI 0 0 0 0 0 0 00 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 00 r m O m rI Q M o r r n m m m m m m 0 N fn O V1 l0 N w W N Vf m V1 V1 N v1 vl N v L L C L L L L L L t m m m 00 U w wOO OO CO 00 m a a E u m rI Q m m m m Q v a? m m m m m ao vi ni cd vi ni vi .6 at Q r l0 M O m Q Q r Q Vf w I r m O T v1 vl m O1 M M �a °f m rV N m '1 Q Vf rl La m. r N m m 'I m Q Q m m m m. m m d 'I ry ni .+ ed vi m 0 ni m, ai vi w vi m e. ai m ry ry vi ui ro of W 'I m m N l0 rI N.. m Vl N N N M M N m Q W a� N rl M a x a g r v1 N M m m rry v� O o O 0 O 0 rI N w m m o O o 00 O O O o O 0 O 0 O 0 O 0 O 0 O 0 O O O 0 O O O 0 �D O N O O O O �a m 0 00 O O O O O O O O O O m 0 O 0 n o 00 0 0 0 0 0 0 0 o O 0 0 L C ° _ o v v a o `° E E m ¢ m v m LL v v 3 v1 F- N o �e Y i it m m N N N m vi N n h N p q in u�i N U 9 A A R N R N n ° w a a a in r F y r 3 in Fi in G in in . mm v `v, E c " 3 min hHF- >>> E �e Jm v v c y m °° g r v v v v a a a G>a>a> >> mmm v -_ E al 3 L C C C ` q N t T L N > T T T T 3 0 v x E E E v, a o O a >1 v v a v > > > > L L c t nyvi . c c o x 2 2 U' 3 O Vl ill vl Vl 0000 U O Y1 V1 Vf �+1 0 N N vl O m y 0 N M Q �n w n m N m m m H m T m O O O Oy O N N N N N N °1 ei rl N N '1 '1 tvf M M VI lO I� m' rl m rl O rI 'i rl N rl M rl Q Vml Vml Vm1 �n lOa m w m r r r r n C i� 0 � A 0 .' ii N 10 m w o m 8 m �n �n d a d N m o a m .m+ ry b N b o in v0i ry o m 'i ti ro m O m O v v v m ai .-i 'i od 0 ro 0 m b b a Q Q •+ .+ O m .i N o �n u+ b a a a N m d ry b b ui N eI '1 N N 1/� lry H V� VF V1 to N V1 N V� N a a e 0 0 O O 0 O o O O O o O O O N m O ry h N o O 0 O 0 0 0 0 0 0 0 v v 0 0 0 0 0 o O O O O m � m N o 0 '+ 0 0 Q O o b M n .� N n n n lc le m Iq o m n 00 �o � ,ti ni m m vi n 0 vi .big a a m m m .di ry ry a r"i m s o c u y Y 0 O O 2 W Z o a c c N W_ '0 O O m O io U 6 L 0 vl m ry 3 a O 'm N N N N J O O c u u Q Q l'! a U' U' D LL C O -p m y u W C W O O w V w N IA N VI VI VI VI C 3 N V1 O U 'O L L L S L L L O O O O O O v m u1 M M M M O O O .O N 00 O O V v v v v d e d n n n rn 8 n n n n n n n M 00000000880000000 0 0 0 0 0 0 0 0 0 0 0 0 vT 0 0 M M M M M M M M M M M M M M MM M 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O.O O m m m m m m m m N N N N N N N N N N N N N N N N N O O O O O OQ 00 0 00S S OO O"O O'-0 O 'i O O 0 ✓i Nt09 b r M a bb�Obb n am a .y +.+mm 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Q N NMmM M c o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 d 0 0 0ui in viN.i d bN bbbo000 000 oono E 0 o v v M. ry N. i i oo oo. M. ai rry �v0o� vin v m M. v n o`��ry mn a m.d+mw mmm 1 Vl eel V� V� N ei V1 N V� N Vf O f O n 0 Q in b m 01 M 0 o m n m m b 0 0 m nom ry o ab bd o bo ni0.-i 0�o 0.-i .i vi vi ni rci 0 v vi �o 00 N C O O an d vl N vl O m. m Vf Vt b V1 W rl b N M •-I Q Q d O n N M Y1 VI n �D M M 'I m O V1 n O n d b rl N m m N n O n O M m rl M W 0 w Vl d M '1 rl d l0 m N d m d ni c6 of vi '^ ' m d ni M �^ rvi v ui ai of 06 N N N 1 pp N V _ m aci Y Y T L C H O Oo pp w 33 mom== v M `m a w 1O m o o no a v v n o« J a ao.M 3t�mu�ww mYnrt�'u 14T1% General Liability Breakdown July 2017 General Liability Premium Due: $37,821.40 General Liability - Excess Premium $9,660.56 Less Credit: General Prem ($3,579.02) Less Credit: Excess Prem ($914.17) Total Due: $42,988.76 Excess Prem & Total Departments: Premium $'s Credit % Credit $'s Prem Cr $'s Premium $'s Acct a's Administration/General Operations $17,387.57 45.97% (1,645.38) $4,020.96 $19,763.13 see below Fire $1,897.18 5.02% (179.53) $438.73 $2,156.38 010.10.1400.290000 Sewer $3,414.38 9.03% (323.10) $789.59 $3,880.87 520.30.6520.290000 Water $2,752.65 7.28% (260.48) $636.56 $3,128.73 510.30.6510.290000 Public Works $1,800.27 4.76% (170.36) $416.32 $2,046.23 010.20.6000.290000 Parks $1,308.44 3.46% (123.82) $302.58 $1,487.21 010.40.4100.290000 Rec $1,308.09 3.46% (123.78) $302.50 $1,486.81 010.40.4200.290000 Ambulance/Rescue $267.12 0.71% (25.28) $61.77 $303.62 010.10.1500.290000 EMT/Rescue $267.12 0.71% (25.28) $61.77 $303.62 010.10.1500.290000 Fireworks Display/Parks $66.78 0.18% (6.32) $15.44 $75.90 010.40.4100.290000 Fire Fighters $0.00 0.00% 0.00 $0.00 $0.00 010.10.1400.290000 Golf Course $14.18 0.04% (1.34) $3.28 $16.12 750.80.8750.290000 Spraying/Road Use $709.20 1.88% (67.11) $164.01 $806.09 060.30.7100.290000 Employee Benefits/Administration $0.00 0.00% 0.00 $0.00 $0.00 010.60.8300.290000 Elec Utilities/Gas $6,628.42 17.53% (627.24) $1,532.85 $7,534.04 540.30.6540.290000 $37,821.40 100.00% -$3,579.02 $8,746.38 $42,988.76 Admin/General Operations Breakdown: (divided based on budgeted $ to all departments & tried to make some what even) Police $1,235.20 $1,235.20 010,10.1100.290000 Fire $617.60 $617.60 010.10.1400.290000 EMS $617.60 $617.60 010.10.1500.290000 Code Compliance $617.60 $617.60 010.10.1900.290000 Library $617.60 $617.60 010.40.3100.290000 Parks $617.60 $617.60 010.40.4100.290000 Recreation $617.60 $617.60 010.40.4200.290000 Public Works $1,235.20 $1,235.20 010.20.6000.290000 Administration $617.60 $617.60 010.60.8300.290000 Communications $617.60 $617.60 010.60.8200.290000 HR $617.60 $617.60 010.60.8350.290000 Finance $617.60 $617.60 010.60.8400.290000 IT $617.60 $617.60 010-60.8800.290000 Comm/Econ Development $617.60 $617.60 010.50.8500.290000 Development Services $617.60 $617.60 010.50.8700.290000 Engineer $617.60 $617.60 010.20.8900.290000 GIS $617.60 $617.60 010.20.8950.290000 Community Center $617.60 $617.60 010.40.4300.290000 Roads $1,235.20 $1,235.20 060.30.7100.290000 Water $1,235.20 $1,235.20 510.30.6510.290000 Sewer $1,235.20 $1,235.20 520.30,6520.290000 Gas $1,235.20 $1,235.20 540.30.6540.290000 Storm Water $1,235.20 $1,235.20 560.80.5300.290000 Golf Course $1,235.20 $1,235.20 750.80.8750.290000 $19,763.13 $19,763.13 Figured: 16 depts with Fire, EMS, Code, Libr, Parks, Rec, Admin, Communications, HR, Finance, IT, Comm/Econ Develop, Devel Serv, Engineer, GIS & Comm Cei calculated as being 1/2 depts Secondary Load Y„``'„_ *,� Prioryr% CurrentYrSplit Ambulance/Rescue 0.00% $267.12 EMT/Rescue 0.00% $267.12 Fireworks Display/Parks 0.00% $67.13 Fire Fighters 0.00% $307.19 Golf Course 0.00% $14.18 Employee Benefits/Administration 0.00% $0.00 0.00% $922.74 [CAP July 2017 Billing Law Enforcement & Public Officials Liability Excess Total Description Premium Credit$'s Premium Premium Acct# Law Enforcement Liability $7,134.08 ($675.09) $1,649.79 $8,108.78 010.10.1100.290400 Public Officials Liability $7,862.35 ($744.01) $1,818.21 $8,936.55 010.60.8100.290000 C 0 6 0 Q 0 S S S a m m m o 0 o d m o m o d O O N N p o % - N N O m N O E F n N E v n` v «p o ORNo N m o maw o .� vni o � w a v - n n ° E a' a —ra v m m ry n a � w 0 0 E a a' a N a a o Q < N m m <o N 40 N .r vi ri u` m om �n o mm OmN�o io nNorv�o �nQ omm .+0 Lq nm vimmmmoo n Q no cl Nm.+o mo m to mm Nn�Nm �o a .+N �o o.+Q mmaoQ �a rv.m+0 wmn E aim �irv�e grin a 10 a+�c ri 66wro oNni.i ni c .r co o QNm mm m nna a Q n.+ �mm .Qi I, n�Qn m Qm�n�am .+tiry v m N NNNNV�NNNVI.NNNNN NSA 1/�NNNNNNNNNNNNNNN NNVYN V� NV�VY VY VYN N NV�N NNNN O O O O O O O O O O O O O O O O O 8 Orr; O O O O O O O O O O O O S S O O O O O O O O O O O O O O O O O O O O O 8 O O O O 0.0t0oIn� O w QO O S S O O O O N O O O O O O O O O S O N O O O O O O O O N O O N S Lq S S Lq 'i Oml N S S S O N O S O O n O r O m N N S N VN mN � N N m O N tvNl Q m Q Q l0 m b fl m O T O M S N VQV O trvl 1/�VLN�NNN �N�VIN NNN N VL�HNV�NN NV?'I O N N l m nl H V1NNN N '1 Q Vm1 m NNNNNN tp N N T a VY b< V� NN NN W a mom�c�n Qom m em��N VNy onooN m �n No OI tO ry O O N m m V oN o O O,m m ti n Q m N N ti Q N .-� N m . p W tQv1 V N m Q ~ ul e m s la/1 �O b m m. m n tmO J N W S Q m N Q 1O N b N N In O eNi tO0 T m In Q aryO tp O m m S W I� 2 2 tJ N O W O O W LL u ry V W_ u_ N H N W LL O N Q N W W Q N ry O W yQj yQj QY m t0 O N N Q K¢ N O K N n U N K m C O K W Cg U Q W N W ip w �o n m m m g g g C g K g g mu0�N�3�3 m 3^mrv'mmw wov'ieN3 �03�3 ti�oi� Vt InoN 3 LLX a LL' Oj F W N N U O m uN. W n 3 Y X Q Q O M x N Y jf Y u W Y N I K O M Q m ��. �m. xLLxNLL x0x.�. � .�. .m-� O'.0.3e�.�. .�. .0. .�. .z. .z. �.mae�t �0LL LL3�c�axLL 0� i E 2 2 >; v v 9 nnq n� m aF= Sr °° .—• o o .. `v E E ES c Eao0 00 -00 `° ° 0 n o o o' o o' 0 Q 3 3 3 3 F_ r— a ,o ; s a o> n m q Inc c c c c iO o `v c a c w s n `u vai a u> iO 0 y N c m ✓ ✓ « « « wN — Y C 'G H '� N « W = in >-i o y o u u C O W E N .i H d u T R LL LL W m C 4 T u F C o o `w t `v a v v a a u a L v v a v 3 v a N N L a v v u - a a �°. u°. �°. LL u LL �° LL m rvrvmm a mho n oo rvNN mNmmmQNN W N N ..nn 0 0 0 0 0 0 m 0 0 0 0 0 ti o 0 0 0 0 0 o o 0 0 0 0 0 0 0 0 0 0 0 0 00 ... o ... o NNaN 0 o .00. W onrvm`oN O o 0 o mN Nm 0 0 0 0 m N N N N4, .......N N N 0 00000 N N N N N N 0 .... N 0 0 0 0 0 0 0 00 $ m o m m o 0 0 N ry O O O O O q O O00 O Q $ m V 0 N N O O O d d d Q e m 0 0 0 0 0. 0 0 0 0 0 0 0 N N � i1Ovl Imo b •+ v m .y n m N N W 0 N m I N N N m o .0o n � � 00 VY N m N Inil O N � o Q O T 0 a m N o � d N N N N N v V� Q � OR,^° V% N N m O N m m o m m ry o n � a n o Ino O1 Q m m O M N N H O O n n 0 0 m m N m m^^ N V Q O O V O W I° Q Q N ID VI m m ul m fi Ip eiO1 Q N nt n m Ip eQ1 ^ O m N 1D m O n n n n IO m N N Vl ry ry M m \D IO N m W m W T W Q VI n M N W W N N T n n Q O N N M eN O O O] m N N e n m m m m n N �/?N IANVIN VYN V�VI. V� NNN V�NNN NVY VINNNV�NNNVLNNN NNNNNNNVYNN a/�V�H VYNN 1/� o In In lnoom omoo o In.+oOlo No rn In $om.o n oo o o In oomoQ oa oo MM N'ww`�rv,mi ry rl'{nm ,: ofo oNc ni nry`� �a e v v v elroi on 6 .b .Qi r00 i N �NNNNNVVNN voi NNNN�'1 w V�NN voiaae.00m NNVIN V�VVNNNNNN�A VI Nmo v�vQim$o QW N�NNQN rvu�mim�6 a � VAN VAN VI mry N N N N N N N N '^m �Nm �Icn mmm nmmv"ia a 0°tmm�m N o N Ml"Iri o m N ON N N N--- N~ q Opp�4 N a y W S m Vl C m W lm0 °nl O Q m M ON M m Q M Ip Inp l M N flml w m W w LL J W Y Y LL J U' li U' U li U U' W O O I+I W N O n O N O Y<Qo 0 �imZ n"tiIN Q O H Q m Y 6 Z XM W m K J W Y W LL U' o Q Q l oao a a a - - 3 3 3 w y o 0 0 r � 06 a c y o f = ao Faa v v v I� 2 a v Q Q a t i `a w `a `w `a `-' °1 a 0 F.o nJo i v Inw� o no o> >>> v o xNNln Nin o J o a y a a a a y a y a v a a v a a a a y a a v v a a r m a a a> y.� v w w r v a LL LLtLL> LL p LLLL LL LL LLLL LLu°. LL LLI°LLL E> I°i l°i I°i U I°i I°i l°i InnH V V U u` V f U V U z u u m O O Q vl O N N m o o m o 0 0 W vl aa. 0 0 Q N Ip O M o M T Q I° IO m 0 0 O m W M M m N m m n n O M 0 0 0 0 0 0 0 0 0 o 0 o a m o� o 0 0 0 0 0 . 0 0 .... 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ry ry n 0 o d o 0 0 W W 0 m 0 o d o m m 0 o d o n m v m N 1O m ry .Qi n N � N ^ e � H � N N N N N N N N 'i M VQY n N N m v a m 1 N T N N Q N N M N O O 01 N O N eY N N DJ O N0 N N b O T � VOl ^W fl Ol m IN Q O N eY '1 M N h NNNVY VYNN O O O O O O O T O W-1 Ol N O O O O Qi n m O I� O 0000000 N Q OJ O N O Ili O O N h n ry N O 0 Q N N �NNV1NNti V� N � .N. NN m V ONNryi0 eQ1 O Y W W N N W W m O� S u m G E s °L a ¢ - ¢LL iLL LLLLu°.0 LL u ba m « as °m' 0 000aoo o a� u - N