australia post end of an era or an opportunity to shine

8
Page 1 Australia Post The Business Impact on Australia

Upload: fwrgroup

Post on 23-Nov-2015

13 views

Category:

Documents


0 download

DESCRIPTION

With the rise in emails and decline of the demand for letters, There needs to be a mindset change to improve the operations of the business, and minimise the impact on the workers.Look at the Royal Mail, that went from a company that was loosing money and turned it into a profitable business.A program was put in place and it was progressive with improvements

TRANSCRIPT

Folie 1

Australia Post The Business Impact on Australia

Page #1

Australia Post Must Make ChangesPostal Impacts for Australia Post

With the rise in emails and decline of the demand for letters, There needs to be a mindset change to improve the operations of the business, and minimise the impact on the workers.

Look at the Royal Mail, that went from a company that was loosing money and turned it into a profitable business.

A program was put in place and it was progressive with improvements

Page #2

Royal Mail Case StudyRoyal mail summary

Single largest employer in the UK - c.176,000 employeesHandle 75 million items every working day 113,000 collection points28 million delivery addresses33,000 vehicles travelling 1.8 million miles a day135 million litres of diesel annually12,000 retail outlets.

Page #3

Map the Business ImpactBenchmark where you are at and set a programme.

Concentrate on Business Road and Electricity Efficiency

Page #4

Quality Assurance and Management Systems Introduction to Management Systems

The ISO 9000 series of International Standards emphasise the importance of audits as a management tool for monitoring and verifying the effective implementation of an organisation's quality policy.

Audits are also an essential part of conformity assessment activities such as external certification/registration and of supply chain evaluation and surveillance.

Page #5

Management System RequirementsThe organisation shall establish, document, implement and maintain a quality management system and continually improve its effectiveness in accordance with the requirements of this International Standard. The organisation shall a) determine the processes needed for the quality management system and their application throughout the organisation , b) determine the sequence and interaction of these processes, c) determine criteria and methods needed to ensure that both the operation and control of these processes are effective, d) ensure the availability of resources and information necessary to support the operation and monitoring of these processes, e) monitor, measure where applicable, and analyse these processes, and f) implement actions necessary to achieve planned results and continual improvement of these processes.

Page #6

OutcomesA management system should have :

An effective audit programScheduled audits on the basis of risk and importance of processesEffective audit checklistsReview and follow up corrective actionsManagement Review Meeting

Your can join our free webinar

http://iso26000.net.au/webinar1/discover-the-power-of-auditing-for-small-business-registration

Page #7

Independent Inspections /FWR Group Pty LtdIndependent Inspections Pty Ltdwww.iigi.com.au

www.fwrgroup.com.auwww.independentcertification.com.au

Mr. Peter GreenhamQualifications:Diploma of Civil EngineeringAssociate Diploma of Laboratory OperationsDiploma of Quality ManagementDiploma of BusinessLead Environmental AuditorDiploma of workplace training and AssessmentNATA Asessor

Your Auditors and Trainers

P: 1300 857 149F: 1300 857 150

Team

Mr. Sydney LueM: 0423 234 [email protected]

Mr. Peter GreenhamM: [email protected]

Page #8Chart1389390.702526123594.34091601199784.290313185597.08585224968216.82391416804.15428672758512.6111927303

CO2 emissions by source

At-a-glance-EnvEnvironmental2006/072005/062004/052003/042002/03Building energy consumption (gwh)21040.81151.71272.71230.11156.3Green35Renewable energy (% of electicity consumption)98.8%1.2%1.2%1.2%1.0%Green41Renewable energy (electicity consumption in GWh)377.65554Green41Water usage (m3)2,035,1602,254,7202,166,0662,378,682-Green39Road fleet fuel procured (million litres)147.6153.9160.5159158.4Green38CO2 emissions from mail operations (CO2 kg per 1000 items)18.018.719.921.826Green38Total CO2 emissions (tonnes)991,900810,174864,018877,655885,351Green34Solid waste dispatch to landfill (tonnes)42,13347,12648,07449,153-Green39Mail items (in millions)24,13924,926

Judith.Odonnell:sources as for CSR Governance reportsJudith.Odonnell:From Elfyn MorganJudith.Odonnell:Only NI not covered by contract with EDF - 377,600 MWh UK, 8.2MWh NI, i.e. 99.9% certified renewable.Judith.Odonnell:Only NI not covered by contract with EDF - 377,600 MWh UK, 8.2MWh NI, i.e. 99.9% certified renewable.Judith.Odonnell:From Elfyn MorganJudith.Odonnell:Confirmed by Sally Woods as fuel purchasedJudith.Odonnell:From Governance ReportJudith.Odonnell:This figure now includes commuting to work, which was not shown in last year's returns.Judith.Odonnell:Peter Reynolds dept provided report summary for whole year - file: Recycling SITA.Judith.Odonnell:CO2 emission figures 2006-07Judith.Odonnell:CO2 calcs 05_06

CO2-0607cumRM Group sheet - NB don't change formats!Yellow cells are source data or linked source data892,763.2882,842.7869,206.2815,362.1806,302.9Green cells are secondary links or formulasScopeCO2 emissions by source2002/032003/042004/052005/062006/0739.3%Scope 1 Business road424,445.4425,707.3430,148.8404,708.7389,390.712.5%Scope 1 Natural gas and oil141,778.0154,568.5164,835.2143,314.3123,594.320.1%Scope 2 Grid electricity180,500.0180,160.5175,373.4171,292.7199,784.318.7%Scope 3 Commuting to work172,323.8172,323.8172,323.8172,312.4185,597.16.9%Scope 3 Business air & rail122,562.0101,499.679,468.173,798.968,216.81.7%Scope 3 Personal road16,065.413,494.412,085.214,992.116,804.20.9%Scope 3 Personal air & rail & Authorised cars on delivery7,412.47,412.47,295.67,255.48,512.673,187.00.06871457396.8714573858Total CO2 in tonnes1,065,087.01,128,353.61,041,536.9987,674.5991,900.0Commuting and Cars on Delivery177,512.0177,512.0177,512.0177,500.6191,647.2Total without Commuting and Cars on Delivery (as in CSR Reports 0506 - except 0203 see below and 0607)887,575.0950,841.6864,024.9810,173.9800,252.8Figures reported in CSR Report885,351.0877,654.6864,018.1810,173.9991,900.0Difference for 02/03 is for personal air and rail, which is an estimate using figures from 03/042,224.0%Carbon dioxide emissions by scope (reported from 2006/07)2002/032003/042004/052005/062006/0751.7%Scope 1 - DIRECT566,223580,276594,984548,023512,98520.1%Scope 2 - INDIRECT180,500180,161175,373171,293199,78428.1%Scope 3 - INDIRECT318,364367,917271,180268,359279,131100%1,065,0871,128,3541,041,537987,674991,900ScopeCO2 emissions (tonnes) from energy consumption2002/032003/042004/052005/062006/071Gas oil7,692.05,826.16,1234,7006,517.11Natural gas134,086.0148,742.5158,712138,614117,077.32Grid electricity180,500.0180,160.5175,373171,293199,784.3Total (externally generated)322,278.0334,729.1340,208.6314,607.0323,378.6CO2 emissions (tonnes) from transport2002/032003/042004/052005/062006/076.5%Business Air65,772.067,825.278,22171,13664,5480.4%Business Rail56,790.033,674.41,2472,6633,66939.3%Business Road424,445.4425,707.3430,149404,709389,3910.2%Personal Air1,811.11,811.11,7581,6321,8300.1%Personal Rail413.1413.13494356331.7%Personal Road16,065.413,494.412,08514,99216,8040.6%Private cars on delivery5,188.25,188.25,188.25,188.26,050.118.7%Commuting to work172,323.8172,323.8172,323.8172,312.4185,597.146.1%Business fleet air/rail/road kg CO2 - total547,007527,207509,617478,508457,6081.9%Personal air/rail/road CO2 (for business travel) - tonnes18,29015,71914,19317,05919,26748.1%Total travel excluding private usage565,297542,926523,809495,567476,87467.4%Total travel - including private usage742,809720,438701,321673,067668,521Summary - CO2 tonnes39.3%Business (fleet) road CO2 - scope 1424,445.4425,707.3430,148.8404,708.7389,390.76.9%Business (fleet) air/rail CO2 - scope 3122,562.0101,499.679,468.173,798.968,216.81.9%Personal road/rail/air CO2 (for business travel) - scope 3 (cost to business)18,289.615,718.614,192.617,059.319,266.720.1%Private travel emissions - scope 3 (little business influence)177,512.0177,512.0177,512.0177,500.6191,647.232.6%Building energy use - scope 1 & 2322,278.0334,729.1340,208.6314,607.0323,378.6100%Tonnes CO21,065,087.01,055,166.61,041,530.1987,674.5991,900.0Scope 1 - fleet road only, buildings gas + oil - DIRECTScope 2 - electricity (generated on our behalf) - INDIRECTScope 3 - all rail/air, personal business miles, commuting, cars on delivery - INDIRECTPerformanceIndirect gaseous emissions (tonnes) from building enery usage2002/032003/042004/052005/062006/07SO23,880.63,906.73,805.43,756.83,561.9NOx998.41,031.31,033.9980.0909.0CO527.8532.6519.3512.3484.7VOC13.413.913.913.212.2CH40.20.20.20.20.1Air emissions67,583.169,636.379,979.472,767.966,378.2Rail emissions57,203.134,087.51,596.13,098.34,301.1Road emissions440,510.8439,201.7442,234.0419,700.8406,194.9565,297.0542,925.5523,809.5495,566.9476,874.2

