General Fund Finance Report (May 2020)

        May 20 Oct ’19 – May 20   YTD Budget   % of Budget
  Income              
    311000 · Ad Valorem (2019)  Assessment 893.05 70,899.42   44,000.00   161.14%
    311001 · Ad Valorem (2019) Future 0.00 0.00   28,787.00   0.0%
    312410 · 1st Local Opt Fuel Tax (LOCOP) 3,520.43 29,464.64   37,900.00   77.74%
    312600 · Discretionary Surtax (DISC) 9,655.16 72,560.21   128,000.00   56.69%
    314100 · Utility Service Tax (FPL-MT) 5,746.42 35,379.90   51,600.00   68.57%
    314800 · Utility Service Tax – Propane 16.64 879.19   3,500.00   25.12%
    315000 · Communication Svc Tax (CST) 1,191.34 11,460.13   9,600.00   119.38%
    322000 · Building Permit Fee 493.85 19,993.25   10,000.00   199.93%
    323100 · Franchise Fee/Electric (FPL-FR) 2,875.63 25,202.95   37,000.00   68.12%
    329000 · Other Fees – (State Surcharges) 13.31 447.86   300.00   149.29%
    334360 · State Grant – StormWater (CDBG) 0.00 79,105.36   600,000.00   13.18%
    334704 · State – FRDAP (Parks Upgrade) 0.00 0.00   50,000.00   0.0%
    335120 · State Revenue Sharing 2,483.60 27,613.52   51,300.00   53.83%
    335180 · Local Govt 1/2 ct Tx (Sale) 3,424.78 28,623.01   43,300.00   66.1%
    335490 · Other (FDOT Lighting/Signal) 0.00 0.00   7,600.00   0.0%
    337100 · Local Grant (Historical Museum) 0.00 0.00   40,000.00   0.0%
    342500 · Svc Chg/Annual Fire Inspection 0.00 0.00   1,500.00   0.0%
    343900 · Other – (FDOT Mowing/Misc) 0.00 11,102.05   15,000.00   74.01%
    347200 · Service Charge – Parks & Rec 0.00 0.00   150.00   0.0%
    351500 · Judgments & Fees (Traffic) 0.00 0.00   100.00   0.0%
    361200 · Interest Income 208.85 5,460.60   8,500.00   64.24%
    366000 · Contribution/Donations/Private 0.00 0.00   100.00   0.0%
    367000 · License (Business) 0.00 12.00   50.00   24.0%
    369900 · Other Miscellaneous Revenues 0.00 9,032.46   100.00   9,032.46%
    381000 · Water Utility Transfer In 3,273.32 30,856.75   72,700.00   42.44%
    381002 · WW/Sewer Transfer In 1,375.89 12,835.79   47,500.00   27.02%
    389901 · Building Permit Capital (2019) 0.00 3,470.00   73,470.00   4.72%
  Total Income 35,172.27 474,399.09   1,362,057.00   34.83%
  Expense              
    5110000 · Legislative Salaries (Council)            
      5119000 · Council Reserve Fund 0.00 1,374.49   6,975.00   19.71%
    Total 5110000 · Legislative Salaries (Council) 0.00 1,374.49   6,975.00   19.71%
    5121000 · Executive Salaries            
      5121100 · Town Manager Salary 4,292.54 39,313.90   56,303.00   69.83%
      5122100 · Payroll Tax Expense 442.19 7,740.32   11,261.00   68.74%
      5122200 · Pension Plan Expense 429.26 3,931.44   5,580.00   70.46%
      5122300 · Health Insurance 515.90 3,579.75   4,701.00   76.15%
    Total 5121000 · Executive Salaries 5,679.89 54,565.41   77,845.00   70.1%
    5131000 · Reg Salaries & Wages            
      5131200 · Water Admin Salary (Wendy) (108.51) (964.94)   30,470.00   (3.17%)
      5131201 · Town Clerk Salary (Anita) 3,280.00 30,112.27   45,600.00   66.04%
      5131202 · Admin. Assist. Salary (Rachael) 1,507.00 13,416.00   20,940.00   64.07%
      5132100 · Payroll Tax Expense 266.80 6,322.36   11,370.50   55.6%
      5132200 · Pension Plan Expense 355.27 3,963.84   9,087.00   43.62%
      5132300 · Health Insurance 1,136.68 8,511.27   14,025.00   60.69%
      5132400 · Workers’ Comp 0.00 3,457.58   7,108.00   48.64%
    Total 5131000 · Reg Salaries & Wages 6,437.24 64,818.38   138,600.50   46.77%
    5133000 · Financial & Admin – (Oper Exp)            
      5133100 · Professional Services 950.00 1,530.00   2,500.00   61.2%
      5133200 · Accounting/Auditing 0.00 2,946.00   8,000.00   36.83%
      5134100 · Telephone 485.83 4,289.16   7,200.00   59.57%
      5134600 · Repair & Maintenance 330.00 500.00   500.00   100.0%
      5134901 · Legal Ads 72.00 611.14   1,500.00   40.74%
      5135200 · Operating Supplies (Bank Fees) 76.95 727.26   1,500.00   48.48%
      5135400 · Dues/Subscriptions 14.00 2,687.72   3,000.00   89.59%
      5135500 · Education/Training 0.00 0.00   300.00   0.0%
    Total 5133000 · Financial & Admin – (Oper Exp) 1,928.78 13,291.28   24,500.00   54.25%
    5140000 · Legal Services            
      5140001 · Town Attorney Expense 0.00 1,700.00   2,500.00   68.0%
    Total 5140000 · Legal Services 0.00 1,700.00   2,500.00   68.0%
    5191000 · General Govt Salaries            
      5191200 · Grant Writer Salary 200.00 1,800.00   2,600.00   69.23%
      5192100 · Payroll Taxes 7.65 130.05   208.00   62.52%
    Total 5191000 · General Govt Salaries 207.65 1,930.05   2,808.00   68.73%
    5193000 · General Government (Oper Exp)            
      5194200 · Postage/Freight 93.15 784.22   1,000.00   78.42%
      5194300 · Utilities Expense 194.53 2,025.02   3,500.00   57.86%
      5194400 · Rentals/Leases 399.00 3,630.90   5,050.00   71.9%
      5194500 · Insurance (Property) 0.00 3,591.08   6,274.00   57.24%
      5195100 · Office Supplies 834.92 6,976.95   8,500.00   82.08%
      5195102 · Emergency Plan Exp (CEMP) 80.75 80.75   1,000.00   8.08%
    Total 5193000 · General Government (Oper Exp) 1,602.35 17,088.92   25,324.00   67.48%
    5196000 · Capital Expenditure (> $5,000)            
      5196200 · Capital Outlay – Unrestricted 229.20 3,283.59   37,650.00   8.72%
      5196202 · Historic Museum – Restricted 0.00 0.00   2,691.00   0.0%
      5196211 · Double Gate (Water Tower) -ADV 0.00 0.00   2,000.00   0.0%
      5196225 · Ad Valorem – Restricted (2019) 0.00 0.00   28,787.00   0.0%
      5196300 · Passive Park – Restoration-ADV 0.00 0.00   10,000.00   0.0%
      5196302 · Paint/Landscape Town Hall – BPR 0.00 0.00   15,000.00   0.0%
      5196303 · ADA Restrooms – BPR 0.00 0.00   30,000.00   0.0%
      5196305 · Town Hall / Storage Room – BPR 0.00 0.00   25,000.00   0.0%
      5196307 · New Town Website – BPR 0.00 3,470.00   3,470.00   100.0%
    Total 5196000 · Capital Expenditure (> $5,000) 229.20 6,753.59   154,598.00   4.37%
    5210000 · TOPF – Grants            
      5210001 · State Grant – CDBG Storm Water 0.00 79,105.36   600,000.00   13.18%
      5210002 · State Grant –  Park Upgrades 0.00 0.00   50,000.00   0.0%
      5210003 · Local Grant – Historical Museum 0.00 0.00   40,000.00   0.0%
    Total 5210000 · TOPF – Grants 0.00 79,105.36   690,000.00   11.47%
    5243000 · Protective Inspections            
      5243100 · Inspections / Plan Reviews 525.00 7,805.00   8,000.00   97.56%
      5244900 · State Surcharge Fees 0.00 97.40   300.00   32.47%
    Total 5243000 · Protective Inspections 525.00 7,902.40   8,300.00   95.21%
    5411000 · Public Works (Salaries)            
      5411200 · Public Works (Tracy) 0.00 3,275.00   3,275.00   100.0%
      5411201 · Public Works (Alex) 2,438.07 22,317.60   45,860.00   48.67%
      5411204 · Public Works (Trevor) 1,697.81 15,496.75   30,440.00   50.91%
      5411205 · – Public Works (Josh) 51.20 51.20   46,435.00   0.11%
      5412100 · Payroll Tax Expense 126.39 4,622.31   10,201.00   45.31%
      5412200 · Pension Plan Expense 390.26 3,730.76   11,856.00   31.47%
      5412300 · Health Insurance 593.07 6,279.07   17,627.50   35.62%
      5412400 · Workers’ Compensation 0.00 3,457.60   7,108.00   48.64%
    Total 5411000 · Public Works (Salaries) 5,296.80 59,230.29   172,802.50   34.28%
    5413000 · Public Works (Oper Exp)            
      5414100 · Telephone 299.16 2,278.05   4,200.00   54.24%
      5414300 · Utilities/Electric Expense 984.94 7,577.01   11,000.00   68.88%
      5414500 · Insurance (Auto/Truck) 0.00 865.16   1,459.00   59.3%
      5414600 · Repair & Maintenance 1,355.69 5,199.34   9,500.00   54.73%
      5415200 · Operating Supplies 0.00 2,737.46   5,000.00   54.75%
      5415201 · Fuel 374.97 3,597.09   7,500.00   47.96%
      5415202 · Uniforms 0.00 0.00   400.00   0.0%
      5415300 · Road Materials/Supplies/Equip 0.00 4,759.22   1,000.00   475.92%
      5415500 · Training (Certification) 0.00 0.00   100.00   0.0%
    Total 5413000 · Public Works (Oper Exp) 3,014.76 27,013.33   40,159.00   67.27%
    5723000 · Parks & Recreation (Oper Exp)            
      5724300 · Utilities/Electric Expense 66.43 519.55   1,000.00   51.96%
      5724500 · Insurance (General Liability) 0.00 6,253.08   12,945.00   48.31%
      5724600 · Repair & Maintenance 0.00 2,764.35   1,000.00   276.44%
      5724800 · Special Events (Parades, etc) 0.00 2,036.13   2,500.00   81.45%
    Total 5723000 · Parks & Recreation (Oper Exp) 66.43 11,573.11   17,445.00   66.34%
    5810000 · Interfund Transfers Out            
      5810001 · Transfer Out to Sewer Fund 0.00 1,925.00   100.00   1,925.0%
      5810003 · Transfer Out to Water Utility 0.00 1,400.00   100.00   1,400.0%
    Total 5810000 · Interfund Transfers Out 0.00 3,325.00   200.00   1,662.5%
  Total Expense 24,988.10 349,671.61   1,362,057.00   25.67%
Net Income     10,184.17 124,727.48   0.00   100.0%