Transcript Document

The energy and environmental scorekeeper
Planet Footprint moves
local governments
beyond measurement so
they can focus on
improving performance
About Planet Footprint
Planet Footprint delivers a fully supported service that independently
monitors and reports the Energy, Water, Fleet, Waste and Greenhouse
performance of 200 organisations internationally – including over 175
Australian Councils and several large state government departments.
We are:
o Independent
o An annual subscription based service – you pay an annual fee to access our
service
o Experienced - 8th year in business
o Specialists in local government
We are not:
o A software company
o Consultants or sellers of technology
o A government or non-profit program
2
Risk of Inverted Effort
Without PF
Indecision
and
Inaction =
results
Information
and Data
With PF
Decisions
and Actions
= Results
Information
and Data
People
You
Service & Support: Claire,
Tim, Marianne, Anna, Rod
Data and IT:
Derek, Louise,
Rod, Annie, Jon
Thusus, Vina
Director:
Dean
4
What We Deliver
Quarterly Reviews, Support, Other Modules
Organization-level: Dashboard & Reports
Property-level: reports and profiles
Account-level: data and toolkits
Managed Data Collection
Core Scorekeeping Service
• Data Collection
• Data Cleansing, Reconciliation and Management
• Report and Datasets available online
• Quarterly Performance Reviews
• General Support
Quarterly Performance Reviews
Review performance and identify opportunities for improvement. Inform decisions and
celebrate achievements. Sharing information and accountability.
• Data quality review
• Organisation wide & top site performance trends
• Mid-year and end of financial year summary
• Anomaly reporting
7
e Power Cost Comparison - NSW
Rural - Cost per kWh
Urban - Cost per kWh
$0.40
$0.35
$0.30
$0.25
$0.20
$0.15
$0.10
$0.05
0
5
10
2011/12 FY kWh Consumption
15
0
5
10
Millions
15
20
25
2011/12 FY kWh Consumption
30
35
Millions
NSW - Costs per kWh
$0.40
$0.35
Urban Av = 19c/kWh
$0.30
$0.25
Rural Av. = 22c/kWh
$0.20
$0.15
NSW Av. = 22c/kWh
$0.10
0
5
10
15
20
2011/12 FY kWh Consumption
25
30
35
Millions
8
Spotlight on Lighting: LED vs. T5
LED & T5 Comparison: Total Costs, Financial Savings & ROI Averages
$14,000
40%
35%
$12,000
30%
Total Costs $
$10,000
25%
$8,000
20%
$6,000
15%
$4,000
10%
$2,000
5%
$0
0%
LED Lighting Upgrades
T5 Lighting Upgrades
Financial Savings
$
Return on
Investment %
Emissions Module
10
Measures, Offsets & Events
Recognition Program
• Recognise organisations that actively demonstrate
commitment to:
–
–
–
–
–
Monitoring and reporting performance
Understanding emissions
Reporting actions and measures
Engaging staff
Communicating and feeding performance
information ‘up the line’
– Transparency of project outcomes
– Anomaly management and accountability
We guide you to compliance through Quarterly Performance Reviews
12
Our First Gold Subscribers
Mackay Regional Council
QLD
Eurobodalla Shire Council
NSW
13
Ok, so what about
Fleets and Fuel?
Existing
System
Gaps
• Overall cost and efficiency for fleet and bulk fuel
• Corporate and Regulatory Reporting, esp. environment/sustainability
• Consistency between Councils – reporting formats, vehicle classes etc
Technically possible using existing systems but the data is not quite right and Fleet
Managers don’t have the time.
Product
Overview
Fleet Product Overview
•
Types of information:
–
–
–
–
–
•
Costs, consumption, emissions, efficiency, star ratings
Whole organisation, department, fuel type, vehicle type, individual vehicle.
Targets, forecasts, budgets
Trends, benchmarks, best practices across Councils
Anomalies?
Delivered as a managed service:
– Data collection, integration and management
– Reports
– Presentation (at QPRs, regional meeting etc) – trends, anomalies, benchmarks, best
practices. This is where the value is
– Project support
•
Main outputs
– Benchmarking (against self and others)
– Briefings
– Corporate and Regulatory Reporting (NGER, WaSIP)
Value – for Fleet Managers
• Less work for fleet managers to output sustainability data
– Corporate Social Responsibility
– Regulatory (NGER, WaSIP?)
•
•
•
•
•
Summary view of all fuel (bulk and fleet)
Cost allocation (with markup?) per vehicle for bulk fuel
Inter council benchmarking
Simple and smart anomaly reporting, if feasible
Help with project work:
– GHG accounting at project level
– Budgeting, forecasting
– Get recognition for efficiency measures implemented
Value – for
Sustainability/Environment Staff
• Easier to obtain data for GHG emissions
calculations.
• Ability to drill-down into data without
bothering Fleet Manager.
• Combined reporting of electricity, gas, fleet
fuel, waste etc to senior management and
Council.
• Opportunities and results of fuel efficiency
measures for Council and all Councils.
Sample Information
Anywhere Council
Fuel cost and consumption by fuel type - Financial Year 2011-2012 (l/100km)
Cost
Consumption
ULP
LPG
DIESEL
ULP
DIESEL
LPG
PULP
PULP
E10
E10
Sample Information
Fuel Consumption & Cost Breakdown, 2011-2012
1000000
800000
700000
100000
600000
10000
500000
1000
400000
$$$
L
300000
Prev. Value
100
200000
10
100000
1
0
Sample Information
800
Fuel Consumption ($$$) by year
700
600
500
$$$
2011
400
2012
300
YTD 2012
YTD 2013
200
100
0
Light Truck
Fleet
Utility
TRACTOR BACKHOE GRADER
SEDAN
WAGON
ROLLER
Prime
mover
Other
Sample Information
Fuel Consumption Totals ($$$) by year
2500
2000
2011
1500
kL
2012
YTD 2012
1000
YTD 2013
500
0
Grand Total
Sample Information
Fuel efficiency by Council - Financial Year 2011-2012 (l/100km)
Anywhere
Council
Auto Shire
Council
Fleetville
Council
Bulk
23.5
23.6
23.2
Fleet
10.1
9.9
9.2
Sample Information
Fuel efficiency by Vehicle Type - Financial Year 2011-2012 (l/100km)
Anywhere
Council
Hatch
Auto Shire
Council
Fleetville
Council
9.5
9.4
9.5
WAGON
10.5
10.5
10.5
PANEL VAN
12.4
12.4
12.4
SEDAN
12.5
12.4
12.4
Utility
15.7
15.6
15.5
Light Truck
22.4
22.3
22.4
Prime mover
57.0
57.0
57.0
Overall Average
19.2
19.1
19.3
Sample Information
Fuel efficiency by Vehicle Type - Financial Year 2011-2012 (l/hr)
Anywhere
Council
Auto Shire
Council
Fleetville
Council
FORKLIFT
2.4
2.4
2.4
MOWER
4.7
4.7
4.7
ROLLER
5.5
5.0
5.3
BACKHOE
6.1
6.0
6.0
TRACTOR
7.6
7.7
7.7
GRADER
8.5
8.5
8.5
Medium Truck
9.6
9.6
9.6
Overall Average
6.8
6.7
6.8
Sample Information
• Can also do:
– Excel detail data
– Intensity analysis by headcount, LGA population,
kms of road network.
– Regulatory Reports (NGER, WaSIP)
– Custom reporting for specific projects
Estimated Subscription Fees
Annual Service
$2,000 - $4,000
Anomaly Management
$1,500 - $3,000
Set up (once-off)
$1,000 - $2,500
Additional Consulting
$150 per hour
• Varies based on fleet size and data availability.
• Assumes Council is also subscribed to Core
Scorekeeping Service
• Includes 2 hours of prepaid billable support.
Next Steps
• Phase 2 – Develop a working product/service.
– Formal data collection formats and process
– Reports with real data
– Quarterly Performance Review content
• Phase 3 – Pilot rollout
– 1 year subscription
– waive setup fee and include more hours of
consulting time.
• Phase 4 – Available to all Councils and clients
Feasibility - It’s all about the data
• Planet Footprint data will only be as good as what we
extract from Ausfleet, FleetMex, or your automated
fuel pump or fuel vendor.
• Must be at vehicle level, otherwise there isn’t enough
detail to ensure data quality, and no way to explain
performance.
• Consistent Identifiers
• Completeness (are all council vehicles covered?)
• Mapping and meaning
• Synchronisation of vehicle and fuelling details from
Council systems to PF – at vehicle level
How does the data flow?
Is this correct?
Are there variations? For example, Fleet Fuel data (Caltex) is not in Fleet
Management System (AusFleet)?
Are FleetMex, AusFleet hosted or installed in-house?
Other data questions
• Vehicle and equipment classes?
–
–
–
–
–
Passenger (vkt)
Light commercial (vkt)
Trucks (vkt)
Heavy machinery (graders, rollers) hours
Other plant (mowers etc) hours
• Universal vehicle identifier?
– Equipment/Asset number (preferred)
– PF could assign if ID does not exist in Council
– Rego, VN etc may not be universal. Store as secondary
references.
• Cost data for bulk fuel?
– Set up in current systems or PF can calculate
• Different ways to get km (odometer) or hours?
Data issues and draft responses
• Cost data not available from automated fuel pumps. A: Planet
Footprint can synthesise cost for each vehicle refuel based on bulk
fuel purchases. Can Ausfleet/FleetMex do this?
• Private use is allowed and staff buy the fuel without using the
fleet card. This causes underestimation of consumption and cost.
A: selectively exclude these vehicles from anomaly, and efficiency
analysis.
• Poor odometer readings. A: PF can discard bad data and give fleet
manager option to enter correct figure.
• Inconsistent identifiers for vehicles. A: 1st priority when setting up
for each council
• Anomalies are usually caused by poor data or explained by
operational changes. ???
• General Data quality. A: PF can provide initial and ongoing
diagnosis and advice but Council will be responsible for data quality.
Anomalies
• Anomalies – What is current practice?
• Why doesn’t your current fleet system fill this
requirement?
• Types
– Gross consumption increases and decreases
– High l/100km – indicating poor fuel consumption or ??
– Inaccurate or missing odometer readings (Fleet
manager can override with periodic reading)
– New asset identification (eg new vehicle on Caltex
StarCard)
– Unused assets (no fuel consumption or km)
Detecting , explaining and addressing anomalies reduces costs, improves
operational performance and you get more accurate reporting. But it is labour
intensive.
Discussion
• 1300 721 113
• [email protected]
• [email protected]