CO2-0607cum0000000

CO2 emissions by sourceGroup Carbon dioxide emissions by source & scope 2006/07

Indirect06070000000000000000000000000

2006/072005/062004/052003/042002/03Indirect gaseous emissions (tonnes) from building energy usage

CarsOnDelivery00000000000000000000

2006/072005/062004/052003/042002/03Carbon dioxide emissions (tonnes) from energy consumption

Commuting0000000000000000000000000000000000000000

2006/072005/062004/052003/042002/03Carbon dioxide emissions (tonnes) by mode of transport

CO2RML0000000

Judith.Odonnell:input values for chart to updateJudith.Odonnell:N4O = Nitrous Oxide, as presumably does NOxJudith.Odonnell:MethaneJudith.Odonnell:Volatile Organic CompoundsJudith.Odonnell:Carbon MonoxideJudith.Odonnell:Sulfur DioxideJudith.Odonnell:factor from defra jun07 for national rail 0.0602 which is between light rail and underground. 64,957 sectors, total milage 6,530,689. Source [email protected]:Short Haul Factor 0.1304*109% to account for 'circling'. 23,951 flights (sectors), total milage 8,001,653. Source [email protected]:25,634,744 litres of fuel, source Howard F Morris. Defra conversion factor jun 07 x2.518Judith.Odonnell:7,014,414 kWh Source: Simon M Francis (extra coach since Feb 07 - updated rail sheet in 06/07 CO2 calculator spreadsheet). Defra Jun 07 factor = 0.523Judith.Odonnell:51,995,867 total:41,125,111 miles claimed through T&S, report PRT540 from MyPeople (through Simon M Francis) excludes POL. 10,870,756 miles claimed through T&S, report from Steve S Reeves for POL only. Split on (national?) company car profile of diesel 80.1, petrol 19.9% Defra diesel factor x0.3197; petrol factor x0.3372Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportScope 1 - DIRECTScope 2 - INDIRECTScope 3 - INDIRECTCO2 tonnesRMG CO2 emissions (tonnes) by Scope000000000CO2 emissions by sourceGroup Carbon dioxide emissions by source & scope 2005/06

CO2PFW0000000

CO2 emissions by sourceGroup Carbon dioxide emissions by source & scope 2004/05

CO2POL000000000000000000000

Scope 1 Business roadScope 1 Natural gas and oilScope 2 Grid electricityScope 3 Commuting to workScope 3 Business air & railScope 3 Personal roadScope 3 Personal air & rail & Authorised cars on deliveryRMG carbon dioxide emissions (tonnes) by source

CO2CFEMISSION REPORTPOLLUTANTS EXPRESSED IN Kg/GJUTILITYCONSUMPTIONkWh/Litres to GJCONSUMPTION IN GJCO2CH4SO2NOXVOCCOELECTRICITY - kWh381,996,7310.00361,375,188.23164197474.85304100.38874090683534233.755212646338.4688528663.68585908477190.3163652Electricity Factors119.40.0000732.570.470.00630.347GAS - kWh632,850,1250.00362,278,260.45120246586.55143.2869485511619.128295252431.257863440.17327957062.607395Gas Factors52.780.0000190.00510.11080.001510.0031OIL - Litres2,221,0790.03884,401.005860805.578881.85682204416036.1903810204.0811418139.177252298455.7654108Oil Factors69.440.0000220.190.12090.0016490.0054methanesulphur dioxide0.13561.9909.012.2484.7co2 equivalents neededgwp123nyknyknyknyk& vehicles!!!!!need cycles - urban or rural;need info on cold starts, etcneed fleet factors

Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Revised Electricity factor Jun 07 x0.523 - using factor for brown, not green & not restating previous years' usageJudith.Odonnell:Gas Defra factor x0.185Defra litres conversion is 2.674, but we are using kwh conversion ofx0.251 as this applies consistency to energy figures, and a higher CO2 value results (thus not underestimating footprint). Conversion from litres to kwh of 11.69 is from Carbon Trust.Judith.Odonnell:Simon Francis indicated where factors fit within 3 scopes of emissionsJudith.Odonnell:Conversion of miles to kilometres = 1.609Judith.Odonnell:Inc biodiesel percentage. Calculation was for fuel consumed in year 06/07, but fuel purchased in previous yearsJudith.Odonnell:148,058,089 total diesel. Source Cathy Braithwaite. Defra factor Jun 07 x 2.63. Biodiesel element of 33,412 included in total and discountedJudith.Odonnell:Use short haul factorJudith.Odonnell:Factor in pkmJudith.Odonnell:SIP needs updating when info can be foundJudith.Odonnell:SIP needs updating when info can be found

CO2totalBUsPrivate cars on delivery2006/072005/062004/052004/062004/07Current number of authorised private cars on delivery11,00311,00311,00311,00311,003Estimated average distance (miles) of a delivery round77777Estimated average daily distance77,02177,02177,02177,02177,021Estimated average weekly distance - using a five day week385,105385,105385,105385,105385,105Estimated average annual distance - using 47 weeks per yr18,099,93518,099,93518,099,93518,099,93518,099,935Therefore applying above percentages to estimated annual mileage gives:Mileage undertaken by a diesel fuelled car (16.8%)3,040,7893,040,7893,040,7893,040,7893,040,789Mileage undertaken by a petrol fuelled car (83.2%)15,059,14615,059,14615,059,14615,059,14615,059,146Estimated for private cars on deliverykg CO2kg CO2kg CO2kg CO3kg CO4CO2 for diesel fuelled cars (16.8%)972,140821,013821,013821,013821,013CO2 for petrol fuelled cars (83.2%)5,077,9444,367,1524,367,1524,367,1524,367,152CO2 tonnes6,0505,1885,1885,1885,188UK split between petrol & diesel cars - 83.20% petrol, 16.80% diesel - from DTI/AEA Technology Rpt (2005)

conversion factor 0.3197 kgCO2/mile (Defra jun07)conversion factor 0.3372 kgCO2/mile (Defra Jun07)Judith.Odonnell:Figure from 200506 - source Simon M FrancisJudith.Odonnell:Figure from 200506 - source Simon M FrancisJudith.Odonnell:Conversion factor of 0.27kg CO2/mileJudith.Odonnell:Conversion factor of 0.29kg CO2/mileJudith.Odonnell:Figure from 200506 - source Simon M FrancisJudith.Odonnell:Conversion factor of 0.27kg CO2/mileJudith.Odonnell:Conversion factor of 0.29kg CO2/mile

CO2-0405Home to office commuter travel2006/07UK ave distance home > work (miles)Estimated total daily return mileageAverage RMG workforce over year - includes POL188,0608.53,197,020Transport modal splitSplit (%)Daily mileage by modeEstimated annual mileageEstimated CO2 tonnesCar, van, minibus, works van71.22,276,278514,438,882171,956conversion factors updated Defra jun07Motorbike, moped, scooter1.135,1677,947,7921,365new conversion factor Defra jun07Bicycle2.889,51720,230,7430Bus, coach, private bus7.6242,97454,912,0167,872Rail3.7118,29026,733,4812,589new conversion factor Defra jun07Underground, light railway, tram2.476,72817,340,6361,814new conversion factor Defra jun07Foot10.6338,88476,587,8110Other0.619,1824,335,1590Total1003,197,020722,526,520185,5972005/06Current RMG workforce - 2005/06195,9608.53,331,320CO2 tonnes - new 07 factorsCO2 tonnes - prev factorsCar, van, minibus, works van71.22,371,900536,049,364179,180153,653Motorbike, moped, scooter1.136,6458,281,6621,4231,663Bicycle2.893,27721,080,59300Bus, coach, private bus7.6253,18057,218,7528,20314,041Rail3.7123,25927,856,4982,6981,793Underground, light railway, tram2.479,95218,069,0801,8901,163Foot10.6353,12079,805,10200Other0.619,9884,517,27000Total1003,331,320752,878,320193,394172,3122004/05Average RMG workforce over year - includes POL195,9738.53,331,541Car, van, minibus, works van71.22,372,057536,084,925179,192153,663Motorbike, moped, scooter1.136,6478,282,2111,4231,663Bicycle2.893,28321,081,99100Bus, coach, private bus7.6253,19757,222,5488,20414,042Rail3.7123,26727,858,3462,6981,793Underground, light railway, tram2.479,95718,070,2781,8901,163Foot10.6353,14379,810,39600Other0.619,9894,517,57000Total1003,331,541752,928,266193,406172,3242003/04Average RMG workforce over year - includes POL195,9738.53,331,541Car, van, minibus, works van71.22,372,057536,084,925179,192153,663Motorbike, moped, scooter1.136,6478,282,2111,4231,663Bicycle2.893,28321,081,99100Bus, coach, private bus7.6253,19757,222,5488,20414,042Rail3.7123,26727,858,3462,6981,793Underground, light railway, tram2.479,95718,070,2781,8901,163Foot10.6353,14379,810,39600Other0.619,9894,517,57000Total1003,331,541752,928,266193,406172,3242002/03Average RMG workforce over year - includes POL195,9738.53,331,541Car, van, minibus, works van71.22,372,057536,084,925179,192153,663Motorbike, moped, scooter1.136,6478,282,2111,4231,663Bicycle2.893,28321,081,99100Bus, coach, private bus7.6253,19757,222,5488,20414,042Rail3.7123,26727,858,3462,6981,793Underground, light railway, tram2.479,95718,070,2781,8901,163Foot10.6353,14379,810,39600Other0.619,9894,517,57000Total1003,331,541752,928,266193,406172,324The modal split is taken from Office National Statistics website - 'Main methods of travel to work, autumn 2002'http://www.statistics.gov.uk/STATBASE/ssdataset.asp?vlnk=7805nb - the modal split for RMG employees may be significantly different to the UK average given the shift system operated within Operations.It is also expected that the bicycle figure will be higher than averageUK wholly owned businesses only

