General Fund Finance Report – April 2020

    Apr 20Oct ’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%