DCLG logo

2008/09 Reorganisation Fallback Calculation
Table 3: Calculation of the Relative Needs Formulae for Bedford (R679)

Children's Services = 0.00044273004278

Youth and Community = 0.00003255438829

Basic amount

YOUTH AND COMMUNITY BASIC AMOUNT =    14.8173

Top-ups

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

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

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

Youth and Community

(a)   PROJECTED POPULATION AGED 13 TO 19 IN 2008 (    14,553)
      multiplied by the result of:
         YOUTH AND COMMUNITY BASIC AMOUNT (14.8173000000000); plus
         YOUTH AND COMMUNITY DEPRIVATION TOP-UP (4.36197555000000); plus
         YOUTH AND COMMUNITY ETHNICITY TOP-UP (2.21671748000000)

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

(c)   The result of (b) is then multiplied by the scaling factor for the Youth and
	Community Services sub block (1.00000120888040)

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

Local Authority Central Education Functions = 0.00015289904736

Basic amounts

PUPILS BASIC AMOUNT =    20.3435

RESIDENT PUPILS BASIC AMOUNT =    20.1338

Top-ups

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

SPARSITY TOP-UP =	   26.7902
 multiplied by WARD SPARSITY (    0.3637)

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

Fixed cost amount

CEF FIXED COST AMOUNT =	70738.1486

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

(b)	RESIDENT PUPILS AGED 3 TO 18 (25682.0000) multiplied by the result of:
         RESIDENT PUPILS BASIC AMOUNT (20.1338000000000); plus
         SPARSITY TOP-UP (9.74359574000000); plus
         RESIDENT PUPILS DEPRIVATION TOP-UP (1.77301533420000)

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

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

(e)	The result of (d) is then multiplied by the scaling factor for the Local
 	Authority Central Education Functions sub block (1.00000091522124).

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

Children's Social Care = 0.00025727660713

Basic amount

CHILDREN'S SOCIAL CARE BASIC AMOUNT	= 26.3193000000000

Top-up

CHILDREN'S SOCIAL CARE DEPRIVATION TOP-UP	=  244.1810
 multiplied by CHILDREN WITHOUT GOOD HEALTH (    0.0926); plus  138.3237
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE 
CLAIMANTS AGED 18 TO 64 YEARS (    0.0715); plus  172.5060
 multiplied by CHILDREN OF INCOME SUPPORT/INCOME BASED JOBSEEKER'S 
ALLOWANCE CLAIMANTS (    0.1720); plus   93.0712
 multiplied by CHILDREN IN BLACK ETHNIC GROUPS (    0.0252); minus
   27.2556

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

Children's Social Care

(a)   PROJECTED POPULATION AGED 0-17 IN 2008 (     35741) 
      multiplied by the result of:
         CHILDREN'S SOCIAL CARE BASIC AMOUNT (26.3193000000000); plus
         CHILDREN'S SOCIAL CARE DEPRIVATION TOP-UP (37.2621313900000); 

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

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

(d)	The result of (c) is then multiplied by the scaling factor for the Children's 
	Social Care sub block (0.99999946971584).

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

Adults' Personal Social Services = 0.00053095419485

Social Services for Older People = 0.00033305166633

Basic amount

OLDER PEOPLE PSS BASIC AMOUNT = 82.3847000000000

Top-ups

OLDER PEOPLE PSS AGE TOP-UP =	
HOUSEHOLD AND SUPPORTED RESIDENTS AGED 90 YEARS AND OVER (  827.0000);
divided by HOUSEHOLD AND SUPPORTED RESIDENTS AGED 65 AND OVER (22788.0000); 
rounded to 4 decimal places and multiplied by   955.7978; 
minus    24.5640

