Spreadsheet: 622dcf3e-a7f5-4b72-8828-ae6feaa1a91e
Sheet: Sheet1

PROJECT NAME | Enabling Better Delivery of Aid In Somalia
IMPACT | Impact Indicator 1 |  | Baseline mid 2011 | Milestone 1.  Dec 2011 | Milestone 2 | Target end 2014
Development and humanitarian programmes meet the needs of poor Somalis | Crude mortality rate in worst affected regions |  | >2/10,000 per day | <2/10,000 per day |  | <0.5/10,000 per day
 |  | Source
 |  | DFID Humanitarian programme logframe.
 | Impact Indicator 2 |  | Baseline 2010 | Milestone 1 2011/12 | Milestone 2 2012/13 | Target end 2014
 | Proportion of people below the poverty line. | Planned | 43.2 |  |  | TBD
 |  | Achieved
 |  | Source
 |  | UNSAS.  UNDP technical reports and surveys
OUTCOME | Outcome Indicator 1 |  | Baseline (2011) | Milestone 1 2012 | Milestone 2 2013 | Target end 2014 | Assumptions
Aid to Somalia is more effectively targeted and delivered | % of population in reached with humanitarian assistance in areas of greatest needs - south(C) | Planned | 30% in Sept | 70% in Sept | 70% in Sept | 70% in Sept | Conflict levels remain within expected levels  Fragmentation of government in Somalia does not undermine efforts to improve aid effectiveness. Sufficient funding by other donors is made available to operational agencies.
 |  | Achieved
 |  | Source
 |  | DFID Humanitarian programme logframe (OCHA CAP, FSNAU)
 | Outcome Indicator 2 |  | Baseline 2011 | Milestone 1 | Milestone 2 | Target end 2013
 | Level of adherence to Fragile States Principles   Indicator 1a Are the international actors’ country strategies based on sound political and social analysis (i.e. taking into account the situation in terms of national capacity, state-society relations and societal divisions? Indicator 8c Has  practical co-ordination resulted in better analysis, greater agreement on strategic objectives and improved implementation of international programmes? | Planned | 1a: Not consistently 8c. No or marginally |  |  | 1a: Consistently 8c. Yes
 |  | Achieved
 |  | Source
 |  | 2011 Report on International Engagement in Fragile State. Somali Republic
 | Outcome Indicator 3 |  | Baseline (2010) | Milestone 1 | Milestone 2 | Target end 2013
 | Degree of fragmentation of aid flows. | Planned | 0.08 |  |  | 0.15
 |  | Achieved
 |  | Source
 |  | Herfindhal-Hirschman Index Country base index for Somalia. Source:   Development Aid Effectiveness and Aid Flow Analysis.
INPUTS (£) | DFID (£) |  | Govt (£) | Other | Total (£) | DFID SHARE (%)
 | 10144000 |  |  |  |  | 0.71
INPUTS (HR) | DFID (FTEs)
OUTPUT 1 | Output Indicator 1.1 |  | Baseline | Milestone 1  end  2012 | Milestone 2 | Target end 2014 | Assumption
Stronger use of evidence, management of risk, planning and co-ordination in implementing development assistance | Coherence of programming across the UN | Planned | Joint programmes: 1 | UNSAS and ICF merged Joint programmes 3 |  | Joint programmes 6 | The UN continues to play a leading role in the management and coordination of development assistance and humanitarian aid to Somalia.    Efforts to strengthen coordination are not undermined by a lack of commitment from UN agencies operating in Somalia.  Donors willing to establish common positions that support aid effectiveness. UN agencies are  open to the changes needed to mitigate risk including fiduciary risk. DFID financing does not simply displace funding from the UNs Development Operations Coordination Office (DOCO) and UN agencies and undermines the sustainability of the RCO in the longer term.
 |  | Achieved
 |  | Source
 |  | Number of joint programmes - RCO Development aid database.   Merged ISF and UNSAS - records of UN Senior Policy Group
 | Output Indicator 1.2 |  | Baseline | Milestone 1 end 2012 | Milestone 2 end 2013 | Target end 2014
 | Analysis influences programming across the UN | Planned | Number of agencies received training on the programming implications of improved analysis: 0 | Number of agencies received training on the programming implications of improved analysis: 60 | Number of agencies received training on the programming implications of improved analysis: 120 | Number of agencies received training on the programming implications of improved analysis: 180
 |  | Achieved
 |  | Source
 |  | RCO records on Peace-building, Political economy of emerging administrations and other studies. Numbers are cumulative
IMPACT WEIGHTING (%) | Output Indicator 1.3 |  | Baseline 2010 | Milestone End 2012 | Milestone 2 | Target end 2014
40 | Risk management in the UN system | Planned | Agencies with an ERM: 0 | Agencies with an ERM: 15 |  | Agencies with an ERM: 22
 |  | Achieved
 |  | Source |  |  |  |  | RISK RATING
 |  | Enterprise Risk Management (ERM) project records |  |  |  |  | Medium
INPUTS (£) Grants will fund Interventions that deliver on more than 1 output – a breakdown in budgets between the outputs is inappropriate | DFID (£) |  | Govt (£) | Other (£) | Total (£) | DFID SHARE (%)
 | 4553000 |  |  | Danida 6.4 m Dkr for Risk Management Programme | 5.2M | 0.87
INPUTS (HR) | DFID (FTEs)
OUTPUT 2 | Output Indicator 2.1 |  | Baseline 2011 | Milestone 1 | Milestone 2 | Target end 2014 | Assumption
Stronger use of evidence, management of risk, planning and co-ordination in the humanitarian response | Number of interventions in relevant clusters responding to emergencies utilising FSNAU information | Planned | 0.35 |  |  | 0.7 | The security situation permits field operations to continue
 |  | Achieved
 |  | Source
 |  | Partner reports
 | Output Indicator 2.2 |  | Baseline 2011 | Milestone 1 | Milestone 2 | Target end 2013
 | % of CERF and CHF allocations that are made towards highest priority projects; % of ERF project allocations that are made in accordance with agreed criteria. | Planned | CERF 100% CHF 90% | CERF 100% CHF 90% |  | CERF 100% CHF 90%
 |  | Achieved
 |  | Source
IMPACT WEIGHTING (%) | Output Indicator 2.3 |  | Baseline 2011 | Milestone 1 end 2012 | Milestone 2 | Target end 2013
40 | Level of satisfaction expressed by key stakeholders (government, donors, humanitarian actors) with UN OCHA coordination leadership | Planned | Nairobi – 68% Somaliland – 40% Puntland – 35% South Central Somalia – 27% | Nairobi 75% Somaliland 50% Puntland 50% South Central % |  | Nairobi 85% Somaliland 60% Puntland 60% South Central 60%
 |  | Achieved
 |  | Source |  |  |  |  | RISK RATING
 |  | OCHA performance framework: satisfaction survey |  |  |  |  | Medium
INPUTS (£) | DFID (£) |  | Govt (£) | Other (£) | Total (£) | DFID SHARE (%)
 | 3480000 |  |  | Sida, USAID, the EU and several smaller donors: approx £14M  OCHA do not have budget beyond 2012
INPUTS (HR) | DFID (FTEs)
OUTPUT 3 | Output Indicator 3.1 |  | Baseline | Milestone 1 end 2012 | Milestone 2 2013 | Target end 2014 | Assumptions
Greater access for aid workers in Somalia through the provision of improved safety and security. | Number of UN and INGO aid workers covered by emergency medical response services | Planned | 1500 |  | 1900 | 2400 | The security situation permits field operations to continue
 |  | Achieved
 |  | Source
 |  | UNDSS records
 | Output Indicator 3.2 |  | Baseline 2010 | Milestone 1 end 2012 | Milestone 2 end 2013 | Target end 2014
 | Number of aid workers provided with security information | Planned | 1200 | 1300 | 1400 | 1500
 |  | Achieved
 |  | Source
 |  | NGO Safety Programme records
IMPACT WEIGHTING (%) | Output Indicator 3.3 |  | Baseline 2010 | Milestone 1 end 2012 | Milestone 2 end 2013 | Target end 2014
20 | % NGOs operating in Somalia  satisfied with the support they receive from the NGO Safety Programme (NSP) in terms of provision of security information provision and support | Planned | 60% express satisfaction | 60% express satisfaction | 60% express satisfaction | 60% express satisfaction
 |  | Achieved |  |  |  |  |  |  |  |  | \
 |  | Source |  |  |  |  | RISK RATING
 |  | NGO Safety Programme records |  |  |  |  | High
INPUTS (£) | DFID (£) |  | Govt (£) | Other (£) | Total | DFID SHARE (%)
 | 2102000 |  |  | ECHO, Sida, Danida and CHF: £2m approx.
INPUTS (HR) | DFID (FTEs)