India - Coal Fired Generation Rehabilitation Project : procurement plan

Page 1 Goods Plan / Actual MAHARASHTRA India Coal-Fired Generation Rehabilitation Project (Page 1) Procurement Plan as of date in file name Procurement Ref. # Type-Category Estimated Cost/Actual if in Rs (Rs million) Estimated Cost/Actual if in USD IBRD/GEF Financing (USD) Financing Share Selection Method Bank Review Bid document submis-sion Days Interval No Objection Days Interval Invitation Days Interval 1st stage Bid Opening Days Interval 1st stage evaluation report D ays Interval No Objection 1 03/09/2011 2:40 3 4 5 6 8 7 9 10 11 12 13 14 15 16 17 18 19 20 21 P Boiler-turbine-generator G-S&I 3,962.28 90,051,818 66,638,345 74% ICB Prior 14-Apr-10 43 27-May-10 72 07-Aug-10 192 15-Feb-11 45 01-Apr-11 28 29-Apr-11 A P Coal-handling plant G-S&I 356.26 8,096,818 5,991,645 74% ICB Prior 10-Apr-11 14 24-Apr-11 30 24-May-11 60 23-Jul-11 90 21-Oct-11 15 05-Nov-11 A P Balance of plant G-S&I 241.15 5,480,682 4,055,705 74% ICB Prior 10-Mar-11 14 24-Mar-11 30 23-Apr-11 60 22-Jun-11 90 20-Sep-11 15 05-Oct-11 A P Electrical system package G-S&I 300.47 6,828,864 5,053,359 74% ICB Prior 17-Jun-10 222 25-Jan-11 30 24-Feb-11 60 25-Apr-11 90 24-Jul-11 15 08-Aug-11 A P Unallocated Goods Plan / Actual Continued Days Interval 2nd stage Bid Opening Days Interval 2nd stage evaluation report Days Interval No Objection Days Interval Contract Award Days Interval Contract Signature Days Interval Start D ays Execution Completion 1 03/09/2011 2:40 22 23 24 25 26 27 28 23 24 25 26 27 28 29 P Boiler-turbine-generator 60 28-Jun-11 45 12-Aug-11 28 09-Sep-11 30 09-Oct-11 25 03-Nov-11 40 13-Dec-11 900 31-May-14 A P Coal-handling plant 0 05-Nov-11 0 05-Nov-11 0 05-Nov-11 30 05-Dec-11 40 14-Jan-12 40 23-Feb-12 885 27-Jul-14 A P Balance of plant 0 05-Oct-11 0 05-Oct-11 0 05-Oct-11 30 04-Nov-11 40 14-Dec-11 40 23-Jan-12 900 11-Jul-14 A P Electrical system 0 08-Aug-11 0 08-Aug-11 0 08-Aug-11 30 07-Sep-11 40 17-Oct-11 40 26-Nov-11 915 29-May-14 A P Unallocated Total Goods 4,860.16 110,458,182 81,739,055 Page 2 Technical Assistance (TA) Plan / Actual MAHARASHTRA India Coal-Fired Generation Rehabilitation Project (Page 2) Procurement Ref. # Type-Category Estimated Cost/Actual if in Rs (Rs million) Estimated Cost/Actual if in USD IBRD/GEF Financing (USD) Financing Share Selection Method Bank Review Advertising Expression of Interest Days Interval Reception of EOI Days Interval Short Listing and RFP ready Days Interval No Objection Days Interval Invitation for RFP D ays Interval Proposal Submis-sion 1 03/09/2011 2:40 3 4 5 6 8 7 9 10 11 12 13 14 15 16 17 18 19 20 21 P Koradi 6 implementation support TA 15.40 350,000 350,000 100% QCBS Prior 20-Mar-10 31 20-Apr-10 344 30-Mar-11 14 13-Apr-11 10 23-Apr-11 30 23-May-11 A P Koradi 6 quality assurance TA 6.60 150,000 150,000 100% QCBS Post 30-Mar-11 30 29-Apr-11 30 29-May-11 0 29-May-11 10 08-Jun-11 30 08-Jul-11 A P Mahagenco capacity building TA 35.20 800,000 800,000 100% QCBS Prior PENDING 30 #VALUE! 30 #VALUE! 14 #VALUE! 10 #VALUE! 30 #VALUE! A DECISION P Chandrapur 1&2 design cons. TA 14.05 319,318 319,318 100% QCBS Prior 01-Nov-08 14 15-Nov-08 124 19-Mar-09 8 27-Mar-09 356 18-Mar-10 67 24-May-10 A P Rapid social assessment 3 plants TA 1.26 28,636 28,636 100% QCBS Post 22-Oct-09 22 13-Nov-09 168 30-Apr-10 14 14-May-10 21 04-Jun-10 57 31-Jul-10 A P Chandrapur 1&2 EADD TA 3.70 84,091 84,091 100% QCBS Post 11-Aug-09 14 25-Aug-09 104 07-Dec-09 14 21-Dec-09 169 08-Jun-10 37 15-Jul-10 A P Bhusawal 2 design cons. TA 10.62 241,364 241,364 100% QCBS Prior 11-Dec-08 67 16-Feb-09 435 27-Apr-10 13 10-May-10 10 20-May-10 57 16-Jul-10 A P Bhusawal 2 EADD TA 2.63 59,773 59,773 100% QCBS Post 22-Oct-09 22 13-Nov-09 166 28-Apr-10 17 15-May-10 20 04-Jun-10 57 31-Jul-10 A P Parli 3 design consultant TA 18.70 425,000 425,000 100% QCBS Prior 27-Nov-09 50 16-Jan-10 124 20-May-10 14 03-Jun-10 49 22-Jul-10 30 21-Aug-10 A P Parli 3 EADD TA 2.75 62,500 62,500 100% QCBS Post 24-Mar-10 17 10-Apr-10 52 01-Jun-10 0 01-Jun-10 38 09-Jul-10 34 12-Aug-10 A P Unallocated Technical Assistance (TA) Plan / Actual Continued Days Interval Technical Evaluation Days Interval No Objection Days Interval Draft contract Days Interval No Objection Days Interval Contract Signature Days Interval Start D ays Interval Completion 1 03/09/2011 2:40 22 23 24 25 26 27 28 29 30 31 32 33 34 35 P Koradi 6 implementation support 30 22-Jun-11 14 06-Jul-11 30 05-Aug-11 14 19-Aug-11 7 26-Aug-11 30 25-Sep-11 1081 10-Sep-14 A P Koradi 6 quality assurance 30 07-Aug-11 14 21-Aug-11 30 20-Sep-11 14 04-Oct-11 7 11-Oct-11 30 10-Nov-11 1009 15-Aug-14 A P Mahagenco capacity building 30 #VALUE! 14 #VALUE! 30 #VALUE! 14 #VALUE! 7 #VALUE! 30 #VALUE! #VALUE! A P Chandrapur 1&2 design cons. 23 16-Jun-10 36 22-Jul-10 30 21-Aug-10 9 30-Aug-10 42 11-Oct-10 14 25-Oct-10 240 22-Jun-11 A P Rapid social assessment 3 plants 74 13-Oct-10 97 18-Jan-11 44 03-Mar-11 14 17-Mar-11 7 24-Mar-11 30 23-Apr-11 240 19-Dec-11 A P Chandrapur 1&2 EADD 15 30-Jul-10 3 02-Aug-10 36 07-Sep-10 27 04-Oct-10 8 12-Oct-10 34 15-Nov-10 210 13-Jun-11 A P Bhusawal 2 design cons. 46 31-Aug-10 38 08-Oct-10 84 31-Dec-10 47 16-Feb-11 7 23-Feb-11 30 25-Mar-11 240 20-Nov-11 A P Bhusawal 2 EADD 62 01-Oct-10 21 22-Oct-10 82 12-Jan-11 34 15-Feb-11 7 22-Feb-11 30 24-Mar-11 210 20-Oct-11 A P Parli 3 design consultant 67 27-Oct-10 113 17-Feb-11 60 18-Apr-11 14 02-May-11 7 09-May-11 30 08-Jun-11 240 03-Feb-12 A P Parli 3 EADD 55 06-Oct-10 75 20-Dec-10 60 18-Feb-11 14 04-Mar-11 7 11-Mar-11 30 10-Apr-11 210 06-Nov-11 A P Unallocated Total TA 110.91 2,520,682 2,520,682 Page 3 Front-end Fee 147,500 Maharashtra Grand Total 4971.07 112,978,864 84,407,236 IBRD Loan 59,000,000 Rs/USD: 44.0 GEF Goods 12,450,000 GEF TA 3,300,000 Total IBRD/GEF 74,750,000 Project Closing Date: 11/30/2014 Difference Plan/Financing -9,657,236 Front-end Fee has already been paid to the World Bank. It reduces available IBRD funds as compared to amount in sub-loan agreement. Page 4 Disbursements Cost Percentages (Calendar Quarters) MAHARASHTRA India Coal-Fired Generation Rehabilitation Project Disbursement Schedule as of date in file name Funding Source Estimated Cost/Actual if in USD Financing Share Contract Signature Contract Completion 2010 2011 2012 2013 2014 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Boiler-turbine-generator IBRD-GEF 90,051,818 74% 03-Nov-11 31-May-14 10% 10% 10% 10% 20% 20% 10% 10% Coal-handling plant IBRD-GEF 8,096,818 74% 14-Jan-12 27-Jul-14 10% 10% 10% 10% 20% 20% 10% 10% Balance of plant IBRD-GEF 5,480,682 74% 14-Dec-11 11-Jul-14 10% 10% 10% 10% 20% 20% 10% 10% Electrical system \0apackage IBRD-GEF 6,828,864 74% 17-Oct-11 29-May-14 10% 10% 10% 10% 20% 20% 10% 10% Koradi 6 implementation support GEF 350,000 100% 26-Aug-11 10-Sep-14 10% 10% 40% 30% 10% Koradi 6 quality assurance GEF 150,000 100% 11-Oct-11 15-Aug-14 10% 10% 40% 30% 10% Mahagenco capacity building GEF 800,000 100% #VALUE! #VALUE! 100% Chandrapur 1&2 design cons. GEF 319,318 100% 11-Oct-10 22-Jun-11 10% 8% 58% 20% 5% Rapid social assessment 3 plants GEF 28,636 100% 24-Mar-11 19-Dec-11 10% 80% 10% Chandrapur 1&2 EADD GEF 84,091 100% 12-Oct-10 13-Jun-11 10% 50% 40% Bhusawal 2 design cons. GEF 241,364 100% 23-Feb-11 20-Nov-11 18% 35% 18% 25% 5% Bhusawal 2 EADD GEF 59,773 100% 22-Feb-11 20-Oct-11 10% 70% 20% Parli 3 design consultant GEF 425,000 100% 09-May-11 03-Feb-12 18% 35% 18% 25% 5% Parli 3 EADD GEF 62,500 100% 11-Mar-11 06-Nov-11 60% 40% Front-end Fee IBRD 147,500 100% 100% Total Disbursements 0% 0% 0% 0% 0% 10% 10% 10% 10% 20% 20% 0% 0% 0% 10% 10% 0% 0% IBRD GEF Total GEF Goods GEF TA Accumulated Disbursements 0% 0% 0% 1% 1% 11% 21% 31% 40% 61% 80% 80% 80% 80% 90% 100% 100% 100% How to revise the disbursement schedule: The only data input field is the yellow area where percentage disbursements per contract per calendar (!) quarter should be inserted. White text is linked to Procurement Plan and will change with it. It needs manual adjustment if new line items are added. Other colored fields are automatically populated with numbers through links to costs and percentages. Printing is best done by hiding columns not wanted for printing and then define print to fit by 2 pages (or 1) wide and 1 page tall Page 5 Disbursements MAHARASHTRA India Coal-Fired Generation Rehabilitation Project Disbursement Schedule as of date in file name Funding Source Estimated Cost/Actual if in USD Financing Share Contract Signature Contract Completion Boiler-turbine-generator IBRD-GEF 90,051,818 74% 03-Nov-11 31-May-14 Coal-handling plant IBRD-GEF 8,096,818 74% 14-Jan-12 27-Jul-14 Balance of plant IBRD-GEF 5,480,682 74% 14-Dec-11 11-Jul-14 Electrical system \0apackage IBRD-GEF 6,828,864 74% 17-Oct-11 29-May-14 Koradi 6 implementation support GEF 350,000 100% 26-Aug-11 10-Sep-14 Koradi 6 quality assurance GEF 150,000 100% 11-Oct-11 15-Aug-14 Mahagenco capacity building GEF 800,000 100% #VALUE! #VALUE! Chandrapur 1&2 design cons. GEF 319,318 100% 11-Oct-10 22-Jun-11 Rapid social assessment 3 plants GEF 28,636 100% 24-Mar-11 19-Dec-11 Chandrapur 1&2 EADD GEF 84,091 100% 12-Oct-10 13-Jun-11 Bhusawal 2 design cons. GEF 241,364 100% 23-Feb-11 20-Nov-11 Bhusawal 2 EADD GEF 59,773 100% 22-Feb-11 20-Oct-11 Parli 3 design consultant GEF 425,000 100% 09-May-11 03-Feb-12 Parli 3 EADD GEF 62,500 100% 11-Mar-11 06-Nov-11 Front-end Fee IBRD 147,500 100% Total Disbursements IBRD GEF Total GEF Goods GEF TA Accumulated Disbursements How to revise the disbursement schedule: The only data input field is the yellow area where percentage disbursements per contract per calendar (!) quarter should be inserted. White text is linked to Procurement Plan and will change with it. It needs manual adjustment if new line items are added. Other colored fields are automatically populated with numbers through links to costs and percentages. Printing is best done by hiding columns not wanted for printing and then define print to fit by 2 pages (or 1) wide and 1 page tall Total Cost (USD) 2010 2011 2012 2013 TOTAL Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 100% 0 0 0 0 0 9,005,182 9,005,182 9,005,182 9,005,182 18,010,364 18,010,364 100% 0 0 0 0 0 809,682 809,682 809,682 809,682 1,619,364 1,619,364 100% 0 0 0 0 0 548,068 548,068 548,068 548,068 1,096,136 1,096,136 100% 0 0 0 0 0 682,886 682,886 682,886 682,886 1,365,773 1,365,773 100% 0 0 0 0 0 35,000 35,000 0 0 0 140,000 100% 0 0 0 0 0 15,000 15,000 0 0 0 60,000 100% 0 0 0 0 0 0 0 0 0 800,000 0 100% 0 31,932 23,949 183,608 63,864 0 15,966 0 0 0 0 100% 0 0 2,864 22,909 2,864 0 0 0 0 0 0 100% 0 8,409 42,045 33,636 0 0 0 0 0 0 0 100% 0 0 0 42,239 84,477 42,239 60,341 0 12,068 0 0 100% 0 0 5,977 41,841 11,955 0 0 0 0 0 0 100% 0 0 0 74,375 148,750 74,375 106,250 0 21,250 0 0 100% 0 0 0 37,500 25,000 0 0 0 0 0 0 100% 147,500 0 0 0 0 0 0 0 0 0 0 100% 147,500 40,341 74,835 436,108 336,909 11,212,432 11,278,375 11,045,818 11,079,136 22,891,636 22,291,636 147,500 187,841 262,676 698,784 1,035,693 12,248,125 23,526,500 34,572,318 45,651,455 68,543,091 90,834,727 Page 6 Disbursements MAHARASHTRA India Coal-Fired Generation Rehabilitation Project Disbursement Schedule as of date in file name Funding Source Estimated Cost/Actual if in USD Financing Share Contract Signature Contract Completion Boiler-turbine-generator IBRD-GEF 90,051,818 74% 03-Nov-11 31-May-14 Coal-handling plant IBRD-GEF 8,096,818 74% 14-Jan-12 27-Jul-14 Balance of plant IBRD-GEF 5,480,682 74% 14-Dec-11 11-Jul-14 Electrical system \0apackage IBRD-GEF 6,828,864 74% 17-Oct-11 29-May-14 Koradi 6 implementation support GEF 350,000 100% 26-Aug-11 10-Sep-14 Koradi 6 quality assurance GEF 150,000 100% 11-Oct-11 15-Aug-14 Mahagenco capacity building GEF 800,000 100% #VALUE! #VALUE! Chandrapur 1&2 design cons. GEF 319,318 100% 11-Oct-10 22-Jun-11 Rapid social assessment 3 plants GEF 28,636 100% 24-Mar-11 19-Dec-11 Chandrapur 1&2 EADD GEF 84,091 100% 12-Oct-10 13-Jun-11 Bhusawal 2 design cons. GEF 241,364 100% 23-Feb-11 20-Nov-11 Bhusawal 2 EADD GEF 59,773 100% 22-Feb-11 20-Oct-11 Parli 3 design consultant GEF 425,000 100% 09-May-11 03-Feb-12 Parli 3 EADD GEF 62,500 100% 11-Mar-11 06-Nov-11 Front-end Fee IBRD 147,500 100% Total Disbursements IBRD GEF Total GEF Goods GEF TA Accumulated Disbursements How to revise the disbursement schedule: The only data input field is the yellow area where percentage disbursements per contract per calendar (!) quarter should be inserted. White text is linked to Procurement Plan and will change with it. It needs manual adjustment if new line items are added. Other colored fields are automatically populated with numbers through links to costs and percentages. Printing is best done by hiding columns not wanted for printing and then define print to fit by 2 pages (or 1) wide and 1 page tall World Bank/GEF Financed (USD) 2014 2010 2011 Q2 Q3 Q4 Q1 Q2 Q3 Q4 TOTAL Q3 Q4 Q1 0 0 0 9,005,182 9,005,182 0 0 0 0 0 0 0 0 0 809,682 809,682 0 0 0 0 0 0 0 0 0 548,068 548,068 0 0 0 0 0 0 0 0 0 682,886 682,886 0 0 0 0 0 0 0 0 0 105,000 35,000 0 0 0 0 0 0 0 0 0 45,000 15,000 0 0 0 0 0 0 0 0 0 0 0 0 0 800,000 0 0 0 0 0 0 0 0 0 0 319,318 0 31,932 23,949 0 0 0 0 0 0 0 28,636 0 0 2,864 0 0 0 0 0 0 0 84,091 0 8,409 42,045 0 0 0 0 0 0 0 241,364 0 0 0 0 0 0 0 0 0 0 59,773 0 0 5,977 0 0 0 0 0 0 0 425,000 0 0 0 0 0 0 0 0 0 0 62,500 0 0 0 0 0 0 0 0 0 0 147,500 147,500 0 0 0 0 0 11,195,818 11,095,818 0 0 113,126,364 147,500 40,341 74,835 0 0 0 0 40,341 74,835 0 0 0 0 40,341 74,835 90,834,727 90,834,727 90,834,727 102,030,545 113,126,364 113,126,364 113,126,364 147,500 187,841 262,676 Page 7 Disbursements MAHARASHTRA India Coal-Fired Generation Rehabilitation Project Disbursement Schedule as of date in file name Funding Source Estimated Cost/Actual if in USD Financing Share Contract Signature Contract Completion Boiler-turbine-generator IBRD-GEF 90,051,818 74% 03-Nov-11 31-May-14 Coal-handling plant IBRD-GEF 8,096,818 74% 14-Jan-12 27-Jul-14 Balance of plant IBRD-GEF 5,480,682 74% 14-Dec-11 11-Jul-14 Electrical system \0apackage IBRD-GEF 6,828,864 74% 17-Oct-11 29-May-14 Koradi 6 implementation support GEF 350,000 100% 26-Aug-11 10-Sep-14 Koradi 6 quality assurance GEF 150,000 100% 11-Oct-11 15-Aug-14 Mahagenco capacity building GEF 800,000 100% #VALUE! #VALUE! Chandrapur 1&2 design cons. GEF 319,318 100% 11-Oct-10 22-Jun-11 Rapid social assessment 3 plants GEF 28,636 100% 24-Mar-11 19-Dec-11 Chandrapur 1&2 EADD GEF 84,091 100% 12-Oct-10 13-Jun-11 Bhusawal 2 design cons. GEF 241,364 100% 23-Feb-11 20-Nov-11 Bhusawal 2 EADD GEF 59,773 100% 22-Feb-11 20-Oct-11 Parli 3 design consultant GEF 425,000 100% 09-May-11 03-Feb-12 Parli 3 EADD GEF 62,500 100% 11-Mar-11 06-Nov-11 Front-end Fee IBRD 147,500 100% Total Disbursements IBRD GEF Total GEF Goods GEF TA Accumulated Disbursements How to revise the disbursement schedule: The only data input field is the yellow area where percentage disbursements per contract per calendar (!) quarter should be inserted. White text is linked to Procurement Plan and will change with it. It needs manual adjustment if new line items are added. Other colored fields are automatically populated with numbers through links to costs and percentages. Printing is best done by hiding columns not wanted for printing and then define print to fit by 2 pages (or 1) wide and 1 page tall 2012 2013 2014 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 0 0 6,663,835 6,663,835 6,663,835 6,663,835 13,327,669 13,327,669 0 0 0 6,663,835 0 0 599,165 599,165 599,165 599,165 1,198,329 1,198,329 0 0 0 599,165 0 0 405,570 405,570 405,570 405,570 811,141 811,141 0 0 0 405,570 0 0 505,336 505,336 505,336 505,336 1,010,672 1,010,672 0 0 0 505,336 0 0 35,000 35,000 0 0 0 140,000 0 0 0 105,000 0 0 15,000 15,000 0 0 0 60,000 0 0 0 45,000 0 0 0 0 0 0 800,000 0 0 0 0 0 183,608 63,864 0 15,966 0 0 0 0 0 0 0 0 22,909 2,864 0 0 0 0 0 0 0 0 0 0 33,636 0 0 0 0 0 0 0 0 0 0 0 42,239 84,477 42,239 60,341 0 12,068 0 0 0 0 0 0 41,841 11,955 0 0 0 0 0 0 0 0 0 0 74,375 148,750 74,375 106,250 0 21,250 0 0 0 0 0 0 37,500 25,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 436,108 336,909 8,340,519 8,406,462 8,173,905 8,207,224 17,147,811 16,547,811 0 0 0 8,323,905 0 0 6,749,621 6,749,621 6,749,621 6,749,621 13,499,242 13,499,242 0 0 0 6,749,621 436,108 336,909 1,590,898 1,656,841 1,424,284 1,457,603 3,648,569 3,048,569 0 0 0 1,574,284 0 0 1,424,284 1,424,284 1,424,284 1,424,284 2,848,569 2,848,569 0 0 0 1,424,284 436,108 336,909 166,614 232,557 0 33,318 800,000 200,000 0 0 0 150,000 698,784 1,035,693 9,376,212 17,782,675 25,956,580 34,163,804 51,311,615 67,859,425 67,859,425 67,859,425 67,859,425 76,183,331 Page 8 Disbursements MAHARASHTRA India Coal-Fired Generation Rehabilitation Project Disbursement Schedule as of date in file name Funding Source Estimated Cost/Actual if in USD Financing Share Contract Signature Contract Completion Boiler-turbine-generator IBRD-GEF 90,051,818 74% 03-Nov-11 31-May-14 Coal-handling plant IBRD-GEF 8,096,818 74% 14-Jan-12 27-Jul-14 Balance of plant IBRD-GEF 5,480,682 74% 14-Dec-11 11-Jul-14 Electrical system \0apackage IBRD-GEF 6,828,864 74% 17-Oct-11 29-May-14 Koradi 6 implementation support GEF 350,000 100% 26-Aug-11 10-Sep-14 Koradi 6 quality assurance GEF 150,000 100% 11-Oct-11 15-Aug-14 Mahagenco capacity building GEF 800,000 100% #VALUE! #VALUE! Chandrapur 1&2 design cons. GEF 319,318 100% 11-Oct-10 22-Jun-11 Rapid social assessment 3 plants GEF 28,636 100% 24-Mar-11 19-Dec-11 Chandrapur 1&2 EADD GEF 84,091 100% 12-Oct-10 13-Jun-11 Bhusawal 2 design cons. GEF 241,364 100% 23-Feb-11 20-Nov-11 Bhusawal 2 EADD GEF 59,773 100% 22-Feb-11 20-Oct-11 Parli 3 design consultant GEF 425,000 100% 09-May-11 03-Feb-12 Parli 3 EADD GEF 62,500 100% 11-Mar-11 06-Nov-11 Front-end Fee IBRD 147,500 100% Total Disbursements IBRD GEF Total GEF Goods GEF TA Accumulated Disbursements How to revise the disbursement schedule: The only data input field is the yellow area where percentage disbursements per contract per calendar (!) quarter should be inserted. White text is linked to Procurement Plan and will change with it. It needs manual adjustment if new line items are added. Other colored fields are automatically populated with numbers through links to costs and percentages. Printing is best done by hiding columns not wanted for printing and then define print to fit by 2 pages (or 1) wide and 1 page tall Power Company Financed (USD) 2010 2011 2012 Q2 Q3 Q4 TOTAL Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 6,663,835 0 0 66,638,345 0 0 0 0 0 2,341,347 2,341,347 2,341,347 599,165 0 0 5,991,645 0 0 0 0 0 210,517 210,517 210,517 405,570 0 0 4,055,705 0 0 0 0 0 142,498 142,498 142,498 505,336 0 0 5,053,359 0 0 0 0 0 177,550 177,550 177,550 35,000 0 0 350,000 0 0 0 0 0 0 0 0 15,000 0 0 150,000 0 0 0 0 0 0 0 0 0 0 0 800,000 0 0 0 0 0 0 0 0 0 0 0 319,318 0 0 0 0 0 0 0 0 0 0 0 28,636 0 0 0 0 0 0 0 0 0 0 0 84,091 0 0 0 0 0 0 0 0 0 0 0 241,364 0 0 0 0 0 0 0 0 0 0 0 59,773 0 0 0 0 0 0 0 0 0 0 0 425,000 0 0 0 0 0 0 0 0 0 0 0 62,500 0 0 0 0 0 0 0 0 0 0 0 147,500 0 0 0 0 0 0 0 0 8,223,905 0 0 84,407,236 0 0 0 0 0 2,871,913 2,871,913 2,871,913 6,749,621 0 0 67,496,210 1,474,284 0 0 16,763,526 1,424,284 0 0 14,242,844 50,000 0 0 2,520,682 84,407,236 84,407,236 84,407,236 0 0 0 0 0 2,871,913 5,743,825 8,615,738 IBRD/GEF Available: 74,750,000 Shortfall to address: -9,657,236 Control: -9,657,236 Page 9 Disbursements MAHARASHTRA India Coal-Fired Generation Rehabilitation Project Disbursement Schedule as of date in file name Funding Source Estimated Cost/Actual if in USD Financing Share Contract Signature Contract Completion Boiler-turbine-generator IBRD-GEF 90,051,818 74% 03-Nov-11 31-May-14 Coal-handling plant IBRD-GEF 8,096,818 74% 14-Jan-12 27-Jul-14 Balance of plant IBRD-GEF 5,480,682 74% 14-Dec-11 11-Jul-14 Electrical system \0apackage IBRD-GEF 6,828,864 74% 17-Oct-11 29-May-14 Koradi 6 implementation support GEF 350,000 100% 26-Aug-11 10-Sep-14 Koradi 6 quality assurance GEF 150,000 100% 11-Oct-11 15-Aug-14 Mahagenco capacity building GEF 800,000 100% #VALUE! #VALUE! Chandrapur 1&2 design cons. GEF 319,318 100% 11-Oct-10 22-Jun-11 Rapid social assessment 3 plants GEF 28,636 100% 24-Mar-11 19-Dec-11 Chandrapur 1&2 EADD GEF 84,091 100% 12-Oct-10 13-Jun-11 Bhusawal 2 design cons. GEF 241,364 100% 23-Feb-11 20-Nov-11 Bhusawal 2 EADD GEF 59,773 100% 22-Feb-11 20-Oct-11 Parli 3 design consultant GEF 425,000 100% 09-May-11 03-Feb-12 Parli 3 EADD GEF 62,500 100% 11-Mar-11 06-Nov-11 Front-end Fee IBRD 147,500 100% Total Disbursements IBRD GEF Total GEF Goods GEF TA Accumulated Disbursements How to revise the disbursement schedule: The only data input field is the yellow area where percentage disbursements per contract per calendar (!) quarter should be inserted. White text is linked to Procurement Plan and will change with it. It needs manual adjustment if new line items are added. Other colored fields are automatically populated with numbers through links to costs and percentages. Printing is best done by hiding columns not wanted for printing and then define print to fit by 2 pages (or 1) wide and 1 page tall 2013 2014 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 TOTAL 2,341,347 4,682,695 4,682,695 0 0 0 2,341,347 2,341,347 0 0 23,413,473 210,517 421,035 421,035 0 0 0 210,517 210,517 0 0 2,105,173 142,498 284,995 284,995 0 0 0 142,498 142,498 0 0 1,424,977 177,550 355,101 355,101 0 0 0 177,550 177,550 0 0 1,775,505 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2,871,913 5,743,825 5,743,825 0 0 0 2,871,913 2,871,913 0 0 28,719,127 11,487,651 17,231,476 22,975,302 22,975,302 22,975,302 22,975,302 25,847,215 28,719,127 28,719,127 28,719,127