Spreadsheet: 257f80dc-fb00-4afc-8878-4b2fda18bba5
Sheet: Sheet1

TB FINANCIAL REPORTING FORM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Country |  | Multi-Country Western Pacific |  |  | PLEASE REFER TO THE "GUIDANCE FOR COMPLETION OF THE ENHANCED FINANCIAL REPORTING TEMPLATE" DOCUMENT TO ASSIST YOU IN COMPLETING THE TEMPLATE
Grant No. |  | MWP-708-G07-T
PR |  | Secretariat of Pacific Communities
Currency |  | USD
 |  |  |  |  |  | [NAME] |  |  |  | [NAME]
 |  |  |  | Current Reporting Period | Start Date: | 2010-01-01 00:00:00 |  | Cumulative Reporting Period | Start Date: | 2008-07-01 00:00:00
 |  |  |  |  | End Date: | 2010-12-31 00:00:00 |  |  | End Date: | 2010-12-31 00:00:00
 |  |  |  |  |  |  | The end date for the current reporting period and cumulative reporting period must be the same
 |  |  |  | The "TOTAL" rows in Table A, B and C will have a RED background if the amounts in each table do not agree. If the Totals for each Table agrees, these rows will have a YELLOW background.
A- BREAKDOWN* BY  EXPENDITURE CATEGORY |  |  |  | Current Reporting Period |  |  |  | Cumulative Reporting Period
# | Category |  |  | Budget | Expenditures | [NAME] | Reason for [NAME] | Cumulative Budget | Cumulative Expenditure | [NAME] | Reason for [NAME]
1 | Human Resources |  |  | 1757856.78 | 948052.76 | -809804.02 | Please refer to Annex 1 | 3257793.78 | 1684897.98 | -1572895.8 | Please refer to Annex 1
2 | Technical Assistance |  |  | 220378.44 | 93956.73 | -126421.71 | Please refer to Annex 1 | 451878.44 | 189969.42 | -261909.02 | Please refer to Annex 1
3 | Training |  |  | 365912.15 | 363998.36 | -1913.790000000037 | Please refer to Annex 1 | 1002022.15 | 711098 | -290924.15 | Please refer to Annex 1
4 | Health Products and Health Equipment |  |  | 233000 | 21267.69 | -211732.31 | Please refer to Annex 1 | 597782.38 | 91530.21 | -506252.17 | Please refer to Annex 1
5 | Medicines and Pharmaceutical Products |  |  | 97000 | 0 | -97000 | Please refer to Annex 1 | 97000 | 0 | -97000 | Please refer to Annex 1
6 | Procurement and Supply Management Costs |  |  | 0 | 2548.24 | 2548.24 | Please refer to Annex 1 | 3757.62 | 7427.12 | 3669.5 | Please refer to Annex 1
7 | Infrastructure and Other Equipment |  |  | 202696 | 112743.17 | -89952.83 | Please refer to Annex 1 | 640198 | 403349.1 | -236848.9 | Please refer to Annex 1
8 | Communication Materials |  |  | 119574 | 73265.23 | -46308.77 | Please refer to Annex 1 | 201844 | 98915.02 | -102928.98 | Please refer to Annex 1
9 | Monitoring and Evaluation |  |  | 142591.49 | 146682.95 | 4091.460000000021 | Please refer to Annex 1 | 639807.49 | 267335.9 | -372471.59 | Please refer to Annex 1
10 | Living Support to Clients/Target Population |  |  | 80400 | 157274.89 | 76874.89000000001 | Please refer to Annex 1 | 159000 | 270319.7 | 111319.7 | Please refer to Annex 1
11 | Planning and Administration |  |  | 224107.08 | 250736.59 | 26629.51000000001 | Please refer to Annex 1 | 406824.08 | 458231.7 | 51407.62 | Please refer to Annex 1
12 | Overheads |  |  | 116758.69 | 48476.63 | -68282.06 | Please refer to Annex 1 | 187534.69 | 97843.77 | -89690.92 | Please refer to Annex 1
13 | Other |  |  | 0 | 60.63 | 60.63 | Please refer to Annex 1 | 0 | 60.63 | 60.63 | Please refer to Annex 1
 |  |  | TOTAL | 3560274.63 | 2219063.87 | -1341210.76 |  | 7645442.630000001 | 4280978.55 | -3364464.079999999
