NEW PROGRAM BUDGET WORKSHEET 2020-21 Leave cells blank if the information is not applicable to your new program proposal Please add comments and brief justifications to the right of year 5. Include a full narrative within the New Program Pre-proposal Form. Note: Values will be updated yearly. Please ensure the correct year's form is being used. I. PLANNED STUDENT ENROLLMENT (click here for retention rates) PLANNED PLANNED PLANNED Year 1
Year 2
Year 3
Year 4
Year 5
PLANNED Headcount
PLANNED
PLANNED Headcount
PLANNED
PLANNED Headcount
PLANNED PLANNED
FTE
Headcount
FTE
FTE
FTE
FTE
Headcount
A. New Enrollments 1
Undergrad students ……………………………….. B. Prior Year's Enrollments Adjusted for Retention Undergrad students ………………………………..
5
5
6
6
7
7
8
8
9 9
Expected yearly increase in students based on current enrollment trends
4
4
4
4
5
5
6 6
C. Total Headcounts
Undergrad students ………………………………..
5
5
10
10
11
11
13
13
15 15
1. New Enrollment refers to students who would otherwise not attend CWU without this program.
II. REVENUE
Year 1
Year 2
Year 3
Year 4
Year 5
On-going
One-time
On-going
One-time
On-going
One-time
On-going
One-time
On-going
One-time
1 New Appropriated Funding Request ………........…… 2 Institutional Funds …………...………..…………...…………. 3 Federal e.g. grant funds……………………....….……..…… 4 Est. tuition generated by program's college 2 5 Estimated tuition generated by other colleges 7 Other fees (course fees, etc.) ……………………….….… 8 Other (e.g. Gifts) ……………………………......……………… TOTAL REVENUE 6 Student fees
0
0
0
0
0
15,000 27,798
WSOS grant first year
33,357
38,917
44,477
50,036
0 0
0 0
0 0
0 0
0 0
42,798 28,899
0
33,357 16,679
0 0
38,917 19,459
0 0
44,477 22,238
0 0
50,036 25,018
NET College Revenue after Overhead*
0 0
*estimated at 50%
Revenue notes:
2. College share of SCH generation
1 Note: users can change these to reflect their situation
Other colleges' share Increased tuition and fees
0 Shares must sum to 1.0
Tuition
Fees Average tuition calculated after sutracting out averate waiver. $652 See Retention & Tuition Rate tab for more details.
Average Residential Undergrad Average Residential Grad
$ $
5,559.58 7,631.64
$652 Note: Fees at Centers are $285.60 Note: full time undergrad out-of-state net tuition (after waivers) is $12,319 for undergraduates and $7632 for graduate students
III. EXPENDITURES
Year 1
Year 2
Year 3
Year 4
Year 5
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
A. Additional Personnel Needed
1. Faculty FTE ………………………….............……………… 2. Adjunct Faculty FTE…………...……………...…..……… 3. Staff FTE ……………………………………...…...….….…… 4. Directors / Administrator FTE …………....………… 5. Classified Staff FTE ……………………………....……… 6. Undergrad/Graduate Student FTE ………...….... B. Personnel Costs 1 Faculty Salary …………………………..………...……..…..... 2 Adjunct Salary ………………………………………..………… 3 Staff Salary ………………………………………….…………… 4 Directors/Administrators Salary ………………..……. 5 Classified Staff …………………………………………………. 6 Undergraduate/Graduate Student Wages 7 Estimated Benefits 3 ……………………………....…….. 8 CWU's Share of Retirement…………………………….. 9 Other, e.g., grant funded student workers Total Incremental Payroll
N/A 0.26
No new TT faculty would be hired 0.31 12-14 wlu per year for all sections
0.26
0.26
0.31
0 0 0 0
0 0
0 0
0 0
0 0
0
0 0
0
0 0
0
0 0
0
0 0
0
Based on $45000
11,700
11,700
11,700
13,950
13,950
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0
0 0 0 0
0
0
0
0
4,721 1,170
0 0
4,721 1,170
0 0
4,721 1,170
0 0
5,628 1,395
0 0
5,628 0 1,395 0
$ 17,591
$ 0
$ 17,591
$ 0
$ 17,591
$ 20,973
$ 0
$ 20,973 $ 0
3. See this worksheet for details on benefits
Details on Benefits
C. Operating Expenses
Year 1
Year 2
Year 3
Year 4
Year 5
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
Made with FlippingBook Publishing Software