Xtandi prices, Medicare_Part_D_Spending

	A	B	D	E	F	G	H	I	J	K	L
1	Brnd_Name	Xtandi	Year	Medicare Part D Spending on Xtandi	% change	Medicare Unit price	Cost for 12 months treatment	% change	CPI-U in Septembr	% change	Change in price over CPI-U change
2	Gnrc_Name	Enzalutamide	2012	$34,898,756		$63.72	$93,031.20		231.407
3	Tot_Mftr	$1.00	2013	$231,503,731	563.4%	$64.85	$94,681.00	1.8%	234.149	1.2%	0.6%
4	Mftr_Name	Astellas Pharma	2014	$447,311,084	93.2%	$69.41	$101,338.60	7.0%	238.031	1.7%	5.4%
5	Tot_Spndng_2017	$854,223,631.81	2015	$790,655,731	76.8%	$73.94	$107,952.40	6.5%	237.945	0.0%	6.6%
6	Tot_Dsg_Unts_2017	$10,049,853.00	2016	$907,585,915	14.8%	$76.69	$111,967.40	3.7%	241.428	1.5%	2.3%
7	Tot_Clms_2017	$85,673.00	2017	$854,223,632	-5.9%	$85.00	$124,100.00	10.8%	246.819	2.2%	8.6%
8	Tot_Benes_2017	$15,809.00	2018	$1,182,582,187	38.4%	$91.48	$133,560.80	7.6%	252.439	2.3%	5.3%
9	Avg_Spnd_Per_Dsg_Unt_Wghtd_2017	$85.00	2019	$1,420,960,113	20.2%	$97.81	$142,802.60	6.9%	256.759	1.7%	5.2%
10	Avg_Spnd_Per_Clm_2017	$9,970.74	2020	$1,968,567,948	38.5%	$101.49	$148,175.40	3.8%	260.280	1.4%	2.4%
11	Avg_Spnd_Per_Bene_2017	$54,034.01	2021	$2,411,262,130	22.5%	$112.28	$163,928.80	10.6%	274.310	5.4%	5.2%
12	Outlier_Flag_2017	$0.00
13	Tot_Spndng_2018	$1,182,582,187.20
14	Tot_Dsg_Unts_2018	$12,926,596.00
15	Tot_Clms_2018	$111,109.00
16	Tot_Benes_2018	$20,192.00
17	Avg_Spnd_Per_Dsg_Unt_Wghtd_2018	$91.48
18	Avg_Spnd_Per_Clm_2018	$10,643.44
19	Avg_Spnd_Per_Bene_2018	$58,566.87
20	Outlier_Flag_2018	$0.00
21	Tot_Spndng_2019	$1,420,960,112.90
22	Tot_Dsg_Unts_2019	$14,527,556.00
23	Tot_Clms_2019	$125,338.00
24	Tot_Benes_2019	$21,644.00
25	Avg_Spnd_Per_Dsg_Unt_Wghtd_2019	$97.81
26	Avg_Spnd_Per_Clm_2019	$11,337.03
27	Avg_Spnd_Per_Bene_2019	$65,651.46
28	Outlier_Flag_2019	$0.00
29	Tot_Spndng_2020	$1,968,567,948.00
30	Tot_Dsg_Unts_2020	$19,396,808.00
31	Tot_Clms_2020	$167,667.00
32	Tot_Benes_2020	$26,490.00
33	Avg_Spnd_Per_Dsg_Unt_Wghtd_2020	$101.49
34	Avg_Spnd_Per_Clm_2020	$11,740.94
35	Avg_Spnd_Per_Bene_2020	$74,313.63
36	Outlier_Flag_2020	$0.00
37	Tot_Spndng_2021	$2,411,262,129.80
38	Tot_Dsg_Unts_2021	$22,076,171.00
39	Tot_Clms_2021	$198,288.00
40	Tot_Benes_2021	$30,007.00
41	Avg_Spnd_Per_Dsg_Unt_Wghtd_2021	$112.28
42	Avg_Spnd_Per_Clm_2021	$12,160.40
43	Avg_Spnd_Per_Bene_2021	$80,356.65
44	Outlier_Flag_2021	$0.00
45	Chg_Avg_Spnd_Per_Dsg_Unt_20_21	$0.11
46	CAGR_Avg_Spnd_Per_Dsg_Unt_17_21	$0.07
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