Somali Integrated Statistics and Economic Capacity Building Project (SISECBP) Final Revised Procurement Plan for PPA Dated: 20 May, 2020 I. Packages for Goods, and Non-Consulting Services Ref Contract Estimated Revie Market Selecti Evalua Procureme Prequ Dom Expected Expected . Description Cost (US$) w by Approa on tion nt Process alifica estic date of date of No Bank ch Method Option (Single tion Prefe bid/ Contract (Open- (RFP, s stage- renc proposal Signature (Prior/ (Yes/ Nation RFB, single e opening No) Post) al/ RFQ envelope (Yes Limited etc.) etc.) /No) etc.) GOODS Procurement for the PIU and SIHBS of: (a) Ten Desktop Most Single G1 computers (6 30,800 Prior Limited RFQ advant stage One N/A N/A 15-Jun-20 16-Jul-20 for PIU and 4 ageous - Envelope for SIHBS); 4 laptops for SIHBS; 10 Data Entry tablets Ref Contract Estimated Revie Market Selecti Evalua Procureme Prequ Dom Expected Expected . Description Cost (US$) w by Approa on tion nt Process alifica estic date of date of No Bank ch Method Option (Single tion Prefe bid/ Contract (Open- (RFP, s stage- renc proposal Signature (Prior/ (Yes/ Nation RFB, single e opening No) Post) al/ RFQ envelope (Yes Limited etc.) etc.) /No) etc.) (b)two Big Printer with copier for NEC and DNS; (c) 1 Laser jet desk printers for PIU (d) Two projectors for SIHBS and PIU (i) Ten anti- virus software (6 for PIU and 4 for SIHBS) Purchase of 2 Most motor vehicles advant Single G2 (one for PIU 80,000 Prior Limited RFQ ageous Stage One- N/A N/A 15-Jun-20 16-Jul-20 and one for Envelop NEC) Office furniture Most Single G3 and a 7,700 Prior Limited RFQ advant stage One N/A N/A 30-Jun-20 22-Jul-20 refrigerator for ageous - Envelope Ref Contract Estimated Revie Market Selecti Evalua Procureme Prequ Dom Expected Expected . Description Cost (US$) w by Approa on tion nt Process alifica estic date of date of No Bank ch Method Option (Single tion Prefe bid/ Contract (Open- (RFP, s stage- renc proposal Signature (Prior/ (Yes/ Nation RFB, single e opening No) Post) al/ RFQ envelope (Yes Limited etc.) etc.) /No) etc.) PIU (Chairs, Tables, cabinets) 4 Most Single Anthropometri advant G4 2,000 Prior Limited RFQ stage One N/A N/A 14-July-20 28 July-20 c equipment ageous - Envelope for SIHBS Total 120,50 Goods 0 Ref Contract Description Estimated Review Market Selection Shortlisti Expected Expected Date No. Cost (US$) by Bank Approach Method ng Date of Bid of Contract (Open- (QCBS, (Yes/No) Proposal Signature (Prior/Po National/ LCBCS, Opening st) Limited etc.) QBS, DS Prepare statistics regulations to be used C1 Prior Open INDIV N/A 3-Aug-20 17-Aug-20 along with the revised 20,000 Statistics Act. Hire a consultancy firm for the review the DNS organization structure, C2 Prior Open CQS N/A 10-Aug-20 31-Aug-20 develop and change 96,000 management strategy for DNS. Hire consultant to review the preparation C3 Prior Limited INDV N/A 10-July-20 24-Jul-20 of the project 20,000 operations manual. Hire consultant for C4 translation of the Prior Limited INDV N/A 15-July-20 31-July-20 10,000 Safeguard documents. Consultancy firm to provide support to the Somali Integrated Household Budget Open - C5 Prior CQS N/A 29-Sept-20 26-Oct-20 Survey on GIS and 240,000 International cluster mapping, and sampling frame development. Hire consultant to C6 undertake a Training Prior Open INDV N/A 11-Nov-20 30-Nov-20 80,000 needs assessment of all MDAs benefiting from SISECBP. Hire a consultancy firm to undertake ICT C7 needs assessment in Prior Open CQS N/A 17-Nov-20 1-Dec-20 100,000 all MDAs benefiting from the project. Hire consultancy firm to develop an ICT strategy for NSS, including detailed software and database design for data and metadata, data center C8 Prior Open CQS N/A 25-Jan-21 16-Feb-21 design, specifications 100,000 of data center hardware and software testing, integration and implementation of the hardware and statistical software Hire 4 Senior M&E consultants for 3 months to assist in Open C9 Prior INDV N/A 8-Oct-20 28-Oct-20 development of a 160,000 international national M&E Framework. C16 Hire consultants to undertake the following key policy research and studies for NEC: C16.1 Hire individual consultant to undertake research on 133,000 Prior Open INDV N/A 15-Seot -20 9-Oct-20 “Fiscal Federalism and Related Issues” – Paper 1. C16.2 Hire individual consultants to undertake research for 126,000 Prior Open INDV N/A 5-Oct -20 25-Oct-20 6 months on “Regional Economic Cooperation Analysis” Hiring of the C17 following PIU staff C17.1 Project N/A Coordinator for 6 30,810 Prior Open INDV 1-Jun-20 21-June-20 months C17.2 Technical N/A 25,980 Prior Open INDV 15-Jun-20 4-Jul-20 Manager for 6 months C17.3 Procurement 25,980 N/A Prior Open INDV 8-Jun-20 29-June-20 specialist for 6 months C17.4 Financial N/A Management specialist 25,980 Prior Open INDV 1-Jun-20 21-June-20 for 6 months C17.5 Secretary for 6 N/A 13,660 Prior Limited INDV 8-Jun-20 29-June-20 months C17.56ICT Specialist N/A 6,640 Prior Limited INDV 28-Jun-20 19-Jul-20 for 2 months C17.7 M&E Specialist N/A 6,640 Prior Limited INDV 24-Jun-20 16-Jul-20 for 2 months C17.8 Driver N/A 3,900 Prior Limited INDV 15-Jun-20 16-Jul-20 for the first 6 months. Hiring of the C18 following NEC staff. C18.1 Program N/A 68,000 Prior Open INDV 30-July-20 15-Aug-20 Manager for 8 months C18. Sector Economist for 6 N/A 33,000 Prior Open INDV 9-Aug-20 23-Aug-20 2 months C18.6 Office Manager N/A for the first 12 27,320 Prior Open INDV 30-July-20 15-Aug-20 months. C18.8 Driver N/A for the first 12 7,800 Prior Limited INDV 9-Aug-20 23-Aug-20 months. Hiring Senior N/A 10 June, C19 Statistician for DNS for 58,800 Prior Open INDV 30 June, 2020 2020 6 months Total Consulting 1,419,5 Services 10 Grand 1,540,0 Total 10 PROCUREMENT Somalia : Somali Integrated Statistics and Economic Planning Capacity Building PLAN General Information Country: Somalia Bank’s Approval Date of the Original Procurement Plan: 2020-07-22 2021-02-23 Revised Plan Date(s): (comma delineated, leave blank if none) Project ID: P171160 GPN Date: Project Name: Somali Integrated Statistics and Economic Planning Capacity Building Loan / Credit No: IDA / V3390, IDA / D6660 Ministry of Planning, Investment, and Economic Development Executing Agency(ies): WORKS Activity Reference No. / Estimated Actual Draft Bidding Bid Evaluation Report Loan / Credit Procurement Prequalification High SEA/SH Procurement Process Draft Pre-qualification Prequalification Specific Procurement Bidding Documents as Proposal Submission / Contract Description Component Review Type Method Market Approach Amount Amount Document / and Recommendation Signed Contract No. Process (Y/N) Risk Document Type Status Documents Evaluation Report Notice / Invitation Issued Opening / Minutes Completion (US$) (US$) Justification for Award Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned GOODS Activity Reference No. / Draft Bidding Bid Evaluation Report Loan / Credit Procurement Prequalification Estimated Actual Amount Process Draft Pre-qualification Prequalification Specific Procurement Bidding Documents as Proposal Submission / Description Component Review Type Method Market Approach Document / and Recommendation Signed Contract Contract Completion No. Process (Y/N) Amount (US$) (US$) Status Documents Evaluation Report Notice / Invitation Issued Opening / Minutes Justification for Award Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual SO-MOPIED-220465-GO- RFQ / Office furniture: Office cabinets, executive chairs, Component 3: Data Pending Request for tables, office decoration, IDA / D6660 utilization for Monitoring, Prior 56,400.00 0.00 Implementati 2021-02-27 2021-04-24 2021-10-21 Quotations doors, refrigerators, Library Evaluation, and Planning on office furnishing, and sofa seats for PIU NEC SO-MOPIED-220466-GO- Component 3: Data Pending RFQ / Motor vehicles ( Request for Single Stage - One IDA / D6660 utilization for Monitoring, Prior Limited 80,000.00 0.00 Implementati 2021-02-27 2021-04-24 2021-10-21 Purchase of 2 Vehicles ) for Quotations Envelope Evaluation, and Planning on PIU and NEC SO-MOPIED-220472-GO- RFQ / Computers and accessories; 14 Desktop and 16 laptop ,30 anti-virus Component 3: Data Pending software, 2 big printer with Request for Single Stage - One IDA / D6660 utilization for Monitoring, Prior Limited 94,560.00 0.00 Implementati 2021-02-27 2021-04-24 2021-10-21 photocopier, 9-3 in 1 Quotations Envelope Evaluation, and Planning on printers, 2 Projector,1TV Screen,1 camera, 1VCT, 2 STATA single user license and 4 Microsoft Office 365 for PIU and NEC NON CONSULTING SERVICES Activity Reference No. / Draft Bidding Bid Evaluation Report Loan / Credit Procurement Prequalification Estimated Actual Amount Process Draft Pre-qualification Prequalification Specific Procurement Bidding Documents as Proposal Submission / Description Component Review Type Method Market Approach Document / and Recommendation Signed Contract Contract Completion No. Process (Y/N) Amount (US$) (US$) Status Documents Evaluation Report Notice / Invitation Issued Opening / Minutes Justification for Award Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual SO-MOPIED-220477-NC- Pending Component 4: Project Request for Single Stage - One RFQ / Office Internet Service IDA / D6660 Prior Limited 30,000.00 0.00 Implementati 2021-02-27 2021-04-24 2021-10-21 management Quotations Envelope for the PIU on CONSULTING FIRMS Activity Reference No. / Combined Evaluation Loan / Credit Contract Type Estimated Actual Amount Expression of Interest Short List and Draft Request for Proposals Opening of Technical Evaluation of Description Component Review Type Method Market Approach Process Status Terms of Reference Report and Draft Signed Contract Contract Completion No. Amount (US$) (US$) Notice Request for Proposals as Issued Proposals / Minutes Technical Proposal Negotiated Contract Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Component 1: SO-MOPIED-210302-CS- Strengthening coordination, QCBS / INSTITUTIONAL Quality And Cost- IDA / D6660 statistical infrastructure and Prior Open - National 96,000.00 0.00 Canceled 2020-12-27 2021-01-17 2021-03-02 2021-03-30 2021-04-29 2021-06-03 2021-07-08 2021-10-06 DEVELOPMENT CONSULTANCY Based Selection data development of the FOR NBS national statistical syste m SO-MOPIED-210308-CS- Component 2: ICT Quality And Cost- Under QCBS / ICT NEEDS IDA / D6660 development and equipment Prior Open - International 100,000.00 0.00 2020-12-30 2021-01-08 2021-01-20 2021-03-05 2021-04-02 2021-05-02 2021-06-06 2021-07-11 2021-10-09 Based Selection Implementation ASSESSMENT of the national statistical system Component 2: ICT Consultant SO-MOPIED-215438-CS-CQS Under IDA / D6660 development and equipment Prior Qualification Open - National 100,000.00 0.00 2021-01-31 2021-02-04 2021-02-21 2021-02-17 2021-04-06 2021-05-06 2021-06-10 2021-09-08 / ICT needs assessment Implementation of the national statistical Selection system Component 1: SO-MOPIED-210418-CS- Strengthening coordination, Quality And Cost- QCBS / Training Needs IDA / D6660 statistical infrastructure and Prior Open - National 80,000.00 0.00 Canceled 2020-12-30 2021-01-07 2021-01-20 2021-03-05 2021-04-02 2021-05-02 2021-06-06 2021-07-11 2021-10-29 Based Selection Assessment for all MDS data development of the national statistical syste m Component 1: SO-MOPIED-216963-CS-CQS Strengthening coordination, Consultant / Institutional Development IDA / D6660 statistical infrastructure and Prior Qualification Open - National 96,000.00 0.00 Under Review 2021-02-10 2021-03-03 2021-04-16 2021-05-16 2021-06-20 2021-12-17 Consultancy data development of the Selection national statistical syste m INDIVIDUAL CONSULTANTS Activity Reference No. / Invitation to Loan / Credit Contract Type Estimated Actual Amount Draft Negotiated Description Component Review Type Method Market Approach Process Status Terms of Reference Identified/Selected Signed Contract Contract Completion No. Amount (US$) (US$) Contract Consultant Planned Actual Planned Actual Planned Actual Planned Actual Planned Actual Individual SO-MOPIED-184787-CS- Component 4: Project IDA / V3390 Prior Consultant Open 30,810.00 80,280.00 Signed 2020-07-20 2020-08-04 2020-09-07 2020-11-23 2020-09-28 2020-12-08 2020-11-02 2020-11-30 2021-11-02 INDV / Project Coordinator management Selection Individual SO-MOPIED-184789-CS- Component 4: Project Under IDA / V3390 Prior Consultant Open 25,980.00 0.00 2020-07-20 2020-08-04 2020-09-07 2020-09-28 2020-11-02 2021-11-02 INDV / Technical Manager management Implementation Selection Page 1 SO-MOPIED-184790-CS- Individual Component 4: Project INDV / Financial Management IDA / V3390 Prior Consultant Open 25,980.00 64,680.00 Signed 2020-07-20 2020-08-10 2020-09-07 2020-11-23 2020-09-28 2020-11-28 2020-11-02 2020-11-30 2021-11-02 management Specialist Selection Individual SO-MOPIED-184794-CS- Component 4: Project Under IDA / V3390 Prior Consultant Limited 6,640.00 0.00 2020-07-20 2021-01-05 2020-07-25 2020-08-15 2020-09-19 2021-01-17 INDV / M&E Specialist management Implementation Selection Individual SO-MOPIED-184795-CS- Component 4: Project Under IDA / V3390 Prior Consultant Limited 13,660.00 0.00 2020-07-20 2020-08-10 2020-07-25 2021-02-04 2020-08-15 2020-09-19 2021-09-19 INDV / Secretary management Implementation Selection Individual SO-MOPIED-184797-CS- Component 4: Project IDA / V3390 Prior Consultant Open 25,980.00 67,560.00 Signed 2020-07-20 2020-08-04 2020-09-07 2020-11-23 2020-09-28 2020-12-08 2020-11-02 2020-11-30 2021-11-02 INDV / Procurement specialist management Selection Component 3: Data SO-MOPIED-188749-CS-CDS IDA / V3390 utilization for Monitoring, Prior Direct Selection Direct 68,000.00 100,460.00 Signed 2020-08-15 2020-08-15 2020-08-25 2020-10-27 2020-10-29 2020-11-17 2021-10-29 / NEC Program Manager Evaluation, and Planning Component 3: Data SO-MOPIED-188753-CS-CDS IDA / V3390 utilization for Monitoring, Prior Direct Selection Direct 33,000.00 64,680.00 Signed 2020-08-15 2020-08-15 2020-08-25 2020-10-27 2020-10-29 2020-11-17 2021-10-29 / NEC Sector Economist Evaluation, and Planning SO-MOPIED-210276-CS- Component 3: Data Individual Under INDV / NEC Senior IDA / D6660 utilization for Monitoring, Prior Consultant Open 98,400.00 0.00 2020-12-27 2021-01-04 2021-02-14 2021-03-07 2021-04-11 2022-04-11 Implementation Macroeconomics Specialist Evaluation, and Planning Selection Component 3: Data Individual SO-MOPIED-210284-CS- Under IDA / D6660 utilization for Monitoring, Prior Consultant Open 27,320.00 0.00 2020-12-27 2021-01-04 2021-02-14 2021-03-07 2021-04-11 2022-04-11 INDV / NEC Office Manager Implementation Evaluation, and Planning Selection SO-MOPIED-210292-CS- Component 3: Data Individual Under INDV / NEC Finance and IDA / D6660 utilization for Monitoring, Prior Consultant Open 58,764.00 0.00 2020-12-27 2021-01-26 2021-02-14 2021-03-07 2021-04-11 2022-04-11 Implementation Accounting Manager Evaluation, and Planning Selection SO-MOPIED-210294-CS- Component 3: Data Individual INDV / NEC Communication Under IDA / D6660 utilization for Monitoring, Prior Consultant Open 45,876.00 0.00 2020-12-27 2021-01-04 2021-02-14 2021-03-07 2021-04-11 2022-04-11 and public relations Implementation Evaluation, and Planning Selection Specialists Component 1: Strengthening coordination, Individual SO-MOPIED-211634-CS- Under IDA / D6660 statistical infrastructure and Prior Consultant Limited 58,800.00 0.00 2020-12-27 2020-12-30 2021-01-01 2021-02-04 2021-01-22 2021-02-26 2022-02-26 INDV / NBS Senior Statistician Implementation data development of the Selection national statistical syste m SO-MOPIED-210369-CS- Individual Component 4: Project Under INDV / PIU Communication IDA / D6660 Prior Consultant Limited 51,960.00 0.00 2020-12-27 2021-01-01 2021-01-22 2021-02-26 2022-02-26 management Implementation specialist Selection SO-MOPIED-211638-CS- Individual Component 4: Project Under INDV / Safeguard documents IDA / D6660 Prior Consultant Limited 10,000.00 0.00 2020-12-27 2020-12-30 2021-01-01 2021-02-04 2021-01-22 2021-02-26 2021-03-28 management Implementation translation Selection Individual SO-MOPIED-184791-CS- Component 4: Project IDA / V3390 Prior Consultant Limited 6,640.00 0.00 Canceled 2020-07-20 2020-07-25 2020-08-15 2020-09-19 2021-01-17 INDV / ICT Specialist management Selection Component 1: SO-MOPIED-216960-CS- Strengthening coordination, Individual Under INDV / Training Needs IDA / D6660 statistical infrastructure and Prior Consultant Open 80,000.00 0.00 2021-02-04 2021-02-04 2021-03-25 2021-04-15 2021-05-20 2021-11-16 Implementation Assessment Consultant data development of the Selection national statistical syste m Component 3: Data SO-MOPIED-217770-CS-CDS Under IDA / D6660 utilization for Monitoring, Prior Direct Selection Direct 17,500.00 0.00 2021-02-10 2021-02-09 2021-02-20 2021-02-14 2021-04-26 2021-10-23 / NEC Hawala Systems Expert Implementation Evaluation, and Planning Component 3: Data SO-MOPIED-217773-CS-CDS Under IDA / D6660 utilization for Monitoring, Prior Direct Selection Direct 17,500.00 0.00 2021-02-10 2021-02-09 2021-02-20 2021-02-14 2021-04-26 2021-10-23 / NEC Health Systems Expert Implementation Evaluation, and Planning SO-MOPIED-217777-CS-CDS Component 3: Data Under / NEC Macroeconomist and IDA / D6660 utilization for Monitoring, Prior Direct Selection Direct 22,500.00 0.00 2021-02-10 2021-02-09 2021-02-20 2021-02-14 2021-04-26 2021-10-23 Implementation Lead Researcher Evaluation, and Planning SO-MOPIED-217783-CS-CDS Component 3: Data Under / NEC Remittance Analysis IDA / D6660 utilization for Monitoring, Prior Direct Selection Direct 17,500.00 0.00 2021-02-10 2021-02-09 2021-02-20 2021-02-14 2021-04-26 2021-10-23 Implementation Expert Evaluation, and Planning SO-MOPIED-217786-CS-CDS Component 3: Data Under / NEC Healthcare Institutions IDA / D6660 utilization for Monitoring, Prior Direct Selection Direct 17,500.00 0.00 2021-02-10 2021-02-09 2021-02-20 2021-02-14 2021-04-26 2021-10-23 Implementation Capacity Development Expert Evaluation, and Planning Page 2