NEW PROGRAM BUDGET WORKSHEET 2017-18 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 PLANNED Year 1 Year 2
Year 3
Year 4
Year 5
PLANNED
PLANNED Headcount
PLANNED
PLANNED Headcount
PLANNED PLANNED
FTE
Headcount
FTE
Headcount
FTE
FTE
FTE
Headcount
A. New Enrollments 1
Undergrad students ……………………………….. Graduate students………………...………………. B. Prior Year's Enrollments Adjusted for Retention Undergrad students ……………………………….. Graduate students………………...……………….
8
8
8
8
20
20
20
20
20
20
6 0
6 0
10
10
23
23
30
30
0
0
0
0
0
0
C. Total Headcounts
Undergrad students ……………………………….. Graduate students………………...……………….
8 0
8 0
14
14
30
30
43
43
50
50
0
0
0
0
0
0
0
0
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
38,255
66,946
143,456 15,940 18,660
204,523 22,725 26,603
239,093 26,566 31,100
4,251 4,976
7,438 8,708
47,481
0
83,092
0
178,055
0
253,851
0
296,758
0
Revenue notes:
2. College share of SCH generation
0.9 Note: users can change these to reflect their situation
Other colleges' share Increased tuition and fees
0.1 Shares must sum to 1.0
Tuition
Fees Average tuition calculated after sutracting out averate waiver. $622 See Retention & Tuition Rate tab for more details.
Average Residential Undergrad 5,313.17 $ Average Residential Grad 6,054.52 $ $232 Note: full time underrate out-of-state tuition is $6,570 for undergraduates and $6,704 for graduate students
$8,586
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……………………………..
0
1
1
1
0.56
0.89
0.89
0.89
0.1
0
70,000 41,778
0 0
70,000 41,778
0
70,000 41,778
5,000
26,111
0 0
1,896
10,264
0 0
38,579 11,178
0 0
38,579 11,178
0 0
38,579 11,178
0 0
500
2,611
9 Other, e.g., grant funded student workers Total Incremental Payroll
$ 0
$ 2,396
$ 38,987
$ 0
$ 161,535
$ 0
$ 161,535
$ 0
$ 161,535
$ 0
3. See this worksheet for details on benefits
Detailson 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
1 Sqft Additional office & other space 4 ……….…… 2 Cost of space outside of college ($21/sqft)……. 3 New phones, computers & Furnature ……………. 4 Travel …………………………………………………………….. 5 Professional Services ……………………………………… 6 Other Services ………………………………………………… 7 New faculty start up costs ……………………………… 8 Communications/Promotions ………………………… 9 Library Resources (Consult Ginny Blackson) …. 10 Materials and Supplies …………………………………… 11 Equipment …………………………………………………….. 12 Maintenance and Repairs ……………………………… 13 Assessment/accreditation ……………………………. 14 Miscellaneous costs ……………………………………… TOTAL OPERATING Expenses
0
0
0
0
0
0
0
0
0
0
3,600
3,600
3,600
3,600
3,600
$ 3,600
$ 0
$ 3,600
$ 0
$ 3,600
$ 0
$ 3,600
$ 0
$ 3,600
$ 0
4. Additional Space outside of what College currently occupies/owns.
Note: the ratio of operating expense per faculty FTE is:
$
-
$ 6,480
$ 1,906
$ 1,906
$ 1,906
IV. NET INCOME FROM OPERATIONS
43881.3376
$ (2,396)
$ 40,506
$
-
$ 12,920
$
-
$ 88,717
$
-
$ 131,624
$
-
Revenue less Personnel, Operating, and Capital expense
V. Total Net Revenue from BA VI. Total Net Revenue from Certificate
$ 41,486
$ 40,506 $ 10,131
$ 12,920 $ 36,800
$ 88,717 $ 40,610
$ 131,624 $ 40,610
0
$
-
VII. Total Net Revenue from BA and Certificate
$ 41,486
$ 50,636
$ 49,720
$ 129,326
$ 172,233
Made with FlippingBook flipbook maker