Resource Mapping (.csv) ======================= :download:`Download original .csv file from GitHub ` ==== ======================================== ================================================================== ============================================================================================================================================================================================================================================================================================================================= ============================================================ ========================================= ===================================== ===================================== ===================================== .. Cost Type Cost Sub-Type Programmatic Intervention Level 2 [NEW] Calibration\_category EXPENDITURE (USD) (Jul 2018 - Jun 2019) BUDGETS (USD) (Jul 2019 - Jun 2020) BUDGETS (USD) (Jul 2020 - Jun 2021) BUDGETS (USD) (Jul 2021 - Jun 2022) (when the disaggregated data had to rely upon intervention rather than cost sub-type) ==== ======================================== ================================================================== ============================================================================================================================================================================================================================================================================================================================= ============================================================ ========================================= ===================================== ===================================== ===================================== 0 Drugs and Commodities Drugs, medical supplies, and commodities Other Drugs, medical supplies, and commodities 37735051.33 33585891.65 69727962.89 4373929.058 1 Exclude from calibration All Items recategorised as non-consumable costs even though the cost type was drugs and commodities Program Management & Administration 16649853.76 6001427.872 3562765.51 3542670.515 2 Drugs and Commodities All Beyond EHP Non-EHP consumables 25178739.81 18706715.51 957210.23 851070.13 3 Drugs and Commodities All Voluntary Male Medical Circumcision (VMMC) Voluntary Male Medical Circumcision 2891681 1730270.55 1801078.6 1832645.01 4 Drugs and Commodities All Indoor Residual Spray (IRS) Indoor Residual Spray 7272001.18 12766844.17 13187549.04 13155261.5 5 Drugs and Commodities All ITNs/LLIN (Bednets) Bednets 3552600 2807700 28061308.64 8002242.375 6 Drugs and Commodities All ACTs (LA and ASAQ) Antimalarials 681848.59 201412.87 4001222.91 2338244.615 7 Drugs and Commodities All Micro-nutrient Powder - Under 5s Undernutrition commodities 527728.2 1241436.84 934561.73 600000 8 Drugs and Commodities All Plumpy Peanut - Under 5s Undernutrition commodities 120469 211117.57 0 0 9 Drugs and Commodities All School Feeding Programs Undernutrition commodities 87503.8 65312.75 57794.08 68513.69 10 Drugs and Commodities All Vitamin A - Pregnant Women Other Drugs, medical supplies, and commodities 1356.72 191010.31 93975.37 93975.37 11 Drugs and Commodities All Treatment of Undernutrition Undernutrition commodities 177513.58 159150.6705 173928.6313 199995.5039 12 Drugs and Commodities All Cervical Cancer Screening Other Drugs, medical supplies, and commodities 520131.97 851350.84 1384482.72 428059.72 13 Drugs and Commodities All Cervical Cancer Treatment Other Drugs, medical supplies, and commodities 14740.35 197495.02 71332.69 7258.92 14 Drugs and Commodities All Barrier Methods (e.g. condoms) Condoms and Lubricants 112375.97 6640083.82 1558317.15 1558317.15 15 Drugs and Commodities All Hormonal Methods (e.g. implants, injectables, IUD, the pill) Other family planning commodities 12190873.76 15538449.2 4922990.5 5064869.02 16 Drugs and Commodities All Screening and Diagnosis TB Tests (including RDTs) 599011.62 886710.81 2706005.42 2230863.7 17 Drugs and Commodities All First Line Treatment TB Treatment 1068701 2717468 0 0 18 Drugs and Commodities All MDR-TB TB Treatment 1269835.34 1691496 475056.42 368603.07 19 Drugs and Commodities All Polio, Rotavirus, Measles Rubella, Pentavalent, BCG, Tetatanus Toxoid, and Pneumoccal Vaccines Vaccines 4200418.52 13209399.57 1112804.105 1214369.197 20 Drugs and Commodities All Rapid Diagnostic Test (RDT) Malaria RDTs 1719000 2334561.125 3728967.96 2173892.617 21 Drugs and Commodities All Community-Based Testing HIV Screening/Diagnostic Tests 405156.32 337854.83 175603.95 975783.08 22 Drugs and Commodities All Early Infant Diagnosis HIV Screening/Diagnostic Tests 0 0 2713.41 2984.75 23 Drugs and Commodities All Facility-Based Testing HIV Screening/Diagnostic Tests 17101787.53 43055908.24 968741.85 40063479.18 24 Drugs and Commodities All Index Testing including Voluntary Assisted Partner Notification HIV Screening/Diagnostic Tests 0 5150.01 0 0 25 Drugs and Commodities All Self-Testing HIV Screening/Diagnostic Tests 5425 5336.82 58749.99 4492067.47 26 Drugs and Commodities Program Management & Administration not disaggregated Items recategorised as non-consumable costs even though the cost type was drugs and commodities Program Management & Administration 0 0 5743.325949 4677.920585 27 Drugs and Commodities Travel and Transporation Items recategorised as non-consumable costs even though the cost type was drugs and commodities Program Management & Administration 0 0.000509095 0 0 28 Drugs and Commodities Family Planning Other family planning commodities 132269.6 5514241.99 3350000.01 3350000.01 29 Drugs and Commodities IRS (in one district - Ntcheu) Indoor Residual Spray 0 0 6948.786211 5677.98822 30 Drugs and Commodities TB Treatment TB Treatment 0 0 217362 276992 31 Drugs and Commodities Antimalarials (ACTs-LA) Antimalarials 0 0 2013142.07 320675.5249 32 Drugs and Commodities Antimalarials (ASAQ) Antimalarials 0 0 34093.29 5430.76 33 Drugs and Commodities Antimalarials (Injectable artesunate) Antimalarials 0 0 2045598.38 325845.5357 34 Drugs and Commodities Malaria RDTs Malaria RDTs 0 0 1914467.96 304957.6172 35 Drugs and Commodities BCG Vaccine Other Drugs, medical supplies, and commodities 290782.19 0 0 0 36 Drugs and Commodities Td vaccine Other Drugs, medical supplies, and commodities 264785.1 0 0 0 37 Drugs and Commodities AD syringes Other Drugs, medical supplies, and commodities 174838.04 0 0 0 38 HIV Drugs and Commodities Antiretrovirals Antiretrovirals 53796360.12 77506903.49 17561508.19 70061133.79 39 HIV Drugs and Commodities CD4 Tests HIV Screening/Diagnostic Tests 296760 277000 9635 0 40 HIV Drugs and Commodities Condoms and Lubricants Condoms and Lubricants 97937.86801 54904.84746 76848.98347 4571127.903 41 HIV Drugs and Commodities Diagnostic Tests for STI (including rapid testing) Other Drugs, medical supplies, and commodities 78542.52 93131.57977 0 0 42 HIV Drugs and Commodities Diagnostic Tests for TB (including rapid testing) TB Tests (including RDTs) 0 0 1419632.13 3989558.35 43 HIV Drugs and Commodities Drugs, medical supplies, and commodities Other Drugs, medical supplies, and commodities 0 0 0 5014531.74 44 HIV Drugs and Commodities Food and nutrients Other Drugs, medical supplies, and commodities 393900.24 224721.6904 308179.2506 306105.3169 45 HIV Drugs and Commodities HIV Screening/Diagnostic Tests HIV Screening/Diagnostic Tests 6591239.4 9505086.21 69891.2 9334673.76 46 HIV Drugs and Commodities Other Reagents and Testing materials HIV Screening/Diagnostic Tests 10068675.88 33148137.61 273365.04 36031379.04 47 HIV Drugs and Commodities STI Drugs Other Drugs, medical supplies, and commodities 0 0 203612.41 5002265.29 48 HIV Drugs and Commodities ?? Other Drugs, medical supplies, and commodities 497757 464611 16160 0 49 Human Resources for Health Health Worker Salaries Health Worker Salaries 114418952.8 96289447.6 121614819.8 133228884.3 50 Human Resources for Health Health Worker Training - In-Service Health Worker Training - In-Service 12897136.55 13526727.32 17743710.12 13005517.82 51 Human Resources for Health Health Worker Training - Pre-Service Health Worker Training - Pre-Service 1277697.67 1443446.66 2665199.15 1441745.28 52 Human Resources for Health Mentorships & Supportive Supervision Mentorships & Supportive Supervision 55553332.8 66652165.02 40094104.47 18212349.51 53 Infrastructure and Equipment ICT Equipment and Connectivity Facility utility bills 5180629.881 4314681.338 2702409.349 2762060.733 54 Infrastructure and Equipment Infrastructure - New Builds Infrastructure - New Builds 29663284.53 4496146.709 6768215.83 5158459.586 55 Infrastructure and Equipment Infrastructure - Power & Water for Health Facilities Facility utility bills 556017.55 826846.2157 3464467.611 2617045.413 56 Infrastructure and Equipment Infrastructure - Rehabilitation Infrastructure - Rehabilitation 3586443.584 6782715.623 10177394.16 6833923.22 57 Infrastructure and Equipment Infrastructure - Rehabilitation Of the 'Infrastructure - Rehab' for Govt and CHAM, assume that 12.9% of govt exp and 7.3% of CHAM exp goes towards higher level local and central government admin rather than for health facilities. Source of admin %: https://gh.bmj.com/content/7/Suppl\_1/e008317 (See table 2 - Administrative and Support Staff) Program Management & Administration 531172.4711 1004558.341 1507329.33 1012142.475 58 Infrastructure and Equipment Infrastructure - Upgrades Infrastructure - Upgrades 8782296.75 7556835.828 8832821.371 1721579.063 59 Infrastructure and Equipment Medical Equipment - Maintenance Medical Equipment - Maintenance 2294331.38 16010435.79 16468941.94 729799.7752 60 Infrastructure and Equipment Medical Equipment - Purchase Medical Equipment - Purchase 3754149.89 6897681.165 19024579.29 2560323.293 61 Infrastructure and Equipment Vehicles - Purchase and Maintenance Vehicles - Fuel and Maintenance 1161704.41 1009615.048 746055.1 1418265.41 62 Infrastructure and Equipment Vehicles - Purchase and Maintenance Vehicles - Purchase 7744266.84 4606784.203 4535752.158 3253115.205 63 Infrastructure and Equipment Vehicles - Purchase and Maintenance Vehicles - Fuel and Maintenance 1590013.852 1377846.048 2227956.224 1437580.491 64 Infrastructure and Equipment Vehicles - Purchase and Maintenance Vehicles - Purchase 647931.648 471838.8702 539095.8541 336204.143 65 Program Management & Administration Administrative/Support Staff Salaries Program Management & Administration 24192554.5 24037791.15 26523690.62 19765382.08 66 Program Management & Administration Health Worker Salaries Program Management & Administration 1109191 0 0 0 67 Program Management & Administration Meeting Costs Program Management & Administration 4432881.163 6746368.804 8331545.052 4184240.754 68 Program Management & Administration Office Rents Program Management & Administration 233229.3842 180375.503 20586.6663 33273.39701 69 Program Management & Administration Office Supplies Program Management & Administration 6533157.844 2437965.433 1789616.249 1283029.631 70 Program Management & Administration Office Utilities (electricity, water, heating, etc.) Facility utility bills 6406060.55 8508379.558 7459340.455 23815959.6 71 Program Management & Administration Program Management & Administration not disaggregated Program Management & Administration 76286561.89 80112918.41 88020806.59 79180165.51 72 Program Management & Administration Promotional/Information Materials and Printing Program Management & Administration 5470061.04 6574128.75 6477016.358 1981892.293 73 Program Management & Administration Travel and Transporation This is the 'Travel and Transport' for all financing sources Government and CHAM Vehicles - Fuel and Maintenance 11618372.36 3920058.128 6219018.901 5235795.126 74 Program Management & Administration Travel and Transporation Of the 'Vehicle-Fuel and Maintenance' for Govt and CHAM, assume that 12.9% of govt exp and 7.3% of CHAM exp goes towards higher level local and central government admin rather than for health facilities. Source of admin %: https://gh.bmj.com/content/7/Suppl\_1/e008317 (See table 2 - Administrative and Support Staff) Program Management & Administration 1714561.441 573369.0917 916384.9305 775232.6424 75 Program Management & Administration Travel and Transporation This is the 'Travel and Transport' for all financing sources other than Government and CHAM Vehicles - Fuel and Maintenance (Beyond Government and CHAM) 8309105.9 8334574.65 21629947.92 3526722.085 76 Supply Chain Procurement (excluding Drug/Commodity Costs) Supply Chain 9918093.144 9261444.666 10137233.97 14287066.31 77 Supply Chain Warehousing & Distribution Supply Chain 8824388.095 7931021.788 8012147.355 18794789.71 78 Supply Chain Procurement (excluding Drug/Commodity Costs) - non EHP consumables We estimate this as the percentage of drug exp composed of non-EHP consumables multiplied by total Procurement expenditure as per RM - ($11,293,315.25 $10,545,617.26 $11,542,841.69 $16,268,081.12 ) Supply Chain - non-EHP consumables 1375222.106 1284172.598 1405607.716 1981014.811 79 Supply Chain Warehousing & Distribution - non EHP consumables We estimate this as the percentage of drug exp composed of non-EHP consumables multiplied by total warehousing and distribution expenditure as per RM - ( $10,047,959.34 $9,030,720.73 $9,123,094.99 $21,400,836.05 ) Supply Chain - non-EHP consumables 1223571.245 1099698.937 1110947.639 2606046.336 80 (blank) (blank) Unclassified 0 3622078.57 0 0 81 Grand Total 624054026.6 689820411.3 616418054 605723734.1 82 83 84 Categories from Resource Mapping Round 7 Categories from Resource Mapping Round 7 Categories from Resource Mapping Round 7 Categories defined for model ==== ======================================== ================================================================== ============================================================================================================================================================================================================================================================================================================================= ============================================================ ========================================= ===================================== ===================================== =====================================