Procurement Plan-Works Country/Organisation: Nigeria/ Kaduna State Water Board Project/Programme: National Urban Water Sector Reform Project/ Additional Financing Draft Bid Documents, If Post-Review, No-objection Dates are not needed including specs and Spec Proc Loan #: CR 4784 -NG Basic Data Bidding Period Bid Evaluation Contract Finalization Contract Implementation quantities, draft SPN Notice Advert Lumpsum or Plan Prep & No- On-line UNDB Bid Submission No- Plan Date Date Date Plan Mobilization Package Lot Procurement Estimated Amount in Pre-or Post Prior or Bid Closing- Contract Amount in Substantial Final Final Description* Bill of vs. Submission objection Gateway Invitation Bid Eval objection vs. Contract Contract Contract vs. Advance Number Number Method US $ Qualification Post Review Opening US$ Completion Acceptance Cost Quantities Actual by Ex Agency Date Nat Press Date Rpt Date Actual Award Advert Signature Actual Payment If Prequalification Plan 4 - 7 wks 1 - 1.5 wks 1.5 - 2 wks 1.5 - 2 wks 6 to 12 wks 1.5 - 3 wks Plan 1 wk 1.5-3 wks Plan Norm Duration of Proc Steps add 7-13 wks Actual Actual Actual List of Contracts Kaduna North Old Water Works [M&E] 1 BOQ ICB Post Prior Plan 15 Feb, 12 24 Feb, 12 05 Mar, 12 05 Mar, 12 09 Apr, 12 07 May, 12 18 May, 12 Plan 25 May, 12 28 May, 12 11 Jun, 12 Plan 25 Jun, 12 25 May 13 25 Jun, 13 Kaduna North Old Water Works [M&E] Actual Actual Actual 2 BOQ ICB Post Prior Plan 15 Feb, 12 24 Feb, 12 05 Mar, 12 05 Mar, 12 09 Apr, 12 07 May, 12 18 May, 12 Plan 25 May, 12 28 May, 12 11 Jun, 12 Plan 25 Jun, 12 25 May 13 25 Jun, 13 Kaduna North New Plant [M&E] Actual Actual Actual 3 BOQ ICB Post Prior Plan 15 Feb, 12 24 Feb, 12 05 Mar, 12 05 Mar, 12 09 Apr, 12 07 May, 12 18 May, 12 Plan 25 May, 12 28 May, 12 11 Jun, 12 Plan 25 Jun, 12 25 May 13 25 Jun, 13 Kaduna South Plant [M&E] Actual Actual Actual 4 BOQ ICB Post Prior Plan 15 Feb, 12 24 Feb, 12 05 Mar, 12 05 Mar, 12 09 Apr, 12 07 May, 12 18 May, 12 Plan 25 May, 12 28 May, 12 11 Jun, 12 Plan 25 Jun, 12 25 May 13 25 Jun, 13 Booster Stations - M&E Works KSWB/NUWSRP/IC 22,426,566.67 22,426,566.67 B/WORKS/01/12 Actual Actual Actual Civil Works in KNOWW, KNNWW and 5 BOQ ICB Post Prior Plan 15 Feb, 12 24 Feb, 12 05 Mar, 12 05 Mar, 12 09 Apr, 12 07 May, 12 18 May, 12 Plan 25 May, 12 28 May, 12 11 Jun, 12 Plan 25 Jun, 12 25 May 13 25 Jun, 13 KSWW Actual Actual Actual Replacement of some existing AC pipes in 6 BOQ ICB Post Prior Plan 15 Feb, 12 24 Feb, 12 05 Mar, 12 05 Mar, 12 09 Apr, 12 07 May, 12 18 May, 12 Plan 25 May, 12 28 May, 12 11 Jun, 12 Plan 25 Jun, 12 25 May 13 25 Jun, 13 Kaduna Metropolis Actual Actual Actual Extension of distribution network in some areas 7 of Kaduna Metropolis BOQ ICB Post Prior Plan 15 Feb, 12 24 Feb, 12 05 Mar, 12 05 Mar, 12 09 Apr, 12 07 May, 12 18 May, 12 Plan 25 May, 12 28 May, 12 11 Jun, 12 Plan 25 Jun, 12 25 May 13 25 Jun, 13 Installation of HDPE Lateral Pipes and De- 1 BOQ SHOPPING 100,000.00 Post Post Plan NA NA NA 01 Dec, 11 08 Dec, 11 NA NA Plan 100,000.00 13 Dec, 11 NA 15 Dec, 11 Plan NA 15 Feb, 12 20 Feb, 12 Silting of Clarifiers IFB/KSWB/NUWSRP/SH OPPING/11/1 Actual 14 Dec, 11 27 Dec, 11 NA NA Actual 28 Dec, 11 NA 29 Dec, 11 Actual Rehabilitation of fence, Plant Manager's Office BOQ NCB 140,000.00 Post Post Plan NA NA 06 Feb, 12 06 Feb, 12 05 March, 12 NA NA Plan 140,000.00 02 Apr, 12 05 Apr, 12 19 Apr, 12 Plan 03 May, 12 19 Jul, 12 17 Aug, 12 and roofing, etc at KNNWW and KNOWW 1 Actual Actual Actual KSWB/NUWSRP/NCB/ Construction of New Plant Manager's Office and WORKDS/02/12 2 BOQ NCB 134,000.00 Post Post Plan NA NA 06 Feb, 12 06 Feb, 12 05 March, 12 NA NA Plan 134,000.00 02 Apr, 12 05 Apr, 12 19 Apr, 12 Plan 03 May, 12 19 Jul, 12 17 Aug, 12 Repair of Treatment Plant Facilities at KSWW Actual Actual Actual Improvement of Water Supply to 1 BOQ Post Post Plan NA NA 06 Feb, 12 06 Feb, 12 05 March, 12 NA NA Plan 02 Apr, 12 05 Apr, 12 19 Apr, 12 Plan 03 May, 12 19 Jul, 12 17 Aug, 12 Goubarau/Degel Road, Actual Actual Actual Improvement of Water Supply to Kigo New 2 BOQ Post Post Plan NA NA 06 Feb, 12 06 Feb, 12 05 March, 12 NA NA Plan 02 Apr, 12 05 Apr, 12 19 Apr, 12 Plan 03 May, 12 19 Jul, 12 17 Aug, 12 Extension Actual Actual Actual 3 BOQ Post Post Plan NA NA 06 Feb, 12 06 Feb, 12 05 March, 12 NA NA Plan 02 Apr, 12 05 Apr, 12 19 Apr, 12 Plan 03 May, 12 19 Jul, 12 17 Aug, 12 Improvement of Water Supply to Unguwan Rimi Actual Actual Actual Improvement of Water Supply to Gongola Road 4 BOQ Post Post Plan NA NA 06 Feb, 12 06 Feb, 12 05 March, 12 NA NA Plan 02 Apr, 12 05 Apr, 12 19 Apr, 12 Plan 03 May, 12 19 Jul, 12 17 Aug, 12 KSWB/NUWSRP/NCB/ Barnawa NCB 365,433.33 365,433.33 WORKS/03/12 Actual Actual Actual 5 BOQ Post Post Plan NA NA 06 Feb, 12 06 Feb, 12 05 March, 12 NA NA Plan 02 Apr, 12 05 Apr, 12 19 Apr, 12 Plan 03 May, 12 19 Jul, 12 17 Aug, 12 Improvement of Water Supply to Narayi High Cost Behind NITEL Quarters Actual Actual Actual 6 BOQ Post Post Plan NA NA 06 Feb, 12 06 Feb, 12 05 March, 12 NA NA Plan 02 Apr, 12 05 Apr, 12 19 Apr, 12 Plan 03 May, 12 19 Jul, 12 17 Aug, 12 Improvement of Water Supply to Bayan Dutse Actual Actual Actual 7 BOQ Post Post Plan NA NA 06 Feb, 12 06 Feb, 12 05 March, 12 NA NA Plan 02 Apr, 12 05 Apr, 12 19 Apr, 12 Plan 03 May, 12 19 Jul, 12 17 Aug, 12 Improvement of Water Supply to NAFDAC Road Actual Actual Actual 673790PROP0P070872B0Kaduna0NUWSRP01.xls 1 of 6 03/12/2012 1:28 AM Procurement Plan-Works Lot 1: Rehabilitation of Zaria Water Supply 1 BOQ NCB 656,000.00 Post Post Plan NA NA 20 Feb, 12 20 Feb, 12 19 Mar, 12 NA NA Plan 656,000.00 16 Apr, 12 19 Apr, 12 30 Apr, 12 Plan 14 May, 12 14 Apr, 13 14 May, 13 System Actual Actual Actual 2 BOQ NCB 1,140,000.00 Post Post Plan NA NA 20 Feb, 12 20 Feb, 12 19 Mar, 12 NA NA Plan 1,140,000.00 16 Apr, 12 19 Apr, 12 30 Apr, 12 Plan 14 May, 12 14 Apr, 13 14 May, 13 Lot 2: Rehabilitation of Kafanchan/Kagoro Water Supply System Actual Actual Actual KSWB/NUWSRP/N CB/WORKS/03/11 Lot 3: Rehabilitation of Zonkwa Water Supply 3 BOQ NCB 700,000.00 Post Post Plan NA NA 20 Feb, 12 20 Feb, 12 19 Mar, 12 NA NA Plan 700,000.00 16 Apr, 12 19 Apr, 12 30 Apr, 12 Plan 14 May, 12 14 Apr, 13 14 May, 13 System. Actual Actual ] Actual Lot 4: Rehabilitation of Saminaka Water 4 BOQ NCB 400,000.00 Post Post Plan NA NA 20 Feb, 12 20 Feb, 12 19 Mar, 12 NA NA Plan 400,000.00 16 Apr, 12 19 Apr, 12 30 Apr, 12 Plan 14 May, 12 14 Apr, 13 14 May, 13 Supply System. Actual Actual Actual Plan Plan Plan Actual Actual Actual Total Cost 26,062,000.00 Plan Plan 26,062,000.00 Plan 0.00 0.00 Actual Actual 0.00 Actual 0.00 Fill gray cells only! NCB - National Competative Bidding DC - Direct Contracting ICB - International Competitative Bidding 673790PROP0P070872B0Kaduna0NUWSRP01.xls 2 of 6 03/12/2012 1:28 AM Procurement Plan-Goods Country/Organisation: Nigeria / Kaduna State Water Board Project/Programme: National Urban Water Sector Reform Project / Additional Financing If Post-Review, No-objection Dates are not needed Loan #: Draft Bid Documents, including specs Spec Proc Notice CR 4784 -NG BASIC DATA and quantities, draft SPN Bidding Period Bid Evaluation Contract Finalization Contract Implementation Advert On-line UNDB No- Date Date Date Opening Arrival Inspection Package Lot Estimated Amount in US Procurement Pre-or Post Prior or Post Prep & Submission No-objection Bid Invitation Bid Closing- Submission Plan vs. Contract Description* Plan vs. Actual Gateway objection Contract Contract Contract of of Final Number Number $ Method Qualification Review by Ex Agency Date Date Opening Bid Eval Rpt Actual Amount in US$ Nat Press Date Award Advert Signature Let of Credit Goods Acceptance Norm Duration of Proc Steps If Prequalification Plan 4 - 7 wks 1 - 1.5 wks 1.5 - 2 wks 6 to 12 wks 1.5 - 3 wks 1 - 1.5 wks Plan 1 wk 1.5-3 wks add 7-13 wks Actual Actual List of Contracts Supply of Alum (3,600Mt) 1,920,000.00 Post Prior Plan 10 Feb, 11 18 Feb, 11 14 Oct, 11 14 Oct, 11 02 Nov, 11 06 Feb, 12 17 Feb, 12 Plan 1,920,000.00 24 Feb, 12 28 Feb, 12 13 Mar, 12 27 Mar, 12 26 Jun, 12 02 Jul, 12 1 Actual 06 Jun, 11 28 Jul, 11 05 Oct, 11 05 Sep, 11 09 Nov, 11 Actual date Supply of Liquid Chlorine (75mt) 435,000.00 Post Prior Plan 10 Feb, 11 18 Feb, 11 14 Oct, 11 14 Oct, 11 02 Nov, 11 06 Feb, 12 17 Feb, 12 Plan 435,000.00 24 Feb, 12 28 Feb, 12 13 Mar, 12 27 Mar, 12 26 Jun, 12 02 Jul, 12 2 KSWB/NUWSRP/ICB/GOOD Actual 06 Jun, 11 28 Jul, 11 05 Oct, 11 05 Sep, 11 09 Nov, 11 Actual S/01/12 Supply of HTH (200mt) ICB 250,000.00 Post Prior Plan 10 Feb, 11 18 Feb, 11 14 Oct, 11 14 Oct, 11 02 Nov, 11 06 Feb, 12 17 Feb, 12 Plan 250,000.00 24 Feb, 12 28 Feb, 12 13 Mar, 12 27 Mar, 12 26 Jun, 12 02 Jul, 12 3 Actual 06 Jun, 11 28 Jul, 11 05 Oct, 11 05 Sep, 11 09 Nov, 11 Actual Supply of HTH Chipping 100,000.00 Post Prior Plan 10 Feb, 11 18 Feb, 11 14 Oct, 11 14 Oct, 11 02 Nov, 11 06 Feb, 12 17 Feb, 12 Plan 100,000.00 24 Feb, 12 28 Feb, 12 13 Mar, 12 27 Mar, 12 26 Jun, 12 02 Jul, 12 4 Actual 06 Jun, 11 28 Jul, 11 05 Oct, 11 05 Sep, 11 09 Nov, 11 Actual Supply & Installation of Dom, Ind. & Bulk Meters KSWB/NUWSRP/ICB/GOOD 2,140,000.00 Post Prior Plan 22 Feb, 12 05 Mar, 12 15 Mar, 12 19 Mar, 12 16 Apr, 12 30 Apr, 12 11 May, 12 Plan 2,140,000.00 11 May, 12 15 May, 12 29 May, 12 08 Jun, 12 11 Sep, 12 14 Sep, 12 1 S/02/12 Actual Actual Procurement of pipes & fittings for maintenance of distribution network in the Project towns (Kaduna, 200,000.00 NCB Post Post Plan NA NA 27 Feb, 12 27 Feb, 12 27 Mar, 12 NA NA Plan 200,000.00 10 Apr, 12 13 Apr, 12 26 Apr, 12 10 May, 12 02 Aug, 12 06 Aug, 12 Zaria, Kafanchan, Kagoro, Zonkwa and Saminka) 1 Actual Actual Procurement of maintenance tools, compressor & jack hammer for the Project towns (Kaduna, Zaria, 200,000.00 NCB Post Post Plan NA NA 27 Feb, 12 27 Feb, 12 27 Mar, 12 NA NA Plan 200,000.00 10 Apr, 12 13 Apr, 12 26 Apr, 12 10 May, 12 02 Aug, 12 06 Aug, 12 Kafanchan, Kagoro, Zonkwa and Saminaka) 2 KSWB/NUWSRP/NCB/GOO Actual Actual DS/01/12 Supply of House connection materials for the Project towns (Kaduna, Zaria, Kafanchan, Kagoro, Zonkwa and 200,000.00 NCB Post Post Plan NA NA 27 Feb, 12 27 Feb, 12 27 Mar, 12 NA NA Plan 200,000.00 10 Apr, 12 13 Apr, 12 26 Apr, 12 10 May, 12 02 Aug, 12 06 Aug, 12 Saminaka) 3 Actual Actual Supply & installation of computer hardware for billing 80,000.00 NCB Post Post Plan NA NA 27 Feb, 12 27 Feb, 12 27 Mar, 12 NA NA Plan 80,000.00 10 Apr, 12 13 Apr, 12 26 Apr, 12 10 May, 12 02 Aug, 12 06 Aug, 12 and accounting 4 Actual Actual Supply & Installation of closed Television cameras at malali Plants IFB/KSWB/NUWSRP/SHOPP 32,000.00 SHOPPING Post Post Plan NA NA NA 12 Mar, 12 26 Mar, 12 NA NA Plan 32,000.00 02 Apr, 12 NA 12 Apr, 12 NA 12 Jul, 12 16 Jul, 12 1 ING/GOODS/01/12 Actual Actual Supply and Installation of Internet Communication Facilities in Districts/Plants IFB/KSWB/NUWSRP/SHOPP 15,200.00 SHOPPING Post Post Plan NA NA NA 12 Mar, 12 26 Mar, 12 NA NA Plan 15,200.00 02 Apr, 12 NA 12 Apr, 12 NA 12 Jul, 12 16 Jul, 12 1 ING/GOODS/02/12 Actual Actual Supply & Installation of office equipment and furniture for PIU 50,000.00 NCB Post Post Plan NA NA 05 Mar, 12 05 Mar, 12 04 Apr, 12 NA NA Plan 50,000.00 18 Apr, 12 25 Apr, 12 09 May, 12 23 May, 12 23 Jul, 12 27 Jul, 12 1 Actual Actual Supply & Installation of office equipment and furniture SWA Kaduna KSWB/NUWSRP/NCB/GOO 100,000.00 NCB Post Post Plan NA NA 05 Mar, 12 05 Mar, 12 04 Apr, 12 NA NA Plan 100,000.00 18 Apr, 12 25 Apr, 12 09 May, 12 23 May, 12 23 Jul, 12 27 Jul, 12 2 DS/02/12 Actual Actual Supply & Installation of office equipment and furniture SWA Other towns 50,000.00 NCB Post Post Plan NA NA 05 Mar, 12 05 Mar, 12 04 Apr, 12 NA NA Plan 50,000.00 18 Apr, 12 25 Apr, 12 09 May, 12 23 May, 12 23 Jul, 12 27 Jul, 12 3 Actual Actual 673790PROP0P070872B0Kaduna0NUWSRP01.xls 3 of 6 03/12/2012 1:28 AM Procurement Plan-Goods Supply installation of software for billing centre 80,000.00 Post Post Plan NA NA 15 Feb, 12 15 Feb, 12 16 Mar, 12 NA NA Plan 80,000.00 30 Mar, 12 04 Apr, 12 18 Apr, 12 02 May, 12 01 Aug, 12 06 Aug, 12 1 Actual Actual Supply & installation of software for accounting centre 60,000.00 Post Post Plan NA NA 15 Feb, 12 15 Feb, 12 16 Mar, 12 NA NA Plan 60,000.00 30 Mar, 12 04 Apr, 12 18 Apr, 12 02 May, 12 01 Aug, 12 06 Aug, 12 2 Actual Actual Supply of Health &Safety Equipments 200,000.00 Post Post Plan NA NA 15 Feb, 12 15 Feb, 12 16 Mar, 12 NA NA Plan 200,000.00 30 Mar, 12 04 Apr, 12 18 Apr, 12 02 May, 12 01 Aug, 12 06 Aug, 12 3 Actual Actual Supply & installation of lab equipment 300,000.00 Post Post Plan NA NA 15 Feb, 12 15 Feb, 12 16 Mar, 12 NA NA Plan 300,000.00 30 Mar, 12 04 Apr, 12 18 Apr, 12 02 May, 12 01 Aug, 12 06 Aug, 12 4 Actual Actual KSWB/NUWSRP/NCB/GOO Supply of Project Supervision, operational vehicles & 600,000.00 NCB Post Post Plan NA NA 15 Feb, 12 15 Feb, 12 16 Mar, 12 NA NA Plan 600,000.00 30 Mar, 12 04 Apr, 12 18 Apr, 12 02 May, 12 01 Aug, 12 06 Aug, 12 DS/03/12 motor cycles 5 Actual Actual Supply & Installation of Metrological equipment 80,000.00 Post Post Plan NA NA 15 Feb, 12 15 Feb, 12 16 Mar, 12 NA NA Plan 80,000.00 30 Mar, 12 04 Apr, 12 18 Apr, 12 02 May, 12 01 Aug, 12 06 Aug, 12 6 Actual Actual Supply & Installation of office equipment 200,000.00 Post Post Plan NA NA 15 Feb, 12 15 Feb, 12 16 Mar, 12 NA NA Plan 200,000.00 30 Mar, 12 04 Apr, 12 18 Apr, 12 02 May, 12 01 Aug, 12 06 Aug, 12 7 Actual Actual Supply and Installation of Radio Communications 120,000.00 Post Post Plan NA NA 15 Feb, 12 15 Feb, 12 16 Mar, 12 NA NA Plan 120,000.00 30 Mar, 12 04 Apr, 12 18 Apr, 12 02 May, 12 01 Aug, 12 06 Aug, 12 8 Actual Actual Billing and Accounting Centres Consumables 200,000.00 Post Post Plan NA NA 15 Feb, 12 15 Feb, 12 16 Mar, 12 NA NA Plan 200,000.00 30 Mar, 12 04 Apr, 12 18 Apr, 12 02 May, 12 01 Aug, 12 06 Aug, 12 9 Actual Actual Plan Plan Actual Actual Total Cost 7,612,200.00 Plan Plan 5,845,000.00 0.00 Actual Actual 0.00 Fill gray cells only! 673790PROP0P070872B0Kaduna0NUWSRP01.xls 4 of 6 03/12/2012 1:28 AM Procurement Plan-Consultants 67379 Country/Organisation: Nigeria / Kaduna State Water Board Project/Programme: National Urban Water Sector Reform Project / Additional Financing Loan #: Request for EOI Proposal Evaluation and Negotiation for Projects after May Contract Preparation Short Consultant CR 4784 -NG (where required) 2002 Draft Contract Contract Finalization Contract Implementation Type Request for Proposals List Proposals Technical (T) & Financial (F) and Negotions (N) Description* Lumpsum Estimated Prep & No- On-line Lead-time No- Submission Submission No- Opening Preparatio Plan vs. No- Contract Date Mobilization Prior/Post Plan vs. UNDB Submission Plan vs. Invitation / Negotiation Submission Contract Contract Plan vs. Draft Final Item No. Selection Method or Amount Submission objection before objection Evaluation objection Financial n Actual objection Amount in Contract Advance Review Actual Gateway Date Actual Date Opening Report (T) Evaluation Proposals Eval s (N) Date Award Signature Actual Report Report Time-Based in US$ by Ex Ag Date shortlist Date Date US$ Advert Payment Nat Press Date Report (T) Report Norm Duration of Proc Steps Plan 3 - 6 wks 1 - 2 wks 1 - 1.5 wks 2 wks 1 - 2 wks Plan 4 to 12 wks 2 - 3 wks 0.5 - 2 wks 2 wks 1 - 2 wks 2 wks Plan 1 - 2 wks 1 - 2 wks 1 wk 1 - 3 wks Plan Actual Actual Actual Actual List of Contracts 3.1 New Consulting Services 1,260,000.00 Plan 20 Feb, 12 12 Mar, 12 NA NA NA NA Plan 26 Mar, 12 23 Apr, 12 07 May 12 14 May, 12 28 May, 12 08 Jun, 12 18, Jun, 12 Plan 25 Jun, 12 09 Jul, 12 1,260,000.00 16 Jul, 12 18 Jul, 12 01 Aug, 12 Plan 15 Aug, 12 15 Jul, 13 15 Aug, 13 Construction Supervision (Kaduna + Other Lumpsum 3.1.1 SSS Prior Towns) Supervision Additional Works Actual Actual Actual Actual Detailed Engineering Design for Kaduna Met Lumpsum 986,295.74 Plan 20 Feb, 12 12 Mar, 12 NA NA NA NA Plan 26 Mar, 12 23 Apr, 12 07 May 12 14 May, 12 28 May, 12 08 Jun, 12 18, Jun, 12 Plan 25 Jun, 12 09 Jul, 12 986,295.74 16 Jul, 12 18 Jul, 12 01 Aug, 12 Plan 15 Aug, 12 15 Jul, 13 15 Aug, 13 3.1.2 SSS Prior WS Expansion Actual Actual Actual Actual Customer enumeration for Kaf/kwoi/B/Gwari Lumpsum 100,000.00 Plan NA NA 08 Feb, 12 22 Feb, 12 NA NA Plan 07 Mar, 12 04 Apr, 12 NA NA NA 18 Apr, 12 02 May, 12 Plan NA NA 100,000.00 16 May, 12 NA 23 May, 12 Plan 06 Jun, 12 06 Nov, 12 06 Dec, 12 3.1.2 CQS Post etc Actual Actual Actual Actual 600,000.00 Plan 06 Feb, 12 20 Feb, 12 27 Feb, 12 12 Mar, 12 19 Mar, 12 26 Mar, 12 Plan 02 Apr, 12 30 Apr, 12 14 May, 12 21 May, 12 28 May, 12 07 Jun, 12 14 Jun, 12 Plan 21 Jun, 12 28 Jun, 12 600,000.00 02 Jul, 12 02 Jul, 12 12 Jul, 12 Plan 19 Jul, 12 19 Dec, 12 19 Jan, 13 3.1.3 PPP in revenue generation and collection QCBS Lumpsum Prior Actual Actual Actual Actual 50,000.00 Plan NA NA 08 Feb, 12 22 Feb, 12 NA NA Plan 07 Mar, 12 04 Apr, 12 NA NA NA 18 Apr, 12 02 May, 12 Plan NA NA 50,000.00 16 May, 12 NA 23 May, 12 Plan 06 Jun, 12 06 Nov, 12 06 Dec, 12 Appointment of technical Assistant Expert for 3.1.4 CQS Lumpsum Post Billing / Accounting hard and softwares Actual Actual Actual Actual 100,000.00 Plan NA NA 08 Feb, 12 22 Feb, 12 NA NA Plan 07 Mar, 12 04 Apr, 12 NA NA NA 18 Apr, 12 02 May, 12 Plan NA NA 100,000.00 16 May, 12 NA 23 May, 12 Plan 06 Jun, 12 06 Nov, 12 06 Dec, 12 Detailed Engineering Design Review for Zaria 3.1.5 Transmission Mains, Service Reservoirs and CQS Lumpsum Post Actual Distribution network Actual Actual Actual 100,000.00 Plan NA NA 08 Feb, 12 22 Feb, 12 NA NA Plan 07 Mar, 12 04 Apr, 12 NA NA NA 18 Apr, 12 02 May, 12 Plan NA NA 100,000.00 16 May, 12 NA 23 May, 12 Plan 06 Jun, 12 06 Nov, 12 06 Dec, 12 Updating the Feasibility Report for Kaduna and 3.1.6 CQS Lumpsum Post Zaria Water supply expansion Projects Actual Actual Actual Actual 100,000.00 Plan NA NA 10 Feb, 12 24 Feb, 12 NA NA Plan 09 Mar, 12 06 Apr, 12 NA NA NA 20 Apr, 12 04 May, 12 Plan NA NA 100,000.00 18 May, 12 NA 25 May, 12 Plan 11 Jun, 12 14 Nov, 12 14 Dec, 12 3.1.7 ESIA for Zaria Expansion Projects - Dam CQS Lumpsum Post Actual Actual Actual Actual 200,000.00 Plan NA NA 10 Feb, 12 24 Feb, 12 NA NA Plan 09 Mar, 12 06 Apr, 12 NA NA NA 20 Apr, 12 04 May, 12 Plan NA NA 200,000.00 18 May, 12 NA 25 May, 12 Plan 11 Jun, 12 14 Nov, 12 14 Dec, 12 Updating State-Wide Water Resources 3.1.8 CQS Lumpsum Prior Masterplan Actual Actual Actual Actual 100,000.00 Plan NA NA 10 Feb, 12 24 Feb, 12 NA NA Plan 09 Mar, 12 06 Apr, 12 NA NA NA 20 Apr, 12 04 May, 12 Plan NA NA 100,000.00 18 May, 12 NA 25 May, 12 Plan 11 Jun, 12 14 Nov, 12 14 Dec, 12 Lumpsum 3.1.9 Updating Fixed Asset Register of the Board CQS Prior Actual Actual Actual Actual 100,000.00 Plan NA NA 10 Feb, 12 24 Feb, 12 NA NA Plan 09 Mar, 12 06 Apr, 12 NA NA NA 20 Apr, 12 04 May, 12 Plan NA NA 100,000.00 18 May, 12 NA 25 May, 12 Plan 11 Jun, 12 14 Nov, 12 14 Dec, 12 Lumpsum 3.1.10 KSWB reform and Restructuring CQS Prior Actual Actual Actual Actual Plan Sub-Total New Consuting Services 2,710,000.00 Plan 2,710,000.00 Plan Actual Actual Actual 3.2 Consulting Services Contracts Migrated Cr- 4784 - NG N/A N/A N/A N/A N/A N/A Aug 23, 07 Sep 23, 07 NA NA Sep 30, 07 Oct 14, 07 Nov 14, 07 Plan Nov 28, 07 Dec 5, 07 271,156.20 Apr 2, 07 Jun 9, 07 July 9, 07 30 Nov, 11 31 Dec, 11 Construction Supervision for Kaduna 271,156.20 Plan 3.2.1 QCBS Time Based Prior Plan Feb 6, 08 Plan Metropolitan WSS Actual N/A N/A N/A N/A N/A N/A July 4, 07 Aug 15, 07 NA NA Aug 17, 07 Aug 30, 07 Sept 5, 07 Actual Sept 6, 07 Sept 14 ,07 0.00 Sept 19, 07 Sep 19, 07 Nov. 14,07 Actual Mar 10, 08 Actual July 5, 07 July 19, 07 NA NA Aug 2, 07 Aug 9, 07 Aug 30, 07 Sep 30, 07 Jan.30, 08 Feb 6, 08 Feb 13, 08 Feb 20, 08 March 5, 08 Plan Mar 12, 08 Mar 19, 08 1,100,127.49 March 26, 08 Feb 27, 09 April 2, 08 April 23, 08 30 Nov, 11 31 Dec, 11 1,100,127.49 Plan Construction Supervision for Other Towns Plan Plan 3.2.2 QCBS Lumpsum Prior July 9, 07 July 23, 07 Aug 2, 07 Aug 3, 07 Aug 3, 07 Oct 28, 07 Jan 27, 08 Feb 16, 08 Mar 5, 08 May 23, 08 May 30, 08 Actual Aug 16, 08 Sep 05, 08 1442.57 Dec 05, 08 Dec 10, 08 Jan 16, 09 (Zaria, Kaf/kag/Zon and S/Naka) Actual Actual Feb 13, 09 Actual Management Contract for Kaduna & Zaria Jan 12, 07 Feb 02, 07 Feb 15, 07 Feb 22, 07 Mar 08, 07 Mar 22, 07 Apr 05, 07 Apr 26, 07 Jan 14, 07 Jul 07, 07 Jul 14, 07 Jul 27, 07 Aug 10, 07 Actual Aug 24, 07 Sep 07, 07 841,602.29 Sep 21, 08 Sep 25, 07 Sep 28, 07 Oct 05, 08 30 Nov, 11 31 Dec, 11 841,602.29 Plan 3.2.3 Water Treatment Plants and Booster Stations QCBS Lumpsum Prior Plan Plan Aug 18, 07 Sep 01, 07 Sep 13, 07 Sep 27, 07 Oct 12, 07 Oct 26, 07 Nov 22, 07 Jan 18, 08 Feb 01, 08 Feb 20, 08 Mar 07, 08 Mar 20, 08 Apr 01, 08 Actual Apr 12, 08 May 02, 08 0.00 May 27, 08 May 27, 08 Management fees Actual Actual Jul 05, 08 Actual N/A N/A N/A N/A N/A N/A Mar 03, 09 Apr 03, 09 NA NA NA NA May 28,09 Plan Jun 12, 09 Jun 19, 09 72,280.00 Jul 25, 09 Aug 05, 09 Aug 25, 09 Sep 25, 09 30 Nov, 11 31 Dec, 11 72,280.00 Plan 3.2.4 ESIA for Kaduna & Zaria Expansion Projects QCBS Lumpsum Post Plan May 04, 09 Jul 04, 09 NA NA NA NA Jun 16, 09 Jul 12, 09 Jul 22, 09 240.94 Oct 09, 09 Oct 09, 09 Actual N/A N/A N/A N/A N/A N/A Actual Actual May 14, 06 May 21, 06 Jun 04, 06 July 04, 06 Jul 18, 06 Jul 25, 06 Aug 15, 06 Sep 15, 06 Oct 15, 06 Oct 22, 06 Oct 29, 06 Nov 15, 06 Dec 15, 06 Plan Dec 31, 06 Jan 07, 07 39,613.14 Jan 28, 07 Feb 14, 07 Feb 28, 07 Plan Oct 14, 07 30 Nov, 11 31 Dec, 11 39,613.14 Plan 3.2.5 Customers Enumerations for Kaduna Town QCBS Lumpsump Post Plan May 12, 06 May 15, 06 May 30, 06 July 04, 06 Aug. 10, 06 Sep 05, 06 Sep 15, 06 Oct 20, 06 Dec 28, 06 May 7, 07 May 15, 07 Jun 21, 07 Jul 16, 07 Actual Actual Actual Actual Aug 15, 06 Sep 15, 06 Oct 15, 06 Oct 22, 06 Oct 29, 06 Nov 15, 06 Dec 15, 06 Dec 31, 06 Jan 07, 07 Jan 28, 07 Feb 14, 07 Feb 28, 07 Oct 14, 07 Nov 14, 07 30 Nov, 11 31 Dec, 11 371,682.23 Plan 371,682.23 Plan 16 Sept, 11 3.2.6 Customers Enumerations for Zaria QCBS Lumpsum Prior Plan Plan Sep 15, 06 Oct 20, 06 Dec 28, 06 May 7, 07 May 15, 07 Jun 21, 07 Jul 16, 07 Actual Actual Actual Actual 48,000.00 Plan NA NA NA NA NA NA Plan 11 Jul, 10 25 Jul, 10 NA NA NA NA 22 Aug, 10 Plan 5 Sep, 10 19 Sep, 10 48,000.00 26 sep, 10 08 Oct, 10 10 oct, 10 Plan 28 Oct, 11 28 Dec, 11 31 Jan, 12 3.2.7 Auditors fees for KSWB 2008 , 2009, 2010 SSS Lumpsum Prior Actual Actual 09 Aug, 10 23 Aug, 10 NA NA NA NA 21 Sep, 10 Actual 05 Oct, 10 22 Oct, 10 29 Oct, 10 12 Nov, 10 19 Nov, 10 Actual 2,744,461.35 Plan Plan Plan 2,744,461.35 Plan Sub-Total migrated Consulting Services Contracts Actual Actual Actual Actual 5,454,461.35 Plan Plan Plan 5,454,461.35 Plan Total Consulting Services Actual Actual Actual Actual 673790PROP0P070872B0Kaduna0NUWSRP01.xls 5 of 6 03/12/2012 1:28 AM Procurement Plan-Consultants Country/Organisation: Project/Programme: Loan #: Description* Final Cost Norm Duration of Proc Steps List of Contracts New Consulting Services Construction Supervision (Kaduna + Other Towns) Supervision Additional Works Detailed Engineering Design for Kaduna Met WS Expansion Customer enumeration for Kaf/kwoi/B/Gwari etc PPP in revenue generation and collection Appointment of technical Assistant Expert for Billing / Accounting hard and softwares Detailed Engineering Design Review for Zaria Transmission Mains, Service Reservoirs and Distribution network Updating the Feasibility Report for Kaduna and Zaria Water supply expansion Projects ESIA for Zaria Expansion Projects - Dam Updating State-Wide Water Resources Masterplan Updating Fixed Asset Register of the Board KSWB reform and Restructuring Sub-Total New Consuting Services Consulting Services Contracts Migrated Cr- 4784 - NG Construction Supervision for Kaduna Metropolitan WSS Construction Supervision for Other Towns (Zaria, Kaf/kag/Zon and S/Naka) Management Contract for Kaduna & Zaria Water Treatment Plants and Booster Stations Management fees ESIA for Kaduna & Zaria Expansion Projects Customers Enumerations for Kaduna Town Customers Enumerations for Zaria Auditors fees for KSWB 2008 , 2009, 2010 Sub-Total migrated Consulting Services Contracts Total Consulting Services 673790PROP0P070872B0Kaduna0NUWSRP01.xls 6 of 6 03/12/2012 1:28 AM