simon.francis:Source - Office National Statistics/Dept for Transport - Travel to work in GB; Personal Travel Factsheet 3 June 2003simon.francis:Calculation based on petrol & diesel car conversion factors - as worst case scenarios. Recognise vans, minibuses etc should be included, but conversion factors unavailable at this stage. Hence the usage of worst case scenario figures.simon.francis:Calculated using NAEI conversion factors from UK Emission Factor Database. For buses, on an urban cycle, 374g of CARBON are emitted per 1km. Assumed that on average 9 people travel per journey (figure from Hansard) - hence divided by 9 to get RMG related emissions.simon.francis:Calculated using NAEI conversion factors from UK Emission Factor Database. For motorbikes, on an urban cycle, 34g (0.034kg) of CARBON are emitted per 1km.simon.francis:Source - Office National Statistics/Dept for Transport - Travel to work in GB; Personal Travel Factsheet 3 June 2003simon.francis:Calculation based on petrol & diesel car conversion factors - as worst case scenarios. Recognise vans, minibuses etc should be included, but conversion factors unavailable at this stage. Hence the usage of worst case scenario figures.simon.francis:Calculated using NAEI conversion factors from UK Emission Factor Database. For motorbikes, on an urban cycle, 34g (0.034kg) of CARBON are emitted per 1km.simon.francis:Calculated using NAEI conversion factors from UK Emission Factor Database. For buses, on an urban cycle, 374g of CARBON are emitted per 1km. Assumed that on average 9 people travel per journey (figure from Hansard) - hence divided by 9 to get RMG related emissions.simon.francis:Source - Office National Statistics/Dept for Transport - Travel to work in GB; Personal Travel Factsheet 3 June 2003Judith.Odonnell:average from end of year Source: CSRDatawarehouse-P12-P13-Q4_2006-07simon.francis:Assumed RMG employees work average 226 days per yr (5dpw,47wks pr yr, 9b/h)simon.francis:Calculation based on petrol & diesel car conversion factors - as worst case scenarios. Recognise vans, minibuses etc should be included, but conversion factors unavailable at this stage. Hence the usage of worst case scenario figures.Judith.Odonnell:average petrol = 0.3372average diesel = 0.3197simon.francis:Previously calculated using NAEI conversion factors from UK Emission Factor Database. For motorbikes, on an urban cycle, 34g (0.034kg) of CARBON are emitted per 1km.Latest calculation uses average petrol bike conversion figure from Defra Jun07 of 0.1718simon.francis:Previously calculated using NAEI conversion factors from UK Emission Factor Database. For buses, on an urban cycle, 374g of CARBON are emitted per 1km. Assumed that on average 9 people travel per journey (figure from Hansard) - hence divided by 9 to get RMG related emissions.Revised calculation uses Defra Jun07 conversion of 0.0891 per passenger kmJudith.Odonnell:Defra jnu07 factor is 0.0602 for national railJudith.Odonnell:new conversion figures separate out light rail at 0.0650 and underground at 0.0526 - therefore used light rail as worst case scenario as difference is both unknown and minimalJudith.Odonnell:Average of total SIP inc POL. Source: Reference Data Safety 0405finalJudith.Odonnell:CSRDatawarehouse-P12-13_2005-06 gives average for year of 196,005simon.francis:Calculation based on petrol & diesel car conversion factors - as worst case scenarios. Recognise vans, minibuses etc should be included, but conversion factors unavailable at this stage. Hence the usage of worst case scenario figures.simon.francis:Previously calculated using NAEI conversion factors from UK Emission Factor Database. For motorbikes, on an urban cycle, 34g (0.034kg) of CARBON are emitted per 1km.Latest calculation uses average petrol bike conversion figure from Defra Jun07 of 0.1718simon.francis:Previously calculated using NAEI conversion factors from UK Emission Factor Database. For buses, on an urban cycle, 374g of CARBON are emitted per 1km. Assumed that on average 9 people travel per journey (figure from Hansard) - hence divided by 9 to get RMG related emissions.Revised calculation uses Defra Jun07 conversion of 0.0891 per passenger kmJudith.Odonnell:Defra jnu07 factor is 0.0602 for national railJudith.Odonnell:new conversion figures separate out light rail at 0.0650 and underground at 0.0526 - therefore used light rail as worst case scenario as difference is both unknown and minimalsimon.francis:Calculation based on petrol & diesel car conversion factors - as worst case scenarios. Recognise vans, minibuses etc should be included, but conversion factors unavailable at this stage. Hence the usage of worst case scenario figures.simon.francis:Previously calculated using NAEI conversion factors from UK Emission Factor Database. For motorbikes, on an urban cycle, 34g (0.034kg) of CARBON are emitted per 1km.Latest calculation uses average petrol bike conversion figure from Defra Jun07 of 0.1718simon.francis:Previously calculated using NAEI conversion factors from UK Emission Factor Database. For buses, on an urban cycle, 374g of CARBON are emitted per 1km. Assumed that on average 9 people travel per journey (figure from Hansard) - hence divided by 9 to get RMG related emissions.Revised calculation uses Defra Jun07 conversion of 0.0891 per passenger kmJudith.Odonnell:Defra jnu07 factor is 0.0602 for national railJudith.Odonnell:new conversion figures separate out light rail at 0.0650 and underground at 0.0526 - therefore used light rail as worst case scenario as difference is both unknown and minimalJudith.Odonnell:Average of total SIP inc POL. Source: Reference Data Safety 0405finalsimon.francis:Source - Office National Statistics/Dept for Transport - Travel to work in GB; Personal Travel Factsheet 3 June 2003simon.francis:Calculation based on petrol & diesel car conversion factors - as worst case scenarios. Recognise vans, minibuses etc should be included, but conversion factors unavailable at this stage. Hence the usage of worst case scenario figures.simon.francis:Calculation based on petrol & diesel car conversion factors - as worst case scenarios. Recognise vans, minibuses etc should be included, but conversion factors unavailable at this stage. Hence the usage of worst case scenario figures.simon.francis:Previously calculated using NAEI conversion factors from UK Emission Factor Database. For motorbikes, on an urban cycle, 34g (0.034kg) of CARBON are emitted per 1km.Latest calculation uses average petrol bike conversion figure from Defra Jun07 of 0.1718simon.francis:Calculated using NAEI conversion factors from UK Emission Factor Database. For motorbikes, on an urban cycle, 34g (0.034kg) of CARBON are emitted per 1km.simon.francis:Previously calculated using NAEI conversion factors from UK Emission Factor Database. For buses, on an urban cycle, 374g of CARBON are emitted per 1km. Assumed that on average 9 people travel per journey (figure from Hansard) - hence divided by 9 to get RMG related emissions.Revised calculation uses Defra Jun07 conversion of 0.0891 per passenger kmsimon.francis:Calculated using NAEI conversion factors from UK Emission Factor Database. For buses, on an urban cycle, 374g of CARBON are emitted per 1km. Assumed that on average 9 people travel per journey (figure from Hansard) - hence divided by 9 to get RMG related emissions.Judith.Odonnell:Defra jnu07 factor is 0.0602 for national railJudith.Odonnell:new conversion figures separate out light rail at 0.0650 and underground at 0.0526 - therefore used light rail as worst case scenario as difference is both unknown and minimalJudith.Odonnell:Average of total SIP inc POL. Source: Reference Data Safety 0405finalsimon.francis:Source - Office National Statistics/Dept for Transport - Travel to work in GB; Personal Travel Factsheet 3 June 2003simon.francis:Calculation based on petrol & diesel car conversion factors - as worst case scenarios. Recognise vans, minibuses etc should be included, but conversion factors unavailable at this stage. Hence the usage of worst case scenario figures.simon.francis:Calculation based on petrol & diesel car conversion factors - as worst case scenarios. Recognise vans, minibuses etc should be included, but conversion factors unavailable at this stage. Hence the usage of worst case scenario figures.simon.francis:Previously calculated using NAEI conversion factors from UK Emission Factor Database. For motorbikes, on an urban cycle, 34g (0.034kg) of CARBON are emitted per 1km.Latest calculation uses average petrol bike conversion figure from Defra Jun07 of 0.1718simon.francis:Calculated using NAEI conversion factors from UK Emission Factor Database. For motorbikes, on an urban cycle, 34g (0.034kg) of CARBON are emitted per 1km.simon.francis:Previously calculated using NAEI conversion factors from UK Emission Factor Database. For buses, on an urban cycle, 374g of CARBON are emitted per 1km. Assumed that on average 9 people travel per journey (figure from Hansard) - hence divided by 9 to get RMG related emissions.Revised calculation uses Defra Jun07 conversion of 0.0891 per passenger kmsimon.francis:Calculated using NAEI conversion factors from UK Emission Factor Database. For buses, on an urban cycle, 374g of CARBON are emitted per 1km. Assumed that on average 9 people travel per journey (figure from Hansard) - hence divided by 9 to get RMG related emissions.Judith.Odonnell:Defra jnu07 factor is 0.0602 for national railJudith.Odonnell:new conversion figures separate out light rail at 0.0650 and underground at 0.0526 - therefore used light rail as worst case scenario as difference is both unknown and minimal

