Loading...
07 - DECEMBER 2016 FINANCIAL REPORTItem No. 7 memorandum TO: City Council John Godwin, City Manager FROM: Gene Anderson, Finance Director SUBJECT: DECEMBER 2016 FINANCIAL REPORT DATE: January 17, 2017 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 December 2016 Financial Report Comments Net to Date Comparison of Revenues: 1. The operations and maintenance property tax and related collections are 1.13% less than this time last year. Current taxes are 30.11% collected vs. 30.05% last year. 2. Sales taxes are up 2.77% from last year. 3. Hotel occupancy taxes are down 2.39% from last year. All hotels are current on their taxes. 4. Franchise fees are up 2.43% compared to last year. 5. Permit fees are up 7.89 %. This is only $2,492. 6. Municipal Court fines are 20.87% below last year's collections. This is only $14,734. 7. Other revenue includes leases, interest, copy fees, birth & death certificates, library fees, mixed beverage tax, and other minor revenues. This revenue is up 422.09 %. This amounts to $97,271 and is due to Ramp Grant reimbursement, tower rental, purchase card rebate, and other miscellaneous revenues. 8. EMS fees are up 5.79% compared to last year. 9. Total General Fund revenues are 2.67% above last year. General Fund revenues equal 27.25% of the budget with the City being 25.00% through the budget year. 10. Total General Fund expenditures are down 8.55% compared to last year. General Fund expenditures to date equal 24.56% of budget with the City being 25.00% through the budget year. 11. Sewer revenue is up 0.47% compared to last year. 12. Water revenue is down 0.49% compared to last year. 13. Total Water & Sewer revenues, ignoring transfers, are 0.47% above last year. 14. Total Water & Sewer expenses are 5.91% below last year at this point and represent 16.61% of the total budget (27.58% adjusted for debt payments) while the City is 25.00% through the budget year. Departmental Expenditure Summary: At this point the City is three months or 25.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 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 six departments whose expenditures are over 25.00 %. 1. City Council- 46.24%. The overage amounts to $16,238. This overage is due to making the annual payments for general liability insurance, membership in the Ark -Tex Council of Governments, and electrical repairs to the building. 2. Police - 25.81%. The overage amounts to $49,930 and is due to the annual payment for general liability insurance, uniforms, supplies, vehicle maintenance, and confidential funds. 3. Streets - 29.79 %. The overage amounts to $116,878 and is due to the annual payment for general liability insurance, contract services for concrete work, and temp workers. 4. Cox Field Airport - 32.83 %. The overage amounts to $8,375 and is due to the annual insurance payment. 5. Library - 25.42 %. The overage amounts to $2,953 and is due to the annual payment for general liability insurance, postage, technical processing, and utilities. 6. General Expenses - 33.01 %. The overage amounts to $128,618 and is due to annual payment to non - profits and purchase of IT related equipment. 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. 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 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. 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 -Dec 2016 General Fund: Current Prior Net Report Sort Sequence Report Group Description Year Year To Date 70 Taxes Collected 2,144,911.92 2,169,513.08 - 24,601.16 71 Sales Tax 1,773,792.49 1,725,872.20 47,920.29 72 Hotel /Motel Tax 164,832.85 168,869.97 - 4,037.12 73 Franchise Fees 864,854.04 844,308.49 20,545.55 74 Permits 34,040.01 31,547.76 2,492.25 75 Court Fines 55,863.16 70,597.22 - 14,734.06 77 Other Revenue 120,316.30 23,045.04 97,271.26 78 Sanitation 103,360.36 103,697.54 - 337.18 79 Ems Fees 639,147.67 604,162.51 34,985.16 84 Water and Sewer Transfers 224,749.98 224,749.98 0.00 0 Miscellaneous Revenue 0.00 0.00 0.00 Total Revenue: $ 6,125,868.78 $ 5,966,363.79 $ 159,504.99 Total Expenditures: $ 5,518,503.73 $ 6,035,050.54 $ (516,546.81) Net To Date: $ 607,365.05 $ (68,686.75) $ 676,051.80 Water and Sewer Transfers Ems Fees Sanitation Other Revenue Court Fines Permits Franchise Fees Hotel /Motel Tax Sales Tax Taxes Collected 0.00 500, 000. 001, 000, 000. 001, 500 ,000.0 @,000,000.002,500,000.00 • Prior Year • Current Year Expenditures Fund Number 1 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 - Departmental 0.00 0.00 0.00 0.00 0.00 0.00 11 City Council 4,511.53 3,586.50 35,345.78 33,423.53 76,430.00 73,930.00 12 City Manager 27,355.54 27,146.09 85,924.57 95,579.96 376,383.00 369,563.00 13 City Attorney 22,715.57 24,301.31 62,339.21 98,024.47 378,928.00 438,910.00 14 Municipal Court 15,344.65 15,401.26 53,617.45 59,677.22 232,063.00 229,092.00 15 City Clerk 9,847.26 9,826.55 33,625.98 36,264.45 143,688.00 140,958.00 21 Accounting & Auditing 39,041.14 31,273.50 104,023.81 109,320.26 425,416.00 420,501.00 31 Police 539,016.23 507,017.78 1,578,227.81 1,783,577.51 6,113,190.00 6,073,596.00 32 Fire 342,154.59 331,707.96 1,130,252.93 1,311,297.38 4,680,012.77 4,381,076.00 40 Community Developm� 31,901.36 - 54,080.30 107,792.02 - 6,801.83 541,768.00 463,692.00 41 Engineering 24,227.31 23,814.78 67,702.28 89,585.34 492,522.00 513,374.00 42 Public Works 16,587.49 16,249.58 50,188.67 56,533.75 216,337.00 205,471.00 43 Parks,Recreation,& RC 53,411.92 70,207.20 187,363.54 235,056.07 1,120,324.00 1,140,560.00 44 Sanitation 98.34 11,858.09 1,508.18 12,684.71 0.00 0.00 46 Streets & Highways 156,981.52 112,755.22 467,512.55 492,084.57 1,569,116.00 1,488,440.00 48 Traffic & Public Lightir 41,501.06 70,554.58 125,416.15 126,612.60 583,250.00 593,119.00 49 Garage 23,754.48 29,690.21 76,920.43 90,926.46 342,686.00 341,450.00 51 Paris -Lamar Co Health 80.00 0.00 80.00 0.00 0.00 0.00 54 Emergency Medical Se 199,501.74 178,289.38 608,878.54 606,620.03 2,693,797.00 2,332,850.00 61 Cox Field Airport 6,903.10 8,499.23 35,113.34 25,406.80 106,950.00 103,350.00 62 Paris Band 0.00 0.00 53.23 93.71 23,050.00 23,050.00 64 Library 44,847.65 57,980.72 176,666.00 211,200.91 694,850.00 691,853.00 89 General Expenses 116,374.90 63,201.75 529,951.26 567,882.64 1,605,333.00 1,598,860.00 90 Debt 0.00 0.00 0.00 0.00 0.00 0.00 91 Contingency 0.00 0.00 0.00 0.00 50,000.00 50,000.00 Total General Fund $1,716,157.38 $1,539,281.39 $5,518,503.73 $6,035,050.54 $22,466,093.77 $21,673,695.00 Water Sewer Fund: Current Prior Net - 1,000,000.00;00,000.00 0.00 500,000.00., 000, 000. OA500 ,000.0AOOO,OOO.OII500,000.00 Fund Number ■ Prior Year ■ Current Year Revenue Group Year Year To Date Water 2,076,886.52 2,087,170.64 - 10,284.12 Sewer 1,438,509.16 1,431,700.63 6,808.53 Transfers - 996,000.00 - 353,000.00 - 643,000.00 Other 130,479.91 109,761.63 20,718.28 Total Revenue: $ 2,649,875.59 $ 3,275,632.90 $ (625,757.31) Total Expenditures: $ 2,340,248.68 $ 2,487,442.66 $ (147,193.98) Net To Date: $ 309,626.91 $ 788,190.24 $ (478,563.33) - 1,000,000.00;00,000.00 0.00 500,000.00., 000, 000. OA500 ,000.0AOOO,OOO.OII500,000.00 Fund Number ■ Prior Year ■ Current Year 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 8,415.45 7,631.56 26,573.12 81 W & S Billing and Collecting 183,104.20 173,223.05 526,674.73 82 Water Production 232,494.16 222,596.62 642,810.64 83 Water Distribution 135,143.32 184,168.72 382,638.07 85 Sewer Maintenance 35,422.67 83,282.86 138,043.03 86 Waste Water Treatment 231,687.33 154,938.22 543,495.58 87 Lift Stations 27,847.12 42,503.30 80,013.51 Total Water & Sewer Fund $854,114.25 $868,344.33 $2,340,248.68 Prior Year To Date 28,799.57 524,154.72 632,052.34 435,632.24 227,701.15 509,338.14 129,764.50 $2,487,442.66 Current 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 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 Fund Number 2 Economic Development Fund Current Year Prior Year Net To Date Revenue $ 265,290.02 $ 258,249.66 $ 7,040.36 Expenditure $ 86,231.20 $ 34,893.72 $ 51,337.48 Subtotal Net To Date: $ 179,058.82 $ 223,355.94 $ (44,297.12) Fund Number 11 Capital Projects Fund Current Year Prior Year Net To Date Revenue $ 1,896.55 $ 359.85 $ 1,536.70 Expenditure $ 334,984.21 $ 9,207.78 $ 325,776.43 Subtotal Net To Date: $ (333,087.66) $ (8,847.93) $ (324,239.73) 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 $ 138.98 $ (116.48) $ 255.46 Expenditure $ - $ - $ - Subtotal Net To Date: $ 138.98 $ (116.48) $ 255.46 Fund Number 14 CO 2010 Construction Fund Current Year Prior Year Net To Date Revenue $ 299.29 $ 1,253.28 $ (953.99) Expenditure $ 461.50 $ 111.70 $ 349.80 Subtotal Net To Date: $ (162.21) $ 1,141.58 $ (1,303.79) Fund Number 16 TWDB Loan Fund Current Year Prior Year Net To Date Revenue $ 79.56 $ 184,070.18 $ (183,990.62) Expenditure $ - $ 220,011.29 $ (220,011.29) Subtotal Net To Date: $ 79.56 $ (35,941.11) $ 36,020.67 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 $ 3.98 $ 10.05 $ (6.07) Expenditure $ 600.00 $ 20,000.17 $ (19,400.17) Subtotal Net To Date: $ (596.02) $ (19,990.12) $ 19,394.10 Fund Number 22 Health Department Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number Fund Number 23 PEG Channel Fund Current Year Prior Year Net To Date Revenue $ 13,631.66 $ 13,966.57 $ (334.91) Expenditure $ - $ - $ Subtotal Net To Date: ; 13,631.66 ; 13,966.57 ; (334.91) Fund Number 24 Lake Crook Restoration Fund Current Year Prior Year Net To Date Revenue $ 9.04 $ 140.64 $ (131.60) Expenditure $ - $ - $ Subtotal Net To Date: $ 9.04 ; 140.64 ; (131.60) Fund Number 25 Grant Fund Current Year Prior Year Net To Date Revenue $ 92,213.46 $ 75,138.44 $ 17,075.02 Expenditure $ 165,554.03 $ 406,978.96 $ (241,424.93) Subtotal Net To Date: ; (73,340.57) ; (331,840.52) ; 258,499.95 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 $ 3,840.63 $ 4,638.24 $ (797.61) Subtotal Net To Date: $ - $ - $ - ; 3,840.63 ; 4,638.24 ; (797.61) Fund Number 30 Community Dvl Block Grant Fund Current Year Prior Year Net To Date Revenue $ 604.89 $ 921.58 $ (316.69) Expenditure $ 13,237.50 $ 18,850.31 $ (5,612.81) Subtotal Net To Date: ; (12,632.61) ; (17,928.73) ; 5,296.12 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 #1001053 Revenue Expenditure Subtotal Net To Date: Fund Number 33 Municipal Court Tech Fee Revenue Expenditure Subtotal Net To Date: Fund Number 34 Municipal Court Security Fee Revenue Expenditure Subtotal Net To Date: Fund Number 35 Municipal Court Child Safe Fee Revenue Expenditure Subtotal Net To Date: Fund Number 36 Municipal Court Time Pay Fee Revenue Expenditure Subtotal Net To Date: Fund Number 37 Police Conf Fds- Gambling Revenue Expenditure Subtotal Net To Date: Fund Number 38 Police Judicial Forfeitures Revenue Expenditure Subtotal Net To Date: Fund Number Current Year Prior Year Net To Date Current Year Prior Year Net To Date $ 2,192.09 $ 2,318.90 $ (126.81) $ 1,278.23 $ (5,472.27) $ 6,750.50 $ 913.86 $ 7,791.17 $ (6,877.31) Current Year Prior Year Net To Date $ 1,710.71 $ 1,777.27 $ (66.56) $ 1,534.45 $ 1,434.71 $ 99.74 $ 176.26 $ 342.56 $ (166.30) Current Year Prior Year Net To Date $ 247.35 $ 346.14 $ (98.79) $ 4,626.00 $ - $ 4,626.00 $ (4,378.65) $ 346.14 $ (4,724.79) Current Year Prior Year Net To Date $ 394.87 $ 460.94 $ (66.07) $ 1,652.20 $ - $ 1,652.20 $ (1,257.33) $ 460.94 $ (1,718.27) Current Year Prior Year Net To Date $ 11.99 $ 6.55 $ 5.44 - $ 11.99 $ 6.55 $ 5.44 Current Year Prior Year Net To Date $ 12,014.19 $ (1,053.76) $ 13,067.95 $ 7,961.50 $ 1,305.00 $ 6,656.50 $ 4,052.69 $ (2,358.76) $ 6,411.45 39 Equitable Sharing Forfeitures Revenue Expenditure Subtotal Net To Date: Current Year Prior Year Net To Date $ 399.87 $ 7,578.96 $ (7,179.09) $ 16,308.23 $ 7,000.00 $ 9,308.23 f (15,908.36) ; 578.96 (16,487.32) 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.06 $ (0.06) Expenditure $ $ $ Subtotal Net To Date: $ $ 0.06 $ (0.06) 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 $ 37,437.51 $ 22,568.37 $ 14,869.14 Expenditure $ 2,300,438.00 $ 1,758,917.36 $ 541,520.64 Subtotal Net To Date: $ (2,263,000.49) $ (1,736,348.99) $ (526,651.50) Fund Number 45 Land Fill Current Year Prior Year Net To Date Revenue $ 261,010.80 $ 260,506.15 $ 504.65 Expenditure $ 240,920.85 $ 227,321.85 $ 13,599.00 Subtotal Net To Date: $ 20,089.95 $ 33,184.30 $ (13,094.35) Fund Number 50 Revenue Bonds Sinking Funds Current Year Prior Year Net To Date Revenue $ 84,651.51 $ 84,998.30 $ (346.79) Expenditure $ - $ - $ - Subtotal Net To Date: $ 84,651.51 $ 84,998.30 $ (346.79) Fund Number 51 Tx &RevCOs 2013 (TWDB) I &S Fund Current Year Prior Year Net To Date Revenue $ 54,275.73 $ 6,012.91 $ 48,262.82 Expenditure $ 9,773.25 $ 9,773.25 $ - Subtotal Net To Date: $ 44,502.48 $ (3,760.34) $ 48,262.82 Fund Number 52 2012 GO Refunding Bond I&S Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 53 Tax & Rev CO 2010 I &S Fund Current Year Prior Year Net To Date Revenue $ 100,072.03 $ 70,153.44 $ 29,918.59 Expenditure $ 174,295.63 $ 171,639.38 $ 2,656.25 Subtotal Net To Date: $ (74,223.60) $ (101,485.94) $ 27,262.34 Fund Number 54 City of Paris CO '93 I &S Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 55 Tax & Rev CO 2000 I &S Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 56 Tax & Rev CO 2002 I &S Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 57 Contractual Oblig I &S Fund Current Year Prior Year Net To Date Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 58 2003 GO Refunding Bonds Current Year Prior Year Net To Date 63 CO Bonds - 2015 Revenue $ - $ - $ Revenue Expenditure $ $ $ Subtotal Net To Date: $ $ - Fund Number $ 22,282.01 $ $ 22,282.01 59 2010 GO /W &S Refunding Bonds Current Year Prior Year Net To Date 70 Employees Insurance Fund Revenue $ 412,830.22 $ 440,246.98 $ (27,416.76) Revenue Expenditure $ 468,612.50 $ 479,125.00 $ (10,512.50) Subtotal Net To Date: $ (55,782.28) $ (38,878.02) $ (16,904.26) Fund Number $ $ $ 60 Refunding Bonds 2012 Current Year Prior Year Net To Date Revenue $ 126,281.26 $ 132,012.21 $ (5,730.95) Expenditure $ 381,375.00 $ 379,875.00 $ 1,500.00 Subtotal Net To Date: $ (255,093.74) $ (247,862.79) $ (7,230.95) Fund Number 61 Interlocal Coop Agreement I &S Current Year Prior Year Net To Date Revenue $ 29,654.69 $ 32,633.46 $ (2,978.77) Expenditure $ - $ - $ Subtotal Net To Date: $ 29,654.69 $ 32,633.46 $ (2,978.77) Fund Number 62 G O Bonds 2013 I &S Fund Revenue Expenditure Subtotal Net To Date: Current Year Prior Year Net To Date $ 591,702.97 $ 212,333.16 $ 379,369.81 $ 1,489,487.50 $ 1,280,087.50 $ 209,400.00 $ (897,784.53) $ (1,067,754.34) $ 169,969.81 Fund Number 63 CO Bonds - 2015 Current Year Prior Year Net To Date Revenue $ 22,282.01 $ $ 22,282.01 Expenditure $ - $ $ - Subtotal Net To Date: $ 22,282.01 $ $ 22,282.01 Fund Number 70 Employees Insurance Fund Current Year Prior Year Net To Date Revenue $ $ $ - Expenditure $ $ $ Subtotal Net To Date: $ $ $ Fund Number 71 Subtotal Fund Number 72 Subtotal Fund Number 73 Subtotal Fund Number 74 Subtotal Fund Number 75 Subtotal Fund Number 76 Subtotal Fund Number 77 Subtotal Fund Number Insurance Claims Fund Current Year Prior Year Net To Date Revenue $ $ $ - Expenditure $ $ $ Net To Date: # # ; - Library Memorial Fund Current Year Prior Year Net To Date Revenue $ 477.97 $ 545.68 $ (67.71) Expenditure $ 357.39 $ 461.65 $ (104.26) Net To Date: # 120.58 ; 84.03 # 36.55 A Love Trust Fund Current Year Prior Year Net To Date Revenue $ $ - $ - Expenditure $ $ $ Net To Date: # # # I P Poteet Trust Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Net To Date: Wilbor Deshong Trust Fund Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Net To Date: ; # ; Gibbs Library Fund Current Year Prior Year Net To Date Revenue $ - $ $ Expenditure $ $ $ Net To Date: # ; ; W B & Kathryn Vaughan Memorial Current Year Prior Year Net To Date Revenue $ $ $ Expenditure $ $ $ Net To Date: ; # ; 78 Malone H Love Memorial Fund Revenue Expenditure Subtotal Net To Date: Current Year Prior Year Net To Date Fund Number 79 Library Expendable Fund Current Year Prior Year Net To Date Revenue $ 192.11 $ 118.85 $ 73.26 Expenditure $ - $ - $ - Subtotal Net To Date: # 192.11 # 118.85 # 73.26 Fund Number 80 Library Permanent Fund Current Year Prior Year Net To Date Revenue $ 1.38 $ 0.76 $ 0.62 Expenditure $ $ $ Subtotal Net To Date: # 1.38 # 0.76 $ 0.62