HomeMy WebLinkAbout05.B. Approve updated administrative overhead percentage of 225% for Fiscal Year 2017-18 5mBm
Central San
' BOARD OF DIRECTORS
POSITION PAPER
Board Meeting Date: January 26, 2017
Subject: APPROVE UPDATED ADMINISTRATIVE OVERHEAD PERCENTAGE OF
225% FOR FISCAL YEAR 2017-18
Submitted By: Initiating Dept./Div.:
Thea Vassallo, CPA, CMA Administrative / Finance &Accounting
Finance Manager
REVIEWED AND RECOMMENDED FOR BOARD ACTION:
Philip Leiber, CPA ;L . Ia— Z95-P
Director of Finance and Administration �.,.. Roger S.Bailey
General Manager
ISSUE: Board approval is needed to revise the annually updated administrative
overhead percentage in order to recover the full cost of the indirect services provided by
Central San. This overhead rate is used for several purposes including billing outside
agencies, calculating certain customer rates and charges, and for internal use in
charging overhead to capital projects.
BACKGROUND: In prior years, the purpose of calculating administrative overhead,
employee benefits, and non-work hours rates was to follow the Board's direction for
Central San to recover the full cost of the indirect services it provides. In an effort to set
the rate early enough to be used for calculating rates and charges and the negotiation
of the Clean Water Program contract, staff brings the annual updated percentage to the
Board every January.
Administrative overhead consists of all administrative indirect costs for Central San that
are incurred for a common purpose benefiting more than one task. This rate includes
administration department staff salaries, retirement costs, administration portion of
Other Post-Employment Benefits (OPEB) trust contributions for active and retired
employees, and any additional Unfunded Actuarial Accrued Liability (UAAL) payments
allocated to administration.
Employee benefits consist of costs associated with retirement pension payments,
medical premiums, deferred compensation contribution in lieu of social security and
other similar benefits expressed as a percent of salaries.
Non-work hours consist of the value of vacation, sick leave, administrative leave,
birthday holiday, and earned overtime expressed as a percentage of annual work
hours.
Page 1 or 3
POSITION PAPER
Board Meeting Date: January 26, 2017
Subject: APPROVE UPDATED ADMINISTRATIVE OVERHEAD PERCENTAGE OF
225% FOR FISCAL YEAR 2017-18
During 2013, Central San's staff, in conjunction with Matrix Consulting Group (Matrix),
reviewed the methodology used by Central San and analyzed other allowable methods
used to calculate overhead. Matrix issued its report in March 2014, which stated that
the methodology that Central San previously used was compliant with state and federal
guidelines, and was generally consistent with other agencies and jurisdictions, so there
was no immediate need for change. It was suggested by several Board members that
staff conduct further analysis as to Central San's methodology for calculating the
administrative overhead percentage prior to presenting the matter for consideration for
Fiscal Year (FY) 2014-15. Consequently, Central San staff, with the help of Matrix, had
proposed and recommended a slightly different methodology for calculating the
administrative overhead percentage for FY 2014-15 and beyond. The four main items
addressed by Central San staff and the consultant included the treatment of the
following:
• Use of audited or budgeted benefit amounts for the employee benefits
component
• OPEB contributions for active employees and retirees
• Retiree premiums
• Additional UAAL payments
On April 3, 2014 the Board approved the following:
1. A change/clarification in methodology for calculating Central San's administrative
overhead percentage, commencing with FY 2014-15 as follows:
• Use audited cost of benefits for the benefits component of the calculation
• Allocate the OPEB contribution for active employees and retirees to their
respective departments, and include only the administrative portion in the
administrative component
• Continue to treat retiree premiums as indirect, and include them in the
administrative overhead component
Allocate any additional UAAL payments to their respective departments,
and include only the administrative portion in the administrative overhead
component
2. A single administrative overhead percentage is to be used for billing outside
agencies, calculating the annual Environmental and Development Rates and
Charges, and for internal use in charging to capital projects (administrative and
non-work hours percentages used); and
3. A three-year smoothing methodology going forward to adjust for volatility in the
rate, using FY 2014-15 as the base year. The rate for FY 2015-16 would be
Page 2 of 3
POSITION PAPER
Board Meeting Date: January 26, 2017
subject: APPROVE UPDATED ADMINISTRATIVE OVERHEAD PERCENTAGE OF
225% FOR FISCAL YEAR 2017-18
based on two years and it would not be until FY 2016-17 that an actual three-
year smoothing would be able to be utilized.
For FY 2017-18, the largest contributors to the net change in the total administrative
overhead rate (3 year smoothed) were:
• Filling vacant positions during FY 2015-16 (INCREASE)
• Actuarially determined retirement contributions decreased from $25.8 million in
FY 2014-15 to $20.8 million in FY 2015-16 (DECREASE), and
• The effects of three-year smoothing (INCREASE)
Central San's rate for FY 2017-18 increased to 225% from 216% in FY 2016-17. See
Attachment 1 for a summary of the FYs 2017-18, 2016-17, and 2015-16.
ALTERNATIVES/CONSIDERATIONS: The administrative overhead calculation
methodology could be modified resulting in an increased or reduced percentage. It is
not recommended to modify the method again as the new method was Board approved
in April 2014.
FINANCIAL IMPACTS: The administrative overhead percentage is calculated annually
for the purpose of recovering administrative overhead and employee benefit costs when
charging to capital projects, recovering full costs for services provided to another
agency, company or developer, and for customer billings involving labor costs.
COMMITTEE RECOMMENDATION: The proposed three-year smoothed
administrative overhead percentage of 225% for FY 2017-18 was reviewed by the
Finance Committee at its January 18, 2017 meeting. The Committee recommended
Board approval.
RECOMMENDED BOARD ACTION: Approve the use of the administrative overhead
percentage of 225% for Fiscal Year 2017-18.
Attached Supportinq Document(s):
1. Administrative Overhead Summary for FY 2017-18
Page 3 of 3
ATTACHMENT
Central Contra Costa Sanitary District
Administrative Overhead Summary
For the 2017-18 Budget-Calculated using 2015-2016 Audited Financial Statements
Current Year
Calculation Last Year's Two Years ago
3 Year Smoothed Unsmoothed Unsmoothed Unsmoothed
Year 2017-2018 2017-2018 2016-2017 2015-2016
Employee Benefits 101.61% 91.52% 113.04% 100.26%
Administrative Overhead 105.04% 109.37% 106.63% 99.12%
Non-work Hours 18.01% 18.04% 18.12% 17.95%
224.66% 218.94% 237.79% 217.33%
Smoothed Rate 225% 225% 216% 206%
Years in Smooth Rate 3 yr 3 yr 3 yr 2 yr
Comparison of Rate Before smoothing 2016-2017 2015-2016 Decrease
Employee Benefits 92% 113% -22%
Administrative Overhead 109% 107% 3%
Non-work Hours 18% 18% 0%
Total 219% 238% -19%
Summary of Increases(Decreases)
Employee Benefits
Retirement rate decreases&additional$2.5M UAAL contribution in CY vs.$5M in PY -22%
All other combined variances 1%
Total -22%
Variance in total is due to
rounding
Admin Overhead:
SalariesTrech Svc 16%
Decease in retirement contribution -3%
Change in Self-Insurance funding and all other -10%
Total 3%
M/1/147 14-AC Ann C,,.........,.,799 n.......,