job market model.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1
2	Job Market Model
3	dropout rate per year:	0.2
4	new applicants per year:	500
5	jobs per year:	100
6
7		Year 1		Year 2		Year 3		Year 4		Year 5		Year 6		Year 7		Year 8		Year 9		Year 10		Year 11
8	class year	jobs given	remaining candidates from class	jobs given	remaining candidates from class	jobs given	remaining candidates from class	jobs given	remaining candidates from class	jobs given	remaining candidates from class	jobs given	remaining candidates from class	jobs given	remaining candidates from class	jobs given	remaining candidates from class	jobs given	remaining candidates from class	jobs given	remaining candidates from class	jobs given	remaining candidates from class
9		100		100		100		100		100		100		100		100		100		100		100
10	x (start)	100	320	39	225	21	163	13	120	8	90	6	67	4	50	3	38	2	29	2	22	1	17
11	x+1		500	61	351	33	255	20	188	13	140	9	105	6	79	4	60	3	45	2	34	2	26
12	x+2				500	46	363	28	268	19	199	13	149	9	112	6	85	5	64	3	49	3	37
13	x+3						500	39	369	26	275	17	206	12	155	9	117	6	88	5	67	3	51
14	x+4								500	35	372	24	279	17	210	12	158	9	120	6	91	5	69
15	x+5										500	32	375	22	282	16	213	12	161	9	122	6	92
16	x+6												500	30	376	21	284	16	215	11	163	8	123
17	x+7														500	28	377	21	285	15	216	11	164
18	x+8																500	27	378	20	286	15	217
19	x+9																		500	27	379	20	287
20	x+10																				500	26	379
21		100		100		100		100		100		100		100		100		100		100		100
22
23	total applicants:	500		820		1076		1281		1445		1576		1681		1764		1832		1885		1928
24	total jobs:	100		100		100		100		100		100		100		100		100		100		100
25	average individual placement rate:	20%		12%		9%		8%		7%		6%		6%		6%		5%		5%		5%
26	percentage of jobs to first two years on market:	100%		100%		79%		67%		60%		55%		52%		50%		48%		47%		46%
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100