Loading...
HomeMy WebLinkAbout11-17-2014 PUBLIC WORKS COMMITTEE AGENDA MODIFICATIONCITY OF AUBU WASHINGTON To: Public Works Committee From: Ingrid Gaub, Assistant Director of Engineering /City Engineer Memorandum CC: Mayor City Clerk Councilmembers Kevin Snyder, Community Development & Public Works Director Jacob Sweeting, Assistant City Engineer Shelley Coleman, Finance Director Paula Barry, Assistant Finance Director Brenda Goodson - Moore, Utility Billing Customer Care Manager Date: November 13, 2014 Re: Agenda Modification for the November 17, 2014 Meeting This modification adds the following item to the agenda: IV. DISCUSSION ITEMS H. Auburn Manor Leak Adjustment (Coleman) 1. Quarterly Financial Report (Coleman) AUBURN * MORE THAN YOU IMAGINED CITY OF * AUBURN WASHINGTON Interoffice Memorandum To: Shelley Coleman, Finance Director From: Brenda Goodson - Moore, Utility Billing Customer Care Manager CC: Paula Barry, Assistant Finance Director Date: November 12, 2014 Re: Auburn Manor Leak Adjustment Request On October 7, 2014, Finance staff met with Public Works, Mayor Backus and Mr. John Sherwood, the manager at Auburn Manor Mobile Home Park. Mr. Sherwood requested the meeting to discuss the ongoing high consumption and leak issues at Auburn Manor. Mr. Sherwood submitted a leak adjustment request on August 14, 2014. On September 3, 2014, a letter denying the leak adjustment request was sent to Mr. Sherwood's attention, at Auburn Manor. The request was denied based upon the fact that the technician was unable to obtain a still read on the meter after Mr. Sherwood notified the tenants at the park not to use the water. The technician indicated in his notes that he believed that the park still had some type of leak. Additionally, there were two other large Mobile Home Parks which were also denied a leak adjustment under the same circumstances. Per our conversation with Mr. Sherwood, he concurred that the park has additional existing water leaks. He stated that he and his company, Cal -Am properties, are committed to repairing leaks intermittently as they are not able to repair their entire system at this time. Mr. Sherwood is requesting that the City reconsider his leak adjustment request denial and grant him a sewer credit subsequent to the two repairs most recently made. Mr. Sherwood provided copies of two repair receipts. One receipt is dated June 2, 2014 for $5,579.03 for repair of a leak in the water line. The second receipt is dated July 15, 2014 for $4,248.60 for repair of a leak in the water line as well. The Mayor explained to Mr. Sherwood that a leak adjustment denial appeal would be submitted to the Finance Director and then on to council committees and full council for consideration. Please see the attached two adjustment options that may be considered along with policy 100 -52. Additionally, there were two other large Mobile Home Parks which were also denied a leak adjustment under the same circumstances. Page 1 of 11 AUBURN - MORI THAN YOU IMAGINED Agenda Subject: Auburn Manor Leak Adjustment Request Date: November 12, 2014 Department: Finance Attachments: Memo, Policy, 2 mos adjustment option, 6 mos adjustment option, Timeline Budget Impact: $0 Administrative Recommendation: Council review Auburn Manor Leak Adjustment Request. Background Summary: See attached memo and documents. Reviewed by Council ❑ Arts Commission ❑ Airport ❑ Hearing Examiner ❑ Human Services ❑ Park Board ❑ Planning Comm. & Committees: COUNCIL COMMITTEES: ® Finance ❑ Municipal Serv. ❑ Planning & CD ®Public Works ❑ Other Reviewed by Departments & ❑ Building ❑ ❑ Cemetery ❑ ❑ Finance ❑ ❑ Fire ❑ ❑ Legal ❑ ❑ Public Works ❑ ❑ Information Services Divisions: M &O Mayor Parks Planning Police Human Resources Action: Committee Approval: Council Approval: Referred to Tabled E Yes ❑No E Yes ❑No Call for Public Hearing _ /_ /, Until / / Until / / Councilmember: Osborne Staff: Coleman Meeting Date: November 17, 2014 Item Number: Page 2 of 11 ADMINISTRATIVE POLICY AND PROCEDURE TITLE: UTILITY SERVICE WATER LEAK ADJUSTMENT SUBJECT: UTILITY BILLING & COLLECTION INDEX NUMBER: 100 -52 EFFECTIVE DATE 1/22/13 SUPERSEDES 11/07/11 PAGE 1 of 3 PREPARED BY: SHELLEY COLEMAN 1.0 PURPOSE To provide a procedure for the approval, calculation and adjustment of water and sewer charges (single family & non - single family account classifications) where excessive water consumption can be attributed to a water leak. For this purpose, a water leak is defined to occur on the service line between the City water meter and the point where the line enters the building. 2.0 ORGANIZATIONS AFFECTED 3.0 REFERENCES 4.0 POLICY 4.1 Customer must request adjustment in writing by completing a request form located at the Finance Department in City Hall or the City website. Required information shall include: a. Name, service address where leak occurred and account number b. Description of leak and date repaired c. Copy of repair bill or materials receipts d. Signature of customer 4.2 Upon receipt of the completed request form, a representative of the City Water Division will confirm, through visual check of the City meter, that the leak has been repaired. 4.3 A water adjustment may be granted, following confirmation of repair, if the leak is determined to be on the service line. Finance personnel will adjust the water charge for no more than two (2) water billing cycles (4 months), if consumption is billed bi- monthly; or 3 billing cycles (3 months), if consumption is billed monthly. Water adjustments are limited to a $500 maximum, see section 4.6. Single- family account types will have water only adjusted. Only non - single family account types are eligible for sewer adjustments. See section 4.3.1 for sewer adjustments. 4.3.1 A sewer adjustment may be granted for non - single family account types where the customer's sewer bill is based on the water consumption. Sewer adjustments may be made for leaks not entering the sanitary sewer. An adjustment to the City sewer and Metro sewer charges will be considered provided that the Water technician can confirm that the additional water volume was due to the leak and did not enter the sanitary sewer system. Following confirmation of repair, Finance personnel will adjust no more than four Page 3 of 11 ADMINISTRATIVE POLICY AND PROCEDURE TITLE: UTIITY SERVICE WATER LEAK ADJUSTMENT INDEX No: 100-52 PAGE 2 of 3 (4) billing cycles (8 months) if water consumption is billed bi- monthly; or 6 billing cycles if water consumption is billed monthly. 4.4 The consumption used to determine the leak adjustment amount will be the actual consumption from the same bill cycle of the previous year. 4.4.1 For new owners or renters occupying the residence for Tess than one year, the consumption used to determine the leak adjustment amount will be one of the following: a. An average of the water consumption in the three- complete billing cycles immediately proceeding the bill cycle in which the leak began. b. In the absence of three complete billing cycles, the water consumption from the previous occupants for the same billing cycle in the previous year. c. If neither of the above is applicable, the system average for the applicable customer classification will be used. 4.5 One leak adjustment per 12 —month period per account will be authorized. If an additional adjustment request is submitted for an account in the next or following year(s), the Utility Accounting Manager will consult with the Water Utility Engineer to determine if the City will require the customer to complete extensive repairs to the service line and/or fixtures. 4.6 Customers will be eligible for a leak adjustment if the total dollar amount of the adjustment for both water and sewer is greater than $50.00 (or $25.00 for a water only account), not to exceed a credit of $500.00 for water only adjustments. 4.7 Leak adjustments shall have the following required approvals: a. $1,000 or Tess — Utility Customer Care Manager b. Greater than $1,000 and less that $10,000 — Finance Director c. Greater than $10,000 — Mayor 4.8 If the customer disputes the decision to deny the adjustment or the approved adjustment amount exceeds $500.00, he or she may submit a written request to the City of Auburn Finance Director for an administrative review of the leak adjustment request by the City Council Public Works Committee. Leak adjustment appeals will be considered by the Public Works Committee including additional adjustments of 50% of the remaining water portion over $500.00. Recommendations for leak adjustments made by the Public Works Committee will be submitted to the full City Council for final consideration and approval. Leak Adjustment appeals should identify the property, describe the leak and repair, and state the basis for the request for an administrative review. Pending the decision of this review, the customer who requests such a review must continue to pay the disputed charges as billed until the written decision of the Finance Director is provided. A decision of such an administrative review will be provided within 30 days of receipt of the written request. Upon the written decision of the Finance Director, if an account has been incorrectly charged, the account will be adjusted accordingly to cover all billings occurring Page 4 of 11 ADMINISTRATIVE POLICY AND PROCEDURE TITLE: UTIITY SERVICE WATER LEAK ADJUSTMENT INDEX NO: 100 -52 PAGE 3 of 3 during the administrative review and all billings that preceded the date of receipt of the written request for review, in accordance with City policy. The Finance Director may approve an adjustment up to $500.00 for customers whose water leaks pose a financial hardship. Financial hardship requests must include income eligibility documentation. The Finance Director must receive the written request for an administrative review within 15 days from the date the City posted the adjustment to the account Page 5 of 11 CITY OF ' -! AUBURN WASHINGTON Utility Billing Adjustments Multi - Family Date: 10/17/14 Account #: 034205 -000 Name: Auburn Manor Service Location: 210 37th St SE Water $ - Water Consumption Adjustment: 0 City Sewer $ (2,487.42) Sewer Consumption Adjustment: (1063) Metro Sewer $ (5,644.53) Storm Water $ - Refuse $ - Yard Waste $ - Refuse Tax $ - HHW $ - Miscellaneous $ - TOTAL $ (8,131.95) Explanation for adjustment: Leak Adjustment. Adjust 2 billing cycles (2 months consumption) for sewer only. APPROVALS: M F216M <_ $1,000 - Utilities Customer Care Supervisor Date: <_ $1,000 - Utilities Customer Care Manager Date: >$1,000 and <_ $10,000 - Finance Director Date: >$10,000 - Mayor Date: POSTED BY: Date: Page 6 of 11 CITY OF *J AUUiu1 WASHINGTON Utility Account Leak Adjustment Rates based on Inside City Limits Multi - Family Customer Name: Auburn Manor Account Number: 034205 -000 Property Address: 210 37th St SE Consumption that Billed on 7/2/14 I 2626 Billed City Sewer Metro Total Cons I Unit $ 1 Total 2618.5 2618.5 $ 2.34 5.31 $ 6,127.29 $13,904.24 $20,031.53 City Sewer $(1,733.94) KCSewer $(3,934.71) Total Adjustment Bill Cycle 1 Total $(5,668.65) Consumption that Billed on 8/6/14 I 3037 I Billed City Sewer Metro Total Cons I Unit $ 1 Total 3029.5 3029.5 $ 2.34 5.31 $ 7,089.03 $16,086.65 $23,175.68 City Sewer $ (753.48) KCSewer $(1,709.82) Total Adjustment Bill Cycle 2 Total $(2,463.30) Total City Sewer Adjustment Total Metro Sewer Adjustment Total Leak Adjustment on Account Page 7 of 11 Consumption adjusted to the I 1885 previous year same period: Adjusted City Sewer Metro Total Cons I Unit $ I Total 1877.5 $ 2.34 $ 4,393.35 1877.5 $ 5.31 $ 9,969.53 $ 14,362.88 Consumption adjusted to the I 2715 I previous year same period: $ (2,487.42) $ (5,644.53) $(8,131.95) Adjusted City Sewer Metro Total Cons I Unit $ I Total 2707.5 $ 2.34 $ 6,335.55 2707.5 $ 5.31 $ 14,376.83 $ 20,712.38 CITY OF ' -! AUBURN WASHINGTON Utility Billing Adjustments Multi - Family Date: 10/17/14 Account #: 034205 -000 Name: Auburn Manor Service Location: 210 37th St SE Water $ - Water Consumption Adjustment: 0 City Sewer $ (6,802.38) Sewer Consumption Adjustment: (2907) Metro Sewer $ (15,436.17) Storm Water $ - Refuse $ - Yard Waste $ - Refuse Tax $ - HHW $ - Miscellaneous $ - TOTAL $ (22,238.55) Explanation for adjustment: Leak Adjustment. Adjust 6 billing cycles (6 months consumption) for sewer only. APPROVALS: M F216M <_ $1,000 - Utilities Customer Care Supervisor Date: <_ $1,000 - Utilities Customer Care Manager Date: >$1,000 and <_ $10,000 - Finance Director Date: >$10,000 - Mayor Date: POSTED BY: Date: Page 8 of 11 CITY OF WASHINGTON Utility Account Leak Adjustment Rates based on Inside City Limits Multi - Family Customer Name: Auburn Manor Account Number: 034205 -000 Property Address: 210 37th St SE Consumption that Billed on 3/5/14 I 2006 Billed City Sewer Metro Total Cons I Unit $ 1 Total 1998.5 1998.5 $ 2.34 5.31 $ 4,676.49 $10,612.04 $15,288.53 City Sewer $ (416.52) KCSewer $ (945.18) Total Adjustment Bill Cycle 1 Total $ (1,361.70) Consumption that Billed on 4/2/14 I 2298 Billed City Sewer Metro Total Cons I Unit $ 1 Total 2290.5 2290.5 $ 2.34 5.31 $ 5,359.77 $12,162.56 $17,522.33 City Sewer $ (1,600.56) KCSewer $ (3,632.04) Total Adjustment Bill Cycle 2 Total $ (5,232.60) Consumption that Billed on 5/7/14 I 2249 Billed City Sewer Metro Total Cons I Unit $ 1 Total 2241.5 2241.5 $ 2.34 5.31 $ 5,245.11 $11,902.37 $17,147.48 City Sewer $ (1,270.62) KCSewer $ (2,883.33) Total Adjustment Bill Cycle 3 Total $ (4,153.95) Page 9 of 11 Consumption adjusted to the I 1828 previous year same period: Adjusted City Sewer Metro Total Cons I Unit $ 1 Total 1820.5 $ 2.34 $ 4,259.97 1820.5 $ 5.31 $ 9,666.86 $ 13,926.83 Consumption adjusted to the I 1614 previous year same period: Adjusted City Sewer Metro Total Cons I Unit $ 1 Total 1606.5 $ 2.34 $ 3,759.21 1606.5 $ 5.31 $ 8,530.52 $ 12,289.73 Consumption adjusted to the I 1706 previous year same period: Adjusted City Sewer Metro Total Cons I Unit $ 1 Total 1698.5 $ 2.34 $ 3,974.49 1698.5 $ 5.31 $ 9,019.04 $ 12,993.53 $ (22,238.55) Consumption that Billed on I 2218 Billed City Sewer Metro Total Cons I Unit $ 1 Total 2210.5 2210.5 2.34 5.31 $ 5,172.57 $11,737.76 $16,910.33 City Sewer $ (1,027.26) KCSewer $ (2,331.09) Total Adjustment Bill Cycle 4 Total $ (3,358.35) Consumption that Billed on 7/2/14 I 2626 Billed City Sewer Metro Total Cons I Unit $ 1 Total 2618.5 2618.5 2.34 5.31 $ 6,127.29 $13,904.24 $20,031.53 City Sewer $ (1,733.94) KCSewer $ (3,934.71) Total Adjustment Bill Cycle 5 Total $ (5,668.65) Consumption that Billed on 8/6/14 I 3037 I Billed City Sewer Metro Total Cons I Unit $ 1 Total 3029.5 3029.5 2.34 5.31 $ 7,089.03 $16,086.65 $23,175.68 City Sewer $ (753.48) KCSewer $ (1,709.82) Total Adjustment Bill Cycle Total $ (2,463.30) Total City Sewer Adjustment Total Metro Sewer Adjustment Total Leak Adjustment on Account Page 10 of 11 $ (6,802.38) $ (15,436.17) Consumption adjusted to the I 1779 previous year same period: Adjusted City Sewer Metro Total Cons I Unit $ 1 Total 1771.5 $ 2.34 $ 4,145.31 1771.5 $ 5.31 $ 9,406.67 $ 13,551.98 Consumption adjusted to the I 1885 previous year same period: Adjusted City Sewer Metro Total Cons I Unit $ 1 Total 1877.5 $ 2.34 $ 4,393.35 1877.5 $ 5.31 $ 9,969.53 $ 14,362.88 Consumption adjusted to the I 2715 I previous year same period: Adjusted City Sewer Metro Total Cons I Unit $ 1 Total 2707.5 $ 2.34 $ 6,335.55 2707.5 $ 5.31 $ 14,376.83 $ 20,712.38 Account #: 034205 -000 Name: Auburn Manor Address: 210 37th St SE 10/31/2003 — Customer received a leak adjustment for $11,317.55 9/28/04- Auburn Manor called to request for a leak adjustment form. They were informed account had a leak adjustment in October 2003. They will wait until then to request again. 1/31/05- Received request for a leak adjustment. 9/29/05 — Customer received a leak adjustment for $18,933.28 11/21/05 — Auburn Manor submitted additional leak adjustment request. 7/19/10 — Received request for a leak adjustment. 7/20/10 — Per City Service Technician, low flow is moving at a constant rate & not stopping. It looks like there is another leak. 8/13/10— Request closed. Property Manager did not respond to our requests to schedule a time for tenants not to use water and to check the meter. 12/20/10 — Received request for a leak adjustment. 2/2/11— Request closed. Request to check meter that leaks have been repaired was denied. 8/15/14 — Received request for a leak adjustment. 8/26/14- Per City Service Technician, low flow meter continues to move & not stop even after all customers were asked not to use water. Meter is still showing leak exists. 9/3/14 — Denial letter was mailed. 10/6/14— Received a call from John Sherwood regarding denial letter. He disagrees with the denial for a leak adjustment. Mr. Sherwood believes he has done everything possible to not have tenants use water during the time meter was checked. He thinks the meter will never stop spinning because it is impossible to have 100% of the tenants to not use water at the same. Mr. Sherwood also mentioned that he fixed another leak. He wanted to speak to someone else regarding the decision to deny his leak adjustment request. 10/16/14— Utilities Manager, Assistant Finance Director, Assistant PW Director and Mayor met with Mr. John Sherwood to discuss Auburn Manor property and water leaks. Mr. Sherwood requested a formal appeal before council. Page 11 of 11 AUBURN • WASHINGTON AGENDA BILL APPROVAL FORM Agenda Subject: 3rd Quarter 2014 Financial Report Date: November 5, 2014 Department: Finance Attachments: Quarterly Financial Report Budget Impact: $0 Administrative Recommendation: For discussion only. Background Summary: The purpose of the quarterly financial report is to summarize for the City Council the general state of Citywide financial affairs and to highlight significant items or trends that the City Council should be aware of. The following provides a high level summary of the City's financial performance. Further detail can be found within the attached financial report. The 3rd Quarter status report is based on financial data available as of October 17, 2014 for the period ending September 30, 2014. Sales tax information represents business activity that occurred through July 2014. General Fund: The General Fund is the City's largest fund and is used to account for the majority of City resources and services except those required by statute or to be accounted for in another fund. Through September 2014, General Fund revenues totaled $41.3 million and were sufficient to support total General Fund expenditures of $40.7 million. General Fund revenues exceed budget by $2.3 million, or 5.9% primarily due to increases in retail sales tax collections, building permit revenues, and development services fees. General Fund expenditures through September totaled $40.7 million and are $3.4 million, or 7.7% under budget. The year to date underspend is a result of many factors including staff vacancies, continued vigilance in monitoring general spending, and underspend of contingency funds. Through September 2014, payments to SCORE have decreased by $1.3 million compared to the same period in 2013. The majority of this reduction in expenditures is due to reduced monthly payments for incarceration services (current year monthly payments are based upon prior year City inmate counts). In addition, the annual payment to King County District Court for municipal court services was $550,000 lower than budgeted for the year. Year to date, 4,348 pet licenses have been sold resulting in $114,330 in revenue. For the same period in 2013, 3,876 licenses were sold resulting in $116,920 in revenue. Enterprise Funds: The City's seven enterprise funds account for operations with revenues primarily provided from user fees, charges or contracts for services. At the end of the third quarter, the Water fund's net operating income increased to $1,289,500 and compares to income of $517,000 the previous year. The Sewer fund ended the quarter with $98,900 net operating income compared to an operating loss of $497,800 the previous year; the Sewer -Metro Utility ended the quarter with operating income of $94,900 compared to operating income of $61,900 the previous year; and the Stormwater Utility ended the quarter with operating income of $1,098,900 and compares to operating income of $813,500 the previous year. AUBURN * MORE THAN YOU IMAGINED Page 1 of 24 Agenda Subject: 3rd Quarter 2014 Financial Report Date: 11/5/2014 The Cemetery ended the third quarter with net operating income of $3,600 compared to operating income of $60,500 the previous year. The difference is due primarily to water costs, which are being charged to the Cemetery Fund in 2014 but were not in 2013 or before. Internal Service Funds: Internal Service Funds provide services to other City departments and include functions such as Insurance, Worker's Compensation, Facilities, Innovation and Technology, and Equipment Rental. All funds have sufficient revenues to cover year to date expenditures. Investment Portfolio: The City's total cash and investments at the end million at the end of Q2 -2014. Q3 -2014 was $117.7 million, and compares to $119.4 Reviewed by Council & Committees: Reviewed by Departments & Divisions: • Arts Commission COUNCIL COMMITTEES: • Building ❑ M &O • Airport Finance • Cemetery ❑ Mayor ❑ Hearing Examiner • Municipal Serv. ►1 Finance ❑ Parks ❑ Human Services • Planning & CD • Fire ❑ Planning ❑ Park Board Public Works • Legal ❑ Police ❑ Planning Comm. • Other • Public Works • Human Resources • Information Services Action: Committee Approval: •Yes • No Council Approval: •Yes • No Call for Public Hearing /_ /_ _ Referred to Until /_/ Tabled Until / / Councilmember: Wales Staff: Coleman Meeting Date: November 17, 2014 Item Number: Page 2 of 24 Quarterly Financial Report Through Q3 2014 General Fund Summary of Sources and Uses 2014 2013 2014 YTD Budget vs. Actual Annual Budget YTD Budget YTD Actual YTD Actual Favorable (Unfavorable) Amount Percentage Operating Revenues Property Tax 15,699,417 8,590,600 8,671,476 7,960,868 80,876 0.9 % Sales Tax 13,048,552 9,562,400 10,232,931 9,233,567 670,531 7.0 % Sales Tax - Annexation Credit 1,404,590 1,020,300 1,353,361 1,236,641 333,061 32.6 % Criminal Justice Sales Tax 1,231,185 905,500 1,220,359 1,117,505 314,859 34.8 % Brokered Natural Gas Tax 303,008 248,800 225,727 221,202 (23,073) (9.3) % City Utilities Tax 3,203,673 2,444,400 2,583,403 2,500,608 139,003 5.7 % Admissions Tax 365,427 277,000 242,304 241,141 (34,696) (12.5) % Electric Tax 3,373,905 2,608,600 2,676,062 2,529,525 67,462 2.6 % Natural Gas Tax 1,213,919 1,076,400 1,016,345 914,644 (60,055) (5.6) % Cable TV Franchise Fee 816,000 608,200 662,669 637,051 54,469 9.0 % Cable TV Franchise Fee - Capital 62,310 46,900 47,420 47,254 520 1.1 % Telephone Tax 2,042,737 1,495,500 1,369,114 1,326,474 (126,386) (8.5) % Garbage Tax (external) 96,261 72,400 79,933 74,608 7,533 10.4 % Leasehold Excise Tax 50,754 32,200 27,111 19,685 (5,089) (15.8) % Gambling Excise Tax 250,237 192,200 211,463 201,330 19,263 10_0 % Taxes subtotal 43,161,975 29,181,400 30,619,679 28,262,103 1,438,279 4.9 % Business License Fees 203,015 106,700 107,374 116,156 674 0.6 % Building Permits 1,169,160 843,200 1,164,856 1,684,253 321,656 38.1 % Other Licenses & Permits 528,072 384,600 501,420 532,254 116,820 30.4 % Intergovernmental (Grants, etc.) 4,982,364 3,669,945 3,690,117 3,565,555 20,171 0.5 % Charges for Services: General Government Services 94,783 74,900 80,975 85,384 6,075 8.1 % Public Safety 580,449 435,600 382,509 16,521 (53,091) (12.2) % Development Services Fees 738,881 599,600 910,625 868,072 311,025 51.9 % Culture and Recreation - (1) 2,047,549 1,769,700 1,871,665 725,425 101,965 5.8 % Fines and Forfeits 1,562,575 1,194,100 1,040,512 1,073,569 (153,588) (12.9) % Fees /Charges /Fines subtotal 11,906,848 9,078,345 9,750,053 8,667,190 671,708 7.4 % 42,230 31,100 29,470 35,163 (1,630) (5.2) % Interests and Other Earnings Rents, Leases and Concessions - (1) 543,150 475,800 587,800 253,885 112,000 23.5 % Contributions and Donations 30,000 21,400 35,531 37,648 14,131 66.0 % Other Miscellaneous - (1) 113,200 87,700 129,929 47,398 42,229 48.2 % Transfers In 123,000 123,000 121,097 193,548 (1,903) (1.5) % Insurance Recoveries - Capital & Operating 25,000 18,900 65,375 126,850 46,475 245.9 % Other Revenues subtotal 876,580 757,900 969,200 694,492 211,300 27.9 % 55,945,403 39,017,645 41,338,932 37,623,785 2,321,287 5.9 % Operating Expenditures Council & Mayor 718,926 531,476 557,961 764,833 (26,485) (5.0) % Administration 875,639 656,729 511,602 0 145,127 22.1 % Community & Human Services 1,379,335 1,068,000 689,430 687,547 378,570 35.4 % Municipal Court & Probation 1,870,966 1,806,074 1,198,451 505,054 607,623 33.6 % Human Resources 1,557,163 1,128,200 908,539 1,017,520 219,661 19.5 % Finance 1,369,895 1,071,900 899,315 907,409 172,585 16.1 % City Attorney 1,880,945 1,298,809 1,232,988 1,385,238 65,822 5.1 % Community Development 4,069,107 2,969,806 2,814,196 2,796,866 155,610 5.2 % Jail - SCORE 5,786,100 3,649,625 3,439,293 4,704,763 210,332 5.8 % Police 21,893,036 16,236,000 15,115,068 14,215,450 1,120,932 6.9 % Public Works 2,656,777 1,966,500 1,945,676 2,026,435 20,824 1.1 Parks, Arts & Recreation - (1) 9,539,253 7,167,011 7,332,550 6,063,767 (165,539) (2.3) % Streets 3,306,718 2,259,100 2,258,289 1,919,545 811 0.0 % Non - Departmental 3,331,207 2,335,205 1,834,182 1,506,257 501,024 21.5 % Tot& Operating Expenditures 60,235,066 44,144,435 40,737,539 38,500,684 3,406,896' 7.7 % (1) Through December 31, 2013, Golf Course revenues and expenditures were reported under Fund 437. Effective January 1, 2014, Golf Course revenues and expenditures are now reported in the General Fund (above). Therefore, when comparing 2014 General Fund actuals to prior year, it is important to recognize this change. Page 3 of 24 Quarterly Financial Report Through Q3 2014 Overview This financial overview reflects the City's overall financial position for the fiscal period ending September 30, 2014 and represents financial data available as of October 17, 2014. The budgeted revenues and operating expenditures are primarily based on the collection /disbursement average for the same period of the two years prior. Through the first three quarters of 2014, General Fund revenues totaled $41.3 million and compares to year to date budget of $39.0 million and collections of $37.6 million for the same period last year. Revenues year to date are sufficient to cover General Fund expenditures. Some highlights through Q3 -2014 include: - Sales Tax revenue totals $10.2 million and exceeds budget by 7.0% or $671,000. - Criminal Justice Sales Taxes and Sales Taxes from Annexation exceed budget expectations by $648,000 through the third quarter of 2014. - Fees /Charges /Fines total $9.8 million and exceed budget by $672,000 primarily due to stronger than budgeted revenues from development activity. - Rents, Leases, and Concessions total $589,000 and exceed budget by $112,000 primarily due to increased bookings at City facilities, most notably at the Senior Center and Game Farm Park. General Fund expenditures through the first three quarters of 2014 total $40.7 million and compare to a budget of $44.1 million. Due to an accounting change effective January 1, 2014 all revenues and expenditures related to the Auburn Golf Course are now reported in the General Fund. Therefore, it is important to recognize this shift when comparing 2014 performance to prior year performance. After adjusting for the Golf Course expenditures through September of 2013 in the amount of $1.1 million, the year to date General Fund expenditures are running 2.8% higher than the same period the year prior. $ 50.0 $45.0 $ 40.0 $35.0 c $30.0 0 E $25.0 $20.0 $15.0 $10.0 $5.0 $0.0 Page 4 of 24 General Fund Year to Date Revenues vs. Expenditures ❑ 2014 Budget ❑ 2014 Actual Revenues Expenditures 2 Quarterly Financial Report Through Q3 2014 Revenues The combined total of property tax, sales /use tax, utility tax, gambling, and admissions tax provides approximately 80% of all resources supporting general governmental activities. The following section provides additional information on these sources. Property Tax collections to date total $8.7 million and compare to a budget of $8.6 million, and are in line with 2014 expectations. The majority of property tax revenues are collected during the months of April and October, coinciding with the due dates for the County property tax billings. $18.0 $16.0 $14.0 $12.0 2 $10.0 0 $8.0 $ 6.0 $4.0 $2.0 Property Taxes 2014 budget �- -2014 actual to date 2013 actual $0.0 1r••4 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1 1 i Page 5 of 24 3 Quarterly Financial Report Through Q3 2014 Sales tax distributions Citywide total $11.5 million of which $10.2 million was distributed to the General Fund and $1.3 million was distributed to the Local Street Fund (SOS) program.* Year to date Sales Tax revenue collections in the General Fund exceed budget expectations by $671,000, or 7.0 %. $14.0 $12.0 $10.0 $ 8.0 $ 6.0 $4.0 $2.0 $0.0 Sales & Use Tax (Net of Revenue from Construction) 2014 budget -- -2014 actual to date 2013 actual 7 ,...- 17 7 ..----- /----''--- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec * Per 2013 -2014 budget, Local Street Fund (Fund 103) street repairs are funded from sales taxes on construction. Total transferred in through Q3 -2014 was $1,299,177. The graphic above presents sales taxes under the current policy. The following table breaks out the City's base sales tax, excluding Criminal Justice, Annexation Credit and Streamlined Sales Tax Mitigation, by major business sector. 4 Page 6 of 24 Quarterly Financial Report Through Q3 2014 Comparison of Sales Tax Collections by SIC Group September -2014 Component Group 2013 Actual 2014 Actual Change from 2013 Amount Percentage Construction 1,253,470 1,299,177 45,707 3.6 Manufacturing 455,540 866,808 411,268 90.3 Transportation & Warehousing 28,716 30,851 2,136 7.4 Wholesale Trade 956,449 889,379 (67,070) (7.0) Automotive 2,346,460 2,449,526 103,066 4.4 Retail Trade 3,136,407 3,438,556 302,149 9.6 Services 2,271,279 2,464,157 192,879 8.5 Miscellaneous 44,144 91,121 46,978 106.4 YTD Total 10,492,464 11,529,575 1,037,111 9.9 As the table shows, sales tax revenues collected through the first three quarters of 2014 exceed prior year collections by $1,037,000, or 9.9 %. The business sectors showing the largest increase in revenues compared to 2013 are the manufacturing and retail trade categories. Total sales tax revenue on construction, which is transferred to the Local Street Fund (Fund 103) for local street repair and maintenance, totals $1,299,177 year to date and exceeds budget by $46,000, reflecting increased commercial and residential construction activity throughout the City. 2 0 Page 7 of 24 $2.0 $1.8 $1.6 $1.4 $1.2 $1.0 $0.8 $0.6 $0.4 $0.2 $0.0 Sales Tax on Construction Transfer 2014 budget 2014 actual to date 2013 actual Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 5 Quarterly Financial Report Through Q3 2014 Utility Taxes consist of interfund taxes on City utilities (Water, Sewer, Storm and Solid Waste) and taxes on external utilities (Electric, Natural Gas, Telephone and Solid Waste). Utility taxes collected through the first three quarters of 2014 total $7.7 million and compare to $7.3 million collected in the same period last year. $12.0 - $10.0 - $8.0 - O $ 6.0 $4.0 $2.0 $0.0 Utility Tax 2014 budget -2014 actual to date 2013 actual Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec As shown in the table below, utility tax revenues year to date are in line with budget expectations of $7.7 million. Utility Tax by Type September -2014 Month 2013 Actual 2014 2014 Budget Actual 2014 vs. 2013 Actual 2014 vs. Budget Amount Percentage Amount Percentage City Interfund Utility Taxes 2,500,608 2,444,400 2,583,403 82,795 3.3 % 139,003 5.7 % Electric 2,529,525 2,608,600 2,676,062 146,537 5.8 % 67,462 2.6 % Natural Gas 914,644 1,076,400 1,016,345 101,701 11.1 % (60,055) (5.6) % Telephone 1,326,474 1,495,500 1,369,114 42,640 3.2 % (126,386) (8.5) % Solid Waste (external) 74,608 72,400 79,933 5,326 7.1 % 7,533 10.4 % YTD Total 7,345,859 7,697,300 7,724,857 378,998 5.2 % 27,557 0.4 Annual Total 9,540,139 9,930,495 6 Page 8 of 24 Quarterly Financial Report Through Q3 2014 Cable TV Franchise Fees, which are collected quarterly, total $663,000 and exceed budget by $54,000 or 9.0 %. c EP, 0 1- I— $900 $800 $700 $600 $500 $400 $300 $200 $100 $0 Cable TV Franchise Fee 2014 budget 2014 actual to date 2013 actual 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Licenses and Permits include business licenses, building permits, plumbing, electric and other licenses and permit fees. Building permit fees and business licenses make up 80% of the annual budgeted revenue in this category. Total building permit revenues collected through September total $1.2 million and compare to budget of $843,000. Building permits issued through September total 662 compared to 751 during the same period last year. Major projects contributing to building permit revenues this quarter include building permits for several housing developments including Lakeland Hills Estates, Edgeview, Auburn 40 PUD, and Kendall Ridge. 7 Page 9 of 24 Quarterly Financial Report Through Q3 2014 0 $2.2 $2.0 $1.8 $1.6 $1.4 $1.2 $1.0 $0.8 $0.6 $0.4 $0.2 $0.0 Building Permits 2014 budget 2014 actual to date 2013 actual Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Note: The spike seen in February 2013 (above) includes revenues for the Auburn High School Reconstruction and Modernization project. Business License revenues collected through September total $107,000, and are in line with budget expectations. The graphic on the following page reflects the timing of payments by business owners, where the majority of business license payments are collected during the first two months of the year and the last month of the year. 8 Page 10 of 24 Quarterly Financial Report Through Q3 2014 $240 $220 $200 $180 $160 $140 $120 o $100 I- $80 $60 $40 • $20 $0 Business Licenses 2014 budget 2014 actual to date 2013 actual . jAvoilsollig I t t it Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Intergovernmental revenues include Grants (Direct & Indirect Federal, State and Local), state shared revenues and compact revenue from the Muckleshoot Indian Tribe (MIT). Collections to date total $3.7 million and are in line with budget expectations. Intergovernmental September -2014 Revenue 2013 Actual 2014 2014 Budget Actual 2014 vs. 2013 Actual 2014 vs. Budget Amount % Change Amount % Change Federal Grants 46,901 191,300 90,084 43,183 92.1 % (101,216) (52.9) % State Grants 105,943 228,500 67,921 (38,022) (35.9) % (160,579) (70.3) % Interlocal Grants 58,486 15,700 9,652 (48,834) 0.0 % (6,048) (38.5) % State Shared Revenue 2,887,749 2,781,850 3,022,691 134,943 4.7 % 240,841 8.7 % Muckleshoot Casino Emerg. 437,462 445,800 444,667 7,205 1.6 % (1,134) (0.3) % Intergovernmental Service 29,015 6,795 55,102 26,087 89.9 % 48,307 710.9 % YTD Total 3,565,555 3,669,945 3,690,117 124,562 3.5 % 20,171 0.5 % State shared revenue includes $1,478,789 in Streamlined Sales Tax Mitigation payments. 9 Page 11 of 24 Quarterly Financial Report Through Q3 2014 Charges for Services consist of general governmental services, public safety, development service fees and cultural & recreation fees. Collections to date total $3.2 million and compare to a budget of $2.9 million. General governmental revenues through Q3 -2014 exceed year to date budget by $6,000 — primarily due to timing of payments from local jurisdictions that contract services through the City of Auburn, as well as increased revenues for passport services. Public safety revenues collected year to date total $383,000 and compare to a budget of $436,000. Public Safety revenues primarily consist of revenues generated for Police Officer extra duty overtime, where officers are contracted for services and reimbursement is made by the hiring contractor. Effective this year, the expenditures for Police Officer extra duty overtime are no longer netted against the revenues for this service, which is why the collections this year are significantly higher than collections reflected in the prior year. Development services fee collections, which primarily consist of plan check fees, exceed budget by $311,000 year to date. Total plan check fees collected in the third quarter of 2014 total $196,000 and compare to $141,000 collected during the third quarter of last year. This quarter's plan check revenues include fees related to several commercial projects, including a storage facility, a wedding venue and a project at the Outlet Collection. Plan check revenues also include plans for several housing developments — most notably Edgeview and Sonata Hill. Culture and recreation revenues exceed budget by $102,000 or 5.8 %, reflecting increased activity from recreational classes and City special events. A significant factor in the year- over -year increase seen in culture and recreation revenues is a change in accounting, whereby Golf Course revenues and expenditures are now reported within the General Fund. Revenues included in this category include golf lessons and green fees. Charges for Services by Type September -2014 Revenue 2013 Actual 2014 Budget 2014 Actual 2014 vs. 2013 Actual 2014 vs. Budget Amount Percentage Amount Percentage General Government 85,384 74,900 80,975 (4,409) (5.2) To 6,075 8.1 Public Safety 16,521 435,600 382,509 365,988 2,215.2 To (53,091) (12.2) To Development Services 868,072 599,600 910,625 42,553 4.9 To 311,025 51.9 To Culture & Recreation 725,425 1,769,700 1,871,665 1,146,240 158.0 To 101,965 5.8 YTD Total 1,695,403 2,879,800 1 3,245,775 1,550,372 91.4 To 365,975 12.7 To 10 Page 12 of 24 Quarterly Financial Report Through Q3 2014 $L4 - $1.2 - $1.0 - $0.4 - $ 0.2 $ 0.0 Development Service Fees b. 2014 budget ■2014 actual to date 2013 actual Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec c 0 $2.2 $2.0 $1.8 $1.6 $1.4 $1.2 $1.0 $0.8 $0.6 $0.4 $0.2 $0.0 Culture & Recreation 2014 budget 2013 actual ■11■2014 actual to date `♦ • Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Note: The 2014 budget is considerably higher than 2013 actuals due to the accounting change effective January 1, 2014 where the Golf Course is now included in the General Fund. 11 Page 13 of 24 Quarterly Financial Report Through Q3 2014 Fines & Penalties include traffic and parking infraction penalties, Redflex photo enforcement violations, criminal fines (including criminal traffic, criminal non traffic and criminal costs) as well as non -court fines such as false alarm fines. Total revenue collected to date is $1.0 million and compares to a budget of $1.2 million. Fines & Forfeits by Type September -2014 Month 2013 Actual 2014 Budget 2014 Actual 2014 vs. 2013 Actual 2014 vs. Budget Amount Percentage Amount Percentage Civil Penalties 14,572 11,800 13,115 (1,457) (10.0) % 1,315 11.1 Civil Infraction Penalties 343,146 515,600 368,220 25,075 7.3 % (147,380) (28.6) Redflex Photo Enforcement 436,428 360,300 377,730 (58,698) (13.4) % 17,430 4.8 Parking Infractions 97,053 137,300 102,962 5,908 6.1 % (34,338) (25.0) Criminal Traffic Misdemeanor 42,131 60,600 39,908 (2,223) (5.3) % (20,692) (34.1) Criminal Non - Traffic Fines 45,637 69,600 33,951 (11,685) (25.6) % (35,649) (51.2) Criminal Costs 20,926 9,700 38,366 17,441 83.3 % 28,666 295.5 Non -Court Fines & Penalties 73,678 29,200 66,260 (7,418) (10.1) % 37,060 126.9 YE Total 1,073,569 1,194,100 1,040,512 (33,057) (3.1) % (153,588) (12.9) $1.8 $1.6 $1.4 $1.2 c $1.0 0 g. $0.8 $0.6 $0.4 $0.2 $0.0 Page 14 of 24 Fines & Penalties 2014 budget -. -2014 actual to date 2013 actual Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 12 Quarterly Financial Report Through Q3 2014 Effective June 1, 2014, the City no longer contracts with Redflex for photo enforcement services. Due to the inactivity of the speed zone and red -light cameras, this monthly revenue stream is expected to be extinguished by the end of the year. The amount collected in September was $8,000 and compares to monthly average collections of $50,000 when the cameras were fully operational. -a c o $300 - I— Redflex Photo Enforcement $700 2014 budget $600 2014 actual to date 2013 actual $500 - $400 - $200 - $100 - $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Miscellaneous revenues primarily consist of income from facility rentals; other sources within this category include investment earnings, contributions & donations and other miscellaneous income. Revenue in this category totals $783,000 and compares to a budget of $616,000. Through the first three quarters of 2014, rents and leases revenues are $112,000 higher than budgeted primarily due to stronger than anticipated revenues for facility rentals at Game Farm Park and the Senior Center. In comparing year- over -year actuals, it is important to note that effective January 1, 2014 golf cart rental revenues are now included in the General Fund and are collected in the rents and leases revenue category below. Miscellaneous Revenues by Type September -2014 Month 2013 Actual 2014 2014 Budget Actual 2014 vs. 2013 2014 vs. Budget Amount Percentage Amount Percentage Interest & Investments 35,163 31,100 29,470 (5,693) (16.2) % (1,630) (5.2) Rents & Leases 253,885 475,800 587,800 333,915 131.5 % 112,000 23.5 Contributions & Donations 37,648 21,400 35,531 (2,117) (5.6) % 14,131 66.0 Other Miscellaneous Revenue 47,398 87,700 129,929 82,531 174.1 % 42,229 48.2 YTD Total 374,093 616,000 782,729 408,636 109.2 % 166,729 27.1 13 Page 15 of 24 Quarterly Financial Report Through Q3 2014 Real Estate Excise Tax (REET) revenue is receipted into the Capital Improvement Projects Fund and is used for governmental capital projects. Total revenue collected through September is $1.9 million. This exceeds budget and prior year actuals by $1.0 million and $390,000 respectively, reflecting improvement in the local and regional real estate markets. Real Estate Excise Tax Revenues September -2014 Month 2013 Actual 2014 Budget 2014 Actual 2014 vs. 2013 2014 vs. • udget Amount Percentage Amount Percentage Jan 113,615 61,300 119,765 6,150 5.4 % 58,465 95.4 Feb 107,485 92,200 208,206 100,721 93.7 % 116,006 125.8 Mar 143,198 98,000 118,578 (24,620) (17.2) % 20,578 21.0 Apr 124,445 69,100 189,771 65,325 52.5 % 120,671 174.6 May 162,750 89,400 243,472 80,721 49.6 % 154,072 172.3 Jun 177,380 95,800 236,067 58,688 33.1 % 140,267 146.4 Jul 267,976 147,100 305,214 37,238 13.9 % 158,114 107.5 Aug 200,627 112,200 263,573 62,947 31.4 % 151,373 134.9 Sep 183,507 103,600 182,829 (678) (0.4) % 79,229 76.5 Oct 261,388 260,600 Nov 287,776 138,600 Dec 202,388 132,100 YTD Total 1,480,983 868,700 1,867,475 386,493 26.1 % 998,775 115.0 0 $2.4 - $2.2 - $2.0 - $1.8 - $1.6 - $1.4 - $1.2 - $1.0 - $0.8 - $0.6 - $0.4 - $0.2 - $ 0.0 Page 16 of 24 Real Estate Excise Tax 2014 budget �- -2014 actual to date 2013 actual eee te° ° // ee / e// /..7." • e....1., ......, eee • • • • • Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 14 Quarterly Financial Report Through Q3 2014 Pet Licensing Year -to -date, 4,348 pet licenses have been sold resulting in $114,300 in revenue. For the same period in 2013, 3,876 licenses were sold resulting in $116,900 in revenue. 900 800 -E 700 = 600 500 5 400 300 Z 200 100 0 Pet Licenses Issued By Month 2014 vs 2013 C >• c -� uo a > -`0 u01. '� -�i i Q in O z 0 Month t 2014 Licenses Issued — +— 2013 Licenses Issued 2014 Budget Goal: $240,000 or more Year -to -Date Revenue 2014 (through September) = $114,330 Year -to -Date Licenses 2014 (through September) = 4,348 Year -to -Date Licenses 2013 (through September) = 3,876 License Revenue $14,000 $12,000 $10,000 $ 8,000 $ 6,000 $ 4,000 $2,000 so Pet Licensing Revenue By Month 2014 co w Month 2014 License Revenue 15 Page 17 of 24 Quarterly Financial Report Through Q3 2014 $250,000 $200,000 $150,000 w w ce C" J $100,000 $50,000 Cumulative Pet Licensing Revenue & Licenses Issued 2014 vs 2013 C t0 N LL Month b0 Q a t Q) O ✓ 12,000 10,000 8,000 6,000 4,000 2,000 Number of Licenses Issued 2014 License Revenue (L) 2014 License Revenue (L) (Budget Goal: $240,000) — 2014 Licenses Issued (R) -- 2013 Licenses Issued (R) Enterprise Funds The detailed Working Capital and Fund Balance statements for Enterprise and Internal Service funds can be found in the Appendix at the end of this report. At the end of the third quarter, the Water Utility's net operating income increased from $517,000 in 2013 to $1,289,500 in 2014. $1,600 - $1,400 - $1,200 - $1,000 - $800 - $600 - $400 - $200 - $0 Water Revenues vs Water Sold 2014 vs 2013 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2013 Water Sales ($) —0— 2014 Water Sales ($) 2013 Water Sold (ccf) —0— 2014 Water Sold (ccf) 16 Page 18 of 24 Quarterly Financial Report Through Q3 2014 The Sewer Utility ended the quarter with operating income of $98,900 compared to an operating loss of $497,800 for the same period in 2013. The Sewer -Metro Utility ended the period with operating income of $94,900 compared to operating income of $61,900 for the previous year. The Stormwater Utility ended the quarter with $1,098,900 in net operating income which compared to operating income of $813,500 for the same period last year. The Cemetery Fund ended the third quarter with operating income of $3,600 compared to operating income of $60,500 for the same period last year. During the third quarter of 2014, the number of interments at the Cemetery totaled 179 (82 burials, 97 cremations) which compares to 172 (82 burials, 97 cremations) for the same period last year. Cemetery Operating Revenues & Expenditures By Month 2014 vs 2013 $140 $120 $100 $80 v, 1- $60 $40 $20 $o -I Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2014 Bud. Revenue +2014 Act. Revenue 2013 Act. Revenue f 2014 Act. Expenses v c 0 2 I- $1,000 $900 $800 $700 $600 $500 $400 $300 $200 $100 $o Cumulative Cemetery Revenues & Expenditures 2014 vs 2013 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2014 Bud. Revenue t 2014 Act. Revenue 2013 Act. Revenue t 2014 Act. Expenses 17 Page 19 of 24 Quarterly Financial Report Through Q3 2014 Internal Service Funds Operating expenditures within the Insurance Fund represents the premium cost -pool that will be allocated monthly to other City funds over the course of 2014. As a result, this balance will gradually diminish each month throughout the year. No significant variances are reported in the Worker's Compensation, Facilities, Innovation & Technology, or Equipment Rental Funds. All funds have sufficient revenues to cover year -to -date expenditures. Contact Information This report is prepared by the Finance Department. Additional financial information can also be viewed at our website: http: / /www.auburnwa.gov /. For any questions about this report please contact Shelley Coleman at scolemanPauburnwa.gov. 18 Page 20 of 24 Investment Type State Investment Pool KeyBank Money Market US Treasury FFCB FHLB LAKUTL Total Cash & Investments Investment Mix State Investment Pool KeyBank Money Market US Treasury FFCB FHLMC LAKUTL Page 21 of 24 City of Auburn Investment Portfolio Summary September 30, 2014 Purchase Date Various Various 05/04/1990 4/11/2013 2/19/2014 9/25/2013 % of Total 89.6% 5.8% 0.0% 2.5% 1.7% 0.2% 100.0% Purchase Price $ 105,469,219 6,843,540 57,750 3,000,000 2,047,200 235,919 $ 117,653,628 Maturity Yield to Date Maturity Various 0.10% Various 0.00% 05/15/2016 5.72% 4/11/2016 0.43% 11/19/2018 1.98% 11/1/2017 1.90% 0.140% Summary Current 6 -month treasury rate Current State Pool rate KeyBank Money Market Blended Auburn rate 0.04% 0.10% 0.00% 0.14% SALES TAX SUMMARY SEPTEMBER 2014 SALES TAX DISTRIBUTIONS (FOR JULY 2014 RETAIL ACTIVITY) 1 NAILS CONSTRUCTION 2013 Annual Total 2013 VTD 2014 YTD VTD (Nov'12- 00013) (Nov '12 - 4013) (Nov .13- 71101'14) % DI80 236 Construction of Buildings 237 Heavy and Civil Construction 238 Specialty Trade Contractors TOTAL CONSTRUCTION Overall Change from Previous Y 949,102 166,874 826,744 1,942,720 593,884 71,364 588,222 1,253,470 652,751 104,326 542,100 1,299,177 45,707 NAICS AUTOMOTIVE 2013 Annual Total 2013 YTD 2014 YTD (Nov'12 -00013) 040812 - 40 013) (Nov '13- Jul 14) %0080 9.9% 441 46.2% 447 - 7.8% NAILS MANUFACTURING 2013 Annual Total 2013 VTD 2014 YTD VTD (Nov '12- 08013) (Nov '12 - J0113) (Nov '13- Jul '14) %DIM 311 Food Manufacturing 312 Beverage and Tobacco Products 313 Textile Mills 314 Textile Product Mills 315 Apparel Manufacturing 316 Leather and Allied Products 321 Wood Product Manufacturing 322 Paper Manufacturing 323 Printing and Related Support 324 Petroleum 884 Coal Products 325 Chemical Manufacturing 326 Plasfics and Rubber Products 327 Nonmetallic Mineral Products 331 Primary Metal Manufacturing 332 Fabricated Metal Product Manuf 333 Machinery Manufacturing 334 Computer and Electronic Produc 335 Electric Equipment, Appliances 336 Transportation Equipment Man 337 Furniture and Related Products 339 Miscellaneous Manufacturing TOTAL MANUFACTURING Overall Change from Previous Yaw 1,836 7,670 272 3,435 280 11 72,780 3,442 26,277 9,762 8,995 9,566 20,455 717 13,135 b 25,232 13,545 1,251 350,172 24,852 30,699 824,385 1,308 5,635 201 3,017 268 7 57,801 2,658 18 207 7,028 6,442 6,915 14,460 592 6,794 15,548 10298 1,089 256,922 18,074 22275 455,540 2,654 6,142 197 2,518 237 7 57,779 3,712 28,677 7,488 3,986 7,583 13,993 1,416 25,992 15,644 12714 797 629,795 17,480 27,997 888,808 102.9% 9.0% - 1.9% - 16.6% - 11.4% - 5.5% 0.0% 39.7% 57.5% 65% - 38.1% 9.7% - 3.2% 139.1% 282.6% 0.6% 23.5% - 26.8% 145.1% - 3.3% 25.7% 90.3% NAILS 2013 Annual Total 2013YTD 12,014 YTD VTD TRANSPORTATION AND WAREHOUSING (Nov 12-00013) (Nov '12- JUT13) ( '13- 7101'14) %DI80 481 Air Transportation 482 Rail Transportation 484 Truck Transportation 485 Transit and Ground Passengers 488 Transportation Support 491 Postal Service 492 Couriers and Messengers 493 Warehousing and Storage TOTAL TRANSPORTATION Overall Change from Previous Year 0 9,552 -3,489 a 93 27,757 863 1,272 9,648 45,898 0 8,604 -4,937 a 93 17,490 655 1,001 5,809 28,718 0 3,977 3,291 4 19,325 631 671 2,953 30,851 2-_738 N/A - 53.8% - 166.7% - 95.9% 10.5% - 3.8% - 33.0% - 49.2% 7.4% NAICS ' WHOLESALE TRADE 2013 Annual Total 2013YTD 2014YTD VTD (Nov '12- 00013) (Nov '12- 78113) (Nov '13 -Jul '14) % DM 423 Wholesale Trade, Durable Goods 424 Wholesale Trade, Nondurable 425 Wholesale Electronic Markets TOTAL WHOLESALE Overall Change from Previous Y 1,111,249 163,774 4,384 1279,407 831,213 121,438 3,798 958,449 a. WA State Dept of Revenue audit adjustment to sales tax returns for period Jan 2013 (adjustment: - $11,382). b. WA State Dept of Revenue audit adjustment to sales tax returns for period May 2013 (adjustment -$30,493). c. WA State Dept of Revenue audit adjustment to sales tax returns for period March 2014 (adjustment - $45,145). d. WA State Dept of Revenue audit adjustment to sales tax returns for period April 2014 (adjustment: $10,242). 09/23/14 Prepared by Auburn Finance Department Page 22 of 24 758,585 128,756 2,038 889,379 - 8,,077 - 8.7% 6.0% -46.3% -7.0% Motor Vehicle and Parts Dealer Gasoline Stations TOTAL AUTOMOTIVE Overall Change from Prev1008 Yaw 2,899,545 236,015 3,135,559 2,166,473 179,986 2,348,480 2263,012 186,513 2,449,528 108065 tl 4.5% 3.6% 4.496 NAILS RETAIL TRADE 2013 Annual Total 2019 YTD 2014 YTD (Nov '12 -00t 13) (4 08 12 - 70113) (Nov '13 - 7101'14) %0080 442 Furniture and Home Furnishings 443 Electronics and Appliances 444 Building Material and Garden 445 Food and Beverage Stores 446 Health and Personal Care Store 448 Clothing and Accessories 451 Sporting Goods, Hobby, Books 452 General Merchandise Stores 453 Miscellaneous Store Retailers 454 Nonstore Retailers TOTAL RETAIL TRADE Overall Change from Previous Year 235,036 173,552 446,976 335,409 173,874 889,410 125,040 974,130 548,688 316,455 4218,570 174,342 130,520 333,749 245,666 132,599 646,219 90229 738,740 403,216 241,127 3,138,417 178,076 194,124 365,425 257,712 144,146 742,048 161,403 720,944 413,147 261,531 3,438,558 302,849 2.1% 48.7% 95% 4.9% 8.7% 14.8% 78.9% O 24% 2,5% 85% 9.6% NAILS SERVICES 2013 Annual Total 2013 YTD 2014 YTD VTD (Nov '12-00['13) (Nov12- 70113) (Nov 13- Jul' 14) % 0080 51* Information 57 Finance and Insurance 57 Real Estate, Rental, Leasing 541 Professional, Scientific, Tech 551 Company Management 56* Admin. Supp., Remed Svcs 611 Educational Services 62 Health Care Social Assistance 71* Arts and Entertainment 72 Acoomodation and Food Svcs 81* Other Services 92 Public Administration 445,827 91,439 278,919 183,904 76 336269 50,183 32,608 148,530 979254 394,645 112,629 TOTAL SERVICES Overall Change from Previous Y 3,054,283 325,768 366,007 69,833 63,727 207,620 231,133 137,518 160,723 77 26 255,791 277,970 34,913 32,383 28,162 32,412 122,219 132,701 716,964 780,814 290,724 313,316 81,688 72945 2,271,279 2,484,157 92,,879 12.4% - 8.7% 11.3% 16.9% - 66.5% 8.7% - 7.2% 15.1% 8.6% 8.9% 7.8% - 10.7% 8.5% NAICS MISCELLANEOUS 2013 Annual Total 2013 YTD 2014YTD VTD (Nov 12 -00 13) 948y 12 - 70113) (Nov 13 - 3011 4) % 0008 000 111 -115 211 -221 999 Unknown Agriculture, Forestry, Fishing Mining 8 Utilities Unclassifiable Establishments TOTAL SERVICES Overall Change from Previous Y 4,385 22,645 36,549 83,580 0 3,266 16,706 24,172 44,144 3,441 18,631 69,049 91,121 48978 N/A 5.4% 11.5% 185.7% 1064% 384 200 10 492 484 11 529 575 file:Montnty Sales Tae Report.. The following table presents the Working Capital Statement for each of the City's Enterprise and Internal Service funds. Working Capital is generally defined as the difference between current assets and current liabilities. WORKING CAPITAL ENTERPRISE FUNDS INTERNAL SERV SEWER SEWER METRO STORM SOLID WASTE AIRPORT CEMETERY INSURANCE WORKERi COMPENSATION FACILITIES INNOVATION &TECHNOLOGY EQUIPMENT RENTAL OPERATING REVENUES Charges For Service 9,561,388 5,683,469 - 6,675,123 10,006,048 12,198 733,254 - 623,764 - - InterfundCbargesForService - - - - - - - - - 2,547,395 3,558,897 2,166,415 Sewer Metro Service Revenue - - 11,322,650 - - - - - - - - Rents, Leases, Concessions, &Other - - - - - 473,474 - - - 80,107 97,945 TOTAL OPERATING REVENUES 9,561,388 5,683,469 11,322,650 6,675,123 10,006,048 485,672 733,254 - 623,764 2,627,502 3,656,842 2,166,415 OPERATING EXPENSES Salaries & Wages 1,811,031 1,169,634 - 1,622,429 311,972 16,052 311,855 - 62,469 390,759 1,097,569 419,074 Benefits 791,803 504,892 - 700,682 146,608 5,329 144,069 - 50,998 190,960 450,848 193,086 Supplies 151,658 62,183 - 74,192 10,140 112 108,438 - - 108,739 189,634 769,242 Other Service Charges 2,879,517 1,689,932 22 1,007,583 842,394 350,991 49,459 360,703 161,109 1,149,480 1,334,196 314,002 Intergovernmental Services - 2,420 - 69,058 208,111 - - - - - - - Waste Management Payments - - - - 7,584,163 - - - - - - Sewer Metro Services - - 11,227,707 - - - - - - - - InterfundOperatingRentals &Supplies 827,976 724,194 - 952,073 134,775 - 75,797 - - 88,884 216,297 185,581 Other Expenses - - - - - - - - - - - Depreciation &Amortization 1,809,876 1,431,349 - 1,150,201 14,114 301,263 40,050 - - - 408,118 565,835 TOTAL OPERATING EXPENSES 8,271,860 5,584,605 11,227,730 5,576,219 9,252,277 673,748 729,668 360,703 274,575 1,928,822 3,696,662 2,446,819 OPERATING INCOME (LOSS) 1,289,527 98,865 94,921 1,098,904 753,771 088,076) 3,586 (360,703) 349,189 698,679 (39,820) (280,405) NON -OPERATING REVENUES& EXPENSES Interest Revenue 11,427 9,630 511 13,357 1,071 686 223 839 134 1,561 2,513 4,167 Contributions - - - 23,992 18,238 - 25 - - 2,354 - 799 Other Non -Operating Revenue 153,999 51,853 - 83,007 240 (1,541) 4,654 - - - 1,646 43,926 Gain (loss) On Sale Of Fixed Assets DebtServicelnterest - (49,516) - 07,659) - - 322,871 - - - - (20,838) - (11,134) - - - - - - - - Other Non-Operating Expense - - - - - - - - - - - TOTAL NON-OPERATING REVENUES& EXPENSES 115,910 43,825 511 443,228 19,550 (21,692) (6,233) 839 134 3,915 4,159 48,892 PLUS ITEMS NOT AFFECTING WORKING CAPITAL Depreciation 1,809,876 1,431,349 - 1,150,201 14,114 301,263 40,050 - - - 408,118 565,835 NET WORKING CAPITAL FROM OPERATIONS 3,215,313 1,574,039 95,432 2,692,332 787,435 91,494 37,404 (359,864) 349,323 702,595 372,457 334,323 Increase In Contributions- System Development 430,899 188,050 - 477,338 - - - - - - - IncreaselnContributions - Area Assessments - 3,282 - - - - - - - - - IncreaselnContribu tions - Other Governments 42,200 162,203 - 597,204 - 6,976 - - - - - IncreaselnContributions - Other Funds - - - - - - - - - - - IncreaselnContributions - FAA - - - - - 59,425 - - - - - PmceedsofDebtARivity 67,438 - - - - - - - - - - OperatingTransfers ln - - - 18,649 - - - - - - 119,023 Increase In Restricted Net Assets 10,638 (5,412) - - - (590) - - - - - - Decrease In Long -Term Receivables Increase In Deferred Credits - - 90,000 - - - - - - - - 8,991 - - - - - - - - - - TOTALRESOURCESOTHERTHANOPERATIONS 551,175 438,123 - 1,093,191 - 74,802 - - - - 119,023 Net Change In Restricted Net Assets 473,930 302,281 - 532,624 - (590) - - - 2,200 - crease In Fixed Assets - Salaries 112,677 72,780 - 181,587 - - - - - - - ase In Fixed Assets - Benefits 42,508 30,338 - 73,629 - - - - - - - se In Fixed Assets - Site Improvements 16,734 - - - - - - - - - - selnFixedAssets - land - - - 261,979 - - - - - - - crease In Fixed Assets- Equipment - - - 51,405 - - - - - - 493,581 565,928 crease In Fixed Assets - Construction 1,623,096 888,136 - 2,050,770 - 275,078 - - - - - OperatingTransfers Out 76,846 75,810 - 141,003 - - - - - 295,379 - 7,000 Debt Service Principal 519,405 288,262 - - - - - - - - - TOTAL USES OTHER THAN OPERATIONS 2,865,195 1,657,608 - 3,292,997 - 274,488 - - - 297,579 493,581 572,928 NET CHANGE IN WORKING CAPITAL 901 ,293 354,554 95,432 492,526 787,435 (108,192) 37,404 (359,864) 349,323 405,016 (2,100) (238,606) BEGINNING WORKING CAPITAL - January 1, 2014 14,189,404 12,952,797 1,826,811 15,762,939 1,504,560 801,281 261,934 1,815,731 - 1,976,512 3,406,012 5,920,444 ENDING WORKING CAPITAL- September 30, 2014 15,090,698 13,307,351 1,922,243 16,255,465 2,291,995 693,092 299,338 1,455,867 349,323 2,381,528 3,403,912 5,681,838 NET CHANGE IN WORKING CAPITAL 901,293 354,554 95,432 492,526 787,435 (108,192) 37,404 (359,864) 349,323 405,016 (2,100) (238,606) pagfeRril6A'S Waste Management payment in the amount of 5833,263 has been added to the Solid Waste Fund and is effected in the Ending Working Capital balance. The following table provides an analysis of each of the City's Enterprise and Intemal Service funds - showing 2014 revenues and expenditures by fund. FUND BALANCE ENTERPRISE FUNDS INTERNAL SERVICE FUNDS SEWER SEWER METRO STORM SOLID WASTE AIRPORT CEMETERY INSURANCE WORKER'S COMPENSATION FACILITIES INNOVATION &TECHNOLOGY EQUIPMENT RENTAL OPERATING REVENUES Charges For Service InterfundChargesForService Sewer Metro Service Revenue Rents, leases, Concessions, & Other 9,561388 - - - 5,683,469 - - - - - 11322,650 - 6,675,123 - - - 10,006,048 - - - 12,198 - - 473,474 733,254 - - - - - - - 623,764 - - - - 2,547395 - 80,107 - 3,558,897 - 97,945 - 2,166,415 - - TOTAL OPERATING REVENUES 9,561388 5,683,469 11322,650 6,675,123 10,006,048 485,672 733,254 - 623,764 2,627502 3,656,842 2,166,415 OPERATING EXPENSES Administration Operations & Maintenance Waste Management Payments' Sewer Metro Services Depreciation &Amortization 2,225,427 4,236,558 - - 1,809,876 1,615,204 2,538,051 - - 1,431349 22 - - 11,227,707 - 2,233,129 2,192,889 - - 1,150,201 560,637 1,093363 7584,163 - 14,114 370,648 1,837 - - 301,263 205,124 484,494 - - 40,050 360,703 - - - - - 274,575 - - - - 1,928,822 - - - - 3,288,544 - - 408,118 675,223 1,205,761 - - 565,835 TOTAL OPERATING EXPENSES 8,271,860 5584,605 11,227,730 5576,219 9,252,277 673,748 729,668 360,703 274,575 1,928,822 3,696,662 2,446,819 OPERATING INCOME (LOSS) 1,289527 98,865 94,921 1,098,904 753,771 (188,076) 3,586 (360,703) 349,189 698,679 (39,820) (280,405) NON - OPERATING REVENUES & EXPENSES Interest Revenue Other Non- Operating Revenue Gain (loss) On Sale Of Fixed Assets Other Non - Operating Expense 11,427 153,999 - (49516) 9,630 51,853 - (17,659) 511 - - - 13,357 107,000 322,871 - 1,071 18,478 - - 686 (1541) - (20,838) 223 4,679 - (11,134) 839 - - - 134 - - - 1561 2,354 - - 2,513 1,646 - - 4,167 44,725 - TOTAL NON-OPERATING REVENUES & EXPENSES 115,910 43,825 511 443,228 19,550 (21,692) (6,233) 839 134 3,915 4,159 48,892 INCOME(LOSS)BEFORE CONTRIBUTIONS& TRANSFERS 1,405,437 142,690 95,432 1542,131 773 ,320 (209,769) (2,646) (359,864) 349,323 702,595 (35,660) (231512) Contributions Tmnsfers In Transfers Out 473,099 - (76,846) 353535 - (75,810) - - - 1,074542 18,649 (141,003) - - - 66,401 - - - - - - - - - - - - - (295,379) - 119,023 - - - (7,000) TOTAL CONTRIBUTIONS & TRANSFERS 396,253 277,725 - 952,187 - 66,401 - - - (295,379) 119,023 (7,000) CHANGE IN FUND BALANCE 1,801,690 420,415 95,432 2,494319 773 ,320 (143368) (2,646) (359,864) 349,323 407,216 83,363 (238,512) BEGINNING FUND BALANCE - January 1, 2014 68,655,974 75,821385 1,826,811 51,686,935 1598,247 9,318,866 888,882 1,815,731 - 1,938,141 4,604,445 10,714,407 ENDING FUND BALANCE - September 30, 2014 70,457,664 76,241,800 1,922,243 54,181,254 2,371567 9,175,498 886,236 1,455,867 349,323 2,345,357 4,687,808 10,475,895 September's Waste Management payment in the amoun of $833,263 has been added to the Solid Waste Fund and is reflected in Ending Fund Balance. Page 24 of 24 * CITYOF "� « Memorandum '� _ ° Engineering Division WASHINGTON To: Public Works Committee From; Ingrid Gaub, Assistant Director of EngineeringlCity Engineer CC: Mayor City Clerk Councilmembers Kevin Sriyder, Corrimunity Development & Public Works Director Jacob Sweeting, Assistant City Engineer Date: November 17, 2014 Re: Agenda Modification for the November 17, 2014 Meeting This modification adds the following item to the agenda: III. ACTION C. Resolution No. 5711 (Gaub) A Resolution of the City Council of the City of Auburn, Washington, confirming the determination of emergency for repairs to the traffic signal at the intersection of Oravetr Road and Kersey Way and ratifying and confirming prior acts Page 1 of 4 AUBURN * MORE THAN YOU IMAGWED CITY OF_ � v /• �� ' :-_�� AGENDA BILL APPROVAL FORM �WASH I NGTON Agenda Subject: Resolution No. 5111 Date: November 14, 2014 Department: Community Attachments: Budget Impact: $0 Development and Public Works Administretive Recommendation: Public Works Committee recommend that Cit Council ado ts Resolution No.5111 Background Summary: On November 11, 2014, a tree fell at tFie intersection of Kersey Way and Oreyetz Road striking the span wire signal and causing damage to the traffic signal system and breaking a traffic signal pole. Resolution No. 5111 declares and confirms a determination of emergency that allows the Mayor to negotiate and enter into cbntracts with qualified contractors to repair the damage because there was not suffcient time to enable the City to go through the normal purchasing and contrecting process. Reviewed by Council�8 Committees: Reviewed by Departments 8 Divisions: ❑ Arts Commission COUNCIL COMMITfEES: ❑ Building ❑ M80 ❑ Airport ❑ Finance ❑ Cemetery ❑ Mayor ❑ Hearing Examiner ❑ Municipal Serv. ❑ Finance ❑ Parks ❑ Human Services ❑ Planning 8 CD ❑ Fire ❑ Planning ❑ Park Board �Public Works O Legal ❑ Police ❑ Planning Comm. ❑Other � Public Works ❑ Human Resources Attion: Committee Approval: ❑Yes ❑No CounCil ApprOVal: ❑Ye5 ❑NO Call lOr PubliC Heafing _/_/_ Referred to Until / / Tabled Unlil -I -/ Councilmemtier: Osborne Staff: Gaub Meetin Date: November 17,2014 Item Numberi AUBURN * MORE THAN YOU [MAGINED Page 2 ot 4 RESOLUTION NO. 5111 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF AUBURN, WASHINGTON, CONFIRMING THE DETERMINATION OF EMERGENCY FOR REPAIRS TO THE TRAFFIC SIGNAL AT THE INTERSECTION OF CQRAVETZ ROAD AND KERSEY WAY AND RATIFYING AND CONFIRMING PRIOR ACTS WHEREAS, on November 11, 2014, a wind storm caused various trees to fall through out the City of Auburn; and WHEREAS, a failen tree caused damage to the traffic signal at the intersection of Kersey Way and Oravetz Road creating an unsafe condition; and WHEREAS, the City of Auburn has determined that in order to prevent address a safety issue at the intersection, it is crucial that the City begin repair work as soon as feasibly possible; and WHEREAS, in order to make the repairs in a timely manner as warranted, 4he City does not have time fo follow normal purchasing and contracting procedures. NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF AUBURN, WASHINGTON, HEREBY RESOLVES as follows: Section 1. The City Council finds an emergency exists in conne.ction with the need to repair the traffc signal at the intersection of Kersey Way and Oravetz Road, and there is not sufficient time to enable the City to go through the normal purchasing and contracting process. Resolution No. 5111 November 14, 2014 Page 1 Page 3 of 4 Section 2. That the Mayor is authorized to negotiate and enter intb contracts with qualified contractors and construction service providers to effect the repair of traffc signal at the intersection of Kersey Way and Oravetz Road, and that any action taken in furtherance thereof is hereby ratified. SecEion 3. That this Resolution shall take effect and be in full force upon passage and signatures hereon. Dated and Signed this day of , 2014. CITY OF AUBURN NANCY BACKUS MAYOR ATTEST: Danielle E. Daskam, City Clerk APPROVED AS TO FORM: Daniel B. Heid, City Attorney Resolution No. 5111 November 14, 2014 Page 2 Page 4 of 4