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 NameCCG CodeExcess Cost (NIC)Excess Cost (Actual Cost)
NHS NORTHERN, EASTERN AND WESTERN DEVON CCG99P£726,919£672,909
NHS DORSET CCG11J£571,558£529,091
NHS CAMBRIDGESHIRE AND PETERBOROUGH CCG06H£565,923£523,875
NHS LIVERPOOL CCG99A£542,056£501,781
NHS NENE CCG04G£525,774£486,709
NHS BIRMINGHAM CROSSCITY CCG13P£521,667£482,907
NHS GLOUCESTERSHIRE CCG11M£496,503£459,613
NHS NEWCASTLE GATESHEAD CCG13T£443,562£410,606
NHS MANCHESTER CCG14L£438,948£406,334
NHS SANDWELL AND WEST BIRMINGHAM CCG05L£421,620£390,294
NHS KERNOW CCG11N£417,504£386,484
NHS SOMERSET CCG11X£414,200£383,425
NHS OXFORDSHIRE CCG10Q£404,420£374,372
NHS WEST HAMPSHIRE CCG11A£387,125£358,361
NHS COASTAL WEST SUSSEX CCG09G£381,452£353,111
NHS SHEFFIELD CCG03N£380,040£351,803
NHS EAST AND NORTH HERTFORDSHIRE CCG06K£374,911£347,055
NHS SOUTHERN DERBYSHIRE CCG04R£373,978£346,192
NHS HERTS VALLEYS CCG06N£370,525£342,995
NHS COVENTRY AND RUGBY CCG05A£369,919£342,434
NHS WILTSHIRE CCG99N£360,099£333,344
NHS WEST KENT CCG99J£358,680£332,030
NHS BEDFORDSHIRE CCG06F£325,355£301,181
NHS IPSWICH AND EAST SUFFOLK CCG06L£311,576£288,426
NHS NORTH EAST ESSEX CCG06T£297,708£275,589
NHS MID ESSEX CCG06Q£294,825£272,919
NHS WIGAN BOROUGH CCG02H£292,505£270,772
NHS EAST LANCASHIRE CCG01A£289,673£268,150
NHS BRISTOL CCG11H£289,568£268,053
NHS SOUTH TEES CCG00M£289,078£267,600
NHS SUNDERLAND CCG00P£284,615£263,468
NHS WAKEFIELD CCG03R£283,196£262,154
NHS DURHAM DALES, EASINGTON AND SEDGEFIELD CCG00D£281,319£260,417
NHS NORTHUMBERLAND CCG00L£272,062£251,848
NHS MORECAMBE BAY CCG01K£270,048£249,983
NHS WEST LEICESTERSHIRE CCG04V£269,756£249,713
NHS EALING CCG07W£261,489£242,061
NHS HULL CCG03F£252,680£233,906
NHS STOKE ON TRENT CCG05W£250,338£231,738
NHS EAST RIDING OF YORKSHIRE CCG02Y£249,137£230,626
NHS LEICESTER CITY CCG04C£245,750£227,490
NHS HARTLEPOOL AND STOCKTON-ON-TEES CCG00K£245,481£227,241
NHS BARNET CCG07M£245,021£226,816
NHS SOUTH WORCESTERSHIRE CCG05T£244,628£226,452
NHS LINCOLNSHIRE EAST CCG03T£243,814£225,699
NHS SHROPSHIRE CCG05N£242,452£224,438
NHS HASTINGS AND ROTHER CCG09P£242,205£224,210
NHS BRIGHTON AND HOVE CCG09D£241,785£223,821
NHS NORTH WEST SURREY CCG09Y£240,051£222,215
NHS BRADFORD DISTRICTS CCG02R£239,798£221,981
NHS NORTH CUMBRIA CCG01H£239,770£221,955
NHS DUDLEY CCG05C£238,360£220,650
NHS STOCKPORT CCG01W£235,354£217,867
NHS BIRMINGHAM SOUTH AND CENTRAL CCG04X£235,251£217,772
NHS DONCASTER CCG02X£233,931£216,550
NHS TAMESIDE AND GLOSSOP CCG01Y£233,256£215,925
NHS NOTTINGHAM CITY CCG04K£232,425£215,156
NHS WIRRAL CCG12F£231,390£214,197
NHS CROYDON CCG07V£225,651£208,885
NHS HEYWOOD, MIDDLETON AND ROCHDALE CCG01D£224,366£207,696
NHS SOUTH DEVON AND TORBAY CCG99Q£222,261£205,747
NHS LEEDS WEST CCG03C£222,230£205,718
NHS OLDHAM CCG00Y£218,697£202,448
NHS BROMLEY CCG07Q£217,763£201,583
NHS WALSALL CCG05Y£217,373£201,222
NHS NORTH DERBYSHIRE CCG04J£216,215£200,150
NHS BOLTON CCG00T£215,522£199,509
NHS MEDWAY CCG09W£212,703£196,899
NHS BASILDON AND BRENTWOOD CCG99E£212,566£196,772
NHS SOUTH WARWICKSHIRE CCG05R£212,030£196,276
NHS VALE OF YORK CCG03Q£211,766£196,032
NHS BRENT CCG07P£210,686£195,032
NHS GREAT YARMOUTH AND WAVENEY CCG06M£209,931£194,333
NHS EAST LEICESTERSHIRE AND RUTLAND CCG03W£209,054£193,521
NHS BARNSLEY CCG02P£207,588£192,164
NHS SALFORD CCG01G£201,965£186,959
NHS NORTH DURHAM CCG00J£198,251£183,521
NHS ST HELENS CCG01X£197,769£183,075
NHS SOUTH NORFOLK CCG06Y£197,543£182,865
NHS WEST CHESHIRE CCG02F£193,661£179,272
NHS SOUTH KENT COAST CCG10A£193,654£179,265
NHS LINCOLNSHIRE WEST CCG04D£193,056£178,712
NHS CHILTERN CCG10H£192,827£178,500
NHS GREATER PRESTON CCG01E£192,251£177,966
NHS NORTH TYNESIDE CCG99C£191,976£177,712
NHS EASTBOURNE, HAILSHAM AND SEAFORD CCG09F£191,806£177,555
NHS ENFIELD CCG07X£190,656£176,490
NHS SOUTH GLOUCESTERSHIRE CCG12A£190,530£176,373
NHS NORTH NORFOLK CCG06V£190,312£176,172
NHS SOUTHAMPTON CCG10X£189,483£175,405
NHS LEEDS SOUTH AND EAST CCG03G£189,310£175,244
NHS WEST SUFFOLK CCG07K£188,517£174,511
NHS KNOWSLEY CCG01J£188,398£174,400
NHS NEWHAM CCG08M£187,049£173,152
NHS WOLVERHAMPTON CCG06A£186,395£172,546
NHS LAMBETH CCG08K£186,292£172,451
NHS ROTHERHAM CCG03L£185,545£171,759
NHS SOUTH SEFTON CCG01T£185,368£171,595
NHS WEST ESSEX CCG07H£183,727£170,076
NHS CANTERBURY AND COASTAL CCG09E£180,689£167,263
NHS GREENWICH CCG08A£179,596£166,252
NHS SWINDON CCG12D£178,048£164,819
NHS BLACKPOOL CCG00R£176,592£163,471
NHS LEWISHAM CCG08L£176,278£163,180
NHS SOUTHEND CCG99G£175,688£162,634
NHS TOWER HAMLETS CCG08V£175,677£162,624
NHS WANDSWORTH CCG08X£175,115£162,104
NHS BURY CCG00V£174,962£161,962
NHS SOLIHULL CCG05P£174,630£161,655
NHS NORWICH CCG06W£173,334£160,455
NHS HILLINGDON CCG08G£171,688£158,931
NHS TRAFFORD CCG02A£170,333£157,677
NHS HOUNSLOW CCG07Y£168,966£156,412
NHS SOUTH EAST STAFFORDSHIRE AND SEISDON PENINSULA CCG05Q£168,106£155,615
NHS SURREY DOWNS CCG99H£167,957£155,478
NHS NORTH SOMERSET CCG11T£166,474£154,105
NHS WARWICKSHIRE NORTH CCG05H£166,129£153,785
NHS CASTLE POINT AND ROCHFORD CCG99F£165,614£153,309
NHS FAREHAM AND GOSPORT CCG10K£165,134£152,864
NHS HAVERING CCG08F£163,310£151,176
NHS NORTH STAFFORDSHIRE CCG05G£163,194£151,069
NHS GREATER HUDDERSFIELD CCG03A£163,084£150,966
NHS WALTHAM FOREST CCG08W£162,887£150,785
NHS HORSHAM AND MID SUSSEX CCG09X£162,599£150,518
NHS SOUTH EASTERN HAMPSHIRE CCG10V£162,570£150,491
NHS WARRINGTON CCG02E£162,122£150,077
NHS HARINGEY CCG08D£160,414£148,495
NHS SOUTHWARK CCG08Q£160,350£148,436
NHS MANSFIELD AND ASHFIELD CCG04E£159,722£147,855
NHS NORTH HAMPSHIRE CCG10J£158,813£147,013
NHS THANET CCG10E£158,789£146,991
NHS REDBRIDGE CCG08N£157,508£145,805
NHS CITY AND HACKNEY CCG07T£157,245£145,562
NHS DARTFORD, GRAVESHAM AND SWANLEY CCG09J£156,185£144,581
NHS HIGH WEALD LEWES HAVENS CCG99K£155,997£144,407
NHS NORTH EAST HAMPSHIRE AND FARNHAM CCG99M£155,149£143,622
NHS WEST NORFOLK CCG07J£153,121£141,744
NHS PORTSMOUTH CCG10R£152,682£141,337
NHS EASTERN CHESHIRE CCG01C£152,002£140,709
NHS CHORLEY AND SOUTH RIBBLE CCG00X£151,560£140,299
NHS MILTON KEYNES CCG04F£151,534£140,275
NHS GUILDFORD AND WAVERLEY CCG09N£151,422£140,171
NHS FYLDE AND WYRE CCG02M£150,507£139,325
NHS CALDERDALE CCG02T£150,071£138,921
NHS HARROW CCG08E£148,661£137,616
NHS BEXLEY CCG07N£147,555£136,592
NHS SOUTH CHESHIRE CCG01R£146,235£135,370
NHS NORTH KIRKLEES CCG03J£143,404£132,749
NHS TELFORD AND WREKIN CCG05X£142,484£131,898
NHS ISLINGTON CCG08H£138,660£128,357
NHS SOUTHPORT AND FORMBY CCG01V£137,790£127,552
NHS LUTON CCG06P£135,247£125,198
NHS NORTH EAST LINCOLNSHIRE CCG03H£134,146£124,179
NHS BATH AND NORTH EAST SOMERSET CCG11E£132,060£122,248
NHS ISLE OF WIGHT CCG10L£129,297£119,690
NHS LEEDS NORTH CCG02V£127,526£118,051
NHS HEREFORDSHIRE CCG05F£127,134£117,688
NHS WEST LONDON CCG08Y£126,731£117,315
NHS CAMDEN CCG07R£126,008£116,646
NHS SOUTH TYNESIDE CCG00N£125,475£116,152
NHS NORTH LINCOLNSHIRE CCG03K£123,664£114,475
NHS BLACKBURN WITH DARWEN CCG00Q£122,824£113,698
NHS AYLESBURY VALE CCG10Y£120,391£111,446
NHS REDDITCH AND BROMSGROVE CCG05J£119,876£110,970
NHS BARKING AND DAGENHAM CCG07L£119,583£110,698
NHS NOTTINGHAM NORTH AND EAST CCG04L£114,334£105,839
NHS THURROCK CCG07G£112,820£104,438
NHS SUTTON CCG08T£112,658£104,287
NHS SOUTH LINCOLNSHIRE CCG99D£112,559£104,196
NHS AIREDALE, WHARFEDALE AND CRAVEN CCG02N£112,397£104,045
NHS EAST SURREY CCG09L£112,126£103,795
NHS STAFFORD AND SURROUNDS CCG05V£111,895£103,581
NHS RICHMOND CCG08P£108,559£100,493
NHS HAMBLETON, RICHMONDSHIRE AND WHITBY CCG03D£107,830£99,818
NHS HARROGATE AND RURAL DISTRICT CCG03E£107,645£99,647
NHS HAMMERSMITH AND FULHAM CCG08C£106,696£98,768
NHS WINDSOR, ASCOT AND MAIDENHEAD CCG11C£106,480£98,569
NHS SLOUGH CCG10T£105,558£97,715
NHS KINGSTON CCG08J£104,819£97,031
NHS CENTRAL LONDON (WESTMINSTER) CCG09A£103,307£95,631
NHS HALTON CCG01F£101,744£94,185
NHS MERTON CCG08R£101,719£94,162
NHS CANNOCK CHASE CCG04Y£101,684£94,129
NHS ASHFORD CCG09C£99,495£92,103
NHS BRACKNELL AND ASCOT CCG10G£98,917£91,568
NHS WOKINGHAM CCG11D£98,271£90,969
NHS WEST LANCASHIRE CCG02G£98,130£90,839
NHS SOUTH WEST LINCOLNSHIRE CCG04Q£95,499£88,403
NHS NEWARK AND SHERWOOD CCG04H£95,071£88,007
NHS WYRE FOREST CCG06D£94,124£87,131
NHS EAST STAFFORDSHIRE CCG05D£92,640£85,757
NHS SWALE CCG10D£90,541£83,814
NHS HARDWICK CCG03Y£87,086£80,616
NHS SCARBOROUGH AND RYEDALE CCG03M£85,979£79,591
NHS DARLINGTON CCG00C£84,925£78,615
NHS BASSETLAW CCG02Q£83,905£77,671
NHS VALE ROYAL CCG02D£81,734£75,661
NHS EREWASH CCG03X£80,627£74,637
NHS SOUTH READING CCG10W£80,017£74,072
NHS NEWBURY AND DISTRICT CCG10M£79,355£73,459
NHS CRAWLEY CCG09H£77,099£71,370
NHS RUSHCLIFFE CCG04N£75,418£69,814
NHS NORTH AND WEST READING CCG10N£74,173£68,662
NHS BRADFORD CITY CCG02W£72,737£67,333
NHS SURREY HEATH CCG10C£72,240£66,873
NHS NOTTINGHAM WEST CCG04M£63,343£58,637
NHS CORBY CCG03V£62,247£57,622
CCGs in England£41,602,778£38,511,692