Loading...
07 - Financial ReportItem No. 7 TO: City Council John Godwin, City Manager FROM: Gene Anderson, Finance Director SLJBJECT: MARCH 2018 FINANCIAL REPORT DATE: April 11, 2018 BACKGROUND: Section 69 (3) ofthe 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: ']'his report updates the City Council oil the City's financial activities through the month stated in the subject title. BIJI)GET: Not affected by this report. RECOMMENDATION: Motion to receive the monthly financial report. City of Paris March 2018 Financial Report Comments Net to Late Comparison of Revenues: L The operations and maintenance property tax and related collections are 7,06% more than this time last year. Current tax collections are 96.15% of the tax levy vs. 95.12% last year. 2. Sales taxes are down 2,10% from last year. 3. Hotel occupancy taxes are up 2.67% from last year. All hotels are current on their taxes. 4. Franchise fees are down 2.52% compared to last year. 5. Permit fees are up 47.66% from last year. This amounts $35,941. 6. Municipal Court fines and related fees are 10,161 below last year's collections.. 7, Other revenue includes leases, iinterest, copy fees, birth & death certificates, library fees, mixed beverage tax, and other minor revenues. This revenue is down $9.74% compared to last year. 8. Sanitation fees are down 15,76%. This was expected with more of these fees going directly to the Sanitation Fund in this year's budget. 9. EMS fees are up 5.06% compared to last year. 10. Total General Fund revenues, net of any transfers, are 2,631 above last year. General Fund revenues equal 64.66% of the budget with the City being 50.00% through the budget year. 11. Total General Fund expenditures are down 3,82% compared to last year. General Fund expenditures to date equal 47.26% of budget with the City being 5000% through the budget year. 12. Sewer revenue is down 0.211 compared to last year, 13. Water revenue is down 20.631a compared to last year. This is due to the adjustment made for the overcharge to LCWS. Otherwise revenue would be down 1,83%. 14. Total Water & Sewer revenues, ignoring transfers, are, 11.33% below last year. 15, Total Water & Sewer expenses are 6,87% above last year at this point and represent 35,01% of the total budget (48.901 adjusted for debt payments) while the City is 50,00 % through the budget year. Departmental Expenditure Summary: At this point the City is six months or 50.00% 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 five departments whose, expenditures are over 50.00 % 1. City Council -82,00%. The overage amounts to $26,089. 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 -55.47%, The overage amounts to $18,266 and is ma�nly due to plan review services provided byBureau Veritas. 3. EMS -50.80%. The overage amounts to $21,661 and due mainly to vehic�e maintenance, overtime, and medical supplies, 4. General Expenses-5478%.The overage amounts to$79,99Band isdue tupayments made to non -profits, the Health District, and pass through payments to the Chamber of Commerce for 5, Water Treatment Plant -51,72%. The overage amounts to $53,993 and is due to work on water storage tanks, pumps, and the purchase of a vehicle. General comments to the City Council: Over 99% of all of the City operational activity take� 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 be spent on, For that reaso,n, I normally only cornment on the activity of the Genera� Fund, Water & Sewer Fund, and the Sanitation Fund, However, if circumstances merited it, I would make comment on activity in one of the other funds. | try toanticipate questions you might have about the report and comment onthose 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 your question, That does not prevent you from asking the question at the meeting ifyou wish tomake apoint, but itdoes help prevent questions coming up that I can't answer on the spot and possibly delaying the Council immaking adecision. The activity of the Paris Economic Development Corporation is refected in the monthly report. This is a result of the City performing the bookkeeping functions for this agency. PEDC has its own managing board, V ritv ii of Paris lFul-fd-TeLcao. fo-r ngg!rri 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 Sanitatlon 79 Ems Fees Total Revenue - Total Expenditures: Net To Date: Current Prior Net Year Year To Date 7,115,855.91 6,646,401.48 469,454.43 3,635,886,71 3,713,938.97 -78,052.26 323,705,51 315,268,33 8,437.18 1,634,757,19 1,677,188.99 -42,431.81 111,34813 75,406.38 35,941,75 155,09158 172,634.86 -17,541,28 273,646.85 303,192.32 -29,545A7 174,033,79 206,596 16 -32,562.37 1,377,194.20 1,310,75032 66,443.88 $ 14,801,521.86 $ 14,421,377.81 $ 380,144.05 $ 10,899,772.28 $ 11,332,790.12 5 (433,017.84) $ 3,901,749.58 $ 3,088,587.69 813,161.89 Expenditures FmJ %tlll i General Fund Department Department Current Prior Current Prior Current Year Prior Year Number Name Month Actual Month Actual Year To Date Year To Date Budget Budget 0 Non-Departmenital 0,00 0.00 22,148,48 10.00 UO 11 City,Council 8,574.78 4,59669 66,854.70 49,405,33 81,530.00 0.001 715,430.00 12 City Manager 42,047.63 40,655.71 187,1.82.39 183,619.68 392,116,00 376,38300 13 City Attorney 26,378.61 22,711.62 122,035.60 128,324,44 347,968.00 378,928,00 14 Municipal Court 23,967.95 25,557.13 116,173.93 114,551.17 244,555Z0 232,063.00 15 City Clerk 12,047,82 1.4,503.36 63,092.16 68,621.92 149,045.00 143,688.00 21 Accounting & Auditing 39,918.56 40,18630 218,889.16 214,431.88 442,839,00 425,41600 31 Police 32 Fire 602,117.74 729,783,77 3,102,931.00 3,295,622.03 6,396,,659.00 6,113,190.00 40 Community Developm, 466,055.36 51,514.25 490,700.00 2,361„395.14 2,392,219,77 4,916,871.00 4,680,012.77 41 Engineering 37,844.87 38,685,85 184,960,67 135,1509.31 333,388.00 541,768.00 42 Public Works 40,01033 174,393.89 166,940,155 5()5,066.00 492,522,00 43 Parks, Recreation,& RC 24,039,98 24,91E94 113,496.00 108,063.07 231,598.00 216,337.00 44 Sanitation 80,02030 104,429,85 341,522.72 412,181,46 1,234,015,00 1,120,324,00 46 Streets & Highways 11,49 58,726.35 7.50 167,47951 240,85 705,440.38 4,344.06 945,386.98 0.00 1,5 79,583.00 0.00 48 Traffic & Public : Lighth 48,295.79 41,423.53 270,2810.88 260,616.86 564,620.00 1,569,116,00 49 Garage 30,228.68 30,377,72 159,917.51 154,069.61 361,500.00 583,250.00 342,686,00 51. Paris -(Lamar Co Health 0.00 0.00 1,878.00 80.00 000 54 Emergency Medical Se 287,929.58 414,032.80 1364,261.01 1,417,339.36 2,685,200.00 0.00 2,693,797.00 61 Cox Field Airport 6,20752 6,357.16 5'7,645.26 60,097.01 117,650.00 106,950.00 62 Paris Band 64 Library -450.00 0.00 -399.64 53.83 23,0510.00 23,050.00 89 General Expenses 59,725.53 49,847.90 64,89686 350,125.29 353,636.57 733,179.00 694,850.00 90 Debt 58,239.45 915,306.90 867,675.13 1,670,615-00 1,605,.333.0() 91 Contingency 10.00 UO 0,00 0.00 0.00 0,00, 0.00 Total General Fund $1,955,050.69 0.00 $2,359,552.48 O-C)o0. $10,899,772.28 00 $11,332,790.12 50,000.00 $23,061,047,00 50,000 -OD $22,466,093.77 Water Sewer Fund: Current Prior Net Revenue Group Water Sewer Other Total Revenue: Total Expenditures: Net To Date: Year Year To Date 3,096,91838 3,902,306.35 -805,387,37 2,850,435,74 2,856,487.25 -6,051.51 278,335,34 263,140.06 15,195.28 $ 6,225,690. 7,021,933.66 (796,243.60) $ 5,130,197.27 $ 4,800,099.61 330,097.66 $ 1,095,492.79 $ 2,221,834.05 $ (1,126,341.26) Expenditures , Water / Sewer Fund Fund Number 10 Water & Sewer Fund Department Department Current Year Prior Year Current Year Number Name Month Month To Date 80 Warehouse 9,720.29 11,63618 51,654.09 81 W & S BflHng and Collecting 195,282,45 191,876.55 1,141,524.85 82 Water Production 307,365 17 273,311.75 1,623,396.98 83 Water iOistribution 101,439.43 108,434.74 738,086.88 85 Sewer Maintenance 134,772.44 70,74126 3,84,880.60 86 Waste Water Treatment 205,680.00 195,281-24 1,036,619 57 87 Lift Stations 30,751.24 34,968 52 154,034.30 Total Water & Sewer Fund $,985,011.02 $886,252.24 $5,130,197.27 Prior Year To Date 54,181.58 1,076,541,41 1,365,311.68 771,614,22 322,837 38 1,044,002,58 165,610.76 $4,800,099.61 Current Year Budget 107,284.00 2,387,749.00 2,762,802.00 1,367,033.00 600,11800 2,036,450r00 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 831,268.010 1,981,465.00 323,520,00 $9,101,030.010 Fund Number 2 Economic Development Fur Current Year Prior Year Net To Date Revenue $ 728,840.52 $ 559,904.79 168,935.73 Expenditure $ 230,690.52 $ 210,446.66 $ 20,243.86 Subtotal Net To Date: $ 498,150.00 $ 349,458.13 $ 148,691.87 Fund Number 11 Capital Projects Fund Current Year Prior Year Net To Date Revenue $ 749,852.56 3,074.82 $ 746,777.74 Expenditure $ 90,245.24 $ 615,713.05 $ (525,467,81) Subtotal Net To Date: 659,607.32 (612,638.23) $ 1,272,245.55 Fund Number 12 WW&SS Rev Bond 2000 Co Current Year Prior Year Net To Date Revenue $ Expenditure $ $ SubtotaN Net To Date: $ $ Fund Number 13 Equipment Replacement Ft Current Year Prior Year Net To Date Revenue $ 131.30 31638 $ (185.08) Expenditure Subtotal Net To Date: $ 131.30 $ 316.38 $ (185.08) Fund Number 14 CO 2010 Construction Fun( Current Year Prior Year Net To Date Revenue $ 294.35 $ 620.59 $ (326.24) Expenditure $ - $ 461.50 $ (461.50) Subtotal Net To Date: $ 294-35 $ I59.09 $ 135.26 Fund Number 16, TWDS Loan Fund Current Year Prior Year Net To Date Revenue 298.20 $ 2,409.19 (2,110.99) Expenditure, - $ - $ Subtotal Net To Date: $ 298.20 $ 2,409.,19 $ Fund Number 17 Library Construction Fund Current Year Prior Year Net To Date Revenue $ - $ - $ Expenditure $ Subtotal Net To Date: $ Fund Number is W,&S Series "97' Const 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,689.61 $ 7.53 $ 1,682.08 Expenditure $ - $ 600.00 $ (600.00) Subtotal Net To Date: $ 1,689.61 $ (592.47) $ 2,282.08 Fund Number 22 Health Department Fund Current Year Prior Year Net To Date Revenue $ $ Expenditure $ (776.73) $ (776.73) Subtotal Net To Date: $ 776.73 $ $ 776.73 Fund Number 23 PEG Channel Fund Current Year Prior Year Net To Date Revenue $ 31,717.98 30,158.28 $ 1,55930 Expenditure $ - $ . ....... . ... ..... - $ - Subtotal Net To Date: $ 31,717.98 $ 30,158.28 $ 1,559.70 Fund Number 24 lake Crook Restoration Fui Current Year Prior Year Net To Date Revenue $ 32.16 $ 18,76 13.40 Expenditure $ $ - Subtotal Net To Date: $ 32.16 $ 18.76 $ 13.40 Fund Number 25 Grant! Fund Current Year Prior Year Net To Date Revenue $ 210,979.47 $ 241,806.65 $ (30,827.18) Expenditure $ 507,772.58 $ 630,443.23 $ (122,670.65) Subtotal Net To Date. $ (296,793.11) (388,636.58) $ 91,843.47 Fund Number 26 Criminal Justice Div Grant I Current Year, Prior Year Net To Date Revenue $ - $ - $ - Expenditure $ (33.54) $ $1 (33.54) Subtotal Net To Data: $ 33,54 $ 33.54 . ..... ........... Fund Number 27 Water Contract Fund Current Year Prior Year Net To Date Revenue 9,485.38 7,925.72 $ 1,559.66 Subtotal Net To Date: $ $ 9,485.38 $ 7,925.72 $ 1,559.66 Fund Number 30 Community Dvi Block Gran Current Year Prior Year Net To Date Revenue 111,529.22 $ 1,083.77 $ 110,445.45 Expenditure - $ 40,584.12 ........ ........ $ (40,584.12) Subtotal' Net To Date; $ 111,529.22 $ (39,500.35) 151,029.57 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 Nlet To CDate Revenue $ 5,352.36 5,765,40 $ (413.04) Expenditure $ 21,625,21 $ 1,515.04 $ 20,110.17 Subtotal Net To Date: $ (16,272A5) $ 4,250.36 (20,523.21) Fund Number 34 Municipal Court Security F( Current Year Prior Year Net To Date Revenue $ 4,295.57 $ 4,458.68 $ (163.11) Expenditure $ 3,154.32 $ 3,253.38 $ (99-06) Subtotal Net To Date: $ 1,141.25 $ 1,205.,30 $ (64.05) Fund Number 35 Municipal Court Child Safe Current Year Prior Year Net To Date Revenue $ 371.37 $ 432.93 $ (61.56) Expenditure $ - $ 4,626-00 $ (4,626.00) Subtotal Net To Date: $ 371.,37 $ (4,193.07) 4,564.44 Fund Number 36 Municipal Court Time Pay F Current Year Prior Year Net To Date Revenue $ 1,171.89 $ 1,074.83 97.06 Expenditure $ $ 1,652.20(1,652.20) . .... ......... . . . . Subtotal Net To Date: 1,171.89 $ (577.37) $ 1,749.26 Fund Number 37 Police Conf Fds-Garnbling Current Year Prior Year Net To Date Revenue $ 42.64 24-86 $ 17.78 Expenditure $ - $ - Subtotal Net To Date: $ 42.64 $ 24.86 $ 17.78 Fund Number 38 Police Judicial Forfeitures Current Year Prior Year Net To Date Revenue $ 12,110.62 $ 13,777.27 $ (1,666.65) Expenditure $ 1,287.35 $ 16,384.27 $ (15,096.92) Subtotal Net To Date: $ 10,823.27 $ (2,607.00) $ 13,430.27 Fund Number 39 Equitable Sharing Forfeitui Current Year Prior Year Net To Date Revenue $ 529.19 $ 712.84 $ (183.65) Expenditure $ 8,032.34 $ 74,942.66 $ (66,910.32) Subtotal Net To Date: $ (7,503.15,) $ (74,229X2) $ 66,726.67 Fund Number $ $ 40 City of Paris CO'93 Const F Current Year Prior Year Net To Date Revenue $ $ $ Expenditure Subtotal Net To Date: CO Series, 2002 Constructi( $ $ Fund Number 4,1 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 $ 81,514,57 $ 68,172.87 $ 13,341.70 Expenditure $ 4,939,009.36 $ 4,552,222.95 $ 386,786.41 Subtotal Net To Date: $ (4,857,494.79) $ (4,484,050.,08) $ (373,444.71) Fund Number 45 Land Fill Current Year Prior, Year Net To Date Revenue, 555,762.95 $ 524,500.41 31,262.54 Expenditure 486,964.92 $ 504,274.16 $ (17,309.24) Subtotal Net To Date: 68,798.03 $ 20,226.25 $ 48,571.78 Fund Number so Revenue Bonds Sinking Full Current Year Prior Year Net To Date Revenue $ 179,090.99 $ 173,122.09 5,968.90 Expenditure $ - $ 174,295.63 $ - Subtotal Net To Date: $ 179,090.99 $ 173,122.09 $ 5,968.90 Fund Number 51 Tx&RevCOs 2013 (TWDB) I Current! Year Prior Year Net To Date Revenue $ 90,960.11 $ 84,646.57 $ 6,313.54 Expenditure $ 101,273.25 I . ............ . $ 10)273.25 $ - Subtotal Net To Date: $ 80,686.86 $ 74,373.32 $ 6,313.54 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 Fu i Current Year Prior Year Net To Date Revenue $ 327,555.22 $ 299,767.07 $ 27,788.15 Expenditure $ 176,858.13 $ 174,295.63 $ 2,562.50 Subtotal Net, To Date: $ 150,697.09 125,471.44 25,225.65 Fund Number 54 City of Paris CO '913 I&S Fui Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 55 Tax & Rev CO 2000 I&S Foe Current Year Prior Year Net To Date Revenue $ $ Expenditure $ $ Subtotal Net To Date: $ $ - Fund Number 56 Tax & Rev CO 2002 I&S Fuii Current Year Prior Year Net To Date Revenue $ $ Expenditure $ $ Subtotal Net To Date: $ $ $ Fund Number 57 Contractual Oblig I&S l=ung 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&5 Refunding I Current Year Prior Year Net To Date Revenue $ 809,472.01 $ 1,065,694.43 $ (256,222,42) Expenditure $ 468,612.50 $ 469,362.50 $ (750M) Subtotal Net To Date: 340,859.51 $ 596,331.93 $ (255,472.42) Fund Number 60 Refunding Bonds 2012 Current Year Prior Year Net To Date Revenue $ 391,856.02 $ 389,621.23 $ 2,234.79 Expenditure $ 387,825.00 $ 381,375.00 $ 6,450.00 Subtotal Net To Date: $ 4,031.02 $ 8,24613 $ (4,215.21) Fund Number 61 Interlocal Coop Agreement Current Year Prior Year Net To Date Revenue $ 95,663.87' 94,748.99 $ 914.,88 Expenditure $ $ - Subtotal Net To Date: $ 95,663.87 $ 94,748.99 $ 914,88 Fund Number 62 G 0 Bonds 2013 I&S Fund Current Year Prior Year Net To Date Revenue 902,257.67 $ 1,042,416.,53 $ (140,I58.86) Expenditure 1,473,987.50 $ 1,489,487.50 $ (15,500.00) Subt.otN Net To Date: (571,729.83) (447,070.97) (124,658,86) Fund Number 63 CO Bonds - 2016 Current Year Prior Year Net To Date Revenue $ 342,243.71 $ 22,342.44 319,901.27 Expenditure $ 514,317.50 $ - 514,317.50 Subtotal Net To Date: $ (172,073.79) 27.,34,7.44 (194,416.23) Fund Number 64 CO Bonds - 2017 Current 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) $ $ (11$,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 Data: Revenue $ Expenditure $ Subtotal Net To Date: $ $ $ Fund Number 72 Library Memorial Fund Current Year Prior Year Net To Date, Revenue $ 812.58 $ 1,014.57 $ (201.99) Expenditure 334.07 $ 4613.37 $ (126.30) Subtotal Net To Date: 478.51 $ 55420 $ (75.69) Fund Number 73 1 A Love Trust Fund Current Year Prior Year Net To Date Revenue WilborDeshongTrust FUnC Cuirrent Year $ Expenditure Net To Date, Subtotal Net To Date: $ $ Fund Number Expenditure 74 3 P Poteet Trust Fund Current Year Prior Year Net To Date Revenue $ $ Expenditure $ Fund Nurnber Subtotal Net To Date: $ $ $ Fund Number 75 WilborDeshongTrust FUnC Cuirrent Year Prior Year Net To Date, Revenue $ $ Expenditure $ $ SubLotaU Net To Date: $ $ $ Fund Nurnber 76 Gibbs Library Fund Current Year Prior Year Net To Date Revenue $ $ Expenditure $ $ SubtotaV Net To Date: $ $ Fund Number 77 W B & Kathryn Vaughan M4 Current Year Prior Year Net To Date Revenue $ $ $ Expenditure -$ $ $ subtotal Net To Date: $ $ $ Fund Number 78 Malone H Love Mernorial R Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ - Subtotal Net To Date: $ `✓r $ Fund Number 79 Library Expendable Fund Current Year Prior Year Net To Date Revenue $ 687-64 $ 398.33 $ 289.31 Expenditure $ $ $ SubtotM Net To Date: $ 687.64 $ 398.33 $ 289.31 Fund Number 80 Library Permanent Fund Current Year Prior Year Net To Date Revenue $ 4.91 $ 2.86 $ 2.05 Expenditure $ - $ $ - Subtotal Net To Date: $ 4.91 $ 2.86 $ 2.05