The URL can be used to link to this page

Home My WebLink About2016-03-21-J10 ICAP RenewalWXG Waukee Irl ip THE KEY TO GOOD LIVING AGENDA ITEM: CITY OF WAUKEE, IOWA CITY COUNCIL MEETING COMMUNICATION MEETING DATE: March 21, 2016 AGENDA ITEM: Renewal with Iowa Communities Assurance Pool (ICAP) for 04/01/2016 — 03/31/2017 Property, Auto, Professional and Liability insurance. FORMAT: Resolution SYNOPSIS INCLUDING PRO & CON: The attached reports provide detail for the 2016/2017 insurance renewal and annual billing. With an increase in vehicle valuations of $314,520 and an increase property valuations of $2.5M, our premiums increased $9,831.42 or 5.58% over last year. There was no increase to our overall premium rate structure. Total Member credit — ($14,861.09) Enclosed is a memo from Mark Currie, reviewing the renewal information; Mark will not be at the meeting this year, so if you have any questions, we will have him attend the April 4th meeting. Staff has included his recommendation, moving the building/content deductible from $2500 to $5000, and has presented the revised invoice, recognizing the $4,914.78 premium reduction. Also, please note, staff did discover a couple items that are either duplicated on the original equipment listing, or show an incorrect valuation; those items will be corrected by ICAP and issued as an additional billing or credit once revisions are completed. FISCAL IMPACT INCLUDING COST/BENEFIT ANALYSIS: $185,988.04 COMMISSIONBOARD/COMMITTEE 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 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/01/2016 — 03/31/2017 PROPERTY, AUTO, PROFESSIONAL & LIABILITY INSURANCE IN THE AMOUNT OF $185,988.04 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 April 1, 2016 through March 31, 2017 at a cost of $200,849.13 less member distribution credit of $14,861.09, for a total payment of $185,988.04; 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 21" day of March, 2016, that it hereby approves payment to Iowa Communities Assurance Pool (ICAP) for 04/01/2016 — 03/31/2017 property, auto, professional & liability insurance in the amount of $185,988.04. William F. Peard, Mayor Attest: Rebecca D. Schuett, City Clerk ROLL CALL VOTE AYE NAY ABSENT ABSTAIN Shane Blanchard Brian Harrison Shelly Hughes Larry R. Lyon Rick Peterson Linda Burkhart From: Mark Currie <mcurrie@Insproins.com> Sent: Thursday, March 03, 2016 12:35 PM To: Linda Burkhart; Tim Moerman Cc: Brian Conway; Tonya Wagner Subject: ICAP Insurance renewal review for 2016/2017 Hi Linda, Thank you for meeting with Brian and I this morning. I will summarize the 2016 renewal with the expiring 2015 policy period. Your 2015-2016 renewal policy was issued at a gross premium of $190,882.14, less the renewal credit voucher of $14,725.52, for a net premium of $176,156.62. That does not include any changes that were made mid term that resulted in an additional premium being billed. The renewal rates for ICAP remained flat again this year. After the review meetings and updates from the Departments, we do have some exposure changes for the upcoming policy term. I will note several of the updates to exposure: Employee count has been increased from 74f/80pt to 86f/90pt, Payroll by Dept. reflects a change from $2.2M to $2.7M, EMrs increased from 18 to 20, Police Officers with Powers increased from 15 to 18, Auto values for the fleet increased from $5,945,846 to $6,260,366 and number of autos in the fleet increased as well. Cyber expense coverage was increased from the current level of $50,000 to the maximum now available of $250,000. Property values increased approximately $2,500,000 for the addition of Street lights and Traffic lights, plus some new equipment. The Property limits have been increased from $37,441,902 to $47,125,572..... this includes the items just noted, plus the Valuations Northwest changes /corrections. Those new building valuations were increase during the 2015-2016 term, but also remain on the 2016-2017 term with no additional premium, per the Program installed by ICAP for its membership. We did experience some auto liability losses over the past few years of around $36,000 in total, so a 2% debit (to Auto Liability premium) was added this year, but that only amounted to an increase of $275 range on the annual renewal. The renewal premium for 2016-2017 is $205,763.91 gross amount with a credit renewal voucher deduction of $14,861.09 , so the net premium is $190,902.82. We do have a recommendation this year to reduce premium costs. Currently the Building/Contents Deductible is $2500. We recommend increasing that to $5,000 as this will provide a premium reduction of $4,914.78. Your property loss trends are very good and we feel this would be a good savings consideration for the City to make. If you increase the deductible, the net cost for 2016-2017 would be reduced to $185,988.04. Lastly, the quotes did not include a quote for Earthquake Insurance.... that was quoted and declined last year. But it is still available and can be quoted upon request. You had noted the placement of the ICAP Insurance Renewal on the March 21" agenda. You had indicated that Brian and I did not need to attend this year, but we are happy to and available if that changes. Please let me know if you have any additional questions and "Thank You Again" for all the work you put into the preparation of the renewal application process. Best Regards, Mark Mark Currie, CIC Account Executive INSPRO INSURANCE 515-226-9565 Office Extension 1106 515-226-9443 Fax 515-988-4444 Cell CONFIDENTIALITY STATEMENT This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Al M Iowa Communities Assurance Pool INVOICE FOR City of Waukee Anniversary Date: 04/01/2016 5701 Greendale Road Johnston, IA 50131 www.icaplowa.com a. Iowa Communities Assurance Pool 5701 Greendale Road Johnston, IA 50131 Member Name: City of Waukee Member Address: 230 Hickman City, State, Zip: Waukee, IA 50263-5004 Member #: 59 Anniversary Date: 04/01 /2016 Coverage Limit of Coverage Contribution General Liability $2,000,000 $38,888.35 Automobile Liability $2,000,000 $13,513.05 Law Enforcement Liability $2,000,000 $6,110.47 Public Officials Wrongful Acts $2,000,000 $7,538.56 Excess Liability $6,000,000 $16,922.67 Vehicles $6,260,366 $30,471.46 Property $47,125,752 $92,319.35 Equipment Breakdown Included Included Crime $5,000 $0.00 FINAL CONTRIBUTION $205,763.91 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 City of Waukee Number 59 Date 02/24/2016 $ 14,861.09 Fourteen Thousand Eight Hundred Sixty -One Dollars and Nine Cents FOR: Member Distribution Redemption THE ICAP BOARD OF DIRECTORS Not Negotiable Voucher must be applied with current year anniversary invoice 11:KD Iowa Communities Assurance Pool REVISED Member Invoice Member Name: City of Waukee Anniversary Date: 04/01/2016 Policy Number: R0059PC2016-02 Coverage Limit of Coverage Contribution General Liability $2,000,000 $38,888.35 Automobile Liability $2,000,000 $13,513.05 Law Enforcement Liability $2,000,000 $6,110.47 Public Officials Wrongful Acts $2,000,000 $7,538.56 Excess Liability $6,000,000 $16,922.67 Vehicles $6,260,366 $30,471.46 Property $47,125, 752 $87,404.57 Equipment Breakdown Included Included Crime $5,000 $0.00 TOTAL CONTRIBUTION $200,849.13 MAKE CHECKS PAYABLE TO IOWA COMMUNITIES ASSURANCE POOL ON OR BEFORE: 04/01 /2016 When you provide a check as payment, you authorize us 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. At1 0 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,763.91 (less attached vouchers if applicable) by . 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 Signature Date Iowa Communities Assurance Pool 5701 Greendale Road Johnston, IA 50131 IKZD Iowa Communities Assurance Pool Member Proxy Be it known, that the undersigned representative of the Governmental Sub -Division (hereafter referred to as MEMBER) by resolution of the governing body, a copy of which is attached hereto, hereby nominates and appoints the following individual and alternate to represent the MEMBER with the Iowa Communities Assurance Pool (hereinafter referred to as the POOL). The individual and alternate shall act as liaison between MEMBER and the POOL for the purposes of relating risk reduction and loss control information, and any other loss information or instructions concerning the obligations of the MEMBER imposed by signing the Iowa Risk Management Agreement and the rules and regulations established thereunder, to the same extent and with like effect as the undersigned thereunder, to the same extent as the undersigned could do if personally present and the undersigned does hereby ratify and confirm and adopt all action done or taken by the individual or alternate. Primary Contact: Tim Moerman Title: Address: Address: City, State, Zip Email: Telephone: Alternate Contact:Linda Burkhart City Administrator Title: 230 Hickman Address: Waukee, IA 50263-5004 Address: City, State, Zip: tmoerman@waukee.org Email: 5159874522 Telephone Director of Finance 230 Hickman Waukee, IA 50263-5004 lburkhart@waukee.org 5159874522 In witness whereof, this proxy was executed on the day of in the year by the undersigned duly authorized officers of the Governmental Subdivision indicated below:. Governmental Subdivision: City of Waukee Member CAP #: 59 By: Title: By: (City Clerk/County Auditor/Board Secretary) NEED 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. Reviewed all applicable property and vehicle schedules. Confirms, to the best of his/her knowledge, that all information provided is complete and accurate. Reviewed 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: ❑ Waive 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 day of , in the year by the undersigned duly authorized officer of the Governmental Subdivision (City of Waukee) indicated below: l� Title: Member: City of Waukee Member Number: 59 Anniversary Date: 04/01/2016 I wczi M) Iowa Communities Assurance Pool REVISED Quote Summary City of Waukee Coverage General Liability Automobile Liability Law Enforcement Liability Public Officials Wrongful Acts Excess Liability Vehicles Property Equipment Breakdown Crime TOTAL CONTRIBUTION Excess Liability Options Excess Liability Excess Liability Excess Liability Excess Liability Excess Liability Excess Liability Excess Liability Contribution Anniversary Date: 04/01/2016 Limit of Retroactive Coverage Coverage Deductible Date Effective $38,888.35 $2,000,000 $0 $13,513.05 $2,000,000 $0 $6,110.47 $2,000,000 $2,000 $7,538.56 $2,000,000 $500 $16,922.67 $6,000,000 $30,471.46 $6,260,366 See Schedule $87,404.57 $47,125,752 See Schedule Included Included Included $0.00 $5,000 $500 $200,849.13 Limit of Coverage Contribution Liability Effective $18,170.67 $7,000.000 04/01/2016 $19,361.07 $8,000,000 04/01/2016 $20,489.07 $9,000,000 04/01/2016 $21,559.47 $10,000,000 04/01/2016 $22,567.47 $11,000,000 04/01/2016 $23,522.67 $12,000,000 04/01/2016 $24,449.07 $13,000,000 04/01/2016 This quotation expires on the Proposed Effective Date. 04/01/2016 04/01/2016 04/01/2016 04/01/2016 04/01/2016 04/01/2016 04/01/2016 04/01/2016 04/01/2016 04/01/2016 04/01/2016 Included 04/01/2016 NaD Iowa Communities Assurance Pool Schedule of Covered Vehicles City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 14 - 25 - 1300 L.A. Grant Parkway, Waukee, IA 50263 Year Make Model VIN Type Value Valuation Comp Ded Coll Ded 1 2013 Ford Interceptor AWD w/Eqpt 4844 Police 40,000 ACV Y $200 Y $600 2 2013 Ford Interceptor AWD w/Eqpt. 4843 Police 40,000 ACV Y $200 Y $600 3 2013 Ford Interceptor w/Eqpt. 0051 Police 46,000 ACV Y $200 Y $600 4 2011 Ford Crown Vic Intcptr w/egpt. 2403 Police 47,500 ACV Y $200 Y $600 5 2010 Ford Explorer w/Eqpt. 5131 Police 47.500 ACV Y $200 Y $600 6 2008 Ford Crown Victoria w/Eqpt. 4714 Police 47,500 ACV Y $200 Y $600 7 2000 Spartan Firetruck/Toyne Pumper 3683 Fire Trucks 480.000 RC Y $350 Y $1,000 8 2003 Miscellaneous E1 95' Ladder Truck 6652 Fire Trucks 800,000 RC Y $350 Y $1,000 9 2008 Ford E450 Ambulance 6912 Ambulances 170.000 RC Y $350 Y $1.000 10 2011 Ford F450 Ambulance 4532 Ambulances 170,000 RC y $200 Y $600 11 2000 Ford Explorer 5639 Fire Trucks 30,000 ACV Y $200 Y $600 12 2009 Ford Expedition/Fire Dept. 0403 Fire Trucks 42,500 ACV Y $200 Y $600 13 2013 Chevrolet Tahoe w/Eqpt. 7520 Fire Trucks 54,000 RC Y $200 Y $600 14 2013 Chevrolet Silverado 6500 Fire Trucks 32,999 ACV Y $200 Y $600 15 1938 Chevrolet Firetruck 8710 Fire Trucks 8,000 ACV Y $350 Y $1,000 16 2013 Chevrolet Impala w/Eqpt. 2G1 WG5 Police 50,000 ACV Y $200 Y $600 E370112 6560 17 2013 Freightliner E-1 Fire Engine Fire Trucks 450,000 ACV Y $350 y $1.000 18 2014 Ford Explorer w/Eqpt. 1FM5K8 Police 50.000 ACV Y $200 Y $600 AR2EGA 04119 19 2000 Trailer Decatur Galaxy Model RT-50 0680 Trailers 10,000 ACV Y $200 Y $600 Radar Trailer 202016 Ford Explorer w/Eqpt. 1FM5K8 Fire Trucks 41,000 RC Y $200 Y $600 AR2GGB 55576 21 2016 Ford Explorer w/Eqpt. 1 FM5K8 Police 48,000 ACV Y $200 Y $600 AR7GGA 47180 Total Location Vehicle Value: 2,704.999 vwz 1 ID Iowa Communities Assurance Pool Schedule of Covered Vehicles City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 20 - 31 - 230 Hickman, Waukee, IA 50263 Year Make Model VIN Type Value Valuation Comp Ded Coll Ded 1 2014 Chevrolet Equinox Sport Utility 2FTRF17 Passenger 25,000 ACV Y $200 V $600 233CA51 Car/Vans/Pickups 296 2 2014 Ford F-150 Pickup 1FTEX1E Passenger 24.200 ACV Y $200 Y $600 MOEKF7 CarlVans/Pickups 9263 Total Location Vehicle Value: 49,200 59 -91 - 805 University Ave., Waukee, IA 50263 Year Make Model VIN Type Value Valuation Comp Ded Coll Ded 1 2002 Chevrolet Silverado 4949 Passenger 24,000 ACV Y $200 Y $600 CarfVans/Pickups 2 2005 Chevrolet Pickup/Public Works 5393 Passenger 24,000 ACV Y $200 Y $600 CarNans/Pickups 3 2006 Chevrolet Silverado 0365 Passenger 25,000 ACV Y $200 Y $600 CarNans/Pickups 4 2013 Chevrolet Silverado (Strmwtr Dept) 6753 Passenger 26,498 ACV Y $200 Y $600 Car/Vans/Pickups 5 2003 Chevrolet Silverado 8072 Passenger 29,000 ACV Y $200 Y $600 CarlVans/Pickups 6 2012 Chevrolet F350 (Street Dept.) 5476 Passenger 45,000 ACV Y $200 Y $600 CarNans/Pickups 7 2008 Chevrolet Uplander (Park & Rao) 8615 Passenger 18,125 ACV Y $200 Y $600 Car/Vans/Pickups 8 2005 GMC Pickup 9632 Passenger 18,500 ACV Y $200 Y $600 Car/Vans/Pickups 9 2010 H&H Trailer 1081 Trailers 1.500 ACV Y $200 Y $600 10 2000 H&H Trailer 4,16UT16 Trailers 7,500 ACV Y $200 Y $600 ZZY8026 625 11 1999 Trailer Noma Trailer 1470 Trailers 12,000 ACV Y $200 Y $600 12 2014 Trailer Felling Trailer, Model 1132 Trailers 13,500 ACV Y $200 Y $600 FT20-2LP 13 2008 Trailer Dolittle Trailer 0895 Trailers 1.500 ACV Y $200 Y $600 14 2003 Trailer Kiefer Trailer 3638 Trailers 10,000 ACV Y $200 Y $600 15 2005 Trailer "CED Iowa Communities Assurance Pool Schedule of Covered Vehicles City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 Belshe T18-2EP Trailer 1045 Trailers 6,000 ACV Y $200 Y $600 16 2006 Trailer Doolittle 8x20 Trailer 8164 Trailers 7,500 ACV Y $200 Y $600 17 2005 Trailer McLander Trailer 7704 Trailers 7,500 ACV Y $200 Y $600 18 2009 Trailer Belshe Trailer 5224 Trailers 10,000 ACV Y $200 Y $600 19 2001 International Dump Truck 1137 Dump Trucks 45,000 ACV Y $200 Y $600 20 2000 International 4700 Dump Truck 6218 Dump Trucks 55,000 ACV Y $200 Y $600 21 2005 International Dump Truck 0218 Dump Trucks 86.000 ACV Y $200 Y $600 22 2007 International Dump Truck 6404 Dump Trucks 108,000 ACV Y $200 Y $600 23 2010 International Wing Truck 1378 Dump Trucks 135,000 ACV Y $200 Y $600 24 2013 International 7300 SFA 4X2 0545 Dump Trucks 168,000 ACV Y $200 Y $600 25 2013 International 7300 SFA 4x2 Dump Truck 4181 Dump Trucks 169,000 ACV Y $200 Y $600 26 2012 International Wing Truck 3240 Dump Trucks 186,000 ACV Y $200 Y $600 27 1998 International Dump Truck 5239 Dump Trucks 20,000 ACV Y $200 Y $600 28 2006 Ford w/Crane 9023 Lt. Med Trucks 20,320 ACV Y $200 Y $600 29 2012 Ford F550 SD Bucket Truck 6102 Lt. Med Trucks 95.000 ACV Y $200 Y $600 30 2004 Ford F450 3466 Lt. Med Trucks 25,000 ACV Y $200 Y $600 31 2012 Chevrolet 3500 HD (Water Dept.) 6053 Lt. Med Trucks 45,000 ACV Y $200 Y $600 32 1980 GMC Water Tanker 7392 Lt. Med Trucks 25,000 ACV Y $200 Y $600 33 2008 International 4300 (Gas Dept.) 9175 Lt. Med Trucks 66,000 ACV Y $200 Y $600 34 2010 Ford F350 1205 Passenger Car/Vans/Pickups 28,990 ACV Y $200 Y $600 35 2006 Ford Utility Pickup 9231 Passenger CarNans/Pickups 30.000 ACV Y $200 Y $600 36 2012 Ford F250 (Water Dept.) 2282 Passenger Car/Vans/Pickups 31,800 ACV Y $200 Y $600 37 2009 Ford F350 (PW/St. Dept.) 4426 Passenger Car/Vans/Pickups 35,000 ACV Y $200 Y $600 38 2011 Ford F350 XL Pickup 6631 Passenger CarNans/Pickups 35,000 ACV Y $200 Y $600 39 2012 Ford F350 (Street Dept.) 9539 Passenger CartVans/Pickups 45,000 ACV Y $200 Y $600 NEZD Iowa Communities Assurance Pool Schedule of Covered Vehicles City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 40 2012 International Tymco Sweeper, Model 0924 Road Maintenance 165,000 ACV Y $200 Y $600 4300M7SBA 41 2007 Ford E350 Cube Van 9559 Passenger 11,900 ACV Y $200 Y $600 Car/Vans/Pickups 42 2005 Ford V2 Ton Pickup 3053 Passenger 14,600 ACV Y $200 Y $600 CarNans/Pickups 43 2004 Ford 4x4 7402 Passenger 19,000 ACV Y $200 Y $600 CarNans/Pickups 44 2007 Ford Explorer 1810 Passenger 21.556 ACV Y $200 Y $600 CarNans/Pickups 45 2009 Ford F150 2199 Passenger 22,400 ACV Y $200 Y $600 CarNans/Pickups 46 1999 Ford F250 Super Cab 8122 Passenger 24,000 ACV Y $200 Y $600 Pickup/Public Works CarNans/Pickups 47 2006 Ford F-350 Pickup 9022 Passenger 25,000 ACV Y $200 Y $600 CarNans/Pickups 48 2013 Ford - Explorer 5410 Passenger 27,388 ACV Y $200 Y $600 CarNans/Pickups 49 2005 Ford Truck 5450 Passenger 28,000 ACV Y $200 Y $600 CarNans/Pickups 50 2010 Ford F150 5580 Passenger 28,350 ACV Y $200 Y $600 CarNans/Pickups 51 2010 Ford F350 1204 Passenger 28.990 ACV Y $200 Y $600 Car/Vans/Pickups 521998 Miscellaneous Road Husky Trailer 1N9FW1 Trailers 1,500 ACV Y $200 Y $600 016W105 4761 53 2013 Trailer Falcon RIME Asphalt Patch 1 F9P416 Trailers 35,000 ACV Y $200 Y $600 Trailer (Street Dept.) 22DM339 278 54 2003 Miscellaneous Spinner Cargo Van WD2YD5 Passenger 28,000 ACV Y $200 Y $600 4243553 CarNans/Pickups 5001 55 2014 International 7300 SFA 4x2 1HTWAA Dump Trucks 200,000 ACV Y $200 Y $600 AR9EH7 84006 56 2014 Trailer EH Wachs Valve 1 E9PT15 Trailers 70,000 ACV Y $200 Y $600 Maintenance Trailer llDC297 863 NCZD Iowa Communities Assurance Pool Schedule of Covered Vehicles City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 57 2014 Ford F-150 Pickup 1FTFXIE Passenger 35,000 ACV Y $200 Y $600 FOERE65 CarNans/Pickups 897 58 2015 Chevrolet Silverado 3500 Pickup 1GB4KY Passenger 35,000 ACV Y $200 Y $600 CG2FF14 Car/Vans/Pickups 8972 59 2015 Ford F-250 Pickup (Gas Dept.) 1FT7X28 Passenger 35,000 ACV Y $200 Y $600 66FEB12 Car/Vans/Pickups 515 60 2015 Ford F-250 Pickup (Water Dept.) 1FT7X2B Passenger 33,000 ACV Y $200 Y $600 68FEB12 Car/Vans/Pickups 516 61 2015 International 7300 SFA 4x2 (Street Dept.) 3HAWAA Dump Trucks 200,000 ACV Y $200 Y $600 AR9FL57 3089 62 2015 Trailer Sure-Trac Utility Trailer 5JW1 U 12 Trailers 1,750 ACV Y $200 Y $600 18F1112 563 63 2015 Ford F550 1FDUF5 Lt. Med Trucks 51,000 ACV Y $200 Y $600 HY4FEC 98812 64 2015 Chevrolet Silverado Pickup 1GCVKP Passenger 35,000 ACV Y $200 Y $600 EC4FZ36 Car/Vans/Pickups 7015 652015 Chevrolet Silverado Pickup 1GCVKP Passenger 35,000 ACV Y $200 Y $600 EC1FZ36 CarNans/Pickups 6470 66 2016 Ford F-250 Pickup 1FTSF28 Passenger 35,500 ACV Y $200 Y $600 64GEA66 CarNans/Pickups 620 67 2016 Ford F-250 Pickup 1FT7X2B Passenger 35,000 ACV Y $200 Y $600 62GEA66 CarNans/Pickups 621 68 2006 International Series 7400 Hydro -Vac Truck 1 HTWHA Heavy 150,000 ACV Y $200 Y $600 ZT96J24 5763 69 2015 Trailer Sprayer Specialties Trailer TBD Trailers 20,000 ACV Y $200 Y $600 70 2015 International 7400 Plow Truck 3HAWHS Dump Trucks 200,000 ACV Y $200 Y $600 UT6GL19 8434 71 2015 Ford F550 1TC1600 Lt. Mad Trucks 51,000 ACV Y $200 Y $600 TVEF200 349 NEZ0 Iowa Communities Assurance Pool Schedule of Covered Vehicles City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 72 2014 Ford F-150 Pickup 1 FDUF5 Passenger 25,000 ACV Y $200 Y $600 AY4FEC CarNans/Pickups 98812 73 2002 Chevrolet 2500 Pickup 1GCHK2 Passenger 35,000 ACV Y $200 Y $600 41.102Z23 CarNans/Pickups 4949 74 2003 H&H UT162 Sign Trailer 4J6UT16 Trailers 2,000 ACV Y $200 Y $600 Z42BO40 337 Total Location Vehicle Value: 3,506,167 99 -99 - Liability Only, Waukee, IA 50263 Year Make Model VIN Type Value Valuation Comp Ded Coll Ded 1 1995 Buick LeSabre Custom 3671 Police 0 LO N N 2 2003 John Deere 700CH Motorgrader DW770C Road Maintenance 0 LO N N H588662 Total Location Vehicle Value: 0 Total ACV Value: 4,545,366 Total RC Value: 1,715,000 Total SA Value: 0 Grand Total Vehicle Value: 6,260,366 NaD Iowa Communities Assurance Pool Additional Property Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 14 - 25 -1300 L.A. Grant Parkway, Waukee, IA 50263 Coverage Line Classification Description Serial No Limit Valuation Deductible 1 EDP - Hardware (17) RS2-X2 Body Cameras (valued at $829 each) $14.093 RC $500 2 EDP - Hardware 4-Bay NAS (for use w/body camera system) $2,278 RC $500 3 EDP - Hardware HP ProLiant ML150 G9 Tower Server (for use w/body cameras) $9,161 RC $500 4 EDP - Hardware (3) RS2-X2 Docking Stations (valued at $349 each) $1,047 RC $500 5 Miscellaneous Grass Fire Skid $10,000 RC $500 ProDertv Scheduled 6 EDP - Hardware Police/Fire 800 Digital Radios $207,000 RC $500 7 EDP -Software Unscheduled EDP Software (individual item value not to exceed $40,000 RC $500 8 EDP - Hardware Unscheduled EDP Hardware (individual item value not to exceed $60,000 RC $500 $4,800 per item) 9 EDP - Hardware Thermal Imaging Camera $10,000 RC $500 10 Miscellaneous Make Air Compressor $10,000 RC $500 Property Scheduled 11 EDP - Hardware (4) Hand -Held Radar Units (valued at $1,500 each) $6.000 RC $500 12 EDP - Hardware Lazar Hand -Held Radar Unit $5,000 RC $500 13 Miscellaneous John Deere Gator with'Med Bed' 6879 $12,000 RC $500 Property Scheduled 14 Miscellaneous Motorcycle Puppet $5,000 RC $500 Property Scheduled 15 EDP - Hardware Thermal Imaging Camera $10.300 RC $500 16 Miscellaneous Miscellaneous Police Car Equipment (in -car video/computers, $100.000 RC $500 Property Scheduled radios, stop sticks, guns) 17 Miscellaneous Miscellaneous Fire Equipment (ind air tanksKre equipment) $100.000 RC $500 Property Scheduled 18 Miscellaneous Jaws of Life/Power Unit, Spreader, Cutter, (2) Rams $22,000 RC $500 Property Scheduled 19 Miscellaneous (2) Automatic Defibrillator (valued at $18.000 each) $36,000 RC $500 Property Scheduled 20 EDP - Hardware (10) Mobile Vision Cameras in Vehicles (valued @ $5,000 each) $50,000 RC $500 Total Location EDP - Hardware $374,879 Total Location EDP - Software $40,000 Total Location Miscellaneous Property Scheduled $295,000 Total Location Additional Property Scheduled Value $709,879 zKzi)� Iowa Communities Assurance Pool Additional Property Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 20 -31 - 230 Hickman, Waukee, IA 50263 Line Classification Description Coverage Serial No Limit Valuation Deductible 1 EDP -Software Invision Software $43,517 RC $500 2 EDP - Software Utility Billing $3,000 RC $500 3 EDP - Software Fixed Assets $1,000 RC $500 4 EDP - Hardware Okidata 393 Matrix Printer $1,500 RC $500 5 EDP - Software Windows 2000 Software $820 RC $500 6 EDP - Software Backup Exec Software & tapes $1,954 RC $500 7 EDP - Hardware HP Proliant ML150 Server NB71 $1,808 RC $500 8 EDP - Hardware AST Vision 7L Monitor Model P766d, S#353D700800452; AST $3,247 Bravo Computer LC 4/66 Model #601199-115, S#USC9010072 RC $500 9 EDP -Hardware Monitor $1,850 RC $500 10 EDP - Hardware Handheld Computer Meter Readers (Unisys 838 systems: 838-CPU, 2 MB Memory 90 MB Disk/Floppy Drive) $15,000 RC $500 11 EDP - Hardware (2) 12" Power Supplies $10,440 RC $500 12 EDP - Hardware Dell 230OMP Projector 0362 $1,188 RC $500 13 EDP - Hardware HP 1600 Printer MOLM $300 RC $500 14 EDP - Hardware Tape Drive/Power Supply $2,925 RC $500 15 EDP - Hardware Unisys PW2 300-10 PC, 20M8 Disk, 640 KB Memor, Keyboard, Mono Monitor $2,379 RC $500 16 EDP - Hardware (7) Compac Desk Pros $9,921 RC $500 17 EDP - Hardware HP Pavilion 9880 $2,084 RC $500 18 EDP - Hardware B27-LCW W/512KB, B27-LCW-3812 52477, B25-KS-138891 $995 RC $500 19 EDP - Hardware 100' Cluster Cable $80 RC $500 20 EDP - Software Budgetary Accounting $2,500 RC $500 21 EDP - Software Context Manager $413 RC $500 22 EDP - Software Powerbook 150 Laptop $3,000 RC $500 23 EDP - Software New Program to Sequence Meters, Option -Build more than 1 account $250 RC $500 24 EDP -Hardware 827-LCW Workstation $700 RC $500 25 EDP - Hardware B27-LCW-3788-35581 Mono Monitor Keyboard, BTOS II OP Sys B2-Low $2,105 RC $500 26 EDP - Software Payroll Accounting $2,500 RC $500 27 EDP - Software Inventory $1,000 RC $500 NEZ1 D Iowa communities Assurance Pool Additional Property Statement of Values 28 EDP - Software City of Waukee Report Writer Effective Date: 04/01/2016 Printed on: 02/23/2016 $1,000 RC $500 29 EDP - Software Ofis Writer $825 RC $500 30 EDP -Hardware HP Laserjet Printer $1,780 RC $500 31 EDP - Hardware Leased Computer Equipment $7 036 RC $500 32 EDP - Software Enhanced Mulliplan $550 RC $500 33 EDP - Software PC-TOS Net $700 RC $500 34 EDP - Software Data Base $500 RC $500 35 EDP - Hardware Compac Proliant ML350 Server $6,583 RC $500 36 EDP -Software Payroll/Personal $500 RC $500 37 EDP - Software Perpetual Calendar Program $300 RC $500 Total Location EDP - Hardware $71,921 Total Location EDP - Software $64,329 Total Location Additional Property Scheduled Value $136,250 24 - 34 - 950 Warrior Lane, Waukee, IA 50263 Coverage Line Classification Description Serial No Limit Valuation Deductible i EDP - Hardware Unscheduled EDP Hardware (individual item value not to exceed $60,000 RC $500 2 Fine Arts American Gothic (-derived) "Iowa - Past and Present - Living $33.000 RC $500 Fence" Sculpture (created by John Brommel in 2003) Total Location EDP - Hardware $50,000 Total Location Fine Arts $33.000 Total Location Additional Property Scheduled Value $83,000 39 -55 -1501 6th St., Waukee, IA 50263 Coverage Line Classification Description Serial No Limit Valuation Deductible 1 Miscellaneous John Deere 1600 Wide Area Mower $58,000 RC $500 Properly Scheduled 2 Miscellaneous 2014 Jacobsen LF-570 Fairway Mower 06798202513 $50,000 RC $500 Property Scheduled 3 Miscellaneous 2001 Sullivan Air Compressor 30536 $12,000 RC $500 Property Scheduled 4 Miscellaneous Jacobson Greens Mower 6628905033 $16,000 RC $500 Property Scheduled 5 Miscellaneous 2011 Jacobsen R311T, 60hp Kubota, 11' Cut Mower, Model 6917101750 $49,085 RC $500 Property Scheduled #069171 6 Miscellaneous 2012 Redexim Seeder C348211 $11,000 RC $500 19:KD Iowa communities Assurance Pool Additional Property Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 7 Miscellaneous 2011 Buffalo CKB4 19981 $7,500 RC $500 Property Scheduled 8 Miscellaneous 2001 Redexim 1500 B0186 $6,000 RC $500 Property Scheduled 9 Miscellaneous 2005 Jacobson, Model 3407 06795201655 $50,000 RC $500 Property Scheduled 10 Miscellaneous 2006 Jacobson 6228904050 $25,000 RC $500 Property Scheduled 11 Miscellaneous 2006 Ryan GA60 $25,000 RC $500 Property Scheduled 12 Miscellaneous 2007 Smitco Sweeper 7901 $10,000 RC $500 Property Scheduled 13 Miscellaneous 2009 Jacobson 6228905033 $25,000 RC $500 Property Scheduled 14 Miscellaneous (2) Truckster Dump 9569 $6,000 RC $500 Property Scheduled 15 Miscellaneous Jacobson LF-128 677951701 $3,500 RC $500 Property Scheduled 16 Miscellaneous Turfco Toppdresser 8542 $7,000 RC $500 Property Scheduled 17 Miscellaneous 2014 Cushman Truckster Utility Cart, Model 84067 84067000212 $22,000 RC $500 Property Scheduled 5 18 Miscellaneous Golf Carts $200,000 RC $500 Property Scheduled 19 Miscellaneous Tees & Greens $100,000 RC $500 Property Scheduled Total Location Miscellaneous Property Scheduled Total Location Additional Property Scheduled Value $682.085 $682,085 48. 100 -1255 3rd Street, Waukee, IA 50263 Coverage Line Classification Description Serial No Limit Valuation Deductible 1 EDP - Hardware Unscheduled EDP Hardware (individual item value not to exceed $5,880 RC $500 Total Location EDP - Hardware $5,880 Total Location Additional Property Scheduled Value $5,880 59 - 91 - 805 University Ave., Waukee, IA 50263 Coverage Line Classification Description Serial No Limit Valuation Deductible 1 Miscellaneous 2013 Hitachi ZX35 Compact Excavator NCMIYAOOA $43,500 RC $500 Property Scheduled 00270827 Iowa Communities Assurance Pool Additional Property Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 2 EDP - Hardware Unscheduled EDP Hardware (indivdual item value not to exceed $75,000 RC $500 $3,500 per item) 3 EDP - Hardware HP Officejet 5610 All -In -One Printer 320A $600 RC $500 4 Miscellaneous 1998 Ingersoll Air Compressor XP185WJD 186959U9032 $20,000 RC $500 Property Scheduled 9 5 Miscellaneous Kubota 72" F3060 Mower $14,000 RC $500 Property Scheduled 6 Miscellaneous 1991 Jacobson IV Verti-Cut Mower 622871766 $25,000 RC $500 Property Scheduled 7 Miscellaneous 2012 John Deere 1600 Wing Mower ITC160OTPC $58,000 RC $500 Property Scheduled 100079 8 Miscellaneous X-Mark 324333 $15,000 RC $500 Property Scheduled 9 Miscellaneous Case MXI DFG0006075 $32,000 RC $500 Property Scheduled 10 Miscellaneous 2010 John Deere 507SE PY507SE001 $30,000 RC $500 Property Scheduled 676 11 Miscellaneous 2012 Husqvarna F54800 00130469300 $35.000 RC $500 Property Scheduled 1 12 Miscellaneous 2013 John Deere 544K Loader 1DW544KZD $170,000 RC $500 Property Scheduled E657071 13 Miscellaneous 1995 Contrail K1T2C15215 $1,500 RC $500 Property Scheduled 616175 14 Miscellaneous Brushog TD1500 $2,000 RC $500 Property Scheduled 15 Miscellaneous 2007 Clark C25 Forklift $15,000 RC $500 Property Scheduled 16 EDP - Hardware (2) Gateway Computers, Model EV700 (Q $900 ea) 03606272103 $1,800 RC $500 606267 17 Miscellaneous 2011 Bobcat 5600 AOW116747 $50,000 RC $500 Property Scheduled 18 Miscellaneous Advance Zamboni 1987202 $17,500 RC $500 Property Scheduled 19 Miscellaneous Vermeer 3"Mole $4,200 RC $500 Property Scheduled 20 Miscellaneous John Deere 72" Mower CH310230D4 $16,000 RC $500 Property Scheduled 007 21 Miscellaneous 2014 Crafco Crack Sealer w/Trailer 1 CPSY1019E $33,000 RC $500 Property Scheduled 1418018 22 Miscellaneous Rotary Broom for Bobcat $4,800 RC $500 Property Scheduled i Iowa Communities Assurance Pool Additional Property Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 23 Miscellaneous 10' John Deere Ditch Mower 1518 $9,200 RC $500 Property Scheduled 24 Miscellaneous 2010 Case 580 Super M JJGN580SHA $95.000 RC $500 Property Scheduled C531774 25 EDP - Hardware Sony Laptop, Model PCG9211 2528 $2 500 RC $500 26 Miscellaneous 2012 ExMark Mower 0606 $12,500 RC $500 Property Scheduled 27 Miscellaneous 2012 John Deere Model 5065M Tractor 1 LV506SMTC $45,000 RC $500 Property Scheduled J443791 28 Miscellaneous 2009 Bobcat Model T300 ASGU35074 $50,000 RC $500 Property Scheduled 29 Miscellaneous 2014 Minnich Concrete Drill, Model A-1-36 (Street Dept.) 1044140- $7,500 RC $500 Property Scheduled 11.5 30 Miscellaneous 1993 Portable Backup Generator w/Trailer $23,000 RC $500 Property Scheduled 31 Miscellaneous 2010 John Deere CXIS POCX16G00 $16,000 RC $500 Property Scheduled 8827 32 Miscellaneous 2013 Minnich Concrete Drill Al 30UTL 1043735.11 $7,500 RC $500 Property Scheduled 33 Miscellaneous 2000 Erskin Snowblower 780 FM 12841 $5.000 RC $500 Property Scheduled 34 Miscellaneous 2007 John Deere MX7 Mower W00MX7X01 $3.000 RC $500 Property Scheduled 3958 35 Miscellaneous 1987 Club Car Turf Cart RG0010- $500 RC $500 Property Scheduled 874429 36 Miscellaneous 2011 Bobcat SBX240 84" Snowblower 713600902 $6,000 RC $500 Property Scheduled 37 Miscellaneous 2011 Bobcat SB200 72" Snowblower 712903913 $4,500 RC $500 Property Scheduled 38 Miscellaneous 2010 Big Ox Snowblade 985- $5,000 RC $500 Property Scheduled C3347103 39 Miscellaneous 2013 Bobcat 9' Snow Blade AD5S00798 $3.200 RC $500 Property Scheduled 40 EDP - Hardware (2) TopCon Units (valued at $15,000 each) $30 000 RC $500 41 EDP - Hardware GIS Server (Public Works) $13 102 RC $500 42 Miscellaneous John Deere 1600 Turbo Series II Commercial Wide -Area Mower ITC1600TVE $51,212 RC $500 Property Scheduled w/Eqpt. F200349 43 Miscellaneous 2013 Astec RT800 Trencher RT08000K01 $118,900 RC $500 Property Scheduled 13 44 Miscellaneous 2003 John Deere 770CH Motorgrader 8662 $120,000 RC $500 Property Scheduled NE1 D Iowa communities Assurance Pool Additional Property Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 45 Miscellaneous Hydraulic Breaker $7.000 RC $500 Property Scheduled 46 Miscellaneous Greco 3900 4062 $3,800 RC $500 Property Scheduled 47 EDP - Hardware GPS Equipment $35,000 RC $500 48 Miscellaneous 2006 VED Pump Controller N1224240838 $20.000 RC $500 Property Scheduled 79 49 Miscellaneous 2007 Vicon PS403 Spreader 75406-09- $7,500 RC $500 Property Scheduled 9566 50 Miscellaneous Christmas Decorations $10.000 RC $500 Property Scheduled 51 Miscellaneous Ringomatic $90,000 RC $500 Property Scheduled 52 Miscellaneous Sewer Jet Machine $45.000 RC $500 Property Scheduled 53 EDP - Hardware (2) AR4002RF Sensus w/2 Charging Stands 312A/674A $6,000 RC $500 54 Miscellaneous John Deere 72" Mower CD3012DO36 $16,000 RC $500 Property Scheduled 317 55 Miscellaneous VXU Unite, Model 3600 917B $25,000 RC $500 Property Scheduled 56 Miscellaneous Park Equipment $30,000 RC $500 Property Scheduled 57 Miscellaneous 2008 John Deere Model Z840A TC840ALL01 $10,000 RC $500 Property Scheduled 0701 58 Miscellaneous John Deere 1200A TC1200A160 $7,500 RC $500 Property Scheduled 756 59 Miscellaneous John Deere 1200A TC1200AI35 $7,500 RC $500 Property Scheduled 378 60 Miscellaneous Total Station Survey Equipment $15,000 RC $500 Property Scheduled Total Location EDP - Hardware $164,002 Total Location Miscellaneous Property Scheduled $1,463,812 Total Location Additional Property Scheduled Value $1,627,814 59 - 95 - 805 University Ave., Waukee, IA 50263 Coverage Line Classification Description Serial No Limit Valuation Deductible 1 EDP - Hardware Sewer Line Video Camera $12 000 RC $500 2 Miscellaneous 2013 Bobcat 2858 $45,000 RC $500 Property Scheduled NCA D Iowa communities Assurance Pool Additional Property Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 02/23/2016 3 Miscellaneous 2012 Bobcat E80 Excavator 2578 $100,000 Prooertv Scheduled RC $500 Total Location EDP - Hardware $12,000 Total Location Miscellaneous Property Scheduled $145,000 Total Location Additional Property Scheduled Value $157,000 63 -101 -1725 98th St., West Des Moines, IA 50263 Coverage Line Classification Description Serial No Limit Valuation Deductible 1 EDP - Hardware Unscheduled EDP Hardware (individual item value not to exceed $5,880 RC $500 Total Location EDP - Hardware $5,880 Total Location Additional Property Scheduled Value $5,880 98 -98 - Various Locations, Waukee, IA 50263 Coverage Line Classification Description Serial No Limit Valuation Deductible 1 Miscellaneous Unscheduled Miscellaneous Property/Tools (individual item value $125,000 RC $500 Property Unscheduled not to exceed $10,00 per item) Total Location Miscellaneous Property Unscheduled $125,000 Total Location Additional Property Scheduled Value $125,000 Grand Total EDP - Hardware $684,562 Grand Total EDP - Software $104,329 Grand Total Fine Arts $33,000 Grand Total Miscellaneous Property Scheduled $2,585,897 Grand Total Miscellaneous Property Unscheduled $125,000 Grand Total Additional Property Scheduled Value $3,532,788 suz ID Iowa Communities Assurance Pool REVISED Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area # of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 1- 1: Centennial Park on University 800 1 6 Y N N Y Waukee, IA 50263 Shelter Value Valuation Deductible Building 47,487 RC $5,000 Personal Property 1,000 RC $5,000 Total Location TIV 48,487 1- 2: Centennial Park on University 480 2 6 Y N N Y Waukee, IA 50263 Restroom Value Valuation Deductible Building 49,905 RC $5,000 Personal Property 1,000 RC $5,000 Total Location TIV 50,905 1- 3: Centennial Park on University 480 2 6 Y N N Y Waukee, IA 50263 Restroom Value Valuation Deductible Building 49,905 RC $5,000 Personal Property 1,000 RC $5,000 Total Location TIV 50,905 1- 4: Centennial Park on University 576 1 6 Y N N Y Waukee, IA 50263 Concession Stand (addition in 2009) Value Valuation Deductible Building 83,111 RC $5,000 Personal Property 10,000 RC $5,000 Total Location TIV 93,111 1- 36: Centennial Park on University 3 6 Y N N Y Waukee, IA 50263 Playground Equipment Value Valuation Deductible Building 97,521 RC $5,000 Total Location TIV 97,521 1 -42: Centennial Park on University 3 6 Y N N Y Waukee, IA 50263 Siren & Solar Panel System Value Valuation Deductible Building 42,448 RC $5,000 Total Location TIV 42,448 NE1 0 Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 1- 49: Centennial Park on University 3 6 Y N N Y Waukee, IA 50263 Ball Field Lights Value Valuation Deductible Building 31,084 RC $5,000 Total Location TIV 31,084 1- 92: Centennial Park on University 1 2011 1 6 Y N N y Waukee, IA 50263 Walk Path Bridge Value Valuation Deductible Building 212,242 RC $5,000 Total Location TIV 212,242 2- 6: 1205 6th 4,860 1 1975 1 6 Y N N y Waukee, IA 50263 Maintenance Garage/Public Works Value Valuation -Deductible Building 104,040 ACV $5,000 Personal Property 2,000 RC $5,000 Total Location TIV 106,040 2- 8: 1205 6th 775 1 1975 1 6 Y N N y Waukee, IA 50263 Storage Garage Value Valuation Deductible Building 22,142 RC $5,000 Personal Property 2,000 RC $5,000 Total Location TIV 24,142 3- 9: South of Waukee 864 3 6 Y N N Y Waukee, IA 50263 Well House Value Valuation Deductible Building 22,082 RC $5,000 Personal Property 1,000 RC $5,000 Total Location TIV 23,082 4- 10: 1215 6th St. 2.190 1 1991 1 6 Y N N Y Waukee, IA 50263 Maintenance/Garage Value Valuation Deductible Building 104,040 RC $5,000 Personal Property 5,000 ACV $5,000 Total Location TIV 109,040 � r Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 5 - 13: Water Treatment Facilityll 300 4th St. 429 1 1994 4 6 Y N N Y Waukee, IA 50263 EQ Basin Blower Building Value Valuation Deductible Building 176,531 RC $5,000 Personal Property 15,860 RC $5,000 Total Location TIV 192,391 6- 15: 410 6th 3,348 1 1928 4 6 Y N N Y Waukee, IA 50263 Community Center (leased out) Value Valuation Deductible Building 334,563 RC $5,000 Personal Property 1,000 RC $5,000 Total Location TIV 335,563 12 - 23: Winfield Park 2,000 2015 1 6 Y N N Y Waukee, IA 50263 Restroom & Shelter Value Valuation Deductible Building 175,000 RC $5,000 Personal Property 1,000 RC $5,000 Total Location TIV 176,000 12 - 44: Winfield Park 3 6 Y N N Y Waukee, IA 50263 Playground Equipment Value Valuation Deductible Building 92,000 RC $5,000 Total Location TIV 92,000 13 - 24: 397 Hwy. 6 225 1995 3 6 Y N N Y Waukee, IA 50263 Lift Station #2 Value Valuation Deductible Building 351,758 RC $5,000 Total Location TIV 351,T58 13 - 45: 397 Hwy. 6 350 1 2005 1 6 Y N N Y Waukee, IA 50263 Storage Building Value Valuation Deductible Building 60,948 RC $5,000 Personal Property 50,000 RC $5,000 Total Location TIV 110,948 I Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 14 - 25: 1300 L.A. Grant Parkway 26,743 2 1998 4 6 Y N N Y Waukee, IA 50263 Police/Fire Dept Ind Generator/Comm. Towers Value Valuation Deductible Building 6,258,720 RC $5.000 Personal Property 300,000 RC $5,000 EDP - Hardware 374,879 RC $500 EDP - Software 40,000 RC $500 Miscellaneous Property Scheduled 295,000 RC $500 Total Location TIV 7,268,599 15 - 26: 50 Little Walnut Creek Drive 3 6 Y N N Y Waukee, IA 50263 Siren & Solar Panel System Value Valuation Deductible Building 42,448 RC $5,000 Total Location TIV 42,448 16 - 27: 501 4th St. 3 6 Y N N Y Waukee, IA 50263 Siren & Solar Panel System Value Valuation Deductible Building 42,448 RC $5,000 Total Location TIV 42,448 17.28: 1155 Westbrooke 3 6 Y N N Y Waukee, IA 50263 Siren & Solar Panel System Value Valuation Deductible Building 42,448 RC $5,000 Total Location TIV 42,448 18 - 29: 701 Boone Drive 3 6 Y N N Y Waukee, IA 50263 Siren & Solar Panel System Value Valuation Deductible Building 42,448 RC $5,000 Total Location TIV 42,448 19 - 30: 600 142nd St. 146 1999 3 6 Y N N Y Waukee,1A 50263 Lift Station #4 Value Valuation Deductible Building 382,619 RC $5,000 Total Location TIV 382,619 NEzi) Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 19 - 73: 600 142nd St. 3 6 Y N N Y Waukee, IA 50263 East Town Border Station Value Valuation Deductible Building 175,749 RC $5,000 Total Location TIV 175,749 20 - 31: 230 Hickman 12,000 1 1999 1 6 Y N N Y Waukee, IA 50263 City Hall & Offices (renovation/2013) Value Valuation Deductible Building 2,648,668 RC $5,000 Personal Property 316,590 RC $5,000 EDP - Hardware 71,921 RC $500 EDP - Software 64,329 RC $500 Total Location TIV 3,101,508 20 - 105: 230 Hickman 3 6 Y N N Y Waukee, IA 50263 (3) Flag Poles Value Valuation Deductible Building 15,606 RC $5,000 Total Location TIV 15,606 22 - 32: Hwy R22 3,500 1997 2 6 Y N N Y Waukee, IA 50263 Sewer Treatment Facility, incl. Generator & Lagoon Eqpt. Value Valuation Deductible Building 1,554,915 RC $5,000 Personal Property 3,000 RC $5,000 Total Location TIV 1,557,915 22-109:Hwy R22 3 6 Y N N Y Waukee, IA 50263 Fencing Value Valuation Deductible Building 10,200 RC $5,000 Total Location TIV 10,200 WE Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spkir Built Reno Code Class Break Limit 24 - 34: 950 Warrior Lane 16,811 1 2002 1 6 Y N N Y Waukee, IA 50263 New Library Value Valuation Deductible Building 2,932,925 RC $5,000 Personal Property 1,575,000 RC $5,000 EDP - Hardware 50,000 RC $500 Fine Arts 33,000 RC $500 Total Location TIV 4,590,925 24 - 81: 950 Warrior Lane 150 2002 2 6 Y N N y Waukee, IA 50263 Lift Station #9 Value Valuation Deductible Building 48,000 ' RC $5,000 Total Location TIV 48,000 25 - 35: 3256 Ashworth Rd. 3 6 Y N N y Waukee, IA 50263 Siren & Solar Panel System Value Valuation Deductible Building 42,448 RC $5,000 Total Location TIV 42,448 27 - 37: 31653 Ute 126 2004 2 6 Y N N y Waukee, IA 50263 Lift Station #8 Value Valuation Deductible Building 190,235 RC $5,000 Total Location TIV 190,235 27 - 86: 31653 Ute 3 6 Y N N y Waukee, IA 50263 Siren & Solar Panel System Value Valuation Deductible Building 42,448 RC $5,000 Total Location TIV 42,448 29 - 40: 225 University Ave. 3 6 Y N N y Waukee, IA 50263 Siren & Solar Panel System Value Valuation Deductible Building 42,448 RC $5,000 Total Location TIV 42,448 NEZD Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 30 - 41: 550 Ashworth Drive, Triangle Park 1 6 Y N N Y Waukee,lA 50263 Clock Value Valuation Deductible Building 11,190 RC $5,000 Total Location TIV 11,190 30 - 43: 550 Ashworth Drive, Triangle Park 6 6 Y N N Y Waukee,lA 50263 (18) Iron Lampposts Value Valuation Deductible Building 228,284 RC $5,000 Total Location TIV 228,284 30 - 57: 550 Ashworth Drive, Triangle Park 120 1 2002 2 6 Y N N Y Waukee, IA 50263 Bandstand Value Valuation Deductible Building 22,082 RC $5,000 Total Location TIV 22,082 31 - 88: Ridge Pointe Park 3 6 Y N N Y Waukee, IA 50263 Playground Equipment Value Valuation Deductible Building 55,204 RC $5,000 Total Location TIV 55,204 31 - 89: Ridge Pointe Park 3 6 Y N N Y Waukee,lA 50263 Playground Equipment Value Valuation Deductible Building 11,041 RC $5,000 Total Location TIV 11,041 32 - 47: Southfork Park 3 6 Y N N Y Waukee, IA 50263 Playground Equipment Value Valuation Deductible Building 24,866 RC $5,000 Total Location TIV 24,866 1 � Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 32 - 48: Southfork Park 1,200 1 1990 2 6 Y N N Y Waukee, IA 50263 Open Shelter Value Valuation Deductible Building 31,084 RC $5,000 Total Location TIV 31,084 34 - 50: 1300 3rd Street 168 1998 2 6 Y N N Y Waukee, IA 50263 Lift Station #1 Value Valuation Deductible Building 449,767 RC $5,000 Total Location TIV 449,767 35-51:1080 Westwoods 165 1999 2 6 Y N N Y Waukee, IA 50263 Lift Station #3 & Silent Pump Value Valuation Deductible Building 304,748 RC $5,000 Total Location TIV 304,748 37 - 78: Hickman and Alices Rd. 3 6 Y N N Y Waukee, IA 50263 SlreetlTraffic Lights Value Valuation Deductible Building 218,906 RC $5,000 Total Location TIV 218,906 39 - 55: 1501 6th St. Waukee, IA 50263 Value Valuation Deductible Miscellaneous Property Scheduled 682,085 RC $500 Total Location TIV 682,085 39 - 56: 1501 6th St. 2,940 1 1999 3 6 Y N N Y Waukee, IA 50263 Pole Building/Storage Value Valuation Deductible Building 87,276 RC $5,000 Personal Property 10,000 RC $5,000 Total Location TIV 97,276 WIF 0 Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 39 - 76: 1501 6th St. 3 6 Y N N Y Waukee, lA 50263 Comfort Stations (benches/ball washers-machine/signs) Value Valuation Deductible Building 27,602 RC $5,000 Total Location TIV 27,602 39 - 121: 1501 6th St. 150 2001 2 6 Y N N Y Waukee,lA 50263 Lift Station #11 Value Valuation Deductible Building 13,500 RC $5,000 Total Location TIV 13,500 41 - 59: Hickman & N. 10th 3 6 Y N N Y Waukee, IA 50263 Street/Traffic Lights Value ' Valuation Deductible Building 223,807 RC $5,000 Total Location TIV 223,807 42 - 60: Hickman & 4th St. 3 6 Y N N Y Waukee, IA 50263 StreetlTraffic Lights Value Valuation Deductible Building 223,807 RC $5,000 Total Location TIV 223,807 43 - 61: Hickman & Warner Lane 3 6 Y N N Y Waukee, IA 50263 Street/Traffic Lights Value Valuation Deductible Building 223,807 RC $5,000 Total Location TIV 223,807 44 - 65: Boone Drive & University 3 6 Y N N Y Waukee, IA 50263 Streetfrraffic Lights Value Valuation Deductible Building 223,807 RC $5,000 Total Location TIV 223,807 ii PO Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area If of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 45 - 74: 90 N. 10th St. 2006 3 6 Y N N Y Waukee, IA 50263 West Town Border Station Value Valuation Deductible Building 175,749 RC $5,000 Total Location TIV 176,749 46 - 68: Hickman - Alices Road to R22 3 6 Y N N Y Waukee, IA 50263 Street Lights Value Valuation Deductible Building 609,497 RC $5,000 Total Location TIV 609,497 48 - 70: 1255 3rd Street 1978 3 6 Y N N y Waukee, IA 50263 Water Tower & Antenna Value Valuation Deductible Building 1,837,300 RC $5,000 Total Location TIV 1,837,300 48 - 100: 1255 3rd Street 1 2012 3 6 y N N y Waukee, IA 50263 Water Tower Climate Controls w/Base Station/Antenna Value Valuation Deductible Building 75,164 RC $5,000 EDP - Hardware 5,880 RC $500 Total Location TIV 81,044 48 - 108: 1255 3rd Street 6 6 y N N y Waukee, IA 50263 Fencing Value Valuation Deductible Building 10,200 RC $5,000 Total Location TIV 10,200 49 - 71: Intersection/Alice's Rd. & University 2007 3 6 Y N N y Waukee, IA 50263 Traffic Lights Value Valuation Deductible Building 290,000 RC $5,000 Total Location TIV 290,000 NEA 0 Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 50 - 72: 100 Block of S.E. UniversityAve. 3 6 Y N N Y Waukee, IA 50263 Traffic Signals & Cabinets Value Valuation Deductible Building 32,340 RC $5,000 Total Location TIV 32,340 52 - 77: University & L.A. Grant 3 6 Y N N Y Waukee, IA 50263 Traffic Signals Value Valuation Deductible Building 220,816 RC $5,000 Total Location TIV 220,816 53 - 79: University & SE Florence 3 6 Y N N Y Waukee, IA 50263 Traffic Signals Value Valuation - Deductible Building 220,816 RC $5.000 Total Location TIV 220,816 54 - 80: University & Waukee School Entrance 3 6 Y N N Y Waukee, IA 50263 Traffic Signals Value Valuation Deductible Building 220,816 RC $5,000 Total Location TIV 220,816 55 - 83: 3107 312th PI. (West of Gun Club) 469 1 2008 2 6 Y N N Y Waukee, IA 50263 Lift Station #12 Value Valuation Deductible Building 412,488 RC $5,000 Total Location TIV 412,488 56 - 84: 106 SE Baytree Dr./Hemmingway 128 1 2008 2 6 Y N N Y Waukee, IA 50263 Lift Station #15 Value Valuation Deductible Building 99,193 RC $5.000 Total Location TIV 99,193 NEZD Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 57 - 85: 1080 SE Westwoods Dr 115 1 1999 2 6 Y N N Y Waukee, lA 50263 Lift Station #16 Value Valuation Deductible Building 72.000 RC $5,000 Total Location TIV 72,000 58 - 90: Grant Park 3 6 Y N N Y Waukee, IA 50263 Playground Equipment Value Valuation Deductible Building 59,000 RC $5,000 Total Location TIV 59,000 58 - 107: Grant Park 2014 2 3 Y N N Y Waukee, IA 50263 Restrooms Value - Valuation Deductible Building 50,000 RC $5,000 Total Location TIV 50,000 59 - 91: 805 University Ave. 69,570 2 Full 2011 4 6 Y N N Y Waukee, IA 50263 - Public Works Building Value Valuation Deductible Building 7,771,772 RC $5,000 Personal Property 600,000 RC $5,000 EDP -Hardware 164,002 RC $500 Miscellaneous Property Scheduled 1,463,812 RC $500 Total Location TIV 9,999,586 59 - 93: 805 University Ave. 2011 3 6 Y N N Y Waukee, IA 50263 Parking Lot Lights Value Valuation Deductible Building 88,326 RC $5,000 Total Location TIV 88,326 l 0 Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area # of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 59 - 95: 805 University Ave. 1,200 1 2011 3 6 Y N N Y Waukee, IA 50263 Sand/Salt Storage w/Canvas Roof Value Valuation Deductible Building 55,204 RC $5,000 Personal Property 25,000 RC $5,000 EDP - Hardware 12,000 RC $500 Miscellaneous Property Scheduled 145,000 RC $500 Total Location TIV 237,204 59 - 120: 805 University Ave. 150 2011 2 6 Y N N Y Waukee, IA 50263 Lift Station #5 Value Valuation Deductible Building 55,500 RC $5,000 Total Location TIV 55,500 60 - 94: Hickman & 6th 2011 3 6 Y N N Y Waukee, IA 50263 Traffic Signals Value Valuation Deductible Building 220,816 RC $5,000 Total Location TIV 220,816 61 - 96: South Fork Development 2011 3 6 Y N N Y Waukee, IA 50263 Street Lights Value Valuation Deductible Building 552,040 RC $5,000 Total Location TIV 552,040 62 - 97: 955 W. Hickman Rd./Raccoon River Valley Trailhead 180 1 2012 3 6 Y N N Y Waukee, IA 50263 Restrooms Value Valuation Deductible Building 102,831 RC $5,000 Total Location TIV 102,831 62 - 102: 955 W. Hickman Rd./Raccoon River Valley Trailhead 2012 1 6 Y N N Y Waukee, IA 50263 Shade Structure Value Valuation Deductible Building 20,566 RC $5,000 Total Location TIV 20,566 1 W POW Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 62 - 103: 955 W. Hickman Rd./Raccoon River Valley Trailhead 2012 3 6 Y N N Y Waukee, IA 50263 Picnic Tables/Trash Receptacles/Benches Value Valuation Deductible Building 10,824 RC $5,000 Total Location TIV 10,824 63 - 101: 1725 98th St. 3 6 Y N N Y West Des Moines, IA 50263 Water Tower Base Station/Antenna Value Valuation Deductible Building 60,400 RC $5,000 EDP -Hardware 5,880 RC $500 Total Location TIV 66,280 63 - 106: 1725 98th St. 6 6 Y N N Y West Des Moines, IA 50263 Fencing Value Valuation Deductible Building 5,100 RC $5,000 Total Location TIV 5,100 64 - 17: 675 Walnut St. 2,744 1 1965 4 6 Y N N Y Waukee, IA 50263 Community Center Value Valuation Deductible Building 480,335 RC $5,000 Personal Properly 25,000 RC $5,000 Total Location TIV 505,335 65 - 104: 990 Warrior Lane 100 1 2013 4 6 Y N N Y Waukee, IA 50263 Lift Station #7 Value Valuation Deductible Building 439,049 RC $5,000 Total Location TIV 439,049 66 - 110: SE of Sugar Creek Golf Course on Bike Trail 800 2014 3 6 Y N N y Waukee, IA 50263 Walking Bridge Value Valuation Deductible Building 204,000 RC $5,000 Total Location TIV 204,000 III' Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area # of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 67 - 122: Hickman Rd. & Dartmoor 3 6 Y N N Y Waukee, IA 50263 Traffic Lights Value Valuation Deductible Building 225,000 RC $5,000 Total Location TIV 225,000 68 - 123: Westown Pkwy. & L.A. Grant 3 6 Y N N Y Waukee, IA 50263 Traffic Lights Value Valuation Deductible Building 225,000 RC $5,000 Total Location TIV 225,000 69 - 124: L.A. Grant & Ashworth 3 6 Y N N Y Waukee, IA 50263 Traffic Light/Tent Signals Value Valuation Deductible Building 50,000 RC $5,000 Total Location TIV 50,000 70 - 125: Alice's Rd. & Olsen 3 6 Y N N Y Waukee, IA 50263 Traffic LightfTent Signals Value Valuation Deductible Building 50,000 RC $5,000 Total Location TIV 50,000 71 - 126: Westown Pkwy. & Grand Prairie 3 6 Y N N Y Waukee, IA 50263 Traffic Lights Value Valuation Deductible Building 290,000 RC $5,000 Total Location TIV 290,000 72 - 127: Ashworth & Grand Prairie 3 6 Y N N Y Waukee, IA 50263 Traffic Lights Value Valuation Deductible Building 290,000 RC $5,000 Total Location TIV 290,000 Ij Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area #of Auto Year Year Con Pro Equip FL EQ Blank Firs Spkir Built Reno Code Class Break Limit 73 - 128: Grand Prairie Rd. 3 6 Y N N Y Waukee, IA 50263 Street Lights (104 light poles; 19 tunnel fxtures) Value Valuation Deductible Building 1,007,295 RC $5,000 Total Location TIV 1,007,295 74 - 112: 1300 4th St. 2,220 1997 4 6 Y N N Y Waukee, IA 50263 Headworks/Blower Building Value Valuation Deductible Building 1,142,583 RC $5,000 Total Location TIV 1,142,583 74 - 113: 1300 4th St. 305 1995 4 6 Y N N Y Waukee, IA 50263 Inlet -Flow Diversion Value Valuation Deductible Building 66,766 RC $5,000 Total Location TIV 66,766 74 - 114: 1300 4th St. 2,375 1997 4 6 Y N N Y Waukee, IA 50263 Clarifier #142 Value Valuation Deductible Building 447,765 RC $5,000 Total Location TIV 447,765 74 - 115: 1300 4th St. 2,375 1997 4 6 Y N N Y Waukee, IA 50263 Clarifier #344 Value Valuation Deductible Building 447,765 RC $5,000 Total Location TIV 447,765 74-116: 1300 4th St. 1,752 1997 4 6 Y N N Y Waukee, IA 50263 Bio-Solids Tank #142 Value Valuation Deductible Building 354,641 RC $5,000 Total Location TIV 354,641 NCZD Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area # of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 74 - 117: 1300 4th St. 11,205 1997 4 6 Y N N Y Waukee, IA 50263 Aeration Basin #1 Value Valuation Deductible Building 356,500 RC $5,000 Total Location TIV 356,500 74 - 118: 1300 4th St. 11,205 1997 4 6 Y N N Y Waukee, IA 50263 Aeration Basin #2 Value Valuation Deductible Building 356,500 RC $5,000 Total Location TIV 356,500 74 - 119: 1300 4th St. 55 1975 2 6 Y N N Y Waukee, IA 50263 Generator Value Valuation _ Deductible Building 141,045 RC $5,000 Total Location TIV 141,045 75 - 87: 655 SE Legacy Point Blvd 1,088 1 2010 4 6 Y N N Y Waukee, IA 50263 Pavil I ion/Restroom/She Iter Value Valuation Deductible Building 250,571 RC $5,000 Total Location TIV 250,571 76 - 53: 1255 E. Hwy. 6 144 1999 2 6 Y N Y Y Waukee,lA 50263 Lift Station #6 Value Valuation Deductible Building 271,644 RC $5,000 Total Location TIV 271,644 77 - 55: 1505 6th St. 4,755 2 1993 1 6 Y N N Y Waukee, IA 50263 Golf Clubhouse Value Valuation Deductible Building 382,658 RC $5,000 Personal Property 60,000 RC $5,000 Total Location TIV 442,658 VIEZiD Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area # of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit 77 - 67: 1505 6th St. 64 2001 1 6 Y N N Y Waukee, IA 50263 Golf Course Pump House #11/Underground Irrigation Value Valuation Deductible Building 211,532 RC $5,000 Total Location TIV 211,532 98 - 98: Various Locations 1 6 N N N N Waukee, IA 50263 Unscheduled Miscellaneous Property Value Valuation Deductible Miscellaneous Property Unscheduled 125,000 RC $500 Total Location TIV 125,000 300 - 300: Various Locations (as noted on file) 1 6 Y N N Y Waukee, IA 50263 Fiber Optic Network Value Valuation Deductible Building 515,747 RC $5,000 Total Location TIV 515,747 WE Iowa Communities Assurance Pool Statement of Values City of Waukee Effective Date: 04/01/2016 Printed on: 03/04/2016 Location Description Area # of Auto Year Year Con Pro Equip FL EQ Blank Firs Spklr Built Reno Code Class Break Limit Total Blanket TIV $43,383,924 Building $40,487,514 Personal Property $3,005.450 EDP - Hardware $684,562 EDP - Software $104,329 Fine Arts $33,000 Miscellaneous Property Scheduled $2,585,897 Miscellaneous Property Unscheduled $125,000 Total TIV $47,025,752 As of: 04/01/2016 Iowa Communities Assurance Pool General Liability Breakout City of Waukee Anniversary: 04/0112016 Total Contribution % of Total Initial Loading $16,854.17 43.34% Fire Dept. $1,417.23 3.64% Sewer Dept. $2,766.83 7.11 % Waterworks Dept. $2,106.13 5.42% DPW $1,743.27 4,48% Parks and Recreation $2,321.43 5.97% Gas Utility • Distribution $5,701.51 14.66% Secondary Loading Ambulances $267.12 0,69% EMT (No. of technicians, not $267.12 0.69% including paid EMT's) Fireworks displays $66.78 0.17% Golf Course $3,360.37 8.64% Volunteer Firefighters - Basic $307.19 0,79% Herbicide/Pesticide $709.20 1.82% GL Coverage Extension $1,000.00 2.57% GL Excess $9,962.38 Total $48,850.73 V/ Public Officials Wrongful Acts $7,538,56 ` Excess $1,930.88 Total $9,469.44 Law Enforcement $6,110.47 Excess $1,565.35 Total $7,675.82 Iowa Communities Assurance Pool Auto Liability Breakout City of Waukee Anniversary; 04/0112016 Tota I Vehicle Type Contribution # of Vehicles Ambulances $475.58 2 $237.79 Dump Trucks $3,095.98 12 $258.00 Fire Trucks $1,473.15 9 $163,68 Heavy $244.52 1 $244.52 Lt. Med Trucks $1,263.50 8 $157.94 Passenger CarNans/Pickups $4,672.18 38 $122.95 Police $2,216.77 10 $221.68 Road Maintenance $71,37 2 $35.69 Trailers $0.00 17 $0.00 Excess $3,464.06 Total $16,977.11 Iowa Communities Assurance Pool Property Breakout City of Waukee Anniversary: 04/01 /2016 REVISED Location Address Total TIV Contribution 1-1: Centennial Park on University Centennial Park on University $48,486.94 $139.08 Waukee, IA 50263 1-2: Centennial Park on University Centennial Park on University $50,905.43 $74.75 Waukee, IA 50263 1-3: Centennial Park on University Centennial Park on University $50,905.43 $74.75 Waukee, IA 50263 1-36: Centennial Park on Centennial Park on University $97,520.77 $120.44 University Waukee, IA 50263 1-4: Centennial Park on University Centennial Park on University $93,110.63 $267.08 Waukee, IA 50263 1-42: Centennial Park on Centennial Park on University $42,448.32 $52.43 University Waukee, IA 50263 1-49: Centennial Park on Centennial Park on University $31,083.84 $38.39 University Waukee, IA 50263 1-92: Centennial Park on Centennial Park on University $212,241.60 $608.79 University Waukee, IA 50263 2-6: 1205 6th 1205 6th $106,040.00 $304.16 Waukee, IA 50263 2-8: 1205 6th 1205 6th $24,142.10 $69.25 Waukee, IA 50263 3-9: South of Waukee South of Waukee $23,081.62 $28.51 Waukee, IA 50263 4-10: 1215 6th St. 1215 6th St. $109,040.00 $312.77 Waukee, IA 50263 5-13: Water Treatment Water Treatment Facility/1300 4th St. $192,391.00 $237.62 Facility/1300 4th St. Waukee, IA 50263 6-15: 410 6th 410 6th $335,563.00 $414.44 Waukee, IA 50263 12-23: Winfield Park Winfield Park $176,000.00 $504.84 Waukee, IA 50263 12-44: Winfield Park Winfield Park $92,000.00 $113.63 Waukee, IA 50263 13-24: 397 Hwy, 6 397 Hwy. 6 $351,758.00 $434.44 Waukee, IA 50263 13-45: 397 Hwy. 6 397 Hwy. 6 $110,948.36 $318.24 Waukee, IA 50263 14-25: 1300 L.A. Grant Parkway 1300 L.A. Grant Parkway $7,268,598.92 $11,064.89 Waukee, IA 50263 15-26: 50 Little Walnut Creek 50 Little Walnut Creek Drive $42,448.32 $52.43 Drive Waukee, IA 50263 16-27: 501 4th St. 501 4th St. $42,448.32 $52.43 Waukee, IA 50263 17-28: 1155 Westbrooke 1155 Westbrooke $42,448.32 $52.43 Waukee, IA 50263 18-29: 701 Boone Drive 701 Boone Drive $42,448.32 $52.43 Waukee, IA 50263 19-30: 600 142nd St. 600 142nd St. $382,618.54 $472.56 Waukee, IA 50263 19-73: 600 142nd St. 600 142nd St. $175,748.78 $217.06 Waukee, IA 50263 20-105: 230 Hickman 230 Hickman $15,606.00 $19.27 Waukee, IA 50263 20-31: 230 Hickman 230 Hickman $3,101,508.01 $9,301.55 Waukee, IA 50263 22-109: Hwy R22 Hwy R22 $10,200.00 $12.60 Waukee, IA 50263 22-32: Hwy R22 Hwy R22 $1,557,914.86 $2,287.64 Waukee, IA 50263 24-34: 950 Warrior Lane 950 Warrior Lane $4,590,925.00 $13,246.02 Waukee, IA 50263 24-81: 950 Warrior Lane 950 Warrior Lane $48,000.00 $70.48 Waukee, IA 50263 25-35: 3256 Ashworth Rd. 3256 Ashworth Rd. $42,448.32 $52.43 Waukee, IA 50263 27-37: 31653 Ute 31653 Ute $190,235.33 $279.34 Waukee, IA 50263 27-86: 31653 Ute 31653 Ute $42,448.32 $52.43 Waukee, IA 50263 29-40: 225 University Ave. 225 University Ave. $42,448.32 $52.43 Waukee, IA 50263 30-41: 550 Ashworth Drive, 550 Ashworth Drive, Triangle Park $11,190.44 $32.10 Triangle Park Waukee, IA 50263 30-43: 550 Ashworth Drive, 550 Ashworth Drive, Triangle Park $228,283.88 $228.68 Triangle Park Waukee, IA 50263 30-57: 550 Ashworth Drive, 550 Ashworth Drive, Triangle Park $22.081.62 $32.42 Triangle Park Waukee, IA 50263 31-88: Ridge Pointe Park Ridge Pointe Park $55,204.04 $68.18 Waukee, IA 50263 31-89: Ridge Pointe Park Ridge Pointe Park $11.040.81 $13.64 Waukee, IA 50263 32-47: Southfork Park Southfork Park $24,866.23 $30.71 Waukee, IA 50263 32-48: Southfork Park Southfork Park $31,083.84 $45.64 Waukee, IA 50263 34-50: 1300 3rd Street 1300 3rd Street $449,767.00 $660.44 Waukee, IA 50263 35-51: 1080 Westwoods 1080 Westwoods $304,748.16 $447.49 Waukee, IA 50263 37-78: Hickman and Alices Rd. Hickman and Alices Rd. $218,905.99 $270,36 Waukee, IA 50263 39-121: 1501 6th St. 1501 6th St. $13,500.00 $19.82 Waukee, IA 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. $97,275.87 $120.14 Waukee, IA 50263 39-76: 1501 6th St. 1501 6th St. $27,602.02 $34.09 Waukee, IA 50263 41-59: Hickman & N. 10th Hickman & N. 10th $223,806.64 $276.42 Waukee, IA 50263 42-60: Hickman & 4th St. Hickman & 4th St. $223,806.64 $276.42 Waukee, IA 50263 43-61: Hickman & Warder Lane Hickman & Warrier Lane $223,806.64 $276.42 Waukee, IA 50263 44-65: Boone Drive & University Boone Drive & University $223,806.64 $276.42 Waukee, IA 50263 45-74: 90 N. 10th St. 90 N. 10th St. $175,748.78 $217.06 Waukee, IA 50263 46-68: Hickman - Alices Road to Hickman - Alices Road to R22 $609,497.39 $752.77 R22 Waukee, IA 50263 48-100: 1255 3rd Street 1255 3rd Street $81,044.30 $110.50 Waukee. IA 50263 48-108: 1255 3rd Street 1255 3rd Street $10,200.00 $10.22 Waukee, IA 50263 48-70:1255 3rd Street 1255 3rd Street $1,837,300.00 $2,269.18 Waukee, IA 50263 49-71: Intersection/Alice's Rd. & Intersection/Alice's Rd. & University $290,000,00 $358.17 University Waukee, IA 50263 50-72: 100 Block of S.E. University 100 Block of S.E. University Ave. $32,340.31 $39.94 Ave. Waukee, IA 50263 52-77: University & L.A. Grant University & L.A. Grant $220,816.16 $272.72 Waukee, IA 50263 53-79: University & SE Florence University & SE Florence $220.816.16 . $272.72 Waukee, IA 50263 54-80: University & Waukee University & Waukee School Entrance $220,816.16 $272.72 School Entrance Waukee, IA 50263 55-83: 3107 312th PI. (West of 3107 312th PI. (West of Gun Club) $412,488,00 $605.70 Gun Club) Waukee, IA 50263 56-84: 106 SE Baytree 106 SE Baytree Dr./Hemmingway $99,193.00 $145.65 Dr./Hemmingway Waukee, IA 50263 57-85: 1080 SE WestwoodsDr 1080 SE Westwoods Dr $72,000.00 $105.72 Waukee, IA 50263 58-107: Grant Park Grant Park $50,000.00 $59.42 Waukee, IA 50263 58-90: Grant Park Grant Park $59,000.00 $72.87 Waukee, IA 50263 59-120: 805 University Ave. 805 University Ave. $55,500.00 $81.50 Waukee, IA 50263 59-91: 805 University Ave. 805 University Ave. $9,999,585.72 $18,163.43 Waukee, [A 50263 59-93: 805 University Ave. 805 University Ave. $88,326.46 $109.09 Waukee, IA 50263 59-95: 805 University Ave. 805 University Ave. $237,204.04 $861.29 Waukee, IA 50263 60-94: Hickman & 6th Hickman & 6th $220,816.16 $272.72 Waukee, IA 50263 61-96: South Fork Development South Fork Development $552,040.40 $681.81 Waukee, IA 50263 62-102: 955 W. Hickman 955 W. Hickman Rd./Raccoon River Valley $20,566.21 $58.99 Rd./Raccoon River Valley Trailhead Trailhead Waukee, IA 50263 62-103: 955 W. Hickman 955 W. Hickman Rd./Raccoon River Valley $10,824.32 $13.37 Rd./Raccoon River Valley Trailhead Trailhead Waukee, IA 50263 62-97: 955 W. Hickman 955 W. Hickman Rd./Raccoon River Valley $102,831.06 $127.00 Rd./Raccoon River Valley Trailhead Trailhead Waukee, IA 50263 63-101: 1725 98th St. 1725 98th St. $66,279.71 $92.27 West Des Moines, IA 50263 63-106: 1725 98th St. 1725 98th St. $5,100.00 $5.11 West Des Moines, IA 50263 64-17: 675 Walnut St. 675 Walnut St. $505,334.58 $624.12 Waukee, IA 50263 65-104: 990 Warrior Lane 990 Warrior Lane $439,048.80 $542.25 Waukee, IA 50263 66-110: SE of Sugar Creek Golf SE of Sugar Creek Golf Course on Bike Trail $204,000.00 $251.95 Course on Bike Trail Waukee, IA 50263 67-122: Hickman Rd. & Dartmoor Hickman Rd. & Dartmoor $225,000.00 $277.89 Waukee, IA 50263 68-123: Westown Pkwy & L.A. Westown Pkwy. & L.A. Grant $225.000.00 $277.89 Grant Waukee, IA 50263 69-124: L.A. Grant & Ashworth L.A. Grant & Ashworth $50,000.00 $61.75 Waukee, IA 50263 70-125: Alice's Rd. & Olsen Alice's Rd. & Olsen Waukee, IA 50263 71-126: Westown Pkwy. & Grand Westown Pkwy. & Grand Prairie Prairie Waukee, IA 50263 72-127: Ashworth & Grand Prairie Ashworth & Grand Prairie Waukee, IA 50263 73-128: Grand Prairie Rd. Grand Prairie Rd. Waukee, IA 50263 74-112, 1300 4th St. 1300 4th St. Waukee, IA 50263 74-113: 1300 4th St. 1300 4th St. Waukee, IA 50263 74-114: 1300 4th St. 1300 4th St. Waukee, IA 50263 74-115: 1300 4th St, 1300 4th St. Waukee, IA 50263 74-116: 1300 4th St. 1300 4th St. Waukee, IA 50263 74-117: 1300 4th St. 1300 4th St. Waukee, IA 50263 74-118: 1300 4th St. 1300 4th St. Waukee, IA 50263 74-119: 1300 4th St. 1300 4th St. Waukee, IA 50263 75-87: 655 SE Legacy Point Blvd. 655 SE Legacy Point Blvd Waukee, IA 50263 76-53: 1255 E. Hwy. 6 1255 E. Hwy, 6 Waukee, IA 50263 77-55: 1505 6th St. 1505 6th St. Waukee, IA 50263 77-67: 1505 6th St. 1505 6th St. Waukee, IA 50263 98-98: Various Locations Various Locations Waukee, IA 50263 99-99: Liability Only Liability Only Waukee, IA 50263 300-300: Various Locations (as Various Locations (as noted on file) noted on file) Waukee, IA 50263 Earthquake Property Coverage Extension TOTALS $50,000.00 $61.75 $290,000.00 $358.17 $290,000.00 $358.17 $1,007,295.00 $1,244.07 $1,142,583.00 $1,411.16 $66,766.00 $82.46 $447,765.00 $553.02 $447,765.00 $553.02 $354,641.00 $438.00 $356,500.00 $440.30 $356,500.00 $440.30 $141,045.00 $207.11 $250,571.37 $309.47 $271.644.00 $398.88 $442,658.00 $1,269.72 $211,531.65 $606.76 $125,000.00 $626.02 $0.00 $0.00 $515,747.09 $1,479.37 $271.64 $250.00 / $47,025.752.02 ✓ $87,404.57 ICAP April 2016 Billing Description Total Premium Billed Total Credit % Liability Credit % Excess % General Liability $38,888.35 41% 47% 59% Wrongful Acts Liability $7,538.56 9% 11% Law Enforcement Liability $6,110.47 7% 9% Business Auto Liability $13,513.05 16% 20% Excess Liability (+$6M) new 2014 $16,922.67 20% $82,973.10 Property Premium $87,404.57 44% Auto Physical Damage $30,471.46 15% Boiler & Machinery $0.00 0% $200,849.13 Credits $'s: Liability (See Breakdown below) Property Auto Boiler Liability Breakdown: General Wrongful Acts Law Enforcement Business Auto Excess Liability (See Breakdown below) Excess Liability Breakdown General Public Officials Law Enforcement Vehicles ($14,861.09) 41% ($6,139.29) 44% ($6,467.18) 15% ($2,254.62) 0% $0.00 ($14,861.09) 47% ($2,877.40) 9% ($557.79) 7% ($452.12) 16% ($999.85) 20% ($1,252.13) ($6,139.29) +$6M Invoiced Credit Total Excess Liab 59% $9,963.52 $ (737.21) $9,226.31 11% $1,931.44 $ (142.91) $1,788.53 9% $1,565.55 $ (115.84) $1,449.72 20% $3,462.16 $ (256.17) $3,205.99 100% $16,922.67 $ (1,252.13) $15,670.54 CAP General Liability Breakdown April 2016 General Liability Premium Due: $38,888.35 General Liability - Excess Premium $9,963.52 Less Credit: General Prem ($2,877.40) Less Credit: Excess Prem ($737.21) Total Due: $45,237.26 Excess Prem & Total Departments: Premium $'s Credit % Credit $'s Prem Cr $'s Premium $'s Acct #'s Administration/General Operations $16,854.17 43.34% (1,247.06) $3,998.67 $19,605.76 see below Fire $1,417.23 3.64% (104.86) $336.24 $1,648.61 010.10.1400.290000 Sewer $2,766.83 7.11% (204.72) $656.43 $3,218.54 520.30.6520.290000 Water $2,106.13 5.42% (155.84) $499.68 $2,449.98 510.30.6510.290000 Public Works $1,743.27 4.48% (128.99) $413.59 $2,027.88 010.20.6000.290000 Parks $1,160.72 2.98% (85.88) $275.38 $1,350.22 010.40.4100.290000 Rec $1,160.71 2.98% (85.88) $275.38. $1,350.21 010,40.4200.290000 Ambulance/Rescue $267.12 0.69% (19.76) $63.37 $310.73 010.10.1500.290000 EMT/Rescue $267.12 0.69% (19.76) $63.37 $310.73 010,10.1500.290000 Fireworks Display/Parks $66.78 0.17% (4.94) $15.84 $77.68 010.40.4100.290000 Fire Fighters $307.19 0.79% (22.73) $72.88 $357.34 010.10.1400.290000 Golf Course $3,360.37 9.64% (248.64) $797.25 $3,908.98 750.80.8750.290000 Spraying/Road Use $709.20 1.82% (52.47) $168.26 $824.98 060.30.7100.290000 Employee Benefits/Administration $1,000.00 2.57% (73.99) $237.25 $1,163.26 010.60.8300.290000 Elec Utilities/Gas $5,701.51 14.66% (421.86) $1,352.69 $6,632.35 540.30.6540.290000 $38,888.35 100.00% -$2,877.40 $9,226.31 $45,237.26 Initial Load ?INI Admin/General Operations Breakdown: (divided based on budgeted $ to all departments & tried to make some what even) Police $1,225.36 $1,225.36 010,10,1100.290000 Fire $612.68 $612.68 010.10.1400.290000 EMS $612.68 $612.68 010.10.1500.290000 Code Compliance $612.68 $612.68 010.10.1900.290000 Library $1,225.36 $1,225.36 010.40.3100.290000 Parks $612.68 $612.68 010.40.4100.290000 Recreation $612.68 $612.68 010.40.4200.290000 Public Works $1,225.36 $1,225.36 010.20.6000.290000 Administration $612.68 $612.68 010.60.8300.290000 Communications $612.68 $612.68 010.60.8200.290000 HR $612.68 $612.68 010.60.8350.290000 Finance $612.68 $612.68 010.60.8400.290000 Comm/Econ Development $612.68 $612.68 010.50.8500.290000 Development Services $612.68 $612.68 010.50.8700.290000 Engineer $612.68 $612.68 010.20.8900.290000 GIS $612.68 $612.68 010.20.8950.290000 Community Center $612.68 $612.68 010.40.4300.290000 Roads $1,225.36 $1,225.36 060.30.7100.290000 Water $1,225.36 $1,225.36 510.30.6510.290000 Sewer $1,225.36 $1,225.36 520.30.6520.290000 Gas $1,225.36 $1,225.36 540.30.6540.290000 Storm Water $1,225.36 $1,225.36 560.80.5300.290000 Golf Course $1,225.36 $1,225.36 750.80.8750.290000 $19,605.76 $19,605.76 Figured: 16 depts with Fire, EMS, Code, Parks, Rec, Admin, Communications, HR, Finance, Comm/Econ Develop, Devel Serv, Engineer, GIS & Comm Center calculated as being 1/2 depts Secondary Load _ '�.y k Prior yr % Current Yr Split Ambulance/Rescue 0.00% $267.12 EMT/Rescue 0.00% $267.12 Fireworks Display/Parks 0.00% $66.78 Fire Fighters 0.00% $307.19 Golf Course 0.00% $3,360.37 Employee Benefits/Administration 0.00% $0.00 0.009, $4,268.58 v u Y Y Y Y Y Y F R d d d 1 d S vl M W N n Q M N n n N 'i m fl rl N M M M N Q b n N M W Vf h �A h N M N N O] Q m 01 O1 lO N 'i n N y a M n C Q n n O Q Q M n n fl N Q N n b a. CO l0 Q Q N Q Q n O N o'J c0 vl Q Ol M W N n Q Q m CO Q M n n b N N M O n O b n N 'i m rl O rl e4 M fl N aa�aa°aae 0 O O O e 0 o a ae�0 1w N N tO l0 n b O l0 V O n M N o'J .i .i c0 N n Ol c0 O Q vt O O O O O b m O O m c6 oovvi o �ovm.-i oi0 0 0 0 viv16m 0 0 o W .. o 0 0 0 o b m o n ry e1 'i '1 ei ei ei ey oN m a a c a m ry ON 16 lQp VI Vl Vf N W O O b M M a O1 N M O Ol Ot T M M M M t0 b N N n N O N W Ol Q Q W a Q Q Q N O b vl N O] b O Q n M M V N (V fV fV N n N pl O N N b O N N N tO N N N N n .4 w O Q tvl M 'I Oi Ol N rcl o 0 Coco oNNo oOo O� 0000 Naw O NQO 0O 0 NNo 0 0 0 n o 0 0 0 0 a o of o 0 0 0 Q NN O -1 O O O O ei ei M ei b m O ei m O M O ei O ei N VI �e1 W Q N oa.+ W Qo M O N aQ N W N W O Q m M b 000 O 000 O O] O] NQo lO m m N W W W QQaQ m m .iQb W W lD oo.-� Q N O N .-io N m m '1 N Q O N n O rl 'i O O M Vf O O O m m � N Q Q Q Q b n M N b N m N m O O M n N rl N tD t0 V O M m N Vf b N W N O N W N N N N N vl W "I vl r r O O N N m m Q M fl N O N M N O m M n m b N rl l0 b V Q Q C W n N O N fl N N m N V� H 1n V� 1A N 1O 'i V1 'i aA 'i ei M rl V! N M rl ti�h Q N N� i/� VY V1 N M r1 N rl H rl vl {A N N C L C E U U ba0 Oa0 Oa0 « °1 TO"O 6 9 N m 3 O- OO C a a f0 R C U U O U E E 3 a' N Cal L " C 3 w o m �^ Y 0 O a L a oa0 2 a O m d O n a n bo U a u°a;-nm3 m L S L L L L M C = y m o~~ Y Y o N d O O L a C y N L L L L L i a a y a Q Q Q > > > > > > »j»juu Ni o zi n n .N-� �° .Ni 3 a mm 01 N 0 N a N Q N N l6 N N Q 'I N ei T u � a E � a C m 2 O n x E LL y m fo in « a E5 n` Cm tn in n a' r� u u 3 m Y U Y v y 0 H 0 0 o m m 3 3 0 0 N N ei n b b N N 2 2 m m N OM M N N N n M M N W Vl t0 W m m O ti 'i .i N N ry N N N v w 3 v Y Y Y in v01i i'n in a a a M n M O Q n Q N N rl N M M m m M rn N aA N V1 N �O N Ol N m N N CI N M N M N M a aa°0 0 O b Q n N o O o O w w Q N N Q Q m O DJ °9 S S W v v v v v �v V1 N VI N V1 N IA � n n L L O O'a w W N W0 0 0 0N W W 0 0 0 0 0 E a a a a v� vi E N vl 01 b N N N N b n O n Q w m Q m q Q Q Q Q o n m .+ m b N Vl N N N N N n m m M N N H N N V? N Vl N N N VY vY N N N M b M b M Q Q M Q rn O W O Q Q Q Q O n 'i M N O1 . w m + o b m O n � O n 6 m O of Q b b b b n N m m 0 O m .6 m b Q N lD Q e1 Vf N N N N N n N ei M m M M N N N V1 VY V1 N V1 N N 'N. Vl VY N 1R N V1 VY i/1 N N 41 VY V1 1A N V} V} N N (/� a a° 89 a a a el a a 9 Z9 e e e ZR a e a e e a a° a a� o e o m w o � v O 0 0 0 o . Ml . o 0 0 0 0 0 0 ry 1 v 0 0 0 o m w o < vi c a o 0 o ni .: ni f4 o 0 0 0 0 0 o vi v o 0 06 w. o Q M o 0 0 0 w .+ 0 0 O 0 0 0 0 m 0 0 0 N m rwl� w m N ' N N mf O 6 M w M VY m N N 1l�ol6 V wNNm � V} N N C y 4 c C N N W N Y v E E E Ri m m '- m o m L 'o 'a « c c v 3 c S c a a c c c c '� vi o m_ a v o o o ¢ v m o o 0 0 0 vLi a t m 17 Y F Y m w o U 7, W O � N (0 R 6 ;K .t.' .�' b p �• i N i N N N C v R 7 L N c W J O06 O `o N > � .c ♦' > 3 L L L Y Y i O N W N W N W o O Q Y t i L' d 6 vl U U i d Z Q W vl vl vl C 3 d a 6 O O O 3 Q Q N VI t%f vl ei$ ta' N t tOi "O "O "O o Y Y V Y O M �' �' O Z v1 b b N 0 0 0 VI Vf V1 3 3 O O I w O �+ 3 0 0 0 0 rn vl U O O 3 vi M V1 N N N H O o '1 rl O _ _ _ w m 2 .i I H � e1 V1 n l0 O 'i M n n w m n w O rl M w 1f1 b l0 m O ti V Q w O O w N m M w Q Q Q b w w w M n M M n ti L� b b b n b n o'. 9 n n Vt 1� n m o o o '1 rl 'I N N Q Vf n n m m m 'i N M Q Vl b w m O N N N N M m m M m m m M m M M M M M M m Q Q Q Q Q Q Q 4 a Q V1 m m U U y O O O �m 33B N N N O ke N N n n n n r N N N N Vl of of N N N N O 1!1 N n N N n N N b N ao v n N r O ti O N of N N N l0 '1 VT Vl Vi V? V! VY V1 N 1/� a a e a 0 e a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 e1 'i e4 e1 'i e1 e1 e1 rl N a L L C L L L L L t L m UO N o0 h0 M OO 00 e0 pp U J J J y Y Y Y E Y N N 3 N 10 N N 10 F N d d d U m O1 f Vf n r r m n w m m .�+ rf ry m Of w oo n N .i .+ o V1 N 'i 01 I� V N rl r n 'i ei W OJ V N N n N M b Ot rl Ot N b V Vf Vf N n N n N b b VI M Vl C M N m eti 'i Vl t/� N Vl V? Vl Vi Vi N VL Vi �A N V! Vl M Ol O1 O o] N O T n b n .i N Vf m O1 Vf r n r C O N Vf pt n w M O N M m N m m f1 N m O4 M W r I n �d rd O m O1 rl b N 'i n W M m I. N V1 n R N 'i n n rl m V b O b c0 r'I e'I CO m m n N o] b N N ti rl Ol O1 O1 N lO d 4!1 m N N N N N b w b I M M m O M N W N rl a s m� m m m W N i o O O O O O .. N b b M O 0 O 0 o O O O O O O O O O O O O o O O O o O o O O O b O N O O O O b N Od O O O O O O O O O O m O O O $ O O m a O o O o o O o m M O O O O O O O O N of v N vi o 0 0 o n 0 V1 a ON VY aA N N Vf V} N �y` N E i L C � O Yn o m v a a en o a r H �• R — u d m N N S v m a N m m m N 10 '^ 112 O o_D o0 m L O O r O m o0 a0 00 00 00 00 Lpp !- F F ` .Y v) V I v1 vl ✓f i/1 J E m Y N N o v d d d J H VI J v � a - tl0 o6 a c¢ m v a a a c E Q 3 C o L w T E E Y N yt VI Y O d a O d qj Y 3 O W Uf oL d LL o o 0 ry , v p� Vf Vf Vt V1 O 000 y o N Vl Vl in vi in N N r N Vl r O m OD o y J- y L N w m m 0 0 0 0 0 0 0 0 o g o o$ uoi » 0 00 M m m m m m m m m m m m M m m m m 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 m m m m m m of m m m m m m m m m m Y� O o O O O O O g O O O O O p O O O 8.i OO N.-i p 0 OOOO.i w.i rl O O Vl �l1 Vf fi M �y �y y N ,y Vl Vl n M C Q p V) lD b b b n p M M ei e-I M ei ei W M m 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 y� p N N M m M M p p 'i ti 'i fl m M W t0 U O O O O O O O O O O O O O O O O O d d d d d d d d N '�� H y rl rl ei N rl p b �y rl '1 rl M rl b b Vl N 3 3 3 3 3 3 3 3 a 3 0 0 � m > 00 o in in v+o0oo0000o n o vdi vdi t7 vd1 vdi VI vdi Vd1 vdi U' U' 1- > 4O l0 N N O O O rl n W N b N n N n p p p N Vl O n N m b b lD O b N b Of rl p O O O M m rl p W n n O In b Vf E O O Vf b M . Ol n T W rl rl V V M O e4 m e-I N M M M O O n Ot m Ol b b Ol p O m o O N l0 O N rl 0M OOM N NMN rpeil W Vvlf VvlI mp Vp ON OM 0m1 OlO bNe-1 Nb nprl N O bONNm rvbM N N t0 Vy w i p Ot 01 M N O 0 M t0 m ll rl N p N N M p VI W O n m dV! NVFN V! rI VFN V} �V�V�to O] V) VV N N O Vf V1 Vt N N K N ut V? V) V1 N h V) V1 V} F' l0 p N o N O O O O m O m n p m M n n O m b a M tf1 VI M V V O O Ol b O N n N d. V ifl VI V p C N M M N l0 t0 V M O LL rj rj rj m `O L r V1 N 1A ✓1 N 4} VF V} N V} V}V! 1/F VL VY 0 0 0 0 o o O O o O O o O 0 o o V1 N 01 O m m m n O 0 o 0 c o 0 0 0 0 0 0 1 v �.i vi S 0 O O O O O O O O M O m o m O a n n 'n'� .mio ooa m voi�O�mmoMvmiv w .j yj yj yp M O N r1 O N p l0 O N m M N O p vl M M m w l0 b O m N rl N VF h VF O N M b V V? rl h 01 M N N N N M p b OVl NNN'�'N Sul V1M V1�MNVL VI n m � N N it tt C C � d m 3 ° v `d a `o_ 0 0 o a E a Cl 3 d s 7 oou tUu D S m x � m N V1 V1 V1 V1 N VI VI C 3 N IA O U L L L L L L L L O 2 00 0 0 0 O o 0 a a 0 0 0 0 0 0 o O o 0 0 0 .o m 00 o M M M M M M M M N Vt Vf N 10 rl rl ei ei e-I M rl rl 4' rl rt rl i % 2 n n n n n n n n ^ n n n m o � m aa°aaa°aaa°aa°a'aeae bo N �mm r+mb n � .i .i oo enQu no m Nmm n bb p Ov+Nu moo obO •+�+ut utmmO pmb� N rl rl 0 C O 0 n rn n m •• o a vtOi o a a a a b N M(v1 b M n W l0 n M M Ol 4l1 N l6 ^ 00 n ivl C p p M p �h vt v) .i p n b '^ y� N N Ol Vl W Vl O N n N ei p N M p R d U th rl ✓1 V) N N rl N a/� V) N N N V C d V V O E u° a>, m E E d C � 6 o E 3 d m a` 0 0 f f 00 d a = — m d O Y Y ? 6 N H Q 0 E t C 33 E O _ m = U_ v' U Y a a 3 m m E d d d F gym° ��LL�r`s �„ �❑ ICAP April 2016 Law Enforcement & Public Officials Liability Excess Total Description Premium Credit$'s Premium Premium Acct# Law Enforcement Liability $6,110.47 ($452.12) $1,449.72 $7,108.06 010.10.1100.290400 Public Officials Liability $7,538.56 ($557.79) $1,788.53 $8,769.30 010.60.8100.290000 O m T a 0 0 m N 0 m 0 N O O O O O� O N O P N O O m N O M O O O V1 VN a ON O V1 O O — N o n P m W mM O E H � H N E a a p vPi .ma n O O� W vi y A E N N Q � a a coi o n m p m N N d N mE O w N H N w 'E a' v — e m m o o o 0 a O' n a m m ce N fmE E a E E vMPi 'E .ini H 0 0 v a' n` p n N m m ^ P n n m OI n uN1 U - - �n ro ry m U O 1 O O M N M O P N n N P N M Vl T M N l0 n O O P VI n a Ol Ol N O Ol N N n� m Ol fl O N n lO N N N fl N V1 m Ol E Ot C N O O n M .4 n P W m rl W [O M W M N n n P n P P n 'I 'i ei 'I M P N N 'i m 'I n n M n m ti m ti W n ti n P P n m N ti ti C m N fi P m N V� P ti ti ey ti i0 e+ O fl P N t0 ti ti n a VAN V)NNNNNNVl �R V1 VIN V�NNNNNNNNV�NNNN O O O O O O O O O O O O O O O O O O O O O O O O O O O O O o 0 0 ................. voi S o 0 o voi o 0 NNVL O O O O O O 0 0 Lq o o Lq NNV�NNV�N O O O O O O O O m o m m o 0 0 o N.A VAN VY O O O O O O O n o o S o n o O n —'vo Nri viN ioowaoNmvi �o vi vi ai �ri��rio i.io vioo6 c6� '�o ooco .. 'o > vr�NNNanNNNN o a mP P tim o 0 o�n rI V� NN V�.iNNryNNNN N mm O t/�t/�N .i rvmry a n NNVYNNNfINm o+ rv.nm .n �o N NN .Pi N NON N N N N N N � N N o+ m n m O N� N P O� tnvl 0 m n m V � O n 0� O O N On m n m O M O N VI N � N p h O 2� Q N N M VPI uM1 N 00 M C N� u m t0 n "� 0 O NP ti nm'1 Z > W�-I any W w 3 N M m O O n S a ti U yaj N O O Oti � u J yaj � m� W W N 1mNi yaj w � N W P W M O ^' �, N P rvmrc m n+s a x Nam o �0n P �n .T. a s a cac ggxc� T t� oY o m� h< M Now mN a ry O n Zmu��o�N��Um 3 ^� LL LL xz m a w a x z LL m Y n rmi LL 22 6 m u n o LL 3 r 3 F r 3 m i' F o r 3 m Q n 3 x w x> x z 3 v� m ry H i o 22 n e .z-i u m.wi m.x.0 m"n. m .". .Oi".O. � �"� Q.�i r .". .m. `..° LL ar. m n v o x o m c ? E E m E o c E P o M o U t= m m o' o' o o P 3 0 3 a 3 3 F a n g n r n .o ; _ a a> n.A- „{ r e z v m m T `v ry ry m m n m m ry m m m o a `w a ^' m co co c n w N a 6. U x> '° V' m > o F m o N o o v o o z t c o N o o � g y w V o o= o V o o > o u o a A « .. ,., E E E E c c E �^ E T E w „` ,n r d W voi � LL m E T r c A c x v a `E `v o w w `w `w v L v o v_° v L `w a m v u a y a a v v L o .c a M u° LL o c LL E LL LL a c LL voi E x K U u N S LL LL _ u u u u w c LL v LL v CO N M P m V1 CO lO n O O .-I N N M N M M M P N N M N N m 00000000moo. . vl Vl P v1 oo.+ tD tO O n N M tO m oo.�o.+.+o.-. M VI N P vi m 0000..o m o 0 0 0 0 ........... 00.000000000 'a N N N N N N N N H N N N N N N N N N N N N N N N ry ry ry N 0 0 0 0 ry N ry ry 0 0 0 0 0 0 0 0 N N N ry N N N N 0 00 0 0 0 N N N N N N a v"i om om rvn n'I Lq m m m m N N VAN VINNV�NNN 0 0 0 0 0 0 0 o m o o vl vl vlo o.o omo eN1 M N N N ti al N N N 0 0 0 0 00 0 0 0 m m m m m m m m m N N N N N O O O O O m O O O O O O O O O O O w0 0 0 0 0 0 o 0 0 a Q 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o viOi o 0 n n N O N m W � a N m w 'I 1p m M V.NiI Vro'iINN-m 00010 0oei 0a 0 vN100goo0Q oSa eoQ oVI 0oVl 0.a offl NV4NN VIN NNNNVINNNa mON m,o u, mm m ry m wo m m m o m m w � LL mz LL J> S� n J n N Na Na u r a a m w 0 � n m m a m N N m n m n m n n � ry od N N m m v"i W N N N N � W m m m O O m a as a a rvmm.+n mom 6 �o vi ni ni iris oi000�+i ni0 of rri e nin m a a m m a o vl a w .+a rm.ym a.y o ry o a n a ni vi . o VY VL VL 1/�NNV)NN VIN V�V�N NNN N 0 0 0 0 0 0 0 o m o o m o o m o rn o m m 0 0 0 0 0 0 o o m o o a o o Q o a m m n o Q VINNNVIN VINNN O] N b N M NNVrNN VI � N VIN VNl V� M N N O T m O Ol N M N p Ol o w, Vl O O Vml m b V r n ry m m n O Vmi VQj tmn n m o o m o d o o m m m nin °v'n'moo.po mil ma ao m 'n0 O N Q J u Y y Y Y y M Q Y F W c FGro��w uu'uu' � �w LL 'c v 4 F W L n �11' y n o f 3 0 N o o m a Emm _ .i w nw nLLrm c n c _mN✓t w''� a.mi °' =LL x W N w m w va �o+aaa v y a E > n y E vL nLL u LLvni�PLLuu - ur uu LL LL m o o m m m m l0 o m m o 0 0 o 0 0 0 0 0 0 .+ INININIIII .... N N N N o. IN 0 N 3 0 0 0 m 0 0 m w N .-iod m `oi mmmv.1Oi 0 0 0 0 0 0 o0 m 0 n 0 m 0 0 0 0 0 0 Lnvmoon 0 0 0 N ry m m m n N NNN'I ry N N M b � O W Q N Nm m N M 01 O Ot m N N m � ti N N N N N M 8 ry m y`ij ry m m m N N N ti e a m m m ry H X Irvi Jrv( u 4°LLLL�LL � 6 j 1 E E v m 00 o 0 a a` u vmmi v N L O V x x a a a u u o ICAP April 2016 G/L Account Number Detail FY16 Budget Over/(Under) Budget Account# Premium$'s 010.10.1100.290000 $ 1,225.36 $ 1,200.00 010.10.1100.290100 $ 2,459.83 $ 3,000.00 010.10.1110.290300 $ 388.41 $ - 010.10.1100.290300 $ 4,405.86 $ 4,500.00 010.10.1100.290400 $ 7,108.06 $ 15,587.51 $ 8,000.00 $ 16,700.00 $ (1,112.49) 010.10.1400.290000 $ 2,618.63 $ 2,500.00 010.10.1400.290100 $ 15,257.91 $ 18,000.00 010.10.1400.290300 $ 2,920.16 $ 20,796.70 $ 2,550.00 $ 23,050.00 $ (2,253.30) 010.10.1500.290000 $ 1,234.14 $ 1,200.00 010.10.1500.290100 $ 3,672.50 $ 4,300.00 010.10.1500.290300 $ 2,920.16 $ 7,826.80 $ 2,550.00 $ 8,050.00 $ (223.20) 060.30.1600.290350 $ 3,283.40 $ 3,283.40 $ 3,650.00 $ 3,650.00 $ (366.60) 060.30.1610.290350 $ 4,512.36 $ 4,512.36 $ 4,000.00 $ 4,000.00 $ 512.36 010.10.1900.290000 $ 612.68 $ 700.00 010.10.1900.290100 $ 461.80 $ 1,074.48 $ 400.00 $ 1,100.00 $ (25.52) 010.40.3100.290000 $ 1,225.36 $ 1,200.00 010.40.3100.290300 $ 12,265.93 $ 13,491.29 $ 7,000.00 $ 8,200.00 $ 5,291.29 010.40.4100.290000 $ 2,040.58 $ 2,000.00 010.40.4100.290100 $ 1,426.89 $ 1,000.00 010.40.4100.290300 $ 3,043.04 $ 6,510.51 $ $ 3,000.00 $ 3,510.51 010.40.4200.290000 $ 1,962.89 $ 2,200.00 010.40.4200.290100 $ 528.65 $ 2,491.54 $ 600.00 $ 2,900.00 $ (308.46) 010.40.4300.290000 $ 612.68 $ 1,000.00 010.40.4300.290300 $ 961.72 $ 1,574.40 $ 1,500.00 $ 2,500.00 $ (925.60) 010.20.6000.290000 $ 3,253.24 $ 2,900.00 010.20.6000.290100 $ 346.90 $ 500.00 010.20.6000.290300 $ - $ 3,600.14 $ $ 3,400.00 $ 200.14 010.20.6010.290300 $ 16,920.54 $ 16,920.54 $ 21,000.00 $ 21,000.00 $ (4,079.46) 010.20.6150.290100 $ 217.83 $ 217.83 $ 300.00 $ 300.00 $ (82,17) 010.60.8100.290000 $ 8,769.30 $8,769.30 $ 7,900.00 $ 7,900.00 $ 869.30 010.60.8200.290000 $ 612.68 $ 612.68 $ - $ - $ 612.68 010.60.8300.290000 $ 1,775.94 $ 1,600.00 010.60.8310.290300 $ 8,631.16 $ 10,407.10 $ 11,000.00 $ 12,600.00 $ (2,192.90) 010.60.8350.290000 $ 612.68 $ 612.68 $ 600.00 $ 600.00 $ 12.68 010.60.8400.290000 $ 612.68 $ 612.68 $ 650.00 $ 650.00 $ (37.32) 010.50.8500.290000 $ 612.68 $ 612.68 $ 600.00 $ 600.00 $ 12.68 010.50.8700.290000 $ 612.68 $ 612.68 $ 600.00 $ 600.00 $ 12.68 010.20.8900.290000 $ 612.68 $ 1,400.00 010.20.8900.290100 $ 725.07 $ 1,337.75 $ 1,000.00 $ 2,400.00 $ (1,062.25) 010.20.8950.290000 $ 612.68 $ - - 010.20.8950.290100 $ - $ 612.68 $ - $ - $ 612.68 060.30.7100.290000 $ 2,050.34 $ 3,500.00 060.30,7100.290100 $ 13,054.20 $ 12,000.00 060.30.7100.290300 $ 1,432.97 $ 16,537.52 $ 1,500.00 $ 17,000.00 $ (462.48) 510.30.6510.290000 $ 3,675.34 $ 3,500.00 510.30.6510.290100 $ 793.06 $ 1,500.00 510.30.6510.290300 $ 5,136.35 $ 9,604.75 $ 6,000.00 $ 11,000.00 $ (1,395.25) 520.30.6520.290000 $ 4,443.90 $ 4,500.00 520.30,6520.290100 $ 2,344.56 $ 1,300.00 520.30.6520.290300 $ 8,272.62 $ 15,061.08 $ 5,500.00 $ 11,300.00 $ 3,761.08 540.30.6540.290000 $ 7,857.71 $ 10,000.00 540.30.6540.290100 $ 886.05 $ 1,500.00 540.30.6540.290300 $ 780.70 $ 9,524.45 $ 1,000.00 $ 12,500.00 $ (2,975.55) 560.80.5300.290000 $ 1,225.36 $ 1,400.00 560.80.5300.290100 $ 1,611.40 $ 1,500.00 560.80.5300.290300 $ $ 2,836.76 $ - $ 2,900.00 $ (63.24) 750,80.8750.290000 $ 5,134.34 $ 6,000.00 750.80.8750.290100 $ 149.37 $ 200.00 750.80.8750.290300 $ 5,062.02 $ 10,345.73 $ 5,000.00 $ 11,200.00 $ (854.27) $ 185,988.04 $ 185,988.04 $ 189,000.00 $ 189,000.00 $ (3,011.97) General Fund Over/(Under) Budget $ (1,168.02)