Skip to main content

Table 4 Real and predicted pharmaceutical expenditure and case mix adjusted by health district in 2013

From: Pharmaceutical cost management in an ambulatory setting using a risk adjustment tool

Health district

Case mix (1)

Real C (2)

Predicted C (3)

Population. N (4)

Average real C (5) = (2)/(4)

Average predicted C (6) = (3)/(4)

Differences (7) = (5)-(6)

1

35.29

22,404,536.70

24,714,441.39

87,448

256.20

282.62

-26.41

2

32.34

68,608,549.95

68,793,348.13

265,636

258.28

258.98

-0.70

3

35.94

47,720,043.15

51,816,313.29

180,051

265.04

287.79

-22.75

4

35.20

43,430,451.48

41,221,848.93

146,219

297.02

281.92

15.10

5

33.39

88,177,744.42

85,893,722.31

321,192

274.53

267.42

7.11

6

32.15

72,489,772.23

75,357,459.28

292,715

247.65

257.44

-9.80

7

36.18

49,825,584.93

52,580,973.57

181,468

274.57

289.75

-15.18

8

43.10

15,989,816.02

16,733,570.96

48,479

329.83

345.17

-15.34

9

34.48

99,701,853.24

93,549,589.70

338,770

294.31

276.14

18.16

10

34.22

97,918,781.79

93,218,916.90

340,151

287.87

274.05

13.82

11

34.43

66,559,137.30

68,259,770.67

247,529

268.89

275.76

-6.87

12

34.13

49,736,535.24

46,595,511.68

170,456

291.79

273.36

18.43

13

31.76

41,575,756.05

39,612,929.41

155,755

266.93

254.33

12.60

14

37.28

60,142,256.18

57,547,721.39

192,759

312.01

298.55

13.46

15

37.36

40,973,176.21

40,243,795.62

134,490

304.66

299.23

5.42

16

33.48

43,043,816.92

45,423,640.85

169,389

254.11

268.16

-14.05

17

33.97

52,476,085.67

54,889,413.61

201,780

260.07

272.03

-11.96

18

35.24

54,265,489.06

52,482,585.31

185,984

291.78

282.19

9.59

19

34.15

66,260,672.07

69,172,538.68

252,932

261.97

273.48

-11.51

20

34.54

39,467,859.22

42,750,213.31

154,533

255.40

276.64

-21.24

21

34.29

41,080,531.21

43,366,934.60

157,932

260.12

274.59

-14.48

22

35.09

44,150,450.69

44,686,006.13

159,031

277.62

280.99

-3.37

23

35.01

55,746,290.13

54,498,692.53

194,401

286.76

280.34

6.42

24

32.31

40,153,602.94

38,488,854.55

148,732

269.97

258.78

11.19

Total

34.38

1,301,898,792.80

1,301,898,792.80

4,727,832

275.37

275.37

0.00

  1. (1) District case mix (CM).
  2. (2) Annual real cost.
  3. (3) Predictive expenditure health district = real expenditure vc  CM health district   N health district /CM cv N vc .
  4. (4) Health district total population.