![]() |
2002-2003 |
Search Lane |
General Fund
( Revised 11/13/01)
Budget Projection Assumptions for FY03 and Beyond
Executive Summary
Net Working Capital
· For the purposes of projecting future budgets, it is assumed
that restricted revenues, including Net Working Capital Restricted, are
entirely expended during the year.
· By Board Policy the Unappropriated Ending Fund Balance will
be 3% of budgeted revenues.
· All projected carryover (Net Working Capital Unrestricted)
is ìon the tableî during budget development. For the current fiscal
year (FY02) Net Working Capital Unrestricted of $3,270,724 was budgeted
on the resource side with offsetting expenditures. The actual Net
Working Capital Unrestricted on 7/1/01 was $996,768 above budget.
Revenues: State Sources
· FY03: The college relies on state projections based on the
biennial allocation of funds to the community colleges and the funding
formula. The State will be splitting the funding formula allocation
50/50 between FY02 and FY03.
· The projections include a reduction of 2% mandated by the
Governor for FY02 and FY03 ($635,878 and $618,493 respectively).
· Projections developed by the State are used for FY04 and beyond.
· In the funding formula, the State uses the assumption that
the FTE for each college will increase at the same annual rate. (For
the purposes of calculating tuition, the college uses enrollment projections
developed by Institutional Research Assessment & Planning.)
Revenues: Local Property Taxes
· Property tax revenues will increase approximately 4.5% per
year.
· Typically, property taxes assessed are not collected at 100%.
The college uses a collection rate based on historical trends. Projections
in recent years have used a 92% collection rate. Because the stateís economy
has been strong the last few years, actual collection rates have been higher.
The adopted budget for the current year uses an estimated collection rate
of 93.5%. [Note: The downturn in the economy of the state and county
will cause us to re-examine the rate for FY03. For 2001, the countyís assessed
taxes may increase by up to 6.5%, which should virtually offset the high
collection rate used for the FY02 budget.]
Revenues: Tuition
· Tuition revenues are projected based on enrollment projections
developed by Institutional Research, Assessment & Planning
· Tuition revenue projections are based on total tuition assessed.
Tuition waivers and uncollected tuition are reported as expenditures.
· No increases in tuition rates are projected if not yet approved
by the Board.
· Projections use $1292-per-credit-FTE and $494-per-non-credit-FTE
to calculate total tuition revenues. These per-FTE rates are based on history
and approved Board tuition rates.
Revenues: Mandatory Instructional Fees/Non-Mandatory Instructional Fees/ Other Fees
· Projections assume that all fees collected at 100%. Uncollected
fees are reported as an expenditure.
· All fees are restricted revenue. That is, fees are tied to
specific expenditures. In the budget projections there is an offsetting
expenditure for every restricted revenue.
Revenues: Interest on investments:
· The estimated rate for annual return on investments in FY02
is 2.25%. Rates are estimated based on historical returns and current economic
indicators.
· The amount invested averages approximately $28,000,000.
Revenues: Sale of Goods and Services assumptions:
· Sales revenues are ìpass throughî, that is, there is an offsetting expenditure for the cost of the goods and services.
Expenditures: Personal Services
· Personal Services expenditures for FY03 use current negotiation
parameters.
· For FY04 and beyond projections use ìstepsî plus estimated
COLA increases each year. Projection models may vary COLA rates to
determine the effects of different COLAs.
· Each year, approximately 3.6% of Salary Provision (the account
for compensation changes not yet allocated to departments) is for non-recurring
compensation changes.
· Cost savings through vacancies will be partially offset by
part-time backfill.
· OPE rate is recalculated every year using projected actual
costs of benefits. Calculated rate for 2001-02 is 45.0%. The rate has yet
to be calculated for FY03.
Expenditures: Materials & Services
· No inflationary increase in M&S is built into expenditure projections. M&S budgets are ìrolled overî from the current year into the budget year.
Expenditures: Capital Outlay
· No inflationary increase in Capital Outlay is built into expenditure projections.
Expenditures: Unappropriated Ending Fund Balance:
· According to Local Budget Law, the Unappropriated Ending Fund Balance (UEFB) from previous year may not be spent except under extraordinary circumstances and therefore will be part of the total Ending Fund Balance and a resource (Net Working Capital Unrestricted and part of the Beginning Fund Balance) for the ensuing year.
Expenditures: Contingency:
· It is assumed that current year Contingency will be 100% spent
during the year.
· This assumption will change toward the end of the current
year to reflect a higher projected Ending Fund Balance (Beginning Fund
Balance for the ensuing budget year).
Net Working Capital Assumptions
Beginning Fund Balance and Net Working Capital
The spreadsheet and charts below show the history of Net Working Capital
from Fiscal Year 1995 through Fiscal Year 2001. The Beginning Fund
Balance (the sum of Net Working Capital Unrestricted and Net Working Capital
Restricted from 6/30 the previous year) is shown in dollars, as a percentage
of the annual budget, and as the number of months of expenditures the Beginning
Fund Balance would cover.
|
|
|
|
|
|
|
|
|
|
NWC Restricted |
|
|
|
|
|
|
|
|
|
NWC Unrestricted |
|
|
|
|
|
|
|
|
|
Beginning Fund Balance (BFB) |
|
|
|
|
|
|
|
|
|
Total Budget |
|
|
|
|
|
|
|
|
|
Beginning Fund Balance as % of Budget |
|
|
|
|
|
|
|
|
|
BFB as # months expenses |
|
|
|
|
|
|
|
|
The size of Net Working Capital Restricted grew steadily during the first few years (after Fiscal Year 1994) that both ICP and department Materials & Services balances were carried over into the ensuing fiscal year. Since Fiscal Year 1999 Net Working Capital has leveled off at approximately $5 million. Since 1999, Net Working Capital Restricted has been large enough to carry the college through four weeks of expenditures. In the current fiscal year, Net Working Capital Restricted includes $1 million authorized in the budget process for transfer to the LASR Project (implementation of Banner information system) and $346,018 in contractually obligated funds.
Net Working Capital Unrestricted has remained steady at between $4 million
and $6 million. Another way to state this is that Net Working Capital
Unrestricted typically is enough funds to carry the college through three
to five weeks of expenditures.
Budget Projection Assumptions for FY03 and Beyond
· For the purposes of projecting future budgets, it is assumed
that restricted revenues, including Net Working Capital Restricted, are
entirely expended during the year.
|
Data Sources for Accompanying Spreadsheet
· ìTotal Budgetî figures are from the collegeís annual Budget
Documents
· ìActualî Net Working Capital Restricted and Net Working Capital
Unrestricted figures are from Budget Office records.
· Beginning Fund Balance figures are from the Annual Financial
Reports
Revenue Assumptions
State Revenue
The spreadsheet and chart below show budget and actual revenues from the State of Oregon for the fiscal years 1992 through 2001. Also shown are calculations for (a) the difference in dollars between budget and actual, (b) the dollar increase/decrease from the previous year, and (c) the percent increase/decrease from the previous year.
STATE RESOURCES HISTORY | ||||||||||
|
|
|
|
|
|
|
|
|
|
|
Budget |
|
|
|
|
|
|
|
|
|
|
Actual |
|
|
|
|
|
|
|
|
|
|
Difference (Actual minus Budget) |
|
|
|
|
|
|
|
|
|
|
Actual Inc (Dec) from previous year |
|
|
|
|
|
|
|
|
|
|
% Increase (Decrease) in Actual |
|
|
|
|
|
|
|
|
|
Since the passage of Ballot Measure 5 in 1991, Oregon community colleges have relied more and more on funding from the State. Phase-in of a funding formula based on enrollment and the passage of Ballot Measure 47/50 have almost reached final implementation, resulting in more stable state funding. However, multiple pressures on the state budget have resulted in state funding increases that do not match the demands of enrollment growth at the community colleges.
One-half of each collegeís property tax revenue is taken into account
in the state funding formula. An explanation of the funding formula
is on Laneís Budget Development web site: http://2011sitearchive.lanecc.edu/budget/fundform.htm
Budget Projection Assumptions for FY03 and Beyond
· FY03: The college relies on state projections based on the
biennial allocation of funds to the community colleges and the funding
formula. The State will be splitting the funding formula allocation
50/50 between FY02 and FY03.
|
Data Sources for Accompanying Spreadsheet
· ìBudgetî revenues are from the collegeís annual Budget Documents
· ìActualî revenues are from the Annual Financial Reports
Revenue Assumptions
Local Property Taxes
The spreadsheet and chart below show budget and actual revenues from Local Property Taxes for the fiscal years 1992 through 2001. Also shown are calculations for (a) the difference in dollars between budget and actual, (b) the dollar increase/decrease from the previous year, and (c) the percent increase/decrease from the previous year.
PROPERTY TAX HISTORY | ||||||||||
|
|
|
|
|
|
|
|
|
|
|
Budget |
|
|
|
|
|
|
|
|
|
|
Actual |
|
|
|
|
|
|
|
|
|
|
Difference (Actual minus Budget) |
|
|
|
|
|
|
|
|
|
|
Actual Inc (Dec) from previous year |
|
|
|
|
|
|
|
|
|
|
% Increase (Decrease) in Actual |
|
|
|
|
|
|
|
|
|
Since the passage of Ballot Measure 5 in 1991, Oregon community colleges have relied less and less on local property tax revenues. Since the passage of Ballot Measure 47/50, revenues from property taxes have stabilized and are much more predictable than before FY 99.
Because property taxes are used in the state funding formula, the college
uses state projections for property tax receipts. In general, the state
uses the assumption that property tax revenues will increase approximately
4.5% per year for Lane County.
Budget Projection Assumptions for FY03 and Beyond
· Property tax revenues will increase approximately 4.5% per
year.
|
Data Sources for Accompanying Spreadsheet
· ìBudgetî revenues are from the collegeís annual Budget Documents
· ìActualî revenues are from the Annual Financial Reports
Revenue Assumptions
Tuition
The spreadsheet and chart below show budget and actual revenues from tuition for the fiscal years 1992 through 2001. Also shown are calculations for (a) the difference in dollars between budget and actual, (b) the dollar increase/decrease from the previous year, and (c) the percent increase/decrease from the previous year.
TUITION HISTORY | ||||||||||
|
|
|
|
|
|
|
|
|
|
|
Budget |
|
|
|
|
|
|
|
|
|
|
Actual |
|
|
|
|
|
|
|
|
|
|
Difference (Actual minus Budget) |
|
|
|
|
|
|
|
|
|
|
Actual Inc (Dec) from previous year |
|
|
|
|
|
|
|
|
|
|
% Increase (Decrease) in Actual |
|
|
|
|
|
|
|
|
|
|
FTE |
|
|
|
|
|
|
|
|
|
|
Tuition Revenue per FTE |
|
|
|
|
|
|
|
|
|
|
Budget Projection Assumptions for FY03 and Beyond
· Tuition revenues are projected based on enrollment projections
developed by Institutional Research, Assessment & Planning
|
Data Sources for Accompanying Spreadsheet
· ìBudgetî revenues are from the collegeís annual Budget Documents
· ìActualî revenues are from the Annual Financial Reports
Revenue Assumptions
Mandatory Instructional Fees/Non-Mandatory Instructional Fees/ Other Fees
The spreadsheet and chart below show budget and actual revenues from mandatory instructional fees, non-mandatory instructional fees, and other miscellaneous fees for the fiscal years 1992 through 2001. Also shown are calculations for (a) the difference in dollars between budget and actual, (b) the dollar increase/decrease from the previous year, and (c) the percent increase/decrease from the previous year.
INSTRUCTIONAL FEES HISTORY | ||||||||||
|
|
|
|
|
|
|
|
|
|
|
Budget |
|
|
|
|
|
|
|
|
|
|
Actual |
|
|
|
|
|
|
|
|
|
|
Difference (Actual minus Budget) |
|
|
|
|
|
|
|
|
|
|
Actual Inc (Dec) from previous year |
|
|
|
|
|
|
|
|
|
|
% Increase (Decrease) in Actual |
|
|
|
|
|
|
|
|
|
|
FTE |
|
|
|
|
|
|||||
Instructional Fees Revenue per FTE |
|
|
|
|
|
Increases in fee revenue from year to year can be the result of (a)
increases in enrollment or number of users, and/or (b) increases in fee
rates.
Budget Projection Assumptions for FY03 and Beyond
· Projections assume that all fees collected at 100%.
Uncollected fees are reported as an expenditure.
|
Data Sources for Accompanying Spreadsheet
· ìBudgetî revenues are from the collegeís annual Budget Documents
· ìActualî revenues are from the Annual Financial Reports
Revenue Assumptions
Miscellaneous Revenue Sources
Budget Projection Assumptions for FY03 and Beyond
Interest on investments:
Sale of Goods and Services assumptions:
|
Note on investments:
While expenditure patterns for the college are relatively stable from
month to month the receipt of revenues is not. The college receives
large amounts of money at particular times of the year as noted below:
Quarterly payments from the state: August, October, January, April
Property tax revenues: December or January
Tuition and fee receipts: September, January, March
Quite large amounts of money may be invested in January, for example, awaiting expenditures over the remainder of the fiscal year.
Expenditure Assumptions
General Assumptions
Budget projections assume that the college will maintain ìcurrent service levelî expenditures. That is, the college will continue to offer the current mix and level of programs and services. (The budgeting model used by the college is a modified incremental model where current-year budgets are considered as the starting point for budget development for the following year.)
Budget projections for future years include $700,000 in additional unidentified expenditures (recurring annually) to cover ìmandatoryî expenditure increases.
Expenditure Assumptions
Personal Services
The spreadsheet and chart below show budget and actual expenditures for Personal Services for the fiscal years 1992 through 2001. Also shown are calculations for (a) the difference in dollars between budget and actual, (b) the dollar increase/decrease from the previous year, and (c) the percent increase/decrease from the previous year.
|
|
|
|
|
|
|
|
|
|
|
Expenditures by Object | ||||||||||
Personal Services | ||||||||||
Budget |
|
|
|
|
|
|
|
|
|
|
Actual |
|
|
|
|
|
|
|
|
|
|
Actual minus Budget |
|
|
|
|
|
|
|
|
|
|
Increase (Decrease) from previous year |
|
|
|
|
|
|
|
|
|
|
% Inc (Dec) from previous year |
|
|
|
|
|
|
|
|
|
Annual increases in Personal Services expenditures are due to (a) increases in employee compensation levels, (b) increases in the OPE (Other Personnel Expenses) rate, (c) increases in staffing levels, or a combination of any of these factors.
The Office of Instruction & Student Services annually allocates
money to instructional divisions during the year for ìextraî class sections.
This money is spent for faculty Personal Services however the funds are
budgeted under ìReserve for Restricted Revenue Changesî on the Contingency/Projects
& Provisions page of the budget.
Budget Projection Assumptions for FY03 and Beyond
· Personal Services expenditures for FY03 use current negotiation
parameters.
|
Note:
The figures for total salary base and compensation increases (Salary
Provision) are based on the most current updated Position List, which is
employee-specific and takes into account where each employee is placed
on the salary schedules.
Data Sources for Accompanying Spreadsheet
· ìBudgetî expenditures are from the collegeís annual Budget
Documents
· ìActualî expenditures are from the Annual Financial Reports
Expenditure Assumptions
Materials & Services
The spreadsheet and chart below show budget and actual expenditures
for Personal Services for the fiscal years 1992 through 2001. Also shown
are calculations for (a) the difference in dollars between budget and actual,
(b) the dollar increase/decrease from the previous year, and (c) the percent
increase/decrease from the previous year.
Materials & Services |
|
|
|
|
|
|
|
|
|
|
Budget |
|
|
|
|
|
|
|
|
|
|
Budget (without NWC Restricted) |
|
|
|
|
|
|
|
|
|
|
Actual |
|
|
|
|
|
|
|
|
|
|
Actual minus Budget |
|
|
|
|
|
|
|
|
|
|
Increase (Decrease) from previous year |
|
|
|
|
|
|
|
|
|
|
% Inc (Dec) from previous year |
|
|
|
|
|
|
|
|
|
Budget authority (authorization to expend funds received) for Net Working
Capital Restricted is normally included in the ìBudgetî figures, so for
comparison a third column is shown for M&S Budget without Net Working
Capital Restricted.
Budget Projection Assumptions for FY03 and Beyond
· No inflationary increase in M&S is built into expenditure projections. M&S budgets are ìrolled overî from the current year into the budget year. |
Data Sources for Accompanying Spreadsheet
· ìBudgetî expenditures are from the collegeís annual Budget
Documents
· ìActualî expenditures are from the Annual Financial Reports
Expenditure Assumptions
Capital Outlay
The spreadsheet and chart below show budget and actual expenditures for Personal Services for the fiscal years 1992 through 2001. Also shown are calculations for (a) the difference in dollars between budget and actual, (b) the dollar increase/decrease from the previous year, and (c) the percent increase/decrease from the previous year.
Capital Outlay |
|
|
|
|
|
|
|
|
|
|
Budget |
|
|
|
|
|
|
|
|
|
|
Actual |
|
|
|
|
|
|
|
|
|
|
Actual minus Budget |
|
|
|
|
|
|
|
|
|
|
Increase (Decrease) from previous year |
|
|
|
|
|
|
|
|
|
|
% Inc (Dec) from previous year |
|
|
|
|
|
|
|
|
|
Budget Projection Assumptions for FY03 and Beyond
· No inflationary increase in Capital Outlay is built into expenditure projections. |
Data Sources for Accompanying Spreadsheet
· ìBudgetî expenditures are from the collegeís annual Budget
Documents
· ìActualî expenditures are from the Annual Financial Reports
Expenditure Assumptions
Miscellaneous Expenditure Categories
Budget Projection Assumptions for FY03 and Beyond
Unappropriated Ending Fund Balance:
Contingency:
|
Transfers Out and Transfers In
The spreadsheet below shows the transfers from the General Fund to other
funds for Fiscal Year 2000-01. Funds are transferred annually for
a variety of purposes.
|
|||||||||
|
|
|
|
|
|
|
|||
|
|
|
|
|
|||||
Transferred From | Transferred To |
|
|
|
|
|
|
|
|
Facilities Management & Planning | |||||||||
Motor Pool | Internal Service Fund (II) | 23,533 | 23,533 | ||||||
Debt Services Loan Payment | Debt Service Fund (III) | 102,000 | 102,000 | ||||||
Major Maintenance | Capital Projects Fund (IV) | 118,489 | 118,489 | ||||||
Capital Repairs/Improvements | Capital Projects Fund (IV) | 725,000 | 725,000 | ||||||
Specialized Employment Services | |||||||||
Laundry | Enterprise Fund (VI) | 166,537 | 166,537 | ||||||
Financial Aid | Student Financial Aid Fund (V) | 434,768 | 434,768 | ||||||
Disability Services | |||||||||
Childcare Resource Center | Special Revenue Fund (VIII) | 4,750 | 4,750 | ||||||
Student Activities | |||||||||
Downtown Center Parking Subisdy | Enterprise Fund (VI) | 14,000 | 14,000 | ||||||
LTD Bus Pass Program | Enterprise Fund (VI) | 136,800 | 136,800 | ||||||
Student Financial Services | |||||||||
Job Placement Office | Student Financial Aid Fund (V) | 95,626 | 95,626 | ||||||
Learn & Earn Program | Student Financial Aid Fund (V) | 120,000 | 120,000 | ||||||
Student Health Services | Enterprise Fund (VI) | 271,948 | 271,948 | ||||||
College Operations Office | |||||||||
Mailroom Support | Internal Service Fund (II) | 16,763 | 16,763 | ||||||
Computer Services | |||||||||
Telephone Services | Internal Service Fund (II) | 231,097 | 231,097 | ||||||
Computer Payment | Debt Service Fund (III) | 233,200 | 233,200 | ||||||
KLCC Endowment | Endowment Fund (X) | 500 | - | - | - | - | - | - | 500 |
TOTAL TRANSFERS OUT | $ 2,695,011 | $271,393 | $335,200 | $843,489 | $ 650,394 | $ 589,285 | $ 4,750 | $ 500 |
Revenues Over (Under) Expenditures
The spreadsheet and chart below show the history of General Fund Revenues (minus Net Working Capital) over (under) Expenditures and Operating Transfers from Fiscal Year 1995 through Fiscal Year 2001.
FY95 | FY96 | FY97 | FY98 | FY99 | FY00 | FY01 | |
Revenues | |||||||
State & Federal | 21,725,931 | 24,799,591 | 24,948,769 | 27,671,711 | 28,848,379 | 29,456,241 | 29,964,650 |
Property Taxes | 12,911,989 | 9,334,292 | 10,018,544 | 9,219,781 | 9,509,132 | 9,939,709 | 10,316,442 |
Tuition | 10,243,326 | 10,655,786 | 10,854,937 | 10,820,982 | 12,532,586 | 12,937,821 | 12,997,798 |
Mandatory Class Fees | 2,131,870 | 2,331,768 | 2,645,851 | 2,680,508 | 3,057,503 | 2,972,431 | 3,338,481 |
Other | 3,783,797 | 4,308,464 | 4,619,020 | 4,977,003 | 4,969,293 | 5,278,559 | 5,673,632 |
Total Revenues | 50,796,913 | 51,429,901 | 53,087,121 | 55,369,985 | 58,916,893 | 60,584,761 | 62,291,003 |
Expenditures | |||||||
Instruction | 27,847,669 | 29,317,213 | 30,547,378 | 31,893,143 | 33,074,722 | 35,259,169 | 36,453,578 |
Community Services | 725,376 | 788,682 | 826,509 | 963,193 | 1,017,228 | 1,081,908 | 1,128,077 |
Instructional Support | 1,924,601 | 2,194,626 | 2,189,053 | 2,299,945 | 2,395,012 | 2,757,368 | 2,713,706 |
Student Services | 4,431,080 | 4,646,958 | 5,072,696 | 5,025,554 | 5,529,431 | 5,887,064 | 6,441,617 |
College support services | 6,789,253 | 8,179,024 | 9,211,256 | 8,543,162 | 9,068,809 | 8,979,649 | 8,748,173 |
Plant O&M | 3,197,880 | 3,294,168 | 3,508,831 | 3,565,797 | 3,705,173 | 4,020,925 | 4,489,607 |
Financial Aid | 19,080 | - | 720 | - | 492 | - | - |
Total Expenditures | 44,934,939 | 48,420,671 | 51,356,443 | 52,290,794 | 54,790,867 | 57,986,083 | 59,974,758 |
Other Financing Sources (Uses) | |||||||
Operating Transfers In | 368,450 | 219,374 | 181,746 | 192,283 | 142,015 | 144,250 | 163,688 |
Operating Transfers Out | (3,828,917) | (2,680,593) | (2,437,404) | (2,478,155) | (2,289,627) | (3,878,111) | (2,883,104) |
Total Other Financing Sources (Uses) | (3,460,467) | (2,461,219) | (2,255,658) | (2,285,872) | (2,147,612) | (3,733,861) | (2,719,416) |
Total Expenditures & Other Sources | 48,395,406 | 50,881,890 | 53,612,101 | 54,576,666 | 56,938,479 | 61,719,944 | 62,694,174 |
Revenues over (under) Expenditures | 2,401,507 | 548,011 | (524,980) | 793,319 | 1,978,414 | (1,135,183) | (403,171) |
Source: Annual Financial Reports/Combined Statements of Revenues, Expenditures and Changes in Fund Balances (Non-GAAP Budgetary Basis) - General Fund |
Note that negative numbers in the line labeled ìRevenues over (under) Expendituresî and bars below the zero-dollar line on the chart mean that in those years the college spent more money than it took in. Carryover (Net Working Capital) was used to cover expenditures in those years.
Data Sources for Accompanying Spreadsheet
· Actual Revenues, Expenditures and Operating Transfers
are from the Annual Financial Reports/Combined Statements of Revenues,
Expenditures and Changes in Fund Balances (Non-GAAP Budgetary Basis) ñ
General Fund
Assumptions about Other Funds
Funds may not be transferred to the General Fund from several sources
outside the General Fund, including:
· OPE (Other Personnel Expenses)
· Financial Aid Fund
· Bond Construction Funds and other plant funds legally designated
for a specific use
· Trust and Agency Funds (including employee early retirement
funds)
· Special Revenue (grants and contracts)
· Endowment Fund
Administrative Overhead at the rate of 2.5% of gross revenue is charged
to the Bookstore and Foodservices. This amount is transferred annually
to the General Fund.