Loading...
HomeMy WebLinkAboutCity Council Committees - Operations - 11/05/2013 • KEN T WASH NOTON Operations Committee Agenda Councilmembers: Dennis Higgins * Jamie Perry * Les Thomas, Chair November 5, 2013 4:00 p.m. Item Description Action Speaker Time Pace 1. Approval of Minutes YES 1 dated October 15, 2013. 2. Approval of Check Summary YES Reports 10/1/2013 through 10/15/2013. 3. Preferred Copier Systems IMaintenance YES D. Drake 5 3 Contract for City MFDs- Authorize 4. Resolution Authorizing the Write-off of YES B. Nachlinger 5 27 Uncollectable Accounts 5. September Financial Summary. No B. Nachlinger 5 29 Unless otherwise noted, the Operations Committee meets at 4:00 p.m. on the first and third Tuesday of each month. Council Chambers East, Kent City Hall, 220 4th Avenue South, Kent, 98032-5895. Dates and times are subject to change. For information please contact Satwinder Kaur at (253) 856-5705. Any person requiring a disability accommodation should contact the City Clerk's Office at (253) 856- 5725 in advance. For TDD relay service call the Washington Telecommunications Relay Service at 1-800-833-6388. This page intentionally left blank 1 KENT WASHINGTON OPERATIONS COMMITTEE MINUTES October 15, 2013 Committee Members Present: Les Thomas, Chair, Dennis Higgins and Jamie Perry. The meeting was called to order by L. Thomas at 4:04 p.m. 1. APPROVAL OF MINUTES DATED SEPTEMBER 17, 2013. D. Higgins moved to approve the Operations Committee minutes dated September 17, 2013. J. Perry seconded the motion, which passed 3-0. 2. APPROVAL OF CHECK SUMMARY REPORTS DATED 9/1/2013 THROUGH 9/15/2013 AND 9/16/2013 THROUGH 9/30/2013. J. Perry moved to approve the check summary reports dated 9/1/2013 through 9/15/2013 and 9/16/2013 through 9/30/2013. D. Higgins seconded the motion and it passed 3-0. 3. HEWLETT PACKARD I WSCA CONTRACT - AUTHORIZE. M. Carrington presented the contract with Hewlett Packard to purchase new desktop PCs to be productive and competitive. This is next phase in the replacement of old machines. There is no change to the budget as they are already projected in the budget. D. Higgins moved to recommend that the council authorize the Mayor to sign a Purchase Order in an amount not to exceed $143,829 for the purchase of 185 HP 8300 Desktop PC's, services, and maintenance, subject to final terms and conditions acceptable to the City Attorney and Information Technology Director. 4. ALPHA TECHNOLOGIES SERVICES PURCHASE AMPS 80 UNINTERRUPTED POWER SUPPLY UNIT - AUTHORIZE. M. Carrington presented the contract that will enable IT to replace the current uninterrupted power supply unit at Station 74 as it is causing power issues at the station. It is currently operating at 90% capacity and is a 7 year old unit. The replacement will improve the data center power issues and the battery run time. The current unit will be moved to the court and will provide upscale capability at that facility. J. Perry asked what this unit will power for 75 minutes. M. Carrington responded that this will allow the computer system to safely store and not lose existing data, and the individuals will be able to shut down their machines without losing data. J. Perry moved to recommend that the council authorize the Mayor to sign a Goods and Services Agreement with Alpha Technology Services, Inc. in an amount not to exceed $101,154 for the purchase of an Alpha Hybrid AMPS 80 uninterrupted power supply unit, subject to final terms and conditions acceptable to the City Attorney and Information Technology Director. 2 Operations Committee Minutes October 15, 2013 Page: 2 S. AUGUST FINANCIAL SUMMARY PACKET. B. Nachlinger discussed the budget to date. He mentioned that Building Permits and Plan Check fees are above the forecast. Revenues are exceeding the budget by $300,000 through August. And Expenditures are 2.3% below budget. Property taxes will end the year very close to the budget where as sales tax will be almost $400,000 above budget. The meeting was adjourned at 4:23 p.m. by L. Thomas. '6t1'F11 t`f �'rr, Satwinder Kaur Operations Committee Secretary 3 INFORMATION TECHNOLOGY DEPARTMENT Mike Carrington, Director Information Technology ISI� T Phone: 253-856-4607 WASH IN°r°x Fax: 253-856-4700 Address: 220 Fourth Avenue S. Kent, WA. 98032-5895 DATE: November 5, 2013 TO: Operations Committee SUBJECT: Preferred Copier Systems Maintenance Contract for City MFD's- Authorize MOTION: Recommend the Mayor sign a Goods and Services Agreement with Preferred Copier Systems in an amount not to exceed $150,000 over 12 months for maintenance of the city fleet of Ricoh Multifunction Copier/Printer Devices (MFD's) subject to terms and conditions acceptable to the City Attorney and Information Technology Director. SUMMARY: This expenditure provides ongoing maintenance for the City's fleet of Ricoh Multifunction Copier/Printer Devices (MFD's) for twelve months with an option for a six month extension. The city now owns the MFD's, having formerly leased them under a contract with ABS Ricoh. This was a five year lease and included yearly maintenance. With completion of the terms of the lease agreement, the maintenance contract is now expired and we are on a month to month contract. In addition, the RFA is transitioning to its own fleet of MFD's, freeing 14 machines that we can leverage back into our fleet for greater flexibility. An RFP for service was issued. Three vendors responded. Responding vendors were interviewed by an IT panel. A costs and services analysis, along with references, led to the selection of Preferred Copier Systems. They are a local, highly motivated company who will be a partner in servicing these machines, maximizing the City's investment. We anticipate improved service, improved machine up time, and better reporting and billing service. Over the next year we will continue assessing the MFD's and potentially go out for an RFP for a replacement fleet for 2014-15. The six month extension will allow for a transition period, if needed. EXHIBITS: a) Preferred Copier Systems Draft Goods & Services Agreement with Exhibit A Draft Contract Service Details, Exhibit B, List of current MFD's included under the contract, and Exhibit C, Insurance Requirements; and b) RFP Results Matrix. Budget Impact: IT Operations Budget allocations approved as a part of the 2013-2014 biennial budget process are earmarked for this expenditure. 4 KENT WASHIN ON GOODS & SERVICES AGREEMENT between the City of Kent and Preferred Copier Systems. Inc. THIS AGREEMENT is made by and between the City of Kent, a Washington municipal corporation (hereinafter the "City"), and Preferred Copier Systems, Inc. organized under the laws of the State of Washington, located and doing business at 7691 S. 180th Street, Kent, Washington 98032, Phone 425-251-1201, Contact: Ron Cox, President and/or Charles Bryant (hereinafter the "Vendor"). AGREEMENT I. DESCRIPTION OF WORK. Vendor shall provide the following goods and materials and/or perform the following services for the City: Please See Exhibit A "Preferred Copier Systems, Inc. and City of Kent MFD Maintenance Repair Description of Services and Service Level Agreement" and Exhibit B, List of City-owned MFD Fleet Vendor acknowledges and understands that it is not the City's exclusive provider of these goods, materials, or services and that the City maintains its unqualified right to obtain these goods, materials, and services through other sources. II. TIME OF COMPLETION. Upon the effective date of this Agreement, Vendor shall complete the work and provide all goods, materials, and services for a 12 month period from Dec 1, 2013 through Dec. 1, 2014 (the "Term"). At the end of the Term, City and Vendor may mutually agree to a month-to-month extension of this Agreement for up to six (6) months by a written agreement signed by both parties. III. COMPENSATION. The City shall pay the Vendor an amount not to exceed .0092 per black and white impression and .07 per color impression for all makes and models of the City's fleet of Ricoh MFDs, including applicable Washington State Sales Tax, for the goods, materials, and services contemplated in this Agreement. The City shall pay the Vendor the following amounts according to the following schedule: GOODS & SERVICES AGREEMENT - 1 (Over$10,000.00, including WSST) 5 Vendor will gather meter counts electronically through a meter gathering tool. Meters will then download into the PCS billing system. Vendor will provide the meter information on a machine by machine basis in a format mutually agreed to between the City and the Vendor but including meter start and end counts for each product, the rate charged, total impressions and total amount billed per machine. Vendor will provide consolidated invoices by the loth of every month based on machine usage. City will pay 30 days net from date of receipt of invoices. Billing questions or errors will be resolved between the Vendor's local office and the City and credits or additional charges will be applied to the next month's billing. Meters will be based on actual usage; no averaging or estimating will be done. If the City objects to all or any portion of an invoice, it shall notify Vendor and reserves the option to only pay that portion of the invoice not in dispute. In that event, the parties will immediately make every effort to settle the disputed portion. A. Defective or Unauthorized Work. The City reserves its right to withhold payment from Vendor for any defective or unauthorized goods, materials or services. If Vendor is unable, for any reason, to complete any part of this Agreement, the City may obtain the goods, materials or services from other sources, and Vendor shall be liable to the City for any additional costs incurred by the City. "Additional costs" shall mean all reasonable costs, including legal costs and attorney fees, incurred by the City beyond the maximum Agreement price specified above. The City further reserves its right to deduct these additional costs incurred to complete this Agreement with other sources, from any and all amounts due or to become due the Vendor. B. Final Payment: Waiver of Claims. VENDOR'S ACCEPTANCE OF FINAL PAYMENT SHALL CONSTITUTE A WAIVER OF CLAIMS, EXCEPT THOSE PREVIOUSLY AND PROPERLY MADE AND IDENTIFIED BY VENDOR AS UNSETTLED AT THE TIME REQUEST FOR FINAL PAYMENT IS MADE. IV. INDEPENDENT CONTRACTOR. The parties intend that an Independent Contractor-Employer Relationship will be created by this Agreement. By their execution of this Agreement, and in accordance with Ch. 51.08 RCW, the parties make the following representations: A. The Vendor has the ability to control and direct the performance and details of its work, the City being interested only in the results obtained under this Agreement. B. The Vendor maintains and pays for its own place of business from which Vendor's services under this Agreement will be performed. C. The Vendor has an established and independent business that is eligible for a business deduction for federal income tax purposes that existed before the City retained Vendor's services, or the Vendor is engaged in an independently established trade, occupation, profession, or business of the same nature as that involved under this Agreement. GOODS & SERVICES AGREEMENT - 2 (Over$10,000.00, including WSST) 6 D. The Vendor is responsible for filing as they become due all necessary tax documents with appropriate federal and state agencies, including the Internal Revenue Service and the state Department of Revenue. E. The Vendor has registered its business and established an account with the state Department of Revenue and other state agencies as may be required by Vendor's business, and has obtained a Unified Business Identifier (UBI) number from the State of Washington. F. The Vendor maintains a set of books dedicated to the expenses and earnings of its business. V. DEFAULT AND TERMINATION. If Vendor fails to meet the performance guarantees stated in this Agreement or is financially unable to perform the services contracted for in this Agreement, it is a default of this Agreement. The City shall notify Vendor in writing of any default, which shall be corrected by Vendor within thirty (30) of receipt of notice of default from the City. A. If Vendor does not correct a default within thirty (30) days of receipt of notice from the City, the City may immediately terminate this Agreement. B. If the City issues a notice of default to Vendor more than twice during the Term or any extension term of this Agreement, the City may terminate this Agreement, effective immediately. The City may terminate this Agreement effective immediately if its City Council fails to provide funding for continued MFD maintenance. VI. CHANGES. The City may issue a written amendment for any change in the goods, materials or services to be provided during the performance of this Agreement. If the Vendor determines, for any reason, that an amendment is necessary, Vendor must submit a written amendment request to the person listed in the notice provision section of this Agreement, section XIV(D), within fourteen (14) calendar days of the date Vendor knew or should have known of the facts and events giving rise to the requested change. If the City determines that the change increases or decreases the Vendor's costs or time for performance, the City will make an equitable adjustment. The City will attempt, in good faith, to reach agreement with the Vendor on all equitable adjustments. However, if the parties are unable to agree, the City will determine the equitable adjustment as it deems appropriate. The Vendor shall proceed with the amended work upon receiving either a written amendment from the City or an oral order from the City before actually receiving the written amendment. If the Vendor fails to require an amendment within the time allowed, the Vendor waives its right to make any claim or submit subsequent amendment requests for that portion of the contract work. If the Vendor disagrees with the equitable adjustment, the Vendor must complete the amended work; however, the Vendor may elect to protest the adjustment as provided in subsections A through E of Section VII, Claims, below. The Vendor accepts all requirements of an amendment by: (1) endorsing it, (2) writing a separate acceptance, or (3) not protesting in the way this section provides. An amendment that is accepted by Vendor as provided in this section shall constitute full payment and final settlement of all claims for contract time and for direct, indirect and consequential costs, including costs of delays related to any work, either covered or affected by the change. GOODS & SERVICES AGREEMENT - 3 (Over$10,000.00, including WSST) 7 VII. CLAIMS. If the Vendor disagrees with anything required by an amendment, another written order, or an oral order from the City, including any direction, instruction, interpretation, or determination by the City, the Vendor may file a claim as provided in this section. The Vendor shall give written notice to the City of all claims within fourteen (14) calendar days of the occurrence of the events giving rise to the claims, or within fourteen (14) calendar days of the date the Vendor knew or should have known of the facts or events giving rise to the claim, whichever occurs first . Any claim for damages, additional payment for any reason, or extension of time, whether under this Agreement or otherwise, shall be conclusively deemed to have been waived by the Vendor unless a timely written claim is made in strict accordance with the applicable provisions of this Agreement. At a minimum, a Vendor's written claim shall include the information set forth in subsections A, items 1 through 5 below. FAILURE TO PROVIDE A COMPLETE, WRITTEN NOTIFICATION OF CLAIM WITHIN THE TIME ALLOWED SHALL BE AN ABSOLUTE WAIVER OF ANY CLAIMS ARISING IN ANY WAY FROM THE FACTS OR EVENTS SURROUNDING THAT CLAIM OR CAUSED BY THAT DELAY. A. Notice of Claim. Provide a signed written notice of claim that provides the following information: 1. The date of the Vendor's claim; 2. The nature and circumstances that caused the claim; 3. The provisions in this Agreement that support the claim; 4. The estimated dollar cost, if any, of the claimed work and how that estimate was determined; and 5. An analysis of the progress schedule showing the schedule change or disruption if the Vendor is asserting a schedule change or disruption. B. Records. The Vendor shall keep complete records of extra costs and time incurred as a result of the asserted events giving rise to the claim. The City shall have access to any of the Vendor's records needed for evaluating the protest. The City will evaluate all claims, provided the procedures in this section are followed. If the City determines that a claim is valid, the City will adjust payment for work or time by an equitable adjustment. No adjustment will be made for an invalid protest. C. Vendor's Duty to Complete Protested Work. In spite of any claim, the Vendor shall proceed promptly to provide the goods, materials and services required by the City under this Agreement. D. Failure to Protest Constitutes Waiver. By not protesting as this section provides, the Vendor also waives any additional entitlement and accepts from the City any written or oral order (including directions, instructions, interpretations, and determination). E. Failure to Follow Procedures Constitutes Waiver. By failing to follow the procedures of this section, the Vendor completely waives any claims for protested work and accepts from the City any written or oral order (including directions, instructions, interpretations, and determination). GOODS & SERVICES AGREEMENT - 4 (Over$10,000.00, including WSST) 8 VIII. LIMITATION OF ACTIONS. VENDOR MUST, IN ANY EVENT, FILE ANY LAWSUIT ARISING FROM OR CONNECTED WITH THIS AGREEMENT WITHIN 120 CALENDAR DAYS FROM THE DATE THE CONTRACT WORK IS COMPLETE OR VENDOR'S ABILITY TO FILE THAT SUIT SHALL BE FOREVER BARRED. THIS SECTION FURTHER LIMITS ANY APPLICABLE STATUTORY LIMITATIONS PERIOD. IX. WARRANTY. This Agreement is subject to all warranty provisions established under the Uniform Commercial Code, Title 62A, Revised Code of Washington. Vendor warrants goods are merchantable, are fit for the particular purpose for which they were obtained, and will perform in accordance with their specifications and Vendor's representations to City. The Vendor shall correct all defects in workmanship and materials within one (1) year from the date of the City's acceptance of the Contract work. In the event any part of the goods are repaired, only original replacement parts shall be used—rebuilt or used parts will not be acceptable. When defects are corrected, the warranty for that portion of the work shall extend for one (1) year from the date such correction is completed and accepted by the City. The Vendor shall begin to correct any defects within seven (7) calendar days of its receipt of notice from the City of the defect. If the Vendor does not accomplish the corrections within a reasonable time as determined by the City, the City may complete the corrections and the Vendor shall pay all costs incurred by the City in order to accomplish the correction. X. DISCRIMINATION. In the hiring of employees for the performance of work under this Agreement or any sub-contract, the Vendor, its sub-contractors, or any person acting on behalf of the Vendor or sub-contractor shall not, by reason of race, religion, color, sex, age, sexual orientation, national origin, or the presence of any sensory, mental, or physical disability, discriminate against any person who is qualified and available to perform the work to which the employment relates. Vendor shall execute the attached City of Kent Equal Employment Opportunity Policy Declaration, Comply with City Administrative Policy 1.2, and upon completion of the contract work, file the attached Compliance Statement. XI. INDEMNIFICATION. Vendor shall defend, indemnify and hold the City, its officers, officials, employees, agents and volunteers harmless from any and all claims, injuries, damages, losses or suits, including all legal costs and attorney fees, arising out of or in connection with the Vendor's performance of this Agreement, except for that portion of the injuries and damages caused by the City's negligence. The City's inspection or acceptance of any of Vendor's work when completed shall not be grounds to avoid any of these covenants of indemnification. IT IS FURTHER SPECIFICALLY AND EXPRESSLY UNDERSTOOD THAT THE INDEMNIFICATION PROVIDED HEREIN CONSTITUTES THE VENDOR'S WAIVER OF IMMUNITY UNDER INDUSTRIAL INSURANCE, TITLE 51 RCW, SOLELY FOR THE PURPOSES OF THIS INDEMNIFICATION. THE PARTIES FURTHER ACKNOWLEDGE THAT THEY HAVE MUTUALLY NEGOTIATED THIS WAIVER. In the event Vendor refuses tender of defense in any suit or any claim, if that tender was made pursuant to this indemnification clause, and if that refusal is subsequently determined by a court having jurisdiction (or other agreed tribunal) to have been a wrongful refusal on the Vendor's part, then Vendor shall pay all the City's costs for defense, including all reasonable GOODS & SERVICES AGREEMENT - 5 (Over$10,000.00, including WSST) 9 expert witness fees and reasonable attorneys' fees, plus the City's legal costs and fees incurred because there was a wrongful refusal on the Vendor's part. The provisions of this section shall survive the expiration or termination of this Agreement. XII. INSURANCE. The Vendor shall procure and maintain for the duration of the Agreement, insurance of the types and in the amounts described in Exhibit C attached and incorporated by this reference. XIII. WORK PERFORMED AT VENDOR'S RISK. Vendor shall take all necessary precautions and shall be responsible for the safety of its employees, agents, and subcontractors in the performance of the contract work and shall utilize all protection necessary for that purpose. All work shall be done at Vendor's own risk, and Vendor shall be responsible for any loss of or damage to materials, tools, or other articles used or held for use in connection with the work. XIV. MISCELLANEOUS PROVISIONS. A. Recyclable Materials. Pursuant to Chapter 3.80 of the Kent City Code, the City requires its contractors and consultants to use recycled and recyclable products whenever practicable. A price preference may be available for any designated recycled product. B. Non-Waiver of Breach. The failure of the City to insist upon strict performance of any of the covenants and agreements contained in this Agreement, or to exercise any option conferred by this Agreement in one or more instances shall not be construed to be a waiver or relinquishment of those covenants, agreements or options, and the same shall be and remain in full force and effect. C. Resolution of Disputes and Governing Law. This Agreement shall be governed by and construed in accordance with the laws of the State of Washington. If the parties are unable to settle any dispute, difference or claim arising from the parties' performance of this Agreement, the exclusive means of resolving that dispute, difference or claim, shall only be by filing suit exclusively under the venue, rules and jurisdiction of the King County Superior Court, King County, Washington, unless the parties agree in writing to an alternative dispute resolution process. In any claim or lawsuit for damages arising from the parties' performance of this Agreement, each party shall pay all its legal costs and attorney's fees incurred in defending or bringing such claim or lawsuit, including all appeals, in addition to any other recovery or award provided by law; provided, however, nothing in this paragraph shall be construed to limit the City's right to indemnification under Section XI of this Agreement. D. Written Notice. All communications regarding this Agreement shall be sent to the parties at the addresses listed on the signature page of the Agreement, unless notified to the contrary. Any written notice hereunder shall become effective three (3) business days after the date of mailing by registered or certified mail, and shall be deemed sufficiently given if sent to the addressee at the address stated in this Agreement or such other address as may be hereafter specified in writing. E. Assignment. Any assignment of this Agreement by either party without the written consent of the non-assigning party shall be void. If the non-assigning party gives its consent to any assignment, the terms of this Agreement shall continue in full force and effect and no further assignment shall be made without additional written consent. GOODS & SERVICES AGREEMENT - 6 (Over$10,000.00, including WSST) 10 F. Modification. No waiver, alteration, or modification of any of the provisions of this Agreement shall be binding unless in writing and signed by a duly authorized representative of the City and Vendor. G. Entire Agreement. The written provisions and terms of this Agreement, together with any Exhibits attached hereto, shall supersede all prior verbal statements of any officer or other representative of the City, and such statements shall not be effective or be construed as entering into or forming a part of or altering in any manner this Agreement. All of the above documents are hereby made a part of this Agreement. However, should any language in any of the Exhibits to this Agreement conflict with any language contained in this Agreement, the terms of this Agreement shall prevail. H. Compliance with Laws. The Vendor agrees to comply with all federal, state, and municipal laws, rules, and regulations that are now effective or in the future become applicable to Vendor's business, equipment, and personnel engaged in operations covered by this Agreement or accruing out of the performance of those operations. I. Counterparts. This Agreement may be executed in any number of counterparts, each of which shall constitute an original, and all of which will together constitute this one Agreement. IN WITNESS, the parties below execute this Agreement, which shall become effective on the last date entered below. VENDOR: CITY OF KENT: By: By: (signature) (signature) Print Name: Print Name: Suzette Cooke Its Its Mayor (title) DATE: DATE: NOTICES TO BE SENT TO: NOTICES TO BE SENT TO: VENDOR: CITY OF KENT: Preferred Copier Systems, Inc. City of Kent Attn: Ron Cox Attn: Dea Drake, Multimedia Manager 7691 South 180th Street City of Kent Kent, WA 98032 220 Fourth Avenue South Kent, WA 98032 425-251-1202 (telephone) (facsimile) (253) 856-4646 (telephone) (253) 856-4700 (facsimile) GOODS & SERVICES AGREEMENT - 7 (Over$10,000.00, including WSST) 11 APPROVED AS TO FORM: Kent Law Department PVCivi1Ti1esV0pm Filesio013-TT6maelA f ed Copies Systans Goods&Svcs Agea entdocz GOODS & SERVICES AGREEMENT - 8 (Over$10,000.00, including WSST) 12 DECLARATION CITY OF KENT EQUAL EMPLOYMENT OPPORTUNITY POLICY The City of Kent is committed to conform to Federal and State laws regarding equal opportunity. As such all contractors, subcontractors and suppliers who perform work with relation to this Agreement shall comply with the regulations of the City's equal employment opportunity policies. The following questions specifically identify the requirements the City deems necessary for any contractor, subcontractor or supplier on this specific Agreement to adhere to. An affirmative response is required on all of the following questions for this Agreement to be valid and binding. If any contractor, subcontractor or supplier willfully misrepresents themselves with regard to the directives outlines, it will be considered a breach of contract and it will be at the City's sole determination regarding suspension or termination for all or part of the Agreement; The questions are as follows: 1. I have read the attached City of Kent administrative policy number 1.2. 2. During the time of this Agreement I will not discriminate in employment on the basis of sex, race, color, national origin, age, or the presence of all sensory, mental or physical disability. 3. During the time of this Agreement the prime contractor will provide a written statement to all new employees and subcontractors indicating commitment as an equal opportunity employer. 4. During the time of the Agreement I, the prime contractor, will actively consider hiring and promotion of women and minorities. 5. Before acceptance of this Agreement, an adherence statement will be signed by me, the Prime Contractor, that the Prime Contractor complied with the requirements as set forth above. By signing below, I agree to fulfill the five requirements referenced above. Dated this day of 20 . By: For: Title: Date: EEO COMPLIANCE DOCUMENTS - 1 of 3 13 CITY OF KENT ADMINISTRATIVE POLICY NUMBER: 1.2 EFFECTIVE DATE: January 1, 1998 SUBJECT: MINORITY AND WOMEN SUPERSEDES: April 1, 1996 CONTRACTORS APPROVED BY Jim White, Mayor POLICY: Equal employment opportunity requirements for the City of Kent will conform to federal and state laws. All contractors, subcontractors, consultants and suppliers of the City must guarantee equal employment opportunity within their organization and, if holding Agreements with the City amounting to $10,000 or more within any given year, must take the following affirmative steps: 1. Provide a written statement to all new employees and subcontractors indicating commitment as an equal opportunity employer. 2. Actively consider for promotion and advancement available minorities and women. Any contractor, subcontractor, consultant or supplier who willfully disregards the City's nondiscrimination and equal opportunity requirements shall be considered in breach of contract and subject to suspension or termination for all or part of the Agreement. Contract Compliance Officers will be appointed by the Directors of Planning, Parks, and Public Works Departments to assume the following duties for their respective departments. 1. Ensuring that contractors, subcontractors, consultants, and suppliers subject to these regulations are familiar with the regulations and the City's equal employment opportunity policy. 2. Monitoring to assure adherence to federal, state and local laws, policies and guidelines. EEO COMPLIANCE DOCUMENTS - 2 of 3 14 CITY OF KENT EQUAL EMPLOYMENT OPPORTUNITY COMPLIANCE STATEMENT This form shall be filled out AFTER COMPLETION of this project by the Contractor awarded the Agreement. I, the undersigned, a duly represented agent of Company, hereby acknowledge and declare that the before-mentioned company was the prime contractor for the Agreement known as that was entered into on the (date), between the firm I represent and the City of Kent. I declare that I complied fully with all of the requirements and obligations as outlined in the City of Kent Administrative Policy 1.2 and the Declaration City of Kent Equal Employment Opportunity Policy that was part of the before-mentioned Agreement. Dated this day of 20 By: For: Title: Date: EEO COMPLIANCE DOCUMENTS - 3 of 3 15 Exhibit A Preferred Copier Systems, Inc. and City of Kent MFD Maintenance Repair Description of Services and Service Level Agreement 1. DEFINITIONS: a. Impression: An impression (also called a "click" charge) is defined as one side of one piece of 8.5x11 or 8.5x14 paper. Paper sizes greater than or 8.5 x 14 will be charged two impressions per side. b. MFD (Multifunction Device). A copier/printer device that provides copying off the glass, network printing, scanning and/or faxing. c. Vendor Meap/EESA Maintenance and Network Maintenance services: Covers phone support and network onsite support on the MFDs, including reinstalling copier apps, troubleshooting application problems, etc. This does not include supporting other network problems. If a problem resides on the City's network, normal network charges will apply. 2. MAINTENANCE SERVICE FEES BILLING: a. Vendor will gather monthly meter counts electronically via remote retrieval in order to determine machine usage. b. Vendor will provide consolidated invoices by the loth of every month based on machine usage. Should the remote retrieval feature fail to properly meter copies for any reason, the City shall be without liability for any impact to the amount of maintenance service fees due Vendor. In such cases and upon request, the City shall provide a visual meter read for Vendor in a timely manner to allow Vendor to provide a timely invoice. c. City will pay 30 days from date of receipt of invoices. Billing questions or errors will be resolved between the Vendor's local office and the City, and credits or additional charges will be applied to the next month's billing. d. The maintenance service fees due under the Agreement shall remain fixed during the Term of the Agreement or any extension thereof, unless adjusted by mutual agreement of the parties. The maintenance services fees due for the current month shall be based on the actual per page copies made during the prior month; no averaging or estimating will be done. The per- impression rates are: .0092 for all B&W and .07 for all color. 3. PARTS, SUPPLIES AND LABOR: a. This Agreement covers all parts, labor and consumable supplies (except paper and staples). Consumables include black toner and color toner, developer drums and fuser rollers as well as all other parts stated or not stated. This Agreement also includes any required refurbishing or rebuilding Exhibit A — Page 4 16 of equipment, regardless of current condition, and/or as provided in Section 16 entitled "Replacement Equipment" below. b. Vendor will stock adequate inventories of parts and supplies to maximize City MFD up-time. Should parts not be available, Vendor will order parts to be delivered via next day air in order to meet the 48 hour repair requirement described in Section 7 entitled "Service Loaners" below. c. Supplies. Toner and all other necessary supplies, excluding paper and staples, are to be provided to the City by Vendor in accordance with Section 2(b) above. On an as needed and/or as requested basis, Vendor will ship a sufficient amount of supplies for each piece of equipment upon execution of the Agreement. Any subsequent orders will be placed by City personnel. The City will be responsible for requisitioning supplies from Vendor for delivery. Vendor shall not cause a "stock-out" situation due to backorder of supplies. There will be no charge for shipping supplies, unless on the date an order is first placed, the City requests an order of supplies be shipped via overnight delivery. 4. EXCLUDED SERVICES: Vendor Meap/EESA Maintenance and Network Maintenance services are not included in this Agreement. These services will be provided at the rate of $150 per hour with a one-hour minimum. 5. RESPONSE TIME: Vendor will call the City's service desk or the customer directly (depending on established mutually-agreed procedures) within one (1) hour of receiving the initial service call. If the MFD cannot be resolved via phone consultation, Vendor will arrive on site within four (4) business hours of the time service call was placed. In the event of a missed four hour window, Vendor will credit the City $25.00 per occurrence. The four hour requirement is not a composite average, but a per call commitment. However, there may be times where mutually agreed extenuating or extreme circumstances prevent the four hour response and the credit requirement will be waived at the City's sole discretion. 6. ONGOING TRAINING: Vendor shall provide initial user training at each equipment location and refresher training as needed and upon request at no additional charge. Trainers shall be courteous, neat, and skilled in the operation of the applicable equipment. Vendor's failure to provide skilled trainers shall constitute a default of this Agreement. Exhibit A — Page 5 17 7. HARD DRIVE WIPES: Vendor will complete an initial hard drive wipe of all MFDs followed by up to quarterly wipes at no additional charge. The City may elect to install software to provide this function, which is not included in this contract. 8. SERVICE LOANER(s): a. In the event that Vendor is unable to repair the MFD within 24 hours due to parts availability, Vendor will order parts to be delivered via next day delivery. In the event that Vendor is unable to repair any machine within 24 hours after parts have been delivered, or within 48 hours for any other reason, Vendor will either bring in a City-owned spare MFD or provide a service loaner at no additional charge. b. The Vendor shall be responsible for all costs associated with delivery, installation, and removal of equipment loaners. 9. EQUIPMENT TRANSITION PLAN: a. The City and Vendor will meet at the beginning of the Term to review equipment placement and usage and come to a mutual plan to "right size" or move/replace equipment to better meet the needs of the City. Vendor and the City will review equipment and mutually agree on permanent removal and decommission of any equipment deemed unfit for continued service. City and Vendor may agree, at City's sole discretion, that decommissioned equipment will become the property of the Vendor for the purpose of re- using any good parts for City-owned MFD repairs. At termination of this Agreement, Vendor will retain ownership of decommissioned MFD of which the City agreed to transfer ownership. b. If mutually agreed, Vendor may elect to loan to City Vendor-owned equipment of like capability to replace City-owned equipment, if it will be more cost-effective for Vendor to trade out equipment than to repair existing equipment and the trade will provide significantly improved up-time for the City. Vendor-owned equipment will remain the property of Vendor at the end of this agreement. 10. SERVICE DESK INTERFACE: Vendor and City will work together to set criteria for working with the City's service desk for all services including dispatching service calls, reporting to service desk, repair contact, onsite contact, etc. The service desk interface agreement may be changed from time to time as agreed to by both parties, and to the City's satisfaction. Exhibit A — Page 6 18 11. EQUIPMENT INSTALLATION/REMOVAL/RELOCATION: a. Installation, relocation and removal costs are included in equipment "click/impression" pricing, however, extraordinary installation/removal/delivery requirements and their associated extra costs may be charged to the City as a separate line item on the invoice, when pre- approved by the City. b. When requested by the City, the Vendor agrees to relocate any MFD within the City to its new location at no additional cost to the City and without change to the Agreement's terms. For those equipment moves and relocations conducted by Vendor, the Vendor will remain responsible for damage caused and repairs required following each move and relocation. Movement of equipment must be coordinated with the City's Information Technology staff in charge of the computer network and telephone system to which the equipment may be connected or disconnected. c. Relocation includes moving MFD's between, to or from any City-owned facility or to/from Vendor facility and City. Relocation services also include moving in a City "loaner" machine from a stored location to a City customer location and then moving it back to storage when the MFD is repaired and the recapture of city MFDs at Regional Fire Authority facilities. d. The installation, relocation and/or removal of contract equipment shall be performed by Vendor in a professional manner. During and upon completion of installation, the City's premises shall be left in a clean condition. The Vendor may be required to repair all damage and/or provide full compensation for damage to the City's premises that occurred as a result of equipment delivery, installation, and removal. 12. CUSTOMER SERVICE REPRESENTATIVE (CSR). Vendor shall provide a dedicated person or persons to physically monitor and maintain all equipment at optimum operating condition. The CSR(s) will be courteous, neat, and skilled in the operation of all equipment for which service or maintenance is required. 13. EQUIPMENT PERFORMANCE a. All equipment, including all accessories and software supplied under the Agreement, shall be capable of continuous operation. Vendor guarantees that all equipment will be operational at least 98% of normal business hours. b. Equipment that develops a trend of requiring an excessive number of service calls resulting in equipment downtime shall be reported by the City to Vendor, or by Vendor to the City as the situation warrants. "Equipment Downtime" is defined as: Exhibit A — Page 7 19 i. A copying system that fails to produce the required number of copies when the start button is depressed, whether by jamming, or any other mechanical, electrical, or software malfunction; ii. a copying system, or printer whose image quality is significantly reduced so as to be considered unprofessional by normal business standards. Examples include but are not limited to toner streaks or roller marks appearing on the paper, faded toner or colors; iii. an auto feed tray that will not accept and feed paper for scanning, faxing or copying; iv. a scanner that does not accept or transmit a scanned file back to MFD designated personal computer and software; V. a facsimile system that cannot transmit or receive facsimiles; vi. a printer that fails to print a standard MFD-provided print file from a stand-alone personal computer; or vii. a multifunctional peripheral (MFP) that cannot perform one or more of its functions according to the definitions above. viii. A machine the jams repeatedly on a job, or over the course of a business week. 14. REPORTING: a. Vendor will provide the meter information monthly on a machine-by-machine basis in a format mutually agreed to between the City and Vendor, that will include meter start and end counts for each product, the rate charged, total impressions and total amount billed per machine. Vendor will provide a written machine performance/service history report within two (2) weeks of receiving a request. b. Vendor shall maintain a service log for each piece of equipment serviced describing maintenance and repair services provided. A no cost copy of service logs/reports must be provided to the City within five (5) working days of request. 15. PERFORMANCE REVIEW: Vendor shall review with the City, on a quarterly basis, all service history information regarding the performance of all equipment maintained under the Agreement. A quarterly service calls report will be provided to the City electronically. 16. REPLACEMENT EQUIPMENT If remedial maintenance is required for an item of equipment on more than three occasions for a similar issue during any 30-day period, Vendor will Exhibit A — Page 8 20 escalate repair procedures up to and including reconditioning or trading out City equipment with the loan of Vendor-owned of equipment as provided in Section 9 above. If, after escalated refurbish or repair, the scenario is repeated on the same machine, upon the City's request, Vendor will replace the equipment, or the inoperative portion thereof, with a substitute of equal or better quality. The option of providing a lifetime service loaner is available if the City does not have an available machine in its existing unused fleet. Exhibit A — Page 9 Exhibit B Preferred Copier Systems, Inc. and City of Kent MFD Maintenance Repair 21 List of City-Owned MFD Fleet City of Kent Fleet MFD's 2012 IT Asset Copy Departments Service lD u# Physical Address Serial# Speed MFD Model Admit City Clerks Office/Formerly Fire Admin N2113 00017 2204th Ave V7600900129 65 MPC6501 Admin Mayor's Office 35667 00037 2204th Ave M5785000780 50 MP5000SPF-414379 ECDC Building Services 35685 00006 400 W Gowe St Ertl Floor L3784900342 30 MPC3000SPF-413219 ECDC Engineering Development 35678 00007 400 W Gowe St L8976920674 41 MPC3500SP-413343 ECDC Permit Center Back Office(Main) 35699 00047 400 W Gowe St 1st Floor M5585001706 40 MP4000SP-414376 ECDC Permit Center Reception(front counter) 35699 00048 400 W Gowe St 1st Floor M0179500517 16 MP161SPF-413567 ECDC Planning Services Copy Room 35686 00008 400 W Gowe St Ertl Floor L8184900098 65 MP6500SP-412794 Employee Services-Copy Room 35683 00010 400 W Gowe St 4th Floor M5785001521 50 MP5000SPF-414379 Employee Services-Risk Management 35684 00011 400 WGowe St4thfloor L3784900375 30 MPC3000SPF-413219 Finance Admin(Copy Room) 35682 00013 400 W Gowe St 4th Floor M5585002034 40 MP4000SPF-414377 Finance Customer Service 35673 00015 400 W Gowe St 1st Floor M0179500515 16 MP161SPF-413567 Finance Customer Service 35730 00014 400 W Gowe St 1st Floor M5785001360 50 MP5000SPF-414379 Finance Payroll/Formerly Admin City Clerk 35672 00070 2204th Ave M5585002096 40 MP4000SPF-414377 Finance Payroll/Offline 35681 00016 400 W Gowe St 4th Floor M6385100193 33 MP3350SP-414399 Fire Logistics 35724 00028 24611116th Ave SE M5585100384 40 MP4000SPF-414377 Fire Emergency Management N2568 00019 24425116th Ave SE V9515102001 45 MPC4501SPF Fire Prevention 35680 00020 400 W Gowe St 2nd floor M7980200166 60 MPC6000-413959 Fire Station#71 35711 00021 504 W Crow St M6585000159 25 MP2550SPF-414398 Fire Station#72 35710 00022 25620140th Ave SE M6585000179 25 MP2550SPF-414398 Fire Station#73 35727 00023 26512 Military Rd S M6585100457 25 MP2550SPF-414398 Fire Station#74 35725 00024 24611116th Ave SE M6585100459 25 MP2550SPF-414398 Fire Station#75 35709 00025 15635 SE272nd St M6585100462 25 MP2550SPF-414398 Fire Station#76 35729 00026 2067672nd Ave M6585100463 25 MP2550SPF-414398 Fire Station#77 35708 00071 20717132nd Ave SE M6585100442 25 MP2550SPF-414398 Fire Station#78 L2270 00029 17820 SE 256th St M6595100600 25 MP2550SPF Fire Training 35723 00030 24425116th Ave SE L9086121147 45 MPC4500SPF-413346 Fire Vehicle Maintenance 35728 00018 2067872nd Ave M6385000388 33 MP3350SPF-414400 ITAdmin 35666 00032 2204th Ave S 2nd Floor L9086121056 45 MPC4500SPF-413346 IT Systems Annex 35665 00033 302 WGowe St M6385000166 33 MP3350SP-414399 Law 35670 00035 2204th Ave S 4th Floor L8084900275 50 MP5500SP-412793 Law Color 35671 00036 2204th Ave S 4th Floor L9086120694 45 MPC4500SP-413345 Municipal Courts Copy Room 35674 00004 1220 S Central Ave M5785001360 40 MP4000SPF-414377 Municipal Courts Courtroom 1/Formerly TAnnex 35664 00034 302 WGowe St M0179500508 16 MP161SPF-413567 Municipal Courts Courtroom 2/Formerly Permit Ctr 35687 00002 1220 S Central Ave M0179500510 16 MP161SPF-413567 Municipal Courts Courtroom 3/Formerly ECD Self Hell 35690 00003 1220 S Central Ave M6584900122 25 MP2550SP-414397 Municipal Courts Courtroom 4/PW Construction 35734 00061 1220 S Central Ave M6585101593 25 MP2550SPF414397 Municipal Courts Front 35722 00005 1220 S Central Ave M0179500516 16 MP161SPF Municipal Courts Probation 35675 00060 400 W Gowe St 1st Floor M6385100002 33 MP3350SPF-414400 Parks Admin. 35669 00038 2204th Ave L9076920601 45 MPC4500SPF Parks Facilities 35676 00012 400 W Gowe St 1st Floor M6584900858 25 MP2550SPF Parks Housing&Human Services 35669 00040 2204th Ave M5785001301 50 MP5000SPF-414379 Parks Kent Commons JulieR Office 35719 00041 5254th Ave M0179500513 16 MP161SPF Parks Kent Commons-Main-color 35718 00042 5254th Ave L8977020779 35 MPC3500SPF Parks Kent Commons-Tami H Office 35720 00043 5254th Ave M0179500518 16 MP161SPF Parks Maintenance 35733 00044 5821 S240th St M6585100460 25 MP2550SPF-414398 Parks Resource Center @ Commons 35717 00045 5254th Ave M5584900627 40 MP4000SPF Parks Riverbend Golf 35721 00039 2019 W Meeker M6585000160 25 MP2550SPF-414398 Parks Senior Center 35716 00046 600 ESmith St M6385000357 33 MP3350SPF Police&Fire Training Shared Machine 35726 00031 24523116th Ave SE M6385100001 33 MP3350SPF-414400 Police Admin 35705 00055 2524th Ave M5584900595 40 MP4000SP-414376 Police CEO 35704 00056 2524th Ave L9086120934 45 MPC4500SPF-413346 Police Corrections Admin 35715 00051 1230 S Central Ave M5585100386 40 MP4000SPF Police Corrections Annex 35712 00049 1230 S Central Ave M5584900629 40 MP4000SPF-414377 Police Corrections Booking 35714 00050 1230 S Central Ave M5584900622 40 MP4000SPF-414377 Police Corrections Medical 35713 00052 1230 S Central Ave M0179500512 16 MP161SPF Police Detectives 35663 00053 400 WGowe St L9076520515 41 MPC4500SPF-413346 Police Patrol 35707 00057 2524th Ave M5584900596 40 MP4000SP-414376 Police Patrol East Hill Sub Station L4385 00054 24523116th Ave SE V4409306650 17 MP171SPF-R171F Police Patrol West Hill Sub Station-Woodmom Sub L4349 00059 26226 Pacific Highway S. V4409501003 17 MP171SPF-R171F Police Records 35706 00058 2524th Ave L8185100064 65 MP6500SP-412794 Public Works Engineering Admin 35703 00063 407 W Gowe St L8976920686 35 MPC3500SPF-413344 Public Works Engineering Copy Room 35677 00064 400 W Gowe St L8275800207 75 MP7500SP-412795 Public Works Engineering Front 35679 00062 400 W Gowe St L9077220213 45 MPC4500SPF-413346 Public Works Operations 2ndFloor 35731 00066 5821 S240th St M5584900616 40 MP4000SP-414376 Public Works Operations Fleet 35662 00065 5821S240th St M0179500470 16 MP161SPF-413567 Public Works Operations Front Office 35732 00067 5821 S240th St L9076620573 45 MPC4500SPF-413346 Public Works Operations Water 35702 00069 5821 S240th St M0188908807 16 MP161SPF Public Works Operations TechSery L5899 00068 5821 S240th St M6594901083 25 MP2550SPF-414397 Exhibit B - Page 1 22 Exhibit C Preferred Copier Systems, Inc. and City of Kent MFD Maintenance Repair INSURANCE REQUIREMENTS Insurance Vendor shall procure and maintain for the duration of the Agreement, insurance against claims for injuries to persons or damage to property which may arise from or in connection with the performance of the work hereunder by Vendor, their agents, representatives, employees or subcontractors. Minimum Scope of Insurance Vendor shall obtain insurance of the types described below: 1. Automobile Liability insurance covering all owned, non-owned, hired and leased vehicles. Coverage shall be written on Insurance Services Office (ISO) form CA 00 01 or a substitute form providing equivalent liability coverage. If necessary, the policy shall be endorsed to provide contractual liability coverage. 2. Commercial General Liability insurance shall be written on ISO occurrence form CG 00 01 and shall cover liability arising from premises, operations, independent contractors, products-completed operations, personal injury and advertising injury, and liability assumed under an insured contract. The Commercial General Liability insurance shall be endorsed to provide the Aggregate Per Project Endorsement ISO form CG 25 03 11 85. The City shall be named as an insured under the Vendor's Commercial General Liability insurance policy with respect to the work performed for the City using ISO additional insured endorsement CG 20 10 11 85 or a substitute endorsement providing equivalent coverage. 3. Workers' Compensation coverage as required by the Industrial Insurance laws of the State of Washington. Minimum Amounts of Insurance Vendor shall maintain the following insurance limits: Exhibit C — Page 1 23 1. Automobile Liability insurance with a minimum combined single limit for bodily injury and property damage of $1,000,000 per accident. 2. Commercial General Liability insurance shall be written with limits no less than $1,000,000 each occurrence, $2,000,000 general aggregate and a $2,000,000 products-completed operations aggregate limit. Other Insurance Provisions The insurance policies are to contain, or be endorsed to contain, the following provisions for Automobile Liability and Commercial General Liability insurance: 1. The Vendor's insurance coverage shall be primary insurance as respect the City. Any Insurance, self-insurance, or insurance pool coverage maintained by the City shall be excess of the Vendor's insurance and shall not contribute with it. 2. The Vendor's insurance shall be endorsed to state that coverage shall not be cancelled by either party, except after thirty (30) days prior written notice by certified mail, return receipt requested, has been given to the City. 3. The City of Kent shall be named as an additional insured on all policies (except Professional Liability) as respects work performed by or on behalf of the Vendor and a copy of the endorsement naming the City as additional insured shall be attached to the Certificate of Insurance. The City reserves the right to receive a certified copy of all required insurance policies. The Vendor's Commercial General Liability insurance shall also contain a clause stating that coverage shall apply separately to each insured against whom claim is made or suit is brought, except with respects to the limits of the insurer's liability. D. Acceptability of Insurers Insurance is to be placed with insurers with a current A.M. Best rating of not less than A:VII. E. Verification of Coverage Vendor shall furnish the City with original certificates and a copy of the amendatory endorsements, including but not necessarily limited to the Exhibit C — Page 2 24 additional insured endorsement, evidencing the insurance requirements of the Vendor before commencement of the work. F. Subcontractors Vendor shall include all subcontractors as insureds under its policies or shall furnish separate certificates and endorsements for each subcontractor. All coverages for subcontractors shall be subject to all of the same insurance requirements as stated herein for the Vendor. Exhibit C — Page 3 MFD SP,irPVendor RFP Matrix.xlsx 25 Ricoh Inc. Description-MFD RFP Service Vendor Pacific Office Preferred Automation Copiers (Formerly Ricoh,) NOTES vendor) current ventlo Quoted prices are per"copy made"or"click". For comparison purposes,costs Iisted are based on 2012 actual count of 3,480,238 copies,minus RFA numbers $52,724.70 $57,683.87 $48,422.18 (pre-tax(.i.e.what we would have paid in 2012 with the rate,riuctic]. with Tax $57,733.55 $63,163.84 $53,022.29 Cost for moves based on 28 rel ocati ons from fire to city $4,599.00 $0.00 $4,599.00 and real location of ci ty fleet Hard Drive Wi pes Fire MFDs $1,517.67 $0.00 $2,759A0 Hard Drive wi pes al l machines $99 per machine per NC for initial wipe and $180 per machine Ricoh Doss App Software for al l machines wipe quarterly wipes software around$10,000 Total $63,850.22 $63,163.84 $60,380.69 Does not include possible software solutions for fleet tracking and cost mans ement such as"Pa erCuP'software 8 complaints 0complaints Assoc.Business Systems- Not ratedNet Rated Ricoh(ABS Ricoh( BBB Rating 8 complaints closed 0 complaints closed 0complaints with BBB in last with BBB in last Rated A,. years 14 closed in last years l 0 closed in last *No info at all for 12 months 12 months Ricoh USA Bellevue Kent Local Business Seattle t/ Bellevue Experience with Ricnhs Not in this region t/ ✓ [Me local Ricoh exp.until very recently,"jaA moved"teens into this area,one Ricoh reference for Portland 3 teams of 3 based on equip type Regi anal techs/teams with l ocal ized service areas Local Techs 411* 10 up to 180i sh regional ly. *not clear how many service Kent Different service manager Certified Tacks x/ ✓ d Depends on service:billing,moves and repair each separate,plus three service Si pill a Point of Contact x/ t/ managers and inconsistent salesman with incomplete,confusing or inaccurate information. Response Time-emergencies Ihr call/4 hr onshe Ihr call/4 hr onsite Yhr call/4 hr onshe Use quarterly composite response time to calculate 4 hr response times Access to latest software/firmware updates or upgrades Has access to latest;however MFD's software does not appear to be current on as they are rel eased ✓ all machines. MFD moves 15D ✓ $150-$225 Moves require Kent to make arrangements,three step process, Unacceptable process restricted move dates slow response Hard drive wipe solution for Fire MFDs $99 per in Free $150 replace hard drives achine per Does not offer hard drive wipe as an option. Offers hard drive replacement or wi a software at 180+[ax per device *2 poor ref from Kent and Tigard,Oregon(won't use again(. 4 references **PLO billing issues,some tech issues,lots of transition problems,similar to overall good, 3references our experiences.Did like ABS Ricoh.On the fence about Ricoh USA. One References: 'Me he al Ricoh overall good *2 Poor,**I law,1 ok reference gave good reference but for PD Department Other info indicated the references d Preferred Copiers rescued the PD department with toner because Ricoh wasn't getting it there. Same cap.Kent has had. Response Time-references good good *2 Poor,I ok** No experience,each area calls,hasn't heard a lot of complaints Avg Machine optima Nn local Wachs good *2 Poor,I ok** No experience,each area calls,hasn't heard a lot of complaints Machine repair on first call Nn local Wachs good *2 Poor,I low** **Had to"let go"a Ricoh service tech and get a new one for ropy ctr Billing Process-easy timely good good *2 Poor,l poor** **Cant get Tacoma tax right takes weeks to fix,happens every time Dispatch References good good *2 Poor,I low** **Cant find Ricoh ID number in system so can't service machine. Excellent, "Ricoh will conduct assessed in advance, detailed and thorough made the RFP criteria,list rA problem machines and the RFP process was a prime Evaluate Flee[and provide proposal for Good see pg 13 of RFP evaluation rA the MFDs and media recommendations for missedoncertunity by the curand cnoor copmetMdemnnstnrte their runlutionnding assessment/repair/recondition/rebuild services response primers where Yacilities immediate .r „6 nYthe concerns and their skill and mmmittment in Prnvidinp,a resolution. improvement,will are open ee RFP accept/fix fleet as is response Pg4 Free trade out of like Free trade out of like **Proposes rebuild Loner/trade out machines machines machine from their refurbish rR enhisting *propose Konica's stock immediately equipment at no charge Service Hours 8-5 mon-fr 8-5 mon-fr 8-5 mon-fr Equipment and Parts Local in Stock in all local and in cars in all Regional Parts Local service/Dispatch Center Seattle t/ Bellevue Included in click "Vendor will temporarily store RFA MFDs Delivery of Equipment move/add/chang machine Pe ne p Perer move* charge $150 per **Current charges$250-$400 ✓ machine per move** Quote is$150-$225. Customer must make move arrangements, 2-3 step process limited move days Training City Staff Ricoh Smart Device Difficult to get answers,options fi&Pricing Appeared unprepared to make Software solutions for print tracking Papercu[ Monitor withVariable rccommendatinns nr pive details Acroun[i Plu In Redeployment Redeployment Additional Services Avail able assessment Assessment Redeployment Assessment Fleet mgmt software Fleet mgmt software Fleet mgmt software 1st Choice x/ 2nd Choice f No 3rd Choice Prepared by Drake,Dea 10/11/2013 Page 1 26 This page intentionally left blank 27 FINANCE DEPARTMENT Robert Nachlinger, Finance Director Phone: 253-856-5264 KEN T Fax: 253-856-6255 WASHING-ON Address: 220 Fourth Avenue S. Kent, WA. 98032-5895 Date: November 5, 2013 To: Kent City Council Operations Committee From: R. J. Nachlinger, Finance Director Through: Tom Brubaker, Interim Chief Administrative Officer Subject: Resolution Authorizing the Write-off of Uncollectable Accounts Motion: I move to recommend Council approve the ordinance authorizing the write-off of uncollectable accounts in the amount of $34,492.29. SUMMARY: The Administration recommends that the City Council authorize the write-off of uncollectable accounts which are in bankruptcy of have passed the six year collection period or are otherwise uncollectable. BUDGET IMPACT: There is no budget impact of this resolution as these accounts have already been fully reserved as doubtful accounts and are not included in the net accounts receivable amount. BACKGROUND: The accounts to be written off are listed below and the reason for the write- off: Misc. Accounts Receivable write-off - $22,298.78 The accounts receivable balance as of 10/15/13 was $835,135.78 and the requested write-off represents 2.67% of the balance. City Council's approval will also include the write-off of $593.22 in finance charges on these accounts. Fire Permits write-offs - $501.00 The total includes fire permits because the business closed, and in bankruptcy. Promissory Note write-offs $15,692.51 The accounts included contain a 1979 Water charge in lieu of assessment and damages to city owned vehicles. All have exceeded the statute of limitations and are uncollectable. A complete listing of these accounts is attached 28 Misc.Accounts Receivables Write-offs: DATE CUSTOMER: AMOUNT SERVICE AR Inv.# 2008/2009 Code Enforcement-ARMI Collections/uncellectable 7,000.00 Code Violations Multiple 2006/2009 Flre Prevention-ARMI Collections/uncollectable 224.00 Flre permits/fees FPS/FUFC 2008/2009 Parks Dept/Limont-ARMI Collections/uncollectabe 105.00 Commons/Rm-Gym Rentals RI 16336/11809 2009 Police Dept.-ARMI Collections/uncollectable 267.23 Police overtime RI 16731 2009/2010 Police/Gambling Txs-ARMI Collections/uncollectable 7,463.30 Quarterly Gambling Taxes Multiple 2007-2010 PW Ops/ARMI Collections/uncellectable 7,239.25 Various Operations Svcs Multiple Total Misc.AR Write-off: $22,298.78 Promisory Note Write-offs: DATE CUSTOMER: AMOUNT SERVICE ACCT# 1990 Ronald Fitzgerald-Damage to city vehicle#342-uncollectable 14,748.38 KCSC Case#90-1017997 5100.12500.0203 1979 Don Lloyd-In lieu of water assessment-uncollectable 240J0 Rec#197808300758 4100.12500.0203 1991 Kevin Merrill- Damage to city vehicle#344-uncollectable 703.43 KCSC Case#91-8003906 5100.12500.0203 Total Write-off: $15,692.51 Fire Permit Write-offs: DATE CUSTOMER: AMOUNT SERVICE Permit# 2007-2009 Kent Station(system error,back billed'10'12 3 yrs) 243.00 Annual Flre permit fee FPS 2070015 2012 Kent 4 Wheel Drive-Bankruptycy,uncollectable(RI 28047) 258.00 InPI Fire Code permit fee FUFC 2100078 Total Fire Permit Write-off: $501.00 TOTAL-2013 WRITE-OFFS: $38,492.29 29 City of Kent, Washington Summary Financial Report 4^0 KEN T WASH IN G T O N As of September 30, 2013 30 City of Kent MONTHLY FINANCIAL REPORT Table of Contents EXECUTIVE SUMMARY AND GRAPHIC ANALYSIS Executive Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 General Fund Revenues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 General Fund Expenditures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 PropertyTax . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 SalesTax . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 UtilityTax . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 Building Permits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 Plan Check Fees . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Recreation Fees . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Fines And Forfeitures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 Water Operating Revenues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 Sewer&Drainage Operating Revenues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 Golf Operating Revenues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 CURRENT BUDGET ANALYSIS General Fund Analysis (includes Annexation) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Street Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Lodging Tax Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Youth/Teen Programs Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Capital Improvement Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Criminal Justice Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Golf Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 INTERNAL SERVICE FUNDS PROFIT AND LOSS Fleet Services Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Central Services Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Information Technology Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 Facilities Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Unemployment Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Workers Compensation Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Health and Employee Wellness Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 LEOFF 1 Retirees Benefits Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Liability Insurance Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Property Insurance Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 REVENUE AND EXPENSE SUMMARIES Monthly Comparison 2010,2011,2012 and 2013 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 System Reports General Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 Special Revenue Operating Funds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 Debt Service Funds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 Water Utility Operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Sewerage Utility Operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Golf Course Operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 Internal Services-excluding Insurance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 Insurance Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 Street Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 Parks Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 Other Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 Technology Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 Facilities Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 Water Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 Sewerage Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 31 City Of Kent Monthly Financial Summary for September 2013 General Fund Summary Based on information available through August, ending fund balance will grow by $3.9 million and is estimated to end the year at nearly $7.6 million, which includes a fully funded contingency for unanticipated costs of $1.5 million and an estimated $400,000 for the strategic opportunities fund. Chanaes from Prior Month Forecast Sales Tax continues to show an upward trend. Collections through September are up nearly $425,000 from the same time period in 2012, which is a 3.6% increase. Building Permits and Plan Check Fees continue to come in above forecasted amounts. Because these areas tend to fluctuate, we forecast future months very conservatively. As a result, actual revenues continue to come in higher than our predictions. Through September, actuals exceed the budget by approximately $270,000. Revenues Overall revenues are estimated to end the year approximately $1.2 million over budget. Highlights include: • Property Tax continues to trend just above budget and is projected to end the year very near budget. • Sales Tax is showing a sustainable upward trend and is projected to end the year almost $475,000 above budget. • Utility Tax revenues are estimated to end the year slightly under budget. • Building Permits and Plan Check Fees continue to show a strong upward trend and both are currently above budget by approximately 10%. • Recreation Fees are trending to end the year above budget and are currently above budgeted projections by approximately 2.6%. Expenditures Current projections end the year at about $1.2 million or 1.9% below the budget. The expenditure savings is largely a result of departments continuing to be frugal with their budgets, especially in the areas of supplies and services. Fund Balance Ending fund balance is estimated to be nearly $7.6 million. Of this, $5.7 million is General Fund Reserves which equates to 10% of the expenditure budget. The remaining fund balance includes $1.5 million Contingency for Unanticipated Costs, as well as an estimated $400,000 for the Strategic Opportunities Fund. 3 32 General Fund Revenues (excluding Annexation) 12,000,000 10,000,000 8,000,000 6,000,000 4,000 000 o bi, 21,000,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Monthly Budget vs Adjusted Actual o 12 Act 113Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 3,110,563 3,667,409 4,646,335 9,549,882 5,254,735 4,492,624 3,513,188 3,138,721 4,764,030 9,572,573 4,512,854 3,916,350 13 Bud 3,287,453 3,582,989 5,272,332 10,707,786 5,316,435 4,443,933 3,235,522 2,834,184 4,428,143 10,541,289 4,272,968 4,055,873 13 Pct 3,358,007 3,802,504 5,090,165 10,591,647 5,364,940 4,603,295 3,707,056 3,162,420 5,241,646 +/- 70,555 219,516 (182,167) (116,139) 48,505 159,362 471,534 328,236 813,503 Put+/- 2.1% 6.1% -3.5% -1.1% 0.9% 3.6% 14.6% 11.6% 18.4% General Fund Revenues (excluding Annexation) 70,000,000 60,000,000 n" 40,000,000 30,000,000 20,000,000 10,000,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13Bud Cumulative Budget vs Actual """12AG .13Ac[ ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 3,110,563 6,777,971 11,424,306 20,974,188 26,228,923 30,721,547 34,234,735 37,373,456 42,137,486 51,]10,059 56,222,913 60,139,262 13 Bud 3,287,453 6,870,441 12,142,773 22,850,559 28,166,993 32,610,926 35,846,448 38,680,632 43,108,]]5 53,650,065 57,923,032 61,978,905 13 Pct 3,358,007 7,160,511 12,250,676 22,842,323 28,207,263 32,810,558 36,517,614 39,680,034 44,921,680 +/- 70,555 290,070 107,904 (8,236) 40,269 199,,632 671,165 999,402 1,812,905 Put+/- 2.1% 4.2% 0.9% 0.0% 0.1% 0.6% 1.9% 2.6% 4.2% 33 General Fund Expenditures (excluding Annexation) 6,000,000 5,000,000 "A , �rii�/Gil /lllr " + e ,n 4,000,000 3,000,000 2,000,000 1,000,000 p Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Monthly Budget vs Adjusted Actual 12 Act 113 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 3,920,818 4,780,445 4,613,724 4,565,843 4,731,962 4,442,759 5,080,919 4,461,378 4,608,106 4,510,269 5,053,289 4,697,490 13 Bud 4,647,795 4,831,926 4,388,324 4,867,081 4,884,201 4,628,116 5,358,139 4,463,618 4,955,127 4,728,197 5,279,944 4,697,958 13 Pct 4,020,154 4,407,030 4,530,859 4,629,351 5,229,138 4,431,382 4,942,990 4,615,412 4,665,982 +/- (627,640) (424,896) 142,535 (237,730) 344,937 (196,734) (415,149) 151,794 (289,145) Put+/- -13.5% -8.8% 3.2% -4.9% 7.1% -4.3% JJ% 3.4% -5.8% General Fund Expenditures (excluding Annexation) 70,000,000 60,000,000 50,000,000 �rr�' 40,000,000 ,„. ; 30,000,000 20,000,000 10,000,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13Bud Cumulative Budget vs Actual """12AG .13Ac[ ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 3,920,818 8,701,263 13,314,987 17,880,830 22,612,792 27,055,551 32,136,470 36,59,848 41,205,954 45,716,223 50,769,512 55,467,002 13 Bud 4,647,795 9,479,721 13,868,044 18,735,126 23,619,327 28,247,442 33,605,582 38,069,200 43,024,327 47,752,524 53,032,468 57,730,426 13 Pct 4,020,154 8,427,184 12,958,043 17,587,394 22,816,532 27,247,914 32,190,904 36,806,316 41,472,299 +/- (627,640) (1,052,537) (910,001) (1,147,732) (802,795) (999,529) (1,414,678) (1,262,883) (1,552,028) Put+/- -13.5% -11.1% -6.6% -6.1% -3.4% -35555% -4.2% -3.3% -3.6% 34 Property Tax (excluding Annexation) 7,000,000 6,000,000 Q, to r/'� 5,000,000 '�� �' d'%r 4,000,000 3,000,000 2,000,000 Unti, I 'h4 y„ o Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Monthly Budget vs Adjusted Actual o 12 Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct (3,392) 119,956 411,883 6,005,997 2,213,628 112,122 28,103 96,095 328,944 6,200,897 1,554,685 (67,488) 13 Bud 0 135,378 447,506 6,660,125 1,661,201 67,073 32,597 85,255 321,407 6,414,061 1,386,021 84,293 13 Pct 6,606 107,689 523,185 6,657,367 1,637,359 66,176 34,197 52,420 375,365 +/- 6,606 (27,689) 75,679 (2,757) (23,842) (896) 1,601 (32,835) 53,958 Put+/- 0.0% -20.5% 16.9% 0.0% -1.4% -1.3% 4.9% -38.5% 16.8% Property Tax (excluding Annexation) 20,000,000 18,000,000 16,000,000 1 ,000,000 2,000,000 10,000,000 8,000,000 ,,,s 6,000,000 4,000,000 2,000,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Cumulative Budget vs Actual "`12Act �13Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct (3,392) 116,564 528,447 6,534,444 8,]48,0]2 8,860,194 8,888,297 8,984,392 9,313,336 15,514,233 17,068,919 17,001,430 13 Bud 0 135,378 582,884 7,243,009 8,904,211 8,971,283 9,003,880 9,089,135 9,410,542 15,824,603 17,210,625 17,294,918 13 Pct 6,606 114,295 637,481 7,294,848 8,932,207 8,998,384 9,032,581 9,085,001 9,460,366 +/- 6,606 (21,083) 54,596 51,839 27,997 27,101 28,701 (4,134) 49,823 Put+/- 0.0% -15.6% 9.4% OJ% 0.3% 0.3% 0.3% 0.0% 0.5% 6 35 Sales Tax (excluding Annexation) 2,500,000 2,000,000 1,500,000 1,000,000 "" Jdo,, 500,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Monthly Budget vs Adjusted Actual 9 12 Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 907,756 1,198,096 2,014,990 810,864 882,252 1,878,097 906,674 996,584 2,129,283 953,761 999,614 2,033,969 13 Bud 843,252 1,152,499 1,964,008 789,706 945,581 2,017,627 861,461 958,080 2,075,219 907,608 980,008 2,103,379 13 Pct 889,656 1,124,015 2,017,041 806,374 953,321 2,103,539 1,009,068 996,220 2,246,916 +/- 46,404 (28,484) 53,033 16,668 7,739 85,912 147,607 38,140 171,697 Put+/- 5.5% -2.5% 2.7% 2.1% 0.8% 4.3% 17.1% 4.0% 8.3% Sales Tax (excluding Annexation) 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 i 8,000,000 6,000,000 4,000,000 2,000,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec t 13 Bud Cumulative Budget vs Actual """'12Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 907,756 2,105,852 4,120,842 4,931,706 5,813,958 7,692,054 8,598,728 9,595,312 11,724,595 12,678,356 13,677,970 15,711,938 13 Bud 843,252 1,995,751 3,959,760 4,749,465 5,695,047 7,712,674 8,574,134 9,532,215 11,607,433 12,515,041 13,495,049 15,598,428 13 Pct 889,656 2,013,672 4,030,713 4,837,087 5,790,407 7,893,946 8,903,014 9,899,234 12,146,150 +/- 46,404 17,920 70,953 87,621 95,361 181,273 328,880 367,020 538,717 Put+/- 5.5% 0.9% 1.8% 1.8% 1.7% 1.4% 3.8% 3.9% 4.6% 36 Utility Tax (excluding Annexation) 2,000,000 1,800,000 1,600,000 a , 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13Bud Monthly Budget vs Adjusted Actual it 12Ac[ .13Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 1,619,454 1,288,955 1,221,167 1,511,280 1,087,909 1,154,716 1,360,856 1,081,742 1,165,697 1,296,892 1,189,123 862,333 13 Bud 1,764,072 1,352,430 1,343,823 1,594,088 1,214,513 1,262,664 1,464,924 1,103,165 1,273,221 1,253,949 1,187,328 1,031,213 13 Pct 1,677,539 1,340,166 1,302,161 1,506,646 1,253,588 1,146,707 1,366,431 1,177,282 1,449,242 +/- (86,533) (12,264) (41,662) (87,442) 39,076 (115,957) (98,493) 74,116 176,021 Put+/- -4.9% -0.9% -3.1% -5.5% 3.2% -9.2% -6J% 6.7% 13.8% Utility Tax (excluding Annexation) 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 a..'`*„ 6,000,000 4,000,000 2,000,000 ` 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud .....12Act Cumulative Budget vs Actual 13Att ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 1,619,454 2,908,409 4,129,576 5,640,855 6,728,764 7,883,480 9,244,336 10,326,078 11,491,775 12,788,667 13,977,789 14,840,122 13 Bud 1,764,072 3,116,502 4,460,325 6,054,413 7,268,926 8,531,590 9,996,514 11,099,679 12,372,900 13,626,850 14,814,177 15,845,390 13 Pct 1,677,539 3,017,705 4,319,866 5,826,512 7,080,100 8,226,807 9,593,239 10,770,520 12,219,762 +/- (86,533) (98,797) (140,459) (227,902) (188,826) (304,783) (403,275) (329,159) (153,138) Put+/- -4.9% -3.2% -3.1% -3.8% -2.6% -3.P -4.0% -3.0% -1.2% 37 Building Permits (excluding Annexation) 350,000 3 00,000 250,000 PJ 200,000 ,,,,/ me, ®,,,,�, �Il 1, � 150,000 %/A r� Imo 100,000 50,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13Bud Monthly Budget vs Adjusted Actual ,12Act .13Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 25,055 172,710 167,250 183,913 184,131 198,651 158,301 240,085 223,792 178,928 114,037 232,381 13 Bud 75,511 163,760 193,467 215,714 228,329 242,375 237,929 212,814 174,066 152,061 136,616 133,097 13 Pct 77,108 196,379 209,153 213,511 271,096 324,478 255,066 163,164 216,429 +/- 1,598 32,619 15,686 (2,204) 42,767 82,103 17,137 (49,649) 42,363 Put+/- 2.1% 19.9% 8.1% -1.0% 18.7% 33.9% 7.2% -23.3% 24.3% Building Permits (excluding Annexation) 2,500,000 2,000,000 1,500,000 1,000,000 500,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Cumulative Budget vs Actual ,,.. 12 Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 25,055 197,765 365,015 548,927 733,058 931,709 1,090,009 1,330,095 1,553,887 1,732,815 1,846,852 2,079,233 13 Bud 75,511 239,271 432,738 648,452 876,782 1,119,157 1,357,086 1,569,899 1,743,966 1,896,026 2,032,642 2,165,739 13 Pct 77,108 2]3,48] 482,640 696,151 967,247 1,291,725 1,546,791 1,709,955 1,926,384 +/- 1,598 34,217 49,902 47,699 90,465 172,568 189,705 140,056 182,419 Put+/- 2.1% 14.3% 11.5% 7.4% 10.3% 144% 14.0% 8.9% 10.5% 38 Plan Check Fees (excluding Annexation) 350,000 300,000 25 0,000 200,000 �IIJv ,r ,� ,�„ 150,000 ,y, r %�, 100,000 .. of 7111; 50,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Monthly Budget vs Adjusted Actual ,12 Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 66,766 141,814 114,843 169,667 148,793 184,929 107,092 170,656 177,974 156,266 177,318 131,471 13 Bud 147,265 173,192 194,691 217,079 221,379 233,846 210,912 194,034 175,168 153,023 137,481 121,374 13 Pct 181,841 190,940 291,904 145,764 293,145 319,439 165,345 160,581 153,065 +/- 34,576 17,748 97,213 (71,316) 71,766 85,593 (45,568) (33,453) (22,103) Put+/- 23.5% 10.2% 49.9% -32.9% 32.4% 36.6% -21.6% -17.2% -12.6% Plan Check Fees (excluding Annexation) 2,500,000 2,000,000 1,000,000 500,000 0 LI/X------------------ Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec t 13 Bud Cumulative Budget vs Actual """'12Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 66,766 208,580 323,423 493,090 641,884 826,813 933,905 1,104,561 1,282,536 1,438,801 1,616,119 1,747,591 13 Bud 147,265 320,457 515,149 732,228 953,607 1,187,453 1,398,366 1,592,400 1,767,568 1,920,590 2,058,071 2,179,445 13 Pct 181,841 372,782 664,686 810,450 1,103,595 1,423,034 1,588,378 1,748,960 1,902,024 +/- 34,576 52,325 149,537 78,222 149,987 235,580 190,013 156,560 134,457 Put+/- 23.5% 16.3% 29.0% 10J% 15.7% 468% 13.6% 9.8% 7.6% Recreation..Fees. 39 . (excluding Annexation) 250,000 200,000 150,000 100,000 /,�,,, '� so 000 � 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Monthly Budget vs Adjusted Actual I 12 Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 106,827 39,771 90,603 192,227 70,696 50,428 162,378 103,085 148,637 64,127 27,778 50,625 13 Bud 109,937 39,623 85,499 209,852 78,870 47,522 159,782 111,867 160,305 53,884 41,421 95,187 13 Pct 146,178 46,730 93,362 200,494 75,294 54,760 157,061 90,541 164,659 +/- 36,242 7,107 7,863 (9,358) (3,575) 7,238 (2,721) (21,326) 4,354 Put+/- 33.0% 17.9% 9.2% -4.5% -4.5% 15.2% -1J% -19.1% 2.7% Recreation Fees (excluding Annexation) 1,400,000 1,200,000 1,000,000 a, 800,000 600,000 400,000 200,000 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Cumulative Budget vs Actual k....12Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 106,827 146,598 237,200 429,427 500,124 550,551 712,929 816,015 964,652 1,028,778 1,056,556 1,107,181 13 Bud 109,937 149,560 235,059 444,910 523,780 571,302 731,084 842,950 1,003,256 1,057,140 1,098,560 1,193,747 13 Pct 146,178 192,909 286,270 486,764 562,058 616,818 773,879 864,420 1,029,079 +/- 36,242 43,348 51,212 41,854 38,279 45,516 42,795 21,470 25,824 Pct+/- 33.0% 29.0% 21.8% 9.4A 7.3A 8.0A 5.9A 2.5A 2.6A 77 40 Fines & Forfeitures (excluding Annexation) 250,000 200,000 150,000 '10111,dA nd dew o, 100,000 ,,,,,� 50,000 p Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Monthly Budget vs Adjusted Actual o 12 Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 88,688 128,588 148,075 129,454 123,587 121,287 105,670 111,370 107,144 131,710 168,669 94,449 13 Bud 112,974 140,418 157,620 137,831 124,294 133,417 117,586 134,310 119,447 123,040 129,855 106,458 13 Pct 118,540 102,708 190,741 117,167 153,213 131,229 129,367 106,243 151,391 +/- 5,565 (37,710) 33,122 (20,664) 28,919 (2,189) 11,781 (28,067) 31,944 Put+/- 4.9% -26.9% 21.0% -15.0% 23.3% -1.6% 10.0% -20.9% 26.7% Fines & Forfeitures (excluding Annexation) 1,800,000 1,600,000 1,400,000 1,000,000 a �„ ��' , „ 800,000 600,000 400,000 200,000 C" 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec t 13 Bud 12 Act Cumulative Budget vs Actual t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 88,688 217,276 365,351 494,805 618,392 739,679 845,349 956,718 1,063,862 1,195,572 1,364,241 1,458,690 13 Bud 112,974 253,393 411,013 548,844 673,137 806,555 924,141 1,058,450 1,177,897 1,300,937 1,430,792 1,537,250 13 Pct 118,540 221,248 411,989 529,156 682,368 813,597 942,964 1,049,208 1,200,599 +/- 5,565 (32,145) 97 (19,688) 9,231 7,042 18,824 (9,243) 22,701 Put+/- 4.9% -12J% 0.2% -3.6% 1.4% 0.9% 2.0% -0.9% 1.9% 12 41 Water Operating Revenues (excluding Annexation) 2,500,000 2,000,000 J. ,,,,,, ,7P 1,500,000 1,000,000 "u,,,!" 500,000 p Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Monthly Budget vs Adjusted Actual o 12 Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 1,327,353 1,012,681 1,027,632 1,044,570 1,367,405 1,428,526 1,661,086 1,673,155 2,063,752 1,266,202 1,333,954 1,043,195 13 Bud 1,375,040 1,044,461 1,076,897 1,087,895 1,372,090 1,433,267 1,707,109 1,749,783 2,112,055 1,320,275 1,198,973 1,255,057 13 Pct 1,387,570 1,031,007 1,096,391 1,103,113 1,404,702 1,455,984 2,032,444 1,751,009 2,235,360 +/- 12,530 (13,455) 19,494 15,218 32,612 22,716 325,334 1,226 123,304 Put+/- 0.9% -1.3% 1.8% 1.4% 2.4% 1.6% 19.1% 0.1% 5.8% Water Operating Revenues (excluding Annexation) 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 - 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec t 13 Bud 12 Act Cumulative Budget vs Actual t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 1,327,353 2,340,035 3,367,667 4,412,237 5,779,642 7,208,168 8,869,254 10,542,409 12,606,161 13,872,363 15,206,317 16,249,512 13 Bud 1,375,040 2,419,501 3,496,398 4,584,293 5,956,383 7,389,651 9,096,760 10,846,543 12,958,598 14,278,874 15,477,847 16,732,904 13 Pct 1,387,570 2,418,577 3,514,968 4,618,081 6,022,783 7,478,767 9,511,210 11,262,219 13,497,579 +/- 12,530 (924) 18,570 33,788 66,400 89,116 414,450 415,677 538,981 Put+/- 0.9% 0.0% 0.5% OJ% 1.1% 1.2% 4.6% 3.8% 4.2% 13 42 Sewer and Drainage Operating Revenues (excluding Annexation) 4,500,000 4,000,000 3,500,000 //1/„ .. II/A ������ . %i 3,000 000 a,,,� ' ,n �� d0 /l,'i ,pj� %; i%i, 2,500,000 2,000,000 1,500,000 1,000,000 500,000 p Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Monthly Budget vs Adjusted Actual 9 12 Act 113Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 3,473,066 2,988,938 3,081,870 3,390,448 3,234,163 3,098,707 3,601,095 3,154,570 3,307,082 3,355,308 3,266,151 2,842,614 13 Bud 3,757,194 3,183,600 3,383,493 3,588,581 3,454,582 3,349,140 3,875,983 3,386,786 3,664,310 3,490,709 3,296,848 3,554,916 13 Pct 3,804,787 3,182,946 3,378,914 3,638,900 3,442,025 3,292,346 4,044,226 3,293,735 3,601,943 +/- 47,593 (654) (4,580) 50,319 (12,557) (56,794) 168,243 (93,051) (62,367) Put+/- 1.3% 0.0% -0.1% 1.4% -0.4% -1J% 4.3% -2J% -1J% Sewer and Drainage Operation Revenues (excluding Annexation) 45,000,000 40,000,000 35,000,000 30,000,000 25,000,000 % 20,000,000 15,000,000 7 7/,�,,., 10,000,000 5,000,000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec t 13 Bud 12 Act Cumulative Budget vs Actual t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 3,473,066 6,462,004 9,543,874 12,934,322 16,168,486 19,267,192 22,868,287 26,022,857 29,329,939 32,685,246 35,951,398 38,794,012 13 Bud 3,757,194 6,940,794 10,324,287 13,912,869 17,367,450 20,716,591 24,592,574 27,979,359 31,643,670 35,134,379 38,431,227 41,986,143 13 Pct 3,804,787 6,987,733 10,366,646 14,005,546 17,447,571 20,739,918 24,784,144 28,077,879 31,679,822 +/- 47,593 46,939 42,359 92,678 80,121 23,327 191,570 98,519 36,152 Put+/- 1.3% OJ% 0.4% OJ% 0.5% 0.1% 0.8% 0.4% 0.1% 14 43 Golf Operating Revenues (excluding Annexation) 500,000 45 0,000 400,000 350,000 300,000 250,000 11 200,000 - - - --- 150,000 100,000 e /���� G� 50,000 p Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Monthly Budget vs Adjusted Actual 9 12 Act 113Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 66,561 93,636 125,860 246,460 284,901 311,823 359,641 343,856 247,964 1]],862 116,212 123,470 13 Bud 97,104 129,628 175,789 259,441 287,498 385,648 461,785 450,392 282,078 197,982 102,730 148,919 13 Pct 71,129 108,922 184,571 201,960 255,764 326,892 346,431 326,]]3 186,999 +/- (25,975) (20,706) 8,782 (57,481) (31,734) (58,756) (115,354) (123,619) (95,079) Put+/- -26J% -16.0% 5.0% -22.2% -11.0% -15.2% -25.0% -27.4% -33J% Golf Operating Revenues (excluding Annexation) 3,500,000 3,000,000 2,500,000 2,000,000 1 1,500,000 1,000,000 i 500,000 0 c' Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13 Bud Cumulative Budget vs Actual k....12Act t 13 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Pct 66,561 160,197 286,058 532,518 817,419 1,129,242 1,488,882 1,832,739 2,080,703 2,258,565 2,374,]]8 2,498,247 13 Bud 97,104 226,732 402,521 661,963 949,461 1,335,109 1,796,894 2,247,286 2,529,364 2,727,345 2,830,075 2,978,994 13 Pct 71,129 180,051 364,622 566,583 822,347 1,149,238 1,495,670 1,822,443 2,009,442 +/- (25,975) (46,681) (37,899) (95,380) (127,114) (185,870) (301,224) (424,843) (519,922) Pct+/- -26Jh -20.6% -9.4% -14.4A -13.4A -13.9A -16.8A -18.9A -20.6A 7s 44 GENERAL FUND including Annexation As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Fund Balance 643,515 4,129,977 4,129,977 4,129,977 8,468,529 Revenues Taxes: Property 19,811,488 20,176,059 11,044,724 20,215,937 20,527,820 Sales Tax 20,120,481 19,902,489 15,153,157 20,234,505 20,234,460 Utility 17,478,468 18,807,401 14,468,335 18,840,663 19,071,967 Other 1,116,790 1,156,619 626,689 1,053,101 1,057,905 Business and Occupation Tax 300,000 300,000 300,000 300,000 Licenses and Permits 3,036,340 3,365,746 3,064,296 3,748,020 3,669,971 Intergovernmental Revenue 2,609,331 2,017,357 1,750,414 2,157,563 2,372,929 Charges for Services 4,248,388 4,779,967 4,015,328 5,029,069 5,029,870 Fines and Forfeitures 1,499,054 1,537,250 1,116,391 1,411,197 1,552,429 Miscellaneous Revenue 1,377,520 1,249,884 1,109,100 1,408,887 1,282,014 Transfers In 935,202 1,119,139 525,000 1,119,139 1,006,524 TOTAL REVENUES 72,233,062 74,411,911 53,173,434 75,518,081 76,105,889 Expenditures Salaries & Benefits 47,115,556 48,236,742 35,240,178 47,913,857 49,730,148 Supplies 2,081,119 3,354,551 1,629,887 2,489,918 3,416,487 Services & Charges 26,210,354 28,024,576 19,515,844 26,819,534 28,397,106 Capital Outlay 120,963 Cost Allocations (10,376,660) (10,614,161) (7,462,487) (10,047,818) (10,639,426) Transfers Out 3,595,268 3,874,291 123,926 3,874,291 3,635,680 TOTAL EXPENDITURES 68,746,600 72,875,999 49,047,348 71,049,782 74,539,995 Net Revenues less Expenditures 3,486,462 1,535,912 4,126,086 4,468,300 1,565,894 Ending Fund Balance 4,129,977 5,665,889 8,256,063 8,598,276 10,034,423 Comprised of: General Fund Reserves 3,669,464 4,662,791 5,673,703 7,591,137 6.6% 8.1% 10.0% 12.8% Contingency for Unanticipated Costs 500,000 1,500,000 1,500,000 Estimated Strategic Opportunities Fund 400,000 400,000 Annexation Fund Balance 460,513 503,098 1,024,574 543,286 16 45 STREET OPERATING FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Fund Balance 355,417 275,044 275,044 275,044 424,441 Revenues Fuel Tax - Unrestricted 1,865,667 1,886,725 1,400,212 1,893,652 1,905,592 Water Utility Tax 162,924 167,414 134,725 171,070 172,436 Sewer Utility Tax 223,450 231,245 185,730 239,091 238,182 Drainage Utility Tax 165,087 173,236 130,073 173,342 178,433 Electric Utility Tax 1,088,861 1,119,842 870,201 1,121,527 1,131,040 Gas Utility Tax 350,459 393,959 277,403 350,624 378,210 Garbage Utility Tax 156,016 205,866 169,863 205,942 207,925 Telephone Utility Tax 710,882 669,929 498,824 675,338 689,618 Business &Occupation Tax 4,700,000 2,163,090 4,000,000 4,700,000 Miscellaneous Revenues (47,995) 70 3,125 3,125 70 Total Revenues 4,675,351 9,548,286 5,833,247 8,833,709 9,601,506 Total Resources 5,030,768 9,823,330 6,108,290 9,108,753 10,025,947 Expenditures&Transfers Debt Service PW Trust Fund Loan 797,200 827,069 827,069 827,069 823,391 LTGO Bonds 2000 28,775 LTGO Bonds 2002 553,692 GO Refund (96) 2004 136,393 139,507 20,769 139,507 151,089 GO Refund 2005 (93,95,00,96TF) 37,789 114,714 15,972 114,714 112,485 LTGO Bonds 2008 487,066 466,921 144,610 466,921 472,025 LTGO Bonds 2009 207,213 207,107 23,679 207,107 207,637 GO Refund 2012 (2000/2002) 253,557 600,023 95,407 600,023 713,250 Total Debt Service 2,501,685 2,355,341 1,127,506 2,355,341 2,479,877 Operating Costs Street Utility Operations 1,805,094 1,674,419 1,136,874 1,624,584 1,685,359 Street Tree Maintenance Program 196,017 267,968 121,927 249,210 271,177 Engineering Services Allocation 264,546 265,180 198,885 265,180 265,180 Total Operating Costs 2,265,657 2,207,567 1,457,686 2,138,975 2,221,716 Arterials Asphalt Overlays/ S 256th Street 4,550,000 810,000 3,850,000 4,700,000 James Ave Impr (4th to UPRR) 39,685 Street Light Repair 150,000 15,000 150,000 Closed and other Arterial Projects (166,617) Total Arterials (126,932) 4,700,000 825,000 4,000,000 4,700,000 Other Improvements Transportation Master Plan 4,966 Mero Transit Services 155,000 155,000 155,000 155,000 Closed and Other Improvements (44,652) Total Other Improvements 115,315 155,000 155,000 155,000 Total Effective Transportation System 2,254,039 7,062,567 2,282,686 6,293,975 7,076,716 Total Expense &Transportation 4,755,724 9,417,908 3,410,192 8,649,316 9,556,593 Change In Fund Balance (80,373) 130,378 2,423,055 184,394 44,913 Ending Fund Balance 275,044 405,422 2,698,099 459,437 469,354 17 46 LODGING TAX OPERATING FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Fund Balance 86,810 95,397 95,397 95,397 111,496 Revenues Lodging Tax 187,971 194,382 147,550 209,129 196,812 Miscellaneous Income 115 50 45 50 50 Total Revenues 188,086 194,432 147,594 209,179 196,862 Total Resources 274,896 289,829 242,991 304,576 308,358 Expenditures Seattle Southside Visitor Services 120,000 60,000 60,000 60,000 60,000 Tourism Unallocated 26,000 20,000 10,000 20,000 20,000 Tourism Chamber 18,500 18,500 18,500 18,500 18,500 ShoWare Marketing 60,000 35,000 60,000 60,000 Branding Activities 20,000 20,000 20,000 Total Expenditures 164,500 178,500 123,500 178,500 178,500 Transfers Out - ShoWare Impact Study 5,000 Transfers Out - Ballfield Portable Fencing 10,000 Total Expenditures and Transfers 179,500 178,500 123,500 178,500 178,500 Change in Fund Balance 8,587 15,932 24,094 30,679 18,362 Ending Fund Balance 95,397 111,329 119,491 126,076 129,858 78 47 YOUTH/TEEN PROGRAMS OPERATING FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed BEGINNING FUND BALANCE 20,579 86,458 86,458 86,458 85,988 REVENUES Utility Taxes: Water 48,877 50,224 40,417 50,385 51,731 Sewer 67,035 69,374 55,719 69,676 71,455 Drainage 49,526 55,971 39,022 53,156 57,650 Electric 326,658 335,885 261,060 335,885 339,244 Gas 105,138 118,164 83,221 118,164 113,399 Garbage 46,805 61,824 50,959 54,429 62,442 Telephone 213,264 200,938 149,647 211,703 206,885 Miscellaneous Revenues 576 250 295 304 255 TOTAL REVENUES 857,879 892,630 680,340 893,702 903,061 TOTAL RESOURCES 878,458 979,088 766,798 980,160 989,049 EXPENDITURES Transfer Out - General Fund Teen Programs 750,000 844,139 400,000 844,139 856,524 Teen Golf Program 42,000 42,000 42,000 42,000 TOTAL EXPENDITURES (TRANSFERS) 792,000 886,139 400,000 886,139 898,524 Change In Fund Balance 65,879 6,491 280,340 7,563 4,537 ENDING FUND BALANCE 86,458 92,949 366,798 94,021 90,525 19 48 CAPITAL IMPROVEMENT OPERATING FUND Including Both Portions of Estate Excise Taxes As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actuals Budget YTD Est Actual Proposed Total Beginning Fund Balance (12,052,614) (11,082,376) (11,082,376) (11,082,376) (7,055,821) Revenues &Other Fin Sources Sales Tax 4,608,055 4,340,469 3,560,519 4,861,498 4,874,950 Utility Tax 1,171,672 901,055 1,183,389 1,218,674 Real Estate Excise Tax 1,644,785 1,142,799 1,520,648 1,895,648 1,548,819 Real Estate Excise Tax-2nd Qtr 1,644,785 1,142,799 1,520,648 1,895,648 1,548,819 Real Estate Excise Tax-St Percent 258,392 73,287 73,287 Miscellaneous Revenues 2,135 3,939 1,066 3,089 3,978 Transfer In - Facilities 260,000 Sale of Property 198,526 2,500,000 1,795,075 2,500,000 3,500,000 Transfer In - GF 2,201,772 2,193,787 2,193,787 2,259,600 Total Rev/Other Fin Sources 10,818,451 12,495,465 9,372,299 14,606,346 14,954,840 Total Resources (1,234,163) 1,413,089 (1,710,077) 3,523,970 7,899,019 Expenditures (Transfers) Debt Service Non-Voted Debt Service 6,820 1,171,672 1,031 1,183,389 1,218,674 LTGO Bonds 2000 76,575 Valley Communications 170,910 240,880 240,880 229,280 LTGO Bonds 2002 434,733 LTGO /Taxable Bonds 2003 667,274 666,340 33,606 666,340 186,491 GO Refund (96) 2004 1,447,831 1,480,875 220,467 1,480,875 1,603,821 GO Refund 2005 (93,95,00,96TF) 63,112 191,579 26,674 191,579 187,857 LTGO Bonds 2006 770,000 758,000 229,000 758,000 1,246,000 LTGO Bonds 2008 1,412,334 1,306,679 404,690 1,306,679 1,324,575 GO Refund 2009 (Part 1999) 721,641 721,268 82,464 721,268 723,120 GO Refund 2012 (2000/2002) 350,111 747,257 88,233 747,257 645,377 ShoWare Debt Service 2,764,025 2,500,000 1,257,179 2,800,000 2,400,000 Water Fund Loan Payoff 366,660 Subtotal Debt Service 9,252,026 9,784,550 2,343,344 10,096,267 9,765,195 Facilities HVAC Lifecycle Replacements 75,000 Kent Meridian Pool Repairs/Mtc 25,000 Parks Maintenance Shop Renovation 35,000 Public Building Major Maintenance 54,962 Sealcoat Parking Lots 35,000 Security Camera Software Upgrade 40,000 Closed and Other Facilities Projects (4,962) Subtotal Facilities 260,000 0 0 0 0 Information Technology Hardware Lifecycle Replacmnts 120,000 Subtotal Information Technology 120,000 0 0 0 0 Parks Lifecycle Parks System 400,000 178,991 (61,009) 178,991 500,000 Eagle Scout Projects 23,159 23,159 23,159 Adopt-a-Park Program 23,602 23,602 23,602 Urban Forestry 15,000 24,248 24,248 24,248 Closed and Other Parks Projects (738) Subtotal Parks 414,262 250,000 10,000 250,000 500,000 20 49 CAPITAL IMPROVEMENT OPERATING FUND Including Both Portions of Estate Excise Taxes As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actuals Budget YTD Est Actual Proposed Other Annexation Study (48,076) Emergency Flood Preparedness (450,000) Event Center Lifecycle 300,000 300,000 300,000 300,000 Closed and Other Projects (30,197) (30,197) Subtotal Other (198,076) 269,803 (30,197) 300,000 300,000 Total Expenditures (Transfers) 9,848,212 10,304,353 2,323,147 10,646,267 10,565,195 Change in Fund Balance 970,239 2,191,112 7,049,152 3,960,079 4,389,645 Total Ending Fund Balance (11,082,375) (8,891,264) (4,033,224) (7,122,297) (2,666,176) 21 50 CRIMINAL JUSTICE OPERATING FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Fund Balance 327,985 650,437 650,437 650,437 738,577 Revenues Sales Tax - Local Option (1) 1,924,193 1,814,268 1,510,763 2,014,350 1,942,648 MVET - Basic Crime 100,113 92,899 78,533 104,560 104,136 MVET - High Crime 46,314 191,199 MVET - Special Programs 78,549 74,406 61,213 81,070 80,747 Miscellaneous Revenues 280 100 414 414 200 Total Revenues 2,149,448 2,172,872 1,650,922 2,200,394 2,127,731 Total Resources 2,477,433 2,823,309 2,301,359 2,850,831 2,866,308 Expenditures Law Salaries & Benefits 548,523 554,171 407,265 544,444 558,291 Supplies 13,963 30,554 5,733 17,309 30,922 Services &Charges 9,129 22,349 9,586 16,249 22,453 Domestic Violence Salaries & Benefits 160,674 138,291 102,126 136,167 140,107 Services &Charges 7,511 8,198 5,994 7,993 8,361 KYFS -Youth Violence Prevention Services &Charges 25,000 25,000 25,000 25,000 Police Salaries & Benefits 974,852 1,187,655 745,489 1,143,042 1,433,254 Supplies 36,558 58,064 40,608 54,144 93,476 Services &Charges 34,285 123,132 31,728 42,304 137,056 Total Expenditures 1,810,496 2,147,414 1,348,530 1,986,652 2,448,920 Transfers Out 16,500 16,500 30,000 46,500 16,500 Total Expenditures and Transfers 1,826,996 2,163,914 1,378,530 2,033,152 2,465,420 Increase (Decrease) In Fund Balance 322,452 8,958 272,393 167,242 (337,689) Ending Fund Balance 650,437 659,395 922,830 817,679 400,888 (1) Council resolution allocated 11% of Criminal Justice sales tax to Domestic Violence. 22 51 GOLF OPERATING FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actuals Budget YTD Est Actual Proposed Beginning Working Capital (2,174,297) (2,395,200) (2,395,200) (2,395,200) (2,494,183) 16 Hole Course Operating Revenues Green Fees 1,033,850 1,288,000 839,365 1,085,290 1,338,000 Cart&Club Rentals 155,812 204,000 146,594 179,023 204,000 Restaurant Lease 50,875 60,000 35,957 50,875 60,000 1,240,538 1,552,000 1,021,916 1,315,188 1,602,000 Direct Operating Expenditures 1,235,649 1,341,250 908,777 1,263,591 1,354,201 16 Hole Course Net Income/(Loss) 4,889 210,750 113,139 51,597 247,799 Par 3 Course Operating Revenues Green Fees 211,747 281,000 195,625 228,438 281,000 Cart&Club Rentals 11,809 14,000 9,623 11,979 14,000 Food &Beverage Sales 10,217 20,000 10,920 12,300 20,000 233,774 315,000 216,168 252,717 315,000 Direct Operating Expenditures 250,590 257,801 198,019 264,025 259,568 Par 3 Course Net Income/(Loss) (16,816) 57,199 18,149 (11,308) 55,432 Driving Range/Merchandise Center Operating Revenues Driving Range Fees 457,101 470,000 333,761 468,456 470,000 Mini Putt Fees 31,719 48,000 34,543 37,130 48,000 Lesson Fees 84,560 110,000 68,375 89,781 110,000 Cart&Club Rentals 1,841 1,485 1,679 Food &Beverage Sales 32,395 35,000 29,489 32,395 35,000 Merchandise Sales 467,175 508,994 338,899 473,992 508,994 1,074,791 1,171,994 806,551 1,103,433 1,171,994 Direct Operating Expenditures 791,820 999,004 564,133 812,764 1,013,777 DR/Merchandising Net Income/(Loss) 282,971 172,990 242,418 290,669 158,217 Net Operating Income/(Loss) 271,043 440,939 373,707 330,958 461,448 Other Operating Revenue/(Expenses) Internal Services * (388,867) (396,272) (291,060) (390,082) (408,477) Bank Charges/Armored Car Fees (39,594) (40,750) (28,704) (38,272) (41,565) Other Operating (14,232) (19,031) (9,644) (16,920) 58,639 (442,692) (456,053) (329,407) (445,274) (391,403) Adjusted Operating Income/(Loss) (171,649) (15,114) 44,299 (114,315) 70,045 Non-Operating Revenues (Expenses) Admissions Tax to General Fund (68,184) (58,539) (78,051) (86,100) Non-Operating Revenues (Expenses) ** 18,930 22,404 16,667 22,223 25,350 (49,254) 22,404 (41,872) (55,829) (60,750) Net Change in Working Capital (220,903) 7,290 2,428 (170,144) 9,295 Ending Working Capital (2,395,200) (2,387,910) (2,392,772) (2,565,344) (2,484,888) * Internal Services includes: Finance, HR, Law, Fleet, IT, Facilities and Property/Liability Insurance ** Other Non-Operating includes: interfund loan interest, repair assets, cell tower lease and penalties related to the restaurant contract. 23 52 FLEET SERVICES FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget VTD Est Actual Proposed Beginning Working Capital 2,628,235 1,866,304 1,866,304 1,866,304 1,393,225 Operating Revenue Fleet Operations 2,961,063 3,187,651 2,408,778 3,227,559 3,335,555 Fleet Replacement 374,875 792,850 596,332 792,850 1,042,850 Sale of Property 29,335 15,482 15,482 Miscellaneous Revenues 3,335 13,835 2,202 3,304 13,835 Total Operating Revenue 3,368,608 3,994,336 3,022,794 4,039,194 4,392,240 Total Resources 5,996,843 5,860,640 4,889,098 5,905,498 5,785,465 Expenditures Salaries & Benefits 847,779 827,334 619,621 856,257 829,189 Supplies 1,596,595 1,583,964 1,080,770 1,562,268 1,615,815 Services 786,363 739,124 600,025 731,733 782,145 Capital Outlay 820,905 1,364,440 307,970 1,364,440 500,000 Total Expenditures 4,051,642 4,514,862 2,608,386 4,514,698 3,727,149 Transfers Out 78,898 134 Total Expenses and Transfers 4,130,539 4,514,996 2,608,386 4,514,698 3,727,149 Net Change In Working Capital (761,931) (520,660) 414,409 (475,504) 665,091 Total Working Capital 1,866,304 1,345,644 2,280,713 1,390,800 2,058,316 24 53 CENTRAL SERVICES FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Working Capital (122,352) (168,200) (168,200) (168,200) (39,914) REVENUE Central Stores 101,236 217,827 85,861 114,481 222,183 Postage 199,667 296,204 120,401 207,083 301,610 Transfers In 120,882 120,882 Total Revenue 300,903 634,913 206,261 442,446 523,793 Total Resources 178,551 466,713 38,061 274,246 483,879 EXPENSE Central Stores 115,813 207,454 72,386 118,129 211,603 Postage 211,638 282,099 179,998 219,949 287,248 Central Services 19,301 19,361 14,521 19,361 19,555 Total Expense 346,752 508,914 266,905 357,439 518,406 Net Operating Income (45,849) 125,999 (60,644) 85,007 5,387 Ending Working Capital (168,200) (42,201) (228,844) (83,193) (34,527) 25 54 INFORMATION TECHNOLOGY FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Working Capital 399,972 570,140 570,140 570,140 789,754 Revenues Contributions & Other 4,533,585 4,212,504 3,008,083 4,212,504 4,618,812 Utility Tax 1,040,000 897,933 1,040,000 1,045,200 Intergovernmental - RFA 471,972 444,012 302,127 466,213 452,893 Technology Fees 413,035 374,800 353,527 441,948 389,308 Total Revenue 5,418,592 6,071,316 4,561,671 6,160,664 6,506,213 Total Resources 5,818,565 6,641,456 5,131,810 6,730,804 7,295,967 Expenditures Computer Systems &Tech Svcs Salaries & Benefits 2,138,636 1,887,305 1,193,412 1,817,840 1,895,104 Supplies 176,164 41,438 46,168 58,668 42,152 Services & Charges 1,169,621 1,196,198 1,158,992 1,196,198 1,526,968 Subtotal 3,484,420 3,124,941 2,398,572 3,072,707 3,464,224 Telecommunications Salaries & Benefits 147,407 147,009 120,825 142,984 148,420 Supplies 2,155 14,774 1,623 14,774 15,058 Services & Charges 296,732 406,661 216,966 406,661 415,287 Subtotal 446,294 568,444 339,414 564,419 578,765 Printing/Graphics/Cable TV Salaries & Benefits 561,058 663,316 479,386 633,996 674,734 Supplies 55,733 77,012 54,968 65,460 78,479 Services & Charges 289,156 368,605 152,408 313,314 396,974 Subtotal 905,947 1,108,933 686,762 1,012,770 1,150,187 Total Operating Expense 4,836,661 4,802,318 3,424,747 4,649,897 5,193,176 Transfers Out-LT Lifecycle 411,764 1,226,491 603,527 1,293,639 1,247,808 Total Exp &Transfers 5,248,425 6,028,809 4,028,274 5,943,535 6,440,984 Net Income 170,168 42,507 533,396 217,129 65,229 Ending Working Capital 570,140 612,647 1,103,536 787,269 854,983 26 55 FACILITIES OPERATING FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Working Capital 306,190 867,060 867,060 867,060 814,859 Operating Revenue Intergovernmental -RFA 843,316 843,316 649,564 866,086 843,316 Rental Fees - Internal 4,240,371 3,997,582 2,998,187 3,997,582 4,178,609 Leases 26,918 26,916 20,189 26,919 26,916 Miscellaneous Revenue 20,684 16,269 11,000 14,666 16,269 Total Revenue 5,131,289 4,884,083 3,678,939 4,905,253 5,065,110 Total Resources 5,437,479 5,751,143 4,546,000 5,772,313 5,879,969 Operating Expense Salaries and benefits 2,083,212 2,165,481 1,465,095 2,090,481 2,169,392 Supplies 271,314 351,202 199,603 334,167 360,176 Services and charges 1,802,990 1,873,365 1,153,403 1,813,259 1,924,181 Capital outlay - 40,500 - 40,500 - Total Operating Expense 4,157,516 4,430,548 2,818,102 4,278,407 4,453,749 Other Financial Uses Transfers Out - Projects 260,000 500,000 20,000 500,000 500,000 Transfers Out - Debt 152,903 109,115 76,452 109,115 101,714 Total Non Operating Rev (Exp) 412,903 609,115 96,452 609,115 601,714 Total Expenses and Uses 4,570,419 5,039,663 2,914,553 4,887,522 5,055,463 Net Change In Working Capital 560,870 (155,580) 764,386 17,731 9,647 Ending Working Capital 867,060 711,480 1,631,446 884,791 824,506 27 56 UNEMPLOYMENT FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Working Capital 201,790 280,233 280,233 280,233 420,207 Revenues Contributions 389,106 402,324 283,791 378,388 402,324 Miscellaneous Revenue 354 250 354 354 250 Total Revenues 389,460 402,574 284,144 378,741 402,574 Total Resources 591,250 682,807 564,377 658,974 822,781 Expenditures Salaries & Benefits 16,592 23,951 14,354 19,139 24,115 Supplies 4,177 2,089 4,260 Claims Paid 1st Quarter 77,395 100,000 54,869 54,869 100,000 2nd Quarter 101,465 100,000 45,979 45,979 100,000 3rd Quarter 72,840 100,000 13,325 13,325 100,000 4th Quarter 39,928 100,000 100,000 100,000 Other Services & Charges 2,796 5,087 2,330 3,966 5,189 Total Expenditures 311,017 433,215 130,857 239,366 433,564 Net Income 78,442 (30,641) 153,288 139,375 (30,990) Ending Working Capital 280,233 249,592 433,520 419,608 389,217 28 57 WORKERS COMPENSATION FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Working Capital (509,195) 693,747 693,747 693,747 1,070,540 Revenues Contributions 1,602,991 1,656,075 1,134,730 1,612,556 1,656,075 Miscellaneous Revenue 3,775 3,000 2,802 3,736 3,000 Total Revenue 1,606,766 1,659,075 1,137,532 1,616,293 1,659,075 Total Resources 1,097,572 2,352,822 1,831,279 2,310,040 2,729,615 Expenditures Salaries & Benefits 66,368 106,022 57,415 76,553 106,673 Judgements & Damages 742,840 1,000,000 219,175 789,817 950,000 Ultimate Loss Adjustment (676,087) Liability Insurance 43,329 78,234 50,025 50,025 79,799 Intergovernmental Services 138,790 204,000 105,689 140,919 204,000 Administrative Expenses 64,362 53,777 51,975 65,648 54,853 Other Expenses 4,427 16,660 5,054 6,738 16,962 Safety Program 19,795 90,262 1,116 90,262 92,066 Total Expenditures 403,825 1,548,955 490,450 1,219,964 1,504,353 Net Income 1,202,942 110,120 647,082 396,329 154,722 Ending Working Capital 693,747 803,867 1,340,829 1,090,076 1,225,262 Claims Reserve* Reserve Amount 1,757,476 Actuary Recommended 1,879,022 *Claims reserve is not included in ending working capital. It is adjusted annuallyon December 31st. The variance between reserve amount booked and actuary recommended amount is due to a timing difference between when the actual entries must be made versus receipt of the actuary report. 29 58 HEALTH AND EMPLOYEE WELLNESS FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Working Capital 4,634,833 5,963,620 5,963,620 5,963,620 6,856,399 Revenues Contributions Blue Cross 9,163,751 9,606,586 7,074,591 9,438,095 9,609,589 Group Health 392,117 424,534 278,009 370,678 445,761 Employee Share Blue Cross 907,667 1,043,069 665,476 888,173 1,043,511 Group Health 50,938 55,476 41,319 55,093 58,250 RFA Contributions 3,687,875 COBRA 156,845 86,282 99,297 132,395 90,596 Miscellaneous 196,866 148,068 101,726 135,634 155,471 Total Revenue 14,556,059 11,364,015 8,260,418 11,020,067 11,403,178 Total Resources 19,190,891 17,327,635 14,224,038 16,983,687 18,259,577 Expenditures Salaries& Benefits 329,982 350,704 231,862 309,149 354,212 Blue Cross Claims 10,418,590 8,045,679 5,452,601 7,645,679 8,711,459 Blue Cross Admin Fees 565,520 397,404 291,972 437,959 417,274 Blue Cross Audit Fees 59,332 59,332 60,519 Delta Dental Claims 1,027,473 811,325 539,363 799,447 860,816 Delta Dental Admin Fees 62,369 46,015 37,605 50,883 48,316 Vision Service Plan Claims 117,180 95,021 53,585 95,021 95,021 Vision Service Plan Admin Fees 26,325 14,293 15,423 22,525 15,008 Stop Loss Fees 469,190 415,113 255,593 415,113 477,380 Stop Loss Reimbursements (193,310) (349,793) (20,885) (159,650) (349,793) Group Health Premiums 443,055 531,269 314,479 425,771 610,959 COBRA Medical Expenses 11,205 11,205 IBNR Adjustment (110,300) (127,800) (127,800) 61,700 Wellness 16,012 88,314 43,718 68,290 124,482 Other Professional Services 55,188 53,338 25,097 53,462 189,345 Total Expenditures 13,227,272 10,430,214 7,251,618 10,106,385 11,676,698 Change in Working Capital 1,328,787 933,801 1,008,800 913,682 (273,520) Ending Working Capital 5,963,620 6,897,421 6,972,419 6,877,301 6,582,879 IBNR 863,400 670,800 670,800 670,800 742,800 Target Fund Bal @ 2 X IBNR 1,726,800 1,341,600 1,341,600 1,341,600 1,485,600 Ending Working Capital Less 2 X IBNR 4,236,820 5,555,821 5,630,819 5,535,701 5,097,279 30 59 LEOFF 1 RETIREES BENEFITS FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget Actual Est Actual Proposed Beginning Working Capital 527,368 699,508 699,508 699,508 598,392 Revenues Contributions 695,730 673,806 532,663 690,217 751,294 Contributions - Dependents 60,300 60,000 27,081 36,108 72,000 Miscellaneous Revenue 831 2,500 796 796 2,500 Total Revenues 756,861 736,306 560,540 727,121 825,794 Operating Transfers In 250,000 250,000 250,000 250,000 Total Resources 1,534,228 1,685,814 1,260,048 1,676,629 1,674,186 Expenditures Blue Cross Claims 556,619 764,122 359,561 664,122 814,122 Blue Cross Ad min Fees 52,486 61,812 35,539 53,536 63,048 Delta Dental Claims 41,801 50,468 28,707 45,981 52,991 Delta Dental Ad min Fees 5,476 4,774 4,331 5,774 4,869 Vision Service Plan Claims 5,420 7,441 2,588 5,652 7,813 Vision Service Plan Admin Fees 1,781 1,803 1,322 1,823 1,839 Stop Loss Reimbursements (25,000) (6,249) (25,000) Stop Loss Fees 43,219 50,425 31,062 46,775 51,434 IBNR Adjustment (14,400) 4,900 4,900 5,300 Medical Reimbursements 122,495 184,682 84,950 138,854 191,416 Other Professional Services 19,824 16,181 4,464 16,181 16,505 Total Expenditures 834,720 1,121,608 552,523 977,349 1,184,337 Change in Fund Balance 172,140 (135,302) 8,017 (228) (108,543) Ending Working Capital 699,508 564,206 707,525 699,280 489,849 IBNR 67,100 34,400 34,400 34,400 37,900 Target Fund Bal @ 2 X IBNR 134,200 68,800 68,800 68,800 75,800 Ending Working Capital Less 2 X IBNR 565,308 495,406 638,725 630,480 414,049 31 60 LIABILITY INSURANCE FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Working Capital 831,667 2,187,087 2,187,087 2,187,087 2,928,533 Revenues Contributions 2,340,300 2,340,300 1,755,225 2,340,300 1,989,256 Miscellaneous Revenue 6,164 4,000 4,666 6,221 4,000 Total Revenues 2,346,464 2,344,300 1,759,891 2,346,521 1,993,256 Total Resources 3,178,131 4,531,387 3,946,978 4,533,608 4,921,789 Expenditures Salaries & Benefits 66,367 95,684 61,374 81,832 96,335 Claims &Judgements 122,990 1,000,000 376,767 640,331 840,000 Insurance Premiums 664,509 719,750 691,440 691,440 755,737 Other Expenses 137,179 200,839 119,614 186,379 204,857 Total Expenditures 991,044 2,016,273 1,249,195 1,599,983 1,896,929 Net Income 1,355,420 328,027 510,695 746,538 96,327 Ending Working Capital 2,187,087 2,515,114 2,697,782 2,933,625 3,024,860 Claims Reserve* Reserve Amount 1,977,374 Actuary Recommended 1,282,088 *Claims reserve is not included in ending working capital. It is adjusted annuallyon December 31st. The variance between reserve amount booked and actuary recommended amount is due to a timing difference between when the actual entries must be made versus receipt of the actuary report. 32 61 PROPERTY INSURANCE FUND As of September 30, 2013 2012 2013 2013 2013 2014 Budget Actual Budget YTD Est Actual Proposed Beginning Working Capital 104,731 141,317 141,317 141,317 160,532 Revenues Contributions 453,593 562,455 421,841 562,455 568,080 Miscellaneous Revenue 114 100 53 100 100 Total Revenues 453,707 562,555 421,894 562,555 568,180 Total Resources 558,439 703,872 563,210 703,872 728,712 Expenditures Insurance Premiums 387,734 510,000 734,685 734,685 520,200 Insurance Premiums-2014 portion (239,980) (239,980) Property Claims/Deductibles 12,796 24,684 24,684 25,178 Other Expenses 16,592 23,951 14,354 23,951 24,115 Total Expenditures 417,122 558,635 509,058 543,340 569,493 Net Income 36,585 3,920 (87,164) 19,215 (1,313) Working Capital 141,317 145,237 54,152 160,532 159,219 33 62 \ \ � \ � ) \ \ \ \ J \ \ \ ( \ \ \ \ \ \ \ \ \ \ \ \ ( ( ® \ \ \ \ \ 7 ( ( ( ( § REEK 7 f \ fK § f \ f ( ( f & tK 7 \ \ ) ) { ) \ { \ ea } ) 7 : Z2 \ \ W M10M K & \ K ( ktf \ \ \ \ \ \ ( ) ( } } \ \ \ \ \ \ \ \ } } \ \ \ \ \ \ \ k \ \ \ > > ! ! ! ! ) \ 64 \ r f { \ \ \ ( \ \ \ \ / \ ) ) \ W1m } u u 7 \ \ ) ) { ) \ { \ e5 § ) ) 9 f { \ \ k \ § \ \ \ \ \ ) \ \ { \ } { \ \ \ ) \ ) } wc \m m ¥ ` \ } \ ) ) ! \ ) \ ) ) ) ) ! ! ! ! r 66 N y c a m o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O L C OI O r r M T (O r M T N OJ y V V V M O N (O OJ V N (O O N O a O (O N OJ M M T OJ N N N N r N (O OJ N (O (O N r r OJ V N M O N V N (O (O N N fV (O O r T O N OJ N OJ O V M O N 'N m aI O O O OJ N O � T O (O O O OJ O O r OJ T V N r T T O OJ T W T M > a fY d N N N m OJ m T N N N r M r N 0 OJ r N N r N O r r O m (O M r V O m OJ M M mO O N N r M O M OJ O N OJ V M O V r T (O O V OJ T (O T O O r r OJ Cl! N O N M V M r M � N N W W N W (O (O V (O V OJ Cl! d O N r OJ N N OJ OJ (O N (O M O O O O OJ OJ OJ M V O r (O (O V O V W O O m W r M N r T M (O T M V O M M V M OJ T V M N V M (O V N V (O W N l0 V L N N OJ r N (O M N V V N (O (O OJ (O (O M V N V O O T r N H O M M N O N O M r M M r r c r N N M T N (O N O N l0 N V < < V M = I Q o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C N N V N M N V N OJ N N V fV (O (O (O N M O V O OJ V r (O N W y d V (O (O M T M N T (O M N N O T OJ M V M OJ OJ N OJ r Iz a c p� r r N (O (O O O T T T M T T r O O T r N N (O N (O T (O r OJ T OJ r (O r r M (O O W r (O OJ N (O OJ N r V fV aaM gal c c � V d d d O O O V W W (O V V M (O O W N M M OJ W W (O W W W M M N M N N OJ fV r N N N a � y x M O T N N T OJ O N V V N OJ V r V M V N M (O V M Q (O l0 N N M M N OJ O V N (O N OJ M � N r N r M OJ V V O (O N W M OJ OJ O O V (O r r W N OJ W r V m OJ W m M O N W N V N O O O (O O r (O N T T r r T O O N M N (O OJ r (O N (O N N O co m OJ O O O O OJ V M OJ r N N V � M N OJ (O N (O OJ M r N W r ml I I I I Id I N a c o d (7 m y d d u c d c m m li c x d y y a £ N 'o o f — u w d m a m a�i E c m d d of o o d c d '� k d u x O m of o co d O d a c m O N � d � Od d U c d O Q o OH Dd a d m cdi d t c y o u a ° d o ,(? m m w a m 0 - U ii 2 z O m Q U U x � U x a a m w o a K m 'm m 38 m a c oI ¢ w r 67 N N y v y o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o � c rn co co rn o co �o o rn rn o ro M r rn v co ro o 0 o M M v O V V � r T O N l0 O T N N N OJ W V M N T fV N fV N N r N V M OJ T N N O N r N (O V V OJ r OJ N l0 OJ OJ V V W N d m O O T OJ T M W O O OJ W T T W OJ (O T r OJ T W OJ Y O d c a' � o fY d O a M O r OJ N N l0 N r N N (O OJ N O N N O OJ OJ N fV ClIfJ O O O OJ (O T l0 r OJ l0 N (O cl (O N N OJ cl V V (O l0 W OJ W M � (O M � W � M N OJ V M O N M N fV Yal r M N (O O O r (O T M OJ T N T (O N V O fV O O T W l0 fV OJ N M N O N (O OJ CO c (O N c O O O V l0 r r O O _ c O O N W W m OJ m l0 ID (O CO CD OJ IQ OJ (O r V V CO � N O N N r T r N � m O V (O OJ (O M M r (O l0 V V N OJ (O N fV N N � N M N N � M OJ M W d 'G O W � N fV c l0 � a c d a a a a a a e a a a e a a e a a a a e a e a e e a C N O O N V N V N O T T fV M N M r O N OJ W N N O O O d a O N M r N V r O V (O l0 V � fV M N T T l0 (O l0 V V M d T O O (O V (O N T N N (O O M (O M M M M r i y a N r r r (O r N r r r (O r r r r (O N r N l0 r r l0 � I C jp N M M r O W V N W N N N l0 O O _ 0 M p] V M r OJ N 1 m N W V 0 V 10 IfJ O r N N r N r N C M K 'O (O M W M N O W V O M N m — V V M M O N N oc l0 Q O V w O N M Co M M fY d V i N aw c c M O2 r M OJ l0 T W (O l0 OJ fV r d Y r d (O (O O (O r O r T (O r V O N w , O , V OJ O O N fV l0 N N OJ OJ (O V W O N m M V N V O fV V V O W M O V d y N O N W N N W M M W M N r O O m M V r r r M M r l0 x � V M T y m N N (O M W O N mV rn � rn V O O O O t0' W t0 t0' � O Cl' N' � W M O N W (O MM W W N N fV N V OJ N r V N O W (O M N r (O (O r O (O l0 V V W N V r N M W O l0 N O (O W O OJ M O (O W N W V V O O W r T N N M O O r OJ OJ M W r T l0 (O OJ O r fV V V T W N � N � (O M r M V N r OJ r l0 O N r r M N 10 V r O OJ V N l0 O r r OJ T M N OJ M M N fV (O M l0 = M N M N N T O M CoM N mI I I N d u U U U y O E T O LO E U y £ U j d y £ O £ d d y O m o o o 05 N d O 05 d a�i aoi d a ^tl o N d c Y p d c d m o Y N ¢ aoi ao aoi U > > cdi 07, w m i a O m U m m 0 d F o N Z w d U d a d m m o m ac 0 p f � d N m w D m m 'Q d d a 9 9 o C o b m N m 39 m v � of � w` 68 � c o00000000 000 0000000000000000 O = = m O r N r V O N M T IfJ (O W T O OJ T IfJ OJ N (O OJ r OJ O N (O O a O O OJ (O � O OJ OJ N IfJ V M N IfJ � OJ O (O O (O (O N IfJ N V fV (O V O IfJ N N (O � (O (O N M M N N OJ IfJ (O (O OJ N OJ O I� W IfJ IfJ M Y a fY d m � M M OJ I� r OJ (O (O OJ N N OJ O N c M N O r (O IfJ IfJ M r O r (O r OJ M (O N (O (O � OJ � M T M M N V IfJ O IfJ M O N (O OJ O T OJ M IfJ V M M W N V O d V V O V O M O N IfJ (O W O M OJ V OJ V O < < O I� IfJ OJ N (O N I� M a C O O V N M T I� (O IfJ OJ r N O r l0 M M T M M M r V r m m m O M O � O (p (p O N T N I� (O V OJ V M O T l0 IfJ N N (O V OJ � V (O O r N OJ O IfJ N IfJ M I� IfJ OJ M V O (O c IfJ IzJ IfJ T T r V V M (O (O O IfJ V M OJ O IfJ (O N M N IfJ N � W N O � OJ V M W N N I� V O O V IfJ 10 W O H O M M I� M T M r M M r M M (O OJ OJ N (O M N (O IfJ M r N C � OJ OJ O N O IfJ M M M OJ OJ O c d a a a a a a a a a a o 0 o a a a a a a a a a a a a a e a a a C y O O O N O IfJ O I� N N M N N OJ V O O (O M (O IfJ � T d a N I� OJ � O OJ IfJ OJ (O I� T O l0 N OJ � T N O O IfJ IfJ (O T V IfJ W I� O y d N V OJ I� N O T M N T (O N M T (O M (O IfJ N V M r O OJ l0 T y N O ifJ I� r t0 T r W r r V r r t0 r W ifJ ifJ t0 V N ifJ r t0 ifJ t0 t0 r r a c O � p� I� r N N OJ IfJ V r M T M T T M l0 N O V M N IfJ � (O T O IfJ O T r r T N C a M M IfJ (O N � N N IfJ IfJ M IfJ T T T V I� O IfJ O M T r V V c N N N I� C d N d C C M d X y i x d 'c c W a > O y £ M M (O (O N M N I� V O O y IfJ N IfJ IfJ T T r OJ M r IfJ r r OJ N O C m V Q V M OJ r O OJ (O OJ M r r O l0 IfJ M O W OJ N M V N m c r N d w d O m m O O � W r r V OJ (O O W IfJ N � � V � O � OJ mM M IfJ � r OJ V N IfJ � (O (O (O T T IfJ I� O T N (O c T V V OJ O O (O � OJ IfJ IfJ IfJ r (O (O V V N (O O I� O O IfJ V � OJ IfJ M N O V N M N OJ V y a u W (p T V m OJ V m r r m N IfJ M M O M IfJ OJ T Lo y O V y M N N IfJ m O m m IfJ m cc�w OJ M M I� (; r N O O V IfJ W N I� � IfJ N W W IfJ W OJ I� OJ OJ O (O M (O OJ � I� O V IfJ OJ OJ O N W W N r M V I M V V M V O M IfJ y M O V N V M l0 N N ifJ N N yl (O (O OJ OJ O OJ (O 8 O N N N T V (O IfJ W O M O O V (O IfJ V IfJ IfJ T I� r T (O l0 (O OJ (O M OJ IfJ N (O T N M N V O O O O r N (p O I� M (O _ O r T (O N IfJ IfJ IfJ (O IfJ V N� M M N IfJ IfJ N I� OJ � M O r IfJ N � r N O (O r M IfJ � (O OJ M mfV N � I I I I Id I N a c m a c a�i v, c m o cdi p w d c o m F N d d of o o d c d � k d u x of c y o d a r c m m 05 F F y p aNi of = a�i A m o O d o d = U 05 o O p d d c a a d 2` d o m rn K m d a>i D 0 1D - U ii 2 z O m Q U U x ii U x a a w p a ii 40 m m a oI ¢ w 69 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O = = m IfJ 0 0 y OJ r r f V V OJ O M M M Cl � OJ W V r N M IfJ M (O T V IfJ N O Y O G c o' � o fY d W � O M N M OJ r OJ O IfJ l0 OJ O V r W IfJ N M fV O a O (° IfJ T V OJ V fV M V OJ (° O M IfJ l0 N N l0 IfJ N N O O T N r N V r r W M M N OJ r (° l0 l0 O W � O W r M r W y t° ifJ N N r N N d � N � � M � � M OJ W Yal M MO OJ C fV V OJ fV M T r N (° T N T W OJ M N V O M O fV M N O T V l0 O O O N O IfJ W O OJO N l0 N H O N V M r O IfJ M W T O O� r M O r W V V l0 l0 V V OJ N M M l0 OJ W d 'G O O (V Cl c N x o. c d a a a a a e a a e a a e a a a a e a e e a C y O M M IfJ V c OJ O M M W V O (° OJ O O O fV d a IfJ V O N IfJ y T r OJ IfJ M T IfJ V O OJ V V N d O V r fV m(° V V O N fV IfJ O IfJ (° M M r a N r I� r r N r T r 00 r r r ifJ ifJ r ifJ t0 t0 � I C N C a IfJ O N IfJ N fV M IfJ W r IfJ M T IfJ OJ (° OJ � W r w d = m IfJ N OJ OJ M O m cV M M r m N fV ifJ N W m L6 V r c d p] M M OJ r V OJ O V V N O N M M M M T IfJ V M L m Q K a (p N fV V V N C\ r V V N fV ifJ y O Nl N fV d a � W fV M � fV C d N d w a > > rd N �d.. d LQ V r T M V N l0 T C'J m IfJ O OJ V W N cl cl fV L y+ Q IfJ r (° (° OJ (° OJ V O M M N IfJ N T W T W fV V V d N r V N(° OJ O M IfJ m W IfJ N N r N fV W M O M M l0 IfJ (° V O N O N y r" ci � � r u K V O OJ M � IfJ (° fV M O fV (° OJ OJ O M O O fV O W M rJ N T I OJ V M V m O V O m O O O cl W y r r (° IfJ l0 M OJ fV N OJ N T OJ T O O O W OJ W t0 O t0 N' W O V N' W W V N' ifJ N' O' r W W 00 N M (° MO M OJ N N l0 N IfJ O (° r O l0 V N N (° N N c r OJ y r OJ V r O OJ V N (° M M fV O M r O V (° O N O r l0 N IfJ M O T l0 N OJ M (° O IfJ OJ O r fV T W � d O M M O y V c N v M N N r V V O O fV V r OJ � W T OJ N M M (° l0 l0 mI I I I y I d u I � U U U d _ y E T m p E u y c 5 d y m ._ 'm d d ° U 5 cdi w m i a m U m m F o N m o d a L L H d U � c � x z U y N U d U _ N _ Y d ° O U7 d A ° ° N F d A y y y N y O C c Fa o- a` rn o aN nO' O J Q] d aU sU ain ain fo d N D D N N Wcy O d NOl c y y 47 a v N 70 M � N o 0 0 0 0 0 0 o e o e o 0 o e o 0 o e o o e o 0 O C c G7 O T M M N M O N O N N O O M O r A T M T N � W O ? m 9 T N N A M (D T fD CO O (D O M E N I� O o N ry O a a V V V N N T N (D V O O (D C M M V V M m N (D M T N M 1 N M D V (D O (D N Lo � � M N M N � } O (D (D N V N V (D CO M O) M (D M Cl! M N � O � O_ M N N N O M V V T N I� fD N T V fD V M A M N C0 N N (D rc a � o. o 0 0 0 0 0 0 0 o e o v o 0 o v o 0 o v o o e o 0 C co N N CO V A N N N V W O N M N V N N a c a N N N M O V N T M M V O O O (D N N O N V M O M V O O N M ,O T T M LL N O N d a c d o ° d x y C a a c C > > `o > a�i N a ad. O O M N r M M N O N N O O O M N O fD O N N M T O A r r V A K U W O T O O N N N I� N Cl! M N N N N N N V V M N N O M r (O A r A T M M (D O N (D N I� A O (D fD M M N N r T fD N N d (D V N V T W N (D N (D N T T V T (D O N T O M N fD O O T O (D fD M (D (O M M O M M O 0 T O N N N N V O O N O V N N N (D N V M N W N O � � 0 (D O I� r M O T V ON N r N (O Co N r r N N r lc O N C N N M N N N 10 m � d C C d U U U 00 N N (n U) N c > 5 �` m E ° E O °' m O V) so m m m " m m fD w 0 d '^ u m m 0 vai 0 y w o, m 0 0 c c o c o m c m c m x 0 0 0 d E w > > w UM .� 10 .0 F w d F 0 0 O w 0 'u O a� (� C a O a 0 0 d f d U E 2 d O LL N O N N C O O Oco in y y U U N O in i 0 Ot X X yp LL C C N N O N O O N N N d N N N o O C K C mT F 8 0 N LL 'O ? LL d F F F L F Q a d OI C ow _ L N N N VI L_ 7 7 L_ U 0 L N N L C ¢ d a E O N N m LL (n j U = (J LL O O w Q C = Q d J J a a a a 0 x 0 0 N N N N A2 N p 0 > O O O x O Q F F f W N I 71 {y N N e e O C C G7 V N fD A N N m th V } O O o N_ ry m � M N I� ty Ip O a a M N N C C O N N U V N NCI r a c m M o M a O N fD I� c O N N 0 O_ N A N N G N N h rc a c d e e a d co ry m d N N Cl a � l rc ml > m ai ai Balm LL O N d N d a x y C a a c C > > O > N N N A c d a K p d m m A U x N O v�i m U W O V A D o `O M O N V A O y cl D N N E r d N co V N N A D O m A Im fD W lc O V ml I I I I IE I � a c � o � IZ � U c c x m a a rc ° c 43 0 w M 72 N o 0 o e o e e N V V V W O ? V It fD M M M } O O o N_ ry O a a N N N N O O O V (D O (D M (D fD fD N W O O N T N CO M M M N N M N (D A M M M M i a (D V M O O A M N N I� A O O O fD O C (D N N M T W W W C N CO rc a c a y a m (D v v a v a a o > m ` of v M aS M aS aS o m m a a r m � Inai ai N N a U N N n C LL ' M %y d a a C C U y UM d N N N T N M V OV M N > N N (D N N M_ O O I� U 0 U I� r m N V m V V 0 O O V Cl! (D N N N N 0 O N N V N N N N M M N O (D fD V V V N ry M V V N N N N a ai ai c m d N N N N V N cc T A A M N N T (D M(D T W W M N N N O N O O O N M V V V A 0 M T M c N N c mI � � I I I I I y C I d E C C N Ua O O cl N C J LL U N j N N Z N O OI N F N N N ate. U O C N m C J N N 0 O C N I � T d a A m ii a` U N K 0i > wa 4 ° 0ff ¢ a w N 73 N � N o 0 0 0 o a o 0 o e e O C C G7 N (0 N O V N O r N N W O ? N N N O It O (D N o N_ ry N N N V I� V N r N V O M M A A fD cO M o cO v m m cO m m v a N M m o v m m r N o v a N CO N V N N N V V rc a � C N O (D N O M W N N N 9 O (D (D V O CO CO CDR R d N a a C LL O M N % V V T N V O V CO M T M O A A A (D N N T O N M M M ry M I� T M V V N M A A fD N M M (D fD T N M M M N N N O V IQ V N N I� N N N fD V V T V N O N T N N O O V N U O U N U i N N N in C N N J U E U) O N N C N m N N �A >O VNI VNI N C W O � � m 0 0 N � S C m N > � � O C N O O C "O OI OI N ESP a O. L N J N L O O O. N 7 'p L L_ L_ % m N N 6] LL S U Z C a O O W C N 0 N N N N O. 45 N L K N > O O O % O C 0 Q F F f W f W N 74 o � o 0 0 0 0 o a o 0 0 0 o e e O C c G7 V O N V o M N m m M V V (D T m N O M (D M T (D N N N } O O o N_ ry O O O N m M V N N M T O M N N A M It m� T O V (D Co V V fD N N r r N N N M a V N N N O d V V N N V V } a M M N N N (D A O (D M N V V N O (p N r Q) (p (p Q) N O N M M M M M I� N M N O (D M O O V N � N M M N N � � N M M I� N C d O M (D O O O o. o 0 0 0 0 0 o e o 0 0 0 o e e C co O M N O M M T r N M M O M r N O T r T M M p� O Iz c a O M N N N N N r O N Mlc A N M M N O M M M N N T M m M N M (D N C y = a a c c aT. M N N M T m V V M G7 J p d M M N m N � I� M O M r N V O (D N N N 3 W r r (D N r O A r N M V r M M M M T T N N V ry m V V T m M (D M M Cl! Cl! M N N V E N M O M M M N m O M M N fq M M O m m M M M O N (D M V N N V O O N m N (D M m M O m V M V O O M m I N O U m `m m `m uci W fD cl F m a OI OI Q a a m c�i `m t '^ ,(? U A m LL 1D - U z O m W c a a a 0 0 W c K ry joz 6 C O Q F F f W f W 75 M c I o 0 0 0 0 0 0 ga r� rMi coo m o m m m o rn N o m m N d m W T W N T 00 00 Y O O M a' I \1 d N O O N M (O l0 N fV fV l0 O a N N rn N (O OJ N l0 (O a a W a c O rn cNo rn V V V m W M M T r r M r r r M r o (o (o r r r m N (O N cl V V V w m a d o rn rn ro m ro m m c d a a a a e a e e a c N o rn N o N N (o (o a y N O (moo (r0 (r0 V (r0 (r0 (r0 a j m I O N N N (O (O fV fV M C a M N OJ OJ OJ V M M N d M N N N OJ T OJ r d p] N N r r N -I -I� fV M K a r N O O W W W ° " dl O O r r V N N c d N N (O T (O N Cl! V fV r (O N N fV OJ OJ OJ l0 y r O OJ OJ V V V l0 � (O OJ V V OJ OJ OJ M d N O N fV fV M N O O O M M M O V N N fV N N O N N O W O O O N N r N N r V N r r O mI � � I I I I IU � I N ° i £ � ° d N O A K m a d d F d I0N0 U d a m m ? d c m w = A d o c 2m -O m N N — Y N f d N e m o > m .5 d a m K m 'm m m m c 4r v M 76 N � M o 0 0 0 0 o a o 0 0 0 0 o e e O J C G7 N r N O O N M T M V M M V T O N O N V } O O o N_ ry N N N V N N N V M N I� r M (D V M O fD fD O M M T W � � � } al fD M M N (D N O O (D N (D (D N N A A M It N O N OD M M T N N N N rc a a o 0 0 0 0 0 o e o 0 0 0 0 o e C co N D N O O a � c - N y L a a c C (D M M I� dl N ' I N S E N N N Cl! N M M N W W M N N N O N M O V I� O V T (D V V N N N O M M � O N fD T N N T M M O N N T N (D M N O V N O m N N M mI I I I I I I IN d d N U U O w J U C 0 2 d N N O i O N (n w (1] o U N O w J C d N a C N C C YI U N LL Q F d YI C 'a 6] F O N LL N N N N > O C N O O OI 21 (�.� N N j N .J- (Cp U N N ~ a m O. N 6] LL S U O O Q C LL S LL a O O co W C Uffl K ry j x C O I Q F F f W f W 77 ooe 00000e e O C c G7 N N A r N O N N N w 0 ? N N A N N I� (D r M M A d m m m m v v m m r m m } 'o `o o N_ ry N O O O O O I� M N T V V fD J C (p (p O O y V M N N N N O W N N N N O (D (D (D T W } ° Ia` co co m m M co m m m m o O (D (D fD (D V N M (D M M N N c0 d M M M N M M rc a a l o 0 o e o 0 0 0 o e C coo v v v (O M m Ce Ce d a o co co N ry ID N M CD d N i O I� r M OM M (D (D M fD fD a ry J (D (D C M N N O V V M D fD A t2 M � " I y LL a d c C d a > > O m m y co o � U 0 x N ao M M aS o o m m m O (D (D (D (D N M T N V V cc A N C W 0 N N N N V N Cl! I� MM N O � I V V T T M N N V M N N N O O N N N N T N N (D N N N (D (D M M A M V M N M M � N N M M N V N V O N A A fD ? T T (D (D N S O N V c O ml � � I I I I I N U CO fn N > E N m N J 0 U U U C O N C C C N J U J N N E J d J LLo O O N N E O C O 0 C a d N aJ. E 0 O m c � � 49 A c d > o 0 o x o c o � Q w w R55JCO21 City of Kent 10/29/201:7$05:33 Fiscal Year: 13 Period: 9 Street Capital Projects Fund Page - 1 Budget Prior Years Fiscal YTD Prj to Date Variance % Beginning Fund Balance 12,936- 10,188.78- 10,188.78- 2,747.22- 78.76 Fund Balance Adjustments 2,747 2,747.00 Intergovernmental 33,542,388- 30,158,196.82- 185,975.97- 30,344,172.79- 3,198,215.21- 90.47 Charges for Services 72,963- 93,702.69- 8,722.18- 102,424.87- 29,461.87 140.38 Miscellaneous Revenues 24,750,338- 16,312,401.88- 369,153.19- 16,681,555.07- 8,068,782.93- 67.40 Non Revenues 10,457,804- 10,482,432.31- 10,482,432.31- 24,628.31 100.24 Other Financing Sources 25,855,591- 26,278,410.80- 26,278,410.80- 422,819.80 101.64 Operating Transfers In 11,586,237- 6,438,236.35- 825,000.00- 7,263,236.35- 4,323,000.65- 62.69 Total Available Resources 106,275,510- 89,773,569.63- 1,388,851.34- 91,162,420.97- 15,113,089.03- 85.78 Unallocated Street Projects 15,783 41,096.00 41,096.00 25,313.00- 260.38 Street Mitigation Receipts 438,923 438,923.00 Street Light Wiring Upgrade 120,000 52,817.03 52,817.03 67,182.97 44.01 Street Light Repair 150,000 13,912.99 13,912.99 136,087.01 9.28 Misc Intersection Signals 200,000 124,788.87 124,788.87 75,211.13 62.39 Pedestrian Walkways 356,460 415,951.98 415,951.98 59,491.98- 116.69 Kent-Kangley Pedestrian Improv 414,997 54,391.01 29,487.36 83,878.37 331,118.63 20.21 Railroad Quiet Zone 52,807 4,727.37 4,727.37 48,079.63 8.95 108th &208th Intersection Imp 41,813.86 38,878.42 80,692.28 80,692.28- Asphalt Overlays2009 6,043,099 1,238,230.38 1,066,493.17 2,304,723.55 3,738,375.45 38.14 Sidewalk Renovations 2008 1,902,871 1,495,636.62 1,495,636.62 407,234.38 78.60 Kent Station 3,693,318 3,989,621.32 3,989,621.32 296,303.32- 108.02 Downtown ITS Improvements 4,779,960 4,967,276.42 4,967,276.42 187,316.42- 103.92 84th Avenue Rehabilitation 7,379,096 7,020,311.73 8,155.81 7,028,467.54 350,628.46 95.25 Lincoln Ave/Smith St Improv 765,012 857,746.02 13,247.54 870,993.56 105,981.56- 113.85 256th Street-116th to 132nd 58,000 58,000.00 BNSF Grade Separation 19,877,044 19,741,812.17 25,460.01 19,767,272.18 109,771.82 99.45 Military/Reith Intersection 30,031 30,031.01 30,031.01 .01- 100.00 272nd Extension (KKto 256th) 7,575,417 6,661,515.76 4,808.84 6,666,324.60 909,092.40 88.00 Willis St UPRR/BNRR Grade Sepr 881,627 240,077.46 278.22 240,355.68 641,271.32 27.26 James Ave Impr(4th to UPRR) 2,909,838 2,885,959.66 2,885,959.66 23,878.34 99.18 256thlmps(KentKangley-116th) 2,315,358 801,403.66 465,462.64 1,266,866.30 1,048,491.70 54.72 212th UPRR/BN Grade Separation 116,972 17,386.88 17,386.88 99,585.12 14.86 LID 353 224th-228th Corridor 30,861,440 32,153,548.82 60,020.32 32,213,569.14 1,352,129.14- 104.38 224th-228th Corridor East Leg 11,293,362 1,857,313.29 60,491.76 1,917,805.05 9,375,556.95 16.98 196th Street-East-Mitigation 501,726 822.58 822.58 500,903.42 .16 East Hill Operations Center 3,542,369 1,539,948.78 33,836.89 1,573,785.67 1,968,583.33 44.43 72nd Ave Imps(S.196th-200th) 61,456.04 38,246.28 99,702.32 99,702.32- Total Expenditures 106,275,510 86,295,684.72 1,858,780.25 88,154,464.97 18,121,045.03 82.95 Ending Balance 3 477 884.91- 469 928.91 3 007 956.00- s0 R55JCO21 City of Kent 10/29/201:7$05:22 Fiscal Year: 13 Period: 9 Parks Capital Projects Fund Page - 1 Budget Prior Years Fiscal YTD Prj to Date Variance % Beginning Fund Balance 21,007- 21,005.82- 21,005.82- 1.18- 99.99 Intergovernmental 2,832,832- 2,226,664.78- 479,411.51- 2,706,076.29- 126,755.71- 95.53 Charges for Services 43.84- 43.84- 43.84 Miscellaneous Revenues 1,329,899- 1,166,172.26- 317,277.57- 1,483,449.83- 153,550.83 111.55 Operating Transfers In 3,219,242- 2,519,433.79- 224,809.17- 2,744,242.96- 474,999.04- 85.25 Total Available Resources 7,402,980- 5,933,320.49- 1,021,498.25- 6,954,818.74- 448,161.26- 93.95 ARRA-Comm Putting Prev.to Wk 111,504 111,504.38 111,504.38 .38- 100.00 Parks FIL 199,809 199,809.17 199,809.17 .17- 100.00 Regional Trails/KC Levy 776,549 377,481.00 722.00 378,203.00 398,346.00 48.70 Boat Launch Fees 32,432 3,617.44 2,630.83 6,248.27 26,183.73 19.27 Lake Fenwick 141,849 113,330.69 14,997.17 128,327.86 13,521.14 90.47 Paths and Trails 132,243 81,433.65 1,935.67 83,369.32 48,873.68 63.04 Adopt-a-Park Program 498,050 454,577.60 12,747.33 467,324.93 30,725.07 93.83 Street Tree Replacements 127,603 97,255.77 9,815.00 107,070.77 20,532.23 83.91 Rental Houses Demolition 162,730 169,553.75 169,553.75 6,823.75- 104.19 Big Blue Mobile Computer Lab 45,000 13,044.22 13,044.22 31,955.78 28.99 Light Pole Replacement 671,792 394,581.46 50,000.00 444,581.46 227,210.54 66.18 Eagle Scout Projects 179,861 173,850.46 27,820.86 201,671.32 21,810.32- 112.13 Multi-use Ballfields/KSD 70,000 72,946.46 50,000.00- 22,946.46 47,053.54 32.78 Earthworks Stairs 229,368 226,697.45 226,697.45 2,670.55 98.84 Park Lifecycle Program 1,125,672 429,142.14 239,453.89 668,596.03 457,075.97 59.40 Kent Loop Trail 120,000 9,187.82 9,187.82 110,812.18 7.66 Urban Forestry Plan 354,528 272,395.05 51,356.43 323,751.48 30,776.52 91.32 Community Parks Reinv. Program 186,909 186,909.00 Parks Land Acquisition 2,013,332 1,183,867.23 394,000.22 1,577,867.45 435,464.55 78.37 Senior Center Memorial Gift 103,749 103,749.00 Green Tree Park Renovation 120,000 120,000.00 Total Expenditures 7,402,980 4,175,278.75 964,476.39 5,139,755.14 2,263,224.86 69.43 Ending Balance 1 758 041.74- 57 021.86- 1 815 063.60- 51 R55JCO21 City of Kent 10/29/201ZQ05:19 Fiscal Year: 13 Period: 9 Other Capital Projects Fund Page - 1 Budget Prior Years Fiscal YTD Prj to Date Variance % Intergovernmental 78,600,000- 63,575,208.71- 63,575,208.71- 15,024,791.29- 80.88 Miscellaneous Revenues 179,938.99- 307.86- 180,246.85- 180,246.85 Non Revenues 10,242,533.86- 10,242,533.86- 10,242,533.86 Other Financing Sources 17,000,000- 27,840,000.00- 136,878.42- 27,976,878.42- 10,976,878.42 164.57 Operating Transfers In 7,320,463- 7,356,022.94- 7,356,022.94- 35,559.94 100.49 Total Available Resources 102,920,463- 109,193,704.50- 137,186.28- 109,330,890.78- 6,410,427.78 106.23 ShoWare Center Marquee 225,000 209,244.96 209,244.96 15,755.04 93.00 Event Center 85,695,463 80,422,813.44 80,422,813.44 5,272,649.56 93.85 Kent City Center Garage 136,513.57 2,077.74 138,591.31 138,591.31- LTGO Bonds 2008 17,000,000 16,762,887.05 219,899.29 16,982,786.34 17,213.66 99.90 LTGO Refunding 2012A&B 11,375,365.13 2.00- 11,375,363.13 11,375,363.13- Total Expenditures 102,920,463 108,906,824.15 221,975.03 109,128,799.18 6,208,336.18- 106.03 Ending Balance 286 880.35- 8478875 202 091.60- 52 R55JCO21 City of Kent 10/29/201Z1:04:56 Fiscal Year: 13 Period: 9 Technology Capital Projects Page - 1 Budget Prior Years Fiscal YTD Prj to Date Variance % Miscellaneous Revenues 1,283- 1,283.42- 1,283.42- .42 100.03 Operating Transfers In 8,228,129- 6,836,142.45- 770,714.45- 7,606,856.90- 621,272.10- 92.45 Total Available Resources 8,229,412- 6,837,425.87- 770,714.45- 7,608,140.32- 621,271.68- 92.45 Software Lifecycle Replacement 321,605 321,605.07 321,605.07 .07- 100.00 Hardware Lifecycle Replacemnts 1,848,973 1,700,129.82 31,123.26 1,731,253.08 117,719.92 93.63 IT Systems 2,170,651 2,049,260.48 123,851.60 2,173,112.08 2,461.08- 100.11 IT Tech Services 2,182,806 2,182,806.60 2,182,806.60 .60- 100.00 IT Multi Media 27,339 27,338.64 27,338.64 .36 100.00 Long Term Lifecycle Replacemts 68,135 68,135.00 RAIN 10,645 10,645.00 ALPR 98,505 98,505.00 Scanning System 96,350 96,350.00 Desktop Virtual Machine/DVM 50,000 49,033.50 49,033.50 966.50 98.07 Desktop/PC 120,000 109,601.36 109,601.36 10,398.64 91.33 Monitors 38,000 22,131.05 22,131.05 15,868.95 58.24 Blades/Servers 55,500 10,660.96 10,660.96 44,839.04 19.21 Station 74 Power 224,700 8,565.00 8,565.00 216,135.00 3.81 North-South Fiber Run 20,000 20,000.00 Conn Community-City of Kent 6,000 6,000.00 System Services 38,388 38,388.00 Tech Services-Security 51,450 51,450.00 Storage-Enterprise 189,050 24,106.43 24,106.43 164,943.57 12.75 CH Service Center Renovation 202,000 76,528.38 76,528.38 125,471.62 37.89 Telephony 323,200 275,558.90 275,558.90 47,641.10 85.26 Multimedia-Chamber-Audio 23,815 23,815.00 Chamber-Video/Editing 27,820 27,820.00 Chamber-Broadcasting 25,150 25,150.00 Chamber-Projection 9,330 9,330.00 Total Expenditures 8,229,412 6,281,140.61 731,160.44 7,012,301.05 1,217,110.95 85.21 Ending Balance 556 285.26- 39 554.01- 595 839.27- 53 R55JCO21 City of Kent 10/29/201Z2.04:45 Fiscal Year: 13 Period: 9 Facilities Capital Projects Page - 1 Budget Prior Years Fiscal YTD Prj to Date Variance % Intergovernmental 1,167,658- 1,167,658.01- 1,167,658.01- .01 100.00 Operating Transfers In 7,710,264- 7,657,552.24- 52,711.76- 7,710,264.00- 100.00 Total Available Resources 8,877,922- 8,825,210.25- 52,711.76- 8,877,922.01- .01 100.00 CKCF Improvements 1,167,658 85,473.43 85,473.43 1,082,184.57 7.32 Aukeen Court Expansion 7,635,264 7,546,846.75 50,922.84 7,597,769.59 37,494.41 99.51 Security Camera Software Upgrd 40,000 40,000.00 Parks Maintenance Renovation 35,000 465.00 465.00 34,535.00 1.33 Total Expenditures 8,877,922 7,632,785.18 50,922.84 7,683,708.02 1,194,213.98 86.55 Ending Balance 1 192 425.07- 1 788.92- 1 194 213.99- 54 R55JCO21 City of Kent 10/29/201ZB04:33 Fiscal Year: 13 Period: 9 Water Fund Page - 1 Projects Only Budget Prior Years Fiscal YTD Prj to Date Variance % Beginning Fund Balance 193,927- 193,926.30- 193,926.30- .70- 100.00 Intergovernmental 581,522- 591,020.75- 591,020.75- 9,498.75 101.63 Charges for Services 1,764- 4,238.36- 91.32- 4,329.68- 2,565.68 245.45 Miscellaneous Revenues 771,649- 2,883,509.32- 24,897.90- 2,908,407.22- 2,136,758.58 376.91 Non Revenues 43,055,889- 43,055,888.33- 43,055,888.33- .20- 100.00 Other Financing Sources 2,500,903.04- 2,500,903.04- 2,500,903.04 Operating Transfers In 41,315,606- 38,615,607.00- 245,338.00- 38,860,945.00- 2,454,661.00- 94.06 Total Available Resources 85,920,356- 87,845,093.10- 270,327.22- 88,115,420.32- 2,195,064.15 102.55 Seismic Vulnerability Assess 752,158 752,570.88 752,570.88 412.88- 100.05 Water Comp Plan Update 2007 693,311 681,150.83 681,150.83 12,160.17 98.25 2009 Revenue Bonds 73,357 97,591.78 97,591.78 24,234.78- 133.04 Water Conservation Plan 475,193 488,736.29 3,787.64 492,523.93 17,330.93- 103.65 Water Unallocated Projects 2,454,662 2,454,662.00 Rock Creek Mitigation Projects 735,000 47,907.50 158,993.27 206,900.77 528,099.23 28.15 Guiberson Reservoir Repair 3,678,847 179,378.31 145.46 179,523.77 3,499,323.23 4.88 Tacoma Intertie 44,485,507 39,464,797.37 39,464,797.37 5,020,709.27 88.71 Clark Springs Tran Main Repair 1,327.25 4,245.30 5,572.55 5,572.55- Clark Springs Well#2VFD Repl. 9,748 9,748.38 9,748.38 .38- 100.00 Seismic System Controls 78,783 78,783.00 Corrosion Control 2,740,623 2,740,625.65 2,740,625.65 2.65- 100.00 Pump Station#3 Replacement 2,008,534 108,751.41 108,751.41 1,899,782.59 5.41 Kent Springs Source Upgrade 627,779 319,284.46 319,284.46 308,494.07 50.86 Kent Springs Trans Main Repair 506,528 8,601.49 8,601.49 497,926.51 1.70 Misc Water Improvements 5,640,752 4,794,040.90 55,633.69 4,849,674.59 791,077.41 85.98 Additional Water Source Dev 1,470,476 1,056,022.10 1,056,022.10 414,453.90 71.81 Well Head Protection 431,384 179,657.18 179,657.18 251,726.82 41.65 Security Improvement per VA 70,000 14,655.70 3,074.51 17,730.21 52,269.79 25.33 East Hill Pressure Zone 4,703,686 91,366.12 305,224.80 396,590.92 4,307,095.08 8.43 Impoundment Reservoir 2,226,286 2,126,345.44 16.34 2,126,361.78 99,924.22 95.51 SE 248th Watermain 355,936 365,417.08 365,417.08 9,481.08- 102.66 West Hill Reservoir 50,000 50,000.00 East Hill Reservoir 4,944,304 4,925,156.78 1,254.63 4,926,411.41 17,892.59 99.64 East Hill Well Generator 735,000 36,127.30 240,239.76 276,367.06 458,632.94 37.60 Clark Springs Source lmprvmnts 574,278 41,871.57 41,871.57 532,406.43 7.29 Landsburg Mine 600,000 258,952.53 6,525.26 265,477.79 334,522.21 44.25 Clark Springs HCP 212,722 222,221.43 986.18- 221,235.25 8,513.25- 104.00 Hydrant Replacement 2005 90,043 50,481.88 2,822.24 53,304.12 36,738.88 59.20 Large Meter/Vault Replace 2008 180,341 130,305.32 15,841.15 146,146.47 34,194.53 81.04 Kent Station -Water 109,198 109,197.68 109,197.68 .32 100.00 Downtown ITS Improvements 233,131 233,131.16 233,131.16 .16- 100.00 84th Avenue Rehabilitation 298,660 298,659.62 298,659.62 .38 100.00 Remote Telemetry Upgrade 459,575 469,074.41 469,074.41 9,499.41- 102.07 55 R55JCO21 City of Kent 10/29/201Z404:33 Fiscal Year: 13 Period: 9 Water Fund Page - 2 Projects Only Budget Prior Years Fiscal YTD Prj to Date Variance % BNSF Grade Separation 205,000 777,124.00 777,124.00 572,124.00- 379.08 272nd Extension (KKto 116th) 303,759 303,759.61 303,759.61 .61- 100.00 Scenic Hill -Water 413,141 413,324.31 413,324.31 183.31- 100.04 LID 341-196th Corridor Mid 194,003 194,002.60 194,002.60 .40 100.00 LID 353 224th-228th Corridor 155,901 155,900.56 155,900.56 .44 100.00 East Hill Operations Center 1,467,413 1,467,572.24 1,467,572.24 159.24- 100.01 Lower East Hill Improvements 475,338 475,510.59 475,510.59 172.59- 100.04 Total Expenditures 85,920,356 64,090,349.71 796,817.87 64,887,167.58 21,033,188.59 75.52 Ending Balance 23 754 743.39- 526 490.65 23 228 252.74- 56 R55JCO21 City of Kent 10/29/201Z504:08 Fiscal Year: 13 Period: 9 Sewerage Fund Page - 1 Projects Only Budget Prior Years Fiscal YTD Prj to Date Variance % Beginning Fund Balance 488,467- 488,466.98- 488,466.98- .02- 100.00 Intergovernmental 21,250,778- 16,132,766.72- 4,647,737.33- 20,780,504.05- 470,273.95- 97.79 Charges for Services 4,000- 295,965.02- 45.66- 296,010.68- 292,010.68 *****- Miscellaneous Revenues 743,652- 882,853.34- 19,180.92- 902,034.26- 158,382.26 121.30 Non Revenues 12,786,845- 12,786,844.80- 12,786,844.80- .20- 100.00 Other Financing Sources 1,500,000- 1,500,000.00- 1,500,000.00- 100.00 Operating Transfers In 52,208,407- 41,716,761.79- 5,241,635.87- 46,958,397.66- 5,250,009.34- 89.94 Total Available Resources 88,982,149- 73,803,658.65- 9,908,599.78- 83,712,258.43- 5,269,890.57- 94.08 NPDES Permit 3,667,335 2,730,172.56 88,003.48 2,818,176.04 849,158.96 76.85 Drainage Master Plan 1,432,784 1,432,783.98 1,432,783.98 .02 100.00 2009 Revenue Bonds 86,845 97,592.43 97,592.43 10,747.43- 112.38 Green River Flood Protection 3,750,005 3,750,278.60 3,750,278.60 273.60- 100.01 Drainage Unallocated Projects 258,719 258,719.00 Misc Environmental Projects 435,562 732,783.87 7,628.45 740,412.32 304,850.32- 169.99 Meridian Valley Creek 392,681 388,964.86 3,761.58 392,726.44 45.44- 100.01 Hawley Road Levee 2,130,000 513,542.10 935,528.99 1,449,071.09 680,928.91 68.03 Citywide Stm Pipe/Culvert Mtc 4,100,000 3,656,438.45 118,925.88 3,775,364.33 324,635.67 92.08 S. 228th Drainage Bypass 6,950,000 6,253,577.29 47,971.20 6,301,548.49 648,451.51 90.67 Mill Ck/James St. Pump Station 5,366,670 4,209,785.62 151,885.05 4,361,670.67 1,004,999.33 81.27 Upper Mill Creek Dam 2,435,000 237,340.27 131,463.51 368,803.78 2,066,196.22 15.15 Seven Oaks Pond Imps 2,935 2,934.60 2,934.60 .40 99.99 Lower Garrison Creek 1,122,815 1,158,973.29 1,158,973.29 36,158.29- 103.22 Johnson Creek 700,000 591,921.90 964.85 592,886.75 107,113.25 84.70 Earthworks Overlays 1,196,621 1,180,686.22 59.50 1,180,745.72 15,875.28 98.67 Lake Fenwick Restoration 2009 20,895 9,215.48 13,720.70 22,936.18 2,041.18- 109.77 256th Flume 510,000 439,796.93 439,796.93 70,203.07 86.23 Lake Meridian Outlet 2,718,065 2,717,997.13 25,671.36 2,743,668.49 25,603.49- 100.94 Upper Meridian Valley Creek 80,594 80,593.68 80,593.68 .32 100.00 E Fork Soosette Crk/144th Clvt 97,526 97,525.60 97,525.60 .40 100.00 Meridian Valley Crk Revegetate 800 800.00 800.00 100.00 Big Soos Creek/SE 256th Bridge 225 224.91 224.91 .09 99.96 81stAv So Storm Drainage Impr 150,000 129,958.12 129,958.12 20,041.88 86.64 Surface Water Manual 87,955 87,954.67 87,954.67 .33 100.00 Mill Creek @ James-Fld Protect 600,000 469,093.34 140.26 469,233.60 130,766.40 78.21 Riverview Park 2,390,000 2,101,505.98 34,677.11 2,136,183.09 253,816.91 89.38 Downey Farmstead 550,000 318,200.13 94,900.17 413,100.30 136,899.70 75.11 Bauer Property 310,000 137,691.10 1,990.21 139,681.31 170,318.69 45.06 Mill Crk @ 76th Av-Fld Protect 100,000 30,545.77 30,545.77 69,454.23 30.55 Horseshoe Bend Levee Impr. 14,129,417 10,996,560.39 1,807,366.05 12,803,926.44 1,325,490.56 90.62 Upper Russell Road Levee Impr. 2,353,121 1,083,916.31 293,981.90 1,377,898.21 975,222.79 58.56 Lower Russell Rd Levee-S231 st 600,000 450,916.07 125,579.26 576,495.33 23,504.67 96.08 Lowest Russell Rd-Van Dorens 290,000 211,957.36 37,327.40- 174,629.96 115,370.04 60.22 57 R55JCO21 City of Kent 10/29/201Z604:08 Fiscal Year: 13 Period: 9 Sewerage Fund Page - 2 Projects Only Budget Prior Years Fiscal YTD Prj to Date Variance % Boeing Levee Improvements 4,190,000 2,410,147.19 1,142,435.90 3,552,583.09 637,416.91 84.79 Briscoe Levee Improvements 940,000 570,503.72 1,015,721.75 1,586,225.47 646,225.47- 168.75 Desimone Levee Improvements 900,000 528,062.48 54,632.38 582,694.86 317,305.14 64.74 Green River Sandbag Removal 2,443,541 773,523.15 3,052.25 776,575.40 1,666,965.60 31.78 Signature Point Levee 3,299.14 3,299.14 3,299.14- Misc Drainage 2008 2,388,932 1,591,332.26 63,169.46 1,654,501.72 734,430.28 69.26 Drainage Infractructure Improv 473,379 463,248.62 463,248.62 10,130.38 97.86 Kent Station - Drainage 142,758 142,758.17 142,758.17 .17- 100.00 Downtown ITS Improvements 107,315 158,406.09 158,406.09 51,091.09- 147.61 84th Avenue Rehabilitation 19,644 19,644.39 19,644.39 .39- 100.00 LincolnAve/Smith St Improv 60,000 41,443.50 41,443.50 18,556.50 69.07 Remote Telemetry Upgrade 114,930 114,929.88 114,929.88 .12 100.00 BNSF Grade Separation 993,000 434,964.00 434,964.00 558,036.00 43.80 272nd Extension (KK to 116th) 538,373 538,373.48 538,373.48 .48- 100.00 256th Imps(Kent Kangley-116th) 39,746.51 5,562.25 45,308.76 45,308.76- LID 341-196th Corridor Mid 1,165,295 1,167,076.54 1,167,076.54 1,781.54- 100.15 224th-228th Corridor 2,004,580 1,516,197.43 1,516,197.43 488,382.57 75.64 Russell Road Maint. Facility 313,901 313,898.68 313,898.68 2.32 100.00 East Hill Operations Center 1,465,385 1,465,385.07 1,465,385.07 .07- 100.00 Lower East Hill Improvements 33,072 33,400.54 33,400.54 328.54- 100.99 Sanitary Sewer Master Plan 300,000 290,070.17 7,984.96 298,055.13 1,944.87 99.35 Unallocated Sewer Projects 111,247 111,247.11 111,247.11 .11- 100.00 Kentview Sewer Interceptor 275,044 249,844.91 23,625.85 273,470.76 1,573.24 99.43 Skyline Sewer Interceptor 20,000 6,670.33 2,149.55 8,819.88 11,180.12 44.10 Linda Heights Pump Station 150,000 58,377.15 1,177.30 59,554.45 90,445.55 39.70 Misc Pump Station Replacements 100,000 100,000.00 Derbyshire 50,000 50,000.00 Misc Sewer 2007 6,567,710 5,991,696.26 696.15 5,992,392.41 575,317.59 91.24 Kent Station -Sewer 93,935 93,935.42 93,935.42 .42- 100.00 Downtown ITS Improvements 12,968 12,967.74 12,967.74 .26 100.00 84th Avenue Rehabilitation 233,740 233,740.40 233,740.40 .40- 100.00 Remote Telemetry Upgrade 123,647 123,647.28 123,647.28 .28- 100.00 272nd Extension (KK to 116th) 526,229 526,228.68 526,228.68 .32 100.00 256th Imps(Kent Kangley-116th) 187,859.47 187,859.47 187,859.47- Scenic Hill -Sewer 65,895 65,895.00 65,895.00 100.00 LID 341-196th Corridor Mid 8,738 8,737.87 8,737.87 .13 100.00 224th-228th Corridor 136,400 136,400.07 136,400.07 .07- 100.00 Russell Road Maint. Facility 313,899 313,898.00 313,898.00 1.00 100.00 East Hill Operations Center 1,465,386 1,465,385.00 1,465,385.00 1.00 100.00 Lower East Hill Improvements 1,116,636 1,116,978.22 1,116,978.22 342.22- 100.03 Total Expenditures 88,982,149 69,430,990.32 6,358,258.52 75,789,248.84 13,192,900.16 85.17 Ending Balance 4 372 668.33- 3 550 341.26- 7 923 009.59- 58