Department for Communities and Local Government - Local Government Finance Settlement 2007/08
DCLG logo

2007/08 Settlement
Table 3: Annotated Chapter 4 of the LGFR for Barnet ( R384)

Children’s Services = 0.00090853878824

Youth and Community = 0.00007112939108

Basic amount

 
YOUTH AND COMMUNITY BASIC AMOUNT =    14.0735

Top-ups

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

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

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

Youth and Community

 
(a)   PROJECTED POPULATION AGED 13 TO 19 IN 2007 (    26,716)
      multiplied by the result of:
         YOUTH AND COMMUNITY BASIC AMOUNT (14.0735000000000); plus
         YOUTH AND COMMUNITY DEPRIVATION TOP-UP (5.05010028000000); plus
         YOUTH AND COMMUNITY ETHNICITY TOP-UP (3.94164524000000)

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

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

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

Local Authority Central Education Functions = 0.00024976124666

Basic amounts

 
PUPILS BASIC AMOUNT =    19.3170

RESIDENT PUPILS BASIC AMOUNT =    19.2022

Top-ups

 
PUPILS DEPRIVATION TOP-UP =	   32.7858
 multiplied by CHILDREN OF INCOME SUPPORT 
/INCOME BASED JOBSEEKER’S ALLOWANCE CLAIMANTS  ABOVE THRESHOLD (    0.0948)

SPARSITY TOP-UP =	   25.4891
 multiplied by WARD SPARSITY (    0.0000)

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

Fixed cost amount

 
CEF FIXED COST AMOUNT =	69335.8505

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

(b)	RESIDENT PUPILS AGED 3 TO 18 (48558.0000) multiplied by the result of:
         RESIDENT PUPILS BASIC AMOUNT (19.2022000000000); plus
         SPARSITY TOP-UP (0.00000000000000); plus
         RESIDENT PUPILS DEPRIVATION TOP-UP (2.05134193440000)

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

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

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

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

Children’s Social Care = 0.00061272172788

Basic amount

 
CHILDREN'S SOCIAL CARE BASIC AMOUNT	= 17.9444000000000

Top-up

 
CHILDREN'S SOCIAL CARE DEPRIVATION TOP-UP	=  217.5863
 multiplied by CHILDREN WITHOUT GOOD HEALTH (    0.0870); plus  123.2583
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER’S ALLOWANCE 
CLAIMANTS AGED 18 TO 64 YEARS (    0.0810); plus  153.7177
 multiplied by CHILDREN OF INCOME SUPPORT/INCOME BASED JOBSEEKER’S 
ALLOWANCE CLAIMANTS (    0.1864); plus   82.9345
 multiplied by CHILDREN IN BLACK ETHNIC GROUPS (    0.0858); minus
   18.7788

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

Children’s Social Care

 
(a)   PROJECTED POPULATION AGED 0-17 IN 2007 (     73868) 
      multiplied by the result of:
         CHILDREN'S SOCIAL CARE BASIC AMOUNT (17.9444000000000); plus
         CHILDREN'S SOCIAL CARE DEPRIVATION TOP-UP (45.9038897800000); 

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

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

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

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

Children’s Social Care Damping

See RNF Floor Damping Models for Details

Adults’ Personal Social Services = 0.00119239599263

Social Services for Older People = 0.00069009087911

Basic amount

 
OLDER PEOPLE PSS BASIC AMOUNT = 68.7732000000000

Top-ups

 
OLDER PEOPLE PSS AGE TOP-UP =	
HOUSEHOLD AND SUPPORTED RESIDENTS AGED 90 YEARS AND OVER ( 2255.0000)
divided by HOUSEHOLD AND SUPPORTED RESIDENTS AGED 65 AND OVER (43937.0000), 
rounded to 4 decimal places and multiplied by   827.1427; 
minus    21.1749

OLDER PEOPLE PSS DEPRIVATION TOP-UP =	  238.9062
 multiplied by OLDER PEOPLE 
RECEIVING ATTENDANCE ALLOWANCE (    0.1384)
; plus46.2010000000000
 multiplied by OLDER PEOPLE 
IN RENTED ACCOMMODATION (    0.2300)
; plus61.8815000000000
 multiplied by OLDER PEOPLE 
LIVING IN ONE PERSON HOUSEHOLDS (    0.3424)
; plus185.809600000000
 multiplied by OLDER PEOPLE 
RECEIVING PENSION CREDIT GUARANTEE/INCOME BASED JOBSEEKER’S ALLOWANCE
(    0.1895); minus
61.9140000000000

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 
      (43808.0000) multiplied by the result of:
          OLDER PEOPLE PSS BASIC AMOUNT (68.7732000000000); plus
          OLDER PEOPLE PSS AGE TOP-UP (21.2575205100000); plus
          OLDER PEOPLE PSS DEPRIVATION TOP-UP (38.1759928800000); 

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

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

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

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

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

Social Services for Younger Adults = (0.00040017740681)

Basic amount

 
YOUNGER ADULTS PSS BASIC AMOUNT	=  (8.41030000000000)

