Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018 - 2018 December (Year-End) Financial Report - Josh DeLay, Finance Director
City of East Wenatchee February 21, 2019 Council Workshop December 2018 Financial Report Date: February 21, 2019 To: Councilmembers, Mayor Lacy & Department Heads From: Josh DeLay, Finance Director Subject: 2018 December (Year-End) Financial Report This report provides a summary of the City’s overall financial operations through December 31, 2018. 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. Table 1 below shows the City’s revenue collections through December 31, 2018 compared to revenue collections through December 31, 2017, along with the respective dollar and percentage variances. Table 1 December 31, 2018 December 31, 2017 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 6,971,271 6,012,102 959,169 15.95% Street Fund - 101 1,393,565 1,339,038 54,526 4.07% Comm Dev Grants Fund - 102 3,470 7,492 (4,023) - Trans Benefit District Fund - 105 254,112 250,270 3,842 1.54% Debt Reserve Fund - 110 165,000 165,000 - - Library Fund - 112 7,000 6,500 500 7.69% Hotel/Motel Tax Fund - 113 151,159 14,000 137,159 979.71% Drug Fund - 114 148 6,107 (5,958) (97.57%) Criminal Justice Fund - 116 18,197 17,670 527 2.98% Events Board Fund - 117 111,052 236,235 (125,182) (52.99%) Bond Redemption Fund - 202 30,000 29,870 130 0.43% Street Improvements Fund - 301 1,164,564 7,917,496 (6,752,932) (85.29%) Storm Water Improvements Fund - 308 127,610 210,444 (82,834) (39.36%) Capital Improvements Fund - 314 670,262 521,017 149,245 28.65% Equipment R&R Fund - 501 350,000 344,000 6,000 1.74% Total Revenues 11,417,411 17,077,242 (5,659,831) (33.14%) Revenues JOSH DELAY, FINANCE DIRECTOR 271 9TH STREET NE • EAST WENATCHEE, WA 98802 PHONE: (509) 886-4507 • FAX: (509) 884-6233 ● E-MAIL: JDELAY@EAST-WENATCHEE.COM 1 of 24 City of East Wenatchee February 21, 2019 Council Workshop December 2018 Financial Report Chart 1 is a graphical representation of year to year revenue comparisons for each fund. Chart 1 Revenue Highlights: General Fund revenues finished $959,169, or 15.95%, greater than last year due to across the board increases to many revenue sources within the fund. The largest increases were the result of: •$739,680 in property taxes due to a change in property tax fund allocation for 2018 versus 2017 2 of 24 City of East Wenatchee February 21, 2019 Council Workshop December 2018 Financial Report •$180,783 in sales & use tax due to inflation and taxpayer spending habits •$66,376 in phone/cellular utility tax presumably due to more businesses paying this tax The largest decreases within this fund were the result of: •$125,000 transfer in from the Streets Fund in 2017 that wasn’t planned in 2018 •$77,018 in gambling tax due to the temporary closing of a large gambling establishment •$18,238 in Columbia River Drug Task Force money that we didn’t receive this year Hotel/Motel Tax Fund finished $137,159, or 979.71%, greater that last year, while Events Fund revenues finished $125,182, or 52.99%, lower than last year, due to a decision to re-allocate hotel/motel taxes from the Events Fund to the Hotel/Motel Tax Fund. Street Improvements Fund revenues finished $6,752,932, or 85.29%, less than last year mainly due to the decrease and timing of Transportation Improvement Board (TIB) funding and projects, and $555,000 less in property taxes allocated to the fun. Monies for this fund are generally received from state and federal grants, which typically explains the large fluctuations. Capital Improvements Fund revenues finished $149,245, or 28.65%, greater than last year due to across the board increases in all three revenue sources for this fund. Real Estate Excise taxes finished $141,632 higher, while the Douglas County Regional Share finished $57,613 higher. Table 2 below shows the City’s expenditures through December 31, 2018 compared to expenditures through December 31, 2018, along with respective dollar and percentage variances. Table 2 December 31, 2018 December 31, 2017 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 6,939,049 6,171,018 768,030 12.45% Street Fund - 101 1,310,699 1,218,415 92,284 7.57% Comm Dev Grants Fund - 102 1,801 2,932 (1,131) (38.58%) Trans Benefit District Fund - 105 197,335 136,488 60,847 - Debt Reserve Fund - 110 - - - - Library Fund - 112 3,566 5,265 (1,699) (32.27%) Hotel/Motel Tax Fund - 113 77,411 14,500 62,911 433.87% Drug Fund - 114 - 9,372 (9,372) - Criminal Justice Fund - 116 - 43,000 (43,000) - Events Board Fund - 117 167,653 155,194 12,459 8.03% Bond Redemption Fund - 202 30,604 30,901 (297) (0.96%) Street Improvements Fund - 301 1,367,087 7,608,374 (6,241,287) (82.03%) Storm Water Improvements Fund - 308 118,497 203,572 (85,075) (41.79%) Capital Improvements Fund - 314 74,609 658,837 (584,228) (88.68%) Equipment R&R Fund - 501 270,819 339,328 (68,510) (20.19%) Total Expenditures 10,559,128 16,597,196 (6,038,068) (36.38%) Expenditures 3 of 24 City of East Wenatchee February 21, 2019 Council Workshop December 2018 Financial Report Chart 2 is a graphical representation of year to year expenditure comparisons for each fund. Chart 2 Expenditure Highlights: General Fund expenditures finished $768,030, or 12.45%, greater than last year due to various reasons. The biggest variance is $280,546 for the house and land purchase at 311 9th St NE. Salaries and benefits contributed to most of the rest of the increases, including some retirements that resulted in large leave balance payouts. 4 of 24 City of East Wenatchee February 21, 2019 Council Workshop December 2018 Financial Report Street Fund expenditures finished $92,284, or 7.57%, greater than last year due to a combination of increases in salaries, benefits, and supplies. Hotel/Motel Tax Fund expenditures finished $62,911, or 433.87%, greater than last year due to approved funding for the Wenatchee Valley Museum. Street Improvements Fund expenditures finished $6,241,287, or 82.03%, less than last year due to a decrease in the number, size and scope of projects in 2018 versus 2017. Capital Improvements Fund expenditures finished $584,228, or 88.68%, less than last year due to a decrease of $500,000 in the amount transferred out of this fund to other funds. Last year, a $500,000 transfer from the Capital Improvements Fund to the Street Fund was allocated that wasn’t allocated this year. Equipment R&R Fund expenditures finished $68,310, or 20.19%, less than last year due to timing differences in the purchase of replacement equipment. 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 December 31, 2018. 5 of 24 Account Number Title Period Fiscal Budget % of Total Balance General Fund Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $97,764.83 $955,517.56 $972,000.00 98.30 %$16,482.44 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $308,661.73 $3,310,417.25 $2,930,000.00 112.98 %($380,417.25) 001-000-000-313-71-00-00 1/10 Sales Tax-Criminal Just $26,015.93 $308,959.06 $270,000.00 114.43 %($38,959.06) 001-000-000-316-40-00-00 Electric Utility Tax $25,261.70 $347,998.29 $345,800.00 100.64 %($2,198.29) 001-000-000-316-45-00-00 Natural Gas Utility Tax $3,437.68 $40,258.33 $38,000.00 105.94 %($2,258.33) 001-000-000-316-49-00-00 Phone/cellular Utility Tax $24,112.37 $403,294.30 $340,000.00 118.62 %($63,294.30) 001-000-000-316-84-00-00 Gambling Tax $0.00 $262,426.09 $340,000.00 77.18 %$77,573.91 001-000-000-316-84-00-01 Gambling Tax Penalties $0.00 $0.00 $3,500.00 0.00 %$3,500.00 Total Taxes $485,254.24 $5,628,870.88 $5,239,300.00 107.44 %($389,570.88) Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $0.00 $500.00 $800.00 62.50 %$300.00 001-000-000-321-60-00-00 Taxicab Licenses & Permits $582.00 $1,415.00 $200.00 707.50 %($1,215.00) 001-000-000-321-91-00-50 Franchise Fees - Cable $0.00 $98,903.67 $95,900.00 103.13 %($3,003.67) 001-000-000-321-91-00-60 Franchise Fees - Fiber Optics $0.00 $4,000.00 $0.00 ($4,000.00) 001-000-000-321-99-00-00 Business Licenses & Permits $6,861.01 $93,922.48 $86,290.00 108.85 %($7,632.48) 001-000-000-321-99-05-00 Other Business Lic & Permits $250.00 $250.00 $100.00 250.00 %($150.00) 001-000-000-322-10-00-00 Building & Structure Permits $349.15 $61,804.28 $52,000.00 118.85 %($9,804.28) 001-000-000-322-90-00-00 Other Non-Business Lic & Per $0.00 $18.00 $0.00 ($18.00) 001-000-000-322-90-01-00 Gun Permits $399.00 $6,592.00 $5,000.00 131.84 %($1,592.00) 001-000-000-322-90-02-00 Sign Permits $0.00 $355.00 $0.00 ($355.00) Total Licenses and Permits $8,441.16 $267,760.43 $240,290.00 111.43 %($27,470.43) Intergovernmental Revenues 001-000-000-333-04-21-05 WASPC Safety Grant $0.00 $2,000.00 $0.00 ($2,000.00) 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-01-20-00 WaState Court Equip Reimb $3,784.02 $3,788.52 $0.00 ($3,788.52) 001-000-000-334-03-50-01 DOJ - USMS Task Force $0.00 $2,922.37 $0.00 ($2,922.37) 001-000-000-334-03-51-03 Tsc - Seatbelt Emphasis Patrols $0.00 $369.75 $1,000.00 36.98 %$630.25 001-000-000-334-03-51-04 X-52 Tsc-Speed Limit Emphasis $0.00 $3,034.65 $2,000.00 151.73 %($1,034.65) 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $0.00 $1,961.65 $2,000.00 98.08 %$38.35 001-000-000-334-03-51-12 Tsc - DUI Emphasis Patrol $0.00 $3,146.79 $2,000.00 157.34 %($1,146.79) 001-000-000-334-06-91-10 Washington State Archives Grant $0.00 $45,000.00 $45,000.00 100.00 %$0.00 001-000-000-334-06-95-00 RIVERCOM 911 Funding Assistance $0.00 $4,804.68 $0.00 ($4,804.68) 001-000-000-335-00-91-00 Pud Privilege Tax $0.00 $44,925.74 $42,000.00 106.97 %($2,925.74) 001-000-000-336-00-71-00 Multimodal Transportation $0.00 $4,784.93 $0.00 ($4,784.93) 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $7,182.62 $36,935.11 $8,116.00 455.09 %($28,819.11) 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: 2018 - December 2018 6 of 24 Account Number Title Period Fiscal Budget % of Total Balance 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $2,010.48 $2,100.00 95.74 %$89.52 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $68,751.69 $63,000.00 109.13 %($5,751.69) 001-000-000-336-06-95-00 Liquor Board Profits $28,168.14 $112,688.53 $114,000.00 98.85 %$1,311.47 Total Intergovernmental Revenues $39,134.78 $337,124.89 $286,216.00 117.79 %($50,908.89) Charges for Goods and Services 001-000-000-341-33-10-00 Background Check Fees $0.00 $132.00 $0.00 ($132.00) 001-000-000-341-35-30-00 Duplicating Services - Court & Police $0.00 $0.00 $600.00 0.00 %$600.00 001-000-000-341-35-31-00 Copy and Duplication Fees - Admin $34.60 $104.00 $0.00 ($104.00) 001-000-000-341-35-35-00 Annual Admin Reimb Fees $0.00 $5,037.60 $10,500.00 47.98 %$5,462.40 001-000-000-341-96-00-00 Personnel Services $480.90 $5,916.58 $0.00 ($5,916.58) 001-000-000-342-33-00-00 Adult Probation Services $5,229.80 $71,460.32 $70,000.00 102.09 %($1,460.32) 001-000-000-342-36-00-00 Housing of Prisoners $1,490.22 $31,789.95 $23,000.00 138.22 %($8,789.95) 001-000-000-342-40-00-01 Fire Marshall Inspection Ser $0.00 $3,445.38 $3,500.00 98.44 %$54.62 001-000-000-345-83-00-00 Plan Checking Fees $156.00 $31,931.12 $25,551.00 124.97 %($6,380.12) 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $516.00 $1,000.00 51.60 %$484.00 001-000-000-345-86-00-00 Sepa Permits $0.00 $1,151.00 $800.00 143.88 %($351.00) 001-000-000-345-89-00-00 Planning & Development Fees $309.00 $8,366.45 $3,000.00 278.88 %($5,366.45) Total Charges for Goods and Services $7,700.52 $159,850.40 $137,951.00 115.87 %($21,899.40) Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $12,376.02 $199,480.22 $190,000.00 104.99 %($9,480.22) 001-000-000-357-33-00-00 Public Defender Costs $1,445.09 $27,653.26 $29,500.00 93.74 %$1,846.74 001-000-000-357-35-00-00 Restitution $100.00 $175.00 $0.00 ($175.00) Total Fines and Penalties $13,921.11 $227,308.48 $219,500.00 103.56 %($7,808.48) Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $11,539.99 $106,836.41 $41,961.00 254.61 %($64,875.41) 001-000-000-361-40-00-00 Sales Tax Interest $588.83 $5,523.82 $2,600.00 212.45 %($2,923.82) 001-000-000-369-20-00-00 Unclaimed Property $0.00 $174.14 $0.00 ($174.14) 001-000-000-369-80-00-00 Cash Adjustments $5.00 $5.00 $0.00 ($5.00) 001-000-000-369-91-50-00 Miscellaneous Revenue $480.21 $8,582.33 $5,000.00 171.65 %($3,582.33) Total Miscellaneous Revenues $12,614.03 $121,121.70 $49,561.00 244.39 %($71,560.70) Other Increases in Fund Resources 001-000-000-389-30-00-03 Fireworks - Cleaning Deposit $0.00 $2,500.00 $2,000.00 125.00 %($500.00) 001-000-000-389-30-00-04 Fireworks - Dcfd Remittance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-000-389-30-00-05 Crime Victim Assessment $131.36 $3,714.67 $3,850.00 96.48 %$135.33 001-000-000-389-30-00-10 ST WA Surcharge/bld Code Fee $6.50 $397.50 $300.00 132.50 %($97.50) 001-000-000-389-30-00-15 State Share Weapons Permit Fee $742.30 $10,719.80 $9,000.00 119.11 %($1,719.80) 001-000-000-389-30-00-20 Court Remittance--State $12,026.57 $196,957.95 $200,000.00 98.48 %$3,042.05 001-000-000-389-30-40-00 Engineering Reimbursements $0.00 $117.00 $0.00 ($117.00) Total Other Increases in Fund Resources $12,906.73 $214,406.92 $215,400.00 99.54 %$993.08 Other Financing Sources 001-000-000-395-10-00-00 Proceeds-Disposition of Assets $0.00 $14,797.50 $0.00 ($14,797.50) 001-000-000-397-21-01-00 Payroll/claims Corrections $0.00 $25.00 $0.00 ($25.00) 001-000-000-398-20-00-00 Insurance Recoveries $0.00 $5.00 $0.00 ($5.00) Total Other Financing Sources $0.00 $14,827.50 $0.00 ($14,827.50) E 7 of 24 Account Number Title Period Fiscal Budget % of Total Balance Total General Fund $579,972.57 $6,971,271.20 $6,388,218.00 109.13 %($583,053.20) Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $0.00 $500,000.00 $500,000.00 100.00 %$0.00 101-000-000-313-11-00-00 Sales And Use Tax $0.00 $320,000.00 $320,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $0.00 $960.00 $3,000.00 32.00 %$2,040.00 101-000-000-336-00-71-00 Multimodal Transpo City $4,783.66 $14,352.41 $4,500.00 318.94 %($9,852.41) 101-000-000-336-00-87-00 Street Fuel Excise Tax $24,376.16 $281,001.30 $282,000.00 99.65 %$998.70 101-000-000-336-00-87-05 MVA Transport Cities $4,185.74 $16,745.34 $7,900.00 211.97 %($8,845.34) 101-000-000-341-70-00-00 Sales of Scrap $0.00 $102.26 $0.00 ($102.26) 101-000-000-343-13-00-00 SWA Administrative Services $2,178.80 $16,901.94 $28,300.00 59.72 %$11,398.06 101-000-000-343-13-00-90 SWA NPDES Reimbursement $4,999.86 $234,048.00 $210,200.00 111.35 %($23,848.00) 101-000-000-343-13-00-95 DOE Capacity Grant - SWU $0.00 $9,074.79 $50,000.00 18.15 %$40,925.21 101-000-000-369-91-01-05 Miscellaneous Revenue $0.00 $378.58 $5,000.00 7.57 %$4,621.42 Total Street Fund $40,524.22 $1,393,564.62 $1,410,900.00 98.77 %$17,335.38 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $0.00 $3,469.76 $0.00 ($3,469.76) Total Community Development Grants Fund $0.00 $3,469.76 $0.00 ($3,469.76) Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fee Revenue $16,771.85 $254,112.43 $245,100.00 103.68 %($9,012.43) Total Transportation Benefit District Fund $16,771.85 $254,112.43 $245,100.00 103.68 %($9,012.43) Financing Reserves Fund 110-000-000-311-10-00-00 Property Tax $0.00 $165,000.00 $165,000.00 100.00 %$0.00 Total Financing Reserves Fund $0.00 $165,000.00 $165,000.00 100.00 %$0.00 Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $7,000.00 $6,500.00 107.69 %($500.00) Total Library Fund $0.00 $7,000.00 $6,500.00 107.69 %($500.00) Hotel/Motel Tax Fund 113-000-000-313-31-02-00 HM Tax - Allocated $7,078.17 $75,579.50 $56,850.00 132.95 %($18,729.50) 113-000-000-313-31-04-00 H/M Tax Allocated $7,078.17 $75,579.49 $56,850.00 132.95 %($18,729.49) Total Hotel/Motel Tax Fund $14,156.34 $151,158.99 $113,700.00 132.95 %($37,458.99) Drug Fund 114-000-000-356-50-03-00 Drug Investigation $7.14 $148.46 $120.00 123.72 %($28.46) Total Drug Fund $7.14 $148.46 $120.00 123.72 %($28.46) Criminal Justice Fund 116-000-000-336-06-21-00 Crim Justice - Population $0.00 $3,943.62 $3,740.00 105.44 %($203.62) 116-000-000-336-06-26-00 Crim Just - Special Programs $0.00 $14,253.78 $13,600.00 104.81 %($653.78) Total Criminal Justice Fund $0.00 $18,197.40 $17,340.00 104.94 %($857.40) Events Board Fund 117-000-100-313-31-00-00 H/M Tax - Events $7,078.19 $67,078.19 $60,000.00 111.80 %($7,078.19) 117-000-200-347-40-02-01 Easter Egg Hunt Admission Fees $0.00 $1,735.05 $1,600.00 108.44 %($135.05) 117-000-300-347-40-12-02 Classy Chassis Parade/car Show $0.00 $9,962.00 $8,500.00 117.20 %($1,462.00) 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $0.00 $0.00 $275.00 0.00 %$275.00 117-000-300-347-90-00-12 Classy Chassis Sponsorships $0.00 $8,100.00 $9,500.00 85.26 %$1,400.00 8 of 24 Account Number Title Period Fiscal Budget % of Total Balance 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $0.00 $1,845.00 $2,300.00 80.22 %$455.00 117-000-400-347-40-11-03 Wings & Wheels Car Show Registration $0.00 $5,260.00 $4,700.00 111.91 %($560.00) 117-000-400-347-40-11-04 Wings & Wheels Carnival $0.00 $0.00 $5,000.00 0.00 %$5,000.00 117-000-400-347-40-11-07 Wings & Wheels Vendor Fees $0.00 $110.00 $250.00 44.00 %$140.00 117-000-400-347-90-00-01 Wings & Wheels Donations $0.00 $0.00 $1,400.00 0.00 %$1,400.00 117-000-400-347-90-00-11 Wings & Wheels Sponsorships $350.00 $9,450.00 $7,000.00 135.00 %($2,450.00) 117-000-400-347-90-00-13 Schedule of Events Brochure $0.00 $3,950.00 $5,000.00 79.00 %$1,050.00 117-000-400-347-90-11-00 Wings & Wheels Merchandise Sales $0.00 $1,292.00 $900.00 143.56 %($392.00) 117-000-450-347-90-00-12 PkwyPile-up Car Show Sponsorship $0.00 $0.00 $450.00 0.00 %$450.00 117-000-450-347-90-00-15 PkwyPile-up Car Show Misc Revenue $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 Total Events Board Fund $9,428.19 $111,052.24 $108,875.00 102.00 %($2,177.24) 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 $20,000.00 $100,000.00 20.00 %$80,000.00 301-000-000-334-03-27-30 TIB Relight WA Install Grant $0.00 $57,094.99 $58,150.00 98.19 %$1,055.01 301-000-000-334-03-27-32 TIB Relight WA Mtls Grant $68,183.01 $68,183.01 $131,250.00 51.95 %$63,066.99 301-000-000-334-03-80-06 TIB Baker Ave 15th to 20th Project $143,079.30 $143,079.30 $13,531.00 1,057.42 %($129,548.30) 301-000-000-334-03-80-07 TIB - S. Kentucky & 5th ST. NE $350,841.94 $529,381.80 $557,440.00 94.97 %$28,058.20 301-000-000-334-03-80-22 TIB - Highline Drive $0.00 $65,499.75 $75,049.00 87.28 %$9,549.25 301-000-000-344-10-95-12 GEWSWU - 5th St. Sidewalks & SWU $0.00 $15,435.38 $15,000.00 102.90 %($435.38) 301-000-000-344-10-95-16 GEWSWU Baker Ave 15th to 20th $0.00 $18,213.05 $18,212.00 100.01 %($1.05) 301-000-000-344-10-96-00 EWWD - Baker Ave 15th to 20th $0.00 $0.00 $108,881.00 0.00 %$108,881.00 301-000-000-344-10-96-02 DCSD - Baker Ave - 15th to 20th $0.00 $0.00 $20,620.00 0.00 %$20,620.00 301-000-000-344-10-96-10 5th St Sidewalks & SWU - EWWD $0.00 $3,895.20 $0.00 ($3,895.20) 301-000-000-344-10-96-16 DC Rgnl Council -VMP Tfc Controller $0.00 $46,446.53 $0.00 ($46,446.53) 301-000-000-397-41-10-05 Transfer In-TBD Fund 105 Proj Funding $0.00 $197,335.00 $197,335.00 100.00 %$0.00 Total Street Improvements Fund $562,104.25 $1,164,564.01 $1,295,468.00 89.90 %$130,903.99 Storm Water Improvements Fund 308-000-000-343-13-00-30 SWA Small Improvement Projects $0.00 $0.00 $5,000.00 0.00 %$5,000.00 308-000-000-343-13-00-50 GEWSWU Astor Court $0.00 $59,122.52 $58,000.00 101.94 %($1,122.52) 308-000-000-343-13-00-55 GEWSWU Ashland Avenue $0.00 $59,122.51 $58,000.00 101.94 %($1,122.51) 308-000-000-343-13-00-83 DOE Grant 19th St. NW Design $0.00 $0.00 $125,000.00 0.00 %$125,000.00 308-000-000-343-13-00-86 DOE Grant SWA VMP LID Project $0.00 $9,364.98 $0.00 ($9,364.98) Total Storm Water Improvements Fund $0.00 $127,610.01 $246,000.00 51.87 %$118,389.99 Capital Improvements Fund 314-000-000-311-10-00-00 Real and Personal Property Taxes $0.00 $100,000.00 $0.00 ($100,000.00) 314-000-000-318-34-00-00 Real Estate Excise Tax $56,509.50 $512,649.24 $337,100.00 152.08 %($175,549.24) 314-000-000-333-10-00-00 Douglas County Regional Share $0.00 $57,613.00 $57,614.00 100.00 %$1.00 Total Capital Improvements Fund $56,509.50 $670,262.24 $394,714.00 169.81 %($275,548.24) 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 9 of 24 Account Number Title Period Fiscal Budget % of Total Balance 501-000-000-313-11-00-20 Sales & Use Tax - Streets $0.00 $200,000.00 $200,000.00 100.00 %$0.00 Total Equipment Purchase, Repair & Replacement Fund $0.00 $350,000.00 $350,000.00 100.00 %$0.00 Grand Totals $1,279,474.06 $11,417,411.36 $10,771,935.00 105.99 %($645,476.36) 10 of 24 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $579,972.57 $6,971,271.20 $6,388,218.00 109.13 %($583,053.20) 101-000-000-000-00-00-00 Street Fund $40,524.22 $1,393,564.62 $1,410,900.00 98.77 %$17,335.38 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $3,469.76 $0.00 ($3,469.76) 105-000-000-000-00-00-00 Transportation Benefit District Fund $16,771.85 $254,112.43 $245,100.00 103.68 %($9,012.43) 110-000-000-000-00-00-00 Financing Reserves Fund $0.00 $165,000.00 $165,000.00 100.00 %$0.00 112-000-000-000-00-00-00 Library Fund $0.00 $7,000.00 $6,500.00 107.69 %($500.00) 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $14,156.34 $151,158.99 $113,700.00 132.95 %($37,458.99) 114-000-000-000-00-00-00 Drug Fund $7.14 $148.46 $120.00 123.72 %($28.46) 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $18,197.40 $17,340.00 104.94 %($857.40) 117-000-000-000-00-00-00 Events Board Fund $9,428.19 $111,052.24 $108,875.00 102.00 %($2,177.24) 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 $562,104.25 $1,164,564.01 $1,295,468.00 89.90 %$130,903.99 308-000-000-000-00-00-00 Storm Water Improvements Fund $0.00 $127,610.01 $246,000.00 51.87 %$118,389.99 314-000-000-000-00-00-00 Capital Improvements Fund $56,509.50 $670,262.24 $394,714.00 169.81 %($275,548.24) 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $0.00 $350,000.00 $350,000.00 100.00 %$0.00 Grand Totals $1,279,474.06 $11,417,411.36 $10,771,935.00 105.99 %($645,476.36) 11 of 24 Account Number Title Period Fiscal Budget % of Total Balance General Fund General Government 001-000-001-518-91-30-00 Wellness $1,074.14 $2,858.95 $2,500.00 114.36 %($358.95) 001-000-001-518-93-49-00 City Theme $0.00 $7,122.00 $1,000.00 712.20 %($6,122.00) 001-000-001-521-10-29-00 Leoff 1 Ins Premiums/misc $0.00 $31,047.94 $35,000.00 88.71 %$3,952.06 001-000-001-528-70-40-00 River Com $26,835.50 $322,026.00 $322,026.00 100.00 %$0.00 001-000-001-539-30-40-00 Animal Control $6,126.18 $73,514.82 $73,515.00 100.00 %$0.18 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $0.00 $13,005.00 $13,003.00 100.02 %($2.00) 001-000-001-558-70-40-00 Contributions - Region $0.00 $30,000.00 $25,000.00 120.00 %($5,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-558-70-41-15 Wenatchee Valley Museum & CC $0.00 $46,365.00 $46,365.00 100.00 %$0.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$0.00 $2,692.50 $3,500.00 76.93 %$807.50 001-000-001-594-58-60-00 City Land Purchase - 311 9th St NE $0.00 $280,546.46 $0.00 ($280,546.46) Total General Government $34,035.82 $814,866.17 $528,019.00 154.33 %($286,847.17) Legislative 001-000-110-511-60-10-00 Salaries $12,442.95 $157,750.46 $210,500.00 74.94 %$52,749.54 001-000-110-511-60-20-00 Benefits $3,650.95 $42,132.32 $87,000.00 48.43 %$44,867.68 001-000-110-511-60-21-50 Public Defender $8,100.00 $97,700.00 $97,200.00 100.51 %($500.00) 001-000-110-511-60-30-00 Public Defender Conflicts $472.50 $4,579.50 $6,000.00 76.33 %$1,420.50 001-000-110-511-60-31-00 Office Supplies $118.96 $694.69 $235.00 295.61 %($459.69) 001-000-110-511-60-31-05 Newsletter Printing & Mailing $0.00 $13,387.75 $13,500.00 99.17 %$112.25 001-000-110-511-60-31-10 Public Records Expenses $0.00 $383.40 $0.00 ($383.40) 001-000-110-511-60-40-00 Training $185.00 $2,372.42 $8,000.00 29.66 %$5,627.58 001-000-110-511-60-41-00 Professional Services $12,350.00 $22,925.01 $25,000.00 91.70 %$2,074.99 001-000-110-511-60-41-20 Awc Annual Membership Fee $0.00 $8,828.00 $8,828.00 100.00 %$0.00 001-000-110-511-60-42-01 Telephone $100.67 $1,123.10 $0.00 ($1,123.10) 001-000-110-511-60-43-00 Travel $0.00 $2,470.59 $2,500.00 98.82 %$29.41 001-000-110-511-60-43-01 Travel - Misawa $0.00 $4,718.42 $7,500.00 62.91 %$2,781.58 001-000-110-511-60-44-00 Advertising $1,047.00 $8,142.26 $1,000.00 814.23 %($7,142.26) 001-000-110-511-60-45-00 Election Costs - Registered Voters $0.00 $23,597.03 $17,000.00 138.81 %($6,597.03) 001-000-110-511-60-46-00 Insurance $9,292.60 $11,660.34 $7,900.00 147.60 %($3,760.34) 001-000-110-511-60-47-00 Background Check Costs $48.00 $120.00 $0.00 ($120.00) 001-000-110-511-60-49-00 Miscellaneous $104.95 $5,329.66 $4,400.00 121.13 %($929.66) Total Legislative $47,913.58 $407,914.95 $496,563.00 82.15 %$88,648.05 Expenditure Starting Account Number: 001-000-001-515-10-40-00 Professional Services - Legal Ending Account Number: 501-001-000-508-10-00-00 Ending EPM&R Fund Balance - Reserved Period: 2018 - December 2018 12 of 24 Account Number Title Period Fiscal Budget % of Total Balance Municipal Court 001-000-120-512-50-10-00 Salaries $13,091.84 $171,686.26 $174,100.00 98.61 %$2,413.74 001-000-120-512-50-12-00 Salaries - Probation Svcs $3,658.66 $49,109.78 $48,900.00 100.43 %($209.78) 001-000-120-512-50-20-00 Benefits $4,693.08 $61,234.76 $57,000.00 107.43 %($4,234.76) 001-000-120-512-50-22-00 Benefits - Probation Svcs $2,733.44 $33,834.63 $32,500.00 104.11 %($1,334.63) 001-000-120-512-50-31-00 Office Supplies $0.00 $2,766.26 $2,800.00 98.80 %$33.74 001-000-120-512-50-40-00 Training $0.00 $1,005.00 $1,500.00 67.00 %$495.00 001-000-120-512-50-41-05 Do Not Use $0.00 $150.00 $0.00 ($150.00) 001-000-120-512-50-43-00 Travel $47.96 $3,005.01 $4,000.00 75.13 %$994.99 001-000-120-512-50-46-00 Insurance $11,175.16 $11,462.19 $9,600.00 119.40 %($1,862.19) 001-000-120-512-50-49-00 Miscellaneous $410.99 $410.99 $1,200.00 34.25 %$789.01 001-000-120-512-50-49-01 Interpreting $525.00 $1,245.00 $5,000.00 24.90 %$3,755.00 001-000-120-512-50-49-02 Judge Protems $225.00 $2,250.00 $4,000.00 56.25 %$1,750.00 001-000-120-512-50-49-03 Witness Fees $0.00 $17.51 $500.00 3.50 %$482.49 001-000-120-512-50-49-04 Juror Fees $859.80 $2,083.67 $1,500.00 138.91 %($583.67) 001-000-120-512-50-49-09 Security $700.00 $4,731.25 $5,000.00 94.63 %$268.75 001-000-120-594-12-60-00 Capital Outlay $1,224.84 $4,482.47 $5,000.00 89.65 %$517.53 Total Municipal Court $39,345.77 $349,474.78 $352,600.00 99.11 %$3,125.22 City Clerk 001-000-140-514-20-10-00 Salaries $5,935.50 $71,644.06 $71,000.00 100.91 %($644.06) 001-000-140-514-20-20-00 Benefits $2,897.26 $38,658.65 $40,000.00 96.65 %$1,341.35 001-000-140-514-20-31-00 Office Supplies $210.13 $1,783.34 $3,000.00 59.44 %$1,216.66 001-000-140-514-20-31-01 Central Stores $594.83 $5,919.40 $4,000.00 147.99 %($1,919.40) 001-000-140-514-20-40-00 Training $0.00 $944.00 $2,000.00 47.20 %$1,056.00 001-000-140-514-20-41-00 Membership Dues & Publications $28.12 $958.90 $0.00 ($958.90) 001-000-140-514-20-43-00 Travel $218.40 $1,171.03 $1,200.00 97.59 %$28.97 001-000-140-514-20-44-00 Advertising $901.68 $2,956.92 $2,000.00 147.85 %($956.92) 001-000-140-514-20-46-00 Insurance $5,711.09 $5,904.61 $4,900.00 120.50 %($1,004.61) 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 $156.75 $560.46 $750.00 74.73 %$189.54 001-000-140-514-30-20-00 Records Services $0.00 $845.00 $200.00 422.50 %($645.00) 001-000-140-514-30-25-00 Codification $573.09 $2,015.86 $2,100.00 95.99 %$84.14 Total City Clerk $17,226.85 $133,362.23 $131,650.00 101.30 %($1,712.23) Internal Services 001-000-141-514-20-31-01 Office Machine Costs $105.60 $17,614.35 $19,000.00 92.71 %$1,385.65 001-000-141-514-20-42-01 Telephone Line Charges $1,077.03 $10,952.04 $13,500.00 81.13 %$2,547.96 001-000-141-514-20-42-03 Postage $0.00 $5,499.20 $10,500.00 52.37 %$5,000.80 001-000-141-514-20-48-00 Repairs & Maintenance $1,570.22 $1,907.02 $1,750.00 108.97 %($157.02) Total Internal Services $2,752.85 $35,972.61 $44,750.00 80.39 %$8,777.39 Finance 001-000-142-514-20-10-00 Salaries $11,914.05 $183,567.92 $177,000.00 103.71 %($6,567.92) 001-000-142-514-20-20-00 Benefits $5,514.49 $85,683.47 $77,000.00 111.28 %($8,683.47) 001-000-142-514-20-31-00 Office Supplies $251.99 $1,842.59 $2,000.00 92.13 %$157.41 001-000-142-514-20-43-00 Travel $48.35 $398.43 $300.00 132.81 %($98.43) 001-000-142-514-20-46-00 Insurance $5,217.09 $5,452.61 $4,400.00 123.92 %($1,052.61) 13 of 24 Account Number Title Period Fiscal Budget % of Total Balance 001-000-142-514-20-49-00 Miscellaneous $0.00 $25.00 $500.00 5.00 %$475.00 001-000-142-514-23-20-00 Budgeting, Accting, & Auditing $0.00 $623.86 $2,000.00 31.19 %$1,376.14 001-000-142-514-25-30-00 Bank Charges & Fees $129.07 $3,531.40 $3,200.00 110.36 %($331.40) 001-000-142-514-40-20-00 Training $0.00 $1,114.45 $500.00 222.89 %($614.45) Total Finance $23,075.04 $282,239.73 $266,900.00 105.75 %($15,339.73) Information Technology 001-000-145-514-20-40-00 Network Services $13,942.66 $88,306.79 $75,000.00 117.74 %($13,306.79) 001-000-145-514-20-40-05 Disaster Backup System Support $0.00 $8,622.03 $8,000.00 107.78 %($622.03) 001-000-145-514-20-40-10 Annual Fee - ESRI GIS System License $1,967.56 $2,616.76 $2,150.00 121.71 %($466.76) 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $1,046.01 $17,541.49 $18,500.00 94.82 %$958.51 001-000-145-514-20-40-25 Annual License - Municipal Court $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $0.00 $5,463.08 $5,000.00 109.26 %($463.08) 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $3,218.50 $3,300.00 97.53 %$81.50 001-000-145-514-20-40-40 Annual Subscription - Vision Website $0.00 $6,753.05 $7,000.00 96.47 %$246.95 001-000-145-514-20-40-50 Annual License - FTR Recording System $0.00 $1,131.77 $600.00 188.63 %($531.77) 001-000-145-514-20-48-00 Repairs & Maintenance $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-145-514-20-49-00 Miscellaneous $32.44 $226.53 $1,000.00 22.65 %$773.47 001-000-145-594-14-60-20 Capital - Cmptr Software Admin $0.00 $68,530.08 $65,000.00 105.43 %($3,530.08) 001-000-145-594-14-60-25 Capital - Cmptr Hdwe Admin $38.91 $17,806.07 $20,000.00 89.03 %$2,193.93 001-000-145-594-14-60-27 Capital - Cmptr Equip Police $0.00 $21,785.73 $20,000.00 108.93 %($1,785.73) 001-000-145-594-14-60-35 Capital - Cmptr Equip Admin $0.00 $3,751.77 $6,950.00 53.98 %$3,198.23 001-000-145-594-14-60-40 Capital - Cmptr Sftwr Police $0.00 $972.98 $0.00 ($972.98) Total Information Technology $17,027.58 $246,726.63 $234,500.00 105.21 %($12,226.63) Legal 001-000-151-515-30-10-00 Salaries $10,315.79 $135,939.64 $134,000.00 101.45 %($1,939.64) 001-000-151-515-30-20-00 Benefits $4,983.70 $63,889.38 $62,000.00 103.05 %($1,889.38) 001-000-151-515-30-20-10 Training $0.00 $245.00 $100.00 245.00 %($145.00) 001-000-151-515-30-25-05 Litigation Expenses $0.00 $0.00 $500.00 0.00 %$500.00 001-000-151-515-30-25-10 Licensing $495.08 $495.08 $500.00 99.02 %$4.92 001-000-151-515-30-31-00 Office Supplies $0.00 $114.68 $300.00 38.23 %$185.32 001-000-151-515-30-43-00 Travel $0.00 $1,767.39 $600.00 294.57 %($1,167.39) 001-000-151-515-30-46-00 Insurance $9,401.07 $9,447.83 $8,000.00 118.10 %($1,447.83) 001-000-151-515-30-49-00 Miscellaneous $410.35 $498.95 $100.00 498.95 %($398.95) Total Legal $25,605.99 $212,397.95 $206,100.00 103.06 %($6,297.95) Civil Service 001-000-160-521-10-10-00 Salaries $260.00 $2,451.00 $2,300.00 106.57 %($151.00) 001-000-160-521-10-46-00 Insurance $3,720.05 $3,766.81 $3,200.00 117.71 %($566.81) 001-000-160-521-10-49-00 Miscellaneous $0.00 $353.38 $100.00 353.38 %($253.38) Total Civil Service $3,980.05 $6,571.19 $5,600.00 117.34 %($971.19) Central Services 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $200.49 $2,159.65 $1,800.00 119.98 %($359.65) 001-000-180-518-30-35-00 Small Tools & Equipment $55.17 $6,790.32 $10,000.00 67.90 %$3,209.68 001-000-180-518-30-41-00 Professional Services $3,424.34 $15,762.97 $15,000.00 105.09 %($762.97) 14 of 24 Account Number Title Period Fiscal Budget % of Total Balance 001-000-180-518-30-41-01 Contracted Custodial Services $2,206.13 $26,488.93 $20,000.00 132.44 %($6,488.93) 001-000-180-518-30-41-05 Security Services $0.00 $2,844.95 $0.00 ($2,844.95) 001-000-180-518-30-46-00 Insurance $41,372.63 $41,382.71 $35,500.00 116.57 %($5,882.71) 001-000-180-518-30-47-00 Utilities $2,823.59 $23,266.22 $22,500.00 103.41 %($766.22) 001-000-180-518-30-48-00 Repairs & Maintenance $2,070.46 $8,036.85 $12,000.00 66.97 %$3,963.15 001-000-180-518-30-49-00 Miscellaneous $306.59 $749.32 $2,000.00 37.47 %$1,250.68 001-000-180-518-30-49-01 Landscaping $0.00 $1,208.61 $14,000.00 8.63 %$12,791.39 001-000-180-518-61-41-00 Judgements & Settlements $0.00 $28,439.39 $0.00 ($28,439.39) 001-000-180-518-92-20-00 Ancillary (interfund maintenance)$1,983.41 $12,910.26 $5,000.00 258.21 %($7,910.26) 001-000-180-594-18-60-00 Capital Outlay $55,195.13 $95,586.84 $100,000.00 95.59 %$4,413.16 Total Central Services $109,637.94 $265,627.02 $237,800.00 111.70 %($27,827.02) Law Enforcement 001-000-210-521-10-10-00 Salaries $166,459.08 $2,022,088.39 $2,074,000.00 97.50 %$51,911.61 001-000-210-521-10-10-02 Overtime Salaries $8,183.22 $134,639.82 $100,000.00 134.64 %($34,639.82) 001-000-210-521-10-10-03 Overtime Salaries-Traf Control $818.69 $6,299.16 $8,000.00 78.74 %$1,700.84 001-000-210-521-10-20-00 Benefits $59,344.63 $755,888.67 $795,000.00 95.08 %$39,111.33 001-000-210-521-10-20-01 Clothing Allowance $4,266.11 $13,922.49 $14,400.00 96.68 %$477.51 001-000-210-521-10-25-00 Tuition Reimbursement $0.00 $2,600.00 $0.00 ($2,600.00) 001-000-210-521-10-31-00 Office Supplies $0.00 $6,101.58 $6,000.00 101.69 %($101.58) 001-000-210-521-10-31-05 Office Machine Costs $0.00 $3,191.06 $4,000.00 79.78 %$808.94 001-000-210-521-10-32-00 Fuel Consumed $8,443.74 $51,461.55 $40,000.00 128.65 %($11,461.55) 001-000-210-521-10-35-00 Small Tools & Equipment $415.08 $13,143.00 $13,000.00 101.10 %($143.00) 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 $2,712.03 $4,000.00 67.80 %$1,287.97 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,937.52 $13,923.22 $14,000.00 99.45 %$76.78 001-000-210-521-10-42-01 Telephone $3,607.86 $25,020.48 $33,000.00 75.82 %$7,979.52 001-000-210-521-10-42-03 Postage $271.79 $1,267.96 $850.00 149.17 %($417.96) 001-000-210-521-10-43-00 Travel $420.38 $19,787.39 $15,000.00 131.92 %($4,787.39) 001-000-210-521-10-44-00 Advertising $0.00 $0.00 $2,500.00 0.00 %$2,500.00 001-000-210-521-10-46-00 Insurance $80,142.09 $83,806.33 $68,200.00 122.88 %($15,606.33) 001-000-210-521-10-48-00 Repairs & Maintenance $746.66 $4,413.92 $8,000.00 55.17 %$3,586.08 001-000-210-521-10-49-00 Miscellaneous $662.38 $2,722.02 $4,500.00 60.49 %$1,777.98 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 $34.57 $944.27 $1,500.00 62.95 %$555.73 001-000-210-521-30-40-00 Crime Prevention $0.00 $491.31 $750.00 65.51 %$258.69 001-000-210-521-40-22-00 Training-Police Chief $0.00 $450.00 $1,000.00 45.00 %$550.00 001-000-210-521-40-25-00 Training--Officers $0.00 $4,811.50 $4,000.00 120.29 %($811.50) 001-000-210-521-40-27-00 Training--Office Staff $0.00 $364.99 $800.00 45.62 %$435.01 001-000-210-521-40-30-00 Training - Recruits-Academy $0.00 $5,266.89 $9,600.00 54.86 %$4,333.11 001-000-210-521-50-10-00 Ancillary (interfund vehicle maintenance) $0.00 $1,749.30 $2,000.00 87.47 %$250.70 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 $12,388.02 $36,263.82 $36,000.00 100.73 %($263.82) Total Law Enforcement $348,141.82 $3,213,331.15 $3,267,600.00 98.34 %$54,268.85 15 of 24 Account Number Title Period Fiscal Budget % of Total Balance Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $46,368.00 $262,816.02 $300,000.00 87.61 %$37,183.98 001-000-230-523-60-20-00 Medical Care For Prisoners $0.00 $8,136.91 $12,000.00 67.81 %$3,863.09 001-000-230-527-60-30-00 Juvenile Detention $1,080.00 $13,080.00 $5,000.00 261.60 %($8,080.00) Total Jail Services $47,448.00 $284,032.93 $317,000.00 89.60 %$32,967.07 Public Works 001-000-315-542-10-10-00 Salaries $5,958.37 $35,515.00 $90,000.00 39.46 %$54,485.00 001-000-315-542-10-20-00 Benefits $2,986.20 $18,421.32 $29,000.00 63.52 %$10,578.68 001-000-315-542-10-31-00 Office Supplies $242.00 $242.00 $0.00 ($242.00) 001-000-315-542-10-35-00 Small Tools & Equipment $0.00 $74.21 $100.00 74.21 %$25.79 001-000-315-542-10-43-00 Travel $0.00 $58.56 $0.00 ($58.56) 001-000-315-542-10-46-00 Insurance $8,166.07 $8,212.83 $7,000.00 117.33 %($1,212.83) 001-000-315-542-10-49-00 Training $0.00 $849.00 $0.00 ($849.00) 001-000-315-544-20-45-00 Engineering Support Services $807.84 $13,585.17 $15,000.00 90.57 %$1,414.83 Total Public Works $18,160.48 $76,958.09 $141,100.00 54.54 %$64,141.91 Planning 001-000-580-558-60-10-00 Salaries $11,918.53 $140,015.83 $157,100.00 89.13 %$17,084.17 001-000-580-558-60-20-00 Benefits $4,365.82 $49,319.49 $51,200.00 96.33 %$1,880.51 001-000-580-558-60-31-00 Office Supplies $689.48 $1,865.62 $650.00 287.02 %($1,215.62) 001-000-580-558-60-32-00 Fuel Consumed $26.85 $175.66 $125.00 140.53 %($50.66) 001-000-580-558-60-35-00 Small Tools & Equipment $0.00 $43.23 $100.00 43.23 %$56.77 001-000-580-558-60-40-00 Training $150.00 $699.00 $1,500.00 46.60 %$801.00 001-000-580-558-60-41-00 Professional Services $0.00 $5,150.00 $12,000.00 42.92 %$6,850.00 001-000-580-558-60-41-01 Hearings Examiner $0.00 $0.00 $450.00 0.00 %$450.00 001-000-580-558-60-41-02 Engineer/architect Services $200.00 $917.00 $1,200.00 76.42 %$283.00 001-000-580-558-60-43-00 Travel $374.93 $772.67 $1,500.00 51.51 %$727.33 001-000-580-558-60-44-00 Advertising $173.40 $2,099.64 $1,800.00 116.65 %($299.64) 001-000-580-558-60-46-00 Insurance $8,675.10 $8,768.62 $7,400.00 118.49 %($1,368.62) 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 $947.18 $1,400.00 67.66 %$452.82 Total Planning $26,574.11 $210,817.22 $236,525.00 89.13 %$25,707.78 Code Compliance 001-000-590-558-50-10-00 Salaries $7,167.94 $97,015.00 $100,900.00 96.15 %$3,885.00 001-000-590-558-50-20-00 Benefits $3,889.93 $49,700.27 $46,700.00 106.42 %($3,000.27) 001-000-590-558-50-31-00 Office Supplies $226.31 $295.87 $400.00 73.97 %$104.13 001-000-590-558-50-32-00 Fuel Consumed $37.77 $486.13 $300.00 162.04 %($186.13) 001-000-590-558-50-40-00 Training $0.00 $0.00 $500.00 0.00 %$500.00 001-000-590-558-50-41-01 Fire Marshal Services $5,090.49 $19,722.96 $20,064.00 98.30 %$341.04 001-000-590-558-50-46-00 Insurance $5,696.06 $5,742.82 $4,900.00 117.20 %($842.82) 001-000-590-558-50-48-00 Repairs & Maintenance $0.00 $0.00 $100.00 0.00 %$100.00 001-000-590-558-50-49-00 Miscellaneous $0.00 $95.00 $300.00 31.67 %$205.00 Total Code Compliance $22,108.50 $173,058.05 $174,164.00 99.36 %$1,105.95 Other Expenditures 001-001-000-589-30-00-03 Fireworks-Cleaning Deposit Ref $0.00 $2,500.00 $800.00 312.50 %($1,700.00) 001-001-000-589-30-00-04 Fireworks - Dcfd Remittance $0.00 $0.00 $200.00 0.00 %$200.00 16 of 24 Account Number Title Period Fiscal Budget % of Total Balance 001-001-000-589-30-00-05 County Share of Crime Victims $0.00 $3,013.23 $3,000.00 100.44 %($13.23) 001-001-000-589-30-00-10 Remittance: State Bldg Code Surcharge $20.08 ($17.34)$350.00 -4.95 %$367.34 001-001-000-589-30-00-15 State Share of Permits & Licenses $672.00 $12,481.00 $10,000.00 124.81 %($2,481.00) 001-001-000-589-30-00-20 Court Remittances $22,693.97 $207,721.06 $195,000.00 106.52 %($12,721.06) Total Other Expenditures $23,386.05 $225,697.95 $209,350.00 107.81 %($16,347.95) Total General Fund $806,420.43 $6,939,048.65 $6,850,221.00 101.30 %($88,827.65) Street Fund Storm Water Administration 101-000-311-542-42-10-00 SWU Administration - Salaries $1,639.96 $5,367.09 $8,500.00 63.14 %$3,132.91 101-000-311-542-42-20-00 SWU Administration - Benefits $582.78 $2,649.87 $4,200.00 63.09 %$1,550.13 101-000-311-542-42-31-00 SWU Administration - DC Annual Billing Fee $0.00 $6,705.12 $7,000.00 95.79 %$294.88 Total Storm Water Administration $2,222.74 $14,722.08 $19,700.00 74.73 %$4,977.92 NPDES 101-000-313-542-42-10-00 NPDES Maintenance Salaries $2,543.92 $81,727.25 $65,000.00 125.73 %($16,727.25) 101-000-313-542-42-10-10 NPDES Sweeping Salaries $483.78 $11,798.11 $15,000.00 78.65 %$3,201.89 101-000-313-542-42-20-00 NPDES Maintenance Benefits $1,390.84 $45,364.63 $35,000.00 129.61 %($10,364.63) 101-000-313-542-42-20-10 NPDES Sweeping Benefits $392.33 $6,805.02 $7,400.00 91.96 %$594.98 101-000-313-542-42-30-00 NPDES Supplies $1,021.06 $44,515.40 $42,000.00 105.99 %($2,515.40) 101-000-313-542-42-31-10 NPDES GIS System License $0.00 $1,082.00 $1,000.00 108.20 %($82.00) 101-000-313-542-42-35-00 NPDES Small Tools & Equipment $0.00 $40.95 $0.00 ($40.95) 101-000-313-542-42-40-00 NPDES Training $3,093.71 $11,896.90 $1,000.00 1,189.69 %($10,896.90) 101-000-313-542-42-40-01 NPDES DOE Annual Permit $0.00 $4,686.28 $5,000.00 93.73 %$313.72 101-000-313-542-42-40-02 NPDES Equipment Rental $0.00 $6,767.91 $15,000.00 45.12 %$8,232.09 101-000-313-542-42-45-00 NPDES Travel $14.00 $2,080.19 $1,500.00 138.68 %($580.19) 101-000-313-542-42-47-00 NPDES Utilities $86.09 $1,966.74 $1,000.00 196.67 %($966.74) 101-000-313-542-42-48-00 NPDES Equipment Repair & Maintenance $1,137.89 $6,281.09 $10,000.00 62.81 %$3,718.91 101-000-313-542-42-49-00 NPDES Miscellaneous Expense $16.25 $718.41 $3,500.00 20.53 %$2,781.59 101-000-313-594-31-60-00 NPDES Equipment Spraying $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total NPDES $10,179.87 $225,730.88 $207,400.00 108.84 %($18,330.88) Storm Water Utility Charge 101-000-315-542-41-47-00 Annual GEWSWU Utility Charge $0.00 $146,655.00 $164,347.00 89.23 %$17,692.00 Total Storm Water Utility Charge $0.00 $146,655.00 $164,347.00 89.23 %$17,692.00 101-000-420-542-30-10-00 Salaries -Roadway $1,119.47 $35,014.09 $35,000.00 100.04 %($14.09) 101-000-420-542-30-20-00 Benefits $721.15 $18,645.67 $19,000.00 98.14 %$354.33 101-000-420-542-30-30-00 Supplies $90.28 $32,145.62 $25,000.00 128.58 %($7,145.62) 101-000-420-542-30-48-00 Repairs & Maintenance $13.91 $211.85 $7,500.00 2.82 %$7,288.15 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $1,982.59 $2,500.00 79.30 %$517.41 101-000-420-542-61-20-00 Benefits $0.00 $925.93 $1,300.00 71.23 %$374.07 101-000-420-542-61-30-00 Supplies $8.23 $530.45 $2,000.00 26.52 %$1,469.55 101-000-420-542-61-48-00 Repairs & Maintenance $0.00 $84.00 $2,500.00 3.36 %$2,416.00 101-000-420-542-62-10-00 Salaries - Special Purpose Paths $0.00 $130.42 $1,500.00 8.69 %$1,369.58 101-000-420-542-62-20-00 Benefits $0.00 $505.85 $800.00 63.23 %$294.15 17 of 24 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-62-30-00 Supplies $359.91 $1,563.57 $2,000.00 78.18 %$436.43 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-62-48-00 Repair & Maintenance $1,986.47 $1,986.47 $0.00 ($1,986.47) 101-000-420-542-63-10-00 Salaries - Street Lighting $68.71 $1,499.04 $2,000.00 74.95 %$500.96 101-000-420-542-63-20-00 Benefits $13.87 $994.20 $1,100.00 90.38 %$105.80 101-000-420-542-63-30-00 Supplies $0.00 $291.58 $500.00 58.32 %$208.42 101-000-420-542-63-47-00 Utilities $5,677.00 $35,659.00 $39,000.00 91.43 %$3,341.00 101-000-420-542-63-48-00 Repairs & Maintenance $0.00 $6,357.57 $1,000.00 635.76 %($5,357.57) 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $594.85 $30,561.23 $40,000.00 76.40 %$9,438.77 101-000-420-542-64-20-00 Benefits $449.86 $17,488.61 $23,000.00 76.04 %$5,511.39 101-000-420-542-64-30-00 Supplies $113.76 $36,335.99 $55,000.00 66.07 %$18,664.01 101-000-420-542-64-47-00 Utilities $873.45 $7,492.30 $9,000.00 83.25 %$1,507.70 101-000-420-542-64-48-00 Repairs & Maintenance $5,701.03 $6,501.62 $20,000.00 32.51 %$13,498.38 101-000-420-542-64-49-00 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-65-10-00 Salaries - Parking Facilities $0.00 $204.27 $2,000.00 10.21 %$1,795.73 101-000-420-542-65-20-00 Benefits $0.00 $95.27 $1,200.00 7.94 %$1,104.73 101-000-420-542-65-30-00 Supplies $0.00 $144.84 $300.00 48.28 %$155.16 101-000-420-542-65-47-00 Utilities $0.00 $225.00 $500.00 45.00 %$275.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $2,637.13 $15,328.54 $65,000.00 23.58 %$49,671.46 101-000-420-542-66-20-00 Benefits $1,594.48 $7,032.74 $34,000.00 20.68 %$26,967.26 101-000-420-542-66-30-00 Supplies $7,497.74 $69,002.39 $100,000.00 69.00 %$30,997.61 101-000-420-542-66-48-00 Repairs & Maintenance $2,827.87 $5,218.26 $6,000.00 86.97 %$781.74 101-000-420-542-69-10-00 Salaries - Flags/Banners $0.00 $7,532.96 $18,000.00 41.85 %$10,467.04 101-000-420-542-69-20-00 Benefits $0.00 $3,041.87 $10,000.00 30.42 %$6,958.13 101-000-420-542-69-30-00 Supplies $229.70 $911.84 $2,500.00 36.47 %$1,588.16 101-000-420-542-70-10-00 Salaries - Roadside $21,894.54 $195,988.94 $125,000.00 156.79 %($70,988.94) 101-000-420-542-70-20-00 Benefits $13,661.42 $110,884.83 $68,000.00 163.07 %($42,884.83) 101-000-420-542-70-30-00 Supplies $359.75 $4,275.19 $5,000.00 85.50 %$724.81 101-000-420-542-70-47-00 Utilities $0.00 $865.60 $1,000.00 86.56 %$134.40 101-000-420-542-70-48-00 Repairs & Maintenance $0.00 $156.83 $1,000.00 15.68 %$843.17 101-000-420-542-70-49-00 Miscellaneous $0.00 $33.00 $1,000.00 3.30 %$967.00 101-000-420-542-75-10-00 Salaries - City Parks $4,430.64 $44,029.43 $60,000.00 73.38 %$15,970.57 101-000-420-542-75-20-00 Benefits $2,027.50 $24,334.97 $37,000.00 65.77 %$12,665.03 101-000-420-542-75-30-00 Supplies $457.68 $8,404.23 $20,000.00 42.02 %$11,595.77 101-000-420-542-75-47-00 Utilities $345.32 $5,140.93 $3,000.00 171.36 %($2,140.93) 101-000-420-542-75-48-00 Repairs & Maintenance $341.89 $3,023.45 $3,000.00 100.78 %($23.45) 101-000-420-542-80-48-00 Maint Agmt - Japanese Gdn $2,000.00 $18,000.00 $18,000.00 100.00 %$0.00 101-000-420-542-90-10-00 Salaries - Maintenance Admin $0.00 $152.31 $13,000.00 1.17 %$12,847.69 101-000-420-542-90-20-00 Benefits $0.00 $486.71 $7,500.00 6.49 %$7,013.29 101-000-430-543-30-10-00 Salaries $1,088.35 $43,840.88 $50,000.00 87.68 %$6,159.12 101-000-430-543-30-20-00 Benefits $500.37 $20,719.68 $13,500.00 153.48 %($7,219.68) 101-000-430-543-30-30-00 Supplies $1,186.51 $7,623.42 $6,000.00 127.06 %($1,623.42) 101-000-430-543-30-46-00 Insurance $59,203.71 $59,684.99 $45,600.00 130.89 %($14,084.99) 101-000-430-543-30-49-00 Miscellaneous $102.00 $1,349.71 $3,000.00 44.99 %$1,650.29 101-000-430-543-50-10-00 Salaries - Facilities $235.54 $1,136.86 $6,000.00 18.95 %$4,863.14 101-000-430-543-50-20-00 Benefits $41.70 $943.77 $3,500.00 26.96 %$2,556.23 18 of 24 Account Number Title Period Fiscal Budget % of Total Balance 101-000-430-543-50-30-00 Supplies $132.85 $2,070.91 $2,000.00 103.55 %($70.91) 101-000-430-543-50-47-00 Utilities $1,023.61 $5,097.57 $6,000.00 84.96 %$902.43 101-000-430-543-50-48-00 Repairs & Maintenance $0.00 $541.45 $2,500.00 21.66 %$1,958.55 101-000-430-543-50-49-00 Miscellaneous $0.00 $157.50 $500.00 31.50 %$342.50 101-000-430-544-90-10-00 Salaries - Training $0.00 $2,583.70 $2,000.00 129.19 %($583.70) 101-000-430-544-90-20-00 Benefits $0.00 $1,255.05 $1,100.00 114.10 %($155.05) 101-000-430-544-90-30-00 Supplies $20.96 $20.96 $1,000.00 2.10 %$979.04 101-000-430-544-90-35-00 Travel - Training $0.00 $880.49 $1,000.00 88.05 %$119.51 101-000-430-544-90-49-01 Training Miscellaneous $0.00 $1,262.00 $1,000.00 126.20 %($262.00) Total Street Fund $154,035.82 $1,310,698.95 $1,441,847.00 90.90 %$131,148.05 Community Development Grants Fund 102-000-000-558-70-10-00 CDBG Salaries $0.00 $0.00 $4,000.00 0.00 %$4,000.00 102-000-000-558-70-20-00 CDBG Benefits $0.00 $0.00 $1,240.00 0.00 %$1,240.00 102-000-000-558-70-41-00 CDBG Professional Services $0.00 $0.00 $23,800.00 0.00 %$23,800.00 102-000-000-558-70-44-00 CDBG Advertising $329.46 $1,267.89 $2,000.00 63.39 %$732.11 102-000-000-558-70-49-00 CDBG Miscellaneous $0.00 $532.73 $1,000.00 53.27 %$467.27 Total Community Development Grants Fund $329.46 $1,800.62 $32,040.00 5.62 %$30,239.38 Transportation Benefit District Fund 105-000-000-597-91-00-00 Transfer Out - Fund 301 Project Expenditures $0.00 $197,335.00 $197,335.00 100.00 %$0.00 Total Transportation Benefit District Fund $0.00 $197,335.00 $197,335.00 100.00 %$0.00 Library Fund 112-000-000-572-50-41-00 Facilities -- Professional Services $0.00 $1,026.82 $3,200.00 32.09 %$2,173.18 112-000-000-572-50-47-00 Facilities--Utilities $353.61 $2,503.23 $1,800.00 139.07 %($703.23) 112-000-000-572-50-48-00 Facilities--Repairs & Maintenance $36.00 $36.00 $0.00 ($36.00) 112-000-000-572-50-49-00 Facilities--Supplies & Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Library Fund $389.61 $3,566.05 $5,100.00 69.92 %$1,533.95 Hotel/Motel Tax Fund 113-000-000-557-30-41-10 Contributions to Other Entities $0.00 $12,500.00 $14,500.00 86.21 %$2,000.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $9,273.00 $64,911.00 $64,911.00 100.00 %$0.00 Total Hotel/Motel Tax Fund $9,273.00 $77,411.00 $79,411.00 97.48 %$2,000.00 Drug Fund 114-000-000-521-10-35-00 Small Tools & Equipment $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Drug Fund $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Events Board Fund 117-000-050-557-30-10-00 Eweb Salaries $1,184.35 $14,749.74 $12,000.00 122.91 %($2,749.74) 117-000-050-557-30-20-00 Eweb Benefits $480.94 $5,485.27 $5,600.00 97.95 %$114.73 117-000-050-557-30-30-00 Contract Services $7,150.57 $85,806.84 $85,900.00 99.89 %$93.16 117-000-100-518-63-40-00 Tourism Promotion Grant - Miss Veedol Video $0.00 $6,000.00 $0.00 ($6,000.00) 117-000-100-557-30-25-00 Marketing - Regional Tourism $0.00 $1,050.00 $2,000.00 52.50 %$950.00 117-000-100-557-30-32-00 Eweb Fuel Consumed $0.00 $0.00 $100.00 0.00 %$100.00 117-000-100-557-30-35-00 Eweb Small Tools & Equipment $0.00 $19.46 $100.00 19.46 %$80.54 117-000-100-557-30-49-00 Eweb Miscellaneous $0.00 $224.76 $100.00 224.76 %($124.76) 19 of 24 Account Number Title Period Fiscal Budget % of Total Balance 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 $2,574.76 $4,600.00 55.97 %$2,025.24 117-000-115-557-30-31-05 Eweb Office Supplies $0.00 $1,234.26 $1,000.00 123.43 %($234.26) 117-000-200-557-30-35-02 Easter Small Tools & Equipmen $0.00 $151.87 $200.00 75.94 %$48.13 117-000-200-557-30-44-02 Easter Advertising $0.00 $152.00 $350.00 43.43 %$198.00 117-000-200-557-30-46-02 Easter Office Supplies $0.00 $87.81 $0.00 ($87.81) 117-000-200-557-30-49-02 Easter Miscellaneous $0.00 $981.87 $1,500.00 65.46 %$518.13 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,956.29 $4,800.00 103.26 %($156.29) 117-000-300-557-30-35-12 Classy Chassis Small Tools & Equipment $23.79 $583.07 $1,000.00 58.31 %$416.93 117-000-300-557-30-41-12 CC Professional Services $0.00 $4,248.40 $4,500.00 94.41 %$251.60 117-000-300-557-30-42-14 Classy Chassis Postage $0.00 $1,466.32 $1,500.00 97.75 %$33.68 117-000-300-557-30-43-12 CC EMPD Facility Fee $0.00 $0.00 $1,100.00 0.00 %$1,100.00 117-000-300-557-30-44-12 Classy Chassis Advertising $0.00 $4,233.56 $4,500.00 94.08 %$266.44 117-000-300-557-30-49-12 Classy Chassis Miscellaneous $0.00 $716.18 $1,000.00 71.62 %$283.82 117-000-400-557-30-34-11 W&W Event Merch For Resale $0.00 $2,669.91 $3,500.00 76.28 %$830.09 117-000-400-557-30-35-11 W & W Small Tools & Equipment $0.00 $806.61 $3,000.00 26.89 %$2,193.39 117-000-400-557-30-41-00 W & W Professional Services $0.00 $1,924.00 $2,750.00 69.96 %$826.00 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 $1,000.00 $1,100.00 90.91 %$100.00 117-000-400-557-30-44-11 Wings & Wheels Advertising $0.00 $8,741.72 $8,000.00 109.27 %($741.72) 117-000-400-557-30-44-15 W&W Sponsored Car Show Prizes $0.00 $3,020.96 $1,000.00 302.10 %($2,020.96) 117-000-400-557-30-49-11 Wings & Wheels Miscellaneous $0.00 $2,307.10 $1,000.00 230.71 %($1,307.10) 117-000-400-557-30-49-12 Wings & Wheels Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 117-000-400-557-30-49-13 W&W Schedule of Events Brochur $0.00 $4,156.72 $3,500.00 118.76 %($656.72) 117-000-450-557-30-41-00 PPU Professional Services $0.00 $738.44 $1,000.00 73.84 %$261.56 117-000-450-557-30-41-11 PkwyPile-up Event Merchandise $0.00 ($60.00)$0.00 $60.00 117-000-450-557-30-44-12 PkwyPile-up Car Show Advertising $0.00 $2,265.29 $1,000.00 226.53 %($1,265.29) 117-000-450-557-30-49-01 PkwyPile-up Car Show Miscellaneous $0.00 $443.71 $1,200.00 36.98 %$756.29 117-000-500-557-30-35-01 Christmas Small Tools & Equip $160.85 $341.79 $400.00 85.45 %$58.21 117-000-500-557-30-40-05 Christmas Events & Decorations $1,172.79 $1,821.98 $1,500.00 121.47 %($321.98) 117-000-500-557-30-44-01 Christmas Advertising $1,315.00 $1,413.00 $1,500.00 94.20 %$87.00 117-000-500-557-30-49-01 Christmas Miscellaneous $1,081.15 $1,338.88 $800.00 167.36 %($538.88) Total Events Board Fund $12,569.44 $167,652.57 $164,500.00 101.92 %($3,152.57) Bond Redemption Fund 202-000-000-591-95-71-05 Redemption of PWTFL Debt $0.00 $29,712.48 $29,712.00 100.00 %($0.48) 202-000-000-592-95-89-05 Interest Exp PWTFL Debt $0.00 $891.37 $891.00 100.04 %($0.37) Total Bond Redemption Fund $0.00 $30,603.85 $30,603.00 100.00 %($0.85) Street Improvements Fund 301-000-000-595-10-40-00 2019 TBD Residential Project Design $6,174.50 $13,675.25 $30,000.00 45.58 %$16,324.75 301-000-000-595-10-50-37 Design -S. Kentucky & 5th St NE.$0.00 $61,702.08 $62,455.00 98.79 %$752.92 301-000-000-595-10-51-12 Design - Relight WA Install $0.00 $3,769.14 $5,000.00 75.38 %$1,230.86 301-000-000-595-20-50-16 ROW - Baker Ave 15th to 20th Project $0.00 $33,871.92 $35,000.00 96.78 %$1,128.08 301-000-000-595-30-40-05 Roadway- Baker 15th- 20th TIB $0.00 $34,899.40 $0.00 ($34,899.40) 20 of 24 Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-595-30-40-20 Roadway - Highline Drive TIB $0.00 $41,000.00 $40,000.00 102.50 %($1,000.00) 301-000-000-595-30-40-32 5th Str Sidewalks & SWU- EWWD $0.00 $541.00 $0.00 ($541.00) 301-000-000-595-30-40-34 5th Str Sidewalks & SWU - DCSD $0.00 $1,406.60 $2,000.00 70.33 %$593.40 301-000-000-595-30-40-40 VMP Tfc Signal Controller $0.00 $24,680.65 $25,000.00 98.72 %$319.35 301-000-000-595-30-50-22 Roadway - Baker Ave 15th to 20th Project $0.00 $0.00 $42,000.00 0.00 %$42,000.00 301-000-000-595-30-50-27 TBD Residential Project $0.00 $162,855.00 $197,335.00 82.53 %$34,480.00 301-000-000-595-30-50-37 SDC - S. Kentucky & 5th St. NE $3,548.70 $38,487.63 $49,975.00 77.01 %$11,487.37 301-000-000-595-30-51-04 5th Street Sidewalks & SWU $0.00 $220,463.01 $272,680.00 80.85 %$52,216.99 301-000-000-595-30-51-07 Roadway-S. Kentucky & 5th St NE $0.00 $546,065.03 $564,500.00 96.73 %$18,434.97 301-000-000-595-30-52-12 SDC - Baker Ave 15th to 20th TIB $0.00 $2,782.03 $10,000.00 27.82 %$7,217.97 301-000-000-595-30-52-18 SDC - Highline Drive - TIB $0.00 $9,900.77 $12,000.00 82.51 %$2,099.23 301-000-000-595-40-45-00 Materials - Relight WA Project $0.00 $0.00 $53,150.00 0.00 %$53,150.00 301-000-000-595-50-30-38 SDC - 5th St Sidewalks & SWU $0.00 $36,593.98 $35,000.00 104.55 %($1,593.98) 301-000-000-595-50-49-10 Installation - Relight WA Project $12,885.05 $134,393.67 $131,250.00 102.40 %($3,143.67) Total Street Improvements Fund $22,608.25 $1,367,087.16 $1,567,345.00 87.22 %$200,257.84 Storm Water Improvements Fund 308-000-000-595-40-63-00 SWA Small Improvement Projects $0.00 $4,999.86 $5,000.00 100.00 %$0.14 308-000-000-595-40-63-39 19th St. NW Design SWU DOE $0.00 $0.00 $125,000.00 0.00 %$125,000.00 308-000-312-595-40-10-00 Salaries - SWA Improvement Projects $0.00 $1,742.49 $0.00 ($1,742.49) 308-000-312-595-40-20-00 Benefits - SWA Improvement Projects $0.00 $487.15 $0.00 ($487.15) 308-000-314-595-40-12-00 Salaries - Astor Court Project $0.00 $30.28 $500.00 6.06 %$469.72 308-000-314-595-40-13-00 Salaries - Ashland Court Project $0.00 $30.28 $500.00 6.06 %$469.72 308-000-314-595-40-22-00 Benefits - Astor Court Project $0.00 $15.40 $250.00 6.16 %$234.60 308-000-314-595-40-23-00 Benefits - Ashland Avenue Project $0.00 $15.40 $250.00 6.16 %$234.60 308-000-314-595-40-30-00 Engineering - Astor Court Project $0.00 $794.25 $0.00 ($794.25) 308-000-314-595-40-30-05 SDC - Astor Court Project $0.00 $0.00 $4,500.00 0.00 %$4,500.00 308-000-314-595-40-30-10 Construction - Astor Court Project $0.00 $54,793.88 $52,000.00 105.37 %($2,793.88) 308-000-314-595-40-30-15 Engineering - Ashland Avenue Project $0.00 $794.25 $0.00 ($794.25) 308-000-314-595-40-30-20 SDC - Ashland Avenue Project $0.00 $0.00 $4,500.00 0.00 %$4,500.00 308-000-314-595-40-30-25 Construction - Ashland Avenue Project $0.00 $54,793.87 $52,000.00 105.37 %($2,793.87) Total Storm Water Improvements Fund $0.00 $118,497.11 $244,500.00 48.47 %$126,002.89 Capital Improvements Fund 314-000-000-594-22-60-40 Purchase Gateway Property $4,097.25 $4,356.00 $0.00 ($4,356.00) 314-000-000-594-22-60-42 Gateway Property Design & Engr $538.92 $50,704.92 $55,000.00 92.19 %$4,295.08 314-000-000-594-22-60-44 Gateway Property Improvements $0.00 $1,385.00 $2,000.00 69.25 %$615.00 314-000-000-594-22-60-50 Public Works Area Design $0.00 $16,463.00 $22,000.00 74.83 %$5,537.00 314-000-000-594-58-60-00 City Land Purchase - 311 9th St NE $0.00 $1,700.00 $0.00 ($1,700.00) Total Capital Improvements Fund $4,636.17 $74,608.92 $79,000.00 94.44 %$4,391.08 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicles R&M Labor $43.52 $2,758.65 $6,000.00 45.98 %$3,241.35 501-000-000-521-10-20-00 Police Vehicle R&M Benefits $182.85 $1,668.85 $3,000.00 55.63 %$1,331.15 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $6,149.76 $30,627.80 $32,000.00 95.71 %$1,372.20 501-000-000-542-90-10-00 Street Vehicle R&M Labor $2,198.87 $30,362.63 $25,000.00 121.45 %($5,362.63) 501-000-000-542-90-20-00 Street Vehicle R&M Benefits $835.99 $14,633.19 $15,000.00 97.55 %$366.81 21 of 24 Account Number Title Period Fiscal Budget % of Total Balance 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $596.00 $19,565.41 $35,000.00 55.90 %$15,434.59 501-000-000-542-90-48-25 Street Vehicle R&M Supplies $1,378.34 $4,177.94 $4,000.00 104.45 %($177.94) 501-000-000-542-90-48-30 Street Equipment R&M $0.00 $1,582.36 $2,000.00 79.12 %$417.64 501-000-000-558-58-48-00 Admin Vehicle R&M $0.00 $0.00 $1,000.00 0.00 %$1,000.00 501-000-000-594-21-60-00 Capital Outlay - Police Vehicles $0.00 $97,349.75 $98,000.00 99.34 %$650.25 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $0.00 $80,000.00 0.00 %$80,000.00 501-000-000-594-42-60-30 Capital - Street Equipment $0.00 $37,701.79 $40,000.00 94.25 %$2,298.21 501-000-000-594-44-60-20 Capital Outlay - Admin Vehicles $47.75 $30,390.15 $0.00 ($30,390.15) Total Equipment Purchase, Repair & Replacement Fund $11,433.08 $270,818.52 $341,000.00 79.42 %$70,181.48 Grand Totals $1,021,695.26 $10,559,128.40 $11,034,902.00 95.69 %$475,773.60 22 of 24 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $806,420.43 $6,939,048.65 $6,850,221.00 101.30 %($88,827.65) 101-000-000-000-00-00-00 Street Fund $154,035.82 $1,310,698.95 $1,441,847.00 90.90 %$131,148.05 102-000-000-000-00-00-00 Community Development Grants Fund $329.46 $1,800.62 $32,040.00 5.62 %$30,239.38 105-000-000-000-00-00-00 Transportation Benefit District Fund $0.00 $197,335.00 $197,335.00 100.00 %$0.00 112-000-000-000-00-00-00 Library Fund $389.61 $3,566.05 $5,100.00 69.92 %$1,533.95 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $9,273.00 $77,411.00 $79,411.00 97.48 %$2,000.00 114-000-000-000-00-00-00 Drug Fund $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-000-000-00-00-00 Events Board Fund $12,569.44 $167,652.57 $164,500.00 101.92 %($3,152.57) 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $30,603.85 $30,603.00 100.00 %($0.85) 301-000-000-000-00-00-00 Street Improvements Fund $22,608.25 $1,367,087.16 $1,567,345.00 87.22 %$200,257.84 308-000-000-000-00-00-00 Storm Water Improvements Fund $0.00 $118,497.11 $244,500.00 48.47 %$126,002.89 314-000-000-000-00-00-00 Capital Improvements Fund $4,636.17 $74,608.92 $79,000.00 94.44 %$4,391.08 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $11,433.08 $270,818.52 $341,000.00 79.42 %$70,181.48 Grand Totals $1,021,695.26 $10,559,128.40 $11,034,902.00 95.69 %$475,773.60 23 of 24 Beginning Activity Ending Cash In Cash 001 $3,192,390.50 $6,972,550.13 $3,224,638.05 101 $241,993.59 $1,393,564.62 $324,859.26 102 $76,285.13 $3,469.76 $77,954.27 105 $323,201.07 $254,352.43 $379,978.50 110 $330,000.00 $165,000.00 $495,000.00 112 $6,937.80 $7,000.00 $10,371.75 113 $2,810.63 $151,158.99 $76,558.62 114 $915.42 $148.46 $1,063.88 116 $10,166.25 $18,197.40 $28,363.65 117 $166,474.06 $113,905.57 $109,873.73 202 $9,692.04 $30,000.00 $9,088.19 301 $819,665.99 $1,164,564.01 $617,142.84 308 $106,477.57 $127,610.01 $115,590.47 314 $475,877.81 $670,262.24 $1,071,531.13 501 $52,449.96 $350,004.50 $131,635.94 $5,815,337.82 $11,421,788.12 $6,673,650.28 Cash and Investment Activity Period: 2018 - December 2018 Fund Activity Street Fund $1,310,698.95 Out General Fund $6,940,302.58 Community Development Grants Fund $1,800.62 Transportation Benefit District Fund $197,575.00 Financing Reserves Fund $0.00 Library Fund $3,566.05 Hotel/Motel Tax Fund $77,411.00 Drug Fund $0.00 Criminal Justice Fund $0.00 Events Board Fund $170,505.90 Bond Redemption Fund $30,603.85 Street Improvements Fund $1,367,087.16 Storm Water Improvements Fund $118,497.11 Capital Improvements Fund $74,608.92 $10,563,475.66 Equipment Purchase, Repair & R l t F d $270,818.52 24 of 24