DCLG logo

Settlement
Table 3: Annotated Chapter 4 of the LGFR for Telford and the Wrekin (R662/E3201)

Children's Services = 0.00041390454398

Youth and Community = 0.00003142671970

Basic amount

YOUTH AND COMMUNITY BASIC AMOUNT =    13.7300

Top-ups

YOUTH AND COMMUNITY DEPRIVATION TOP-UP =   47.1891
 multiplied by CHILDREN OF OUT OF WORK CHILD TAX CREDIT CLAIMANTS ABOVE THRESHOLD (    0.1327)

YOUTH AND COMMUNITY ETHNICITY TOP-UP =	   11.6454
 multiplied by SECONDARY LOW ACHIEVING ETHNIC GROUPS ABOVE THRESHOLD
(    0.0509)

The full formula used to calculate the Youth and Community element is:

Youth and Community

(a)   PROJECTED POPULATION AGED 13 TO 19 IN 2011 (    15,267)
      multiplied by the result of:
         YOUTH AND COMMUNITY BASIC AMOUNT (13.7300000000000); plus
         YOUTH AND COMMUNITY DEPRIVATION TOP-UP (6.26199357000000); plus
         YOUTH AND COMMUNITY ETHNICITY TOP-UP (0.59275086000000)

(b)   The result of (a) is multiplied by AREA COST ADJUSTMENT FOR EDUCATION 
      (1.00000000000000)

(c)   The result of (b) is then multiplied by the scaling factor given in Annex F 
      for the Youth and Community Services sub block (0.99999969373668)

(d)   The result of (c) is then divided by 10,000,000,000.

Local Authority Central Education Functions = 0.00011692904071

Basic amounts

PUPILS BASIC AMOUNT =    16.5642

RESIDENT PUPILS BASIC AMOUNT =    16.3833

Top-ups

PUPILS DEPRIVATION TOP-UP =	   26.1452
 multiplied by CHILDREN OF OUT OF WORK CHILD TAX CREDIT CLAIMANTS ABOVE THRESHOLD (    0.1327)

SPARSITY TOP-UP =	   21.7794
 multiplied by WARD SPARSITY (    0.1315)

RESIDENT PUPILS DEPRIVATION TOP-UP =	   26.1452
 multiplied by     0.6600 multiplied by 
CHILDREN OF OUT OF WORK CHILD TAX CREDIT CLAIMANTS ABOVE THRESHOLD 
(    0.1327)

Fixed cost amount

CEF FIXED COST AMOUNT =	59,880.934

The full formula used to calculate the Local Authority Central Education Functions element is:

Local Authority Central Education Functions

(a)   PUPILS AGED 3 TO 18 (25,663.000) multiplied by the result of:
         PUPILS BASIC AMOUNT (16.5642000000000); plus
         PUPILS DEPRIVATION TOP-UP (3.46946804000000)

(b)	RESIDENT PUPILS AGED 3 TO 18 (27,640.000) multiplied by the result of:
         RESIDENT PUPILS BASIC AMOUNT (16.3833000000000); plus
         SPARSITY TOP-UP (2.86399110000000); plus
         RESIDENT PUPILS DEPRIVATION TOP-UP (2.28984890640000)

(c)	The result of (a) plus (b) is multiplied by AREA COST ADJUSTMENT FOR EDUCATION
      (1.00000000000000);

(d)	The result of (c) is then added to the CEF FIXED COST AMOUNT (59,880.933500000);

(e)	The result of (d) is then multiplied by the scaling factor given in Annex F 
      for the Local Authority Central Education Functions sub block 
      (0.99999906000692).

(f)	The result of (e) is then divided by 10,000,000,000

Children's Social Care = 0.00026554878358

Basic amount

CHILDREN'S SOCIAL CARE BASIC AMOUNT	= 25.4863000000000

Top-up