CO2-0506Royal Mail sheet - NB don't change formats, just data in yellow cellsYellow cells are source data or linked source dataGreen cells are secondary links or formulasScopeCO2 emissions by source2002/032003/042004/052005/062006/0741.6%Scope 1 Business road386,457.5387,606.5391,650.5368,487.3354,540.210.9%Scope 1 Natural gas and oil106,673.8116,297.4124,022.0107,829.792,992.417.7%Scope 2 Grid electricity135,808.2135,552.8131,950.9128,880.6150,317.78.0%Scope 3 Business air & rail122,562.0101,499.679,468.173,798.968,216.81.2%Scope 3 Personal road9,655.38,110.17,263.29,010.210,107.00.2%Scope 3 Personal air & rail1,336.71,336.71,266.61,242.41,480.019.7%Scope 3 Commuting to work155,884.1155,884.1155,884.1155,873.8167,891.10.7%Scope 3 Authorised cars on delivery5,188.25,188.25,188.25,188.26,050.1Total CO2 in tonnes923,565.9911,475.4896,693.6850,311.1851,595.3Commuting and Cars on Delivery161,072.3161,072.3161,072.3161,062.0173,941.2Total without Commuting and Cars on Delivery (as in CSR Reports 0506 & 0405)762,493.6750,403.1735,621.3689,249.1677,654.1%Carbon dioxide emissions by scope (reported from 2006/07)2002/032003/042004/052005/062006/0752.6%Scope 1 - DIRECT493,131503,904515,672476,317447,53317.7%Scope 2 - INDIRECT135,808135,553131,951128,881150,31829.8%Scope 3 - INDIRECT294,626272,019249,070245,114253,745100%923,566911,475896,694850,311851,595ScopeCO2 emissions (tonnes) from energy consumption2002/032003/042004/052005/062006/071Gas oil5,787.54,383.54,6073,5364,903.41Natural gas100,886.3111,913.8119,415104,29388,088.92Grid electricity135,808.2135,552.8131,951128,881150,317.7Total (externally generated)242,482.0251,850.1255,972.9236,710.3243,310.1CO2 emissions (tonnes) from transport2002/032003/042004/052005/062006/077.6%Business Air65,772.067,825.278,22171,13664,5480.4%Business Rail56,790.033,674.41,2472,6633,66941.6%Business Road386,457.5387,606.5391,650368,487354,5400.1%Personal Air1,088.51,088.51,0579811,1000.0%Personal Rail248.3248.32102613801.2%Personal Road9,655.38,110.17,2639,01010,1070.7%Private cars on delivery5,188.25,188.25,188.25,188.26,050.119.7%Commuting to work155,884.1155,884.1155,884.1155,873.8167,891.149.6%Business fleet air/rail/road kg CO2 - total509,020489,106471,119442,286422,7571.4%Personal air/rail/road CO2 (for business travel) - tonnes10,9929,4478,53010,25311,58751.0%Total travel excluding private usage520,012498,553479,648452,539434,34471.4%Total travel - including private usage681,084659,625640,721613,601608,285Summary - CO2 tonnes41.6%Business (fleet) road CO2 - scope 1386,457.5387,606.5391,650.5368,487.3354,540.28.0%Business (fleet) air/rail CO2 - scope 3122,562.0101,499.679,468.173,798.968,216.81.4%Personal road/rail/air CO2 (for business travel) - scope 310,992.19,446.98,529.810,252.611,586.917.7%Private travel emissions - scope 3161,072.3161,072.3161,072.3161,062.0173,941.228.6%Building energy use - scope 1 & 2242,482.0251,850.1255,972.9236,710.3243,310.1100%Tonnes CO2923,565.9911,475.4896,693.6850,311.1851,595.3Scope 1 - fleet road only, buildings gas + oil - DIRECTScope 2 - electricity (generated on our behalf) - INDIRECTScope 3 - all rail/air, personal business miles, commuting, cars on delivery - INDIRECTPerformanceIndirect gaseous emissions (tonnes) from building enery usage2002/032003/042004/052005/062006/07SO2NOxCOVOCCH4

CO2-050600000000

CO2 emissions by sourceLetters Carbon dioxide emissions by source & scope 2006/07

BldEnergy060700000000

Judith.Odonnell:input values for chart to updateJudith.Odonnell:N4O = Nitrous Oxide, as presumably does NOxJudith.Odonnell:MethaneJudith.Odonnell:Volatile Organic CompoundsJudith.Odonnell:Carbon MonoxideJudith.Odonnell:Sulfur DioxideJudith.Odonnell:25,634,744 litres of fuel, source Howard F Morris. Defra conversion factor jun 07 x2.518Judith.Odonnell:7,014,414 kWh Source: Simon M Francis (extra coach since Feb 07 - updated rail sheet in 06/07 CO2 calculator spreadsheet). Defra Jun 07 factor = 0.523Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportScope 1 - DIRECTScope 2 - INDIRECTScope 3 - INDIRECTCO2 tonnesLetters CO2 emissions (tonnes) by Scope000000000CO2 emissions by sourceLetters Carbon dioxide emissions by source & scope 2005/06

BldEnergy050600000000

CO2 emissions by sourceLetters Carbon dioxide emissions by source & scope 2004/05

000000000000000000000

Scope 1 Business roadScope 1 Natural gas and oilScope 2 Grid electricityScope 3 Commuting to workScope 3 Business air & railScope 3 Personal roadScope 3 Personal air & railLetters Carbon dioxide emissions (tonnes) by source

