FY 2021 Budget Kickoff February 21, 2020 Agenda Introductions - - PowerPoint PPT Presentation

FY 2021 Budget Kickoff

February 21, 2020

Agenda

• Introductions
• Budget Update
• FAMIS Re-Platform Update
• Dates & Reminders
• Phase II Update
• Resources
• Discussion & Questions

BUDGET UPDATE

State Budget Overview

Legislative Budget Board

Distribution of Texas General Revenue by Function

Source: LBB

GR Funding by University System

(Academics Only) $5.3B

2020-21 Biennium

Texas State University System 9% Texas A&M University System 28% Texas Tech University System 7% University of Texas System 34% University of Houston System 10% University of North Texas System 5% Independents 7%

GR Funding by University System

(Academics + Health Related) $8.4B

2020-21 Biennium

Texas State University System 6% Texas A&M University System 21% Texas Tech University System 10% University of Texas System 47% University of Houston System 6% University of North Texas System 6% Independents 4%

Growth in TAMU Enrollment

Fall Undergraduates 2001: 44K 2019: 63.7K

30,000 35,000 40,000 45,000 50,000 55,000 60,000 65,000 70,000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019

Students

Growth in TAMU Expense Budget

TAMU Board Budgets (Including Debt) 1995: $500M 2006: $1B 2016: $1.5B 2020: $1.9B 2021: ?

$0 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 $2,000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020

Millions

State Funding vs. Tuition & Fees

as a % of Total Revenues

0.0% 5.0% 10.0% 15.0% 20.0% 25.0% 30.0% 35.0% 40.0% 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020

Tuition Deregulation

Tuition & Fees Appropriations

TAMU Board Budgets

Revenue by Source

FY2020 Board Budget

Total Revenues (in millions)

$2,046.9

Expenses by Category

FY2020 Board Budget

Total Expenses (in millions) $1,966.1

Budget Trivia

• 4367 Budgeted expense categories
• 1883 Expense budgets by account
• 710 Revenue budgets by account
• 257 Expense budgets by department
• 1693 New FAMIS accounts
• Largest Budget: $110.9M
• Smallest Budget: $1

2020 Done Budget

FAMIS Re-Platform Update

FAMIS Re-Platform Update

• High level of risk with current FAMIS system
• Based on code licensed by company in Germany that no longer

provides support

• Attrition of support staff knowledgeable with source code
• Renewed interest in new finance system after Workday HCM was

implemented

• Evaluated PeopleSoft (Oracle), Banner & Workday
• Settled on Workday
• Barriers:
• High cost
• Maturity of Workday Financials
• Considered other options: re-platforming FAMIS

FAMIS Re-Platform Update

• Advantages
• Lower cost than new system
• Leverage current and future staff
• Easier to hire new staff familiar with new code
• Keep current add-on systems
• Concur
• Aggie Buy
• Maestro
• Canopy
• Keep current integrations with Workday HCM and Data

Warehouse

FAMIS Re-Platform Update

Convert 4M lines of code to new language

• Phase I – Proof of Concept - completed
• Phase II – Conversion
• Feb 2020 – Conversion begins
• Oct 2020 – Data fully converted, testing begins
• June 2021 – Integrated testing
• Feb 2022 – Go live
• Phase III – Modernization
• Investment in enhanced reporting
• Canopy enhancements
• Improve/replace Budget & Annual Financial Report Modules

DATES & REMINDERS

Budget Dates

Feb 24 (Mon) Phase 1 Begins Budget Guidelines posted FAMIS Budget Module open for entry Central allocations available in FAMIS Mar 2 (Mon) Distribution of Variance Analysis Reports begins March 6 (Fri) Phase I Ends FAMIS Budget Module closes for departmental entry Variance Analysis due to Budget Office Mar 9-13 Spring Break Mar 18 (Wed) Budget due to System Office of Budgets & Accounting TBD Phase II Begins

What you need to know …

• Guidelines posted on our website
• President has authorized a 2% merit program
• 2088 Working Hours
• Estimated Benefit Rate Percentages
• Percent of salary dollars
• E&G Benefits paid at colleges/divisions

Faculty 22.5 Staff 29.8 Grad Student 9.2 Student 1.4

Reminders-Phase I

• No beginning balances on E&G, DT, UAF (many SL’s

to one GL accounts)

• Budget enough in expense dollars to cover salaries

in Phase II

• If you need to utilize a beginning balance as a source
• f funding for salaries in Phase II, you must budget

that BB in Phase I

• We will reconcile beginning balance, revenue &

expenses by fund group

Reminders-Phase I

• Budget merit in Unallocated Faculty or Non-Faculty Merit
• Re-allocated in Phase II
• Budget new planned positions in Unallocated Salaries
• Positions not yet created in Workday
• Will feed to Budget Pool 1005 in FAMIS
• Please … no pennies in budgets or allocations/transfers
• Let us know if you have any NO FEED accounts
• Contact FMO Access & Security if you have budget

access issues in FAMIS

PHASE II UPDATE

Phase II Tentative Dates

April 1 Statement of Responsibility Forms Due for PBA and Workday Merit Planner May 11th Snapshot from Workday loaded to PBA May/July (TBD) PBA Access July 6th FAMIS budget module opens and daily salary feeds begin July 31st FAMIS budget module closes to users August 3rd Workday Merit Launched August 12th Workday Merit submitted by units August 15th One-Time Merit templates due August 17th Merit is finalized in Workday

Enhancements/Changes

• Merit Planner role expanded
• PBA available earlier
• File upload capability to PBA
• EIB upload from PBA to Workday Merit
• Workday Merit module upgrades
• Reporting

RESOURCES

Resources available on website

• Budget Module Refresher
• Budget Workpaper
• Budgeting Business Rules
• Budget Screen Information
• Budget Module Training Presentation
• Merit 2020 Preview Webinar March 25th

Contacts

Hotline: 845-8145 E-mail: budget@tamu.edu Website: budget.tamu.edu

Mark Herzog 862-2371 herzog@tamu.edu Shelly Janac 458-2882 s-janac@tamu.edu Tracy Foster 862-2364 tfoster211@tamu.edu Katy Pleasant 862-1732 katy.pleasant@tamu.edu Deborah Wright 862-1622 deb-wright@tamu.edu

Don’t panic … everything is fixable