CHILDREN'S SOCIAL CARE DEPRIVATION TOP-UP	=  205.1062
 multiplied by CHILDREN WITHOUT GOOD HEALTH (    0.0961); plus  119.4286
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE 
CLAIMANTS AGED 18 TO 64 YEARS (    0.0967); plus  143.4962
 multiplied by CHILDREN OF OUT OF WORK CHILD TAX CREDIT CLAIMANTS (    0.2406); plus   78.7225
 multiplied by CHILDREN IN BLACK ETHNIC GROUPS (    0.0035); minus
   26.1180

The full formula used to calculate the Children's Social Care element is:

Children's Social Care

(a)   PROJECTED POPULATION AGED 0-17 IN 2011 (    37,448) 
      multiplied by the result of:
         CHILDREN'S SOCIAL CARE BASIC AMOUNT (25.4863000000000); plus
         CHILDREN'S SOCIAL CARE DEPRIVATION TOP-UP (39.9421659100000); 

(b)	The result of (a) is multiplied by FOSTER COST ADJUSTMENT 
      (1.08380000000000);

(c)	The result of (b) is multiplied by AREA COST ADJUSTMENT FOR CHILDREN AND 
      YOUNGER ADULTS PSS (1.00000000000000);

(d)	The result of (c) is then multiplied by the scaling factor given in 
      Annex F for the Children's Social Care sub block (0.99999954862086).

(e)	The result of (d) is then divided by 10,000,000,000.

Adults' Personal Social Services = 0.00070560544337

Social Services for Older People = 0.00040953666306

Basic amount

OLDER PEOPLE PSS BASIC AMOUNT = 80.4698000000000

Top-ups

OLDER PEOPLE PSS AGE TOP-UP =	
HOUSEHOLD AND SUPPORTED RESIDENTS AGED 90 YEARS AND OVER (  768.0000)
divided by HOUSEHOLD AND SUPPORTED RESIDENTS AGED 65 AND OVER (23,186.000), 
rounded to 4 decimal places and multiplied by   961.5896; 
minus    22.1166

OLDER PEOPLE PSS DEPRIVATION TOP-UP =	  277.7389
 multiplied by OLDER PEOPLE 
RECEIVING ATTENDANCE ALLOWANCE (    0.1871)
; plus 53.7107000000000 multiplied by OLDER PEOPLE 
IN RENTED ACCOMMODATION (    0.3212)
; plus 71.9399000000000 multiplied by OLDER PEOPLE 
LIVING IN ONE PERSON HOUSEHOLDS (    0.3348)
; plus 216.011700000000 multiplied by OLDER PEOPLE 
RECEIVING PENSION CREDIT GUARANTEE/INCOME BASED JOBSEEKER'S ALLOWANCE
(    0.2499); minus
74.9958000000000

The full formula used to calculate the Social Services for Older People element is:

Social Services for Older People

(a)   PROJECTED HOUSEHOLD AND SUPPORTED RESIDENTS AGED 65 YEARS AND OVER 
      (24,564.000) multiplied by the result of:
          OLDER PEOPLE PSS BASIC AMOUNT (80.4698000000000); plus
          OLDER PEOPLE PSS AGE TOP-UP (9.71201576000000); plus
          OLDER PEOPLE PSS DEPRIVATION TOP-UP (72.2878273800000); 

(b)   The result of (a) is multiplied by LOW INCOME ADJUSTMENT  (1.02280000000000);

(c)   The result of (b) is multiplied by SPARSITY ADJUSTMENT FOR PEOPLE AGED 65 AND OVER
      (1.00330000000000);

(d)   The result of (c) is multiplied by AREA COST ADJUSTMENT FOR OLDER PEOPLE'S PSS
      (1.00000000000000);

(e)   The result of (d) is then multiplied by the scaling factor given in Annex F for 
      the Social Services for Older People sub block  (0.99999986283034).

(f)   The result of (e) is then divided by 10,000,000,000.