Parcelforce sheet - NB don't change formats, just data in yellow cellsYellow cells are source data or linked source dataBright yellow cells have been updated for BUGreen cells are secondary links or formulasScopeCO2 emissions by source2002/032003/042004/052005/062006/0735.0%Scope 1 Business road25,763.825,840.426,110.024,565.823,636.021.6%Scope 1 Natural gas and oil16,729.818,239.119,450.616,911.114,584.134.9%Scope 2 Grid electricity21,299.021,258.920,694.120,212.523,574.52.2%Scope 3 Personal road1,413.81,187.51,063.51,319.31,473.60.3%Scope 3 Personal air & rail195.7195.7185.5181.9216.76.0%Scope 3 Commuting to work3,791.13,791.13,791.13,790.94,083.10.0%Scope 3 Authorised cars on delivery0.00.00.00.00.0Total CO2 in tonnes69,193.270,512.871,294.766,981.567,568.2Commuting and Cars on Delivery3,791.13,791.13,791.13,790.94,083.1Total without Commuting and Cars on Delivery (as in CSR Reports 0506 & 0405)65,402.166,721.767,503.663,190.763,485.0%Carbon dioxide emissions by scope (reported from 2006/07)2002/032003/042004/052005/062006/0756.6%Scope 1 - DIRECT42,49444,08045,56141,47738,22034.9%Scope 2 - INDIRECT21,29921,25920,69420,21323,5758.5%Scope 3 - INDIRECT5,4015,1745,0405,2925,773100%69,19370,51371,29566,98267,568ScopeCO2 emissions (tonnes) from energy consumption2002/032003/042004/052005/062006/071Gas oil907.7687.5723555769.01Natural gas15,822.117,551.618,72816,35613,815.12Grid electricity21,299.021,258.920,69420,21323,574.5Total (externally generated)38,028.839,498.040,144.637,123.638,158.7CO2 emissions (tonnes) from transport2002/032003/042004/052005/062006/070.0%Business Air0.0%Business Rail35.0%Business Road25,763.825,840.426,11024,56623,6360.2%Personal Air159.4159.41551441610.1%Personal Rail36.436.43138562.2%Personal Road1,413.81,187.51,0631,3191,474Private cars on delivery6.0%Commuting to work3,791.13,791.13,791.13,790.94,083.135.0%Business fleet air/rail/road kg CO2 - total25,76425,84026,11024,56623,6362.5%Personal air/rail/road CO2 (for business travel) - tonnes1,6091,3831,2491,5011,69037.5%Total travel excluding private usage27,37327,22427,35926,06725,32643.5%Total travel - including private usage31,16431,01531,15029,85829,409Summary - CO2 tonnes35.0%Business (fleet) road CO2 - scope 125,763.825,840.426,110.024,565.823,636.00.0%Business (fleet) air/rail CO2 - scope 30.00.00.00.00.02.5%Personal road/rail/air CO2 (for business travel) - scope 31,609.51,383.21,248.91,501.21,690.334.9%Private travel emissions - scope 33,791.13,791.13,791.13,790.94,083.156.5%Building energy use - scope 1 & 238,028.839,498.040,144.637,123.638,158.7100%Tonnes CO269,193.270,512.871,294.766,981.567,568.2Scope 1 - fleet road only, buildings gas + oil - DIRECTScope 2 - electricity (generated on our behalf) - INDIRECTScope 3 - all rail/air, personal business miles, commuting, cars on delivery - INDIRECTPerformanceIndirect gaseous emissions (tonnes) from building enery usage2002/032003/042004/052005/062006/07SO2NOxCOVOCCH4

Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Simon Francis indicated where factors fit within 3 scopes of emissionsJudith.Odonnell:Conversion of miles to kilometres = 1.609Judith.Odonnell:Inc biodiesel percentage. Calculation was for fuel consumed in year 06/07, but fuel purchased in previous yearsJudith.Odonnell:Use short haul factorJudith.Odonnell:Factor in pkmJudith.Odonnell:Not applicable except to RMLJudith.Odonnell:148,058,089 total diesel. RML = 91.05% of total. Source Cathy Braithwaite - VolumebyBusinessDefra factor Jun 07 x 2.63. Biodiesel element of 33,412 included in total and discounted for 91.05%Judith.Odonnell:SIP: RML = 90.5; PFW = 2.2; CF = 1.7; POL = 5.7Judith.Odonnell:51,995,867 total:41,125,111 miles claimed through T&S, report PRT540 from MyPeople (through Simon M Francis) excludes POL, excepting 36,05110,870,756 miles claimed through T&S, report from Steve S Reeves for POL only. 36,051 to be added to this for POL breakdown.Split on (national?) company car profile of diesel 80.1, petrol 19.9% Defra diesel factor x0.3197; petrol factor x0.3372PFW = 4,559,791; RML = 31,273,228; POL = 10,906,807; CF = 5,256,041Judith.Odonnell:Short Haul Factor 0.1304*109% to account for 'circling'. 23,951 flights (sectors), total milage 8,001,653. Source [email protected]% split for BUs as for road miles, i.e.PFW = 8.8; RM = 60.1; POL = 21; CF = 10.1Judith.Odonnell:factor from defra jun07 for national rail 0.0602 which is between light rail and underground. 64,957 sectors, total milage 6,530,689. Source [email protected]% split for BUs as for road miles, i.e.PFW = 8.8; RM = 60.1; POL = 21; CF = 10.1Defra litres conversion is 2.674, but we are using kwh conversion ofx0.251 as this applies consistency to energy figures, and a higher CO2 value results (thus not underestimating footprint). Conversion from litres to kwh of 11.69 is from Carbon Trust.Using percentage splits for Electricity usage by building owner:RML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76Judith.Odonnell:Revised Electricity factor Jun 07 x0.523 - using factor for brown, not green & not restating previous years' usageRML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76Judith.Odonnell:Gas Defra factor x0.185Using percentages for Electricity split:RML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76

000000

CO2 emissions by sourcePFW Carbon dioxide emissions by source & scope 2006/07

000000

Judith.Odonnell:input values for chart to updateJudith.Odonnell:N4O = Nitrous Oxide, as presumably does NOxJudith.Odonnell:MethaneJudith.Odonnell:Volatile Organic CompoundsJudith.Odonnell:Carbon MonoxideJudith.Odonnell:Sulfur DioxideJudith.Odonnell:factor from defra jun07 for national rail 0.0602 which is between light rail and underground. 64,957 sectors, total milage 6,530,689. Source [email protected]% split for BUs as for road miles, i.e.PFW = 8.8; RM = 60.1; POL = 21; CF = 10.1Judith.Odonnell:Short Haul Factor 0.1304*109% to account for 'circling'. 23,951 flights (sectors), total milage 8,001,653. Source [email protected]% split for BUs as for road miles, i.e.PFW = 8.8; RM = 60.1; POL = 21; CF = 10.1Judith.Odonnell:25,634,744 litres of fuel, source Howard F Morris. Defra conversion factor jun 07 x2.518Judith.Odonnell:7,014,414 kWh Source: Simon M Francis (extra coach since Feb 07 - updated rail sheet in 06/07 CO2 calculator spreadsheet). Defra Jun 07 factor = 0.523Judith.Odonnell:51,995,867 total:41,125,111 miles claimed through T&S, report PRT540 from MyPeople (through Simon M Francis) excludes POL, excepting 36,05110,870,756 miles claimed through T&S, report from Steve S Reeves for POL only. 36,051 to be added to this for POL breakdown.Split on (national?) company car profile of diesel 80.1, petrol 19.9% Defra diesel factor x0.3197; petrol factor x0.3372PFW = 4,559,791; RML = 31,273,228; POL = 10,906,807; CF = 5,256,041Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportScope 1 - DIRECTScope 2 - INDIRECTScope 3 - INDIRECTCO2 tonnesPFW CO2 emissions (tonnes) by Scope000000000CO2 emissions by sourcePFW Carbon dioxide emissions by source & scope 2005/06

000000

CO2 emissions by sourcePFW Carbon dioxide emissions by source & scope 2004/05

000000000000000000

Scope 1 Business roadScope 1 Natural gas and oilScope 2 Grid electricityScope 3 Commuting to workScope 3 Personal roadScope 3 Personal air & railPFW Carbon dioxide emissions (tonnes) by source

Post Office Ltd sheet - NB don't change formats, just data in yellow cellsYellow cells are source data or linked source dataGreen cells are secondary links or formulasScopeCO2 emissions by source2002/032003/042004/052005/062006/0722.9%Scope 1 Business road12,224.012,260.412,388.311,655.611,214.518.1%Scope 1 Natural gas and oil10,208.011,128.911,868.110,318.68,898.829.3%Scope 2 Grid electricity12,996.012,971.612,626.912,333.114,384.57.2%Scope 3 Personal road3,373.72,833.82,537.93,148.33,524.91.1%Scope 3 Personal air & rail467.1467.1442.6434.1517.121.4%Scope 3 Commuting to work9,753.59,753.59,753.59,752.910,504.80.0%Scope 3 Authorised cars on delivery0.00.00.00.00.0Total CO2 in tonnes49,022.449,415.349,617.347,642.649,044.5Commuting and Cars on Delivery9,753.59,753.59,753.59,752.910,504.8Total without Commuting and Cars on Delivery (as in CSR Reports 0506 & 0405)39,268.939,661.839,863.837,889.838,539.7%Carbon dioxide emissions by scope (reported from 2006/07)2002/032003/042004/052005/062006/0741.0%Scope 1 - DIRECT22,43223,38924,25621,97420,11329.3%Scope 2 - INDIRECT12,99612,97212,62712,33314,38429.7%Scope 3 - INDIRECT13,59413,05412,73413,33514,547100%49,02249,41549,61747,64349,045ScopeCO2 emissions (tonnes) from energy consumption2002/032003/042004/052005/062006/071Gas oil553.8419.5441338469.21Natural gas9,654.210,709.511,4279,9808,429.62Grid electricity12,996.012,971.612,62712,33314,384.5Total (externally generated)23,204.024,100.524,495.022,651.723,283.3CO2 emissions (tonnes) from transport2002/032003/042004/052005/062006/070.0%Business Air0.0%Business Rail22.9%Business Road12,224.012,260.412,38811,65611,2140.8%Personal Air380.3380.33693433840.3%Personal Rail86.786.773911337.2%Personal Road3,373.72,833.82,5383,1483,5250.0%Private cars on delivery21.4%Commuting to work9,753.59,753.59,753.59,752.910,504.822.9%Business fleet air/rail/road kg CO2 - total12,22412,26012,38811,65611,2148.2%Personal air/rail/road CO2 (for business travel) - tonnes3,8413,3012,9803,5824,04231.1%Total travel excluding private usage16,06515,56115,36915,23815,25652.5%Total travel - including private usage25,81825,31525,12224,99125,761Summary - CO2 tonnes22.9%Business (fleet) road CO2 - scope 112,224.012,260.412,388.311,655.611,214.50.0%Business (fleet) air/rail CO2 - scope 30.00.00.00.00.08.2%Personal road/rail/air CO2 (for business travel) - scope 33,840.83,300.92,980.43,582.54,042.029.3%Private travel emissions - scope 39,753.59,753.59,753.59,752.910,504.847.5%Building energy use - scope 1 & 223,204.024,100.524,495.022,651.723,283.3100%Tonnes CO249,022.449,415.349,617.347,642.649,044.5Scope 1 - fleet road only, buildings gas + oil - DIRECTScope 2 - electricity (generated on our behalf) - INDIRECTScope 3 - all rail/air, personal business miles, commuting, cars on delivery - INDIRECTPerformanceIndirect gaseous emissions (tonnes) from building enery usage2002/032003/042004/052005/062006/07SO2NOxCOVOCCH4

Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Revised Electricity factor Jun 07 x0.523 - using factor for brown, not green & not restating previous years' usageRML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76Judith.Odonnell:Gas Defra factor x0.185Using percentages for Electricity split:RML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76Defra litres conversion is 2.674, but we are using kwh conversion ofx0.251 as this applies consistency to energy figures, and a higher CO2 value results (thus not underestimating footprint). Conversion from litres to kwh of 11.69 is from Carbon Trust.Using percentage splits for Electricity usage by building owner:RML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76Judith.Odonnell:Simon Francis indicated where factors fit within 3 scopes of emissionsJudith.Odonnell:Conversion of miles to kilometres = 1.609Judith.Odonnell:Inc biodiesel percentage. Calculation was for fuel consumed in year 06/07, but fuel purchased in previous yearsJudith.Odonnell:148,058,089 total diesel. PFW = 8,992,201.50 @ 6.07% of total. Source Cathy Braithwaite - VolumebyBusinessDefra factor Jun 07 x 2.63. Biodiesel element of 33,412 included in total and discounted for 6.07%Judith.Odonnell:Use short haul factorJudith.Odonnell:Factor in pkmJudith.Odonnell:Not applicable except to RMLJudith.Odonnell:SIP: RML = 90.5; PFW = 2.2; CF = 1.7; POL = 5.7

