Loading...
07-October Financial ReportItem No. 7 memorandum TO: City Council John Godwin, City Manager FROM: Gene Anderson, Finance Director SUBJECT: OCTOBER 2016 FINANCIAL REPORT DATE: November 17, 2016 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 October 2016 Financial Report Comments Net to Date Comparison of Revenues: 1. The operations and maintenance property tax and related collections are 70.90%% less than this time last year. Collections for both current and delinquent taxes are lower than last year. Current taxes are 0.53% collected vs. 1.48% last year. 2. Sales taxes are up 1.52 %% from last year. 3. Hotel occupancy taxes are up 25.45% from last year. All hotels are current on their taxes. 4. Franchise fees are up 8.80% compared to last year. 5. Permit fees are up 337.31 %. This is only $15,473. 6. Municipal Court fines are 4.04% 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 21.84% but is only $7,531. 8. Sanitation fees appear to be down, but there was a posting error in October 2015 that was not corrected until November 2015. Adjusting for that correction, sanitation fees are within $241 of last year's amount. 9. EMS fees are up 9.54% compared to last year. 10. Total General Fund revenues are 8.38% below last year. This decrease is primarily due to the lower property tax collections noted above. General Fund revenues equal 5.94% of the budget with the City being 8.33% through the budget year. 11. Total General Fund expenditures are down 20.03% compared to last year. General Fund expenditures to date equal 8.50% of budget with the City being 8.33% through the budget year. 12. Sewer revenue is down 2.14% compared to last year. 13. Water revenue is down 8.98% compared to last year. About 60% of the decrease is due to two large billing adjustments. The other 40% reflects a decrease in sales in all four billing cycles compared to last year. 14. Total Water & Sewer revenues, ignoring transfers, are 3.84% below last year for the reason noted above. 15. Total Water & Sewer expenses are 11.50% below last year at this point and represent 5.21% of the total budget (5.21% adjusted for debt payments) while the City is 8.33% through the budget year. Departmental Expenditure Summary: At this point the City is one month or 8.33% 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 eight departments whose expenditures are over 8.33 %. 1. City Council- 34.40%. The overage amounts to $19,925. This overage is due to making the annual payments for general liability insurance and membership in the Ark -Tex Council of Governments. 2. Police- 8.89%. The overage amounts to $34,353 and is due to the annual payment for general liability insurance. 3. Fire - 9.57%. The overage amounts to $58,213 and is due to the annual payments for general liability insurance and lease payments on two fire trucks. 4. Streets - 10.79%. The overage amounts to $38,615 and is due to the annual payment for general liability insurance, contract services for concrete work, and temp workers. 5. Library - 8.45%. The overage amounts to $837 and is due to the annual payment for general liability insurance. 6. General Expenses - 9.19%. The overage amounts to $13,884 and is due to annual payment to non - profits and purchase of IT related equipment. 7. Warehouse - 8.91%. The overage amounts to $631 and is due to the annual payment for general liability insurance. 8. Sanitation - 9.45%. The overage amounts to $11,917 and is due to the annual payment for general liability insurance and maintenance of equipment and vehicles. 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 be 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 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. 7. City of Paris Fund Recap, for month ending- October 2016 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 84 Water and Sewer Transfers 0 Miscellaneous Revenue Total Revenue: Total Expenditures: Net To Date: Current Prior Net Year Year To Date 52,695.38 181,120.96 - 128,425.58 557,707.27 549,322.20 8,385.07 144,352.68 115,058.84 29,293.84 150, 669.82 138, 479.70 12,190.12 20,060.60 4,587.18 15,473.42 21,530.13 22,437.55 - 907.42 42,009.11 34,477.18 7,531.93 34,491.81 120,822.34 - 86,330.53 236,833.66 216,189.63 20,644.03 74,916.66 74,916.66 0.00 0.00 0.00 0.00 $ 1,335,267.12 $ 1,457,412.24 $ (122,145.12) $ 1,910,833.93 $ 2,389,637.89 $ (478,803.96) $ (575,566.81) $ (932,225.65) $ 356,658.84 I I I ` Water and Sewer Transfers Ems Fees Sanitation Other Revenue ■ Prior Year Court Fines ■ Current Year Permits Franchise Fees Hotel /Motel Tax Sales Tax Taxes Collected j j 0.00 100,000.00200,000.00300, 000. 00300 ,000.00i00,000.00i00,000.00 Fund Number Department Number Total 1 General Fund Department Current Name Month Actual 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 Lightir 49 Garage 51 Paris -Lamar Co Health 54 Emergency Medical Se 61 Cox Field Airport 62 Paris Band 64 Library 89 General Expenses 90 Debt 91 Contingency General Fund 0.00 26,292.46 27,781.76 19,852.11 17,774.97 11,318.21 29,975.41 543,581.83 448,058.41 36,917.99 19,695.55 17,176.30 72,692.02 1,166.94 169,328.02 40,213.34 24,648.04 0.00 177,271.64 20,709.01 53.23 58,718.12 147,608.57 0.00 0.00 $1,910,833.93 Prior Month Actual 0.00 25,226.89 39,752.40 35,388.42 22,855.47 14,500.27 42,015.28 631,845.12 600,325.86 23,106.01 36,292.74 22,705.18 69,302.08 0.00 187,478.88 44,586.20 32,928.60 0.00 242,982.34 13,293.24 93.71 86,720.18 218,239.02 0.00 0.00 $2,389,637.89 Current Year To Date 0.00 26,292.46 27,781.76 19,852.11 17,774.97 11,318.21 29,975.41 543,581.83 448,058.41 36,917.99 19,695.55 17,176.30 72,692.02 1,166.94 169,328.02 40,213.34 24,648.04 0.00 177,271.64 20,709.01 53.23 58,718.12 147,608.57 0.00 0.00 $1,910,833.93 Prior Year To Date 0.00 25,226.89 39,752.40 35,388.42 22,855.47 14,500.27 42,015.28 631,845.12 600,325.86 23,106.01 36,292.74 22,705.18 69,302.08 0.00 187,478.88 44,586.20 32,928.60 0.00 242,982.34 13,293.24 93.71 86,720.18 218,239.02 0.00 0.00 $2,389,637.89 Current Year Budget 0.00 76,430.00 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 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 0.00 50,000.00 $22,466,093.77 Prior Year Budget 0.00 73,930.00 369,563.00 438,910.00 229,092.00 140,958.00 420,501.00 6,073,596.00 4,381,076.00 463,692.00 513,374.00 205,471.00 1,140,560.00 0.00 1,488,440.00 593,119.00 341,450.00 0.00 2,332,850.00 103,350.00 23,050.00 691,853.00 1,598,860.00 0.00 50,000.00 $21,673,695.00 Water Sewer Fund: Revenue Group Water Sewer Other Total Revenue: Total Expenditures: Net To Date: Current Prior Net Year Year To Date 716,417.65 787,136.95 - 70,719.30 487,380.25 498,082.73 - 10,702.48 60,843.31 30,057.94 30,785.37 $ 1,264,641.21 $ 1,315,277.62 $ (50,636.41) $ 734,878.31 $ 830,385.57 $ (95,507.26) $ 529,762.90 $ 484,892.05 $ 44,870.85 Fund Number Expenditures Water / Sewer Fund Fund Number 10 Water & Sewer Fund Department Department Current Year Prior Year Current Year Prior Year Current Year Number Name Month Month To Date To Date Budget 80 Warehouse 9,616.24 11,242.61 9,616.24 11,242.61 101,355.00 81 W & S Billing and Collecting 172,829.48 176,151.78 172,829.48 176,151.78 2,096,039.00 82 Water Production 221,764.53 232,662.95 221,764.53 232,662.95 2,433,377.00 83 Water Distribution 124,585.67 132,627.65 124,585.67 132,627.65 1,354,006.00 85 Sewer Maintenance 46,085.74 60,282.13 46,085.74 60,282.13 811,268.00 86 Waste Water Treatment 133,737.47 168,621.82 133,737.47 168,621.82 1,981,465.00 87 Lift Stations 26,259.18 48,796.63 26,259.18 48,796.63 323,520.00 Total Water & Sewer Fund $734,878.31 $830,385.57 $734,878.31 $830,385.57 $9,101,030.00 Prior Year Budget 99,479.00 2,037,150.00 2,644,850.00 1,492,331.00 703,378.00 1,951,462.00 353,193.00 $9,281,843.00 2 Economic Development Fund Revenue Expenditure Subtotal Net To Date: Fund Number 11 Capital Projects Fund Revenue Expenditure Subtotal Net To Date: Fund Number Current Year Prior Year Net To Date $ 81,712.69 $ 80,882.97 $ 829.72 $ 24,745.51 $ 7,519.83 $ 17,225.68 $ 56,967.18 $ 73,363.14 $ (16,395.96) Current Year Prior Year Net To Date $ 652.17 $ 109.37 $ 542.80 $ 109,451.25 $ 7,480.28 $ 101,970.97 $ (108,799.08) $ (7,370.91) $ (101,428.17) Fund Number 12 WW&SS Rev Bond 2000 Const Fund Current Year Prior Year Net To Date Revenue $ - $ $ Expenditure $ - $ $ Subtotal Net To Date: $ $ $ - Fund Number 13 Equipment Replacement Fund Current Year Prior Year Net To Date Revenue $ 25.72 $ (52.16) $ 77.88 Expenditure $ - $ - $ - Subtoal Net To Date: $ 25.72 $ (52.16) $ 77.88 Fund Number 14 CO 2010 Construction Fund Current Year Prior Year Net To Date Revenue $ 89.11 $ 379.14 $ (290.03) Expenditure $ 461.50 $ 111.70 $ 349.80 Subtotal Net To Date: S (372.39) $ 267.44 $ (639.83) Fund Number 16 TWDB Loan Fund Current Year Prior Year Net To Date Revenue $ 23.69 S 11.80 $ 11.89 Expenditure $ - $ - $ - Subtotal Net To Date: $ 23.69 $ 11.80 $ 11.89 Fund Number 17 Library Construction Fund Current Year Prior Year Net To Date Revenue $ - $ $ Expenditure $ - $ $ - Subtotal Net To Date: $ - $ $ - Fund Number Fund Number 18 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.44 $ 5.11 $ (3.67) Expenditure $ - $ 12,549.88 $ (12,549.88) Subtotal Net To Date: $ 1.44 $ (12,544.77) $ 12,546.21 Fund Number 22 Health Department Fund Current Year Prior Year Net To Date Revenue $ - $ $ Expenditure $ - $ $ Subtotal Net To Date: $ $ - $ - Fund Number Fund Number 31 Home Buyers Asst 2009 Revenue Expenditure Subtotal Net To Date: Fund Number Current Year Prior Year Net To Date - S 23 PEG Channel Fund Current Year Prior Year Net To Date Revenue $ 13,999.46 $ 46.53 $ 13,952.93 Expenditure $ - $ - $ - Subtotal Net To Date: $ 13,999.46 $ 46.53 $ 13,952.93 Fund Number 24 Lake Crook Restoration Fund Current Year Prior Year Net To Date Revenue $ 2.69 $ 42.55 $ (39.86) Expenditure $ - $ - $ - Subtotal Net To Date: $ 2.69 $ 42.55 $ (39.86) Fund Number 25 Grant Fund Current Year Prior Year Net To Date Revenue $ 16,827.13 $ 25,711.90 $ (8,884.77) Expenditure $ 65,071.10 $ 87,553.50 $ (22,482.40) Subtotal Net To Date: $ (48,243.97) $ (61,841.60) $ 13,597.63 Fund Number 26 Criminal Justice Div Grant Fd 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 $ 1,489.84 $ 1,551.50 $ (61.66) Subtotal Net To Date: $ - $ - $ $ 1,489.84 $ 1,551.50 $ (61.66) Fund Number 30 Community Dvl Block Grant Fund Current Year Prior Year Net To Date Revenue $ 209.18 $ 315.63 $ (106.45) Expenditure $ 4,754.05 $ 3,491.60 $ 1,262.45 Subtotal Net To Date: $ (4,544.87) $ (3,175.97) $ (1,368.90) Fund Number 31 Home Buyers Asst 2009 Revenue Expenditure Subtotal Net To Date: Fund Number Current Year Prior Year Net To Date - S Fund Number 32 Owner Occ Rehab #1001053 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 $ 804.13 $ 794.47 $ 9.66 Expenditure $ 1,245.15 $ 59.98 $ 1,185.17 Subtotal Net To Date: $ (441.02) $ 734.49 $ (1,175.51) Fund Number 34 Municipal Court Security Fee Current Year Prior Year Net To Date Revenue $ 623.27 $ 607.13 $ 16.14 Expenditure $ 494.71 $ 692.62 $ (197.91) Subtotal Net To Date: $ 128.36 $ (85A9) $ 214.05 Fund Number 35 Municipal Court Child Safe Fee Current Year Prior Year Net To Date Revenue $ 85.71 $ 130.89 $ (45.18) Expenditure Subtotal Net To Date: $ 85.71 $ 130.89 $ (45.18) Fund Number 36 Municipal Court Time Pay Fee Current Year Prior Year Net To Date Revenue $ 161.82 $ 146.47 $ 15.35 Expenditure $ 150.00 $ - $ 150.00 Subtotal Net To Date: $ 11.82 $ 146.47 $ (134.65) Fund Number 37 Police Conf Fds- Gambling Current Year Prior Year Net To Date Revenue $ 3.57 $ 1.98 $ 1.59 Expenditure $ - $ - $ - Subtotal Net To Date: $ 3.57 $ 1.98 $ 1.s9 Fund Number 38 Police Judicial Forfeitures Current Year Prior Year Net To Date Revenue $ 11,893.18 $ 8.88 $ 11,884.30 Expenditure $ 4,158.00 $ 1,305.00 $ 2,853.00 Subtotal Net To Date: $ 7,735.18 $ (1,296.12) $ 9,031.30 Fund Number Fund Number 39 Equitable Sharing Forfeitures Current Year Prior Year Net To Date Revenue $ 124.17 $ 82.20 $ 41.97 Expenditure $ 2,937.18 $ 7,000.00 $ (4,062.82) Subtotal Net To Date: $ (2,813.01) $ (6,917.80) $ 4,104.79 Fund Number 40 City of Paris CO'93 Const Fund Current Year Prior Year Net To Date Revenue $ - $ - $ Expenditure $ - $ - $ Subtotal Net To Date: $ - $ - $ - Fund Number 41 Tax & Rev CO 2000 Const Fund Current Year Prior Year Net To Date Revenue $ - $ 0.02 $ (0.02) Expenditure $ - $ - $ - Subtotal Net To Date: $ - $ 0.02 $ (0.02) Fund Number 42 CO Series 2002 Construction Fd Current Year Prior Year Net To Date Revenue $ $ - $ - Expenditure $ $ - $ - Subtotal Net To Date: $ - $ $ Fund Number 43 GO Bonds 2013 Construction Fd Current Year Prior Year Net To Date Revenue $ 31,880.40 $ 8,775.65 $ 23,104.75 Expenditure $ 634,824.11 $ 448,105.45 $ 186,718.66 Subtotal Net To Date: $ (602,943.71) $ (439,329.80) $ (163,613.91) Fund Number 45 Land Fill Current Year Prior Year Net To Date Revenue $ 87,125.02 $ - $ 87,125.02 Expenditure $ 100,465.05 $ 68,953.41 $ 31,511.64 Subtotal Net To Date: $ (13,340.03) $ (68,953.41) $ 55,613.38 Fund Number 50 Revenue Bonds Sinking Funds Current Year Prior Year Net To Date Revenue $ 28,959.53 $ 28,376.51 $ 583.02 Expenditure $ - $ - $ - Subtotal Net To Date: $ 28,959.53 $ 28,376.51 $ 583.02 Fund Number S1 Tx &RevCOs 2013 (TWDB) I&S Fund Current Year Prior Year Net To Date Revenue $ 22,070.38 $ 2,004.52 $ 20,065.86 Expenditure $ - $ - $ - Subtotal Net To Date: # 22,070.38 # 2,004.32 # 20,065.86 Fund Number 52 2012 GO Refunding Bond I&S Revenue Expenditure Subtotal Net To Date: Fund Number 53 Tax & Rev CO 2010 I&S Fund Revenue Expenditure Subtotal Net To Date: Fund Number 54 City of Paris CO'93 I&S Fund Revenue Expenditure Subtotal Net To Date: Fund Number 55 Tax & Rev CO 2000 I&S Fund Revenue Expenditure Subtotal Net To Date: Fund Number 56 Tax & Rev CO 2002 I&S Fund Revenue Expenditure Subtotal Net To Date: Fund Number 57 Contractual Oblig I&S Fund Expenditure Subtotal Net To Date: Fund Number Current Year Prior Year Net To Date Current Year Prior Year Net To Date $ 2,162.29 $ 4,948.88 $ (2,786.59) # 2,162.29 # 4,948.88 # (2,786.59) Current Year Prior Year Net To Date Current Year Prior Year Net To Date Current Year Prior Year Net To Date Current Year Prior Year Net To Date 58 2003 GO Refunding Bonds Revenue Expenditure Subtotal Net To Date: Fund Number Current Year Prior Year Net To Date 59 2010 GO /W&S Refunding Bonds Current Year Prior Year Net To Date Revenue $ 83,359.75 $ 108,407.82 $ (25,048.07) Expenditure $ - $ - $ - Subtotal Net To Date: $ 83,359.75 $ 108,407.82 $ (25,048.07) Fund Number 60 Refunding Bonds 2012 Revenue Expenditure Subtotal Net To Date: Fund Number Current Year Prior Year Net To Date $ 3,266.82 $ 9,487.82 $ (6,221.00) $ 3,266.82 $ 9,487.82 $ (6,221.00) Fund Number 61 Interlocal Coop Agreement I&S Current Year Prior Year Net To Date Revenue $ 696.16 $ 2,291.45 $ (1,595.29) Expenditure $ - $ - $ Subtotal Net To Date: $ 696.16 $ 2,291.45 $ (1,595.29) Fund Number 62 G O Bonds 2013 I&S Fund Current Year Prior Year Net To Date Revenue $ 220,802.44 $ 105,873.46 $ 114,928.98 Expenditure $ - $ - $ - Subtotal Net To Date: $ 220,802.44 $ 105,873.46 $ 114,928.98 Fund Number 63 CO Bonds - 2015 Current Year Prior Year Net To Date Revenue $ $ - $ - Expenditure $ $ - $ - Subtotal Net To Date: $ $ - $ - Fund Number 70 Employees Insurance Fund Current Year Prior Year Net To Date Revenue $ - $ - $ Expenditure $ - $ - $ Subtotal Net To Date: $ - $ - $ Fund Number Fund Number 75 Wilbor Deshong Trust Fund Revenue Expenditure Subtotal Net To Date: Current Year Prior Year Net To Date Fund Number 71 Insurance Claims Fund Current Year 76 Gibbs Library Fund Prior Year Net To Date Net To Date Revenue Revenue $ $ - $ $ $ Expenditure $ $ - $ - Subtotal Net To Date: ; - # - # - Revenue $ - $ - Fund Number Expenditure $ $ - $ - Subtotal Net To Date: ; - ; - 72 Library Memorial Fund Current Year Prior Year Net To Date Revenue $ 220.67 $ 249.83 $ (29.16) Expenditure $ 92.66 $ - $ 92.66 Subtotal Net To Date: ; 128.01 ; 249.83 ; (121.82) 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 Fund Revenue Expenditure Subtotal Net To Date: Current Year Prior Year 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 Memorial Current Year Prior Year Net To Date Revenue $ - $ - $ Expenditure $ $ - $ - Subtotal Net To Date: ; - ; - # Fund Number 78 Subtotal Fund Number 79 Subtotal Fund Number 80 Subtotal Malone H Love Memorial Fund Current Year Prior Year Net To Date Revenue $ $ - $ Expenditure $ - $ $ Net To Date: $ $ - $ Library Expendable Fund Current Year Prior Year Net To Date Revenue $ 57.20 $ 35.95 $ 21.25 Expenditure $ - $ - $ - Net To Date: $ 57.20 $ 35.95 $ 21.25 Library Permanent Fund Current Year Prior Year Net To Date Revenue $ 0.41 $ 0.23 $ 0.18 Expenditure $ - $ $ - Net To Date: $ 0.41 $ 0.23 $ 0.18