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 2020-12-28 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 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 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- Pending IDA / D6660 statistical infrastructure and Prior Open - National 96,000.00 0.00 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 Implementation data development of the FOR NBS national statistical syste m SO-MOPIED-210308-CS- Component 2: ICT Quality And Cost- Pending QCBS / ICT NEEDS IDA / D6660 development and equipment Prior Open - International 100,000.00 0.00 2020-12-30 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 1: SO-MOPIED-210418-CS- Strengthening coordination, Quality And Cost- Pending QCBS / Training Needs IDA / D6660 statistical infrastructure and Prior Open - National 80,000.00 0.00 2020-12-30 2021-01-20 2021-03-05 2021-04-02 2021-05-02 2021-06-06 2021-07-11 2021-10-29 Based Selection Implementation Assessment for all MDS data development of the 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 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-184791-CS- Component 4: Project Under IDA / V3390 Prior Consultant Limited 6,640.00 0.00 2020-07-20 2020-07-25 2020-08-15 2020-09-19 2021-01-17 INDV / ICT Specialist management Implementation Selection Individual SO-MOPIED-184794-CS- Component 4: Project Under IDA / V3390 Prior Consultant Limited 6,640.00 0.00 2020-07-20 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 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 Pending INDV / NEC Senior IDA / D6660 utilization for Monitoring, Prior Consultant Open 98,400.00 0.00 2020-12-27 2021-02-14 2021-03-07 2021-04-11 2022-04-11 Implementation Macroeconomics Specialist Evaluation, and Planning Selection Page 1 Component 3: Data Individual SO-MOPIED-210284-CS- Pending IDA / D6660 utilization for Monitoring, Prior Consultant Open 27,320.00 0.00 2020-12-27 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 Pending INDV / NEC Finance and IDA / D6660 utilization for Monitoring, Prior Consultant Open 58,764.00 0.00 2020-12-27 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 Pending IDA / D6660 utilization for Monitoring, Prior Consultant Open 45,876.00 0.00 2020-12-27 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- Pending IDA / D6660 statistical infrastructure and Prior Consultant Limited 58,800.00 0.00 2020-12-27 2021-01-01 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 Pending 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 Pending INDV / Safeguard documents IDA / D6660 Prior Consultant Limited 10,000.00 0.00 2020-12-27 2021-01-01 2021-01-22 2021-02-26 2021-03-28 management Implementation translation Selection Page 2