{UTF-8}
Years of hiring=
	1
	~	1/Year
	~		|

Professors required=
	IF THEN ELSE(Professors/Faculty<"AQ/PQ ratio required", (Faculty*"AQ/PQ ratio required"\
		)-Professors, 0)
	~	Faculty
	~		|

Hiring of AF=
	IF THEN ELSE(Faculty expense gap>0, INTEGER(Faculty expense gap/Average cost per AF)\
		*Years of hiring, 0)
	~	Faculty/Year
	~		|

Hiring rate= DELAY FIXED (
	Professors required*Years of hiring, Recruiting delay , 0)
	~	Faculty/Year
	~	Tenure track hiring rate
	|

Adjunct Faculty atrittion rate=
	0.05
	~	1/Year
	~		|

Departure of AF=
	INTEGER(Adjunct Faculty*Adjunct Faculty atrittion rate)
	~	Faculty/Year
	~		|

Faculty Expense=
	Professor Expense+Adjunct Faculty Expense
	~	Dollars
	~		|

Adjunct Faculty Expense=
	Adjunct Faculty*Average cost per AF
	~	Dollars
	~		|

Faculty expense gap=
	Faculty Expense Budget-Faculty Expense
	~	Dollars
	~		|

Departure rate=
	INTEGER(Professors*Professor atrittion rate)
	~	Faculty/Year
	~		|

Professor atrittion rate=
	0.07
	~	1/Year
	~		|

Budget $ per FTES:=
	GET XLS DATA('SDSdata.xls', '2', 'B', 'q4')
	~	Dollars/FTES
	~		|

Faculty=
	Adjunct Faculty+Professors
	~	Faculty
	~		|

Faculty Expense Budget=
	Business FTES*Budget $ per FTES
	~	Dollars
	~		|

Recruiting delay=
	1
	~	Year
	~	Recruiting cycle takes approximately one academic year to complete
	|

Professor Expense=
	Average cost per Professor*Professors
	~	Dollars
	~		|

Adjunct Faculty= INTEG (
	Hiring of AF-Departure of AF,
		30)
	~	Faculty
	~	Adjunct Faculty with a teaching load of 4+4 per AY
	|

Admissions=
	Freshman Registration+Transfer Students
	~	FTES/Year
	~		|

Attrition=
	Business FTES*"Dropout & transfer rate"
	~	FTES/Year
	~		|

"Dropout & transfer rate"=
	0.08
	~	1/Year
	~		|

Business FTES= INTEG (
	Admissions-Attrition-Exit,
		1606)
	~	FTES
	~		|

Exit=
	Business FTES*Graduation Rate
	~	FTES/Year
	~		|

"AQ/PQ ratio required"=
	0.5
	~	Dmnl
	~		|

Average cost per AF=
	50000
	~	Dollars/Faculty
	~		|

Average cost per Professor=
	100000
	~	Dollars/Faculty
	~	100,000 / 6 sections per AY
	|

Professors= INTEG (
	Hiring rate-Departure rate,
		30)
	~	Faculty
	~	Tenured, Tenure track faculty, and other faculty with TT teaching load of \
		3+3 sections per AY
	|

Graduation Rate=
	0.2
	~	1/Year
	~		|

Transfer Students:=
	GET XLS DATA('SDSdata.xls', '2', 'B', 'k4')
	~	FTES/Year
	~		|

Freshman Registration:=
	GET XLS DATA('SDSdata.xls', '2', 'B', 's4')
	~	FTES/Year
	~		|

********************************************************
	.Control
********************************************************~
		Simulation Control Parameters
	|

FINAL TIME  = 20
	~	Year
	~	The final time for the simulation.
	|

INITIAL TIME  = 0
	~	Year
	~	The initial time for the simulation.
	|

SAVEPER  = 
        TIME STEP
	~	Year [0,?]
	~	The frequency with which output is stored.
	|

TIME STEP  = 0.5
	~	Year [0,?]
	~	The time step for the simulation.
	|

