Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2019 - August 2019 Monthly Financial Report - Josh DeLay, Finance Director
City of East Wenatchee October 1, 2019 City Council Meeting August 2019 Financial Report Date: October 1, 2019 To: Councilmembers, Mayor Lacy & Department Heads From: Josh DeLay, Finance Director Subject: August 2019 Financial Report This report provides a summary of the City’s overall financial operations through August 31, 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 August 31, 2019 compared to revenue collections through August 31, 2018, along with the respective dollar and percentage variances for its operating funds. Table 1 August 31, 2019 August 31, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 4,234,205 4,173,370 60,834 1.46% Street Fund - 101 1,086,619 1,060,708 25,911 2.44% Events Board Fund - 117 54,570 81,127 (26,557) (32.74%) Equipment R&R Fund - 501 450,000 350,000 100,000 28.57% Total Revenues - Operating Funds 5,825,393 5,665,205 160,188 2.83% 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 October 1, 2019 City Council Meeting August 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 August 31, 2019 compared to revenue collections through August 31, 2018, along with the respective dollar and percentage variances for its non-operating funds. Page 2 of 26 City of East Wenatchee October 1, 2019 City Council Meeting August 2019 Financial Report Table 2 August 31, 2019 August 31, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - - - - Trans Benefit District Fund - 105 171,448 168,240 3,208 1.91% Debt Reserve Fund - 110 - 135,000 (135,000) (100.00%) Library Fund - 112 3,500 3,500 - - Hotel/Motel Tax Fund - 113 109,944 74,723 35,221 47.14% Drug Fund - 114 448 124 324 260.35% Criminal Justice Fund - 116 14,011 13,554 457 3.37% Bond Redemption Fund - 202 30,000 30,000 - - Street Improvements Fund - 301 905,709 255,516 650,193 254.46% Storm Water Improvements Fund - 308 1,796 127,610 (125,814) (98.59%) Capital Improvements Fund - 314 245,415 508,748 (263,333) (51.76%) Total Revenues - Non-Operating Funds 1,482,270 1,317,015 165,256 12.55% 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 October 1, 2019 City Council Meeting August 2019 Financial Report Revenue Highlights: General Fund revenues are up $60,834, or 1.46%, from last year due to: •$311,007 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,523 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: •$234,716 less sales tax allocation due to other funds needing their allotted sales tax for large purchases and cash flow purposes •$49,024 less phone/cellular utility tax collections •$25,041 less in court fines collected Street Fund revenues are up $25,911, or 2.44%, from last year due to a larger sales tax allocation this year versus last year at the same point in time. This variance will decrease as the year progresses because this fund has received its fully approved, budgeted amount of sales tax allocation for the year. 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 $35,221, or 47.14%, 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,557, or 32.74%. Street Improvements Fund revenues are up $650,193, or 254.46%, 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 $263,333, or 51.76%, 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. The City will be receiving over $188,000 from the Douglas County Regional Share by the end of the fiscal year, which will offset much of this variance. Table 3 below shows the City’s expenditures through August 31, 2019 compared to expenditures through August 31, 2018, along with respective dollar and percentage variances for its operating funds. Page 4 of 26 City of East Wenatchee October 1, 2019 City Council Meeting August 2019 Financial Report Table 3 August 31, 2019 August 31, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 4,653,988 4,297,145 356,843 8.30% Street Fund - 101 992,868 917,431 75,437 8.22% Events Board Fund - 117 88,141 93,787 (5,646) (6.02%) Equipment R&R Fund - 501 312,067 197,809 114,258 57.76% Total Expenditures - Operating Funds 6,047,064 5,506,172 540,892 9.82% 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 August 31, 2019 compared to expenditures through August 31, 2018, along with respective dollar and percentage variances for its non-operating funds. Page 5 of 26 City of East Wenatchee October 1, 2019 City Council Meeting August 2019 Financial Report Table 4 August 31, 2019 August 31, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 59,927 1,471 58,456 3973.45% Trans Benefit District Fund - 105 284,381 - 284,381 - Debt Reserve Fund - 110 - - - - Library Fund - 112 3,491 2,682 809 30.16% Hotel/Motel Tax Fund - 113 79,184 40,319 38,865 96.39% Drug Fund - 114 - - - - Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 30,420 30,604 (184) (0.60%) Street Improvements Fund - 301 582,022 582,800 (777) (0.13%) 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,717,672 839,646 878,026 104.57% 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 October 1, 2019 City Council Meeting August 2019 Financial Report Expenditure Highlights: General Fund expenditures are up $356,843, or 8.30%, from last year primarily due to the purchase of 1002 N Colorado Ave., and salary and benefit increases. Street Fund expenditures are up $75,437, or 8.22%, 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 $5,646, or 6.02%, 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,258, or 57.76%, 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. Hotel/Motel Tax Fund expenditures are up $38,865, or 96.39%, 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. 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 will be 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 August 31, 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 $0.00 $561,855.88 $1,000,000.00 56.19 %$438,144.12 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $340,293.58 $1,796,757.32 $3,270,000.00 54.95 %$1,473,242.68 001-000-000-313-71-00-00 1/10 Sales Tax-Criminal Just $27,571.27 $232,772.37 $277,000.00 84.03 %$44,227.63 001-000-000-316-40-00-00 Electric Utility Tax $24,434.89 $263,835.50 $352,000.00 74.95 %$88,164.50 001-000-000-316-45-00-00 Natural Gas Utility Tax $1,865.55 $28,940.49 $34,000.00 85.12 %$5,059.51 001-000-000-316-49-00-00 Phone/cellular Utility Tax $36,312.69 $237,043.95 $355,000.00 66.77 %$117,956.05 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 $430,477.98 $3,408,431.05 $5,591,500.00 60.96 %$2,183,068.95 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 $87.00 $668.00 $800.00 83.50 %$132.00 001-000-000-321-91-00-50 Franchise Fees - Cable $23,614.14 $73,580.69 $97,000.00 75.86 %$23,419.31 001-000-000-321-99-00-00 Business Licenses & Permits $10,044.58 $70,820.58 $81,000.00 87.43 %$10,179.42 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,086.20 $26,201.93 $63,000.00 41.59 %$36,798.07 001-000-000-322-90-01-00 Gun Permits $432.00 $4,997.00 $6,200.00 80.60 %$1,203.00 001-000-000-322-90-02-00 Sign Permits $0.00 $72.50 $100.00 72.50 %$27.50 Total Licenses and Permits $36,263.92 $177,500.70 $248,600.00 71.40 %$71,099.30 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 $476.12 $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 $0.00 $2,017.22 $2,500.00 80.69 %$482.78 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 $44,490.03 $44,490.03 $41,000.00 108.51 %($3,490.03) 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $0.00 $14,283.91 $30,000.00 47.61 %$15,716.09 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 $0.00 $55,724.22 $111,500.00 49.98 %$55,775.78 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 - August 2019 Page 8 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Intergovernmental Revenues $44,966.15 $186,842.48 $323,293.55 57.79 %$136,451.07 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 $12.95 $41.15 $200.00 20.58 %$158.85 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 $6,185.51 $41,887.51 $80,000.00 52.36 %$38,112.49 001-000-000-342-36-00-00 Housing of Prisoners $1,496.84 $13,185.11 $27,000.00 48.83 %$13,814.89 001-000-000-342-40-00-01 Fire Marshall Inspection Ser $0.00 $2,724.00 $5,500.00 49.53 %$2,776.00 001-000-000-345-83-00-00 Plan Checking Fees $1,185.21 $15,833.06 $32,000.00 49.48 %$16,166.94 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 $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-000-345-89-00-00 Planning & Development Fees $1,710.00 $10,320.70 $4,500.00 229.35 %($5,820.70) Total Charges for Goods and Services $10,590.51 $91,284.73 $160,200.00 56.98 %$68,915.27 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $15,531.48 $118,986.17 $211,000.00 56.39 %$92,013.83 001-000-000-357-33-00-00 Public Defender Costs $2,183.60 $15,698.51 $29,000.00 54.13 %$13,301.49 001-000-000-357-35-00-00 Restitution $50.00 $260.25 $0.00 ($260.25) Total Fines and Penalties $17,765.08 $134,944.93 $240,000.00 56.23 %$105,055.07 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $10,818.61 $91,142.84 $85,000.00 107.23 %($6,142.84) 001-000-000-361-40-00-00 Sales Tax Interest $730.19 $5,013.87 $2,800.00 179.07 %($2,213.87) 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,195.00 $6,044.27 $14,400.00 41.97 %$8,355.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,351.08 $5,405.39 $6,000.00 90.09 %$594.61 Total Miscellaneous Revenues $17,094.88 $107,606.37 $108,300.00 99.36 %$693.63 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 $278.79 $2,154.17 $3,900.00 55.24 %$1,745.83 001-000-000-389-30-00-10 State Surcharge $95.50 $637.50 $800.00 79.69 %$162.50 001-000-000-389-30-00-15 State Share Weapons Permit Fee $903.25 $5,340.00 $10,000.00 53.40 %$4,660.00 001-000-000-389-30-00-20 Court Remittance--State $15,123.91 $116,054.47 $218,000.00 53.24 %$101,945.53 Total Other Increases in Fund Resources $16,401.45 $126,686.14 $235,100.00 53.89 %$108,413.86 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 $382.80 $382.80 $0.00 ($382.80) Total Other Financing Sources $382.80 $908.17 $0.00 ($908.17) Total General Fund $573,942.77 $4,234,204.57 $6,906,993.55 61.30 %$2,672,788.98 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 $510.00 $2,109.70 $3,700.00 57.02 %$1,590.30 101-000-000-336-00-71-00 Multimodal Transpo City $0.00 $9,463.37 $18,000.00 52.57 %$8,536.63 101-000-000-336-00-87-00 Street Fuel Excise Tax $24,217.20 $175,173.65 $299,000.00 58.59 %$123,826.35 101-000-000-336-00-87-05 MVA Transport Cities $0.00 $8,280.53 $9,700.00 85.37 %$1,419.47 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 $322.10 $7,302.77 $27,500.00 26.56 %$20,197.23 101-000-000-343-13-00-90 SWA NPDES Reimbursement $25,803.57 $55,236.45 $240,000.00 23.02 %$184,763.55 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 $7,190.28 $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) Total Street Fund $58,043.15 $1,086,618.74 $1,481,149.00 73.36 %$394,530.26 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 $22,433.40 $171,447.60 $241,000.00 71.14 %$69,552.40 Total Transportation Benefit District Fund $22,433.40 $171,447.60 $241,000.00 71.14 %$69,552.40 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 $12,329.38 $54,972.11 $56,850.00 96.70 %$1,877.89 113-000-000-313-31-04-00 H/M Tax Allocated $12,329.38 $54,972.10 $56,850.00 96.70 %$1,877.90 Total Hotel/Motel Tax Fund $24,658.76 $109,944.21 $113,700.00 96.70 %$3,755.79 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $1.07 $20.66 $150.00 13.77 %$129.34 114-000-000-369-30-00-00 Confiscated/forfeited Property $0.00 $427.26 $0.00 ($427.26) Total Drug Fund $1.07 $447.92 $150.00 298.61 %($297.92) 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 $0.00 $32,020.24 $60,000.00 53.37 %$27,979.76 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) 117-000-300-347-90-00-12 Classy Chassis Sponsorships $0.00 $6,500.00 $9,000.00 72.22 %$2,500.00 Page 10 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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,090.00 $1,115.00 $5,500.00 20.27 %$4,385.00 117-000-400-347-40-11-07 Wings & Wheels Vendor Fees $50.00 $50.00 $300.00 16.67 %$250.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 $0.00 $1,300.00 $6,500.00 20.00 %$5,200.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 $1,140.00 $54,570.09 $103,270.00 52.84 %$48,699.91 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 $58,150.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 $35,149.35 $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-397-41-10-05 Transfer In-TBD Fund 105 Proj Funding $277,141.05 $277,141.05 $360,000.00 76.98 %$82,858.95 Total Street Improvements Fund $370,440.40 $905,708.76 $1,816,678.00 49.86 %$910,969.24 Storm Water Improvements Fund 308-000-000-334-03-10-00 State Ecology Grant $0.00 $0.00 $37,500.00 0.00 %$37,500.00 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 $1,795.94 $1,795.94 $250,000.00 0.72 %$248,204.06 Total Storm Water Improvements Fund $1,795.94 $1,795.94 $612,500.00 0.29 %$610,704.06 Capital Improvements Fund 314-000-000-311-10-00-00 Real and Personal Property Taxes $9,045.56 $14,976.82 $100,000.00 14.98 %$85,023.18 314-000-000-318-34-00-00 Real Estate Excise Tax $68,478.92 $230,438.35 $350,000.00 65.84 %$119,561.65 314-000-000-333-10-00-00 Douglas County Regional Share $0.00 $0.00 $188,000.00 0.00 %$188,000.00 Total Capital Improvements Fund $77,524.48 $245,415.17 $638,000.00 38.47 %$392,584.83 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 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 Page 11 of 26 Account Number Title Period Fiscal Budget % of Total Balance Grand Totals $1,129,979.97 $7,307,663.57 $12,735,881.55 57.38 %$5,428,217.98 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 $573,942.77 $4,234,204.57 $6,906,993.55 61.30 %$2,672,788.98 101-000-000-000-00-00-00 Street Fund $58,043.15 $1,086,618.74 $1,481,149.00 73.36 %$394,530.26 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 $22,433.40 $171,447.60 $241,000.00 71.14 %$69,552.40 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 $24,658.76 $109,944.21 $113,700.00 96.70 %$3,755.79 114-000-000-000-00-00-00 Drug Fund $1.07 $447.92 $150.00 298.61 %($297.92) 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 $1,140.00 $54,570.09 $103,270.00 52.84 %$48,699.91 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 $370,440.40 $905,708.76 $1,816,678.00 49.86 %$910,969.24 308-000-000-000-00-00-00 Storm Water Improvements Fund $1,795.94 $1,795.94 $612,500.00 0.29 %$610,704.06 314-000-000-000-00-00-00 Capital Improvements Fund $77,524.48 $245,415.17 $638,000.00 38.47 %$392,584.83 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,129,979.97 $7,307,663.57 $12,735,881.55 57.38 %$5,428,217.98 Page 13 of 26 Account Number Title Period Fiscal Budget % of Total Balance General Fund General Government 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 $319.17 $1,570.27 $2,500.00 62.81 %$929.73 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 $19,406.16 $27,500.00 70.57 %$8,093.84 001-000-001-528-70-40-00 River Com $28,242.67 $225,941.36 $340,000.00 66.45 %$114,058.64 001-000-001-539-30-40-00 Animal Control $6,126.24 $42,883.68 $73,515.00 58.33 %$30,631.32 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 $36,770.08 $568,996.63 $734,176.69 77.50 %$165,180.06 Legislative 001-000-110-511-60-10-00 Salaries $15,775.28 $122,392.62 $165,000.00 74.18 %$42,607.38 001-000-110-511-60-20-00 Benefits $5,966.75 $40,580.94 $95,000.00 42.72 %$54,419.06 001-000-110-511-60-21-50 Public Defender $8,100.00 $65,300.00 $96,000.00 68.02 %$30,700.00 001-000-110-511-60-30-00 Public Defender Conflicts $307.50 $2,955.00 $6,000.00 49.25 %$3,045.00 001-000-110-511-60-31-00 Office Supplies $0.00 $56.37 $400.00 14.09 %$343.63 001-000-110-511-60-31-05 Newsletter Printing & Mailing $3,997.83 $9,136.05 $11,000.00 83.06 %$1,863.95 001-000-110-511-60-31-10 Public Records Expenses $21.02 $46.25 $90.00 51.39 %$43.75 001-000-110-511-60-40-00 Training $0.00 $2,093.47 $4,000.00 52.34 %$1,906.53 001-000-110-511-60-41-00 Professional Services $5,366.01 $23,496.01 $28,500.00 82.44 %$5,003.99 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 $1,047.62 $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 $0.00 $220.56 $6,500.00 3.39 %$6,279.44 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 $240.00 $1,375.60 $11,000.00 12.51 %$9,624.40 001-000-110-511-60-47-00 Background Check Costs $0.00 $108.00 $250.00 43.20 %$142.00 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 - August 2019 Page 14 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-110-511-60-49-00 Miscellaneous $741.45 $4,688.50 $5,000.00 93.77 %$311.50 Total Legislative $41,563.46 $308,723.83 $468,343.00 65.92 %$159,619.17 Municipal Court 001-000-120-512-50-10-00 Salaries $15,071.50 $122,058.86 $182,000.00 67.07 %$59,941.14 001-000-120-512-50-12-00 Salaries - Probation Svcs $4,404.82 $35,711.82 $53,000.00 67.38 %$17,288.18 001-000-120-512-50-20-00 Benefits $5,344.03 $43,534.96 $66,000.00 65.96 %$22,465.04 001-000-120-512-50-22-00 Benefits - Probation Svcs $3,029.86 $23,896.00 $36,000.00 66.38 %$12,104.00 001-000-120-512-50-31-00 Office Supplies $543.90 $1,401.40 $3,300.00 42.47 %$1,898.60 001-000-120-512-50-40-00 Training $370.00 $1,535.00 $1,500.00 102.33 %($35.00) 001-000-120-512-50-43-00 Travel $0.00 $5,147.11 $4,000.00 128.68 %($1,147.11) 001-000-120-512-50-46-00 Insurance $0.00 $277.56 $12,600.00 2.20 %$12,322.44 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 $0.00 $2,025.00 $4,000.00 50.63 %$1,975.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 $17.32 $1,282.14 $2,000.00 64.11 %$717.86 001-000-120-512-50-49-09 Security $0.00 $2,687.50 $6,000.00 44.79 %$3,312.50 001-000-120-594-12-60-00 Capital Outlay $319.07 $21,293.61 $24,495.00 86.93 %$3,201.39 Total Municipal Court $29,100.50 $261,332.78 $401,595.00 65.07 %$140,262.22 City Clerk 001-000-140-514-20-10-00 Salaries $6,143.84 $52,647.68 $78,884.00 66.74 %$26,236.32 001-000-140-514-20-20-00 Benefits $3,181.42 $26,038.28 $39,000.00 66.76 %$12,961.72 001-000-140-514-20-31-00 Office Supplies $0.00 $290.65 $3,000.00 9.69 %$2,709.35 001-000-140-514-20-31-01 Central Stores $308.19 $3,402.16 $4,000.00 85.05 %$597.84 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 $0.00 $329.36 $1,200.00 27.45 %$870.64 001-000-140-514-20-43-00 Travel $170.52 $2,004.93 $2,500.00 80.20 %$495.07 001-000-140-514-20-44-00 Advertising $0.00 $702.27 $2,000.00 35.11 %$1,297.73 001-000-140-514-20-46-00 Insurance $0.00 $89.51 $8,000.00 1.12 %$7,910.49 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 $217.50 $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 $10,021.47 $87,436.90 $144,934.00 60.33 %$57,497.10 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $0.00 $3,373.43 $14,000.00 24.10 %$10,626.57 001-000-141-514-20-42-01 Telephone Line Charges $1,507.63 $9,361.24 $13,000.00 72.01 %$3,638.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 $798.66 $5,460.18 $1,500.00 364.01 %($3,960.18) 001-000-141-514-20-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 Total Internal Services $2,306.29 $20,694.85 $37,000.00 55.93 %$16,305.15 Finance 001-000-142-514-20-10-00 Salaries $14,245.37 $114,742.58 $174,000.00 65.94 %$59,257.42 001-000-142-514-20-20-00 Benefits $7,563.12 $53,659.67 $80,000.00 67.07 %$26,340.33 001-000-142-514-20-31-00 Office Supplies $0.00 $676.44 $1,700.00 39.79 %$1,023.56 Page 15 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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 $142.00 $403.60 $8,000.00 5.05 %$7,596.40 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 $1,291.29 $1,291.29 $22,000.00 5.87 %$20,708.71 001-000-142-514-25-30-00 Bank Charges & Fees $431.28 $2,984.74 $4,000.00 74.62 %$1,015.26 001-000-142-514-40-20-00 Training $0.00 $250.00 $2,000.00 12.50 %$1,750.00 Total Finance $23,673.06 $174,144.89 $292,700.00 59.50 %$118,555.11 Information Technology 001-000-145-514-00-10-00 IT Salaries $7,586.00 $53,102.00 $92,000.00 57.72 %$38,898.00 001-000-145-514-00-20-00 IT Benefits $3,652.06 $25,691.12 $36,000.00 71.36 %$10,308.88 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 $0.00 $0.00 $9,000.00 0.00 %$9,000.00 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 $1,225.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 $200.95 $325.25 $1,000.00 32.53 %$674.75 001-000-145-514-20-49-00 Miscellaneous $0.00 $320.80 $300.00 106.93 %($20.80) 001-000-145-594-14-60-20 Capital - Cmptr Software Admin $1,662.50 $9,400.69 $28,000.00 33.57 %$18,599.31 001-000-145-594-14-60-25 Capital - Cmptr Hdwe Admin $881.93 $5,839.59 $25,000.00 23.36 %$19,160.41 001-000-145-594-14-60-27 Capital - Cmptr Equip Police $664.94 $7,221.08 $25,000.00 28.88 %$17,778.92 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 $15,873.38 $172,367.53 $284,045.00 60.68 %$111,677.47 Legal 001-000-151-515-31-10-00 Salaries $11,634.60 $94,596.77 $139,000.00 68.06 %$44,403.23 001-000-151-515-31-20-00 Benefits $6,545.68 $44,728.73 $65,000.00 68.81 %$20,271.27 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 $182.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 $0.00 $83.29 $11,000.00 0.76 %$10,916.71 001-000-151-515-31-49-00 Miscellaneous $0.00 $2,692.69 $5,000.00 53.85 %$2,307.31 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $500.00 0.00 %$500.00 Page 16 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-151-596-00-60-00 Capital Outlay $0.00 $0.00 $500.00 0.00 %$500.00 Total Legal $18,362.28 $142,358.28 $227,300.00 62.63 %$84,941.72 Civil Service 001-000-160-521-10-10-00 Salaries $260.00 $2,080.00 $3,120.00 66.67 %$1,040.00 001-000-160-521-10-46-00 Insurance $0.00 $49.84 $6,500.00 0.77 %$6,450.16 001-000-160-521-10-49-00 Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Civil Service $260.00 $2,129.84 $9,720.00 21.91 %$7,590.16 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 $141.50 $1,158.81 $2,000.00 57.94 %$841.19 001-000-180-518-30-35-00 Small Tools & Equipment $12.16 $256.59 $10,000.00 2.57 %$9,743.41 001-000-180-518-30-41-00 Professional Services $555.91 $17,425.60 $20,000.00 87.13 %$2,574.40 001-000-180-518-30-41-01 Contracted Custodial Services $2,206.13 $16,351.59 $24,000.00 68.13 %$7,648.41 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 $0.00 $243.59 $41,000.00 0.59 %$40,756.41 001-000-180-518-30-47-00 Utilities $1,635.81 $16,656.16 $25,000.00 66.62 %$8,343.84 001-000-180-518-30-48-00 Repairs & Maintenance $0.00 $6,058.47 $12,000.00 50.49 %$5,941.53 001-000-180-518-30-49-00 Miscellaneous $22.46 $224.87 $2,000.00 11.24 %$1,775.13 001-000-180-518-30-49-01 Landscaping $183.94 $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)$559.43 $4,774.24 $6,000.00 79.57 %$1,225.76 001-000-180-594-18-60-00 Capital Outlay $0.00 $8,488.93 $10,000.00 84.89 %$1,511.07 Total Central Services $5,317.34 $72,336.84 $184,000.00 39.31 %$111,663.16 Law Enforcement 001-000-210-521-10-10-00 Salaries $162,010.06 $1,388,123.25 $2,120,000.00 65.48 %$731,876.75 001-000-210-521-10-10-02 Overtime Salaries $22,493.68 $123,926.28 $150,000.00 82.62 %$26,073.72 001-000-210-521-10-10-03 Overtime Salaries-Traf Control $500.41 $3,697.48 $8,000.00 46.22 %$4,302.52 001-000-210-521-10-20-00 Benefits $64,551.37 $517,105.28 $810,000.00 63.84 %$292,894.72 001-000-210-521-10-20-01 Clothing Allowance $361.53 $4,742.92 $15,600.00 30.40 %$10,857.08 001-000-210-521-10-31-00 Office Supplies $1,281.63 $5,562.68 $8,000.00 69.53 %$2,437.32 001-000-210-521-10-31-05 Office Machine Costs $894.04 $1,776.79 $5,000.00 35.54 %$3,223.21 001-000-210-521-10-32-00 Fuel Consumed $4,207.47 $30,282.37 $45,000.00 67.29 %$14,717.63 001-000-210-521-10-35-00 Small Tools & Equipment $415.81 $10,189.22 $13,000.00 78.38 %$2,810.78 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 $559.02 $9,670.31 $14,000.00 69.07 %$4,329.69 001-000-210-521-10-42-01 Telephone $3,353.05 $15,366.25 $28,000.00 54.88 %$12,633.75 001-000-210-521-10-42-03 Postage $174.55 $714.18 $1,200.00 59.52 %$485.82 001-000-210-521-10-43-00 Travel $550.00 $13,307.12 $22,000.00 60.49 %$8,692.88 001-000-210-521-10-46-00 Insurance $0.00 $4,752.55 $75,600.00 6.29 %$70,847.45 001-000-210-521-10-48-00 Repairs & Maintenance $321.71 $2,537.83 $8,000.00 31.72 %$5,462.17 001-000-210-521-10-49-00 Miscellaneous $369.07 $2,837.48 $5,500.00 51.59 %$2,662.52 001-000-210-521-10-49-01 Reserves $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-521-10-49-02 Dry Cleaning Services $0.00 $404.54 $1,500.00 26.97 %$1,095.46 Page 17 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-30-40-00 Crime Prevention $801.22 $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 $95.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 $5,150.50 $6,302.82 $9,600.00 65.65 %$3,297.18 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 $268,090.12 $2,188,459.55 $3,448,450.00 63.46 %$1,259,990.45 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $55,492.00 $167,242.14 $302,000.00 55.38 %$134,757.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 $1,080.00 $2,760.00 $8,000.00 34.50 %$5,240.00 Total Jail Services $56,572.00 $172,841.76 $321,000.00 53.84 %$148,158.24 Public Works 001-000-315-542-10-10-00 Salaries $6,867.00 $55,545.77 $83,000.00 66.92 %$27,454.23 001-000-315-542-10-20-00 Benefits $3,338.51 $26,985.90 $42,000.00 64.25 %$15,014.10 001-000-315-542-10-31-00 Office Supplies $0.00 $88.87 $750.00 11.85 %$661.13 001-000-315-542-10-35-00 Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 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 $0.00 $76.02 $10,500.00 0.72 %$10,423.98 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 $3,688.46 $5,945.25 $10,000.00 59.45 %$4,054.75 Total Public Works $13,893.97 $89,497.36 $152,050.00 58.86 %$62,552.64 Planning 001-000-580-558-60-10-00 Salaries $14,121.93 $114,622.37 $172,000.00 66.64 %$57,377.63 001-000-580-558-60-20-00 Benefits $4,998.65 $40,742.11 $62,000.00 65.71 %$21,257.89 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 $0.00 $100.69 $200.00 50.35 %$99.31 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 $755.50 $1,882.93 $1,500.00 125.53 %($382.93) 001-000-580-558-60-44-00 Advertising $728.28 $3,014.73 $2,400.00 125.61 %($614.73) 001-000-580-558-60-46-00 Insurance $0.00 $106.96 $10,400.00 1.03 %$10,293.04 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 $20,604.36 $165,370.21 $266,950.00 61.95 %$101,579.79 Code Compliance Page 18 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-590-558-50-10-00 Salaries $8,453.81 $68,630.20 $104,000.00 65.99 %$35,369.80 001-000-590-558-50-20-00 Benefits $4,268.62 $34,486.55 $53,000.00 65.07 %$18,513.45 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 $78.29 $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 $0.00 $5,268.66 $20,664.00 25.50 %$15,395.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 $0.00 $61.48 $7,900.00 0.78 %$7,838.52 001-000-590-558-50-49-00 Miscellaneous $0.00 $95.00 $300.00 31.67 %$205.00 Total Code Compliance $12,800.72 $114,138.42 $217,289.00 52.53 %$103,150.58 Other Expenditures 001-001-000-589-30-00-03 Fireworks-Cleaning Deposit Ref $2,500.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 $504.00 $400.00 126.00 %($104.00) 001-001-000-589-30-00-15 State Share of Permits & Licenses $760.00 $6,133.25 $12,000.00 51.11 %$5,866.75 001-001-000-589-30-00-20 Court Remittances $16,314.87 $100,871.15 $220,000.00 45.85 %$119,128.85 Total Other Expenditures $19,650.87 $113,158.48 $237,700.00 47.61 %$124,541.52 Total General Fund $574,859.90 $4,653,988.15 $7,427,252.69 62.66 %$2,773,264.54 Street Fund Storm Water Administration 101-000-311-542-42-10-00 SWU Administration - Salaries $612.76 $1,702.45 $15,000.00 11.35 %$13,297.55 101-000-311-542-42-20-00 SWU Administration - Benefits $286.30 $850.58 $5,000.00 17.01 %$4,149.42 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 $899.06 $2,553.03 $27,500.00 9.28 %$24,946.97 NPDES 101-000-313-542-42-10-00 NPDES Maintenance Salaries $6,846.70 $40,324.63 $75,000.00 53.77 %$34,675.37 101-000-313-542-42-10-10 NPDES Sweeping Salaries $1,000.90 $9,858.38 $16,000.00 61.61 %$6,141.62 101-000-313-542-42-20-00 NPDES Maintenance Benefits $2,710.76 $27,417.13 $45,000.00 60.93 %$17,582.87 101-000-313-542-42-20-10 NPDES Sweeping Benefits $814.56 $6,925.20 $8,000.00 86.57 %$1,074.80 101-000-313-542-42-30-00 NPDES Supplies $2,486.06 $9,870.34 $63,149.00 15.63 %$53,278.66 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 $34.61 $34.61 $500.00 6.92 %$465.39 101-000-313-542-42-40-00 NPDES Training $2,940.39 $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 $13,856.04 $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 $42.00 $56.00 $1,500.00 3.73 %$1,444.00 101-000-313-542-42-47-00 NPDES Utilities $441.99 $1,939.28 $1,500.00 129.29 %($439.28) Page 19 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-313-542-42-48-00 NPDES Equipment Repair & Maintenance $33.76 $1,833.43 $2,500.00 73.34 %$666.57 101-000-313-542-42-49-00 NPDES Miscellaneous Expense $19.33 $331.45 $1,000.00 33.15 %$668.55 Total NPDES $31,227.10 $120,485.42 $273,149.00 44.11 %$152,663.58 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 $6,894.49 $32,549.34 $60,000.00 54.25 %$27,450.66 101-000-420-542-30-20-00 Benefits $2,741.94 $17,091.03 $33,000.00 51.79 %$15,908.97 101-000-420-542-30-30-00 Supplies $0.00 $41,717.23 $50,000.00 83.43 %$8,282.77 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 $1,340.42 $4,446.39 $4,500.00 98.81 %$53.61 101-000-420-542-61-20-00 Benefits $1,329.23 $3,052.62 $2,400.00 127.19 %($652.62) 101-000-420-542-61-30-00 Supplies $0.00 $287.06 $2,000.00 14.35 %$1,712.94 101-000-420-542-61-48-00 Repairs & Maintenance $1.79 $12.13 $3,000.00 0.40 %$2,987.87 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 $0.00 $1,670.00 $2,000.00 83.50 %$330.00 101-000-420-542-63-20-00 Benefits $0.00 $722.38 $1,200.00 60.20 %$477.62 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 $4,460.63 $73,219.09 $60,000.00 122.03 %($13,219.09) 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 $1,766.17 $24,908.50 $40,000.00 62.27 %$15,091.50 101-000-420-542-64-20-00 Benefits $1,219.06 $14,387.73 $23,000.00 62.56 %$8,612.27 101-000-420-542-64-30-00 Supplies $0.00 $31,633.66 $48,000.00 65.90 %$16,366.34 101-000-420-542-64-47-00 Utilities $580.81 $4,208.77 $9,000.00 46.76 %$4,791.23 101-000-420-542-64-48-00 Repairs & Maintenance $1,575.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 $22,075.75 $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 $79.91 $3,995.98 $10,000.00 39.96 %$6,004.02 101-000-420-542-69-20-00 Benefits $47.87 $1,795.13 $5,000.00 35.90 %$3,204.87 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 $17,342.08 $129,660.29 $180,000.00 72.03 %$50,339.71 101-000-420-542-70-20-00 Benefits $10,174.37 $68,740.88 $94,000.00 73.13 %$25,259.12 101-000-420-542-70-30-00 Supplies $0.00 $1,424.17 $5,000.00 28.48 %$3,575.83 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 $3,482.35 $32,042.86 $45,000.00 71.21 %$12,957.14 101-000-420-542-75-20-00 Benefits $1,702.43 $16,116.46 $23,000.00 70.07 %$6,883.54 101-000-420-542-75-30-00 Supplies $313.80 $3,439.63 $15,000.00 22.93 %$11,560.37 101-000-420-542-75-47-00 Utilities $75.00 $2,588.34 $4,000.00 64.71 %$1,411.66 101-000-420-542-75-48-00 Repairs & Maintenance $45.36 $771.18 $4,000.00 19.28 %$3,228.82 101-000-420-542-80-48-00 Maint Agmt - Japanese Gdn $0.00 $4,000.00 $18,000.00 22.22 %$14,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,687.00 $13,588.28 $0.00 ($13,588.28) 101-000-430-543-30-20-00 Benefits $1,996.04 $7,744.09 $0.00 ($7,744.09) 101-000-430-543-30-30-00 Supplies $483.73 $5,415.50 $6,000.00 90.26 %$584.50 101-000-430-543-30-46-00 Insurance $10.32 $1,651.56 $48,600.00 3.40 %$46,948.44 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 $116.66 $3,372.46 $6,000.00 56.21 %$2,627.54 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 $0.00 $2,099.83 $6,500.00 32.31 %$4,400.17 101-000-430-544-90-20-00 Benefits $0.00 $1,066.95 $3,872.00 27.56 %$2,805.05 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 $480.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 $114,148.37 $992,868.01 $1,625,049.00 61.10 %$632,180.99 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 $59,926.90 $59,926.90 $142,769.00 41.97 %$82,842.10 102-000-000-558-70-41-00 CDBG Professional Services $0.00 $0.00 $6,000.00 0.00 %$6,000.00 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 $59,926.90 $59,926.90 $153,841.00 38.95 %$93,914.10 Transportation Benefit District Fund 105-000-000-595-90-60-00 StreetSaver Program $7,240.00 $7,240.00 $0.00 ($7,240.00) 105-000-000-597-91-00-00 Transfer Out - Fund 301 Project Expenditures $277,141.05 $277,141.05 $360,000.00 76.98 %$82,858.95 Total Transportation Benefit District Fund $284,381.05 $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 $227.23 $3,490.83 $3,700.00 94.35 %$209.17 112-000-000-572-50-49-00 Facilities--Supplies & Miscellaneous $0.00 $0.00 $40.00 0.00 %$40.00 Total Library Fund $227.23 $3,490.83 $6,940.00 50.30 %$3,449.17 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 $0.00 $5,000.00 $70,000.00 7.14 %$65,000.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $9,273.00 $74,184.00 $111,276.00 66.67 %$37,092.00 Total Hotel/Motel Tax Fund $9,273.00 $79,184.00 $181,276.00 43.68 %$102,092.00 Events Board Fund 117-000-050-557-30-10-00 Eweb Salaries $5,885.75 $37,789.68 $72,000.00 52.49 %$34,210.32 117-000-050-557-30-20-00 Eweb Benefits $3,202.54 $21,823.85 $32,000.00 68.20 %$10,176.15 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 $573.60 $573.60 $0.00 ($573.60) 117-000-100-557-30-25-00 Marketing - Regional Tourism $0.00 $8.62 $2,000.00 0.43 %$1,991.38 117-000-100-557-30-31-00 Events Department Office Supplies $0.00 $350.02 $0.00 ($350.02) 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 $0.00 $205.54 $7,600.00 2.70 %$7,394.46 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 $0.00 $243.45 $2,750.00 8.85 %$2,506.55 117-000-400-557-30-42-13 Wings & Wheels Postage $0.00 $0.00 $1,000.00 0.00 %$1,000.00 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 $0.00 $309.17 $8,000.00 3.86 %$7,690.83 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 $408.52 $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 $0.00 $348.35 $1,000.00 34.84 %$651.65 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 $10,070.41 $88,140.95 $192,600.00 45.76 %$104,459.05 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 $37,584.74 $41,422.51 $100,000.00 41.42 %$58,577.49 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 $30,254.09 $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 $14,539.31 $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 $22,585.74 $25,727.74 $15,000.00 171.52 %($10,727.74) 301-000-000-595-30-40-39 Construction 2019 TBD Paving $242,091.85 $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 $347,055.73 $582,022.47 $1,502,150.00 38.75 %$920,127.53 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 $4,197.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 $4,197.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 $51,858.99 $565,299.57 $517,000.00 109.34 %($48,299.57) 314-000-000-594-73-60-00 City Gazebo Rebuild $35,900.76 $35,900.76 $0.00 ($35,900.76) Total Capital Improvements Fund $87,759.75 $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 $563.26 $5,102.08 $7,000.00 72.89 %$1,897.92 501-000-000-521-10-20-00 Police Vehicle R&M Benefits $412.06 $2,860.09 $2,300.00 124.35 %($560.09) 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $1,646.81 $18,147.01 $35,000.00 51.85 %$16,852.99 501-000-000-542-90-10-00 Street Vehicle R&M Labor $720.96 $12,030.50 $19,000.00 63.32 %$6,969.50 501-000-000-542-90-20-00 Street Vehicle R&M Benefits $542.13 $5,507.78 $10,000.00 55.08 %$4,492.22 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $27.15 $9,315.82 $31,000.00 30.05 %$21,684.18 501-000-000-542-90-48-25 Street Vehicle R&M Supplies $164.16 $2,974.09 $5,000.00 59.48 %$2,025.91 Page 23 of 26 Account Number Title Period Fiscal Budget % of Total Balance 501-000-000-542-90-48-30 Street Equipment R&M $0.00 $720.44 $1,600.00 45.03 %$879.56 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 $96,628.36 $96,628.36 $196,000.00 49.30 %$99,371.64 Total Equipment Purchase, Repair & Replacement Fund $100,704.89 $312,067.14 $466,600.00 66.88 %$154,532.86 Grand Totals $1,592,604.23 $7,764,736.19 $13,330,308.69 58.25 %$5,565,572.50 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 $574,859.90 $4,653,988.15 $7,427,252.69 62.66 %$2,773,264.54 101-000-000-000-00-00-00 Street Fund $114,148.37 $992,868.01 $1,625,049.00 61.10 %$632,180.99 102-000-000-000-00-00-00 Community Development Grants Fund $59,926.90 $59,926.90 $153,841.00 38.95 %$93,914.10 105-000-000-000-00-00-00 Transportation Benefit District Fund $284,381.05 $284,381.05 $360,000.00 78.99 %$75,618.95 112-000-000-000-00-00-00 Library Fund $227.23 $3,490.83 $6,940.00 50.30 %$3,449.17 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $9,273.00 $79,184.00 $181,276.00 43.68 %$102,092.00 117-000-000-000-00-00-00 Events Board Fund $10,070.41 $88,140.95 $192,600.00 45.76 %$104,459.05 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 $347,055.73 $582,022.47 $1,502,150.00 38.75 %$920,127.53 308-000-000-000-00-00-00 Storm Water Improvements Fund $4,197.00 $40,748.05 $575,000.00 7.09 %$534,251.95 314-000-000-000-00-00-00 Capital Improvements Fund $87,759.75 $637,499.14 $809,000.00 78.80 %$171,500.86 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $100,704.89 $312,067.14 $466,600.00 66.88 %$154,532.86 Grand Totals $1,592,604.23 $7,764,736.19 $13,330,308.69 58.25 %$5,565,572.50 Page 25 of 26 Beginning Activity Cash In 001 $3,224,637.95 $4,235,453.47 101 $324,859.26 $1,100,770.04 102 $77,954.27 $0.00 105 $379,978.50 $171,507.60 110 $495,000.00 $0.00 112 $10,371.75 $3,500.00 113 $76,558.62 $109,944.21 114 $1,063.88 $447.92 116 $28,363.65 $14,010.57 117 $109,898.73 $56,020.09 202 $9,088.19 $30,000.00 301 $617,142.84 $905,708.76 308 $115,590.47 $9,453.94 314 $1,071,531.13 $245,415.17 501 $131,631.44 $450,000.00 $6,673,670.68 $7,332,231.77 $7,789,304.39 $6,216,598.06 Equipment Purchase, Repair & Replacement Fund $312,067.14 $269,564.30 Storm Water Improvements Fund $48,406.05 $76,638.36 Capital Improvements Fund $637,499.14 $679,447.16 Bond Redemption Fund $30,419.50 $8,668.69 Street Improvements Fund $582,022.47 $940,829.13 Criminal Justice Fund $0.00 $42,374.22 Events Board Fund $89,590.95 $76,327.87 Hotel/Motel Tax Fund $79,184.00 $107,318.83 Drug Fund $0.00 $1,511.80 Financing Reserves Fund $0.00 $495,000.00 Library Fund $3,490.83 $10,380.92 Community Development Grants Fund $59,926.90 $18,027.37 Transportation Benefit District Fund $284,441.05 $267,045.05 Street Fund $1,007,019.31 $418,609.99 Out Balance General Fund $4,655,237.05 $2,804,854.37 Cash and Investment Activity Period: 2019 - August 2019Fund Activity Ending Page 26 of 26