Forum for the Future of Higher Education
CyberCampus Project
Higher Education
The Simulation Engine: Modeling Resource Allocation and Finance
This paper describes work in progress on the Higher Education simulation project funded by the Alfred P. Sloan Foundation. Contents may not be used or cited without permission. Limited distribution is provided to obtain comments and criticisms, and to assist potential development partners. Copyright © 1997 by JHHEG.
Table of Contents
1. Introduction
2. Overview
3. Financial Structure
4. Aggregate Revenues and Expenditures
5. Budget Adjustments
6. Faculty Salary Increases
7. Budgeted Faculty Positions
8. Endowment Asset Allocation and Total Return
9. Borrowing Limit
10. Autumn Budget Revisions
Endnotes:
Higher Education is a computer-based simulation game under development that targets both the institutional professional and the interested layperson to participate in leadership challenges in a college or university setting. Players set, monitor, and modify a variety of institutional parameters and policies, allocate resources as they see fit, and watch as results continually unfold. The game provides an opportunity to experiment and succeed or fail in a safe and entertaining fantasy environment. While Higher Education is necessarily a caricature of real academic life, it is grounded in authentic data and will provide serious lessons in higher education. The game will be driven by a sophisticated simulation engine that models five broad areas:
·
This paper describes the model for resource allocation and finance. It is intended to provide an overview for technical readers, especially those who will be responsible for game development. The elements discussed herein pertain to the simulation engine, not to the player interface. Many will be transparent to the player. In particular, the spreadsheets shown describe the kinds of data that will be embedded within the simulation. They do not describe the game as it will be seen by the player.
Resource allocation provides the central policy focus for Higher Education, for it is the creation and distribution of resources that drive most college and university functions. The term "resource allocation" as used here is synonymous with budgeting—the annual process that determines prices, salary guidelines, provisions for cost-rise, and net changes in the expenditure authorizations for academic and nonacademic operations. The resource allocation model converts player-generated policy inputs and changes in exogenous factors to the specific decisions needed to drive the simulation for the ensuing year. The resource allocation model’s main algorithms have been prototyped in Microsoft Excel®. The model will run once per simulated year.
The model begins by defining the institution’s financial structure—its balance sheet and sources and uses of funds. The resulting financial statements will vary in structure and content depending on the player’s choice of institutional characteristics. The statements for public institutions will include state support. Wealthy institutions will have large endowments and cash reserves; struggling colleges might have none. The financial statements provide the initial conditions for the budget model that determines revenue and expense.
The budget model has three components. The first calculates the drivers of aggregate revenues and expenditures: e.g.,, tuition and financial aid, salary increases, and budget adjustments. (Budget adjustments, which will be defined presently, refer to expenditure changes over and above the effects of salary increases and cost-rise.) A second component allocates the budget adjustments among functions and activities: e.g., faculty, other departmental expense, libraries and information technology, athletics, and institutional advancement. The model’s third component, "faculty positions," allocates faculty salary expenditure adjustments among departments. By so doing, it also determines the number of new faculty that each department can hire.
Every spring Higher Education allocates resources for the next academic year. For simplicity, the model assumes accurate estimates for the current year’s financial outcomes. Because resource allocation takes place late in the fiscal year, this is not an unrealistic assumption. The current-year data provide the baseline against which budget adjustments will be considered. The player determines student intake targets as part of budgeting. (Actual admissions may deviate from the targets.) Therefore, the resource allocation model runs before the enrollment management model. The model also runs before the faculty hiring model even though, in real life, faculty hiring is not concentrated in the late spring. The new budget takes effect on July 1 and remains in effect for the next twelve months unless the player decides to rescind expenditure authorizations.
While actual revenues and expenditures tend to conform to the institution’s planned budget, deviations can be expected. The model uses the coming year’s budget as the initial condition for that year’s revenue and expenditure statement. Changes are introduced during the year as the result of endogenous, exogenous, and random events. For example, if the enrollment management model produces a shortfall or overflow of students (an endogenous event), tuition revenue and financial will be adjusted accordingly. A plunge in the stock market (an exogenous event) will produce variances in gift income and investment return. Small random deviations also will be programmed to affect most or all of the other revenue and expense items. The player can view the current revenue/expenditure statement and balance sheet at any time during the year, and it will be offered up for examination at year-end. Finally, the player can rescind amounts from some expenditure lines—for example, from student life or operations and maintenance—if the financial picture worsens during the year.
Because Higher Education is not intended to be primarily a financial exercise, its balance sheet and income statement contain only the elements needed to drive the rest of the simulation. For example, there is no general distinction between restricted and unrestricted funds for most income and expense categories, and some categories are highly aggregated. The revenue and expenditure statement also departs from normal usage in that it cross classifies expenditures by object of expense (faculty salaries, staff salaries, other expenses) and function or activity. The cross-classification is required for modeling purposes, and it will be instructive for the player to see the data displayed in this way. This system generally follows the strategic financial model developed previously by W. F. Massy.
Table 1 shows a sample balance sheet. It and subsequent sample tables display information needed by the simulation engine. They are not samples of player interface screens.
Table 1. Balance Sheet ($000)
Table 2 shows a sample revenue and expenditures statement. Most items are self-explanatory. Those items treated in an unusual way include:
Revenues:
Table 2. Revenue and Expenditure Statement ($000)
Expenditures:
Table 3 lists key financial factors that may vary exogenously over time, either at random or as part of preprogramed scenarios. Player decisions can influence the right-hand variables to some extent. For example, asset allocation might influence endowment total return. Expenditures on advancement and athletics might influence income growth for those categories. Heavy deficits requiring bank debt close to the credit limit might escalate the bank interest rate. Other income may be influenced by as yet unspecified institutional financial policies.
Table 3. Exogenous Factors
Table 4 presents the ten policy variables needed to determine aggregate revenues and expenditures. All percentages refer to the prior year’s base. Highlights include:
Table 4. Policy Variables for Aggregate Revenue and Expense
See text for the meaning of *.
Two player-controlled policy parameters are associated with each policy variable.
Three model-determined figures also are associated with each policy variable.
The model uses quadratic programming to minimize the weighted sum of squared differences between the actual values of the policy variables and their targets. The upper and lower bounds enter the quadratic program as inequality constraints. Equality constraints are added where necessary to handle any policy variables whose targets must be achieved exactly. Relationships among the policy variables and the underlying financial variables enter as additional equality constraints. For example, if the base year’s tuition rate is $10,000, the policy for real tuition growth is 2.5 percent, and inflation is 5 percent, the new tuition rate would be $10,750. The surplus or deficit implied by a given setting of the decision variables equals total revenue minus total operating expenditures, debt service, and transfer to plant.
It is anticipated that the game will be programmed to allow players to perform sensitivity analyses with different weights, targets, and bounds. Players should also be able to advance from year to year without having to change any of the policy variables. An automatic mode also may be offered that bypasses the budget screen(s) altogether.
The second step in allocating resources is to allocate budget adjustment amount, as calculated by the previous component, among alternative expenditure categories. The expenditure categories, called "functions" in university accounting jargon, are listed in Table 5. The table contains the same columns as Table 4, except that "suggested value" has been replaced by "absolute minimum value." The targets and bounds may be positive or negative, depending upon whether the function is to be expanded or contracted. The percentage changes represent shifts from the prior year’s levels of operation.
Most of the expenditure functions are self-explanatory, but the two involving departments require a brief explanation.
The absolute minimum value for faculty FTEs reflects the current number of open positions—in other words, the degrees of freedom available for downsizing by attrition. For example, –5 percent indicates that people accounting for five percent of last year’s faculty compensation bill have announced their resignations. The resignations will take effect at the end of the current fiscal year, thus opening the way for new hires. If the absolute minimum value is –5 percent and the player indicates a policy target of +1.5 percent, then he or she is seeking to refill all the vacated places and expand the faculty by an additional 1.5 percent for a total inhire authorization of 6.5 percent.
Table 5. Policy Variables for Allocating Net Operating Budget Growth
The model again makes use of quadratic programming to minimize the weighted sum of squared deviations of the allocations from their targets, subject to certain constraints. The primary constraint forces total net operating budget growth to equal the amount determined by the aggregate revenue and expenditure model. Both sums are evaluated as dollar quantities, not as percentages. The dollars may be positive or negative depending on whether the institution is expanding or contracting in real terms. The upper and lower bounds are applied as additional constraints, as are any requirements that the targets be achieved exactly, just in the aggregative revenue and expenditure model.
The quadratic program produces growth or reduction percentages for each expenditure function. These may be closer or further from their targets depending upon the targets’ consistency with the overall budget adjustment figure.
Applying these percentages to the prior year’s expenditure base gives the dollar value of the real budget increment or decrement for each function. The model assumes that the increment or decrement divides itself between salaries and other expenses in proportion to the existing base after adjustment for salary increments and cost-rise. (The exception is faculty salaries versus other departmental expenses, which are treated explicitly in the optimization.) Adding the real increments and decrements to the adjusted budget base produces the new budget, which can displayed according to the format of Table 2.
The aggregate revenue and expenditure model determines the overall level of faculty salary growth, but it is silent as to how this sum should be allocated across departments and faculty groups. The default will be to apply the same percentage increase figure everywhere. Depending on resources, we may consider allowing the player to override the default percentage and apply his or her own percentage to one or more departments, faculty groups, or department-group combinations. The remaining departments and groups will receive a new default percentage, determined by deducting the dollar values produced by the player-determined from the overall salary pool and then dividing by the remaining salary base. (To be designed, prototyped, and written up.)
The budget model’s remaining task is to allocate expenditures on faculty, as determined previously, among departments. In the aforementioned example, how much of the 6.5 percent increase in faculty expenditures should go to the English department? The Pphysics dDepartment?
The model’s first step uses average salaries to convert from expenditures to FTE numbers. Then it optimizes the number of FTEs to be assigned to each department, taking attrition, the continuing faculty base, and the expenditure limit into account. Finally, the number of new hires permitted each department can be determined by comparing the optimal FTE numbers with the continuing base.
The departmental allocations are based on the department’s teaching load, its relevance to institutional mission, its sponsored research volume, and the year-to-year change in faculty size.
i. compute the average of the normal class sizes ("average NCS") for the department’s course mix as determined in the prior year by the academic operations model (course mix represents the percentage of lecture, seminar, general undergraduate, and graduate courses);
ii. divide total departmental enrollment by the average NCS to get the number of course sections needed to service the demand;
iii. divide the required number of course sections by the departmental faculty FTE (the decision variable) to get the teaching load implied by the putative faculty staffing level;
iv. subtract the result of (iii) from the average of the normal teaching load for all faculty age-rank combinations in the department to get the teaching load deviation.
The budget model calculates the departmental teaching and sponsored research loads and the year-to-year staffing changes from data provided by the academic operations model. The mission relevance weights are policy parameters which are provided initially in the initial conditioins and which may be changed by the player at any time. The player can steer the allocation of new hires, including those that replace faculty who have departed, by adjusting importance weights for teaching load, mission relevance, sponsored research, and year-to-year staffing changes.
The faculty hiring optimization again is performed by quadratic programming. The following terms enter the objective function for each department:
The first two terms are quadratic in the decision variable and the last two are linear. The quadratic terms enter the objective function with positive weights because the deviations from norms are to be minimized. The linear terms enter with negative weights because the program rewards mission relevance and sponsored research. The program minimizes the objective function subject to constraints.
The primary constraint requires that the expected total faculty salary cost equal the sum set aside for this purpose in the budget adjustment allocation. The resultant faculty size for each department also is constrained to be no less than the number of continuing FTEs. The number of new hires authorized for each department equals the resultant total faculty FTEs minus the continuing FTE base. The new hire figures are passed on to the faculty hiring component of the faculty FTE model, which produces the faculty roster for the year just budgeted.
While not part of the budget model, per se, this is an appropriate place to describe the asset allocation and total return model. (Total investment return is an input to the budget model.)
The player will be asked to describe how the institution’s endowment assets should be allocated among the following asset categories: (i) large-company stocks; small-company stocks; and (iii) bonds. This determination should be built into the player interface. Changes in asset allocation can be introduced any time, but they will not take effect until the beginning of the next fiscal year.
The allocation determines the expected real value and standard deviation of total return according to a function to be provided. The simulated total return for a given year will be determined by drawing a random number from a log-normal distribution with mean equal to the inflation rate plus the expected total return, and the given standard deviation. By managing asset allocation, players will learn that boosting total return—as may be achieved by upping the percentage of stocks (particularly small-company stocks)—comes at the price of increased risk.
The institution’s credit rating determines the total amount of debt that can be outstanding at a given time. For simplicity, we make no distinction between plant debt, residence hall debt, and bank debt. (Bank debt exists when the operating reserve balance is negative.) The institution’s borrowing limit represents the difference between its overall debt capacity and the debt currently outstanding.
Pending further research, the debt limit will depend on the four asset category balances shown on the left side of Table 1 and the fraction of total funds usage in Table 2 represented by debt service. The first quantity will be obtained by multiplying each asset balance will by a constant and summing. For example, the debt limit based on assets might be:
1.0 x Operating Reserve, if positive (this is ready cash) +
0.7 x Endowment (discounting due to restrictions on some funds) +
0.5 x Plant (discounting because plant may be hard to sell) +
0.9 x Capital reserve (this is mostly ready cash).
The borrowing limit based on debt service will be obtained by determining how much debt could be added without causing the debt service percentage to exceed a predetermined limit. The limit will be calculated and reported using both the long-term and short-term interest rates.
The player’s main budget decision comes near the end of each fiscal year and takes effect at the beginning of the next fiscal year. (The fiscal year runs from July 1 to June 30.) However, it may be desirable to follow established practice and give the play an opportunity to adjust the budget during the course of the year. This would allow a quick reaction to adverse circumstances or windfalls, thus speeding up the pace of response and helping the player maintain a sense of control.
Because the overall budget model is too complex to run more than once a year, the mid-year interventions will be constrained as follows.
The model considers a certain portion of direct sponsored research expenditures to be used to offset academic year faculty salaries. The offsets are shown in the "faculty" column of Table 2’s sponsored research line. This amount needs to be escalated by the growth rate of faculty salaries. However, the growth rate of direct sponsored research expenditures may not equal the faculty salary growth rate. The dollar value of any such difference reverts back to general funds in the surplus-deficit calculation. Suppose, for example, that the offsets would have to grow by 5 percent because of salary increases, but direct sponsored research will grow by only 4 percent. The resulting gap, which is 1 percent of the $5,143 (thousand) shown in Table 2, amounts to a little over $50 thousand. The model will add this to the "departmental" line before calculating the surplus/deficit.