Loading...
07 - Financial Report.Item No. 7 TO: City Council John Godwin, City Manager FROM: Gene Anderson, Finance Director SUBJECT: MAY 2018 FINANCIAL REPORT DATE, June 18, 2018 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 2018 Financial Report Comments Net to Date Comparison of Revenues: L The operations and maintenance property tax and rebated collections are 6,29% more than this time last year. Current tax collections, are 97.26% of the tax levy vs. 96.76%, last year, 2. Sales taxes are down 0.90% from last year. This amounts to $44,127. 1 Hotel occupancy taxes are down 1..464! from last year. All hotels are current on their taxes. 4. Franchise fees are up 14.91% compared to bast year. 5. Permit fees are up 58.62% from last year. This amounts $54,418. 16. Municipal Court fines and related fees are 7.53% below last year's collections. 7. Other revenue includes leases, interest, copy fees, birth & death certificates, library fees, mixed beverage tax, and other minor revenues. This revenue is up 7.18% compared to last year. 8. Sanitation flees are down 15.821x. This was expected with more of these fees going directly to the Sanitation Fund in this year's budget. 9. EMS, fees are up 8.04% compared to last year, 10. Total General Fund revenues, net of any transfers, are 5.02% above last year. General Fund revenues equal 78.64% of the budget with the City being 66,66% through the budget year. 11. Total General Fund expenditures are down 3.46% compared to last year. General Fund expenditures to date equal 66.00% of budget with the City being 66.661x through the budget year, 12. Sewer revenue is down 1.05% compared to last year, 13. Water revenue is down 17.571x compared to last year. This is due to the adjustment made for the overcharge to LCWS, Otherwise revenue would be down 3.51%, 14. Total Water & Sewer revenues, ignoring transfers, are 10.08% below last year. 15. Total Water & Sewer expenses are 4.77% above last year at this point and represent 47,09% of the total budget (60,9,8% adjusted for debt payments) 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 onetime expenditures that if made early in the fiscal year can produce a distorted expenditure percentage. Within the General, Water & Sewer, and Sanitation Funds there are sIx departments whose expenditures are over 66.66%. L City Council -94,554. The overage amounts to $22,740. This overage is due to the annual insurance payment, election related expenses, updating ordinance book, replacing restrooms' water heater, and building maintenance. 2. Community Development -76,42%. The overage announts to $32,564 and is mainly due to plan review services provided byBureau Veritas. 3. E&4S-68.2396,The, overage amounts to$42,4I1and due mainly tovehicle maintenance, lease of equipment, office supphcs,overtime, and medical supplies, 4. Airport -86.23%. The overage amounts to $23,023 and is due to building and grounds maintenance and insurance. 5. GenenalExpenses-73.28%.Thenverageammuntsto$l1(l743andisduehmpaymentsmadetn non -profits, the Health District, IT expenditures, and pass through payments to the Chamber of Commerce for hotel taxes. 6� VVaterDistribudon-66.8S96.Theoverageamountstu$2,877andisdueprima,i|ytoserviceUme nep�acementexpenoes. General comments to the City Couincik L Over 99% of all of the City operationai activity takes place in the General Fund, the Water & Sewer Fund, or the Sanitation Fund. The other funds are special purpose funds with limited activity and usually with legal restrictions on what their money can he spent on. For that reason, | normally only comment onthe activity mfthe General Fund, Water & Sewer Fmnd,andthe Sanitation Fund. However, if circumstances merited it | would make comment on activity in one ofthe 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 | have to research the answer to ypurquesflmn. That does not prevent you from asking the question mtthe meeting ifyou wish tomake apoint, but itdoes help prevent questions coming up that l' can't answer on the spot and possibly delaying the Council inmaking adecision. 3. The activity of the Paris Economic Development Corporation is refiected in the monthly report. This is a result of the City performing the bookkeeping functions for this agency. PED[ has its own managing board, ,General Fund: Report Sort Sequence, Report Group Description 70 Taxes Collected 71 Sales Tax 72 Hotel/Motel Tax 73 Franchise Fees 74 Permits 75 Court Fines 77 Other Revenue 78 Sanitation 79 Ems Fees Total Revenue: Total' Expenditures: Net To Date: 101174FLUMOTEMyo Current Prior Net Year Year To Date 7,227,736-62 6,799,9123.97 427,812.65 4,843,54146 4,887,671,24 -44,127.78 471,595.17 478,592.50 -6,997-33 2,435,150.79 2,119,110,21 316,040.58 147,250,35 92,831.67 54,418.68 204,061.43 220,683,37 -16,621.94 430,,862.24 401,990.48 28,87136 231,934,30 275,535.17 -43,600-87 1,876,712.51 1,737,022.54 139,689.97 $ 17,868,846.87 $ 17,013,361A5 $ 855,485.72 14,520,514.90 $ 15,041,185.39 $ (5,20,670.49) $ 3,348,331.97 $ 1,972,175.76 1,376,156.21 ExpenditureS F,,d Number Department Number Total 1 General Fund Department Name 0 Non -Departmental 11 City Council 12 City Manager 13 City Attorney 14 Municipal Court 15 City Clerk 21 Accounting & Auditing 31 Police 32 Fire 40 Community Developm 41 Engineering, 42 Public Works 43 Parks, Recreation,& RC 44 Sanitation 46 Streets & Highways 48 Traffic & Public Lighth 49 Garage 51 Paris -Lamar Co Health 54 Emergency Medical Se 61 Cox Field Airport 62 Paris Sand 64 Library 89 General Expenses 90 Debt 91 Contingency General Fund Current Prior Month Actual Month Actual OnOO 0.00 4,032.79 23,467.93 29,594.51 28,343.69 22,998.56 23,050.13 17,580.26 17,08338 8,95E81 10,64160 29,092,33 30,958.27 456,77158 467,873.81 356,88603 390,485 23 29,290.85 24,452,50 44,037.57 27,054.86 17,630.04 16,956,18 100,414.03 90,314.46 -240,85 -5,581.72 199,164.11 127,662.57 41,195.62 57,370.51 22,935.43 23,475.01 .1,87&00 _80Z0 241,919.72 226,258.48 11,062.83 11,736.54 35.72 822.70 45,198.52 53,444.74 234,055.66 274,283.05 000 OMO 0.00 0.00 $1,909,714.12 $1,920�,076.32 Current Year To Date 22,148.48 77,088.32 254,81169 168,324.16 150,485.23 80,475,51 276,596.38 4,083,481.25 3,044,323.01 254,800.84 243,046.28 149,227,46 524,800.74 0.00 1,029,352.26 353,436,54 205,715.27 OLO 1,832,366.29 101,44921 -363.92 444,572.65 1,224,37525 0.00 0.00 $14,520,514.90 Prior Year To Date UO 87,36&23 241,34738 173,902.83 149,862.91 90,544.01 273,764.68 4,245,918.53 3,112,295,05 419,224.23 223,501,23 142,45&51 583,980.38 -552.55 1,178,521.07 359,620,86 205,124.85 0.00 1,828,168.08 82,171,37 876.53 453,802.34 1,189,284,47 0.00 0,00 $I5,041,185.39 Current Year Budget 0,00 81, 530.00 392,116,00 347,96&00 244,555.00 149,045.00 442,839.00 6,396,659.00 4,916,871,00 333,38&00 505,066.00 231,59800 1,234,015.00 0.00 1,579,583.00 564,620.00 361,500.00 0.00 2,685,200.00 117,650.00 23,050.00 733,179.00 1,670,615.00 0.00 50,000.00 $23,061,047.00 Prior Year Budget 0.00 76,430.00 376,38100 378,928,00 232,063.Oo 143,688.00 425,41600 6,113,190.00 4,680,01237 541,768,00 492,52,2,00 216,337.00 1,120,324.00 0.00 1,569,116.00 583,250.00 342,686.00 0.00 2,693,797,00 106,950.00 23,050.00 694,850,00 1,605,333.00 ODD 50,000.00 $22,466,0913.77 Water Sewer Fund: Revenue Group Water Sewer Other Total Revenue: Total! Expenditures: Net To Date: Current Prior Net Year Year To Date 4,236,748.57 5,140,142.54 -903,39,3,97 3,761,132.18 3,801,080A5 -39,948-27 367,498.68 362,167.02 -606,87634 8,365-,379.43 $ 9,303,390.01 (938,010.58) 6,760,308.70 $ 6,452,007.11 $ 308,301.59 $ 1,605,070,73 $ 2,851,382.90 $ (1,246,312.17): -I,VUU,UUU.UU 0.00 1,000,000.00 2,000,000.00 3,000,000,00 4,000,000.00 5,000,000.00 6,000,000.00 0 Pr�or Year M Current Year Expenditures Water / Sewer Fund Fund Number 10 Water& Sewer Fund Department Department Current Year Prior Year Current Year Prior Year Number Name Month Month To Date To Date 80 Warehouse 14,759-63 8,05783 74,038,24 70,883-32 81 W & S Billing and Collecting 198,456,62 196,678-97 1,536,300.48 1,459,497.53 82 Water Production 230,853.85 204,148.84 2,081,681.36 1,791,882.22 83 Water Distribution 129,370,54 121,43032 988,114J1 1,053,479.38 85 Sewer Maintenance 70,790,95 77,71286 501,8412.95 467,051.51 86 Waste Water Treatment 188,55125 194,448.27 1,365,029.74 1,387,212.87 87 Lift Stations 28,129.90 28,524.59 213,301.82 222,000-28 Total Water & Sewer Fund $860,912.74 $831,002.08 $6,760,308.70 $6,452,007.11 Current Year Budget 107,284.00 2,187,749,00 2,762,802,00 1,367,033.00 600,118.00 2,036,450.00 332,142.00 $9,393,578.00 Prior Year Budget 101,355.00 2,096,039.00 2,433,377.00 1,354,006.00 811,268,00 1,981,465,00 323, 520.00 $9,101,030.00 Fund Number 2 Economic Development Fui Current Year Prior Year Net To Date Revenue $ 826,38126 $ 727,075.30 $ 99,307.96 Expenditure $ 505,844.63 $ 338,374.55 $ 167,470.08 Subtotal Net To Date: $ 320,538.63 $ 389300.75 $ (68,162.12) Fund Number 11 Capital Projects Fund Current Year Prior Year Net To Date Revenue $ 751,891.38 $ 4,180.97 747,710.41 Expenditure $ 117,,596.47 $ 504,527,77 (386,931,30) Subtotal Net To Date: $ 634,294m9,1 $ (500,346.80) $ 1,134,641.71 Fund Number 12, WW&SS Rev Bond 2000 Cc Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ Fund Number 13, Equipment Replacement Ft Current Year Prior Year Net To Date Revenue 182.75 $ 369.23 (186.48) Expenditure $ $ $ Subtotal Net To Date: $ 182.75 $ 369-23 (186.48) Fund Number 14 CO 2010 Construction Fun( Current Year Prior Year Net To Date Revenue $ 368.95 883.82 $ (514.87) Expenditure $ 461.50 $ (461.50) Subtotal Net To Date: $ 368«95 $ 422.32 $ (53.37) Fund Number 16 TWDB Loan Fund Current Year Prior Year Net To Date Revenue $ 373.7'7 2,482.94 $ (2,109.17) Expenditure $ - 541.,25 -$(541.25) Subtotal Net To Date: 373.77 1,941.69 $ (1,567,92) Fund Number 17 Library Construction Fund, Current Year Prior Year Net To Date Revenue $ - $ - $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 18 W&S Serles'97 Co'nst Fund Current Year, Prior Year Net To Date Revenue $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 19 Water Revenue Const Fund Current Year Prior Year Net To Date Revenue $ $ Expenditure $ $ Subtotal Net 'To Date: $ $ $ Fund Number 20 Special Revenue Fund Current Year Prior Year Net To Date Revenue $ $ Expenditure, $ Subtotal Net To Date: Fund Number 21 Child Safety Fund Current Year Prior Year Net To Date Revenue $ 1,897.54 $ 2,213.23 $ (315-69) Expenditure $ $ 2,470.00 $ (2,470.00) Subtotal Net To Date: $ 1,897.54 $ (256.77) 2,154.31 Fund Number 22 Health Department Fund Current Year Prior Year Net To Date Revenue $ - $ - $ Expenditure $ (776,73) $ .- -$(776.73) Subtotal Net To Date: $ 776J3 $ 776.73 Fund Nvmbetr 23 PEG Channel Fund Current Year, Prior Year Net To Date Revenue $ 47',279,8-,8--. $ 45,855.47 $ 1,424.41 Expenditure $ $ - $ - Subtotal Net To Date: $ 47,279M $ 45,S55.47 -$1,424.41 Fund Number 24 Lake Crook Restoration Fw Current Year Prior Year Net To Date Revenue $ 40.31 $ 26,,72 $ 13.59 Expenditure $ $ - $ - Subtotal Net To Date: $ 40.31 $ 26.72 $ 13.59 Fund Numbeir 25 Grant Fund Current Year Prior Year Net To Date Revenue 276,742-39 $ 714,228.34 $ (43,7,485.95) Expenditure 683,994.17 $ 754,5,75.03 $ (70,580.86) Subtotal Net To Date: (407,251.78) $ (40,346.69) $ (366,905,09) Fund Number 26 Criminal Justice Div Grant P Current Year Prior Year Net To Date Revenue $ $ Expenditure $ $ Subtotal Net To Date: $ $ Fund Number 27 Water Contract Fund Current Year Prior Year Net To Date Revenue $ 12,650.98 $ 11,8161.56 $ 7891.42 Subtotal Net To Date; $ $ .. ........ - $ $ 12,650,9$ $ 11,861.56 $ 789.42 Fund Number 30 Community DvI Block Gran Current Year Prior Year Net To Date Revenue 112,049.74 $ 1,363.81 $ 110,68,5.93 Expenditure $ - 51,247.41 $ (51,247.41) Subtotal Net To Date: 112f049.74 $ (49,883.60) $ 161,933.34 Fund Number 31 Home Buyers Asst 2009 Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 32 Owner Occ Rehab #10010! Current Year Prior Year Net To Date Revenue $ $ Expenditure, $ $ $ Subtotal Net To Date: $ $ Fund Number 33 Municipal Court Tech Fee Current Year Prior Year Net To Date Revenue $ 7,243.38 $ 7,644.25 $ (400.87) Expenditure $ 26,534.11 $ 1,653.09 $ 24,881.02 Subtotal Net To Date: $ (19,290.73) 5,991.16 $ (25,281.89) Fund Number 34 Municipal Court Security Fi Current Year Prior Year Net'To Date Revenue $ 5,807.28 $ 5,921.12 $ (113.84) Expenditure $ 4,822.11 $ 4,200-88 $ 621.23 Subtotal Net To Date: $ 985.17 $ 1,720.24 $ (735.07) Fund Number 35 Municipal Court Child Safe Current Year Prior Year Net To Date Revenue 489.05 $ 569,16 (80,11) Expenditure 2,719,85 4,626.00 $ (1,906.15) Subtotal Net To Date: (2,230.80) $ (4,056.84) $ 1,826.04 Fund Number 36 Municipal Court Time Pay F Current Year Prior Year Net To Date Revenue $ 1,493.09 $ 1,421.44 $ 71.65 Expenditure $ $ 1,652.20 $ (1,652.20) Subtotal Net To Date: $ 1,493.09 $ (230.76) $ 1,723.85 Fund Number 37 Police Conf Fds-Gambling Current Year, Prior Year Net To Date Revenue 53.45 35,41 18.04 Expenditure - $ Subtotal Net To Date: 53.45 $ 35.41 $ 18.04 Fund Number 38 Police Judicial Forfeitures Current Year Prior Year Net To Date Revenue 12,162.,82 $ 18,883.94 $ (6,721.12) Expenditure 5,296.42 $ 16,384.27 $ (11,087.85) Subtotal Net To Date: $ 6,866.40 $ 2,499.67 $ 4,366.73 Fund Number 39 Equitable Sharing Forfeitut Current Year Prior Year Net To Date Revenue $ 630.89 $ 922.39 $ (291.50) Expenditure $ 8,873.84 $ 79',943.54 $ (71,069.70) Subtotal Net To Date: (8,242.95) (79,021.15) 70,778.20 Fund Number 40 City of Paris CO'93 Const F Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ Fund Number 41 Tax & Rev CO 2000 Const F Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ SubtDt8l Net To Date, $ $ $ Fund Number 42 CO Series 2002 Constructi( Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 43 GO Bonds 2013 Constructi( Current Year Prior Year Net To Date Revenue $ 92,905.29 $ 96,898.11 $ (3,9,92.82) Expenditure $ 6,271,322.02 $ 6,671,300.97 $ (399,978.95) Subtotal Net To Date: $ (6,178,416.73) $ (6,574,402.86) $ 395,9,86.13 Fund Number 45 Land Fill Current Year Prior Year Net To Date Revenue $ 741,071.40 $ 7010,231.25 $ 40,840.15 Expenditure $ 643,439.76 $ 686,841.58 $ (43,401.82� Subtotaf Net To Date: $ 97,631.64 $ 13,309.67 $ 84,241.97 Fund Number so Revenue Bonds Sinking Full Current Year Prior Year Net To Date Revenue 240,996.36 233,416.74 $ 7,579,62 Expenditure $ - Subtotal Net To Date: $ 240,996.36 $ 233,416.74 $ 7,579.62 Fund Number 51 Tx&RevCOs 2013 (TWDB) I Current Year Prior Year Net To Date Revenue $ 121,325.24 $ 105,002.72 $ 16,322.52 Expenditure $ 10,273.25 $ 10,273.25 $ - Subtotal Net To Date: 111f051.99 $ 94,729.47 $ 16,32152 Fund Number 52 2012 GO Refunding Bond Current Yeah Prior Year Net To Date Revenue $ $ Expenditure $ $ Subtotal Net To Date: $ $ $ Fund Number 53 Tax & Rev CO 2010 I&S Ful Current Year Prior Year Net To Date Revenue $ 330,870.25 $ 305,500.76 25,369.49 Expenditure $ 177,608.13 $ 175,045.63 $ 2,562.50 Subtotal Net To Date: $ I53,262.12 $ 130,455.13 $ 22,806.99 Fund Number 54 City of Paris Co '9M3 I&S Fw Current Year Prior Year, Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: -$ I, $ Fund Number 55 Tax & Rev CO 2000 I,&S Fm Current Year Prior Year Net To Date Revenue $ - $ - $ Expenditure $ - $ $ Subtotal Net To Date: $ - $ $ Fund Number 56 Tax & Rev CO 20012 I&S Fm Current Year Prior Year Net To Date Revenue $ - $ - $ Expenditure $ $ - $ Subtotal Net To Date: $ $ $ Fund Number 57 Contractual Oblig I&S Func Current Year Prior Year Net To Date Expenditure $ $ $1 - Subtotal Net To Date: $ $ $ Fund Number 58 2003 GO Refunding Bonds Current Year Prior Year Net To Date Revenue $ $ Expenditure $ - Subtotal Net To Date: $ $ $ Fund Number 59 2010 GO/W&S Refunding I Current Year Prior Year Net To Date Revenue $ 941,502,42 $ 1,315,801.69 $ (374,299.27) Expenditure $ 468,612.50 $ 469',362.50 $ X756.00) Subtotal Net To Date: $ 472,889.92 846,439.191 $ (373,549.27) Fund Number 60 Refunding Bonds 2012 Current Year Prior Year Net To Date Revenue $ 398,248.70 398,388.96 $ (140.26) Expenditure, $ 387,825.00 $ 381,375.00 $ -6,450.00 Subtotal Net To Date: $ 10,423,70 $, 17,013.96 $ (6,590.26) Fund Number 61 Interlocal Coop Agreement Current Year Prior Year Net To Date Revenue $ 96,865.60 $ 96,16230 703.30 Expenditure $ 100,826.95 $ 100y826.95 Subtotal Net To Date: (3,961.35) (4,664.65) $ 703.30 Fund Number 62 G 0 Bonds 2013 I&S Fund' Current Year Prior Year Net To Date Revenue $ 1,202,796.91 $ 1,343,795.52 $ (140,998.61) Expenditure $ 1,473,98,7.50 $ 1,489,487.50 $ (15,500.00) Subtotal Net To Date: $ (271,190.59) $ (145,691.98) $ (125,498.61) Fund Number 63 CO Bonds - 2.016 Current Year Prior Year Net To Date Revenue $ 462„794.65 $ 22,,391.95 $ 440,402.70 Expenditure 514,317S0 $ 514,317.50 Subtotal Net To Date, $ (51,522.85) $ 22,391.95 $ (73,914.80) Fund Number 64 CO Bonds - 2017 Cuirre,nt Year Prior Year Net To Date Revenue 78.92 $ $ 78.92 Expenditure $ 115,681.77 $ $ 115,681.77 Subtotal Net To Date., (115,602.85) $ (115,602.85) Fund Number 70 Employees Insurance Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 71 Insurance Claims Fund Current Year Prior Year Net To Date Revenue $ Expenditure $ $ $ Subtotal Net To Date: $ $ Fund Number 72 Library Memorial Fund Current Year Prior Year Net To Date Revenue $ 2,685,22 1,173.10 1,512,12 Expenditure $ 351.07 $ 506.11 $ (155.04) Subtotal Net To Date: $ 2,334.I5 $ 666,99 1,667.16 Fund Number 73 3 A Love Trust Fund Current Year Prior Year Net'To Date Revenue $ Expenditure $ Subtotal Net To Date: $ Fund Number 74 3 P Poteet Trust Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ Subtotal Net To Date: $ $ Fund Number 75 Wilbor Deshong Trust Func Current Year Prior Year Net To Date Revenue $ Expenditure $ Subtotal Net To Date: $ $ Fund Number 76 Gibbs Library Fund Current Year Prior Year Net To Date Revenue $ $ $ - Expenditure $ Subtotal Net To Date: $ $ Fund Number 77 W B & Kathryn Vaughan Mt Current Year Prior Year, Net To Date Revenue $ $ Expenditure $ $ $ Subtotal Net To Date; $ $ Fund Number 78 Malone H Love Memorial FI Current Year Prior Year Net To Date Revenue -$ - $$ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 79 Library Expendable Fund Current Year Priior Year Net To Date Revenue $ 861.92 $ 567.28 $ 294.64 Expenditure $ - $ .... ........ $ — - Subtotal Net To Date: $ 8;1.92 $ 567.28 $ 294.64 Fund Number 80 Library Permanent Fund Current! Year Prior Year Net To Date Revenue $ 6,15 $ 4.07 $ 2.08 Expenditure $ $ - Subtotal Net To Date: $ 6.IS $ 4,07 2.08