February 2021 Release Notes

February 5, 2021

February 2021 CalPlanning Release Notes

The CalPlanning FY21 Forecast is now available for planning. We used data from CalPlanning FY21 Operating Budget Final as the source for FY21 Forecast. 

We will open FY22 Operating Budget in March. Due to the continued uncertainty regarding COVID-19, the FY22 Operating Budget is currently blank and uneditable.  We plan to pre-populate the FY22 Operating Budget with the Final version of the FY21 Operating Budget along with updated Campus Commitments when we open the FY22 budget in March.  You may see Beginning Balance and Ending Balance in FY22 Operating Budget but those are calculated fields that equal FY21 Forecast Ending Balance. 

Overview of FY21 Forecast 

1. Data Sources

We copied the FY21 Operating Budget Final version to both the FY21 Forecast Initial and Working versions:

  • FY21 Forecast Initial is available for reporting

  • FY21 Forecast Working is available for editing and reporting

2. Differences between FY21 Operating Budget Final and FY21 Forecast Working

The FY21 Operating Budget Final and FY21 Forecast Working are nearly identical except for these differences:

  • FY21 Forecast Working Beginning Balance has been replaced with beginning balances from Actuals. (See the FY21 Beginning Balance section below for details.) 

  • FY21 Central Transfers and Commitments have been loaded into CalPlanning from a combination of Actuals data and planned data from the Campus Commitments Database.  

    • General allocation account 71110 was updated to Actual values for FY2020-21. 

    • Accounts in the Campus Support 712xx and 714xx series have been updated with the most recent commitments data available for open periods for the Forecast year (Q3 & Q4). (Inclusion in the Campus Commitments Database does not guarantee future funding. All amounts are subject to change.) Data in these accounts for closed periods reflect actual transacted commitments.

  • Accounts in the 713xx series have been updated for closed periods with Actuals for the FY21 Forecast Working version.  Accounts in the 71xxx series will be further updated in the spring with FY2021-22 Form A data to be provided by DFLs for both planning years (FY21 Forecast and FY22 Operating Budget). Cell comments from FY21 Operating Budget Final version have been copied to assist in your planning. We recommend you edit these comments as appropriate.

3. Central Transfer Accounts Update

Intersection Detail Reports

  • Intersection Detail Reports have been updated with the most recent commitments data available for open periods in the FY21 Forecast (Q3 & Q4).

Faculty Funding 

  • Planned Faculty separations and hires from last year's Form A (submitted in March 2020) were moved from the month of August to the month of May. 

    • Separations:  Faculty separations that were expected to occur 12/31/19 or 6/30/20  were moved from the intersection: Account 71110; Fund Unrestricted Plan; Month August; Chart1 C1 - 3ZACOM - Commencement Expense to the same intersection in the FY21 month of May. They were moved within their respective planned DeptIDs.

    • Benefits related to Separations: Withdrawal of benefits funding related to planned faculty separations was moved from the intersection: Account 71304; Fund Unrestricted Plan; Months of September and March; Chart 1 C1_SUMPLN - Summary Plan - to the same intersection in the FY21 month of May. They were moved within their respective planned DeptIDs.

    • Hires:  Faculty hires that were expected to occur 7/1/20 or 1/1/21 were moved from the intersection: Account 71110; Fund Unrestricted Plan; Month August; Chart1 C1 - 3U00MC - Fac Recruitment to the same intersection in the FY21 month of May. They were moved within their respective planned DeptIDs.

    • Benefits on Hires:  Benefits related to faculty hires planned by the DFL expected to occur 7/1/20 or 1/1/21 were moved from the intersection: Account 71110; Fund Unrestricted Plan; Month August; Chart1 C1 - 3S0RES - Multi-disc StUp Endow Chr to the same intersection in the FY21 month of May. They were moved within their respective planned DeptIDs. 

  • Form A planned Faculty merits/promotions from the months of September and March to April and May.

    • Merits/Promotions: Faculty merits/promotions were moved from the intersection: Account 71314; Fund Unrestricted Plan; Months September and March; Chart1 C1 - SUMPLN - Summary - Plan to the same intersection in the FY21 months of April and May. They were moved within their respective planned DeptIDs.

    • Benefits on Merits/Promotions: Benefits to support Faculty merits/promotions for were moved from the intersection: Account 71304; Fund Unrestricted Plan; Months September and March; Chart1 C1 - SUMPLN - Summary - Plan to the same intersection in the FY21 months of April and May. They were moved within their respective planned DeptIDs.

 

4. Actualized Forecast

With the Actualized Forecast process at the close of each month, we overwrite the Forecast values with Actuals data from BFS for all accounts: non-compensation accounts in CalPlan and compensation accounts in HCP.

