General Fund Finance Report – April 2020

        Apr 20 Oct ’19 – Apr 20   YTD Budget   % of Budget
  Income            
    311000 · Ad Valorem (2019)  Assessment  $   1,100.53  $        70,006.37    $      44,000.00   159.11%
    311001 · Ad Valorem (2019) Future  $              –    $                    –      $      28,787.00   0.0%
    312410 · 1st Local Opt Fuel Tax (LOCOP)  $   3,322.49  $        25,944.21    $      37,900.00   68.45%
    312600 · Discretionary Surtax (DISC)  $   6,016.46  $        62,905.05    $    128,000.00   49.15%
    314100 · Utility Service Tax (FPL-MT)  $   2,417.67  $        29,633.48    $      51,600.00   57.43%
    314800 · Utility Service Tax – Propane  $        91.31  $             862.55    $        3,500.00   24.64%
    315000 · Communication Svc Tax (CST)  $   1,372.06  $        10,268.79    $        9,600.00   106.97%
    322000 · Building Permit Fee  $      820.50  $        19,499.40    $      10,000.00   194.99%
    323100 · Franchise Fee/Electric (FPL-FR)  $   3,038.71  $        22,327.32    $      37,000.00   60.34%
    329000 · Other Fees – (State Surcharges)  $        24.87  $             434.55    $           300.00   144.85%
    334360 · State Grant – StormWater (CDBG)  $ 11,699.50  $        79,105.36    $    600,000.00   13.18%
    334704 · State – FRDAP (Parks Upgrade)  $              –    $                    –      $      50,000.00   0.0%
    335120 · State Revenue Sharing  $   3,589.98  $        25,129.92    $      51,300.00   48.99%
    335180 · Local Govt 1/2 ct Tx (Sale)  $   3,398.61  $        25,198.23    $      43,300.00   58.2%
    335490 · Other (FDOT Lighting/Signal)  $              –    $                    –      $        7,600.00   0.0%
    337100 · Local Grant (Historical Museum)  $              –    $                    –      $      40,000.00   0.0%
    342500 · Svc Chg/Annual Fire Inspection  $              –    $                    –      $        1,500.00   0.0%
    343900 · Other – (FDOT Mowing/Misc)  $   3,700.68  $        11,102.05    $      15,000.00   74.01%
    347200 · Service Charge – Parks & Rec  $              –    $                    –      $           150.00   0.0%
    351500 · Judgments & Fees (Traffic)  $              –    $                    –      $           100.00   0.0%
    361200 · Interest Income  $      202.17  $          5,251.75    $        8,500.00   61.79%
    366000 · Contribution/Donations/Private  $              –    $                    –      $           100.00   0.0%
    367000 · License (Business)  $              –    $               12.00    $             50.00   24.0%
    369900 · Other Miscellaneous Revenues  $        31.44  $          9,032.46    $           100.00   9,032.46%
    381000 · Water Utility Transfer In  $   4,701.13  $        27,583.43    $      72,700.00   37.94%
    381002 · WW/Sewer Transfer In  $   1,720.63  $        11,459.90    $      47,500.00   24.13%
    389901 · Building Permit Capital (2019)  $   3,470.00  $          3,470.00    $      73,470.00   4.72%
  Total Income  $ 50,718.74  $      439,226.82    $ 1,362,057.00   32.25%
  Expense            
    5110000 · Legislative Salaries (Council)            
      5119000 · Council Reserve Fund  $      111.18  $          1,374.49    $        6,975.00   19.71%
    Total 5110000 · Legislative Salaries (Council)  $      111.18  $          1,374.49    $        6,975.00   19.71%
    5121000 · Executive Salaries            
      5121100 · Town Manager Salary  $   6,619.85  $        35,021.36    $      56,303.00   62.2%
      5122100 · Payroll Tax Expense  $   1,380.42  $          7,298.13    $      11,261.00   64.81%
      5122200 · Pension Plan Expense  $      661.99  $          3,502.18    $        5,580.00   62.76%
      5122300 · Health Insurance  $      257.95  $          3,063.85    $        4,701.00   65.17%
    Total 5121000 · Executive Salaries  $   8,920.21  $        48,885.52    $      77,845.00   62.8%
    5131000 · Reg Salaries & Wages            
      5131200 · Water Admin Salary (Wendy)  $      (31.00)  $           (856.43)    $      30,470.00   (2.81%)
      5131201 · Town Clerk Salary (Anita)  $   4,920.00  $        26,832.27    $      45,600.00   58.84%
      5131202 · Admin. Assist. Salary (Rachael)  $   2,178.00  $        11,909.00    $      20,940.00   56.87%
      5132100 · Payroll Tax Expense  $   1,013.60  $          6,055.56    $      11,370.50   53.26%
      5132200 · Pension Plan Expense  $      613.86  $          3,608.57    $        9,087.00   39.71%
      5132300 · Health Insurance  $   2,090.34  $          7,374.59    $      14,025.00   52.58%
      5132400 · Workers’ Comp  $              –    $          3,457.58    $        7,108.00   48.64%
    Total 5131000 · Reg Salaries & Wages  $ 10,784.80  $        58,381.14    $    138,600.50   42.12%
    5133000 · Financial & Admin – (Oper Exp)            
      5133100 · Professional Services  $      400.00  $             580.00    $        2,500.00   23.2%
      5133200 · Accounting/Auditing  $              –    $          2,946.00    $        8,000.00   36.83%
      5134100 · Telephone  $      845.69  $          3,803.33    $        7,200.00   52.82%
      5134600 · Repair & Maintenance  $        85.00  $             170.00    $           500.00   34.0%
      5134901 · Legal Ads  $        72.00  $             539.14    $        1,500.00   35.94%
      5135200 · Operating Supplies (Bank Fees)  $        76.95  $             650.31    $        1,500.00   43.35%
      5135400 · Dues/Subscriptions  $      316.77  $          2,673.72    $        3,000.00   89.12%
      5135500 · Education/Training  $              –    $                    –      $           300.00   0.0%
    Total 5133000 · Financial & Admin – (Oper Exp)  $   1,796.41  $        11,362.50    $      24,500.00   46.38%
    5140000 · Legal Services            
      5140001 · Town Attorney Expense  $      100.00  $          1,700.00    $        2,500.00   68.0%
    Total 5140000 · Legal Services  $      100.00  $          1,700.00    $        2,500.00   68.0%
    5191000 · General Govt Salaries            
      5191200 · Grant Writer Salary  $      300.00  $          1,600.00    $        2,600.00   61.54%
      5192100 · Payroll Taxes  $        22.95  $             122.40    $           208.00   58.85%
    Total 5191000 · General Govt Salaries  $      322.95  $          1,722.40    $        2,808.00   61.34%
    5193000 · General Government (Oper Exp)            
      5194200 · Postage/Freight  $      110.00  $             691.07    $        1,000.00   69.11%
      5194300 · Utilities Expense  $      243.73  $          1,830.49    $        3,500.00   52.3%
      5194400 · Rentals/Leases  $      837.90  $          3,231.90    $        5,050.00   64.0%
      5194500 · Insurance (Property)  $              –    $          3,591.08    $        6,274.00   57.24%
      5195100 · Office Supplies  $   2,983.98  $          6,142.03    $        8,500.00   72.26%
      5195102 · Emergency Plan Exp (CEMP)  $              –    $                    –      $        1,000.00   0.0%
    Total 5193000 · General Government (Oper Exp)  $   4,175.61  $        15,486.57    $      25,324.00   61.15%
    5196000 · Capital Expenditure (> $5,000)            
      5196200 · Capital Outlay – Unrestricted  $              –    $          3,054.39    $      37,650.00   8.11%
      5196202 · Historic Museum – Restricted  $              –    $                    –      $        2,691.00   0.0%
      5196211 · Double Gate (Water Tower) -ADV  $              –    $                    –      $        2,000.00   0.0%
      5196225 · Ad Valorem – Restricted (2019)  $              –    $                    –      $      28,787.00   0.0%
      5196300 · Passive Park – Restoration-ADV  $              –    $                    –      $      10,000.00   0.0%
      5196302 · Paint/Landscape Town Hall – BPR  $              –    $                    –      $      15,000.00   0.0%
      5196303 · ADA Restrooms – BPR  $              –    $                    –      $      30,000.00   0.0%
      5196305 · Town Hall / Storage Room – BPR  $              –    $                    –      $      25,000.00   0.0%
      5196307 · New Town Website – BPR  $   3,470.00  $          3,470.00    $        3,470.00   100.0%
    Total 5196000 · Capital Expenditure (> $5,000)  $   3,470.00  $          6,524.39    $    154,598.00   4.22%
    5210000 · TOPF – Grants            
      5210001 · State Grant – CDBG Storm Water  $ 11,699.50  $        79,105.36    $    600,000.00   13.18%
      5210002 · State Grant –  Park Upgrades  $              –    $                    –      $      50,000.00   0.0%
      5210003 · Local Grant – Historical Museum  $              –    $                    –      $      40,000.00   0.0%
    Total 5210000 · TOPF – Grants  $ 11,699.50  $        79,105.36    $    690,000.00   11.47%
    5243000 · Protective Inspections            
      5243100 · Inspections / Plan Reviews  $              –    $          7,280.00    $        8,000.00   91.0%
      5244900 · State Surcharge Fees  $        23.94  $               97.40    $           300.00   32.47%
    Total 5243000 · Protective Inspections  $        23.94  $          7,377.40    $        8,300.00   88.88%
    5411000 · Public Works (Salaries)            
      5411200 · Public Works (Tracy)  $              –    $          3,275.00    $      49,710.00   6.59%
      5411201 · Public Works (Alex)  $   3,657.10  $        19,879.53    $      45,860.00   43.35%
      5411204 · Public Works (Trevor)  $   2,334.52  $        13,798.94    $      30,440.00   45.33%
      5412100 · Payroll Tax Expense  $      822.08  $          4,495.92    $      10,201.00   44.07%
      5412200 · Pension Plan Expense  $      616.50  $          3,340.50    $      11,856.00   28.18%
      5412300 · Health Insurance  $   1,217.83  $          5,686.00    $      17,627.50   32.26%
      5412400 · Workers’ Compensation  $              –    $          3,457.60    $        7,108.00   48.64%
    Total 5411000 · Public Works (Salaries)  $   8,648.03  $        53,933.49    $    172,802.50   31.21%
    5413000 · Public Works (Oper Exp)            
      5414100 · Telephone  $      299.43  $          1,978.89    $        4,200.00   47.12%
      5414300 · Utilities/Electric Expense  $      978.35  $          6,592.07    $      11,000.00   59.93%
      5414500 · Insurance (Auto/Truck)  $              –    $             865.16    $        1,459.00   59.3%
      5414600 · Repair & Maintenance  $      205.72  $          3,843.65    $        9,500.00   40.46%
      5415200 · Operating Supplies  $   1,397.25  $          2,737.46    $        5,000.00   54.75%
      5415201 · Fuel  $      555.90  $          3,222.12    $        7,500.00   42.96%
      5415202 · Uniforms  $              –    $                    –      $           400.00   0.0%
      5415300 · Road Materials/Supplies/Equip  $      442.24  $          4,759.22    $        1,000.00   475.92%
      5415500 · Training (Certification)  $              –    $                    –      $           100.00   0.0%
    Total 5413000 · Public Works (Oper Exp)  $   3,878.89  $        23,998.57    $      40,159.00   59.76%
    5723000 · Parks & Recreation (Oper Exp)            
      5724300 · Utilities/Electric Expense  $        64.83  $             453.12    $        1,000.00   45.31%
      5724500 · Insurance (General Liability)  $              –    $          6,253.08    $      12,945.00   48.31%
      5724600 · Repair & Maintenance  $        40.00  $          2,764.35    $        1,000.00   276.44%
      5724800 · Special Events (Parades, etc)  $      147.53  $          2,036.13    $        2,500.00   81.45%
    Total 5723000 · Parks & Recreation (Oper Exp)  $      252.36  $        11,506.68    $      17,445.00   65.96%
    5810000 · Interfund Transfers Out            
      5810001 · Transfer Out to Sewer Fund  $              –    $          1,925.00    $           100.00   1,925.0%
      5810003 · Transfer Out to Water Utility  $              –    $          1,400.00    $           100.00   1,400.0%
    Total 5810000 · Interfund Transfers Out  $              –    $          3,325.00    $           200.00   1,662.5%
  Total Expense  $ 54,183.88  $      324,683.51    $ 1,362,057.00   23.84%
Net Income  $ (3,465.14)  $      114,543.31    $                   –     100.0%