AFT-OR Per-Caps Reform.xlsx

	A	B	C	D	E	F	M	N	O
1		Name	Per Cap	Upper Limit	Lower Limit		Per Cap	Upper Limit	Lower Limit
2		Model 0 (Current Model)					81		$96,000.00
3			35		$36,000.00		35.5	$95,999.99	$37,000.00
4		1/2	17.5	35999.99	$14,000.00		17.5	$36,999.99	$17,000.00
5		1/4	8.75	13999.99	$8,500.00		8.75	$16,999.99	$10,000.00
6		1/8	4.38	8499.99	$0.00		4.38	$9,999.99	$0.00
7
8	Local	Base Model	Rebate (pre-2018)	Rebate (2018)	Typical Month (pre-2018)	Typical Month (Sept 2018)	Model Red	After Rebate	Difference
9	AFT-Oregon				$174,570.21	$174,162.94		170871.53
10	111	15995.07		1	$15,995.07	$15,995.07	15696.32	15696.32	-$298.75
11	2278	7227.5		1	$7,227.50	$7,227.50	7294.5	7294.5	$67.00
12	2277	$41,200.14		1	$41,200.14	$41,200.14	40652.23	40652.23	-$547.91
13	2417	9179.21		1	$9,179.21	$9,179.21	9253.34	9253.34	$74.13
14	3209	34658.85	0.6	0.5	$20,795.31	$17,329.43	41568.63	20784.315	-$10.99
15	3544	16209.67		1	$16,209.67	$16,209.67	13033.67	13033.67	-$3,176.00
16	3571	4126.33		1	$4,126.33	$4,126.33	3453.67	3453.67	-$672.66
17	3922	15767.5		1	$15,767.50	$15,767.50	15799.75	15799.75	$32.25
18	3972	1793.75		1	$1,793.75	$1,793.75	1649.75	1649.75	-$144.00
19	4671	15526.97		1	$15,526.97	$15,526.97	14894.9	14894.9	-$632.07
20	4912	4497.5		1	$4,497.50	$4,497.50	4519	4519	$21.50
21	6069	19241.26		1	$19,241.26	$19,241.26	18068.78	18068.78	-$1,172.48
22	6200	3010		1	$3,010.00	$3,010.00	3143.5	3143.5	$133.50
23	6666	6117.23		0.5	$0.00	$3,058.62	5255.61	2627.805	$2,627.81
24	To AFT:
25	Percent difference:					99.77%		97.88%
26	Per month difference:								-$3,698.68
27									-$29,589.44
28									-$11,317.96
29	Approx total annual difference:								-$40,907.40
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