The URL can be used to link to this page

2007.11.14 Finance Committee Meeting Agenda PacketAGENDA Finance Committee Meeting Council Chambers, Public Safety Complex 250 5th Avenue North, Edmonds November 14, 2007 6:00 p.m. The Edmonds 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. 1.Finance Committee Meeting Location: Jury Meeting Room A. AM-1248 (10 Min) Edmonds Center for the Arts Capital Bond Issue Guarantee B. AM-1253 (10 Min) Domestic Partner Benefits C. AM-1241 (10 Min) Donated Property Ordinance D. AM-1238 (10 Min) 2007 Third Quarter Budget Report E. AM-1247 (10 Min) 2007 Final Quarter Budget Amendment F. AM-1246 (10 Min) Mid-Biennial Review and Modification Ordinance G. AM-1237 (10 Min) 2007-2008 Mid-Biennial Budget Ordinance H. AM-1236 (10 Min) Preliminary 2008 Property Tax Ordinance I. AM-1251 (10 Min) Broadband Up-Date J. AM-1249 (10 Min) Broadband Customer Contracts K. AM-1250 (10 Min) Broadband Marketing Contract Packet Page 1 of 84 AM-1248 1.A. Edmonds Center for the Arts Capital Bond Issue Finance Committee Meeting Date:11/14/2007 Submitted By:Dan Clements, Administrative Services Time:10 Minutes Department:Administrative Services Action Information Subject Edmonds Center for the Arts Capital Bond Issue Guarantee Previous Council Action The City Council has previously approved guaranteeing an interim construction bridge loan. Narrative Final contract payments associated with the Edmonds Center for the Arts are being finalized, and staff recommend turning the remaining $3.5 million interim loan into a 15 year "mortgage." This recommendation has been made for the following reasons: 1.) Lower interest rates; 2.) Completion of construction; 3.) Elimination of the need to run both a capital and operating fund raising campaigns; and 4.) Since the City has guaranteed the interim loan, transferring the debt to a bond issue reduced the City's financial exposure. Recommendation Approve transferring the City's backing of the Edmonds Center for the Arts interim construction loan to a Center bond issue backed by the City. Fiscal Impact Attachments Link: Financing_Recommendation Packet Page 2 of 84 1 Clements, Dan From:Clements, Dan Sent:Friday, October 26, 2007 11:46 AM To:'Rinehart'; Dave Earling (Dave_earling@yahoo.com); 'Dave'; Maria Montalvo (maria@olivesgourmet.com); 'Montalvo'; 'John'; 'Terry Vehrs (E-mail'; 'mpopke@lynnwoodhonda.com' Cc:McIalwain, Joe; 'Ginny Arveson'; Cruz, Cindi; Junglov, Kathleen; Junglov, Kathleen; Clifton, Stephen; Alan Dashen Subject:Construction Loan Restructuring Hi All: This is a follow-up to our discussion earlier this week regarding rolling the PFD’s bridge financing into a longer term “mortgage.” As noted below, Alan Dashen is planning on attending the November 13 Board meeting where this topic will be discussed. Follow-Up Questions Below are the responses to the questions that needed researching. 1. Interim Financing Loan Term. The current financing was for a maximum ten year period, and expires in 2015. 2. Interim Financing Loan Rate. The current loan is variable rate, and is equal to 65% of prime plus 37 basis points. At the present time the actual rate is 4.37%. 3. Proposed Loan Financing Rate. In phone conversations this morning, the current interest rate for a $3.5 million bond issue of this type is in the 4.25% range. So, at this point in time, the rate is actually lower than the interim loan rate. 4. Proposed Loan Financing Term. As mentioned at the PFD Board meeting, there are a number of ways of structuring the issue. Below is a table listing approximate annual repayment for 10, 15, and 20 year terms. Term Annual Debt Service 10 Years $430,000 15 Years $315,000 20 Years $260,000 For planning purposes, I have asked Alan Dashen to work off a 15 year term. Depending on Board wishes, this can be adjusted. 5. Prepayment Period. My understanding is that the Board is interested in being able to pay-off the “mortgage” ahead of schedule. There is normally a 10 year non-prepayment period, but we will look at what options are available. If there is a penalty, we could set up some type of escrow account to pay off the loan, should fund raising run ahead of schedule. Loan Restructuring & Fund Raising Efforts Both during the Board meeting, and in several conversations since then, there have Packet Page 3 of 84 2 been concerns raised as to whether or not this move might lessen Joe and Victoria’s attention to fund raising. From my perspective, these are two separate issues. First, with respect to the construction loan, we need to move in the direction that makes the most financial sense given what we know now. Second, the Board can (and in my view should) set annual performance targets in a number of areas, including fundraising. This can take the form of the Business Plan I have spoken about, or the Strategic Plan the Kjris tried to get going. In my view, development of concrete metrics should be a collaborative effort between Joe and the Board, but at the conclusion of the process there should be firm annual targets for key activities like fund raising, performance profitability, etc. Progress on meeting these targets is discussed monthly, and forms part of the basis for evaluating how the ECA and its employees are doing. Questions & November 13 Board Meeting Should you have any questions or comments, please feel free to call/e-mail. If you have questions pertaining to the specifics of the proposed bond issue, please feel free to contact Alan Dashen at 425.452.9550 or by e-mail at alandashen@msn.com. Alan is also planning on attending the November 13 Board meeting to respond to your questions and concerns. Thanks, Dan Clements City of Edmonds 425-771-0239 Packet Page 4 of 84 AM-1253 1.B. Domestic Partner Benefits Finance Committee Meeting Date:11/14/2007 Submitted By:Debi Humann, Human Resources Time:10 Minutes Department:Human Resources Action Information Subject Domestic Partner Benefits Previous Council Action None. Narrative On July 22, 2007, Washington State's new Domestic Partner Registration Law became effective. While the Domestic Partnership Law does not require employers to provide the same employment benefits to registered domestic partners, the new law does give the opportunity for cities to choose to provide benefits. The attached ordinance changes the definition of "spouse" to not only include individuals who are married to a City employee under the laws of the State of Washington (our current policy), but allows the city to include domestic partners who are registered with the State of Washington in accordance with the provisions of Chapter 43.07 RCW. This ordinance would allow registered domestic partners (and eligible dependents) to receive benefits, if requested, under our group health insurance program. In addition, by changing the definition of "spouse" as detailed in the ordinance, employees would be able to apply sick leave, bereavement leave, and shared leave benefits to registered domestic partner relationships. This ordinance would apply to same sex registered domestic partners only. Recommendation Staff respectfully requests that Finance approve the ordinance and allow it to move forward for review and approval by full City Council. Fiscal Impact Attachments Link: Domestic Partner Benefits Ordinance Packet Page 5 of 84 {WSS593807.DOC;1/00006.900000/} - 1 - 0006.90000 WSS/gjz 6/26/07 ORDINANCE NO. _______ AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING THE PROVISIONS OF THE EDMONDS CITY CODE, SECTION 12.35.010 DEFINITIONS TO ADD A DEFINITION FOR THE TERM “SPOUSE”, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE WHEREAS, Chapter 49.60 RCW has been amended to extend the protections against discrimination to prohibit discrimination on the basis of sexual orientation; and WHEREAS, the Washington State Legislature has also enacted Chapter 43.07 RCW which provides for the registration of domestic relationships, and WHEREAS, the City Council wishes to amend the definition of “spouse” to authorize participation by registered domestic partners in the City’s shared leave policy (2.35.045) and sick leave policy (2.35.060) in accordance with the provisions of Chapter 49.60 RCW, NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO ORDAIN AS FOLLOWS: Section 1. The Edmonds City Code Section 2.35.010 is hereby amended by the addition of a new paragraph G relating to a definition for “spouse” to read as follows: 2.35.010 Definitions. … G. “Spouse.” Spouse shall mean an individual who is married to a City employee under the laws of the State of Washington, or who is in a domestic partnership which Packet Page 6 of 84 {WSS593807.DOC;1/00006.900000/} - 2 - has been registered with the State of Washington in accord with the provisions of Chapter 43.07 RCW. Section 2. Effective Date. This ordinance, being an exercise of a power specifically delegated to the City legislative body, is not subject to referendum, and shall take effect five (5) days after passage and publication of an approved summary thereof consisting of the title. APPROVED: MAYOR GARY HAAKENSON ATTEST/AUTHENTICATED: CITY CLERK, SANDRA S. CHASE APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: BY W. SCOTT SNYDER FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. Packet Page 7 of 84 {WSS593807.DOC;1/00006.900000/}- 3 - SUMMARY OF ORDINANCE NO. __________ of the City of Edmonds, Washington On the ____ day of ___________, 2007, the City Council of the City of Edmonds, passed Ordinance No. _____________. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING THE PROVISIONS OF THE EDMONDS CITY CODE, SECTION 12.35.010 DEFINITIONS TO ADD A DEFINITION FOR THE TERM “SPOUSE”, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE The full text of this Ordinance will be mailed upon request. DATED this _____ day of ________________,2007. CITY CLERK, SANDRA S. CHASE Packet Page 8 of 84 AM-1241 1.C. Donated Property Ordinance Finance Committee Meeting Date:11/14/2007 Submitted By:Kathleen Junglov, Administrative Services Time:10 Minutes Department:Administrative Services Action Information Subject Donated Property Ordinance Previous Council Action None Narrative RCW 35.21.100, which authorizes cities to accept donations of money or property, also requires acceptance of the same to be accomplished by ordinance. Because accepting donations by ordinance each and every time money or property of any value is donated to the City is impractical, it is generally accepted that the City Council may, by a standing ordinance, delegate to the Mayor the authority to accept donations up to a certain amount and the duty to administer them. Recommendation Forward attached ordinance to full council for approval. Fiscal Impact Attachments Link: Donated Property Ordinance Packet Page 9 of 84 ORDINANCE NO. _______ AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, CONCERNING DONATIONS OF PROPERTY TO THE CITY AND THE RESPONSIBILITY FOR ACCEPTANCE THEREOF; ADDING A NEW CHAPTER 3.45 TO THE EDMONDS CITY CODE; PROVIDING FOR SEVERABILITY; AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. WHEREAS, RCW 35.21.100 requires that donations to the City be accepted by ordinance; and WHEREAS, the City Council desires this ordinance to establish a procedure and means for the receipt of and the accounting for donations to the City, NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO ORDAIN AS FOLLOWS: Section 1. A new Chapter 3.45 ECC Donations of Property to City is hereby added to Title 3 of the Edmonds City Code to read as follows: Chapter 3.45 Donations of Property to City Sections: Section 3.45.010 Administration. Section 3.45.020 Use. Section 3.45.030 Acceptance. 3.45.010 Administration. The Mayor or the Mayor’s designee shall have the responsibility for the administration of all donations to the City. 3.45.020 Use. In the event a donor has indicated a desire for a particular use by the City of a donation, such donation shall, to the extent reasonably L:\Productiondb\CCOUNCIL\0007_1241_Donated Property Ordinance.DOC Packet Page 10 of 84 feasible, be used consistent with the donor’s desired use. If a donor has not specified a particular desired use, the donation may be used for any municipal purpose. 3.45.030 Acceptance. All monetary and non-monetary donations with a current value of up to $10,000 may be approved and accepted for the City by the Mayor. All donations with a value greater than $10,000 must be approved by the City Council before acceptance. The Mayor shall estimate the value of any non-monetary donation not supported by a bona fide appraisal, for purposes of compliance with this section. Section 2. Effective Date. This ordinance, being an exercise of a power specifically delegated to the City legislative body, is not subject to referendum and shall take effect five (5) days after passage and publication of an approved summary thereof consisting of the title. APPROVED: MAYOR GARY HAAKENSON ATTEST/AUTHENTICATED: CITY CLERK, SANDRA S. CHASE APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: BY W. SCOTT SNYDER FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. Page 2 of 3 Packet Page 11 of 84 SUMMARY OF ORDINANCE NO. __________ of the City of Edmonds, Washington On the ____ day of ___________, 2007, the City Council of the City of Edmonds, passed Ordinance No. _____________. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, CONCERNING DONATIONS OF PROPERTY TO THE CITY AND THE RESPONSIBILITY FOR ACCEPTANCE THEREOF; ADDING A NEW CHAPTER 3.45 TO THE EDMONDS CITY CODE; PROVIDING FOR SEVERABILITY; AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. The full text of this Ordinance will be mailed upon request. DATED this _____ day of ________________, 2007. CITY CLERK, SANDRA S. CHASE Page 3 of 3 Packet Page 12 of 84 AM-1238 1.D. 2007 Third Quarter Budget Report Finance Committee Meeting Date:11/14/2007 Submitted By:Kathleen Junglov, Administrative Services Time:10 Minutes Department:Administrative Services Information Information Subject 2007 Third Quarter Budget Report Previous Council Action None. Narrative This item transmits the 2007 Third Quarter Budget Report. Recommendation For information only, no action required. Fiscal Impact Attachments Link: 2007 Third Quarter Budget Report Packet Page 13 of 84 CITY OF EDMONDS SEPTEMBER 30, 2007 BUDGET REPORT TABLE OF CONTENTS (October 31, 2007) Overview Summary..........................2 Revenues..........................2 Expenditures....................2 On the Horizon ................3 Major Revenue Projections........4 General Fund Revenue Detail ...7 Expenditure Summary Status by Fund.................12 Status by Department.......12 Expenditure Detail by Fund General Fund ...................13 Street Fund.......................14 Street Construction..........14 Multi-Modal.....................14 Building Maintenance......15 Municipal Arts.................15 Hotel/Motel......................15 Employee Parking............15 Tourism Promotion..........16 Park Improve (REET 2).......16 Park Capital (REET 1).......16 Gifts Catalog....................17 Cemetery Maintenance....17 Parks Construction ..........17 Combined Utility .............18 Equipment Rental.............19 Expenditure Detail by Department City Council.....................20 Mayor...............................20 Human Resources............20 Municipal Court...............21 Economic Development...21 City Clerk.........................21 Administrative Services...22 City Attorney ...................22 Non-Departmental............22 Police Department............23 Fire Department...............24 Community Services........24 Development Services .....25 Parks & Recreation..........25 Public Works....................26 Facilities...........................26 Storm Drainage................27 Water................................28 Sewer................................29 Treatment Plant................30 Capital Improvement Project Status 31 L:\Productiondb\CCOUNCIL\0009_1238_2007 Q3 Report.doc Packet Page 14 of 84 SEPTEMBER 30, 2007 BUDGET REPORT CITY OF EDMONDS 2007 THIRD QUARTER BUDGET REPORT This report will provide preliminary information regarding the City of Edmonds’ financial operations for the quarter ending September 30, 2007. Information for October has been included when available. Revenue Variances Sales tax revenue for the first half of the year was $4 million or 75.8% of budget. Our forecasting model which includes October 2007 receipts, and takes into account the seasonality of collections, is forecasting sales tax for the year to come in $100,000 over budget. Sales tax receipts through October 2007 exceed sales tax receipts through the same period in 2006 by about $125,000. Our top three performers contribute to this increase as follows: receipts from Motor Vehicle and Parts Dealers (29.9%) are up $40,000, receipts from Food Services/Drinking Places (10%) are up $34,000, and receipts from Specialty Trade Contractors (8.3%) increased by $6,000. Specialty Trade Contractors replaced Construction of Buildings (8.1%) as the number three source of sales tax revenue. Due to the cold winter, Natural Gas Utility and Electric Utility taxes are at 81.7% and 80.7% respectively of budget. Again, at this time our forecasting model is predicting that the Natural Gas Utility tax will exceed budget by $178,000, and the Electric Utility tax will come in $29,000 over budget. Leasehold Excise tax receipts are currently at 101.4% of budget with another $60,000 anticipated before year end. This is primarily due to the Port of Edmonds purchase of properties at Harbor Square. Building permit fees, zoning and subdivision fees, along with plan check fees are at 90.7%, 96.7%, and 111.9% of budget. Input from our Development Services Department is that they are seeing a slowing of permit activity however; they expect construction related receipts to exceed budget estimates collectively by about $72,000. Adult Probation Services receipts estimated to come in approximately $50,000 under budget. The Court has indicated that this is the result of shifting probation services from third degree driving with a suspended license to those convicted of more serious crimes. It appears the budget estimate for these services may have been too optimistic. Also, revenues for Electronic Monitoring lagging behind budget estimates as fewer defendants elect this option. Real Estate Excise Tax (REET) receipts for the ten month period ending October were $1,176,000, and for the first time our forecasting model is pointing towards REET receipts for the year of $1,371,000 coming in under the budget estimate by $29,000. This forecast is significantly down from the high of $1.78 million or $382,000 over budget forecasted at the end of March. Departmental and Fund Variances No Departments or Funds are in danger of exceeding budget. The Final 2007 amending ordinance this report on the Finance committee agenda. Page 2 Packet Page 15 of 84 SEPTEMBER 30, 2007 BUDGET REPORT On the Horizon The City finished 2006 in a stronger position than anticipated; however, Finance still remains cautious about the City’s financial future. Major items on the horizon are: • Labor negotiations with all of the City’s bargaining units • Discussion of legislation at the State level that would enhance public safety benefits • Continued development the City’s Broadband initiative • Passage of an Emergency Services Levy in 2008 to take effect in 2009 • Review of business practices to reduce General Fund expenditures by $500,000 by 2009 - July, 2007 Page 3 Packet Page 16 of 84 SEPTEMBER 30, 2007 BUDGET REPORT 2007 BUDGET 1,400,000 TOTAL JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Monthly Forecast % 6.57% 5.05% 6.50% 8.13% 8.25% 9.33% 12.01% 9.30% 10.62% 10.02% 7.51% 6.71% Cumulative Forecast % 6.57% 11.63% 18.13% 26.26% 34.51% 43.83% 55.85% 65.15% 75.77% 85.78% 93.29% 100.00% Monthly Forecast $ 92,044 70,739 91,068 113,778 115,445 130,597 168,167 130,267 148,643 140,212 105,070 93,970 Cumulative Forecast $ 92,044 162,783 253,851 367,630 483,075 613,672 781,839 912,106 1,060,748 1,200,960 1,306,030 1,400,000 Actual Collected $ 103,851 97,636 121,587 116,516 80,661 180,433 137,954 123,798 146,050 67,700 Cumulative Collection $ 103,851 201,487 323,074 439,590 520,252 700,684 838,638 962,436 1,108,486 1,176,186 YEAR END FORECAST 1,579,578 1,732,865 1,781,767 1,674,039 1,507,742 1,598,506 1,501,707 1,477,252 1,463,005 1,371,121 Projected YE Variance 179,578 332,865 381,767 274,039 107,742 198,506 101,707 77,252 63,005 (28,879) Budget Variance % 12.83% 23.78% 27.27% 19.57% 7.70% 14.18% 7.26% 5.52% 4.50% -2.06% REAL ESTATE EXCISE TAX 2007 CUMULATIVE COLLECTIONS - 250,000 500,000 750,000 1,000,000 1,250,000 1,500,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Actual Budget 2007 BUDGET 5,346,267 TOTAL JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Monthly Forecast % 8.06% 9.92% 7.25% 6.73% 8.74% 7.68% 8.09% 9.18% 8.32% 8.54% 9.28% 8.20% Cumulative Forecast % 8.06% 17.99% 25.24% 31.97% 40.71% 48.39% 56.48% 65.66% 73.98% 82.52% 91.80% 100.00% Monthly Forecast $ 430,995 530,552 387,673 360,020 467,343 410,680 432,422 490,903 444,645 456,722 496,036 438,275 Cumulative Forecast $ 430,995 961,547 1,349,220 1,709,239 2,176,582 2,587,263 3,019,685 3,510,588 3,955,233 4,411,956 4,907,992 5,346,267 Actual Collected $ 417,105 556,132 361,112 407,876 484,916 428,837 432,932 512,889 452,157 446,310 Cumulative Collection $ 417,105 973,237 1,334,349 1,742,225 2,227,141 2,655,978 3,088,910 3,601,799 4,053,956 4,500,266 YEAR END FORECAST 5,173,969 5,411,264 5,287,342 5,449,441 5,470,452 5,488,258 5,468,827 5,485,172 5,479,709 5,453,278 Projected YE Variance (172,298) 64,997 (58,925) 103,174 124,185 141,991 122,560 138,905 133,442 107,011 Budget Variance % -3.22% 1.22% -1.10% 1.93% 2.32% 2.66% 2.29% 2.60% 2.50% 2.00% SALES AND USE TAX 2007 CUMULATIVE COLLECTIONS - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Actual Budget Page 4 Packet Page 17 of 84 SEPTEMBER 30, 2007 BUDGET REPORT 2007 BUDGET 762,700 TOTAL JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Monthly Forecast % 13.54% 14.04% 12.93% 11.03% 8.69% 5.86% 4.62% 3.40% 3.18% 3.99% 6.21% 12.50% Cumulative Forecast % 13.54% 27.58% 40.51% 51.54% 60.24% 66.10% 70.73% 74.13% 77.31% 81.29% 87.50% 100.00% Monthly Forecast $ 103,296 107,054 98,645 84,126 66,316 44,731 35,266 25,962 24,216 30,413 47,365 95,310 Cumulative Forecast $ 103,296 210,350 308,995 393,121 459,437 504,168 539,434 565,396 589,612 620,025 667,390 762,700 Actual Collected $ 123,405 146,567 112,487 100,835 80,144 59,834 41,915 31,358 30,236 Cumulative Collection $ 123,405 269,972 382,459 483,293 563,438 623,272 665,187 696,545 726,781 YEAR END FORECAST 911,178 978,878 944,031 937,645 935,349 942,879 940,501 939,616 940,137 Projected YE Variance 148,478 216,178 181,331 174,945 172,649 180,179 177,801 176,916 177,437 Budget Variance % 19.47% 28.34% 23.77% 22.94% 22.64% 23.62% 23.31% 23.20% 23.26% GAS UTILITY TAX 2007 CUMULATIVE COLLECTIONS - 200,000 400,000 600,000 800,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Actual Budget 2007 BUDGET 1,367,500 TOTAL JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Monthly Forecast % 7.82% 6.59% 9.89% 8.55% 8.27% 8.19% 8.59% 8.29% 8.35% 7.90% 8.02% 9.54% Cumulative Forecast % 7.82% 14.42% 24.31% 32.85% 41.12% 49.32% 57.91% 66.20% 74.55% 82.44% 90.46% 100.00% Monthly Forecast $ 106,982 90,152 135,244 116,877 113,116 112,046 117,442 113,428 114,140 107,997 109,637 130,438 Cumulative Forecast $ 106,982 197,135 332,379 449,256 562,372 674,417 791,860 905,288 1,019,428 1,127,425 1,237,062 1,367,500 Actual Collected $ 63,588 120,817 140,001 54,929 160,817 53,852 159,448 106,128 110,635 Cumulative Collection $ 63,588 184,405 324,407 379,335 540,152 594,004 753,452 859,580 970,215 YEAR END FORECAST 812,816 1,279,199 1,334,699 1,154,667 1,313,470 1,204,448 1,301,172 1,298,455 1,301,484 Projected YE Variance (554,684) (88,301) (32,801) (212,833) (54,030) (163,052) (66,328) (69,045) (66,016) Budget Variance % -40.56% -6.46% -2.40% -15.56% -3.95% -11.92% -4.85% -5.05% -4.83% TELEPHONE UTILITY TAX 2007 CUMULATIVE COLLECTIONS - 250,000 500,000 750,000 1,000,000 1,250,000 1,500,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Actual Budget Page 5 Packet Page 18 of 84 SEPTEMBER 30, 2007 BUDGET REPORT 2007 BUDGET 1,385,000 TOTAL JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Monthly Forecast % 10.22% 11.41% 9.76% 10.88% 9.15% 7.78% 6.93% 6.69% 6.27% 6.50% 7.05% 7.36% Cumulative Forecast % 10.22% 21.63% 31.40% 42.27% 51.42% 59.20% 66.13% 72.82% 79.09% 85.59% 92.64% 100.00% Monthly Forecast $ 141,595 157,988 135,243 150,629 126,664 107,768 95,960 92,711 86,805 90,064 97,644 101,929 Cumulative Forecast $ 141,595 299,583 434,826 585,455 712,119 819,887 915,847 1,008,558 1,095,363 1,185,427 1,283,071 1,385,000 Actual Collected $ 121,717 191,261 141,619 148,822 121,283 115,855 97,060 86,783 93,706 Cumulative Collection $ 121,717 312,978 454,596 603,419 724,701 840,556 937,617 1,024,400 1,118,106 YEAR END FORECAST 1,190,565 1,446,924 1,447,973 1,427,496 1,409,471 1,419,915 1,417,921 1,406,754 1,413,756 Projected YE Variance (194,435) 61,924 62,973 42,496 24,471 34,915 32,921 21,754 28,756 Budget Variance % -14.04% 4.47% 4.55% 3.07% 1.77% 2.52% 2.38% 1.57% 2.08% ELECTRIC UTILITY TAX 2007 CUMULATIVE COLLECTIONS - 250,000 500,000 750,000 1,000,000 1,250,000 1,500,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Actual Budget Page 6 Packet Page 19 of 84 SEPTEMBER 30, 2007 BUDGET REPORT GENERAL FUND REVENUES Title Budget 9/30/2007 Revenues Balance % Received BEGINNING FUND BALANCE 3,551,329 4,243,355 (692,026) 119.5% REAL PERSONAL / PROPERTY TAX 8,873,000 4,750,462 4,122,538 53.5% EMS PROPERTY TAX 2,400,000 1,284,135 1,115,865 53.5% VOTED PROPERTY TAX 787,348 421,854 365,494 53.6% LOCAL RETAIL SALES/USE TAX 5,346,267 4,053,941 1,292,326 75.8% NATURAL GAS USE TAX 15,750 12,860 2,890 81.7% 1/10 SALES TAX LOCAL CRIM JUST 590,760 492,172 98,588 83.3% GAS UTILITY TAX 762,700 726,781 35,919 95.3% TELEPHONE UTILITY TAX 1,367,500 913,298 454,202 66.8% ELECTRIC UTILITY TAX 1,385,000 1,118,106 266,894 80.7% SOLID WASTE UTILITY TAX 260,000 200,514 59,486 77.1% WATER UTILITY TAX 197,300 163,701 33,599 83.0% SEWER UTILITY TAX 275,000 203,190 71,810 73.9% STORMWATER UTILITY TAX 104,500 89,807 14,693 85.9% LEASEHOLD EXCISE TAX 178,500 180,933 (2,433) 101.4% PULLTABS TAX 54,500 33,978 20,522 62.3% AMUSEMENT GAMES 500 366 134 73.3% PENALTIES ON GAMBLING TAXES 500 0 500 0.0% TOTAL TAXES 22,599,125 14,646,097 7,953,028 64.81% FIRE PERMITS-SPECIAL USE 5,000 4,530 470 90.6% PROF AND OCCUPATION LICENSE 1,000 330 670 33.0% AMUSEMENTS 5,000 6,550 (1,550) 131.0% BUS. LICENCE PERMIT PENALTY 1,800 2,368 (568) 131.5% GENERAL BUSINESS LICENSE 56,000 54,371 1,630 97.1% FRANCHISE AGREEMENTS 536,490 430,872 105,618 80.3% OLY VIEW WATER DIST FRANCHISE 115,500 89,453 26,048 77.4% DEV SERV PERMIT SURCHARGE 21,000 17,565 3,435 83.6% NON RESIDENT BUS LICENSE 22,000 15,000 7,000 68.2% RIGHT OF WAY FRANCHISE FEE 2,000 5,000 (3,000) 250.0% BUILDING STRUCTURE PERMITS 650,000 589,750 60,250 90.7% ANIMAL LICENSES 15,000 6,339 8,661 42.3% STREET AND CURB PERMIT 105,370 5,910 99,460 5.6% OTHER/NON-BUS/LIC/PERMIT 5,000 4,864 137 97.3% TOTAL LICENSES AND PERMITS 1,541,160 1,232,900 308,260 80.00% Page 7 Packet Page 20 of 84 SEPTEMBER 30, 2007 BUDGET REPORT GENERAL FUND REVENUES Title Budget 9/30/2007 Revenues Balance % Received US Dept of Justice Grant 2,000 0 2,000 0.0% DOJ 15-0404-01-754 2006 BPV 0 7,425 (7,425) - WA ASSOC OF SHERRIFFS TRAFFIC GRANT 1,500 5,418 (3,918) 361.2% WTSC-CLICK IT OR TICKET 0 0 0 - WTSC-DUI TRAFFIC SAFETY 0 2,302 (2,302) - WTSC-HIGHWAY SAFETY 7,046 14,897 (7,851) 211.4% WTSC-NIGHTTIME SEATBELT 2,600 2,600 0 100.0% Federal WA State Traffic Comm Grant 8,000 0 8,000 0.0% SHSGP #E05-071 FIRE RESCUE BOAT 9,000 9,000 0 100.0% E07943 P#17 PW#242 2006 STORM ASST. 0 8,032 (8,032) - HAZARD MITIGATION GRANT FEMA #E06-218 0 60,479 (60,479) - WSP-DRUG RECOGNITION EXPERT OT 0 265 (265) - WA STATE TRAFFIC COMM GRANT 2,000 2,829 (829) 141.4% DOE SHORELINE MASTER PROG G0600108 40,000 48,023 (8,023) 120.1% WA STATE TRAUMA GRANT 1,290 0 1,290 0.0% GROWTH MGT INCENTIVE GRANT 0 0 0 - WA ST DEPT OF HEALTH GRANT 1,439 1,439 0 100.0% PUD PRIVILEDGE TAX 185,000 171,057 13,943 92.5% JUDICIAL SALARY CONTRIBUTION-STATE 5,600 3,886 1,714 69.4% MVET/SPECIAL DISTRIBUTION 7,236 5,916 1,320 81.8% CRIMINAL JUSTICE - SPECIAL PROGRAMS 30,445 23,139 7,306 76.0% DUI - CITIES 8,794 7,459 1,335 84.8% LIQUOR EXCISE TAX 171,053 135,054 35,999 79.0% LIQUOR BOARD PROFITS 298,041 226,543 71,498 76.0% SHARED COURT COSTS 5,000 2,500 2,500 50.0% POLICE FBI CONTRACTS 6,100 10,001 (3,901) 164.0% DV COORDINATOR SERVICES 0 2,115 (2,115) - FIRE PROTECTION - WOODWAY 318,438 318,438 0 100.0% FIRE PROTECTION - DISTRICT #1 221,763 221,763 0 100.0% CAMPUS SAFETY-EDM. SCH. DIST. 39,875 22,795 17,080 57.2% WOODWAY - LAW PROTECTION 6,500 4,776 1,724 73.5% CITY OF MTLK TERR-ANIMAL CONTR 31,000 23,061 7,939 74.4% SNOCOM/DIRECTOR SERVICES 142,000 96,928 45,072 68.3% OTHER BEACH RANGER SUBSIDY 1,000 0 1,000 0.0% SNO-ISLE 54,000 45,955 8,045 85.1% TOTAL INTERGOVERNMENTAL REVENUE 1,606,720 1,484,095 122,625 92.37% Page 8 Packet Page 21 of 84 SEPTEMBER 30, 2007 BUDGET REPORT GENERAL FUND REVENUES Title Budget 9/30/2007 Revenues Balance % Received RECORD/LEGAL INSTRUMTS 1,500 1,591 (91) 106.1% COURT RECORD SERVICES 400 802 (402) 200.4% COURT-OTHER CERT/CC FEE 0 3 (3) - SALE MAPS & BOOKS 1,000 2,799 (1,799) 279.9% MUNIC.-DIST. COURT CURR EXPEN 0 204 (204) - PHOTOCOPIES 0 5,153 (5,153) - POLICE DISCLOSURE REQUESTS 0 5,799 (5,799) - ASSESSMENT SEARCH 0 30 (30) - BIRD FEST MERCHANDISE-WHOLESALE 0 79 (79) - PASSPORTS AND NATURALIZATION FEES 30,000 34,950 (4,950) 116.5% POLICE SERVICES SPECIAL EVENTS 30,600 20,826 9,774 68.1% ADULT PROBATION SERVICE CHARGE 150,000 66,289 83,711 44.2% ELECTRONIC MONITORING 33,000 12,410 20,590 37.6% ELECTRONIC MONITOR DUI 8,000 3,940 4,060 49.3% BOOKING FEES 4,000 4,846 (846) 121.1% FIRE CONSTRUCTION INSPECTION FEES 14,000 10,175 3,825 72.7% EMERGENCY SERVICE FEES 0 8,223 (8,223) - EMERGENCY SERVICE FEES-HAZMAT 500 0 500 0.0% DUI EMERGENCY AID 0 29 (29) - POLICE - FINGERPRINTING 500 295 205 59.0% CRIM CONV FEES CT 2,100 4,046 (1,946) 192.7% CRIM CONV FEES CN 1,600 2,095 (495) 130.9% POLICE TRAINING CLASSES 250 915 (665) 366.0% ENGINEERING FEES AND CHARGES 121,170 100,027 21,143 82.6% STORM DRAINAGE FEES 900 0 900 0.0% AMIMAL CONTROL SHELTER 7,500 7,901 (401) 105.3% ZONING/SUBDIVISION FEE 110,000 106,420 3,581 96.7% FIRE PLAN CHECK FEES 9,000 8,210 790 91.2% PLAN CHECKING FEES 400,000 447,487 (47,487) 111.9% PLANNING 1% INSPECTION FEE 0 2,020 (2,020) - CERT/PHOTO/RECORD SEARCH FEE 12,000 0 12,000 0.0% S.E.P.A. REVIEW 13,000 10,920 2,080 84.0% SHORELINE PERMIT 500 0 500 0.0% CRITICAL AREA STUDY 20,000 17,955 2,045 89.8% SWIM POOL ENTRANCE FEES 63,000 50,646 12,354 80.4% LOCKER FEES 1,000 489 511 48.9% SWIM CLASS FEES 56,000 62,329 (6,329) 111.3% PROGRAM FEES 695,250 603,725 91,525 86.8% TAXABLE RECREATION ACTIVITIES 0 3,982 (3,982) - BIRD FEST REGISTRATION FEES 0 565 (565) - INTERFUND REIMB. CONTRACT SVCS 1,178,888 837,553 341,335 71.0% MISCELLANEOUS POLICE SERVICES 0 189 (189) - TOTAL CHARGES FOR SERVICES 2,965,658 2,445,915 519,743 82.47% Page 9 Packet Page 22 of 84 SEPTEMBER 30, 2007 BUDGET REPORT GENERAL FUND REVENUES Title Budget 9/30/2007 Revenues Balance % Received PROOF OF VEHICLE INS PENALTY 4,400 2,899 1,501 65.9% TRAFFIC INFRACTION PENALTIES 44,000 43,200 800 98.2% BC TRAFFIC INFRACTION 190,000 121,327 68,673 63.9% NON-TRAFFIC INFRACTION PENALTIES 1,600 12,595 (10,995) 787.2% OTHER INFRACTIONS '04 0 818 (818) - PARKING INFRACTION PENALTIES 50,000 20,984 29,016 42.0% PR - HANDICAPPED 3,000 3,931 (931) 131.0% PARKING INFRACTION LC 300 160 140 53.3% DWI PENALTIES 4,500 4,398 102 97.7% OTHER CRIMINAL TRAF MISDEM PEN 2,500 841 1,659 33.6% CRIMINAL TRAFFIC MISDEMEANOR 8/03 10,000 23,125 (13,125) 231.3% OTHER NON-TRAF MISDEMEANOR PEN 1,000 3,877 (2,877) 387.7% OTHER NON TRAFFIC MISD. 8/03 8,000 6,797 1,203 85.0% COURT DV PENALTY ASSMT 0 1,198 (1,198) - CRIMINAL COSTS-RECOUPMENTS 120,000 93,780 26,220 78.1% JURY DEMAND COST 0 351 (351) - PUBLIC DEFENSE RECOUPMENT 20,000 21,428 (1,428) 107.1% COURT INTERPRETER COST 1,000 796 204 79.6% MISC FINES AND PENALTIES 20,000 17,160 2,840 85.8% TOTAL FINES AND FORFEITURES 480,300 379,666 100,634 79.05% INVESTMENT INTEREST 170,000 226,853 (56,853) 133.4% INTEREST ON COUNTY TAXES 25,000 30,340 (5,340) 121.4% INTEREST - COURT COLLECTIONS 2,000 2,912 (912) 145.6% PARKING 4,000 2,800 1,200 70.0% SPACE & FACILITIES RENTALS 125,700 107,374 18,326 85.4% GYM & WEIGHTROOM FEES 13,200 8,111 5,089 61.4% BRACKET ROOM RENTAL 0 150 (150) - LEASES LONG-TERM 124,410 112,875 11,535 90.7% VENDING MACHINE CONCESSION 2,400 1,847 553 76.9% OTHER RENTS & USE CHARGES 14,000 13,239 762 94.6% DONATION / CONTRIBUTION 0 50 (50) - PARKS DONATIONS 8,315 8,515 (200) 102.4% POLICE CONT FROM PRIVATE SOURCES 44,202 39,202 5,000 88.7% BIRDFEST CONTRIBUTION 2,000 3,034 (1,034) 151.7% CONTRIBUTIONS - HISTORIC PRESERVATION 1,000 0 1,000 0.0% SALE OF JUNK/SALVAGE 500 167 333 33.3% SALES OF UNCLAIM PROPERTY 5,000 1,229 3,771 24.6% CONFISCATED AND FORFEITED PROPERTY 1,500 4,469 (2,969) 297.9% OTHER JUDGEMENT/SETTLEMENT 0 (1) 1 - CASHIER OVERAGE/SHORTAGE 0 (25) 25 - OTHER MISC REVENUES 10,000 24,486 (14,486) 244.9% NSF FEES - PARKS 0 240 (240) - NSF FEES - MUNI CT 200 346 (146) 173.0% NSF FEES - POLICE 0 30 (30) PLANNING SIGNAGE REVENUE 6,000 600 5,400 10.0% TOTAL MISCELLANEOUS REVENUE 559,427 588,842 (29,415) 105.26% Page 10 Packet Page 23 of 84 SEPTEMBER 30, 2007 BUDGET REPORT GENERAL FUND REVENUES Title Budget 9/30/2007 Revenues Balance % Received PROCEEDS FROM LONG TERM DEBT 640,819 640,819 0 100.0% TRANSFER FROM FUND 121 19,475 8,500 10,975 43.6% TRANSFER FROM FUND 511 39,213 0 39,213 0.0% TOTAL TRANSFERS 699,507 649,319 50,188 92.83% TOTAL GENERAL FUND REVENUE 34,003,226 25,670,189 8,333,037 75.49% Page 11 Packet Page 24 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE SUMMARIES Page 12 BUDGET SUMMARY BY FUND # Title Appropriation 09/30/07 Expenditures Balance % Used All Funds 76,357,579 42,999,894 33,357,685 56.3% 001 General Fund 32,929,566 22,973,602 9,955,964 69.8% 111 Street Fund 1,343,834 941,625 402,209 70.1% 112 Street Const./Imprv. 2,246,699 1,003,321 1,243,378 44.7% 113 Multimodal Transportation 625,000 0 625,000 0.0% 116 Building Maintenance 1,729,510 245,208 1,484,302 14.2% 117 Municipal Arts Acquisition Fund 103,250 16,482 86,768 16.0% 120 Hotel/Motel Tax Fund 66,625 14,305 52,320 21.5% 121 Employee Parking Permit Fund 18,000 8,500 9,500 47.2% 123 Tourism Promotional Fund/Arts 21,800 10,929 10,871 50.1% 125 Real Estate Excise Tax 2 4,508,200 1,643,565 2,864,635 36.5% 126 Park Acquisition (REET 1) 901,715 134,323 767,392 14.9% 127 Gifts Catalog Fund 12,866 8,578 4,288 66.7% 130 Cemetery Maintenance 180,559 113,048 67,511 62.6% 132 Park Construction Fund 420,000 341,489 78,511 81.3% 411 Combined Utility Operation 15,425,653 9,930,565 5,495,088 64.4% 511 Equipment Rental Fund 2,640,299 1,534,314 1,105,985 58.1% BUDGET SUMMARY BY DEPARTMENT # Title Budget 9/30/07 Expenditures Balance % Used 110 City Council 294,605 174,883 119,722 59.4% 210 Office of Mayor 226,008 163,809 62,199 72.5% 220 Human Resources 232,365 177,229 55,136 76.3% 230 Municipal Court 663,011 484,001 179,010 73.0% 240 Economic Development 163,476 43,106 120,370 26.4% 250 City Clerk 523,626 381,827 141,799 72.9% 310 Administrative Services 1,346,660 1,093,028 253,632 81.2% 360 City Attorney 448,300 311,060 137,240 69.4% 390 Non-Departmental Expenses 4,669,319 2,584,870 2,084,449 55.4% 410 Police Services 9,353,013 6,739,477 2,613,536 72.1% 510 Fire Services 7,051,309 5,136,578 1,914,731 72.8% 610 Community Services 328,359 239,103 89,256 72.8% 620 Development Services 3,035,559 2,088,196 947,363 68.8% 640 Parks & Recreation 3,000,671 2,251,594 749,077 75.0% 650 Public Works 275,212 215,762 59,450 78.4% 651 Facilities Maintenance 1,318,073 889,076 428,997 67.5% 652 Storm Drainage 3,608,008 2,900,745 707,263 80.4% 654 Water 4,360,999 2,877,209 1,483,790 66.0% 655 Sewer 3,491,690 2,127,548 1,364,142 60.9% 656 Treatment Plant 3,964,956 2,025,064 1,939,892 51.1% Packet Page 25 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY FUND Page 13 001 GENERAL FUND # Title Appropriation 09/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 15,734,573 11,323,603 4,410,970 72.0% 120 OVERTIME 682,372 831,923 (149,551) 121.9% 150 HOLIDAY BUY BACK 335,835 4,567 331,268 1.4% 230 BENEFITS 5,106,587 3,538,494 1,568,093 69.3% 240 UNIFORMS 120,940 79,697 41,243 65.9% 250 PROTECTIVE CLOTHING 17,290 18,293 (1,003) 105.8% 310 SUPPLIES 505,324 326,802 178,522 64.7% 320 FUEL CONSUMED 1,700 509 1,191 29.9% 350 SMALL EQUIPMENT 295,407 272,253 23,154 92.2% 410 PROFESSIONAL SERVICES 1,686,161 1,168,535 517,626 69.3% 420 COMMUNICATIONS 240,312 154,788 85,524 64.4% 430 TRAVEL 80,580 27,455 53,125 34.1% 440 ADVERTISING 45,290 28,930 16,360 63.9% 450 RENTAL/LEASE 139,240 94,749 44,491 68.0% 460 INSURANCE 426,000 428,516 (2,516) 100.6% 470 UTILITIES 452,750 294,681 158,069 65.1% 480 REPAIRS & MAINTENANCE 195,580 152,786 42,794 78.1% 490 MISCELLANEOUS 342,705 164,848 177,857 48.1% 510 INTERGOVTL SERVICES 1,812,052 1,394,246 417,806 76.9% 530 EXCISE TAXES 5,000 3,808 1,192 76.2% 550 INTERFUND TRANSFER 1,551,731 774,966 776,765 49.9% 630 OTHER IMPROVEMENTS 3,000 0 3,000 0.0% 640 MACHINERY/EQUIPMENT 142,018 169,529 (27,511) 119.4% 650 CONSTRUCTION PROJECTS 0 6,618 (6,618) - 710 BOND PRINCIPAL 1,426,264 626,108 800,156 43.9% 750 BOND PRINCIPAL 60,304 60,304 0 100.0% 790 BOND PRINCIPAL 20,235 10,118 10,117 50.0% 810 INTEREST ON ST DEBT 0 0 0 - 830 INTEREST ON LT DEBT 470,313 236,995 233,318 50.4% 840 DEBT ISSUE COSTS 14,711 11,420 3,291 77.6% 890 FISCAL AGENT FEES 1,500 898 602 59.9% 910 INTERFUND SERVICES 0 854 (854) - 920 INTERFUND FUEL 32,731 37,076 (4,345) 113.3% 930 INTERFUND SUPPLIES 40,184 38,539 1,645 95.9% 950 INTERFUND RENTAL 849,246 637,481 211,765 75.1% 980 INTERFUND REPAIRS 91,631 53,214 38,417 58.1% TOTAL GENERAL FUND 32,929,566 22,973,602 9,955,964 69.8% Packet Page 26 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY FUND Page 14 111 STREET FUND # Title Appropriation 09/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 427,663 354,553 73,110 82.9% 120 OVERTIME 9,789 7,478 2,311 76.4% 230 BENEFITS 163,496 125,409 38,087 76.7% 240 UNIFORMS 7,100 4,915 2,185 69.2% 310 SUPPLIES 155,900 110,953 44,947 71.2% 350 SMALL EQUIPMENT 1,200 0 1,200 0.0% 410 PROFESSIONAL SERVICES 36,000 3,453 32,547 9.6% 420 COMMUNICATIONS 4,000 1,489 2,511 37.2% 430 TRAVEL 3,380 268 3,112 7.9% 450 RENTAL/LEASE 2,500 1,035 1,465 41.4% 460 INSURANCE 33,536 33,688 (152) 100.5% 470 UTILITIES 254,250 166,565 87,685 65.5% 480 REPAIRS & MAINTENANCE 19,300 2,490 16,810 12.9% 490 MISCELLANEOUS 12,660 2,376 10,284 18.8% 510 INTERGOVTL SERVICES 16,000 5,325 10,675 33.3% 710 BOND PRINCIPAL 31,061 0 31,061 0.0% 830 BOND INTEREST 12,483 5,857 6,626 46.9% 840 DEBT ISSUE COSTS 0 613 (613) - 890 FISCAL AGENT FEES 0 21 (21) - 950 INTERFUND RENTAL 153,516 115,137 38,379 75.0% TOTAL STREET FUND 1,343,834 941,625 402,209 70.1% 112 STREET CONST/IMPRV FD # Title Appropriation 09/30/07 Expenditures Balance % Used 410 PROFESSIONAL SERVICES 20,000 0 20,000 0.0% 550 INTERFUND TRANSFER 0 0 0 - 650 CONSTRUCTION PROJECTS 2,181,000 958,402 1,222,598 43.9% 790 LOAN PRINCIPAL 38,143 38,143 (0) 100.0% 830 LOAN INTEREST 3,251 3,906 (655) 120.1% 950 INTERFUND RENTAL 4,305 2,870 1,435 66.7% TOTAL STREET CONST/IMPRV FD 2,246,699 1,003,321 1,243,378 44.7% 113 MULTIMODAL TRANS FD # Title Appropriation 09/30/07 Expenditures Balance % Used 410 PROFESSIONAL SERVICES 625,000 0 625,000 0.0% TOTAL MULTIMODAL TRANS FD 625,000 0 625,000 0.0% Packet Page 27 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY FUND Page 15 116 BUILDING MAINT FUND # Title Appropriation 09/30/07 Expenditures Balance % Used 310 SUPPLIES 25,000 129 24,871 0.5% 410 PROFESSIONAL SERVICES 15,000 17,257 (2,257) 115.0% 480 REPAIRS & MAINTENANCE 100,000 8,549 91,451 8.5% 550 INTERFUND TRANSFER 0 25 (25) - 650 CONSTRUCTION PROJECTS 1,581,391 215,063 1,366,328 13.6% 840 DEBT ISSUE COSTS 8,119 4,185 3,934 51.5% TOTAL BUILDING MAINT FUND 1,729,510 245,208 1,484,302 14.2% 117 MUNI ARTS ACQ FUND # Title Appropriation 09/30/07 Expenditures Balance % Used 310 SUPPLIES 3,200 440 2,760 13.8% 350 SMALL EQUIPMENT 600 0 600 0.0% 410 PROFESSIONAL SERVICES 82,200 9,836 72,364 12.0% 440 ADVERTISING 4,000 4,100 (100) 102.5% 450 RENTAL/LEASE 1,000 0 1,000 0.0% 480 REPAIRS & MAINTENANCE 300 0 300 0.0% 490 MISCELLANEOUS 8,950 2,105 6,845 23.5% 550 INTERFUND TRANSFER 3,000 0 3,000 0.0% TOTAL MUNI ARTS ACQ FUND 103,250 16,482 86,768 16.0% 120 HOTEL/MOTEL TAX FUND # Title Appropriation 09/30/07 Expenditures Balance % Used 410 PROFESSIONAL SERVICES 47,190 3,564 43,626 7.6% 440 ADVERTISING 0 3,382 (3,382) - 490 MISCELLANEOUS 0 0 0 - 550 INTERFUND TRANSFER 19,435 7,360 12,075 37.9% TOTAL HOTEL/MOTEL TAX FUND 66,625 14,305 52,320 21.5% 121 EMPLOYEE PKG PERMIT FD # Title Appropriation 09/30/07 Expenditures Balance % Used 310 SUPPLIES 1,000 0 1,000 0.0% 550 INTERFUND TRANSFER 17,000 8,500 8,500 50.0% TOTAL EMPLOYEE PKG PERMIT FD 18,000 8,500 9,500 47.2% Packet Page 28 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY FUND Page 16 123 TOURISM PROMOTIONAL # Title Appropriation 09/30/07 Expenditures Balance % Used 310 SUPPLIES 300 0 300 0.0% 410 PROFESSIONAL SERVICES 10,500 5,142 5,358 49.0% 440 ADVERTISING 2,500 506 1,994 20.2% 490 MISCELLANEOUS 8,500 5,281 3,219 62.1% TOTAL TOURISM PROMOTIONAL 21,800 10,929 10,871 50.1% 125 REAL ESTATE EXCISE TAX 2 # Title Appropriation 09/30/07 Expenditures Balance % Used 310 SUPPLIES 0 2,455 (2,455) - 410 PROFESSIONAL SERVICES 0 0 0 - 550 INTERFUND TRANSFER 886,200 236,821 649,379 26.7% 650 CONSTRUCTION PROJECTS 3,622,000 1,404,288 2,217,712 38.8% TOTAL REAL ESTATE EXCISE TAX 2 4,508,200 1,643,565 2,864,635 36.5% 126 PARKS ACQUISITION (REET 1) # Title Appropriation 09/30/07 Expenditures Balance % Used 410 PROFESSIONAL SERVICES 0 4,500 (4,500) - 490 MISCELLANOUS 0 304 (304) - 550 INTERFUND TRANSFER 68,911 19,456 49,455 28.2% 610 LAND 210,000 0 210,000 0.0% 710 BOND PRINCIPAL 405,248 0 405,248 0.0% 830 BOND INTEREST 216,356 105,968 110,388 49.0% 840 DEBT ISSUE COSTS 0 3,569 (3,569) - 890 FISCAL AGENT FEES 1,200 527 673 43.9% TOTAL PARKS ACQUISITION (REET 1) 901,715 134,323 767,392 14.9% Packet Page 29 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY FUND Page 17 127 GIFTS CATALOG # Title Appropriation 09/30/07 Expenditures Balance % Used 310 SUPPLIES 9,366 8,578 788 91.6% 410 PROFESSIONAL SERVICES 3,000 0 3,000 0.0% 490 MISCELLANEOUS 500 0 500 0.0% TOTAL GIFTS CATALOG 12,866 8,578 4,288 66.7% 130 CEMETERY MAINTENANCE # Title Appropriation 09/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 58,111 43,729 14,382 75.3% 120 OVERTIME 2,050 1,791 259 87.4% 230 BENEFITS 24,953 17,522 7,431 70.2% 240 UNIFORMS 1,000 0 1,000 0.0% 310 SUPPLIES 7,000 2,864 4,136 40.9% 340 RESALE ITEMS 20,000 14,380 5,620 71.9% 350 SMALL EQUIPMENT 0 1,960 (1,960) - 410 PROFESSIONAL SERVICES 1,000 0 1,000 0.0% 420 COMMUNICATIONS 1,200 908 292 75.7% 430 TRAVEL 1,000 0 1,000 0.0% 440 ADVERTISING 3,000 811 2,189 27.0% 470 UTILITIES 3,700 3,021 680 81.6% 480 REPAIRS & MAINTENANCE 500 183 317 36.5% 490 MISCELLANEOUS 1,000 515 486 51.5% 550 INTERFUND TRANSFER 0 0 0 - 640 MACHINERY/EQUIPMENT 16,000 15,240 760 95.2% 650 CONSTRUCTION PROJECTS 0 0 0 - 790 INTERFUND PRINCIPAL 15,000 4,020 10,980 26.8% 820 INTERFUND INTEREST 13,903 0 13,903 0.0% 910 INTERFUND SERVICES 3,000 0 3,000 0.0% 950 INTERFUND RENTAL 8,142 6,107 2,035 75.0% TOTAL CEMETERY MAINTENANCE 180,559 113,048 67,511 62.6% 132 PARK CONSTRUCTION FUND # Title Appropriation 09/30/07 Expenditures Balance % Used 550 INTERFUND TRANSFER 0 2,313 (2,313) - 650 CONSTRUCTION PROJECTS 420,000 341,489 78,511 81.3% TOTAL PARK CONSTRUCTION FUND 420,000 343,803 76,197 81.3% Packet Page 30 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY FUND Page 18 411 COMBINED UTILITY # Title Appropriation 09/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 2,503,226 1,830,438 672,788 73.1% 120 OVERTIME 92,100 63,413 28,687 68.9% 230 BENEFITS 887,599 621,000 266,599 70.0% 240 UNIFORMS 27,350 17,416 9,934 63.7% 310 SUPPLIES 578,930 320,981 257,949 55.4% 320 FUEL CONSUMED 83,200 35,982 47,218 43.2% 340 RESALE ITEMS 1,540,000 889,911 650,089 57.8% 350 SMALL EQUIPMENT 27,650 16,033 11,618 58.0% 410 PROFESSIONAL SERVICES 205,440 79,509 125,931 38.7% 420 COMMUNICATIONS 54,956 40,369 14,588 73.5% 430 TRAVEL 14,370 4,210 10,160 29.3% 440 ADVERTISING 2,120 772 1,348 36.4% 450 RENTAL/LEASE 22,320 14,751 7,569 66.1% 460 INSURANCE 312,080 312,817 (737) 100.2% 470 UTILITIES 935,850 566,572 369,278 60.5% 480 REPAIRS & MAINTENANCE 103,192 37,217 65,975 36.1% 490 MISCELLANEOUS 475,660 335,458 140,202 70.5% 510 INTERGOVTL SERVICES 307,050 156,097 150,953 50.8% 540 EXCISE TAXES 579,290 456,698 122,592 78.8% 550 INTERFUND TRANSFER 3,320,000 2,682,914 637,086 80.8% 620 BUILDINGS 20,000 0 20,000 0.0% 640 MACHINERY/EQUIPMENT 61,925 7,205 54,720 11.6% 710 GO BOND PRINCIPAL 74,143 0 74,143 0.0% 720 REVENUE BOND PRINCIPAL 1,160,839 0 1,160,839 0.0% 780 INTERGOV'T LOAN PRINCIPAL 85,005 83,833 1,172 98.6% 790 OTHER LOAN PRINCIPAL 13,491 6,745 6,746 50.0% 830 BOND INTEREST 262,170 125,082 137,088 47.7% 840 DEBT ISSUE COSTS 34,709 40,596 (5,887) 117.0% 890 FISCAL AGENT FEES 0 292 (292) - 910 INTERFUND SERVICES 1,178,889 838,805 340,084 71.2% 950 INTERFUND RENTAL 460,599 345,449 115,150 75.0% 980 INTERFUND REPAIRS 1,500 0 1,500 0.0% TOTAL COMBINED UTILITY 15,425,653 9,930,565 5,495,088 64.4% Packet Page 31 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY FUND Page 19 511 EQUIP RENTAL/REPAIR FUND # Title Appropriation 09/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 257,389 208,753 48,636 81.1% 120 OVERTIME 2,000 398 1,602 19.9% 230 BENEFITS 99,669 74,029 25,640 74.3% 240 UNIFORMS 2,000 1,031 969 51.6% 310 SUPPLIES 170,000 89,355 80,645 52.6% 320 FUEL CONSUMED 219,000 219,339 (339) 100.2% 350 SMALL EQUIPMENT 48,000 22,561 25,439 47.0% 410 PROFESSIONAL SERVICES 800 1,121 (321) 140.1% 420 COMMUNICATIONS 4,000 1,624 2,376 40.6% 430 TRAVEL 3,540 0 3,540 0.0% 440 ADVERTISING 500 0 500 0.0% 450 RENTAL/LEASE 95,840 24,870 70,970 25.9% 460 INSURANCE 28,491 30,165 (1,674) 105.9% 470 UTILITIES 14,000 8,973 5,027 64.1% 480 REPAIRS & MAINTENANCE 40,000 45,557 (5,557) 113.9% 490 MISCELLANEOUS 5,000 5,933 (933) 118.7% 510 INTERGOVTL SERVICES 4,000 2,654 1,346 66.3% 640 MACHINERY/EQUIPMENT 1,623,418 790,474 832,944 48.7% 810 INTEREST ON CAPITAL LEASES 1,243 0 1,243 0.0% 910 INTERFUND SERVICES 15,000 2,670 12,330 17.8% 950 INTERFUND RENTAL 6,409 4,807 1,602 75.0% TOTAL EQUIP RENTAL/REPAIR FUND 2,640,299 1,534,314 1,105,985 58.1% Packet Page 32 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 20 110 CITY COUNCIL # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 110,170 76,089 34,081 69.1% 120 OVERTIME 5,590 2,820 2,770 50.5% 230 BENEFITS 80,295 54,645 25,650 68.1% 310 SUPPLIES 1,000 825 175 82.5% 350 SMALL EQUIPMENT 0 0 0 - 410 PROFESSIONAL SERVICES 63,000 35,251 27,749 56.0% 430 TRAVEL 4,100 3,877 223 94.6% 480 REPAIRS & MAINTENANCE 1,500 0 1,500 0.0% 490 MISCELLANEOUS 28,950 1,377 27,573 4.8% TOTAL CITY COUNCIL 294,605 174,883 119,722 59.4% 210 OFFICE OF MAYOR # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 170,438 123,916 46,522 72.7% 230 BENEFITS 44,470 31,849 12,621 71.6% 310 SUPPLIES 3,000 1,565 1,435 52.2% 350 SMALL EQUIPMENT 100 122 (22) 122.4% 410 PROFESSIONAL SERVICES 1,000 1,139 (139) 113.9% 420 COMMUNICATIONS 1,400 1,197 203 85.5% 430 TRAVEL 1,500 748 752 49.8% 450 RENTAL/LEASE 1,500 1,303 197 86.9% 480 REPAIRS & MAINTENANCE 100 129 (29) 128.7% 490 MISCELLANEOUS 2,500 1,840 660 73.6% TOTAL OFFICE OF MAYOR 226,008 163,809 62,199 72.5% 220 HUMAN RESOURCES # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 139,571 103,112 36,459 73.9% 230 BENEFITS 43,123 35,064 8,059 81.3% 310 SUPPLIES 2,850 1,816 1,034 63.7% 350 SMALL EQUIPMENT 350 122 228 35.0% 410 PROFESSIONAL SERVICES 24,500 13,782 10,718 56.3% 430 TRAVEL 500 424 76 84.9% 440 ADVERTISING 5,000 8,512 (3,512) 170.2% 450 RENTAL/LEASE 1,320 1,238 82 93.8% 480 REPAIRS & MAINTENANCE 3,971 3,996 (25) 100.6% 490 MISCELLANEOUS 11,180 9,162 2,018 81.9% TOTAL HUMAN RESOURCES 232,365 177,229 55,136 76.3% Packet Page 33 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 21 230 MUNICIPAL COURT # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 423,863 323,510 100,353 76.3% 120 OVERTIME 2,000 1,609 391 80.5% 230 BENEFITS 132,330 103,742 28,588 78.4% 310 SUPPLIES 15,000 9,812 5,188 65.4% 350 SMALL EQUIPMENT 8,878 283 8,595 3.2% 410 PROFESSIONAL SERVICES 55,000 32,056 22,944 58.3% 420 COMMUNICATIONS 0 139 (139) - 430 TRAVEL 3,000 1,727 1,273 57.6% 450 RENTAL/LEASE 2,400 1,296 1,104 54.0% 480 REPAIRS & MAINTENANCE 640 1,002 (362) 156.5% 490 MISCELLANEOUS 4,900 2,403 2,497 49.0% 510 INTERGOVERNMENTAL SERVICES 15,000 6,423 8,577 42.8% TOTAL MUNICIPAL COURT 663,011 484,001 179,010 73.0% 240 ECONOMIC DEVELOPMENT # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 103,000 0 103,000 0.0% 230 BENEFITS 21,006 0 21,006 0.0% 310 SUPPLIES 2,500 163 2,337 6.5% 350 SMALL EQUIPMENT 800 0 800 0.0% 410 PROFESSIONAL SERVICES 19,000 24,895 (5,895) 131.0% 420 COMMUNICATIONS 0 6,400 (6,400) - 430 TRAVEL 4,470 0 4,470 0.0% 440 ADVERTISING 7,700 120 7,580 1.6% 450 RENTAL/LEASE 0 616 (616) - 490 MISCELLANEOUS 5,000 10,911 (5,911) 218.2% TOTAL ECONOMIC DEVELOPMENT 163,476 43,106 120,370 26.4% 250 CITY CLERK # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 285,901 211,173 74,728 73.9% 120 OVERTIME 410 189 221 46.2% 230 BENEFITS 87,260 62,160 25,100 71.2% 310 SUPPLIES 16,260 10,485 5,775 64.5% 410 PROFESSIONAL SERVICES 17,250 13,750 3,500 79.7% 420 COMMUNICATIONS 59,050 42,116 16,934 71.3% 430 TRAVEL 2,080 682 1,398 32.8% 440 ADVERTISING 20,420 14,894 5,526 72.9% 450 RENTAL/LEASE 23,810 16,173 7,637 67.9% 480 REPAIRS & MAINTENANCE 6,685 6,455 230 96.6% 490 MISCELLANEOUS 4,500 3,748 752 83.3% TOTAL CITY CLERK 523,626 381,827 141,799 72.9% Packet Page 34 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 22 310 ADMINISTRATIVE SERVICES # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 782,395 572,233 210,162 73.1% 120 OVERTIME 6,100 2,864 3,236 46.9% 230 BENEFITS 211,187 180,715 30,472 85.6% 310 SUPPLIES 16,050 15,530 520 96.8% 350 SMALL EQUIPMENT 108,000 101,704 6,296 94.2% 410 PROFESSIONAL SERVICES 15,000 15,667 (667) 104.4% 420 COMMUNICATIONS 27,200 19,513 7,687 71.7% 430 TRAVEL 4,450 13 4,437 0.3% 440 ADVERTISING 0 0 0 - 450 RENTAL/LEASE 9,200 6,941 2,259 75.4% 480 REPAIRS & MAINTENANCE 49,878 44,303 5,575 88.8% 490 MISCELLANEOUS 23,000 7,297 15,703 31.7% 640 MACHINERY/EQUIPMENT 94,200 126,248 (32,048) 134.0% TOTAL ADMINISTRATIVE SERVICES 1,346,660 1,093,028 253,632 81.2% 360 CITY ATTORNEY # Title Budget 9/30/07 Expenditures Balance % Used 410 PROFESSIONAL SERVICES 445,300 311,060 134,240 69.9% 490 MISCELLANEOUS 3,000 0 3,000 0.0% TOTAL CITY ATTORNEY 448,300 311,060 137,240 69.4% 390 NON-DEPARTMENTAL # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 120,000 86,435 33,565 72.0% 230 BENEFITS 78,600 38,372 40,228 48.8% 410 PROFESSIONAL SERVICES 239,977 149,800 90,177 62.4% 420 COMMUNICATIONS 45,000 21,140 23,860 47.0% 430 TRAVEL 0 0 0 - 450 RENTAL/LEASE 3,600 2,700 900 75.0% 460 INSURANCE 426,000 428,516 (2,516) 100.6% 480 REPAIRS & MAINTENANCE 0 4,977 (4,977) - 490 MISCELLANEOUS 84,847 33,525 51,322 39.5% 510 INTERGOVTL SERVICES 220,994 171,267 49,727 77.5% 540 EXCISE TAXES 5,000 3,808 1,192 76.2% 550 INTERFUND TRANSFER 1,451,974 698,487 753,487 48.1% 700 BOND PRINCIPAL 1,506,803 686,412 820,391 45.6% 800 BOND INTEREST 470,313 247,113 223,200 52.5% 840 DEBT ISSUE COSTS 14,711 11,420 3,291 77.6% 890 FISCAL AGENT FEES 1,500 898 602 59.9% TOTAL NON-DEPARTMENTAL 4,669,319 2,584,870 2,084,449 55.4% Packet Page 35 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 23 410 POLICE # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 4,821,022 3,421,835 1,399,188 71.0% 120 OVERTIME 229,324 371,829 (142,505) 162.1% 150 HOLIDAY BUYBACK 169,517 2,657 166,860 1.6% 230 BENEFITS 1,635,412 1,121,891 513,521 68.6% 240 UNIFORMS 57,790 41,725 16,065 72.2% 310 SUPPLIES 84,425 53,632 30,793 63.5% 320 FUEL CONSUMED 0 250 (250) - 350 SMALL EQUIPMENT 132,602 124,413 8,189 93.8% 410 PROFESSIONAL SERVICES 127,353 44,221 83,132 34.7% 420 COMMUNICATIONS 21,700 14,263 7,437 65.7% 430 TRAVEL 28,520 12,478 16,042 43.8% 440 ADVERTISING 2,500 56 2,444 2.2% 450 RENTAL/LEASE 12,000 11,009 991 91.7% 480 REPAIRS & MAINTENANCE 27,094 13,410 13,684 49.5% 490 MISCELLANEOUS 43,299 29,412 13,887 67.9% 510 INTERGOVTL SERVICES 1,295,612 972,491 323,121 75.1% 550 INTERFUND TRANSFER 65,757 52,479 13,278 79.8% 640 MACHINERY & EQUIPMENT 0 0 0 - 910 INTERFUND SERVICES 0 854 (854) - 920 INTERFUND FUEL 0 1,574 (1,574) - 950 INTERFUND RENTAL 598,086 448,674 149,412 75.0% 980 INTERFUND REPAIRS 1,000 327 673 32.7% TOTAL POLICE 9,353,013 6,739,477 2,613,536 72.1% Packet Page 36 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 24 510 FIRE # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 4,135,701 3,040,280 1,095,421 73.5% 120 OVERTIME 396,438 431,441 (35,003) 108.8% 150 HOLIDAY BUYBACK 166,318 1,910 164,408 1.1% 230 BENEFITS 1,455,800 998,390 457,410 68.6% 240 UNIFORMS 48,480 33,629 14,851 69.4% 250 PROTECTIVE CLOTHING 17,290 18,293 (1,003) 105.8% 310 SUPPLIES 104,082 54,893 49,189 52.7% 350 SMALL EQUIPMENT 17,500 21,753 (4,253) 124.3% 410 PROFESSIONAL SERVICES 80,549 28,922 51,627 35.9% 420 COMMUNICATIONS 36,242 18,757 17,485 51.8% 430 TRAVEL 19,590 5,061 14,529 25.8% 450 RENTAL/LEASE 1,800 1,637 163 90.9% 480 REPAIRS & MAINTENANCE 17,640 12,973 4,667 73.5% 490 MISCELLANEOUS 37,124 25,733 11,391 69.3% 510 INTERGOVTL SERVICES 213,196 212,923 273 99.9% 550 INTERFUND TRANSFER 34,000 24,000 10,000 70.6% 640 MACHINERY & EQUIPMENT 29,000 20,859 8,141 71.9% 920 INTERFUND FUEL 32,731 35,502 (2,771) 108.5% 930 INTERFUND SUPPLIES 40,184 38,579 1,605 96.0% 950 INTERFUND RENTAL 77,013 58,196 18,817 75.6% 980 INTERFUND REPAIRS 90,631 52,847 37,784 58.3% TOTAL FIRE 7,051,309 5,136,578 1,914,731 72.8% 610 COMMUNITY SERVICES # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 187,120 139,851 47,269 74.7% 120 OVERTIME 1,600 627 973 39.2% 230 BENEFITS 43,800 31,719 12,081 72.4% 310 SUPPLIES 3,000 539 2,461 18.0% 350 SMALL EQUIPMENT 500 245 255 48.9% 410 PROFESSIONAL SERVICES 82,000 61,666 20,334 75.2% 420 COMMUNICATIONS 690 0 690 0.0% 430 TRAVEL 2,000 46 1,954 2.3% 440 ADVERTISING 2,060 0 2,060 0.0% 450 RENTAL/LEASE 1,320 1,238 82 93.8% 480 REPAIRS & MAINTENANCE 500 150 350 30.0% 490 MISCELLANEOUS 2,000 1,695 305 84.7% 950 INTERFUND RENTAL 1,769 1,327 442 75.0% TOTAL COMMUNITY SERVICES 328,359 239,103 89,256 72.8% Packet Page 37 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 25 620 DEVELOPMENT SERVICES # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 1,952,885 1,347,195 605,690 69.0% 120 OVERTIME 28,135 12,531 15,604 44.5% 230 BENEFITS 563,737 366,359 197,378 65.0% 240 UNIFORMS 2,130 442 1,688 20.8% 310 SUPPLIES 30,700 20,837 9,863 67.9% 350 SMALL EQUIPMENT 2,020 2,717 (697) 134.5% 410 PROFESSIONAL SERVICES 286,422 246,123 40,299 85.9% 420 COMMUNICATIONS 13,900 6,209 7,691 44.7% 430 TRAVEL 6,570 474 6,096 7.2% 440 ADVERTISING 3,910 2,751 1,159 70.4% 450 RENTAL/LEASE 27,590 15,168 12,422 55.0% 480 REPAIRS & MAINTENANCE 15,496 9,525 5,971 61.5% 490 MISCELLANEOUS 52,775 12,590 40,185 23.9% 640 MACHINERY & EQUIPMENT 18,818 22,421 (3,603) 119.1% 950 INTERFUND RENTAL 30,471 22,853 7,618 75.0% TOTAL DEVELOPMENT SERVICES 3,035,559 2,088,196 947,363 68.8% 640 PARKS & RECREATION # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 1,753,852 1,317,330 436,522 75.1% 120 OVERTIME 4,075 4,808 (733) 118.0% 230 BENEFITS 457,458 336,473 120,985 73.6% 240 UNIFORMS 6,540 2,146 4,394 32.8% 310 SUPPLIES 122,257 91,243 31,014 74.6% 350 SMALL EQUIPMENT 20,627 16,396 4,231 79.5% 410 PROFESSIONAL SERVICES 229,810 181,375 48,435 78.9% 420 COMMUNICATIONS 20,700 15,976 4,724 77.2% 430 TRAVEL 2,840 1,657 1,183 58.4% 440 ADVERTISING 3,700 2,597 1,103 70.2% 450 RENTAL/LEASE 50,250 31,454 18,796 62.6% 470 UTILITIES 105,750 100,714 5,036 95.2% 480 REPAIRS & MAINTENANCE 19,976 19,766 210 98.9% 490 MISCELLANEOUS 34,650 22,020 12,630 63.6% 910 INTERGOVTL SERVICES 64,250 29,686 34,564 46.2% 950 INTERFUND RENTAL 103,936 77,952 25,984 75.0% TOTAL PARKS & RECREATION 3,000,671 2,251,594 749,077 75.0% Packet Page 38 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 26 650 PUBLIC WORKS # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 206,052 155,256 50,796 75.3% 120 OVERTIME 200 0 200 0.0% 230 BENEFITS 48,512 44,860 3,652 92.5% 310 SUPPLIES 5,200 4,407 793 84.8% 350 SMALL EQUIPMENT 0 544 (544) - 410 PROFESSIONAL SERVICES 0 57 (57) - 420 COMMUNICATIONS 480 190 290 39.5% 430 TRAVEL 960 56 904 5.9% 450 RENTAL/LEASE 4,450 3,560 890 80.0% 470 UTILITIES 2,500 1,528 972 61.1% 480 REPAIRS & MAINTENANCE 2,100 1,799 301 85.7% 490 MISCELLANEOUS 2,200 1,588 612 72.2% 950 INTERFUND RENTAL 2,558 1,919 639 75.0% TOTAL PUBLIC WORKS 275,212 215,762 59,450 78.4% 651 FACILITIES MAINTENANCE # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 542,603 405,387 137,216 74.7% 120 OVERTIME 8,500 3,204 5,296 37.7% 230 BENEFITS 203,597 132,261 71,336 65.0% 240 UNIFORMS 6,000 1,755 4,245 29.2% 310 SUPPLIES 99,000 61,049 37,951 61.7% 320 FUEL CONSUMED 1,700 259 1,441 15.3% 350 SMALL EQUIPMENT 4,030 3,953 77 98.1% 410 PROFESSIONAL SERVICES 0 8,770 (8,770) - 420 COMMUNICATIONS 13,950 8,887 5,063 63.7% 430 TRAVEL 0 212 (212) - 450 RENTAL/LEASE 0 415 (415) - 470 UTILITIES 344,500 192,440 152,060 55.9% 480 REPAIRS & MAINTENANCE 50,000 34,854 15,146 69.7% 490 MISCELLANEOUS 2,780 1,863 917 67.0% 510 INTERGOVTL SERVICES 3,000 588 2,413 19.6% 630 OTHER IMPROVEMENTS 3,000 0 3,000 0.0% 650 CONSTRUCTION PROJECTS 0 6,618 (6,618) - 950 INTERFUND RENTAL 35,413 26,560 8,853 75.0% TOTAL FACILITIES MAINTENANCE 1,318,073 889,076 428,997 67.5% Packet Page 39 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 27 652 STORM DRAINAGE UTILITY # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 427,045 291,670 135,376 68.3% 120 OVERTIME 5,080 0 5,080 0.0% 230 BENEFITS 156,364 100,145 56,219 64.0% 240 UNIFORMS 6,300 3,928 2,372 62.4% 310 SUPPLIES 49,500 21,227 28,273 42.9% 350 SMALL EQUIPMENT 2,800 3,358 (558) 119.9% 410 PROFESSIONAL SERVICES 17,500 17,613 (113) 100.6% 420 COMMUNICATIONS 3,000 881 2,119 29.4% 430 TRAVEL 3,330 210 3,120 6.3% 450 RENTAL/LEASE 4,000 4,631 (631) 115.8% 460 INSURANCE 33,796 33,688 108 99.7% 470 UTILITIES 4,500 5,804 (1,304) 129.0% 480 REPAIRS & MAINTENANCE 4,362 6,172 (1,810) 141.5% 490 MISCELLANEOUS 63,540 62,328 1,212 98.1% 510 INTERGOVTL SERVICES 14,070 17,664 (3,594) 125.5% 540 EXCISE TAXES 104,500 89,807 14,693 85.9% 550 INTERFUND TRANSFER 1,890,000 1,727,414 162,586 91.4% 640 MACHINERY/EQUIPMENT 1,925 0 1,925 0.0% 710 BOND PRINCIPAL 138,968 30,281 108,687 21.8% 830 BOND INTEREST 86,699 36,352 50,347 41.9% 840 DEBT ISSUE COSTS 26,243 15,014 11,229 57.2% 890 FISCAL AGENT FEES 0 61 (61) - 910 INTERFUND SERVICES 380,475 294,489 85,986 77.4% 950 INTERFUND RENTAL 184,011 138,008 46,003 75.0% TOTAL STORM DRAINAGE UTILITY 3,608,008 2,900,745 707,263 80.4% Packet Page 40 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 28 654 WATER UTILITY # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 628,573 481,610 146,963 76.6% 120 OVERTIME 24,180 13,506 10,674 55.9% 230 BENEFITS 210,344 154,053 56,291 73.2% 240 UNIFORMS 6,880 3,283 3,597 47.7% 310 SUPPLIES 111,580 42,600 68,980 38.2% 340 RESALE ITEMS 1,540,000 889,916 650,084 57.8% 350 SMALL EQUIPMENT 4,000 2,780 1,220 69.5% 410 PROFESSIONAL SERVICES 81,480 31,584 49,896 38.8% 420 COMMUNICATIONS 39,068 16,979 22,089 43.5% 430 TRAVEL 4,850 164 4,686 3.4% 440 ADVERTISING 560 0 560 0.0% 450 RENTAL/LEASE 11,370 4,201 7,169 37.0% 460 INSURANCE 77,540 77,803 (263) 100.3% 470 UTILITIES 28,000 14,369 13,631 51.3% 480 REPAIRS & MAINTENANCE 21,662 10,978 10,684 50.7% 490 MISCELLANEOUS 196,990 158,130 38,860 80.3% 510 INTERGOVTL SERVICES 41,140 33,238 7,902 80.8% 540 EXCISE TAXES 201,790 163,701 38,089 81.1% 550 INTERFUND TRANSFER 400,000 400,000 0 100.0% 620 BUILDINGS 20,000 0 20,000 0.0% 710 BOND PRINCIPAL 167,835 6,629 161,206 3.9% 830 BOND INTEREST 71,150 35,530 35,620 49.9% 840 DEBT ISSUE COSTS 4,233 12,818 (8,585) 302.8% 890 FISCAL AGENT FEES 0 82 (82) - 910 INTERFUND SERVICES 355,266 238,874 116,392 67.2% 950 INTERFUND RENTAL 112,508 84,381 28,127 75.0% 980 INTERFUND REPAIRS 0 0 0 - TOTAL WATER UTILITY 4,360,999 2,877,209 1,483,790 66.0% Packet Page 41 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 29 655 SEWER # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 362,141 273,666 88,475 75.6% 120 OVERTIME 17,330 9,605 7,725 55.4% 230 BENEFITS 143,745 105,170 38,575 73.2% 240 UNIFORMS 5,170 2,872 2,298 55.6% 310 SUPPLIES 49,970 28,511 21,459 57.1% 340 FUEL CONSUMED 0 334 (334) - 350 SMALL EQUIPMENT 4,000 1,702 2,298 42.6% 410 PROFESSIONAL SERVICES 48,960 9,486 39,474 19.4% 420 COMMUNICATIONS 4,888 16,153 (11,265) 330.5% 430 TRAVEL 2,490 2,261 229 90.8% 440 ADVERTISING 560 0 560 0.0% 450 RENTAL/LEASE 1,870 1,743 127 93.2% 460 INSURANCE 117,533 117,908 (375) 100.3% 470 UTILITIES 461,110 277,505 183,605 60.2% 480 REPAIRS & MAINTENANCE 18,042 10,783 7,259 59.8% 490 MISCELLANEOUS 127,330 64,092 63,238 50.3% 510 INTERGOVTL SERVICES 182,640 69,596 113,044 38.1% 540 EXCISE TAXES 273,000 203,190 69,810 74.4% 550 INTERFUND TRANSFER 1,030,000 555,500 474,500 53.9% 640 MACHINERY/EQUIPMENT 60,000 0 60,000 0.0% 780 BOND PRINCIPAL 112,181 50,667 61,514 45.2% 830 BOND INTEREST 37,120 20,540 16,580 55.3% 840 DEBT ISSUE COSTS 4,233 12,765 (8,532) 301.6% 910 INTERFUND SERVICES 269,892 176,510 93,382 65.4% 950 INTERFUND RENTAL 155,985 116,989 38,996 75.0% 980 INTERFUND REPAIRS 1,500 0 1,500 0.0% TOTAL SEWER 3,491,690 2,127,548 1,364,142 60.9% Packet Page 42 of 84 SEPTEMBER 30, 2007 BUDGET REPORT EXPENDITURE DETAIL BY DEPARTMENT Page 30 656 TREATMENT PLANT # Title Budget 9/30/07 Expenditures Balance % Used 110 SALARIES AND WAGES 1,085,467 783,493 301,974 72.2% 120 OVERTIME 45,510 40,302 5,208 88.6% 230 BENEFITS 377,146 261,633 115,513 69.4% 240 UNIFORMS 9,000 7,333 1,667 81.5% 310 SUPPLIES 367,880 228,643 139,237 62.2% 320 FUEL CONSUMED 83,200 35,643 47,557 42.8% 350 SMALL EQUIPMENT 16,850 8,192 8,658 48.6% 410 PROFESSIONAL SERVICES 57,500 20,825 36,675 36.2% 420 COMMUNICATIONS 8,000 6,356 1,644 79.5% 430 TRAVEL 3,700 1,576 2,124 42.6% 440 ADVERTISING 1,000 772 228 77.2% 450 RENTAL/LEASE 5,080 4,177 903 82.2% 460 INSURANCE 83,211 83,418 (207) 100.2% 470 UTILITIES 442,240 268,894 173,346 60.8% 480 REPAIRS & MAINTENANCE 59,126 9,284 49,842 15.7% 490 MISCELLANEOUS 87,800 50,909 36,891 58.0% 510 INTERGOVTL SERVICES 69,200 35,599 33,601 51.4% 640 MACHINERY/EQUIPMENT 0 7,205 (7,205) - 710 BOND PRINCIPAL 914,494 2,050 912,444 0.2% 830 BOND INTEREST 67,201 33,610 33,591 50.0% 890 FISCAL AGENT FEES 0 149 (149) - 910 INTERFUND SERVICES 173,256 128,933 44,323 74.4% 950 INTERFUND RENTAL 8,095 6,071 2,024 75.0% TOTAL TREATMENT PLANT 3,964,956 2,025,064 1,939,892 51.1% Packet Page 43 of 84 SEPTEMBER 30, 2007 BUDGET REPORT CAPITAL IMPROVEMENT PROJECT STATUS Page 31 CAPITAL IMPROVEMENTS PROGRAM - 2007-2008 Fund REET 2 2007 2007 No. Eligible Budget Actual Comments TRANSPORTATION PROJECTS 112 X 100th Ave Right of Way Stabilization 1,000,000 502,443 Construction in progress. 112 220th St Improvements 100,000 92,604 Construction completed in 2006. Closing out contract. Final payments made in 2007. 112 X Downtown Parking Improvements 60,000 0 No action yet in 2007. 112 X 92nd Ave/234th St Intersection Improvement 0 83,542 Construction started in 2006, completed in 2007. Contract closed. 112 X Nonmotorized Trans- Caspers/9th/Puget Drive Walkway 380,000 32,765 Consultant contract awarded. Design in progress. 112 X Nonmotorized Trans- 96th Ave W Ped Impr 0 15,411 Construction completed in 2005. Final payments made in 2007. Contract closed. 112 X Nonmotorized Trans- Interurban Trail 125,000 0 Design and ROW acquisition in progress. 112 X Nonmotorized Trans- School Zone Improvements - Citywide 10,000 0 No projects yet in 2007. 112 X Nonmotorized Trans- Walkways & Bikeways Citywide 15,000 0 Some walkway/ADA ramp work included in 2007 street overlay contract. Construction in progress. 112 X 2006 Citywide Street Overlay 0 1,330 Construction completed in 2006. Final payments in 2007. Contract closed. 112 X 2007 Overlay-Utility Streets 320,000 220,849 Construction in progress. 112 X Signals/Citywide 5,000 0 No projects yet in 2007. 112 X Stabilization Projects Citywide 50,000 0 Design in progress for OVD. Geotech consultant monitoring slide area on Talbot Rd near Cyrus Pl. 112 X Street Improvements Citywide 15,000 0 Misc street impr work included in 2007 street overlay contract. Construction in progress. 112 X Traffic Calming 10,000 0 No projects yet in 2007. 112 Transportation Plan 5,000 0 Initiated consultant selection for plan update. 112 X Street Lighting on Main between 5th and 6th 75,000 0 Project put on hold by Council due to cost. 112 X SR99/76th Ave W Intersection Safety Impr 0 314 Consultant selected for design. 112 X 196th ST SW/88th Ave W Intersection Impr 0 12,013 Consultant task order issued. Evaluation in progress. 2,170,000 961,271 REET 2 - TRANSPORTATION 125 X Nonmotorized Trans - ADA Curb Ramp Improvements 20,000 0 ADA ramp work included in 2007 street overlay contract. Construction in progress. 125 X Nonmotorized Trans - Pedestrian Lighting Citywide 5,000 0 No projects yet in 2007. 125 X 2007 Overlays - Citywide 550,000 466,025 Construction in progress. 125 X 164th Street Walkway 0 35,013 Construction completed. Closing out contract. Additional expenditures for this project in Fund 125 (REET2 - Parks Improvement) 125 X Transfer to 112 for 100th Ave W Road Stabilization 500,200* Construction in progress. Finance to transfer funds. 125 X Transfor to 112 for Caspers/9th/Puget Drive Walkway 190,000* Design in progress. Finance to transfer funds. TOTAL REET 2 - TRANSPORTATION 575,000 501,038 Packet Page 44 of 84 SEPTEMBER 30, 2007 BUDGET REPORT CAPITAL IMPROVEMENT PROJECT STATUS Page 32 CAPITAL IMPROVEMENTS PROGRAM - 2007-2008 Fund REET 2 Proposed Actual No. Eligible 2007 2007 Comments BUILDINGS MAINTENANCE 116 ADA Improvements- City Wide 5,000 25 1% for Arts. Improvement cost yet to come. 116 Anderson Center Seismic Retrofit (FEMA Grant) 838,460 180,967 Design and bidding costs. 116 City Hall Entrance Doors 18,000 143 Investigating needs and solutions. 116 Fire Station #20 HVAC 30,000 0 Part of ESCO Phase II. 116 Meadowdale Clubhouse Roof 16,000 0 Deferred. Looking at gutter replacement. 116 Park and Facilities Maintenance Bldg Renovation Study 15,000 0 Will begin Fall 2007. 116 Senior Center Remodel Kitchen (CDBG Funding) 90,000 0 SCSC working with equipment consultant. 116 Senior Center Vestibule/Front Entry (CDBG Funding) 130,000 12,374 Completed engineering investigation phase. 116 Budget Adjustment 587,050 (-) 116 Bond Discount & Debt Issue Costs 0 8,118 116 City Hall Glass Replacement 0 443 Should be reimbursed by insurance. 116 City Hall Generator Circuit Additions 0 3,185 Changes in emergency power distribution. 116 ESCO Phase I Project 0 25,269 Phase I retainage paid from 2006 project. 116 Fire Station #17 Kitchen Hood 0 1,683 Project originally scheduled in 2006. 116 Fire Station #17 Soffit Installation 0 98 Work started in 2006, never finished. 116 Log Cabin Exterior Preservation 0 616 Excess charges not covered by Fund 120. 116 Edmonds Historical Museum Brick Repairs 0 600 Structural engineering - loose brick on wall. 116 Public Works Fiber Optic Installation 0 32 Supplies charges for installation. 116 Senior Center Elevator Replacement 0 6,885 2006 Project retainage released. 116 Senior Center Fire Alarm 0 1,959 2006 Project retainage released. 116 Senior Center Miscellaneous Repairs 0 5,664 Floor repairs in dining area - safety issue. 116 Senior Center Roofing Project 0 1,081 2006 Project retainage released. TOTAL BUILDING MAINTENANCE 1,729,510 249,142 Packet Page 45 of 84 SEPTEMBER 30, 2007 BUDGET REPORT CAPITAL IMPROVEMENT PROJECT STATUS Fund REET 2 2007 2007 No. Eligible Budget Actual Comments REET 2 - PARKS IMPROVEMENT 125 X 75th/76th Street Walkway 945,000 52,059 Design in progress. 125 X 162nd Street Park 300,000 34,630 Design in progress. 125 X 164th Street Walkway 0 272,708 Construction completed. Closing out contract. Additional expenditures for this project in Fund 125 (REET2 - Trans.) 125 X Anderson Center Field / Court/Plaza 5,000 125 X City Park Improvements 60,000 125 X Civic Center Complex Improvements 50,000 4,020 drainage improvements 125 X Fishing Pier/Olympic Beach/Parking Lot 20,000 12,496 pier survey, interpretive panels 125 X Maplewood Park Playground 40,000 125 X Mathay Ballinger Playfield 60,000 125 X Old Woodway Elementary 1,000,000 431,303 Demolition completed. Park design and engineering in progress. 125 X Senior Center & 144 RR Waterfront Walkway 140,000 125 X Underwater Park Improvements 2,000 125 X Yost Park/Pool Improvement 25,000 8,299 bridge and pool repair BEAUTIFICATION 125 X Beautification Citywide 20,000 20,163 signage design project, misc. CITY-WIDE PARK IMPROVEMENTS 125 X Citywide Park Improvements / misc small projects 145,000 50,120 bench recoats,sidewalk repair, marsh channel restoration plan 125 X Misc Paving 10,000 Math-Bal. sportct in 07 overlay:in progress 125 X Sports Fields Upgrade/Playground Partnership 25,000 SPECIALIZED PARK DEVELOPMENT 125 X Skateboard Park in Fund 132 125 X Aquatic Recreation Complex TRAIL DEVELOPMENT 125 X Interurban Trail Development 40,000 4,262 Design and ROW acquisition in progress. 125 X Misc. Unpaved Trail / Bike Path/Improvements 10,000 PLANNING 125 X 4th Ave Arts Corridor Design 25,000 50,000 matching grant awarded 125 X Comp Plan 40,000 30,205 planning underway/completion Mar 08 125 X Cultural Arts Center 15,000 125 X Edmonds Marsh Environmental Plan 30,000 125 X Yost Pool Feasibility Study 40,000 TOTAL REET 2 - PARKS IMPROVEMENT 3,047,000 PARKS ACQUISITION 126 Misc. Open space/Land 200,000 4,500 Milltown parcel appraisal 126 Tideland Acquisitions 10,000 TOTAL PARKS ACQUISITION FUND 210,000 4,500 PARKS CONSTRUCTION FUND 132 X 164th Street Walkway 270,000 0 Construction completed. Costs charged to Fund 125. No grant funding. 132 X Dayton Street Plaza 50,000 redevelopment design in progress 132 X Skateboard Park 100,000 335,754 Construction complete. Construction contract closed out. TOTAL PARKS CONSTRUCTION FUND 420,000 335,754 Note #1 $10 - $15 Million General Obligation Bond Issue CAPITAL IMPROVEMENTS PROGRAM - 2007-2008 Page 33 Packet Page 46 of 84 SEPTEMBER 30, 2007 BUDGET REPORT CAPITAL IMPROVEMENT PROJECT STATUS Fund REET 2 2007 2007 No. Eligible Budget Actual Comments WATER SYSTEM IMPROVEMENTS (Fund #412-100) 412 2005 Replacement Program 800,000 1,273,995 Construction completed. Closing out contract. 412 2006 Replacement Program 1,100,000 incl below Design in progress with 2007 program. 412 2007 Replacement Program 555,000 9,484 Design in progress. 412 220th St Waterline Relocation/Upgrade 0 2,511 Contruction completed in 2006. Closing out contract. Final payments made in 2007. 412 Chlorine Residual Analyzers 15,000 0 Public Works in-house design in progress. 412 Citywide Improvements 25,000 0 No projects yet in 2007. 412 Five Corners Pump Station Improvements 400,000 19,857 Design in progress. 90% complete. 412 Reservoir Security 90,000 incl above Design in progress in conjunction with Five Corners project. Design 90% complete. 412 Seismic Improvements 150,000 incl above Design in progress. Work to be in conjunction with Five Corners Pump Station Improvements. 412 PRV Replacement 100,000 0 To be included in 2006/2007 watermain replacement project design. 412 Transfer (112)*115,000*57,500 Finance to transfer funds. SUB-TOTAL 3,235,000 1,363,347 *Not included in sub-total or total DRAINAGE SYSTEM PROJECTS (Fund #412-200) 412 93rd Ave West/ 96th Ave W 760,000 9,562 Completed design for segment on 95th, between 228th and SR104. Construction contract awarded. Construction in October. 412 2007 City Wide Drainage Replacement/ Extension 50,000 12,312 Two projects constructed. Two project work orders recently submitted to PW. Several in planning stage. 412 2006 Citywide Storm Improvements 0 50,582 Construction started in 2006, completed in 2007. 412 L. Ballinger Monitoring 10,000 32 Volunteer monitoring. 412 Lake Ballinger Lake Level & Outlet Study 40,000 184 Consultant contract awarded. Study in progress. 412 Meadowdale 70,000 8,158 Lorian Woods improvements design 90% complete. Working on easement. Construction planned for summer/fall 2008. 412 Meadowdale Beach Rd Drainage Impr 0 4,259 Construction completed in 2006. Contract closed out in 2007. 412 Northstream 30" Storm Repair/ Improvements 575,000 38,316 Design nearing completion. Construction planned for summer 2008. 412 Public Involvement (Student Project)1,000 0 Earth Day project. 412 Shoreline Regulation Revisions, Monitoring & Education 30,000 0 No action in 2007. Planning on public education brochure mailout. 412 Southwest Edmonds Basin Study, Projects 75,000 8,158 1) Humber Lane overflow project design complete. Work order submitted to PW. Planned for fall construction. 2) Old Woodway infiltration system design 90% complete. Construction to be done in conjunction with park development. 412 Friar Tuck Lane Drainage Impr 0 2,820 Construction completed. Closing out contract. 412 220th Street SW Improvements 0 5,092 Contruction completed in 2006. Closing out contract. Final payments made in 2007. 412 Edmonds Marsh Channel Improvements 50,000 0 Plan to begin study in fall. 412 Vehicle Wash Station 100,000 0 Design in progress. Construction in 2008. 412 74th Pl W/Mead Bch Road Drainage Impr 0 98,308 Construction completed. Closing out contract. 412 242nd St SW Storm Impr, Phase II 0 25,314 Construction completed. Contract closed. 412 Glen-Daley Alley Drainage Improvements 0 3,513 Construction completed. Contract closed. 412 Dayton Street Storm Outfall Repair 0 213 Construction completed in 2005. Closing out contract. Final payments in 2007 412 Willow Creek Storm Outfall Repair 0 4,396 Construction completed in 2005. Closing out contract. Final payments in 2007 412 2006 Street Overlay 0 1,450 157th St Storm Impr and Glen-Daley Alley Drainage Impr pavement. Completed in 2006. Contract closed. 412 2007 Slope Stabilization Projects 0 1,245 Design in progress for OVD. Geotech consultant monitoring slide area on Talbot Rd near Cyrus Pl. 412 Transfer (112)*50,000*25,000 Finance to transfer funds. SUB-TOTAL 1,761,000 298,914 *Not included in sub-total or total CAPITAL IMPROVEMENTS PROGRAM - 2007-2008 Page 34 Packet Page 47 of 84 SEPTEMBER 30, 2007 BUDGET REPORT CAPITAL IMPROVEMENT PROJECT STATUS Fund REET 2 2007 2007 No. Eligible Budget Actual Comments SEWER COLLECTION SYSTEM PROJECTS (Fund #412-300) 412 Citywide Sewer Improvements 10,000 0 No projects yet in 2007. 412 Lift Station #13 500,000 26,257 Design in progress, 90% complete. Obtained easement. Conducting additional geotech work. Construction planned to began late 2007 or early 2008. 412 Lift Station #2 500,000 incl above Design in progress. Working on easement issue. 412 Lift Station #7 & 8 Integration 1,000,000 71,878 Design in progress (95%). Advertise for bids, 1st qtr 2008. 412 Lift Station #4 90,000 0 Consultant selection planned 4th qtr 2007. 412 Lift Station #9 100,000 0 Consultant selection planned 4th qtr 2007. 412 Telemetry Upgrade all Lift Stations 175,000 67,814 Project completed. 412 West Dayton Street Sewer 300,000 0 Design in progress (95%) with lift sta 7 & 8. Advertise for bids, 1st qtr 2008. 412 220th St SW Sewer Improvements 0 279 Contruction completed in 2006. Closing out contract. Final payments made in 2007. 412 Transfer (112)*25,000*12,500 Finance to transfer funds. SUB-TOTAL 2,675,000 178,728 *Not included in sub-total or total TOTAL FUND 412 7,671,000 1,840,989 CAPITAL IMPROVEMENTS PROGRAM - 2007-2008 CAPITAL IMPROVEMENTS PROGRAM - 2007-2008 Fund 2007 2007 No. Budget Actual Comments TREATMENT PLANT PROJECTS 414 General 25,000 5,840 Conduit installation completed, Meter C 414 Mechanical Equipment Replacement 50,000 10,930 WAS pump upgrade 414 Screenings system evaluation 400,000 494,290 Project is almost complete 414 Concrete repairs 30,000 4,460 Project will cost about $150,000 414 Odor Control Study 100,000 15,560 Study is completed, no more expense 414 Electrical Improvements Project 178,000 38,110 Design is 90% complete. 414 Clarifier repair 178,000 78,150 Project is complete, no more expense 414 Process control improvement 12,070 Study is almost complete 414 Incinerator improvement 66,040 Project completed 414 Switchgear improvements 73,150 Project complete. Cost will be $300k TOTAL TREATMENT PLANT PROJECTS 961,000 798,600 Page 35 Packet Page 48 of 84 AM-1247 1.E. 2007 Final Budget Amendment Finance Committee Meeting Date:11/14/2007 Submitted By:Debra Sharp, Administrative Services Time:10 Minutes Department:Administrative Services Action Information Subject 2007 Final Quarter Budget Amendment Previous Council Action None. Narrative In governmental budgeting, expenditures may take place up to the amount appropriated in the current budget. Financial activity impacting appropriation levels are brought before the Edmonds City Council on a quarterly basis in the form of a budget amendment ordinance. The final 2007 budget amendment contains a total of 8 proposed adjustments, one of which has previously been before Council. There are seven new items for Council to consider. The first three items are increases in General Fund expenditures for police and fire overtime and police uniforms. The expenditure increases are offset by grant revenue. The next three items are due to two long time employee retirements. The final amendment is a transfer from the Multimodel Project Fund to the General Fund for internal labor costs. Overall, General Fund requests total $79,528 of which $21,528 will be funded by grant revenue. With the transfer in from the Multimodel Project Fund, the net impact to the General Fund's ending cash is an increase of $3,947. Non-General Fund requests total $149,013. The net impact to Non-General Fund ending cash is a decrease of $149,013. Recommendation Forward ordinance to full council for approval Fiscal Impact Attachments Link: 2007 Final Budget Amendment Packet Page 49 of 84 ORDINANCE NO. _______ AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 3613 AS A RESULT OF UNANTICIPATED TRANSFERS AND EXPENDITURES OF VARIOUS FUNDS, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. WHEREAS, previous actions taken by the City Council require Interfund Transfers and increases in appropriations; and WHEREAS, state law requires an ordinance be adopted whenever money is transferred from one fund to another; and WHEREAS, the City Council has reviewed the amended budget appropriations and information which was made available; and approves the appropriation of local, state, and federal funds and the increase or decrease from previously approved programs within the 2007 Budget; and WHEREAS, the applications of funds have been identified; THEREFORE, THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO ORDAIN AS FOLLOWS: Section 1. Section 1. of Ordinance No. 3613 adopting the final budget for the fiscal year 2007 is hereby amended to reflect the changes shown in “Exhibit A” adopted herein by reference. Section 2. Effective Date. This ordinance, being an exercise of a power specifically delegated to the City legislative body, is not subject to referendum, and shall take L:\PRODUCTIONDB\CCOUNCIL\0011_1247_2007 FINAL AMENDING ORDINANCE.DOC Packet Page 50 of 84 effect five (5) days after passage and publication of an approved summary thereof consisting of the title. APPROVED: MAYOR, GARY HAAKENSON ATTEST/AUTHENTICATE: CITY CLERK, SANDRA S. CHASE APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: BY ___ W. SCOTT SNYDER, CITY ATTORNEY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. 2 Packet Page 51 of 84 SUMMARY OF ORDINANCE NO. __________ of the City of Edmonds, Washington On the ____ day of ___________, 2007, the City Council of the City of Edmonds, passed Ordinance No. _____________. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING ORDINANCE NO. 3613 AS A RESULT OF UNANTICIPATED TRANSFERS AND EXPENDITURES OF VARIOUS FUNDS, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. The full text of this Ordinance will be mailed upon request. DATED this _____ day of ________________,2007. CITY CLERK, SANDRA S. CHASE 3 Packet Page 52 of 84 EXHIBIT“A:” BUDGET SUMMARY BY FUND 2007 2007 FUND FUND BEGINNING REVENUE EXPENDITURES ENDING NO. DESCRIPTION CASH CASH 001 GENERAL FUND 3,551,328 30,535,372 33,009,094 1,077,606 006 EMERGENCY/FINANCIAL RESERVE 1,927,600 0 0 1,927,600 009 LEOFF-MEDICAL INS. RESERVE 338,670 476,095 497,250 317,515 104 DRUG ENFORCEMENT FUND 46,260 61,883 89,213 18,930 111 STREET FUND 101,683 1,273,029 1,343,834 30,878 112 COMBINED STREET CONST/IMPROVE 793,490 2,136,696 2,246,699 683,487 113 MULTIMODAL TRANSPORTATION FD. 0 625,000 625,000 0 116 BUILDING MAINTENANCE 247,138 1,760,725 1,729,510 278,353 117 MUNICIPAL ARTS ACQUIS. FUND 204,625 65,930 103,250 167,305 118 MEMORIAL STREET TREE 15,847 600 0 16,447 120 HOTEL/MOTEL TAX REVENUE FUND 55,268 63,625 66,625 52,268 121 EMPLOYEE PARKING PERMIT FUND 71,574 18,600 18,000 72,174 122 YOUTH SCHOLARSHIP FUND 8,303 2,740 3,200 7,843 123 TOURISM PROMOTIONAL FUND/ARTS 26,941 17,035 21,800 22,176 125 PARK ACQ/IMPROVEMENT 4,996,514 1,517,500 4,508,200 2,005,814 126 SPECIAL CAPITAL FUND 198,648 1,470,000 901,715 766,933 127 GIFTS CATALOG FUND 148,875 16,260 12,866 152,269 129 SPECIAL PROJECTS FUND 11,000 316,000 327,000 0 130 CEMETERY MAINTENANCE/IMPROV 160,240 261,214 180,559 240,895 131 FIRE DONATIONS 13,778 6,838 0 20,616 132 PARKS CONSTRUCTION 0 435,000 420,000 15,000 211 LID FUND CONTROL 1,766 351,000 345,300 7,466 213 LID GUARANTY FUND 41,529 2,000 0 43,529 234 LTGO BOND DEBT SERVICE FUND 0 415,710 415,710 0 411 COMBINED UTILITY OPERATION 4,787,026 14,434,776 15,512,719 3,709,083 412 COMBINED UTILITY CONST/IMPROVE 2,666,800 8,095,805 7,861,000 2,901,605 414 CAPITAL IMPROVEMENTS RESERVE 1,121,321 2,989,675 3,433,915 677,081 511 EQUIPMENT RENTAL FUND 3,739,375 2,296,632 2,805,780 3,230,227 601 PARKS TRUST FUND 124,908 4,000 0 128,908 610 CEMETERY MAINTENANCE TRUST FD 323,949 60,126 0 384,075 617 FIREMEN'S PENSION FUND 283,727 100,368 113,000 271,095 621 SPECIAL LIBRARY 0 0 0 0 623 SISTER CITY COMMISSION 14,937 21,200 20,000 16,137 Totals 26,023,120 69,831,434 76,611,239 19,243,315 4 Packet Page 53 of 84 EXHIBIT “B”: BUDGET AMENDMENTS BY EXPENDITURE ORD. NO. ORD. NO. ORD. NO. ORD. NO. 2007 FUND FUND 3613 3637 3660 Amended NO. DESCRIPTION 11/21/2006 4/17/2007 8/31/2007 Budget 001 GENERAL FUND 32,026,798 91,595 811,173 79,528 33,009,094 006 EMERGENCY/FINANCIAL RESERVE 0 0 0 0 0 009 LEOFF-MEDICAL INS. RESERVE 497,250 0 0 0 497,250 104 DRUG ENFORCEMENT FUND 89,213 0 0 0 89,213 111 STREET FUND 1,340,217 0 3,617 0 1,343,834 112 COMBINED STREET CONST/IMPROVE 2,215,699 31,000 0 0 2,246,699 113 MULTIMODAL TRANSPORTATION FD. 625,000 0 0 0 625,000 116 BUILDING MAINTENANCE 1,142,460 0 587,050 0 1,729,510 117 MUNICIPAL ARTS ACQUIS. FUND 103,250 0 0 0 103,250 118 MEMORIAL STREET TREE 0 0 0 0 0 120 HOTEL/MOTEL TAX REVENUE FUND 63,625 3,000 0 0 66,625 121 EMPLOYEE PARKING PERMIT FUND 18,000 0 0 0 18,000 122 YOUTH SCHOLARSHIP FUND 3,200 0 0 0 3,200 123 TOURISM PROMOTIONAL FUND/ARTS 21,800 0 0 0 21,800 125 PARK ACQ/IMPROVEMENT 4,508,200 0 0 0 4,508,200 126 SPECIAL CAPITAL FUND 880,661 0 21,054 0 901,715 127 GIFTS CATALOG FUND 4,866 8,000 0 0 12,866 129 SPECIAL PROJECTS FUND 316,000 11,000 0 0 327,000 130 CEMETERY MAINTENANCE/IMPROV 180,559 0 0 0 180,559 131 FIRE DONATIONS 0 0 0 0 0 132 PARKS CONSTRUCTION FUND 420,000 0 0 0 420,000 211 LID FUND CONTROL 345,300 0 0 0 345,300 213 LID GUARANTY FUND 0 0 0 0 0 234 LTGO BOND DEBT SERVICE FUND 415,710 0 0 0 415,710 411 COMBINED UTILITY OPERATION 13,528,375 104,500 1,792,778 87,066 15,512,719 412 COMBINED UTILITY CONST/IMPROVE 7,861,000 0 0 0 7,861,000 414 CAPITAL IMPROVEMENTS RESERVE 1,286,844 0 2,147,071 0 3,433,915 511 EQUIPMENT RENTAL FUND 2,610,299 30,000 78,415 87,066 2,805,780 601 PARKS TRUST FUND 0 0 0 0 0 610 CEMETERY MAINTENANCE TRUST FD 0 0 0 0 0 617 FIREMEN'S PENSION FUND 113,000 0 0 0 113,000 621 SPECIAL LIBRARY 0 0 0 0 0 623 SISTER CITY COMMISSION 20,000 0 0 0 20,000 Totals 70,637,326 279,095 5,441,158 253,660 76,611,239 5 Packet Page 54 of 84 EXHIBIT “C”: BUDGET AMENDMENT DETAIL Department Category Debit Credit Description Items Previously Before Council Utility Fund Interfund Transfer Out 69,653 Utility Fund Interfund Transfer Out 8,707 Utility Fund Interfund Transfer Out 8,707 Utility Fund Ending Fund Balance 87,066 Equipment Rental Interfund Transfer In 87,066 Equipment Rental Equipment 87,066 New Items for Council to Consider Police Overtime 9,091 Police Intergovernmental Srvc 9,091 Police Uniforms 7,841 Police Grant Revenue 7,841 Fire Overtime 4,596 Fire Grant Revenue 4,022 Fire Grant Revenue 574 Information Services Professional Services 12,000 Information Services Ending Fund Balance 12,000 Information Services Benefits 35,000 Information Services Ending Fund Balance 35,000 Public Works Benefits 11,000 Public Works Ending Fund Balance 11,000 Multimodel Transfer-Out 61,947 Multimodel Professional Services 61,947 Non-Departmental Ending Fund Balance 61,947 Non-Departmental Transfer-In 61,947 Increase in overtime - FBI investigation reimbursement Increase in uniforms - DOJ grant for ballistic vests Increase professional services - CIO new to city Increase budgets for the purchase of the Asphalt Zipper Transfer funds for labor expense paid out of the general fund Increase in benefits due to PERS 1 additional payout Increase in benefits due to change in personnel Increase in overtime - FEMA storm reimbursement 6 Packet Page 55 of 84 AM-1246 1.F. Mid-Biennial Review and Modification Ordinance Finance Committee Meeting Date:11/14/2007 Submitted By:Kathleen Junglov, Administrative Services Time:10 Minutes Department:Administrative Services Information Information Subject Mid-Biennial Review and Modification Ordinance Previous Council Action Ordinance No. 3592 adopting a Biennial Budget. Narrative Pursuant to RCW 35A.34.130 the City must adopt an ordinance providing for a mid-biennial review and modification of the biennial budget. Recommendation Forward attached ordinance to full council for approval. Fiscal Impact Attachments Link: Mid-Biennial Review and Modification Ordinance Packet Page 56 of 84 ORDINANCE NO. _______ AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING THE PROVISIONS OF CHAPTER 1.02 CITY CLASSIFICATION TO ADD A NEW SECTION 1.02.060 MID-BIENNIAL BUDGET REVIEW AND MODIFICATION, PROVIDING FOR SEVERABILITY, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. WHEREAS, by Ordinance No. 3592 the City of Edmonds has adopted a biennial budget process conducted pursuant to RCW 35A.34; and WHEREAS, pursuant to RCW 35A.34.130 the legislative authority of a city must provide by ordinance for a mid-biennial review and modification of the biennial budget, NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO ORDAIN AS FOLLOWS: Section 1. Adopted. Chapter 1.02 of the Edmonds City Code is hereby amended by the addition of a new Section 1.02.060 relating to the mid-biennial budget review and modification to read as follows: 1.02.060 Mid-biennial budget review and modification. A review of the mid-biennial budget shall commence no sooner than eight months after the start nor later than conclusion of the first year of the fiscal biennium. The mayor shall prepare the proposed budget modification and shall provide for publication of notice of hearings consistent with publication of notices for adoption of other city ordinances. Public hearings on the proposed budget modification shall be heard prior to the adoption of the ordinance modifying the biennial budget. At least seven (7) days before said hearings, the mayor shall distribute the proposed budget modification to members of the city council, with copies available to the public at City Hall. L:\Productiondb\CCOUNCIL\0013_1246_Mid-Biennial Review Ord.DOC Packet Page 57 of 84 Section 2. Severability. If any section, sentence, clause or phrase of this ordinance should be held to be invalid or unconstitutional by a court of competent jurisdiction, such invalidity or unconstitutionality shall not affect the validity or constitutionality of any other section, sentence, clause or phrase of this ordinance. Section 3. Effective Date. This ordinance, being an exercise of a power specifi- cally delegated to the City legislative body, is not subject to referendum, and shall take effect five (5) days after passage and publication of an approved summary thereof consisting of the title. APPROVED: MAYOR GARY HAAKENSON ATTEST/AUTHENTICATED: CITY CLERK, SANDRA S. CHASE APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: BY W. SCOTT SNYDER FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. Page 2 of 3 Packet Page 58 of 84 SUMMARY OF ORDINANCE NO. __________ of the City of Edmonds, Washington On the ____ day of ___________, 2007, the City Council of the City of Edmonds, passed Ordinance No. _____________. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, AMENDING THE PROVISIONS OF CHAPTER 1.02 CITY CLASSIFICATION TO ADD A NEW SECTION 1.02.060 MID-BIENNIAL BUDGET REVIEW AND MODIFICATION, PROVIDING FOR SEVERABILITY, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. The full text of this Ordinance will be mailed upon request. DATED this _____ day of ________________, 2007. CITY CLERK, SANDRA S. CHASE Page 3 of 3 Packet Page 59 of 84 AM-1237 1.G. 2007-2008 Mid-Biennial Budget Ordinance Finance Committee Meeting Date:11/14/2007 Submitted By:Kathleen Junglov, Administrative Services Time:10 Minutes Department:Administrative Services Action Information Subject 2007-2008 Mid-Biennial Budget Ordinance Previous Council Action Ordinance 3613 adopting the the 2007-2008 Budget (November 21, 2006). Narrative The 2007-2008 Budget was adopted on Tuesday, November 21, 2006. Both printed and on-line versions of the budget have been available since that date. A public hearing on modifications to the 2007-2008 Mid-biennial budget will be held on November 20, 2007. With the exception of Property Taxes, there are no changes to the 2008 Budget as originally adopted. The attached ordinance is a draft and can be adopted as is or with Council amendments. Recommendation Refer the 2007-2008 Mid-Biennial Budget Ordinance to full council. Fiscal Impact Attachments Link: 2007-2008 Mid-Biennial Budget Ordinance Packet Page 60 of 84 ORDINANCE NO. _______ AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, MODIFYING THE 2008 BUDGET AS ADOPTED BY REFERENCE IN ORDINANCE NO. 3613, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. WHEREAS, the City adopted the 2007-2008 Biennial Budget on November 21, 2006; and WHEREAS on ___________ the City Council adopted Ordinance No. _____ that requires a mid-biennium review of the second year of each biennial budget; and WHEREAS, the City has completed its mid-biennium review of the 2007-2008 Adopted Budget; and WHEREAS, the City finds it necessary to adjust anticipated Property Tax Revenue, THEREFORE, THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO ORDAIN AS FOLLOWS: Section 1. Section 1. of Ordinance No. 3613 adopting the final budget for the 2007-2008 biennium is hereby amended to reflect the changes shown in “Exhibit A” adopted herein by reference. Section 2. Effective Date. This ordinance, being an exercise of a power specifically delegated to the City legislative body, is not subject to referendum, and shall take L:\PRODUCTIONDB\CCOUNCIL\0015_1237_2007-2008 MID-BIENNIAL ORDINANCE.DOC Packet Page 61 of 84 effect five (5) days after passage and publication of an approved summary thereof consisting of the title. APPROVED: MAYOR, GARY HAAKENSON ATTEST/AUTHENTICATE: CITY CLERK, SANDRA S. CHASE APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: BY ___ W. SCOTT SNYDER, CITY ATTORNEY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. 2 Packet Page 62 of 84 SUMMARY OF ORDINANCE NO. __________ of the City of Edmonds, Washington On the ____ day of ___________, 2007, the City Council of the City of Edmonds, passed Ordinance No. _____________. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, MODIFYING THE 2008 BUDGET AS ADOPTED BY REFERENCE IN ORDINANCE NO. 3613, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. The full text of this Ordinance will be mailed upon request. DATED this _____ day of ________________,2007. CITY CLERK, SANDRA S. CHASE 3 Packet Page 63 of 84 EXHIBIT“A:” BUDGET SUMMARY BY FUND 2008 Beginning 2008 Ending Fund Balance Revenue Expenditures Fund Balance 001 GENERAL FUND 2,972,617 30,798,213 33,281,772 489,058 006 EMERGENCY/FINANCIAL RESERVE 1,927,600 0 0 1,927,600 009 LEOFF-MEDICAL INS. RESERVE 317,515 535,492 561,938 291,069 104 DRUG ENFORCEMENT FUND 18,930 70,035 70,035 18,930 111 STREET FUND 34,495 1,360,059 1,362,403 32,151 112 COMBINED STREET CONST/IMPROVE 694,487 2,353,047 2,820,895 226,639 113 MULTIMODAL TRANSPORTATION FD. 0 2,000,000 2,000,000 0 116 BUILDING MAINTENANCE 278,353 64,100 193,000 149,453 117 MUNICIPAL ARTS ACQUIS. FUND 167,305 65,930 77,250 155,985 118 MEMORIAL STREET TREE 16,447 600 0 17,047 120 HOTEL/MOTEL TAX REVENUE FUND 55,268 65,206 65,206 55,268 121 EMPLOYEE PARKING PERMIT FUND 72,174 18,600 18,510 72,264 122 YOUTH SCHOLARSHIP FUND 7,843 2,850 3,200 7,493 123 TOURISM PROMOTIONAL FUND/ARTS 22,176 17,483 21,800 17,859 125 REAL ESTATE EXCISE TAX 2 2,005,814 1,488,808 3,388,000 106,622 126 REAL ESTATE EXCISE TAX 1, PARKS ACQ FUND 787,987 1,470,000 869,550 1,388,437 127 GIFTS CATALOG FUND 152,269 8,700 1,600 159,369 130 CEMETERY MAINTENANCE/IMPROVEMT 240,895 265,364 170,645 335,614 131 FIRE DONATIONS 19,616 5,838 0 25,454 211 L.I.D. FUND CONTROL 7,466 251,000 243,300 15,166 213 L.I.D. GUARANTY FUND 43,529 2,000 0 45,529 234 LIMITED TAX G.O. BOND FUND, 0 421,973 421,973 0 411 COMBINED UTILITY OPERATION 3,787,218 12,626,193 13,023,174 3,390,237 412 COMBINED UTILITY CONST/IMPROVE 2,136,605 4,519,897 5,346,000 1,310,502 414 CAPITAL IMPROVEMENTS RESERVE 782,459 440,887 552,076 671,270 511 EQUIPMENT RENTAL FUND 3,286,108 2,101,015 1,363,287 4,023,836 601 PARKS TRUST FUND 128,908 4,000 0 132,908 610 CEMETERY MAINTENANCE TRUST FD 384,075 60,126 0 444,201 617 FIREMEN'S PENSION FUND 271,095 103,000 113,000 261,095 623 SISTER CITY COMMISSION 16,137 21,200 23,500 13,837 TOTALS 20,635,391 61,141,616 65,992,114 15,784,893 4 Packet Page 64 of 84 AM-1236 1.H. Preliminary 2008 Property Tax Ordinance Finance Committee Meeting Date:11/14/2007 Submitted By:Kathleen Junglov, Administrative Services Time:10 Minutes Department:Administrative Services Action Information Subject Preliminary 2008 Property Tax Ordinance Previous Council Action None. Narrative As part of budget adoption the City is required to adopt a property tax ordinance that provides funding for overall City operations ($9,075,000), Emergency Medical Service ($2,452,000), and voter approved public safety bonds ($817,373). This draft form of the ordinance would see the City’s portion of the property tax rate increase 1%. Recommendation Review preliminary 2008 Property Tax Ordinance and recommend approval to the full Council during budget deliberations. Total revenue collected is approximately $12,344,373. Fiscal Impact Attachments Link: Preliminary 2008 Property Tax Ordinance Packet Page 65 of 84 ORDINANCE NO. ______ AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, PROVIDING FOR THE ANNUAL TAX LEVY BY INCREASING THE REGULAR PROPERTY TAX LEVY BY THE CURRENT 101% LEVY LIMIT, THEREBY LEVYING AN ESTIMATED REGULAR PROPERTY TAX LEVY OF $9,075,000, BY INCREASING THE EMS PROPERTY TAX LEVY BY THE CURRENT 101% LEVY LIMIT, THEREBY LEVYING AN EMS LEVY OF $2,452,000, AND LEVYING $817,373 FOR VOTED INDEBTEDNESS FOR THE PUBLIC SAFETY COMPLEX, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. WHEREAS, the City Council and the City of Edmonds have properly given notice of the public hearing held on November 20, 2007, to consider the City's current expense budget for 2008, pursuant to RCW 84.55.120; and WHEREAS, the City Council in the course of considering the budget for 2008 have reviewed all sources of revenue and examined all anticipated expenses and obligations; and WHEREAS, the City Council hereby determines following public hearing that it is in the best interest of and necessary to meet the expenses and obligations of the City to increase the regular property levy by 1%, and the EMS levy by 1%; and WHEREAS, the Snohomish County Assessor’s Office has requested that all Snohomish County Taxing Districts submit their levy certifications to the county on the State Department of Revenue standardized form REV 64 0100; NOW, THEREFORE THE CITY COUNCIL OF THE CITY OF EDMONDS, WASHINGTON, DO ORDAIN AS FOLLOWS: L:\Productiondb\CCOUNCIL\0017_1236_Property Tax Ord - 1%.DOC Page 1 of 5 Packet Page 66 of 84 Section 1. The limit factor for the regular levy to be collected in budget year 2008 shall be 101% of the highest amount of regular property taxes that could have been levied in the City in any year since 1985. Section 2. The 2007 regular property tax levy for collection in 2008 is the amount levied in 2006 for collection in 2007, plus an increase of $88,201 which is a percentage increase of 1%, plus an increase equal to the amount allowed under the new construction provisions of RCW 84.55.010 for an estimated total of $9,075,000. Section 3. The 2007 Emergency Medical Services (EMS) property tax levy for collection in 2008 is the amount levied in 2006 for collection in 2007, plus an increase of $23,827 which is a percentage increase of 1%, plus an increase equal to the amount allowed under the new construction provisions of RCW 84.55.010 for an estimated total of $2,452,000. Section 4. There shall be and is hereby levied current taxes of $817,373, the purpose of which is to make debt service payments on voter approved bonds. Section 5. The levies contained in sections 2 through 4 are subject to amendment upon receipt of 2008 assessed valuation from Snohomish County. Section 6. Pursuant to the request by the Snohomish County Assessor’s Office, the Administrative Services Director is hereby authorized to submit to the Snohomish County Council certification of the hereby approved levies on the State Department of Revenue standardized form REV 64 0100 attached hereto as Exhibit A. Section 7. Effective Date. This ordinance, being an exercise of a power specifically delegated to the City legislative body, is not subject to referendum, and shall take effect five (5) days after passage and publication of an approved summary thereof consisting of the title. It is enacted on a vote of a majority plus one of the City Council. L:\Productiondb\CCOUNCIL\0017_1236_Property Tax Ord - 1%.DOC Page 2 of 5 Packet Page 67 of 84 APPROVED: MAYOR, GARY HAAKENSON ATTEST/AUTHENTICATED: CITY CLERK, SANDRA S. CHASE APPROVED AS TO FORM: OFFICE OF THE CITY ATTORNEY: BY FILED WITH THE CITY CLERK: PASSED BY THE CITY COUNCIL: PUBLISHED: EFFECTIVE DATE: ORDINANCE NO. L:\Productiondb\CCOUNCIL\0017_1236_Property Tax Ord - 1%.DOC Page 3 of 5 Packet Page 68 of 84 SUMMARY OF ORDINANCE NO. __________ of the City of Edmonds, Washington On the ____ day of ___________, 2007, the City Council of the City of Edmonds, passed Ordinance No. _____________. A summary of the content of said ordinance, consisting of the title, provides as follows: AN ORDINANCE OF THE CITY OF EDMONDS, WASHINGTON, PROVIDING FOR THE ANNUAL TAX LEVY BY INCREASING THE REGULAR PROPERTY TAX LEVY BY THE CURRENT 101% LEVY LIMIT, THEREBY LEVYING AN ESTIMATED REGULAR PROPERTY TAX LEVY OF $9,075,000, BY INCREASING THE EMS PROPERTY TAX LEVY BY THE CURRENT 101% LEVY LIMIT, THEREBY LEVYING AN EMS LEVY OF $2,452,000, AND LEVYING $817,373 FOR VOTED INDEBTEDNESS FOR THE PUBLIC SAFETY COMPLEX, AND FIXING A TIME WHEN THE SAME SHALL BECOME EFFECTIVE. The full text of this Ordinance will be mailed upon request. DATED this _____ day of _________________, 2007. CITY CLERK, SANDRA S. CHASE L:\Productiondb\CCOUNCIL\0017_1236_Property Tax Ord - 1%.DOC Page 4 of 5 Packet Page 69 of 84 Exhibit A – Levy Certification Levy Certification Submit this document to the county legislative authority on or before November 30 of the year preceding the year in which the levy amounts are to be collected and forward a copy to the assessor. In accordance with RCW 84.52.020, I, Dan Clements , (Name) Administrative Services Director , for City of Edmonds , do hereby certify to (Title) (District Name) the Snohomish County legislative authority that the Council (Name of County) (Commissioners, Council, Board, etc.) of said district requests that the following levy amounts be collected in 2008 as provided in the district’s (Year of Collection) budget, which was adopted on November 20, 2007 : (Date of Public Hearing) Regular Levy: $9,075,000 (State the total dollar amount to be levied) Excess Levy: $817,373 (State the total dollar amount to be levied) EMS Levy: $2,452,000 (State the total dollar amount to be levied) Dan Clements Date: November 21, 2007 Signature: L:\Productiondb\CCOUNCIL\0017_1236_Property Tax Ord - 1%.DOC Page 5 of 5 Packet Page 70 of 84 AM-1251 1.I. Broadband Up-Date Finance Committee Meeting Date:11/14/2007 Submitted By:Dan Clements, Administrative Services Time:10 Minutes Department:Administrative Services Action Information Subject Broadband Up-Date Previous Council Action Council has previously approved a business plan bid award, budget for funds to provide broadband services to local governmental entities and not-for-profits. There are preliminary customer and marketing contracts currently under consideration. Narrative As discussions of the City's broadband initiative continue, it has been suggested that staff provide Council with a formal up-date of the project's status, prior to receipt of the complete business plan scheduled for late December. The purpose of this discussion is to frame the future discussion with the full Council. Recommendation Discuss timing and elements to be included in the Council broadband briefing. Fiscal Impact Attachments No file(s) attached. Packet Page 71 of 84 AM-1249 1.J. Broadband Customer Contracts Finance Committee Meeting Date:11/14/2007 Submitted By:Dan Clements, Administrative Services Time:10 Minutes Department:Administrative Services Action Information Subject Broadband Customer Contracts Previous Council Action Council has previously approved acquisition of equipment necessary to provide broadband services to other jurisdictions and governmental entities. Narrative For a number of months the City has been working with other governmental and not-for-profit entities regarding the City's providing broadband services. Staff have also been working with legal counsel on formal contracts to provide these services. The attached contract represents the contract that is proposed to be used with the Edmonds School District, and will be the form used with other governmental and not-for-profit entities. Recommendation Approve Edmonds School District Contract both in its use with the District, and as a model for other entities. Fiscal Impact Attachments Link: Edmonds_Contract Packet Page 72 of 84 L:\PRODUCTIONDB\CCOUNCIL\0020_1249_EDMONDS SCHOOL DISTRICT CONTRACT RGJ EDITS.DOC D R A F T s Fiber Optic Service Agreement Edmonds School District __________, 2007, of Edmonds and Edmonds School District, providing for fiber optic services to Edmonds School District by the City of Edmonds. The 1. 1. and internet n and data ices to the lice services, and lib nd the community hese efforts ond sophisticated ndant connectivity. 1.3 The installation of an advanced fiber network allows the City to enjoy substantial additional capacity in the system and the opportunity to supply broad band fiber optic and internet connection services to other government institutions, such as the District, on a basis that will expand the internal communication abilities and the educational out reach of those institutions, while at the same time lowering the overall cost of the fiber optic network to the City and enhancing the robustness of the City’s fiber optic system. The additional capacity will also enable the City to expand its own usage in future years to serve City agencies and to serve the citizens of Edmonds. City of Edmond with This Fiber Optic Service Agreement is entered into this ______ day of ___ between the City City of Edmonds (“City”) and Edmonds School District (“District”) agree as follows: Findings 1 The City is building a high speed, broad band fiber optic network connection in the City in order to provide advanced telecommunicatio management services to its various departments and to enhance city serv public, including but not limited to water and sewer services, fire and po rary and park services. 1.2 The District is poised to expand its outreach to students, staff, a in order to advance instructional and communication goals. However, t cannot be expanded adequately and efficiently without access to a sec broadband fiber network and internet connection which provides redu Packet Page 73 of 84 Edmonds School District Broadband Agreement Page 2 of 11 2. Term 2.ive date. he date on which the fiber optic connection is completed to the District, and the District has tested the connection by 2.e the agreement ten notice to the other party. ement will extend 2.5 Either party may then terminate the agreement at the end of each successive one- 3. Ci The City will provide the following services (either with its own employees or through its co 3.ion to a demarcation patch pa 3.1.1 ___________________________________________________ _____ 3.se of the City fiber .1. 3.3 the District for a um of five years. 3.4 Use its best efforts to provide a 99 percent standard of reliability of the network internet connection, excluding (1) – two hour scheduled maintenance window per month during weekend hours (Friday at 9 PM – Monday at 3 AM). 3.5 Bill the District on a monthly basis on the basis of rate principles established in section 6.4. 1 The initial term of this agreement is five years from its effect 2.2 The effective date of this agreement shall be t sending and receive internet traffic at the demarcation patch panel. 3 At the end of the initial five-year term, either party may terminat on ninety days’ advance writ 2.4 If not terminated at the end of the initial five-year term, the agre automatically on a year to year basis. year extension on ninety days’ advance written notice to the other party. ty Obligations ntractors) to the District: 1 Install a high speed broad band fiber cable and connect nel attached to the District at the following locations: 3.1.2 ______________________________________________ 2 Supply metering facilities capable of measuring the District’s u network on an industry standard basis, as described below in section 6.4 Operate and maintain the City’s high speed broad band internet connection and fiber system, including the connections to demarcation patch panels at minim Packet Page 74 of 84 Edmonds School District Broadband Agreement Page 3 of 11 4. District Obligations rn for the services provided by the City under section 3, the District will do the fo table locations for installation of high speed broad band fiber cable and connections to dem 4.2 Provide the City with access to District property to install the fiber connections an ground procedure to rapidly obtain 24 hour a day/seven days per we t at the locations er locations on District property over which the City fiber system is connected. ponsibility for the District’s communication systems on the District’s side of the demarcation patch panels. ling date. 5. Te 5.1 Technical specifications of the City’s broad band fiber system and internet co ibed in Exhibit A, e during the ter Should the specifications change, the City will attempt to inform the District of e changes sixty at least days prior to the change. However, because there may be ity does not to the District. to request and obtain the most up to date technical specifications in the possession of the City. In retu llowing: 4.1 Provide sui arcation patch panels attached to the District at the at the locations described in section 3.1. d fiber optic cable, together with underground conduits should under connections be required. 4.3 Provide the City with a ek access to the demarcation patch panels attached to the Distric described in section 3.1, and any oth 4.4 Assume full res 4.5 Pay the City invoice for costs and fees, within 30 days of the bil chnical Specifications nnection existing at the time this agreement is entered into are descr which is made a part of the agreement. 5.2 The City reserves the option to change those specifications at any tim m of the contract. 5.3 thos multiple changes to the system over the term of the agreement, the C guarantee that all changes in technical specifications will be provided 5.4 The District has the option at any time 6. Pricing The City will charge the District for high speed, broad band fiber optic network and internet connection under the following categories (1) installation costs amortized over five years, (2) maintenance expenses, inclusive of any federal, state, City, or other local taxes, (3) port charges, and (4) bandwidth usage charges. Packet Page 75 of 84 Edmonds School District Broadband Agreement Page 4 of 11 6.1 Installation The installation cost of connecting to the District will be charged to i agreement. 6.1.1 The estimated cost of installing the fiber optic connection and demarcation Exhibit B ount is only an estimate. The actual installation costs, which may installation financed over 5 years using an interest he time the arged for t, the monthly tervening installations or other capital costs agreed upon in writing by both parties. 6. the D strict at cost and amortized over the initial five year term of the patch panel at the locations specified in section 3.1 is provided in 6.1.2 This am be different, will be the amount used to calculate the amortized charges to the District. 6.1.3 The actual installation costs will rate of 1.5% over the State’s investment pool rate in effect at t agreement is adopted. This monthly fixed monthly payment, will be ch the first sixty months of billing under the agreement. 6.1.4 After the first sixty months of billing under the agreemen charges for installation will cease, unless there are additional in 2 Maintenance A charge for ongoing maintenance will be separately identified on the City’s monthly billing to the District. The components of that modest maintenance ch part on the length of connection between the connection points to the District and the City’s fiber ith the d the metering mechanisms necessary to operate the connections to the District. 6.3 arge are: 6.2.1 Maintenance of fiber and conduits based in system. 6.2.2 Maintenance of the hardware and software associated w demarcation patch panels at the connections to the District an 6.2.3 Proportionately allocated federal, state, and local taxes. Port Charge A fixed monthly port charge will be billed to the District for each nection to the ay later be added. 6.3.1 The port charges identified in the illustrative Exhibit B will remain fixed for the initial five-year term of the agreement. They may be then changed by the City on an annual basis provided the City gives the District 180 days’ advance written notice of changes in the monthly port charges. 6.4 Bandwidth connection point identified above in section 3.1 and for any other con District that m A fourth component of charges to the District will be based on bandwidth usage. Packet Page 76 of 84 Edmonds School District Broadband Agreement Page 5 of 11 6.4.1 The City will utilize an thindustry standard “95 percentile” method of com trict’s usage in 5 minute intervals over t month. ghest 5 minute r discarding the top 5 percent. 6 price schedule or n harges will be thly bandwidth charge is established, regardless monthly bandwidth guarantees are available at the 10, 15, 20, 30 and 50 mb/month levels. , any higher usage ociated with that rantee level. inimum mb/month es will be higher. Bandwidth measured by the above in section 6.4.1. puting network utilization as follows: 6.4.1.1 The City will track the Dis the course of a calendar month. 6.4.1.2 The City will then sort the intervals based on usage (highest to lowest) and discard the top 5 percent of intervals for tha 6.4.1.3 The City will then compute usage based on the hi interval remaining afte .4.2 The District will have a choice of a minimum bandwidth o minimum bandwidth price schedule. 6.4.2.1 The rates per mb of bandwidth usage and port c lower if a minimum mon of the actual usage. 6.4.2.2 Minimum 6.4.2.3 If a minimum monthly bandwidth is guaranteed by the District will be charged at the lower $/mb rate ass minimum gua 6.4.2.4 Should the District choose not to guarantee a m bandwidth, the bandwidth and port charg will be based only on the actual usage during the month “95th percentile” method of computing network utilization described 6 on or a specific l strict is outlined 6.4.3.2 As the Bandwidth requirements of the District increase, the District will be able to increase their minimum bandwidth commitment in order to take advantage of the lower unit costs. The District must request modification of the billing structure in writing, and it will take effect the billing period that follows the date the notice is received plus 30 days. The District may only reduce its minimum bandwidth commitment on the anniversary date of the agreement or subsequent renewals. .4.3 The District must select the no minimum bandwidth opti evel of minimum bandwidth at the inception of the agreement. 6.4.3.1 The bandwidth option initially selected by the Di in Schedule B. Packet Page 77 of 84 Edmonds School District Broadband Agreement Page 6 of 11 6.4.4 The Pricing Matrix identified in Exhibit B will remain fi five-year term of the agreement After the initial five-year term changed by the City on an annual basis provided xed for the initial , the rates may be the City gives the District 180 days’ advance written notice of changes in bandwidth charges. 7. No 7. very, U.S. Mail, FedEx (or other express delivery service), fax, or e-mail. , however, only on the date received. 7. Director onds, WA 98020 5.771.0239 ents@ci.edmonds.wa.us tices 1 Notices required under this agreement must be in writing. 7.1.1 Written notices may be delivered by hand-deli 7.1.2 Notices will be effective 2 Notices to the City should be sent to the following Name Dan Clements Position Administrative Services Street Address 121 Fifth Avenue North, Edm Phone Number 42 e-mail address clem 7.o the District should be sent to the following Street Address 7.4 The designated recipients for written notices may be changed at any time during th arty in writing. . 8.ssor or assign, provided 8.2 Approval of a request for transfer to a successor or assign must not be unreasonably withheld. 9. Limitation of Liability 9.1 The City has no responsibility for any data loss or any other consequential damages that may result from the failure, interruption or poor performance of its high speed, broad band fiber optic network and internet connection. 3 Notices t Name Position Phone Number e-mail address e agreement, so long as the change is delivered to the other p 8 Successors and Assigns 1 This agreement may be assigned by either party to a succe the other party agrees in writing. Packet Page 78 of 84 Edmonds School District Broadband Agreement Page 7 of 11 re, interruption, or network and internet s proportional to the time of the failure, in third-party beneficiaries of this agreement. 10. y losses or other from the operation and maintenance of the City’s high speed broad band unless the loss or solely responsible. pt make the other party an additional insured on all policies. 10.3 If that is not possible, each party will notify the other of the issue, at which point one or the other 11. n ity and the f the City’s high speed . d drafts. nless it is in the form of a written reement. 12. ompetent hose provisions will be severed from the agreement and the obligations of the parties will continue under the remaining terms of the agreement. 12.2 If a court of competent jurisdiction finds this agreement to be beyond the legal authority of the City to provide internet broadband services on a service contract basis, the parties agree to enter into an interlocal agreement providing for a joint arrangement to provide each government with its own internal communication under the unified management and operation of the City of Edmonds in accord with the provisions of this service agreement. 9.2 The only remedy available to the District as a result of the failu poor performance of the City’s high speed, broad band fiber optic connection is the reduction of City charge terruption, or poor performance. 9.3 There are no Indemnity and Insurance 10.1 The City and the District mutually indemnify each other for an claims arising internet connection and fiber system during the term of this agreement, claim is caused solely by either the City or the District, in which case that party will be 10.2 The City and District will review their respective insurance policies and attem to additional insurance policies may be recommended and obtained by party. I tegration 11.1 This agreement represents the complete agreement between the C District relating to the installation, maintenance and operation o broad band internet connection and fiber system 11.2 The agreement integrates within it all prior discussions an 11.3 No amendment to the agreement will be valid, u amendment that specifically amends or specifically supersedes this ag Severability 12.1 If any part of this agreement is held to be invalid by a court of c jurisdiction, t Packet Page 79 of 84 Edmonds School District Broadband Agreement Page 8 of 11 13. Force s during a period g so by a force majeure event including natural disasters such as windstorms and earthquakes, terrorist attacks or other public safety nd injunctions or other court orders. 14 14 he course of this ag will be handled as follows: President of the 14.1.2 If the Mayor of the City and the President of the District are unable to cil of the City e a special joint the City Council of the able to resolve the City and the President of the District will meet to agree in thirty the City and the District. If he Mayor of the City and the President of the District cannot agree on a ding judge of ty Superior Court. 14.1.4 If the dispute is still not resolved within two weeks after the parties meet ial remedy. 14.1.5 Any court costs and attorney and witness fees will be borne separately by the City and the District. 14.2 This agreement is entered into and will be interpreted under Washington law. 14.3 The judicial forum for resolving any dispute, after the procedures outlined in Section 14.1 are exhausted, will be in Snohomish County Superior Court. Majeure The parties to this agreement will be not be required to carry out its term when either party is prevented from doin emergencies, a Dispute Resolution .1 It is not anticipated that any significant disputes will arise in t reement. If disputes do arise, however, they 14.1.1 The first step will be for the Mayor of the City and the District to meet in an attempt to resolve the dispute. resolve the problem within two weeks of meeting, the City Coun and the Board of Trustees of the District will be asked to conven meeting to address the issue. 14.1.3 If within two weeks after meeting in joint session, City and the Board of Trustees of the District are together un dispute, the Mayor of the on a non-binding mediator who will be hired to convene the parties with days. The cost of the mediator will be shared equally by mediator, a non-binding mediator will be appointed by the presi Snohomish Coun in non-binding mediation, either party may then seek a judic Packet Page 80 of 84 Edmonds School District Broadband Agreement Page 9 of 11 Agreement Approved: , 20____. DATED THIS ________ DAY OF _____________________ CITY OF EDMONDS Mayor Gary Haakenson By: ATTEST/AUTHENTICATED: Sandra S. Chase, City Clerk APPR By: OVED AS TO FORM: W. Scott Snyder, City Attorney Edmonds School District Signature on be of Edmonds School trict: half Dis Printed Name: Marla Miller Title: VP Business Services Date: Packet Page 81 of 84 Edmonds School District Broadband Agreement Page 10 of 11 EXHIBIT A Interface Specifications and Requirements 1. {To be established} Packet Page 82 of 84 Edmonds School District Broadband Agreement Page 11 of 11 EXHIBIT B Pricing Matrix of mitment of 10 Mbps for the term of ent. This minimum commitment can be modified UPWARD given 30 days notice pursuant to the terms of Section 6.4.3.2 of this agreement. 3. Pri 1. The following Pricing Matrix reflect the agreed upon pricing to be used for the term this agreement 2. The District has chosen a minimum bandwidth com the agreem cing Matrix: Edmonds Fiber Network - w/minimum BW Commitment Monthly Charges Minimum Committed Usage (MB) Port Charge Capital Amort on izati Maint Bandwidth Total Per MB 10 $50 $1 0 $898 $65 58 $40 $65 15 $50 $158 $40 $930 $1,178 $62 20 $50 $158 $40 $1,200 $1,448 $60 30 $50 $158 $40 $1,710 $1,958 $57 50 $50 $158 $40 $2,600 $2,848 $52 on the 95th percentile calculation method is 10mb or less the monthly charge will be $898 plus any applicable taxes. e District’s m ge based on the 95 th percentile calculation method exceeds b, the monthl lculated as follows: Example: (Assuming 11.25mb usage for the period) 4. If the District’s monthly usage based 5. If th onthly usa 10m y charge will be ca Component Calculation Charge Port Charge Fixed Rate Component $50.00 Amortized Capital Costs Fixed Rate Component $158.00 Maintenance Charge Fixed Rate Component $40.00 Minimum Bandwidth Charge Minimum Bandwidth Charge $650.00 Bandwidth Overage (Assuming actual bandwidth at 11.25mb for the period) 11.25 – 10.00= 1.25mb x $65 = $81.25 $81.25 Total Total Monthly Charge for 11.25 Mbps $979.25 Packet Page 83 of 84 AM-1250 1.K. Broadband Marketing Contract Finance Committee Meeting Date:11/14/2007 Submitted By:Dan Clements, Administrative Services Time:10 Minutes Department:Administrative Services Action Information Subject Broadband Marketing Contract Previous Council Action Council has previously approved funds for the acquisition of equipment necessary to provide broadband services to local governmental and not-for-profit entities. There is currently a request before Council to approve a contract to provide these services with the Edmonds School District. Narrative The City and Community Technology Advisory Committee (CTAC) have met on several occasions to discuss ways in which the City's broadband services can be best marketed, especially during a transition period where services are still being developed. All parties agree that it would be most effective to contract with Rick Jenness of Procom.sis. There were fairly lengthy discussions of a set commission basis versus an hourly rate plus signing bonus. For a variety of reasons, the recommending being forwarded is for an hourly rate plus one time fixed percent for customers signed up. Recommendation Confirm the method of marketing compensation so that a final contract with Rick Jenness of Procom.sis can be developed and brought forward to the full Council. Fiscal Impact Attachments No file(s) attached. Packet Page 84 of 84