The PSNC has published the list today of Price Concessions for November 2017. The list is the biggest yet, at 91 lines.

We’ve taken a first stab at calculating the estimated effect for CCGs, using September 2017 prescribing data. The Google Sheet can be found here. (edit) - the Google Sheet now also contains national calculations per presentation and all CCG presentation data.

A couple of calculation changes:

  1. The PSNC spreadsheet had a typo, listing the Zolmitriptan 2.5mg tablets as “$.69”. Therefore until this is corrected we’ve used the October 2017 price concession which is £18.00 for 6 tablets. (edit) - this has now been corrected, and the data below refreshed.
  2. We added in an estimated “Actual Cost” calculation - which is close to what CCGs actually pay, rather than the Net Ingredient Cost. This estimate is used by taking the National average discount percentage from here for October 2017 (7.43%)

The total for England (actual cost) for November is £38.5m. We’ll do some further calculations when we get the chance. It’s less of an impact than we were expecting - possibly as some of the “big excess” items have been removed. We’ll take another look tomorrow!(edit) - we’ve taken a quick look - and here are some of the reasons why the total cost of price concessions is lower.

CCG Name CCG Code Excess Cost (NIC) Excess Cost (Actual Cost)
NHS NORTHERN, EASTERN AND WESTERN DEVON CCG 99P £726,919 £672,909
NHS DORSET CCG 11J £571,558 £529,091
NHS CAMBRIDGESHIRE AND PETERBOROUGH CCG 06H £565,923 £523,875
NHS LIVERPOOL CCG 99A £542,056 £501,781
NHS NENE CCG 04G £525,774 £486,709
NHS BIRMINGHAM CROSSCITY CCG 13P £521,667 £482,907
NHS GLOUCESTERSHIRE CCG 11M £496,503 £459,613
NHS NEWCASTLE GATESHEAD CCG 13T £443,562 £410,606
NHS MANCHESTER CCG 14L £438,948 £406,334
NHS SANDWELL AND WEST BIRMINGHAM CCG 05L £421,620 £390,294
NHS KERNOW CCG 11N £417,504 £386,484
NHS SOMERSET CCG 11X £414,200 £383,425
NHS OXFORDSHIRE CCG 10Q £404,420 £374,372
NHS WEST HAMPSHIRE CCG 11A £387,125 £358,361
NHS COASTAL WEST SUSSEX CCG 09G £381,452 £353,111
NHS SHEFFIELD CCG 03N £380,040 £351,803
NHS EAST AND NORTH HERTFORDSHIRE CCG 06K £374,911 £347,055
NHS SOUTHERN DERBYSHIRE CCG 04R £373,978 £346,192
NHS HERTS VALLEYS CCG 06N £370,525 £342,995
NHS COVENTRY AND RUGBY CCG 05A £369,919 £342,434
NHS WILTSHIRE CCG 99N £360,099 £333,344
NHS WEST KENT CCG 99J £358,680 £332,030
NHS BEDFORDSHIRE CCG 06F £325,355 £301,181
NHS IPSWICH AND EAST SUFFOLK CCG 06L £311,576 £288,426
NHS NORTH EAST ESSEX CCG 06T £297,708 £275,589
NHS MID ESSEX CCG 06Q £294,825 £272,919
NHS WIGAN BOROUGH CCG 02H £292,505 £270,772
NHS EAST LANCASHIRE CCG 01A £289,673 £268,150
NHS BRISTOL CCG 11H £289,568 £268,053
NHS SOUTH TEES CCG 00M £289,078 £267,600
NHS SUNDERLAND CCG 00P £284,615 £263,468
NHS WAKEFIELD CCG 03R £283,196 £262,154
NHS DURHAM DALES, EASINGTON AND SEDGEFIELD CCG 00D £281,319 £260,417
NHS NORTHUMBERLAND CCG 00L £272,062 £251,848
NHS MORECAMBE BAY CCG 01K £270,048 £249,983
NHS WEST LEICESTERSHIRE CCG 04V £269,756 £249,713
NHS EALING CCG 07W £261,489 £242,061
NHS HULL CCG 03F £252,680 £233,906
NHS STOKE ON TRENT CCG 05W £250,338 £231,738
NHS EAST RIDING OF YORKSHIRE CCG 02Y £249,137 £230,626
NHS LEICESTER CITY CCG 04C £245,750 £227,490
NHS HARTLEPOOL AND STOCKTON-ON-TEES CCG 00K £245,481 £227,241
NHS BARNET CCG 07M £245,021 £226,816
NHS SOUTH WORCESTERSHIRE CCG 05T £244,628 £226,452
NHS LINCOLNSHIRE EAST CCG 03T £243,814 £225,699
NHS SHROPSHIRE CCG 05N £242,452 £224,438
NHS HASTINGS AND ROTHER CCG 09P £242,205 £224,210
NHS BRIGHTON AND HOVE CCG 09D £241,785 £223,821
NHS NORTH WEST SURREY CCG 09Y £240,051 £222,215
NHS BRADFORD DISTRICTS CCG 02R £239,798 £221,981
NHS NORTH CUMBRIA CCG 01H £239,770 £221,955
NHS DUDLEY CCG 05C £238,360 £220,650
NHS STOCKPORT CCG 01W £235,354 £217,867
NHS BIRMINGHAM SOUTH AND CENTRAL CCG 04X £235,251 £217,772
NHS DONCASTER CCG 02X £233,931 £216,550
NHS TAMESIDE AND GLOSSOP CCG 01Y £233,256 £215,925
NHS NOTTINGHAM CITY CCG 04K £232,425 £215,156
NHS WIRRAL CCG 12F £231,390 £214,197
NHS CROYDON CCG 07V £225,651 £208,885
NHS HEYWOOD, MIDDLETON AND ROCHDALE CCG 01D £224,366 £207,696
NHS SOUTH DEVON AND TORBAY CCG 99Q £222,261 £205,747
NHS LEEDS WEST CCG 03C £222,230 £205,718
NHS OLDHAM CCG 00Y £218,697 £202,448
NHS BROMLEY CCG 07Q £217,763 £201,583
NHS WALSALL CCG 05Y £217,373 £201,222
NHS NORTH DERBYSHIRE CCG 04J £216,215 £200,150
NHS BOLTON CCG 00T £215,522 £199,509
NHS MEDWAY CCG 09W £212,703 £196,899
NHS BASILDON AND BRENTWOOD CCG 99E £212,566 £196,772
NHS SOUTH WARWICKSHIRE CCG 05R £212,030 £196,276
NHS VALE OF YORK CCG 03Q £211,766 £196,032
NHS BRENT CCG 07P £210,686 £195,032
NHS GREAT YARMOUTH AND WAVENEY CCG 06M £209,931 £194,333
NHS EAST LEICESTERSHIRE AND RUTLAND CCG 03W £209,054 £193,521
NHS BARNSLEY CCG 02P £207,588 £192,164
NHS SALFORD CCG 01G £201,965 £186,959
NHS NORTH DURHAM CCG 00J £198,251 £183,521
NHS ST HELENS CCG 01X £197,769 £183,075
NHS SOUTH NORFOLK CCG 06Y £197,543 £182,865
NHS WEST CHESHIRE CCG 02F £193,661 £179,272
NHS SOUTH KENT COAST CCG 10A £193,654 £179,265
NHS LINCOLNSHIRE WEST CCG 04D £193,056 £178,712
NHS CHILTERN CCG 10H £192,827 £178,500
NHS GREATER PRESTON CCG 01E £192,251 £177,966
NHS NORTH TYNESIDE CCG 99C £191,976 £177,712
NHS EASTBOURNE, HAILSHAM AND SEAFORD CCG 09F £191,806 £177,555
NHS ENFIELD CCG 07X £190,656 £176,490
NHS SOUTH GLOUCESTERSHIRE CCG 12A £190,530 £176,373
NHS NORTH NORFOLK CCG 06V £190,312 £176,172
NHS SOUTHAMPTON CCG 10X £189,483 £175,405
NHS LEEDS SOUTH AND EAST CCG 03G £189,310 £175,244
NHS WEST SUFFOLK CCG 07K £188,517 £174,511
NHS KNOWSLEY CCG 01J £188,398 £174,400
NHS NEWHAM CCG 08M £187,049 £173,152
NHS WOLVERHAMPTON CCG 06A £186,395 £172,546
NHS LAMBETH CCG 08K £186,292 £172,451
NHS ROTHERHAM CCG 03L £185,545 £171,759
NHS SOUTH SEFTON CCG 01T £185,368 £171,595
NHS WEST ESSEX CCG 07H £183,727 £170,076
NHS CANTERBURY AND COASTAL CCG 09E £180,689 £167,263
NHS GREENWICH CCG 08A £179,596 £166,252
NHS SWINDON CCG 12D £178,048 £164,819
NHS BLACKPOOL CCG 00R £176,592 £163,471
NHS LEWISHAM CCG 08L £176,278 £163,180
NHS SOUTHEND CCG 99G £175,688 £162,634
NHS TOWER HAMLETS CCG 08V £175,677 £162,624
NHS WANDSWORTH CCG 08X £175,115 £162,104
NHS BURY CCG 00V £174,962 £161,962
NHS SOLIHULL CCG 05P £174,630 £161,655
NHS NORWICH CCG 06W £173,334 £160,455
NHS HILLINGDON CCG 08G £171,688 £158,931
NHS TRAFFORD CCG 02A £170,333 £157,677
NHS HOUNSLOW CCG 07Y £168,966 £156,412
NHS SOUTH EAST STAFFORDSHIRE AND SEISDON PENINSULA CCG 05Q £168,106 £155,615
NHS SURREY DOWNS CCG 99H £167,957 £155,478
NHS NORTH SOMERSET CCG 11T £166,474 £154,105
NHS WARWICKSHIRE NORTH CCG 05H £166,129 £153,785
NHS CASTLE POINT AND ROCHFORD CCG 99F £165,614 £153,309
NHS FAREHAM AND GOSPORT CCG 10K £165,134 £152,864
NHS HAVERING CCG 08F £163,310 £151,176
NHS NORTH STAFFORDSHIRE CCG 05G £163,194 £151,069
NHS GREATER HUDDERSFIELD CCG 03A £163,084 £150,966
NHS WALTHAM FOREST CCG 08W £162,887 £150,785
NHS HORSHAM AND MID SUSSEX CCG 09X £162,599 £150,518
NHS SOUTH EASTERN HAMPSHIRE CCG 10V £162,570 £150,491
NHS WARRINGTON CCG 02E £162,122 £150,077
NHS HARINGEY CCG 08D £160,414 £148,495
NHS SOUTHWARK CCG 08Q £160,350 £148,436
NHS MANSFIELD AND ASHFIELD CCG 04E £159,722 £147,855
NHS NORTH HAMPSHIRE CCG 10J £158,813 £147,013
NHS THANET CCG 10E £158,789 £146,991
NHS REDBRIDGE CCG 08N £157,508 £145,805
NHS CITY AND HACKNEY CCG 07T £157,245 £145,562
NHS DARTFORD, GRAVESHAM AND SWANLEY CCG 09J £156,185 £144,581
NHS HIGH WEALD LEWES HAVENS CCG 99K £155,997 £144,407
NHS NORTH EAST HAMPSHIRE AND FARNHAM CCG 99M £155,149 £143,622
NHS WEST NORFOLK CCG 07J £153,121 £141,744
NHS PORTSMOUTH CCG 10R £152,682 £141,337
NHS EASTERN CHESHIRE CCG 01C £152,002 £140,709
NHS CHORLEY AND SOUTH RIBBLE CCG 00X £151,560 £140,299
NHS MILTON KEYNES CCG 04F £151,534 £140,275
NHS GUILDFORD AND WAVERLEY CCG 09N £151,422 £140,171
NHS FYLDE AND WYRE CCG 02M £150,507 £139,325
NHS CALDERDALE CCG 02T £150,071 £138,921
NHS HARROW CCG 08E £148,661 £137,616
NHS BEXLEY CCG 07N £147,555 £136,592
NHS SOUTH CHESHIRE CCG 01R £146,235 £135,370
NHS NORTH KIRKLEES CCG 03J £143,404 £132,749
NHS TELFORD AND WREKIN CCG 05X £142,484 £131,898
NHS ISLINGTON CCG 08H £138,660 £128,357
NHS SOUTHPORT AND FORMBY CCG 01V £137,790 £127,552
NHS LUTON CCG 06P £135,247 £125,198
NHS NORTH EAST LINCOLNSHIRE CCG 03H £134,146 £124,179
NHS BATH AND NORTH EAST SOMERSET CCG 11E £132,060 £122,248
NHS ISLE OF WIGHT CCG 10L £129,297 £119,690
NHS LEEDS NORTH CCG 02V £127,526 £118,051
NHS HEREFORDSHIRE CCG 05F £127,134 £117,688
NHS WEST LONDON CCG 08Y £126,731 £117,315
NHS CAMDEN CCG 07R £126,008 £116,646
NHS SOUTH TYNESIDE CCG 00N £125,475 £116,152
NHS NORTH LINCOLNSHIRE CCG 03K £123,664 £114,475
NHS BLACKBURN WITH DARWEN CCG 00Q £122,824 £113,698
NHS AYLESBURY VALE CCG 10Y £120,391 £111,446
NHS REDDITCH AND BROMSGROVE CCG 05J £119,876 £110,970
NHS BARKING AND DAGENHAM CCG 07L £119,583 £110,698
NHS NOTTINGHAM NORTH AND EAST CCG 04L £114,334 £105,839
NHS THURROCK CCG 07G £112,820 £104,438
NHS SUTTON CCG 08T £112,658 £104,287
NHS SOUTH LINCOLNSHIRE CCG 99D £112,559 £104,196
NHS AIREDALE, WHARFEDALE AND CRAVEN CCG 02N £112,397 £104,045
NHS EAST SURREY CCG 09L £112,126 £103,795
NHS STAFFORD AND SURROUNDS CCG 05V £111,895 £103,581
NHS RICHMOND CCG 08P £108,559 £100,493
NHS HAMBLETON, RICHMONDSHIRE AND WHITBY CCG 03D £107,830 £99,818
NHS HARROGATE AND RURAL DISTRICT CCG 03E £107,645 £99,647
NHS HAMMERSMITH AND FULHAM CCG 08C £106,696 £98,768
NHS WINDSOR, ASCOT AND MAIDENHEAD CCG 11C £106,480 £98,569
NHS SLOUGH CCG 10T £105,558 £97,715
NHS KINGSTON CCG 08J £104,819 £97,031
NHS CENTRAL LONDON (WESTMINSTER) CCG 09A £103,307 £95,631
NHS HALTON CCG 01F £101,744 £94,185
NHS MERTON CCG 08R £101,719 £94,162
NHS CANNOCK CHASE CCG 04Y £101,684 £94,129
NHS ASHFORD CCG 09C £99,495 £92,103
NHS BRACKNELL AND ASCOT CCG 10G £98,917 £91,568
NHS WOKINGHAM CCG 11D £98,271 £90,969
NHS WEST LANCASHIRE CCG 02G £98,130 £90,839
NHS SOUTH WEST LINCOLNSHIRE CCG 04Q £95,499 £88,403
NHS NEWARK AND SHERWOOD CCG 04H £95,071 £88,007
NHS WYRE FOREST CCG 06D £94,124 £87,131
NHS EAST STAFFORDSHIRE CCG 05D £92,640 £85,757
NHS SWALE CCG 10D £90,541 £83,814
NHS HARDWICK CCG 03Y £87,086 £80,616
NHS SCARBOROUGH AND RYEDALE CCG 03M £85,979 £79,591
NHS DARLINGTON CCG 00C £84,925 £78,615
NHS BASSETLAW CCG 02Q £83,905 £77,671
NHS VALE ROYAL CCG 02D £81,734 £75,661
NHS EREWASH CCG 03X £80,627 £74,637
NHS SOUTH READING CCG 10W £80,017 £74,072
NHS NEWBURY AND DISTRICT CCG 10M £79,355 £73,459
NHS CRAWLEY CCG 09H £77,099 £71,370
NHS RUSHCLIFFE CCG 04N £75,418 £69,814
NHS NORTH AND WEST READING CCG 10N £74,173 £68,662
NHS BRADFORD CITY CCG 02W £72,737 £67,333
NHS SURREY HEATH CCG 10C £72,240 £66,873
NHS NOTTINGHAM WEST CCG 04M £63,343 £58,637
NHS CORBY CCG 03V £62,247 £57,622
CCGs in England £41,602,778 £38,511,692