Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2019 - November 2019 Monthly Financial Report - Josh DeLay, Finance Director
City of East Wenatchee January 7, 2020 City Council Meeting November 2019 Financial Report Date: January 7, 2020 To: Councilmembers, Mayor Lacy & Department Heads From: Josh DeLay, Finance Director Subject: November 2019 Financial Report This report provides a summary of the City’s overall financial operations through November 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 November 30, 2019 compared to revenue collections through November 30, 2018, along with the respective dollar and percentage variances for its operating funds. Table 1 November 30, 2019 November 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 6,504,193 6,391,998 112,195 1.76% Street Fund - 101 1,373,061 1,353,040 20,021 1.48% Events Board Fund - 117 99,611 101,709 (2,098) (2.06%) Equipment R&R Fund - 501 450,000 350,000 100,000 28.57% Total Revenues - Operating Funds 8,426,866 8,196,748 230,118 2.81% Revenues - Operating Funds CITY OF EAST WENATCHEE Finance Department 271 9th Street NE * East Wenatchee, WA 98802 P: (509) 886-6101 * F: (509) 884-6233 * Email: jdelay@east- wenatchee.com 1 of 26 City of East Wenatchee January 7, 2020 City Council Meeting November 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 November 30, 2019 compared to revenue collections through November 30, 2018, along with the respective dollar and percentage variances for its non-operating funds. 2 of 26 City of East Wenatchee January 7, 2020 City Council Meeting November 2019 Financial Report Table 2 November 30, 2019 November 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 65,250 3,470 61,780 1780.53% Trans Benefit District Fund - 105 242,965 237,341 5,625 2.37% Debt Reserve Fund - 110 165,000 165,000 - 0.00% Library Fund - 112 7,000 7,000 - - Hotel/Motel Tax Fund - 113 166,817 137,003 29,814 21.76% Drug Fund - 114 450 141 308 218.16% Criminal Justice Fund - 116 18,841 18,197 643 3.53% Bond Redemption Fund - 202 30,000 30,000 - - Street Improvements Fund - 301 1,008,969 602,460 406,509 67.47% Storm Water Improvements Fund - 308 49,953 127,610 (77,657) (60.85%) Capital Improvements Fund - 314 565,140 613,753 (48,613) (7.92%) Total Revenues - Non-Operating Funds 2,320,384 1,941,974 378,410 19.49% 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 3 of 26 City of East Wenatchee January 7, 2020 City Council Meeting November 2019 Financial Report Revenue Highlights: General Fund revenues are up $112,195, or 1.76%, from last year due to: •$142,247 increase in property tax allocated to this fund this year versus last year at this time •$129,678 increase in gambling tax collected due to the re-opening of a gambling establishment •$43,225 increase in criminal justice sales tax, which is imposed by Douglas County, but shared with all cities within the county on a per capita basis The above increases are offset by the following decreases from last year: •$54,798 less sales tax allocation due to other funds needing their allotted sales tax for large purchases early in the year. This number should equalize by year-end. •$31,720 less phone/cellular utility tax collections •$30,907 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 $29,814, or 21.76%, from last year presumably due to an increase in hotel stays in the City. Street Improvements Fund revenues are up $406,509, or 67.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. Storm Water Improvements Fund revenues are down $77,657, or 60.85%, from last year due to the timing, completion and reimbursement of Astor Court and Ashland Avenue projects. Capital Improvements Fund revenues are down $48,613, or 7.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 hasn’t received its full property tax allocation in 2019 yet. Table 3 below shows the City’s expenditures through November 30, 2019 compared to expenditures through November 30, 2018, along with respective dollar and percentage variances for its operating funds. 4 of 26 City of East Wenatchee January 7, 2020 City Council Meeting November 2019 Financial Report Table 3 November 30, 2019 November 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 6,257,107 6,133,348 123,759 2.02% Street Fund - 101 1,421,122 1,156,663 264,459 22.86% Events Board Fund - 117 140,651 155,143 (14,492) (9.34%) Equipment R&R Fund - 501 443,700 93,992 349,709 372.06% Total Expenditures - Operating Funds 8,262,581 7,539,146 723,435 9.60% 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 November 30, 2019 compared to expenditures through November 30, 2018, along with respective dollar and percentage variances for its non- operating funds. 5 of 26 City of East Wenatchee January 7, 2020 City Council Meeting November 2019 Financial Report Table 4 November 30, 2019 November 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 197,335 87,046 44.11% Debt Reserve Fund - 110 - - - - Library Fund - 112 4,520 3,176 1,344 42.30% Hotel/Motel Tax Fund - 113 140,843 68,138 72,705 106.70% Drug Fund - 114 - - - - Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 30,420 30,604 (184) (0.60%) Street Improvements Fund - 301 674,475 1,344,479 (670,004) (49.83%) Storm Water Improvements Fund - 308 81,951 118,497 (36,547) (30.84%) Capital Improvements Fund - 314 639,036 69,973 569,063 813.26% Total Expenditures - Non-Operating Funds 1,918,191 1,833,673 84,518 4.61% 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 6 of 26 City of East Wenatchee January 7, 2020 City Council Meeting November 2019 Financial Report Expenditure Highlights: General Fund expenditures are up $123,759, or 2.02%, from last year primarily due to salary and benefit increases. Additionally, the Law Enforcement and Municipal Court Departments had increases in capital outlay due to some one-time purchases of new radios, and a Laserfiche system, respectively. Street Fund expenditures are up $264,459, or 22.86%, from last year due to snow and ice removal overtime, delayed Department of Transportation utility billings from prior years that we paid this year, and the pre-payment to Eastmont Metro Parks for the next ten years’ worth of loop trail services per a contract between the City and Eastmont Metro Parks. Events Fund expenditures are down $14,492, or 9.34%, from last year due to a portion of the Events Director salary and benefits 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 $349,709, or 372.06%, from last year due to the purchase of a new snow plow by the Street Department. Transportation Benefit District Fund expenditures are up $87,046, or 44.11%, due to an increase of the cost and size of overlay projects between this year and last year. Hotel/Motel Tax Fund expenditures are up $72,705, or 106.70%, due to an increase in contributions to the Wenatchee Valley Museum, and other entities that received funding recommended by the Lodging Tax Advisory Committee. Street Improvements Fund expenditures are down $670,004, or 49.83%, from last year due to an overall decrease in the size and number of projects that are funded from this fund. Capital Improvements Fund expenditures are up $569,063, or 813.26%, 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 November 30, 2019. 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 $399,129.09 $1,000,000.00 $1,000,000.00 100.00 %$0.00 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $381,484.31 $2,946,957.50 $3,270,000.00 90.12 %$323,042.50 001-000-000-313-71-00-00 Criminal Justice Sales Tax $30,341.01 $326,168.35 $277,000.00 117.75 %($49,168.35) 001-000-000-316-40-00-00 Electric Utility Tax $23,403.73 $339,416.86 $352,000.00 96.43 %$12,583.14 001-000-000-316-45-00-00 Natural Gas Utility Tax $1,785.97 $32,740.22 $34,000.00 96.29 %$1,259.78 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $65,035.55 $347,462.09 $355,000.00 97.88 %$7,537.91 001-000-000-316-84-00-00 Gambling Tax $74,314.56 $392,104.10 $302,000.00 129.84 %($90,104.10) 001-000-000-316-84-00-01 Gambling Tax Penalties $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Total Taxes $975,494.22 $5,384,849.12 $5,591,500.00 96.30 %$206,650.88 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 $0.00 $742.00 $800.00 92.75 %$58.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 $7,357.75 $95,501.41 $81,000.00 117.90 %($14,501.41) 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 $1,211.50 $40,575.35 $63,000.00 64.41 %$22,424.65 001-000-000-322-90-01-00 Gun Permits $449.00 $6,319.00 $6,200.00 101.92 %($119.00) 001-000-000-322-90-02-00 Sign Permits $0.00 $72.50 $100.00 72.50 %$27.50 Total Licenses and Permits $9,018.25 $217,950.95 $248,600.00 87.67 %$30,649.05 Intergovernmental Revenues 001-000-000-331-97-06-00 Homeland Security Grnt Program $1,727.00 $1,727.00 $0.00 ($1,727.00) 001-000-000-333-16-50-00 Columbia River Drug Task Force $3,770.75 $4,851.02 $5,000.00 97.02 %$148.98 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 $0.00 $3,135.89 $2,500.00 125.44 %($635.89) 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 $44,228.30 $48,734.57 $48,600.00 100.28 %($134.57) 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 $0.00 $22,419.25 $30,000.00 74.73 %$7,580.75 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $1,904.74 $2,100.00 90.70 %$195.26 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $74,740.49 $70,000.00 106.77 %($4,740.49) 001-000-000-336-06-95-00 Liquor Board Profits $0.00 $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 - November 2019 8 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Intergovernmental Revenues $49,726.05 $295,295.28 $323,293.55 91.34 %$27,998.27 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 $0.00 $51.00 $200.00 25.50 %$149.00 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 $4,691.54 $0.00 ($4,691.54) 001-000-000-342-33-00-00 Adult Probation Services $5,039.59 $54,380.97 $80,000.00 67.98 %$25,619.03 001-000-000-342-36-00-00 Housing of Prisoners $1,730.56 $16,580.44 $27,000.00 61.41 %$10,419.56 001-000-000-342-40-00-01 Fire Marshall Inspection Services $188.00 $3,294.50 $5,500.00 59.90 %$2,205.50 001-000-000-345-83-00-00 Plan Checking Fees $641.05 $21,779.13 $32,000.00 68.06 %$10,220.87 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 $239.00 $1,000.00 23.90 %$761.00 001-000-000-345-89-00-00 Planning & Development Fees $0.00 $11,697.70 $4,500.00 259.95 %($7,197.70) Total Charges for Goods and Services $7,599.20 $117,714.28 $160,200.00 73.48 %$42,485.72 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $17,290.89 $156,197.49 $211,000.00 74.03 %$54,802.51 001-000-000-357-33-00-00 Public Defender Costs $2,167.66 $20,753.44 $29,000.00 71.56 %$8,246.56 001-000-000-357-35-00-00 Restitution $0.00 $360.25 $0.00 ($360.25) Total Fines and Penalties $19,458.55 $177,311.18 $240,000.00 73.88 %$62,688.82 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $8,834.93 $119,602.58 $85,000.00 140.71 %($34,602.58) 001-000-000-361-40-00-00 Sales Tax Interest $667.72 $7,042.67 $2,800.00 251.52 %($4,242.67) 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,195.00 $9,629.27 $14,400.00 66.87 %$4,770.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 $1,000.80 $6,415.22 $6,000.00 106.92 %($415.22) Total Miscellaneous Revenues $11,698.45 $142,689.74 $108,300.00 131.75 %($34,389.74) 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 $319.84 $2,841.58 $3,900.00 72.86 %$1,058.42 001-000-000-389-30-00-10 State Surcharge $38.00 $903.50 $800.00 112.94 %($103.50) 001-000-000-389-30-00-15 State Share Weapons Permit Fee $721.00 $7,402.75 $10,000.00 74.03 %$2,597.25 001-000-000-389-30-00-20 Court Remittance - State $17,829.02 $153,307.13 $218,000.00 70.32 %$64,692.87 Total Other Increases in Fund Resources $18,907.86 $166,954.96 $235,100.00 71.01 %$68,145.04 Other Financing Sources 001-000-000-395-10-00-00 Proceeds - Disposition of Assets $519.36 $572.16 $0.00 ($572.16) 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 $519.36 $1,427.53 $0.00 ($1,427.53) Total General Fund $1,092,421.94 $6,504,193.04 $6,906,993.55 94.17 %$402,800.51 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $69,178.35 $500,000.00 $500,000.00 100.00 %$0.00 9 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-000-313-11-00-00 Sales & Use Tax $0.00 $350,000.00 $350,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $285.00 $2,714.70 $3,700.00 73.37 %$985.30 101-000-000-336-00-71-00 Multi-Modal Distribution $0.00 $14,193.62 $18,000.00 78.85 %$3,806.38 101-000-000-336-00-87-00 Gas Tax $23,140.57 $247,781.16 $299,000.00 82.87 %$51,218.84 101-000-000-336-00-87-05 Increased Gas Tax $0.00 $12,419.54 $9,700.00 128.04 %($2,719.54) 101-000-000-343-13-00-00 SWA Administrative Services $794.94 $9,443.46 $27,500.00 34.34 %$18,056.54 101-000-000-343-13-00-90 SWA NPDES Reimbursement $25,191.66 $152,766.28 $240,000.00 63.65 %$87,233.72 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-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 $0.00 $42,736.98 $0.00 ($42,736.98) Total Street Fund $118,590.52 $1,373,061.08 $1,481,149.00 92.70 %$108,087.92 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $65,250.00 $65,250.00 $153,841.00 42.41 %$88,591.00 Total Community Development Grants Fund $65,250.00 $65,250.00 $153,841.00 42.41 %$88,591.00 Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $25,462.80 $242,965.20 $241,000.00 100.82 %($1,965.20) Total Transportation Benefit District Fund $25,462.80 $242,965.20 $241,000.00 100.82 %($1,965.20) Financing Reserves Fund 110-000-000-311-10-00-00 Property Tax $165,000.00 $165,000.00 $165,000.00 100.00 %$0.00 Total Financing Reserves Fund $165,000.00 $165,000.00 $165,000.00 100.00 %$0.00 Library Fund 112-000-000-347-20-00-00 Library Services $3,500.00 $7,000.00 $6,500.00 107.69 %($500.00) Total Library Fund $3,500.00 $7,000.00 $6,500.00 107.69 %($500.00) Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $9,002.23 $83,408.43 $56,850.00 146.72 %($26,558.43) 113-000-000-313-31-04-00 H/M Tax Allocated $9,002.23 $83,408.43 $56,850.00 146.72 %($26,558.43) Total Hotel/Motel Tax Fund $18,004.46 $166,816.86 $113,700.00 146.72 %($53,116.86) Drug Fund 114-000-000-356-50-03-00 Drug Investigation $0.57 $22.37 $150.00 14.91 %$127.63 114-000-000-369-30-00-00 Confiscated/forfeited Property $0.00 $427.26 $0.00 ($427.26) Total Drug Fund $0.57 $449.63 $150.00 299.75 %($299.63) Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $0.00 $4,097.70 $3,700.00 110.75 %($397.70) 116-000-000-336-06-26-00 Criminal Justice - Special Programs $0.00 $14,742.84 $13,400.00 110.02 %($1,342.84) Total Criminal Justice Fund $0.00 $18,840.54 $17,100.00 110.18 %($1,740.54) Events Board Fund 117-000-100-313-31-00-00 H/M Tax - Events $9,002.25 $60,456.58 $60,000.00 100.76 %($456.58) 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 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $0.00 $2,202.00 $1,650.00 133.45 %($552.00) 10 of 26 Account Number Title Period Fiscal Budget % of Total Balance 117-000-400-347-40-11-03 Wings & Wheels Car Show Registration $0.00 $4,620.00 $5,500.00 84.00 %$880.00 117-000-400-347-40-11-07 Wings & Wheels Vendor Fees $0.00 $150.00 $300.00 50.00 %$150.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 $7,900.00 $12,400.00 $6,500.00 190.77 %($5,900.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 Parkway Pile-Up Car Show Sponsorships $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 $2,000.00 $2,000.00 $2,000.00 100.00 %$0.00 117-000-610-347-40-00-00 Diggin the Sun Volleyball Entry Fee $0.00 $0.00 $0.00 $0.00 Total Events Board Fund $18,902.25 $99,611.43 $103,270.00 96.46 %$3,658.57 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 $67,580.50 $85,000.00 79.51 %$17,419.50 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-04-20-02 PWTFL - 10th Street Design $0.00 $202,129.79 $750,000.00 26.95 %$547,870.21 301-000-000-361-00-00-00 Interest Earnings $0.00 $25.20 $0.00 ($25.20) 301-000-000-397-41-10-05 Transfer-In from Fund 105 $0.00 $277,141.05 $360,000.00 76.98 %$82,858.95 Total Street Improvements Fund $0.00 $1,008,968.74 $1,816,678.00 55.54 %$807,709.26 Storm Water Improvements Fund 308-000-000-334-03-10-00 State Ecology Grant $0.00 $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 $11,855.00 $13,650.94 $250,000.00 5.46 %$236,349.06 Total Storm Water Improvements Fund $11,855.00 $49,953.07 $612,500.00 8.16 %$562,546.93 Capital Improvements Fund 314-000-000-311-10-00-00 Real and Personal Property Taxes $17,734.42 $55,074.88 $100,000.00 55.07 %$44,925.12 314-000-000-318-34-00-00 Real Estate Excise Tax $53,743.18 $321,879.35 $350,000.00 91.97 %$28,120.65 314-000-000-333-10-00-00 Douglas County Regional Share $0.00 $188,186.00 $188,000.00 100.10 %($186.00) Total Capital Improvements Fund $71,477.60 $565,140.23 $638,000.00 88.58 %$72,859.77 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 11 of 26 Account Number Title Period Fiscal Budget % of Total Balance Grand Totals $1,590,465.14 $10,747,249.82 $12,735,881.55 84.39 %$1,988,631.73 12 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $1,092,421.94 $6,504,193.04 $6,906,993.55 94.17 %$402,800.51 101-000-000-000-00-00-00 Street Fund $118,590.52 $1,373,061.08 $1,481,149.00 92.70 %$108,087.92 102-000-000-000-00-00-00 Community Development Grants Fund $65,250.00 $65,250.00 $153,841.00 42.41 %$88,591.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $25,462.80 $242,965.20 $241,000.00 100.82 %($1,965.20) 110-000-000-000-00-00-00 Financing Reserves Fund $165,000.00 $165,000.00 $165,000.00 100.00 %$0.00 112-000-000-000-00-00-00 Library Fund $3,500.00 $7,000.00 $6,500.00 107.69 %($500.00) 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $18,004.46 $166,816.86 $113,700.00 146.72 %($53,116.86) 114-000-000-000-00-00-00 Drug Fund $0.57 $449.63 $150.00 299.75 %($299.63) 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $18,840.54 $17,100.00 110.18 %($1,740.54) 117-000-000-000-00-00-00 Events Board Fund $18,902.25 $99,611.43 $103,270.00 96.46 %$3,658.57 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 $0.00 $1,008,968.74 $1,816,678.00 55.54 %$807,709.26 308-000-000-000-00-00-00 Storm Water Improvements Fund $11,855.00 $49,953.07 $612,500.00 8.16 %$562,546.93 314-000-000-000-00-00-00 Capital Improvements Fund $71,477.60 $565,140.23 $638,000.00 88.58 %$72,859.77 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,590,465.14 $10,747,249.82 $12,735,881.55 84.39 %$1,988,631.73 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 $565.43 $2,907.15 $2,500.00 116.29 %($407.15) 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 Insurance Premiums $2,082.00 $25,652.16 $27,500.00 93.28 %$1,847.84 001-000-001-528-70-40-00 River Com $28,242.67 $310,669.37 $340,000.00 91.37 %$29,330.63 001-000-001-539-30-40-00 Animal Control $6,126.24 $61,262.40 $73,515.00 83.33 %$12,252.60 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 District $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)$901.05 $3,488.57 $3,600.00 96.90 %$111.43 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,917.39 $680,587.29 $734,176.69 92.70 %$53,589.40 Legislative 001-000-110-511-60-10-00 Salaries $16,501.99 $170,132.17 $165,000.00 103.11 %($5,132.17) 001-000-110-511-60-20-00 Benefits $5,250.47 $56,058.20 $95,000.00 59.01 %$38,941.80 001-000-110-511-60-21-50 Public Defender $8,100.00 $89,600.00 $96,000.00 93.33 %$6,400.00 001-000-110-511-60-30-00 Public Defender Conflicts $195.00 $3,900.00 $6,000.00 65.00 %$2,100.00 001-000-110-511-60-31-00 Office Supplies $191.20 $371.79 $400.00 92.95 %$28.21 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 ($5.00)$41.25 $90.00 45.83 %$48.75 001-000-110-511-60-40-00 Training $178.07 $2,321.54 $4,000.00 58.04 %$1,678.46 001-000-110-511-60-41-00 Professional Services $0.00 $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 Cell Phone $366.22 $1,342.26 $1,800.00 74.57 %$457.74 001-000-110-511-60-43-00 Travel $18.00 $1,091.40 $2,100.00 51.97 %$1,008.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 $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 $0.00 $1,398.87 $11,000.00 12.72 %$9,601.13 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-518-20-40-00 Property Management - 311 9th St NE Ending Account Number: 501-001-000-508-80-00-00 Ending EPM&R Fund Balance - Unreserved Period: 2019 - November 2019 14 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-110-511-60-49-00 Miscellaneous $544.03 $6,934.98 $5,000.00 138.70 %($1,934.98) Total Legislative $31,339.98 $401,054.55 $468,343.00 85.63 %$67,288.45 Municipal Court 001-000-120-512-50-10-00 Salaries $15,042.32 $167,010.74 $182,000.00 91.76 %$14,989.26 001-000-120-512-50-12-00 Salaries - Probation Services $4,404.82 $48,926.28 $53,000.00 92.31 %$4,073.72 001-000-120-512-50-20-00 Benefits $5,280.51 $59,424.45 $66,000.00 90.04 %$6,575.55 001-000-120-512-50-22-00 Benefits - Probation Services $2,908.75 $32,706.97 $36,000.00 90.85 %$3,293.03 001-000-120-512-50-31-00 Office Supplies $0.00 $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 $0.00 $6,305.95 $4,000.00 157.65 %($2,305.95) 001-000-120-512-50-46-00 Insurance $0.00 $391.13 $12,600.00 3.10 %$12,208.87 001-000-120-512-50-49-00 Miscellaneous $2,000.00 $2,109.84 $1,200.00 175.82 %($909.84) 001-000-120-512-50-49-01 Interpreting $0.00 $580.00 $5,000.00 11.60 %$4,420.00 001-000-120-512-50-49-02 Judge Protems $0.00 $2,475.00 $4,000.00 61.88 %$1,525.00 001-000-120-512-50-49-03 Witness Fees $0.00 $188.18 $500.00 37.64 %$311.82 001-000-120-512-50-49-04 Juror Fees $31.61 $1,313.75 $2,000.00 65.69 %$686.25 001-000-120-512-50-49-09 Security $512.50 $4,475.00 $6,000.00 74.58 %$1,525.00 001-000-120-594-12-60-00 Capital Outlay $291.08 $22,148.85 $24,495.00 90.42 %$2,346.15 Total Municipal Court $30,471.59 $351,126.16 $401,595.00 87.43 %$50,468.84 City Clerk 001-000-140-514-20-10-00 Salaries $6,128.28 $70,935.55 $78,884.00 89.92 %$7,948.45 001-000-140-514-20-20-00 Benefits $3,156.99 $35,506.97 $39,000.00 91.04 %$3,493.03 001-000-140-514-20-31-00 Office Supplies $0.00 $318.83 $3,000.00 10.63 %$2,681.17 001-000-140-514-20-31-01 Central Stores $294.76 $5,249.94 $4,000.00 131.25 %($1,249.94) 001-000-140-514-20-40-00 Training $0.00 $655.00 $2,000.00 32.75 %$1,345.00 001-000-140-514-20-41-00 Membership Dues & Publications $0.00 $547.12 $1,200.00 45.59 %$652.88 001-000-140-514-20-42-03 Postage $427.39 $427.39 $0.00 ($427.39) 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 $251.43 $1,420.17 $2,000.00 71.01 %$579.83 001-000-140-514-20-46-00 Insurance $0.00 $246.85 $8,000.00 3.09 %$7,753.15 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 $8.80 $213.99 $750.00 28.53 %$536.01 001-000-140-514-30-20-00 Records Services $365.50 $854.21 $1,000.00 85.42 %$145.79 001-000-140-514-30-25-00 Codification $0.00 $1,539.34 $2,100.00 73.30 %$560.66 Total City Clerk $10,633.15 $119,920.29 $144,934.00 82.74 %$25,013.71 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $0.00 $3,581.75 $14,000.00 25.58 %$10,418.25 001-000-141-514-20-42-01 Telephone Line Charges $2,904.70 $13,382.53 $13,000.00 102.94 %($382.53) 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 $660.19 $7,599.84 $1,500.00 506.66 %($6,099.84) 001-000-141-514-20-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 Total Internal Services $3,564.89 $27,064.12 $37,000.00 73.15 %$9,935.88 Finance 001-000-142-514-20-10-00 Salaries $14,744.04 $157,729.34 $174,000.00 90.65 %$16,270.66 001-000-142-514-20-20-00 Benefits $6,350.01 $72,672.78 $80,000.00 90.84 %$7,327.22 15 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-142-514-20-31-00 Office Supplies $92.13 $794.58 $1,700.00 46.74 %$905.42 001-000-142-514-20-43-00 Travel $0.00 $191.87 $600.00 31.98 %$408.13 001-000-142-514-20-46-00 Insurance $0.00 $458.74 $8,000.00 5.73 %$7,541.26 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 State Audit $6,966.96 $19,249.23 $22,000.00 87.50 %$2,750.77 001-000-142-514-25-30-00 Bank Charges & Fees $916.03 $4,479.25 $4,000.00 111.98 %($479.25) 001-000-142-514-40-20-00 Training $0.00 $250.00 $2,000.00 12.50 %$1,750.00 Total Finance $29,069.17 $255,831.74 $292,700.00 87.40 %$36,868.26 Information Technology 001-000-145-514-00-10-00 Salaries $7,566.78 $75,706.24 $92,000.00 82.29 %$16,293.76 001-000-145-514-00-20-00 Benefits $3,620.97 $36,597.47 $36,000.00 101.66 %($597.47) 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 $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 $6,927.30 $7,000.00 98.96 %$72.70 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 $756.32 $1,500.00 50.42 %$743.68 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 $21.08 $449.12 $1,000.00 44.91 %$550.88 001-000-145-514-20-49-00 Miscellaneous $48.66 $515.44 $300.00 171.81 %($215.44) 001-000-145-594-14-60-20 Capital - PC Software Admin $1,960.63 $15,217.48 $28,000.00 54.35 %$12,782.52 001-000-145-594-14-60-25 Capital - PC Hardware Admin $578.16 $8,299.16 $25,000.00 33.20 %$16,700.84 001-000-145-594-14-60-27 Capital - Cmptr Equip Police $1,452.05 $11,288.06 $25,000.00 45.15 %$13,711.94 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,248.33 $234,845.62 $284,045.00 82.68 %$49,199.38 Legal 001-000-151-515-31-10-00 Salaries $11,501.16 $129,172.09 $139,000.00 92.93 %$9,827.91 001-000-151-515-31-20-00 Benefits $5,206.98 $60,447.15 $65,000.00 93.00 %$4,552.85 001-000-151-515-31-20-10 Training $0.00 $70.00 $1,000.00 7.00 %$930.00 001-000-151-515-31-25-00 Professional Services $0.00 $278.00 $2,500.00 11.12 %$2,222.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 $141.06 $11,000.00 1.28 %$10,858.94 001-000-151-515-31-49-00 Miscellaneous $0.00 $2,692.69 $5,000.00 53.85 %$2,307.31 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,708.14 $192,840.79 $227,300.00 84.84 %$34,459.21 Civil Service 001-000-160-521-10-10-00 Salaries $260.00 $2,860.00 $3,120.00 91.67 %$260.00 001-000-160-521-10-46-00 Insurance $0.00 $82.35 $6,500.00 1.27 %$6,417.65 001-000-160-521-10-49-00 Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Civil Service $260.00 $2,942.35 $9,720.00 30.27 %$6,777.65 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 $151.98 $1,890.33 $2,000.00 94.52 %$109.67 001-000-180-518-30-35-00 Small Tools & Equipment $17.29 $859.90 $10,000.00 8.60 %$9,140.10 001-000-180-518-30-41-00 Professional Services $0.00 $20,412.94 $20,000.00 102.06 %($412.94) 001-000-180-518-30-41-01 Contracted Custodial Services $3,933.53 $22,491.25 $24,000.00 93.71 %$1,508.75 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 $427.60 $41,000.00 1.04 %$40,572.40 001-000-180-518-30-47-00 Utilities $1,366.28 $20,663.42 $25,000.00 82.65 %$4,336.58 001-000-180-518-30-48-00 Repairs & Maintenance $0.00 $9,473.80 $12,000.00 78.95 %$2,526.20 001-000-180-518-30-49-00 Miscellaneous $153.08 $755.06 $2,000.00 37.75 %$1,244.94 001-000-180-518-30-49-01 Landscaping $0.00 $745.69 $12,000.00 6.21 %$11,254.31 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)$587.56 $5,951.81 $6,000.00 99.20 %$48.19 001-000-180-594-18-60-00 Capital Outlay $0.00 $10,059.99 $10,000.00 100.60 %($59.99) Total Central Services $6,209.72 $93,762.62 $184,000.00 50.96 %$90,237.38 Law Enforcement 001-000-210-521-10-10-00 Salaries $178,600.77 $1,894,746.96 $2,120,000.00 89.37 %$225,253.04 001-000-210-521-10-10-02 Overtime Salaries $14,842.50 $166,025.78 $150,000.00 110.68 %($16,025.78) 001-000-210-521-10-10-03 Overtime Salaries - Traffic Control $0.00 $4,477.87 $8,000.00 55.97 %$3,522.13 001-000-210-521-10-20-00 Benefits $61,421.65 $696,191.50 $810,000.00 85.95 %$113,808.50 001-000-210-521-10-20-01 Clothing Allowance $2,037.96 $10,546.54 $15,600.00 67.61 %$5,053.46 001-000-210-521-10-31-00 Office Supplies $17.52 $6,333.87 $8,000.00 79.17 %$1,666.13 001-000-210-521-10-31-05 Office Machine Costs $349.43 $3,312.99 $5,000.00 66.26 %$1,687.01 001-000-210-521-10-32-00 Fuel Consumed $4,644.52 $44,013.86 $45,000.00 97.81 %$986.14 001-000-210-521-10-35-00 Small Tools & Equipment $0.00 $11,363.01 $13,000.00 87.41 %$1,636.99 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 $1,075.45 $11,907.78 $14,000.00 85.06 %$2,092.22 001-000-210-521-10-42-01 Telephone $1,281.14 $18,515.66 $28,000.00 66.13 %$9,484.34 001-000-210-521-10-42-03 Postage $49.03 $1,123.38 $1,200.00 93.62 %$76.62 001-000-210-521-10-43-00 Travel $0.00 $17,515.89 $22,000.00 79.62 %$4,484.11 001-000-210-521-10-46-00 Insurance $0.00 $5,492.22 $75,600.00 7.26 %$70,107.78 001-000-210-521-10-48-00 Repairs & Maintenance $712.33 $3,841.89 $8,000.00 48.02 %$4,158.11 001-000-210-521-10-49-00 Miscellaneous $375.38 $4,057.28 $5,500.00 73.77 %$1,442.72 001-000-210-521-10-49-01 Reserves $0.00 $0.00 $1,500.00 0.00 %$1,500.00 17 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-10-49-02 Dry Cleaning Services $117.93 $550.33 $1,500.00 36.69 %$949.67 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 $630.00 $1,000.00 63.00 %$370.00 001-000-210-521-40-25-00 Training - Officers $0.00 $7,236.56 $8,000.00 90.46 %$763.44 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 - Academy $1,765.57 $9,249.77 $9,600.00 96.35 %$350.23 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 $44,228.30 $83,600.46 $84,000.00 99.52 %$399.54 Total Law Enforcement $311,519.48 $3,004,457.64 $3,448,450.00 87.12 %$443,992.36 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $0.00 $216,861.14 $302,000.00 71.81 %$85,138.86 001-000-230-523-60-20-00 Medical Care - Prisoners $0.00 $2,839.62 $11,000.00 25.81 %$8,160.38 001-000-230-527-60-30-00 Juvenile Detention $2,160.00 $4,920.00 $8,000.00 61.50 %$3,080.00 Total Jail Services $2,160.00 $224,620.76 $321,000.00 69.98 %$96,379.24 Public Works 001-000-315-542-10-10-00 Salaries $6,849.60 $75,990.17 $83,000.00 91.55 %$7,009.83 001-000-315-542-10-20-00 Benefits $3,302.20 $36,905.33 $42,000.00 87.87 %$5,094.67 001-000-315-542-10-31-00 Office Supplies $0.00 $106.39 $750.00 14.19 %$643.61 001-000-315-542-10-35-00 Small Tools & Equipment $0.00 $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 $0.00 $128.30 $10,500.00 1.22 %$10,371.70 001-000-315-542-10-49-00 Training $0.00 $310.00 $2,000.00 15.50 %$1,690.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 $639.09 $8,995.05 $10,000.00 89.95 %$1,004.95 Total Public Works $10,790.89 $123,515.29 $152,050.00 81.23 %$28,534.71 Planning 001-000-580-558-60-10-00 Salaries $14,115.38 $156,816.65 $172,000.00 91.17 %$15,183.35 001-000-580-558-60-20-00 Benefits $4,922.32 $55,511.93 $62,000.00 89.54 %$6,488.07 001-000-580-558-60-31-00 Office Supplies $697.78 $1,304.42 $900.00 144.94 %($404.42) 001-000-580-558-60-32-00 Fuel Consumed $0.00 $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 $589.56 $3,964.96 $2,400.00 165.21 %($1,564.96) 001-000-580-558-60-46-00 Insurance $0.00 $177.48 $10,400.00 1.71 %$10,222.52 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 $20.00 $1,218.00 $2,000.00 60.90 %$782.00 Total Planning $20,345.04 $224,126.63 $266,950.00 83.96 %$42,823.37 18 of 26 Account Number Title Period Fiscal Budget % of Total Balance Code Compliance 001-000-590-558-50-10-00 Salaries $8,616.24 $94,410.94 $104,000.00 90.78 %$9,589.06 001-000-590-558-50-20-00 Benefits $4,249.89 $47,198.88 $53,000.00 89.05 %$5,801.12 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 $39.45 $423.37 $350.00 120.96 %($73.37) 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-01 Fire Marshal Services $0.00 $15,711.98 $20,664.00 76.04 %$4,952.02 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 $102.78 $7,900.00 1.30 %$7,797.22 001-000-590-558-50-49-00 Miscellaneous $0.00 $105.12 $300.00 35.04 %$194.88 Total Code Compliance $12,905.58 $157,972.54 $217,289.00 72.70 %$59,316.46 Other Expenditures 001-001-000-589-30-00-03 Fireworks - Deposit Refund $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 $791.94 $3,192.02 $4,200.00 76.00 %$1,007.98 001-001-000-589-30-00-10 Remittance: State Building Code Surcharge $140.00 $808.00 $400.00 202.00 %($408.00) 001-001-000-589-30-00-15 State Share of Permits & Licenses $512.75 $8,121.25 $12,000.00 67.68 %$3,878.75 001-001-000-589-30-00-20 Court Remittances $18,350.55 $147,067.77 $220,000.00 66.85 %$72,932.23 Total Other Expenditures $19,795.24 $162,439.04 $237,700.00 68.34 %$75,260.96 Total General Fund $558,938.59 $6,257,107.43 $7,427,252.69 84.25 %$1,170,145.26 Street Fund Storm Water Administration 101-000-311-542-42-10-00 SWU Administration - Salaries $2,362.40 $5,194.22 $15,000.00 34.63 %$9,805.78 101-000-311-542-42-20-00 SWU Administration - Benefits $961.38 $2,310.02 $5,000.00 46.20 %$2,689.98 101-000-311-542-42-31-00 SWU Administration - DC Annual Billing Fee $6,856.36 $6,856.36 $7,500.00 91.42 %$643.64 Total Storm Water Administration $10,180.14 $14,360.60 $27,500.00 52.22 %$13,139.40 NPDES 101-000-313-542-42-10-00 NPDES Maintenance Salaries $1,670.90 $71,089.01 $75,000.00 94.79 %$3,910.99 101-000-313-542-42-10-10 NPDES Sweeping Salaries $2,007.90 $14,791.21 $16,000.00 92.45 %$1,208.79 101-000-313-542-42-20-00 NPDES Maintenance Benefits $646.68 $42,944.15 $45,000.00 95.43 %$2,055.85 101-000-313-542-42-20-10 NPDES Sweeping Benefits $943.86 $9,709.80 $8,000.00 121.37 %($1,709.80) 101-000-313-542-42-30-00 NPDES Supplies $4,111.92 $30,180.52 $63,149.00 47.79 %$32,968.48 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 $820.74 $500.00 164.15 %($320.74) 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 $13,639.64 $32,272.37 $5,000.00 645.45 %($27,272.37) 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-40-04 SWU Postage $15.66 $15.66 $0.00 ($15.66) 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 $0.00 $76.00 $1,500.00 5.07 %$1,424.00 19 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-313-542-42-47-00 NPDES Utilities $356.54 $2,476.78 $1,500.00 165.12 %($976.78) 101-000-313-542-42-48-00 NPDES Equipment Repair & Maintenance $407.26 $3,295.20 $2,500.00 131.81 %($795.20) 101-000-313-542-42-49-00 NPDES Miscellaneous Expense $55.26 $386.71 $1,000.00 38.67 %$613.29 Total NPDES $23,855.62 $214,691.91 $273,149.00 78.60 %$58,457.09 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 $661.92 $34,378.31 $60,000.00 57.30 %$25,621.69 101-000-420-542-30-20-00 Benefits - Roadway $242.07 $18,237.16 $33,000.00 55.26 %$14,762.84 101-000-420-542-30-30-00 Supplies - Roadway $22.00 $47,783.47 $50,000.00 95.57 %$2,216.53 101-000-420-542-30-48-00 Repairs & Maintenance - Roadway $0.00 $257.64 $6,000.00 4.29 %$5,742.36 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $7,312.42 $4,500.00 162.50 %($2,812.42) 101-000-420-542-61-20-00 Benefits - Sidewalks $0.00 $4,529.75 $2,400.00 188.74 %($2,129.75) 101-000-420-542-61-30-00 Supplies - Sidewalks $108.66 $1,073.70 $2,000.00 53.69 %$926.30 101-000-420-542-61-48-00 Repairs & Maintenance - Sidewalks $0.00 $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 - Special Purpose Paths $0.00 $120.17 $250.00 48.07 %$129.83 101-000-420-542-62-30-00 Supplies - Special Purpose Paths $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 $140,000.00 $153,000.00 $13,000.00 1,176.92 %($140,000.00) 101-000-420-542-63-10-00 Salaries - Street Lighting $854.04 $2,770.12 $2,000.00 138.51 %($770.12) 101-000-420-542-63-20-00 Benefits - Street Lighting $194.50 $1,125.53 $1,200.00 93.79 %$74.47 101-000-420-542-63-30-00 Supplies - Street Lighting $0.00 $103.96 $500.00 20.79 %$396.04 101-000-420-542-63-47-00 Utilities - Street Lighting $3,495.92 $83,759.06 $60,000.00 139.60 %($23,759.06) 101-000-420-542-63-48-00 Repairs & Maintenance - Street Lighting $0.00 $8,103.62 $5,000.00 162.07 %($3,103.62) 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $223.54 $25,626.85 $40,000.00 64.07 %$14,373.15 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $193.27 $15,002.99 $23,000.00 65.23 %$7,997.01 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $96.75 $33,936.01 $48,000.00 70.70 %$14,063.99 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $576.99 $5,709.38 $9,000.00 63.44 %$3,290.62 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $0.00 $17,317.33 $14,000.00 123.70 %($3,317.33) 101-000-420-542-65-10-00 Salaries - Parking Facilities $172.33 $300.71 $1,000.00 30.07 %$699.29 101-000-420-542-65-20-00 Benefits - Parking Facilities $142.85 $230.53 $500.00 46.11 %$269.47 101-000-420-542-65-30-00 Supplies - Parking Facilities $0.00 $0.00 $300.00 0.00 %$300.00 101-000-420-542-65-47-00 Utilities - Parking Facilities $0.00 $270.00 $500.00 54.00 %$230.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $1,737.96 $35,961.98 $50,000.00 71.92 %$14,038.02 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $609.09 $14,987.86 $27,000.00 55.51 %$12,012.14 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $0.00 $73,339.30 $100,000.00 73.34 %$26,660.70 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $0.00 $9,958.20 $5,000.00 199.16 %($4,958.20) 101-000-420-542-69-10-00 Salaries - Flags/Banners $715.16 $8,205.02 $10,000.00 82.05 %$1,794.98 101-000-420-542-69-20-00 Benefits - Flags/Banners $444.45 $4,005.64 $5,000.00 80.11 %$994.36 101-000-420-542-69-30-00 Supplies - Flags/Banners $51.66 $807.26 $2,000.00 40.36 %$1,192.74 101-000-420-542-70-10-00 Salaries - Roadside $20,837.55 $174,587.80 $180,000.00 96.99 %$5,412.20 101-000-420-542-70-20-00 Benefits - Roadside $11,832.38 $92,188.27 $94,000.00 98.07 %$1,811.73 101-000-420-542-70-30-00 Supplies - Roadside $50.66 $2,010.45 $5,000.00 40.21 %$2,989.55 20 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-70-41-00 Professional Services - Roadside $0.00 $1,623.00 $3,000.00 54.10 %$1,377.00 101-000-420-542-70-47-00 Utilities - Roadside $0.00 $790.60 $1,000.00 79.06 %$209.40 101-000-420-542-70-48-00 Repairs & Maintenance - Roadside $0.00 $16.00 $1,000.00 1.60 %$984.00 101-000-420-542-75-10-00 Salaries - City Parks $3,077.77 $44,078.28 $45,000.00 97.95 %$921.72 101-000-420-542-75-20-00 Benefits - City Parks $2,047.64 $23,500.84 $23,000.00 102.18 %($500.84) 101-000-420-542-75-30-00 Supplies - City Parks $393.45 $6,401.78 $15,000.00 42.68 %$8,598.22 101-000-420-542-75-47-00 Utilities - City Parks $1,391.00 $5,408.94 $4,000.00 135.22 %($1,408.94) 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $128.33 $1,198.16 $4,000.00 29.95 %$2,801.84 101-000-420-542-80-48-00 Japanese Garden Agreement $4,000.00 $12,000.00 $18,000.00 66.67 %$6,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 - Maintenance Admin $0.00 $686.20 $23,520.00 2.92 %$22,833.80 101-000-430-543-30-10-00 Salaries - General Services $1,950.79 $18,705.31 $0.00 ($18,705.31) 101-000-430-543-30-20-00 Benefits - General Services $892.79 $10,059.07 $0.00 ($10,059.07) 101-000-430-543-30-30-00 Supplies - General Services $1,369.29 $9,059.20 $6,000.00 150.99 %($3,059.20) 101-000-430-543-30-46-00 Insurance $51.60 $2,692.87 $48,600.00 5.54 %$45,907.13 101-000-430-543-30-49-00 Miscellaneous - General Services $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 - Facilities $0.00 $126.30 $1,600.00 7.89 %$1,473.70 101-000-430-543-50-30-00 Supplies - Facilities $0.00 $33.50 $2,000.00 1.68 %$1,966.50 101-000-430-543-50-47-00 Utilities - Facilities $234.71 $3,954.09 $6,000.00 65.90 %$2,045.91 101-000-430-543-50-48-00 Repairs & Maintenance - Facilities $0.00 $814.48 $2,500.00 32.58 %$1,685.52 101-000-430-544-90-10-00 Salaries - Training $639.37 $3,098.03 $6,500.00 47.66 %$3,401.97 101-000-430-544-90-20-00 Benefits - Training $131.13 $1,490.82 $3,872.00 38.50 %$2,381.18 101-000-430-544-90-30-00 Supplies - Training $0.00 $54.30 $500.00 10.86 %$445.70 101-000-430-544-90-35-00 Travel $145.00 $1,839.00 $4,000.00 45.98 %$2,161.00 101-000-430-544-90-49-01 Training $0.00 $85.00 $1,000.00 8.50 %$915.00 Total Street Fund $233,752.38 $1,421,121.69 $1,625,049.00 87.45 %$203,927.31 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 $0.00 $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 $0.00 $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 to Fund 301 $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 $664.13 $4,520.19 $3,700.00 122.17 %($820.19) 112-000-000-572-50-49-00 Facilities - Supplies & Miscellaneous $0.00 $0.00 $40.00 0.00 %$40.00 Total Library Fund $664.13 $4,520.19 $6,940.00 65.13 %$2,419.81 21 of 26 Account Number Title Period Fiscal Budget % of Total Balance Hotel/Motel Tax Fund 113-000-000-557-30-41-10 Contributions to Other Entities $18,840.00 $38,840.00 $70,000.00 55.49 %$31,160.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $9,273.00 $102,003.00 $111,276.00 91.67 %$9,273.00 Total Hotel/Motel Tax Fund $28,113.00 $140,843.00 $181,276.00 77.70 %$40,433.00 Events Board Fund 117-000-050-557-30-10-00 Salaries $9,979.74 $60,820.77 $72,000.00 84.47 %$11,179.23 117-000-050-557-30-20-00 Benefits $4,138.57 $33,176.31 $32,000.00 103.68 %($1,176.31) 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-30-25-00 Marketing - Regional Tourism $0.00 $1,283.85 $2,000.00 64.19 %$716.15 117-000-100-557-30-31-00 Events Department Office Supplies $9.76 $1,147.98 $0.00 ($1,147.98) 117-000-100-557-30-32-00 Fuel $0.00 $0.00 $200.00 0.00 %$200.00 117-000-100-557-30-35-00 Eweb Small Tools & Equipment $12.95 $12.95 $100.00 12.95 %$87.05 117-000-100-557-30-41-00 Professional Services $0.00 $369.00 $0.00 ($369.00) 117-000-100-557-30-42-00 Cell Phone $25.00 $25.00 $0.00 ($25.00) 117-000-100-557-30-44-00 Advertising $0.00 $573.60 $0.00 ($573.60) 117-000-100-557-30-49-00 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 Insurance $0.00 $230.81 $7,600.00 3.04 %$7,369.19 117-000-115-557-30-31-05 Office Supplies $0.00 $113.82 $1,000.00 11.38 %$886.18 117-000-200-557-30-35-02 Easter - Small Tools & Equipment $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 CC - Small Tools & Equipment $0.00 $476.61 $1,000.00 47.66 %$523.39 117-000-300-557-30-41-12 CC - Professional Services $910.00 $2,849.15 $5,500.00 51.80 %$2,650.85 117-000-300-557-30-42-14 CC - 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 CC - Advertising $0.00 $3,986.30 $4,500.00 88.58 %$513.70 117-000-300-557-30-49-12 CC - 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 $401.50 $401.50 $3,500.00 11.47 %$3,098.50 117-000-400-557-30-35-11 W&W - Small Tools & Equipment $739.58 $739.58 $3,000.00 24.65 %$2,260.42 117-000-400-557-30-41-00 W&W - Professional Services $930.07 $5,817.46 $2,750.00 211.54 %($3,067.46) 117-000-400-557-30-42-13 W&W - Postage $0.00 $470.51 $1,000.00 47.05 %$529.49 117-000-400-557-30-43-12 W&W - EMPD Facility Fee $1,000.00 $1,000.00 $1,100.00 90.91 %$100.00 117-000-400-557-30-44-11 W&W - Advertising $1,000.00 $5,060.88 $8,000.00 63.26 %$2,939.12 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 W&W - Miscellaneous $101.40 $216.49 $1,100.00 19.68 %$883.51 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 Brochure $0.00 $1,601.72 $3,500.00 45.76 %$1,898.28 117-000-450-557-30-41-00 Parkway Pile-Up - Professional Services $0.00 $596.73 $1,000.00 59.67 %$403.27 117-000-450-557-30-44-12 Parkway Pile-Up - Advertising $0.00 $387.46 $1,000.00 38.75 %$612.54 117-000-450-557-30-49-01 Parkway Pile-Up - Miscellaneous $0.00 $425.25 $1,200.00 35.44 %$774.75 117-000-500-557-30-35-01 Christmas - Small Tools & Equipment $0.00 $0.00 $400.00 0.00 %$400.00 22 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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 Services $0.00 $227.22 $0.00 ($227.22) 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 $19,248.57 $140,651.22 $192,600.00 73.03 %$51,948.78 Bond Redemption Fund 202-000-000-591-95-71-05 Principal - PWTFL 11th St. NE $0.00 $29,712.47 $30,000.00 99.04 %$287.53 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE $0.00 $112.78 $0.00 ($112.78) 202-000-000-592-95-89-05 Interest - PWTFL 11th St. NE $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 $8,259.51 $87,852.29 $100,000.00 87.85 %$12,147.71 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 $7,567.39 $213,450.62 $750,000.00 28.46 %$536,549.38 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 $2,399.47 $33,192.24 $0.00 ($33,192.24) 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 $27,236.94 $15,000.00 181.58 %($12,236.94) 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 $18,226.37 $674,474.52 $1,502,150.00 44.90 %$827,675.48 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 $2,832.55 $2,832.55 $100,000.00 2.83 %$97,167.45 308-000-000-595-40-63-39 19th St. NW Design SWU DOE $7,424.63 $77,354.81 $250,000.00 30.94 %$172,645.19 308-000-312-595-40-10-00 Salaries - SWA Improvement Projects $0.00 $1,139.21 $0.00 ($1,139.21) 308-000-312-595-40-20-00 Benefits - SWA Improvement Projects $0.00 $623.93 $0.00 ($623.93) Total Storm Water Improvements Fund $10,257.18 $81,950.50 $575,000.00 14.25 %$493,049.50 Capital Improvements Fund 314-000-000-594-48-60-00 Maintenance Facilities Construction $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 $1,536.43 $566,836.00 $517,000.00 109.64 %($49,836.00) 314-000-000-594-73-60-00 City Gazebo Rebuild $0.00 $35,900.76 $0.00 ($35,900.76) Total Capital Improvements Fund $1,536.43 $639,035.57 $809,000.00 78.99 %$169,964.43 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $67.59 $5,439.18 $7,000.00 77.70 %$1,560.82 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $13.86 $2,985.75 $2,300.00 129.82 %($685.75) 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $693.75 $27,486.16 $35,000.00 78.53 %$7,513.84 501-000-000-542-90-10-00 Street Vehicle Repair Labor $3,881.51 $21,013.03 $19,000.00 110.59 %($2,013.03) 501-000-000-542-90-20-00 Street Vehicle Repair Benefits $1,734.69 $10,128.12 $10,000.00 101.28 %($128.12) 23 of 26 Account Number Title Period Fiscal Budget % of Total Balance 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $3,200.78 $15,465.40 $31,000.00 49.89 %$15,534.60 501-000-000-542-90-48-25 Street Vehicle Repair Supplies $1,411.54 $4,597.31 $5,000.00 91.95 %$402.69 501-000-000-542-90-48-30 Street Equipment Repairs $0.00 $1,036.92 $1,600.00 64.81 %$563.08 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 $196,767.46 $196,000.00 100.39 %($767.46) Total Equipment Purchase, Repair & Replacement Fund $11,003.72 $443,700.30 $466,600.00 95.09 %$22,899.70 Grand Totals $881,740.37 $10,180,771.67 $13,330,308.69 76.37 %$3,149,537.02 24 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $558,938.59 $6,257,107.43 $7,427,252.69 84.25 %$1,170,145.26 101-000-000-000-00-00-00 Street Fund $233,752.38 $1,421,121.69 $1,625,049.00 87.45 %$203,927.31 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $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 $664.13 $4,520.19 $6,940.00 65.13 %$2,419.81 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $28,113.00 $140,843.00 $181,276.00 77.70 %$40,433.00 117-000-000-000-00-00-00 Events Board Fund $19,248.57 $140,651.22 $192,600.00 73.03 %$51,948.78 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 $18,226.37 $674,474.52 $1,502,150.00 44.90 %$827,675.48 308-000-000-000-00-00-00 Storm Water Improvements Fund $10,257.18 $81,950.50 $575,000.00 14.25 %$493,049.50 314-000-000-000-00-00-00 Capital Improvements Fund $1,536.43 $639,035.57 $809,000.00 78.99 %$169,964.43 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $11,003.72 $443,700.30 $466,600.00 95.09 %$22,899.70 Grand Totals $881,740.37 $10,180,771.67 $13,330,308.69 76.37 %$3,149,537.02 25 of 26 Beginning Activity Ending Cash In Cash 001 $3,224,637.95 $6,505,545.94 $3,471,723.56 101 $324,859.26 $1,387,212.38 $276,798.65 102 $77,954.27 $65,250.00 $80,637.57 105 $379,978.50 $243,025.20 $338,562.65 110 $495,000.00 $165,000.00 $660,000.00 112 $10,371.75 $7,000.00 $12,851.56 113 $76,558.62 $166,816.86 $102,532.48 114 $1,063.88 $449.63 $1,513.51 116 $28,363.65 $18,840.54 $47,204.19 117 $109,898.73 $102,320.74 $68,858.94 202 $9,088.19 $30,000.00 $8,668.69 301 $617,142.84 $1,008,968.74 $951,637.06 308 $115,590.47 $57,611.07 $83,593.04 314 $1,071,531.13 $565,140.23 $997,635.79 501 $131,631.44 $450,000.00 $137,931.14 $6,673,670.68 $10,773,181.33 $7,240,148.83$10,206,703.18 Equipment Purchase, Repair & Replacement Fund $443,700.30 Storm Water Improvements Fund $89,608.50 Capital Improvements Fund $639,035.57 Bond Redemption Fund $30,419.50 Street Improvements Fund $674,474.52 Criminal Justice Fund $0.00 Events Board Fund $143,360.53 Hotel/Motel Tax Fund $140,843.00 Drug Fund $0.00 Financing Reserves Fund $0.00 Library Fund $4,520.19 Community Development Grants Fund $62,566.70 Transportation Benefit District Fund $284,441.05 Street Fund $1,435,272.99 Out General Fund $6,258,460.33 Cash and Investment Activity Period: 2019 - November 2019Fund Activity 26 of 26