Top-up

 
YOUNGER ADULTS PSS DEPRIVATION TOP-UP =	
(251.046700000000) multiplied by PEOPLE AGED 18 TO 64 RECEIVING 
DISABILITY LIVING ALLOWANCE  (0.02770000000000); plus
(67.9234000000000) multiplied by PEOPLE AGED 18 TO 64 WHO ARE LONG 
TERM UNEMPLOYED OR HAVE NEVER WORKED (0.05310000000000); plus
(22.9762000000000) multiplied by PEOPLE AGED 18 TO 64 WHO WORK 
IN ROUTINE OR SEMI ROUTINE OCCUPATIONS (0.13180000000000); plus
(19.2000000000000) multiplied by HOUSEHOLDS WITH NO FAMILY
(0.36810000000000); minus
(13.0472000000000)

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 2007  (219108.000000000) 
      multiplied by the result of:
         YOUNGER ADULTS PSS BASIC AMOUNT (8.41030000000000); plus
         YOUNGER ADULTS PSS DEPRIVATION TOP-UP (7.60930929000000); 

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

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

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

Younger Adults’ Damping

See RNF Floor Damping Models for Details

Highway Maintenance = 0.00015239381199

Basic Amount

 
Highway Basic Amount =    65.4320

Top-ups

 
Usage Top-Up =   12.2599

 multiplied by TRAFFIC FLOW (32.0280350000000); plus    0.8715
 multiplied by DAYTIME POPULATION PER 
KM (498.791440609544

Winter Maintenance Top-Up =    0.5025
 multiplied by DAYS WITH SNOW LYING (8.40000000000000); plus    1.1317
 multiplied by PREDICTED GRITTING DAYS (54.1000000000000)

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

Highway Maintenance

 
(a)   WEIGHTED ROAD LENGTHS (1408.50000000000) multiplied by the result of:
         HIGHWAY BASIC AMOUNT (65.4320000000000); plus
         USAGE TOP-UP (827.357246787718); plus
         WINTER MAINTENANCE TOP-UP (65.4459700000000);

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

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

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

Environmental, Protective and Cultural Services = 0.00132148451615

DISTRICT-LEVEL EPCS = 0.00090504458135

Basic Amount

 
District Services EPCS Basic Amount =    11.9431

Top-Ups

 
District Services EPCS Density Top-Up =    0.9060
 multiplied by POPULATION DENSITY (6.94342000000000)

District Services EPCS Sparsity Top-Up =    6.4682
 multiplied by POPULATION SPARSITY (0.01260000000000

District Services EPCS Additional Population Top-Up =    4.8179
 multiplied by NET IN-COMMUTERS (0.00000000000000); plus    4.0902
 multiplied by DAY VISITORS (16972.6027397260)

District Services EPCS Deprivation Top-Up =    38.7239
 multiplied by INCAPACITY BENEFIT AND SEVERE DISABLEMENT
    ALLOWANCE  (10085.0000000000); plus   26.1789
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE
    CLAIMANTS (24079.0000000000); plus   38.7239
 multiplied by ELDERLY ON INCOME SUPPORT/INCOME BASED JOBSEEKER'S
    ALLOWANCE  (8590.00000000000); plus   26.1789
 multiplied by UNEMPLOYMENT RELATED BENEFIT CLAIMANTS (5429.00000000000); plus    3.5296
 multiplied by COUNTRY OF BIRTH OF RESIDENTS (73531.6959000000)

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 2007 (338179.000000000) multiplied by the result of:
         DISTRICT SERVICES EPCS BASIC AMOUNT (11.9431000000000); plus
         DISTRICT SERVICES EPCS DENSITY TOP-UP (6.29073852000000); plus
         DISTRICT SERVICES EPCS SPARSITY TOP-UP (0.08149932000000); 

(b)	DISTRICT SERVICES EPCS ADDITIONAL POPULATION TOP-UP (69421.3397260274); plus
      DISTRICT SERVICES EPCS DEPRIVATION TOP-UP (1755193.28754864)

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

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

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

COUNTY LEVEL EPCS = 0.00040818132129

Basic Amount

 
County Services EPCS Basic Amount =     7.9517

Top-Ups

 
County Services EPCS Density Top-Up =     0.1937
 multiplied by POPULATION DENSITY (6.94342000000000)

County Services EPCS Additional Population Top-Up =    5.0767
 multiplied by NET IN-COMMUTERS (0.00000000000000); plus    8.4595
 multiplied by DAY VISITORS (16972.6027397260)

County Services EPCS Deprivation Top-Up =    30.4536
 multiplied by UNEMPLOYMENT RELATED BENEFIT CLAIMANTS (5429.00000000000); plus   23.6862
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE
    CLAIMANTS (24079.0000000000); plus   11.8423
 multiplied by INCAPACITY BENEFIT AND SEVERE DISABLEMENT
    ALLOWANCE (10085.0000000000); plus    4.2787
 multiplied by COUNTRY OF BIRTH OF RESIDENTS (73531.6959000000)

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 2007 (338179.000000000) multiplied by the result of:
         COUNTY SERVICES EPCS BASIC AMOUNT (7.95170000000000); plus
         COUNTY SERVICES EPCS DENSITY TOP-UP (1.34494045400000);
 
(b)	COUNTY SERVICES EPCS ADDITIONAL POPULATION TOP-UP (143579.732876712); plus
      COUNTY SERVICES EPCS DEPRIVATION TOP-UP (1169722.26694733)

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

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

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

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

FIXED COSTS = 0.00000506385425

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.14604734148950).

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

FLOOD DEFENCE = 0.00000165033496

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

Flood Defence

 
(a)   FLOOD DEFENCE EXPENDITURE (113000.000000000)

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

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

Continuing Environment Agency Levies = 0.00000154442431

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

Continuing Environment Agency Levies

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

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

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

Capital Financing = 0.00018713324571

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

Capital Financing

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

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

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

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

Return to: 2007/08 Local Authority Tables Index

Updated November 2006
Return to Local Government Finance Index
Return to DCLG Local Government Index
Return to DCLG Home Page
Terms and conditions