Social Services for Younger Adults = (0.00029606878031)

Basic amount

YOUNGER ADULTS PSS BASIC AMOUNT	=  (10.2827000000000)

Top-up

YOUNGER ADULTS PSS DEPRIVATION TOP-UP =	
(285.624500000000) multiplied by PEOPLE AGED 18 TO 64 RECEIVING 
DISABILITY LIVING ALLOWANCE  (0.06300000000000); plus
(77.2787000000000) multiplied by PEOPLE AGED 18 TO 64 WHO ARE LONG 
TERM UNEMPLOYED OR HAVE NEVER WORKED (0.03550000000000); plus
(26.1409000000000) multiplied by PEOPLE AGED 18 TO 64 WHO WORK 
IN ROUTINE OR SEMI ROUTINE OCCUPATIONS (0.29800000000000); plus
(21.8445000000000) multiplied by HOUSEHOLDS WITH NO FAMILY
(0.27870000000000); minus
(15.5583000000000)

The full formula used to calculate the Social Services for Younger Adults element is:

Social Services for Younger Adults

(a)   PROJECTED POPULATION AGED 18-64 IN 2011  (100,909.00000000) 
      multiplied by the result of:
         YOUNGER ADULTS PSS BASIC AMOUNT (10.2827000000000); plus
         YOUNGER ADULTS PSS DEPRIVATION TOP-UP (19.0574877000000); 

(b)   The result of (a) is multiplied by AREA COST ADJUSTMENT FOR CHILDREN AND YOUNGER 
      ADULTS PSS (1.00000000000000);

(c)   The result of (b) is then multiplied by the scaling factor given in Annex F 
      for the Social Services for Younger Adults sub block (0.99999959553045).

(d)   The result of (c) is then divided by 10,000,000,000.

Highway Maintenance = 0.00010915116608

Basic Amount

Highway Basic Amount =    95.1477

Top-ups

Usage Top-Up =    9.1653

 multiplied by TRAFFIC FLOW (35.8129970000000); plus    0.6813
 multiplied by DAYTIME POPULATION PER 
