Loading...
07 - Financial ReportItem No. 7 TO: City Council ,John Godwin, City Manager FROM: Gene Anderson, Finance Director SUBJECT: FEBRUARY 2018 FINANCIAL REPORT DATE: March 17, 2018 BACKGROUND: Section 69 () 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 n-ionth, stated in the subject fine. BUDGET: Not affected by this report. R.ECOMMENDA'I"'ION: Motion to receive the monthly financial report. City ofParis February 2018 Financial Report Comments Net to Date Comparison of Revenues: L The operations and maintenance property tax and related collections are 7.22% more than this time last year. Current tax cuUect��ons are 95.1896ufthe tax levy vs, 94.U196last year. 2, Sales taxes are down 3.1}96from last year. 3. Hotel occupancy taxes are up 3,06% from last year. All hotels are current on their taxes. 4� Franchise fees are down 3,1]%compared tu last year, 5, Pennftfees, are up 5O.D29&from last year, This amownis $31,540,31. 6. Municipal Court fines and related fees are 828% 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 isdown $3'469compared lnlast year. & Sanitation fees are down 1.5.66%. This was expected with more of these fees going direct|yto the Sanitation Fund inthis year's budget. 9� EMS fees are up7.l0%compared tolast year. 10. Total General Flund revenues, net of any transfers, are 3.14% above last year, General Fund revenues equal 58.24% of the budget with the City being 41.66% through the budget year. 11. Total General Fund expenditures are down 0.31% compared to last year. Genera� Fund expenditures to date equal 38.78% of budget with the City being 41.66% through the budget year. 12. Sewer revenue isdown O.4496compared tolast year. 13. Water revenue isdown 2.1196compared 10last year. 14. Total Water & Sewer revenues, ignoring transfers, are 1.02Y{below last year. 15. Total Water & Sewer expenses are 5,91% above last year at this point and represent 28.29% of the total budget (4Z-17Y6adjusted for debt payments) while the City is41.G6%through the budget year. Departmental Expenditure Summary� Atthis point the City isfive months nr41.6696through the budget year. Itisimportant Toremember that expenditures do not occur equally throughout the year, For example, capital expenditures and association memberships are onetime expenditures that if made early �m the fiscal year can produce a distorted expenditure, percentage, Within the General, Water & Sewer, and Sanitation Funds there are five departments whose expenditures are over 41,66%. L City [ounci|-71,4696.The overage amounts to$24,3O8.This overage �sdue tVthe annual insurance payment, election related expenses, updating ordinance bunk, rep|adngrestroom»' water heater, and building maintenance, Z. Cox Field Airport -43,72%. The overage amounts to $2,424 and is due to the annual insurance payment. 3. General Expenses -51,80%. The overage amounts to $169,480 and is due to payments made to non'proUK4theHea|thDistftt,andpassthroughpaymentsk}the[hamberofCommeoefor hotel taxes. 4. Water Treatment Plant -41.92%. The overage amounts to $8'405 and is due to work on water storage tanks, Pumps, and the purchase ofavehicle. 5, Water Distribution -43,U796.The overage amounts to $20,911 and is due to the annual �nsurance payment and purchase ofatrailer and spreader. General comments to the City Council: Over 99% of all of the City operational 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, i normally only comment on the activity of the General Fund, Water & Sewer Fund, and the Sanitation Fund, However, if circumstances merited it, I would make comment an activity in one nfthe other funds. I 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 frorn asking the question at the meeting if you wish to make a point, but it does help prevent questions coming up that | can't answer on the spot and posn|b|ydeYaying the Council inmaking adec�siom. The activity of the Paris Economic Development Corporation is reflected in the monthly report. This is result ofthe City performing the bookkeeping functions for this agency, PEVChas its own managing board. Citv of Pan General Fund: Current Prior Net Report Sort Sequence Report Group Description Year Year To Date 70 Taxes Collected 7,031,634,82 6,558,,005.46 473,629.36 71 Sales Tax 3,111,194.71 3,211,780.14 -100,585.43 72 Hotel/Motel Tax 324,171.90 314,526.00 9,645.90 73 Franchise Fees 1,225,746.39 1,265,387.27 -39,640.88 74 Permits 94,318.74 62,778.43 31,540.31 75 Court Fines 121,186.15 132,13530 -10,949.55 77 Other Revenue 218,069.60 220,539.05 -2,469A5 78 Sanitation 145,281,91 172,275.84 -26,993.93 79 Ems Fees 1,129,595.34 1,054,659,.06 74,936.28 Total Revenue: $ 13,401,199.56 $ 12,992,086.95, $ 409,112,61 Total Expenditures: $ 8,944,721.59 $ 8,973,237.64 $ (28,516.05) Net To Date: 4,456,477.97 $ 4,018,849.31 $ 437,628.66 Ems Fees Sanitation Other Revenue Court Fines Permits Franchise Fees Hotel/Motel Tax Sales Tax Taxes Collected 0,00 1,000,000.00 2,000,000-00 3,000,000.00 4,000,000,00 5,000,000= 6,000,000-00 7,000,000.00 8,000,000.00 * Prior Year * Current Year Expenditures Fmdirlumber Department Number Total i General Fund Department Current Name Month Actual 0 Non-Departmentall 22,148.48 11 City Council 3,762.07 12 City Manager 31,279.62 13 City Attorney 20,245.19 14 Municipal Court 1-9,77&22 is City Clerk 8,515.81 21 Accounting & Auditing 42,35109 31 Police 464,492.71 32 Fire 344,389.21 40 Community Developm 23,217.38 41 Engineering 29,05323 42 (Public Works 20,483.98 43 Park$,Recreation,& R( 119,876.01 44 Sanitation 0.00 416 Streets & Highways 140,401.22 48 Traffic & Public Lighth 40,067.76 49 Garage 23,929.51 51 Paris -Lamar Co Health 0,00 54 Emergency Medical Se 2116,491.56 61 Cox Field Airport 8,463-32 62 Paris Band 0,00 64 Library 47,962.21 89 General Expenses 251,493.72 99 Debt 0,00 91 Contingency 0.00 General Fund $1,878,402.30 Prior Current Prior Month Actual Year To Date Year To Date 0100 22,148.48 0,00 4,643.19 58,279.92 44,808.64 29,095.94 145j3436 142,963.97 18,371,77 95,65699 105,612.82 18,63690 92,205.98 88,994,04 10,392.79 51,044,34 54,118-56 30,85181 178,970.60 174,245.58 450,41774 2,500,81,126 2,565,838.26 424,261.69 1,895,339.78 1,901,519.77 23,218.54 133,446.42 96,82146 30,103.47 136,549.02 126,929,92 16,277.78 89,456.02 83,146.13 59,423.48 261,502.42 307,751-61 450.76 229,36 4,336.56 177,940.04 646,714.03 777,907.47 47,063.60 221,985-09 21.9,19333 22,48442 129,68&83 123,691.89 0.00 1,878.00 80.00 190,079.47 1,076,331.43 1,003,306 56 12,214.88 51,437.74 53,739.85 0.60 50,36 5183 47,955.55 290,399.76 288,739,71 225,601.89 865,459.00 809,435.68 0.00 0.00 0.00 0.00 0.00 0.00 $1,839,488.31 $8,944,721.5,9 $8,973,237.64 Current Year Budget UO 81,530.00 392,116.00 347,968,00 244,555.0o 1,49,045.00 442,839,00 6,396,659.00 4,916,87100 333,388.00 505,066.00 231,598.00 1,234,015.00 0.00 1,579,58100 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= 376,383.00 378,928,00 232,063.00 143,688.00 425,416,00 6,113,190.00 4,680,012 77 541,768.00 492,522.00 216,337.00 1,120,324.00 UO 1,569,116.00 583,250.00 342,68600 0.00 2,693,797.00 106,950.00 23,O5OrOo 694,850.00 1,605,333,00 0-00 50,000.00 $22,466,093.77 Other Sewer Water Water Sewer Fund: Current Prior Net Revenue Group Year Year To Date Water 3,260,078.73 3,330,569,17 -70,490.44 Sewer 2,380,273,36 2,390,945.13 -10,67137 Other 236,757.59 216,588.43 20,169.16 Total Revenue: S 5,877,10 .68 9, 38,15753 (60,993.05) Total Expenditures: $ 4,149,186.25 $ 3,913,847.37 $ 231,338.88 Net To Date: ljii-,'9ii.43 $ 2,024,255.36, $ (29 2,331.93) 0.00 500,000.00 1,000,000.00 1,500,000m 2,000,000.00 2,500,000.00 3,000,000,00 3,500,000.00 mi Prior Year im Current Year Expenditures Water / Sewer Fund Fund Number 10i Water & Sewer Fund Department Department Current Year Prior Year Current Year Prior Year Current Year Prior Year Number Name Month Month To Date To Date Budget Budget 80 Warehouse 6,813.77 7,779.99 41,933-80 42,545.40 107,284.00 81, W & S Billing and Collecting 209,146Jo 175,149-36 946,242.40 884,66486 2,187,749.00 .101,355.00 2,096,039.00 82 Water Production 212,651.80 195,385.15 1,316,031-81 1,091,999.93 2,762,80100 2,433,377.60 83 Water Distribution 132,666.23 162,836.24 636,64745 663,179.48 1,367,03100 1,354,006.00 85 Sewer Maintenance 47,007,43 72,95834 250,108,16 252,094.12 600,118.00 811,268.00 86 Waste Water Treatment 1,35,164.70 141,843,88 830,939.57 848„721.34 2,036,450.00 1,981,465,00 87 Lift Stations 23,315.97 25,764.39 123,283.06 130,642,24 332,1.42.0E 323,520.00 Total Water & Sewer Fund $766,766.,60 $781,717.35 $4,145,186.25 $3,913,847.37 $9,393,578.00 $9,101,030.010 Fund Number Economic Development Ful Current Year Prior Year Net To Date Revenue $ 623,623.74 $ 493,261.56 $ 130,362,18 Expenditure $ 173,237.51 $ 160,889.78 $ 12,347.73 Subtotal Net To Date: $ 450586.23 $ I'll, 332,371.78 $ 118,014.45 Fund Number 11, Capital Projects Fund Current Year Prior Year Net To Date Revenue $ 748,586.72 $ 2,656.14 $ 745,930.58 Expenditure —$ 69:378.93 $ 541,756.03 $ (472,377.10) Subtotal Net To Date: $ 679,207.79 $ (539,099-89) $ 1,218,307.68 Fund Number 12 WW&SS Rev Bond 2000 Cc Current Year, Prior, Year Net To Date Revenue $ $ - $1 Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 13 Equipment Replacement Fit Current Year Prior Year Net To Date, Revenue $ 100.65 $ 210.41 (109.76) Expenditure - $ $ Subtotal Net To Date: 100.65 $ 210.41 $ Q�(�10976) Fund Number 14 CO 2010 Construction Funt Current Year Prior Year Net To Date Revenue $ 248.82 $ 483-06 $ (234.24) Expenditure $ - $ 461 - .50 (461,50) Subtotal Net To Date: 248.82 21.56 227.26 Fund Number 16 TWDB Loan Fund Current Year Prior Year Net To Date Revenue $ 252.08 $ 2,370.04 $ (2,127.96) Expenditure $ - $ $ Subtotal Net To Date: $ 252.08 $ 2,370.04 $ (2,117.96) Fund Number 17 Library Construction Fund Current Year Prior Year Net To Date Revenue $ - $ - $ - Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Expenditure $1 $ $ Net To Date: $ $ $ 18 W&S Series '97 Const Fund Current Year Prior Year Net To Date Revenue $ $ Expenditure $ $ Net To Date: $ $ 19 Water Revenue Const Fund Current Year Prior Year Net To Date Revenue $ $ $ - Expenditure $ $ $ Net'To Date: $ $ $ 20 Special Revenue Fund Current Year Prior Year Net To Date Revenue $ Expenditure ... ..... .... $ Net To Date: $ 21 Child Safety Fund Current Year Prior Year Net To Date Revenue $ 1,635.04 $ 6.01 $ 1,629-03 Expenditure $ $ 600.00 $ (600.00) Net To Date,: $ 1,635.04 $ (593.99) $ 2,229.03 22 Health Department Fund Current Year Prior Year Net To Date Revenue Expenditure $ $ $ Net To Date: -$ $ $ 23 PES Channel Fund Current Year Prior Year Net To Date Revenue 31,298.191 $ 29,351.07 $ 1,947.12 Expenditure $ - Subtotal Net To Date: 31,298.19 $ 29,351.07 $ 1,947,12 Fund Number 24 Lake Crook Restoration Fut Current Year Prior Year, Net To Date Revenue $ 27.19 $ 14.60 $ 12.59 Expenditure $ $ Subtotal Net To Date: $ 27.19 $ 14.60 $ 12.59 Fund Number 25 Grant Fund Current Year Prior Year Net To Date Revenue $ 204,831.97 $ 225,056.32 $ (20,224,35) Expenditure $ 381,725.32 $ 570,562.66 $ (189,837.34) Subtotal Net To Date: $ (176,893.35) $ (345,506.34) $ 168,612.99 Fund Number 26 Criminal Justice Div Grant D 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 $ 9,183.,21 $ 6,,708.43 $ 2,474.78 Subtotal Net To Date: $ $ 9,183.21 $ 6,708.43 2,474.78 Fund Number . ........... 30 Community Dvi Block Grain Current Year Prior Year Net To Date Revenue $ 111,212.37 $ 926.47 $ 110,285.90 Expenditure $ - $ 35,477.80 $ (35,477.80) Subtotao Net To Date: $ 111,212.37 $ (340551.33) 145,763.70 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 $ 4,154.39 $ 4,387.09 $ (232.70) Expenditure $ 21,208.49 $ 1,347.88 $ 19,860.61 Subtotal Net To Date': $ (17,054.10) $ 3,039.21 $ (20,093.31) Fund Number 34 Municipal Court Security Ft Current Year Prior Year Net To Date Revenue $ 3,343.19 $ 3,396-34 $ (53.15) Expenditure $ 2,369.96 $ 2,549.04 $ (179.08) Subtotal Net To Date: $ 973.23 $ 847.30 $ 125.93 Fund Number 35 Municipal Court Child Safe Current Year Prior Year Net To Date Revenue $ 331.95 $ 371.43 $ (39.48) Expenditure $ - $ 4,626.00 $ (4,626.00) Subtotal Net To Date, $ 331.95 $ (4,254.57) 4,586.52 Fund Number 36 Municipal Court Time Pay f Current Year Prior Year Net To Date Revenue $ 964.04 $ 819.86 $ 144.18 Expenditure $ - $ . . ........ 1,65210 $ (1,652.20) Subtotal Net To Date: 964.04 (832.34) $ 1,796.38 Fund Number 37 Police Conf Fds-Gambling Current Year Prior Year Net To Date Revenue $ 36.04 $ 19.35 $ 16,69 Expenditure $ - $ - $ - Subtotal Net To Date: 36.04 19.35 $ 16.69 Fund Number 38 Police Judicial Forfeitures Current Year Prior Year Net To Date Revenue $ 3,649.06 $ 13,429.00 $ (9,77194) Expenditure $ 1,287.35 $ 16,195.77 $ (14,908.42) Subtotal Net To Date: $ 2,361.71 $ (2,766.77) $ 5,128.48 Fund Number 39 Equitable Sharing Forfeitut Current Year Prior Year Net To Date Revenue 465,98 $ 600.45 $ (134.47) Expenditure 8,032.34 $ 44,347.66 S (36,315.32) Subtotal Net To Date, (7,566.36) (43,747.21) $ 36,180.85 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 -$ $ $ Subtotal 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 $ 73,167,43 $ 84,005.15 $ (10,837.72) Expenditure $ 4,195,138:43 $ 3,446,635.15 $ 748,503.28 Subtotal Net To Date: $ (4,121,971.00) $ (3,362,630.00) $ (759,341.00) Fund Number 45 Land Fill Current Year, Prior Year Net To Date Revenue -$ 464,297.11 $ 436,841.19, $ 27,4SS.92 Expenditure $ 39S,276.13 $ 434,220.82 $ (38,944.69) Subtotal Net To Date- 69,020,98 2,620.37 $ 66,400.61 Fund Number 9,773.25 $ - Subtotal so Revenue Bonds Sinking Fur Current Year Prior Year Net To Date Revenue $ 151,433,19 $ 144,294.98 $ 7,138.21 Expenditure $ - $ - $ Subtotal Net To Date: $ 151,433.19 Prior Year 144,294.98 $ 7,138,21 Fund Number 51 Tx&RevCOs 2013 (TWDB) I Current Year Prior Year Net To Date Revenue 75,766.21 $ 74,477.89 $ 1,288.32 Expenditure 9,773.25 $ 9,773.25 $ - Subtotal Net To Date: 65,992.96 64,704.64 $ 1,288.32 Fund Number 52 2012 GO Refunding Bond I Current Year 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 -$ 264,95,3.90 $ 296,026.40 $ (31,072.50) Expenditure $ 176,858.13 $ 174,295.63 $ 2,562.50 Subtotal Net To Date: $ 88,095.77 121,730.77 (33,635.00) Fund Number 54 City of Paris, C0) '913 I&S Fuii Current Year Prior Year Net To Date Revenue $ $ Expenditure $ $ Subtotal Net To Date: $ $ $ Fund Number 55 Tax & Rev CO 2000 I&S Fuii Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ Subtotal Net To Date: $ $ Fund Number 56, Tax & Rev CO 2002 I&S Ful Current Year Prior Year Net To Date Revenue $ Expenditure $ Subtotal Net To Date: $ $ Fund Number 57 Contractual Oblig I&S Funs Current Year Prior Year Net To Date Expenditure $ - Subtotal Net To Date: Fund Number 58 20'03 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 $ 741,485M $ 939,536.07 $ (198,050J5) Expenditure $ 468,612,50 $ 469,362.50 $ (750.00) Subtotal Net To Date: $ 272,873.42 $ 470,173.57 $ (19'7,300.15) Fund Number 6,0 Refunding Bonds 2012 Current Year Prior Year Net To, Date Revenue $ 386,871.40 $ 383,,834.00 $ 3,037.40 Expenditure $ 387,825.00 $ 381,375.00 $ 6,450.00 Subtotal Net To Date: $ (953,60) $ 2,459.00 $ (3,412.60) Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal Fund Number Subtotal 61 Interlocal Coop Agreement Current Year Prior Year Net To Date Revenue $ 94,526.22 $ 93,880.96 645.26 Expenditure $ Expenditure $ 301.09 Net To Date: 94,526.22 $ 93,880-96 $ 645.26 62 G 0 Bonds 2013 I&S Fund Current Year Prior Year Net To Date Revenue 752,217.88 $ 891,956.89 $ (139,739.01) Expenditure 1,473,987.,50 $ 1,489,,487.50 $ (15,500.00) Net To Date: (721,769.62) $ (597,530.61) $ (124,239.01) 63 CO Bonds - 20116 Current Year Prior Year Net To Date Revenue -$ 342,023.21 $ 22,316.57 $ 319,,706.64 Expenditure $ 514,317.50 $ - $ H4617.50 Net To Date: $ (172,294.29) $ 22,316.,57 $ (194,610.36) 70 Employees Insurance Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ Net To Date: $ $ 71 Insurance Claims Fund Current Year Prior Year Net To Date Revenue $ - $ . . ........ Expenditure $ . . . ............. Net To Date: -$ $ $ 72 Library Memorial Fund Current Year Prior Year Net To Date Revenue $ 755.46 $ 643.42 $ 112.04 Expenditure $ 301.09 $ 413.12 $ (112,030 Net To Date: -$ 45437 $ 230.30 $ 224.07 Fund Number 73 3 A Love Trust Fund Current Year Prior, Year Net To Date Revenue $ $ $ Expenditure Net To Date $ $ Subtotal Net To Date: $ Fund Number Expenditure 74 J P Poteet Trust Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ Fund Number 75 Wilber 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 Da,te Revenue Expenditure Subtotal Net To Date: $ Fund Number 77 W B & Kathryn Vaughan Mi 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 Prior Year Net To Date Revenue $ 581.28 $ 310.06 $ 271.22 Expenditure $ - $ - $ Subtotal Net To Date: 581.28 $ 310.06 271.22 Fund Number so Library Permanent Fundi Current Year Prior Year Net To Date Revenue $ 4.15 $ 2.23 $ 1.92 Expenditure $ - $ - $ - Subtotal Net To Date: $ 4.15 $, 2.23 $ 1.92