DCLG logo

Settlement
Table 3: Annotated Chapter 4 of the LGFR for Lincolnshire (R428/E2520)

Children's Services = 0.00112499932091

Youth and Community = 0.00008174322452

Basic amount

YOUTH AND COMMUNITY BASIC AMOUNT =    11.4808

Top-ups

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

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

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

Youth and Community

(a)   PROJECTED POPULATION AGED 13 TO 19 IN 2012 (    59,790)
      multiplied by the result of:
         YOUTH AND COMMUNITY BASIC AMOUNT (11.4808000000000); plus
         YOUTH AND COMMUNITY DEPRIVATION TOP-UP (1.88815258000000); plus
         YOUTH AND COMMUNITY ETHNICITY TOP-UP (0.30273673000000)

(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 (1.00000237497510)

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

Local Authority Central Education Functions = 0.00046090931715

Basic amounts

PUPILS BASIC AMOUNT =    13.0332

RESIDENT PUPILS BASIC AMOUNT =    12.8909

Top-ups

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

SPARSITY TOP-UP =	   17.1367
 multiplied by WARD SPARSITY (    0.8757)

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

Fixed cost amount

CEF FIXED COST AMOUNT =	48,512.191

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 (104,860.00) multiplied by the result of:
         PUPILS BASIC AMOUNT (13.0332000000000); plus
         PUPILS DEPRIVATION TOP-UP (0.98333204000000)

(b)	RESIDENT PUPILS AGED 3 TO 18 (108,276.00) multiplied by the result of:
         RESIDENT PUPILS BASIC AMOUNT (12.8909000000000); plus
         SPARSITY TOP-UP (15.0057513550000); plus
         RESIDENT PUPILS DEPRIVATION TOP-UP (0.64899914640000)

(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 (48,512.191200000);

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

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

Children's Social Care = 0.00058234677924

Basic amount

CHILDREN'S SOCIAL CARE BASIC AMOUNT	= 20.7974000000000

Top-up

CHILDREN'S SOCIAL CARE DEPRIVATION TOP-UP	=  167.3718
 multiplied by CHILDREN WITHOUT GOOD HEALTH (    0.0889); plus   97.4567
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE 
CLAIMANTS AGED 18 TO 64 YEARS (    0.0699); plus  117.0965
 multiplied by CHILDREN OF OUT OF WORK CHILD TAX CREDIT CLAIMANTS (    0.1557); plus   64.2395
 multiplied by CHILDREN IN BLACK ETHNIC GROUPS (    0.0013); minus
   21.3129

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

Children's Social Care

(a)   PROJECTED POPULATION AGED 0-17 IN 2012 (   140,159) 
      multiplied by the result of:
         CHILDREN'S SOCIAL CARE BASIC AMOUNT (20.7974000000000); plus
         CHILDREN'S SOCIAL CARE DEPRIVATION TOP-UP (18.6941127500000); 

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

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

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

Adults' Personal Social Services = 0.00302736306910

Social Services for Older People = 0.00192485958931

Basic amount

OLDER PEOPLE PSS BASIC AMOUNT = 76.7881000000000

Top-ups

OLDER PEOPLE PSS AGE TOP-UP =	
HOUSEHOLD AND SUPPORTED RESIDENTS AGED 90 YEARS AND OVER (4,591.0000)
divided by HOUSEHOLD AND SUPPORTED RESIDENTS AGED 65 AND OVER (139,076.00), 
rounded to 4 decimal places and multiplied by   917.5953; 
minus    21.1047

OLDER PEOPLE PSS DEPRIVATION TOP-UP =	  265.0319
 multiplied by OLDER PEOPLE 
RECEIVING ATTENDANCE ALLOWANCE (    0.1368)
; plus 51.2533000000000 multiplied by OLDER PEOPLE 
IN RENTED ACCOMMODATION (    0.2453)
; plus 68.6485000000000 multiplied by OLDER PEOPLE 
LIVING IN ONE PERSON HOUSEHOLDS (    0.3045)
; plus 206.128900000000 multiplied by OLDER PEOPLE 
RECEIVING PENSION CREDIT GUARANTEE/INCOME BASED JOBSEEKER'S ALLOWANCE
(    0.1838); minus
71.5646000000000

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 
      (151,121.00) multiplied by the result of:
          OLDER PEOPLE PSS BASIC AMOUNT (76.7881000000000); plus
          OLDER PEOPLE PSS AGE TOP-UP (9.17594490000000); plus
          OLDER PEOPLE PSS DEPRIVATION TOP-UP (36.0541584800000); 

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

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

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

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

Social Services for Younger Adults = (0.00110250347979)

Basic amount

YOUNGER ADULTS PSS BASIC AMOUNT	=  (10.3569000000000)

Top-up

YOUNGER ADULTS PSS DEPRIVATION TOP-UP =	
(287.687200000000) multiplied by PEOPLE AGED 18 TO 64 RECEIVING 
DISABILITY LIVING ALLOWANCE  (0.05300000000000); plus
(77.8368000000000) multiplied by PEOPLE AGED 18 TO 64 WHO ARE LONG 
TERM UNEMPLOYED OR HAVE NEVER WORKED (0.02990000000000); plus
(26.3296000000000) multiplied by PEOPLE AGED 18 TO 64 WHO WORK 
IN ROUTINE OR SEMI ROUTINE OCCUPATIONS (0.29180000000000); plus
(22.0023000000000) multiplied by HOUSEHOLDS WITH NO FAMILY
(0.28910000000000); minus
(15.6706000000000)

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 2012  (419,125.00000000) 
      multiplied by the result of:
         YOUNGER ADULTS PSS BASIC AMOUNT (10.3569000000000); plus
         YOUNGER ADULTS PSS DEPRIVATION TOP-UP (15.9479841300000); 

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

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

Fire and Rescue = 0.00036380863187

Basic amounts

FIRE AND RESCUE BASIC AMOUNT = 2.99300000000000

Top-ups

FIRE AND RESCUE COASTLINE TOP-UP =	    1.4472
 multiplied by COASTLINE (0.27796683024680)

FIRE AND RESCUE DEPRIVATION TOP-UP 1 =	    0.1419
  multiplied by POPULATION DENSITY (2.63085000000000)

FIRE AND RESCUE DEPRIVATION TOP-UP 2 =	    0.0747
  multiplied by RISK INDEX (6.74810000000000)

HIGH RISK TOP-UP =22,446.529
  multiplied by COMAH SITES 0.00000716409356

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

COMMUNITY FIRE SAFETY TOP-UP =	
COMMUNITY FIRE SAFETY (0.25938803132630)

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

Fire and Rescue

(a)   PROJECTED POPULATION IN 2012 (717,991.00000000) multiplied by 
      the result of:
         FIRE AND RESCUE BASIC AMOUNT (2.99300000000000); plus
         FIRE AND RESCUE COASTLINE TOP-UP (0.40227359673317); plus
         FIRE AND RESCUE DEPRIVATION TOP-UP 1(0.37331761500000); plus
	   FIRE AND RESCUE DEPRIVATION TOP-UP 2(0.50408307000000); plus
         HIGH RISK TOP-UP (0.16080903177275); plus
         PROPERTY AND SOCIETAL RISK TOP-UP (0.37440796672215); plus
         COMMUNITY FIRE SAFETY TOP-UP (0.25938803132630)

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

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

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

Highway Maintenance = 0.00030609430064

Basic Amount

Highway Basic Amount =    74.6640

Top-ups

Usage Top-Up =    7.1922

 multiplied by TRAFFIC FLOW (20.3792660000000); plus    0.5346
 multiplied by DAYTIME POPULATION PER 
KM (84.2171136355676

Winter Maintenance Top-Up =    0.3126
 multiplied by DAYS WITH SNOW LYING (14.1000000000000); plus    0.7033
 multiplied by PREDICTED GRITTING DAYS (50.7000000000000)

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

Highway Maintenance

(a)   WEIGHTED ROAD LENGTHS (9,992.4000000000) multiplied by the result of:
         HIGHWAY BASIC AMOUNT (74.6640000000000); plus
         USAGE TOP-UP (191.594225874774); plus
         WINTER MAINTENANCE TOP-UP (40.0649700000000);

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

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

Environmental, Protective and Cultural Services = 0.00072934083949

COUNTY LEVEL EPCS = 0.00065753496128

Basic Amount

County Services EPCS Basic Amount =     6.3974

Top-Ups

County Services EPCS Density Top-Up =     0.1558
 multiplied by POPULATION DENSITY (2.63085000000000)

County Services EPCS Additional Population Top-Up =    4.0844
 multiplied by NET IN-COMMUTERS (0.00000000000000); plus    6.8060
 multiplied by DAY VISITORS (20,035.616438356)

County Services EPCS Deprivation Top-Up =    24.5011
 multiplied by UNEMPLOYMENT RELATED BENEFIT CLAIMANTS (11,309.000000000); plus   19.0565
 multiplied by INCOME SUPPORT/INCOME BASED JOBSEEKER'S ALLOWANCE
    CLAIMANTS (50,779.000000000); plus    9.5276
 multiplied by INCAPACITY BENEFIT AND SEVERE DISABLEMENT
    ALLOWANCE (28,075.000000000); plus    3.4424
 multiplied by COUNTRY OF BIRTH OF RESIDENTS (11,332.603300000)
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 2012 (717,991.00000000) multiplied by the result of:
         COUNTY SERVICES EPCS BASIC AMOUNT (6.39740000000000); plus
         COUNTY SERVICES EPCS DENSITY TOP-UP (0.40988643000000);
 
(b)	COUNTY SERVICES EPCS ADDITIONAL POPULATION TOP-UP (136,362.40547945); plus
      COUNTY SERVICES EPCS DEPRIVATION TOP-UP (1,551,251.677000)

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

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

Fixed Costs = 0.00000352126176

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

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

Continuing Environment Agency Levies = 0.00000244102468

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

Continuing Environment Agency Levies

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

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

Coast Protection = 0.00000002163092

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

Coast Protection

(a)   COAST PROTECTION EXPENDITURE (2,000.0000000000) is multiplied by the 
      scaling factor given in Annex F for Coast Protection (0.10815458728465)

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

Concessionary Fares = 0.00006582196086

Basic Amount

Concessionary Fares Basic Amount =     0.8926

Top-Ups

Concessionary Fares Deprivation Top-Up =    3.3222
 multiplied by PEOPLE AGED OVER 60YRS WITH NO ACCESS TO CAR OR VAN (0.25030000000000); plus   -1.6169
 multiplied by SPARSITY ADJUSTMENT FOR PEOPLE AGED 60 AND OVER (0.75510000000000); plus   10.2865
 multiplied by INCAPACITY BENEFIT AND SEVERE DISABLEMENT ALLOWANCE (0.04020000000000)

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

(a)   PROJECTED POPULATION IN 2011 (717,991.00000000) multiplied by the result of:
         CONCESSIONARY FARES BASIC AMOUNT (0.89260000000000); plus
         CONCESSIONARY FARES DEPRIVATION TOP-UP (0.02414277000000)

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

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

Capital Financing = 0.00058098917876

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

Capital Financing

(a)   DEBT I (414,404,266.8898); plus
      SUPPORTED CAPITAL EXPENDITURE (REVENUE) (               0) multiplied 
      by 0.5; minus
      DEBT I (414,404,266.8898) 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.15581090001901).

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

Return to: 2012/13 Local Authority Tables Index

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