HomeMy WebLinkAboutLPD & CPF2018 Town of Southold Budget Workpapers
Actual ExpensesBudgets
Department 2020 Current 2021 Dept
- 12/31/2014 12/31/2015 12/31/2016 12/31/2017 12/31/201812/31/20196/30/2020
Account Code Budget Request
LAND PRESERVATION
LAND PRESERVATION (GENERAL FUND)
A.8710.2.200.300CAMERA 130 - - - - -
A.8710.4.100.100OFFICE SUPPLIES & STATI 291 144 397 399 - 145 122
300 250
A.8710.4.400.300PRESERVE BROCHURES & MA - - - - - -
- 900 500
A.8710.4.600.100RECORDING FEES 448 - - - - - -
800 800
A.8710.4.600.200MEETINGS & SEMINARS 125 - - - 20 - -
450 300
A.8710.4.600.600DUES & SUBSCRIPTIONS 763 700 701 791 855 788 -
900 200
TOTALS - LAND PRESERVATION (GENERAL FUND) 1,757 844 1,098 1,191 875 933 122 3,350
2,050
COMMUNITY PRESERVATION FUND
APPROPRIATIONS
CM.1320.4.500.300ACCOUNTANTS 6,000 10,000 5,000 3,500 4,000 4,000 - 4,000
6,000
CM.1620.1.100.100STEWARDSHIP, REGULAR EARNINGS 3,406 2,471 6,161 8,254 21,892 23,535 7,404 110,605
104,605
CM.1620.1.200.100REGULAR EARNINGS 2,429 4,488 235 7,500KH
CM.1620.4.100.100MISCELLANEOUS SUPPLIES 1,864 520 1,582 3,697 9,317 11,139 1,563 87,400
65,850
CM.1980.4.000.000MTA PAYROLL TAX 576 582 603 608 662 795 312 1,115KH
CM.8660.2.500.100LEGAL COUNSEL 20,903 25,847 26,086 11,391 17,029 23,134 2,168 50,000 40,000
CM.8660.2.500.200APPRAISALS 16,900 8,650 19,000 2,400 25,200 10,100 - 40,000 30,000
CM.8660.2.600.100LAND ACQUISITIONS 4,825,195 727,219 3,965,145 3,683,677 5,334,397 13,285,836 986 12,060,598?
CM.8710.1.100.100FULL TIME REGULAR EARNINGS 167,796 168,940 172,319 172,319 183,136 189,105 84,790 187,260 191,005
CM.8710.1.100.200FULL TIME OVERTIME EARNINGS 794 1,349 1,927 - - - -
- -
CM.8710.1.200.100PART TIME REGULAR EARNINGS - - - - - -
- - -
CM.8710.2.400.100LAND USE CONSULTANTS 33,536 26,909 21,014 10,598 1,080 - -
- -
CM.8710.2.400.200LAND STEWARDSHIP/MANAGM 126,794 1,446 31,456 250 250 - - 40,810
35,890
CM.8710.2.400.400BITTNER IMPROVEMENTS 190 - - - - -
- - -
CM.8710.2.500.200MOWING EQUIPMENT - - 10,266 - - - -
3,500 -
?Large Equipment: 4x4 Pickup Truck 20,000
?Large Equipment: Tractor 38,830
CM.8710.4.400.100SERVICES PROVIDED BY OTHER FUNDS - - - - 13,590 13,589
- 65,000KH
CM.9010.8.000.000NYS RETIREMENT, BENEFIT - - - 20,734 27,159 27,427 6,893
35,000KH
CM.9030.8.000.000SOCIAL SECURITY 13,045 13,093 13,669 13,735 14,895 17,897 7,014 25,096KH
CM.9040.8.000.000WORKERS COMP BENEFITS - 1,190 1,168 936 1,500KH
CM.9055.8.000.100CSEA BENEFIT FUND 26,765 31,346 - 4,024 4,970 2,551 5,000KH
CM.9055.8.000.300 DISABILITY INSURANCE 25 (61) (35) 25KH
CM.9060.8.000.000MEDICAL INSURANCE, NYSHIP - 304,515 - 39,435 24,791 13,698 38,500KH
CM.9710.6.100.100SERIAL BOND PRINCIPAL 1,297,300 1,338,500 1,364,143 1,513,150 1,473,913 1,490,846 1,508,655 1,508,655KH
CM.9710.7.100.100SERIAL BOND INTEREST 1,051,812 1,006,692 953,959 682,644 708,003 655,172 313,744 597,315KH
TOTAL - CPF APPROPRIATIONS 7,592,875 3,668,080 6,592,329 6,126,957 7,881,626 15,787,931 1,950,914 14,868,879 532,180
Control # 2 of 3
2018 Town of Southold Budget Workpapers
Actual ExpensesBudgets
Department 2020 Current 2021 Dept
- 12/31/2014 12/31/2015 12/31/2016 12/31/2017 12/31/201812/31/20196/30/2020
Account Code Budget Request
LAND PRESERVATION (CONTINUED)
COMMUNITY PRESERVATION FUND (CONTNIUED)
REVENUES
CM.1189.102% LAND TRANSFER TAXES 6,060,255 6,464,184 7,073,493 7,732,204 8,097,019 7,666,589 2,931,774 7,000,000 7,000,000
CM.2401.00INTEREST AND EARNINGS 18,407 14,879 29,296 46,896 99,012 184,120 30,738 50,000KH
CM.3089.80DEPT OF STATE GRANT 527 - - - 40,147 1,714 -
CM.3097.10NYS AG & MARKETS GRANT - - 464,522 - - 10,000 -
CM.3960.80SEMO AID-HOME/COMM SVC - 12,824 - - - -
CM.4097.10NATURAL RESOURCE CONSERV 2,491,750 - - - - -
CM.4960.80FEMA AID-HOME/COMM SVC 110,496 4,919 - - - -
CM.5990.00APPROPRIATED FUND BALANC - - - - - -
- 7,818,879? 9,500,000
TOTAL - CPF REVENUES 8,681,434 6,496,806 7,567,311 7,779,100 8,236,178 7,862,423 2,962,513 14,868,879 7,000,000
Control # 3 of 3
Proposed 2021 Budget Work Papers Additional information/explanation as of August 10, 2020
COMMUNITY PRESERVATION FUND
1)
CM.1620.1.100.100
Line for DPW Charge Backs As of 8/5/2020 @ 104,605
Stewardship, Regular
Earnings
CM.1620.4.100.100
Line for Stewardship Supplies As of 8/5/2019 @ 65,850
Miscellaneous Supplies
CM.8710.2.400.200
Line for Stewardship As of 8/5/2019 @ 35,890
Land
Contractors
Stewardship/Management
The three (3) budget lines noted above are the cumulative amount from a detailed line item
spreadsheet listing estimated costs for a-e below. These are cost estimates only and the
individual line items have not necessarily been approved by Town Board:
a) Non-site specific trail/mowing/pruning/upkeep for public access purposes on CPF
Preserves open to the public.
i) This work includes typical activities/ improvements to sustain public access.
ii) This work is typically done by DPW and is accounted for in the form of Charge Back forms
for actual work completed.
iii) Craig Jobes submitted information to be included in this part of the budget
(e-mail dated 8/3/2020 11:38)
b) Non-site specific items, misc. equipment, contingency for all CPF properties.
i) This line is used for improvements (for example signage, safety/emergency/contingency) to
sustain public access; general supplies and equipment, materials, trail maps, bike racks,
general improvements for CPF preserves.
ii) Craig Jobes submitted information to be included in this part of the budget
(e-mail dated 8/3/2020 11:38)
c) Bay to Sound
i) Amounts for Bay to Sound were provided by John Sep (e-mail 8/4/2020 3:37PM)
d) Deer Management on CPF Preserves
i) This includes Trails/Zones/Signage/Exclosures and work for Deer Management Program
on CPF Preserves.
Amounts for this lie were provided by Craig Jobes (e-mail dated 8/3/2020 11:38)
e) Each Preserved CPF property owned by the Town
This includes and details specific improvements for particular preserve if proposed. Information
was discussed with John Sep (E-mail dated August 5, 2020 and prior to this date)
Decided to keep the list the same as 2020 and to keep the same projects/funding as listed for
2020.
2) CM.8710.2.500.200 Mowing Equipment
It is proposed to change this line to: Large Equipment
Page 1 of 3
Kristie said that this should be a separate capital line item.
The following are excerpts from the CPF Legislation and the CPF Rules and Regulations:
(Legislation) 9-a. (d) Any project funded pursuant to this subdivision must have a useful life
of five years or more under section 11.00 of the local finance law.
(Rules and Regulation Examples):
Example: The purchase of a brush cutting mower for the exclusive use of trail work on CPF
lands, is permissible provided such equipment has a useful life of at least 5
years.
Example: The expense of a 4-wheel drive vehicle, truck or other off-road vehicle used
exclusively for CPF purposes, is part of a management and stewardship “project”
and is a permissible expense as equipment provided it has a useful life of 5
years.
a) Craig requested 4x4 Pickup Truck. Proposed 50% funding from CPF and 50% from DPW
Total cost = 40,000.
$20,000 proposed from CPF
b) Tim Abrams requested tractor for CPF work. Proposed 100% funding from CPF
Total cost = 36,830.
$36,830 proposed from CPF
3) CM.8710.4.400.100 Services Provided by Other Funds
a) Kristie said that she would provide this information.
b) It appears that Coughlin and Jobes are included in the Charge Backs accounted for in
CM.1620.1.100.100 Stewardship, Regular Earnings. I e-mailed Kristie about this and she said
(8/4/20) “During the year, we charge it directly to the Stewardship earnings line. At the end of
the year, we will charge any difference plus the applicable benefits to the other line.”
4) CM.1189.10 2% Land Transfer Taxes /2021 Estimated Revenue Calculation
*Estimating revenue for 2021 is difficult due to the market uncertainties caused by COVID-19.
COVID shut down impacted 2020 monthly revenue due to slow down of closings, and likely to be
up during several months of increased home purchases by people leaving city.
I propose using 7 million as estimated revenue after reviewing the following calculations:
a) 2020 actual revenue for past 6 months (Jan – June) = 3,690,000±
This includes 3 months (April/May/June) during full or partial COVID shut down
Using actual 6 month revenue plus rolling 6 months:
Actual 6 month: 3,690,000
Rolling 6 month (from 2019) : + 3,967411
Estimated 2020 revenue: = 7,657,411
Rd to 7,657,000±
Page 2 of 3
Using actual 6 month revenue plus 12 month average:
Average based on last 12 months revenue = 638,000
Calculations for estimate for 2021 revenue:
Actual 6 month: 3,690,000
Estimate 6 month using 638,000 average: + 3,828,000
Estimated 2020 revenue: = 7,519,874
Rd 7,500,000
b) Actual revenue for last full calendar year (2019) = $ 7,697,637±.
5) CM.5990.00 Appropriated Fund Balance
My internal financial spreadsheet (using last “snapshot” updated by KH dated November 30,
2019) indicates:
a) 9,506,706 (rd 9.5) as of Jan. 1, 2021.
i) Anticipated acquisition of Fuchs by 2020 year end (400,000) is excluded;
ii) Anticipated acquisition of WW Farms by 2020 year end (4,000,000) is excluded.
iii) Anticipated 2020 debt payments are excluded;
iv) Bond payment set aside (4± million) is included.
As per above explanation I showed an Appropriated Fund Balance of 9,500,000*
*This will be revised if snapshot is updated prior to final budget
6) CM.8660.2.600.100 Land Acquisitions
Land Acquisitions needs to be calculated after Kristie supplies numbers for several lines in
budget.
7) CPF legislation allows 10% of fund to be used for management and stewardship costs. (In
accordance with a Stewardship Plan) 10% is based on last full calendar year revenue. For 2021
budget, last full calendar year is 2019 @ $ 7,697,637±. The stewardship part of the budget does
not appear exceed the 10% allowed.
LAND PRESERVATION (GENERAL FUND)
A.8710.4.600.600
To help reduce general budget, eliminated Real Property Tax Map subscriptions for each Land
Preservation Committee member.
Page 3 of 3