NEWPROGRAMBUDGETWORKSHEET Leave cellsblank if the information isnotapplicable toyournewprogramproposal Pleaseadd commentsand justifications to the rightofyear5
I.PLANNEDSTUDENTENROLLMENT (click here for retention rates)
Year1
Year2
Year3
Year4
Year5
PLANNED
PLANNED
PLANNED
PLANNED
PLANNED
FTE 1.
FTE 1.
FTE 1.
FTE 1.
FTE 1.
A.NewEnrollments
Undergrad students……………………………….. Graduate students………………...……………….
30
55
80 10
120
160
Demandgrowth is combinationofEntrepreneurshipMinorandProposedMajor
0
5
15
20
B.PriorYear'sEnrollmentsAdjusted forRetention Undergrad students………………………………..
24
43
60
73 12
Retention rateadjusted to85%given this isupperdivisionprogram
Graduate students………………...……………….
0
4
8
C.TotalHeadcounts
Undergrad students……………………………….. Graduate students………………...……………….
30
79
123
180
233
0
5
14
23
32
1.For thisworksheetPlannedFTEandHeadcount isassumed tobeequal.
II.REVENUE
Year1
Year2
Year3
Year4
Year5
On-going
One-time
On-going
One-time
On-going
One-time
On-going
One-time
On-going
One-time
1 NewAppropriatedFundingRequest………........…… 2 InstitutionalFunds…………...………..…………...…………. 3 Federale.g.grant funds……………………....….……..…… 4 Est. tuitiongeneratedbyprogram's college 2 5 Estimated tuitiongeneratedbyother colleges
143,540 15,949 18,660
267,021 29,669
390,501 43,389
585,752 65,084
781,002 86,778 152,055
6 Student fees
50,298 #
79,789 #
116,997 #
7 Other fees (course fees,etc.)……………………….….… 8 Other (e.g.Gifts)……………………………......……………… HerbertB JonesGrant installments
214,740 214,740
151,627 151,627
75,813 75,813
HerbertB JonesFoundation3yeargrant, coveringpartial salary costs forprogram startup.
TOTALREVENUE
178,149 #
346,988
513,679
767,832
0
1,019,835
0
Revenuenotes:
1.Enrollmentsareassumed tobe full time; thereforeFTE=headcount 2.College shareof tuition
0.9 note:users can change these to reflect their situation
Other college share Increased tuitionand fees
0.1
Tuition
Fees $622
Undergraduate $1,969 x3=$5,907 $5,907 Graduate $2,862 x3=$8,586 $8,586
$232 Note: full timeunderrateout-of-state tuition is$6,570 forundergraduatesand$6,704 forgraduate students
III.EXPENDITURES
Year1
Year2
Year3
Year4
Year5
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
A.AdditionalPersonnelNeeded
1.FacultyFTE………………………….............……………… 2.AdjunctFacultyFTE…………...……………...…..……… 3.StaffFTE……………………………………...…...….….…… 4.Directors /AdministratorFTE…………....………… 5.ClassifiedStaffFTE……………………………....……… 6.Undergrad/GraduateStudentFTE………...….... B.PersonnelCosts 1 FacultySalary…………………………..………...……..…..... 2 AdjunctSalary………………………………………..………… 3 StaffSalary………………………………………….…………… 4 Directors/AdministratorsSalary………………..……. 5 ClassifiedStaff…………………………………………………. 6 Undergraduate/GraduateStudentWages 7 EstimatedBenefits 3. ……………………………....…….. 8 CWU'sShareofRetirement……………………………..
ResearchActiveT/TT's required tomaintainAACSBAccreditationRatios PrimaryFacultyPositionhiredundergrantas full timeProgramManager
2
3
4 1
4 1
5 1
0
1
2
2
2
80,000
132,400
182,848 30,000 13,000 40,800 93,386 22,585
186,848 30,600 13,000 41,880 94,122 23,045
246,848 30,600 13,000 41,880 114,678 29,045
13,000
13,000
20,000 58,602 14,540
39,262
0 0
0 0
0 0
0 0
0 0
9,300
9 Other,e.g.,grant funded studentworkers Total IncrementalPayroll
$141,562
$0
$238,542 #
$0
$382,618 #
$0
$389,494 #
$0
$476,050
$0
3. See thisworksheet fordetailsonbenefits
DetailsonBenefits
C.OperatingExpenses
Year1
Year2
Year3
Year4
Year5
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
1 SqftAdditionaloffice&other space……….……… 2 Costof spaceoutsideof college…………………….. 3 Newphones, computers&Furniture………….. 3 Travel…………………………………………………………….. 4 ProfessionalServices……………………………………… 5 OtherServices………………………………………………… 6 New faculty startup costs……………………………… 7 Communications/Promotions………………………… 8 MaterialsandSupplies…………………………………… 9 MaintenanceandRepairs……………………………… 10 Assessment/accreditation……………………………… 11 Miscellaneous costs………………………………………
300
500
700
900
1,000
200
2,000 2,000
400
2,000
600
4,000
1,000 2,000
4,000
2,000 2,000
2,000
1,500
1,500
1,500
200 100
200 200
200 300
200 400
200 500
10,000
20,000
10,000
40,000
10,000
10,000
10,000
Marketing in firstyears toestablishandposition in regional schoolsashigh success rateprogram for lean startups.
200
400 200
600 200
1,000
1,000
200
200
4,000
4,000
4,000
4,000
200
400
600
800
800
TOTALOPERATINGExpenses
$12,400
$24,000
$17,300
$42,000
$18,000
$4,000
$19,600
$4,000
$20,700
$2,000
Note: the ratioofoperatingexpenseper facultyFTE is:
- $
- $
- $
- $
- $
D.CapitalExpenditures
Year1
Year2
Year3
Year4
Year5
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
Ongoing
One-Time
1. LibraryResources……………………………………….. 2.Equipment…………………………………………………..
1,000
1,000
1,000
1,000
1,000
TotalCapitalExpenditure……...….....… $1,000
- $
$1,000
- $
$1,000
- $
$1,000
- $
$1,000
- $
E.NET INCOMEFROMOPERATIONS
$23,187
$190,740
$90,146
$109,627
$112,060
$71,813
$357,738
$ (4,000)
$522,084
$ (2,000)
Revenue lessPersonnel,Operating, andCapitalexpense
III.CAPITALFACILITIES,CONSTRUCTION,
MAJORRENOVATIONS,MAJOREQUIPMENT
$0
$0
$0
$0
$0
Made with FlippingBook flipbook maker