Loading...
2018-12-11 City Council - Full Agenda-2236Agenda Edmonds City Council COUNCIL CHAMBERS 250 5TH AVE NORTH, EDMONDS, WA 98020 DECEMBER 11, 2018, 6:00 PM Edmonds City Council Agenda December 11, 2018 Page 1 1. CONVENE IN COUNCIL COMMITTEES THE CITY COUNCIL COMMITTEE MEETINGS ARE WORK SESSIONS FOR THE CITY COUNCIL AND STAFF ONLY. THE MEETINGS ARE OPEN TO THE PUBLIC BUT ARE NOT PUBLIC HEARINGS. THE COMMITTEES MEET CONCURRENTLY IN SEPARATE ROOMS AS INDICATED BELOW. 2. FINANCE COMMITTEE (JURY MEETING ROOM) 1. Review of Small and Attractive Assets Policy and revised Capital Asset Policy (20 min) 2. Review of October Financial Report (10 min) 3. Fund Balance / Reserve Policy Planning (10 min) 3. PUBLIC SAFETY PERSONNEL AND PLANNING COMMITTEE (POLICE TRAINING ROOM) 1. 2018 Non-Represented Employee Compensation Study (20 min) City Council Agenda Item Meeting Date: 12/11/2018 Review of Small and Attractive Assets Policy and revised Capital Asset Policy Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History As part of our goal to update Finance-related policies and procedures and in response to auditor comments, we have created a new Small and Attractive Assets policy, which we would like to review. We also would like to review some small changes to the Capital Asset policy. Staff Recommendation Review both policies and move to November 20 consent agenda. Narrative Attachments: CapitalAssetPolicyNov2018 Small and Attractive Asset Policy November 2018 2.1 Packet Pg. 2 1 RESOLUTION NO. XXXX A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, ADOPTING THE CAPITAL ASSET POLICY AS ATTACHED HERTO. WHEREAS, the City of Edmonds is committed to the highest standards of responsible financial management; and WHEREAS, the City Council Finance Committee reviewed the Capital Asset Policy at the November 13April 10, 2018 Finance Committee meeting; and WHEREAS, best practice shows that finance related policies should be formally adopted by Resolution; now therefore, THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, HEREBY RESOLVES AS FOLLOWS: Section 1. ADOPT THE CITY OF EDMONDS CAPITAL ASSET POLICY. The city council hereby adopts the following attached document: City of Edmonds Capital Asset Policy to read as set forth in Attachment A hereto, which is attached hereto and incorporated herein by this reference as if set forth in full. 1. RESOLVED this xx17TH day of xxApril 2018. CITY OF EDMONDS _______________________ MAYOR, DAVE EARLING ATTEST: CITY CLERK, SCOTT PASSEY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: RESOLUTION NO. XXXX 2.1.a Packet Pg. 3 Attachment: CapitalAssetPolicyNov2018 (Review of Small and Attractive Assets policy) Attachment A 2 City of Edmonds Capital Asset Policy April November XX 17, 2018 Resolution # XXXX 2.1.a Packet Pg. 4 Attachment: CapitalAssetPolicyNov2018 (Review of Small and Attractive Assets policy) Attachment A 3 1.0 PURPOSE: To establish a Policy providing stewardship over the City’s capital assets, as well as the capitalization and depreciation or amortization of capital purchases over time, as appropriate. 2.0 FUNDS AFFECTED: All City funds. 3.0 REFERENCES: RCW 43.09.200 Budgetary, Accounting, and Reporting System (BARS) Manual, Part 3, Chapter 3, Capital Assets Budgetary, Accounting, and Reporting System (BARS) Manual, Part Three, Chapter 7, Capital Assets and Internal Service Funds Office of Management and Budget, 2 CFR 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards Office of Management and Budget, 2 CFR 225, Cost Principles for State, Local, and Indian Tribal Governments Edmonds City Code, Chapter 3 4.0 DEFINITIONS: 4.1 "Assets" – All land, buildings, improvements, infrastructure, permanent works of art and historic collections and equipment purchased, donated, constructed, or acquired by the City. 4.2 "Capital Assets" – Land and improvements to land, including right of ways and easements; permanent artwork and historic collections of any value; improvements and infrastructure; buildings, their furnishings, fixtures, and furniture; equipment, machinery, vehicles, and tools; intangible assets such as water rights, and computer software; with a value of $5,000 or more for non-infrastructure, or $50,000 or more per item for infrastructure, or $100,000 or more for repairs or replacements to components of the Wastewater Treatment Plant, and having a useful life exceeding one year from the date of acquisition. 4.3 "Control" – Being in charge of, and having the authority to manage the asset. Having custodial responsibility of the asset includes but is not limited to the caring, keeping, safeguarding and protecting the asset. 4.4 "Infrastructure" – Roads, bridges, water lines, sewers, and drainage systems. 4.5 "Small and Attractive Assets" – Assets that are particularly at risk or vulnerable to loss and cost less than the capitalization threshold of $5,000 and have a life 2.1.a Packet Pg. 5 Attachment: CapitalAssetPolicyNov2018 (Review of Small and Attractive Assets policy) Attachment A 4 expectancy of more than one year. Small and attractive assets are those that may not be missed immediately if stolen, or may expose the City to liability if lost. Due to their sensitive nature, all guns that cost less than $5,000 are included in the definition of small and attractive assets, as well as all computer equipment that cost less than $5,000. Other assets are included in this definition only when their cost is greater than $1,000 but less than $5,000. Examples of these other assets include photographic equipment, tools, equipment, Unmanned Aircraft Systems (drones), and small machinery. 5.0 CAPITAL ASSET POLICY: 5.1 Capital Assets – General capital assets are those assets not specifically related to activities reported in the proprietary funds. The capital assets purchased or constructed by a governmental fund are recorded as expenditures in the fund at the time the related purchases are made; however, the associated capital assets are reported in the governmental activities column of the government-wide statement of net assets while not reported in the fund balance sheets. 5.2 The City classifies assets with an estimated useful life in excess of one year as capital assets. Land and works of art are capitalized at cost with no minimum threshold. Buildings, improvements, intangible assets, and machinery and equipment are capitalized when their cost meets or exceeds $5,000. Infrastructure assets are capitalized when their cost meets or exceeds $50,000. Repairs or replacements to components of the Wastewater Treatment Plant are capitalized when their cost meets or exceeds $100,000. 5.3 Costs of normal maintenance and repair for assets are not capitalized. However, any improvement that increases an asset’s value, capacity or materially extends its life is added to that asset’s capitalized costs. 5.4 Equipment acquired through capital lease agreements and land purchased through conditional sales contracts are reported as general capital assets in the government- wide statement of net assets. In the governmental fund financial statements, lease and contract payments are reported as expenditures. 5.5 The City will complete an inventory of all capital assets no later than February 15th for the previous calendar year. Any adjustments to the Capital Asset List (e.g. additions, transfers, or disposals) must be communicated to the Finance Director no later than February 15th. The Finance Director must be notified immediately if it is discovered that any asset has been stolen, has been taken out of service, or has become impaired. Each department will maintain their own inventory of small and attractive assets and perform these same procedures to their small and attractive asset inventory. 2.1.a Packet Pg. 6 Attachment: CapitalAssetPolicyNov2018 (Review of Small and Attractive Assets policy) Attachment A 5 5.6 In accordance with federal requirements, the City will specifically identify in its inventory any equipment or real property purchased with federal funds. The City will inventory all assets with a cost greater than $5,000 per unit purchased with federal funds at least once every two years, in accordance with 2 CFR 200.313. Upon completion of any Federal award, or when a capital asset is no longer needed and has been declared to be surplus, the appropriate federal agency will be contacted regarding the appropriate disposition of any assets that were purchased with federal funds. 5.7 All project costs related to the construction of any asset, including infrastructure, are included in construction in progress during the construction process and are capitalized upon completion of the project. These costs generally include amounts paid for work done by outside contractors, materials and supplies furnished by the City, labor of City employees, and project management costs. Some costs will be direct costs and readily assignable while some will be indirect costs, which should be allocated to benefited assets in a reasonable manner. Costs incurred during construction must be reported as Construction in Progress if construction has not been completed by year end. Once completed, the Construction in Progress asset is reclassified to the appropriate asset category, e.g. Buildings, Infrastructure, Sidewalks, or Machinery and Equipment. Long-range or advance planning costs and costs incurred to conduct feasibility studies or government compliance studies must be capitalized only when it can be shown that they provide benefits to existing or future capital assets. 5.8 The Construction in Progress schedule must be reviewed and reconciled no later than February 15th for the previous calendar year. The Finance Department will perform a secondary review of the reconciliation to ensure it is performed accurately and completely by reviewing documentation to confirm the date that assets were substantially complete. 5.9 Transfers of assets between departments or funds are allowed by mutual agreement of the departments. The department transferring the assets must notify the Finance Director of the transfer within thirty days of the transfer. 5.10 When a department decides to dispose of an asset in any manner, the department Director must notify the Finance Director and the City Council of their intent to dispose of the asset. In accordance with Edmonds City Code, any such sale or disposal must be approved by the City Council prior to disposal. 5.11 Capital assets acquired or constructed by the proprietary funds are capitalized in those funds at historical cost. Contributed assets are recorded at their estimated fair value as of the date acquired. The estimated value of donated assets is recorded as contributed capital by the fund which receives them. 5.12 Land and construction in progress are not depreciated. Buildings, equipment, non- building improvements and intangible assets are depreciated using the straight line method, using varying estimated service lives for individual assets and asset 2.1.a Packet Pg. 7 Attachment: CapitalAssetPolicyNov2018 (Review of Small and Attractive Assets policy) Attachment A 6 classifications depending on particular characteristics of an asset and factors surrounding its anticipated use. Depreciation is reported as part of the related program expense column on the government-wide statement of activities and as a fund expense in the proprietary funds, while not reported in the fund statements of governmental funds. Capital assets are reported net of accumulated depreciation on the government-wide statement of net assets and in the proprietary fund statement of net assets, while not reported in the governmental fund balance sheets. 5.13 Small and attractive assets should be identified and tracked by each Department Director in accordance with the Small and Attractive Assets Policy. or their designee using cost/benefit principles. The cost/benefit analysis should consider the cost of the item, its apparent susceptibility to loss or theft, and the likelihood of theft. Based on this analysis, the Director or designee shall prepare a list that is updated at least annually of the Department’s small and attractive items, the asset’s cost, its custodian, and its location. The Department shall conduct an inventory at least annually, no later than January 31st, of the assets on the list. The list shall be retained by the Department according to State records retention requirements or completion of the relevant State audit, whichever is longer. Lost or missing assets must be immediately reported to the Finance Director. Finance Department staff may periodically audit these records at the discretion of the Finance Director. 5.14 The average service lives used to calculate depreciation for specific types of assets are summarized below: Asset Type Est. Service Life (Yrs) Buildings 30-50 Improvements other than Buildings 20-40 Furniture and Fixtures 5-10 Cars 5-10 Vans, Trucks, Trailers 5-20 Data Processing Equipment 3-10 Infrastructure 20-100 Sidewalks 30 Machinery and Equipment 5-20 Intangible Assets 20-30 2.1.a Packet Pg. 8 Attachment: CapitalAssetPolicyNov2018 (Review of Small and Attractive Assets policy) 1 RESOLUTION NO. XXXX A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, ADOPTING THE SMALL AND ATTRACTIVE ASSET POLICY AS ATTACHED HERTO. WHEREAS, the City of Edmonds is committed to the highest standards of responsible financial management; and WHEREAS, the City Council Finance Committee reviewed the Small and Attractive Asset Policy at the November 13, 2018 Finance Committee meeting; and WHEREAS, best practice shows that finance related policies should be formally adopted by Resolution; now therefore, THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, HEREBY RESOLVES AS FOLLOWS: Section 1. ADOPT THE CITY OF EDMONDS SMALL AND ATTRACTICE ASSET POLICY. The city council hereby adopts the following attached document: City of Edmonds Small and Attractive Asset Policy to read as set forth in Attachment A hereto, which is attached hereto and incorporated herein by this reference as if set forth in full. 1. RESOLVED this 20TH day of November 2018. CITY OF EDMONDS _______________________ MAYOR, DAVE EARLING ATTEST: CITY CLERK, SCOTT PASSEY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: RESOLUTION NO. XXXX 2.1.b Packet Pg. 9 Attachment: Small and Attractive Asset Policy November 2018 (Review of Small and Attractive Assets policy) Attachment A 2 City of Edmonds Small and Attractive Asset Policy November 20, 2018 Resolution # XXXX 2.1.b Packet Pg. 10 Attachment: Small and Attractive Asset Policy November 2018 (Review of Small and Attractive Assets policy) Attachment A 3 1.0 PURPOSE: To establish a Policy providing stewardship over the City’s capital assets, as well as the capitalization and depreciation or amortization of capital purchases over time, as appropriate. 2.0 FUNDS AFFECTED: All City funds. 3.0 REFERENCES: RCW 43.09.200 Budgetary, Accounting, and Reporting System (BARS) Manual, Part 3, Chapter 3, Capital Assets Budgetary, Accounting, and Reporting System (BARS) Manual, Part Three, Chapter 7, Capital Assets and Internal Service Funds Edmonds City Code, Chapter 3 4.0 DEFINITIONS: 4.1 "Assets" – All land, buildings, improvements, infrastructure, permanent works of art and historic collections, and equipment purchased, donated, constructed, or acquired by the City. 4.2 "Capital Assets" – Land and improvements to land, including right of ways and easements; permanent artwork and historic collections of any value; improvements and infrastructure; buildings, their furnishings, fixtures, and furniture; equipment, machinery, vehicles, and tools; intangible assets such as water rights, and computer software; with a value of $5,000 or more for non-infrastructure, or $50,000 or more per item for infrastructure, or $75,000 or more for repairs or replacements to components of the Wastewater Treatment Plant, and having a useful life exceeding one year from the date of acquisition. 4.3 "Control" – Being in charge of, and having the authority to manage the asset. Having custodial responsibility of the asset includes but is not limited to the caring, keeping, safeguarding and protecting the asset. 4.4 "Small and Attractive Assets" – Assets that are particularly at risk or vulnerable to loss and cost less than the capitalization threshold of $5,000 and have a life expectancy of more than one year. Small and attractive assets are those that may not be missed immediately if stolen, or may expose the City to liability if lost. Due to their sensitive nature, all guns that cost less than $5,000 are included in the definition of small and attractive assets, as well as all computer equipment that cost less than $5,000. Other assets are included in this definition only when their cost is greater than $1,000 but less than $5,000. Examples of these other assets include 2.1.b Packet Pg. 11 Attachment: Small and Attractive Asset Policy November 2018 (Review of Small and Attractive Assets policy) Attachment A 4 photographic equipment, tools, equipment, Unmanned Aircraft Systems (drones), and small machinery. 5.0 SMALL AND ATTRACTIVE ASSET POLICY: 5.1 It is the policy of the City to maintain accountability over all tangible items that may be susceptible to loss without being noticed. All Departments shall maintain records to be verified by a physical inventory at least once per year and provide this inventory list to the Finance Director for monitoring year to year changes. 5.2 Small and attractive items are assets that are easily moveable, desirable items with a cost between $1,000 and $5,000, and have an expected useful life of more than one year. These are items that are either easy to conceal or are portable, and are not likely to be missed immediately if stolen. Each Department Director or their designee will prepare and update at least annually their inventory of small and attractive assets, including the asset’s purchase price, its custodian, and its location. This list will also contain, when possible, the asset’s serial number, model number, or some other identifying information. This inventory list will be provided to the Finance Director no later than January 31 of each year for monitoring. If an asset has been removed from the inventory list, the reason for and means of disposal must be noted. Whenever possible, all small and attractive assets should be tagged in such a way that they can be clearly identified that they are property of the City of Edmonds. 5.3 Small and attractive assets are not to include more permanent fixtures or equipment such as desks, tables, and shelving, or items that are acquired for the purpose of accomplishing tasks that are small or of minimal monetary value, like minor equipment, shovels, wrenches, hand tools, and the like. The small and attractive inventory list should not include items that are consumed or used up, such as asphalt, bottled water, or copy paper. They also do not include items that are used as an accessory for a larger capital asset such as light bars for police vehicles, cages, sirens, or other capital equipment. Small and attractive assets are often things like cameras and video/photographic equipment, laptops, tablets, and notebook computers, and shop equipment like welders, portable drill presses or compressors, as long as their original cost is greater than $1,000 and less than $5,000. At their discretion, the Department Director may include assets that cost less than $1,000, if they desire. An inventory listing of desktop computers, laptops, and telephone equipment shall be maintained by the Information Technology department. 5.4 When it has been determined that a small and attractive asset is missing, the controlling department’s Director shall notify the Finance Director, who will file a police report and a report for insurance purposes when necessary. In addition, the Finance Director shall notify the State Auditor’s Office any time an asset is determined to be missing. 2.1.b Packet Pg. 12 Attachment: Small and Attractive Asset Policy November 2018 (Review of Small and Attractive Assets policy) Attachment A 5 5.5 All departments will complete an inventory of all small and attractive assets no later than January 31st for the previous calendar year. Any adjustments to the Inventory List (e.g. additions, transfers, or disposals) must be communicated to the Finance Director no later than February 15th. Separation of duties procedures shall be followed in maintaining the inventory lists. For example, the person conducting the annual inventory should not be the same person who is responsible for maintaining the asset schedule, and the person responsible for maintaining the asset schedule should not be the same person who orders and receives new assets. 5.6 Transfers of any assets, including small and attractive assets, between departments or funds are allowed by mutual agreement of the departments. The department transferring the assets must notify the Finance Director of the transfer within thirty days of the transfer. 5.7 When a department decides to dispose of an asset in any manner, the department Director must notify the Finance Director and the City Council of their intent to dispose of the asset. In accordance with Edmonds City Code, any such sale or disposal must be approved by the City Council prior to disposal. 5.8 Each department shall conduct an inventory at least annually, no later than January 31st, of the assets on the list. The list shall be retained by the department according to State records retention requirements or completion of the relevant State audit, whichever is longer. Lost or missing assets must be immediately reported to the Finance Director. Finance Department staff may periodically audit these records at the discretion of the Finance Director. 2.1.b Packet Pg. 13 Attachment: Small and Attractive Asset Policy November 2018 (Review of Small and Attractive Assets policy) City Council Agenda Item Meeting Date: 12/11/2018 Review of October Financial Report Staff Lead: Dave Turley Department: Administrative Services Preparer: Dave Turley Background/History Review of the October 2018 monthly financial report. Staff Recommendation Approve and move to Consent Agenda at next meeting. Narrative Attachments: October 2018 Monthly Financial Report 2.2 Packet Pg. 14 CITY OF EDMONDS MONTHLY BUDGETARY FINANCIAL REPORT OCTOBER 2018 2.2.a Packet Pg. 15 Attachment: October 2018 Monthly Financial Report (October Financial Report) 1 Page 1 of 1 Fund No.Title 2018 Amended Budget 10/31/2017 Revenues 10/31/2018 Revenues Amount Remaining % Received 001 GENERAL FUND 39,501,682$ 29,893,590$ 30,903,967$ 8,597,715$ 78% 009 LEOFF-MEDICAL INS. RESERVE 285,650 145,705 144,747 140,903 51% 011 RISK MANAGEMENT FUND 19,180 16,152 20,260 (1,080) 106% 012 CONTINGENCY RESERVE FUND 64,750 73,162 119,588 (54,838) 185% 014 HISTORIC PRESERVATION GIFT FUND 5,170 137 2,693 2,477 52% 016 BUILDING MAINTENANCE - 337,246 - - 0% 017 MARSH RESTORATION & PRESERVATION FUND 300,000 - 306,865 (6,865) 102% 018 EDMONDS HOMELESSNESS RESPONSE FUND 250,000 - 250,000 - 100% 019 EDMONDS OPIOID RESPONSE FUND 250,000 - 250,000 - 100% 104 DRUG ENFORCEMENT FUND 130,560 45,200 78,481 52,079 60% 111 STREET FUND 1,784,270 1,600,631 1,301,203 483,067 73% 112 COMBINED STREET CONST/IMPROVE 3,731,003 3,319,712 3,480,165 250,838 93% 117 MUNICIPAL ARTS ACQUIS. FUND 149,385 86,316 90,993 58,392 61% 118 MEMORIAL STREET TREE 400 323 408 (8) 102% 120 HOTEL/MOTEL TAX REVENUE FUND 87,960 74,785 76,419 11,541 87% 121 EMPLOYEE PARKING PERMIT FUND 25,640 14,107 14,503 11,137 57% 122 YOUTH SCHOLARSHIP FUND 850 752 633 217 74% 123 TOURISM PROMOTIONAL FUND/ARTS 30,520 25,861 31,724 (1,204) 104% 125 REAL ESTATE EXCISE TAX 2 1 1,446,880 1,323,902 1,603,748 (156,868) 111% 126 REAL ESTATE EXCISE TAX 1, PARKS ACQ FUND 1 1,448,300 1,327,171 1,613,473 (165,173) 111% 127 GIFTS CATALOG FUND 53,810 30,139 68,748 (14,938) 128% 129 SPECIAL PROJECTS FUND - 693 - - 0% 130 CEMETERY MAINTENANCE/IMPROVEMT 180,170 160,140 187,207 (7,037) 104% 136 PARKS TRUST FUND 3,150 2,748 3,499 (349) 111% 137 CEMETERY MAINTENANCE TRUST FD 33,360 31,705 39,143 (5,783) 117% 138 SISTER CITY COMMISSION 10,170 7,233 10,482 (312) 103% 140 BUSINESS IMPROVEMENT DISTRICT - 80,282 79,872 (79,872) 0% 211 L.I.D. FUND CONTROL 14,400 - - 14,400 0% 231 2012 LT GO DEBT SERVICE FUND 708,700 64,938 59,284 649,416 8% 332 PARKS CAPITAL CONSTRUCTION FUND 2 1,621,977 408,010 876,662 745,315 54% 411 COMBINED UTILITY OPERATION - 134,998 124,628 (124,628) 0% 421 WATER UTILITY FUND 3 9,660,690 7,364,976 7,994,620 1,666,070 83% 422 STORM UTILITY FUND 3 5,317,996 3,562,897 3,996,980 1,321,016 75% 423 SEWER/WWTP UTILITY FUND 4 11,917,843 11,054,752 9,406,059 2,511,784 79% 424 BOND RESERVE FUND 1,991,530 654,347 640,748 1,350,782 32% 511 EQUIPMENT RENTAL FUND 1,624,640 1,568,228 1,415,858 208,782 87% 512 TECHNOLOGY RENTAL FUND 1,268,390 799,823 1,062,294 206,096 84% 617 FIREMEN'S PENSION FUND 69,690 61,575 50,618 19,072 73% 83,988,716$ 64,272,236$ 66,306,572$ 17,682,144$ 79% 4 Differences primarily due to differences in contributed capital billings to WWTP partners in 2018. CITY OF EDMONDS REVENUES BY FUND - SUMMARY 3 Differences primarily due to a 9% increase in water, and 10% increase in storm base rates in 2018. 1 Differences primarily due to a $418,216 deposit in total for Real Estate Excise Tax in March 2018 from the State. 2 Differences primarily due to $500,175 in Parks Donations, and $166,664 from a Edmonds Waterfront Development Grant in 2018. 2.2.a Packet Pg. 16 Attachment: October 2018 Monthly Financial Report (October Financial Report) 2 Page 1 of 1 Fund No.Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent 001 GENERAL FUND 44,602,053$ 32,226,465$ 33,456,258$ 11,145,795$ 75% 009 LEOFF-MEDICAL INS. RESERVE 363,438 353,475 316,928 46,510 87% 011 RISK MANAGEMENT FUND - 81,277 - - 0% 012 CONTINGENCY RESERVE FUND 5 49,584 - 528,943 (479,359) 1067% 014 HISTORIC PRESERVATION GIFT FUND 5,400 - - 5,400 0% 016 BUILDING MAINTENANCE - 264,868 - - 0% 018 EDMONDS HOMELESSNESS RESPONSE FUND - - 24,557 (24,557) 0% 104 DRUG ENFORCEMENT FUND 103,252 49,085 72,276 30,976 70% 111 STREET FUND 1,856,507 1,408,314 1,388,889 467,618 75% 112 COMBINED STREET CONST/IMPROVE 3,844,638 4,659,349 3,008,293 836,345 78% 117 MUNICIPAL ARTS ACQUIS. FUND 183,892 54,850 61,737 122,155 34% 120 HOTEL/MOTEL TAX REVENUE FUND 90,550 54,000 33,998 56,552 38% 121 EMPLOYEE PARKING PERMIT FUND 26,880 1,638 573 26,307 2% 122 YOUTH SCHOLARSHIP FUND 1,000 1,085 1,905 (905) 191% 123 TOURISM PROMOTIONAL FUND/ARTS 29,700 21,031 12,259 17,441 41% 125 REAL ESTATE EXCISE TAX 2 2,733,000 771,167 1,122,283 1,610,717 41% 126 REAL ESTATE EXCISE TAX 1, PARKS ACQ FUND 2,651,867 182,389 1,058,040 1,593,827 40% 127 GIFTS CATALOG FUND 70,900 27,309 27,913 42,987 39% 130 CEMETERY MAINTENANCE/IMPROVEMT 213,509 133,105 167,259 46,250 78% 138 SISTER CITY COMMISSION 10,500 6,023 807 9,693 8% 140 BUSINESS IMPROVEMENT DISTRICT 6 - 60,166 79,010 (79,010) 0% 211 L.I.D. FUND CONTROL 16,450 16,450 - 16,450 0% 231 2012 LT GO DEBT SERVICE FUND 708,700 64,938 59,284 649,416 8% 332 PARKS CAPITAL CONSTRUCTION FUND 2,346,881 539,728 264,163 2,082,718 11% 421 WATER UTILITY FUND 13,465,028 7,063,917 8,632,802 4,832,226 64% 422 STORM UTILITY FUND 6,986,013 2,790,966 3,316,077 3,669,936 47% 423 SEWER/WWTP UTILITY FUND 14,654,540 11,619,393 8,777,152 5,877,388 60% 424 BOND RESERVE FUND 1,991,520 654,342 640,742 1,350,778 32% 511 EQUIPMENT RENTAL FUND 1,670,082 1,399,235 956,870 713,212 57% 512 TECHNOLOGY RENTAL FUND 1,335,413 590,947 888,190 447,223 67% 617 FIREMEN'S PENSION FUND 75,218 56,452 63,241 11,977 84% 100,086,515$ 65,151,966$ 64,960,448$ 35,126,067$ 65% CITY OF EDMONDS EXPENDITURES BY FUND - SUMMARY 6 Business Improvement District is not included in the City Budget; activity is here for reporting purposes only. 5 2018 Expenditures includes interfund loans to 104 for $16,680 and to 112 for $442,866. 2.2.a Packet Pg. 17 Attachment: October 2018 Monthly Financial Report (October Financial Report) 3 Page 1 of 3 Title 2018 Amended Budget 10/31/2017 Revenues 10/31/2018 Revenues Amount Remaining % Received TAXES: REAL PERSONAL / PROPERTY TAX 7 10,367,860$ 6,405,063$ 5,863,462$ 4,504,398$ 57% EMS PROPERTY TAX 4,027,540 2,477,753 2,247,328 1,780,212 56% VOTED PROPERTY TAX 2,500 14,116 3,094 (594) 124% LOCAL RETAIL SALES/USE TAX 8 7,275,000 6,091,098 6,882,682 392,318 95% NATURAL GAS USE TAX 7,140 8,269 4,159 2,981 58% 1/10 SALES TAX LOCAL CRIM JUST 730,000 584,339 630,562 99,438 86% ELECTRIC UTILITY TAX 1,611,600 1,432,952 1,432,027 179,573 89% GAS UTILITY TAX 620,200 574,774 512,053 108,147 83% SOLID WASTE UTILITY TAX 321,600 276,239 293,755 27,845 91% WATER UTILITY TAX 1,201,100 1,025,687 1,025,199 175,901 85% SEWER UTILITY TAX 769,800 578,092 642,327 127,473 83% STORMWATER UTILITY TAX 406,200 315,597 345,333 60,867 85% T.V. CABLE UTILITY TAX 867,200 728,330 676,771 190,429 78% TELEPHONE UTILITY TAX 1,093,200 907,617 824,223 268,977 75% PULLTABS TAX 56,600 53,103 52,939 3,661 94% AMUSEMENT GAMES 40 777 - 40 0% LEASEHOLD EXCISE TAX 263,600 162,391 204,824 58,776 78% 29,621,180 21,636,197 21,640,738 7,980,442 73% LICENSES AND PERMITS: FIRE PERMITS-SPECIAL USE 250 270 345 (95) 138% POLICE - FINGERPRINTING 300 645 770 (470) 257% PROF AND OCC LICENSE-TAXI 330 - - 330 0% AMUSEMENTS 6,330 6,325 5,950 380 94% VENDING MACHINE/CONCESSION 50,000 52,310 50,396 (396) 101% FRANCHISE AGREEMENT-COMCAST 721,000 730,530 681,819 39,181 95% FRANCHISE FEE-EDUCATION/GOVERNMENT 42,600 35,174 34,714 7,886 81% FRANCHISE AGREEMENT-VERIZON/FRONTIER 105,500 79,762 80,664 24,836 76% FRANCHISE AGREEMENT-BLACKROCK 18,600 13,904 7,220 11,380 39% OLYMPIC VIEW WATER DISTRICT FRANCHISE 263,800 215,607 244,463 19,337 93% GENERAL BUSINESS LICENSE 121,600 70,455 79,671 41,930 66% DEV SERV PERMIT SURCHARGE 64,940 62,842 64,925 15 100% NON-RESIDENT BUS LICENSE 69,000 52,550 48,600 20,400 70% RIGHT OF WAY FRANCHISE FEE 12,000 13,880 52,816 (40,816) 440%BUILDING STRUCTURE PERMITS 715,600 750,793 593,596 122,004 83% ANIMAL LICENSES 24,500 13,492 12,090 12,410 49% STREET AND CURB PERMIT 40,000 34,736 45,185 (5,185) 113% OTR NON-BUS LIC/PERMITS 14,500 15,961 19,273 (4,773) 133% 2,270,850 2,149,234 2,022,498 248,352 89% INTERGOVERNMENTAL: DOJ 15-0404-0-1-754 - BULLET PROOF VEST 7,930 5,949 4,535 3,395 57% TARGET ZERO TEAMS GRANT 4,000 1,030 2,937 1,063 73% HIGH VISIBILITY ENFORCEMENT 7,100 8,226 8,602 (1,502) 121% DOCKSIDE DRILLS GRANT REIMBURSE 1,455 3,092 1,455 0 100% DEPT OF NATURAL RESOURCES - - 17,347 (17,347) 0% WA STATE TRAFFIC COMM GRANT 3,623 - 3,623 (0) 100% STATE GRANTS - BUDGET ONLY 18,000 - - 18,000 0% WATERFRONT ANALYSIS GRANT - 10,000 - - 0% PUD PRIVILEDGE TAX 198,000 198,479 212,002 (14,002) 107% MVET/SPECIAL DISTRIBUTION 12,790 11,564 11,964 826 94% TRIAL COURT IMPROVEMENT 16,716 12,536 16,531 185 99% AOC PRO-TEM JUDGE REIMBURSEMENT - - 705 (705) 0% CRIMINAL JUSTICE-SPECIAL PROGRAMS 43,700 41,971 43,243 457 99% MARIJUANA EXCISE TAX DISTRIBUTION 23,700 5,574 59,452 (35,752) 251% DUI - CITIES 3,000 6,198 6,099 (3,099) 203% LIQUOR EXCISE TAX 203,000 197,143 183,698 19,302 90% LIQUOR BOARD PROFITS 350,600 259,062 256,420 94,180 73% MISCELLANEOUS INTERLOCAL REVENUE 2,500 - - 2,500 0% INTERLOCAL GRANTS - 35,000 25,000 (25,000) 0% VERDANT INTERLOCAL GRANTS 2,000 2,000 5,810 (3,810) 291% FIRST RESPONDERS FLEX FUND 7,114 - 1,991 5,123 28% POLICE TRAINING CLASSES - 300 - - 0% DISCOVERY PROGRAMS TECHNOLOGY ACQ.- - 2,190 (2,190) 0% 905,228 798,123 863,604 41,624 95% REVENUES - GENERAL FUNDCITY OF EDMONDS 8 2018 Local Retail Sales/Use Tax revenues are $791,584 higher than 2017 revenues. Please also see pages pages 18 & 19. 7 Decrease in 2018 is temporary due to change to once monthly property tax deposits. 2.2.a Packet Pg. 18 Attachment: October 2018 Monthly Financial Report (October Financial Report) 4 Page 2 of 3 Title 2018 Amended Budget 10/31/2017 Revenues 10/31/2018 Revenues Amount Remaining % Received CHARGES FOR GOODS AND SERVICES: RECORD/LEGAL INSTRUMENTS 2,500 3,392 4,787 (2,287) 191% ATM SURCHARGE FEES 400 537 598 (198) 149% CREDIT CARD FEES 10,000 8,772 10,689 (689) 107% COURT RECORD SERVICES - 579 82 (82) 0% D/M COURT REC SER 400 226 140 260 35% CIVIL FEE - APPEAL - 53 - - 0% WARRANT PREPARATION FEE - - 5,282 (5,282) 0% IT TIME PAY FEE - 152 1,045 (1,045) 0% MUNIC.-DIST. COURT CURR EXPEN 300 218 112 188 37% SALE MAPS & BOOKS 100 36 70 30 70% CLERKS TIME FOR SALE OF PARKING PERMITS 25,100 - - 25,100 0% BID SUPPLIES REIMBURSEMENT 600 - - 600 0% PHOTOCOPIES 1,000 740 1,223 (223) 122% POLICE DISCLOSURE REQUESTS 4,000 2,428 69 3,931 2% ENGINEERING FEES AND CHARGES 200,000 367,833 192,916 7,084 96% ELECTION CANDIDATE FILING FEES - - 1,486 (1,486) 0% SNO-ISLE 78,000 81,102 91,539 (13,539) 117% PASSPORTS AND NATURALIZATION FEES 23,000 19,375 18,665 4,335 81% POLICE SERVICES SPECIAL EVENTS 33,235 32,603 33,235 0 100% CAMPUS SAFETY-EDM. SCH. DIST.66,280 3,494 26,413 39,867 40% WOODWAY-LAW PROTECTION 60,000 60,856 41,488 18,512 69% MISCELLANEOUS POLICE SERVICES 1,500 - - 1,500 0% DUI EMERGENCY FIRE SERVICES 100 - - 100 0% FIRE PROTECTION & EMS FOR DUI - 77 - - 0% FIRE DISTRICT #1 STATION BILLINGS 50,000 52,894 53,380 (3,380) 107% LEGAL SERVICES - - 1,772 (1,772) 0% ADULT PROBATION SERVICE CHARGE 48,600 40,862 48,161 439 99% ELECTRIC MONITORING - - 100 (100) 0% BOOKING FEES 3,000 2,281 1,611 1,389 54% FIRE CONSTRUCTION INSPECTION FEES 15,560 18,099 13,510 2,050 87% EMERGENCY SERVICE FEES 4,500 3,276 3,660 840 81% EMS TRANSPORT USER FEE 826,000 613,433 838,399 (12,399) 102% FLEX FUEL PAYMENTS FROM STATIONS 2,500 2,273 2,450 51 98% ANIMAL CONTROL SHELTER 250 50 45 205 18% ZONING/SUBDIVISION FEE 80,250 101,183 112,841 (32,591) 141% PLAN CHECKING FEES 443,000 402,693 294,568 148,432 66% FIRE PLAN CHECK FEES 8,000 9,775 7,245 755 91% PLANNING 1% INSPECTION FEE 1,600 1,062 776 824 48% S.E.P.A. REVIEW 5,000 8,710 7,370 (2,370) 147% CRITICAL AREA STUDY 14,000 15,090 15,800 (1,800) 113% DV COORDINATOR SERVICES 11,460 9,549 10,636 824 93% GYM AND WEIGHTROOM FEES 12,000 11,069 10,805 1,195 90% LOCKER FEES - 30 - - 0% PROGRAM FEES 910,100 716,237 741,295 168,805 81% TAXABLE RECREATION ACTIVITIES 1,300 1,281 707 593 54% WINTER MARKET REGISTRATION FEES 6,000 3,300 4,390 1,610 73% BIRD FEST REGISTRATION FEES 1,250 1,030 845 405 68% INTERFUND REIMBURSEMENT-CONTRACT SVCS 2,043,950 1,846,523 2,203,797 (159,847) 108% 4,994,835 4,443,174 4,804,000 190,835 96% CITY OF EDMONDS REVENUES - GENERAL FUND 2.2.a Packet Pg. 19 Attachment: October 2018 Monthly Financial Report (October Financial Report) 5 Page 3 of 3 Title 2018 Amended Budget 10/31/2017 Revenues 10/31/2018 Revenues Amount Remaining % Received FINES AND PENALTIES: PROOF OF VEHICLE INS PENALTY 5,000 4,231 5,472 (472) 109% TRAFFIC INFRACTION PENALTIES 215,000 184,136 233,378 (18,378) 109% NC TRAFFIC INFRACTION 34,000 29,084 25,291 8,709 74% CRT COST FEE CODE LEG ASSESSMENT (LGA)20,700 18,986 27,102 (6,402) 131% NON-TRAFFIC INFRACTION PENALTIES 400 600 4,000 (3,600) 1000% OTHER INFRACTIONS '04 3,400 2,407 897 2,503 26% PARKING INFRACTION PENALTIES 48,000 49,580 139,581 (91,581) 291% PARK/INDDISZONE 2,600 1,839 1,429 1,171 55% DWI PENALTIES 6,000 7,741 6,088 (88) 101% DUI - DP ACCT 2,000 1,522 671 1,329 34% CRIM CNV FEE DUI 200 143 134 66 67% DUI - DP FEE - 56 1,834 (1,834) 0% OTHER CRIMINAL TRAF MISDEM PEN 135 218 96 39 71% CRIMINAL TRAFFIC MISDEMEANOR 8/03 36,000 29,025 27,155 8,845 75% CRIMINAL CONVICTION FEE CT 2,600 2,094 3,096 (496) 119% CRIM CONV FEE CT 1,600 1,355 828 772 52% OTHER NON-TRAF MISDEMEANOR PEN 100 32 38 62 38% OTHER NON TRAFFIC MISD. 8/03 9,300 7,545 11,399 (2,099) 123% COURT DV PENALTY ASSESSMENT 600 435 560 40 93% CRIMINAL CONVICTION FEE CN 1,100 1,086 1,274 (174) 116% CRIM CONV FEE CN 500 377 413 87 83% CRIMINAL COSTS-RECOUPMENTS - 7,246 - - 0% PUBLIC DEFENSE RECOUPMENT 18,500 14,230 15,823 2,677 86% BANK CHARGE FOR CONV. DEFENDANT 6,000 7,386 10,577 (4,577) 176% COURT COST RECOUPMENT 5,000 - 4,833 167 97% COURT INTERPRETER COSTS - 246 - - 0% BUS. LICENSE PERMIT PENALTY 11,000 9,530 11,410 (410) 104% MISC FINES AND PENALTIES 2,000 1,740 1,725 275 86%431,735 382,868 535,104 (103,369) 124% MISCELLANEOUS: INVESTMENT INTEREST 156,840 110,972 140,419 16,421 90% INTEREST ON COUNTY TAXES 7,130 7,815 14,333 (7,203) 201% INTEREST - COURT COLLECTIONS 6,500 5,191 7,361 (861) 113% LOAN INTEREST - - 1,282 (1,282) 0% PARKING 15,600 13,992 4,062 11,538 26% SPACE/FACILITIES RENTALS 147,000 122,573 134,710 12,290 92% BRACKET ROOM RENTAL 5,000 4,560 1,940 3,060 39% LEASES LONG-TERM 185,000 152,279 160,209 24,791 87% OTHER RENTS & USE CHARGES 2,400 1,800 - 2,400 0% DONATION/CONTRIBUTION 1,200 155 1,348 (148) 112% PARKS DONATIONS 4,350 3,650 3,380 970 78% BIRD FEST CONTRIBUTIONS 1,500 2,044 1,776 (276) 118% FIRST RESPONDERS - PRIVATE SOURCE - - 28,000 (28,000) 0% VOLUNTEER PICNIC CONTRIBUTIONS 1,000 - - 1,000 0% POLICE CONTRIBUTIONS FROM PRIV SOURCES 1,000 2,290 - 1,000 0% SALE OF JUNK/SALVAGE 300 4,945 408 (108) 136% SALES OF UNCLAIM PROPERTY 3,000 1,950 2,516 484 84% CONFISCATED AND FORFEITED PROPERTY 2,000 - - 2,000 0% OTHER JUDGEMENT/SETTLEMENT 2,000 7 - 2,000 0% POLICE JUDGMENTS/RESTITUTION 200 91 90 110 45% CASHIER'S OVERAGES/SHORTAGES - 273 (87) 87 0% OTHER MISC REVENUES 9 652,000 8,897 445,070 206,930 68% SMALL OVERPAYMENT 30 37 79 (49) 264% NSF FEES - PARKS & REC 120 - - 120 0% NSF FEES - MUNICIPAL COURT 300 341 321 (21) 107% NSF FEES - POLICE - 60 30 (30) 0% NSF FEES - DEVEL SERV DEPT - - 30 (30) 0% US BANK REBATE 7,500 6,629 7,168 332 96% 1,201,970 450,552 954,446 247,524 79% TRANSFERS-IN: SALE OF FIXED ASSETS - - 5,273 (5,273) 0% INSURANCE RECOVERIES - 7,143 15,570 (15,570) 0% INTERFUND TRANSFER FROM FUND 012 49,584 - 49,584 - 100% TRANSFER FROM FUND 127 26,300 26,300 13,150 13,150 50%75,884 33,443 83,577 (7,693) 110% TOTAL GENERAL FUND REVENUE 39,501,682$ 29,893,590$ 30,903,967$ 8,597,715$ 78% CITY OF EDMONDS 9 $650,000 of this represents a short-term loan to the ECA for a roof/equipment project. REVENUES - GENERAL FUND 2.2.a Packet Pg. 20 Attachment: October 2018 Monthly Financial Report (October Financial Report) 6 Page 1 of 6 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent GENERAL FUND EXPENDITURES (001) SALARIES AND WAGES 15,519,046$ 11,857,427$ 12,207,194$ 3,311,852$ 79% OVERTIME 507,613 423,212 563,567 (55,954) 111% HOLIDAY BUY BACK 243,389 4,413 7,135 236,254 3% BENEFITS 6,173,460 4,647,495 4,774,237 1,399,223 77% UNIFORMS 88,785 61,043 67,314 21,471 76% SUPPLIES 378,580 274,222 311,190 67,390 82% SMALL EQUIPMENT 56,160 45,142 82,188 (26,028) 146% PROFESSIONAL SERVICES 3,999,065 2,173,572 2,365,485 1,633,580 59% COMMUNICATIONS 166,585 116,654 114,618 51,967 69% TRAVEL 55,330 40,471 44,862 10,468 81% EXCISE TAXES 6,500 4,399 5,170 1,330 80% RENTAL/LEASE 1,988,447 1,409,591 1,644,071 344,376 83% INSURANCE 624,530 616,495 437,253 187,277 70% UTILITIES 457,800 421,004 438,196 19,604 96% REPAIRS & MAINTENANCE 726,713 208,390 247,542 479,171 34% MISCELLANEOUS 517,497 251,539 289,721 227,776 56% INTERGOVERNMENTAL SERVICES 9,901,462 9,028,919 8,539,180 1,362,282 86% INTERGOVERNMENTAL PAYMENTS 10 695,000 - 441,873 253,127 64% INTERFUND SUBSIDIES 1,863,370 537,130 779,625 1,083,745 42% LAND 200,000 - 4,884 195,116 2% BUILDINGS 83,000 - - 83,000 0% MACHINERY/EQUIPMENT 151,721 91,135 80,159 71,562 53% GENERAL OBLIGATION BOND PRINCIPAL 176,340 - - 176,340 0% OTHER INTEREST & DEBT SERVICE COSTS 500 222 218 282 44% INTEREST ON LONG-TERM EXTERNAL DEBT 21,160 13,990 10,576 10,584 50% 44,602,053$ 32,226,465$ 33,456,258$ 11,145,795$ 75% LEOFF-MEDICAL INS. RESERVE (009) BENEFITS 184,000$ 136,178$ 133,441$ 50,559$ 73% PENSION AND DISABILITY PAYMENTS 172,158 215,097 180,126 (7,968) 105% PROFESSIONAL SERVICES 7,000 1,800 2,962 4,038 42% MISCELLANEOUS 280 400 400 (120) 143%363,438$ 353,475$ 316,928$ 46,510$ 87% RISK MANAGEMENT RESERVE FUND (011) MISCELLANEOUS -$ 81,277$ -$ -$ 0%-$ 81,277$ -$ -$ 0% CONTINGENCY RESERVE FUND (012) INTERFUND SUBSIDIES 49,584$ -$ 49,584$ -$ 100% INTERFUND LOAN 11 - - 479,359 (479,359) 0% 49,584$ -$ 528,943$ (479,359)$ 1067% HISTORIC PRESERVATION GIFT FUND (014) SUPPLIES 100$ -$ -$ 100$ 0% PROFESSIONAL SERVICES 200 - - 200 0% MISCELLANEOUS 5,100 - - 5,100 0%5,400$ -$ -$ 5,400$ 0% BUILDING MAINTENANCE SUBFUND (016) SUPPLIES -$ 5,670$ -$ -$ 0 PROFESSIONAL SERVICES - 48,350 - - 0% REPAIR & MAINTENANCE - 84,409 - - 0% CONSTRUCTION PROJECTS 126,440 - - 0% -$ 264,868$ -$ -$ 0% EDMONDS HOMELESSNESS RESPONSE FUND (018 PROFESSIONAL SERVICES -$ -$ 24,557$ (24,557)$ 0% -$ -$ 24,557$ (24,557)$ 0% DRUG ENFORCEMENT FUND (104) FUEL CONSUMED 3,000$ 1,628$ -$ 3,000$ 0% SMALL EQUIPMENT 5,000 - - 5,000 0% COMMUNICATIONS 2,230 815 - 2,230 0% REPAIR/MAINT 800 - - 800 0% MISCELLANEOUS 20,000 5,000 - 20,000 0% INTERGOVERNMENTAL SERVICES 72,222 41,642 72,276 (54) 100%103,252$ 49,085$ 72,276$ 30,976$ 70% EXPENDITURES BY FUND - DETAIL CITY OF EDMONDS 10 $650,000 of this represents a short-term loan to the ECA for a roof/equipment project. 11 2018 Expenditures includes interfund loans to 104 for $16,680 and to 112 for $442,866. 2.2.a Packet Pg. 21 Attachment: October 2018 Monthly Financial Report (October Financial Report) 7 Page 2 of 6 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent STREET FUND (111) SALARIES AND WAGES 551,495$ 434,905$ 420,780$ 130,715$ 76% OVERTIME 24,400 24,215 20,249 4,151 83% BENEFITS 286,892 225,421 216,017 70,875 75% UNIFORMS 6,000 3,711 3,136 2,864 52% SUPPLIES 310,000 205,178 167,991 142,009 54% SMALL EQUIPMENT 20,000 8,892 396 19,604 2% PROFESSIONAL SERVICES 16,050 11,641 11,723 4,327 73% COMMUNICATIONS 4,500 6,089 5,613 (1,113) 125% TRAVEL 1,000 - - 1,000 0% RENTAL/LEASE 187,150 151,434 157,160 29,990 84% INSURANCE 113,230 110,508 156,645 (43,415) 138% UTILITIES 273,170 203,893 211,719 61,451 78% REPAIRS & MAINTENANCE 45,000 14,154 15,092 29,908 34% MISCELLANEOUS 8,000 2,595 1,139 6,861 14% INTERGOVERNMENTAL SERVICES 5,000 5,324 906 4,094 18% GENERAL OBLIGATION BOND PRINCIPAL 3,970 - - 3,970 0% INTEREST 650 354 322 328 50% 1,856,507$ 1,408,314$ 1,388,889$ 467,618$ 75% COMBINED STREET CONST/IMPROVE (112) SALARIES AND WAGES -$ 15,383$ 18,138$ (18,138)$ 0% OVERTIME - 672 - - 0% BENEFITS - 6,409 11,626 (11,626) 0% SMALL EQUIPMENT - 2,056 - - 0% PROFESSIONAL SERVICES 365,918 890,592 316,698 49,220 87% REPAIRS & MAINTENANCE 300,000 588,684 178,659 121,341 60% INTERFUND SUBSIDIES 102,910 40,711 40,515 62,395 39% LAND 25,000 - 10,500 14,500 42% MACHINERY/EQUIPMENT - 8,166 - - 0% CONSTRUCTION PROJECTS 2,975,900 3,031,440 2,357,281 618,619 79% INTERGOVERNMENTAL LOANS 72,220 72,201 72,201 19 100% INTEREST 2,690 3,035 2,674 16 99% 3,844,638$ 4,659,349$ 3,008,293$ 836,345$ 78% MUNICIPAL ARTS ACQUIS. FUND (117) SUPPLIES 4,900$ 1,896$ 2,005$ 2,895$ 41% SMALL EQUIPMENT 1,700 902 128 1,572 8% PROFESSIONAL SERVICES 168,312 48,442 55,049 113,263 33% TRAVEL 80 35 9 71 11% RENTAL/LEASE 2,000 - - 2,000 0% REPAIRS & MAINTENANCE 300 - - 300 0% MISCELLANEOUS 6,600 3,575 4,546 2,054 69% 183,892$ 54,850$ 61,737$ 122,155$ 34% HOTEL/MOTEL TAX REVENUE FUND (120) PROFESSIONAL SERVICES 86,300$ 51,800$ 31,998$ 54,302$ 37% MISCELLANEOUS 250 200 - 250 0% INTERFUND SUBSIDIES 4,000 2,000 2,000 2,000 50% 90,550$ 54,000$ 33,998$ 56,552$ 38% EMPLOYEE PARKING PERMIT FUND (121) SUPPLIES 1,790$ 1,638$ 573$ 1,217$ 32% PROFESSIONAL SERVICES 25,090 - - 25,090 0% 26,880$ 1,638$ 573$ 26,307$ 2% YOUTH SCHOLARSHIP FUND (122) MISCELLANEOUS 1,000$ 1,085$ 1,905$ (905)$ 191% 1,000$ 1,085$ 1,905$ (905)$ 191% TOURISM PROMOTIONAL FUND/ARTS (123) PROFESSIONAL SERVICES 28,200$ 18,431$ 10,795$ 17,405$ 38% MISCELLANEOUS 1,500 2,600 1,464 36 98% 29,700$ 21,031$ 12,259$ 17,441$ 41% REAL ESTATE EXCISE TAX 2 (125) SUPPLIES 21,000$ 44,301$ 22,515$ (1,515)$ 107% PROFESSIONAL SERVICES 65,040 295,592 85,269 (20,229) 131% UTILITIES - 1,649 - - 0% REPAIRS & MAINTENANCE 600,000 - 350,122 249,878 58% BUILDINGS 150,000 - - 150,000 0% CONSTRUCTION PROJECTS 1,896,960 429,625 664,378 1,232,582 35% 2,733,000$ 771,167$ 1,122,283$ 1,610,717$ 41% CITY OF EDMONDS EXPENDITURES BY FUND - DETAIL 2.2.a Packet Pg. 22 Attachment: October 2018 Monthly Financial Report (October Financial Report) 8 Page 3 of 6 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent REAL ESTATE EXCISE TAX 1, PARKS ACQ (126) PROFESSIONAL SERVICES 160,555$ 14,527$ 128,391$ 32,164$ 80% REPAIRS & MAINTENANCE 1,031,762 - 651,657 380,105 63% INTERFUND SUBSIDIES 135,130 16,163 15,063 120,068 11% LAND - 43,201 - - 0% MISCELLANEOUS 216,720 - 216,720 - 100% CONSTRUCTION PROJECTS 1,080,850 106,364 44,259 1,036,591 4% GENERAL OBLIGATION BONDS 23,100 - - 23,100 0% INTEREST 3,750 2,062 1,873 1,877 50% OTHER INTEREST & DEBT SERVICE COSTS - 72 77 (77) 0% 2,651,867$ 182,389$ 1,058,040$ 1,593,827$ 40% GIFTS CATALOG FUND (127) SUPPLIES 37,500$ 1,009$ 14,608$ 22,892$ 39% PROFESSIONAL SERVICES 6,500 - - 6,500 0% MISCELLANEOUS 600 - 154 446 26% INTERFUND SUBSIDIES 26,300 26,300 13,150 13,150 50% 70,900$ 27,309$ 27,913$ 42,987$ 39% CEMETERY MAINTENANCE/IMPROVEMENT (130) SALARIES AND WAGES 91,711$ 62,117$ 71,851$ 19,860$ 78% OVERTIME 3,500 3,096 2,639 861 75% BENEFITS 38,253 29,276 32,598 5,655 85% UNIFORMS 1,000 - 675 325 67% SUPPLIES 22,995 4,512 17,480 5,515 76% SUPPLIES PURCHASED FOR INVENTORY/RESALE 20,000 8,803 21,333 (1,333) 107% PROFESSIONAL SERVICES 4,200 5,639 1,582 2,618 38% COMMUNICATIONS 1,410 1,139 1,431 (21) 101% TRAVEL 500 - - 500 0% RENTAL/LEASE 11,640 8,992 9,700 1,940 83% UTILITIES 3,800 4,180 4,368 (568) 115% REPAIRS & MAINTENANCE 500 - - 500 0% MISCELLANEOUS 14,000 5,350 3,602 10,398 26% 213,509$ 133,105$ 167,259$ 46,250$ 78% SISTER CITY COMMISSION (138) SUPPLIES 1,500$ 390$ 170$ 1,330$ 11% TRAVEL 4,500 2,839 - 4,500 0% MISCELLANEOUS 4,500 2,794 637 3,863 14% 10,500$ 6,023$ 807$ 9,693$ 8% BUSINESS IMPROVEMENT DISTRICT FUND (140) SUPPLIES -$ 842$ 6,892$ (6,892)$ 0% PROFESSIONAL SERVICES - 57,357 67,117 (67,117) 0% MISCELLANEOUS - 1,967 5,001 (5,001) 0% -$ 60,166$ 79,010$ (79,010)$ 0% LID FUND CONTROL (211) INTERFUND SUBSIDIES 16,450$ 16,450$ -$ 16,450$ 0% 16,450$ 16,450$ -$ 16,450$ 0% 2012 LTGO DEBT SERVIC FUND (231) GENERAL OBLIGATION BOND 589,630$ -$ -$ 589,630$ 0% INTEREST 118,580 64,938 59,284 59,296 50% OTHER INTEREST & DEBT SERVICE COSTS 490 - - 490 0% 708,700$ 64,938$ 59,284$ 649,416$ 8% PARKS CONSTRUCTION FUND (332) PROFESSIONAL SERVICES 7,160$ 87,857$ 9,048$ (1,888)$ 126% INTERFUND SUBSIDIES 200,000 - 200,000 - 100% CONSTRUCTION PROJECTS 2,139,721 451,871 55,115 2,084,606 3% 2,346,881$ 539,728$ 264,163$ 2,082,718$ 11% CITY OF EDMONDS EXPENDITURES BY FUND - DETAIL 2.2.a Packet Pg. 23 Attachment: October 2018 Monthly Financial Report (October Financial Report) 9 Page 4 of 6 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent WATER FUND (421) SALARIES AND WAGES 828,440$ 620,784$ 603,634$ 224,806$ 73% OVERTIME 24,000 16,689 19,307 4,693 80% BENEFITS 392,984 293,093 300,293 92,691 76% UNIFORMS 4,000 4,727 2,747 1,253 69% SUPPLIES 220,000 121,932 122,879 97,121 56% FUEL CONSUMED - - 70 (70) 0% WATER PURCHASED FOR RESALE 1,800,000 1,445,356 1,553,782 246,218 86% SUPPLIES PURCHASED FOR INVENTORY/RESALE 170,000 192,551 78,176 91,824 46% SMALL EQUIPMENT 11,000 4,489 2,236 8,764 20% PROFESSIONAL SERVICES 866,647 1,171,056 602,835 263,812 70% COMMUNICATIONS 30,000 25,397 22,447 7,553 75% TRAVEL 200 45 - 200 0% EXCISE TAXES 400,000 344,952 379,007 20,993 95% RENTAL/LEASE 144,907 120,677 118,541 26,366 82% INSURANCE 56,050 58,214 56,738 (688) 101% UTILITIES 35,000 20,042 20,662 14,338 59% REPAIRS & MAINTENANCE 239,500 373,192 143,706 95,794 60% MISCELLANEOUS 84,785 79,162 82,380 2,405 97% INTERGOVERNMENTAL SERVICES 30,000 38,184 33,086 (3,086) 110% INTERFUND TAXES 1,209,700 1,025,687 1,025,199 184,501 85% INTERFUND SUBSIDIES 644,620 215,315 211,087 433,533 33% MACHINERY/EQUIPMENT 15,000 - - 15,000 0% CONSTRUCTION PROJECTS 5,648,935 742,481 3,109,281 2,539,654 55% GENERAL OBLIGATION BONDS 2,670 - - 2,670 0% REVENUE BONDS 344,650 - - 344,650 0% INTERGOVERNMENTAL LOANS 25,840 25,839 25,839 1 100% INTEREST 236,100 123,678 118,495 117,605 50% OTHER INTEREST & DEBT SERVICE COSTS - 375 375 (375) 0% 13,465,028$ 7,063,917$ 8,632,802$ 4,832,226$ 64% STORM FUND (422) SALARIES AND WAGES 677,138$ 484,833$ 537,535$ 139,603$ 79% OVERTIME 6,000 9,600 9,417 (3,417) 157% BENEFITS 356,297 256,251 293,934 62,363 82% UNIFORMS 6,500 4,849 5,353 1,147 82% SUPPLIES 46,000 31,142 28,226 17,774 61% SMALL EQUIPMENT 4,000 5,880 317 3,683 8% PROFESSIONAL SERVICES 719,276 831,445 637,374 81,902 89% COMMUNICATIONS 3,200 4,429 3,556 (356) 111% TRAVEL 4,300 - 1,082 3,218 25% EXCISE TAXES 55,000 51,294 56,509 (1,509) 103% RENTAL/LEASE 250,767 217,131 205,263 45,504 82% INSURANCE 71,540 72,028 178,798 (107,258) 250% UTILITES 10,500 7,952 8,168 2,332 78% REPAIR & MAINTENANCE 15,000 50,642 14,577 423 97% MISCELLANEOUS 88,500 65,536 91,673 (3,173) 104% INTERGOVERNMENTAL SERVICES 150,000 112,258 119,969 30,031 80% INTERFUND TAXES AND OPERATING ASSESSMENT 406,100 315,597 345,333 60,767 85% INTERFUND SUBSIDIES 298,500 84,737 83,159 215,341 28% MACHINERY/EQUIPMENT 315,000 - - 315,000 0% CONSTRUCTION PROJECTS 3,074,815 84,252 598,144 2,476,671 19% GENERAL OBLIGATION BONDS 97,320 - - 97,320 0% REVENUE BONDS 168,360 - - 168,360 0% INTERGOVERNMENTAL LOANS 32,070 32,063 32,063 8 100% INTEREST 129,830 68,881 65,463 64,367 50% OTHER INTEREST & DEBT SERVICE COSTS - 165 165 (165) 0% 6,986,013$ 2,790,966$ 3,316,077$ 3,669,936$ 47% EXPENDITURES BY FUND - DETAIL CITY OF EDMONDS 2.2.a Packet Pg. 24 Attachment: October 2018 Monthly Financial Report (October Financial Report) 10 Page 5 of 6 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent SEWER FUND (423) SALARIES AND WAGES 1,793,854$ 1,402,601$ 1,395,512$ 398,342$ 78% OVERTIME 95,000 80,787 70,796 24,204 75% BENEFITS 821,233 642,736 678,791 142,442 83% UNIFORMS 9,500 7,415 6,591 2,909 69% SUPPLIES 432,200 179,423 261,547 170,653 61% FUEL CONSUMED 80,000 59,799 41,988 38,012 52% SUPPLIES PURCHASED FOR INV OR RESALE 4,000 2,989 3,853 147 96% SMALL EQUIPMENT 50,000 19,932 33,625 16,375 67% PROFESSIONAL SERVICES 1,367,627 1,752,043 930,515 437,112 68% COMMUNICATIONS 43,000 33,732 34,890 8,110 81% TRAVEL 5,000 - 3,913 1,088 78% EXCISE TAXES 200,000 187,830 179,344 20,656 90% RENTAL/LEASE 310,809 252,472 255,917 54,892 82% INSURANCE 109,270 116,720 119,178 (9,908) 109% UTILITIES 1,217,860 1,029,911 784,249 433,611 64% REPAIR & MAINTENANCE 695,000 315,757 417,050 277,950 60% MISCELLANEOUS 105,450 85,031 65,335 40,115 62% INTERGOVERNMENTAL SERVICES 168,000 109,106 100,642 67,358 60% INTERFUND TAXES AND OPERATING ASSESSMENT 763,000 578,092 642,327 120,673 84% INTERFUND SUBSIDIES 1,681,512 1,482,744 413,431 1,268,081 25% MACHINERY/EQUIPMENT 85,000 173,745 96,271 (11,271) 113% CONSTRUCTION PROJECTS 4,138,435 2,881,832 2,019,803 2,118,632 49% GENERAL OBLIGATION BONDS 148,140 - - 148,140 0% REVENUE BONDS 77,010 - - 77,010 0% INTERGOVERNMENTAL LOANS 171,890 171,230 171,872 18 100% INTEREST 81,750 47,528 44,050 37,700 54% OTHER INTEREST & DEBT SERVICE COSTS - 5,939 5,662 (5,662) 0% 14,654,540$ 11,619,393$ 8,777,152$ 5,877,388$ 60% BOND RESERVE FUND (424) REVENUE BONDS 710,020$ -$ -$ 710,020$ 0% INTEREST 1,281,500 654,342 640,742 640,758 50% 1,991,520$ 654,342$ 640,742$ 1,350,778$ 32% EXPENDITURES BY FUND - DETAIL CITY OF EDMONDS 2.2.a Packet Pg. 25 Attachment: October 2018 Monthly Financial Report (October Financial Report) 11 Page 6 of 6 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent EQUIPMENT RENTAL FUND (511) SALARIES AND WAGES 250,519$ 195,075$ 210,627$ 39,892$ 84% OVERTIME 2,000 48 - 2,000 0% BENEFITS 114,956 86,591 95,095 19,861 83% UNIFORMS 1,000 651 902 98 90% SUPPLIES 110,000 60,952 65,550 44,450 60% FUEL CONSUMED 1,000 - - 1,000 0% SUPPLIES PURCHASED FOR INVENTORY/RESALE 268,000 154,626 151,919 116,081 57% SMALL EQUIPMENT 58,000 53,378 5,919 52,081 10% PROFESSIONAL SERVICES 44,000 2,088 2,926 41,074 7% COMMUNICATIONS 3,000 1,923 1,848 1,152 62% TRAVEL 1,000 - 339 661 34% RENTAL/LEASE 9,780 12,459 7,788 1,992 80% INSURANCE 29,010 26,351 29,464 (454) 102% UTILITIES 14,000 10,196 10,547 3,453 75% REPAIRS & MAINTENANCE 60,000 39,603 24,800 35,200 41% MISCELLANEOUS 12,000 7,992 7,497 4,503 62% INTERGOVERNMENTAL SERVICES 2,500 1,765 1,580 920 63% MACHINERY/EQUIPMENT 689,317 745,538 340,069 349,248 49% 1,670,082$ 1,399,235$ 956,870$ 713,212$ 57% TECHNOLOGY RENTAL FUND (512) SALARIES AND WAGES 283,742$ 231,072$ 232,898$ 50,844$ 82% OVERTIME 2,000 30 1,632 368 82% BENEFITS 98,101 77,797 77,725 20,376 79% SUPPLIES 5,000 12,580 4,254 746 85% SMALL EQUIPMENT 23,000 45,900 89,201 (66,201) 388% PROFESSIONAL SERVICES 203,300 18,932 164,186 39,114 81% COMMUNICATIONS 58,770 35,856 34,709 24,061 59% TRAVEL 1,500 (17) 412 1,088 27% RENTAL/LEASE 6,810 7,059 6,194 616 91% REPAIRS & MAINTENANCE 315,190 152,106 164,651 150,539 52% MISCELLANEOUS 5,000 9,632 9,581 (4,581) 192% MACHINERY/EQUIPMENT 333,000 - 102,746 230,254 31% 1,335,413$ 590,947$ 888,190$ 447,223$ 67% FIREMEN'S PENSION FUND (617) BENEFITS 23,000$ 16,645$ 18,570$ 4,430$ 81% PENSION AND DISABILITY PAYMENTS 51,018 39,807 44,132 6,886 87% PROFESSIONAL SERVICES 1,200 - 538 662 45% 75,218$ 56,452$ 63,241$ 11,977$ 84% TOTAL EXPENDITURE ALL FUNDS 100,086,515$ 65,151,966$ 64,960,448$ 35,126,067$ 65% CITY OF EDMONDS EXPENDITURES BY FUND - DETAIL 2.2.a Packet Pg. 26 Attachment: October 2018 Monthly Financial Report (October Financial Report) 12 Page 1 of 1 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent CITY COUNCIL 580,919$ 233,786$ 346,118$ 234,801$ 60% OFFICE OF MAYOR 297,088 227,415 241,596 55,492 81% HUMAN RESOURCES 477,314 309,144 346,629 130,685 73% MUNICIPAL COURT 1,105,852 798,191 821,270 284,582 74% CITY CLERK 697,748 523,808 551,894 145,854 79% FINANCE 1,237,786 886,813 894,693 343,093 72% CITY ATTORNEY 847,480 664,783 689,232 158,248 81% NON-DEPARTMENTAL 14,267,661 10,640,517 10,626,583 3,641,078 74% POLICE SERVICES 11,302,664 8,485,904 9,112,432 2,190,232 81% COMMUNITY SERVICES/ECONOMIC DEV.597,661 430,400 463,583 134,078 78% DEVELOPMENT SERVICES 3,357,716 2,204,563 2,253,434 1,104,282 67% PARKS & RECREATION 4,411,972 3,263,584 3,318,630 1,093,342 75% PUBLIC WORKS 3,114,829 2,192,248 2,321,888 792,941 75% FACILITIES MAINTENANCE 2,305,363 1,365,309 1,468,277 837,086 64% 44,602,053$ 32,226,465$ 33,456,258$ 11,145,795$ 75% Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent WATER UTILITY FUND 13,465,028$ 7,063,917$ 8,632,802$ 4,832,226$ 64% STORM UTILITY FUND 6,986,013 2,790,966 3,316,077 3,669,936 47% SEWER/WWTP UTILITY FUND 14,654,540 11,619,393 8,777,152 5,877,388 60% BOND RESERVE FUND 1,991,520 654,342 640,742 1,350,778 32% 37,097,101$ 22,128,618$ 21,366,772$ 15,730,329$ 58% EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN SUMMARY EXPENDITURES - UTILITY- BY FUND IN SUMMARY CITY OF EDMONDS CITY OF EDMONDS 2.2.a Packet Pg. 27 Attachment: October 2018 Monthly Financial Report (October Financial Report) 13 Page 1 of 4 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent CITY COUNCIL SALARIES 169,808$ 132,262$ 136,022$ 33,787$ 80% OVERTIME 1,000 - - 1,000 0% BENEFITS 119,687 81,911 77,441 42,246 65% SUPPLIES 2,000 1,030 1,042 958 52% SMALL EQUIPMENT - 285 15,089 (15,089) 0% PROFESSIONAL SERVICES 237,160 1,672 90,578 146,582 38% COMMUNICATIONS 3,000 3,001 2,821 179 94% TRAVEL 6,700 1,261 2,213 4,487 33% RENTAL/LEASE 16,064 7,283 13,582 2,482 85% REPAIRS/MAINTENANCE 500 - - 500 0% MISCELLANEOUS 25,000 5,080 7,331 17,669 29% 580,919$ 233,786$ 346,118$ 234,801$ 60% OFFICE OF MAYOR SALARIES 208,326$ 168,590$ 174,265$ 34,061$ 84% BENEFITS 53,611 41,383 41,605 12,006 78% SUPPLIES 1,500 553 505 995 34% PROFESSIONAL SERVICES 2,000 1,582 1,943 57 97% COMMUNICATION 1,400 1,125 1,359 41 97% TRAVEL 4,000 1,053 829 3,171 21% RENTAL/LEASE 21,801 9,247 17,356 4,445 80% MISCELLANEOUS 4,450 3,882 3,733 717 84% 297,088$ 227,415$ 241,596$ 55,492$ 81% HUMAN RESOURCES SALARIES 249,577$ 179,329$ 191,238$ 58,339$ 77% OVERTIME - 369 - - 0% BENEFITS 84,882 63,900 72,792 12,090 86% SUPPLIES 12,300 1,870 3,259 9,041 26% SMALL EQUIPMENT 300 909 - 300 0% PROFESSIONAL SERVICES 68,000 32,938 43,831 24,169 64% COMMUNICATIONS 700 1,013 920 (220) 131% TRAVEL 1,000 337 1,593 (593) 159% RENTAL/LEASE 25,525 18,396 22,636 2,890 89% REPAIR/MAINTENANCE 7,850 7,056 7,326 524 93%MISCELLANEOUS 27,180 3,027 3,035 24,145 11% 477,314$ 309,144$ 346,629$ 130,685$ 73% MUNICIPAL COURT SALARIES 587,898$ 482,732$ 468,735$ 119,163$ 80% OVERTIME 800 441 118 682 15% BENEFITS 245,141 190,252 183,279 61,862 75% SUPPLIES 9,600 5,457 6,855 2,745 71% SMALL EQUIPMENT 1,000 474 283 717 28% PROFESSIONAL SERVICES 91,925 66,490 73,388 18,537 80% COMMUNICATIONS 2,700 2,256 2,071 629 77% TRAVEL 6,500 1,852 3,616 2,884 56% RENTAL/LEASE 71,204 33,268 60,132 11,072 84% REPAIR/MAINTENANCE 4,263 537 - 4,263 0% MISCELLANEOUS 14,000 14,433 22,793 (8,793) 163% MACHINERY/EQUIPMENT 70,821 - - 70,821 0% 1,105,852$ 798,191$ 821,270$ 284,582$ 74% EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL CITY OF EDMONDS 2.2.a Packet Pg. 28 Attachment: October 2018 Monthly Financial Report (October Financial Report) 14 Page 2 of 4 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent CITY CLERK SALARIES AND WAGES 345,266$ 272,504$ 298,419$ 46,847$ 86% BENEFITS 163,547 123,954 126,875 36,672 78% SUPPLIES 10,240 3,592 2,935 7,305 29% PROFESSIONAL SERVICES 28,310 25,157 18,710 9,600 66% COMMUNICATIONS 50,000 21,931 21,503 28,497 43% TRAVEL 1,000 368 496 504 50% RENTAL/LEASE 64,305 39,997 49,832 14,473 77% REPAIRS & MAINTENANCE 31,080 30,422 26,551 4,529 85% MISCELLANEOUS 4,000 5,883 6,573 (2,573) 164% 697,748$ 523,808$ 551,894$ 145,854$ 79% FINANCE SALARIES 821,066$ 572,027$ 601,125$ 219,941$ 73% OVERTIME 4,500 - 146 4,354 3% BENEFITS 284,724 200,673 192,583 92,141 68% SUPPLIES 7,350 3,907 3,734 3,616 51% SMALL EQUIPMENT 5,400 1,612 3,831 1,569 71% PROFESSIONAL SERVICES 9,300 34,237 1,442 7,858 16% COMMUNICATIONS 2,000 1,548 1,010 990 50% TRAVEL 3,100 2,465 4,353 (1,253) 140% RENTAL/LEASE 48,146 26,243 40,681 7,465 84%REPAIR/MAINTENANCE 38,500 40,372 41,121 (2,621) 107%MISCELLANEOUS 13,700 3,730 4,666 9,034 34% 1,237,786$ 886,813$ 894,693$ 343,093$ 72% CITY ATTORNEY PROFESSIONAL SERVICES 847,480$ 664,783$ 689,232$ 158,248$ 81% 847,480$ 664,783$ 689,232$ 158,248$ 81% NON-DEPARTMENTAL BENEFITS - UNEMPLOYMENT -$ 2,975$ 10,510$ (10,510)$ 0% SUPPLIES 5,000 829 6,941 (1,941) 139% PROFESSIONAL SERVICES 724,544 395,889 398,980 325,564 55% EXCISE TAXES 6,500 4,399 5,170 1,330 80% RENTAL/LEASE 10,307 9,333 9,533 774 92% INSURANCE 624,530 616,495 437,253 187,277 70% MISCELLANEOUS 164,070 66,290 66,737 97,333 41% INTERGOVT SERVICES 9,776,340 8,992,966 8,454,284 1,322,056 86% ECA LOAN PAYMENT 695,000 - 441,873 253,127 64% INTERFUND SUBSIDIES 1,863,370 537,130 779,625 1,083,745 42% LAND 200,000 - 4,884 195,116 2% GENERAL OBLIGATION BOND 176,340 - - 176,340 0% INTEREST ON LONG-TERM DEBT 21,160 13,990 10,576 10,584 50% FISCAL AGENT FEES 500 222 218 282 44% 14,267,661$ 10,640,517$ 10,626,583$ 3,641,078$ 74% CITY OF EDMONDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2.2.a Packet Pg. 29 Attachment: October 2018 Monthly Financial Report (October Financial Report) 15 Page 3 of 4 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent POLICE SERVICES SALARIES 6,560,766$ 5,049,193$ 5,271,299$ 1,289,467$ 80% OVERTIME 470,513 381,915 520,210 (49,697) 111% HOLIDAY BUYBACK 243,389 4,413 7,135 236,254 3% BENEFITS 2,544,708 1,974,240 2,060,278 484,430 81% UNIFORMS 78,650 53,512 59,285 19,365 75% SUPPLIES 86,500 49,066 69,710 16,790 81% SMALL EQUIPMENT 28,610 18,673 44,661 (16,051) 156% PROFESSIONAL SERVICES 123,420 70,573 91,997 31,423 75% COMMUNICATIONS 32,000 32,412 30,630 1,370 96% TRAVEL 19,310 19,144 23,294 (3,984) 121% RENTAL/LEASE 984,878 697,245 816,416 168,462 83% REPAIR/MAINTENANCE 15,120 6,621 7,644 7,476 51% MISCELLANEOUS 46,350 29,685 45,204 1,146 98% INTERGOVTL SERVICES 10,550 8,078 5,385 5,165 51% MACHINERY/EQUIPMENT 57,900 91,135 59,284 (1,384) 102% 11,302,664$ 8,485,904$ 9,112,432$ 2,190,232$ 81% COMMUNITY SERVICES/ECON DEV. SALARIES 238,449$ 192,671$ 196,462$ 41,987$ 82% BENEFITS 76,571 59,931 61,446 15,125 80% SUPPLIES 7,000 7,218 6,519 481 93% SMALL EQUIPMENT 800 - 44 756 5% PROFESSIONAL SERVICES 247,600 157,541 182,885 64,715 74% COMMUNICATIONS 1,490 991 1,002 488 67% TRAVEL 2,000 1,048 746 1,254 37% RENTAL/LEASE 13,751 8,040 10,511 3,240 76% REPAIR/MAINTENANCE 500 - - 500 0% MISCELLANEOUS 9,500 2,959 3,968 5,532 42% 597,661$ 430,400$ 463,583$ 134,078$ 78% DEVELOPMENT SERVICES/PLANNING SALARIES 1,623,298$ 1,230,221$ 1,231,847$ 391,451$ 76% OVERTIME 1,300 12,552 19,470 (18,170) 1498% BENEFITS 625,023 455,221 464,061 160,962 74% UNIFORMS 500 - 633 (133) 127% SUPPLIES 16,100 10,882 9,110 6,990 57% SMALL EQUIPMENT 6,100 6,131 6,007 93 98% PROFESSIONAL SERVICES 829,526 310,392 354,314 475,212 43% COMMUNICATIONS 9,000 6,854 6,503 2,497 72% TRAVEL 4,750 7,085 4,591 159 97% RENTAL/LEASE 156,959 121,613 129,928 27,031 83% REPAIRS & MAINTENANCE 31,100 2,489 2,773 28,328 9% MISCELLANEOUS 54,060 41,124 24,197 29,863 45% 3,357,716$ 2,204,563$ 2,253,434$ 1,104,282$ 67% ENGINEERING SALARIES 1,661,359$ 1,178,489$ 1,221,671$ 439,688$ 74% OVERTIME 5,000 104 4,968 32 99% BENEFITS 710,496 496,871 500,390 210,106 70% UNIFORMS 360 - - 360 0% SMALL EQUIPMENT 2,200 3,383 3,645 (1,445) 166% PROFESSIONAL SERVICES 28,240 29,885 17,111 11,129 61% COMMUNICATIONS 16,625 10,781 10,942 5,683 66% TRAVEL 600 39 341 259 57% RENTAL/LEASE 120,624 75,941 98,729 21,895 82% REPAIR/MAINTENANCE 2,600 587 - 2,600 0% MISCELLANEOUS 52,677 11,265 44,122 8,555 84% 2,600,781$ 1,807,345$ 1,901,918$ 698,863$ 73% CITY OF EDMONDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2.2.a Packet Pg. 30 Attachment: October 2018 Monthly Financial Report (October Financial Report) 16 Page 4 of 4 Title 2018 Amended Budget 10/31/2017 Expenditures 10/31/2018 Expenditures Amount Remaining % Spent PARKS & RECREATION SALARIES 2,048,165$ 1,565,662$ 1,588,921$ 459,244$ 78% OVERTIME 10,000 20,497 13,237 (3,237) 132% BENEFITS 847,782 624,685 627,684 220,098 74% UNIFORMS 6,275 3,478 3,039 3,236 48% SUPPLIES 125,390 109,222 117,275 8,115 94% SMALL EQUIPMENT 7,750 12,330 6,021 1,729 78% PROFESSIONAL SERVICES 595,160 367,748 356,435 238,725 60% COMMUNICATIONS 30,320 19,423 21,010 9,310 69% TRAVEL 4,870 5,819 2,411 2,459 50% RENTAL/LEASE 264,378 235,675 218,865 45,513 83% PUBLIC UTILITY 175,000 180,368 193,561 (18,561) 111% REPAIR/MAINTENANCE 29,700 31,497 13,167 16,533 44% MISCELLANEOUS 92,610 59,304 56,617 35,993 61% INTERGOVTL SERVICES 114,572 27,876 79,510 35,062 69% BUILDINGS 60,000 - - 60,000 0% MACHINERY/EQUIPMENT - - 20,875 (20,875) 0% 4,411,972$ 3,263,584$ 3,318,630$ 1,093,342$ 75% PUBLIC WORKS SALARIES 279,248$ 228,242$ 230,022$ 49,226$ 82% OVERTIME 200 - - 200 0% BENEFITS 92,055 72,791 82,455 9,600 90% SUPPLIES 8,600 3,510 2,978 5,622 35% SMALL EQUIPMENT 1,000 - - 1,000 0% PROFESSIONAL SERVICES 200 83 82 118 41% COMMUNICATIONS 1,350 581 539 811 40% TRAVEL 500 - 378 122 76% RENTAL/LEASE 122,195 77,162 100,838 21,357 83% PUBLIC UTILITY 2,800 2,052 2,150 650 77% REPAIR/MAINTENANCE 1,000 - - 1,000 0% MISCELLANEOUS 4,900 482 530 4,371 11% 514,048$ 384,903$ 419,971$ 94,077$ 82% FACILITIES MAINTENANCE SALARIES 729,620 605,505 597,167 132,453 82% OVERTIME 10,500 7,334 5,417 5,083 52% BENEFITS 325,233 258,707 272,839 52,394 84% UNIFORMS 3,000 4,053 4,356 (1,356) 145% SUPPLIES 87,000 77,087 80,327 6,673 92% SMALL EQUIPMENT 3,000 1,345 2,607 393 87% PROFESSIONAL SERVICES 166,200 14,603 44,557 121,643 27% COMMUNICATIONS 16,000 14,736 14,310 1,690 89% TRAVEL 1,000 - - 1,000 0% RENTAL/LEASE 68,310 50,148 55,032 13,278 81% PUBLIC UTILITY 280,000 238,584 242,485 37,515 87% REPAIR/MAINTENANCE 564,500 88,809 148,961 415,539 26% MISCELLANEOUS 5,000 4,397 218 4,782 4% BUILDINGS 23,000 - - 23,000 0% MACHINERY/EQUIPMENT 23,000 - - 23,000 0% 2,305,363$ 1,365,309$ 1,468,277$ 837,086$ 64% TOTAL GENERAL FUND EXPENDITURES 44,602,053$ 32,226,465$ 33,456,258$ 11,145,795$ 75% CITY OF EDMONDS EXPENDITURES - GENERAL FUND - BY DEPARTMENT IN DETAIL 2.2.a Packet Pg. 31 Attachment: October 2018 Monthly Financial Report (October Financial Report) 17 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 1,988,623$ 1,988,623$ 2,195,035$ 10.38% February 4,782,198 2,793,575 4,464,993 -6.63% March 7,143,525 2,361,328 7,004,229 -1.95% April 10,854,411 3,710,885 9,270,240 -14.59% May 18,367,542 7,513,131 18,167,955 -1.09% June 20,439,562 2,072,020 21,117,777 3.32% July 22,481,733 2,042,170 23,448,404 4.30% August 24,815,448 2,333,715 26,213,586 5.63% September 26,857,557 2,042,109 28,584,102 6.43% October 29,659,989 2,802,432 30,903,967 4.19% November 37,315,325 7,655,336 38,880,378 4.19% December 39,501,682 2,186,357 41,158,433 4.19% Real Estate Excise Tax 1 & 2 Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 219,352$ 219,352$ 251,030$ 14.44% February 381,613 162,261 407,050 6.67% March 588,896 207,283 1,009,202 71.37% April 780,860 191,964 1,240,201 58.83% May 1,005,087 224,227 1,528,062 52.03% June 1,248,349 243,262 1,830,143 46.61% July 1,653,074 404,724 2,138,601 29.37% August 1,929,331 276,257 2,514,349 30.32% September 2,197,100 267,769 2,905,697 32.25% October 2,416,963 219,864 3,113,763 28.83% November 2,630,341 213,377 3,388,655 28.83% December 2,800,000 169,659 3,607,227 28.83% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Revenue Summary-General Fund 2018 City of Edmonds, WA Monthly Revenue Summary-Real Estate Excise Tax 0 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 40,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC General Fund Current Year Budget Prior Year 0 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Real Estate Excise Tax 1 & 2 Current Year Budget Prior Year 2.2.a Packet Pg. 32 Attachment: October 2018 Monthly Financial Report (October Financial Report) 18 SALES TAX SUMMARY Wholesale Trade, $225,157 Communications, $199,622 Clothing and Accessories, $199,480 Accommodation, $38,007 Construction Trade, $1,460,184 Health & Personal Care, $195,535 Automotive Repair, $159,340 Amusement & Recreation, $73,242 Business Services, $622,297 Gasoline, $29,805 Retail Food Stores, $243,882 Retail Automotive, $1,473,614 Manufacturing, $83,725 Eating & Drinking, $847,867 Others, $62,090 Misc Retail, $968,834 Sales Tax Analysis By Category Current Period: October 2018 Year-to-Date Total $6,882,682 $5,325,287 $5,840,764 $6,741,838 $6,905,122 $7,395,114 $6,882,682 0 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 2013 2014 2015 2016 2017 YTD 2018 Annual Sales Tax Revenue 2.2.a Packet Pg. 33 Attachment: October 2018 Monthly Financial Report (October Financial Report) 19 Sales and Use Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 552,482$ 552,482$ 585,948$ 6.06% February 1,249,207 696,725 1,321,958 5.82% March 1,777,304 528,097 1,886,310 6.13% April 2,272,493 495,189 2,452,585 7.92% May 2,906,618 634,125 3,194,085 9.89% June 3,468,607 561,989 3,866,411 11.47% July 4,058,559 589,952 4,614,605 13.70% August 4,707,320 648,761 5,410,151 14.93% September 5,334,689 627,369 6,141,885 15.13% October 5,989,537 654,848 6,882,682 14.91% November 6,670,224 680,687 7,664,871 14.91% December 7,275,000 604,776 8,359,830 14.91% Gas Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 88,482$ 88,482$ 97,973$ 10.73% February 187,698 99,217 187,404 -0.16% March 267,256 79,558 268,029 0.29% April 335,144 67,888 323,194 -3.57% May 387,986 52,843 383,162 -1.24% June 424,966 36,979 415,620 -2.20% July 453,766 28,800 442,776 -2.42% August 477,013 23,247 466,145 -2.28% September 498,430 21,418 487,993 -2.09% October 523,180 24,749 512,053 -2.13% November 561,415 38,235 549,475 -2.13% December 620,200 58,785 607,010 -2.13% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Revenue Summary-Sales and Use Tax 2018 City of Edmonds, WA Monthly Revenue Summary-Gas Utility Tax 0 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Sales and Use Tax Current Year Budget Prior Year 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Gas Utility Tax Current Year Budget Prior Year 2.2.a Packet Pg. 34 Attachment: October 2018 Monthly Financial Report (October Financial Report) 20 Telephone Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 101,864$ 101,864$ 94,392$ -7.34% February 202,129 100,265 183,702 -9.12% March 294,029 91,900 265,638 -9.66% April 390,095 96,066 350,982 -10.03% May 478,713 88,617 430,977 -9.97% June 568,042 89,329 512,099 -9.85% July 652,808 84,766 592,511 -9.24% August 740,812 88,004 670,052 -9.55% September 832,244 91,432 748,849 -10.02% October 920,171 87,927 824,223 -10.43% November 1,003,763 83,592 899,098 -10.43% December 1,093,200 89,437 979,210 -10.43% Electric Utility Tax Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 171,906$ 171,906$ 169,967$ -1.13% February 353,028 181,122 380,238 7.71% March 518,242 165,214 535,565 3.34% April 683,645 165,403 714,751 4.55% May 824,846 141,201 864,247 4.78% June 940,385 115,539 989,943 5.27% July 1,050,933 110,549 1,098,482 4.52% August 1,157,071 106,138 1,213,435 4.87% September 1,262,180 105,109 1,328,348 5.24% October 1,372,403 110,223 1,432,027 4.34% November 1,490,337 117,934 1,555,085 4.34% December 1,611,600 121,263 1,681,617 4.34% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Revenue Summary-Telephone Utility Tax 2018 City of Edmonds, WA Monthly Revenue Summary-Electric Utility Tax 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Telephone Utility Tax Current Year Budget Prior Year 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Electric Utility Tax Current Year Budget Prior Year 2.2.a Packet Pg. 35 Attachment: October 2018 Monthly Financial Report (October Financial Report) 21 Meter Water Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 671,144$ 671,144$ 686,803$ 2.33% February 1,136,017 464,873 1,148,411 1.09% March 1,808,515 672,498 1,786,469 -1.22% April 2,250,797 442,282 2,228,766 -0.98% May 2,907,543 656,746 2,899,778 -0.27% June 3,420,955 513,413 3,395,518 -0.74% July 4,227,120 806,165 4,220,193 -0.16% August 4,933,718 706,598 4,933,652 0.00% September 5,902,426 968,708 5,914,461 0.20% October 6,565,192 662,766 6,615,148 0.76% November 7,332,394 767,202 7,388,188 0.76% December 7,804,500 472,106 7,863,886 0.76% Storm Water Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 293,128$ 293,128$ 287,956$ -1.13% February 924,642 631,514 913,794 7.71% March 1,217,367 292,725 1,201,441 3.34% April 1,476,942 259,575 1,457,402 4.55% May 1,769,842 292,900 1,745,509 4.78% June 2,030,237 260,395 2,001,084 5.27% July 2,324,515 294,278 2,286,682 -1.63% August 2,956,345 631,830 2,911,729 -1.51% September 3,248,569 292,224 3,199,712 -1.50% October 3,508,364 259,794 3,454,610 -1.53% November 3,801,321 292,958 3,743,079 -1.53% December 4,061,395 260,074 3,999,168 -1.53% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Revenue Summary-Meter Water Sales 2018 City of Edmonds, WA Monthly Revenue Summary-Storm Water Sales 0 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Meter Water Sales Current Year Budget Prior Year 0 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Storm Water Sales Current Year Budget Prior Year 2.2.a Packet Pg. 36 Attachment: October 2018 Monthly Financial Report (October Financial Report) 22 Unmeter Sewer Sales Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 691,863$ 691,863$ 707,735$ 2.29% February 1,253,067 561,204 1,269,207 1.29% March 1,943,785 690,719 1,962,615 0.97% April 2,507,611 563,825 2,530,122 0.90% May 3,199,180 691,569 3,257,122 1.81% June 3,770,233 571,053 3,824,244 1.43% July 4,484,245 714,012 4,538,764 1.22% August 5,054,160 569,916 5,108,881 1.08% September 5,782,066 727,906 5,847,372 1.13% October 6,358,537 576,471 6,427,306 1.08% November 7,064,218 705,680 7,140,618 1.08% December 7,629,500 565,282 7,712,014 1.08% City of Edmonds, WA Monthly Revenue Summary-Unmeter Sewer Sales 2018 *The monthly budget forecast columns are based on a five-year average. 0 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Unmeter Sewer Sales Current Year Budget Prior Year 2.2.a Packet Pg. 37 Attachment: October 2018 Monthly Financial Report (October Financial Report) 23 General Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 5,469,085$ 5,469,085$ 4,000,420$ -26.85% February 8,015,743 2,546,658 7,074,254 -11.75% March 11,825,133 3,809,390 9,997,735 -15.45% April 15,808,122 3,982,988 13,366,102 -15.45% May 18,194,702 2,386,581 16,471,112 -9.47% June 22,115,109 3,920,407 20,515,429 -7.23% July 25,846,219 3,731,110 23,760,976 -8.07% August 29,887,263 4,041,045 26,305,714 -11.98% September 33,369,298 3,482,034 30,144,324 -9.66% October 36,249,856 2,880,558 33,456,258 -7.71% November 40,409,631 4,159,775 37,295,460 -7.71% December 44,602,053 4,192,422 41,164,793 -7.71% Non-Departmental Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 2,937,966$ 2,937,966$ 1,916,589$ -34.76% February 3,200,794 262,827 2,811,392 -12.17% March 4,639,496 1,438,703 3,588,829 -22.65% April 6,112,868 1,473,372 4,704,813 -23.03% May 6,257,168 144,300 5,479,175 -12.43% June 7,760,032 1,502,864 7,214,671 -7.03% July 8,914,150 1,154,117 8,153,117 -8.54% August 10,244,546 1,330,396 8,273,085 -19.24% September 11,228,088 983,542 9,756,639 -13.11% October 11,666,508 438,420 10,626,583 -8.91% November 13,009,305 1,342,798 11,849,687 -8.91% December 14,267,661 1,258,356 12,995,876 -8.91% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Expenditure Report-General Fund 2018 City of Edmonds, WA Monthly Expenditure Report-Non-Departmental 0 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 40,000,000 45,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC General Fund Current Year Budget Prior Year 0 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Non-Departmental Current Year Budget Prior Year 2.2.a Packet Pg. 38 Attachment: October 2018 Monthly Financial Report (October Financial Report) 24 City Council Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 39,156$ 39,156$ 20,137$ -48.57% February 81,707 42,551 43,001 -47.37% March 131,158 49,452 67,048 -48.88% April 177,465 46,306 93,044 -47.57% May 223,060 45,595 148,289 -33.52% June 282,118 59,058 211,018 -25.20% July 332,530 50,412 235,182 -29.27% August 383,904 51,375 309,376 -19.41% September 442,045 58,140 332,628 -24.75% October 480,175 38,130 346,118 -27.92% November 530,273 50,099 382,230 -27.92% December 580,919 50,646 418,736 -27.92% Office of Mayor Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 24,264$ 24,264$ 23,355$ -3.75% February 49,615 25,351 47,920 -3.42% March 74,439 24,823 71,633 -3.77% April 98,806 24,367 97,145 -1.68% May 123,154 24,348 120,989 -1.76% June 147,440 24,286 144,437 -2.04% July 172,527 25,087 168,565 -2.30% August 197,868 25,341 192,272 -2.83% September 222,303 24,435 218,015 -1.93% October 247,077 24,774 241,596 -2.22% November 271,327 24,250 265,307 -2.22% December 297,088 25,761 290,497 -2.22% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Expenditure Report-City Council 2018 City of Edmonds, WA Monthly Expenditure Report-Office of Mayor 0 100,000 200,000 300,000 400,000 500,000 600,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC City Council Current Year Budget Prior Year 0.00 50,000.00 100,000.00 150,000.00 200,000.00 250,000.00 300,000.00 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Office of Mayor Current Year Budget Prior Year 2.2.a Packet Pg. 39 Attachment: October 2018 Monthly Financial Report (October Financial Report) 25 Human Resources Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 36,684$ 36,684$ 36,984$ 0.82% February 77,607 40,923 73,258 -5.60% March 118,303 40,696 107,255 -9.34% April 153,693 35,390 140,435 -8.63% May 191,411 37,718 175,117 -8.51% June 229,956 38,546 205,285 -10.73% July 270,034 40,078 242,785 -10.09% August 308,510 38,475 279,002 -9.56% September 345,878 37,368 314,056 -9.20% October 385,381 39,503 346,629 -10.06% November 421,760 36,379 379,350 -10.06% December 477,314 55,554 429,318 -10.06% Municipal Court Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 82,608$ 82,608$ 80,036$ -3.11% February 175,964 93,357 159,028 -9.62% March 269,619 93,655 241,304 -10.50% April 356,946 87,327 326,606 -8.50% May 446,138 89,192 413,053 -7.42% June 534,494 88,356 492,913 -7.78% July 623,552 89,059 570,967 -8.43% August 718,039 94,486 663,923 -7.54% September 811,352 93,313 737,873 -9.06% October 908,794 97,442 821,270 -9.63% November 1,003,801 95,007 907,128 -9.63% December 1,105,852 102,051 999,351 -9.63% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Expenditure Report-Human Resources 2018 City of Edmonds, WA Monthly Expenditure Report-Municipal Court 0 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Human Resources Current Year Budget Prior Year 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Municipal Court Current Year Budget Prior Year 2.2.a Packet Pg. 40 Attachment: October 2018 Monthly Financial Report (October Financial Report) 26 Community Services/Economic Development Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 35,941$ 35,941$ 43,517$ 21.08% February 79,533 43,592 85,170 7.09% March 124,306 44,773 137,596 10.69% April 185,294 60,989 179,612 -3.07% May 224,624 39,330 227,250 1.17% June 267,815 43,192 269,991 0.81% July 314,459 46,644 315,110 0.21% August 365,689 51,229 372,264 1.80% September 415,579 49,890 410,560 -1.21% October 467,909 52,330 463,583 -0.92% November 525,228 57,319 520,372 -0.92% December 597,661 72,433 592,135 -0.92% City Clerk Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 61,917$ 61,917$ 61,232$ -1.11% February 118,102 56,185 116,550 -1.31% March 174,765 56,663 172,403 -1.35% April 233,347 58,582 222,183 -4.78% May 287,099 53,752 277,663 -3.29% June 339,462 52,363 329,209 -3.02% July 395,577 56,115 380,418 -3.83% August 454,007 58,430 464,996 2.42% September 510,652 56,645 503,247 -1.45% October 579,368 68,715 551,894 -4.74% November 638,746 59,378 608,456 -4.74% December 697,748 59,002 664,661 -4.74% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Expenditure Report-Community Services/Economic Development 2018 City of Edmonds, WA Monthly Expenditure Report-City Clerk 0 100,000 200,000 300,000 400,000 500,000 600,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Community Services/Economic Development Current Year Budget Prior Year 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC City Clerk Current Year Budget Prior Year 2.2.a Packet Pg. 41 Attachment: October 2018 Monthly Financial Report (October Financial Report) 27 Technology Rental Fund Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 143,632$ 143,632$ 144,135$ 0.35% February 300,838 157,206 204,078 -32.16% March 388,705 87,867 293,273 -24.55% April 473,229 84,524 351,042 -25.82% May 541,119 67,890 487,412 -9.93% June 613,434 72,315 615,817 0.39% July 720,259 106,826 663,312 -7.91% August 840,735 120,476 725,215 -13.74% September 955,896 115,161 814,841 -14.76% October 1,040,611 84,714 888,190 -14.65% November 1,136,112 95,501 969,703 -14.65% December 1,335,413 199,301 1,139,812 -14.65% Finance Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 124,798$ 124,798$ 125,728$ 0.75% February 223,504 98,706 210,861 -5.66% March 319,397 95,892 296,541 -7.16% April 425,251 105,855 383,670 -9.78% May 523,182 97,931 467,718 -10.60% June 620,315 97,133 552,805 -10.88% July 716,459 96,144 637,823 -10.98% August 814,575 98,117 722,494 -11.30% September 925,150 110,574 808,422 -12.62% October 1,031,905 106,755 894,693 -13.30% November 1,131,680 99,774 981,201 -13.30% December 1,237,786 106,106 1,073,198 -13.30% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Expenditure Report-Technology Rental Fund 2018 City of Edmonds, WA Monthly Expenditure Report-Finance Prior Year amounts are from the Information Services Budget 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Technology Rental Fund Current Year Budget Prior Year 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Finance Current Year Budget Prior Year 2.2.a Packet Pg. 42 Attachment: October 2018 Monthly Financial Report (October Financial Report) 28 City Attorney Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 70,623$ 70,623$ 46,119$ -34.70% February 141,247 70,623 136,648 -3.26% March 211,870 70,623 182,768 -13.74% April 282,493 70,623 252,179 -10.73% May 353,117 70,623 342,708 -2.95% June 423,740 70,623 411,032 -3.00% July 494,363 70,623 483,871 -2.12% August 564,986 70,623 552,195 -2.26% September 635,610 70,623 598,314 -5.87% October 706,233 70,623 689,232 -2.41% November 776,856 70,623 758,155 -2.41% December 847,480 70,623 827,078 -2.41% Police Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 889,723$ 889,723$ 871,900$ -2.00% February 1,785,559 895,836 1,788,816 0.18% March 2,674,909 889,349 2,677,649 0.10% April 3,567,881 892,973 3,581,604 0.38% May 4,454,567 886,686 4,507,241 1.18% June 5,373,977 919,410 5,475,264 1.88% July 6,288,572 914,595 6,356,315 1.08% August 7,188,618 900,047 7,232,795 0.61% September 8,100,572 911,954 8,146,348 0.57% October 9,111,520 1,010,947 9,112,432 0.01% November 10,348,546 1,237,027 10,349,583 0.01% December 11,302,664 954,118 11,303,796 0.01% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Expenditure Report-City Attorney 2018 City of Edmonds, WA Monthly Expenditure Report-Police 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 900,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC City Attorney Current Year Budget Prior Year 0 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 9,000,000 10,000,000 11,000,000 12,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Police Current Year Budget Prior Year 2.2.a Packet Pg. 43 Attachment: October 2018 Monthly Financial Report (October Financial Report) 29 Development Services Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 245,372$ 245,372$ 175,855$ -28.33% February 509,144 263,772 378,818 -25.60% March 792,048 282,904 591,734 -25.29% April 1,048,289 256,241 817,737 -21.99% May 1,329,279 280,990 1,046,070 -21.31% June 1,594,468 265,189 1,273,975 -20.10% July 1,867,530 273,062 1,515,745 -18.84% August 2,165,422 297,892 1,740,882 -19.61% September 2,438,013 272,591 2,027,906 -16.82% October 2,734,269 296,256 2,253,434 -17.59% November 3,041,759 307,489 2,506,849 -17.59% December 3,357,716 315,957 2,767,244 -17.59% Parks & Recreation Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 293,333$ 293,333$ 258,749$ -11.79% February 599,800 306,468 530,383 -11.57% March 926,080 326,279 815,736 -11.92% April 1,249,317 323,237 1,159,777 -7.17% May 1,601,878 352,560 1,462,933 -8.67% June 1,953,226 351,348 1,773,743 -9.19% July 2,434,795 481,570 2,146,804 -11.83% August 2,983,135 548,340 2,536,505 -14.97% September 3,365,079 381,944 2,938,075 -12.69% October 3,703,882 338,803 3,318,630 -10.40% November 4,009,836 305,954 3,592,760 -10.40% December 4,411,972 402,136 3,953,069 -10.40% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Expenditure Report-Development Services 2018 City of Edmonds, WA Monthly Expenditure Report-Parks & Recreation 0 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Development Services Current Year Budget Prior Year 0 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Parks & Recreation Current Year Budget Prior Year 2.2.a Packet Pg. 44 Attachment: October 2018 Monthly Financial Report (October Financial Report) 30 Public Works Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 42,035$ 42,035$ 42,488$ 1.08% February 85,654 43,620 84,736 -1.07% March 128,689 43,035 126,826 -1.45% April 171,578 42,889 168,659 -1.70% May 214,645 43,067 210,364 -1.99% June 257,701 43,056 251,929 -2.24% July 301,222 43,521 294,549 -2.22% August 343,666 42,444 336,142 -2.19% September 384,825 41,159 378,429 -1.66% October 426,961 42,136 419,971 -1.64% November 469,006 42,045 461,327 -1.64% December 514,048 45,042 505,632 -1.64% Facilities Maintenance Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 180,780$ 180,780$ 133,250$ -26.29% February 364,900 184,119 273,490 -25.05% March 559,670 194,771 416,025 -25.67% April 745,373 185,702 558,614 -25.06% May 934,661 189,288 704,933 -24.58% June 1,100,591 165,930 829,817 -24.60% July 1,317,369 216,779 979,062 -25.68% August 1,492,677 175,308 1,136,010 -23.89% September 1,693,451 200,774 1,276,602 -24.62% October 1,878,654 185,203 1,468,277 -21.84% November 2,084,326 205,672 1,629,022 -21.84% December 2,305,363 221,037 1,801,775 -21.84% *The monthly budget forecast columns are based on a five-year average. 2018 City of Edmonds, WA Monthly Expenditure Report-Public Works 2018 City of Edmonds, WA Monthly Expenditure Report-Facilities Maintenance 0 100,000 200,000 300,000 400,000 500,000 600,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Public Works Current Year Budget Prior Year 0 300,000 600,000 900,000 1,200,000 1,500,000 1,800,000 2,100,000 2,400,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Facilities Maintenance Current Year Budget Prior Year 2.2.a Packet Pg. 45 Attachment: October 2018 Monthly Financial Report (October Financial Report) 31 Engineering Cumulative Monthly YTD Variance Budget Forecast Budget Forecast Actuals % January 200,507$ 200,507$ 164,481$ -17.97% February 398,504 197,996 334,182 -16.14% March 613,516 215,012 504,388 -17.79% April 833,268 219,752 680,024 -18.39% May 1,042,728 209,460 887,608 -14.88% June 1,264,837 222,109 1,079,339 -14.67% July 1,477,294 212,457 1,280,665 -13.31% August 1,702,007 224,713 1,493,771 -12.23% September 1,918,545 216,538 1,697,211 -11.54% October 2,140,781 222,236 1,901,918 -11.16% November 2,357,334 216,553 2,094,308 -11.16% December 2,600,781 243,447 2,310,592 -11.16% *The monthly budget forecast columns are based on a five-year average. City of Edmonds, WA Monthly Expenditure Report-Engineering 2018 0 300,000 600,000 900,000 1,200,000 1,500,000 1,800,000 2,100,000 2,400,000 2,700,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Engineering Current Year Budget Prior Year 2.2.a Packet Pg. 46 Attachment: October 2018 Monthly Financial Report (October Financial Report) 32 INVESTMENT PORTFOLIO SUMMARY Years Agency/Investment Purchase to Par Market Maturity Coupon Issuer Type Price Maturity Value Value Date Rate FFCB Bonds 2,010,790 0.16 2,000,000 1,997,398 12/28/18 1.42% First Financial CD 3,000,000 0.23 3,000,000 3,000,000 01/24/19 2.34% FFCB Bonds 2,000,000 0.24 2,000,000 1,995,070 01/25/19 1.23% FICO Bonds 1,009,725 0.48 1,035,000 1,023,673 04/25/19 1.42% SCIP CD 2,500,000 0.59 2,500,000 2,500,000 06/04/19 2.65% FNMA Bonds 999,750 0.62 1,000,000 993,008 06/13/19 1.40% FHLB Bonds 1,000,400 0.64 1,000,000 992,526 06/20/19 1.40% FNMA Bonds 988,720 0.91 1,000,000 989,299 09/27/19 1.50% FHLMC Bonds 995,970 0.92 1,000,000 986,943 10/02/19 1.25% FNMA Bonds 1,994,310 0.99 2,000,000 1,973,248 10/28/19 1.35% FNMA Bonds 997,300 1.41 1,000,000 978,514 03/30/20 1.38% FHLB Bonds 2,003,780 1.41 2,000,000 1,960,820 03/30/20 1.45% FNMA Bonds 2,000,000 1.41 2,000,000 1,969,228 03/30/20 1.65% FHLMC Bonds 2,003,868 1.49 2,000,000 1,957,606 04/28/20 1.35% FNMA Bonds 1,000,000 1.67 1,000,000 976,598 06/30/20 1.38% FNMA Bonds 1,000,000 1.67 1,000,000 976,598 06/30/20 1.38% FHLB Bonds 3,000,000 1.70 3,000,000 2,917,623 07/13/20 1.20% RFCS Bonds 1,999,698 1.71 2,120,000 2,018,363 07/15/20 1.60% FHLB Bonds 2,000,000 1.75 2,000,000 1,962,160 07/30/20 1.75% FNMA Bonds 1,000,000 1.83 1,000,000 972,502 08/28/20 1.40% FNMA Bonds 1,000,000 1.83 1,000,000 972,502 08/28/20 1.40% FHLMC Bonds 999,500 2.17 1,000,000 975,327 12/30/20 1.75% FNMA Bonds 2,005,474 2.22 2,000,000 1,941,184 01/19/21 1.50% FM Bonds 2,000,000 2.42 2,000,000 1,951,424 04/01/21 1.87% FHLB Bonds 2,000,000 2.64 2,000,000 1,957,824 06/22/21 2.18% FFCB Bonds 968,940 2.87 1,000,000 965,498 09/13/21 1.73% FHLMC Bonds 2,000,000 3.07 2,000,000 1,944,182 11/26/21 2.13% FHLMC Bonds 999,400 3.17 1,000,000 967,119 12/30/21 2.00% FHLMC Bonds 1,000,000 3.32 1,000,000 971,735 02/25/22 2.15% TOTAL SECURITIES 46,477,626 1.6 46,655,000 45,787,972 Washington State Local Gov't Investment Pool 7,020,764 7,020,764 Demand 2.23% Snohomish County Local Gov't Investment Pool 6,460,989 6,460,989 Demand 1.93% TOTAL PORTFOLIO 60,136,753$ 59,269,725$ As of October 31, 2018 City of Edmonds Investment Portfolio Detail SCIP -CD, 5% First Financial - CD, 6% RFCS, 5% FHLMC, 17% FFCB, 11% FICO, 2% FHLB, 21%FM, 4% FNMA, 28% Issuer Diversification Checking, $1.3 , 2%State LGIP, $7.0 , 11% County LGIP, $6.5 , 11% CD's, $5.5 , 9% Bonds, $41.2 , 67% Cash and Investment Balances (in $ Millions) 2.2.a Packet Pg. 47 Attachment: October 2018 Monthly Financial Report (October Financial Report) 33 INVESTMENT PORTFOLIO SUMMARY $74,830 $163,214 $335,926 $423,816 $653,690 $774,499 $- $200,000 $400,000 $600,000 $800,000 $1,000,000 2013 2014 2015 2016 2017 YTD 2018 Annual Interest Income 0.0%0.3%0.5%0.8%1.0%1.3%1.5%1.8%2.0%2.3%2.5%2.8% November January March May July September Edmonds Rate of Return Compared to Benchmark (Rolling 12 months) 6 Month Treasury Rate (Benchmark)City Blended Rate 0.00% 0.50% 1.00% 1.50% 2.00% 2.50% $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 0-6 Mo 6-12 Mo 12-18 Mo 18-24 Mo 24-30 Mo 30-36 Mo 36-42 Mo Maturity Distribution and Rate of Return 2.2.a Packet Pg. 48 Attachment: October 2018 Monthly Financial Report (October Financial Report) 34 GENERAL FUND OVERVIEW 12/31/2017 9/30/2018 10/31/2018 Q3 YTD 001-General Fund 10,273,342$ 8,713,120$ 7,721,051$ (2,162,570)$ (2,552,291)$ 009-Leoff-Medical Ins. Reserve 417,154 270,551 244,973 (89,064) (172,181) 011-Risk Management Fund 902,700 919,656 922,960 5,754 20,260 012-Contingency Reserve Fund *5,447,144 5,039,559 5,037,789 (425,482) (409,355) 014-Historic Preservation Gift Fund 7,356 10,013 10,049 63 2,693 016-Building Maintenance 210,221 210,221 210,221 - - 017 - Marsh Restoration & Preservation - 306,860 306,865 10 306,865 018 - Edmonds Homelessness Response - 250,000 225,443 - 225,443 019 - Edmonds Opioid Response - 250,000 250,000 - 250,000 Total General Fund & Subfunds 17,257,917$ 15,969,981$ 14,929,351$ (2,671,289)$ (2,328,566)$ GENERAL FUND & SUBFUNDS FUND BALANCES CHANGE IN FUND BALANCES ---- ACTUAL -------- ACTUAL ---- *Fund 012 made interfund loans to fund 104 for $16,680 and to fund 112 for $442,866 in 2018. $17.26 $15.97 $14.93 - 4 8 12 16 20 24 Dec 2017 June 2018 Oct 2018MillionsGeneralFund & Subfunds *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 2.2.a Packet Pg. 49 Attachment: October 2018 Monthly Financial Report (October Financial Report) 35 GOVERNMENTAL FUNDS OVERVIEW 12/31/2017 9/30/2018 10/31/2018 Q3 YTD General Fund & Subfunds 17,257,917$ 15,969,981$ 14,929,351$ (2,671,289)$ (2,328,566)$ Special Revenue 8,273,865 10,512,975 9,919,324 684,460 1,645,459 Debt Service 3,812 3,812 3,812 - - Capital Projects 1,544,084 2,145,975 2,156,583 235,820 612,499 Total Governmental Funds 27,079,678$ 28,632,743$ 27,009,071$ (1,751,010)$ (70,607)$ CHANGE IN FUND BALANCESGOVERNMENTAL FUNDS FUND BALANCES ---- ACTUAL -------- ACTUAL ---- $17.26 $15.97 $14.93 $8.27 $10.51 $9.92 $0.00 $0.00 $0.00 $1.54 $2.15 $2.16 - 4 8 12 16 20 Dec 2017 June 2018 Oct 2018Millions General Fund & Subfunds Special Revenue Debt Service Capital Projects Governmental Fund Balances-By Fund GroupGovernmentalFund Balances-By Fund Group $27.08 $28.63 $27.01 - 5 10 15 20 25 30 35 Dec 2017 June 2018 Oct 2018MillionsGovernmentalFund Balances -Combined *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 2.2.a Packet Pg. 50 Attachment: October 2018 Monthly Financial Report (October Financial Report) 36 SPECIAL REVENUE FUNDS OVERVIEW 12/31/2017 9/30/2018 10/31/2018 Q3 YTD 104 - Drug Enforcement Fund *692$ (12,987)$ 6,897$ (3,121)$ 6,205$ 111 - Street Fund 1,102,078 1,021,168 1,014,392 34,348 (87,686) 112 - Combined Street Const/Improve *728,782 1,386,405 1,200,654 224,403 471,872 117 - Municipal Arts Acquis. Fund 533,208 576,297 562,464 33,185 29,256 118 - Memorial Street Tree 18,349 18,690 18,757 116 408 120 - Hotel/Motel Tax Revenue Fund 82,355 114,900 124,777 22,287 42,422 121 - Employee Parking Permit Fund 69,294 82,501 83,223 1,865 13,929 122 - Youth Scholarship Fund 15,348 14,138 14,076 (519) (1,272) 123 - Tourism Promotional Fund/Arts 59,886 78,471 79,351 7,716 19,465 125 - Real Estate Tax 2 1,901,003 2,529,007 2,382,468 153,029 481,465 126 - Real Estate Excise Tax 1 2,165,209 2,991,672 2,720,641 173,896 555,432 127 - Gifts Catalog Fund 265,666 314,165 306,501 12,241 40,835 130 - Cemetery Maintenance/Improvement 188,885 209,330 208,833 17,024 19,948 136 - Parks Trust Fund 155,907 158,836 159,406 994 3,499 137 - Cemetery Maintenance Trust Fund 938,109 971,862 977,252 13,182 39,143 138 - Sister City Commission 7,598 12,390 17,273 77 9,675 140 - Business Improvement Disrict 41,496 46,130 42,358 (6,263) 862 Total Special Revenue 8,273,865$ 10,512,975$ 9,919,324$ 684,460$ 1,645,459$ GOVERNMENTAL SPECIAL REVENUE FUND BALANCES CHANGE IN FUND BALANCES ---- ACTUAL -------- ACTUAL ---- *Fund 012 made interfund loans to fund 104 for $16,680 and to fund 112 for $442,866 in 2018. $8.27 $10.51 $9.92 - 3 6 9 12 15 Dec 2017 June 2018 Oct 2018Millions Special Revenue Special Revenue Funds *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 2.2.a Packet Pg. 51 Attachment: October 2018 Monthly Financial Report (October Financial Report) 37 ENTERPRISE FUNDS OVERVIEW 12/31/2017 9/30/2018 10/31/2018 Q3 YTD 421 - Water Utility Fund 19,153,889$ 18,631,938$ 18,515,707$ 70,608$ (638,182)$ 422 - Storm Utility Fund 10,990,767 12,086,425 11,671,671 490,217 680,904 423 - Sewer/WWTP Utility Fund 44,666,806 45,766,959 45,295,713 (173,747) 628,907 424 - Bond Reserve Fund 843,960 843,966 843,966 2 6 411 - Combined Utility Operation - 113,814 124,628 41,396 124,628 Total Enterprise Funds 75,655,422$ 77,443,101$ 76,451,685$ 428,475$ 796,263$ ENTERPRISE FUNDS FUND BALANCES CHANGE IN FUND ---- ACTUAL -------- ACTUAL ---- $124,628 $18,515,707 $11,671,671 $45,295,713 $843,966 $213,857 0 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 40,000,000 45,000,000 50,000,000 55,000,000 Combined Utility Water Storm Sewer/WWTP Bond Reserve Firemen's Pension Fund Enterprise and Agency Fund Balances as of October 31, 2018 *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 2.2.a Packet Pg. 52 Attachment: October 2018 Monthly Financial Report (October Financial Report) 38 SUMMARY OVERVIEW 12/31/2017 9/30/2018 10/31/2018 Q3 YTD Governmental Funds 27,079,678$ 28,632,743$ 27,009,071$ (1,751,010)$ (70,607)$ Enterprise Funds 75,655,422 77,443,101 76,451,685 428,475 796,263 Internal Services Fund 9,250,186 9,802,534 9,883,277 318,033 633,091 Agency Funds 226,480 219,144 213,857 (16,902) (12,623) Total City-wide Total 112,211,766$ 116,097,522$ 113,557,890$ (1,021,403)$ 1,346,124$ CITY-WIDE FUND BALANCES ---- ACTUAL ---- CHANGE IN FUND BALANCES ---- ACTUAL ---- $2,156,583 $3,812 $42,358 $17,273 $977,252 $159,406 $208,833 $306,501 $2,720,641 $2,382,468 $79,351 $14,076 $83,223 $124,777 $18,757 $562,464 $1,200,654 $1,014,392 $6,897 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 Parks Capital Construction Fund L.I.D. Fund Control Business Improvement District Sister City Commission Cemetery Maintenance Trust Fund Parks Trust Fund Cemetery Maintenance/Improvement Gifts Catalog Fund Real Estate Excise Tax 1, Parks Acq Real Estate Excise Tax 2 Tourism Promotional Fund/Arts Youth Scholarship Fund Employee Parking Permit Fund Hotel/Motel Tax Revenue Fund Memorial Street Fund Municipal Arts Acquis. Fund Combined Street Const/Improve Fund Street Fund Drug Enforcement Fund Governmental Fund Balances (Excluding General Fund) as of October 31, 2018 *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 2.2.a Packet Pg. 53 Attachment: October 2018 Monthly Financial Report (October Financial Report) 39 INTERNAL SERVICE FUNDS OVERVIEW 12/31/2017 9/30/2018 10/31/2018 Q3 YTD 511 - Equipment Rental Fund 8,996,077$ 9,408,259$ 9,455,064$ 198,436$ 458,987$ 512 - Technology Rental Fund 254,109 394,275 428,212 119,597 174,103 Total Internal Service Funds 9,250,186$ 9,802,534$ 9,883,277$ 318,033$ 633,091$ INTERNAL SERVICE FUNDS FUND BALANCES CHANGE IN FUND BALANCES ---- ACTUAL -------- ACTUAL ---- $8,996,077 $9,408,259 $9,455,064 $254,109 $394,275 $428,212 - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 Dec 2017 June 2018 Oct 2018 511 - Equipment Rental Fund 512 - Technology Rental Fund Internal Service Fund Balances *Please note that these revenues and expenses occur within annual cycles. This Interim Report is not adjusted for accruals or those annual cycles. 2.2.a Packet Pg. 54 Attachment: October 2018 Monthly Financial Report (October Financial Report) City Council Agenda Item Meeting Date: 12/11/2018 Fund Balance / Reserve Policy Planning Staff Lead: Scott James Department: Administrative Services Preparer: Scott James Background/History <Type or insert Info here> Staff Recommendation <Type or insert text here> Narrative Use time to talk about what information will be needed when the Council Finance Committee bring this item back to a future Finance Committee meeting for further discussion so we can prepare to bring it forward to Council as a study item in 1st Qtr. 2.3 Packet Pg. 55 City Council Agenda Item Meeting Date: 12/11/2018 2018 Non-Represented Employee Compensation Study Staff Lead: Mary Ann Hardie Department: Human Resources Preparer: MaryAnn Hardie Background/History By City policy (5.5, Non-Represented Employees), every three years the HR department performs a market study of the compensation for the Non-Represented employee group. The City’s non- represented compensation policy strives to maintain equity, by offering competitive salaries and benefits in order to attract and retain high quality staff and an effective work force. It is the policy of the City for the classification and compensation plan to provide salaries that compare favorably with other similar cities in the region for comparable jobs, and within budget limitations. It is also the policy of the City to strive to maintain salaries that are internally equitable, in proper relationship to all other jobs within the City, within reasonable budget parameters. Based on the study results, the Mayor makes a recommendation to Council of any wage adjustments that will take effect starting in 2019. Staff Recommendation Forward to Council for action (approval) of the Mayor's recommendations based on this year’s study. The recommendations are as follows: 1. Adjust the salary/wages of the identified positions that are out of alignment with the market median salary/wages per attachment "2019 Non-Represented Employees- Classification listing (with recommended adjustments)" 2. Provide a one-time, $500 per employee contribution to an health retirement account (HRA- VEBA) for each position to help defray the increased costs of the health insurance plan change that occurred on 1/1/18 and to provide organizational internal equity. 3. Add a two and one half percent (2.5%) base wage, employer contribution to a deferred compensation plan for the Police Chief position. 4. Approve additional language to the policy (5.5 Non-Represented Employees) as attached, including consideration of additional factors such as budget size, assessed valuation, etc. for a more precise labor market that helps maintain a competitive labor market per the attached "5.5 Non-Represented Employees policy - with redline recommended updates." Solely for planning purposes, pending Council approval of the Mayor’s recommendations, the costs have been (as in the past) earmarked for the 2019 budget. The total for the recommended adjustments is approximately $71,635. 3.1 Packet Pg. 56 Narrative The results of the 2018 Non-Represented compensation study reflect that many positions are aligned with the market median pay policy. Changes and fluctuations in the job market over the past 3 years have influenced pay practices. The identified labor market (comparator cities) and the exceptionally low unemployment rate have also contributed to the changes in the salaries and wages. Position Adjustments For those positions out of alignment (below) the market median, by policy, the Mayor is recommending adjustments for 9 positions to higher level pay ranges in order to maintain the market median and to help maintain an appropriately competitive and equitable level of pay. In consideration of compression and internal equity factors, not every position below the market median is recommended for an adjustment to the next higher salary/wage range. Additionally, the Mayor is not recommending any wage freezes to the four positions are that are currently above the market median. The following positions would be placed into one higher level pay (salary) range only. The net result would create, at a maximum, the ability for each position to receive an additional (approximately 5%) pay only in total before reaching the maximum of their new, adjusted salary range. The 9 positions to be adjusted are as follows: Current Adjustment Public Works Director 21 $121,594 - 162,946 22 $127,672 - $171,094 Comm. Svcs./ Econ Dev. Director 20 $115,803 - $155,187 21 $121,594 - $162,946 Development Svcs. Director 20 $115,803 - $155,187 21 $121,594 - $162,946 Finance Director 20 $115,803 - $155,187 21 $121,594 - $162,946 Human Resources Director 20 $115,803 - $155,187 21 $121,594 - $162,946 Parks & Recreation Director 20 $115,803 - $155,187 21 $121,594 - $162,946 Assistant Police Chief 19 $110,289 - $147,797 20 $115,803 - $155,187 Court Administrator 13 $82,298 - $110,289 14 $86,414 - $115,803 Additionally, the 3 below paraprofessional positions (which fall within the lowest salary/wage range for the Non-Represented pay scale) require adjustment to higher level pay ranges in order to align with the market median: Current Adjustment Public Disc. & Records Mgmt. Spec. 1 $45,828 - $61,413 3 $50,523 - $67,707 Safety & Risk Coordinator (part-time) 1 $22,914 - $30,707 8 $32,242 - $43,207 Human Resources Asst. (part-time) 23 $19.56 - $26.21 3 $24.29 - $32.55 The 2019 total cost for all of these position adjustments is approximately $45,709. Other elements of compensation As part of the compensation study, other elements of compensation (such as health insurance benefits, leave, deferred compensation, etc.) are also evaluated as they comprise part of total compensation (the cost and value of total compensation). Overall, there are several cities that provide some additional benefits (such as deferred compensation, additional discretionary leave, one additional holiday and/or additional vacation for longer tenured employees) for their exempt employee groups. Providing a (one- time only) HRA-VEBA contribution for this group will help provide external and internal equity. These 3.1 Packet Pg. 57 benefits, as a part of the total (other elements) of the compensation package, is an area that will need to continue be considered to maintain a competitive overall compensation package (at the median level of the comparator cities) for future studies. Specifically, for the Assistant Chief and Police Chief positions, as was determined with the 2012 and 2015 study (and as referenced in 5.5 Non-Represented Employees policy), the results reflect that the comparator cities for these positions receive additional “cash” compensation similar to the commissioned (union) police officers. The additional compensation items that these positions receive include educational and longevity incentives as well as deferred compensation contributions, etc. (see attached Appendix of Other Elements of Compensation). In order to attract, retain and maintain talent within these positions, it is recommended that the value of these other elements of compensation, continue to be considered to maintain a competitive overall compensation package (at the median level of the comparator cities) for future studies. Police Chief - deferred compensation plan (DCP) contribution With our police comparators, the City is below the median in the total cost of compensation. Given the external comparators, the Mayor is recommending a 2.5% employer base wage, deferred compensation contribution for this position. This would bring this position closer to the market median for the total cost of compensation and also prevent compression issues between the Police Chief and the Assistant Police Chief positions without requiring an adjustment to the position’s salary. The cost for the dcp contribution would be $3,926 for 2019. HRA-VEBA (Health Reimbursement Account/Voluntary Employee Benefits Association) program On 1/1/18, the City's health insurance consortium terminated the health insurance plan that the City employees were covered on. As part of this process, the City transitioned to the next best health insurance plan available through AWC, which resulted in increased costs for employees. In light of the health insurance change, it is recommended that a one-time, HRA-VEBA contribution in 2019 of $500 per employee be authorized. Furthermore, establishing such a benefit will allow this group the option to make a vote to allow a uniform amount of additional, employee only contributions to enhance the overall compensation package as well for the Non-Represented employees. The total cost is $22,000. Policy Updates There are also some housekeeping changes that are recommended with this process. Reviewing private sector data is challenging, primarily based on somewhat limited ability to obtain comparator data. Ideally, it would be considered for certain positions (such as engineering and IT), however, it may not be feasible to always consider private sector data given internal equity and wage compression constraints. It is recommended that the language reflect “may” look at private sector data instead of “will.” Labor Market Another area recommended for change is to the identified labor market, which is not a static one. This will be an area that will need to continue to be closely examined to ensure that the City's process is appropriately competitive and as fair and equitable as possible with the constant changes. The currently 3.1 Packet Pg. 58 identified labor market includes consideration of using the closest 8 comparator cities from King, Snohomish, Pierce and Thurston counties that have a population size of up to 10,000 in population size above and below Edmonds. The City of Edmonds' current population at the time of this survey was 41,960. The comparator cities used for the study include: City Population 1. Bothell 44,370 2. Burien 50,680 3. Issaquah 36,030 4. Lacey 48,700 5. Lake Stevens 31,740 6. Lynnwood 36,950 7. Puyallup 40,500 8. University Place 32,610 Four other cities (the next comparators by policy) were also used for some positions as needed when there was insufficient survey comparator data for salary/wage information and benefits. These cities include: City Population 1. Des Moines 30,860 2. Olympia 52,160 3. Shoreline 55,060 4. Lakewood 59,280 While population size is certainly a factor of the labor market, there are other factors that are recommended to be considered (that other cities are also using) as part of the overall labor market so as to keep the process as equitable as possible. Due to continual changes in population, this year's study included two comparator cities that have a different budget size, organizational size and wages in comparison to Edmonds (Lake Stevens and University Place). Such factors would include, for example, using assessed valuation, overall budget size, and revenues, etc., as part of the labor market factors (which are similar labor market factors used by the comparator cities). This would allow for a competitive policy within the budget. It would also help ensure that by using more than one labor market factor (in addition to population), the City would not have outlier comparators (resulting in either inadvertently disproportionately low or high salary/wage paying cities) or using cities that Edmonds may not necessarily compete with in the labor market. COLA A 3% COLA for the Non-Represented employees has been included in the 2019 budget. ATTACHMENTS/DATA Attached is the following data from the study: 1. 2018 Non-Represented Compensation Study - All positions 2. 2018 Non-Represented Positions by Title - Benchmark positions 3. 2018 Non-Represented Compensation Study (% of difference from the salary/wage range maximum) 3.1 Packet Pg. 59 4. Appendix - Other Elements of Compensation Survey - 2018 5. 2018 Non-Represented Employees - Classification listing (current schedule) 6. 2019 Non-Represented Employees- Classification listing (with recommended adjustments) 7. Non-Represented Employee COLA history (2005-2019) 8. 5.5 Non-Represented Employees policy - with redline recommended updates Attachments: 2018 NR Compensation Study - All Positions 2018 NR Positions by Title- Benchmark positions 2018 NR Compensation Study - Percentage of difference from the salary or wage range maximum Appendix - Other Elements of Compensation Survey - 2018 2018 Non-Represented positions- Classification listing 2019 Non-Represented Employees - Classification Listing - with recommended adjustments COLA History - NR (2005-2019) 5.5 Non-Represented Compensation Policy- with redline recommended updates 3.1 Packet Pg. 60 CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX ARTS & CULTURAL PROGRAMS MANAGER $78,381 $91,709 $105,037 $105,037 $13,340 $24,962 $116,683 $130,011 $143,339 $1,212 $117,895 $131,223 $144,551 NO MATCH Bothell, City of ------------- Recreation Manager Burien, City of $84,576 $93,690 $102,804 -$13,056 $25,864 $123,497 $132,611 $141,725 $395 $123,892 $133,006 $142,120 NO MATCH Issaquah, City of ------------ NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- Recreation Supt.Lynnwood, City of $85,068 $97,302 $109,536 -$13,911 $23,667 $122,646 $134,880 $147,114 $4,634 $127,280 $139,514 $151,748 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$84,822 $95,496 $106,170 Median:$125,586 $136,260 $146,934 Current Edmonds Base Range:$78,381 $91,709 $105,037 Current Edmonds Base Range:$117,895 $131,223 $144,551 Proposed Base Range:$78,381 $91,709 $105,037 Range 12 TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization 3.1.a Packet Pg. 61 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization ASSISTANT FINANCE DIRECTOR $95,270 $111,471 $127,672 $121,594 $16,214 $24,962 $136,447 $152,648 $168,849 $1,473 $137,920 $154,121 $170,322 Deputy Finance Director Bothell, City of $98,988 $112,422 $125,856 -$15,984 $25,826 $140,797 $154,231 $167,665 $11,617 $152,415 $165,849 $179,283 NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of ------------- NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- Asst. Finance Director Lynnwood, City of $113,232 $129,504 $145,776 -$18,514 $23,667 $155,413 $171,685 $187,957 $6,167 $161,580 $177,852 $194,124 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$106,110 $120,963 $135,816 Median:$156,997 $171,850 $186,703 Current Edmonds Base Range:$95,270 $111,471 $127,672 Current Edmonds Base Range:$137,920 $154,121 $170,322 Proposed Base Range:$95,270 $111,471 $127,672 Range 16 3.1.a Packet Pg. 62 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization ASSISTANT POLICE CHIEF $110,289 $129,043 $147,797 $147,797 $8,025 $24,962 $143,277 $162,031 $180,785 $6,300 $149,577 $168,331 $187,085 Deputy Police Chief Bothell, City of $126,708 $143,904 $161,100 -$8,748 $25,826 $161,281 $178,477 $195,673 $14,871 $176,152 $193,348 $210,544 NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of ------------ NO MATCH Lacey, City of ------------ Assistant Police Chief Lake Stevens, City of $92,760 $105,066 $117,372 -$6,373 $26,111 $125,244 $137,550 $149,856 $3,322 $128,566 $140,872 $153,178 Deputy Chief Lynnwood, City of $125,880 $143,970 $162,060 -$8,800 $23,667 $158,347 $176,437 $194,527 $23,433 $181,780 $199,870 $217,960 Deputy Chief Puyallup, City of $117,312 $133,746 $150,180 -$8,155 $29,856 $155,323 $171,757 $188,191 $6,007 $161,330 $177,764 $194,198 NO MATCH University Place, City of ------------- Median:$121,596 $138,825 $155,640 Median:$168,741 $185,556 $202,371 Current Edmonds Base Range:$110,289 $129,043 $147,797 Current Edmonds Base Range:$149,577 $168,331 $187,085 Proposed Base Range:$115,803 $135,495 $155,187 Range 20 3.1.a Packet Pg. 63 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization ASSOCIATE ENGINEER $67,707 $79,221 $90,734 $71,092 $11,523 $24,962 $104,192 $115,706 $127,219 $0 $104,192 $115,706 $127,219 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- Associate Engineer Issaquah, City of $82,104 $97,128 $112,152 -$14,243 $18,780 $115,127 $130,151 $145,175 $4,524 $119,651 $134,675 $149,699 NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- Civil Engineer 1 Lynnwood, City of $57,708 $65,352 $72,996 -$9,270 $23,667 $90,646 $98,290 $105,934 $1,223 $91,868 $99,512 $107,156 Associate Engineer (SW)Puyallup, City of $68,148 $77,688 $87,228 -$11,078 $24,962 $104,188 $113,728 $123,268 $1,006 $105,195 $114,735 $124,275 NO MATCH University Place, City of ------------- Median:$68,148 $77,688 $87,228 Median:$105,195 $114,735 $124,275 Current Edmonds Base Range:$67,707 $79,221 $90,734 Current Edmonds Base Range:$104,192 $115,706 $127,219 Proposed Base Range:$67,707 $79,221 $90,734 Range 9 3.1.a Packet Pg. 64 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization ASSOCIATE PLANNER $67,707 $79,221 $90,734 $90,734 $11,523 $24,962 $104,192 $115,706 $127,219 $0 $104,192 $115,706 $127,219 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- Associate Planner Issaquah, City of $74,520 $88,116 $101,712 -$12,917 $24,962 $112,400 $125,996 $139,592 $4,275 $116,675 $130,271 $143,867 NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$74,520 $88,116 $101,712 Median:$116,675 $130,271 $143,867 Current Edmonds Base Range:$67,707 $79,221 $90,734 Current Edmonds Base Range:$104,192 $115,706 $127,219 Proposed Base Range:$67,707 $79,221 $90,734 Range 9 3.1.a Packet Pg. 65 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization BUILDING OFFICIAL $90,734 $106,164 $121,594 $121,594 $15,442 $24,962 $131,139 $146,569 $161,999 $1,403 $132,542 $147,972 $163,402 Building Official Bothell, City of $106,596 $121,062 $135,528 -$17,212 $25,826 $149,634 $164,100 $178,566 $12,510 $162,144 $176,610 $191,076 NO MATCH Burien, City of ------------- Building Official Issaquah, City of $104,856 $124,020 $143,184 -$18,184 $18,780 $141,820 $160,984 $180,148 $5,264 $147,084 $166,248 $185,412 NO MATCH Lacey, City of ------------- Building Official Lake Stevens, City of $81,984 $92,856 $103,728 -$13,173 $26,111 $121,268 $132,140 $143,012 $1,596 $122,864 $133,736 $144,608 Building Official Lynnwood, City of $102,936 $117,726 $132,516 -$16,830 $23,667 $143,433 $158,223 $173,013 $1,452 $144,884 $159,674 $174,464 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$103,896 $119,394 $134,022 Median:$145,984 $162,961 $179,938 Current Edmonds Base Range:$90,734 $106,164 $121,594 Current Edmonds Base Range:$132,542 $147,972 $163,402 Proposed Base Range:$90,734 $106,164 $121,594 Range 15 3.1.a Packet Pg. 66 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization CAPITAL PROJECTS MANAGER $74,648 $87,342 $100,035 $100,035 $12,704 $24,962 $112,315 $125,008 $137,702 $0 $112,315 $125,008 $137,702 Capital Projects Engineer Bothell, City of $74,352 $84,438 $94,524 -$12,005 $25,826 $112,182 $122,268 $132,354 $5,090 $117,272 $127,358 $137,444 Civil Engineer 2 Burien, City of $84,576 $93,690 $102,804 -$13,056 $25,864 $123,497 $132,611 $141,725 $395 $123,892 $133,006 $142,120 NO MATCH Issaquah, City of ------------- Project Administrator Lacey, City of $77,568 $84,882 $92,196 -$11,709 $26,146 $115,423 $122,737 $130,051 $355 $115,777 $123,091 $130,405 NO MATCH Lake Stevens, City of ------------- Project Manager Lynnwood, City of $78,504 $88,926 $99,348 -$12,617 $23,667 $114,788 $125,210 $135,632 $1,324 $116,112 $126,534 $136,956 Civil Engineer Puyallup, City of $11,310 $50,826 $90,342 -$11,473 $29,856 $52,639 $92,155 $131,671 $1,042 $53,682 $93,198 $132,714 NO MATCH University Place, City of ------------ Median:$78,504 $88,926 $99,348 Median:$116,112 $126,534 $136,956 Current Edmonds Base Range:$74,648 $87,342 $100,035 Current Edmonds Base Range:$112,315 $125,008 $137,702 Proposed Base Range:$74,648 $87,342 $100,035 11 3.1.a Packet Pg. 67 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization CITY CLERK $86,414 $101,109 $115,803 $115,803 $14,707 $24,962 $126,083 $140,778 $155,472 $1,336 $127,419 $142,114 $156,808 City Clerk Bothell, City of $83,268 $94,572 $105,876 -$13,446 $25,826 $122,540 $133,844 $145,148 $9,773 $132,313 $143,617 $154,921 City Clerk Burien, City of $76,620 $84,876 $93,132 -$11,828 $25,864 $114,312 $122,568 $130,824 $358 $114,670 $122,926 $131,182 City Clerk Issaquah, City of $86,232 $102,012 $117,792 -$14,960 $18,780 $119,971 $135,751 $151,531 $9,682 $129,653 $145,433 $161,213 City Clerk Lacey, City of $72,723 $82,907 $93,092 -$11,823 $26,146 $110,692 $120,876 $131,060 $358 $111,050 $121,234 $131,418 City Clerk Lake Stevens, City of $74,256 $84,108 $93,960 -$11,933 $26,111 $112,300 $122,152 $132,004 $1,446 $113,745 $123,597 $133,449 NO MATCH Lynnwood, City of ------------- City Clerk Puyallup, City of $79,032 $90,096 $101,160 -$12,847 $29,856 $121,735 $132,799 $143,863 $389 $122,124 $133,188 $144,252 City Clerk University Place, City of $77,052 $87,564 $98,076 -$12,456 $24,962 $114,470 $124,982 $135,494 $0 $114,470 $124,982 $135,494 Median:$77,052 $87,564 $98,076 Median:$114,670 $124,982 $135,494 Current Edmonds Base Range:$86,414 $101,109 $115,803 Current Edmonds Base Range:$127,419 $142,114 $156,808 Proposed Base Range:$86,414 $101,109 $115,803 Range 14 3.1.a Packet Pg. 68 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization CITY ENGINEER $110,289 $129,043 $147,797 $147,797 $18,770 $24,962 $154,021 $172,775 $191,529 $1,705 $155,727 $174,481 $193,235 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of ------------- City Engineer Lacey, City of $107,112 $122,112 $137,112 -$17,413 $26,146 $122,441 $137,441 $152,441 $527 $122,968 $137,968 $152,968 NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- City Engineer Puyallup, City of $111,672 $127,302 $142,932 -$18,152 $29,856 $127,652 $143,282 $158,912 $1,649 $129,301 $144,931 $160,561 Dir of Eng & Cap Proj University Place, City of $109,080 $126,306 $143,532 -$18,229 $24,962 $125,174 $142,610 $160,046 $2,760 $127,934 $145,370 $162,806 Median:$109,080 $126,306 $142,932 Median:$127,934 $144,931 $160,561 Current Edmonds Base Range:$110,289 $129,043 $147,797 Current Edmonds Base Range:$155,727 $174,481 $193,235 Proposed Base Range:$110,289 $129,043 $147,797 Range 19 3.1.a Packet Pg. 69 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization COMMUNITY SERVICES/ECONOMIC DEVELOPMENT DIRECTOR $115,083 $135,135 $155,187 $155,188 $19,709 $24,962 $159,754 $179,806 $199,858 $1,791 $161,545 $181,597 $201,649 Comm & Econ Dev. Director Bothell, City of $129,876 $147,504 $165,132 -$20,972 $25,826 $176,673 $194,301 $211,929 $15,243 $191,916 $209,544 $227,172 20%(+)Economic Dev. Mgr Burien, City of $129,888 $143,885 $157,882 -$20,051 $25,864 $175,803 $189,800 $203,797 $607 $176,411 $190,407 $204,404 Economic Dev. Director Issaquah, City of $127,440 $150,720 $174,000 -$22,098 $18,780 $168,318 $191,598 $214,878 $12,989 $181,307 $204,587 $227,867 NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of -------- Economic Dev. Director Lynnwood, City of $125,688 $143,748 $161,808 -$20,550 $23,667 $169,905 $187,965 $206,025 $7,788 $177,692 $195,752 $213,812 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------ Median:$128,658 $145,694 $163,470 Median:$179,500 $200,170 $220,492 Current Edmonds Base Range:$115,083 $135,135 $155,187 Current Edmonds Base Range:$161,545 $181,597 $201,649 Proposed Base Range:$121,594 $142,270 $162,946 Range 21 3.1.a Packet Pg. 70 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization COURT ADMINISTRATOR $82,298 $96,294 $110,289 $86,414 $14,007 $24,962 $121,267 $135,262 $149,258 $1,273 $122,539 $136,535 $150,530 Court Administrator Bothell, City of $91,920 $104,394 $116,868 -$14,842 $25,826 $132,588 $145,062 $157,536 $10,788 $143,376 $155,850 $168,324 NO MATCH Burien, City of ------------- Court Administrator Issaquah, City of $104,856 $124,020 $143,184 -$18,184 $18,780 $141,820 $160,984 $180,148 $5,264 $147,084 $166,248 $185,412 NO MATCH Lacey, City of --------- NO MATCH Lake Stevens, City of ------------- Court Administrator Lynnwood, City of $113,220 $129,498 $145,776 -$18,514 $23,667 $155,401 $171,679 $187,957 $7,109 $162,510 $178,788 $195,066 Court Administrator Puyallup, City of $79,032 $90,096 $101,160 -$12,847 $29,856 $121,735 $132,799 $143,863 $389 $122,124 $133,188 $144,252 NO MATCH University Place, City of ------------ Median:$98,388 $114,207 $130,026 Median:$145,230 $161,049 $176,868 Current Edmonds Base Range:$82,298 $96,294 $110,289 Current Edmonds Base Range:$122,539 $136,535 $150,530 Proposed Base Range:$86,414 $101,109 $115,803 Range $14 3.1.a Packet Pg. 71 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization DEPUTY PARKS, RECREATION & CULTURAL SVCS. DIRECTOR $100,035 $117,046 $134,057 $105,037 $17,025 $24,962 $142,022 $159,033 $176,044 $1,547 $143,569 $160,580 $177,591 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- Deputy Director- P& R Issaquah, City of $104,856 $124,020 $143,184 -$18,184 $18,780 $141,820 $160,984 $180,148 $5,264 $147,084 $166,248 $185,412 NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- Deputy P&R & CA Director Lynnwood, City of $102,936 $117,726 $132,516 -$16,830 $23,667 $143,433 $158,223 $173,013 $6,548 $149,981 $164,771 $179,561 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$103,896 $120,873 $137,850 Median:$148,533 $165,510 $182,487 Current Edmonds Base Range:$100,035 $117,046 $134,057 Current Edmonds Base Range:$143,569 $160,580 $177,591 Proposed Base Range:$100,035 $117,046 $134,057 Range 17 3.1.a Packet Pg. 72 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization DEVELOPMENT SERVICES DIRECTOR $115,083 $135,135 $155,187 $155,188 $19,709 $24,962 $159,754 $179,806 $199,858 $1,791 $161,545 $181,597 $201,649 NO MATCH Bothell, City of ------------- Comm Dev. Director Burien, City of $131,892 $146,106 $160,320 -$20,361 $25,864 $178,117 $192,331 $206,545 $617 $178,734 $192,948 $207,162 Development Svcs. Director Issaquah, City of $140,472 $166,140 $191,808 -$24,360 $18,780 $183,611 $209,279 $234,947 $14,037 $197,648 $223,316 $248,984 Community Dev. Director Lacey, City of $116,121 $132,383 $148,645 -$18,878 $26,146 $161,145 $177,407 $193,669 $572 $161,717 $177,979 $194,241 NO MATCH Lake Stevens, City of ------------- Comm. Dev. Director Lynnwood, City of $125,700 $143,754 $161,808 -$20,550 $23,667 $169,917 $187,971 $206,025 $7,788 $177,704 $195,758 $213,812 Development Svcs. Director Puyallup, City of $111,672 $127,302 $142,932 -$18,152 $29,856 $159,680 $175,310 $190,940 $1,649 $161,330 $176,960 $192,590 NO MATCH University Place, City of ---------- Median:$125,700 $143,754 $160,320 Median:$177,704 $192,948 $207,162 Current Edmonds Base Range:$115,083 $135,135 $155,187 Current Edmonds Base Range:$161,545 $181,597 $201,649 Proposed Base Range:$121,594 $142,270 $162,946 Range 21 3.1.a Packet Pg. 73 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization ENGINEERING PROGRAM MANAGER 2 $78,381 $91,709 $105,037 $105,037 $13,340 $24,962 $116,683 $130,011 $143,339 $1,212 $117,895 $131,223 $144,551 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of ------------- Design & Const. Mgr.Lacey, City of $82,788 $94,350 $105,912 -$13,451 $26,146 $122,385 $133,947 $145,509 $407 $122,792 $134,354 $145,916 NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$82,788 $94,350 $105,912 Median:$122,792 $134,354 $145,916 Current Edmonds Base Range:$78,381 $91,709 $105,037 Current Edmonds Base Range:$117,895 $131,223 $144,551 Proposed Base Range:$78,381 $91,709 $105,037 Range 12 3.1.a Packet Pg. 74 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization ENVIRONMENTAL PROGRAM MANAGER $86,414 $101,109 $115,803 $105,037 $14,707 $24,962 $126,083 $140,778 $155,472 $1,336 $127,419 $142,114 $156,808 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of ------------- NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:---Median:--- Current Edmonds Base Range:$86,414 $101,109 $115,803 Current Edmonds Base Range:$127,419 $142,114 $156,808 Proposed Base Range:$86,414 $101,109 $115,803 Range 14 3.1.a Packet Pg. 75 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization EXECUTIVE ASSISTANT-CONFIDENTIAL (PD)$61,413 $71,856 $82,298 $82,299 $10,452 $24,962 $96,827 $107,270 $117,712 $0 $96,827 $107,270 $117,712 Executive Assistant Bothell, City of $68,352 $77,622 $86,892 -$11,035 $25,826 $105,213 $114,483 $123,753 $6,433 $111,646 $120,916 $130,186 Executive Assistant Burien, City of $64,452 $71,406 $78,360 -$9,952 $25,864 $100,268 $107,222 $114,176 $617 $100,885 $107,839 $114,793 Executive Assistant, Police Issaquah, City of $74,520 $88,116 $101,712 -$12,917 $18,780 $106,217 $119,813 $133,409 $4,275 $110,493 $124,089 $137,685 Executive Assistant Lacey, City of $60,762 $69,271 $77,780 -$9,878 $26,146 $96,786 $105,295 $113,804 $299 $97,085 $105,594 $114,103 NO MATCH Lake Stevens, City of ------------- Executive Assistant Lynnwood, City of $63,936 $73,122 $82,308 -$10,453 $23,667 $98,056 $107,242 $116,428 $317 $98,373 $107,559 $116,745 Executive Assistant Puyallup, City of $61,740 $70,386 $79,032 -$10,037 $29,856 $101,633 $110,279 $118,925 $304 $101,937 $110,583 $119,229 Executive Assistant University Place, City of $74,544 $86,310 $98,076 -$12,456 $24,962 $111,962 $123,728 $135,494 $0 $111,962 $123,728 $135,494 Median:$64,452 $73,122 $82,308 Median:$101,937 $110,583 $119,229 Current Edmonds Base Range:$61,413 $71,856 $82,298 Current Edmonds Base Range:$96,827 $107,270 $117,712 Proposed Base Range:$61,413 $71,855.50 $82,298 Range 7 3.1.a Packet Pg. 76 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization EXECUTIVE ASSISTANT TO THE MAYOR $64,484 $75,449 $86,414 $82,299 $10,975 $24,962 $100,421 $111,386 $122,351 $0 $100,421 $111,386 $122,351 Executive Assistant Bothell, City of $68,352 $77,622 $86,892 -$11,035 $25,826 $105,213 $114,483 $123,753 $6,433 $111,646 $120,916 $130,186 Executive Assistant Burien, City of $64,452 $71,406 $78,360 -$9,952 $25,864 $100,268 $107,222 $114,176 $617 $100,885 $107,839 $114,793 Executive Assistant Issaquah, City of $74,520 $88,116 $101,712 -$12,917 $18,780 $106,217 $119,813 $133,409 $0 $106,217 $119,813 $133,409 Executive Assistant Lacey, City of $60,762 $69,271 $77,780 -$9,878 $26,146 $96,786 $105,295 $113,804 $299 $97,085 $105,594 $114,103 NO MATCH Lake Stevens, City of ------------- Executive Assistant Lynnwood, City of $63,936 $73,122 $82,308 -$10,453 $23,667 $98,056 $107,242 $116,428 $317 $98,373 $107,559 $116,745 Executive Assistant Puyallup, City of $61,740 $70,386 $79,032 -$10,037 $29,856 $101,633 $110,279 $118,925 $304 $101,937 $110,583 $119,229 Executive Assistant University Place, City of $74,544 $86,310 $98,076 -$12,456 $24,962 $111,962 $123,728 $135,494 $2,642 $114,604 $126,370 $138,136 Median:$64,452 $73,122 $82,308 Median:$101,937 $110,583 $119,229 Current Edmonds Base Range:$64,484 $75,449 $86,414 Current Edmonds Base Range:$100,421 $111,386 $122,351 Proposed Base Range:$61,413 $71,856 $82,298 Range 7 3.1.a Packet Pg. 77 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization FACILTIES MANAGER $86,414 $101,109 $115,803 $110,289 $14,707 $24,962 $126,083 $140,778 $155,472 $1,336 $127,419 $142,114 $156,808 NO MATCH Bothell, City of ------------ NO MATCH Burien, City of ------------ NO MATCH Issaquah, City of ------------ NO MATCH Lacey, City of ------------ NO MATCH Lake Stevens, City of ------------ NO MATCH Lynnwood, City of ------------ NO MATCH Puyallup, City of ------------ NO MATCH University Place, City of ------------ Median:Median: Current Edmonds Base Range:$86,414 $101,109 $115,803 Current Edmonds Base Range:$127,419 $142,114 $156,808 Proposed Base Range:$86,414 $101,109 $115,803 Range 14 . 3.1.a Packet Pg. 78 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization FINANCE DIRECTOR $115,083 $135,135 $155,187 $155,188 $19,709 $24,962 $159,754 $179,806 $199,858 $1,791 $161,545 $181,597 $201,649 Finance Director Bothell, City of $129,876 $147,504 $165,132 -$20,972 $25,826 $176,673 $194,301 $211,929 $15,243 $191,916 $209,544 $227,172 Finance Director Burien, City of $131,892 $146,106 $160,320 -$20,361 $25,864 $178,117 $192,331 $206,545 $617 $178,734 $192,948 $207,162 Finance Director Issaquah, City of $140,472 $166,140 $191,808 -$24,360 $18,780 $183,611 $209,279 $234,947 $14,037 $197,648 $223,316 $248,984 Finance Director Lacey, City of $117,559 $134,022 $150,485 -$19,112 $26,146 $162,816 $179,279 $195,743 $579 $163,395 $179,858 $196,321 NO MATCH Lake Stevens, City of ------------- Finance Director Lynnwood, City of $139,500 $159,546 $179,592 -$22,808 $23,667 $185,975 $206,021 $226,067 $8,540 $194,515 $214,561 $234,607 Finance Director Puyallup, City of $117,312 $133,746 $150,180 -$19,073 $29,856 $166,241 $182,675 $199,109 $1,733 $167,974 $184,408 $200,842 Finance Director University Place, City of $109,080 $126,306 $143,532 -$18,229 $24,962 $152,271 $169,497 $186,723 $2,760 $155,031 $172,257 $189,483 Median:$129,876 $146,106 $160,320 Median:$178,734 $192,948 $207,162 Current Edmonds Base Range:$115,083 $135,135 $155,187 Current Edmonds Base Range:$161,545 $181,597 $201,649 Proposed Base Range:$121,594 $142,270 $162,946 Range 21 3.1.a Packet Pg. 79 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization FLEET MANAGER $78,381 $91,709 $105,037 $105,037 $13,340 $24,962 $116,683 $130,011 $143,339 $1,212 $117,895 $131,223 $144,551 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- Fleet Manager Issaquah, City of $89,472 $106,572 $123,672 -$15,706 $18,780 $123,958 $141,058 $158,158 $4,799 $128,757 $145,857 $162,957 Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- 10%(+)Fleet Supervisor Lynnwood, City of $85,061 $97,284 $109,507 -$13,907 $23,667 $122,635 $134,859 $147,082 $5,575 $128,210 $140,434 $152,657 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$87,266 $101,928 $116,590 Median:$128,484 $143,145 $157,807 Current Edmonds Base Range:$78,381 $91,709 $105,037 Current Edmonds Base Range:$117,895 $131,223 $144,551 Proposed Base Range:$78,381 $91,709 $105,037 Range 12 3.1.a Packet Pg. 80 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization HUMAN RESOURCES ANALYST (.875 FTE)$56,424 $66,018 $75,612 $59,244 $9,603 $19,658 $85,684 $95,278 $104,873 $0 $85,684 $95,278 $104,873 Human Resources Analyst Bothell, City of $61,299 $69,615 $77,931 -$9,897 $25,826 $97,022 $105,338 $113,654 $4,196 $101,218 $109,534 $117,850 NO MATCH Burien, City of ------------- Human Resources Analyst Issaquah, City of $65,205 $77,102 $88,998 -$11,303 $18,780 $95,287 $107,184 $119,080 $3,972 $99,260 $111,156 $123,053 Human Resources Analyst Lacey, City of $61,134 $69,696 $78,257 -$9,939 $26,146 $97,219 $105,780 $114,342 $301 $97,520 $106,081 $114,643 NO MATCH Lake Stevens, City of ------------- Human Resources Analyst Lynnwood, City of $55,944 $63,982 $72,020 -$9,146 $23,667 $88,758 $96,795 $104,833 $1,219 $89,977 $98,014 $106,052 Human Resources GeneralistPuyallup, City of $54,023 $61,588 $69,153 -$8,782 $29,856 $92,661 $100,226 $107,791 $0 $92,661 $100,226 $107,791 NO MATCH University Place, City of ------------- Median:$61,134 $69,615 $77,931 Median:$97,520 $106,081 $114,643 Current Edmonds Base Range:$56,424 $66,018 $75,612 Current Edmonds Base Range:$85,684 $95,278 $104,873 Proposed Base Range:$56,424 $66,018 $75,612 Range 8 3.1.a Packet Pg. 81 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization HUMAN RESOURCES ASSISTANT (.625) Hourly $19.56 $22.89 $26.21 $22.64 $3.33 $22.89 $26.21 $29.54 $0 $23 $26 $30 Admin Assistant (HR Dept) Bothell, City of $26.31 $29.88 $33.45 -$4.25 $30.56 $34.13 $37.70 $30.56 $34.13 $37.70 Department Assistant Burien, City of $25.43 $28.17 $30.92 -$3.93 $29.36 $32.10 $34.84 $29.36 $32.10 $34.84 NO MATCH Issaquah, City of ------------- NO MATCH Lacey, City of $25.49 $29.06 $32.63 -$4.14 $29.63 $33.20 $36.77 $29.63 $33.20 $36.77 NO MATCH Lake Stevens, City of ------------- HR Administrative Assistant Lynnwood, City of $25.39 $29.04 $32.69 -$4.15 $29.54 $33.19 $36.84 ---- Administrative Assistant Puyallup, City of $25.60 $29.18 $32.76 -$4.16 $29.76 $33.34 $36.92 ---- NO MATCH University Place, City of ------------- Median:$25.49 $29.06 $32.69 Median:$29.63 $33.20 $36.77 Current Edmonds Base Range:$19.56 $22.89 $26.21 Current Edmonds Base Range:$22.89 $26.21 $29.54 Proposed Base Range:$24.29 $28.42 $32.55 Range 3 3.1.a Packet Pg. 82 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization HUMAN RESOURCES DIRECTOR $115,083 $135,135 $155,187 $140,759 $19,709 $24,962 $159,754 $179,806 $199,858 $1,791 $161,545 $181,597 $201,649 Human Resources Director Bothell, City of $129,876 $147,504 $165,132 -$20,972 $25,826 $176,673 $194,301 $211,929 $15,243 $191,916 $209,544 $227,172 NO MATCH Burien, City of ------------- Director- Human Resources Issaquah, City of $127,440 $150,720 $174,000 -$22,098 $18,780 $168,318 $191,598 $214,878 $12,989 $181,307 $204,587 $227,867 NO MATCH Lacey, City of ------------- Human Resources Director Lake Stevens, City of $102,384 $115,962 $129,540 -$16,452 $26,111 $144,946 $158,524 $172,102 $5,481 $150,427 $164,005 $177,583 Human Resources Director Lynnwood, City of $125,688 $143,748 $161,808 -$20,550 $23,667 $169,905 $187,965 $206,025 $7,788 $177,692 $195,752 $213,812 Director of Personnel Puyallup, City of $106,284 $121,170 $136,056 -$17,279 $29,856 $153,419 $168,305 $183,191 $1,570 $154,989 $169,875 $184,761 NO MATCH University Place, City of ------------- Median:$125,688 $143,748 $161,808 Median:$177,692 $195,752 $213,812 Current Edmonds Base Range:$115,083 $135,135 $155,187 Current Edmonds Base Range:$161,545 $181,597 $201,649 Proposed Base Range:$121,594 $142,270 $162,946 Range 21 3.1.a Packet Pg. 83 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization IS MANAGER $90,734 $106,164 $121,594 $121,594 $15,442 $24,962 $131,139 $146,569 $161,999 $1,403 $132,542 $147,972 $163,402 NO MATCH Bothell, City of ------------- IS Manager Burien, City of $98,064 $108,630 $119,196 -$15,138 $25,864 $139,066 $149,632 $160,198 $458 $139,525 $150,091 $160,657 IT Manager Issaquah, City of $99,840 $118,092 $136,344 -$17,316 $25,864 $143,020 $161,272 $179,524 $5,101 $148,121 $166,373 $184,625 NO MATCH Lacey, City of ------------ IS Manager Lake Stevens, City of $84,036 $95,184 $106,332 -$13,504 $26,146 $123,686 $134,834 $145,982 $2,454 $126,140 $137,288 $148,436 IS Manager Lynnwood, City of $102,936 $117,726 $132,516 -$16,830 $23,667 $143,433 $158,223 $173,013 $1,452 $144,884 $159,674 $174,464 IT Manager Puyallup, City of $89,424 $101,940 $114,456 -$14,536 $23,667 $127,627 $140,143 $152,659 $1,321 $128,948 $141,464 $153,980 Communications/IT Manager University Place, City of $86,520 $100,188 $113,856 -$14,460 $24,962 $125,942 $139,610 $153,278 $2,190 $128,131 $141,799 $155,467 Median:$93,744 $105,285 $116,826 Median:$134,236 $145,945 $158,062 Current Edmonds Base Range:$90,734 $106,164 $121,594 Current Edmonds Base Range:$132,542 $147,972 $163,402 Proposed Base Range:$90,734 $106,164 $121,594 Range 15 3.1.a Packet Pg. 84 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization PARKS MAINTENANCE MANAGER $78,381 $91,709 $105,037 $105,037 $13,340 $24,962 $116,683 $130,011 $143,339 $1,212 $117,895 $131,223 $144,551 Parks Operations Manager Bothell, City of $83,268 $94,572 $105,876 -$13,446 $25,826 $122,540 $133,844 $145,148 $9,773 $132,313 $143,617 $154,921 Recreation Manager Burien, City of $84,576 $93,690 $102,804 -$13,056 $25,864 $123,497 $132,611 $141,725 $395 $123,892 $133,006 $142,120 Parks Division Manager Issaquah, City of $95,064 $112,452 $129,840 $16,490 $18,780 $130,333 $147,721 $165,109 $4,946 $135,280 $152,668 $170,056 NO MATCH Lacey, City of ------------ NO MATCH Lake Stevens, City of ------------ Recreation Supt. - Parks & O&MLynnwood, City of $85,068 $97,302 $109,536 -$11,743 $23,667 $120,478 $132,712 $144,946 $1,316 $121,794 $134,028 $146,262 NO MATCH Puyallup, City of ------------ NO MATCH University Place, City of ---- ------- Median:$84,822 $95,937 $107,706 Median:$128,102 $138,823 $150,592 Current Edmonds Base Range:$78,381 $91,709 $105,037 Current Edmonds Base Range:$117,895 $131,223 $144,551 Proposed Base Range:$78,381 $91,709 $105,037 Range 12 3.1.a Packet Pg. 85 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization PLANNER $61,413 $71,856 $82,298 $74,648 $10,452 $24,962 $96,827 $107,270 $117,712 $0 $96,827 $107,270 $117,712 Planner Bothell, City of $67,356 $76,500 $85,644 -$10,877 $25,826 $104,058 $113,202 $122,346 $3,623 $107,682 $116,826 $125,970 Planner Burien, City of $67,716 $75,018 $82,320 -$10,455 $25,864 $104,035 $111,337 $118,639 $317 $104,352 $111,654 $118,956 Assistant Planner Issaquah, City of $67,608 $79,944 $92,280 -$11,720 $24,962 $104,290 $116,626 $128,962 $4,051 $108,340 $120,676 $133,012 NO MATCH Lacey, City of ------------- Planner Lake Stevens, City of $64,536 $73,104 $81,672 -$10,372 $26,111 $101,019 $109,587 $118,155 $314 $101,333 $109,901 $118,469 Planner Lynnwood, City of $62,316 $70,566 $78,816 -$10,010 $23,667 $95,993 $104,243 $112,493 $1,213 $97,206 $105,456 $113,706 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$67,356 $75,018 $82,320 Median:$104,352 $111,654 $118,956 Current Edmonds Base Range:$61,413 $71,856 $82,298 Current Edmonds Base Range:$96,827 $107,270 $117,712 Proposed Base Range:$61,413 $71,856 $82,298 Range 7 3.1.a Packet Pg. 86 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization PARKS, RECREATION & CULTURAL SERVICES DIRECTOR $115,803 $135,495 $155,187 $155,187 $19,709 $24,962 $160,474 $180,166 $199,858 $1,791 $162,265 $181,957 $201,649 Parks & Recreation Director Bothell, City of $129,876 $147,504 $165,132 -$20,972 $25,826 $176,673 $194,301 $211,929 $15,243 $191,916 $209,544 $227,172 Parks, Rec & Cultural Svcs DirectorBurien, City of $131,892 $146,106 $160,320 -$20,361 $25,864 $178,117 $192,331 $206,545 $617 $178,734 $192,948 $207,162 Director Parks & Recreation Issaquah, City of $133,800 $158,256 $182,712 -$23,204 $18,780 $175,784 $200,240 $224,696 $13,502 $189,286 $213,742 $238,198 Parks & Recreation Director Lacey, City of $111,072 $126,630 $142,188 -$18,058 $26,146 $155,276 $170,834 $186,392 $547 $155,823 $171,381 $186,939 NO MATCH Lake Stevens, City of ------------- Parks & Recreation Director Lynnwood, City of $139,500 $159,546 $179,592 -$22,808 $23,667 $185,975 $206,021 $226,067 $8,540 $194,515 $214,561 $234,607 Parks, Rec & Cultural Svcs DirectorPuyallup, City of $106,284 $121,170 $136,056 -$17,279 $23,667 $147,230 $162,116 $177,002 $1,570 $148,800 $163,686 $178,572 NO MATCH University Place, City of ------------- Median:$130,884 $146,805 $162,726 Median:$184,010 $201,246 $217,167 Current Edmonds Base Range:$115,803 $135,495 $155,187 Current Edmonds Base Range:$162,265 $181,957 $201,649 Proposed Base Range:$121,594 $142,270 $162,946 Range 21 3.1.a Packet Pg. 87 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization PLANNING MANAGER $95,270 $111,471 $127,672 $127,672 $16,214 $24,962 $136,447 $152,648 $168,849 $1,473 $137,920 $154,121 $170,322 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- Planning Manager Issaquah, City of $99,840 $118,092 $136,344 -$17,316 $18,780 $135,935 $154,187 $172,439 $5,101 $141,037 $159,289 $177,541 Planning Manager Lacey, City of $86,556 $98,677 $110,799 -$14,071 $26,146 $126,773 $138,895 $151,016 $426 $127,199 $139,321 $151,442 NO MATCH Lake Stevens, City of ------------- Planning Manager Lynnwood, City of $102,936 $117,726 $132,516 -$16,830 $23,667 $143,433 $158,223 $173,013 $6,548 $149,981 $164,771 $179,561 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$99,840 $117,726 $132,516 Median:$141,037 $159,289 $177,541 Current Edmonds Base Range:$95,270 $111,471 $127,672 Current Edmonds Base Range:$137,920 $154,121 $170,322 Proposed Base Range:$95,270 $111,471 $127,672 Range 16 3.1.a Packet Pg. 88 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization POLICE CHIEF $127,672 $149,383 $171,094 $171,094 $9,290 $24,962 $161,925 $183,636 $205,347 $1,974 $163,899 $185,610 $207,321 Police Chief Bothell, City of $139,860 $158,844 $177,828 -$9,656 $25,826 $175,342 $194,326 $213,310 $25,306 $200,648 $219,632 $238,616 NO MATCH Burien, City of ------------- Police Chief Issaquah, City of $140,472 $166,140 $191,808 -$10,415 $18,780 $169,667 $195,335 $221,003 $14,037 $183,704 $209,372 $235,040 Police Chief Lacey, City of $123,468 $140,760 $158,052 -$8,582 $26,146 $158,196 $175,488 $192,780 $608 $158,804 $176,096 $193,388 Police Chief Lake Stevens, City of $121,692 $137,844 $153,996 -$8,362 $26,146 $156,200 $172,352 $188,504 $7,265 $163,465 $179,617 $195,769 Police Chief Lynnwood, City of $141,480 $161,796 $182,112 -$9,889 $23,667 $175,036 $195,352 $215,668 $27,894 $202,930 $223,246 $243,562 Police Chief Puyallup, City of $129,504 $147,636 $165,768 -$9,001 $23,667 $162,172 $180,304 $198,436 $8,543 $170,716 $188,848 $206,980 NO MATCH University Place, City of ------------ Median:$134,682 $153,240 $171,798 Median:$177,210 $199,110 $221,010 Current Edmonds Base Range:$127,672 $149,383 $171,094 Current Edmonds Base Range:$163,899 $185,610 $207,321 Proposed Base Range:$127,672 $149,383 $171,094 Range 22 3.1.a Packet Pg. 89 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization PUBLIC DISCLOSURE & RECORDS MGMT. SPECIALIST $45,828 $53,621 $61,413 $55,703 $7,799 $24,962 $78,590 $86,382 $94,175 $0 $78,590 $86,382 $94,175 Public Records Specialist Bothell, City of $51,336 $58,302 $65,268 -$8,289 $25,864 $85,489 $92,455 $99,421 $251 $85,741 $92,707 $99,673 10%(-)Pub Rec. Officer Burien, City of $52,574 $58,228 $63,882 -$8,113 $25,864 $86,552 $92,206 $97,859 $246 $86,798 $92,451 $98,105 10%(-)Pub Rec. Analyst Issaquah, City of $53,222 $64,778 $76,334 -$9,694 $18,780 $81,697 $93,253 $104,809 $3,670 $85,367 $96,923 $108,479 NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------ Median:$52,574 $58,302 $65,268 Median:$85,741 $92,707 $99,673 Current Edmonds Base Range:$45,828 $53,621 $61,413 Current Edmonds Base Range:$78,590 $86,382 $94,175 Proposed Base Range:$50,523 $59,115 $67,707 Range 3 3.1.a Packet Pg. 90 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization PUBLIC WORKS & UTILITIES DIRECTOR $121,594 $142,270 $162,946 $162,946 $20,694 $24,962 $167,250 $187,926 $208,602 $1,880 $169,130 $189,806 $210,482 PW Director Bothell, City of $139,860 $158,844 $177,828 -$22,584 $25,826 $188,270 $207,254 $226,238 $16,415 $204,685 $223,669 $242,653 NO MATCH Burien, City of ------------- Director of PW Operations Issaquah, City of $140,472 $166,140 $191,808 -$24,360 $18,780 $183,611 $209,279 $234,947 $14,037 $197,648 $223,316 $248,984 PW Director Lacey, City of $119,412 $136,134 $152,856 -$19,413 $26,146 $164,971 $181,693 $198,415 $588 $165,559 $182,281 $199,003 PW Director Lake Stevens, City of $110,256 $124,884 $139,512 -$17,718 $26,146 $154,120 $168,748 $183,376 $5,902 $160,022 $174,650 $189,278 NO MATCH Lynnwood, City of $139,506 $157,918 $179,587 -$22,808 $23,667 $185,980 $204,393 $226,062 $8,540 $194,520 $212,933 $234,602 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$139,506 $157,918 $177,828 Median:$194,520 $212,933 $234,602 Current Edmonds Base Range:$121,594 $142,270 $162,946 Current Edmonds Base Range:$169,130 $189,806 $210,482 Proposed Base Range:$121,594 $142,270 $162,946 Range 21 3.1.a Packet Pg. 91 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization RECREATION SUPERVISOR $71,092 $83,181 $95,270 $95,270 $12,099 $24,962 $108,153 $120,242 $132,331 $0 $108,153 $120,242 $132,331 NO MATCH Bothell, City of ------------- Recreation Supervisor Burien, City of $64,452 $71,406 $78,360 -$9,952 $25,864 $100,268 $107,222 $114,176 $301 $100,570 $107,524 $114,478 Recreation Supervisor Issaquah, City of $86,232 $102,012 $117,792 -$14,960 $18,780 $119,971 $135,751 $151,531 $2,809 $122,780 $138,560 $154,340 NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- Recreation Supervisor Lynnwood, City of $70,308 $80,424 $90,540 -$11,499 $23,667 $105,474 $115,590 $125,706 $1,290 $106,764 $116,880 $126,996 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$70,308 $80,424 $90,540 Median:$106,764 $116,880 $126,996 Current Edmonds Base Range:$71,092 $83,181 $95,270 Current Edmonds Base Range:$108,153 $120,242 $132,331 Proposed Base Range:$71,092 $83,181 $95,270 Range 11 3.1.a Packet Pg. 92 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization RECYCLING COORDINATOR $61,413 $71,856 $82,298 $82,298 $10,452 $24,962 $96,827 $107,270 $117,712 $0 $96,827 $107,270 $117,712 Sustainability & Proj. Coord.Bothell, City of $67,356 $76,500 $85,644 -$10,877 $25,826 $78,233 $87,377 $96,521 $1,976 $80,209 $89,353 $98,497 NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of ------------- NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$67,356 $76,500 $85,644 Median:$80,209 $89,353 $98,497 Current Edmonds Base Range:$61,413 $71,856 $82,298 Current Edmonds Base Range:$71,865 $82,307 $92,750 Proposed Base Range:$61,413 $71,856 $82,298 Range $7 3.1.a Packet Pg. 93 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization SAFETY & RISK COORDINATOR (.5 FTE)$22,914 $26,810 $30,707 unfilled $3,900 $24,962 $51,776 $55,672 $59,568 $0 $51,776 $55,672 $59,568 Safety Manager Bothell, City of $47,106 $53,499 $59,892 -$7,606 $25,826 $80,538 $86,931 $93,324 $1,976 $82,514 $88,907 $95,300 NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of $33,804 $39,972 $46,140 ---------- NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- Safety & Risk Coordinator Puyallup, City of $29,382 $33,498 $37,614 -$4,777 $23,667 $57,826 $61,942 $66,058 $1,087 $58,913 $63,029 $67,145 NO MATCH University Place, City of ------------ Median:$33,804 $39,972 $46,140 Median:$70,713 $75,968 $81,222 Current Edmonds Base Range:$22,914 $26,810 $30,707 Current Edmonds Base Range:$51,776 $55,672 $59,568 Proposed Base Range:$32,242 $37,725 $43,207 Range 8 3.1.a Packet Pg. 94 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization SENIOR HUMAN RESOURCES ANALYST $71,092 $83,183 $95,273 unfunded $12,100 $24,962 $108,154 $120,244 $132,335 $0 $108,154 $120,244 $132,335 Senior HR Analyst Bothell, City of $81,240 $92,268 $103,296 -$13,119 $25,826 $120,184 $131,212 $142,240 $1,976 $122,160 $133,188 $144,216 NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of ------------- NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- Senior HR Analyst Lynnwood, City of $70,572 $80,568 $90,564 -$11,502 $23,667 $105,741 $115,737 $125,733 $1,452 $107,192 $117,188 $127,184 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$75,906 $86,418 $96,930 Median:$114,676 $125,188 $135,700 Current Edmonds Base Range:$71,092 $83,183 $95,273 Current Edmonds Base Range:$108,154 $120,244 $132,335 Proposed Base Range:$71,092 $83,183 $95,273 Range 10 3.1.a Packet Pg. 95 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization SENIOR PLANNER $76,648 $88,342 $100,035 $95,270 $12,704 $24,962 $114,315 $126,008 $137,702 $0 $114,315 $126,008 $137,702 Senior Planner Bothell, City of $74,352 $84,438 $94,524 -$12,005 $25,826 $112,182 $122,268 $132,354 $3,999 $116,181 $126,267 $136,353 Senior Planner Burien, City of $76,620 $84,876 $93,132 -$11,828 $25,864 $114,312 $122,568 $130,824 $358 $114,670 $122,926 $131,182 Senior Planner Issaquah, City of $82,104 $97,128 $112,152 -$14,243 $18,780 $115,127 $130,151 $145,175 $2,674 $117,801 $132,825 $147,849 Senior Planner Lacey, City of $77,568 $84,882 $92,196 -$11,709 $26,146 $115,423 $122,737 $130,051 $355 $115,777 $123,091 $130,405 Senior Planner Lake Stevens, City of $74,256 $84,108 $93,960 -$11,933 $26,146 $112,335 $122,187 $132,039 $361 $112,696 $122,548 $132,400 Senior Planner Lynnwood, City of $72,684 $82,332 $91,980 -$11,681 $23,667 $108,033 $117,681 $127,329 $1,296 $109,328 $118,976 $128,624 Senior Planner Puyallup, City of $71,604 $81,630 $91,656 -$11,640 $23,667 $106,911 $116,937 $126,963 $353 $107,264 $117,290 $127,316 Principal Planner University Place, City of $77,868 $90,174 $102,480 -$13,015 $24,962 $115,845 $128,151 $140,457 $0 $115,845 $128,151 $140,457 Median:$75,486 $84,657 $93,546 Median:$115,224 $123,009 $131,791 Current Edmonds Base Range:$76,648 $88,342 $100,035 Current Edmonds Base Range:$114,315 $126,008 $137,702 Proposed Base Range:$71,092 $83,151 $95,210 Range 10 3.1.a Packet Pg. 96 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization SENIOR UTILITIES ENGINEER $95,270 $93,076 $127,672 $127,673 $16,214 $24,962 $136,447 $134,253 $168,849 $1,473 $137,920 $135,726 $170,322 Supervising Cap Proj Eng Bothell, City of $103,992 $118,110 $132,228 -$16,793 $25,826 $146,611 $160,729 $174,847 $5,594 $152,205 $166,323 $180,441 NO MATCH Burien, City of ---------- Engineering Manager Issaquah, City of $104,856 $124,020 $143,184 -$18,184 $18,780 $141,820 $160,984 $180,148 $11,176 $152,996 $172,160 $191,324 NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of -------- Public Works Manager Lynnwood, City of $102,939 $117,728 $132,517 -$16,830 $23,667 $143,436 $158,225 $173,014 $1,452 $144,888 $159,676 $174,465 Assistant City Engineer Puyallup, City of $101,160 $115,332 $129,504 -$16,447 $23,667 $141,274 $155,446 $169,618 $444 $141,718 $155,890 $170,062 NO MATCH University Place, City of ------------ Median:$103,466 $117,919 $132,372 Median:$148,546 $163,000 $177,453 Current Edmonds Base Range:$95,270 $93,076 $127,672 Current Edmonds Base Range:$137,920 $135,726 $170,322 Proposed Base Range:$95,270 $93,076 $127,672 Range 16 3.1.a Packet Pg. 97 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization STORM WATER ENGINEER $82,298 $93,076 $110,289 $100,035 $14,007 $24,962 $121,267 $132,045 $149,258 $0 $121,267 $132,045 $149,258 Senior Surface Water Eng Bothell, City of $86,220 $97,920 $109,620 -$13,922 $25,826 $125,967 $137,667 $149,367 $2,530 $128,497 $140,197 $151,897 NO MATCH Burien, City of ------------- Senior Engineer Issaquah, City of $99,840 $113,640 $127,440 -$16,185 $18,780 $134,805 $148,605 $162,405 $4,589 $139,393 $153,193 $166,993 Water Resources Manager Lacey, City of $92,102 $105,000 $117,899 -$14,973 $26,146 $133,221 $146,120 $159,018 $453 $133,675 $146,573 $159,471 NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- Senior Civil Engineer Puyallup, City of $89,424 $101,940 $114,456 -$14,536 $23,667 $127,627 $140,143 $152,659 $440 $128,067 $140,583 $153,099 NO MATCH University Place, City of ------------ Median:$90,763 $103,470 $116,177 Median:$131,086 $143,578 $156,285 Current Edmonds Base Range:$82,298 $93,076 $110,289 Current Edmonds Base Range:$121,267 $132,045 $149,258 Proposed Base Range:$82,298 $93,076 $110,289 Range 13 3.1.a Packet Pg. 98 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization STREET/STORMWATER MANAGER $90,734 $93,076 $121,594 $121,594 $15,442 $24,962 $131,139 $133,481 $161,999 $1,403 $132,542 $134,884 $163,402 NO MATCH Bothell, City of ---------- Street/SW Maint. Mgr.Burien, City of $82,512 $92,478 $102,444 -$13,010 $25,826 $121,348 $131,314 $141,280 $394 $121,742 $131,708 $141,674 NO MATCH Issaquah, City of ------------- NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$82,512 $92,478 $102,444 Median:$121,742 $131,708 $141,674 Current Edmonds Base Range:$90,734 $93,076 $121,594 Current Edmonds Base Range:$132,542 $134,884 $163,402 Proposed Base Range:$90,734 $93,076 $121,594 Range 15 3.1.a Packet Pg. 99 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization TRANSPORTATION ENGINEER $86,414 $93,076 $115,803 $115,803 $14,707 $24,962 $126,083 $132,745 $155,472 $0 $126,083 $132,745 $155,472 Trans. Ops. Engineer Bothell, City of $86,220 $97,920 $109,620 -$13,922 $25,826 $125,967 $137,667 $149,367 $1,976 $127,943 $139,643 $151,343 NO MATCH Burien, City of ------------- Traffic Signal Ops Eng Issaquah, City of $99,840 $118,092 $136,344 -$17,316 $18,780 $135,935 $154,187 $172,439 $3,251 $139,187 $157,439 $175,691 Trans. Design Mgr Lacey, City of $86,184 $98,250 $110,316 -$14,010 $26,146 $126,340 $138,406 $150,472 ---- NO MATCH Lake Stevens, City of ------------- Traffic Engineer Lynnwood, City of $93,576 $107,016 $120,456 -$15,298 $23,667 $132,541 $145,981 $159,421 $1,405 $133,946 $147,386 $160,826 Trafffic Engineer Puyallup, City of $87,228 $99,450 $111,672 -$14,182 $23,667 $125,077 $137,299 $149,521 $430 $125,507 $137,729 $149,951 NO MATCH University Place, City of ------------- Median:$87,228 $99,450 $111,672 Median:$130,945 $143,515 $156,085 Current Edmonds Base Range:$86,414 $93,076 $115,803 Current Edmonds Base Range:$126,083 $132,745 $155,472 Proposed Base Range:$86,414 $93,076 $115,803 Range 14 3.1.a Packet Pg. 100 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization WATER/SEWER MANAGER $90,734 $93,076 $121,594 $121,594 $15,442 $24,962 $131,139 $133,481 $161,999 $1,403 $132,542 $134,884 $163,402 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of ------------- NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------ Median:---Median:--- Current Edmonds Base Range:$90,734 $93,076 $121,594 Current Edmonds Base Range:$132,542 $134,884 $163,402 Proposed Base Range:$90,734 $93,076 $121,594 Range 15 3.1.a Packet Pg. 101 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization WWTP MANAGER $100,035 $93,076 $134,057 $134,057 $17,025 $24,962 $142,022 $135,063 $176,044 $1,547 $143,569 $136,610 $177,591 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of ------------- NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- NO MATCH Lynnwood, City of ------------- NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:---Median: Current Edmonds Base Range:$10,035 $93,076 $134,057 Current Edmonds Base Range:$143,569 $136,610 $177,591 Proposed Base Range:$10,035 $93,076 $134,057 Range 17 3.1.a Packet Pg. 102 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee CITY OF EDMONDS' FY 2018 Non-Represented Employees Compensation Survey MIN MID MAX Retiree (12.7% PERS) or (5.43% LEOFF) Health Insurance* (family of four) MID MAX MIN MID MAX TOTAL Additional Cash Compensation & Retiree Benefits (Comparator Cities) TOTAL SALARY RANGE (includes medical and cash compensation from comparator cities) ANNUAL Edmonds' Current Actual Pay Employer Paid Benefits & Total Cash Compensation TOTAL SALARY RANGE Edmonds Job Class Survey Job Class Participant Organization WWTP SUPERVISOR $82,298 $96,294 $110,289 unfilled $14,007 $24,962 $121,267 $135,262 $149,258 $0 $121,267 $135,262 $149,258 NO MATCH Bothell, City of ------------- NO MATCH Burien, City of ------------- NO MATCH Issaquah, City of ------------- NO MATCH Lacey, City of ------------- NO MATCH Lake Stevens, City of ------------- WWTP Supervisor Lynnwood, City of $85,068 $97,302 $109,536 -$13,911 $23,667 $122,646 $134,880 $147,114 $0 $122,646 $134,880 $147,114 NO MATCH Puyallup, City of ------------- NO MATCH University Place, City of ------------- Median:$85,068 $97,302 $109,536 Median:$122,646 $134,880 $147,114 Current Edmonds Base Range:$82,298 $96,294 $110,289 Current Edmonds Base Range:$121,267 $135,262 $149,258 Proposed Base Range:$82,298 $96,294 $110,289 Range 3.1.a Packet Pg. 103 Attachment: 2018 NR Compensation Study - All Positions (2018 Non-Represented Employee 2018 Non-Represented - Compensation Study "Benchmark" positions Job Titles Salary Range Police Chief 22 PW & Utilities Director 21 Development Services Director 20 Finance Director 20 Human Resources Director 20 Parks & Recreation Director 20 Assistant Police Chief 19 Senior Utilities Engineer 16 Building Official 15 IS Manager 15 City Clerk 14 Transportation Engineer 14 Court Administrator 13 Parks Maintenance Manager 12 Capital Projects Manager 11 Senior Planner 11 Executive Assistant to the Mayor 8 Human Resources Analyst 8 Executive Assistant - Confidential 7 Planner 7 Human Resources Assistant (PT Hourly)23 3.1.b Packet Pg. 104 Attachment: 2018 NR Positions by Title- Benchmark positions (2018 Non-Represented Employee Compensation Study) City of Edmonds 2018 NR Compensation Study - Salary/Wage range comparison CURRENT POSITION TITLES Funded/Unfunded % of difference from the maximum Job Titles Filled/Unfilled Salary Range Minimum Midpoint Maximum Salary Range Minimum Midpoint Maximum 1 NB Arts & Cultural Program Manager Filled 12 $78,381 $91,709 $105,037 12 $84,822 $95,496 $106,170 1.07% 2 NB Assistant Finance Director Filled 16 $95,270 $111,471 $127,672 ---- 3 B Assistant Police Chief Filled 19 $110,289 $129,043 $147,797 20 $121,596 $138,825 $155,640 5.04% 4 NB Associate Engineer Filled 9 $67,707 $79,221 $90,734 9 $68,148 $77,688 $87,228 -4.02% 5 NB Associate Planner Filled 9 $67,707 $79,221 $90,734 ---- 6 B Building Official Filled 15 $90,734 $106,164 $121,594 17 $103,896 $119,394 $134,022 9.27% 7 B Capital Projects Manager Filled 11 $74,648 $87,342 $100,035 11 $78,504 $88,926 $99,348 -0.69% 8 B City Clerk Filled 14 $86,414 $101,109 $115,803 14 $77,052 $87,564 $98,076 -18.07% 9 NB City Engineer Filled 19 $110,289 $129,043 $147,797 19 $109,080 $126,306 $142,932 -3.40% 10 NB Community Services/Economic Development Director Filled 20 $115,083 $135,135 $155,187 20 $128,658 $145,694 $163,470 5.07% 11 B Court Administrator Filled 13 $82,298 $96,294 $110,289 17 $98,388 $114,207 $130,026 15.18% 12 NB Deputy Parks, Recreation & Cultural Services Director Unfilled 17 $100,035 $117,046 $134,057 ---- 13 B Development Services Director Filled 20 $115,083 $135,135 $155,187 20 $125,700 $143,754 $160,320 3.20% 14 NB Engineering Program Manager 2 Filled 12 $78,381 $91,709 $105,037 ---- 15 NB Environmental Program Manager Filled 14 $86,414 $101,109 $115,803 ---- 16 B Executive Assistant- Confidential (PD)Filled 7 $61,413 $71,856 $82,298 7 $64,452 $73,122 $82,308 0.01% 17 B Executive Assistant to the Mayor Filled 8 $64,484 $75,449 $86,414 7 $64,452 $73,122 $82,308 -4.99% 18 NB Facilities Manager Filled 14 $86,414 $101,109 $115,803 ---- 19 B Finance Director Filled 20 $115,083 $135,135 $155,187 20 $129,876 $146,106 $160,320 3.20% 20 NB Fleet Manager Filled 12 $78,381 $91,709 $105,037 ---- 21 B HR Analyst Filled 8 $56,424 $66,018 $75,612 8 $61,134 $69,615 $77,931 2.98% 22 B HR Assistant (part-time)Filled nr23 $19.56 $22.89 $26.21 3 $25.49 $29.06 $32.69 19.82% 23 B HR Director Filled 20 $115,083 $135,135 $155,187 21 $125,688 $143,748 $161,808 4.09% 24 B IS Manager Filled 15 $90,734 $106,164 $121,594 14 $93,744 $105,285 $116,826 -4.08% 25 B Parks Maintenance Manager Filled 12 $78,381 $91,709 $105,037 12 $84,822 $95,937 $107,706 2.48% 26 B Planner Filled 7 $61,413 $71,856 $82,298 7 $67,356 $75,018 $82,320 0.03% 27 B Parks, Recreation & Cultural Services Directgor Filled 20 $115,803 $135,495 $155,187 21 $130,884 $146,805 $162,726 4.63% 28 NB Planning Manager Filled 16 $95,270 $111,471 $127,672 ---- 29 B Police Chief Filled 22 $127,672 $149,383 $171,094 22 $134,682 $153,240 $171,798 0.41% 30 NB Public Disclosure & Records Mmgt. Specialist Filled 1 $45,828 $53,621 $61,413 3 $52,574 $58,302 $65,268 5.91% 31 B Public Works Director Filled 21 $121,594 $142,270 $162,946 22 $139,506 $157,918 $177,828 8.37% 32 NB Recreation Supervisor Filled 11 $71,092 $83,181 $95,270 ---- 33 NB Recycling Coordinator Filled 7 $64,413 $71,856 $82,298 ---- 34 NB Safety & Risk Coordinator (part-time)Unfilled 1 $22,914 $26,810 $30,707 8 $33,804 $39,972 $46,140 33.45% 35 NB Senior HR Analyst Unfilled/unfunded 10 $71,092 $83,183 $95,273 ---- 36 B Senior Planner Filled 10 $76,648 $88,342 $100,035 9 $75,486 $84,657 $93,546 -6.94% 37 B Senior Utilities Engineer Filled 16 $95,270 $93,076 $127,672 17 $103,466 $117,919 $132,372 3.55% 38 NB Storm Water Engineer Filled 13 $82,298 $93,076 $110,289 14 $90,763 $103,470 $116,177 5.07% 39 NB Street/Stormwater Manager Filled 15 $90,734 $93,076 $121,594 ---- 40 B Transportation Engineer Filled 14 $86,414 $93,076 $115,083 14 $87,228 $99,450 $111,672 -3.05% 41 NB Water/Sewer Manager Filled 14 $90,734 $93,076 $121,594 ---- 42 NB WWTP Manager Filled 17 $100,035 $93,076 $134,057 ---- 43 NB WWTP Supervisor Unfilled 13 $82,298 $96,294 $110,289 ---- Current Salary/Wage Range Policy comparator cities NB= Non-Benchmark positions 2018 NR Compensation Study - Percentage of difference from the salary or wage range maximum 12/5/2018 3.1.c Packet Pg. 105 Attachment: 2018 NR Compensation Study - Percentage of difference from the salary or wage range City of Edmonds Prevailing Benefits Practices Comparison Page 1 of 15 Other Elements of Compensation Offering Less than Average Average Better than Average Medical Premium % Paid by City Employee Only x Employee plus Family x Dental Premium % Paid by City Employee Only x Employee plus Family x Vision Premium % Paid by City Employee Only x Employee plus Family x Pension/Retirement General x Police x Paid Time Off (PTO) Vacation x Sick x Admin or Management Leave x Comp Time x Holiday x Other compensation (PD) Vehicle Allowance x Take Home Vehicle x Clothing allowance x Deferred Comp x PSPC CITY OF EDMONDS 12/6/2018 3.1.d Packet Pg. 106 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary MEDICAL INSURANCE - by Employer Page 2 of 15 Employer Insurance Group Plan Type/Name Monthly Cost of Coverage Bothell 1 Employee Only AWC -HDHP $719.48 $719.48 100%$0.00 0% 2. Employee + Spouse AWC -HDHP $1,444.99 $1,378.47 90%$72.55 10% 3. Employee + Spouse + Dependent 1 AWC -HDHP $1,802.40 $1,694.11 90%$108.29 10% 4. Employee, Spouse + 2 Dependents AWC -HDHP $2,097.87 $1,960.03 90%$137.84 10% Burien 1 Employee Only AWC -Regence Healthfirst 250 $719.48 $719.48 100%$0.00 0% 2. Employee + Spouse AWC -Regence Healthfirst 250 $1,444.99 $1,378.47 90%$72.55 10% 3. Employee + Spouse + Dependent 1 AWC -Regence Healthfirst 250 $1,802.40 $1,694.11 90%$108.29 10% 4. Employee, Spouse + 2 Dependents AWC -Regence Healthfirst 250 $2,097.87 $1,960.03 90%$137.84 10% EDMONDS 1 Employee Only AWC -Regence Healthfirst 250 $719.48 $647.53 90%$71.95 10% 2. Employee + Spouse AWC -Regence Healthfirst 250 $1,444.99 $1,300.49 90%$144.50 10% 3. Employee + Spouse + Dependent 1 AWC -Regence Healthfirst 250 $1,802.40 $1,622.16 90%$180.24 10% 4. Employee, Spouse + 2 Dependents AWC -Regence Healthfirst 250 $2,097.87 $1,888.08 90%$209.79 10% Issaquah 1 Employee Only Premera Plan 3 HDHP $469.72 $469.72 100%$0.00 0% 2. Employee + Spouse Premera Plan 3 HDHP $945.22 $945.22 100%$0.00 0% 3. Employee + Spouse + Dependent 1 Premera Plan 3 HDHP $1,183.65 $1,183.65 100%$0.00 0% 4. Employee, Spouse + 2 Dependents Premera Plan 3 HDHP $1,378.88 $1,378.88 100%$0.00 0% Lacey 1 Employee Only AWC -Regence Healthfirst 250 $719.48 $719.48 100%$0.00 0% 2. Employee + Spouse AWC -Regence Healthfirst 250 $1,444.99 $1,378.47 90%$72.55 10% 3. Employee + Spouse + Dependent 1 AWC -Regence Healthfirst 250 $1,802.40 $1,694.11 90%$108.29 10% 4. Employee, Spouse + 2 Dependents AWC -Regence Healthfirst 250 $2,097.87 $1,960.03 90%$137.84 10% Lake Stevens 1 Employee Only AWC -Regence Healthfirst 250 $719.48 $719.48 100%$0.00 0% 2. Employee + Spouse AWC -Regence Healthfirst 250 $1,444.99 $1,378.47 90%$72.55 10% 3. Employee + Spouse + Dependent 1 AWC -Regence Healthfirst 250 $1,802.40 $1,694.11 90%$108.29 10% 4. Employee, Spouse + 2 Dependents AWC -Regence Healthfirst 250 $2,097.87 $1,960.03 90%$137.84 10% Lynnwood 1 Employee Only Premera Heritage PPO $710.84 $710.84 100%$71.68 0% 2. Employee + Spouse Premera Heritage PPO $1,427.77 $1,355.97 90%$71.68 10% 3. Employee + Spouse + Dependent 1 Premera Heritage PPO $1,780.77 $1,673.78 90%$106.99 10% 4. Employee, Spouse + 2 Dependents Premera Heritage PPO $2,072.71 $1,936.52 90%$136.19 10% Puyallup 1 Employee Only HMA - Self Insurance $822.00 $822.00 100%$0.00 0% 2. Employee + Spouse HMA - Self Insurance $2,217.00 $2,217.00 100%$0.00 0% 3. Employee + Spouse + Dependent 1 HMA - Self Insurance $2,217.00 $2,217.00 100%$0.00 0% 4. Employee, Spouse + 2 Dependents HMA - Self Insurance $2,217.00 $2,217.00 100%$0.00 0% University Place 1 Employee Only AWC -Regence Healthfirst 250 $719.48 $719.48 100%$0.00 0% 2. Employee + Spouse AWC -Regence Healthfirst 250 $1,444.99 $1,378.47 90%$72.55 10% 3. Employee + Spouse + Dependent 1 AWC -Regence Healthfirst 250 $1,802.40 $1,694.11 90%$108.29 10% 4. Employee, Spouse + 2 Dependents AWC -Regence Healthfirst 250 $2,097.87 $1,960.03 90%$137.84 10% Plan Option 1 Amt. Employer Pays/Mo.Amt. Employee Pays/Mo. nr* indicates no response provided. PSPC CITY OF EDMONDS 12/6/2018 3.1.d Packet Pg. 107 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary MEDICAL INSURANCE - by Employer Page 3 of 15 Employer Insurance Group Plan Type/Name Monthly Cost of Coverage Plan Option 1 Amt. Employer Pays/Mo.Amt. Employee Pays/Mo. Des Moines 1 Employee Only AWC -Regence Healthfirst 250 $719.48 $647.53 90%$71.95 10% 2. Employee + Spouse AWC -Regence Healthfirst 250 $1,444.99 $1,227.94 80%$217.05 20% 3. Employee + Spouse + Dependent 1 AWC -Regence Healthfirst 250 $1,802.40 $1,513.87 80%$288.53 20% 4. Employee, Spouse + 2 Dependents AWC -Regence Healthfirst 250 $2,097.87 $1,749.87 80%$348.00 20% Olympia 1 Employee Only AWC -Regence Healthfirst 250 $719.48 $683.51 95%$35.97 5% 2. Employee + Spouse AWC -Regence Healthfirst 250 $1,444.99 $1,300.19 85%$144.80 15% 3. Employee + Spouse + Dependent 1 AWC -Regence Healthfirst 250 $1,802.40 $1,603.99 85%$198.41 15% 4. Employee, Spouse + 2 Dependents AWC -Regence Healthfirst 250 $2,097.87 $1,855.14 85%$242.73 15% Shoreline 1 Employee Only AWC -Regence Healthfirst 250 2. Employee + Spouse AWC -Regence Healthfirst 250 3. Employee + Spouse + Dependent 1 AWC -Regence Healthfirst 250 4. Employee, Spouse + 2 Dependents AWC -Regence Healthfirst 250 Lakewood 1 Employee Only AWC -Regence Healthfirst 250 $719.48 $719.48 100%$0.00 0% 2. Employee + Spouse AWC -Regence Healthfirst 250 $1,444.99 $1,340.12 -$104.87 - 3. Employee + Spouse + Dependent 1 AWC -Regence Healthfirst 250 $1,802.40 $1,677.42 -$124.98 - 4. Employee, Spouse + 2 Dependents AWC -Regence Healthfirst 250 $2,097.87 $1,968.69 -$129.18 - Other: Employee and Family: Average Paid by Employer:1 Employee Only $691.50 97.92%$20.96 2.08% 2 Employee & Spouse $1,381.61 90.45%$87.14 9.55% 3 Employee & Children $1,663.54 90.45%$120.05 9.55% 4 Other: Employee plus Family $1,899.53 90.45%$146.26 9.55% Cafeteria style plan - $1000-$1876 per month Cafeteria style plan - $1000-$1876 per month Cafeteria style plan - $1000-$1876 per month Cafeteria style plan - $1000-$1876 per month nr* indicates no response provided. PSPC CITY OF EDMONDS 12/6/2018 3.1.d Packet Pg. 108 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary DENTAL INSURANCE - by Employer Employer Insurance Group Plan Type/Name Monthly Cost of Coverage Bothell 1 Employee Only WDS Plan - F Plus Orthodontia $56.02 $50.42 90%$5.60 10% 2 Employee & Spouse WDS Plan - F Plus Orthodontia $106.68 $96.01 90%$10.67 10% Employee, Spouse & Dependent 1 WDS Plan - F Plus Orthodontia $183.99 $165.59 90%$18.40 10% Employee, Spouse & Dependents 1 & 2 WDS Plan - F Plus Orthodontia $183.99 $165.59 90%$18.40 10% Burien 1 Employee Only WDS Plan E-Plus Orthodontia $54.79 $54.79 100%$0.00 0% 2 Employee & Spouse WDS Plan E-Plus Orthodontia $103.63 $103.63 100%$0.00 0% Employee, Spouse & Dependent 1 WDS Plan E-Plus Orthodontia $162.61 $162.61 100%$0.00 0% Employee + Family WDS Plan E-Plus Orthodontia $162.61 $162.61 100%$0.00 0% EDMONDS 1 Employee Only WDS Plan - F Plus Orthodontia $56.02 $50.40 90%$5.62 10% 2 Employee & Spouse WDS Plan - F Plus Orthodontia $106.68 $96.01 90%$10.67 10% Employee, Spouse & Dependent 1 WDS Plan - F Plus Orthodontia $183.99 $165.59 90%$18.40 10% Employee + Family WDS Plan - F Plus Orthodontia $183.99 $165.59 90%$18.40 10% Issaquah 1 Employee Only Delta Dental Plan F $54.79 $54.79 100%$0.00 0% 2 Employee & Spouse Delta Dental Plan F $103.63 $103.63 100%$0.00 0% Employee, Spouse & Dependent 1 Delta Dental Plan F $162.21 $162.21 100%$0.00 0% Employee + Family Delta Dental Plan F $162.21 $162.21 100%$0.00 0% Lacey 1 Employee Only Delta Dental Plan F Plus Ortho $57.23 $57.23 100%$0.00 0% 2 Employee & Spouse Delta Dental Plan F Plus Ortho $109.32 $98.96 90%$10.36 10% Employee, Spouse & Dependent 1 Delta Dental Plan F Plus Ortho $201.24 $185.02 90%$16.22 10% Employee + Family Delta Dental Plan F Plus Ortho $201.24 $185.02 90%$16.22 10% Lake Stevens 1 Employee Only WDS Plan J + Ortho V $59.09 $59.09 100%$0.00 0% 2 Employee & Spouse WDS Plan J + Ortho V $112.84 $107.47 90%$5.38 10% Employee, Spouse & Dependent 1 WDS Plan J + Ortho V $167.73 $156.87 90%$10.86 10% Employee + Family WDS Plan J + Ortho V $167.73 $156.87 90%$10.86 10% Lynnwood 1 Employee Only Delta Dental $56.36 $56.36 100%$0.00 0% 2 Employee & Spouse Delta Dental $135.56 $129.12 90%$6.44 10% Employee, Spouse & Dependent 1 Delta Dental $233.80 $217.53 90%$16.27 10% Employee + Family Delta Dental $233.80 $217.53 90%$16.27 10% Plan Option 1 Amt. Employer Pays/Mo. Amt. Employee Pays/Mo. 3.1.d Packet Pg. 109 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary DENTAL INSURANCE - by Employer Puyallup 1 Employee Only WDS $72.00 $72.00 100%$0.00 0% 2 Employee & Spouse WDS $143.00 $143.00 100%$0.00 0% Employee, Spouse & Dependent 1 WDS $206.00 $206.00 100%$0.00 0% Employee + Family WDS $206.00 $206.00 100%$0.00 0% University Place 1 Employee Only Delta Dental Plan F $54.79 $54.79 100%$0.00 0% 2 Employee & Spouse Delta Dental Plan F $103.63 $103.63 100%$0.00 0% Employee, Spouse & Dependent 1 Delta Dental Plan F $162.21 $162.21 100%$0.00 0% Employee + Family Delta Dental Plan F $162.21 $162.21 100%$0.00 0% Des Moines 1 Employee Only WDS $72.00 $72.00 100%$0.00 0% 2 Employee & Spouse WDS $143.00 $143.00 100%$0.00 0% Employee, Spouse & Dependent 1 WDS $206.00 $206.00 100%$0.00 0% Employee + Family WDS $206.00 $206.00 100%$0.00 0% Olympia 1 Employee Only WDS- Plan E Plus Ortho $54.79 $54.79 100%$0.00 0% 2 Employee & Spouse WDS- Plan E Plus Ortho $103.63 $103.63 100%$0.00 0% Employee, Spouse & Dependent 1 WDS- Plan E Plus Ortho $162.21 $162.21 100%$0.00 0% Employee + Family WDS- Plan E Plus Ortho $162.21 $162.21 100%$0.00 0% Shoreline 1 Employee Only Delta Dental Plan F $54.79 $54.79 100%$0.00 0% 2 Employee & Spouse Delta Dental Plan F $103.63 $103.63 100%$0.00 0% Employee, Spouse & Dependent 1 Delta Dental Plan F $162.21 $162.21 100%$0.00 0% Employee + Family Delta Dental Plan F $162.21 $162.21 100%$0.00 0% Lakewood 1 Employee Only WDS- Plan E Plus Ortho $48.69 $48.69 100%$0.00 0% 2 Employee & Spouse WDS- Plan E Plus Ortho $90.53 $90.53 100%$0.00 0% Employee, Spouse & Dependent 1 WDS- Plan E Plus Ortho $148.57 $148.57 100%$0.00 0% Employee + Family WDS- Plan E Plus Ortho $148.57 $148.57 100%$0.00 0% Employee Only: Average Paid by Employer:$57.80 $56.93 98.46%$0.86 1.54% Other: Employee and Family: Average Paid by Employer:$180.21 $174.05 96.15%$6.17 3.85% 3.1.d Packet Pg. 110 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary VISION INSURANCE - by Employer Employer Insurance Group Plan Type/Name Monthly Cost of Coverage Bothell 1 Employee Only Vision Service Plan $9.82 $8.84 90%$0.98 10% 2 Employee & Spouse Vision Service Plan $19.64 $17.68 90%$1.96 10% Employee, Spouse & Dependent 1 Vision Service Plan $29.46 $26.51 90%$2.95 10% Employee, Spouse & Dependents 1 & 2 Vision Service Plan $29.46 $26.51 90%$2.95 10% Burien 1 Employee Only VSP $10 Co-pay + 2nd pair rider $10.91 $10.91 100%$0.00 0% 2 Employee & Spouse VSP $10 Co-pay + 2nd pair rider $21.82 $21.82 100%$0.00 0% Employee, Spouse & Dependent 1 VSP $10 Co-pay + 2nd pair rider $32.73 $32.73 100%$0.00 0% Employee + Family VSP $10 Co-pay + 2nd pair rider $32.73 $32.73 100%$0.00 0% EDMONDS 1 Employee Only Vision Service Plan $9.82 $8.84 90%$0.98 10% 2 Employee & Spouse Vision Service Plan $19.64 $17.68 90%$1.96 10% Employee, Spouse & Dependent 1 Vision Service Plan $29.46 $26.51 90%$2.95 10% Employee + Family Vision Service Plan $29.46 $26.51 90%$2.95 10% Issaquah 1 Employee Only Vision Service Plan $7.96 $7.96 100%$0.00 0% 2 Employee & Spouse Vision Service Plan $15.92 $15.92 100%$0.00 0% Employee, Spouse & Dependent 1 Vision Service Plan $23.88 $23.88 100%$0.00 0% Employee + Family Vision Service Plan $23.88 $23.88 100%$0.00 0% Lacey 1 Employee Only VSP $0 Copay plus 2nd Pair Rider $12.39 $12.39 100%$0.00 0% 2 Employee & Spouse VSP $0 Copay plus 2nd Pair Rider $24.78 $20.43 90%$4.35 10% Employee, Spouse & Dependent 1 VSP $0 Copay plus 2nd Pair Rider $37.17 $33.78 90%$3.39 10% Employee + Family VSP $0 Copay plus 2nd Pair Rider $37.17 $33.78 90%$3.39 10% Lake Stevens 1 Employee Only Vision Service Plan- $7.96 $7.96 100%$0.00 0% 2 Employee & Spouse Vision Service Plan $15.92 $15.92 100%$0.00 0% Employee, Spouse & Dependent 1 Vision Service Plan $23.88 $23.88 100%$0.00 0% Employee + Family Vision Service Plan $23.88 $23.88 100%$0.00 0% Lynnwood 1 Employee Only Vision Service Plan $71.13 $71.13 100%$0.00 0% 2 Employee & Spouse Vision Service Plan $135.56 $129.12 95%$6.44 5% Employee, Spouse & Dependent 1 Vision Service Plan $233.80 $217.53 95%$16.27 5% Employee + Family Vision Service Plan $233.80 $217.53 95%$16.27 5% Plan Option 1 Amt. Employer Pays/Mo. Amt. Employee Pays/Mo. 3.1.d Packet Pg. 111 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary VISION INSURANCE - by Employer Puyallup 1 Employee Only Vision Service Plan $23.00 $23.00 100%$0.00 0% 2 Employee & Spouse Vision Service Plan $45.00 $45.00 100%$0.00 0% Employee, Spouse & Dependent 1 Vision Service Plan $65.00 $65.00 100%$0.00 0% Employee + Family Vision Service Plan $65.00 $65.00 100%$0.00 0% University Place 1 Employee Only Vision Service Plan $7.96 $7.96 100%$0.00 0% 2 Employee & Spouse Vision Service Plan $15.92 $15.92 100%$0.00 0% Employee, Spouse & Dependent 1 Vision Service Plan $23.88 $23.88 100%$0.00 0% Employee + Family Vision Service Plan $23.88 $23.88 100%$0.00 0% Des Moines 1 Employee Only Vision Service Plan $23.00 $23.00 100%$0.00 0% 2 Employee & Spouse Vision Service Plan $45.00 $45.00 100%$0.00 0% Employee, Spouse & Dependent 1 Vision Service Plan $65.00 $65.00 100%$0.00 0% Employee + Family Vision Service Plan $65.00 $65.00 100%$0.00 0% Olympia 1 Employee Only Vision Service Plan $7.96 $7.96 100%$0.00 0% 2 Employee & Spouse Vision Service Plan $15.92 $15.92 100%$0.00 0% Employee, Spouse & Dependent 1 Vision Service Plan $23.88 $23.88 100%$0.00 0% Employee + Family Vision Service Plan $23.88 $23.88 100%$0.00 0% Shoreline 1 Employee Only Vision Service Plan $7.96 $7.96 100%$0.00 0% 2 Employee & Spouse Vision Service Plan $15.92 $15.92 100%$0.00 0% Employee, Spouse & Dependent 1 Vision Service Plan $23.88 $23.88 100%$0.00 0% Employee + Family Vision Service Plan $23.88 $23.88 100%$0.00 0% Lakewood 1 Employee Only Vision Service Plan $7.96 $7.96 100%$0.00 0% 2 Employee & Spouse Vision Service Plan $15.92 $15.92 100%$0.00 0% Employee, Spouse & Dependent 1 Vision Service Plan $23.88 $23.88 100%$0.00 0% Employee + Family Vision Service Plan $23.88 $23.88 100%$0.00 0% Employee Only: Average Paid by Employer:$15.99 $15.84 98.46%$0.15 1.54% Other: Employee and Family: Average Paid by Employer:$48.92 $46.95 97.31%$1.97 2.69% 3.1.d Packet Pg. 112 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary Paid Time Off - by Employer Page 8 of 15 Employer Employee Group PTO Bank @ 1 Year @5 Years @10 Years @15 Years @20 Years 25+ Years Comments Sick Holidays Mgmt./Admin. Leave Formal Comp time accrual Merit Other Comments Hours/yr Hours/yr Hours/yr Hours/yr Hours/yr Hours/yr Hours/Yr Hours/yr Hours/yr Hours/yr Hours/yr Hours/yr Bothell General (non-managers)96 120 144 160 176 176 96 96 *150 42 -must "exceeds standards" for work peformance Managers 176 200 224 240 256 256 management leave 96 96 *100 42 -*mgmt leave included in vacation leave Directors 176 200 224 240 256 256 management leave 96 96 *100 42 - Burien General 96 120 144 168 168 168 96 96 ---- Managers 96 120 144 168 168 168 96 96 ---- Directors 160 160 184 208 208 208 96 96 ---- EDMONDS General (non-managers)88 88 128 168 176 176 96 88 24 --- Managers/Supervisors 128 128 168 176 200 216 96 88 24 *--*supv. only may accrue 48 hours per year- comp Directors 176 176 176 176 176 176 96 88 24 --- Issaquah General (non-managers)128 160 192 208 224 224 96 96 ---16 wellness & education incentive leave - 16 hours Managers 128 160 192 208 224 224 96 96 ---16 Directors 128 160 192 208 224 224 96 96 ---16 Lacey General (non-managers)120 128 152 168 192 216 96 96 ---- Managers 120 128 152 168 192 216 96 96 ---- Directors 144 144 160 176 192 192 96 96 ---- Lake Stevens General (non-managers)80 128 152 184 200 200 96 96 --24 -supervisors receive 24 hours of merit leave Managers 80 128 152 184 200 200 96 96 --40 - Directors 80 128 152 184 200 200 96 96 --80 - Lynnwood General (non-managers)80 96 136 152 200 200 96*96 80 -- ** * up to 20 extra days of sick leave per year Managers 80 96 136 152 200 200 96*96 80 --**** up to 10 extra days of admin (mgmt) leave Directors 80 96 136 152 200 200 96*96 80 *-** Puyallup General (non-managers)112 144 176 208 208 208 96 96 16 -- - up to 2 days of administrative leave per year Managers 112 144 176 208 208 208 96 96 16 --- Directors 112 144 176 208 208 208 96 96 16 --- University Place General (non-managers)96 120 144 168 184 184 96 88 --40 eligible for up to 5 days of merit leave per year Managers 96 120 144 168 184 184 96 88 --40 Directors 96 120 144 168 184 184 96 88 --40 Des Moines General (non-managers)96 120 144 168 192 192 96 96 ---32 exempt employees are accrue 8 extra hours of leave Managers 96 120 144 168 192 192 96 96 ---32 per quarter Directors 96 120 144 168 192 192 96 96 ---32 Olympia General (non-managers)96 120 144 168 192 216 88 88 ---- Managers 96 120 144 168 192 216 88 88 ---- Directors 96 120 144 168 192 216 88 88 ---- Shoreline General (non-managers)104 136 151 184 184 184 96 96*24 ---*includes 2 personal days per year Managers 104 136 151 184 184 184 96 96*24 --- Directors 104 136 151 184 184 184 96 96*24 --- Lakewood General (non-managers)x 120 152 184 216 232 232 96 96 48 ---up to 6 days of manageement leave per year Managers x 120 152 184 216 232 232 96 96 48 --- Directors x 120 152 184 216 232 232 96 96 48 --- @ 1 Year @5 Years @10 Years @15 Years @20 Years 25+ Years Sick Holidays Mgmt./Admin. Leave Formal Comp time accrual Merit Other Averages Hours/yr Hours/yr Hours/yr Hours/yr Hours/yr Hours/yr Hours/Yr Hours/yr Hours/yr Hours/yr Hours/yr Hours/yr Other Professional Exempt 102 129 154 178 195 199 95 94 28 -35 24 Managers 108 135 161 185 201 205 95 94 28 -41 24 Directors 114 139 164 188 204 206 95 94 28 -54 24 VACATION LEAVE OTHER LEAVE VACATION LEAVE OTHER LEAVE CITY OF EDMONDS 12/6/2018 3.1.d Packet Pg. 113 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary Paid Time Off Notes Page 9 of 15 Employer Comments Bothell City Manager may also approve up to 80 hours of annual vacation leave buyback for each exempt employee. Burien 24 hours of sick leave advanced to new employees. Edmonds Annual conversion option of sick leave over 800 hours on a 3:1 basis for pay up to $1000 per year. Issaquah Non-director level employees allowed to accrue 100 hours of comp time per year. Directors allowed to accrue 150 hours of comp time per year. Annual conversion option of sick leave that includes sick leave earned in excess of 1,280 hours to be converted to vacation leave @ 50% or if sick leave balance is 240 or more hours, may convert 1/3 of sick leave to vacation or pay (as long as leave balance after conversion is 240 hours) or if sick leave balance is 480 or more hours, may convert 1/2 of sick leave to vacation or pay. Lacey Lake Stevens Exempt employees also eligible for additional administrative leave (for work meetings outisde of regular work hours) at the discretion of the City Administrator. Lynnwood Puyallup May convert hours in excess of 18 months of accrued vacation balance into a RHSA (retirement health savings account). University Place N/A Des Moines CITY OF EDMONDS 12/6/2018 3.1.d Packet Pg. 114 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary Paid Time Off Notes Page 10 of 15 Employer Comments Olympia N/A Shoreline May place any unused cafeteria benefit dollars (amount allotted, but not used for health insurance) into a deferred compensation plan. Lakewood N/A CITY OF EDMONDS 12/6/2018 3.1.d Packet Pg. 115 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary By Employer Page 11 of 15 Employer Employee Group Education: AA Education: BA Education: MA DCP 401(a)Longevity Management/Admin Leave Merit Pay or Leave Comp Leave Extra Holiday leave or Floater VEBA/RHS/R HA Vehicle/Car/Housi ng Allowance OTHER Comments Bothell General (non-managers)2-5%42 hours per year 8 holiday Managers 2-5%80 hours per year 42 hours per year 8 holiday Directors 2-5%80 hours per year 42 hours per year 8 holiday Police Burien General (non-managers)8 holiday Managers 8 holiday Directors 8 holiday Police EDMONDS General (non-managers) Managers 24 hours per year Directors 24 hours per year Police 2.5%24 hours per year Issaquah General (non-managers)$300 100 hours per year 8 holiday, 8 wellness, 8 education $1,550 requires 1:1 match up to $300 Managers $300 100 hours per year 8 holiday, 8 wellness, 8 education $1,550 Directors $1,200 3.5%150 hours per year 8 holiday, 8 wellness, 8 education $1,550 requires 5% employee contribution Police $1,200 3.5%8 holiday, 8 wellness, 8 education $1,550 Lacey General (non-managers)8 holiday Managers 8 holiday Directors 8 holiday Police 8 holiday Lake Stevens General (non-managers)24 hours per year 8 holiday Managers 40 hours per year 8 holiday Directors 80 hours per year 8 holiday Police Lynnwood General (non-managers)5 years = $221.52/year 80 hours per year 80 hours extra sick leave extra leave at discretion of City Manager Managers 8 years= $443.04/year 80 hours per year 160 hours extra sick leave Directors 11 years = 664.56 80 hours per year 160 hours extra sick leave 15 years = $941.52 80 hours per year Police See benefits matrix for Police Chief/Assistant Police Chief 80 hours per year Puyallup General (non-managers)16 hours per year 8 holiday 16 hours of administrative leave per yer Managers 16 hours per year 8 holiday 16 hours of administrative leave per yer Directors 16 hours per year 8 holiday 16 hours of administrative leave per yer Police 16 hours per year 16 hours of administrative leave per yer University Place General (non-managers)40 hours per year Managers 40 hours per year Directors 40 hours per year Police 40 hours per year Des Moines General (non-managers)8 holiday Managers 8 holiday Directors 8 holiday Police Olympia General (non-managers) Managers Directors Police Shoreline General (non-managers)24 hours per year 8 holiday Managers 24 hours per year 8 holiday Directors 24 hours per year 8 holiday Police 24 hours per year Lakewood General (non-managers)48 hours per year 8 holiday Managers 48 hours per year 8 holiday Directors 48 hours per year 8 holiday Police 48 hours per year 2% education merit 2% education merit 2% education merit 2% education merit CITY OF EDMONDS 12/6/2018 3.1.d Packet Pg. 116 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary Notes Page 12 of 15 Employer Comments 2-5% deferred compensation (DCP) employer contribution up to 42 hours of merit leave per year Tuition reimbursement - 80% cost of tuition paid for AA/AAS or BA/BS or 40% cost of tuition for Master's degree Telecommmuting program for certain positions. Burien Employer paid ORCA Card for METRO, Community Transit, Everett Transit, Pierce Transit, and Sound Transit. 401 (a) Social Security Replacement Plan through ICMA; 1 year vesting schedule. Tuition reimbursement -$1550 per full time employee per year. Pro-rated for part time employees. Cost of tuition or course books and lab fees. EDMONDS Employer paid ORCA Card for METRO, Community Transit MEBT (Social Security Replacement Plan) - 7 year vesting schedule. 100% tuition reimbursement (up to an Associate's degree); 50% reimbursement for Bachelors/Masters degrees up to $2000 maximum per year. Issaquah Employer VEBA contribution of $1550 per employee. Up to 100% tuition reimbursement as approved by Council in budget Free annual community center family pass. Lacey Lake Stevens Eligible for 100% tuition/continuing eductation (professional training/certifications, etc.) as allowed in budget as administered by HR. Longevity Pay 5 years = $221.52/year 8 years= $443.04/year 11 years = 664.56 15 years = $941.52 Puyallup Tuition reimbursement of $2,000 per employee per year. Exceptions may be made on a case-by-case basis by the City Manager. Bothell Lynnwood CITY OF EDMONDS 12/6/2018 3.1.d Packet Pg. 117 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented City of Edmonds 2018 Other Elements of Compensation Survey Summary Notes Page 13 of 15 Employer Comments BothellUniversity Place Telecommuting, flexible work schedules. Tuition reimbursement only for up to $5500 per calendar year (per approved program). Other courses - up to 100% or 50% depending upon relation to career path/development. Retirement health savings plan Social Security replacement program (401 a), 100% vesting after two years Des Moines Training course(s) reimbursement, up to 100% at City's discretion 401 a Social Security Replacement plan Olympia Tuition reimbursement possible as budgeted by department Shoreline Telecommuting, flexible work schedules 401 a Social Security Replacement plan Tuition reimbursement - 100% tuition and registration - up to 6 credits per semester or 9 credits per quarter for approved courses. Employees may use the pool and recreation center. Lakewood Up to 3% employer match in dcp. Up to 1% base salary dcp contribution for meritorious employees at the top of their pay scale. 100% Tuition reimbursement up to 15 credit hours per school quarter, per semester per employee (tuition and registration). Exceptions on a case-by-Case basis. CITY OF EDMONDS 12/6/2018 3.1.d Packet Pg. 118 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented Police Chief - Other Elements of Compensation City Education Incentive HRA Longevity Incentive Deferred Comp Admin Leave Management Leave Comp Time Overtime Merit Leave Merit Pay Clothing Allowance as salary Car Allowance Cell Phone Allowance Holiday Buy- Back Bothell 2-5% base salary 80 hrs/yr 96 hrs/yr 42 hrs/yr $465/yr Burien EDMONDS 24 hrs/yr $900/yr Issaquah 2%$1,550 $100/mo plus 3.5%150 hrs/yr 7% Lacey 2% $650/yr Lake Stevens 80 hrs/yr 750/yr Lynnwood 5.40%2% - 5 yrs 75 hrs/yr @ 1.5x 1250/yr 3% - 10 yrs 5% - 15 yrs 7% - 20 yrs Puyallup 4%$360/yr University Place Des Moines 1% of base pay Marysville 4%80 hrs/yr $500/mo Lakewood 4%80 hrs/year Olympia 4% Shoreline * includes employer retiree (LEOFF) contributions of 5.23% and health insurance premiums paid by the City Contracted Services Contracted Services Contracted Services 3.1.d Packet Pg. 119 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented Assistant Police Chief - Other Elements of Compensation City Education Incentive Longevity Incentive Deferred Comp Admin Leave Manageme nt Leave Comp Time Overtime Merit Leave Merit Pay Clothing Allowance as salary Cell Phone Allowance Holiday Buy- Back Command Duty Pay Bothell 2-5% base salary 80 hrs/yr 96 hrs/yr 42 hrs/yr $464/yr EDMONDS 2.5%24 hrs/year $900/yr Issaquah $300/mo 100 hrs/year 7% Lacey 1%$650/yr Lake Stevens 40 hrs/yr $600/yr Lynnwood 5.40%2% - 5 yrs 75 hrs/yr @ 1.5x $1250/yr 3% - 10 yrs 5% - 15 yrs 7% - 20 yrs Puyallup 4%16 hrs/yr $360/year University Place Des Moines 1% of base pay Marsyville 4%80 hrs/yr $600/mo Lakewood 4%48 hrs/yr Olympia 1% Shoreline * includes employer retiree (LEOFF) contributions and health insurance premiums paid by the City Contracted Services Contracted Services 3.1.d Packet Pg. 120 Attachment: Appendix - Other Elements of Compensation Survey - 2018 (2018 Non-Represented 2018 Non-Represented Positions Job Titles Salary Range Minimum Midpoint Maximum Police Chief 22 $127,672 $149,383 $171,094 PW & Utilities Director 21 $121,594 $142,270 $162,946 Community & Economic Development Director 20 $115,803 $135,495 $155,187 Development Services Director 20 $115,803 $135,495 $155,187 Finance Director 20 $115,803 $135,495 $155,187 Parks & Recreation Director 20 $115,803 $135,495 $155,187 Assistant Police Chief 19 $110,289 $129,043 $147,797 City Engineer 19 $110,289 $129,043 $147,797 Deputy Parks, Recreation & Cultural Services Director 17 $100,035 $117,046 $134,057 WWTP Manager 17 $100,035 $117,046 $134,057 Assistant Finance Director 16 $95,270 $111,471 $127,672 Planning Manager 16 $95,270 $111,471 $127,672 Senior Utilities Engineer 16 $95,270 $111,471 $127,672 Building Official 15 $90,734 $106,164 $121,594 IS Manager 15 $90,734 $106,164 $121,594 Street/Storm Water Manager 15 $90,734 $106,164 $121,594 Water/Sewer Manager 15 $90,734 $106,164 $121,594 City Clerk 14 $86,414 $101,109 $115,803 Environmental Programs Manager 14 $86,414 $101,109 $115,803 Engineering Program Manager III*14 $86,414 $101,109 $115,803 Facilities Manager 14 $86,414 $101,109 $115,803 Transportation Engineer 14 $86,414 $101,109 $115,803 Court Administrator 13 $82,298 $96,294 $110,289 Storm Water Engineer 13 $82,298 $96,294 $110,289 WWTP Supervisor 13 $82,298 $96,294 $110,289 Arts & Cultural Services Manager 12 $78,381 $91,709 $105,037 Engineering Program Manager II 12 $78,381 $91,709 $105,037 Fleet Manager 12 $78,381 $91,709 $105,037 Parks Maintenance Manager 12 $78,381 $91,709 $105,037 Capital Projects Manager 11 $74,648 $87,342 $100,035 Senior Planner 11 $74,648 $87,342 $100,035 Engineering Program Manager I*10 $71,092 $83,181 $95,270 Recreation Supervisor 10 $71,092 $83,181 $95,270 Senior Human Resources Analyst*10 $71,092 $83,181 $95,270 Associate Planner 9 $67,707 $79,221 $90,734 Associate Engineer 9 $67,707 $79,221 $90,734 Executive Assistant to the Mayor 8 $64,484 $75,449 $86,414 Human Resources Analyst 8 $64,484 $75,449 $86,414 Planner 7 $61,413 $67,470 $82,298 Recycling Coordinator 7 $61,413 $67,470 $82,298 Executive Assistant - Confidential 7 $61,413 $67,470 $82,298 Public Disclosure and Records Management Specialist 1 $45,828 $53,621 $61,413 Safety & Risk Coordinator (part-time)1 $22,914 $26,810 $30,707 * Unfunded, unfilled 3.1.e Packet Pg. 121 Attachment: 2018 Non-Represented positions- Classification listing (2018 Non-Represented Employee Compensation Study) 2018- Non-Represented Positions Job Titles Salary Range Minimum Midpoint Maximum Police Chief 22 $127,672 $149,383 $171,094 PW & Utilities Director 22 $127,672 $149,383 $171,094 Community & Economic Development Director 21 $121,594 $142,270 $162,946 Development Services Director 21 $121,594 $142,270 $162,946 Finance Director 21 $121,594 $142,270 $162,946 Parks & Recreation Director 21 $121,594 $142,270 $162,946 Assistant Police Chief 20 $115,803 $135,495 $155,187 City Engineer 19 $110,289 $129,043 $147,797 Deputy Parks, Recreation & Cultural Services Director 17 $100,035 $117,046 $134,057 WWTP Manager 17 $100,035 $117,046 $134,057 Assistant Finance Director 16 $95,270 $111,471 $127,672 Planning Manager 16 $95,270 $111,471 $127,672 Senior Utilities Engineer 16 $95,270 $111,471 $127,672 Building Official 15 $90,734 $106,164 $121,594 IS Manager 15 $90,734 $106,164 $121,594 Street/Storm Water Manager 15 $90,734 $106,164 $121,594 Water/Sewer Manager 15 $90,734 $106,164 $121,594 City Clerk 14 $86,414 $101,109 $115,803 Environmental Programs Manager 14 $86,414 $101,109 $115,803 Engineering Program Manager III*14 $86,414 $101,109 $115,803 Facilities Manager 14 $86,414 $101,109 $115,803 Transportation Engineer 14 $86,414 $101,109 $115,803 Court Administrator 14 $86,414 $101,109 $115,803 Storm Water Engineer 13 $82,298 $96,294 $110,289 WWTP Supervisor 13 $82,298 $96,294 $110,289 Arts & Cultural Services Manager 12 $78,381 $91,709 $105,037 Engineering Program Manager II 12 $78,381 $91,709 $105,037 Fleet Manager 12 $78,381 $91,709 $105,037 Parks Maintenance Manager 12 $78,381 $91,709 $105,037 Capital Projects Manager 11 $74,648 $87,342 $100,035 Senior Planner 11 $74,648 $87,342 $100,035 Engineering Program Manager I*10 $71,092 $83,181 $95,270 Recreation Supervisor 10 $71,092 $83,181 $95,270 Senior Human Resources Analyst*10 $71,092 $83,181 $95,270 Associate Planner 9 $67,707 $79,221 $90,734 Associate Engineer 9 $67,707 $79,221 $90,734 Executive Assistant to the Mayor 8 $64,484 $75,449 $86,414 Human Resources Analyst 8 $64,484 $75,449 $86,414 Safety & Risk Coordinator (part-time) 8 $32,242 $37,725 $43,207 Planner 7 $61,413 $67,470 $82,298 Recycling Coordinator 7 $61,413 $67,470 $82,298 Executive Assistant - Confidential 7 $61,413 $67,470 $82,298 Public Disclosure and Records Management Specialist 3 $50,523 $59,115 $67,707 HR Assistant (part-time)3 $25.49 $29.06 $32.69 * Unfunded, unfilled 3.1.f Packet Pg. 122 Attachment: 2019 Non-Represented Employees - Classification Listing - with recommended adjustments (2018 Non-Represented Employee NON-REPRESENTED 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Non-Represented 2.0%2.7%3.0%3.5%5.8%**0 0 Lump sum (0.00459)2.0%1.4%2.0%2.0%2.3%3.0%3.0% Non-Represented 0-5%0-5%0-3%0-3%0 0-3%1.5%0 ***N/A N/A N/A N/A N/A N/A N/A Non Represented (not at top step)N/A N/A N/A N/A N/A N/A N/A Placed on steps (by Council approval 9/25/12) 5%5%5%5%5%5%5% Total Increase 2-7%2.7-7.7%3-6%3.5-6.5%5.80%0-3%0-1.5%0.5%-4%2-7%1.4-6.4%2-7%2-7%2.3-7%3-8%3-8% * COLA's in 2009 were offset by 9 mandated furlough days, which is equivalent to a 3.5% salary reduction .. ***Non-represented employees did not receive a COLA or merit increase in 2012. Council authorized an amount, of a different % for each person, to put them on a Step on a new salary schedule. **COLA's in 2009 were offset by 9 mandated furlough days, which is equivalent to a 3.5% salary reduction for one year COLAS CITY OF EDMONDS History of Cost of Living Adjustment (COLA) & Merit Increases for Non-Represented Employees (2005-2019) MERIT INCREASES STEP INCREASES \\edmsvr-deptfs\HR\COMPENSATION & BENEFITS\2018 Non-Represented Salary Survey\Agenda items\COLA History - NR (2005-2019) 3.1.g Packet Pg. 123 Attachment: COLA History - NR (2005-2019) (2018 Non-Represented Employee Compensation Study) 5.5 NON REPRESENTED EMPLOYEES The City’s non-represented compensation policy strives to maintain equity, by offering competitive salaries and benefits in order to attract and retain high quality staff and an effective work force. It is the policy of the City for the classification and compensation plan to provide salaries that compare favorably with other similar cities in the region for comparable jobs, and within budget limitations. It is also the policy of the City to strive to maintain salaries that are internally equitable, in proper relationship to all other jobs within the City, within reasonable budget parameters. SALARY RANGE PROGRESSION Salary ranges for non-represented positions will have a 35% spread from the bottom to the top of each salary range, and will include a seven-step scale with 5% between each of the steps. All new employees will generally be hired at the first step of their salary range; however, an entry level rate of pay above the minimum may be offered to an applicant whose education and experience exceed the minimum qualifications for the classification, or when external labor market pay practices impact recruitment. Initial step placement at higher than Step 3 of the salary range is subject to approval by the Mayor prior to the offer of employment. Employees are advanced to the next salary step increment after satisfactorily completing the first six months of probation. After this, employees advance to the next step in the salary range on the January following their anniversary date and each succeeding January after a concurrent satisfactory overall performance evaluation has been completed by their supervisor, until reaching the maximum step. An employee is considered not to have achieved a satisfactory overall performance rating if two or more performance category areas in the evaluation receive less than a “meets standards” rating. An employee who fails to achieve at least a satisfactory overall performance rating on their annual performance evaluation shall not be eligible for a step increase until their next performance evaluation rating period. Employees who do not achieve a satisfactory overall performance rating will be immediately placed on a performance improvement plan (PIP). The PIP will provide clear expectations to the employee for the work performance items that must improve in order for the employee to achieve a satisfactory overall performance rating by the next evaluation period (usually 3 and/or 6 months) as determined under the PIP. A PIP also serves as a work plan for the employee that will likely include individualized, supervisor-provided feedback and counseling on improving work performance, as well as outlining any necessary areas of training or retraining in order for the employee to succeed on the PIP. In the event of promotion of a non-represented employee to another non-represented job classification in a higher salary range, the employee will be placed on the first step of the new salary range or the lowest step in the new range that results in an increase to their current salary. After this, the employee would follow the salary range progression described above for new employees. To ensure internal equity, employees promoted from a represented position to a non- represented position in a higher pay range, will be placed on the first step of the new salary range, or the lowest step in the new range that results in an increase to their current salary, including consideration of other cash compensation being received in the former position. After 3.1.h Packet Pg. 124 Attachment: 5.5 Non-Represented Compensation Policy- with redline recommended updates (2018 Non-Represented Employee Compensation this, the employee would follow the salary range progression described above for new employees. In the event of a lateral placement of a non-represented employee to another non-represented job classification in the same pay range, the employee will not receive a salary increase. ANNUAL SALARY ADJUSTMENTS The Mayor will recommend the adjustment of salary ranges for non-represented employees to the City Council for approval as part of the budget process, effective January 1 of each year. The Mayor’s recommendation will take into consideration the average adjustment negotiated and approved for represented employee groups. Each employee will maintain the same step within the newly approved salary range that they held prior to the adjustment. In addition, the City will attempt to mitigate compression issues as they arise. The Mayor will make appropriate and timely recommendations to City Council to maintain internal equity and prevent compression issues. MARKET ANALYSIS The Human Resources Department will conduct compensation surveys for each non- represented benchmark position no later than September 1, every three years. The following criteria will be used for determining which cities are comparable for the purposes of analyzing and comparing compensation (“Qualified Comparable Cities”):  Comparable cities must be located in Snohomish, King, Pierce, or Thurston counties; and  Comparable cities will include all cities with a population that is no more than 10,000 over or no more than 10,000 under the population of the City of Edmonds according to the most recent population figures published by the Washington State Office of Financial Management or a similar successor government agency; and  The application of the above criteria will be utilized to select a minimum of eight agencies that are closest in population to the City of Edmonds. If this process yields fewer than eight comparable cities (not counting Edmonds) for analysis during a particular year, additional cities shall be selected for analysis by adding an additional city or cities, up to eight, with agencies that are outside the 10,000 over/under criteria, but that are the next closest in population to the City of Edmonds, with the goal of having 50% of the cities with a higher population and 50% with a lower population than Edmonds..  In addition to population size, the comparable cities will also consider other labor market factors in order to yield the closest regional labor market including: assessed valuation, revenue and budget information. Considering these factors may at times result in using comparable cities that are above the City of Edmonds in population by 10,000. Additionally, private sector data will may be gathered and considered where it is a significant factor in the City’s competitiveness. Benchmark positions are those which are assigned clearly recognizable work at a well-defined level of responsibility, and for which comparable classifications are easily identified to ensure 3.1.h Packet Pg. 125 Attachment: 5.5 Non-Represented Compensation Policy- with redline recommended updates (2018 Non-Represented Employee Compensation that sufficient data can be collected. Classifications that are selected as comparable for survey purposes must match the benchmark position by 80% in level of work and responsibility. Salaries for comparable positions that are not a complete match may be leveled up or down by a maximum of 20%, to adjust for differences in the level or scope of responsibility in work duties. Salary ranges for benchmarks will be determined by using the prevailing rates in the identified comparator cities. The City will be competitive within the defined market, but will not assume the position of a lead pay policy compared to the market; therefore the median or 50th percentile of the mid-range of salary data collected will be used to determine competitiveness. Every three years, based upon the survey data, the Mayor will recommend salary range market adjustments for non-represented positions to City Council. The Mayor will consider the following criteria in developing the recommendation: 1. Maintain the mid-point of each salary range between 5% high/low of the mid-point of the comparator city median. 2. Positions requiring adjustment will be assigned to the new salary range within the salary range table that places the position closest to the comparator city median or will maintain their current wage if appropriate, based on internal equity and/or compression considerations. 3. Any employee whose actual salary falls below the newly adopted pay range minimum, shall be adjusted up to the new minimum upon adoption of the new pay ranges. 4. Any employee whose actual salary exceeds the top of the approved salary range, will have their salary frozen until such time that market rates support pay range adjustment for their job classification. 3.1.h Packet Pg. 126 Attachment: 5.5 Non-Represented Compensation Policy- with redline recommended updates (2018 Non-Represented Employee Compensation