Paper # 188
Business Analytics for Rural India
Applying Information Analytics to Enhance Rural Water Management Efficiency and Sustainability INDIA WATER WEEK April 11 2013 Sustainable and Efficient Community Water Supply in Rural Areas Ravi Sewak Hew Crooks Nithya Rajamani Geoff Riggs Cecilia Laverty
Safe Water Network Safe Water Network IBM Research India IBM Canada IBM USA
Community-owned and operated Safe Water Station
India Water Week – April 11 2013
Business Analytics for Rural India
Business Challenges Plant downtime, or sub-optimal performance Problems often are detected only after they have happened Engineer site visits are expensive and difficult to organize Data is critical to ensure kiosk equipment is functioning properly Sales and consumer data critical for strategic planning
Result Derelict Infrastructure Excessive cost of repairs or replacement
India Water Week – April 11 2013
Business Analytics for Rural India
Solution: Remote Monitoring Sensor based, automatic periodic updates Using mobile data carrying ability Enhance central awareness Help local operator
The Challenge An abundance of data requires significant time to receive, process, report and act on. Conversely, a lack of critical information related to operations and sales performance inhibits efficient operations and planning.
India Water Week – April 11 2013
Business Analytics for Rural India
Project Objectives Provide analytics capability
powerful and flexible
that is accessible, affordable, scalable and more
Support more efficient decentralized water provisioning
by applying enterprise-class technological capabilities and techniques to ‘small-data’ operations Introduce a new level of
information management capabilities to SWN staff
Vision Analytics application to give tools for Village-level information management that would facilitate operational insight and efficiency.
India Water Week – April 11 2013
Business Analytics for Rural India
Principles & Benefits What Gets Measured, Gets Managed Better information leading to better performance More Time for High Value Tasks Reactive processes impair performance and increase costs Foundational Data Model A well-modelled data repository to facilitate efficient information management Affordable, Scalable, Accessible, Sustainable Address the skills and needs of the users, and consider environmental and business constraints Skills and Tools for Future To efficiently process new information sources, aligned with their available resources, budget and organizational objectives India Water Week – April 11 2013
Business Analytics for Rural India Project Overview
Multiple data points exist even in small/rural water distribution kiosks
Operational Dashboard, Customizable Analytics and Reports
The Safe Water Network Analytics application is an integration and optimization layer which leverage, not replaces, the existing data and system resources presently being used. India Water Week – April 11 2013
Business Analytics for Rural India Analysis
Jookal Average Kureb Project ProjectSummary: Summary: Village: Village: Obeyeyie Obeyeyie
120,000 120,000
Jul-12 Jul-12
District: District: Population Population Distance Distancefrom fromAccra Accra Inauguration Inauguration
Ga GaWest West 2,500 2,500 1.5 1.5hours hours May-09 May-09
80,000 80,000
Capacity Capacity(L/H) (L/H) Effective EffectiveCapacity Capacity Remote RemoteKiosks Kiosks Delivery Delivery
2,700 2,700 month 1,300,000 per month 1,300,000L Lper None None 11Truck Truck
20,000 20,000
HH HHPenetration Penetration HH HHPenetration Penetration(500m) (500m) Financial FinancialPerformance Performance REVENUE REVENUE DIRECT DIRECTOPERATING OPERATINGCOST COST EBITDA EBITDA EBITDA Margin EBITDA Margin WHG WHGFEES/EXPENSES FEES/EXPENSES EBITDA EBITDA(After (AfterWHG) WHG) Margin Margin Operating OperatingMetrics Metrics Volume VolumeSold Sold(L) (L) Average AveragePrice/20L Price/20L Op OpCost Cost&&Fees/20L Fees/20L EBITDA/20L EBITDA/20L
40,000 40,000
76,923 76,923
- WHG Site Support to Site Support to WHG Additonal Storage Tanks Additonal Storage Tanks Generators/Upgrades Generators/Upgrades Initial Turnkey Site Initial Turnkey Si te
44% 44% 114% 114%
2012 2012 2,138 2,138 1,511 1,511 627 627 29.3% 29.3% 1,250 1,250 -623 -623 -29.1% -29.1%
Current CurrentMonth Month 2011 Diff. 2011 Diff. 1,270 868 1,270 868 517 994 517 994 753 -126 753 -126 59.3% 59.3% 1,150 100 1,150 100 -397 738 -397 738 -31.3% -31.3%
508,220 508,220 0.08 0.08 0.11 0.11 -0.02 -0.02
253,520 253,520 254,700 254,700 0.10 -0.02 0.10 -0.02 0.13 -0.02 0.13 -0.02 -0.03 0.01 -0.03 0.01
July Julyresults resultswere werepositive, positive,up up100% 100%over overthe theprevious previousyear; year;this thisrepresented representedaa meaningful meaningfulacceleration accelerationiningrowth growthrate rateafter aftermonths monthsofofcontinued continueddecline. decline.
Total TotalProject ProjectCost Cost: 103,642 : 103,642 (US$ (US$67,367) 67,367)
%% 68% 68% 192% 192% -17% -17%
2012 2012 17,542 17,542 12,424 12,424 5,117 5,117 29.2% 29.2% 8,750 8,750 -3,633 -3,633 -20.7% -20.7%
9% 9% 57% 57%
100% 100% -16% -16% -17% -17% -22% -22%
Year YeartotoDate Date 2011 Diff. 2011 Diff. 10,720 6,822 10,720 6,822 7,848 4,577 7,848 4,577 2,872 2,245 2,872 2,245 26.8% 26.8% 8,050 700 8,050 700 -5,178 1,545 -5,178 1,545 -48.3% -48.3%
%% 64% 64% 58% 58% 78% 78% 9% 9% 43% 43%
4,195,720 4,195,720 2,303,620 2,303,620 1,892,100 1,892,100 82% 82% 0.08 0.09 -0.01 -10% 0.08 0.09 -0.01 -10% 0.10 0.14 -0.04 -27% 0.10 0.14 -0.04 -27% -0.02 -0.04 0.03 -61% -0.02 -0.04 0.03 -61%
1,000,000 1,000,000 500,000 500,000 2012 Actual 2012 Actual
India Water Week – April 11 2013
-
-
44% 44% 114% 114%
45% 45% 75% 75%
Water WaterQuality Quality
Fail Fail Pass Pass Pass Pass
Volume VolumeBreakdown Breakdown 500,000 500,000
2009 2009 2010 2010 2011 2011 2012 2012
1,500,000 1,500,000
2012 Budget 2012 Budget
HH HHPenetration Penetration HH HHPenetration Penetration(500m) (500m)
Result Result Fail Fail Pass Pass Pass Pass
600,000 600,000
2,000,000 2,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Operating Operating&&Consumer ConsumerMetrics Metrics Actual Actual Target Target 40% 70% 40% 70% 4% 7% 4% 7% 1% 5% 1% 5%
Overall OverallPlant PlantUtlization Utlization Downtime Downtime(% (%ofof360) 360) Wastage Wastage
Obeyeyie ObeyeyieYoY YoY Comparison Comparison(L) (L) 2,500,000 2,500,000
2011 2011
Confidential
12,308 12,308
60,000 60,000
Obeyeyie ObeyeyieVolume Volume(L) (L) 900,000 900,000 800,000 800,000 700,000 700,000 600,000 600,000 500,000 500,000 400,000 400,000 300,000 300,000 200,000 200,000 100,000 100,000 -
Summary Summaryand andComment Comment Though Thoughititisistied tiedwith withOduman Odumanasasour oursmallest smallestcommunity community(about (about2,000), 2,000), Obeyeyie Obeyeyiehas hasaastrong strongsource sourceand anddoes doesaalot lotofofbulk bulksales salesand anddelivery. delivery.As Asaa result it has been result it has beenaaconsistent consistentperformer performeratatthe thehighest highestper percapita capitavolume volumelevel level ofofany anyofofour oursites. sites.AAremote remotekiosk kioskisisscheduled scheduledtotobe becompleted completedby bymid-August. mid-August.
4,923 4,923 9,488 9,488
100,000 100,000
400,000 400,000
200,000 200,000
74,000 74,000
100,000 100,000
179,520 179,520
Q1 Q1
Q2 Q2
Q3 Q3
Q4 Q4
269,000 269,000
300,000 300,000
-
2011 2011
239,220 239,220
Delivery Delivery RK3 RK3 RK2 RK2 RK1 RK1 Main Site Main Site
2012 2012
7
Business Analytics for Rural India The looks
Locally Operated Confidential
India Water Week – April 11 2013
8
Business Analytics for Rural India “Together, we solve water!”
Thanks
India Water Week – April 11 2013