DCLG logo

2010/11 Settlement
Table 3: Annotated Chapter 4 of the LGFR for Warwickshire (R440/E3720)

Children's Services = 0.00112444759360

Youth and Community = 0.00007955883959

Basic amount

YOUTH AND COMMUNITY BASIC AMOUNT =    16.1181

Top-ups

YOUTH AND COMMUNITY DEPRIVATION TOP-UP =   59.9073
 multiplied by CHILDREN OF INCOME SUPPORT/INCOME BASED 
JOBSEEKER'S ALLOWANCE CLAIMANTS ABOVE THRESHOLD (    0.0168)

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

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

Youth and Community

(a)   PROJECTED POPULATION AGED 13 TO 19 IN 2010 (    44,876)
      multiplied by the result of:
         YOUTH AND COMMUNITY BASIC AMOUNT (16.1181000000000); plus
         YOUTH AND COMMUNITY DEPRIVATION TOP-UP (1.00644264000000); plus
         YOUTH AND COMMUNITY ETHNICITY TOP-UP (0.24454080000000)

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

(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.99999835235125)

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

Local Authority Central Education Functions = 0.00045338299682

Basic amounts

PUPILS BASIC AMOUNT =    21.1232

RESIDENT PUPILS BASIC AMOUNT =    20.8670

Top-ups

PUPILS DEPRIVATION TOP-UP =	   35.3876
 multiplied by CHILDREN OF INCOME SUPPORT 
/INCOME BASED JOBSEEKER'S ALLOWANCE CLAIMANTS  ABOVE THRESHOLD (    0.0168)

SPARSITY TOP-UP =	   27.6633
 multiplied by WARD SPARSITY (    0.4284)

RESIDENT PUPILS DEPRIVATION TOP-UP =	   35.3876
 multiplied by     0.6600 multiplied by 
CHILDREN OF INCOME SUPPORT /INCOME BASED JOBSEEKER'S ALLOWANCE CLAIMANTS ABOVE THRESHOLD 
(    0.0168)

Fixed cost amount

CEF FIXED COST AMOUNT =	73542.7448

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 (78150.0000) multiplied by the result of:
         PUPILS BASIC AMOUNT (21.1232000000000); plus
         PUPILS DEPRIVATION TOP-UP (0.59451168000000)

(b)	RESIDENT PUPILS AGED 3 TO 18 (80721.0000) multiplied by the result of:
         RESIDENT PUPILS BASIC AMOUNT (20.8670000000000); plus
         SPARSITY TOP-UP (11.8495745550000); plus
         RESIDENT PUPILS DEPRIVATION TOP-UP (0.39237770880000)

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

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

