| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Sources | A: Every student has identical cost profile. | Model_A1 | B: Students have modest variability of cost profiles. | Model_B1 | C: Students have extreme variability of cost profiles. | Model_C1 | ||||||||||
2 | DPI FAQ Choice Program | In each Model_#1, the private school is effectively compelled to accept the students who apply to their school without regards to the cost of educating them. | |||||||||||||||
3 | Student | Cost_toEducate | Funds_toTransfer | SchoolToAttend | Student | Cost_toEducate | Funds_toTransfer | School_ToAttend | Student | Cost_toEducate | Funds_toTransfer | School_ToAttend | |||||
23 | |||||||||||||||||
24 | This model is for illustrative purposes. While the voucher funds per student is a real value (check reference), I have made up the Cost_toEducate values in an effort to understand how variability at the student level results in surplus discrepancies. I've used a population of 19 students, and for each lettered model, I have varied the cost_toEducate while maintaining the average. I assume that, for models B & C, that a student who costs more than the funding, that a private school would reject the student, and a public school would therefore be required to educate the student. I would like to understand how variable each student cost actually is in reality, but I wasn't able to drum up decent data on that in a short time frame. | Average | $10,877 | $10,877 | Average | $10,877 | $10,877 | Average | $10,877 | $10,877 | |||||||
25 | Median | $10,877 | $10,877 | Median | $10,877 | $10,877 | Median | $2,583 | $10,877 | ||||||||
26 | Max | $10,877 | $10,877 | Max | $12,877 | $10,877 | Max | $72,332 | $10,877 | ||||||||
27 | Min | $10,877 | $10,877 | Min | $8,877 | $10,877 | Min | $2,583 | $10,877 | ||||||||
28 | |||||||||||||||||
29 | School | Costs | Funds | Surplus | School | Costs | Funds | Surplus | School | Costs | Funds | Surplus | |||||
30 | Public School | $108,770 | $108,770 | $0 | Public School | $108,770 | $108,770 | $0 | Public School | $134,331 | $108,770 | -$25,561 | |||||
31 | Private School | $97,893 | $97,893 | $0 | Private School | $97,893 | $97,893 | $0 | Private School | $72,332 | $97,893 | $25,561 | |||||
32 | |||||||||||||||||
33 | A: Every student has identical cost profile. | Model_A2 | B: Students have modest variability of cost profiles. | Model_B2 | C: Students have extreme variability of cost profiles. | Model_C2 | |||||||||||
34 | In each Model_#2, the private school chooses the students that are most likely to provide a surplus (i.e profit margin) from the funding that comes with the student. | ||||||||||||||||
35 | Student | Cost_toEducate | Funds_toTransfer | SchoolToAttend | Student | Cost_toEducate | Funds_toTransfer | School_ToAttend | Student | Cost_toEducate | Funds_toTransfer | School_ToAttend | |||||
55 | |||||||||||||||||
56 | Average | $10,877 | $10,877 | Average | $10,877 | $10,877 | Average | $10,877 | $10,877 | ||||||||
57 | Median | $10,877 | $10,877 | Median | $10,877 | $10,877 | Median | $2,583 | $10,877 | ||||||||
58 | Max | $10,877 | $10,877 | Max | $12,877 | $10,877 | Max | $72,332 | $10,877 | ||||||||
59 | Min | $10,877 | $10,877 | Min | $8,877 | $10,877 | Min | $2,583 | $10,877 | ||||||||
60 | |||||||||||||||||
61 | School | Costs | Funds | Surplus | School | Costs | Funds | Surplus | School | Costs | Funds | Surplus | |||||
62 | Public School | $108,770 | $108,770 | $0 | Public School | $169,155 | $163,155 | -$6,000 | Public School | $185,997 | $119,647 | -$66,350 | |||||
63 | Private School | $97,893 | $97,893 | $0 | Private School | $37,508 | $43,508 | $6,000 | Private School | $20,666 | $87,016 | $66,350 | |||||