Q3-2018-Generic-Spending-Continental_US_data (1)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Generic Spending in Medicaid by State Q3-2018
NADC+10% = more conservative savings estimate
2
StateUtilization TypeMarkup per UnitMetricNADAC ingredient costNADAC per unit WAPmt per UnitLatitude (generated)Longitude (generated)Number of PrescriptionsTotal Amount Reimbursed (pre-rebate)Total Amount Reimbursed-(post rebate)Units ReimbursedTotal Amount NADACSavings: Reimbursed (pre-rebate)- NADAC% savings (pre-rebate)Savings Reimbursed (post-rebate) - NADAC% savings (post-rebate)Savings at NADC + 10%% savings NADC 10%
3
WY
Fee for service
$0.17 $0.47 $861,991 $0.30 $0.47 43-107.565307$1,369,241$1,281,9412909987.661$872,996$496,24536%$408,94532%$321,64525%1.468438552
4
WV
Managed care
$0.05 $0.27 $36 $0.23 $0.27 38.63-80.73247$44$40159.188$37$716%$39%-$0.21-0.51%1.094376679
5
WV
Fee for service
$0.20 $0.35 $10,174,229 $0.15 $0.35 38.63-80.731646990$24,081,722$23,057,05468311184.22$10,246,678$13,835,04457%$12,810,37756%$11,785,70951%2.250198074
6
WI
Managed care
($0.01)$0.04 $37,275 $0.05 $0.04 44.5-9015242$26,723$22,956753499$37,675-$10,952-41%-$14,719-64%-$18,487-81%0.6093142791
7
WI
Fee for service
$0.20 $0.37 $18,074,423 $0.17 $0.37 44.5-901915669$39,687,830$37,872,676106773725.5$18,151,533$21,536,29654%$19,721,14352%$17,905,99047%2.086472558
8
WA
Managed care
$0.06 $0.29 $26,146,670 $0.23 $0.29 47.5-120.52530877$32,329,039$29,752,411112027307.8$25,766,281$6,562,75820%$3,986,13013%$1,409,5025%1.154703363
9
WA
Fee for service
$0.09 $0.23 $1,354,678 $0.14 $0.23 47.5-120.5214654$2,239,905$2,103,1159770697.066$1,367,898$872,00739%$735,21735%$598,42728%1.537479704
10
VT
Fee for service
$0.14 $0.35 $2,962,380 $0.21 $0.35 44.1584-72.7678231956$4,850,564$4,559,35913866895.43$2,912,048$1,938,51640%$1,647,31136%$1,356,10630%1.56568805
11
VA
Managed care
$0.22 $0.48 $17,037,088 $0.26 $0.48 37.77-78.241584778$31,435,033$29,720,45265945424.82$17,145,810$14,289,22245%$12,574,64142%$10,860,06037%1.733394389
12
VA
Fee for service
$0.22 $0.40 $1,446,647 $0.18 $0.40 37.77-78.24183213$3,164,919$3,023,8057839628.537$1,411,133$1,753,78655%$1,612,67253%$1,471,55949%2.142820757
13
UT
Managed care
$0.15 $0.33 $1,294,918 $0.18 $0.33 39.25-111.75173935$2,332,603$2,204,1837134465.512$1,284,204$1,048,40045%$919,97942%$791,55936%1.716381087
14
UT
Fee for service
$0.19 $0.42 $2,713,925 $0.24 $0.42 39.25-111.75216266$4,891,048$4,614,48511523472.97$2,765,634$2,125,41543%$1,848,85140%$1,572,28834%1.66850917
15
TX
Managed care
$0.24 $0.51 $46,526,532 $0.27 $0.51 31.25-99.254004582$87,819,750$83,185,663171632856$46,340,871$41,478,87947%$36,844,79244%$32,210,70439%1.79508198
16
TX
Fee for service
$0.20 $0.39 $544,789 $0.19 $0.39 31.25-99.2572011$1,118,027$1,063,6252863267.306$544,021$574,00651%$519,60449%$465,20244%1.95511814
17
TN
Managed care
$0.39 $0.74 $57 $0.36 $0.74 35.75-86.25119$119$113160$58$6252%$5649%$5044%1.968229167
18
TN
Fee for service
$0.15 $0.36 $17,888,821 $0.21 $0.36 35.75-86.252020188$30,736,496$28,949,59685090460.44$17,868,997$12,867,49942%$11,080,60038%$9,293,70032%1.620101954
19
SD
Fee for service
$0.24 $0.64 $1,895,502 $0.40 $0.64 44.5-100.25118274$3,052,255$2,862,8634734798.625$1,893,919$1,158,33638%$968,94434%$779,55227%1.511607775
20
SC
Managed care
$0.11 $0.52 $12,637,486 $0.40 $0.52 34-81764143$16,173,506$14,922,78931267916.75$12,507,167$3,666,33923%$2,415,62216%$1,164,9068%1.193139066
21
SC
Fee for service
$0.05 $0.33 $1,979,121 $0.29 $0.33 34-81161350$2,301,117$2,100,2516926404.094$2,008,657$292,46013%$91,5944%-$109,272-5%1.04559964
22
RI
Managed care
$0.14 $0.34 $5,386,390 $0.20 $0.34 41.4966-71.4757636742$9,303,727$8,752,69727551533.76$5,510,307$3,793,42141%$3,242,39037%$2,691,35931%1.588422766
23
RI
Fee for service
$0.07 $0.19 $83,197 $0.12 $0.19 41.4966-71.475714647$131,057$122,652700407.5$84,049$47,00836%$38,60331%$30,19825%1.459295601
24
PA
Managed care
$0.16 $0.40 $64,965,854 $0.25 $0.40 40.86-77.95956625$106,548,077$99,941,524264262139.6$66,065,535$40,482,54338%$33,875,98934%$27,269,43627%1.512763411
25
PA
Fee for service
$0.14 $0.25 $1,149,633 $0.11 $0.25 40.86-77.9251784$2,638,407$2,524,07810393539.15$1,143,289$1,495,11757%$1,380,78855%$1,266,45950%2.20773306
26
OR
Managed care
$0.12 $0.31 $11,708,512 $0.20 $0.31 44-120.51299318$18,872,276$17,672,09260009192.12$12,001,838$6,870,43836%$5,670,25432%$4,470,07025%1.472448764
27
OR
Fee for service
$0.17 $0.44 $5,593,739 $0.27 $0.44 44-120.5483015$9,180,086$8,615,16220923139.08$5,649,248$3,530,83938%$2,965,91434%$2,400,98928%1.525010447
28
OK
Fee for service
$0.19 $0.43 $9,671,932 $0.24 $0.43 35.5-97.5831286$17,356,452$16,398,73039905088.91$9,577,221$7,779,23145%$6,821,50942%$5,863,78736%1.712263888
29
OH
Managed care
$0.05 $0.31 $74,691,173 $0.26 $0.31 40.25-837217354$89,311,889$81,725,379291788836.7$75,865,098$13,446,79115%$5,860,2827%-$1,726,228-2%1.077246084
30
OH
Fee for service
$0.18 $0.38 $5,516,032 $0.20 $0.38 40.25-83638242$10,480,089$9,927,77827615523.47$5,523,105$4,956,98447%$4,404,67444%$3,852,36339%1.797499561
31
NY
Fee for service
$0.17 $0.34 $12,800,811 $0.17 $0.34 43-75.491602152$26,140,906$24,839,34576562429.83$13,015,613$13,125,29350%$11,823,73248%$10,522,17042%1.908426801
32
NV
Managed care
$0.22 $0.37 $4,748,951 $0.15 $0.37 39.25-116.75775137$11,648,505$11,173,53231664847.79$4,749,727$6,898,77859%$6,423,80557%$5,948,83253%2.352457726
33
NV
Fee for service
$0.16 $0.33 $2,849,848 $0.16 $0.33 39.25-116.75317723$5,708,656$5,428,74717494307.95$2,799,089$2,909,56751%$2,629,65848%$2,349,74943%1.93946909
34
NM
Managed care
$0.24 $0.43 $8,709,804 $0.19 $0.43 34.5-106983485$19,493,580$18,630,33945433715.82$8,632,406$10,861,17456%$9,997,93354%$9,134,69249%2.158186152
35
NM
Fee for service
$0.29 $0.46 $97,392 $0.16 $0.46 34.5-10615702$270,521$261,049592003$94,720$175,80165%$166,32964%$156,85760%2.75599524
36
NJ
Managed care
$0.10 $0.33 $29,383,656 $0.23 $0.33 40.16-74.493079907$42,014,931$39,092,806127048895.6$29,221,246$12,793,68530%$9,871,56025%$6,949,43618%1.337821337
37
NJ
Fee for service
$0.21 $0.39 $331,673 $0.18 $0.39 40.16-74.4949722$731,744$698,2451861043.27$334,988$396,75654%$363,25852%$329,75947%2.08439058
38
NH
Managed care
$0.22 $0.54 $2,672,208 $0.32 $0.54 43.66-71.49182902$4,563,378$4,293,1198445599.296$2,702,592$1,860,78641%$1,590,52737%$1,320,26831%1.588519162
39
NH
Fee for service
$0.20 $0.33 $40,036 $0.13 $0.33 43.66-71.497346$100,418$96,498301500$39,195$61,22361%$57,30359%$53,38455%2.462007654
40
NE
Managed care
$0.20 $0.37 $3,396,061 $0.17 $0.37 41.5-99.75465583$7,395,549$7,058,94419800257.66$3,366,044$4,029,50554%$3,692,90152%$3,356,29648%2.097104151
41
NE
Fee for service
$0.13 $0.20 $1,438 $0.07 $0.20 41.5-99.75460$4,316$4,16421614$1,513$2,80365%$2,65164%$2,50060%2.752436913
42
ND
Managed care
$0.33 $0.45 $308,884 $0.12 $0.45 47.5-10062405$1,129,806$1,099,5312522905.5$302,749$827,05773%$796,78272%$766,50770%3.631827252
43
ND
Fee for service
$0.27 $0.56 $911,032 $0.29 $0.56 47.5-10081715$1,742,859$1,652,4953116027.322$903,648$839,21148%$748,84745%$658,48240%1.828692995
44
NC
Fee for service
$0.21 $0.45 $27,164,740 $0.25 $0.45 35.5-802347387$49,716,359$46,970,290109842768$27,460,692$22,255,66745%$19,509,59842%$16,763,52936%1.710455435
45
MT
Fee for service
$0.26 $0.42 $3,042,438 $0.16 $0.42 47-109.75444289$8,001,286$7,696,14219071500.61$3,051,440$4,949,84662%$4,644,70260%$4,339,55856%2.52213439
46
MS
Managed care
$0.23 $0.48 $6,198,032 $0.25 $0.48 33.503-89.8071639960$12,134,075$11,501,88025287795.5$6,321,949$5,812,12648%$5,179,93145%$4,547,73740%1.819356752
47
MS
Fee for service
$0.22 $0.44 $1,365,421 $0.22 $0.44 33.503-89.8071156722$2,766,036$2,627,2776307220.75$1,387,589$1,378,44750%$1,239,68847%$1,100,93042%1.893412089
48
MO
Fee for service
$0.56 $0.85 $23,640,980 $0.28 $0.85 38.25-92.51927938$70,746,957$68,410,73883436396.93$23,362,191$47,384,76667%$45,048,54766%$42,712,32862%2.928267203
49
MN
Managed care
$0.15 $0.38 $17,378,198 $0.23 $0.38 46.25-94.251729456$29,163,350$27,394,54676904528.72$17,688,042$11,475,30939%$9,706,50535%$7,937,70129%1.548760845
50
MN
Fee for service
$0.23 $0.46 $3,657,019 $0.24 $0.46 46.25-94.25301939$7,191,233$6,819,79615476530.47$3,714,367$3,476,86648%$3,105,42946%$2,733,99240%1.836058643
51
MI
Managed care
$0.11 $0.25 $19,534,239 $0.14 $0.25 43.1045-84.61653605758$35,035,560$33,046,636142065984.3$19,889,238$15,146,32243%$13,157,39840%$11,168,47434%1.661533544
52
MI
Fee for service
$0.17 $0.48 $27,757,837 $0.31 $0.48 43.1045-84.61651780771$43,130,711$40,347,68889774932.72$27,830,229$15,300,48235%$12,517,45931%$9,734,43624%1.449779237
53
ME
Fee for service
$0.11 $0.28 $3,342,276 $0.17 $0.28 45.5-69.24285335$5,654,986$5,312,52520144725.05$3,424,603$2,230,38239%$1,887,92236%$1,545,46229%1.551281989
54
MD
Managed care
$0.07 $0.24 $10,038,931 $0.17 $0.24 39.4444-77.08341565423$14,207,256$13,219,95458076597.74$9,873,022$4,334,23431%$3,346,93225%$2,359,63018%1.338997764
55
MD
Fee for service
$0.21 $0.50 $11,001,454 $0.29 $0.50 39.4444-77.0834803486$18,904,433$17,810,51037721512.67$10,939,239$7,965,19542%$6,871,27139%$5,777,34732%1.628130626
56
MA
Managed care
$0.12 $0.32 $13,258,314 $0.21 $0.32 42.3616-72.18391515538$20,701,729$19,347,56064484250$13,541,693$7,160,03635%$5,805,86730%$4,451,69823%1.428740131
57
MA
Fee for service
$0.18 $0.35 $9,839,094 $0.18 $0.35 42.3616-72.18391269009$19,652,265$18,654,45655433829.49$9,978,089$9,674,17549%$8,676,36647%$7,678,55741%1.86954186
58
LA
Managed care
$0.14 $0.37 $29,884,289 $0.24 $0.37 30.6935-92.2413328815$47,589,301$44,542,133126965339.8$30,471,682$17,117,62036%$14,070,45232%$11,023,28325%1.461755009
59
LA
Fee for service
$0.22 $0.44 $1,408,627 $0.22 $0.44 30.6935-92.241133757$2,784,110$2,646,0466275611.55$1,380,635$1,403,47550%$1,265,41248%$1,127,34843%1.916543587
60
KY
Managed care
$0.11 $0.32 $41,081,891 $0.21 $0.32 37.79-84.874231745$63,530,205$59,391,647197074171.5$41,385,576$22,144,62935%$18,006,07130%$13,867,51423%1.435080839
61
KY
Fee for service
$0.20 $0.35 $1,360,662 $0.15 $0.35 37.79-84.87199953$3,159,703$3,025,9138919352.337$1,337,903$1,821,80058%$1,688,01056%$1,554,22051%2.261683629
62
KS
Managed care
$0.26 $0.56 $7,550,123 $0.30 $0.56 38.5-98.5529071$13,895,797$13,152,50024776581.61$7,432,974$6,462,82247%$5,719,52543%$4,976,22838%1.769479979
63
KS
Fee for service
$0.25 $0.34 $5,582 $0.09 $0.34 38.5-98.51425$20,533$19,99559832$5,385$15,14874%$14,61073%$14,07170%3.71314904
64
IN
Managed care
$0.32 $0.59 $29,442,911 $0.27 $0.59 40-86.252419200$64,871,980$61,879,401110836261.2$29,925,791$34,946,18954%$31,953,61052%$28,961,03147%2.067761602
65
IN
Fee for service
$0.18 $0.43 $4,335,793 $0.24 $0.43 40-86.25398109$7,641,308$7,211,23317919788.39$4,300,749$3,340,55944%$2,910,48440%$2,480,40934%1.676738784
66
IL
Managed care
$0.09 $0.27 $31,519,857 $0.18 $0.27 40-89.253995347$48,044,715$44,886,779175440892.7$31,579,361$16,465,35434%$13,307,41830%$10,149,48223%1.421396057
67
IL
Fee for service
$0.09 $0.29 $3,661,951 $0.21 $0.29 40-89.25397379$5,213,147$4,840,01217768336.88$3,731,351$1,481,79628%$1,108,66123%$735,52615%1.297120535
68
ID
Fee for service
$0.23 $0.52 $4,218,805 $0.28 $0.52 44.0739-114.542350005$7,679,523$7,264,22614832029.49$4,152,968$3,526,55546%$3,111,25843%$2,695,96137%1.749164868
69
IA
Managed care
($0.02)$0.17 $3,876,793 $0.20 $0.17 42-93.5465936$3,423,907$3,028,32619779044.34$3,955,809-$531,902-16%-$927,483-31%-$1,323,064-44%0.765538934
70
IA
Fee for service
$0.12 $0.29 $206,695 $0.16 $0.29 42-93.530932$361,891$341,7471258974.782$201,436$160,45544%$140,31241%$120,16835%1.696556488
71
GA
Managed care
$0.10 $0.56 $18,628,151 $0.45 $0.56 32.1598-83.47151189821$22,780,132$20,936,99540958583.66$18,431,363$4,348,76919%$2,505,63312%$662,4963%1.135943974
72
GA
Fee for service
$0.20 $0.38 $9,889,140 $0.17 $0.38 32.1598-83.47151291221$21,562,440$20,589,11557254413.8$9,733,250$11,829,19055%$10,855,86553%$9,882,54048%2.115338092
73
FL
Managed care
$0.09 $0.29 $32,717,385 $0.20 $0.29 28.42-81.553984596$47,687,954$44,380,758165359816.6$33,071,963$14,615,99131%$11,308,79525%$8,001,59818%1.341945071
74
FL
Fee for service
$0.21 $0.49 $4,150,134 $0.28 $0.49 28.42-81.55321520$7,249,256$6,832,90614869642.85$4,163,500$3,085,75643%$2,669,40639%$2,253,05633%1.641144706
75
DE
Fee for service
$0.25 $0.42 $35,117 $0.17 $0.42 38.6716-75.41655344$86,490$82,988205973$35,015$51,47460%$47,97358%$44,47154%2.370043332
76
DC
Managed care
$0.15 $0.30 $1,080,030 $0.16 $0.30 38.91-77182426$2,110,148$1,999,0186945587$1,111,294$998,85447%$887,72444%$776,59539%1.79882044
77
DC
Fee for service
$0.26 $0.43 $1,071,210 $0.18 $0.43 38.91-77150142$2,636,186$2,526,4416096902.943$1,097,443$1,538,74358%$1,428,99957%$1,319,25552%2.302117239
78
CT
Fee for service
$0.22 $0.42 $14,174,535 $0.20 $0.42 41.6227-72.70281451557$29,912,488$28,476,98471775201.81$14,355,040$15,557,44852%$14,121,94450%$12,686,44045%1.983762055
79
CO
Managed care
$0.19 $0.35 $516,203 $0.15 $0.35 39-105.579291$1,174,972$1,124,2443381832.45$507,275$667,69757%$616,96955%$566,24250%2.216242643
80
CO
Fee for service
$0.15 $0.35 $12,846,777 $0.20 $0.35 39-105.51164070$22,725,615$21,417,91465385047.24$13,077,009$9,648,60642%$8,340,90539%$7,033,20433%1.637829698
81
CA
Managed care
$0.12 $0.28 $83,160,451 $0.15 $0.28 37.25-119.7511716575$150,895,263$142,692,070546879535.6$82,031,930$68,863,33346%$60,660,14043%$52,456,94737%1.739469857
82
CA
Fee for service
$0.23 $0.44 $42,256,546 $0.21 $0.44 37.25-119.754185313$87,733,926$83,576,778197959419$41,571,478$46,162,44853%$42,005,30050%$37,848,15245%2.010435575
83
AZ
Managed care
$0.23 $0.42 $22,035,260 $0.19 $0.42 34.5-111.52745332$47,891,224$45,730,252113735366.4$21,609,720$26,281,50455%$24,120,53253%$21,959,56048%2.116189038
84
AZ
Fee for service
$0.14 $0.28 $97,671 $0.14 $0.28 34.5-111.515080$192,401$182,816684597$95,844$96,55750%$86,97348%$77,38842%1.907444943
85
AR
Fee for service
$0.21 $0.39 $5,859,806 $0.18 $0.39 34.75-92.5738457$12,539,221$11,961,54332093266.44$5,776,788$6,762,43354%$6,184,75552%$5,607,07647%2.0706217
86
AL
Fee for service
$0.20 $0.40 $9,644,538 $0.20 $0.40 32.75-86.75983565$18,925,566$17,978,92447332100.1$9,466,420$9,459,14650%$8,512,50447%$7,565,86242%1.899231626
87
$1,753,702,807$1,653,185,990$1,005,168,168$748,534,63943%$648,017,82239%$535,412,13832%1.644685977
88
89
Estimate for 1 year
$2,592,071,289
90
91
Delwaware MCO removed- data appears corrupt
92
DE
Managed care
($0.17)$0.03 $2,932,848 $0.20 $0.03 38.6716-75.4165368262$370,46114744769.94$2,948,954-$2,578,493-696%
93
94
95
96
97
98
99
100
Loading...