Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2019 - September 2019 Montly Financial Report - Josh DeLay, Finance Director
City of East Wenatchee November 5, 2019 City Council Meeting September 2019 Financial Report Date: November 5, 2019 To: Councilmembers, Mayor Lacy & Department Heads From: Josh DeLay, Finance Director Subject: September 2019 Financial Report This report provides a summary of the City’s overall financial operations through September 30, 2019. It offers a comparison of total overall revenues and expenditures between the current fiscal year and the same point in time as the last fiscal year. For the purposes of this report, operating funds are funds that receive general local tax support and/or expend wages and other steady expenses to support the day-to-day operations of the City. Non-operating funds are funds that are supported through special revenues and/or include non-wage and varying expenses (i.e. capital, grant projects, etc.). Table 1 below shows the City’s revenue collections through September 30, 2019 compared to revenue collections through September 30, 2018, along with the respective dollar and percentage variances for its operating funds. Table 1 September 30, 2019 September 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 4,820,245 4,692,149 128,096 2.73% Street Fund - 101 1,196,059 1,194,982 1,077 0.09% Events Board Fund - 117 65,610 91,758 (26,149) (28.50%) Equipment R&R Fund - 501 450,000 350,000 100,000 28.57% Total Revenues - Operating Funds 6,531,914 6,328,890 203,024 3.21% Revenues - Operating Funds CITY OF EAST WENATCHEE Finance Department 271 9th Street NE * East Wenatchee, WA 98802 P: (509) 886-4507 * F: (509) 884-6233 * Email: jdelay@east- wenatchee.com Page 1 of 26 City of East Wenatchee November 5, 2019 City Council Meeting September 2019 Financial Report Chart 1 is a graphical representation of year to year revenue comparisons for the City’s operating funds. Chart 1 Table 2 below shows the City’s revenue collections through September 30, 2019 compared to revenue collections through September 30, 2018, along with the respective dollar and percentage variances for its non-operating funds. Page 2 of 26 City of East Wenatchee November 5, 2019 City Council Meeting September 2019 Financial Report Table 2 September 30, 2019 September 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - 3,470 (3,470) (100.00%) Trans Benefit District Fund - 105 198,217 195,424 2,793 1.43% Debt Reserve Fund - 110 - 135,000 (135,000) (100.00%) Library Fund - 112 3,500 3,500 - - Hotel/Motel Tax Fund - 113 125,483 84,498 40,985 48.50% Drug Fund - 114 448 130 319 245.07% Criminal Justice Fund - 116 14,011 13,554 457 3.37% Bond Redemption Fund - 202 30,000 30,000 - - Street Improvements Fund - 301 905,734 255,516 650,218 254.47% Storm Water Improvements Fund - 308 38,098 127,610 (89,512) (70.14%) Capital Improvements Fund - 314 471,299 553,921 (82,622) (14.92%) Total Revenues - Non-Operating Funds 1,786,791 1,402,622 384,168 27.39% Revenues - Non-Operating Funds Chart 2 is a graphical representation of year to year revenue comparisons for the City’s non- operating funds. Chart 2 Page 3 of 26 City of East Wenatchee November 5, 2019 City Council Meeting September 2019 Financial Report Revenue Highlights: General Fund revenues are up $128,096, or 2.73%, from last year due to: •$314,918 more property tax allocated to this fund this year versus last year at this time •$106,854 more gambling tax collected due to the re-opening of a gambling establishment •$26,647 more interest earnings mainly in the City’s Local Government Investment Pool (LGIP) account due to higher interest rates The above increases are offset by the following decreases from last year: •$155,533 less sales tax allocation due to other funds needing their allotted sales tax for large purchases and cash flow purposes •$48,155 less phone/cellular utility tax collections •$29,191 less in court fines collected Equipment R&R Fund revenues are up $100,000, or 28.57%, from last year due to a larger sales tax allocation this year versus last year in order to purchase a new snow plow for the Street Department. Hotel/Motel Tax Fund revenues are up $40,985, or 48.50%, from last year due to an overall increase in hotel/motel taxes, and a decision in 2018 to change the hotel/motel tax allocation between this fund and the Events Fund whose revenues are down $26,149, or 28.5%. Street Improvements Fund revenues are up $650,218, or 254.47%, from last year due to 10th Street Public Works Trust Fund Loan reimbursements and a $400,000 grant received from the Complete Streets program. Capital Improvements Fund revenues are down $82,622, or 14.92%, from last year due to the collection of less real estate excise tax presumably due to less real estate sales transactions. Additionally, this fund received $100,000 in property tax allocation last year that it hasn’t received in 2019 yet. Table 3 below shows the City’s expenditures through September 30, 2019 compared to expenditures through September 30, 2018, along with respective dollar and percentage variances for its operating funds. Page 4 of 26 City of East Wenatchee November 5, 2019 City Council Meeting September 2019 Financial Report Table 3 September 30, 2019 September 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 5,174,316 4,805,472 368,844 7.68% Street Fund - 101 1,076,757 1,003,480 73,277 7.30% Events Board Fund - 117 101,037 113,398 (12,361) (10.90%) Equipment R&R Fund - 501 318,978 204,007 114,972 56.36% Total Expenditures - Operating Funds 6,671,088 6,126,356 544,732 8.89% Expenditures - Operating Funds Chart 3 is a graphical representation of year to year expenditure comparisons for the City’s operating funds. Chart 3 Table 4 below shows the City’s expenditures through September 30, 2019 compared to expenditures through September 30, 2018, along with respective dollar and percentage variances for its non- operating funds. Page 5 of 26 City of East Wenatchee November 5, 2019 City Council Meeting September 2019 Financial Report Table 4 September 30, 2019 September 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 62,567 1,471 61,096 4152.88% Trans Benefit District Fund - 105 284,381 - 284,381 - Debt Reserve Fund - 110 - - - - Library Fund - 112 3,683 2,736 947 34.61% Hotel/Motel Tax Fund - 113 103,457 49,592 53,865 108.62% Drug Fund - 114 - - - - Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 30,420 30,604 (184) (0.60%) Street Improvements Fund - 301 603,419 715,158 (111,739) (15.62%) Storm Water Improvements Fund - 308 40,748 113,497 (72,749) (64.10%) Capital Improvements Fund - 314 637,499 68,273 569,226 833.75% Total Expenditures - Non-Operating Funds 1,766,174 981,331 784,843 79.98% Expenditures - Non-Operating Funds Chart 4 is a graphical representation of year to year expenditure comparisons for the City’s non- operating funds. Chart 4 Page 6 of 26 City of East Wenatchee November 5, 2019 City Council Meeting September 2019 Financial Report Expenditure Highlights: General Fund expenditures are up $368,844, or 7.68%, from last year primarily due to the purchase of 1002 N Colorado Ave., and salary and benefit increases. Street Fund expenditures are up $73,277, or 7.3%, from last year due to snow and ice removal overtime, and delayed Department of Transportation utility billings from prior years that we paid this year. Events Fund expenditures are down $12,361, or 10.9%, due to part of the Events Director salary now coming out of the General Fund for her role that isn’t related to the Events Department. Equipment R&R Fund expenditures are up $114,972, or 56.36%, from last year due to the timing of the purchase of replacement vehicles by the Police Department, and the purchase of a new snow plow by the Street Department. Transportation Benefit District Fund expenditures are up $284,381 due to the timing of when overlay projects began and finished between this year and last year. Hotel/Motel Tax Fund expenditures are up $53,865, or 108.62%, due to the contributions to the Wenatchee Valley Museum not occurring out of this fund until June of last year. It was previously paid for out of the General Fund. Street Improvements Fund expenditures are down $111,739, or 15.62%, from last year due to the timing of when projects began and finished between this year and last year. Capital Improvements Fund expenditures are up $569,226, or 833.75%, from last year due to the Gateway project and the rebuild of the gazebo that burnt down, which the City was reimbursed for by its insurance company. The reports presented in the following pages represent accounting system generated line-item details of revenues, expenditures, budgets, and cash balances for each fund through September 30, 2019. Page 7 of 26 Account Number Title Period Fiscal Budget % of Total Balance General Fund Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $10,622.15 $572,478.03 $1,000,000.00 57.25 %$427,521.97 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $396,794.01 $2,193,551.33 $3,270,000.00 67.08 %$1,076,448.67 001-000-000-313-71-00-00 1/10 Sales Tax-Criminal Just $34,276.82 $267,049.19 $277,000.00 96.41 %$9,950.81 001-000-000-316-40-00-00 Electric Utility Tax $26,418.49 $290,253.99 $352,000.00 82.46 %$61,746.01 001-000-000-316-45-00-00 Natural Gas Utility Tax $0.00 $28,940.49 $34,000.00 85.12 %$5,059.51 001-000-000-316-49-00-00 Phone/cellular Utility Tax $33,949.16 $270,993.11 $355,000.00 76.34 %$84,006.89 001-000-000-316-84-00-00 Gambling Tax $0.00 $287,225.54 $302,000.00 95.11 %$14,774.46 001-000-000-316-84-00-01 Gambling Tax Penalties $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Total Taxes $502,060.63 $3,910,491.68 $5,591,500.00 69.94 %$1,681,008.32 Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $0.00 $500.00 $500.00 100.00 %$0.00 001-000-000-321-60-00-00 Taxicab Licenses & Permits $37.00 $705.00 $800.00 88.13 %$95.00 001-000-000-321-91-00-50 Franchise Fees - Cable $0.00 $73,580.69 $97,000.00 75.86 %$23,419.31 001-000-000-321-99-00-00 Business Licenses & Permits $5,545.25 $76,365.83 $81,000.00 94.28 %$4,634.17 001-000-000-321-99-05-00 Other Business Lic & Permits $0.00 $660.00 $0.00 ($660.00) 001-000-000-322-10-00-00 Building & Structure Permits $2,515.72 $28,717.65 $63,000.00 45.58 %$34,282.35 001-000-000-322-90-01-00 Gun Permits $520.00 $5,517.00 $6,200.00 88.98 %$683.00 001-000-000-322-90-02-00 Sign Permits $0.00 $72.50 $100.00 72.50 %$27.50 Total Licenses and Permits $8,617.97 $186,118.67 $248,600.00 74.87 %$62,481.33 Intergovernmental Revenues 001-000-000-333-16-50-00 Columbia River Drug Task Force $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-000-334-00-30-00 Secretary of State Local Records Grant $0.00 $3,300.00 $3,300.00 100.00 %$0.00 001-000-000-334-01-20-00 WaState Court Equip Reimb $0.00 $3,493.55 $3,493.55 100.00 %$0.00 001-000-000-334-03-50-00 Traffic Safety Commission $0.00 $291.84 $0.00 ($291.84) 001-000-000-334-03-51-03 Tsc - Seatbelt Emphasis Patrols $0.00 $1,480.78 $1,200.00 123.40 %($280.78) 001-000-000-334-03-51-04 X-52 Tsc-Speed Limit Emphasis $0.00 $0.00 $2,100.00 0.00 %$2,100.00 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $521.48 $2,538.70 $2,500.00 101.55 %($38.70) 001-000-000-334-03-51-12 Tsc - DUI Emphasis Patrol $0.00 $1,148.24 $2,500.00 45.93 %$1,351.76 001-000-000-334-06-95-00 RIVERCOM 911 Funding Assistance $0.00 $4,506.27 $48,600.00 9.27 %$44,093.73 001-000-000-335-00-91-00 Pud Privilege Tax $0.00 $44,490.03 $41,000.00 108.51 %($3,490.03) 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $8,135.34 $22,419.25 $30,000.00 74.73 %$7,580.75 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $1,449.44 $2,100.00 69.02 %$650.56 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $54,656.98 $70,000.00 78.08 %$15,343.02 001-000-000-336-06-95-00 Liquor Board Profits $27,853.66 $83,577.88 $111,500.00 74.96 %$27,922.12 Revenue Starting Account Number: 001-000-000-308-00-00-00 Beginning Net Cash & Invest Ending Account Number: 501-000-000-397-21-00-20 Transfer In - Criminal Justice Period: 2019 - September 2019 Page 8 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Intergovernmental Revenues $36,510.48 $223,352.96 $323,293.55 69.09 %$99,940.59 Charges for Goods and Services 001-000-000-341-33-10-00 Background Check Fees $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-341-35-30-00 Duplicating Services - Court & Police $0.00 $0.00 $900.00 0.00 %$900.00 001-000-000-341-35-31-00 Copy and Duplication Fees - Admin $4.95 $46.10 $200.00 23.05 %$153.90 001-000-000-341-35-33-00 Recording and Filing Fees $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-341-35-35-00 Annual Admin Reimb Fees $0.00 $5,000.00 $7,700.00 64.94 %$2,700.00 001-000-000-341-96-00-00 Personnel Services $0.00 $2,293.20 $0.00 ($2,293.20) 001-000-000-342-33-00-00 Adult Probation Services $3,060.48 $44,947.99 $80,000.00 56.18 %$35,052.01 001-000-000-342-36-00-00 Housing of Prisoners $851.47 $14,036.58 $27,000.00 51.99 %$12,963.42 001-000-000-342-40-00-01 Fire Marshall Inspection Ser $188.00 $2,912.00 $5,500.00 52.95 %$2,588.00 001-000-000-345-83-00-00 Plan Checking Fees $1,587.50 $17,420.56 $32,000.00 54.44 %$14,579.44 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $0.00 $1,200.00 0.00 %$1,200.00 001-000-000-345-86-00-00 Sepa Permits $239.00 $239.00 $1,000.00 23.90 %$761.00 001-000-000-345-89-00-00 Planning & Development Fees $1,138.00 $11,458.70 $4,500.00 254.64 %($6,958.70) Total Charges for Goods and Services $7,069.40 $98,354.13 $160,200.00 61.39 %$61,845.87 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $9,103.27 $128,089.44 $211,000.00 60.71 %$82,910.56 001-000-000-357-33-00-00 Public Defender Costs $1,502.49 $17,201.00 $29,000.00 59.31 %$11,799.00 001-000-000-357-35-00-00 Restitution $100.00 $360.25 $0.00 ($360.25) Total Fines and Penalties $10,705.76 $145,650.69 $240,000.00 60.69 %$94,349.31 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $9,797.62 $100,940.46 $85,000.00 118.75 %($15,940.46) 001-000-000-361-40-00-00 Sales Tax Interest $626.23 $5,640.10 $2,800.00 201.43 %($2,840.10) 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,195.00 $7,239.27 $14,400.00 50.27 %$7,160.73 001-000-000-369-20-00-00 Unclaimed Property $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-369-91-50-00 Miscellaneous Revenue $4.95 $5,410.34 $6,000.00 90.17 %$589.66 Total Miscellaneous Revenues $11,623.80 $119,230.17 $108,300.00 110.09 %($10,930.17) Other Increases in Fund Resources 001-000-000-389-30-00-03 Fireworks - Cleaning Deposit $0.00 $2,500.00 $2,200.00 113.64 %($300.00) 001-000-000-389-30-00-04 Fireworks - Dcfd Remittance $0.00 $0.00 $200.00 0.00 %$200.00 001-000-000-389-30-00-05 Crime Victim Assessment $165.18 $2,319.35 $3,900.00 59.47 %$1,580.65 001-000-000-389-30-00-10 State Surcharge $88.00 $725.50 $800.00 90.69 %$74.50 001-000-000-389-30-00-15 State Share Weapons Permit Fee $822.50 $6,162.50 $10,000.00 61.63 %$3,837.50 001-000-000-389-30-00-20 Court Remittance--State $8,377.15 $124,431.62 $218,000.00 57.08 %$93,568.38 Total Other Increases in Fund Resources $9,452.83 $136,138.97 $235,100.00 57.91 %$98,961.03 Other Financing Sources 001-000-000-395-10-00-00 Proceeds-Disposition of Assets $0.00 $52.80 $0.00 ($52.80) 001-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $472.57 $0.00 ($472.57) 001-000-000-397-21-01-00 Payroll/claims Corrections $0.00 $382.80 $0.00 ($382.80) Total Other Financing Sources $0.00 $908.17 $0.00 ($908.17) Total General Fund $586,040.87 $4,820,245.44 $6,906,993.55 69.79 %$2,086,748.11 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $0.00 $430,821.65 $500,000.00 86.16 %$69,178.35 Page 9 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-000-313-11-00-00 Sales And Use Tax $0.00 $350,000.00 $350,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $250.00 $2,359.70 $3,700.00 63.78 %$1,340.30 101-000-000-336-00-71-00 Multimodal Transpo City $4,730.25 $14,193.62 $18,000.00 78.85 %$3,806.38 101-000-000-336-00-87-00 Street Fuel Excise Tax $23,698.57 $198,872.22 $299,000.00 66.51 %$100,127.78 101-000-000-336-00-87-05 MVA Transport Cities $4,139.01 $12,419.54 $9,700.00 128.04 %($2,719.54) 101-000-000-338-95-00-00 Road & Street Construction Ser $0.00 $35.00 $0.00 ($35.00) 101-000-000-343-13-00-00 SWA Administrative Services $356.58 $7,659.35 $27,500.00 27.85 %$19,840.65 101-000-000-343-13-00-90 SWA NPDES Reimbursement $40,718.91 $95,955.36 $240,000.00 39.98 %$144,044.64 101-000-000-343-13-00-95 DOE Capacity Grant - SWU $0.00 $31,443.49 $33,149.00 94.86 %$1,705.51 101-000-000-344-85-00-00 Impact Fees $0.00 $9,450.00 $0.00 ($9,450.00) 101-000-000-363-00-00-00 Insurance Claims Payment $0.00 $7,190.28 $0.00 ($7,190.28) 101-000-000-369-91-01-05 Miscellaneous Revenue $0.00 $111.85 $100.00 111.85 %($11.85) 101-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $35,546.70 $35,546.70 $0.00 ($35,546.70) Total Street Fund $109,440.02 $1,196,058.76 $1,481,149.00 80.75 %$285,090.24 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $0.00 $0.00 $153,841.00 0.00 %$153,841.00 Total Community Development Grants Fund $0.00 $0.00 $153,841.00 0.00 %$153,841.00 Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fee Revenue $26,769.60 $198,217.20 $241,000.00 82.25 %$42,782.80 Total Transportation Benefit District Fund $26,769.60 $198,217.20 $241,000.00 82.25 %$42,782.80 Financing Reserves Fund 110-000-000-311-10-00-00 Property Tax $0.00 $0.00 $165,000.00 0.00 %$165,000.00 Total Financing Reserves Fund $0.00 $0.00 $165,000.00 0.00 %$165,000.00 Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $3,500.00 $6,500.00 53.85 %$3,000.00 Total Library Fund $0.00 $3,500.00 $6,500.00 53.85 %$3,000.00 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 HM Tax - Allocated $7,769.53 $62,741.64 $56,850.00 110.36 %($5,891.64) 113-000-000-313-31-04-00 H/M Tax Allocated $7,769.53 $62,741.63 $56,850.00 110.36 %($5,891.63) Total Hotel/Motel Tax Fund $15,539.06 $125,483.27 $113,700.00 110.36 %($11,783.27) Drug Fund 114-000-000-356-50-03-00 Drug Investigation $0.57 $21.23 $150.00 14.15 %$128.77 114-000-000-369-30-00-00 Confiscated/forfeited Property $0.00 $427.26 $0.00 ($427.26) Total Drug Fund $0.57 $448.49 $150.00 298.99 %($298.49) Criminal Justice Fund 116-000-000-336-06-21-00 Crim Justice - Population $0.00 $3,045.13 $3,700.00 82.30 %$654.87 116-000-000-336-06-26-00 Crim Just - Special Programs $0.00 $10,965.44 $13,400.00 81.83 %$2,434.56 Total Criminal Justice Fund $0.00 $14,010.57 $17,100.00 81.93 %$3,089.43 Events Board Fund 117-000-100-313-31-00-00 H/M Tax - Events $7,769.53 $39,789.77 $60,000.00 66.32 %$20,210.23 117-000-200-347-40-02-01 Easter Egg Hunt Admission Fees $0.00 $1,427.85 $1,600.00 89.24 %$172.15 117-000-300-347-40-12-02 Classy Chassis Parade/car Show $0.00 $9,105.00 $10,000.00 91.05 %$895.00 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $0.00 $250.00 $0.00 ($250.00) Page 10 of 26 Account Number Title Period Fiscal Budget % of Total Balance 117-000-300-347-90-00-12 Classy Chassis Sponsorships $0.00 $6,500.00 $9,000.00 72.22 %$2,500.00 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $0.00 $2,202.00 $1,650.00 133.45 %($552.00) 117-000-400-347-40-11-03 Wings & Wheels Car Show Registration $1,520.00 $2,635.00 $5,500.00 47.91 %$2,865.00 117-000-400-347-40-11-07 Wings & Wheels Vendor Fees $50.00 $100.00 $300.00 33.33 %$200.00 117-000-400-347-90-00-01 Wings & Wheels Donations $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-400-347-90-00-11 Wings & Wheels Sponsorships $1,700.00 $3,000.00 $6,500.00 46.15 %$3,500.00 117-000-400-347-90-00-13 Schedule of Events Brochure $0.00 $0.00 $5,000.00 0.00 %$5,000.00 117-000-450-347-90-00-12 PkwyPile-up Car Show Sponsorship $0.00 $500.00 $450.00 111.11 %($50.00) 117-000-450-347-90-00-15 PkwyPile-up Car Show Misc Revenue $0.00 $0.00 $270.00 0.00 %$270.00 117-000-500-367-19-00-01 Christmas Sponsorships $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-610-347-40-00-00 Diggin the Sun Volleyball Entry Fee $0.00 $100.00 $0.00 ($100.00) Total Events Board Fund $11,039.53 $65,609.62 $103,270.00 63.53 %$37,660.38 Bond Redemption Fund 202-000-000-311-10-00-00 Property Tax $0.00 $30,000.00 $30,000.00 100.00 %$0.00 Total Bond Redemption Fund $0.00 $30,000.00 $30,000.00 100.00 %$0.00 Street Improvements Fund 301-000-000-311-10-00-00 Property Tax $0.00 $0.00 $17,678.00 0.00 %$17,678.00 301-000-000-334-03-27-30 TIB Relight WA Install Grant $0.00 $58,150.00 $0.00 ($58,150.00) 301-000-000-334-03-60-01 SRTS - 5th St NE: Sterling $0.00 $0.00 $50,000.00 0.00 %$50,000.00 301-000-000-334-03-60-02 SRTS - 5th St NE: Kenroy $0.00 $0.00 $30,000.00 0.00 %$30,000.00 301-000-000-334-03-80-05 TIB Grant Road/Eastmont Ave Intersection Repair $0.00 $0.00 $97,000.00 0.00 %$97,000.00 301-000-000-334-03-80-07 TIB - S. Kentucky & 5th ST. NE $0.00 $3,942.20 $27,000.00 14.60 %$23,057.80 301-000-000-334-03-80-08 TIB 3rd St SE/Highline Drive Roundabout $0.00 $0.00 $85,000.00 0.00 %$85,000.00 301-000-000-334-03-80-12 TIB Complete Streets Award $0.00 $400,000.00 $400,000.00 100.00 %$0.00 301-000-000-334-03-80-22 TIB - Highline Drive $0.00 $35,149.35 $0.00 ($35,149.35) 301-000-000-334-04-20-02 PWTFL - 10th Street Design $0.00 $131,326.16 $750,000.00 17.51 %$618,673.84 301-000-000-361-00-00-00 Interest Earnings $25.20 $25.20 $0.00 ($25.20) 301-000-000-397-41-10-05 Transfer In-TBD Fund 105 Proj Funding $0.00 $277,141.05 $360,000.00 76.98 %$82,858.95 Total Street Improvements Fund $25.20 $905,733.96 $1,816,678.00 49.86 %$910,944.04 Storm Water Improvements Fund 308-000-000-334-03-10-00 State Ecology Grant $36,302.13 $36,302.13 $37,500.00 96.81 %$1,197.87 308-000-000-343-13-00-00 GEWSWU 10th St Design $0.00 $0.00 $225,000.00 0.00 %$225,000.00 308-000-000-343-13-00-30 SWA Small Improvement Projects $0.00 $0.00 $100,000.00 0.00 %$100,000.00 308-000-000-343-13-00-83 DOE Grant 19th St. NW Design $0.00 $1,795.94 $250,000.00 0.72 %$248,204.06 Total Storm Water Improvements Fund $36,302.13 $38,098.07 $612,500.00 6.22 %$574,401.93 Capital Improvements Fund 314-000-000-311-10-00-00 Real and Personal Property Taxes $0.00 $14,976.82 $100,000.00 14.98 %$85,023.18 314-000-000-318-34-00-00 Real Estate Excise Tax $37,697.82 $268,136.17 $350,000.00 76.61 %$81,863.83 314-000-000-333-10-00-00 Douglas County Regional Share $188,186.00 $188,186.00 $188,000.00 100.10 %($186.00) Total Capital Improvements Fund $225,883.82 $471,298.99 $638,000.00 73.87 %$166,701.01 Equipment Purchase, Repair & Replacement Fund 501-000-000-313-11-00-10 Sales & Use Tax - Police $0.00 $150,000.00 $150,000.00 100.00 %$0.00 Page 11 of 26 Account Number Title Period Fiscal Budget % of Total Balance 501-000-000-313-11-00-20 Sales & Use Tax - Streets $0.00 $300,000.00 $300,000.00 100.00 %$0.00 Total Equipment Purchase, Repair & Replacement Fund $0.00 $450,000.00 $450,000.00 100.00 %$0.00 Grand Totals $1,011,040.80 $8,318,704.37 $12,735,881.55 65.32 %$4,417,177.18 Page 12 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $586,040.87 $4,820,245.44 $6,906,993.55 69.79 %$2,086,748.11 101-000-000-000-00-00-00 Street Fund $109,440.02 $1,196,058.76 $1,481,149.00 80.75 %$285,090.24 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $0.00 $153,841.00 0.00 %$153,841.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $26,769.60 $198,217.20 $241,000.00 82.25 %$42,782.80 110-000-000-000-00-00-00 Financing Reserves Fund $0.00 $0.00 $165,000.00 0.00 %$165,000.00 112-000-000-000-00-00-00 Library Fund $0.00 $3,500.00 $6,500.00 53.85 %$3,000.00 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $15,539.06 $125,483.27 $113,700.00 110.36 %($11,783.27) 114-000-000-000-00-00-00 Drug Fund $0.57 $448.49 $150.00 298.99 %($298.49) 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $14,010.57 $17,100.00 81.93 %$3,089.43 117-000-000-000-00-00-00 Events Board Fund $11,039.53 $65,609.62 $103,270.00 63.53 %$37,660.38 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $30,000.00 $30,000.00 100.00 %$0.00 301-000-000-000-00-00-00 Street Improvements Fund $25.20 $905,733.96 $1,816,678.00 49.86 %$910,944.04 308-000-000-000-00-00-00 Storm Water Improvements Fund $36,302.13 $38,098.07 $612,500.00 6.22 %$574,401.93 314-000-000-000-00-00-00 Capital Improvements Fund $225,883.82 $471,298.99 $638,000.00 73.87 %$166,701.01 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $0.00 $450,000.00 $450,000.00 100.00 %$0.00 Grand Totals $1,011,040.80 $8,318,704.37 $12,735,881.55 65.32 %$4,417,177.18 Page 13 of 26 Account Number Title Period Fiscal Budget % of Total Balance General Fund General Government 001-000-001-515-10-40-00 Professional Services - Legal $96.00 $96.00 $0.00 ($96.00) 001-000-001-518-20-40-00 Property Management - 311 9th St NE $0.00 $419.51 $1,200.00 34.96 %$780.49 001-000-001-518-90-40-00 GWATA Membership $0.00 $0.00 $300.00 0.00 %$300.00 001-000-001-518-91-30-00 Wellness $551.37 $2,121.64 $2,500.00 84.87 %$378.36 001-000-001-518-93-49-00 City Theme $0.00 $282.94 $1,000.00 28.29 %$717.06 001-000-001-521-10-29-00 Leoff 1 Ins Premiums/misc $2,082.00 $21,488.16 $27,500.00 78.14 %$6,011.84 001-000-001-528-70-40-00 River Com $28,242.67 $254,184.03 $340,000.00 74.76 %$85,815.97 001-000-001-539-30-40-00 Animal Control $6,126.24 $49,009.92 $73,515.00 66.67 %$24,505.08 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $0.00 $13,265.00 $13,265.00 100.00 %$0.00 001-000-001-558-70-40-00 Contributions - Region $0.00 $15,000.00 $25,000.00 60.00 %$10,000.00 001-000-001-558-70-41-00 Ncw Economic Development Dist $0.00 $1,187.50 $1,250.00 95.00 %$62.50 001-000-001-558-70-41-05 NCWEDD Chelan/Douglas Trends $0.00 $1,500.00 $1,500.00 100.00 %$0.00 001-000-001-558-70-41-07 Wenatchee Valley Chamber of Commerce $0.00 $0.00 $360.00 0.00 %$360.00 001-000-001-558-70-41-10 Spirit of Wenatchee Miss Veedol $0.00 $3,000.00 $3,000.00 100.00 %$0.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$0.00 $2,587.52 $3,600.00 71.88 %$1,012.48 001-000-001-588-80-00-00 Prior Year Corrections $0.00 $1,766.00 $0.00 ($1,766.00) 001-000-001-594-58-60-01 City Land Purchase - 1002 Colorado Ave $0.00 $240,186.69 $240,186.69 100.00 %$0.00 Total General Government $37,098.28 $606,094.91 $734,176.69 82.55 %$128,081.78 Legislative 001-000-110-511-60-10-00 Salaries $15,775.28 $138,167.90 $165,000.00 83.74 %$26,832.10 001-000-110-511-60-20-00 Benefits $5,090.17 $45,671.11 $95,000.00 48.07 %$49,328.89 001-000-110-511-60-21-50 Public Defender $8,100.00 $73,400.00 $96,000.00 76.46 %$22,600.00 001-000-110-511-60-30-00 Public Defender Conflicts $600.00 $3,555.00 $6,000.00 59.25 %$2,445.00 001-000-110-511-60-31-00 Office Supplies $67.75 $124.12 $400.00 31.03 %$275.88 001-000-110-511-60-31-05 Newsletter Printing & Mailing $0.00 $9,136.05 $11,000.00 83.06 %$1,863.95 001-000-110-511-60-31-10 Public Records Expenses $0.00 $46.25 $90.00 51.39 %$43.75 001-000-110-511-60-40-00 Training $50.00 $2,143.47 $4,000.00 53.59 %$1,856.53 001-000-110-511-60-41-00 Professional Services $135.25 $23,631.26 $28,500.00 82.92 %$4,868.74 001-000-110-511-60-41-20 Awc Annual Membership Fee $0.00 $9,703.00 $9,703.00 100.00 %$0.00 001-000-110-511-60-42-01 Telephone $0.00 $976.04 $1,800.00 54.22 %$823.96 001-000-110-511-60-43-00 Travel $0.00 $1,073.40 $2,100.00 51.11 %$1,026.60 001-000-110-511-60-43-01 Travel - Misawa $0.00 $4,620.00 $5,000.00 92.40 %$380.00 001-000-110-511-60-44-00 Advertising $541.20 $761.76 $6,500.00 11.72 %$5,738.24 001-000-110-511-60-45-00 Election Costs - Registered Voters $0.00 $19,902.02 $21,000.00 94.77 %$1,097.98 001-000-110-511-60-46-00 Insurance $91.20 $1,466.80 $11,000.00 13.33 %$9,533.20 Expenditure Starting Account Number: 001-000-001-515-10-40-00 Professional Services - Legal Ending Account Number: 501-001-000-508-80-00-00 Ending EPM&R Fund Balance - Unreserved Period: 2019 - September 2019 Page 14 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-110-511-60-47-00 Background Check Costs $0.00 $108.00 $250.00 43.20 %$142.00 001-000-110-511-60-49-00 Miscellaneous $332.88 $5,021.38 $5,000.00 100.43 %($21.38) Total Legislative $30,783.73 $339,507.56 $468,343.00 72.49 %$128,835.44 Municipal Court 001-000-120-512-50-10-00 Salaries $15,071.50 $137,130.36 $182,000.00 75.35 %$44,869.64 001-000-120-512-50-12-00 Salaries - Probation Svcs $4,404.82 $40,116.64 $53,000.00 75.69 %$12,883.36 001-000-120-512-50-20-00 Benefits $5,326.11 $48,861.07 $66,000.00 74.03 %$17,138.93 001-000-120-512-50-22-00 Benefits - Probation Svcs $3,028.64 $26,924.64 $36,000.00 74.79 %$9,075.36 001-000-120-512-50-31-00 Office Supplies $133.62 $1,535.02 $3,300.00 46.52 %$1,764.98 001-000-120-512-50-40-00 Training $0.00 $1,535.00 $1,500.00 102.33 %($35.00) 001-000-120-512-50-43-00 Travel $783.00 $5,930.11 $4,000.00 148.25 %($1,930.11) 001-000-120-512-50-46-00 Insurance $49.43 $326.99 $12,600.00 2.60 %$12,273.01 001-000-120-512-50-49-00 Miscellaneous $0.00 $109.84 $1,200.00 9.15 %$1,090.16 001-000-120-512-50-49-01 Interpreting $0.00 $280.00 $5,000.00 5.60 %$4,720.00 001-000-120-512-50-49-02 Judge Protems $150.00 $2,175.00 $4,000.00 54.38 %$1,825.00 001-000-120-512-50-49-03 Witness Fees $0.00 $91.98 $500.00 18.40 %$408.02 001-000-120-512-50-49-04 Juror Fees $0.00 $1,282.14 $2,000.00 64.11 %$717.86 001-000-120-512-50-49-09 Security $437.50 $3,125.00 $6,000.00 52.08 %$2,875.00 001-000-120-594-12-60-00 Capital Outlay $0.00 $21,293.61 $24,495.00 86.93 %$3,201.39 Total Municipal Court $29,384.62 $290,717.40 $401,595.00 72.39 %$110,877.60 City Clerk 001-000-140-514-20-10-00 Salaries $6,143.84 $58,791.52 $78,884.00 74.53 %$20,092.48 001-000-140-514-20-20-00 Benefits $3,179.07 $29,217.35 $39,000.00 74.92 %$9,782.65 001-000-140-514-20-31-00 Office Supplies $28.18 $318.83 $3,000.00 10.63 %$2,681.17 001-000-140-514-20-31-01 Central Stores $1,212.06 $4,614.22 $4,000.00 115.36 %($614.22) 001-000-140-514-20-40-00 Training $0.00 $280.00 $2,000.00 14.00 %$1,720.00 001-000-140-514-20-41-00 Membership Dues & Publications $217.76 $547.12 $1,200.00 45.59 %$652.88 001-000-140-514-20-43-00 Travel $0.00 $2,004.93 $2,500.00 80.20 %$495.07 001-000-140-514-20-44-00 Advertising $397.11 $1,099.38 $2,000.00 54.97 %$900.62 001-000-140-514-20-46-00 Insurance $25.27 $114.78 $8,000.00 1.43 %$7,885.22 001-000-140-514-20-48-00 Repairs & Maintenance $0.00 $0.00 $500.00 0.00 %$500.00 001-000-140-514-20-49-00 Miscellaneous $0.00 $180.87 $750.00 24.12 %$569.13 001-000-140-514-30-20-00 Records Services $0.00 $488.71 $1,000.00 48.87 %$511.29 001-000-140-514-30-25-00 Codification $0.00 $982.48 $2,100.00 46.78 %$1,117.52 Total City Clerk $11,203.29 $98,640.19 $144,934.00 68.06 %$46,293.81 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $104.19 $3,477.62 $14,000.00 24.84 %$10,522.38 001-000-141-514-20-42-01 Telephone Line Charges $737.00 $10,098.24 $13,000.00 77.68 %$2,901.76 001-000-141-514-20-42-03 Postage $0.00 $2,500.00 $8,000.00 31.25 %$5,500.00 001-000-141-514-20-48-00 Repairs & Maintenance $745.64 $6,205.82 $1,500.00 413.72 %($4,705.82) 001-000-141-514-20-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 Total Internal Services $1,586.83 $22,281.68 $37,000.00 60.22 %$14,718.32 Finance 001-000-142-514-20-10-00 Salaries $14,245.37 $128,987.95 $174,000.00 74.13 %$45,012.05 001-000-142-514-20-20-00 Benefits $6,427.39 $60,087.06 $80,000.00 75.11 %$19,912.94 Page 15 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-142-514-20-31-00 Office Supplies $26.01 $702.45 $1,700.00 41.32 %$997.55 001-000-142-514-20-43-00 Travel $0.00 $130.62 $600.00 21.77 %$469.38 001-000-142-514-20-46-00 Insurance $23.07 $426.67 $8,000.00 5.33 %$7,573.33 001-000-142-514-20-49-00 Miscellaneous $0.00 $5.95 $400.00 1.49 %$394.05 001-000-142-514-23-20-00 Budgeting, Accting, & Auditing $0.00 $1,291.29 $22,000.00 5.87 %$20,708.71 001-000-142-514-25-30-00 Bank Charges & Fees $305.45 $3,290.19 $4,000.00 82.25 %$709.81 001-000-142-514-40-20-00 Training $0.00 $250.00 $2,000.00 12.50 %$1,750.00 Total Finance $21,027.29 $195,172.18 $292,700.00 66.68 %$97,527.82 Information Technology 001-000-145-514-00-10-00 IT Salaries $7,586.00 $60,688.00 $92,000.00 65.97 %$31,312.00 001-000-145-514-00-20-00 IT Benefits $3,662.77 $29,353.89 $36,000.00 81.54 %$6,646.11 001-000-145-514-00-40-00 Memberships $0.00 $75.00 $0.00 ($75.00) 001-000-145-514-10-10-00 IT Contractor $0.00 $2,671.46 $0.00 ($2,671.46) 001-000-145-514-20-31-00 Supplies $0.00 $307.82 $0.00 ($307.82) 001-000-145-514-20-40-00 Network Services $0.00 $19,642.09 $0.00 ($19,642.09) 001-000-145-514-20-40-05 Disaster Backup System Support $8,622.03 $8,622.03 $9,000.00 95.80 %$377.97 001-000-145-514-20-40-10 Annual Fee - ESRI GIS System License $0.00 $0.00 $1,100.00 0.00 %$1,100.00 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $0.00 $15,299.60 $20,645.00 74.11 %$5,345.40 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $0.00 $5,626.97 $6,000.00 93.78 %$373.03 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $0.00 $7,000.00 0.00 %$7,000.00 001-000-145-514-20-40-40 Annual Subscription - Granicus $0.00 $7,526.01 $7,000.00 107.51 %($526.01) 001-000-145-514-20-40-50 Annual License - FTR Recording System $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-145-514-20-40-55 Annual Support & Maintenance - Laserfiche $0.00 $8,288.12 $8,500.00 97.51 %$211.88 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $0.00 $8,244.84 $8,000.00 103.06 %($244.84) 001-000-145-514-20-48-00 Repairs & Maintenance $102.79 $428.04 $1,000.00 42.80 %$571.96 001-000-145-514-20-49-00 Miscellaneous $97.32 $418.12 $300.00 139.37 %($118.12) 001-000-145-594-14-60-20 Capital - Cmptr Software Admin $2,193.66 $11,594.35 $28,000.00 41.41 %$16,405.65 001-000-145-594-14-60-25 Capital - Cmptr Hdwe Admin $187.07 $6,026.66 $25,000.00 24.11 %$18,973.34 001-000-145-594-14-60-27 Capital - Cmptr Equip Police ($113.56)$7,107.52 $25,000.00 28.43 %$17,892.48 001-000-145-594-14-60-35 Capital - Cmptr Equip Admin $0.00 $911.69 $6,500.00 14.03 %$5,588.31 001-000-145-594-14-60-40 Capital - Cmptr Sftwr Police $0.00 $1,873.40 $1,500.00 124.89 %($373.40) Total Information Technology $22,338.08 $194,705.61 $284,045.00 68.55 %$89,339.39 Legal 001-000-151-515-31-10-00 Salaries $11,634.60 $106,231.37 $139,000.00 76.43 %$32,768.63 001-000-151-515-31-20-00 Benefits $5,314.52 $50,043.25 $65,000.00 76.99 %$14,956.75 001-000-151-515-31-20-10 Training $0.00 $35.00 $1,000.00 3.50 %$965.00 001-000-151-515-31-25-00 Professional Services $0.00 $182.00 $2,500.00 7.28 %$2,318.00 001-000-151-515-31-25-10 Licensing $0.00 $0.00 $500.00 0.00 %$500.00 001-000-151-515-31-31-00 Office Supplies $0.00 $39.80 $300.00 13.27 %$260.20 001-000-151-515-31-43-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-151-515-31-46-00 Insurance $41.74 $125.03 $11,000.00 1.14 %$10,874.97 001-000-151-515-31-49-00 Miscellaneous $0.00 $2,692.69 $5,000.00 53.85 %$2,307.31 Page 16 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $500.00 0.00 %$500.00 001-000-151-596-00-60-00 Capital Outlay $0.00 $0.00 $500.00 0.00 %$500.00 Total Legal $16,990.86 $159,349.14 $227,300.00 70.11 %$67,950.86 Civil Service 001-000-160-521-10-10-00 Salaries $260.00 $2,340.00 $3,120.00 75.00 %$780.00 001-000-160-521-10-46-00 Insurance $16.48 $66.32 $6,500.00 1.02 %$6,433.68 001-000-160-521-10-49-00 Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Civil Service $276.48 $2,406.32 $9,720.00 24.76 %$7,313.68 Central Services 001-000-180-518-30-31-00 Office Supplies $0.00 $30.83 $0.00 ($30.83) 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $238.78 $1,397.59 $2,000.00 69.88 %$602.41 001-000-180-518-30-35-00 Small Tools & Equipment $586.02 $842.61 $10,000.00 8.43 %$9,157.39 001-000-180-518-30-41-00 Professional Services $246.85 $17,672.45 $20,000.00 88.36 %$2,327.55 001-000-180-518-30-41-01 Contracted Custodial Services $2,206.13 $18,557.72 $24,000.00 77.32 %$5,442.28 001-000-180-518-30-41-05 Security Services $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-180-518-30-46-00 Insurance $184.01 $427.60 $41,000.00 1.04 %$40,572.40 001-000-180-518-30-47-00 Utilities $1,179.18 $17,835.34 $25,000.00 71.34 %$7,164.66 001-000-180-518-30-48-00 Repairs & Maintenance $2,419.54 $8,478.01 $12,000.00 70.65 %$3,521.99 001-000-180-518-30-49-00 Miscellaneous $377.11 $601.98 $2,000.00 30.10 %$1,398.02 001-000-180-518-30-49-01 Landscaping $0.00 $667.16 $12,000.00 5.56 %$11,332.84 001-000-180-518-61-41-00 Judgements & Settlements $0.00 $0.00 $18,000.00 0.00 %$18,000.00 001-000-180-518-92-20-00 Ancillary (interfund maintenance)$594.36 $5,368.60 $6,000.00 89.48 %$631.40 001-000-180-594-18-60-00 Capital Outlay $1,571.06 $10,059.99 $10,000.00 100.60 %($59.99) Total Central Services $9,603.04 $81,939.88 $184,000.00 44.53 %$102,060.12 Law Enforcement 001-000-210-521-10-10-00 Salaries $170,711.38 $1,558,834.63 $2,120,000.00 73.53 %$561,165.37 001-000-210-521-10-10-02 Overtime Salaries $16,177.51 $140,103.79 $150,000.00 93.40 %$9,896.21 001-000-210-521-10-10-03 Overtime Salaries-Traf Control $780.39 $4,477.87 $8,000.00 55.97 %$3,522.13 001-000-210-521-10-20-00 Benefits $62,133.79 $579,239.07 $810,000.00 71.51 %$230,760.93 001-000-210-521-10-20-01 Clothing Allowance $1,950.91 $6,693.83 $15,600.00 42.91 %$8,906.17 001-000-210-521-10-31-00 Office Supplies $684.44 $6,247.12 $8,000.00 78.09 %$1,752.88 001-000-210-521-10-31-05 Office Machine Costs $0.00 $1,776.79 $5,000.00 35.54 %$3,223.21 001-000-210-521-10-32-00 Fuel Consumed $4,517.29 $34,799.66 $45,000.00 77.33 %$10,200.34 001-000-210-521-10-35-00 Small Tools & Equipment $1,162.60 $11,351.82 $13,000.00 87.32 %$1,648.18 001-000-210-521-10-35-02 Waspc Traffic Safety Grant $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-210-521-10-35-05 Bulletproof Vests $0.00 $997.60 $4,000.00 24.94 %$3,002.40 001-000-210-521-10-35-06 US Marshall Fugitive Task Force $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-521-10-41-00 Professional Services $484.16 $10,154.47 $14,000.00 72.53 %$3,845.53 001-000-210-521-10-42-01 Telephone $0.00 $15,366.25 $28,000.00 54.88 %$12,633.75 001-000-210-521-10-42-03 Postage $289.80 $1,003.98 $1,200.00 83.67 %$196.02 001-000-210-521-10-43-00 Travel $1,238.19 $14,545.31 $22,000.00 66.12 %$7,454.69 001-000-210-521-10-46-00 Insurance $354.83 $5,107.38 $75,600.00 6.76 %$70,492.62 001-000-210-521-10-48-00 Repairs & Maintenance $353.65 $2,891.48 $8,000.00 36.14 %$5,108.52 001-000-210-521-10-49-00 Miscellaneous $150.25 $2,987.73 $5,500.00 54.32 %$2,512.27 001-000-210-521-10-49-01 Reserves $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Page 17 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-10-49-02 Dry Cleaning Services $0.00 $404.54 $1,500.00 26.97 %$1,095.46 001-000-210-521-30-40-00 Crime Prevention $0.00 $801.22 $750.00 106.83 %($51.22) 001-000-210-521-40-22-00 Training-Police Chief $0.00 $480.00 $1,000.00 48.00 %$520.00 001-000-210-521-40-25-00 Training--Officers $0.00 $3,584.00 $8,000.00 44.80 %$4,416.00 001-000-210-521-40-27-00 Training--Office Staff $0.00 $500.00 $800.00 62.50 %$300.00 001-000-210-521-40-30-00 Training - Recruits-Academy $1,181.38 $7,484.20 $9,600.00 77.96 %$2,115.80 001-000-210-521-50-10-00 Ancillary (interfund vehicle maintenance) $0.00 $1,425.22 $2,400.00 59.38 %$974.78 001-000-210-521-50-49-00 Other Services $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-594-21-60-00 Capital Outlay $0.00 $39,372.16 $84,000.00 46.87 %$44,627.84 Total Law Enforcement $262,170.57 $2,450,630.12 $3,448,450.00 71.06 %$997,819.88 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $19,196.00 $186,438.14 $302,000.00 61.73 %$115,561.86 001-000-230-523-60-20-00 Medical Care For Prisoners $0.00 $2,839.62 $11,000.00 25.81 %$8,160.38 001-000-230-527-60-30-00 Juvenile Detention $0.00 $2,760.00 $8,000.00 34.50 %$5,240.00 Total Jail Services $19,196.00 $192,037.76 $321,000.00 59.82 %$128,962.24 Public Works 001-000-315-542-10-10-00 Salaries $6,867.00 $62,412.77 $83,000.00 75.20 %$20,587.23 001-000-315-542-10-20-00 Benefits $3,327.98 $30,313.88 $42,000.00 72.18 %$11,686.12 001-000-315-542-10-31-00 Office Supplies $17.52 $106.39 $750.00 14.19 %$643.61 001-000-315-542-10-35-00 Small Tools & Equipment $349.50 $349.50 $500.00 69.90 %$150.50 001-000-315-542-10-43-00 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-46-00 Insurance $36.25 $112.27 $10,500.00 1.07 %$10,387.73 001-000-315-542-10-49-00 Training $0.00 $125.00 $2,000.00 6.25 %$1,875.00 001-000-315-542-10-49-01 Miscellaneous $0.00 $606.55 $1,000.00 60.66 %$393.45 001-000-315-542-10-49-05 Registrations $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-49-10 Memberships $0.00 $124.00 $300.00 41.33 %$176.00 001-000-315-544-20-45-00 Engineering Support Services $0.00 $5,945.25 $10,000.00 59.45 %$4,054.75 Total Public Works $10,598.25 $100,095.61 $152,050.00 65.83 %$51,954.39 Planning 001-000-580-558-60-10-00 Salaries $14,121.93 $128,744.30 $172,000.00 74.85 %$43,255.70 001-000-580-558-60-20-00 Benefits $4,989.95 $45,732.06 $62,000.00 73.76 %$16,267.94 001-000-580-558-60-31-00 Office Supplies $0.00 $606.64 $900.00 67.40 %$293.36 001-000-580-558-60-32-00 Fuel Consumed $53.79 $154.48 $200.00 77.24 %$45.52 001-000-580-558-60-35-00 Small Tools & Equipment $0.00 $0.00 $100.00 0.00 %$100.00 001-000-580-558-60-40-00 Training $0.00 $460.00 $1,500.00 30.67 %$1,040.00 001-000-580-558-60-41-00 Professional Services $0.00 $0.00 $12,000.00 0.00 %$12,000.00 001-000-580-558-60-41-01 Hearings Examiner $0.00 $1,800.00 $450.00 400.00 %($1,350.00) 001-000-580-558-60-41-02 Engineer/architect Services $0.00 $792.50 $1,400.00 56.61 %$607.50 001-000-580-558-60-43-00 Travel $0.00 $1,882.93 $1,500.00 125.53 %($382.93) 001-000-580-558-60-44-00 Advertising $147.39 $3,162.12 $2,400.00 131.76 %($762.12) 001-000-580-558-60-46-00 Insurance $38.45 $145.41 $10,400.00 1.40 %$10,254.59 001-000-580-558-60-48-00 Repairs & Maintenance $0.00 $43.28 $100.00 43.28 %$56.72 001-000-580-558-60-49-00 Miscellaneous $0.00 $1,198.00 $2,000.00 59.90 %$802.00 Total Planning $19,351.51 $184,721.72 $266,950.00 69.20 %$82,228.28 Page 18 of 26 Account Number Title Period Fiscal Budget % of Total Balance Code Compliance 001-000-590-558-50-10-00 Salaries $8,556.56 $77,186.76 $104,000.00 74.22 %$26,813.24 001-000-590-558-50-20-00 Benefits $4,289.06 $38,775.61 $53,000.00 73.16 %$14,224.39 001-000-590-558-50-31-00 Office Supplies $0.00 $0.00 $200.00 0.00 %$200.00 001-000-590-558-50-32-00 Fuel Consumed $0.00 $308.40 $350.00 88.11 %$41.60 001-000-590-558-50-35-00 Small Tools & Equipment $0.00 $19.47 $100.00 19.47 %$80.53 001-000-590-558-50-40-00 Training $0.00 $0.00 $300.00 0.00 %$300.00 001-000-590-558-50-41-00 Professional Services $0.00 $5,268.66 $0.00 ($5,268.66) 001-000-590-558-50-41-01 Fire Marshal Services ($94.00)$5,174.66 $20,664.00 25.04 %$15,489.34 001-000-590-558-50-42-00 Abatement $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-590-558-50-43-00 Travel $0.00 $0.00 $475.00 0.00 %$475.00 001-000-590-558-50-46-00 Insurance $25.27 $86.75 $7,900.00 1.10 %$7,813.25 001-000-590-558-50-49-00 Miscellaneous $10.12 $105.12 $300.00 35.04 %$194.88 Total Code Compliance $12,787.01 $126,925.43 $217,289.00 58.41 %$90,363.57 Other Expenditures 001-001-000-589-30-00-03 Fireworks-Cleaning Deposit Ref $0.00 $2,500.00 $900.00 277.78 %($1,600.00) 001-001-000-589-30-00-04 Fireworks - Dcfd Remittance $0.00 $750.00 $200.00 375.00 %($550.00) 001-001-000-589-30-00-05 County Share of Crime Victims $0.00 $2,400.08 $4,200.00 57.14 %$1,799.92 001-001-000-589-30-00-10 Remittance: State Bldg Code Surcharge $76.00 $580.00 $400.00 145.00 %($180.00) 001-001-000-589-30-00-15 State Share of Permits & Licenses $732.25 $6,865.50 $12,000.00 57.21 %$5,134.50 001-001-000-589-30-00-20 Court Remittances $15,123.91 $115,995.06 $220,000.00 52.73 %$104,004.94 Total Other Expenditures $15,932.16 $129,090.64 $237,700.00 54.31 %$108,609.36 Total General Fund $520,328.00 $5,174,316.15 $7,427,252.69 69.67 %$2,252,936.54 Street Fund Storm Water Administration 101-000-311-542-42-10-00 SWU Administration - Salaries $472.48 $2,174.93 $15,000.00 14.50 %$12,825.07 101-000-311-542-42-20-00 SWU Administration - Benefits $203.31 $1,053.89 $5,000.00 21.08 %$3,946.11 101-000-311-542-42-31-00 SWU Administration - DC Annual Billing Fee $0.00 $0.00 $7,500.00 0.00 %$7,500.00 Total Storm Water Administration $675.79 $3,228.82 $27,500.00 11.74 %$24,271.18 NPDES 101-000-313-542-42-10-00 NPDES Maintenance Salaries $10,440.23 $50,764.86 $75,000.00 67.69 %$24,235.14 101-000-313-542-42-10-10 NPDES Sweeping Salaries $1,887.84 $11,746.22 $16,000.00 73.41 %$4,253.78 101-000-313-542-42-20-00 NPDES Maintenance Benefits $4,940.88 $32,358.01 $45,000.00 71.91 %$12,641.99 101-000-313-542-42-20-10 NPDES Sweeping Benefits $984.30 $7,909.50 $8,000.00 98.87 %$90.50 101-000-313-542-42-30-00 NPDES Supplies $1,443.68 $11,314.02 $63,149.00 17.92 %$51,834.98 101-000-313-542-42-31-10 NPDES GIS System License $0.00 $0.00 $1,100.00 0.00 %$1,100.00 101-000-313-542-42-35-00 NPDES Small Tools & Equipment $0.00 $34.61 $500.00 6.92 %$465.39 101-000-313-542-42-40-00 NPDES Training $0.00 $4,220.53 $9,400.00 44.90 %$5,179.47 101-000-313-542-42-40-01 NPDES DOE Annual Permit $0.00 $2,413.23 $5,000.00 48.26 %$2,586.77 101-000-313-542-42-40-02 NPDES Equipment Rental $0.00 $15,261.21 $5,000.00 305.22 %($10,261.21) 101-000-313-542-42-40-03 NPDES Intergovernmental Services $0.00 $0.00 $30,000.00 0.00 %$30,000.00 101-000-313-542-42-41-00 NPDES Effectiveness Studies $0.00 $0.00 $8,500.00 0.00 %$8,500.00 101-000-313-542-42-45-00 NPDES Travel $6.00 $62.00 $1,500.00 4.13 %$1,438.00 101-000-313-542-42-47-00 NPDES Utilities $94.21 $2,033.49 $1,500.00 135.57 %($533.49) Page 19 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-313-542-42-48-00 NPDES Equipment Repair & Maintenance $901.70 $2,735.13 $2,500.00 109.41 %($235.13) 101-000-313-542-42-49-00 NPDES Miscellaneous Expense $0.00 $331.45 $1,000.00 33.15 %$668.55 Total NPDES $20,698.84 $141,184.26 $273,149.00 51.69 %$131,964.74 Storm Water Utility Charge 101-000-315-542-41-47-00 Annual GEWSWU Utility Charge $0.00 $164,385.00 $165,000.00 99.63 %$615.00 Total Storm Water Utility Charge $0.00 $164,385.00 $165,000.00 99.63 %$615.00 101-000-420-542-30-10-00 Salaries -Roadway $978.30 $33,527.64 $60,000.00 55.88 %$26,472.36 101-000-420-542-30-20-00 Benefits $830.97 $17,922.00 $33,000.00 54.31 %$15,078.00 101-000-420-542-30-30-00 Supplies $4,848.99 $46,566.22 $50,000.00 93.13 %$3,433.78 101-000-420-542-30-48-00 Repairs & Maintenance $0.00 $257.64 $6,000.00 4.29 %$5,742.36 101-000-420-542-61-10-00 Salaries - Sidewalks $2,866.03 $7,312.42 $4,500.00 162.50 %($2,812.42) 101-000-420-542-61-20-00 Benefits $1,491.23 $4,543.85 $2,400.00 189.33 %($2,143.85) 101-000-420-542-61-30-00 Supplies $384.28 $671.34 $2,000.00 33.57 %$1,328.66 101-000-420-542-61-48-00 Repairs & Maintenance $11.91 $24.04 $3,000.00 0.80 %$2,975.96 101-000-420-542-62-10-00 Salaries - Special Purpose Paths $0.00 $139.24 $500.00 27.85 %$360.76 101-000-420-542-62-20-00 Benefits $0.00 $120.46 $250.00 48.18 %$129.54 101-000-420-542-62-30-00 Supplies $0.00 $1,067.76 $2,500.00 42.71 %$1,432.24 101-000-420-542-62-45-00 Annual Fee - Loop Trail Services $0.00 $13,000.00 $13,000.00 100.00 %$0.00 101-000-420-542-63-10-00 Salaries - Street Lighting $246.19 $1,916.19 $2,000.00 95.81 %$83.81 101-000-420-542-63-20-00 Benefits $212.06 $934.44 $1,200.00 77.87 %$265.56 101-000-420-542-63-30-00 Supplies $0.00 $103.96 $500.00 20.79 %$396.04 101-000-420-542-63-47-00 Utilities $2,814.87 $76,033.96 $60,000.00 126.72 %($16,033.96) 101-000-420-542-63-48-00 Repairs & Maintenance $0.00 $581.01 $5,000.00 11.62 %$4,418.99 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $49.23 $24,957.73 $40,000.00 62.39 %$15,042.27 101-000-420-542-64-20-00 Benefits $42.40 $14,430.13 $23,000.00 62.74 %$8,569.87 101-000-420-542-64-30-00 Supplies $1,759.88 $33,393.54 $48,000.00 69.57 %$14,606.46 101-000-420-542-64-47-00 Utilities $582.81 $4,791.58 $9,000.00 53.24 %$4,208.42 101-000-420-542-64-48-00 Repairs & Maintenance $0.00 $734.69 $14,000.00 5.25 %$13,265.31 101-000-420-542-65-10-00 Salaries - Parking Facilities $0.00 $128.38 $1,000.00 12.84 %$871.62 101-000-420-542-65-20-00 Benefits $0.00 $87.68 $500.00 17.54 %$412.32 101-000-420-542-65-30-00 Supplies $0.00 $0.00 $300.00 0.00 %$300.00 101-000-420-542-65-47-00 Utilities $0.00 $270.00 $500.00 54.00 %$230.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $0.00 $34,231.00 $50,000.00 68.46 %$15,769.00 101-000-420-542-66-20-00 Benefits $0.00 $14,383.63 $27,000.00 53.27 %$12,616.37 101-000-420-542-66-30-00 Supplies $0.00 $73,339.30 $100,000.00 73.34 %$26,660.70 101-000-420-542-66-48-00 Repairs & Maintenance $0.00 $9,378.56 $5,000.00 187.57 %($4,378.56) 101-000-420-542-69-10-00 Salaries - Flags/Banners $1,974.37 $5,970.35 $10,000.00 59.70 %$4,029.65 101-000-420-542-69-20-00 Benefits $1,184.67 $2,979.80 $5,000.00 59.60 %$2,020.20 101-000-420-542-69-30-00 Supplies $0.00 $540.62 $2,000.00 27.03 %$1,459.38 101-000-420-542-70-10-00 Salaries - Roadside $16,545.04 $146,205.33 $180,000.00 81.23 %$33,794.67 101-000-420-542-70-20-00 Benefits $8,105.15 $76,846.03 $94,000.00 81.75 %$17,153.97 101-000-420-542-70-30-00 Supplies $362.56 $1,786.73 $5,000.00 35.73 %$3,213.27 101-000-420-542-70-41-00 Professional Services $0.00 $1,623.00 $3,000.00 54.10 %$1,377.00 101-000-420-542-70-47-00 Utilities $0.00 $790.60 $1,000.00 79.06 %$209.40 Page 20 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-70-48-00 Repairs & Maintenance $0.00 $16.00 $1,000.00 1.60 %$984.00 101-000-420-542-75-10-00 Salaries - City Parks $2,953.27 $34,996.13 $45,000.00 77.77 %$10,003.87 101-000-420-542-75-20-00 Benefits $2,194.34 $18,310.80 $23,000.00 79.61 %$4,689.20 101-000-420-542-75-30-00 Supplies $2,135.07 $5,574.70 $15,000.00 37.16 %$9,425.30 101-000-420-542-75-47-00 Utilities $1,354.60 $3,942.94 $4,000.00 98.57 %$57.06 101-000-420-542-75-48-00 Repairs & Maintenance $0.00 $771.18 $4,000.00 19.28 %$3,228.82 101-000-420-542-80-48-00 Maint Agmt - Japanese Gdn $4,000.00 $8,000.00 $18,000.00 44.44 %$10,000.00 101-000-420-542-90-10-00 Salaries - Maintenance Admin $0.00 $446.11 $73,158.00 0.61 %$72,711.89 101-000-420-542-90-20-00 Benefits $0.00 $687.05 $23,520.00 2.92 %$22,832.95 101-000-430-543-30-10-00 Salaries $1,347.51 $14,935.79 $0.00 ($14,935.79) 101-000-430-543-30-20-00 Benefits $604.22 $8,348.31 $0.00 ($8,348.31) 101-000-430-543-30-30-00 Supplies $1,150.30 $6,565.80 $6,000.00 109.43 %($565.80) 101-000-430-543-30-46-00 Insurance $829.35 $2,480.91 $48,600.00 5.10 %$46,119.09 101-000-430-543-30-49-00 Miscellaneous $0.00 $810.39 $3,000.00 27.01 %$2,189.61 101-000-430-543-50-10-00 Salaries - Facilities $0.00 $480.38 $3,000.00 16.01 %$2,519.62 101-000-430-543-50-20-00 Benefits $0.00 $126.30 $1,600.00 7.89 %$1,473.70 101-000-430-543-50-30-00 Supplies $0.00 $33.50 $2,000.00 1.68 %$1,966.50 101-000-430-543-50-47-00 Utilities $196.26 $3,568.72 $6,000.00 59.48 %$2,431.28 101-000-430-543-50-48-00 Repairs & Maintenance $0.00 $814.48 $2,500.00 32.58 %$1,685.52 101-000-430-544-90-10-00 Salaries - Training $246.19 $2,346.02 $6,500.00 36.09 %$4,153.98 101-000-430-544-90-20-00 Benefits $212.06 $1,279.01 $3,872.00 33.03 %$2,592.99 101-000-430-544-90-30-00 Supplies $0.00 $54.30 $500.00 10.86 %$445.70 101-000-430-544-90-35-00 Travel - Training $0.00 $1,694.00 $4,000.00 42.35 %$2,306.00 101-000-430-544-90-49-01 Training Miscellaneous $0.00 $85.00 $1,000.00 8.50 %$915.00 Total Street Fund $83,888.74 $1,076,756.75 $1,625,049.00 66.26 %$548,292.25 Community Development Grants Fund 102-000-000-558-70-10-00 CDBG Salaries $0.00 $0.00 $2,000.00 0.00 %$2,000.00 102-000-000-558-70-20-00 CDBG Benefits $0.00 $0.00 $642.00 0.00 %$642.00 102-000-000-558-70-40-00 CDBG Housing Program Costs $0.00 $59,926.90 $142,769.00 41.97 %$82,842.10 102-000-000-558-70-41-00 CDBG Professional Services $2,639.80 $2,639.80 $6,000.00 44.00 %$3,360.20 102-000-000-558-70-42-03 CDBG Postage $0.00 $0.00 $30.00 0.00 %$30.00 102-000-000-558-70-44-00 CDBG Advertising $0.00 $0.00 $1,700.00 0.00 %$1,700.00 102-000-000-558-70-49-00 CDBG Miscellaneous $0.00 $0.00 $700.00 0.00 %$700.00 Total Community Development Grants Fund $2,639.80 $62,566.70 $153,841.00 40.67 %$91,274.30 Transportation Benefit District Fund 105-000-000-595-90-60-00 StreetSaver Program $0.00 $7,240.00 $0.00 ($7,240.00) 105-000-000-597-91-00-00 Transfer Out - Fund 301 Project Expenditures $0.00 $277,141.05 $360,000.00 76.98 %$82,858.95 Total Transportation Benefit District Fund $0.00 $284,381.05 $360,000.00 78.99 %$75,618.95 Library Fund 112-000-000-572-50-41-00 Facilities -- Professional Services $0.00 $0.00 $3,200.00 0.00 %$3,200.00 112-000-000-572-50-47-00 Facilities--Utilities $192.65 $3,683.48 $3,700.00 99.55 %$16.52 112-000-000-572-50-49-00 Facilities--Supplies & Miscellaneous $0.00 $0.00 $40.00 0.00 %$40.00 Total Library Fund $192.65 $3,683.48 $6,940.00 53.08 %$3,256.52 Hotel/Motel Tax Fund Page 21 of 26 Account Number Title Period Fiscal Budget % of Total Balance 113-000-000-557-30-41-10 Contributions to Other Entities $15,000.00 $20,000.00 $70,000.00 28.57 %$50,000.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $9,273.00 $83,457.00 $111,276.00 75.00 %$27,819.00 Total Hotel/Motel Tax Fund $24,273.00 $103,457.00 $181,276.00 57.07 %$77,819.00 Events Board Fund 117-000-050-557-30-10-00 Eweb Salaries $5,730.69 $43,520.37 $72,000.00 60.44 %$28,479.63 117-000-050-557-30-20-00 Eweb Benefits $3,026.96 $24,850.81 $32,000.00 77.66 %$7,149.19 117-000-050-557-30-30-00 Contract Services $0.00 $9,750.10 $23,500.00 41.49 %$13,749.90 117-000-100-557-00-44-00 Eweb Advertisiing - Do Not Use $0.00 $573.60 $0.00 ($573.60) 117-000-100-557-30-25-00 Marketing - Regional Tourism $734.23 $742.85 $2,000.00 37.14 %$1,257.15 117-000-100-557-30-31-00 Events Department Office Supplies $326.08 $676.10 $0.00 ($676.10) 117-000-100-557-30-32-00 Eweb Fuel Consumed $0.00 $0.00 $200.00 0.00 %$200.00 117-000-100-557-30-35-00 Eweb Small Tools & Equipment $0.00 $0.00 $100.00 0.00 %$100.00 117-000-100-557-30-49-00 Eweb Miscellaneous $0.00 $44.59 $100.00 44.59 %$55.41 117-000-100-594-58-64-00 EWEB Capital Outlay $0.00 $0.00 $200.00 0.00 %$200.00 117-000-105-557-30-40-00 Eweb Insurance $25.27 $230.81 $7,600.00 3.04 %$7,369.19 117-000-115-557-30-31-05 Eweb Office Supplies $0.00 $113.82 $1,000.00 11.38 %$886.18 117-000-200-557-30-35-02 Easter Small Tools & Equipmen $0.00 $189.70 $200.00 94.85 %$10.30 117-000-200-557-30-44-02 Easter Advertising $0.00 $448.66 $350.00 128.19 %($98.66) 117-000-200-557-30-46-02 Easter Office Supplies $0.00 $0.00 $0.00 $0.00 117-000-200-557-30-49-02 Easter Miscellaneous $0.00 $578.75 $1,500.00 38.58 %$921.25 117-000-200-596-00-60-02 Easter Capital Outlay $0.00 $5.39 $0.00 ($5.39) 117-000-300-557-30-32-12 Classy Chassis Fuel Consumed $0.00 $0.00 $100.00 0.00 %$100.00 117-000-300-557-30-34-11 Classy Chassis Event Merch For Resale $0.00 $4,349.49 $4,800.00 90.61 %$450.51 117-000-300-557-30-35-12 Classy Chassis Small Tools & Equipment $0.00 $476.61 $1,000.00 47.66 %$523.39 117-000-300-557-30-41-12 CC Professional Services $0.00 $1,939.15 $5,500.00 35.26 %$3,560.85 117-000-300-557-30-42-14 Classy Chassis Postage $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-300-557-30-43-12 CC EMPD Facility Fee $0.00 $1,000.00 $1,100.00 90.91 %$100.00 117-000-300-557-30-44-12 Classy Chassis Advertising $0.00 $3,661.10 $4,500.00 81.36 %$838.90 117-000-300-557-30-49-12 Classy Chassis Miscellaneous $0.00 $1,954.56 $1,000.00 195.46 %($954.56) 117-000-400-557-30-34-11 W&W Event Merch For Resale $0.00 $0.00 $3,500.00 0.00 %$3,500.00 117-000-400-557-30-35-11 W & W Small Tools & Equipment $0.00 $0.00 $3,000.00 0.00 %$3,000.00 117-000-400-557-30-41-00 W & W Professional Services $324.60 $568.05 $2,750.00 20.66 %$2,181.95 117-000-400-557-30-42-13 Wings & Wheels Postage $470.51 $470.51 $1,000.00 47.05 %$529.49 117-000-400-557-30-43-12 W&W EMPD Facility Fee $0.00 $0.00 $1,100.00 0.00 %$1,100.00 117-000-400-557-30-44-11 Wings & Wheels Advertising $2,218.57 $2,527.74 $8,000.00 31.60 %$5,472.26 117-000-400-557-30-44-15 W&W Sponsored Car Show Prizes $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-400-557-30-49-11 Wings & Wheels Miscellaneous $0.00 $0.00 $1,100.00 0.00 %$1,100.00 117-000-400-557-30-49-12 Wings & Wheels Miscellaneous $0.00 $277.50 $0.00 ($277.50) 117-000-400-557-30-49-13 W&W Schedule of Events Brochur $0.00 $408.52 $3,500.00 11.67 %$3,091.48 117-000-450-557-30-41-00 PPU Professional Services $0.00 $596.73 $1,000.00 59.67 %$403.27 117-000-450-557-30-44-12 PkwyPile-up Car Show Advertising $39.11 $387.46 $1,000.00 38.75 %$612.54 117-000-450-557-30-49-01 PkwyPile-up Car Show Miscellaneous $0.00 $425.25 $1,200.00 35.44 %$774.75 117-000-500-557-30-35-01 Christmas Small Tools & Equip $0.00 $0.00 $400.00 0.00 %$400.00 117-000-500-557-30-40-05 Christmas Events & Decorations $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-500-557-30-41-01 Christmas Professional Ser $0.00 $227.22 $0.00 ($227.22) Page 22 of 26 Account Number Title Period Fiscal Budget % of Total Balance 117-000-500-557-30-44-01 Christmas Advertising $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-500-557-30-49-01 Christmas Miscellaneous $0.00 $41.53 $800.00 5.19 %$758.47 Total Events Board Fund $12,896.02 $101,036.97 $192,600.00 52.46 %$91,563.03 Bond Redemption Fund 202-000-000-591-95-71-05 Redemption of PWTFL Debt $0.00 $29,712.47 $30,000.00 99.04 %$287.53 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE Improvements $0.00 $112.78 $0.00 ($112.78) 202-000-000-592-95-89-05 Interest Exp PWTFL Debt $0.00 $594.25 $600.00 99.04 %$5.75 Total Bond Redemption Fund $0.00 $30,419.50 $30,600.00 99.41 %$180.50 Street Improvements Fund 301-000-000-595-10-40-13 Design - TIB Grant Road/Eastmont Ave Intersection $0.00 $0.00 $115,000.00 0.00 %$115,000.00 301-000-000-595-10-40-19 Design - TIB 3rd St SE/Highline Dr Roundabout $21,396.80 $62,819.31 $100,000.00 62.82 %$37,180.69 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $0.00 $0.00 $59,000.00 0.00 %$59,000.00 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $0.00 $0.00 $35,000.00 0.00 %$35,000.00 301-000-000-595-10-40-26 Design - PWTFL - 10th St $0.00 $181,883.93 $750,000.00 24.25 %$568,116.07 301-000-000-595-10-40-27 Design 2019 TBD Paving $0.00 $12,070.58 $30,000.00 40.24 %$17,929.42 301-000-000-595-20-60-00 10th Street ROW $0.00 $20,245.86 $0.00 ($20,245.86) 301-000-000-595-30-40-37 SDC - S. Kentucky & 5th St. NE $0.00 $430.00 $0.00 ($430.00) 301-000-000-595-30-40-38 SDC 2019 TBD Paving $0.00 $25,727.74 $15,000.00 171.52 %($10,727.74) 301-000-000-595-30-40-39 Construction 2019 TBD Paving $0.00 $242,091.85 $345,000.00 70.17 %$102,908.15 301-000-000-595-40-45-00 Materials - Relight WA Project $0.00 $58,150.00 $53,150.00 109.41 %($5,000.00) Total Street Improvements Fund $21,396.80 $603,419.27 $1,502,150.00 40.17 %$898,730.73 Storm Water Improvements Fund 308-000-000-595-40-60-01 10th Street Design $0.00 $0.00 $225,000.00 0.00 %$225,000.00 308-000-000-595-40-63-00 SWA Small Improvement Projects $0.00 $0.00 $100,000.00 0.00 %$100,000.00 308-000-000-595-40-63-39 19th St. NW Design SWU DOE $0.00 $40,499.13 $250,000.00 16.20 %$209,500.87 308-000-312-595-40-10-00 Salaries - SWA Improvement Projects $0.00 $135.18 $0.00 ($135.18) 308-000-312-595-40-20-00 Benefits - SWA Improvement Projects $0.00 $113.74 $0.00 ($113.74) Total Storm Water Improvements Fund $0.00 $40,748.05 $575,000.00 7.09 %$534,251.95 Capital Improvements Fund 314-000-000-594-48-60-00 Public Works Remodel $0.00 $0.00 $250,000.00 0.00 %$250,000.00 314-000-000-594-59-60-00 Gateway Property SDC $0.00 $36,298.81 $42,000.00 86.43 %$5,701.19 314-000-000-594-59-60-01 Gateway Property Construction $0.00 $565,299.57 $517,000.00 109.34 %($48,299.57) 314-000-000-594-73-60-00 City Gazebo Rebuild $0.00 $35,900.76 $0.00 ($35,900.76) Total Capital Improvements Fund $0.00 $637,499.14 $809,000.00 78.80 %$171,500.86 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicles R&M Labor $202.77 $5,304.85 $7,000.00 75.78 %$1,695.15 501-000-000-521-10-20-00 Police Vehicle R&M Benefits $78.93 $2,939.02 $2,300.00 127.78 %($639.02) 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $3,022.20 $21,169.21 $35,000.00 60.48 %$13,830.79 501-000-000-542-90-10-00 Street Vehicle R&M Labor $1,554.57 $13,585.07 $19,000.00 71.50 %$5,414.93 501-000-000-542-90-20-00 Street Vehicle R&M Benefits $1,059.05 $6,566.83 $10,000.00 65.67 %$3,433.17 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $942.36 $10,258.18 $31,000.00 33.09 %$20,741.82 501-000-000-542-90-48-25 Street Vehicle R&M Supplies $34.09 $3,008.18 $5,000.00 60.16 %$1,991.82 Page 23 of 26 Account Number Title Period Fiscal Budget % of Total Balance 501-000-000-542-90-48-30 Street Equipment R&M $17.30 $737.74 $1,600.00 46.11 %$862.26 501-000-000-594-21-60-00 Capital Outlay - Police Vehicles $0.00 $111,663.16 $111,700.00 99.97 %$36.84 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $47,117.81 $48,000.00 98.16 %$882.19 501-000-000-594-42-60-30 Capital - Street Equipment $0.00 $96,628.36 $196,000.00 49.30 %$99,371.64 Total Equipment Purchase, Repair & Replacement Fund $6,911.27 $318,978.41 $466,600.00 68.36 %$147,621.59 Grand Totals $672,526.28 $8,437,262.47 $13,330,308.69 63.29 %$4,893,046.22 Page 24 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $520,328.00 $5,174,316.15 $7,427,252.69 69.67 %$2,252,936.54 101-000-000-000-00-00-00 Street Fund $83,888.74 $1,076,756.75 $1,625,049.00 66.26 %$548,292.25 102-000-000-000-00-00-00 Community Development Grants Fund $2,639.80 $62,566.70 $153,841.00 40.67 %$91,274.30 105-000-000-000-00-00-00 Transportation Benefit District Fund $0.00 $284,381.05 $360,000.00 78.99 %$75,618.95 112-000-000-000-00-00-00 Library Fund $192.65 $3,683.48 $6,940.00 53.08 %$3,256.52 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $24,273.00 $103,457.00 $181,276.00 57.07 %$77,819.00 117-000-000-000-00-00-00 Events Board Fund $12,896.02 $101,036.97 $192,600.00 52.46 %$91,563.03 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $30,419.50 $30,600.00 99.41 %$180.50 301-000-000-000-00-00-00 Street Improvements Fund $21,396.80 $603,419.27 $1,502,150.00 40.17 %$898,730.73 308-000-000-000-00-00-00 Storm Water Improvements Fund $0.00 $40,748.05 $575,000.00 7.09 %$534,251.95 314-000-000-000-00-00-00 Capital Improvements Fund $0.00 $637,499.14 $809,000.00 78.80 %$171,500.86 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $6,911.27 $318,978.41 $466,600.00 68.36 %$147,621.59 Grand Totals $672,526.28 $8,437,262.47 $13,330,308.69 63.29 %$4,893,046.22 Page 25 of 26 Beginning Activity Cash In 001 $3,224,637.95 $4,821,588.34 101 $324,859.26 $1,210,210.06 102 $77,954.27 $0.00 105 $379,978.50 $198,277.20 110 $495,000.00 $0.00 112 $10,371.75 $3,500.00 113 $76,558.62 $125,483.27 114 $1,063.88 $448.49 116 $28,363.65 $14,010.57 117 $109,898.73 $67,059.62 202 $9,088.19 $30,000.00 301 $617,142.84 $905,733.96 308 $115,590.47 $45,756.07 314 $1,071,531.13 $471,298.99 501 $131,631.44 $450,000.00 $6,673,670.68 $8,343,366.57 Cash and Investment Activity Period: 2019 - September 2019Fund Activity Ending Street Fund $1,090,908.05 $444,161.27 Out Balance General Fund $5,175,659.05 $2,870,567.24 Community Development Grants Fund $62,566.70 $15,387.57 Transportation Benefit District Fund $284,441.05 $293,814.65 Financing Reserves Fund $0.00 $495,000.00 Library Fund $3,683.48 $10,188.27 Hotel/Motel Tax Fund $103,457.00 $98,584.89 Drug Fund $0.00 $1,512.37 Criminal Justice Fund $0.00 $42,374.22 Events Board Fund $102,486.97 $74,471.38 Bond Redemption Fund $30,419.50 $8,668.69 Street Improvements Fund $603,419.27 $919,457.53 Storm Water Improvements Fund $48,406.05 $112,940.49 Capital Improvements Fund $637,499.14 $905,330.98 $8,461,924.67 $6,555,112.58 Equipment Purchase, Repair & Replacement Fund $318,978.41 $262,653.03 Page 26 of 26