HomeMy WebLinkAbout04.d. Review drafft to approve updated Administrative Overhead and Benefits Rate for FY 2023-24 Page 1 of 10
Item 4.d.
All" BOARD OF DIRECTORS
' POSITION PAPER
MEETING DATE: FEBRUARY21, 2023
SUBJECT: REVIEW DRAFT POSITION PAPER TO APPROVE UPDATED
ADMINISTRATIVE OVERHEAD AND BENEFITS RATE OF 164% FOR
FISCAL YEAR (FY) 2023-24
SUBMITTED BY: INITIATING DEPARTMENT:
CHRISTOPHER THOMAS, ACCOUNTING ADMINISTRATION-FINANCE
SUPERVISOR
KEVIN MIZUNO, FINANCE MANAGER
REVIEWED BY: PHILIP LEIBER, DIRECTOR OF FINANCE AND ADMINISTRATION
ISSUE
Board approval is needed to adopt the updated administrative overhead and benefits rate for the fiscal
year ending June 30, 2024 (FY 2023-24). This rate is used for several purposes, including billing outside
agencies, calculating certain customer rates and charges, and internal use in billing labor costs to capital
projects.
BACKGROUND
The purpose of calculating administrative overhead, employee benefits, and non-work hours rates has
been for Central San to recover the full cost, including indirect costs, of the services it provides to various
users. This has been consistent with long-standing Board policy on cost recovery. Staff strives to bring
the annual updated percentage to the Board early every calendar year, 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. The administrative overhead and benefits rate is comprised of three sub-components capturing
the following:
1. Administrative overhead consists of all administrative indirect costs for Central San that are
incurred for a common purpose benefiting more than one task including all Executive Governance
and Administration Department costs, and certain support costs of the Engineering & Technical
Services and Operations departments.
2. 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.
3. Non-work hours consist of the value of compensated leave (i.e. vacation, sick leave, administrative
leave, birthday holiday), and earned overtime expressed as a percentage of annual work hours.
February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 123 of 198
Page 2 of 10
Calculation Methodology
The current administrative overhead and benefits rate calculation methodology was approved by the Board
on April 3, 2014, and first employed in FY 2014-15. The calculation is supported by a study issued by
Matrix Consulting Group, an independent consulting firm specializing in developing overhead rates for
governmental agencies in conformance with prevailing laws and best practices. I n summary, the
methodology currently used is based on the independent consultant's study and incorporates the following
previously Board approved principles:
1. Standardizes the methodology for calculating the rate by:
• Using the actual cost of benefits as reported in the independently audited financial statement
for the benefits component of the calculation rather than budgeted estimates,
• Allocates other post-employment benefits (OPEB)trust contributions in excess of pay-as-you-
go costs for active employees and retirees to their respective organization units (i.e.
departments and divisions), leaving only the administrative portion in the administrative
component,
• Continuing to treat retiree health and other premiums as indirect, and include them in the
administrative overhead component of the rate, and
• Allocating any additional Unfunded Actuarial Accrued Liability(UAAL) payments to their
respective organization units, and including only the administrative portion in the administrative
overhead component of the rate.
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 to adjust for volatility in the rate, initially using FY 2014-15 as
the base year(with the rate for FY 2015-16 using two years of data, and from FY 2016-17 forward
fully using three-year smoothing).
Proposed Rate for FY 2023-24
The proposed administrative overhead recovery rate for FY 2023-24 has been calculated in accordance
with the methodology approved by the Board as outlined. The proposed rate (three-year smoothed)for
FY 2023-24 is 164%, reflecting a decline of 5%from the approved FY 2022-23 rate of 169%. This is the
result of the overall decline in annual rates over the past several years, declining annually in six of the past
seven years. While the three-year smoothed rate is declining, there was also a 4.5% decrease in the un-
smoothed one-year rate from the prior fiscal year from 167.1% (FY 2022-23)to 162.6% (FY 2023-24)
which is attributable to the following factors:
1. Employee Benefits Rate Component-This component decreased by 1.5% from the prior year,
largely attributable to the increase in employee benefits costs (numerator) being outpaced by the
increase in employee salaries (denominator). The minimal increase in the benefit cost rate was
primarily driven by a slight increase in benefit premium rates overall in FY 2021-22. The increase in
salaries (denominator) is attributed to the labor agreements specifying cost of living adjustments and
other salary adjustments (i.e., longevity, step increases, etc.).
2. Administrative Overhead Rate Component- This component decreased by 3.3% from the prior year,
largely due to the proportional increase in indirect overhead costs (numerator) being slightly
outpaced by the increase in direct salaries costs (denominator). While relatively minimal, increases
in indirect costs were most evident in the following areas: overall increases indirect salaries and
wages attributable to the labor agreements specifying cost of living adjustments and other salary
adjustments (i.e., longevity, step increases, etc.) as well as an increase in non-labor support costs in
February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 124 of 198
Page 3 of 10
certain functions. The increase in direct salaries (denominator) is attributable to prevailing labor
agreements and other salary adjustments mentioned previously.
The attached presentation (Attachment 1) provides additional highlights of the proposed FY 2023-24 rate
compared to the rates adopted by the Board in prior years.
ALTERNATIVES/CONSIDERATIONS
The methodology used for this year's calculation employed the same methodology approved by the Board
in 2014, which employs three-year smoothing as well as the use of audited actual numbers as opposed to
using budgeted or projected figures. Alternatives that could be employed include eliminating three-year
smoothing, or using budgeted or projected figures instead of actuals. These are not recommended as it
could significantly impact comparability of the rate with prior years and not be in line with rate calculation
best practices.
Following the payoff of Central San's pension UAAL in June 2021 facilitated by the issuance of the 2021
Certificates of Participation (2021 COPs), effective FY 2021-22 Central San was not required to make a
large pension UAAL contribution to its pension administrator(CCCERA). In lieu of this pension UAAL
contribution, Central San paid $11.3 million in debt service on the 2021 COPs. The Board could choose
to exclude the FY 2021-22 debt service from this year's administrative overhead and benefits rate
calculation. This is not recommended as it is the opinion of staff that the pension UAAL was essentially
swapped for lower debt service on the 2021 COPs and exclusion of the debt service would result in
Central San potentially under-recovering costs associated with its pension expense. Despite the
application of three-year smoothing, given the magnitude of the change, it is projected removing the 2021
COPs would significantly reduce the FY 2023-24 rate, lowering it by 9% to a new revised rate of 155%.
Lastly, the 2014 Board approved rate calculation methodology assumed that the component of OPEB
costs associated with retiree health benefits was entirely an indirect cost, and that additional contributions
to the trust account beyond that should be spread between both direct and indirect costs as appropriate.
Effective FY 2021-22, Central San revised the methodology by which OPEB costs were budgeted to
improve transparency and the usefulness of financial reporting. This was achieved in two ways: (1) by
budgeting the actuarially determine contribution (ADC) instead of assumed retiree benefits paid and (2)
splitting the OPEB costs between its normal cost and UAAL components. Considering the change in
budgeting methodology, which disregards the "cash flow" component of retiree benefit premiums
payments, it may be timely to change the way OPEB costs are handled in the annual administrative
overhead and benefits rate calculation so that OPEB costs are fully allocated between direct and indirect
components. Doing so would impact comparability with prior years to some extent, however the
application of three-year smoothing would significantly diminish any spikes in the first year of
implementation. This change would reduce the FY 2023-24 rate as proposed by 1% to a revised rate of
163%.
FINANCIAL IMPACTS
The administrative overhead and benefits rate is calculated annually for the purpose of recovering
administrative overhead and employee benefit costs when charging to capital projects and developing
fees for the full recovery of costs incurred for services provided to customers, including residents, other
agencies, businesses, and developers/contractors.
COMMITTEE RECOMMENDATION
The proposed three-year smoothed administrative overhead percentage of 164% for FY 2023-24 was
reviewed by the Finance Committee on February 21, 2023 and recommended
February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 125 of 198
Page 4 of 10
RECOMMENDED BOARD ACTION
Approve the use of the administrative overhead and benefits rate of 164% for Fiscal Year 2023-24.
Strategic Plan re-In
GOAL FOUR: Governance and Fiscal Responsibility
Strategy 1 - Promote and uphold ethical behavior, openness, and accessibility, Strategy 3- Maintain financial stability
and sustainability
ATTACHMENTS:
1. Presentation
February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 126 of 198
Page 5 0OV10/23
February 21,2023
FY 2023-24 -
Administrative i, i
Overhead &
Benefits Rate
Finance Committee
i'
T. Kevin Mizuno
Finance Manager
1
1
Table of Contents
1. Issue �-
2 Background
Methodology i
Rate Components
Proposed Rate ' --
Historical Trends
Alternatives &
Considerations - ■
Recommendation
I
2
February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 127 of 198 1
Page 6 0OV10/23
Issue
Board approval necessary to update /
administrative overhead and benefits
rate to recover full cost of indirect R!`
support services
Rate used for various purposes:
Billing outside agencies
Calculating certain customer rates and
� t
charges
Capital project labor charges "* -
Labor charges for grants without program-
specific rates/limits
3
Background
z,
Methodology
Calculation conducted by staff utilizing methodology
approved by Board in April 2014 (for FY 2014-15)
Methodology supported by a study issued by an
independent consulting firm (Matrix Consulting Group) in
conformance with prevailing laws and best practices
Utilizes audited actual year-end figures, not budget or
projections
Employs 3-year smoothing
Rate comprised of 3 components
4
February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 128 of 198 2
Page 7 0OV10/23
Background
Rate Components
B(nefits
Hours
Employee Benefits consists of costs
associated with direct employee benefits
Non-work hours consists of the value of Administrative
Overhead
compensated leave and earned overtime
expressed as a percentage of annual work
hours
Administrative overhead consists of all
administrative indirect costs incurred for
a common purpose benefiting more than Administrative Overhead
one task & Benefits Rate
5
Background
FY 2023-24 Administrative Overhead&Benefits
Proposed Rate Rate
Single year FY 2023-24 unsmoothed rate is 18.2%
162.6%
Resulting 3-year smoothed rate proposed
for adoption is 163.7% 79.8%
Consistent with prior years, largest
component is administrative overhead,
decreasing by-3.3%
Slight reduction in benefits rate component
by-1.5%
Overall, 3-year smoothed rate decreasing •Employee Benefits Administrative Overhead Non-Work Hours
by 5.1%
I
6
February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 129 of 198 3
Page 8 o�W10/23
Background
Historical Trends
Historical Trend of Smoothed versus SinglerYear Rates
250.0%
q 240.0%
oq 230.0%
220.0%
O
210.0%
200.0%
E190.0%
Q 180.0%
¢ 170.0%
a
t0 160.0%
150.0%
2015-16 2016-17 1 2017-18 2018-19 2019-20 2020-21 2021-22 1 2022-23 2023-24
3 Year Smoothed Rate 206.0% 227.6% 1 224.7% 219.2% 203.4% 189.7% 176.5% 168.8% 163.7%
Single Year Rate 217.3% 237.8% 218.9% 201.0% 190.2% 178.0% 161 A% 167.1% 162.6%
Fiscal Year
�3 Year Smoothed Rate Single Year Rate
7
Background
Historical Trends
Historical Trend of Rate Components
250.0%
200.0%
N„
.� 150.0%
E v�
Q"
0 y 100.0%
4�O
d
m 50.0% -
0.0%
2015-16 2016-17 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24
F.Non-Work Hours 18.0% 18.1% 18.0% 18.1% 18.2% 1 18.1% 17.9% 17.9% 18.2%
Administrative Overhead 99.1% 106.6% 109.4% 102.3% 96.7% 88.61 77.4% 83.1% 79.8%
■Employee Benefits 100.3% 113.0% 91.5% 80.6% 75.3% 71.2% 66.0% 66.2% 64.7%
Fiscal Year
■Employee Benefits ■Administrative Overhead ■Non-Work Hours
8
February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 130 of 198 4
Alternatives & Considerations
Issue Alternative Considerations Rate Impact
Use of audited actuals Use budget or Not in line with best
and smoothing in projections and/or practices and will impact Unknown
calculation eliminate smoothing comparability
Can exclude debt service Valid argument that it Reduce by 9%to new
2021 COPS debt service from calculation entirely would not capture full rate of 155%
cost recovery
Retiree health premiums Treat portion of retiree Deviation from prior Reduce by I%to new
treated as indirect health premiums as Board-approved method rate of 163%
direct
9 _tsD CENTRAL SAN
Recommendation
Adopt the FY 2023-24 Administrative Overhead and Benefits rate of 164%
to take effect July 1, 2023
Ulllb-
Page 10 A2k10/23
Questions & Discussion
11
February 21, 2023 Regular FINANCE Committee Meeting Agenda Packet- Page 132 of 198 6