Loading...
07 - MAY 2015 FINANCIAL REPORTItem No. 7 memorandum TO: City Council John Godwin, City Manager FROM: Gene Anderson, Finance Director SUBJECT: MAY 2015 FINANCIAL REPORT DATE: June 10, 2015 BACKGROUND: Section 69 (3) of the Paris City Charter requires the Finance Director to submit to the City Council through the City Manager a monthly statement of all receipts and disbursements. The attached report satisfies that requirement. STATUS OF ISSUE: This report updates the City Council on the City's financial activities through the month stated in the subject line. BUDGET: Not affected by this report. RECOMMENDATION: Motion to receive the monthly financial report. City of Paris May 2015 Financial Report Comments Net to Date Comparison of Revenues: 1. The operations and maintenance property tax and related collections are 3.35% more than this time last year. The current tax roll is 95.45% collected vs. 96.53% last year. 2. Sales taxes are up 25.89% over last year due to a one time state audit adjustment. The adjustment added an extra $872,390 to the General Fund and $174,478 to PEDC. Without the audit adjustment, sales taxes for the year would be up compared to last year by 5.51 %. 3. Hotel occupancy taxes are up 7.32% from last year. All hotels are current on their taxes. 4. Franchise fees are up 0.40 %. 5. Permit fees are up 16.93% compared to last year. This amounts to $10,955. 6. Municipal Court fines are 11.88% below last year's collections. 7. Leases & Interest cash flows vary from year to year primarily due to investment maturity dates making it difficult to compare the current and previous year. 8. The Streets & Highways increase was a bookkeeping entry to add some old street assessments to the general ledger. 9. EMS fees are up 13.88 %. 10. General Fund miscellaneous fees /revenues are unpredictable in nature and amount but do occur each year. Variances from one year to the next are not unusual. 11. Recreation fees are up $3,097 or 5.15 %. 12. Total General Fund revenues are 9.70% above last year. This increase is primarily due to increases in sales tax (including the state audit adjustment discussed above), current taxes, and EMS fees. Year to date receipts are 80.51% of the budget with the City being 66.66% through the budget year. 13. Total General Fund expenditures are down 1.21% compared to last year. General Fund expenditures to date equal 68.51% of budget with the City being 66.66% through the budget year. 14. Sewer revenue is up 2.47% compared to last year. 15. Water revenue is down 1.33% compared to last year due in large part to the mild weather in September and October. 16. Total Water & Sewer revenues are 0.49% above last year and equal 63.96% of budget which is below the 66.66% budget to date percentage. 17. Total Water & Sewer expenses are 2.32% below last year at this point in time and represent 44.24% of the total budget (47.72% adjusted for debt) while the City is 66.66% through the budget year. Departmental Expenditure Summary: At this point the City is eight months or 66.66% through the budget year. It is important to remember that expenditures do not occur equally throughout the year. For example, capital expenditures and association memberships are one time expenditures that if made early in the fiscal year can produce a distorted expenditure percentage. Within the General and Water & Sewer Funds there are eleven departments whose expenditures are over 66.66% at this time. 1. City Council- 76.94 %. The overage amounts to $7,689 and is due to public notices, membership dues, election expense, and work authorized by the Council to solve some downtown electrical line problems. Work performed by Oncor. 2. City Manager- 67.85 %. The overage amounts to 4,327 and is due to the annual insurance payment, phone expense, membership dues, utility costs, building maintenance, and IT expense. 3. Police- 70.97 %. The overage amounts to $243,141 and is due to the annual insurance payment, the emergency notification service, publications, utilities, maintenance agreements, building maintenance, and the purchase of vehicles. 4. Fire - 71.04 %. The overage amounts to $188,992 and is due to the annual insurance payment, building & equipment maintenance, overtime, training, utilities, demolition costs, and contract services. 5. Public Works- 82.05 %. The overage amounts to $25,230 and is due to office supplies, phone expense, publications, building maintenance and insurance payments. 6. Streets - 67.73 %. The overage amounts to $16,246 and is due to the annual insurance payment, temp employees, contract services, sidewalks, and equipment maintenance. 7. EMS - 76.21 %. The overage amounts to $215,581 and is due to overtime, equipment maintenance, office supplies, postage, utilities, ambulance purchase, medical supplies, and the annual insurance payment. 8. Cox Field- 69.20 %. The overage amounts to $2,914 and is due to the annual insurance payment, electricity, and radio maintenance. 9. Library - 67.85 %. The overage amounts to $8,048 and is due to the annual insurance payment, postage, technical processing, and utilities. 10. General Expenses- 74.99 %. The overage amounts to $130,589 and is due to the purchase of equipment, increased hotel tax payments, and the annual payments to the non - profit agencies. 11. Lift Stations - 67.98 %. The overage amounts to $5,542 and is due to overtime, wearing apparel, annual insurance payment, buildings & grounds maintenance, and equipment maintenance. General comments to the City Council: 1. Over 99% of all of the City operational activity takes place in the General Fund or the Water and Sewer Fund. The other funds are special purpose funds with limited activity and usually with legal restrictions on what their money can be spent on. For that reason, I normally only comment on the activity of the General Fund and Water & Sewer Fund. However, if it were needed, I would make comment on activity in one of the other funds. 2. 1 try to anticipate questions you might have about the report and comment on those points. After you receive your packet and review the monthly report, if you have questions about the report, please let the Manager know (or me if you can't reach the Manager) before the Council meeting if possible in case I have to research the answer to your question. That does not prevent you from asking the question at the meeting if you wish to make a point, but it does help prevent questions coming up that I can't answer on the spot and possibly delaying the Council in making a decision. 3. The activity of the Paris Economic Development Corporation is reflected in the monthly report. This is a result of the City performing the bookkeeping functions for this agency. PEDC has its own managing board. Year to Date Comparison May, 2015 Current Year Previous Year Net to Date General Fund Taxes Collected 5,995,728.97 5,801,150.47 194,578.50 Sales Tax 5,387,132.39 4,278,919.28 1,108,213.11 Hotel -Motel Tax 425,985.92 396,930.24 29,055.68 Franchise Fees 2,116,610.81 2,107,981.76 8,629.05 Permits 75,646.39 64,690.90 10,955.49 Court Fines 229,791.10 260,796.03 (31,004.93) Leases & Interest 85,590.57 104,831.80 (19,241.23) Fees & Copies 7,036.52 6,857.76 178.76 Streets & Highways 26,472.83 0.00 26,472.83 Sanitation Fees 973,657.86 973,718.07 (60.21) EMS Fees 1,607,710.22 1,411,652.71 196,057.51 Mixed Beverage Tax 40,929.01 40,116.60 812.41 Miscellaneous Fees 232,917.74 1751422.82 57,494.92 Water & Sewer Transfer 583,333.28 583,333.28 0.00 Recreation Programs 57,017.45 60,114.80 (3,097.35) General Fund Total Revenues 17,845,561.06 16,266,516.52 1,579,044.54 General Fund Total Expenditures 15,150,581.02 15,336,829.79 (186,248.77) Net to Date 2,694,980.04 929,686.73 1,765,293.31 PEDC Fund Sales Tax 1,077,426.45 855,783.82 221,642.63 Interest Earned 1,186.86 45,103.31 (43,916.45) Miscellaneous Revenue 0.00 0.00 PEDC Fund Total Revenues 1,078,613.31 900,887.13 177,726.18 PEDC Fund Total Expenditures 165,445.66 2,076,457.33 (1,911,011.67) Net to Date 913,167.65 (1,175,570.20) 2,088,737.85 Water & Sewer Fund Sewer 3,680,879.24 3,592,002.00 88,877.24 Water 5,075,510.84 5,144,431.93 (68,921.09) Interest Earned 21,923.68 16,323.29 5,600.39 Miscellaneous 294,813.13 276,050.74 18,762.39 W &S Fund Total Revenues 9,073,126.89 9,028,807.96 44,318.93 W &S Fund Total Expenditures 6,271,270.77 6,420,370.84 (149,100.07) Net to Date 2,801,856.12 2,608,437.12 193,419.00 Comparison Report Page 1 6/10/2015 Year to Date Comparison 7. May, 2015 Current Year Previous Year Net to Date Capital Projects Fund Interest Earned 1,054.37 855.80 198.57 Auction Proceeds Capital Projects Fund Revenues 1,054.37 855.80 198.57 Capital Projects Fund Expenditures 120,335.57 128,571.48 (8,235.91) Net to Date (119,281.20) (127,715.68) 8,434.48 Equipment Replacement Fund Interest Earned 414.21 491.76 (77.55) Auction Proceeds 0.00 500.00 (500.00) Equipment Replacement Fund Revenues 414.21 991.76 (577.55) Equipment Replacement Fund Expenditures 10,979.78 222,077.31 (211,097.53) Net to Date (10,565.57) (221,085.55) 210,519.98 CO 2010 Construction Fund Interest Earned 2,589.41 1,865.29 724.12 Repayments From Other Funds CO 2010 Construction Fund Revenues 2,589.41 1,865.29 724.12 CO 2010 Construction Fund Expenditures 0.00 0.00 0.00 Net to Date 2,589.41 1,865.29 724.12 TWDB Loan Fund Bond Proceeds 242,083.18 1,826,720.18 (1,584,637.00) Interest Earned TWDB LoanFund Revenues 242,083.18 1,826,720.18 (1,584,637.00) TWDB Loan Fund Expenditures 209,222.60 1,699,906.53 (1,490,683.93) Net to Date 32,860.58 126,813.65 (93,953.07) Special Revenue Fund Interest Earned 0.00 0.00 Special Revenue Fund Revenues 0.00 0.00 Special Revenue Fund Expenditures 0.00 0.00 0.00 Net to Date 0.00 0.00 0.00 Child Safety Fund Interest Earned 77.68 66.23 11.45 Donations 1,980.00 275.00 Child Safety Fund Revenues 2,057.68 341.23 1,716.45 Child Safety Fund Expenditures 4,844.46 1,970.56 2,873.90 Net to Date (2,786.78) (1,629.33) (1,157.45) Comparison Report Page 2 6/10/2015 Year to Date Comparison 7. May, 2015 Current Year Previous Year Net to Date Health Department Interest Earned 0.00 69.80 (69.80) Fees & Grants 0.00 638,888.15 (638,888.15) Miscellaneous Revenue 0.00 Health Department Fund Revenues 0.00 638,957.95 (638,957.95) Health Department Fund Expenditures 0.00 754,130.67 (754,130.67) Net to Date 0.00 (115,172.72) 115,172.72 PEG Channel Fund Interest Earned 293.37 459.99 (166.62) PEG Franchise Fee 43,916.17 30,183.68 PEG Channel Fund Revenues 44,209.54 30,643.67 13,565.87 PEG ChannelFund Expenditures 0.00 0.00 0.00 Net to Date 44,209.54 30,643.67 13,565.87 Grant Fund Grants 639,197.09 363,998.11 275,198.98 Interest Earned 0.00 84.52 (84.52) Grant Fund Revenues 639,197.09 364,082.63 275,114.46 Grant Fund Expenditures 508,867.97 597,361.34 (88,493.37) Net to Date 130,329.12 (233,278.71) 363,607.83 Water Contract Fund Interest Earned 8,386.00 9,932.10 (1,546.10) Deposits Billed (191.68) (318.75) 127.07 Water Contract Fund Revenue 8,194.32 9,613.35 (1,419.03) Water Contract Fund Expenditures Net to Date 8,194.32 9,613.35 (1,419.03) Community Development Block Grant Interest Earned and Fees 3,642.30 9,251.54 (5,609.24) Grants 0.00 0.00 0.00 Community Dvl Block Grant Fd Revenues 3,642.30 9,251.54 (5,609.24) Community Dvl Block Grant Fd Expenditures 0.00 0.00 Net to Date 3,642.30 9,251.54 (5,609.24) Home Buyers Assistance 2009 Grants Home Buyers Assistance 2009 Revenues 0.00 0.00 0.00 Home Buyers Assistance 2009 Expenditures 0.00 0.00 Net to Date 0.00 0.00 0.00 Comparison Report Page 3 6/10/2015 Year to Date Comparison 7 May, 2015 Current Year Previous Year Net to Date Texas Department of Community Affairs Interest Earned 3.57 2.40 1.17 OCC Payments 387,199.20 0.00 387,199.20 TX Dept of Community Affairs Revenues 387,202.77 2.40 387,200.37 TX Dept of Community Affairs Expenditures 393,484.04 5,199.00 388,285.04 Net to Date 6,281.27 5,196.60 1,084.67 Municipal Court Tech Fee Municipal Court Tech Fee 7,733.04 8,882.53 (1,149.49) Interest Earned 128.69 80.10 48.59 Municipal Court Tech Fee Revenue 7,861.73 8,962.63 (1,100.90) Municipal Court Tech Fee Expenditures 1,580.46 1,459.00 121.46 Net to Date 6,281.27 7,503.63 (1,222.36) Municipal Court Security Fee Court Security Fee 5,811.18 6,698.26 (887.08) Interest Earned 177.33 132.06 Municipal Court Security Fee Revenues 5,988.51 6,830.32 (841.81) Municipal Court Security Fee Expenditures 4,285.40 4,866.54 (581.14) Net to Date 1,703.11 1,963.78 (260.67) Municipal Court Child Safety Fee Child Safety Fee 948.15 1,317.97 (369.82) Interest Earned 41.77 39.76 Municipal Court Child Safety Fee Revenues 989.92 1,357.73 (367.81) Municipal Court Child Safety Fee Expenditures 0.00 0.00 Net to Date 989.92 1,357.73 (367.81) Municipal Court Time Pay Fee Time Payment Fee 1,457.35 1,614.24 (156.89) Interest Earned 36.75 23.85 Municipal Court Time Pay Fee Revenues 1,494.10 1,638.09 (143.99) Municipal Court Time Pay Fee Expenditures 71.00 699.40 (628.40) Net to Date 1,423.10 938.69 484.41 Police Conf Fds- Gambling Conf Funds - Gambling Interest Earned 13.31 9.59 3.72 Police Conf Fds - Gambling Revenues 13.31 9.59 3.72 Police Conf Fds - Gambling Expenditures 0.00 0.00 0.00 Net to Date 13.31 9.59 3.72 Comparison Report Page 4 6/10/2015 Year to Date Comparison 7. May, 2015 Current Year Previous Year Net to Date Judicial Fofreiture Fee Judicial Forfeiture Fee 5,003.40 1,324.88 3,678.52 Interest Earned 44.10 11.43 32.67 Police Judicial Forfeiture Revenues 5,047.50 1,336.31 3,711.19 Police Judicial Forfeiture Expenditures 4,370.37 7,312.97 (2,942.60) Net to Date 677.13 (5,976.66) 6,653.79 GO Bonds 2013 Construction Interest Earned 79,861.47 0.08 79,861.39 GO Bonds 2013 Construction Fund Revenues 79,861.47 0.08 79,861.39 Tax & Rev CO 2000 Const Fund Expenditures 0.00 0.00 Net to Date 79,861.47 0.08 79,861.39 Tax & Rev CO 2000 Const Fund Interest Earned 0.12 0.12 Tax & Rev CO 2000 Const Fund Revenues 0.12 0.00 0.12 Tax & Rev CO 2000 Const Fund Expenditures 0.00 0.00 0.00 Net to Date 0.12 0.00 0.12 CO Series 2002 Construction Fd Interest Earned CO Series 2002 Construction Fd Revenues 0.00 0.00 0.00 CO Series 2002 Construction Fd Expenditures 0.00 0.00 0.00 Net to Date 0.00 0.00 0.00 GO Bonds 2013 Construction Fund Interest Earned 79,861.47 63,113.95 16,747.52 Bond Proceeds 0.00 GO Bonds 2013 Construction Fund Revenues 79,861.47 63,113.95 16,747.52 GO Bonds 2013 Construction Fund Expenditures Net to Date 79,861.47 63,113.95 16,747.52 Revenue Bonds Sinking Funds Interest Earned 29,432.76 28,238.97 1,193.79 Revenue Bonds Sinking Funds Revenues 29,432.76 28,238.97 1,193.79 Revenue Bonds Sinking Funds Expenditures 0.00 Net to Date 29,432.76 28,238.97 1,193.79 Tax & Rev CO's 2013 TWDB I &S Fund Tax & Rev CO's 2013 TWDB I &S Fund Interest Earned 334.23 484.98 (150.75) Comparison Report Page 5 6/10/2015 Year to Date Comparison 7. May, 2015 Current Year Previous Year Net to Date Tax & Rev CO's 2013 TWDB I &S Revenues 334.23 484.98 (150.75) Tax & Rev CO's 2013 TWDB I &S Expenditures 11,773.25 11,773.25 0.00 Net to Date (11,439.02) (11,288.27) (150.75) Comparison Report Page 6 6/10/2015 Year to Date Comparison May, 2015 Current Year Previous Year Net to Date 2012 GO Ref Bonds I & S 2012 GO Ref Bonds I & S Interest Earned 0.00 0.00 0.00 2012 GO Ref Bonds I &S Revenues 0.00 0.00 0.00 2012 GO Ref Bonds I &S Expenditures Net to Date 0.00 0.00 0.00 Tax & Rev CO 2010 I &S Tx & Rev CO 2010 I &S 208,150.95 219,341.92 (11,190.97) Interest Earned 288.23 188.98 99.25 Tax & Rev CO 2010 Refunding Bonds Revenues 208,439.18 219,530.90 (11,091.72) Tax & Rev CO 2010 Refunding Bonds Expenditures 164,545.63 161,608.13 2,937.50 Net to Date 43,893.55 57,922.77 (14,029.22) Tax & Rev CO 2002 I &S Fund Tax & Rev COs 2002 I &S 0.00 0.00 Interest Earned 0.00 0.00 0.00 Transfer from fund 42 0.00 0.00 Tax & Rev CO 2002 I &S Fund Revenues 0.00 0.00 0.00 Tax & Rev CO 2002 I &S Fund Expenditures 0.00 0.00 0.00 Net to Date 0.00 0.00 0.00 Cert of Oblig 2003 I &S Fund Interest Earned 0.00 0.00 0.00 Cert of Oblig 2003 I &S Fund Revenues 0.00 0.00 0.00 Cert of Oblig 2003 I &S Fund Expenditures 0.00 0.00 0.00 Net to Date 0.00 0.00 0.00 2010 GO /W &S Refunding Bonds Cert. Of Oblig. 2010 I &S 444,181.88 464,488.72 (20,306.84) Interest Earned 2,365.84 2,586.82 (220.98) 2010 GO /W &S Refunding Bonds Revenues 446,547.72 467,075.54 (20,527.82) 2010 GO /W &S Refunding Bonds Expenditures 493,609.38 1 497,071.88 1 (3,462.50) Net to Date (47,061.66) (29,996.34) (17,065.32) Comparison Report Page 7 6/10/2015 Year to Date Comparison 7. May, 2015 Current Year Previous Year Net to Date 2012 GO Ref Bonds I & S 2012 GO Ref Bonds I & S 641,385.43 820,919.30 (179,533.87) Interest Earned 1,906.40 1,074.26 832.14 2012 GO Ref Bonds I & S Revenues 643,291.83 821,993.56 (178,701.73) 2012 GO Ref Bonds I & S Expenditures Net to Date 643,291.83 821,993.56 (178,701.73) Interlocal Coop Agreement I &S Interlocal Coop Agreement I &S 101,741.57 108,058.10 (6,316.53) Interest Earned 98.70 73.38 25.32 Interlocal Coop Agreement I &S Revenues 101,840.27 108,131.48 (6,291.21) Interlocal Coop Agreement 1 &S Expenditures Net to Date 101,840.27 108,131.48 (6,291.21) GO Bonds 20131 & S GO Bds 2013 Property Taxes 0.00 0.00 0.00 Interest Earned 5,175.45 302.68 4,872.77 GO Bonds 2013 1 & S Revenues 5,175.45 302.68 4,872.77 GO Bonds 2013 1 & S Expenditures Net to Date 5,175.45 302.68 4,872.77 Tax & Rev CO 2002 I &S Fund Tax & Rev COs 2002 I &S 0.00 0.00 Interest Earned 821.98 (821.98) Transfer from fund 42 0.00 Tax & Rev CO 2002 I &S Fund Revenues 0.00 821.98 (821.98) Tax & Rev CO 2002 I &S Fund Expenditures 0.00 0.00 0.00 Net to Date 0.00 821.98 (821.98) 2003 GO Refunding Bonds Cert. Of Oblig. 2003 I &S 0.00 0.00 0.00 Interest Earned 0.00 1,185.85 0.00 2003 GO Refunding Bonds Revenues 0.00 1,185.85 (1,185.85) 2003 GO Refunding Bonds Expenditures 0.00 0.00 0.00 Net to Date 0.00 1,185.85 (1,185.85) Library Memorial Fund Interest Earned 70.15 77.99 Memorial Donations 2,928.05 2,291.43 636.62 Library Memorial Fund Revenues 2,998.20 2,369.42 628.78 Library Memorial Fund Expenditures 2,427.39 9,106.62 (6,679.23) Comparison Report Page 8 6/10/2015 Year to Date Comparison 7. May, 2015 Current Year Previous Year Net to Date Net to Date 570.81 (6,737.20) 7,308.01 Library Expendable Fund Interest Earned 242.34 175.53 66.81 Donations 0.00 0.00 0.00 Library Expendable Fund Revenues 242.34 175.53 66.81 Libra ryExpendable Fund Expenditures 0.00 Net to Date 242.34 175.53 66.81 Library Permanent Fund Interest Earned 226.64 0.63 226.01 Donations Library Permanent Fund Revenues 226.64 0.63 226.01 Library Permanent Fund Expenditures 0.00 0.00 0.00 Net to Date 226.64 0.63 226.01 Comparison Report Page 9 6/10/2015 Expenditure Summary 7 2 May, 015 ' >r» < > < May, 2014 Department Current Month Actual Current Year Actual Year Percent Expended Current Year Budget Budget Balance Current Month Actual Current Year Actual Year Percent Expended Current Year Budget Budget Balance City Council 10,731.23 57,571.48 76.94 74,830.00 17,258.52 6,668.19 70,907.35 73.23 96,830.00 25,922.65 City Manager 40,007.73 246,595.91 67.85 363,439.00 116,843.09 `' 39,699.40 240,942.96 66.89 360,183.00 119,240.04 City Attorney 33,089.50 218,281.40 50.92 428,698.00 210,416.60 >' 42,725.48 245,970.51 67.53 364,259.00 118,288.49 Municipal Court 22,219.39 148,819.47 66.02 225,404.00 76,584.53 21,449.47 138,310.65 64.77 213,525.00 75,214.35 City Clerk 14,148.80 91,359.77 65.33 139,844.00 48, 484.23 ?;; € >?;i: 13,342.75 73,868.23 62.10 118,944.00 45,075.77 Accounting & Auditing 42,571.63 291,993.98 65.78 443,901.00 151,907.02 51,498.42 277,595.98 67.88 408,934.00 131,338.02 Police 648,699.33 4,002,811.97 70.97 5,640,069.00 1,637,257.03 `> 610,375.69 3,640,828.87 68.01 5,353,605.00 1,712,776.13 Fire 522,070.24 3,063,738.77 71.04 4,312,551.00 1,248,812.23 ! 481,411.49 2,858,899.44 67.59 4,229,712.00 1,370,812.56 Community Development 29,477.81 221,330.04 47.75 463,545.00 242,214.96 € 27,427.57 241,766.98 57.67 419,209.00 177,442.02 Engineering 53,668.89 337,752.22 65.34 516,920.00 179,167.78 '; ;;1> 50,507.89 336,678.51 68.31 492,854.00 156,175.49 Public Works 20,230.38 134,535.66 82.05 163,974.00 29,438.34 !t 18,412.51 1,020,273.00 85.98 1,186,691.00 166,418.00 Parks, Recreation,& ROW 83,168.16 644,572.59 50.61 1,273,541.00 628,968.41 ? >?' 101,598.79 583,561.53 52.32 1,115,344.00 531,782.47 Sanitation 100,645.99 665,164.33 65.46 1,016,152.00 350,987.67 €';# 103,258.13 665,488.71 66.85 995,555.00 330,066.29 Streets & Highways 158,618.47 1,025,302.39 67.73 1,513,735.00 488,432.61 135,306.76 1,147,051.79 70.88 1,618,347.00 471,295.21 Traffic & Public Lighting 48,481.53 353,837.54 63.50 557,226.00 203,388.46 €' 78,805.76 370,934.55 66.36 559,000.00 188,065.45 Garage 31,837.71 213,109.38 62.08 343,266.00 130,156.62 € 37,751.97 212,730.21 67.02 317,402.00 104,671.79 Emergency Medical Service 384,977.66 1,720,257.55 76.21 2,257,240.00 536,982.45 :> 233,128.68 1,639,653.20 70.62 2,321,933.00 682,279.80 Cox Field Airport 1,363.98 79,373.73 69.20 114,700.00 35,326.27 '!;; 9,687.75 60,230.47 56.96 105,750.00 45,519.53 Paris Band 34.08 86.51 0.38 23,050.00 22,963.49 ?!; 9.60 57.87 0.25 23,050.00 22,992.13 Library 61,673.93 459,003.15 67.85 676,499.00 217,495.85 ';;; ^ ":;; 68,103.51 455,874.13 65.75 693,334.00 237,459.87 General Expenses 245,396.53 1,175,083.18 74.99 1,566,897.00 391,813.82 ;«; 237,171.55 1,055,204.85 66.74 1,580,976.00 525,771.15 Total General Fund 2,553,112.97 15,150,581.02 68.51 22,115,481.00 6,964,899.98 2,368,341.36 15,336,829.79 67.94 22,575,437.00 7,238,607.21 PEDC 2,291.32 139,560.16 14.77 944,966.00 805,405.84 73,470.72 2,029,095.99 61.11 3,320,566.00 1,291,470.01 Debt 0.00 25,885.50 7.37 351,021.00 325,135.50 !` >' 2,150.00 47,361.34 13.59 348,536.00 301,174.66 Total PEDC Fund 2,291.32 165,445.66 12.77 1,295,987.00 1,130,541.34 '! 75,620.72 2,076,457.33 56.59 3,669,102.00 1,592,644.67 Warehouse 12,046.90 69,928.70 65.41 106,901.00 36,972.30 11,343.10 67,428.26 67.39 100,060.00 32,631.74 W & S Billing and Collecting 181,661.97 1,393,449.55 62.88 2,216,147.00 822,697.45 € 230,464.16 1,406,611.81 63.88 2,201,966.00 795,354.19 Water Production 220,519.33 1,718,079.68 65.36 2,628,819.00 910,739.32 € 269,433.61 1,655,599.36 67.67 2,446,553.00 790,953.64 Water Distribution 115,537.44 872,846.10 49.98 1,746,476.00 873,629.90 ;;<;;;;;;; 145,067.33 1,186,924.35 65.73 1,805,778.00 618,853.65 Sewer Maintenance 83,468.71 553,250.80 51.59 1,072,430.00 519 ,179.20 ?`i;i >; 95,230.99 529,899.46 46.27 1,145,245.00 615,345.54 Current & Previous Expenditures Page 1 6/10/2015 Expenditure Summary 7. a 2015 M Y, >``` Ma 2014 Y, Department Current Month Actual Current Year Actual Year Percent Expended Current Year Budget Budget Balance Current Month Actual Current Year Actual Year Percent Expended Current Year Budget Budget Balance Waste Water Treatment 195,780.67 1,378,724.31 65.46 2,106,268.00 727,543.69 >i 221,301.23 1,335,748.08 62.91 2,123,263.00 787,514.92 Lift Stations 41,423.97 284,991.63 67.98 419,216.00 134,224.37 #[ 51,800.55 238,159.52 56.96 418,090.00 179,930.48 Debt 0.00 0.00 0.00 3,878,772.00 3,878,772.00 i €! 0.00 0.00 0.00 3,838,770.00 3,838,770.00 Total W &5 Fund 850,438.99 6,271,270.77 44.24 14,175,029.00 7,903,758.23 ?> 1,024,640.97 6,420,370.84 45.60 14,079,725.00 7,659,354.16 Fire 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 350,000.00 350,000.00 Community Development (26,004.27) 82,577.03 0.00 0.00 (82,577.03) `![;[i'[; 8,832.44 ........::...:. 128,571.48 0.00 0.00 (128,571.48) Total Capital Improvement Fund (26,004.27) 120,335.57 96.27 125,000.00 4,664.43 8,832.44 128,571.48 36.73 350,000.00 221,428.52 Police 0.00 0.00 0.00 0.00 0.00 i> 0.00 178,292.81 102.47 174,000.00 (4,292.81) Parks 0.00 0.00 0.00 0.00 0.00 0.00 11,965.00 95.72 12,500.00 535.00 Emergency Medical Service 0.00 10,979.78 32.29 34,000.00 23,020.22 <; 0.00 31,819.50 83.74 38,000.00 6,180.50 Total Equip Replacement Fund 0.00 10,979.78 32.29 34,000.00 23,020.22 is 0.00 222,077.31 98.92 224,500.00 2,422.69 Water Distribution 3,469.60 209,222.60 0.00 0.00 ( 209, 222.60) `'<i? 155,273.27 1,699,906.53 0.00 0.00 (1,699,906.53) Total TWDB Loan Fund 3,469.60 209,222.60 0.00 0.00 (209,222.60)..' ........::.... i' > <' 155,273.27 1,699,906.53 0.00 0.00 (1,699,906.53) Emergency Medical Service 604.48 4,844.46 12.11 40,000.00 35,155.54 LEE 2,617.64 1,970.56 4.93 40,000.00 38,029.44 Total Think Child Safety Fund 604.48 4,844.46 12.11 40,000.00 35,155.54 2,617.64 1,970.56 4.93 40,000.00 38,029.44 Health Department 0.00 0.00 0.00 0.00 0.00 286.31 754,130.67 62.48 1,207,019.00 452,888.33 Total Health Department Fund 0.00 0.00 0.00 0.00 0.00 ` >' 286.31 754,130.67 62.48 1,207,019.00 452,888.33 Police 37,728.26 274,999.40 53.29 516,018.00 241,018.60 63,268.59 320,699.06 60.76 527,816.00 207,116.94 Fire Department 0.00 48,100.58 114.53 42,000.00 (6,100.58) "< „! 4,319.64 34,600.55 0.00 0.00 (34,600.55) Community Developement 0.00 166,096.60 37.33 445,000.00 278,903.40 ............... < >' 11.32 90.56 0.02 395,000.00 394,909.44 Parks &ROW 5,478.73 19,671.39 2.06 956,926.00 937,254.61 189,850.67 241,971.17 71.80 337,000.00 95,028.83 Total Grant Fund 43,206.99 508,867.97 24.58 2,069,944.00 1,561,076.03 >'€ 257,450.22 597,361.34 47.42 1,259,816.00 662,454.66 Community Development 0.00 0.00 0.00 0.00 0.00 >= 0.00 0.00 0.00 200,000.00 200,000.00 Total Community Dev Block Grant 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 200,000.00 200,000.00 0.00 0.00 0.00 0.00 0.00 ............... 0.00 0.00 0.00 200,000.00 200,000.00 Community Development 0.00 393,484.04 0.00 0.00 (393,484.04) .............. ........... ....>; 0.00 5,199.00 0.00 0.00 (5,199.00) Total Owner Occ Rehab Fund 0.00 393,484.04 0.00 0.00 (393,484.04 ) ..:.........:.. .............. 0.00 5,199.00 0.00 0.00 5,199.00 Municipal Court Tech Fee 37.37 1,580.46 3.51 45,000.00 43,419.54 39.04 1,459.00 3.24 45,000.00 43,541.00 Total Court Tech Fee Fund 37.37 1,580.46 3.51 45,000.00 1 43,419.54 <i > 39.041 1,459.00 3.241 45,000.00 43,541.00 Current & Previous Expenditures Page 2 6/10/2015 Expenditure Summary 7. M 2015:::: aY. ? May, 2014 Department Current Month Actual Current Year Actual Year Percent Expended Current Year Budget Budget Balance Current Month Actual Current Year Actual Year Percent Expended Current Year Budget Budget Balance Municipal Court Security Fee 735.83 4,285.40 6.52 65,711.00 61,425.60 802.73 4,866.54 7.41 65,711.00 60,844.46 Total Court Security Fee Fund 735.83 4,285.40 6.52 65,711.00 61 ,425.60 802.73 4,866.54 7.41 65,711.00 60,844.46 Municipal Court Child Safe Fee 0.00 0.00 0.00 16,240.00 16,240.00 i' 0.00 0.00 0.00 16,240.00 16,240.00 Total Child Safety Fee Fund 0.00 0.00 0.00 16,240.00 16, 240.00 i':. >`> 0.00 0.00 0.00 16,240.00 16,240.00 Municipal Court Time Pay Fee 71.00 71.00 1.00 7,085.00 7,014.00 .............. ............... i; 0.00 699.40 9.87 7,085.00 6,385.60 Total Time Payment Fee Fund 71.00 71.00 1.00 7,085.00 7,014.00 ......:........ >! 0.00 699.40 9.87 7,085.00 6,385.60 Police Conf Fund - Gambling 0.00 0.00 0.00 4,620.00 4,620.00 '_? 0.00 0.00 0.00 4,620.00 4,620.00 Total Conf Funds - Gambling Fund 0.00 0.00 0.00 4,620.00 4,620.00 >` 0.00 0.00 0.00 4,620.00 4,620.00 Police Judicial Forfeitures 0.00 4,370.37 437.04 1,000.00 (3,370.37) ''' 0.00 7,312.97 60.94 12,000.00 4,687.03 Total Judicial Forfeiture Fee Fund 0.00 4,370.37 437.04 1,000.00 (3,370.37) ............... ?;a; »i 0.00 7,312.97 60.94 12,000.00 4,687.03 Debt Service 0.00 11,773.25 6.88 171,047.00 159 ,273.75 .............. J =;;?i;; 0.00 11,773.25 6.92 170,047.00 158,273.75 Total TWDB I &S Fund 0.00 11,773.25 6.88 171,047.00 159,273.75 >? 0.00 11,773.25 6.92 170,047.00 158,273.75 Debt Service 0.00 164,545.63 77.64 211,935.00 47,389.37 ''` 0.00 161,608.13 76.90 210,154.00 48,545.87 Total Tax & Rev 2010 I &S Fund 0.00 164,545.63 77.64 211,935.00 47,389.37 0.00 161,608.13 76.90 210,154.00 48,545.87 Debt Service 0.00 493,609.38 30.27 1,630,657.00 1,137,047.62 i[ > 0.00 497,071.88 30.44 1,632,932.00 1,135,860.12 Total 2010 GO /W &S Ref Bond 0.00 493,609.38 30.27 1,630,657.00 1,137,047.62 i 0.00 497,071.88 30.44 1,632,932.00 1,135,860.12 Library 0.00 2,427.39 0.00 0.00 (2,427.39) 2,091.39 9,106.62 0.00 0.00 (9,106.62) Total Library Memorial Fund 0.00 2,427.39 0.00 0.00 (2, 427.39) € 2,091.39 9,106.62 0.00 0.00 (9,106.62) Grand Total 3,427,964.28 23,518,494.75 55.98 42,008,736.00 18,490,241.25 i': 3,895,996.09 27,936,772.64 61.04 45,769,388.00 17,832,615.36 Current & Previous Expenditures Page 3 6/10/2015