OLDER PEOPLE PSS DEPRIVATION TOP-UP =   276.0661; 
multiplied by OLDER PEOPLE RECEIVING ATTENDANCE ALLOWANCE (    0.1413); plus 53.3872000000000
 multiplied by OLDER PEOPLE IN RENTED ACCOMMODATION (    0.2275); plus 71.5066000000000
 multiplied by OLDER PEOPLE LIVING IN ONE PERSON HOUSEHOLDS (    0.3233); plus 214.710700000000
 multiplied by OLDER PEOPLE RECEIVING PENSION CREDIT 
GUARANTEE/INCOME BASED JOBSEEKER'S ALLOWANCE (    0.1827); minus
74.3631000000000

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 
      (23693.0000) multiplied by the result of:
          OLDER PEOPLE PSS BASIC AMOUNT (82.3847000000000); plus
          OLDER PEOPLE PSS AGE TOP-UP (10.1314601400000); plus
          OLDER PEOPLE PSS DEPRIVATION TOP-UP (39.1363566000000); 

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

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

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

(e)   The result of (d) is then multiplied by the scaling factor for 
	the Social Services for Older People sub block  (0.99999990080258).

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

Social Services for Younger Adults = (0.00019790252852)

Basic amount

YOUNGER ADULTS PSS BASIC AMOUNT	=  (9.15180000000000)

Top-up

YOUNGER ADULTS PSS DEPRIVATION TOP-UP =	
(265.265300000000) multiplied by PEOPLE AGED 18 TO 64 RECEIVING 
DISABILITY LIVING ALLOWANCE  (0.03560000000000); plus
(71.7704000000000) multiplied by PEOPLE AGED 18 TO 64 WHO ARE LONG 
TERM UNEMPLOYED OR HAVE NEVER WORKED (0.03800000000000); plus
(24.2776000000000) multiplied by PEOPLE AGED 18 TO 64 WHO WORK 
IN ROUTINE OR SEMI ROUTINE OCCUPATIONS (0.22240000000000); plus
(20.2874000000000) multiplied by HOUSEHOLDS WITH NO FAMILY
(0.31180000000000); minus
(14.0514000000000)

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 2008  (100164.000000000) 
      multiplied by the result of:
         YOUNGER ADULTS PSS BASIC AMOUNT (9.15180000000000); plus
         YOUNGER ADULTS PSS DEPRIVATION TOP-UP (9.84426944000000); 

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

(c)   The result of (b) is then multiplied by the scaling factor for the Social
 	Services for Younger Adults sub block (1.00000193107124).

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

Highway Maintenance = 0.00009491157768

Basic Amount

Highway Basic Amount =   130.9925

Top-ups

Usage Top-Up =   10.8549

 multiplied by TRAFFIC FLOW (29.7262530000000); plus    0.7779
 multiplied by DAYTIME POPULATION PER 
