Board of Trustees Agenda 2020

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