By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    Promising Benefits of Predictive Analytics in Asset Management
    11 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Why Budgeting Is “Mission Critical” in Higher Education
Share
Notification Show More
Latest News
ai digital marketing tools
Top Five AI-Driven Digital Marketing Tools in 2023
Artificial Intelligence
ai-generated content
Is AI-Generated Content a Net Positive for Businesses?
Artificial Intelligence
predictive analytics in dropshipping
Predictive Analytics Helps New Dropshipping Businesses Thrive
Predictive Analytics
cloud data security in 2023
Top Tools for Your Cloud Data Security Stack in 2023
Cloud Computing
become a data scientist
Boosting Your Chances for Landing a Job as a Data Scientist
Jobs
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Data Management > Best Practices > Why Budgeting Is “Mission Critical” in Higher Education
Best PracticesBig DataBusiness IntelligenceData ManagementSoftware

Why Budgeting Is “Mission Critical” in Higher Education

LServen@XLerant.com
Last updated: 2013/07/19 at 8:05 AM
LServen@XLerant.com
5 Min Read
SHARE

budgeting tool

budgeting tool

You can’t pick up a newspaper without reading about how higher education is under pressure to keep tuition costs in line.  In the past, higher education institutions were able to pass along cost increases to students.  No more.  Now these institutions must learn to do more with the same resources or, in some cases, with less resources.   This puts pressure on the institution to make sure that it creates a financial plan that allows it to maximize its services at the most efficient cost. 

In addition, college presidents are crafting strategies for their institutions.  These strategies are essential to meeting their short-term and long-term goals as administrators.  In the past, faculty and staff have been more prone to doing what they have always done rather than thinking about strategy.  They tended to budget to politics and history. 

More Read

Spice Up Your Spreadsheets: Boosting BI with Google Spreadsheets

5 Reasons Why Excel Isn’t Enough for Financial Reporting
Five Reasons Excel Is Your Worst Enemy for Budgeting and Forecasting
IBM’s 2013 Vision Bodes Well for Finance
Don’t Gloat Over Excel Model Failures

The budget process is at the vortex of this issue.  The budget must tie to the strategic plan.  It is the next 12 months’ operational plan of that strategic vision and plan. The previous sentence initially was difficult for me to understand but I get it now: if the budget does not tie to the strategy, it is essentially not doing its job. Plus, the budget, being the blueprint for the next 12 months’ operational plan, is the place where institutions need to focus their attention in learning to do more with the same or less resources. 

Most higher education institutions are limited in their budgeting process. They still use Microsoft Excel spreadsheets as the basis of the budget process. Excel was fine for the old days, but can not meet the needs of today’s higher education institutions. There are several reasons for this:

  • Excel does not have “budget intelligence”.  It is a simple two-dimensional spreadsheet that does not inherently understand the budget process or workflow.  It does not understand accounts, departments, time periods, versions, spreading, salary planning, asset planning, users, consolidation, approval or many of the other functions required of more sophisticated budgeting. 
  • It is not a database.  So financial people become the database and must manually manage, consolidate and report data. 
  • It does not check for errors in the budget process and complex formulas, which can be difficult to understand even by their authors, can wreak havoc on the process.  Several institutions have reported submitting budgets to the board that had to be recalled based on the discovery of such errors
  • Excel does not have the flexibility to let various faculty and staff members budget their unique departments the way they think about those departments.  The math department budgets differently than the music department, which are both different from how the library budgets, which is different than the admissions department, which is different from the athletics department, which is different from student housing and on and on.
  • Excel does not easily account for documentation, justification or validation to strategic tenants. 
  • Upwards of 79% of a higher education budget is salary and benefits related.  Yet Excel does not inherently understand headcount and salary planning, how to give raises, calculate state and local taxes, benefits, special arrangements like recruiting fees, relocation and the like.

So the process needs to be upgraded to help colleges and universities better manage revenue and expenses and make sure that faculty and staff budget to strategy and not history or politics. 

But higher education also is slow to change.  People are reluctant to improve their approaches and cling to past practices in spite of the need to do so.  So they limp along claiming that change is too difficult or that that their current approach is not “that bad”.  These institutions will fall behind in their ability to adapt to a changing world and the people who are reluctant to make the changes will be left behind. 

All applications in all industries change over time.  The institutions that lead the change are the winners while the ones who resist these changes tend to be the ones who face crisis after crisis. 

Budgeting is a “mission critical” and strategic application in higher education.  It must be treated as such.  And institutions need to shed their reliance on spreadsheets if they want to keep pace with peer institutions. 

TAGGED: budgeting, excel, higher education, spreadsheets
LServen@XLerant.com July 19, 2013
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai digital marketing tools
Top Five AI-Driven Digital Marketing Tools in 2023
Artificial Intelligence
ai-generated content
Is AI-Generated Content a Net Positive for Businesses?
Artificial Intelligence
predictive analytics in dropshipping
Predictive Analytics Helps New Dropshipping Businesses Thrive
Predictive Analytics
cloud data security in 2023
Top Tools for Your Cloud Data Security Stack in 2023
Cloud Computing

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

Sign Up for Our Newsletter

Subscribe to our newsletter to get our newest articles instantly!

[mc4wp_form id=”1616″]

You Might also Like

Spice Up Your Spreadsheets: Boosting BI with Google Spreadsheets

8 Min Read
Image
Uncategorized

5 Reasons Why Excel Isn’t Enough for Financial Reporting

14 Min Read
spreadsheet
Best PracticesBusiness IntelligenceBusiness RulesCollaborative DataData ManagementExclusive

Five Reasons Excel Is Your Worst Enemy for Budgeting and Forecasting

8 Min Read

IBM’s 2013 Vision Bodes Well for Finance

13 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?