000000

CO2 emissions by sourcePOL Carbon dioxide emissions by source & scope 2006/07

000000

Judith.Odonnell:input values for chart to updateJudith.Odonnell:N4O = Nitrous Oxide, as presumably does NOxJudith.Odonnell:MethaneJudith.Odonnell:Volatile Organic CompoundsJudith.Odonnell:Carbon MonoxideJudith.Odonnell:Sulfur DioxideJudith.Odonnell:25,634,744 litres of fuel, source Howard F Morris. Defra conversion factor jun 07 x2.518Judith.Odonnell:7,014,414 kWh Source: Simon M Francis (extra coach since Feb 07 - updated rail sheet in 06/07 CO2 calculator spreadsheet). Defra Jun 07 factor = 0.523Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportScope 1 - DIRECTScope 2 - INDIRECTScope 3 - INDIRECTCO2 tonnesPOL CO2 emissions (tonnes) by Scope000000000CO2 emissions by sourcePOL Carbon dioxide emissions by source & scope 2005/06

000000

CO2 emissions by sourcePOL Carbon dioxide emissions by source & scope 2004/05

000000000000000000

Scope 1 Business roadScope 1 Natural gas and oilScope 2 Grid electricityScope 3 Commuting to workScope 3 Personal roadScope 3 Personal air & railPOL Carbon dioxide emissions (tonnes) by source

Central Functions sheet - NB don't change formats, just data in yellow cellsYellow cells are source data or linked source dataGreen cells are secondary links or formulasScopeCO2 emissions by source2002/032003/042004/052005/062006/070.0%Scope 1 Business road0.00.00.00.00.030.0%Scope 1 Natural gas and oil8,166.48,903.19,494.58,254.97,119.048.6%Scope 2 Grid electricity10,396.810,377.210,101.59,866.511,507.67.2%Scope 3 Personal road1,622.61,362.91,220.61,514.21,698.71.0%Scope 3 Personal air & rail224.6224.6212.8208.8248.713.2%Scope 3 Commuting to work2,895.02,895.02,895.02,894.83,118.00.0%Scope 3 Authorised cars on delivery0.00.00.00.00.0Total CO2 in tonnes23,305.523,763.023,924.522,739.223,692.0Commuting and Cars on Delivery2,895.02,895.02,895.02,894.83,118.0Total without Commuting and Cars on Delivery (as in CSR Reports 0506 & 0405)20,410.520,868.021,029.519,844.420,574.0%Carbon dioxide emissions by scope (reported from 2006/07)2002/032003/042004/052005/062006/0730.0%Scope 1 - DIRECT8,1668,9039,4958,2557,11948.6%Scope 2 - INDIRECT10,39710,37710,1029,86611,50821.4%Scope 3 - INDIRECT4,7424,4834,3284,6185,065100%23,30623,76323,92522,73923,692ScopeCO2 emissions (tonnes) from energy consumption2002/032003/042004/052005/062006/071Gas oil443.1335.6353271375.41Natural gas7,723.48,567.69,1427,9846,743.72Grid electricity10,396.810,377.210,1029,86611,507.6Total (externally generated)18,563.219,280.419,596.018,121.418,626.6CO2 emissions (tonnes) from transport2002/032003/042004/052005/062006/070.0%Business Air0.0%Business Rail0.0%Business Road0.8%Personal Air182.9182.91781651850.3%Personal Rail41.741.73544647.2%Personal Road1,622.61,362.91,2211,5141,6990.0%Private cars on delivery13.2%Commuting to work2,895.02,895.02,895.02,894.83,118.00.0%Business fleet air/rail/road kg CO2 - total000008.2%Personal air/rail/road CO2 (for business travel) - tonnes1,8471,5881,4331,7231,9478.2%Total travel excluding private usage1,8471,5881,4331,7231,94721.4%Total travel - including private usage4,7424,4834,3284,6185,065Summary - CO2 tonnes0.0%Business (fleet) road CO2 - scope 10.00.00.00.00.00.0%Business (fleet) air/rail CO2 - scope 30.00.00.00.00.08.2%Personal road/rail/air CO2 (for business travel) - scope 31,847.31,587.61,433.51,723.01,947.448.6%Private travel emissions - scope 32,895.02,895.02,895.02,894.83,118.078.6%Building energy use - scope 1 & 218,563.219,280.419,596.018,121.418,626.6100%Tonnes CO223,305.523,763.023,924.522,739.223,692.0Scope 1 - fleet road only, buildings gas + oil - DIRECTScope 2 - electricity (generated on our behalf) - INDIRECTScope 3 - all rail/air, personal business miles, commuting, cars on delivery - INDIRECTPerformanceIndirect gaseous emissions (tonnes) from building enery usage2002/032003/042004/052005/062006/07SO2NOxCOVOCCH4

Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Simon Francis indicated where factors fit within 3 scopes of emissionsJudith.Odonnell:Conversion of miles to kilometres = 1.609Judith.Odonnell:Inc biodiesel percentage. Calculation was for fuel consumed in year 06/07, but fuel purchased in previous yearsJudith.Odonnell:Use short haul factorJudith.Odonnell:Factor in pkmJudith.Odonnell:Not applicable except to RMLJudith.Odonnell:148,058,089 total diesel. POL = 2.88% of total. Source Cathy Braithwaite - VolumebyBusinessDefra factor Jun 07 x 2.63. Biodiesel element of 33,412 included in total and discounted for 2.88%Judith.Odonnell:SIP: RML = 90.5; PFW = 2.2; CF = 1.7; POL = 5.7Judith.Odonnell:51,995,867 total:41,125,111 miles claimed through T&S, report PRT540 from MyPeople (through Simon M Francis) excludes POL, excepting 36,05110,870,756 miles claimed through T&S, report from Steve S Reeves for POL only. 36,051 to be added to this for POL breakdown.Split on (national?) company car profile of diesel 80.1, petrol 19.9% Defra diesel factor x0.3197; petrol factor x0.3372PFW = 4,559,791; RML = 31,273,228; POL = 10,906,807; CF = 5,256,041Judith.Odonnell:Short Haul Factor 0.1304*109% to account for 'circling'. 23,951 flights (sectors), total milage 8,001,653. Source [email protected]% split for BUs as for road miles, i.e.PFW = 8.8; RM = 60.1; POL = 21; CF = 10.1Judith.Odonnell:factor from defra jun07 for national rail 0.0602 which is between light rail and underground. 64,957 sectors, total milage 6,530,689. Source [email protected]% split for BUs as for road miles, i.e.PFW = 8.8; RM = 60.1; POL = 21; CF = 10.1Defra litres conversion is 2.674, but we are using kwh conversion ofx0.251 as this applies consistency to energy figures, and a higher CO2 value results (thus not underestimating footprint). Conversion from litres to kwh of 11.69 is from Carbon Trust.Using percentage splits for Electricity usage by building owner:RML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76Judith.Odonnell:Revised Electricity factor Jun 07 x0.523 - using factor for brown, not green & not restating previous years' usageRML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76Judith.Odonnell:Gas Defra factor x0.185Using percentages for Electricity split:RML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76