The closed months (July 2020 to December 2020) of the FY21 Forecast Working now reflect actual data. 

 

5. FY21 Beginning Balance Details

Beginning Balances reported in CalPlan and CalRptg contain data seeded from BFS FY21 period 0 Actuals.

For most funds, Beginning Balances do not contain period 0 TempBudg. Only a small number of Contract and Grant (C&G) funds, including Financial Aid and Federal Appropriation funds, have continued to use TempBudg in BFS since the C&G implementation, so their Beginning Balances continue to include Period 0 TempBudg and Actuals in CalPlanning.

These ranges are as follows:

  • Financial Aid Funds (ranges 23513-23548, 23601-23603, and 33980-33990)

  • Federal Appropriation Funds (ranges 21000-21099 and 33870-33899)

NOTE: Data for inactive Contract and Grant (C&G) funds are excluded from CalPlanning for FY21 Beginning Balances.

 

6. HCP 

  • HCP data for FY21 Forecast Working version includes the following:

    • Actualized July to December periods.

    • Updated fee remission rates have been applied. (GAEL remains at the planned value for the year.)  Please note that we are aware that fall fee remissions were all expensed in September in the actuals ledger. 

  • HCP data for FY22 is blank and will be populated when we open the Operating Budget at the end of February.

  • The "Review HCM data to add to Plan" task and forms are unavailable at this time but will be made available at the end of February, after we load data extracted from UCPath on the night of Tuesday, February 9.

  • GAEL and fee remission rates have been updated for FY21 in CalPlanning. (The rates are listed below).  

7. What is in the FY21 Forecast Working Version

The table below outlines what was seeded in the FY21 Forecast Working.

FY21 Forecast Working 

CalPlan & HCP 

July 2020 to December 2020 overwritten with Actual data for all accounts

CalPlan January 2021 to June 2021

  • FY21 Operating Budget Final version

for all accounts except for Campus Support accounts and compensation*

  • Campus Support accounts were updated from PermBudget and central commitments data; also some amounts from last year's Form A were moved to later months (see Faculty Funding section above)

HCP January 2021 to June 2021

  • HCP data from FY21 Operating Budget final version for individual employees, pooled positions, and DeptID adjustments.

*Compensation in this context includes fee remissions

 

8. Student Revenue Funds Remapped

These four student revenue funds have been remapped from Unrestricted Funds to Designated:

20259 - Orientation Fee
20274 - Student Basic Needs Fee
20270 - UHS SHIP INC
20272 - SHIP - Berkeley Insured Plan

This change was applied to all years and periods of CalRptg Actuals in October 2020.

This change was applied to CalPlan Actuals as part of this release to:

  • FY21 beginning balance and July to December periods

  • FY19 and FY20 July to June periods (but not to the beginning balance of those years)

Details for Reference

Composite Benefit Rates, Fee Remission, and GAEL

 

Composite Benefit Rates and GAEL have not been changed for planning purposes. Fee remission rates have been updated with newer rates. UCRP is calculated for Current Funds excluding Contracts & Grants.

The composite benefit rates (CBR) for FY2020-21 have been approved. The new values were effective as of July 1, 2020 and were updated in HCP on July 14, 2020. As a reminder, now that we have implemented UCPath, we follow a standard process for calculating rates led by UCOP and adopt their agreements with the federal government. More information about how the CBR rates are calculated is available on the Composite Benefit Rate webpage

Fee remission rates were updated in CalPlanning on January 29, 2021.

The CBR and UCRP rates were updated in CalPlanning on July 20, 2020. 

The GAEL rates have not been changed since they were last updated in CalPlanning in October 2019. 

Composite Benefit Rates (CBR)

FY21

FY21

Rates used for planning
7/14/20 to 10/23/20

Academic

35.9%

35.9%

Staff

45.9%

45.9%

Limited (this includes Postdocs)

16.4%

16.4%

Employees with No Benefit Eligibility

5.5%

5.5%

Students

2.4%

2.4%

 

Fee Remission by 

HCP Pooled Position Type per Semester

FY21

FY21

Rates used for planning
7/14/20 to 10/23/20

GSR - Resident

$9,963.75

$9,963.75

GSR - Non-Resident

$17,514.75

$17,514.75

GSI

$9,276.00

$9,276.00

Reader/Tutor - Student

$9,276.00

$9,276.00

 

GAEL & UCRP

FY21

FY21

Rates used for planning
7/14/20 to 10/23/20

General, Automobile, and Employment Liability (GAEL) rate

 

1.55%

 

1.55%

University of California Retirement Plan (UCRP) Supplemental Allocation

0.30%

0.30%


See the Composite Benefit Rates (CBR), General, Automobile, and Employment Liability (GAEL), or UCRP Supplemental Interest Assessment websites for more information.