B- BREAKDOWN* BY PROGRAM ACTIVITY |  |  |  | Current Reporting Period |  |  |  | Cumulative Reporting Period
# | Macro-category | Objectives | Service Delivery Area | Budget | Expenditures | [NAME] | Reason for [NAME] | Cumulative Budget | Cumulative Expenditure | [NAME] | Reason for [NAME]
1 | TB Detection | 2: To ensure equitable access to high-quality TB care for all people with TB | ACSM ([NAME], communication and social mobilization) | 0 | 4701.33 | 4701.33 | Please refer to [NAME] | 56200 | 34939.93 | -21260.07 | Please refer to [NAME]
2 | Health Systems Strengthening (HSS) | 1: To sustain and optimize the quality of DOTS and go beyond the 70/85 targets | HSS (beyond TB) | 1305284 | 650544.8 | -654739.2 | Please refer to [NAME] | 2605684 | 981949.06 | -1623734.94 | Please refer to [NAME]
3 | TB Detection | 1: To sustain and optimize the quality of DOTS and go beyond the 70/85 targets | Improving diagnosis | 330753 | 207085.64 | -123667.36 | Please refer to [NAME] | 680413 | 383615.1 | -296797.9 | Please refer to [NAME]
4 | TB Treatment | 3: To adapt DOTS to respond to MDR-TB and TB/HIV co infection | MDR-TB | 106881 | 37321.87 | -69559.13 | Please refer to [NAME] | 260881 | 42292.03 | -218588.97 | Please refer to [NAME]
5 | Health Systems Strengthening (HSS) | 1: To sustain and optimize the quality of DOTS and go beyond the 70/85 targets | M&E | 103598 | 57858.3 | -45739.7 | Please refer to [NAME] | 312598 | 160311.54 | -152286.46 | Please refer to [NAME]
6 | TB Treatment | 3: To adapt DOTS to respond to MDR-TB and TB/HIV co infection | Procurement and supply management | 249000 | 145708 | -103292 | Please refer to [NAME] | 396660 | 259800.3 | -136859.7 | Please refer to [NAME]
7 | Supportive Environment | 1: To sustain and optimize the quality of DOTS and go beyond the 70/85 targets | Standardized treatment, patient support and patient charter | 169522 | 150856.38 | -18665.62 | Please refer to [NAME] | 564992 | 312536.33 | -252455.67 | Please refer to [NAME]
8 | TB Treatment | 3: To adapt DOTS to respond to MDR-TB and TB/HIV co infection | TB/HIV | 116995 | 118112.6 | 1117.600000000006 | Please refer to [NAME] | 175595 | 125532.81 | -50062.19 | Please refer to [NAME]
9 | TB Detection | 2: To ensure equitable access to high-quality TB care for all people with TB | High-risk groups | 584073 | 334009.49 | -250063.51 | Please refer to [NAME] | 1288053 | 811394.71 | -476658.29 | Please refer to [NAME]
10 | Supportive Environment | PR-Programme Administration | Supportive environment: Program management and administration | 594168.63 | 512865.46 | -81303.16999999998 | Please refer to [NAME] | 1304366.63 | 1168606.74 | -135759.8899999999 | Please refer to [NAME]
TOTAL |  |  |  | 3560274.63 | 2219063.87 | -1341210.76 |  | 7645442.63 | 4280978.55 | -3364464.08
To add additional rows, right click the row number (Row 39 in a blank template) to the left of the row above the row for TOTAL and select copy, then over the same number, right click again and select Insert Copied Cells. WARNING: Inserting Rows without copying a row as described above will cause the formula in the variance column to become invalid and will mean the overall information will be inaccurate.
C- BREAKDOWN* BY IMPLEMENTING ENTITY |  |  |  | Current Reporting Period |  |  |  | Cumulative Reporting Period
# | PR/SR | Name | Type of Implementing Entity | Budget | Expenditures | [NAME] | Reason for [NAME] | Cumulative Budget | Cumulative Expenditure | [NAME] | Reason for [NAME]
1 | SR | Micronesia Human Resources Development Centre | NGO/CBO/Academic | 265404 | 114832.8799999999 | -150571.1200000001 | Please refer to Annex 3 | 536834 | 291103.79 | -245730.21 | Please refer to Annex 3
2 | SR | Cook Islands MOH | Ministry of Health (MoH) | 93023 | 67293.70000000014 | -25729.29999999986 | Please refer to Annex 3 | 241823 | 110023.89 | -131799.11 | Please refer to Annex 3
3 | SR | Kiribati MOH | Ministry of Health (MoH) | 326909 | 229792.9800000002 | -97116.01999999984 | Please refer to Annex 3 | 621409 | 395273.93 | -226135.07 | Please refer to Annex 3
4 | SR | Nauru MOH | Ministry of Health (MoH) | 130913 | 45157.75000000001 | -85755.25 | Please refer to Annex 3 | 360913 | 103763.96 | -257149.04 | Please refer to Annex 3
5 | SR | Niue MOH | Ministry of Health (MoH) | 27480 | 10926.58 | -16553.42 | Please refer to Annex 3 | 71480 | 19870.62 | -51609.38 | Please refer to Annex 3
6 | SR | Palau MOH | Ministry of Health (MoH) | 127184 | 67477.4 | -59706.60000000001 | Please refer to Annex 3 | 242984 | 130595.32 | -112388.68 | Please refer to Annex 3
7 | SR | Republic of Marshall Islands MOH | Ministry of Health (MoH) | 347375 | 161479.0699999999 | -185895.9300000001 | Please refer to Annex 3 | 732975 | 349841.12 | -383133.88 | Please refer to Annex 3
8 | SR | Samoa MOH | Ministry of Health (MoH) | 133416 | 34552.48 | -98863.52 | Please refer to Annex 3 | 231416 | 53430.37 | -177985.63 | Please refer to Annex 3
9 | SR | Tonga MOH | Ministry of Health (MoH) | 83070 | 90357.85999999996 | 7287.859999999957 | Please refer to Annex 3 | 204770 | 137707.07 | -67062.93 | Please refer to Annex 3
10 | SR | Tuvalu MOH | Ministry of Health (MoH) | 136845 | 83613.45000000001 | -53231.54999999999 | Please refer to Annex 3 | 349345 | 106594.46 | -242750.54 | Please refer to Annex 3
11 | SR | Vanuatu Country Coordinating Mechanism | NGO/CBO/Academic | 113625 | 80842.78999999995 | -32782.21000000005 | Please refer to Annex 3 | 278125 | 186547.7 | -91577.29999999999 | Please refer to Annex 3
12 | SR | World Health Organization (WPRO) | Other Multilateral Organisation | 753391 | 424331 | -329060 | Please refer to Annex 3 | 1340361 | 586180 | -754181 | Please refer to Annex 3
13 | SR | Secretariat of Pacific Communities TB Section | Other Multilateral Organisation | 313471 | 330770.2 | 17299.19999999995 | Please refer to Annex 3 | 908671 | 534420.64 | -374250.36 | Please refer to Annex 3
14 | PR | Secretariat of Pacific Communities - Centralised Procurement | Other Multilateral Organisation | 114000 | 16279.66 | -97720.34 | Please refer to Annex 3 | 219970 | 176394.95 | -43575.04999999996 | Please refer to Annex 3
15 | PR | Secretariat of Pacific Communities | Other Multilateral Organisation | 594168.63 | 461356.0700000001 | -132812.5599999999 | Please refer to Annex 3 | 1304366.63 | 1099230.73 | -205135.8999999999 | Please refer to Annex 3
 |  |  | Please Select …
 |  |  | TOTAL | 3560274.63 | 2219063.87 | -1341210.76 |  | 7645442.63 | 4280978.550000001 | -3364464.08
To add additional rows, right click the row number (Row 51 in a blank template) to the left of the row above the row for TOTAL and select copy, then over the same number, right click again and select Insert Copied Cells. WARNING: Inserting Rows without copying a row as described above will cause the formula in the variance column to become invalid and will mean the overall information will be inaccurate.
* The sum of all three breakdowns should be equal (A- [NAME]-item, B- Program Activity, C- [NAME]).
** For the purposes of this report, the SDA Program management and administration should be included in the Supportive Environment Macro Category.
D- ADDITIONAL INFORMATION
Please disclose any relevant information concerning the information in the above tables. Refer to the Guidelines for Completing the Template if required.