Loading...
HomeMy WebLinkAboutCity Council Committees - Operations - 06/04/2013 • KEN T WASH NOTON Operations Committee Agenda Councilmembers: Dennis Higgins * Jamie Perry * Les Thomas, Chair June 04, 2013 4:00 p.m. Item Description Action Speaker Time Pace 1. Approval of Minutes YES 1 dated May 21, 2013. 2. Approval of Check Summary YES Report dated 5/1/2013through 5/15/2013 3. Kent Valley Loop Trail Art Master YES R. Billerbeck 5 Min 3 Plan Contract- Authorize 4. HP I Nu Oz Corporation Goods & YES M. Carrington 5 Min 17 Services Agreement-Authorize 5. Financial Summary Report as of NO B. Nachlinger 5 Min 19 April 30, 2013 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 May 21, 2013 Committee Members Present: Les Thomas, Chair, Dennis Higgins and Dana Ralph The meeting was called to order by Les Thomas at 4:00 p.m. 1. APPROVAL OF MINUTES DATED MAY 7, 2013. D. Higgins moved to approve the Operations Committee minutes dated May 7, 2013. D. Ralph seconded the motion, which passed 3-0. 2. ORDINANCE AUTHORIZING THE ISSUANCE OF THE CONSOLIDATED LID #362 BONDS THROUGH A PRIVATE PLACEMENT. B. Nachlinger recommended the issuance of LID Bonds for LID 362 to reimburse the City for the costs incurred prior to the bonds being issued. The assessment roll for LID #362 was authorized by the Council in June, 2011 with an original assessment of $2,412,942.02. This LID was financed in house until the amount of internally financed LID was enough to issue LID Bonds. Right now, issuing these bonds as a private placement is the best option for the city. D. Ralph moved to recommend to approve the ordinance authorizing the issuance of the LID 362 Bonds and authorizing the Mayor to execute all necessary documents for the issuance, subject to final review and approval by the Finance Director and the City Attorney. D. Higgins seconded the motion, which passed 3-0. 3. REQUEST FOR RECORDS SPECIALIST POSITION IN THE POLICE DEPARTMENT. J. Straus requested that the council approve the Records Specialist position to the Police Department. The records specialist is retiring and the criminal justice budget allows for the position to be filled. D. Higgins moved to recommend adding a Records Specialist position to the Police Department. D. Ralph seconded and the motion passed 3-0. 4. SHORETELITRI-TEC COMMUNICATIONS, INC. GOODS & SERVICES AGREEMENT. M. Carrington presented the agreement with Tri-Tec communications for the council's approval. Shoretel has been selected as the product offering of choice for the city's new phone system replacement initiative. Shoretel utilizes a Value-Added-Reseller model through local vendors to sell, distribute, install and service their products. Tri-Tec communications, Inc. is an authorized Shoretel VAR located in Kent, Washington. D. Ralph moved to recommend the Mayor sign a Goods and Services Agreement with Tri- Tec Communications, Inc. in the amount of $264,222 for the purchase of telecommunications equipment, services, and maintenance, subject to terms and conditions acceptable to the City Attorney and Information Technology Director. D. Higgins seconded and the motion passed 3-0. 2 Operations Committee Minutes May 21, 2013 Page: 2 S. ALLIED TELESIS ANNUAL MAINTENANCE & SUPPORT- AUTHORIZE. M. Carrington presented the contract for Allied Telesis annual maintenance & support in the amount of $41,094. This expenditure consolidates multiple maintenance and support contracts for related network equipment purchased through disparate projects over the last two years. This consolidation will result in cost savings and reduced effort by staff through a single maintenance and support agreement under one consolidated goods and services contract. D. Higgins moved to recommend the Mayor sign a Goods and Services Agreement with Allied Telesis, Inc. in the amount of $41,094 for the purchase of annual maintenance and support, subject to terms and conditions acceptable to the City Attorney and Information Technology Director. D. Ralph seconded the motion, which passed 3-0. 6. CDW-G I EMC ANNUAL MAINTENANCE & SUPPORT- AUTHORIZE. M. Carrington presented the agreement with CDW-G, Inc for maintenance and support of EMC networked data storage. The City's current EMC equipment support and maintenance vendor will be transitioned to CDW-G, Inc. as the result of a successful competitive bid process. A continually poor track record from the previous vendor prompted the need to switch. D. Ralph moved to recommend the Mayor sign a Goods and Services Agreement with CDW-G, Inc. in the amount of $65,209 for the purchase of annual maintenance and support, subject to terms and conditions acceptable to the City Attorney and Information Technology Director. D. Higgins seconded and the motion passed 3-0. The meeting was adjourned at 4:33 p.m. by L. Thomas. k Satwinder Kaur Operations Committee Secretary 3 • PARKS, RECREATION AND COMMUNITY SERVICES KENT Jeff Watling, Director WASHING70N Phone: 253-856-5100 Fax: 253-856-6050 Address: 220 Fourth Avenue S. Kent, WA. 98032-5895 June 4, 2013 TO: Kent City Council Operations Committee FROM: Ronda Billerbeck, Cultural Programs Manager THROUGH: Jeff Watling, Director, Parks, Recreation and Community Services SUBJECT: Kent Valley Loop Trail Art Master Plan Contract - Authorize MOTION: Move to recommend authorizing the Mayor to sign the contract with artist Ellen Sollod in the amount of $25,000 to serve as Artist Master Planner as part of the Kent Valley Loop Trail planning team, subject to final terms and conditions acceptable to the City Attorney and Parks Director. SUMMARY: Parks Planning and Development has contract with Berger landscape architects to develop a master plan for the Kent Valley Loop Trail project. The Kent Arts Commission recognizes the potential for this project to be a key amenity for Kent residents and visitors and desires to ensure that art is integrated in the project. An invitational call was issued to qualifying artists. Eleven artists applied and three were selected for interviews. The selection panel chose artist Ellen Sollod as the artist to serve on the Kent Valley Loop Trail master planning team. EXHIBITS: Draft Consultant Contract with Ellen Sollod BUDGET IMPACTS: Funded by the CityArt Budget 4 This page intentionally left blank 5 KENT CONSULTANT SERVICES AGREEMENT between the City of Kent and Ellen Sollod, Sollod Studio LLC THIS AGREEMENT is made between the City of Kent, a Washington municipal corporation (hereinafter the "City"), and Ellen Sollod, Sollod Studio LLC organized under the laws of the State of Washington, located and doing business at 724 15th Avenue, Seattle, WA 98122, 206- 324-7644 (hereinafter the "Consultant"). I. DESCRIPTION OF WORK. Consultant shall perform the following services for the City in accordance with the following described plans and/or specifications: The artist will develop recommendations to guide the City's investment in public art as part of the Kent Valley Loop Trail ;project. The Public Art Master Plan will: • Identify a conceptual framework and strategic opportunities as well as priorities for artwork development • Recommend how and where artwork can be implemented to complement the KVLT goals • Clearly demonstrate ideas and be innovative in content and presentation See Exhibit A - Ellen Sollod Kent Valley Loop Trail Master Plan Description of Work Consultant further represents that the services furnished under this Agreement will be performed in accordance with generally accepted professional practices within the Puget Sound region in effect at the time those services are performed. II. TIME OF COMPLETION. The parties agree that work will begin on the tasks described:in Section I above immediately upon the effective date of this Agreement. Upon the effective date of this Agreement, Consultant shall complete the work described in Section I by December 31, 2013. III. COMPENSATION. The City shall pay the Vendor an amount not to exceed $25,000 ($20,000 artist fee + up to $5,000 for production of art plan materials), including applicable taxes, for the goods, materials, and services contemplated in this Agreement. The City shall pay the Vendor the following amounts according to the following schedule: CONSULTANT SERVICES AGREEMENT - 1 (Over$10,000) 6 Payment 1: Completion of community meetings; research and analysis , September 20, 2013 $5000 Payment 2: Draft conceptual framework and approach October 11, 2013 $5000 (Review and Comment by the City by October 25) Payment 3: Draft art plan- on or before November 22, 2013 $5000 (Review and comment by the City by December 6) Payment 4: Final art plan December 31, 2013 $5000 Payment 5: Production of art plan materials December 31,2013 $5000 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.ii INDEPENDENT CONTRACTOR. The parties intend that an Independent Contractor-Employer Relationship will be created by this Agreement and that the Consultant 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. V. TERMINATION. Either party may terminate this Agreement, with or without cause, upon providing the other party thirty (30) days written notice at its address set forth on the signature block of this Agreement. If terminated by the City without cause, the consultant will be compensated for work completed to date. After termination, the City may take possession of all records and data within the Consultant's possession pertaining to this project, which may be used by the City without restriction. If the City's use of Consultant's records or data is not related to this project, it shall be without liability or legal exposure to the Consultant. VI. DISCRIMINATION. In the hiring of employees for the performance of work under this Agreement or any subcontract, the Consultant, its subcontractors, or any person acting on behalf of the Consultant or subcontractor shall not, by reason of race, religion, color, sex, age, CONSULTANT SERVICES AGREEMENT - 2 (Over$10,000) 7 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. Consultant 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. VII. INDEMNIFICATION. Consultant 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 Consultant'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 Consultant's work when completed shall not be grounds to avoid any of these covenants of indemnification. Should a court of competent jurisdiction determine that this Agreement is subject to RCW 4.24.115, then, in the event of liability for damages, arising out of bodily injury to persons or damages to property caused by or resulting from the concurrent negligence of the Consultant and the City, its officers, officials, employees, agents and volunteers, the Consultant's liability hereunder shall be only to the extent of the Consultant's negligence. IT IS FURTHER SPECIFICALLY AND EXPRESSLY UNDERSTOOD THAT THE INDEMNIFICATION PROVIDED HEREIN ' CONSTITUTES THE CONSULTANT'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. The provisions of this section shall survive the expiration or termination of this Agreement. VIII. INSURANCE. The Consultant shall procure and maintain for the duration of the Agreement, insurance of the types and in the amounts described in Exhibit B attached and incorporated by this reference. IX. EXCHANGE OF INFORMATION. The City will provide its best efforts to provide reasonable accuracy of any; information supplied by it to Consultant for the purpose of completion of, the work under this Agreement. X. OWNERSHIP AND USE OF RECORDS AND DOCUMENTS. Original documents, drawings, designs, reports, or any other records developed or created under this Agreement shall belong to and become the property of the City. All records submitted by the City to the Consultant will be safeguarded by the Consultant. Consultant shall make such data, documents, and files available to the City upon the City's request. The City's use or reuse of any of the documents, data and files created by Consultant for this project by anyone other than Consultant on any other project shall be without liability or legal exposure to Consultant. XI. CITY'S RIGHT OF INSPECTION. Even though Consultant is an independent contractor with the authority to control and direct the performance and details of the work authorized under this Agreement, the work must meet the approval of the City and shall be subject to the City's general right of inspection to secure satisfactory completion. CONSULTANT SERVICES AGREEMENT - 3 (Over$10,000) 8 XII. WORK PERFORMED AT CONSULTANT'S RISK. Consultant 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 Consultant's own risk, and Consultant 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. XIII. 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 VII 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. Assig.nment. 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. 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 Consultant. 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 CONSULTANT SERVICES AGREEMENT - 4 (Over$10,000) 9 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 Consultant agrees to comply with all federal, state, and municipal laws, rules, and regulations that are now effective or in the future become applicable to Consultant'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. CONSULTANT: CITY OF KENT: By: By: (signature) (signature) Print Name: Print Name: Suzette Cooke Its Its Mayor (title) DATE: DATE: CONSULTANT SERVICES AGREEMENT - 5 (Over$10,000) 10 NOTICES TO BE SENT TO: NOTICES TO BE SENT TO: CONSULTANT: CITY OF KENT: Ellen Sollod Ronda Billerbeck, Cultural Programs Manager Sollod Studio LLC City of Kent 724 15th Avenue 220 Fourth Avenue South Seattle, WA 98122 Kent, WA 98032 206-324-7644 (telephone) (253) 253-856-5055 (telephone) (facsimile) (253) 253-856-6050 (facsimile) APPROVED AS TO FORM, Kent Law Department [In this field.You may enter the electronic file bath where the contact has been saved] CONSULTANT SERVICES AGREEMENT - 6 (Over$10,000) 11 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 200. By:— — Fo r: Title: Date: EEO COMPLIANCE DOCUMENTS - 1 12 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 13 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 iInto 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 200. By:— — Fo r: Title: Date: EEO COMPLIANCE DOCUMENTS - 3 14 EXHIBIT B INSURANCE REQUIREMENTS FOR CONSULTANT SERVICES AGREEMENTS Insurance The Consultant 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 the Consultant, their agents, representatives, employees or subcontractors. A. Minimum Scope of Insurance Consultant 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 City shall be named as an insured under the Consultant'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. 4. Professional Liability insurance appropriate to the Consultant's profession. B. Minimum Amounts of Insurance Consultant shall maintain the following insurance limits: 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 15 general aggregate and a $1,000,000 products-completed operations aggregate limit. 3. Professional Liability insurance shall be written with limits no less than $1,000,000 per claim and $1,000,000 policy aggregate limit. C. 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 Consultant'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 Consultant's insurance and shall not contribute with it. 2. The Consultant'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 Consultant 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 Consultant'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 Consultant shall furnish the City with original certificates and a copy of the amendatory endorsements, including but not necessarily limited to the additional insured endorsement, evidencing the insurance requirements of the Contractor before commencement of the work. F. Subcontractors Consultant 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 Consultant. 16 This page intentionally left blank 17 INFORMATION TECHNOLOGY DEPARTMENT Mike Carrington, Director Information Technology ISI� T Phone: 253-856-4607 WASH IN oro x Fax: 253-856-4700 Address: 220 Fourth Avenue S. Kent, WA. 98032-5895 DATE: June 4, 2013 TO: Kent City Council Operations Committee FROM: Mike Carrington, Information Technology Director SUBJECT: HP I Nu Oz Corporation Goods & Services Agreement-Authorize MOTION: I move to recommend the Mayor sign a Goods and Services Agreement with Nu Oz Corporation in the amount of $97,592 for the purchase of 125 HP 8300 Desktop PC's, services, and maintenance, subject to terms and conditions acceptable to the City Attorney and Information Technology Director. SUMMARY: City of Kent Desktop Refresh Project In collaboration with departments throughout the city, the HP Elite 8300 Small Form Factor Desktop has been selected as the product offering of choice for the city's Desktop Refresh initiative. Hewlett Packard is an industry leader in simple unified business communication solutions that consistently lead the industry in customer satisfaction and lowest total cost of ownership requirements. Hewlett Packard utilizes a VAR/Value-Added-Reseller model through local vendors to sell, distribute, install and service their products. Nu Oz Corporation is an authorized Hewlett Packard VAR and is a member of the Western States Contracting Alliance (WSCA). As a cooperative member association, WSCA provides deep discount national purchasing power. WSCA utilizes a competitive sealed bid process to obtain pricing for all equipment and services provided through their registered vendors, including Hewlett Packard. City staff have leveraged the WSCA efforts pursuant to KCC 3.70.030 — Advertised Bids and secured contract terms commensurate to WSCA pricing for personal computers and related devices. Nu Oz Corporation will be engaged for product procurement and maintenance services for the deployment and duration of maintenance and support for this hardware. EXHIBITS: a) Nu Oz Corporation Goods & Services Agreement Budget Impact: IT Capital Budget allocations approved as a part of the 2013-2014 biennial budget process are earmarked for this project. 18 This page intentionally left blank 19 City of Kent, Washington Summary Financial Report 4^0 KEN T WASH IN G T O N As of April 30, 2013 20 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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Annexation Budget Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Street Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Lodging Tax Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Youth/Teen Programs Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Capital Improvement Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Criminal Justice Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Golf Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 INTERNAL SERVICE FUNDS PROFIT AND LOSS Fleet Services Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Central Services Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 Information Technology Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Facilities Operating Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Unemployment Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Workers Compensation Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Health and Employee Wellness Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 LEOFF 1 Retirees Benefits Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Liability Insurance Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 Property Insurance Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 REVENUE AND EXPENSE SUMMARIES Monthly Comparison 2010,2011,2012 and 2013 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 System Reports General Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 Special Revenue Operating Funds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 Debt Service Funds . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Water Utility Operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Sewerage Utility Operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 Golf Course Operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 Internal Services-excluding Insurance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 Insurance Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 Street Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 Parks Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 Other Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 Technology Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 Facilities Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 Water Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 Sewerage Capital Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 21 City Of Kent Monthly Financial Summary for April 2013 General Fund Summary Based on information available through April, ending fund balance will grow by $2,507,477 and is estimated to end the year at $6,176,941 or 10.8% of the expenditure budget. Revenues Property Tax and Sales Tax are showing a slight improvement over budget. Overall revenues are estimated to end the year very near budget. Highlights include: • Sales Tax and Property Tax continue to trend just above budget. • Utility Tax revenues are lagging slightly below budget. • Building Permits and Plan Check Fees continue to show a strong upward trend. • Recreation Fees are trending to end the year above budget and are currently above projections by 16.3%. Exoenditures Current projections end the year at about $244,875 or .4% below the budget. Fund Balance Ending fund balance is estimated to be $6,179,941, which equates to 10.8% of the expenditure budget. zz General Fund Revenues (excluding Annexation) 12,000,000 10,000,000 8,000,000 6,000,000 4,000000 a ...� ,. �In, 6,. 2,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,282,016 3,577,476 5,264,604 10,689,664 5,307,642 4,436,584 3,230,171 2,829,497 4,420,820 10,523,856 4,265,901 4,048,173 13 Pct 3,358,007 3,802,504 5,090,165 10,591,647 +/- 75,991 225,028 (174,440) (98,017) Put+/- 2.3% 6.3% -3.3% -0.9% General Fund Revenues (excluding Annexation) 70,000,000 60,000,000 50,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,710,059 56,222,913 60,139,262 13 Bud 3,282,016 6,859,492 12,124,097 22,813,761 28,121,403 32,557,987 35,788,158 38,617,655 43,038,475 53,562,331 57,828,232 61,876,405 13 Pct 3,358,007 7,160,511 12,250,676 22,842,323 +/- 75,991 301,019 126,579 28,562 Put+/- 2.3% 4.4% 1.0% 0.1% 23 General Fund Expenditures (excluding Annexation) 6,000,000 5,000,000 %aii p far i 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,635,336 4,818,974 4,374,684 4,854,035 4,870,305 4,615,710 5,344,045 4,452,324 4,942,113 4,715,791 5,266,193 4,686,169 13 Pct 4,020,154 4,407,030 4,530,859 4,629,351 +/- (615,182) (411,944) 156,175 (224,684) Put+/- -13.3% -8.5% 3.6% -4.6% General Fund Expenditures (excluding Annexation) 70,000,000 60,000,000 50,000,000 40,000,000 30,000,000 „r 20,000,000 w 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,635,336 9,454,310 13,828,995 18,683,030 23,553,335 28,169,045 33,513,090 37,965,413 42,907,526 47,623,317 52,889,511 57,575,680 13 Pct 4,020,154 8,427,184 12,958,043 17,587,394 +/- (615,182) (1,027,126) (870,952) (1,095,636) Put+/- -13.3% -10.9% -6.3% -5.9% 24 Property Tax (excluding Annexation) 7,000,000 6,000,000 5,000,000 'd 4,000,000 w, 3,000,000 �P4�--- 1 2,000,000 1,000,000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13Bud Monthly Budget vs Adjusted Actual of 12Ac[ �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 +/- 6,606 (27,689) 75,679 (2,757) Put+/- 0.0% 0.0% 0.0% 0.0% Property Tax (excluding Annexation) 20,000,000 18,000,000 16,000,000 14,000,000 �j 12,000,000 10,000,000 8,000,000i%T 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 '""." 12 Act 113Act ]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 +/- 6,606 (21,083) 54,596 51,839 Put+/- 0.0% -15.6% 9.4% OJ% 25 Sales Tax (excluding Annexation) 2,500,000 2,000,000 1,500,0001,000,000 �... /� .�...... �, i 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 +/- 46,404 (28,484) 53,033 16,668 Put+/- 5.5% -2.5% 2.7% 2.1% Sales Tax (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 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 +/- 46,404 17,920 70,953 87,621 Put+/- 5.5% 0.9% 1.8% 1.8% 26 Utility Tax (excluding Annexation) 2,000,000 1,800,000 1,600,000 a , 1,400,000 a. 1,200,000 i,pr „90y rll,4'�`... „� �pp�l/oi imi„i ��13vu ii 3Y///� 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 +/- (86,533) (12,264) (41,662) (87,442) Put+/- -4.9% -0.9% -3.1% -5.5% Utility Tax (excluding Annexation) 18,000,000 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 6,000,000 " ;,,,,, G 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 +/- (86,533) (98,797) (140,459) (227,902) Put+/- -4.9% -3.2% -3.1% -3.8% 27 Building Permits (excluding Annexation) 300,000 250,000 200,000 150,000 100,000 50,000 �......... %f< 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 13Bud Monthly Budget vs Adjusted Actual ,12AIt .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 +/- 1,598 32,619 15,686 (2,204) Put+/- 2.1% 19.9% 8.1% -1.0% 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 +/- 1,598 34,217 49,902 47,699 Put+/- 2.1% 14.3% 11.5% 7.4% 28 Plan Check Fees (excluding Annexation) 350,000 3 00,000 25 0,000 200,000 150,000 100,000 .. 9/! 7111; 50,000 WK 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 P t 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 P t 181,841 190,940 291,904 145,764 +/- 34,576 17,748 97,213 (71,316) Put+/- 23.5% 10.2% 49.9% -32.9% Plan Check Fees (excluding Annexation) 2,500,000 2,000,000 1,500,000 1,000,000 ..... , 500,000 o 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 P t 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 P t 181,841 372,782 664,686 810,450 +/- 34,576 52,325 149,537 78,222 Put+/- 23.5% 16.3% 29.0% 10J% 29 Recreation Fees (excluding Annexation) 250,000 200,000 150,000 100,000 50,000 iJ,r" 0 ...p p... 1 1 p p ...1 1... p p 1 ,.....I 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 103,398 37,267 80,413 197,370 74,179 44,696 150,278 105,213 150,771 50,679 38,957 89,525 13 Pct 146,178 46,730 93,362 200,494 +/- 42,780 9,463 12,948 3,123 Put+/- 41.4% 25.4% 16.1% 1.6% Recreation Fees (excluding Annexation) 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 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 103,398 140,665 221,078 418,449 492,627 537,323 687,601 792,815 943,585 994,265 1,033,222 1,122,747 13 Pct 146,178 192,909 286,270 486,764 +/- 42,780 52,244 65,192 68,315 Pct+/- 41.4% 37.1% 29.5% 16.3A 30 Fines & Forfeitures (excluding Annexation) 250,000 200,000 150,000 a� 100,000 50,000 p Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Bud Monthly Budget vs Adjusted Actual -."Act t 12 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 11 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 12 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 12 Pct 118,540 102,708 190,741 117,167 +/- 5,565 (37,710) 33,122 (20,664) Put+/- 4.9% -26.9% 21.0% -15.0% Fines & Forfeitures (excluding Annexation) 1,800,000 1,600,000 1,400,0001,200,000 m 1,000,000 800,000 600,000 �; 400,000 „,�r;,., 200,000 C" 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Bud 11 Act Cumulative Budget vs Actual t 12 Act ]an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 11 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 12 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 12 Pct 118,540 221,248 411,989 529,156 +/- 5,565 (32,145) 97 (19,688) Put+/- 4.9% -12J% 0.2% -3.6% 31 Water Operating Revenues (excluding Annexation) 2,500,000 2,000,000 1,14/611 1,500,000 . oom, 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 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 +/- 12,530 (13,455) 19,494 15,218 Put+/- 0.9% -1.3% 1.8% 1.4% 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 +/- 12,530 (924) 18,570 33,788 Put+/- 0.9% 0.0% 0.5% OJ% 32 Sewer and Drainage Operating Revenues (excluding Annexation) 4,500,000 4,000,000 Oii %li, iiir r' jai ni i+�r ii ���C '%�llioi 3,000,000 �,, :a„��, ,� „i /l," �l%; „111,, 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 +/- 47,593 (654) (4,580) 50,319 Put+/- 1.3% 0.0% -0.1% 1.4% 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 " 10,000,000 c/ 5,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 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 +/- 47,593 46,939 42,359 92,678 Put+/- 1.3% OJ% 0.4% OJ% 33 Golf Operating Revenues (excluding Annexation) 500,000 45 0,000 400,000 350,000 300,000 mo 250,000 i�����, ....... Uo 200,000 150,000 100,000 M , 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 177,862 116,212 123,470 13 Bud 97,930 130,731 177,285 261,649 289,945 388,930 465,715 454,224 284,478 199,666 103,604 150,186 13 Pct 71,129 108,922 184,571 201,960 +/- (26,801) (21,809) 7,286 (59,689) Put+/- -27.4% -16J% 4.1% -22.8% Golf Operating Revenues (excluding Annexation) 3,500,000 3,000,000 2,500,000 j is 2,000,000 ., 1,500,000 1,000,000 F 500,000 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,778 2,498,247 13 Bud 97,930 228,661 405,947 667,596 957,540 1,346,470 1,812,185 2,266,409 2,550,888 2,750,554 2,854,158 3,004,344 13 Pct 71,129 180,051 364,622 566,583 +/- (26,801) (48,610) (41,324) (101,013) Pct+/- -27.4A -21.3% -10.2% -15.Sh 34 GENERALFUND (without Annexation) As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Fund Balance 1,298,783 3,669,464 3,669,464 3,669,464 Revenues Taxes: Property 17,001,431 17,294,918 7,294,848 17,346,756 Sales Tax 15,711,938 15,598,428 4,837,087 15,682,362 Utility 14,840,122 15,845,390 5,826,512 15,829,518 Other 807,081 824,118 188,176 840,650 Business and Occupation Tax 300,000 300,000 300,000 Licenses and Permits 3,029,962 3,365,746 1,329,377 3,568,800 Intergovernmental Revenue 1,667,789 1,156,204 339,966 1,299,044 Charges for Services 4,244,730 4,708,967 1,775,413 4,969,305 Fines and Forfeitures 1,499,054 1,537,250 484,302 1,560,672 Miscellaneous Revenue 1,695,642 1,236,384 521,508 1,321,327 Transfers In 935,202 994,139 994,139 TOTAL REVENUES 61,432,951 62,861,544 22,897,188 63,712,573 Expenditures Salaries & Benefits 42,308,779 42,716,497 * 13,375,350 42,079,110 Supplies 1,829,487 2,312,435 583,720 2,306,368 Services & Charges 21,544,755 23,160,909 6,903,709 22,850,523 Capital Outlay 120,963 Cost Allocations (10,336,981) (10,614,161) (3,275,385) (9,905,196) Transfers Out 3,595,268 3,874,291 92,038 3,874,291 TOTAL EXPENDITURES 59,062,270 61,449,971 17,679,432 61,205,096 Net Revenues less Expenditures 2,370,681 1,411,573 5,217,756 2,507,477 Contingency for Unanticipated Costs 500,000 500,000 General Fund Reserves 4,581,037 5,676,941 Ending Fund Balance 3,669,464 5,081,037 8,887,220 6,176,941 6.6% 8.8% 10.8% * Includes $246,095 for the 2013 COLA received by the KPOA-Police Sergeants and Officers Union 35 ANNEXATION As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Fund Balance (655,268) 460,513 460,513 460,513 Revenues Taxes: Property 2,810,057 2,881,141 1,224,924 2,950,997 Sales Tax 4,408,543 4,304,061 1,458,443 4,385,598 Utility 2,638,346 2,962,011 1,085,960 2,882,217 Other 309,710 332,501 100,059 253,148 ** Licenses and Permits 6,378 Intergovernmental Revenue 941,542 834,153 257,591 807,397 Charges for Services 3,658 2,490 2,490 Miscellaneous Revenue (318,122) TOTAL REVENUES 10,800,111 11,313,867 4,129,467 11,281,847 Expenditures Salaries & Benefits 4,806,777 5,493,069 * 1,645,176 5,311,475 Supplies 251,632 925,532 97,274 740,980 Services & Charges 4,665,600 4,852,167 1,332,787 4,725,408 Capital Outlay Cost Allocations (39,679) (48,137) (48,137) TOTAL EXPENDITURES 9,684,330 11,270,768 3,027,100 10,729,726 Net Revenues less Expenditures 1,115,781 43,099 1,102,367 552,121 Ending Fund Balance 460,513 503,612 1,562,880 1,012,634 * Includes $41,662 for the 2013 COLA received by the KPOA-Police Sergeants and Officers Union ** Reflects Council's decision to reduce the gambling tax rate from 11% to 7%. 36 STREET OPERATING FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Fund Balance 355,417 275,044 275,044 275,044 Revenues Fuel Tax - Unrestricted 1,865,667 1,886,725 582,769 1,912,309 Water Utility Tax 162,924 167,414 46,015 167,811 Sewer Utility Tax 223,450 231,245 79,453 235,739 Drainage Utility Tax 165,087 173,236 60,235 173,342 Electric Utility Tax 1,088,861 1,119,842 419,449 1,094,305 Gas Utility Tax 350,459 393,959 179,856 374,261 Garbage Utility Tax 156,016 205,866 72,978 210,622 Telephone Utility Tax 710,882 669,929 227,661 669,929 Business &Occupation Tax 4,700,000 323,685 4,700,000 Miscellaneous Revenues (47,995) 70 55 70 Total Revenues 4,675,351 9,548,286 1,992,155 9,538,389 Total Resources 5,030,768 9,823,330 2,267,199 9,813,433 Expenditures &Transfers Debt Service PW Trust Fund Loan 797,200 793,499 793,499 LTGO Bonds 2000 28,775 LTGO Bonds 2002 553,692 GO Refund (96) 2004 136,393 139,507 139,507 GO Refund 2005 (93,95,00,96TF) 37,789 114,714 114,714 LTGO Bonds 2008 487,066 466,921 466,921 LTGO Bonds 2009 207,213 207,107 207,107 GO Refund 2012 (2000/2002) 253,557 600,023 600,023 Total Debt Service 2,501,685 2,321,771 2,321,771 Operating Costs Street Utility Operations 1,805,094 1,674,419 510,323 1,624,584 Street Tree Maintenance Program 196,017 267,968 56,234 259,929 Engineering Services Allocation 264,546 265,180 88,393 265,180 Total Operating Costs 2,265,657 2,207,567 654,950 2,149,693 Arterials Asphalt Overlays 4,700,000 4,700,000 James Ave Impr (4th to UPRR) 39,685 Closed and other Arterial Projects (166,617) Total Arterials (126,932) 4,700,000 4,700,000 Other Improvements Transportation Master Plan 4,966 Mero Transit Services 155,000 155,000 155,000 Closed and Other Improvements (44,652) Total Other Improvements 115,315 155,000 155,000 Total Effective Transportation System 2,254,039 7,062,567 654,950 7,004,693 Total Expense &Transportation 4,755,724 9,384,338 654,950 9,326,464 Change In Fund Balance (80,373) 163,948 1,337,205 211,924 Ending Fund Balance 275,044 438,992 1,612,249 486,968 37 LODGING TAX OPERATING FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Fund Balance 86,810 95,397 95,397 95,397 Revenues Lodging Tax 187,971 194,382 48,945 195,473 Miscellaneous Income 115 50 30 60 Total Revenues 188,086 194,432 48,975 195,533 Total Resources 274,896 289,829 144,372 290,930 Expenditures Seattle Southside Visitor Services 120,000 60,000 35,000 60,000 Tourism Unallocated 26,000 20,000 20,000 Tourism Chamber 18,500 18,500 9,250 18,500 ShoWare Marketing 60,000 60,000 Branding Activities 20,000 20,000 Total Expenditures 164,500 178,500 44,250 178,500 Transfers Out - ShoWare Impact Study 5,000 Transfers Out - Ballfield Portable Fencing 10,000 Total Expenditures and Transfers 179,500 178,500 44,250 178,500 Change in Fund Balance 8,587 15,932 4,725 17,033 Ending Fund Balance 95,397 111,329 100,122 112,430 38 YOUTH/TEEN PROGRAMS OPERATING FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual BEGINNING FUND BALANCE 20,579 86,458 86,458 86,458 REVENUES Utility Taxes: Water 48,877 50,224 13,804 50,385 Sewer 67,035 69,374 23,836 69,676 Drainage 49,526 55,971 18,070 53,810 Electric 326,658 335,885 125,835 335,885 Gas 105,138 118,164 53,957 118,164 Garbage 46,805 61,824 21,893 53,297 Telephone 213,264 200,938 68,298 213,348 Miscellaneous Revenues 576 250 50 304 TOTAL REVENUES 857,879 892,630 325,744 894,868 TOTAL RESOURCES 878,458 979,088 412,202 981,327 EXPENDITURES Transfer Out - General Fund Teen Programs 750,000 844,139 844,139 Teen Golf Program 42,000 42,000 42,000 TOTAL EXPENDITURES (TRANSFERS) 792,000 886,139 886,139 Change In Fund Balance 65,879 6,491 325,744 8,729 ENDING FUND BALANCE 86,458 92,949 412,202 95,188 39 CAPITAL IMPROVEMENT OPERATING FUND Including Both Portions of Estate Excise Taxes As of April 30, 2013 2012 2013 2013 2013 Actuals Budget YTD Est Actual Total Beginning Fund Balance (12,052,614) (11,082,376) (11,082,376) (11,082,376) Revenues & Other Fin Sources Sales Tax 4,608,055 4,340,469 1,532,494 4,431,619 Utility Tax 1,171,672 371,404 1,183,389 Real Estate Excise Tax 1,644,785 1,142,799 522,872 1,371,359 Real Estate Excise Tax-2nd Qtr 1,644,785 1,142,799 522,872 1,371,359 Real Estate Excise Tax-St Percent 258,392 811 811 Miscellaneous Revenues 2,135 3,939 586 3,939 Transfer In - Facilities 260,000 Sale of Property 198,526 6,000,000 193,520 6,000,000 Transfer In - GF 2,201,772 2,193,787 2,193,787 Total Rev/Other Fin Sources 10,818,451 15,995,465 3,144,559 16,556,263 Total Resources (1,234,163) 4,913,089 (7,937,817) 5,473,887 Expenditures (Transfers) Debt Service Non-Voted Debt Service 6,820 1,171,672 564 1,171,672 LTGO Bonds 2000 76,575 Valley Communications 170,910 240,880 240,880 LTGO Bonds 2002 434,733 LTGO / Taxable Bonds 2003 667,274 666,340 666,340 GO Refund (96) 2004 1,447,831 1,480,875 1,480,875 GO Refund 2005 (93,95,00,96TF) 63,112 191,579 191,579 LTGO Bonds 2006 770,000 758,000 758,000 LTGO Bonds 2008 1,412,334 1,306,679 1,306,679 GO Refund 2009 (Part 1999) 721,641 721,268 721,268 GO Refund 2012 (2000/2002) 350,111 747,257 747,257 ShoWare Debt Service 2,764,025 2,500,000 2,500,000 Water Fund Loan Payoff 366,660 Subtotal Debt Service 9,252,026 9,784,550 564 9,784,550 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 Information Technology Hardware Lifecycle Replacmnts 120,000 Subtotal Information Technology 120,000 0 0 0 40 CAPITAL IMPROVEMENT OPERATING FUND Including Both Portions of Estate Excise Taxes As of April 30, 2013 2012 2013 2013 2013 Actuals Budget YTD Est Actual Parks Lifecycle Parks System 400,000 250,000 250,000 Urban Forestry 15,000 Closed and Other Parks Projects (738) Subtotal Parks 414,262 250,000 0 250,000 Other Annexation Study (48,076) Emergency Flood Preparedness (450,000) Event Center Lifecycle 300,000 300,000 300,000 Subtotal Other (198,076) 300,000 0 300,000 Total Expenditures (Transfers) 9,848,212 10,334,550 564 10,334,550 Change in Fund Balance 970,239 5,660,915 3,143,994 6,221,713 Total Ending Fund Balance (11,082,375) (5,421,461) (7,938,381) (4,860,663) 41 CRIMINAL JUSTICE OPERATING FUND April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Fund Balance 327,985 650,437 650,437 650,437 Revenues Sales Tax - Local Option (1) 1,924,193 1,814,268 655,822 1,932,983 MVET - Basic Crime 100,113 92,899 50,900 104,410 MVET - High Crime 46,314 191,199 95,600 MVET - Special Programs 78,549 74,406 39,687 80,523 Miscellaneous Revenues 280 100 142 142 Transfers In Total Revenues 2,149,448 2,172,872 746,550 2,213,657 Total Resources 2,477,433 2,823,309 1,396,987 2,864,094 Expenditures Law Salaries & Benefits 548,523 554,171 179,999 539,997 Supplies 13,963 30,554 1,814 23,932 Services & Charges 9,129 22,349 2,905 10,727 Domestic Violence Salaries & Benefits 160,674 138,291 44,924 134,771 Supplies Services & Charges 7,511 8,198 2,611 7,731 Capital Outlay KYFS - Youth Violence Prevention Services & Charges 25,000 25,000 25,000 Police Salaries & Benefits 974,852 1,151,809 336,920 1,167,542 Supplies 36,558 58,064 21,936 50,718 Services & Charges 34,285 123,132 13,918 82,239 Total Expenditures 1,810,496 2,111,568 605,028 2,042,658 Transfers Out 16,500 16,500 16,500 Total Expenditures and Transfers 1,826,996 2,128,068 605,028 2,059,158 Increase (Decrease) In Fund Balance 322,452 44,804 141,522 154,499 Ending Fund Balance 650,437 695,241 791,959 804,936 (1) Council resolution allocated 11% of Criminal Justice sales tax to Domestic Violence. 42 GOLF OPERATING FUND As of April 30, 2013 2012 2013 2013 2013 Actuals Budget YTD Est Actual Beginning Working Capital (2,174,297) (2,395,200) (2,395,200) (2,395,200) Revenues 18 Hole Course Green Fees 1,033,850 1,288,000 184,193 1,201,427 Cart & Club Rentals 155,812 204,000 27,202 162,587 Restaurant Lease 50,875 60,000 11,504 52,119 Par 3 Course Green Fees 211,747 281,000 41,973 240,521 Cart & Club Rentals 11,809 14,000 1,830 12,564 Food & Beverage Sales 10,217 20,000 2,093 15,020 Driving Range Driving Range Fees 457,101 470,000 134,204 470,462 Mini Putt Fees 31,719 48,000 6,542 46,797 Lesson Fees 84,560 110,000 21,780 104,910 Cart & Club Rentals 1,841 210 1,852 Food & Beverage Sales 32,395 35,000 6,280 33,371 Leases - long term 21,350 Merchandising Merchandise Sales 467,175 508,994 140,223 507,782 Other Insurance Reimbursement 115,861 Miscellaneous Revenues 4,042 4,000 1,519 4,556 Driving Range Cell Tower Lease 20,904 7,117 21,350 Total Revenues 2,689,909 3,064,344 586,669 2,875,318 Total Resources 515,612 669,144 (1,808,530) 480,118 Expenditures (Transfers) 18 Hole Course 1,663,082 1,724,636 485,821 1,704,636 Par 3 Course 302,746 294,944 93,077 294,944 Driving Range 381,556 479,598 121,344 410,690 Merchandising 441,817 554,930 121,887 460,205 Repair Damaged Assets 117,861 Other Expenses 3,751 2,946 1,359 2,946 Total Expenditures (Transfers) 2,910,812 3,057,054 823,488 2,873,422 Net Change in Working Capital (220,903) 7,290 (236,819) 1,896 Total Working Capital (2,395,200) (2,387,910) (2,632,019) (2,393,303) 43 FLEET SERVICES FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Working Capital 2,628,235 1,866,304 1,866,304 1,866,304 Operating Revenue Fleet Operations 2,961,063 3,187,651 1,068,346 3,200,909 Fleet Replacement 374,875 792,850 265,036 792,850 Sale of Property 29,335 12,306 12,306 Miscellaneous Revenues 3,335 13,835 967 13,835 Total Operating Revenue 3,368,608 3,994,336 1,346,656 4,019,900 Total Resources 5,996,843 5,860,640 3,212,960 5,886,204 Expenditures Salaries & Benefits 847,779 827,334 279,151 873,213 Supplies 1,596,595 1,583,964 410,749 1,575,839 Services 786,363 739,124 272,307 739,124 Capital Outlay 820,905 1,364,440 75,428 1,364,440 Total Expenditures 4,051,642 4,514,862 1,037,635 4,552,616 Transfers Out 78,898 134 Total Expenses and Transfers 4,130,539 4,514,996 1,037,635 4,552,616 Net Change In Working Capital (761,931) (520,660) 309,021 (532,715) Total Working Capital 1,866,304 1,345,644 2,175,325 1,333,588 44 CENTRAL SERVICES FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Working Capital (122,352) (168,200) (168,200) (168,200) REVENUE Central Stores 101,236 217,827 31,631 123,199 Postage 199,667 296,204 54,709 241,644 Misc Revenue 120,882 120,882 Total Revenue 300,903 634,913 86,340 485,725 Total Resources 178,551 466,713 (81,860) 317,525 EXPENSE Central Stores 115,813 207,454 26,316 118,129 Postage 211,638 282,099 95,527 219,949 Central Services 19,301 19,361 6,454 19,361 Total Expense 346,752 508,914 128,296 357,439 Net Operating Income (45,849) 125,999 (41,956) 128,286 Ending Working Capital (168,200) (42,201) (210,156) (39,914) 45 INFORMATION TECHNOLOGY FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Working Capital 399,972 570,140 570,140 570,140 Revenues Contributions & Other 4,533,585 4,212,504 1,317,174 4,212,504 Utility Tax 1,040,000 292,729 1,040,000 Intergovernmental - RFA 471,972 444,012 114,987 444,012 Technology Fees 413,035 374,800 150,178 386,044 Total Revenue 5,418,592 6,071,316 1,875,068 6,082,560 Total Resources 5,818,565 6,641,456 2,445,208 6,652,700 Expenditures Computer Systems & Tech Svcs Salaries & Benefits 2,138,636 1,976,384 610,065 1,976,384 Supplies 176,164 42,629 132,610 42,629 Services & Charges 1,169,621 1,221,064 670,263 1,221,064 Subtotal 3,484,420 3,240,077 1,412,938 3,240,077 Telecommunications Salaries & Benefits 147,407 147,009 46,817 147,009 Supplies 2,155 14,774 1,452 14,774 Services & Charges 296,732 406,661 108,012 406,661 Subtotal 446,294 568,444 156,280 568,444 Printing/Graphics/Cable TV Salaries & Benefits 561,058 574,237 197,521 574,237 Supplies 55,733 75,821 20,358 75,821 Services & Charges 289,156 343,739 67,622 343,739 Subtotal 905,947 993,797 285,501 993,797 Total Operating Expense 4,836,661 4,802,318 1,854,720 4,802,318 Transfers Out-LT Lifecycle 411,764 1,226,491 148,786 1,226,491 Total Exp & Transfers 5,248,425 6,028,809 2,003,506 6,028,809 Net Income 170,168 42,507 (128,438) 53,751 Ending Working Capital 570,140 612,647 441,702 623,891 46 FACILITIES OPERATING FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Working Capital 306,190 867,060 867,060 867,060 Operating Revenue Intergovernmental -RFA 843,316 843,316 288,695 866,086 Rental Fees - Internal 4,240,371 3,997,582 1,332,527 3,997,582 Leases 26,918 26,916 8,973 21,865 Miscellaneous Revenue 20,684 16,269 4,754 14,261 Total Revenue 5,131,289 4,884,083 1,634,950 4,899,793 Total Resources 5,437,479 5,751,143 2,502,010 5,766,854 Operating Expense Salaries and benefits 2,083,212 2,165,481 668,555 2,165,481 Supplies 271,314 351,202 84,451 338,907 Services and charges 11802,990 1,873,365 479,187 1,783,166 Capital outlay - 40,500 40,500 Total Operating Expense 4,157,516 4,430,548 1,232,193 4,328,054 Other Financial Uses Transfers Out - Projects 260,000 500,000 500,000 Transfers Out - Debt 152,903 109,115 109,115 Total Non Operating Rev (Exp) 412,903 609,115 609,115 Total Expenses and Uses 4,570,419 5,039,663 1,232,193 4,937,169 Net Change In Working Capital 560f870 (155,580) 402,757 (37,376) Ending Working Capital 867,060 711,480 1,269,817 829,685 47 UNEMPLOYMENT FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Working Capital 201,790 280,233 280,233 280,233 Revenues Contributions 389,106 402,324 127,009 381,027 Miscellaneous Revenue 354 250 132 395 Total Revenues 389,460 402,574 127,141 381,422 Total Resources 591,250 682,807 407,373 661,655 Expenditures Salaries & Benefits 16,592 23,951 6,285 18,856 Supplies 4,177 2,089 Claims Paid 1st Quarter 77,395 100,000 54,869 54,869 2nd Quarter 101,465 100,000 100,000 3rd Quarter 72,840 100,000 100,000 4th Quarter 39,928 100,000 100,000 Other Services & Charges 2,796 5,087 932 3,966 Total Expenditures 311,017 433,215 62,086 379,780 Net Income 78,442 (30,641) 65,055 1,642 Ending Working Capital 280,233 249,592 345,287 281,875 48 WORKERS COMPENSATION FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Working Capital (509,195) 693,747 693,747 693,747 Revenues Contributions 1,602,991 1,656,075 489,573 1,590,429 Miscellaneous Revenue 3,775 3,000 1,116 3,349 Total Revenue 1,606,766 1,659,075 490,689 1,593,778 Total Resources 1,097,572 2,352,822 1,184,436 2,287,525 Expenditures Salaries & Benefits 66,368 106,022 25,141 75,424 Judgements & Damages 742,840 1,000,000 61,248 748,754 Ultimate Loss Adjustment (676,087) Liability Insurance 43,329 78,234 50,025 50,025 Intergovernmental Services 138,790 204,000 45,126 135,377 Administrative Expenses 64,362 53,777 26,350 72,595 Other Expenses 4,427 16,660 1,527 4,582 Safety Program 19,795 90,262 1,116 90,262 Total Expenditures 403,825 1,548,955 210,534 1,177,020 Net Income 1,202,942 110,120 280,156 416,758 Ending Working Capital 693,747 803,867 973,903 1,110,505 Claims Reserve* Reserve Amount 1,757,476 Actuary Recommended 1,879,022 'Claims reserve is not included in ending working capital. It is adjusted annually on 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. 49 HEALTH AND EMPLOYEE WELLNESS FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Working Capital 4,634,833 5,963,620 5,963,620 5,963,620 Revenues Contributions Blue Cross 9,163,751 9,606,586 3,167,102 9,501,306 Group Health 392,117 424,534 121,975 365,926 Employee Share Blue Cross 907,667 1,043,069 298,409 895,227 Group Health 50,938 55,476 20,921 62,764 RFA Contributions 3,687,875 COBRA 156,845 86,282 46,329 138,987 Miscellaneous 196,866 148,068 36,681 142,449 Total Revenue 14,556,059 11,364,015 3,691,418 11,106,659 Total Resources 19,190,891 17,327,635 9,655,038 17,070,279 Expenditures Salaries & Benefits 329,982 350,704 116,459 349,377 Blue Cross Claims 10,418,590 8,045,679 2,454,295 7,845,679 Blue Cross Ad min Fees 565,520 397,404 130,701 392,103 Blue Cross Audit Fees 59,332 59,332 Delta Dental Claims 1,027,473 811,325 259,091 1,014,787 Delta Dental Admin Fees 62,369 46,015 18,942 56,826 Vision Service Plan Claims 117,180 95,021 18,463 95,021 Vision Service Plan Admin Fees 26,325 14,293 7,225 21,675 Stop Loss Fees 469,190 415,113 114,970 415,113 Stop Loss Reimbursements (193,310) (349,793) (20,885) (175,314) Group Health Premiums 443,055 531,269 138,047 414,142 COBRA Medical Expenses 5,178 5,178 IBNRAdjustment (110,300) (127,800) (127,800) Wellness 16,012 88,314 9,318 88,314 Other Professional Services 55,188 53,338 8,302 53,338 Total Expenditures 13,227,272 10,430,214 3,260,107 10,507,771 Change in Working Capital 1,328,787 933,801 431,311 598,888 Ending Working Capital 5,963,620 6,897,421 6,394,931 6,562,507 IBNR 863,400 753,100 753,100 753,100 Target Fund Bal @ 2 X IBNR 1,726,800 1,506,200 1,506,200 1,506,200 Ending Working Capital Less 2 X IBNR 4,236,820 5,391,221 4,888,731 5,056,307 50 LEOFF 1 RETIREES BENEFITS FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget Actual Est Actual Beginning Working Capital 527,368 699,508 699,508 699,508 Revenues Contributions 695,730 673,806 244,664 713,992 Contributions - Dependents 60,300 60,000 12,036 36,108 Miscellaneous Revenue 831 2,500 337 337 Total Revenues 756,861 736,306 257,037 750,437 Operating Transfers In 250,000 250,000 250,000 Total Resources 1,534,228 1,685,814 956,545 1,699,945 Expenditures Blue Cross Claims 556,619 764,122 170,998 764,122 Blue Cross Admin Fees 52,486 61,812 16,215 53,536 Delta Dental Claims 41,801 50,468 12,619 45,981 Delta Dental Admin Fees 5,476 4,774 2,172 5,586 Vision Service Plan Claims 5,420 7,441 984 5,652 Vision Service Plan Admin Fees 1,781 1,803 609 1,823 Stop Loss Reimbursements (25,000) (16,664) Stop Loss Fees 43,219 50,425 14,042 46,775 IBNR Adjustment (14,400) 4,900 4,900 Medical Reimbursements 122,495 184,682 38,075 138,854 Other Professional Services 19,824 16,181 1,985 16,181 Total Expenditures 834,720 1,121,608 257,699 1,066,746 Change in Fund Balance 172,140 (135,302) (662) (66,309) Ending Working Capital 699,508 564,206 698,845 633,199 IBNR 67,100 52,700 52,700 52,700 Target Fund Bal @ 2 X IBNR 134,200 105,400 105,400 105,400 Ending Working Capital Less 2 X IBNR 565,308 458,806 593,445 527,799 51 LIABILITY INSURANCE FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Working Capital 831,667 2,187,087 2,187,087 2,187,087 Revenues Contributions 2,340,300 2,340,300 780,100 2,340,300 Miscellaneous Revenue 6,164 4,000 1,951 5,852 Total Revenues 2,346,464 2,344,300 782,051 2,346,153 Total Resources 3,178,131 4,531,387 2,969,138 4,533,240 Expenditures Salaries & Benefits 66,367 95,684 26,615 79,846 Claims & Judgements 122,990 1,000,000 80,808 1,000,000 Insurance Premiums 664,509 719,750 676,980 719,750 Other Expenses 137,179 200,839 19,440 156,030 Total Expenditures 991,044 2,016,273 803,843 1,955,626 Net Income 1,355,420 328,027 (21,792) 390,527 Ending Working Capital 2,187,087 2,515,114 2,165,294 2,577,614 Claims Reserve* Reserve Amount 11977,374 Actuary Recommended 1,282,088 'Claims reserve is not included in ending working capital. It is adjusted annually on December 31 st. 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. 52 PROPERTY INSURANCE FUND As of April 30, 2013 2012 2013 2013 2013 Actual Budget YTD Est Actual Beginning Working Capital 104,731 141,317 141,317 141,317 Revenues Contributions 453,593 562,455 187,485 562,455 Miscellaneous Revenue 114 100 2 100 Total Revenues 453,707 562,555 187,487 562,555 Total Resources 558,439 703,872 328,804 703,872 Expenditures Insurance Premiums 387,734 510,000 254,725 510,000 Property Claims/Deductibles 12,796 24,684 24,684 Other Expenses 16,592 23,951 6,285 23,951 Total Expenditures 417,122 558,635 261,010 558,635 Net Income 36,585 3,920 (73,523) 3,920 Working Capital 141,317 145,237 67,794 145,237 53 } ( ( \ \ ( } \ m \ ( \ \ \ \ � � k \ \ \ \ \ \ \ m � � \ \ } } } \ ( } \ } \ \ } } ( \ \ } : ; E . E r \ \ } ( & ! \ } \ \ � \ \ / / & ll \m � ` n ; um \ \ \ \ m \ .m \ \ \ \ \mm \ \ ) \ } ( \ ( \ � \ : \ \ ( / } \ \ ! \ E ; ! BEEF : / E ; r : ; E i ( \ \ ( / ( m \ 1 m... J ® ® / } mI § o \o \c R \ m \ \ 3 ! R \ fRS ; ( 7 \ \ \ ) \ \ \ \ \ \ \ } ( \ � I - - - � � \ } \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ ƒ ) \ \ \ \ \ \ \ \ s I m m m IT m I m m m } \ Lr � \ / / \ } } \ ) } } ( \ \ ( m \ \ \ § \ \ \ 7 \ \ \ \ \ o \ '\ ( \ \ G ( \ \ \ ) / } } 7I m ( } ( \ } r \c \ \ ( \ \ \ \ / \ \ \ ) \ ( \ { \ \ \ \ \ \ \ ( m m \ \ \ 7mm m m - m I . . . . . m \ m \ } \ \ } / / } \ \ \ / \ / \ \ \ \ / } \ ' \ \ \ } ) \ ll \I I c \ \ ( \ \ \ \ \ �le \ \ \ \ \ ) � ƒ } \ } { } \ ! \ ) ] } I \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ j / } \ \ / 55 \ , � � \ r \o \mm \ \ \ ( \ { } / \ \ / ( � \ o \ m \ \ \ ) } m \ m \ \ \ m \ \ \ ) \ } ( \ ( \ � \ + # , \ } ( / / / \ { } ( \ \ ( / ( / / / [ « } \ \ \ } J ® ® / } / » \ : } ( \ \ , , , , m ® , : , & \ } \ \ m \ \ \ \ \ \ \ \ { \ \ \ \ \ \ � \ r \ c\ \ \ \ \ \ \ \ A / \ \ < , - Eu I - - - - u0 56 \ ; \ \ \ % ; ! f ~ , m , , mel k \ \ \ } \ \ 7I m ( } \ } } \ ( } \ I \ \ \ ) \ ) \ \ k \ k ) \ c \c \ m \ \ ) { } c \m I m ( \ ( / \ \ \ \ \ } � \ \ $ \ } ) ) [ ) [ ) § ) ] § [ } § / ) ) ) § ] ] \ ) \ \ � I I c \ { \ \ \ \ \ \ \ \ & \ \ \ � \ � \ \ � \ \ I \ \ � � \ m \ � \ } } I \ \ \ \ \ \ \ 57 N � N a d 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 m L C O a Y O O a' o � M IO d N O T T T N (O T O r r (O O (O V M OJ O V M N OJ O (O r V (O K N O T o I N N r r M M OJ O M N (O T (O T M OJ M T V M M OJ M N r N r d N N I� OJ N OJ N V M N V O V M N f V OJ OJ N I� O O N T N V V W O (O V V M OJ V OJ N W r r (O OJ (O N r N N N N N (O N W O H O .A O O O M N M M l0 OJ c d a a a a a a a a a a a e a a a a a a a a a a a a a a e a a C N O M I� N O T V O OJ r c M M O N M T O (O M OJ M N N O T y a c O x d p N (O W (O M O OJ W OJ I� O O V V O V OJ OJ N (O OJ I� OJ V O V M M d 7 C K a (p O OJ N O O W O OJ � W OJ OJ N I� (O OJ V (O V M N N M OJ M d a a N x x _ J J O OLO (f Q O D N N T N O r OJ N T N O T r (O T OJ (O OJ N r N y R N �O-` N M a ' I x W OJ M O N OJ N (O (O N W N M OJ N N Com(O O OJ V N V OJ OJ I� N T OJ OJ N OJ V r N (O N M N V V V V Q OJ OJ OJ N V N I� r N c N I M M N OJ O V N (O N OJ M N I� V N r OJ M OJ V V O (O N W V OJ OJ O O V (O I� r W N M V fV V OJ W N M O N W N V N O co m(O mI I I I Id I N a c do d (7 c m O ' u d u x O o amco O E c m d a c m 05 F F y p aNi of = a�i A m o d d U c o O O O c a d y o rn rn y d K m d Q c a d D m cdi d t c y o u a>i > 'v 2` m 2` c > a�0i d a o a�i o z O m Q U U x U x a a m w o a 'u d K m m m m a F F f w 58 N N N a d o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c rn r v N co ro o o N N rn o r N rn rn o r r N O a N V r OJ N O N T fV N M fV r r V OJ M M M N N V T N N r O r T M OJ T W O N N O fV (O 6r r N N d m O O O OJ O W O T OJ W OJ OJ OJ OJ r T r OJ V V OJ Y O G M IO d y M T N M V (O (O N V r r N N OJ (O OJ V V W O N 0. N (O M r l0 N OJ fV T N N V M OJ OJ N O I� r (O l0 Of' Of O O O V (O N V T V N OJ T r r O M CD V r r N T (O N Yal V r O M V N O (O r M OJ M r OJ � T V fV N N (O l0 N W N T O N T O V c OJ O N O r fV M L r r l0 N O O O M L M OJ O OJ OJ V V M � y O (p r (O V (O M M r N (p W O N r C r r OJ OJ O � � fV N N l0 (O V OJ c d a a a a a e a a a e a a e a a a a e a e a e e a d a O OJ OJ N T N M N T O V r r T N OJ (O V N N V y d M O T M O M N T T T W (O V O M r N N N fV OJ a N M M M N M M M M N M N N fV N N M N fV � fV � I C � jp C a r N M OJ O f V OJ V M T N f V N T N r N OJ OJ O O r O �( d O N r V OJ O fV N O N OJ T M M M r N 0 ci O O M M IfJ N r IfJ OJ y� � r IfJ OJ fV IfJ N r r N O C K a O r W N r N 1 M W fV (O W N OJ (O W N r N fV N N O yM d = N � � � M (O r fV co M N N i dwal _ J J mN � 0 V C N N ON TT NO Or (OOJ Nr M l0 ONJ ONJ MO MO NfM V rV0 m N m C W W N fV 10 � (f Q O y r M m M W N O N OJ M M T W O W T M N V O r l0 d d a y x � W r M m M O M N m O (O V O O T V I N N M M fV (O r M (O T fV (O � OJ r Cl! � N (O r r l0 OJ OJ O O fV � N OJ (O W � OJ O r OJ N V l0 O W O N M W W N fV OJ r OJ N N W OJ r OJ N (O OJ v O r � N W W N fV p. M N OJ M r OJ M V Q Cl N r I W N r M r O O N OJ (O W V (O O N O W W M W W O O r M v r M rn O N O (O W O M M O (O T N W V V O O W M T N O M O O M OJ OJ M W r O r (O OJ O r fV V V T W � N � (O M r O V N r OJ N M O N OJ r W N 10 V y fV OJ V N l0 O r r OJ r N OJ M M N fV (O r N MN N E 6 O M CoM c N mI I I I y I d u I � O E O L E T O U y - £ U j d y £o O £ d d y O o 05 N d 05 d a we d a ^tl o N d O m Y p d c .0 d m o Y N ¢ aoi ao .t. c a c aoi U > > cdi w m i a O m U m m a d F o y Z � d U d m m r p p ~ 'Q d o d a 9 9 o m ai E 5 m C L Ol 59 r M � N a d 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 m L C OI O r r T O (O M O OJ M V O V (O O O r OJ T OJ (O fV r O a O O (O OJ r M V N M M M OJ M N M r (O r V D O O M T N Yd O O o' o M IO d N O (O (O OJ IfJ IfJ M O M OJ (O O (O M W (O N O r OJ O (O IfJ T N O OJ (O y N N � IfJ M OJ M O T O R IfJ T M IfJ N T O r O OJ OJ O IfJ (O � W N M N 0. M M W W IfJ IfJ N OJ W r C6 W M V r N M OJ N M OJ W IfJ N a C O O V � O IfJ OJ W M N r W N M M M M M r r OJ O OJ (O o I O O O O r M OJ N N IfJ (O T r l0 IfJ T O N M M N N IfJ IfJ r O N O O O M N M m IfJ V O r O O V m V M r M M O M N w N V r r N N IfJ M (O O V M N c N (O (O (O OJ O IfJ T O r W m m N m N OJ IfJ O � � O r M M OJ (O W OJ IfJ W N fV M V I N O OJ r N N V N V IfJ � W W y O O (O IfJ N IfJ OJ V (O V O IfJ N r OJ M r IfJ N IfJ O O O V (O � OJ N M N r V M l0 W O c d a a a a a a a a a a a e a a a a a a a a a a a a a e a a a C N O OJ N r N O r T O OJ M � T OJ OJ (O OJ IfJ r O (O T M M IfJ � V (O y d O N M (O N T IfJ r V (O O T O V O V IfJ N N T (O O r O M a c O � p� O M OJ r T (O IfJ OJ V O O � � IfJ OJ N (O r � OJ r r r IfJ V IfJ fV IfJ r N C a r V r IfJ (O M M V M r r IfJ IfJ IfJ OJ N V O V r r V IfJ M IfJ r d ; O O OJ N M IfJ M T OJ r (O l0 OJ T O (O M V (O OJ IfJ (O V OJ T � d p] O N OJ N (O IfJ V N M W V O O O IfJ O r OJ N (O O V N O W IfJ v r v O V M V M IfJ W W IfJ N W (O M V V r V (O IfJ W IfJ (O M N W C C C M d Y L O y � (O (O W ifJ N r OJ M N O T M W N V r N V M O r IfJ O IfJ M M (O N y C m w Q d M M OJ W M OJ W W M O (O M IfJ r OJ m V O N O m V M N V r W W IfJ V d y O O V M (O �_ M V V N O � (O N mmO OJ < < r � N r 0 V V O O O O M N N V r OJ N T N OJ M M r r O IfJ IfJ IfJ O r M y a - - N - - M M -M M r M IfJ � � - M O fV r N fV a u I( r V (O M N r OJ IfJ (O OJ OJ O IfJ OJ N (O � (O N V O r M V N M T W (p r M IfJ M V OJ LO r r V M M M O OJ O IfJ OJ IfJ r T (O l0 N r M M (O r OJ M G COM IfJ V V (O V I M OJ O O OJ N (O < < N OJ r (O IfJ O O O OJ N r N W r r N r M V N O IfJ M � V N IfJ OJ p. (O OJ IfJ OJ N V N OJ OJ � � N OJ M I (O (O OJ OJ O OJ (O V O r V O V O r N W OJ V OJ V N r O r (O N W N N N T V O (O IfJ OJ M V r (O V IfJ (O M T V V r (O (O N W M OJ M M W O M r (O W N M � IfJ OJ V O O V (O IfJ V IfJ OJ OJ r (O V m m d T T T r V N (p pJ O M M r l0 r T (O N IfJ IfJ IfJ (O IfJ N M O N O IfJ IfJ N r OJ � M T r IfJ N m � N O (O r M IfJ � (O OJ M mfV N � mI I I I I I Id I y a c m a c a�i v, c m o cdi p w d c o m F y d Q c a d a ) D 'u d 60 r M fY fV d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 pl LC OI V T OJ cl O M l0 M � M N N T r r O V ifJ (O W W fV T (° N m IfJ O fV O r OJ OJ g IfJ N M N d m O O O O W � O O W W W OJ r W r OJ OJ Y O G a o M IO d N O IfJ IfJ N N r V O M r M O M N r � M V V l0 M � � O N N IfJ y IfJ l0 r OJ N r O IfJ (° O r r M fV Yal T ifJ V O N W W m M O t0 T N r v r r t0 N O r M M O N W H O (° OJ v r r N r O O OJ fV H O r OJ OJ (° fV O O O IfJ l0 O (° r l0 OJ OJ N W c d a a a a e a a e a a e a a a a e a e e a c N In o o (o of r v N rn v ro v r M m N N r y d N N M O OJ V l0 O O r V M r N f V OJ a N M M M M M M M M M M M N N M N fV fV � I C O pl r IfJ O O N M (° W N N IfJ T IfJ N fV N fV M fV N C p N M T OJ N OJ OJ N O V N V O O r O O W f V dm m m; V V N (° OJ IfJ M OJ IfJ r T O V O O N � d p] (° � O (° r N V l0 (° O l0 (° r IfJ OJ OJ r r � O V IfJ r N O OJ O IfJ N (° (° OJ N V Ifs N r fV (° 10 fV co M M� V C a O r r V r T r ID L � Q d OJ (° � O fV V O N OJ T r OJ OJ T OJ O O 't r O M V V OJ m O N IfJ N C, IfJ O OJ OJ M T W r c Oy y r r M fV IfJ (° � N r W N N M W l0 a A O N fV c W ' I c U N N � O N M O V M M N fV r O M W H co r Cl! V l0 E IfJ (° (° r N O O fV fV Q fV � l0 I N M N r L V M r O OJ V V N (° M M N N V (° O N fV O O l0 fV N M M O T N OJ M r O IfJ OJ O r fV T W O � O M M O fV V c N C7 M N M r r V y N M N fV V r OJ T OJ T OJ Cl M M (° l0 O N mI I 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 ._ d N p ° U 5 cdi w m i a m U m m F o N m o d a L L c w x z U y N U d U N O N _ N _ Y d ° U7 d ° ° N F d A N N N N y O C N9 9 O N N J N N L pl U J Q] d a s } a x x a a Lb 0 _ c N N N V 61 M N � N a d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 m L C OI N V IfJ I� M r O IfJ M (O � r O (O fV IfJ r N O a I� V T � M IfJ IfJ r M N OJ T V O r O T OJ O � O IfJ (O V O O N M W V W M OJ N (O O N 1� OJ W Y O G o. o M IO d N O O O M M V OJ (O V OJ OJ O O O V OJ M r M IfJ N O M O O O OJ M (O IfJ OJ I� T W O IfJ N O T (O l0 W (O O N r r T N a C IfJ IfJ � OJ W r (O (O O V r N W r M (O l0 (O W OJ V < � O � � V M V IfJ N 1� N M N OJ r T N O OJ (O l0 IfJ N W O O I� M V V OJ W W V r (O W O r W IfJ N T OJ fV � > ° I aI � � N T T T OJ (O N fV O O O M OJ I� OJ V OJ T A M M O T N OJ O M IfJ M c O O O O T O O IfJ I� (O O OJ OJ N O IfJ V � V V < < O IfJ N V M IfJ M N � V W M M C r 'y.. V IfJ O (O O IfJ N fV � T IfJ V W (O IfJ � M M M c c o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C N O V I� OJ OJ V r T l0 T M IfJ OJ N T M T r N c d a Lo N V O M V O I� OJ T T OJ O IfJ M T fV O O y d IfJ IfJ IfJ a N N M M M (O N V N fV N N M fV M N M � I j m O O m T M T O m T N O V V O O O T T N O V r O T r O O r O C a IfJ T V V O OJ (O V M OJ W O IfJ N V O O l0 O I� M O M V O O IfJ O d p OJ I� O I� O M V IfJ W 1� O N fV r W M W m m MM r l0 M c O O I� O 0'I IfJ IfJ N IfJ (O fV T V N r M fV (O r (O (O fV IfJ N IfJ O OJ T W M fV r (O N l0 (O N E O N OJ N fV IfJ O y K a N W (O N N IfJ (O 4 1 N OJ IfJ l0 (O IfJ N y M OJ fV � IfJ a y M y N N V co IfJ (O N fV IfJ l0 O N LL N A O. O 7 d O O V IfJ T T OJ (O � O O O T V V I� T V O N fV O V d a O' O O (O V IfJ � N IfJ (O M O IfJ N O T IfJ 10 N OJ M N T W (O r Q N V V N r IfJ r N Lo O M O N fV r (O N l0 (O O N W (O l0 IfJ N IfJ O N W V M IfJ r N N IfJ M (O � M M V V M OJ V I� OJ V O V N T IfJ M OJ M (O IfJ N OJ OJ y I� r T O IfJ M M c O N fV N M IfJ O V r (O r IfJ N N N V V OJ O O O (O OJ W M m OJ V (O M r r W IfJ V W N fV I O O W M OJ OJ O (O OJ O OJ O O O O OJ OJ M W N I� OJ r O W W O O � O IfJ IfJ IfJ IfJ V O M M O ID O IfJ N V (O IfJ l0 M N W N O O O M O T T O IfJ IfJ M O M V O IfJ I, r OJ OJ M M OJ IfJ T r fV O (O (0 IfJ N (O O V V V N OJ V O IfJ V IfJ OJ M OJ I� r r N IfJ y O OJ (O l0 OJ W N fV IfJ O I� r M O T V N r OJ (O M N r r l0 O r N O IfJ OJ M IfJ c mI I I I I y d u N U) (n y C d O T O) £ O £ 8 O N £ � d d d O y m c U E E O d 0 c ow o a a�i (0) r (0) L' ,� o = L' m w d m y m N y a x m w y y d Nd Umo x°£d wm x 2mo �FmNd i0 £ o m a d a d d vdo, t t m D 0 - U 2 ii 0 0 m 0 Q x 0 a a a a a x O O d K m m m m a w 62 M N N � 0 0 N a d c rn r o a o In ci M IO d fV R l0 M V N L C Yal Im c rn N m d o vmi N r n d 'G o M m � a _ QIo 0 = yl " d a N i H r m � I C a 1d M 1d v y M y a ci N M C LL N A 2 v m K o o m y ' I " o " m_ I � M QI c I M t0 mI I I I I I � C Id I " d. I = y o a u I � a r p f aLi N a a L m � m 63 o N a d o 0 0 0 0 0 0 °f o a m o o m N cOl Cii, N N r N d m OJ N fV c Y O O a' o � M IO d N O O M M � IfJ N N W d IfJ IfJ V O M OJ r r r O a N N OJ (O IfJ r r r r O T N W C d i N N M M O M T N fV O O O fV V O N W OJ OJ OJ OJ cc' N N M cc' OJ O - V V ifJ M N N' W W W a O O O MO c d a a a a e a e e a m a o m N v v v y d o r r c a N o N � I c p v M o 0 0 0 0 o m d � � O IfJ V V IfJ N N O K a IfJ r N N M M M O y y M y a N W N N fV ci C ° O alN N N L LL O = "y d a M c c u y > >. m v 2 d in in v v coo m o N N N � Q N N T IfJ (O W T W W W y W y .d. o o rn rn o m O OJ N O O M M M r V N OJ OJ O O O r (O OJ OJ N fV fV l0 T T T T 'Q ifJ ifJ N N QI I O O IfJ � (O l0 (O l0 l0 O N N T O O M V V ' OJ d r r N IfJ N ! M CO N OJ V r N M W p M T M c N fV c mI � � I I I I I C d y U £ d d a m d d 9 p y a K y O d c i 7 U K 7 i p, Z d O p) N F N d N r U r C K ¢] = F D A d � O C N U d 64 N � M I o00000 0000 0 N a d m L C OI O I� N O M c OJ N r OJ OJ O a OJ N (O O N O T N N I� OJ O (O r r (O OJ fV fV N d m OJ O OJ O OJ OJ I� N T r r Y O O o' o M IO d N O N N M r r r V W OJ V r W W O O OJ OJ V O I� V fV OJ V r O O fV V O N N W o I M M N N N N N y O O N M M O (O V O N (O cl T T N M M fV CO ITO CDW I� O O W W O y 0 M O V OJ I� r O (O OJ N N M M fV 'q C d O N N c r N O O fV aI o 00000 0 0000 0 C N O O (O V M V N T OJ (O l0 l0 a N O N M N M N M N M fV fV � I C a N V V N (O N N N T OJ OJ fV d m V N M M V V V O (O r K a O W V I16 N V M N M M r y M y a N N N c O M N l0 c a " ` I C d O d 2 O. OJ OJ OJ I� O N OJ l0 T V N r r W ro a M N N PZ V W j U d o D ro ro in v w � r i v c c N m v N N (O M N m OJ (O M N l0 V � t0 NW M OJ V V M M OJ N N (O N M CO M N (O M fV fV O M ID OJ 1t r V M IQ N M ' ' I OJ OJ O � V I� V fV N I� N N N l0 V V O V N O N W N N O O M M N V OJ V O M N V OJ W W � .0 r OJ r r N N W OW 0 mI I I I I I I I N J y C S d N 2 N N y n d m V N d taf `d-' 9 C r is d d y �n c d o o N o � 2 � d d � � � � � y c m ro o c a rn d K m o = = H m m Q a d t y o a N m m U 2 z O m Q a 0 0 c 'u d 65 M � M o 0 0 0 0 0 0 0 0 0 0 0 0 fV d m LC OI V (O N O N M N (O M r W W O a in o r w o rn m rn r v r r r O r IfJ O T W V V N (O l0 l0 N d m � O W O W W OJ r O W OJ OJ Y O O M IO d Nd OJ OJ r OJ N m r N IfJ (O O m W l0 N a O W ifJ N r O V ifJ N' N' o O O (O T N V y N O N O O T M CO CD T m O CO cc cc OJ y d V V N N V V Yal O N N N V (O M OJ V O OJ V OJ M IfJ OJ (O N W m M O M cl cl W W O T O IfJ OJ r O IfJ OJ r in co v o M ai o o m m r d O M r rn m mo r O O N 'c � � rn M in rn l m co CO co i LnO N N r aI o 000000 0 000 00 0 C N O OJ IfJ V M l0 N V (O M M d a O M T T M M O M T N W W y d O r M IfJ M M M OJ V V N OJ OJ y N O M M M M M � N N M M fV fV a m I o r N rn v N r rn in � in r r �o C a OJ O M IfJ N O O IfJ O (O M M OJ d � V O O IfJ T W N V (O OJ fV fV fV M V V IfJ T W r O r N N K a O IfJ W W r (O O M (O V V (O v cl M = I y = a M c c O � d O O O (O r IfJ N M r V r Q N N T sm r V (O N V V M O (O cl cl � OJ OJ IfJ T O O N T r OJ OJ O Cl! W W r V V OJ (O M I� IfJ O N (O V IfJ IfJ M �jO D O O OJ T r OJ OJ O OJ M r O O OJ y r r W � r rn t0 M G M r t0 t0 O ' I OJ N r OJ r � � IfJ IfJ M r O O W _ M IfJ V M OJ OJ O V O M W W M V O r r OJ O W OJ OJ _ I � N OJ OJ OJ O V OJ O r IfJ r O M r OJ OJ O CDT CD OJ mI 0 O N m(O mV fV fV V V V O (O (O IfJ O N V N � IfJ M r r OJ O O IfJ M IfJ N OJ OJ T N O m r r T_ (O co CDI W0 O r V M V O O l0 p V V N N y y mI I I I I I I N J m r U 12 d C d N y H d y c m W 0 N p F = d d N N J d > > > a N r o m c m y rn d K m o U U U = = H m m 2 d a cdi t ' o a 1i :0 9 9 9 t t m N N m LL U z O m Q a a a 0 0 c 'u d K m m m m a v off ¢ w w 66 N N � M o 0 0 0 0 0 0 N a d c rn rn ro rn N rn O a r co N m ro m m M N r M O O O N d m N (O N W OJ OJ OJ Y O O a' o � M IO d N O O O M N OJ fV N N N r d O O r M O W (O l0 l0 N M a N N O T O V V V l0 N a 0 O I O O (O T (p M O O O NO N N N N � N fV fV M N r rn m r r r m O N M M r r r M M CD CO M CD W W l0 O C r N M M (O l0 l0 M S u+ o r rn r r v yy yy r E0 c d a a a a e a e e a c N o M rn o c m a a d p o rn ro rn m m y N O N l0 N fV fV � I j m O p N N O O 0 0 C a O N (O l0 N V l0 l0 W d M N N N 6 T N N W d p] W (O N N O N M M K a r V V N N N fV a � N fV N fV fV = I ° C� WX y m a M c c n d > > ° £ v 2 0 o m M ro M ro m m U V U Q jp N N (O (O N ITV V O A O O N fV fV M O W N r CO COM N oc OJ OJ OJ l0 N O N fV N fV fV O O V V N N N V N r r r N N M OJ OJ N fV fV � M r O O (O l0 l0 N p. N fV N fV fV QI I O O O M M M O V N N fV N N O Cl! N O W O O O N N OJ V N r V N r r O mI � � I I I U � N m i £ � ° d N O A K mm O O N r a d d F d a O O -O m N N — Y N f d N 2m e m o > m d a m m m U Q d a 0 c w � w 0 67 Mc I o000 00 0000 0 0 d p LC m d a y a0 ro rn rn o rn m rn ro m m m y o 0 a' o M IO d m Is IfJ r (° M r T N r OJ OJ OJ IfJ O O r d M m OJ V M IfJ V m m m r O m m O N R OJ OJ O (° N T O OJ OJ IfJ IfJ T OJ OJ O o M M r T M N 0 O O O N W pJ N r T M m M O m cl fV r Yal OJ V N N N OJ OJ N N (° O O O OJ IfJ (° N r N fV T OJ r l0 l0 l0 O M N fV fV r m O N V N M IfJ m m W OJ OJ N O V O OJ OJ O c c o 0 0 0 0 0 0 0 0 0 0 0 0 c N o �n co o rn o o M ro c c d a O M T M m m N N OJ T y d O OJ M fV IfJ M r N r r y N O N M M M M � N M N N fV fV a � l c � m LL � rn � m M ro m ro o � ro M in � co in m m r y cp r v N o v o 0 o in co co c CO M M m m � > p] r M r IfJ N W W m O IfJ OJ r OJ O OJ OJ m d d O d M IfJ O O m O. IfJ IfJ N OJ OJ O r oc OJ N IfJ (° l0 l0 fV N = � I d ' I y L O M OJ O O M M IfJ IfJ N OJ V O O r CO Cl! fV M OJ M N N l0 I 0 1p O V O V N W r fV fV m p. OJ N M M M N M O O fV Q � � I m m ID OJ w fV IfJ IfJ O N M O V r O V O (° � V V c OJ OJ O M M O OJ l0 T OJ IfJ T N N V V O r IfJ T N r OJ OJ O V OJ O O O r M M_ V OJ M O N m N O N M O O O O fV � O N N T N (° OJ IfJ O V IfJ � (° fV fV l0 mI I I I I I I v, d I d d d 5 c y m e a�i L' N m N w m N U N (n w C d N 9 C y m a c d m m m cLi m pd F d d c "m 0 m ~m m x d y ° ° an d d o c m 'c m F o d m O p C _O m rn al ii N r ° Lb O m m U O m Q ii - ii a 0 0 c ' d K u m m m m m a m v w � w` 68 N � N a d I o0 0 000000 0 m L C OI (O (O l0 T OJ I� O r M M O a rn rn o rn r r co 0 0 (O (O OJ N O M T O fV fV N d m O O W V V O V W W Y O O a' o � M IO d N O M M OJ OJ OJ O O O W W f V d O O IfJ IfJ l0 IfJ O N M M M M fV (O M IfJ O r r l0 N a C (O (O (O (O Cl (O O �_ M m cli m W o M M O O M O O O W N N OJ OJ (O I� V r r r M {y' cd N W W M m ILo N r S H m ID N N N N O N W W l0 C r ':+ ifJ N V t0 ifJ M .A C dO aI o 00 0 000000 0 C N O N N fV M W (O I� N OJ OJ d a O M M OR l0 y d O N N l0 V M O (O O O y N O M M N M M V M M a j m I M M � T � r O IfJ fV fV fV C a M M M N N O M N fV d r r r v v co m m o M OJ O N r W W � y LL 0. M c c � a d' O O OJ OJ OJ OJ M O V � OJ OJ O r_ A � Q d O O I� r r O IfJ OJ O N N fV O p m co r r co co O co m m a Cl N N N OJ N N N W A W W IfJ IfJ � M V V W ' I ifJ ifJ N T t0 M t0 t0 W W t0 T T W O IfJ V I� r V V V OJ O V O IfJ OJ OJ M N N fV (O � IfJ M M OJ O O O W V M M l0 p. M M I V V O O M IfJ IfJ V M IfJ fV fV O O IfJ IfJ N M N N N (O fV fV fV (O (O M M W M V M IfJ OJ OJ d N N M M N V IfJ V O IfJ W W l0 mI � � I I I I o d _ d m u y N j N Q pma N N C d d i N y Q] N d a of O N C C d li cdi d d E O O c a N d r £ d Q 2 d >O> U d R55JCO21 City of Kent 5/22/2013 9:4.57 Fiscal Year: 13 Period: 4 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- 78,819.35- 30,237,016.17- 3,305,371.83- 90.15 Charges for Services 72,963- 93,702.69- 8,453.84- 102,156.53- 29,193.53 140.01 Miscellaneous Revenues 24,750,338- 16,312,401.88- 149,996.38- 16,462,398.26- 8,287,939.74- 66.51 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- 6,438,236.35- 5,148,000.65- 55.57 Total Available Resources 106,275,510- 89,773,569.63- 237,269.57- 90,010,839.20- 16,264,670.80- 84.70 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 150,000.00 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 17,936.58 72,327.59 342,669.41 17.43 Railroad Quiet Zone 52,807 4,727.37 4,727.37 48,079.63 8.95 108th &208th Intersection Imp 41,813.86 11,519.11 53,332.97 53,332.97- Asphalt Overlays 2009 6,043,099 1,238,230.38 78,210.37 1,316,440.75 4,726,658.25 21.78 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 4,533.38 7,024,845.11 354,250.89 95.20 Lincoln Ave/Smith St Improv 765,012 857,746.02 177.70 857,923.72 92,911.72- 112.15 256th Street-116th to 132nd 58,000 58,000.00 BNSF Grade Separation 19,877,044 19,737,852.17 19,753.98 19,757,606.15 119,437.85 99.40 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 614.90 6,662,130.66 913,286.34 87.94 Willis St UPRR/BNRR Grade Sepr 881,627 240,077.46 248.50 240,325.96 641,301.04 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 229,378.43 1,030,782.09 1,284,575.91 44.52 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 25,436.11 32,178,984.93 1,317,544.93- 104.27 224th-228th Corridor East Leg 11,293,362 1,857,313.29 13,504.97 1,870,818.26 9,422,543.74 16.57 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 10,174.69 1,550,123.47 1,992,245.53 43.76 72ndAve Imps(5.196th-200th) 61,456.04 33,386.37 94,842.41 94,842.41- Total Expenditures 106,275,510 86,291,724.72 444,875.09 86,736,599.81 19,538,910.19 81.61 Ending Balance 3 481 844.91- 207 605.52 3 274 239.39- R55JCO21 City of Kent 5/22/2013 9:1191 Fiscal Year: 13 Period: 4 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,496,463- 2,226,664.78- 50,487.22 2,176,177.56- 320,285.44- 87.17 Charges for Services 43.84- 43.84- 43.84 Miscellaneous Revenues 1,319,774- 1,166,172.26- 263,248.35- 1,429,420.61- 109,646.61 108.31 Operating Transfers In 3,209,117- 2,519,433.79- 189,684.00- 2,709,117.79- 499,999.21- 84.42 Total Available Resources 7,046,361- 5,933,320.49- 402,445.13- 6,335,765.62- 710,595.38- 89.92 ARRA-Comm Putting Prev.to Wk 111,504 111,504.38 111,504.38 .38- 100.00 Parks FIL 189,684 189,684.00 189,684.00 100.00 Regional Trails/KC Levy 806,538 377,481.00 1,973.70- 375,507.30 431,030.70 46.56 Boat Launch Fees 32,432 3,617.44 1,632.03 5,249.47 27,182.53 16.19 Lake Fenwick 111,860 113,330.69 10,382.62 123,713.31 11,853.31- 110.60 Paths and Trails 132,243 81,433.65 1,470.00 82,903.65 49,339.35 62.69 Adopt-a-Park Program 474,448 454,577.60 4,929.90 459,507.50 14,940.50 96.85 Street Tree Replacements 127,603 97,255.77 97,255.77 30,347.23 76.22 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 156,702 173,850.46 12,754.09 186,604.55 29,902.55- 119.08 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,196,681 429,142.14 100,754.75 529,896.89 666,784.11 44.28 Kent Loop Trail 120,000 92.18 92.18 119,907.82 .08 Urban Forestry Plan 283,671 272,395.05 15,925.74 288,320.79 4,649.79- 101.64 Community Parks Reinv. Program 186,909 186,909.00 Parks Land Acquisition 1,713,447 1,183,867.23 9,000.00 1,192,867.23 520,579.77 69.62 Senior Center Memorial Gift 103,749 103,749.00 Green Tree Park Renovation 120,000 120,000.00 Total Expenditures 7,046,361 4,175,278.75 344,651.61 4,519,930.36 2,526,430.64 64.15 Ending Balance 1 758 041.74- 57 793.52- 1 815 835.26- R55JCO21 City of Kent 5/22/2013 9:1647 Fiscal Year: 13 Period: 4 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- 185.95- 180,124.94- 180,124.94 Non Revenues 10,242,533.86- 10,242,533.86- 10,242,533.86 Other Financing Sources 17,000,000- 27,840,000.00- 27,840,000.00- 10,840,000.00 163.76 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- 185.95- 109,193,890.45- 6,273,427.45 106.10 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 364.85 136,878.42 136,878.42- LTGO Bonds 2008 17,000,000 16,762,887.05 218,083.93 16,980,970.98 19,029.02 99.89 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 218,446.78 109,125,270.93 6,204,807.93- 106.03 Ending Balance 286 880.35- 218 260.83 68 619.52- R55JCO21 City of Kent 5/22/2013 9:1133 Fiscal Year: 13 Period: 4 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- 314,158.64- 7,150,301.09- 1,077,827.91- 86.90 Total Available Resources 8,229,412- 6,837,425.87- 314,158.64- 7,151,584.51- 1,077,827.49- 86.90 Software Lifecycle Replacement 321,605 321,605.07 321,605.07 .07- 100.00 Hardware Lifecycle Replacemnts 2,698,973 1,700,129.82 23,626.03 1,723,755.85 975,217.15 63.87 IT Systems 2,209,039 2,049,260.48 5,029.81 2,054,290.29 154,748.71 92.99 IT Tech Services 2,182,806 2,182,806.60 2,182,806.60 .60- 100.00 IT Multi Media 29,154 27,338.64 27,338.64 1,815.36 93.77 Long Term Lifecycle Replacemts 787,835 787,835.00 Total Expenditures 8,229,412 6,281,140.61 28,655.84 6,309,796.45 1,919,615.55 76.67 Ending Balance 556 285.26- 285 502.80- 841 788.06- R55JCO21 City of Kent 5/22/2013 9:161 Fiscal Year: 13 Period: 4 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 2,669.05 7,549,515.80 85,748.20 98.88 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 2,669.05 7,635,454.23 1,242,467.77 86.00 Ending Balance 1192425.07- 50042.71- 1242467.78- R55JCO21 City of Kent 5/22/2013 9:17:07 Fiscal Year: 13 Period: 4 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- 4,238.36- 2,474.36 240.27 Miscellaneous Revenues 771,649- 2,883,509.32- 14,542.93- 2,898,052.25- 2,126,403.61 375.57 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- 259,880.93- 88,104,974.03- 2,184,617.86 102.54 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 2,236.64 490,972.93 15,779.93- 103.32 Water Unallocated Projects 2,454,662 2,454,662.00 Rock Creek Mitigation Projects 735,000 47,907.50 10,565.00 58,472.50 676,527.50 7.96 Guiberson Reservoir Repair 3,678,847 179,378.31 64.14 179,442.45 3,499,404.55 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 1,327.25 1,327.25- 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 10,920.40 4,804,961.30 835,790.70 85.18 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 14,655.70 55,344.30 20.94 East Hill Pressure Zone 4,703,686 91,366.12 386.04 91,752.16 4,611,933.84 1.95 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 4,925,156.78 19,147.22 99.61 East Hill Well Generator 735,000 36,127.30 13,572.40 49,699.70 685,300.30 6.76 Clark Springs Source lmprvmnts 574,278 41,871.57 41,871.57 532,406.43 7.29 Landsburg Mine 600,000 258,952.53 4,164.94 263,117.47 336,882.53 43.85 Clark Springs HCP 212,722 222,221.43 6,090.85 228,312.28 15,590.28- 107.33 Hydrant Replacement 2005 90,043 50,481.88 50,481.88 39,561.12 56.06 Large Meter/Vault Replace 2008 180,341 130,305.32 7,652.71 137,958.03 42,382.97 76.50 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 R55JCO21 City of Kent 5/22/2013 9:17.Q7 Fiscal Year: 13 Period: 4 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 55,669.46 64,146,019.17 21,774,337.00 74.66 Ending Balance 23 754 743.39- 204 211.47- 23 958 954.86- R55JCO21 City of Kent 5/22/2013 9:17:92 Fiscal Year: 13 Period: 4 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- 2,153,043.90- 18,285,810.62- 2,964,967.38- 86.05 Charges for Services 4,000- 295,965.02- 45.66- 296,010.68- 292,010.68 *****- Miscellaneous Revenues 743,652- 882,853.34- 1,414.26- 884,267.60- 140,615.60 118.91 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- 2,036,635.87- 43,753,397.66- 8,455,009.34- 83.81 Total Available Resources 88,982,149- 73,803,658.65- 4,191,139.69- 77,994,798.34- 10,987,350.66- 87.65 NPDES Permit 3,667,335 2,730,172.56 51,218.23 2,781,390.79 885,944.21 75.84 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 1,530.00 3,751,808.60 1,803.60- 100.05 Drainage Unallocated Projects 258,719 258,719.00 Misc Environmental Projects 435,562 732,783.87 14.99 732,798.86 297,236.86- 168.24 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 376,419.04 889,961.14 1,240,038.86 41.78 Citywide Stm Pipe/Culvert Mtc 4,100,000 3,656,438.45 2,720.70 3,659,159.15 440,840.85 89.25 S. 228th Drainage Bypass 6,950,000 6,253,577.29 19,098.50 6,272,675.79 677,324.21 90.25 Mill Ck/James St. Pump Station 5,366,670 4,209,785.62 129,193.67 4,338,979.29 1,027,690.71 80.85 Upper Mill Creek Dam 2,435,000 237,340.27 106,884.92 344,225.19 2,090,774.81 14.14 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 428.82 592,350.72 107,649.28 84.62 Earthworks Overlays 1,196,621 1,180,686.22 1,180,686.22 15,934.78 98.67 Lake Fenwick Restoration 2009 20,895 9,215.48 9,215.48 11,679.52 44.10 256th Flume 510,000 439,796.93 439,796.93 70,203.07 86.23 Lake Meridian Outlet 2,718,065 2,717,742.13 9,942.22 2,727,684.35 9,619.35- 100.35 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,990,000 2,101,505.98 8,173.03 2,109,679.01 880,320.99 70.56 Downey Farmstead 550,000 318,200.13 44,809.39 363,009.52 186,990.48 66.00 Bauer Property 310,000 137,691.10 405.68 138,096.78 171,903.22 44.55 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 505,748.79 11,502,309.18 2,627,107.82 81.41 Upper Russell Road Levee Impr. 2,353,121 1,083,916.31 90,523.17 1,174,439.48 1,178,681.52 49.91 Lower Russell Rd Levee-S231 st 600,000 450,916.07 59,748.17 510,664.24 89,335.76 85.11 Lowest Russell Rd-Van Dorens 290,000 211,957.36 20,650.63 232,607.99 57,392.01 80.21 R55JCO21 City of Kent 5/22/2013 9:17:22 Fiscal Year: 13 Period: 4 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 258,243.99 2,668,391.18 1,521,608.82 63.68 Briscoe Levee Improvements 940,000 570,503.72 278,422.26 848,925.98 91,074.02 90.31 Desimone Levee Improvements 300,000 528,062.48 36,288.80 564,351.28 264,351.28- 188.12 Green River Sandbag Removal 2,443,541 773,523.15 54.77 773,577.92 1,669,963.08 31.66 Misc Drainage 2008 2,388,932 1,591,332.26 29,058.47 1,620,390.73 768,541.27 67.83 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 2,253.58 42,000.09 42,000.09- 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 77.41 290,147.58 9,852.42 96.72 Unallocated Sewer Projects 111,247 111,247.11 111,247.11 .11- 100.00 Kentview Sewer Interceptor 275,044 249,844.91 23,015.86 272,860.77 2,183.23 99.21 Skyline Sewer Interceptor 20,000 6,670.33 6,670.33 13,329.67 33.35 Linda Heights Pump Station 150,000 58,377.15 1,152.12 59,529.27 90,470.73 39.69 Misc Pump Station Replacements 100,000 100,000.00 Derbyshire 50,000 50,000.00 Misc Sewer 2007 6,567,710 5,990,390.01 5,990,390.01 577,319.99 91.21 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 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,429,429.07 2,059,979.05 71,489,408.12 17,492,740.88 80.34 Ending Balance 4 374 229.58- 2 131 160.64- 6 505 390.22-