(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 
      (1.00000108142956).

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

Children's Social Care = 0.00059150575720

Basic amount

CHILDREN'S SOCIAL CARE BASIC AMOUNT	= 28.3003000000000

Top-up

CHILDREN'S SOCIAL CARE DEPRIVATION TOP-UP	=  262.5600
 multiplied by CHILDREN WITHOUT GOOD HEALTH (    0.0846); plus  148.7350
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE 
CLAIMANTS AGED 18 TO 64 YEARS (    0.0525); plus  185.4902
 multiplied by CHILDREN OF INCOME SUPPORT/INCOME BASED JOBSEEKER'S 
ALLOWANCE CLAIMANTS (    0.1139); plus  100.0765
 multiplied by CHILDREN IN BLACK ETHNIC GROUPS (    0.0026); minus
   29.3071

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

Children's Social Care

(a)   PROJECTED POPULATION AGED 0-17 IN 2010 (    109737) 
      multiplied by the result of:
         CHILDREN'S SOCIAL CARE BASIC AMOUNT (28.3003000000000); plus
         CHILDREN'S SOCIAL CARE DEPRIVATION TOP-UP (22.1015961800000); 

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

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

(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.99999983766246).

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

Adults' Personal Social Services = 0.00203561938337

Social Services for Older People = 0.00134791292484

Basic amount

OLDER PEOPLE PSS BASIC AMOUNT = 86.0387000000000

Top-ups

OLDER PEOPLE PSS AGE TOP-UP =	
HOUSEHOLD AND SUPPORTED RESIDENTS AGED 90 YEARS AND OVER ( 2968.0000)
divided by HOUSEHOLD AND SUPPORTED RESIDENTS AGED 65 AND OVER (85594.0000), 
rounded to 4 decimal places and multiplied by   998.1913; 
minus    25.6535

OLDER PEOPLE PSS DEPRIVATION TOP-UP =	  288.3107
 multiplied by OLDER PEOPLE 
RECEIVING ATTENDANCE ALLOWANCE (    0.1479)
; plus55.7551000000000
 multiplied by OLDER PEOPLE 
IN RENTED ACCOMMODATION (    0.2336)
; plus74.6782000000000
 multiplied by OLDER PEOPLE 
LIVING IN ONE PERSON HOUSEHOLDS (    0.3276)
; plus224.233900000000
 multiplied by OLDER PEOPLE 
RECEIVING PENSION CREDIT GUARANTEE/INCOME BASED JOBSEEKER'S ALLOWANCE
(    0.1782); minus
77.6613000000000

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

Social Services for Older People

(a)   HOUSEHOLD AND SUPORTED RESIDENTS AGED 65 YEARS AND OVER 
      (94371.0000) multiplied by the result of:
          OLDER PEOPLE PSS BASIC AMOUNT (86.0387000000000); plus
          OLDER PEOPLE PSS AGE TOP-UP (8.98373811000000); plus
          OLDER PEOPLE PSS DEPRIVATION TOP-UP (42.4273031900000); 

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

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

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

(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.99999999239837).

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

Social Services for Younger Adults = (0.00068770645852)

Basic amount

YOUNGER ADULTS PSS BASIC AMOUNT	=  (9.80490000000000)

Top-up

YOUNGER ADULTS PSS DEPRIVATION TOP-UP =	
(284.194300000000) multiplied by PEOPLE AGED 18 TO 64 RECEIVING 
DISABILITY LIVING ALLOWANCE  (0.03850000000000); plus
(76.8918000000000) multiplied by PEOPLE AGED 18 TO 64 WHO ARE LONG 
TERM UNEMPLOYED OR HAVE NEVER WORKED (0.02260000000000); plus
(26.0100000000000) multiplied by PEOPLE AGED 18 TO 64 WHO WORK 
IN ROUTINE OR SEMI ROUTINE OCCUPATIONS (0.24960000000000); plus
(21.7351000000000) multiplied by HOUSEHOLDS WITH NO FAMILY
(0.29990000000000); minus
(15.0541000000000)

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 2010  (330105.000000000) 
      multiplied by the result of:
         YOUNGER ADULTS PSS BASIC AMOUNT (9.80490000000000); plus
         YOUNGER ADULTS PSS DEPRIVATION TOP-UP (10.6355877200000); 

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

(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 (1.00000076314349).

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

Fire and Rescue = 0.00025623859520

Basic amounts

FIRE AND RESCUE BASIC AMOUNT = 1.68240000000000

Top-ups

FIRE AND RESCUE COASTLINE TOP-UP =	    0.7825
 multiplied by COASTLINE (0.00000000000000)

FIRE AND RESCUE DEPRIVATION TOP-UP =	    0.2349
  multiplied by RISK INDEX 1 (9.05960000000000)

HIGH RISK TOP-UP =30869.6814
  multiplied by COMAH SITES 0.00000574457329

PROPERTY AND SOCIETAL RISK TOP-UP =	
PROPERTY AND SOCIETAL RISK (0.39492194036762)

COMMUNITY FIRE SAFETY TOP-UP	
COMMUNITY FIRE SAFETY (0.27743916020448)

The full formula used to calculate the Fire and Rescue element is:

Fire and Rescue

(a)   PROJECTED POPULATION IN 2010 (536583.000000000) multiplied by 
      the result of:
         FIRE AND RESCUE BASIC AMOUNT (1.68240000000000); plus
         FIRE AND RESCUE COASTLINE TOP-UP (0.00000000000000); plus
         FIRE AND RESCUE DEPRIVATION TOP-UP (2.12810004000000); plus
         HIGH RISK TOP-UP (0.17733314733682); plus
         PROPERTY AND SOCIETAL RISK TOP-UP (0.39492194036762); plus
         COMMUNITY FIRE SAFETY TOP-UP (0.27743916020448)

(b)	The result of (a) is then multiplied by AREA COST ADJUSTMENT FOR 
      FIRE ((1.02470000000000);

(c)	The result of (b) is then multiplied by the scaling factor given 
      in Annex F for the Fire and Rescue service block (1.00001583271762).

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

Highway Maintenance = 0.00031205780669

Basic Amount

Highway Basic Amount =   130.9780

Top-ups

Usage Top-Up =   10.8537

 multiplied by TRAFFIC FLOW (23.1371570000000); plus    0.7779
 multiplied by DAYTIME POPULATION PER 
KM (154.059449022327

Winter Maintenance Top-Up =    0.4999
 multiplied by DAYS WITH SNOW LYING (11.5000000000000); plus    1.1246
 multiplied by PREDICTED GRITTING DAYS (61.2000000000000)

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

Highway Maintenance

(a)   WEIGHTED ROAD LENGTHS (5315.60000000000) multiplied by the result of:
         HIGHWAY BASIC AMOUNT (130.978000000000); plus
         USAGE TOP-UP (370.966606325369); plus
         WINTER MAINTENANCE TOP-UP (74.5743700000000);

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

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

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

Environmental, Protective and Cultural Services = 0.00072205994835

COUNTY LEVEL EPCS FSS = 0.00071537164567

Basic Amount

County Services EPCS Basic Amount =     9.1637

Top-Ups

County Services EPCS Density Top-Up =     0.2232
 multiplied by POPULATION DENSITY (3.63881000000000)

County Services EPCS Additional Population Top-Up =    5.8505
 multiplied by NET IN-COMMUTERS (0.00000000000000); plus    9.7489
 multiplied by DAY VISITORS (32816.4383561644)

County Services EPCS Deprivation Top-Up =    35.0954
 multiplied by UNEMPLOYMENT RELATED BENEFIT CLAIMANTS (5259.00000000000); plus   27.2965
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE
    CLAIMANTS (30355.0000000000); plus   13.6473
 multiplied by INCAPACITY BENEFIT AND SEVERE DISABLEMENT
    ALLOWANCE (17078.0000000000); plus    4.9309
 multiplied by COUNTRY OF BIRTH OF RESIDENTS (15794.3904000000)
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 2010 (536583.000000000) multiplied by the result of:
         COUNTY SERVICES EPCS BASIC AMOUNT (9.16370000000000); plus
         COUNTY SERVICES EPCS DENSITY TOP-UP (0.81218239200000);
 
(b)	COUNTY SERVICES EPCS ADDITIONAL POPULATION TOP-UP (319924.175890411); plus
      COUNTY SERVICES EPCS DEPRIVATION TOP-UP (1324101.11512336)

(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.02240000000000);

(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  (1.00000997899815);

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

FIXED COSTS = 0.00000507693915

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

Fixed Costs

(a)	325000.000000000 is multiplied by the scaling factor 
      given in Annex F for Fixed Costs 4.45 (0.15541296676291).

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

FLOOD DEFENCE FSS = 0.00000000000000

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

Flood Defence

(a)   FLOOD DEFENCE EXPENDITURE (0.00000000000000)

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

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

Continuing Environment Agency Levies = 0.00000161136353

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

Continuing Environment Agency Levies

(a)   ENVIRONMENT AGENCY (ENGLAND) LEVY (241482.000000000) is multiplied by the scaling 
      factor given in Annex F for Continuing Environment Agency Levy (0.06672810119144).

(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.15451236981804)

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

Capital Financing = 0.00040819572220

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

Capital Financing

(a)   DEBT I (266169367.332267); plus
      SUPPORTED CAPITAL EXPENDITURE (REVENUE) (18389011.0000000) multiplied 
      by 0.5; minus
      DEBT I (266169367.332267) multiplied by 0.02;

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

(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.16179648605718).

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

Return to: 2010/11 Local Authority Tables Index

Updated February 2008
Return to Local Government Finance Index
Return to Local Government Index
Return to Communities Home Page
Terms and conditions