NEW PROGRAM BUDGET WORKSHEET Leave cells blank if the information is not applicable to your new program proposal Please add comments and justifications to the right of year 5 Cells in grey are formulas that calculate long term enrollments, FTEs, salary/benefits. These cells should not be used to enter data. Data entry should occur in the green cells only.
I. PLANNED STUDENT ENROLLMENT (click here for retention rates)
Year 1
Year 2
Year 3
Year 4
Year 5
PLANNED
PLANNED
PLANNED
PLANNED
PLANNED
FTE 1.
FTE 1.
FTE 1.
FTE 1.
FTE 1.
Enrollment
Enrollment
Enrollment
Enrollment
Enrollment
A. New Enrollments
Undergrad students …………………… Graduate students (General MBA)……………
23
28
34
34
50
60
28
28
40
46
CoB Graduate students…………….. B. Prior Year's Enrollments Adjusted for Retention Undergrad students ………………..
0 0 0
0 0 0
0 0 0
0 0 0
Graduate students………………...… CoB Graduate students……………..
C. Total Headcounts
0
0
Undergrad students ……………………………….. Graduate students………………...……………….
0
0
0
23
28
28
40
50
CoB Graduate students……………..
0
0
0
0
0
Enrollment Notes: For this worksheet Planned FTE and Headcount is assumed to be equal. Cells in grey are formulas for student retention calculations. Enter FTE expected in each year under A. New Enrollments. II. REVENUE On-going One-time Year 1
Year 2
Year 3
Year 4
Year 5
One-time
On-going
One-time
On-going
One-time
On-going
One-time
On-going
1 New Appropriated Funding Request ……….... 2 Institutional Funds …………...………..……………. 3 Federal e.g. grant funds……………………....…. 4 Est. tuition generated by program's college 2
389,132 67,028 28,000
0 0 0 0
473,726 81,599 34,000
0 0 0 0
473,726 81,599 34,000
0 0 0 0
676,752 116,570 46,000
0 0 0 0
845,940 145,712 60,000
6 Student Mandatory fees
7 Other fees (orientation & capstone, etc.) …………………
8 Other (e.g Kobata, VFF grants TOTAL REVENUE
484,160
0
589,325
0
589,325
0
839,322
0
1,051,652
0
Revenue notes:
Enrollments are assumed to be full time; therefore FTE=headcount Tuition and Mandatory Fees are published on the Financial Aid website. Updates are needed each academic year Do not change values in grey. Those are calculated on annual tuition rates * # of FTE above Annual Tuition and Fees Per Credit Tuition Tuition Mandatory Fees
Fall 2025 and winter start with 3/4 student calculations for Fall-Summer budget
Resident Undergraduate
241.03 367.80
$7,230 $16,919
$2,186
Summer tuition is the same as other quarters
Resident Graduate
$2,914 Assumption= FTE with 12 redit hours every quarter Fall through Summer and Winter through Fall General MBA (45-47 credit hours)
III. EXPENDITURES
Year 1
Year 2
Year 3
Year 4
Year 5
Ongoing from Prior Year
New In Current Year
Ongoing from Prior Year
New In Current Year
Ongoing from Prior Year
New In Current Year
Ongoing from Prior Year
New In Current Year
New Ongoing Hires
A. Additional Personnel Needed
Salary/FTE
(from Column E)
(Column I + K)
(Column M + O)
(Column Q + S)
0 9 1 0 0
0
0
1
1 8 1 0 3
1
1. Faculty FTE ………………………….............……………… 2. Adjunct Faculty FTE…………...……………...…..………. 3. Exempt Staff FTE ……………………………………...……. 4. Directors / Administrator FTE …………....………….. 5. Classified Staff FTE ……………………………....………. 6. Undergrad/Graduate Student FTE ………...…........
135,000 7,500 54,000
9 1
3
12
12
1
1
0.5
12000
12000
12000
12000
15000
0 1
0 2
0
1
1
1
1
15,000
B. Personnel Costs (Total Salary Cost based on # of positions in A. above) 1 Faculty Salary …………………………..………...……
0
0
0
0
0 0 0 0
0
135,000
139,050 100,558 60,777 70,000
135,000
67,500 54,000 12,000
69,525 55,620 12,360
22,500
94,786 57,289 12,731
97,629 59,007
0 0
0
2 Adjunct Salary ……………………………………....... 3 Exempt Staff Salary ………………………………….. 4 Directors/Administrators Salary ………………..
0 0
27,000
70,000
Made with FlippingBook interactive PDF creator