Document 4JeJ6jy7JRNroGJX48KZ2bX01
GULF COAST ECOSYSTEM ----->T----- TION COUNCIL
FISCAL YEAR 2019 PROPOSED
OPERATING BUDGET
AUGUST 7, 2018
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
ED 002061 00171667-00001
FY 2013*2018: Start up to Steady-State Operations
Grow from two detailees to current staff of 21.5 FTE
Administrative and grant infrastructure put in place
Two FPLs approved / grants and lAAs awarded
Three PSEPs and three SEPS approved;
Comprehensive Plan updated
Enterprise risk management program established
Collaboration activities in support of FPL 3
commenced
FY 2019:
Continue to collaborate towards FPL 3
Re-engineer FPL proposal and application process
Migrate RAAMS to new federal automated system
Guif Coast Ecosystem Restoration Council Staff Work Product --- Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
ED 002061 00171667-00002
FY 2019 PROPOSED BUDGET OVERVIEW
Council has demonstrated fiscal responsibility through prudent and conservative management of its operations.
The Council brought $2.1 million in operational carry-forward funds to FY 2018.
The FY 2019 budget request for new funds is 3.35% less than the FY 2018 budget request.
FY 2019: $5,762,391 FY 2018: $5,962,410 reduction: < $ 200.019 >
The FY 2019 budget will utilize $585,985 of carry-forward funds to cover selected FY 2019 requirements.
Admin Expense category:
$ 194,080
Program Expenses category:
$ 391,905
Gulf Coast Ecosystem Restoration Council Staff Work Product Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
ED 002061 00171667-00003
* Major Budget Changes:
Salaries and staffing adjustments:
Acquire administrative support through contracts - increase Realign ASA position to financial analyst position - increase Realign administrative analyst position to program support -
no change
Administrative and Human Resources MOUs
Procurement system/support increased volume - increase HR automated system completed in FY 2018 - reduction
Program Costs, RAAMS and Travel
BAS reviews - use recouped FY 2018 contract funds reduction
Data and collaboration tools - use carry-over - reduction RAAMS hosting and licensing - use carry-over - reduction Travel for collaboration and site visits - increase
(Note: see slides 17-20 for detailed discussion of line item budget changes)
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
4
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
ED 002061 00171667-00004
BUDGET CATEGORIES
FY 2019 FUNDS
REQUEST fo r
FY 2019 BUDGET
FY 2018
APPROVED BUDGET
IN C R E A S E / DECREASE
PERCENT CHANGE
T o ta l Salaries and B enefits
$
A d m in is tra tiv e Services M O U s
Facilities M O U s
H um an Resources M O U s
IT C ontracts and M O U s
M iscellaneous O perating Expenses
Program Expenses and M O U s
RAAMS Contracts and M O U s
Travel
TOTAL NON-PAYROLL EXPENSES
$
GRAND TOTALS
$
3,611,762 $
473,461 46,000 122,563 158,025 54,000
583,012 312,340 401,229
3,521,186 $
407,425 53,000
250,600 145,400
84,500 574,786 642,713 282,800
2,150,630 S 2,441,224 S
5,762,392 $ 5,962,410 $
9 0 ,5 7 6
66,036
(7 ,0 0 0 ) (1 2 8 ,0 3 7 )
12,625
(3 0 ,5 0 0 )
8,226
(3 3 0 ,3 7 3 )
118,429
(2 9 0 ,5 9 4 )
(2 0 0 ,0 1 8 )
2.57% 16.21% -13.21% -51.09% 8.68% -36.09%
1.43% -51.40% 41.88%
-11.90%
-3.35%
Gulf Coast: Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
ED 002061 00171667-00005
* One time costs / Costs that will not recur:
Metadata Tool Development
$ 17,335 (prog)
Collaboration Tool Development
34,550 (prog)
RAAMS Hosting
175,650 (prog)
RAAMS Licensing
69,370 (prog)
Records Mgmt Program Development
100,000 (admin)
Recurring costs funded one time from carry-forward:
BAS Reviews ($95K first year recovery)
Contracted administrative support
95,000 (prog) 94,080 Jadmin)
Total Use of Carry-Forward for Operating Costs
$ 585.985
Gulf Coast Ecosystem Restoration Council Staff Work Product --- Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
ED 002061 00171667-00006
CARRY-OVER AVAILABLE FOR RAAMS REPLACEMENT
Use carry-over funds to develop and implement new grants system
Projected system costs will be available and briefed in September
Current program expense carry-over funds:
Program expense funds available $ 1,706,397
Funds to be used for FY 2018
< 391,905>
operating expenses
Balance of carry-forward funds
$ 1.314.492
available for system replacement
Gulf Coast Ecosystem Restoration Council Staff Work Product --- Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
ED 002061 00171667-00007
BACKGROUND INFORMATION
Sierra Club v. EPA 18cv3472 NDCA
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Tier 3/4
ED 002061 00171667-00008
21.5 positions / MOU support
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
Blue denotes program funded
* Red denotes admin funded
g
ED 002061 00171667-00009
0^ T Co
C tifiiiO n
ertati
T.4 -1 J(.
Comprehensive Plan Total Deposits as of 6/30/2018 Including interest earned and applied
3% Pool 3% Drawn Down (apportioned) Balance Available
$428,475,506
12,854,265 < 6,398,400> $__ 6,455.865
Admin funds drawn-down as a percent of total deposited Comprehensive Plan Trust Funds: Current recurring admin expenses per year: Portion of annual BP payment that is Council admin:
1.5% $1.5 M $2.7 M
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
ED 002061 00171667-00010
Council 3% ADMIN PROJECTIONS
TOTAL PROJECTED TRUST FUND DEPOSITS
Comprehensive Plan Including interest earned as of 6/30/2018
$1,611,923,782
3% Pool 3% Projected Expense through FY2040
48,357,713 < 47.102.622 >
Balance Available
$ 1.255.091
Admin funds expense projection as a percent of total Comprehensive Plan Trust Funds:
2.92%
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
^ ^ ED 002061 00171667-00011
$M
FY13 FY14 F Y 15 FY16 FY17 FY18 FY19 FY20
FY34
FY35
FY 36
FY37
FY38
FY39
FY40
28 years
FTE
0
5.4 11.4 17.6 21.1 21.5 21.5 21.5
21.5 19
18
17
15
11
8 TOTAL
SALARIES
0.86 1.74 2.69 3.37 3.52 3.61 3.71
4.40 3.91 3.78 3.62 3.27 2.48 1.88 95.89
0.36 1.10 1.81 1.58 2.08 2.44 2.1 5 3.00 OP EXP
3.46 3.04 2.97 2.81 2.74 2.73 2.67 75.56
TOTAL
0.36 1.96 3.55 4.27 5.45 5.96 5.76 6.71
7.86 6.75 6.75 6.43 6.01 5.21 4.55 171.45
Admin Exp. 0.36 Breakout
0.9 1.2 1.1 1.7 1.4
1.4 1.7
2.1 2.0
2.0 1.8 1.8
1.8 1.4
47.10
2.9%
Sierra Club v. EPA 18cv3472 NDCA
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Tier 3/4
7/7/2017 ED 002061 00171667-00012
Twenty Seven Year Projection Assumptions and Planning Considerations:
FY2031 last year of BP payment schedule All grants awarded and closed by FY 2040
Grants awarded in FY31 must be closed out within nine years
Planning Considerations:
Timing of grants with long completion times Timing of grants with long-term operations and maintenance
costs
From last payment of $91M:
Must reserve at least $50M for FY32-FY40 operations Should reserve funds for contingencies
^ For every year grants are open beyond FY2040, add $5-6M per year to total and reserved operations costs
Amount dependent on volume of grants open in the out-years
Sierra Club v. EPA 18cv3472 NDCA
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Tier 3/4
% 3
ED 002061 00171667-00013
S^ilii
BUDGET DETAIL
FY18 APPROVED
BUDGET
ADMIN BUDGET
PROGRAM BUDGET
FY19 BUDGET ADMIN REQUEST BUDGET
PROGRAM BUDGET
INCREASE/ DECREASE
PERCENT CHANGE
Salaries Benefits Accrued Leave Total Salaries and Benefits ARC Procurement Services ARC travel svcs OIG-Audit expense ARC general accting/budget/payroll EPA SEE PROGRAM (IAA funded bi-annually) National Associates Inc (Contractor Adm Spt) Transerve Employee Benefits Administrative Services MOUs Security DHS Office space GSA Rent Office equipment Facilities MOUs USDA NFC Payroll EPA Executive Resourcess Treasury HR Connect transition services Personnel security svcs (background checks) ARC HR general services USPS EEO Services Support DOI PIV & Background check Human Resources MOUs
2,634,164 887,022
3,521,186 24,474 12,855 85,000
285,096 -
407,425 3,000
40,000 10,000 53,000 2,100 18,500 125,000 5,000 100,000
250,600
684,527 230,503
915,030 7,171 3,767
24,907 285,096
-
-
320,941. 879
11,721 2,930 15,530 2,100
36,628
1,465 29,302
-
69,495
1,949,637 656,519 ,,
2,606,156 17,303 9,088 60,093
0.00 -
0.00 86,484 2,121 28,279 7,070 37,470 18,500 88,372 3,535 70,698 -
181,105
2,700,504 911,258
3,611,762 75,069 21,777 85,000 289,115 [94,080] 2,500 473,461 3,000 38,000 5,000 46,000 2,100 18,500 13,700 74,063 500 13,700 122,563
671,754 226,634
838,388 22,520 6,533 75,000
289,115 -
1,250 394,418
879 11,400
1,500 13,779 2,100 5,550
4,110 22,219
150 4,107 38,236
2,028,750 684,624
2,713,374 52,549 15,244 10,000 1,250 79,043 2,121 28,600 3,500 32,221 12,950 9,590 51,844 350 9,593 84,327
66,340 24,236
90,576 50,595 8,922
4,019
2.57%
2,500 66,036 16.21%
(2,000) (5,000) (7,000) -13.21%
(125,000) 8,700 (25,937) 500 13,700 (128,037) -51.09%
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
8/2/2018
14
ED 002061 00171667-00014
BUDGET DETAIL
FY18 APPROVED
BUDGET
ADMIN BUDGET
PROGRAM BUDGET
FY19 BUDGET REQUEST
ADMIN BUDGET
INCREASE/
PROGRAM DECREASE PERCENT
BUDGET
CHANGE
Info Technolgy (Email-NOAA) Cellphone/Phone services/ Internet Equipment refresh (Laptops) IT Managed Services IT Security requirements G Suite Eas M TIPSw /VPN Phone Lines (AT&T and Cox) Conferencing (Uber and Goto Meeting) IT Contracts MOUs Misc other svc Supplies/printer toner/etc Training Mail and transportation of things MISC Operating Expense MOUs GOMA Cross Agency Tracker BAS reviews [reduced by $95K - yr 1 recovery] ODP-DMP support USGS GIS Svs, website sytem admin, security Metadata Tool development / Support Collaboration Tool / APP MOU NOAA MOU for Graphics Meta Data Tool training/support NOAA NCEI Principals/Public meetings and Collaboratories Conference attendence fees Land Appraisal Multi-media/printing-PE Materials Tribal Support with DOI
3,000 35,000 22,400 38,000 14,000 18,000 15,000
145,400 20,000 40,000 22,000 2,500 84,500 90,000 125,000 55,505 33,031 34,500 60,400 32,500 65,000 53,350 10,500 10,000 5,000 -
879 10,256
6,564 11,135
4,102 5,274 4,395
42,605 5,860 11,721 6,447 733 24,761 3,078 -
2,121 24,744 15,836 26,865
9,898 12,726 10,605
102,795 14,140 28,279 15,553 1,767 59,739 90,000 125,000 55,505 33,031 34,500 60,400 32,500 65,000 53,350 7,422 10,000 5,000
4,140 35,000 22,400 45,644 14,000
33,468
1,817 1,556 158,025 15,000 15,000 22,000 2,000 54,000 52,500 30,000 34,307 263,665 [17,335] [34,550] 32,701 64,799
15,040 10,000 10,000 70,000
1,242 10,500
6,564 13,693
4,102 10,040
545 467 47,153 4,500 4,500 6,447 600 16,047
2,820
-
2,898 24,500 16,836 31,951
9,898
23,428 1,272 1,089
110,872 10,500 10,500 15,663 1,400 37,953 52,500 30,000 34,307
263,665
32,701 64,799
12,220 10,000 10,000 70,000
1,140 -
7,644 -
(18,000) 18,468
1,817 1,556 12,625 (5,000) (25,000)
(500) (30,500) (37,500) (95,000) (21,198) 230,634 (34,500) (60,400) 201 (201) (53,350) 4,540
5,000 70,000
8.68% -36.09%
Program Expenses/MOUs
574,786
3,078 571,708 583,012
2,820 580,192
8,226 1.43%
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
8/2/2018
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
ED 002061 00171667-00015
O
BUDGET DETAIL Grants system - IT and helpesk - contract Grant System hosting USGS updated cost Grants system-Altum - contract RAAMS Travel Travel
FY18 APPROVED
BUDGET
ADMIN BUDGET
FY19 PROGRAM BUDGET BUDGET REQUEST
ADMIN BUDGET
INCREASE/
PROGRAM DECREASE PERCENT
BUDGET
CHANGE
307,020
- 307,020 312,340
- 312,340
5,320
209,150
- 209,150 [175,650]
[176,650] (209,150)
126,543
126,543 [69,370]
[69,370] (126,543)
642,713
-
312,340
312,340 (330,373) -51.40%
282,800 282,800
26,000 26,000
oo m
256,800
401,229 401,229
34,340 34,340
366,880 3SS,SS9
118,429 41.88% 118,429 41.88%
TOTAL NON-PAYROLL EXPENSES
2,441,224 502,410 1,038,814 2,150,630 546,793 1,603,837 (290,594) -11.90%
GRAND TOTALS
5,962,410 1.417,440
5,762,392 1,445,181 4,317,211 (200,018) -3.35%
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
8/2/2018
*|g
ED 002061 00171667-00016
Salaries and Benefits (Labor):
+$90,576
Small 2.5% increase
Expect to be fully staffed with 21.5 FTE plus inflation impacts increase Reduction in lapse rate
Change in COLA / step increases / difference in actual salary from budgeted salary
Conversion of Admin Assistant to Financial Analyst
Admin Services, Facilities, HR MOUs
-$69,001
HR and Facilities decrease due to one time HR connect cost in FY18 and reduction in Office equipment
Admin has increase due to increase in ARC MOU services for contracts and travel based on actual FY18 usage and NAI contract support
Will cover NAI contractor $94,080/ Records Management contract $100,00 (est.) with carry forward.
Gulf Coast Ecosystem Restoration Council: Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
17
ED 002061 00171667-00017
IT Contracts / MOUs
+$12,624
MTIPS / VPN : increase $18,468
Allows access to financial system remotely, increases efficiency of fiscal support to Council. Increased AT&T cost in FY19
G suite Eas : decrease 18,000 This funding was not executed in FY18. It was a contingency for email if we were not able to extend our current agreement for G-We were successful and Gsuite has increased $1,140 from FY18 .
IT Managed Services: increase $7,644 Security software from provider required by FISMA. This support is
critical to provide IT support remotely to our geographically dispersed staff.
UBER Conferencing/ Goto Meeting : increase $3,372 Required to conduct business, Conference lines were provided by Commerce and we now bear the cost. We have used UBER at a fraction of the cost of major providers.
Misc and Supplies : decrease -$30,500
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Sierra Club v. EPA 18cv3472 NDCA
Tier 3/4
ED 002061 00171667-00018
Program MOUs:
+ $ 8?226
GOMA tracker reduced : Decrease $37,500 * Reduced from $125K in FY18 to $52,500 due to reimbursable agreements
BAS Appraisal : Decrease $95,000 * Will apply $95K in funding de-obligated from FY18 Contract to BAS
USGS :GIS, Website hosting, Security lines: net Increase $209,436 The real increase from FY18 is $41,664. $350,263 of support for FY18 was covered in 3 year MOU starting in FY15. We will now use one year MOUs Metadata & Collaboration Tool lines: Decrease $ 94,900 * Will apply Carry Forward funds resulting in reduction from FY18 cost
Public Meetings/Collaboratories lines: decrease $53,350 * Reduction in budgeted collaboration
DOI Tribal Support: increase $70,000 * New requirement for better tribal outreach and support
PE materials, conference fees, : Increase $9,540 * Small increase in conference fees multi media
Sierra Club v. EPA 18cv3472 NDCA
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Tier 3/4
ED_002061_00171667-00019
.I % .... ... ........... .
ATING EXPENSE INCREASES
- RAAMS MOUs:
-$330,373
* Small increase in Grants System Help desk contract of $5,320 * MOU with HHS for new Grants Management System Fit Gap Analysis is
still in progress. There will be more transition and cost data to follow.
Travel:
+$118,429
* Net increase due to addition of program collaboration travel.
Increase in Site visit and recipient assistance visits
Sierra Club v. EPA 18cv3472 NDCA
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Tier 3/4
20
ED 002061 00171667-00020
<o^7
"111
ASSUA rTMr:-ht
Expenses
Out-year expenses assume steady-state operations; known changes factored in.
Accounting, payroll, human resources, procurement, website, and travel systems/services.
* IT will be managed with internal staff overseeing contracts for services and IT security.
Grant management function performed in-house using externally sourced and hosted automated grant management system. Minimum staff needed to accomplish requirements in statute.
* Leverage resources of Council members to meet surge requirements Office footprint is small - majority of staff will telework.
* Leverage cloud collaboration tools. Expenses inflation rate: 1.5%
Salary/cost of living increase rate: GS - 1.75% then lowered to 1.5% in FY28 due to tenure of staff Length of operations based on 28 years - FY 2013 to FY 2040
Sierra Club v. EPA 18cv3472 NDCA
Gulf Coast Ecosystem Restoration Council Staff Work Product - Subject to Council Approval
Tier 3/4
ED 002061 00171667-00021