KM (207.020954304469

Winter Maintenance Top-Up =    0.4998
 multiplied by DAYS WITH SNOW LYING (12.1000000000000); plus    1.1243
 multiplied by PREDICTED GRITTING DAYS (41.0000000000000)

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

Highway Maintenance

(a)   WEIGHTED ROAD LENGTHS (1374.20000000000) multiplied by the result of:
         HIGHWAY BASIC AMOUNT (130.992500000000); plus
         USAGE TOP-UP (483.717104043146); plus
         WINTER MAINTENANCE TOP-UP (52.1438800000000);

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

(c)   The result of (b) is then multiplied by the scaling factor for the
	Highway Maintenance service block (1.00001116202991).

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

Environmental, Protective and Cultural Services = 0.00060876819006

DISTRICT-LEVEL EPCS = 0.00038309913175

Basic Amount

District Services EPCS Basic Amount =    12.0636

Top-Ups

District Services EPCS Density Top-Up =    0.9151
 multiplied by POPULATION DENSITY (4.96296000000000)

District Services EPCS Sparsity Top-Up =    6.5335
 multiplied by POPULATION SPARSITY (0.22840000000000)

District Services EPCS Additional Population Top-Up =    4.8666
 multiplied by NET IN-COMMUTERS (0.00000000000000); plus    4.1315
 multiplied by DAY VISITORS (5098.63013698630)

District Services EPCS Deprivation Top-Up =    39.1146
 multiplied by INCAPACITY BENEFIT AND SEVERE DISABLEMENT
    ALLOWANCE  (5378.00000000000); plus   26.4431
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE
    CLAIMANTS (10569.0000000000); plus   39.1146
 multiplied by ELDERLY ON INCOME SUPPORT/INCOME BASED JOBSEEKER'S
    ALLOWANCE  (4259.00000000000); plus   26.4431
 multiplied by UNEMPLOYMENT RELATED BENEFIT CLAIMANTS (2197.00000000000); plus    3.5652
 multiplied by COUNTRY OF BIRTH OF RESIDENTS (11772.8176000000)

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 2008 (160168.000000000) multiplied by the result of:
         DISTRICT SERVICES EPCS BASIC AMOUNT (12.0636000000000); plus
         DISTRICT SERVICES EPCS DENSITY TOP-UP (4.54160469600000); plus
         DISTRICT SERVICES EPCS SPARSITY TOP-UP (1.49225140000000); 

(b)	DISTRICT SERVICES EPCS ADDITIONAL POPULATION TOP-UP (21064.9904109589); plus
      DISTRICT SERVICES EPCS DEPRIVATION TOP-UP (756492.464107520)

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

(d)	The result of (c) is then multiplied by the scaling factor for 
      these services (1.00000858329360);

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

COUNTY LEVEL EPCS FSS = 0.00021324859775

Basic Amount

County Services EPCS Basic Amount =     8.5550

Top-Ups

County Services EPCS Density Top-Up =     0.2084
 multiplied by POPULATION DENSITY (4.96296000000000)

County Services EPCS Additional Population Top-Up =    5.4619
 multiplied by NET IN-COMMUTERS (0.00000000000000); plus    9.1014
 multiplied by DAY VISITORS (5098.63013698630)

County Services EPCS Deprivation Top-Up =    32.7643
 multiplied by UNEMPLOYMENT RELATED BENEFIT CLAIMANTS (2197.00000000000); plus   25.4834
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE
    CLAIMANTS (10569.0000000000); plus   12.7408
 multiplied by INCAPACITY BENEFIT AND SEVERE DISABLEMENT
    ALLOWANCE (5378.00000000000); plus    4.6033
 multiplied by COUNTRY OF BIRTH OF RESIDENTS (11772.8176000000)
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 2008 (160168.000000000) multiplied by the result of:
         COUNTY SERVICES EPCS BASIC AMOUNT (8.55500000000000); plus
         COUNTY SERVICES EPCS DENSITY TOP-UP (1.03428086400000);
 
(b)	COUNTY SERVICES EPCS ADDITIONAL POPULATION TOP-UP (46404.6723287671); plus
      COUNTY SERVICES EPCS DEPRIVATION TOP-UP (464031.055358080)

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

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

(e)	The result of (d) is then multiplied by the scaling factor for 
      these services  (1.00000175816016);

(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 
      for Fixed Costs 4.45 (0.15621351216205).

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

FLOOD DEFENCE FSS = 0.00000682734773

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

Flood Defence

(a)   FLOOD DEFENCE EXPENDITURE (460280.000000000)

(b)	The result of (a) is multiplied by the scaling factor for 
	Flood Defence (0.14833031477160).

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

Continuing Environment Agency Levies = 0.00000051617369

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

Continuing Environment Agency Levies

(a)   ENVIRONMENT AGENCY (ENGLAND) LEVY (81045.0000000000) is multiplied by the scaling 
      factor for Continuing Environment Agency Levy (0.06368976345146).

(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 for Coast Protection (0.14747693113081)

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

Under both Variants 1 and 2

Capital Financing = 0.00012488355549

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

Capital Financing

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

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

(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  
      for Debt charges (0.15997527478564).

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

Return to: 2008/09 Local Authority Tables Index

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