\\\---/// Sketch information - do not modify anything except names
V300  Do not put anything below this section - it will be ignored
*View 1
$192-192-192,0,Times New Roman|12||0-0-0|0-0-0|0-0-255|-1--1--1|-1--1--1|120,120,100,0
10,1,Business FTES,910,191,58,26,3,131,0,0,0,0,0,0
12,2,48,704,190,10,8,0,3,0,0,-1,0,0,0
1,3,5,1,4,0,0,22,0,0,0,-1--1--1,,1|(822,188)|
1,4,5,2,100,0,0,22,0,0,0,-1--1--1,,1|(745,188)|
11,5,48,785,188,8,10,34,3,0,0,1,0,0,0
10,6,Admissions,785,212,46,14,40,3,0,0,-1,0,0,0
10,7,Transfer Students,692,107,64,24,8,131,0,0,0,0,0,0
10,8,Freshman Registration,692,287,83,24,8,131,0,0,0,0,0,0
10,9,Professors,888,600,50,25,3,3,0,0,0,0,0,0
12,10,48,709,601,10,8,0,3,0,0,-1,0,0,0
1,11,13,9,4,0,0,22,0,0,0,-1--1--1,,1|(812,601)|
1,12,13,10,100,0,0,22,0,0,0,-1--1--1,,1|(745,601)|
11,13,48,779,601,8,10,34,3,0,0,1,0,0,0
10,14,Hiring rate,779,625,43,14,40,3,0,0,-1,0,0,0
12,15,48,1053,598,10,8,0,3,0,0,-1,0,0,0
1,16,18,15,4,0,0,22,0,0,0,-1--1--1,,1|(1020,598)|
1,17,18,9,100,0,0,22,0,0,0,-1--1--1,,1|(959,598)|
11,18,48,989,598,8,10,34,3,0,0,1,0,0,0
10,19,Departure rate,989,622,58,14,40,3,0,0,-1,0,0,0
10,20,Average cost per Professor,1179,584,66,24,8,131,0,0,0,0,0,0
10,21,Professor Expense,1246,692,64,21,8,131,0,0,0,0,0,0
1,22,20,21,1,0,0,0,0,64,0,-1--1--1,,1|(1214,653)|
1,23,9,21,1,0,0,0,0,64,0,-1--1--1,,1|(1014,745)|
10,24,Faculty Expense Budget,1427,429,66,24,8,3,0,0,0,0,0,0
10,25,Faculty expense gap,1410,641,65,24,8,3,0,0,0,0,0,0
1,26,24,25,1,0,0,0,0,64,0,-1--1--1,,1|(1431,510)|
12,27,48,1111,188,10,8,0,3,0,0,-1,0,0,0
1,28,30,27,4,0,0,22,0,0,0,-1--1--1,,1|(1066,188)|
1,29,30,1,100,0,0,22,0,0,0,-1--1--1,,1|(992,188)|
11,30,48,1024,188,8,10,34,3,0,0,1,0,0,0
10,31,Exit,1024,212,43,14,40,3,0,0,-1,0,0,0
10,32,Graduation Rate,1146,261,76,13,8,131,0,0,0,0,0,0
1,33,32,30,1,0,0,0,0,64,0,-1--1--1,,1|(1079,211)|
1,34,1,31,1,0,0,0,0,64,0,-1--1--1,,1|(962,251)|
10,35,Adjunct Faculty,341,600,50,25,3,3,0,0,0,0,0,0
12,36,48,154,599,10,8,0,3,0,0,-1,0,0,0
1,37,39,35,4,0,0,22,0,0,0,-1--1--1,,1|(256,598)|
1,38,39,36,100,0,0,22,0,0,0,-1--1--1,,1|(184,598)|
11,39,48,213,598,8,10,34,3,0,0,1,0,0,0
10,40,Hiring of AF,213,621,54,13,40,131,0,0,-1,0,0,0
12,41,48,546,601,10,8,0,3,0,0,-1,0,0,0
1,42,44,41,4,0,0,22,0,0,0,-1--1--1,,1|(504,598)|
1,43,44,35,100,0,0,22,0,0,0,-1--1--1,,1|(423,598)|
11,44,48,464,598,8,10,34,3,0,0,1,0,0,0
10,45,Departure of AF,464,622,66,14,40,3,0,0,-1,0,0,0
10,46,Adjunct Faculty Expense,423,764,75,20,8,131,0,0,0,0,0,0
10,47,Average cost per AF,305,698,53,24,8,131,0,0,0,0,0,0
1,48,47,46,1,0,0,0,0,64,0,-1--1--1,,1|(359,746)|
1,49,35,46,1,0,0,0,0,64,0,-1--1--1,,1|(359,692)|
10,50,"AQ/PQ ratio required",555,498,53,24,8,3,0,0,0,0,0,0
1,51,7,5,1,0,0,0,0,64,0,-1--1--1,,1|(753,148)|
1,52,8,6,1,0,0,0,0,64,0,-1--1--1,,1|(778,273)|
10,53,"Dropout & transfer rate",1056,77,48,31,8,131,0,0,0,0,0,0
12,54,48,901,50,10,8,0,3,0,0,-1,0,0,0
1,55,57,54,4,0,0,22,0,0,0,-1--1--1,,1|(902,86)|
1,56,57,1,100,0,0,22,0,0,0,-1--1--1,,1|(902,148)|
11,57,48,902,123,10,8,33,3,0,0,4,0,0,0
10,58,Attrition,946,123,34,14,40,3,0,0,-1,0,0,0
1,59,53,58,1,0,0,0,0,64,0,-1--1--1,,1|(967,71)|
1,60,1,57,1,0,0,0,0,64,0,-1--1--1,,1|(863,132)|
10,61,Faculty,608,435,30,14,8,3,0,0,0,0,0,0
1,62,35,61,1,0,0,0,0,64,0,-1--1--1,,1|(402,479)|
1,63,9,61,1,0,0,0,0,64,0,-1--1--1,,1|(783,446)|
10,64,Faculty Expense,1193,825,65,14,8,3,0,0,0,0,0,0
1,65,64,25,1,0,0,0,0,64,0,-1--1--1,,1|(1314,767)|
1,66,21,64,1,0,0,0,0,64,0,-1--1--1,,1|(1228,753)|
1,67,46,64,1,0,0,0,0,64,0,-1--1--1,,1|(743,966)|
10,68,Professor atrittion rate,1064,674,48,31,8,131,0,0,0,0,0,0
1,69,68,19,1,0,0,0,0,64,0,-1--1--1,,1|(988,673)|
1,70,9,19,1,0,0,0,0,64,0,-1--1--1,,1|(923,645)|
1,71,1,24,1,0,0,0,0,64,0,-1--1--1,,1|(1192,192)|
10,72,Budget $ per FTES,1245,412,53,24,8,3,0,0,0,0,0,0
1,73,72,24,1,0,0,0,0,64,0,-1--1--1,,1|(1339,451)|
10,74,Recruiting delay,655,560,61,23,8,131,0,0,0,0,0,0
1,75,74,13,1,0,0,0,0,64,0,-1--1--1,,1|(741,557)|
10,76,Adjunct Faculty atrittion rate,508,694,66,22,8,3,0,0,0,0,0,0
1,77,76,45,1,0,0,0,0,64,0,-1--1--1,,1|(449,672)|
1,78,35,45,1,0,0,0,0,64,0,-1--1--1,,1|(398,646)|
1,79,25,40,1,0,0,0,0,64,0,-1--1--1,,1|(812,1080)|
1,80,47,40,1,0,0,0,0,64,0,-1--1--1,,1|(247,663)|
10,81,Years of hiring,193,530,36,22,8,3,0,0,0,0,0,0
1,82,81,39,1,0,0,0,0,64,0,-1--1--1,,1|(228,570)|
10,83,Years of hiring,832,707,42,22,8,2,0,3,-1,0,0,0,128-128-128,0-0-0,|12||128-128-128
1,84,83,14,1,0,0,0,0,64,0,-1--1--1,,1|(842,664)|
10,85,Professors required,724,492,45,22,8,3,0,0,0,0,0,0
1,86,61,85,1,0,0,0,0,64,0,-1--1--1,,1|(677,449)|
1,87,9,85,1,0,0,0,0,64,0,-1--1--1,,1|(838,533)|
1,88,50,85,1,0,0,0,0,64,0,-1--1--1,,1|(636,495)|
1,89,85,13,1,0,0,0,0,64,0,-1--1--1,,1|(798,550)|
///---\\\
:L<%^E!@
1:Reduce dropout rate.vdf
1:Increase graduation rate.vdf
1:Baseline.vdf
9:Reduce dropout rate
22:$,Dollar,Dollars,$s
22:Day,Days
22:Hour,Hours
22:Month,Months
22:Person,People,Persons
22:Unit,Units
22:Week,Weeks
22:Year,Years
23:0
15:0,0,0,0,0,0
19:100,0
27:2,
34:0,
4:Time
5:Faculty Expense
35:Date
36:YYYY-MM-DD
37:1996
38:1
39:1
40:0
41:0
24:0
25:20
26:20