000000

CO2 emissions by sourceCentral Functions carbon dioxide emissions by source & scope 2006/07

000000

Judith.Odonnell:input values for chart to updateJudith.Odonnell:N4O = Nitrous Oxide, as presumably does NOxJudith.Odonnell:MethaneJudith.Odonnell:Volatile Organic CompoundsJudith.Odonnell:Carbon MonoxideJudith.Odonnell:Sulfur DioxideJudith.Odonnell:25,634,744 litres of fuel, source Howard F Morris. Defra conversion factor jun 07 x2.518Judith.Odonnell:7,014,414 kWh Source: Simon M Francis (extra coach since Feb 07 - updated rail sheet in 06/07 CO2 calculator spreadsheet). Defra Jun 07 factor = 0.523Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportScope 1 - DIRECTScope 2 - INDIRECTScope 3 - INDIRECTCO2 tonnesCentral Functions CO2 emissions (tonnes) by Scope000000000CO2 emissions by sourceCentral Functions carbon dioxide emissions by source & scope 2005/06

000000

CO2 emissions by sourceCentral Functions carbon dioxide emissions by source & scope 2004/05

000000000000000

Scope 1 Natural gas and oilScope 2 Grid electricityScope 3 Commuting to workScope 3 Personal roadScope 3 Personal air & railCentral Functions carbon dioxide emissions (tonnes) by source

Totals sheet - NB don't change formats - all cells should equal RMG sheetScopeCO2 emissions by source2002/032003/042004/052005/062006/0739.3%Scope 1 Business road424,445.4425,707.3430,148.8404,708.7389,390.712.5%Scope 1 Natural gas and oil141,778.0154,568.5164,835.2143,314.3123,594.320.1%Scope 2 Grid electricity180,500.0180,160.5175,373.4171,292.7199,784.36.9%Scope 3 Business air & rail128,972.1106,883.984,290.173,798.968,216.81.7%Scope 3 Personal road16,065.413,494.412,085.214,992.116,804.20.2%Scope 3 Personal air & rail2,224.22,224.22,107.42,067.22,462.518.7%Scope 3 Commuting to work172,323.8172,323.8172,323.8172,312.4185,597.10.6%Scope 3 Authorised cars on delivery5,188.25,188.25,188.25,188.26,050.1Total CO2 in tonnes1,065,087.01,055,166.61,041,530.1987,674.5991,900.0Commuting and Cars on Delivery177,512.0177,512.0177,512.0177,500.6191,647.2Total without Commuting and Cars on Delivery (as in CSR Reports 0506 & 0405)887,575.0877,654.6864,018.1810,173.9800,252.8885,351.0Difference for 02/03 is for personal air and rail, which is an estimate using figures from 03/042,224.0%Carbon dioxide emissions by scope (reported from 2006/07)2002/032003/042004/052005/062006/0751.7%Scope 1 - DIRECT566,223580,276594,984548,023512,98520.1%Scope 2 - INDIRECT180,500180,161175,373171,293199,78428.1%Scope 3 - INDIRECT318,364294,730271,173268,359279,131100%1,065,0871,055,1671,041,530987,674991,900ScopeCO2 emissions (tonnes) from energy consumption2002/032003/042004/052005/062006/071Gas oil7,692.05,826.16,1234,7006,517.11Natural gas134,086.0148,742.5158,712138,614117,077.32Grid electricity180,500.0180,160.5175,373171,293199,784.3Total (externally generated)322,278.0334,729.1340,208.6314,607.0323,378.6CO2 emissions (tonnes) from transport2002/032003/042004/052005/062006/076.5%Business Air65,772.067,825.278,22171,13664,5480.4%Business Rail56,790.033,674.41,2472,6633,66939.3%Business Road424,445.4425,707.3430,149404,709389,3910.2%Personal Air1,811.11,811.11,7581,6321,8300.1%Personal Rail413.1413.13494356331.7%Personal Road16,065.413,494.412,08514,99216,804Private cars on delivery5,188.25,188.25,188.25,188.26,050.118.7%Commuting to work172,323.8172,323.8172,323.8172,312.4185,597.146.1%Business fleet air/rail/road kg CO2 - total547,007527,207509,617478,508457,6081.9%Personal air/rail/road CO2 (for business travel) - tonnes18,29015,71914,19317,05919,26748.1%Total travel excluding private usage565,297542,926523,809495,567476,87467.4%Total travel - including private usage742,809720,438701,321673,067668,521Summary - CO2 tonnes39.3%Business (fleet) road CO2 - scope 1424,445.4425,707.3430,148.8404,708.7389,390.76.9%Business (fleet) air/rail CO2 - scope 3122,562.0101,499.679,468.173,798.968,216.81.9%Personal road/rail/air CO2 (for business travel) - scope 318,289.615,718.614,192.617,059.319,266.720.1%Private travel emissions - scope 3177,512.0177,512.0177,512.0177,500.6191,647.232.6%Building energy use - scope 1 & 2322,278.0334,729.1340,208.6314,607.0323,378.6100%Tonnes CO21,065,087.01,055,166.61,041,530.1987,674.5991,900.0Scope 1 - fleet road only, buildings gas + oil - DIRECTScope 2 - electricity (generated on our behalf) - INDIRECTScope 3 - all rail/air, personal business miles, commuting, cars on delivery - INDIRECTPerformanceIndirect gaseous emissions (tonnes) from building enery usage2002/032003/042004/052005/062006/07SO23,880.63,906.73,805.43,756.83,561.9NOx998.41,031.31,033.9980.0909.0CO527.8532.6519.3512.3484.7VOC13.413.913.913.212.2CH40.20.20.20.20.1

Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Simon Francis indicated where factors fit within 3 scopes of emissionsJudith.Odonnell:Conversion of miles to kilometres = 1.609Judith.Odonnell:Inc biodiesel percentage. Calculation was for fuel consumed in year 06/07, but fuel purchased in previous yearsJudith.Odonnell:148,058,089 total diesel. Source Cathy Braithwaite. Defra factor Jun 07 x 2.63. Biodiesel element of 33,412 included in total and discountedJudith.Odonnell:Use short haul factorJudith.Odonnell:Factor in pkmJudith.Odonnell:Not applicable except to RMLJudith.Odonnell:SIP: RML = 90.5; PFW = 2.2; CF = 1.7; POL = 5.7Judith.Odonnell:51,995,867 total:41,125,111 miles claimed through T&S, report PRT540 from MyPeople (through Simon M Francis) excludes POL, excepting 36,05110,870,756 miles claimed through T&S, report from Steve S Reeves for POL only. 36,051 to be added to this for POL breakdown.Split on (national?) company car profile of diesel 80.1, petrol 19.9% Defra diesel factor x0.3197; petrol factor x0.3372PFW = 4,559,791; RML = 31,273,228; POL = 10,906,807; CF = 5,256,041Judith.Odonnell:Short Haul Factor 0.1304*109% to account for 'circling'. 23,951 flights (sectors), total milage 8,001,653. Source [email protected]% split for BUs as for road miles, i.e.PFW = 8.8; RM = 60.1; POL = 21; CF = 10.1Judith.Odonnell:factor from defra jun07 for national rail 0.0602 which is between light rail and underground. 64,957 sectors, total milage 6,530,689. Source [email protected]% split for BUs as for road miles, i.e.PFW = 8.8; RM = 60.1; POL = 21; CF = 10.1Defra litres conversion is 2.674, but we are using kwh conversion ofx0.251 as this applies consistency to energy figures, and a higher CO2 value results (thus not underestimating footprint). Conversion from litres to kwh of 11.69 is from Carbon Trust.Using percentage splits for Electricity usage by building owner:RML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76Judith.Odonnell:Revised Electricity factor Jun 07 x0.523 - using factor for brown, not green & not restating previous years' usageRML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76Judith.Odonnell:Gas Defra factor x0.185Using percentages for Electricity split:RML = 75.24%PFW = 11.8%POL = 7.2%CF = 5.76Judith.Odonnell:input values for chart to updateJudith.Odonnell:N4O = Nitrous Oxide, as presumably does NOxJudith.Odonnell:MethaneJudith.Odonnell:Volatile Organic CompoundsJudith.Odonnell:Carbon MonoxideJudith.Odonnell:Sulfur DioxideJudith.Odonnell:factor from defra jun07 for national rail 0.0602 which is between light rail and underground. 64,957 sectors, total milage 6,530,689. Source [email protected]:Short Haul Factor 0.1304*109% to account for 'circling'. 23,951 flights (sectors), total milage 8,001,653. Source [email protected]:25,634,744 litres of fuel, source Howard F Morris. Defra conversion factor jun 07 x2.518Judith.Odonnell:7,014,414 kWh Source: Simon M Francis (extra coach since Feb 07 - updated rail sheet in 06/07 CO2 calculator spreadsheet). Defra Jun 07 factor = 0.523Judith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Split by petrol 83.2, diesel 16.8 - Dti reportJudith.Odonnell:Revised Electricity factor Jun 07 x0.523 - using factor for brown, not green & not restating previous years' usageJudith.Odonnell:Gas Defra factor x0.185Defra litres conversion is 2.674, but we are using kwh conversion ofx0.251 as this applies consistency to energy figures, and a higher CO2 value results (thus not underestimating footprint). Conversion from litres to kwh of 11.69 is from Carbon Trust.Judith.Odonnell:Simon Francis indicated where factors fit within 3 scopes of emissionsJudith.Odonnell:Conversion of miles to kilometres = 1.609Judith.Odonnell:Inc biodiesel percentage. Calculation was for fuel consumed in year 06/07, but fuel purchased in previous yearsJudith.Odonnell:148,058,089 total diesel. PFW = 8,992,201.50 @ 6.07% of total. Source Cathy Braithwaite - VolumebyBusinessDefra factor Jun 07 x 2.63. Biodiesel element of 33,412 included in total and discounted for 6.07%Judith.Odonnell:Use short haul factorJudith.Odonnell:Factor in pkmJudith.Odonnell:Not applicable except to RMLJudith.Odonnell:SIP: RML = 90.5; PFW = 2.2; CF = 1.7; POL = 5.7Judith.Odonnell:51,995,867 total:41,125,111 miles claimed through T&S, report PRT540 from MyPeople (through Simon M Francis) excludes POL, excepting 60,746. 10,870,756 miles claimed through T&S, report from Steve S Reeves for POL only. 60,746 to be added to this for POL breakdown.Split on (national?) company car profile of diesel 80.1, petrol 19.9% Defra diesel factor x0.3197; petrol factor x0.3372

