Spreadsheet: e33db9ca-6d79-4007-a21e-e403a0e26225
Sheet: LFA_Total PR Cash Outflow_3A

[NAME] On-going Progress Review and Disbursement Recommendation
PROGRESS UPDATE PERIOD
Grant number:
Progress Update - Reporting Period: |  | Cycle: |  |  | Number:
Progress Update - Period Covered: |  | Beginning Date: |  |  | End Date:
Progress Update - Number:
Currency:
Section 3A:  Total PR Cash Outflow
LFA-VERIFIED TABLES ON TOTAL PR CASH OUTFLOW
! For RCC grants the cumulative section of the table below should contain cumulative amount from the start of the RCC and not from the start of Phase 1 of the program.
 |  | LFA-Verified Budget for Reporting Period | LFA-Verified Actual for Reporting Period | [NAME] | LFA Analysis of Variance |  | LFA-Verified Cumulative Budget through period of Progress Update | LFA-Verified Actual through period of Progress Update | [NAME] | LFA Analysis of Variance |  |  |  |  | LFA-Verified Budget for Reporting Period | LFA-Verified Actual for Reporting Period | [NAME] | LFA Analysis of Variance |  | LFA-Verified Cumulative Budget through period of Progress Update | LFA-Verified Actual through period of Progress Update | [NAME] | LFA Analysis of Variance
1. Total cash outflow vs. budget |  |  |  |  |  |  |  |  |  |  |  |  | 1. Total cash outflow vs. budget
1a. PR's total expenditures |  |  |  |  | The negative variance for the period was mainly due to: - Higher than planned expenditure on health products by Eur 13,069 due to increases in prices at the global level. - Higher than planned costs incurred on OVC educational support of Eur 53,808. The 2010-2011 academic year began in the fourth quarter hence most OVC fees for the 2010-2011 academic year were paid in period 4. There was no budget for this activitiy in period 4.  The payments made were mainly drawn on the Eur 10,000 surplus from the budget for period 1 in year 1 and the year 2 period 1 budget of Eur 70,000. - Higher than planned cost incurred on OVC nutritional support by Eur 8,145. This was mainly due to general increases in prices of goods and increase in the number of OVCs supported. The number of OVCs increased from the initial target of 1,700 to 2,000 after the MESST workshop in June 2010. - Some expenditure from the previous quarter was rolled over to the current quarter. The roll over was due to the PR's decision to prioritise and spend on activities in period 3 in line with funds available at the time. These include activities under BCC Mass media and community outreach - Eur 60,279, procurement of bicycles under home based care and support for PLHIV- Eur 13,713, administrative costs, monthly meetings for PL support groups - Eur 25,706. The negative variance was partly offset by unutilised funds/savings from the following budget lines; -  Technical assistance from Action Aid International - Eur 4,465 -  Life skills training sessions under BCC community outreach - Eur 10,575 -  M & E survey on the youth  -  Eur 6,624 -  PR Human resource and general administrative cost - Eur  4,956 - Training on Income generating activities  and phsycosocial care and support - Eur 10,148 |  |  |  |  | The total variance is made up both positive and negative variances.  The negative variance was mainly due to over expenditure on  - Educational and nutrional support for OVCs of Eur 58,515 - Administration cost for PL support groups of Eur 10,352 and printing of guideline materials under life skills training. - Procurement of HBC kits - Eur 13,482 - Administration cost for PLHIV support groups - 10,318 - Update of CSWs register under BCC community outreach - Eur 14,265  The PR also incurred some expenditure on behalf of the SRs.   The positive variance is due mainly to the following outstanding activities in:  - BCC mass media and community outreach, STAR sessions and training  - Translation of life skills manual for special needs - Eur 14,140  - HIV advocacy sensitization - Eur 12,375 - Policy development on multi indicator survey - Eur 16,369 |  |  | 1a. PR's total expenditures
1b. Disbursements to sub-recipients |  |  |  |  | The positive variance was due to some expenditure originally designated to SRs and support groups but incurred by the PR to accelerate program implementation. |  |  |  |  | The positive variance is accounted for by procurements made directly by the PR on behalf of the SRs to accelerate program implementation. These include procurement of condoms by VPP, vehicles, office equipment and payment of other administrative costs for support groups orginally designated to CRS. |  |  | 1b. Disbursements to sub-recipients
 |  | LFA-Verified Budget for Reporting Period | LFA-Verified Actual for Reporting Period | [NAME] | LFA Analysis of Variance |  | LFA-Verified Cumulative Budget through period of Progress Update | LFA-Verified Actual through period of Progress Update | [NAME] | LFA Analysis of Variance |  |  |  |  | LFA-Verified Budget for Reporting Period | LFA-Verified Actual for Reporting Period | [NAME] | LFA Analysis of Variance |  | LFA-Verified Cumulative Budget through period of Progress Update | LFA-Verified Actual through period of Progress Update | [NAME] | LFA Analysis of Variance
2. Pharmaceuticals & health product expenditures vs. budget |  |  |  |  |  |  |  |  |  |  |  |  | 2. Pharmaceuticals & health product expenditures vs. budget
2a.  [NAME] and pharmaceutical products |  |  |  |  |  |  |  |  |  |  |  |  | 2a.  [NAME] and pharmaceutical products
2b.  Health products and health equipment |  |  |  |  | The expenditure relates to the procurement of HBC kits which was carried out through the VPP during the period. The budget for procurement was Eur 72,092 and scheduled for period 2. The only products procured then were male and female condoms. The remaining health products were procured in the current period after completing all procurement procedures. |  |  |  |  | The cumulative expenditure relates to male and female condoms procured in Q2 and other health products (mainly HBC kits) procured in quarter 4.   The excess expenditure was due to increases in prices of health products procured mainly in period 4. |  |  | 2b.  Health products and health equipment
* If [NAME]-entered data differs from PR's figures, the respective cells will change colour automatically
3.  Indicate any expenditures (incurred or forecasted) that should not be financed by the Global Fund
None