__NOTOC__[[Image:PEM logo.png|right|130px|link=http://web.archive.org/web/20141022160342/http://www.pem.dk:80/page/en/Home]]This Sector Investment Plan is an Excel spreadsheet for use by the water and sanitation sector in developing countries (Fonseca, et al.). It was developed in 2005 by [http://web.archive.org/web/20141022160342/http://www.pem.dk:80/page/en/Home PEM Consult ] for a disaggregated cost study in Kenya with the support of the Water and Sanitation Program of the World Bank (WSP) and the Kenyan Ministry of Water and Irrigation.
'''The associated study presents a step by step methodology for developing sector investment plans. ''' <br>'''Some critical steps include ''' (Fonseca, et al.):
* estimation of disaggregated costs based on bill of quantities,
The spreadsheet developed for this study was used to estimate the costs of different water and sanitation technologies in the seven areas falling under the responsibility of Water Service Boards in Kenya. The spreadsheet is set up to include hardware costs (including rehabilitation and replacement), operation and maintenance, direct support costs such as design and support, community mobilisation and hygiene promotion. Rehabilitation costs include both depreciation and renovation (due to backlog in maintenance).
{|style="border: 1px solid #DB87C9; text-align: left; background-color: #efefef" align="none" width="70%" |Data can be analysed using per capita and per cubic metre costs. Further, the spreadsheet also calculates the cost for the The various technologies costs are calculated according to a standard bill of quantities and compares these costs with the actual cost of projects that have been implemented or planned in Kenya over the previous five to ten years.|}
==Key documents==
Carlevaro, F. and Gonzalez, C., 2010. Costing improved water supply systems for low-income communities : a practical manual. [http://www.icevirtuallibrary.com/content/article/10.1680/wama.1000043 Proceedings of the ICE - Water Management], 164 (3), pp 123–134.
Jacobsen===Key documents===* Carlevaro, MF. and KarupGonzalez, JC., 20072010. Costing improved water supply systems for low-income communities : a practical manual. [http://www.euwiicevirtuallibrary.netcom/filescontent/euwiarticle/8509_tmpphpJ2Jwqv10.pdf Developing financing strategies in water supply and sanitation1680/wama.1000043 Proceedings of the ICE - Water Management]: information note prepared by COWI consultants and shortened by the FWG Secretariat. EUWI Finance Working Group. Brussels, Belgium : EUWI Secretariat 164 (3), European Commissionpp 123–134.
Fonseca C.* Jacobsen, Dubé AM. and Verhoeven Karup, J., 20112007. [http://www.washcostgwp.infoorg/Global/ToolBox/pageReferences/1473 Cost-based decision support tools for Developing%20a%20Financing%20Strategy%20in%20Water%20Supply%20and%20Sanitation%20%28EUWI,%202007%29.pdf Developing financing strategies in water supply and sanitation]: information note prepared by COWI consultants and shortened by the FWG Secretariat. EUWI Finance Working Paper 4Group. IRC International Water and Sanitation CentreBrussels, Belgium : EUWI Secretariat, European Commission.
Heath T* Fonseca C., Tibenderana PDubé A., Carter R., Danert K and Berhe EVerhoeven J., 20092011. [http://www.ruralircwash.org/resources/cost-based-decision-support-tools-water-supplyand-sanitation Cost-based decision support tools for water and sanitation]. Working Paper 4.net/en/resources/details/361 Borehole Costing Model V2IRC International Water and Sanitation Centre.8 BETA], Cranfield University, UNICEF, SDC, Skat , RWSN
Mali* Heath T., Tibenderana P., Carter R., Danert K and Berhe E. Direction Nationale de l'Hydraulique -ML, 2009. [http://www.washdocrural-water-supply.infonet/en/docsearchresources/titledetails/174885 Etude concernant l’evolution future du systeme STEFI : rapport final361 Borehole Costing Model V2.8 BETA]. Bamako, Mali: MaliCranfield University, UNICEF, Ministere des MinesSDC, de l'Hydraulique et de l'EnergieSkat, Direction Nationale de l'HydrauliqueRWSN.
Mehta, M, Fugelsnes T, Virjee K* Mali.Direction Nationale de l'Hydraulique -ML, 20052009. [http://wwwfr.ircircwash.nlorg/docsearchresources/title/174392 Financing the Millennium Development Goals for Water and Sanitationetude-concernant-l%E2%80%99evolution-future-du-systeme-stefi-rapport-final Etude concernant l’evolution future du systeme STEFI : What Will it Take?rapport final] International Journal of Water Resources Development. Bamako, Mali: Mali, 21(2) pp.239-52Ministere des Mines, de l'Hydraulique et de l'Energie, Direction Nationale de l'Hydraulique.
* Mehta, M, Fugelsnes T, Virjee, K., 20072005. [http://www.washdocircwash.infoorg/docsearchresources/title/172724 The sector wide investment financing-millennium-development-goals-water-and-sanitation-what-will-it-take Financing the Millennium Development Goals for Water and financing tool Sanitation: What Will it Take?] International Journal of Water Resources Development, 21(SWIFT2)]: model overview : working paper draft pp. Nairobi, Kenya: Water and Sanitation Program 239- African Region52.
Water and Sanitation Program (WSP)* Virjee, K., 20112007. [http://www.wspircwash.org/noderesources/162 Is Africa on Track to Meet sector-wide-investment-and-financing-tool-swift-model-overview-working-paper-draft The sector wide investment and financing tool (SWIFT)]: model overview : working paper draft . Nairobi, Kenya: Water Supply and Sanitation Targets?]Program - African Region.
* Water and Sanitation Program (WSP), 2011. [http://www.wsp.org/node/162 Is Africa on Track to Meet Water Supply and Sanitation Targets?] * Wiemers A., 2005. [http://contentmci.ei.undpcolumbia.orgedu/gofiles/cms-service2013/stream01/asset/;jsessionid=aIHA9xSEGS69?asset_id=2548671 WATSAN-User-Guide.pdf Water and Sanitation Needs Assessment Model]. User guide. MDG Needs .
====Assessment Tools====
* Tandon P., Pizarro G., 2006. Water and Sanitation Needs Assessment Tool for use in assessing national needs to achieve the MDGs. United Nations Development Program (UNDP).
* Ravikumar, J. et al., 2009. The City Sanitation Plan, Database and spreadsheet. South Asia: Water and Sanitation Program.