2004-052003-042002-032001-022004-052003-042002-032001-02CO2 emissions (tonnes)RUDC (kg CO2 per 1,000 items)Personal - car12,085.2013,494.4016,065.4017,409.0019.921.82627.3Personal - rail349.12413.09Personal - air1,758.291,811.12Road fleet430,148.78425,707.30424,445.40462,734.00Rail1,247.0233,674.4456,790.0056,763.00Air78,221.0767,825.1665,772.0063,000.00Total523,809.48542,925.51563,072.80599,906.00Transport523,809.48542,925.51563,072.80599,906.00Buildings340,208.58334,729.07322,278.00342,458.00Total864,018.07877,654.58885,350.80942,364.002004-052003-042002-032001-022004-052003-042002-032002-01CO2 emissions (tonnes)Consumption (GWh)Gas oil6,123.35,826.17,692.011,190.024.523.330.843.0Natural gas158,711.9148,742.5134,086.0152,152.0835.3782.9705.7800.8Grid electricity175,373.4180,160.5180,500.0179,116.0412.8424.0419.8416.6Total340,208.6334,729.1322,278.0342,458.01272.71230.11156.31260.4

000000000000000000000

2004-052003-042002-03Carbon dioxide emissions (tonnes) by mode of transport

000000000

2004-052003-042002-03Total Carbon dioxide emissions (tonnes)

000

Carbon dioxide emissions (kg) per 1,000 items

000000000000

Judith.Odonnell:Source: CO2 calcs 04_05.xls2004-052003-042002-03Energy consumption (GWh) by type0000000000002004-052003-042002-03Carbon dioxide emissions (tonnes) from energy consumption

Do not delete sheetCO2 emissions (tonnes)rel to 987k totalrel to 810k totalGas oil4,700.10.476%0.6%Natural gas138,614.214.034%17.1%Grid electricity171,292.717.343%21.1%38.8%Business road404,708.740.976%50.0%404,708.7Personal road14,992.11.518%1.9%Business rail2,663.40.270%0.3%Personal rail434.90.044%0.1%Business air71,135.57.202%8.8%Personal air1,632.30.165%0.2%subtotal ex private cars & commutingAuthorised cars on delivery5,188.20.525%810,173.9tCO2Commuting to work172,312.417.446%Total987,674.5100.000%

4700.0901675138614.21481171292.68268404708.69248120714992.059843182663.39678434.90273385471135.54007841632.33460520265188.1653684172312.4041099

Carbon dioxide emissions by source

000000000

CO2 emissions by source (05-06 financial year)

Energy UseTotal CO2323,379TonnesQuanitityUnitsData SourceCO2 factorCO2Unit381,996,731kWh0.5230199,784,290kgCO2632,850,125kWh0.1850117,077,273kgCO225,964,414kWh0.25106,517,068kgCO2NB - electricity figure is total electricity as invoiced/accrued by TEAM0.0kWh0.24000kgCO2and includes renewable energy. Does not include RMG generated0.0kWh0.26000kgCO2electricty, which has no emissions for the purpose of CO2 calcs.0.0kWh0.30000kgCO2as the emissions lie with the gas used to power CHP system.0.0kWh0.30000kgCO20.0kWh0.21000kgCO2NB2 - gas figures include gas volume used to fuel RMG CHP units0.0kWh0.24000kgCO20.0kWh0.20000kgCO20.0kWh0.26000kgCO2Renewable energy consumption377.6GWh0.0kWh0.25000kgCO2Not certified renewable0.0082GWh0.0kWh0.34000kgCO2Percentage renewable electricity98.85%0.0kWh0.20000kgCO2Elec consumption for purposes of CO2 calc4.4GWh0.0kWh0.24000kgCO20.0kWh0.00000kgCO2Resulting CO2 emissions from elec are2.3kg CO2SUM :323,378,631kgCO2We are not claiming the renewable energy reductions because of the 'double counting' that would result from the two types of certificate - ROCs and LECsStated gas oil consumption (litres)2,221,0792.6745,939,165Equivalent consumption in kWh25,964,413.51using Carbon Trust conversion factor of 1lt = 11.69 kWhAll energy use figures relate to externally generated energy - and do not include the 54GWh of power generated and the 38.9GWh of heat produced & utilisedTotal building energy in GWh1,040.81

LPGJet KeroseneEthaneNaphthaWaste LubricantsPetroleum CokeRefinery GasOther Oil ProductsRenewablesCoking CoalPetrolHFOCoalNatural GasGas/Diesel OilElectricityLPGJet KeroseneEthaneNaphthaWaste LubricantsPetroleum CokeRefinery GasOther Oil ProductsRenewablesCoking CoalPetrolHFOCoalNatural GasGas/Diesel OilElectricityJudith.Odonnell:Source: RMPH Accrued consumption 0607Elfyn MorganJudith.Odonnell:Using factor for brown electricity not green. Not restating previous yearsJudith.Odonnell:Source: RMPH Accrued consumption 0607Elfyn MorganJudith.Odonnell:Using GROSS factor, not net. This will change in future to net value, but when that will be is not yet decided.Judith.Odonnell:Using GROSS factor, not net. This will change in future to net value, but when that will be is not yet decided.Judith.Odonnell:This figure of 377600MWh for UK electricity from EDF supplied by Alan Tweed to Simon Francis on 11/04/07Judith.Odonnell:This figure of 8.2MWh for NI electricity not certified renewable supplied by Alan Tweed to Simon Francis on 11/04/07Judith.Odonnell:From CSR Reporting EOY 06/07 spreadsheet, provided by Elfyn Morgan 9/8/07

Energy UseTotal CO2316,757Tonnes2005-06QuanitityUnitsData SourceCO2 factorCO2Unit403,355,076kWh0.43173,442,683kgCO2729,548,499kWh0.19138,614,215kgCO218,800,361kWh0.254,700,090kgCO2NB - electricity figure is total electricity as invoiced/accrued by TEAM0.0kWh0.240kgCO2and includes renewable energy. Does not include RMG generated0.0kWh0.260kgCO2electricty, which has no emissions for the purpose of CO2 calcs.0.0kWh0.300kgCO2as the emissions lie with the gas used to power CHP system.0.0kWh0.300kgCO20.0kWh0.210kgCO2NB2 - gas figures include gas volume used to fuel RMG CHP units0.0kWh0.240kgCO20.0kWh0.200kgCO20.0kWh0.260kgCO20.0kWh0.250kgCO2Renewable energy consumption5GWh0.0kWh0.340kgCO2Therefore total elec consumption for0.0kWh0.200kgCO2purposes of CO2 calcs is398,355,076.00kWh0.0kWh0.240kgCO20.0kWh0.000kgCO2Resulting CO2 emissions from elec are171,292,682.68kg CO2SUM :316,756,988kgCO2Stated gas oil consumption (litres)1,608,243Equivalent consumption in kWh18,800,360.67using Carbon Trust conversion factor of 1lt = 11.69 kWhstated gas oil consumption (litres) 2004/052284811Equivalent consumption in kWh26,709,440.59using Carbon Trust conversion factor of 1lt = 11.69 kWhAll energy use figures relate to externally generated energy - and do not include the 54GWh of power generated and the 38.9GWh of heat produced & utilised1,151,703,936

LPGJet KeroseneEthaneNaphthaWaste LubricantsPetroleum CokeRefinery GasOther Oil ProductsRenewablesCoking CoalPetrolHFOCoalNatural GasGas/Diesel OilElectricity