Price Concessions Estimate for November 2017 - CCG data
- Posted:
- Written by:
- Categories:
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:
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.- 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 |