KM (164.279257620925

Winter Maintenance Top-Up =    0.3983
 multiplied by DAYS WITH SNOW LYING (15.4000000000000); plus    0.8962
 multiplied by PREDICTED GRITTING DAYS (68.4000000000000)

The full formula used to calculate the Highway Maintenance element is:

Highway Maintenance

(a)   WEIGHTED ROAD LENGTHS (1,810.9000000000) multiplied by the result of:
         HIGHWAY BASIC AMOUNT (95.1477000000000); plus
         USAGE TOP-UP (440.160319621236); plus
         WINTER MAINTENANCE TOP-UP (67.4339000000000);

(b)   The result of (a) is multiplied by AREA COST ADJUSTMENT FOR HIGHWAY MAINTENANCE
      (1.00000000000000);

(c)   The result of (b) is then multiplied by the scaling factor given in Annex F for 
      the Highway Maintenance service block (1.00000578881732).

(d)	The result of (c) is then divided by 10,000,000,000.

Environmental, Protective and Cultural Services = 0.00052355394569

DISTRICT-LEVEL EPCS = 0.00028625189401

Basic Amount

District Services EPCS Basic Amount =     9.7952

Top-Ups

District Services EPCS Density Top-Up =    0.7781
 multiplied by POPULATION DENSITY (3.79464000000000)

District Services EPCS Sparsity Top-Up =    4.6965
 multiplied by POPULATION SPARSITY (0.11760000000000)

District Services EPCS Additional Population Top-Up =    4.0255
 multiplied by NET IN-COMMUTERS (5,600.0000000000); plus    3.3546
 multiplied by DAY VISITORS (5,400.0000000000)

District Services EPCS Deprivation Top-Up =    17.4440
 multiplied by INCAPACITY BENEFIT AND SEVERE DISABLEMENT
    ALLOWANCE  (7,831.0000000000); plus   21.4708
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE
    CLAIMANTS (14,588.000000000); plus   17.4440
 multiplied by ELDERLY ON INCOME SUPPORT/INCOME BASED JOBSEEKER'S
    ALLOWANCE  (5,929.0000000000); plus   21.4708
 multiplied by UNEMPLOYMENT RELATED BENEFIT CLAIMANTS (3,416.0000000000); plus    4.0255
 multiplied by COUNTRY OF BIRTH OF RESIDENTS (5,080.4582000000)

The full formula used to calculate the RNF element for these services is:

Services provided predominantly by non-metropolitan district councils in non-metropolitan areas

(a)   PROJECTED POPULATION IN 2011 (163,518.00000000) multiplied by the result of:
         DISTRICT SERVICES EPCS BASIC AMOUNT (9.79520000000000); plus
         DISTRICT SERVICES EPCS DENSITY TOP-UP (2.95260938400000); plus
         DISTRICT SERVICES EPCS SPARSITY TOP-UP (0.55230840000000); 

(b)	DISTRICT SERVICES EPCS ADDITIONAL POPULATION TOP-UP (40,657.640000000); plus
      DISTRICT SERVICES EPCS DEPRIVATION TOP-UP (647,041.10768410)

(c)	The result of (a) and (b) are added together and the result is then multiplied by 
      AREA COST ADJUSTMENT FOR ENVIRONMENTAL, PROTECTIVE AND CULTURAL SERVICES (1.00000000000000);

(d)	The result of (c) is then multiplied by the scaling factor given in Annex F for 
      these services (1.00000402886240);

(e)	The result of (d) is then divided by 10,000,000,000.

COUNTY LEVEL EPCS = 0.00019700408731

Basic Amount

County Services EPCS Basic Amount =     7.6097

Top-Ups

County Services EPCS Density Top-Up =     0.1854
 multiplied by POPULATION DENSITY (3.79464000000000)

County Services EPCS Additional Population Top-Up =    4.8584
 multiplied by NET IN-COMMUTERS (5,600.0000000000); plus    8.0957
 multiplied by DAY VISITORS (5,400.0000000000)

County Services EPCS Deprivation Top-Up =    29.1439
 multiplied by UNEMPLOYMENT RELATED BENEFIT CLAIMANTS (3,416.0000000000); plus   22.6675
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE
    CLAIMANTS (14,588.000000000); plus   11.3330
 multiplied by INCAPACITY BENEFIT AND SEVERE DISABLEMENT
    ALLOWANCE (7,831.0000000000); plus    4.0947
 multiplied by COUNTRY OF BIRTH OF RESIDENTS (5,080.4582000000)
The full formula used to calculate the RNF element for these services is:

Services provided predominantly by county councils in non-metropolitan areas

(a)   PROJECTED POPULATION IN 2011 (163,518.00000000) multiplied by the result of:
         COUNTY SERVICES EPCS BASIC AMOUNT (7.60970000000000); plus
         COUNTY SERVICES EPCS DENSITY TOP-UP (0.70352625600000);
 
(b)	COUNTY SERVICES EPCS ADDITIONAL POPULATION TOP-UP (70,923.820000000); plus
      COUNTY SERVICES EPCS DEPRIVATION TOP-UP (539,780.72759154)

(c)	The result of (a) and (b) is added together and the result is then multiplied by 
      AREA COST ADJUSTMENT FOR ENVIRONMENTAL, PROTECTIVE AND CULTURAL SERVICES
      (1.00000000000000);

(d)	For London boroughs and the Common Council of the City of London, the result of 
      (c) is then multiplied by (               0)

(e)	The result of (d) is then multiplied by the scaling factor given in Annex F for 
      these services  (0.99998690123099);

(f)	The result of (e) is then divided by 10,000,000,000.

Fixed Costs = 0.00000416000456

The Fixed Costs element for a particular authority is calculated as follows:

Fixed Costs

(a)	325,000.00000000 is multiplied by the scaling factor 
      given in Annex F for Fixed Costs (0.12800014028810).

(b)	The result of (a) is then divided by 10,000,000,000.

Flood Defence = 0.00000037177989

The Flood Defence element for a particular authority is calculated as follows:

Flood Defence

(a) 	   13.0549 multiplied by LENGTH OF ORDINARY WATERCOURSE NOT COVERED BY IDB (284.757761410343); plus
(    0.1362) multiplied by IDB LEVY (0.00000000000000)

(b)	The result of (a) is multiplied by the scaling factor given in Annex F 
      for Flood Defence (1.00008468046915).

(c)	The result of (b) is divided by 10,000,000,000.

Continuing Environment Agency Levies = 0.00000025318426

The Continuing Environment Agency Levies element for a particular authority is calculated as follows:

Continuing Environment Agency Levies

(a)   ENVIRONMENT AGENCY (ENGLAND) LEVY (52,212.000000000) is multiplied by the scaling 
      factor given in Annex F for Continuing Environment Agency Levy (0.04849158364605).

(b)	The result of (a) is then divided by 10,000,000,000.

Coast Protection = 0.00000000000000

The Coast Protection element for a particular authority is calculated as follows:

Coast Protection

(a)   COAST PROTECTION EXPENDITURE (0.00000000000000) is multiplied by the 
      scaling factor given in Annex F for Coast Protection (0.11949328013216)

(b)	The result of (a) is then divided by 10,000,000,000.

Concessionary Fares = 0.00003551299566

Basic Amount

Concessionary Fares Basic Amount =     1.1056

Top-Ups

Concessionary Fares Deprivation Top-Up =    4.1149
 multiplied by PEOPLE AGED OVER 60YRS WITH NO ACCESS TO CAR OR VAN (0.30750000000000); plus   -2.0027
 multiplied by SPARSITY ADJUSTMENT FOR PEOPLE AGED 60 AND OVER (0.40670000000000); plus   12.7408
 multiplied by INCAPACITY BENEFIT AND SEVERE DISABLEMENT ALLOWANCE (0.04830000000000)

The full formula used to calculate the RNF element for these services is:

(a)   PROJECTED POPULATION IN 2011 (163,518.00000000) multiplied by the result of:
         CONCESSIONARY FARES BASIC AMOUNT (1.10560000000000); plus
         CONCESSIONARY FARES DEPRIVATION TOP-UP (1.06621430000000)

(b)	The result of (a) is then multiplied by AREA COST ADJUSTMENT FOR ENVIRONMENTAL, 
	PROTECTIVE AND CULTURAL SERVICES (1.00000000000000);

(c)	The result of (b) is then multiplied by the scaling factor given in Annex F for 
      these services (0.99999782031470);

(d)	The result of (c) is then divided by 10,000,000,000.

Capital Financing = 0.00016190410763

The RNF element for Capital Financing for a particular authority is calculated as follows:

Capital Financing

(a)   DEBT I (115,481,932.3354); plus
      SUPPORTED CAPITAL EXPENDITURE (REVENUE) (               0) multiplied 
      by 0.5; minus
      DEBT I (115,481,932.3354) multiplied by 0.02;

(b)   The result of (a) is then multiplied by INTEREST RATE (0.05100000000000);

(c)   The result of (b) is then added to DEBT I multiplied by 0.04;

(d)   The result of (c) is then multiplied by the scaling factor given in Annex F 
      for Debt charges (0.15581090001706).

(e)   The result of (d) is then divided by 10,000,000,000.

Return to: 2011/12 Local Authority Tables Index

Updated January 2011
Return to Local Government Finance Index
Return to DCLG Local Government Index
Return to Department for Communities and Local Government Home Page
Terms and conditions