Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Costing Module #1279

Draft
wants to merge 246 commits into
base: master
Choose a base branch
from
Draft

Costing Module #1279

wants to merge 246 commits into from

Conversation

sakshimohan
Copy link
Collaborator

@sakshimohan sakshimohan commented Feb 20, 2024

This PR adds a costing module to the TLO model.

The current costing method is as follows -
Screenshot 2024-04-23 at 09 37 23

@sakshimohan
Copy link
Collaborator Author

Questions:

  1. Interpretation of Frac_Time_Used_By_OfficerType in the healthsystem logger. I've currently assumed that the values give the total number of staff used in the simulation.
  2. Is it correct to ignore the squeeze factor because the actual capability used is costed? The same costing formula should work for modes 1 and 2.
  3. How is Frac_Time_Used_By_OfficerType recorded when capabilities_coefficient > 1 --> should costs use capabilities_today?
  4. The costing is currently disaggregated by Facility_Level and Officer_Type. For the calculation of intervention ICERs, we will need to calculate cost by Treatment_ID. Does the healthsystem logger capture health worker time by Treatment_ID?

@sakshimohan
Copy link
Collaborator Author

Draft figures for HR salary cost by cadre and level =-
total_salary_by_level
total_salary_by_cadre

@sakshimohan
Copy link
Collaborator Author

I have now created two categories of costs - 1. Financial Cost and 2. Economic Cost. Here is how I envison HR costs will look under the two categories -
costing drawio

Currently the financial cost of HR does not match well with the 2018 salary budget -
Cost_validation

sm2511 added 14 commits February 28, 2024 15:45
- divide the sum of `Frac_Time_Used_By_OfficerType` by the number of days
- plot the aggregate fraction time used by cadre
- include only those cadres from total capabilities which were used in the simulation
- stylistic changes
- we assume that the log file provides the units of consumables needed rather than the number of HSIs which use the consumable
- with update consumables cost
sakshimohan added 4 commits December 2, 2024 15:57
- disaggregate Rm data on vehicles purchase and maintenance
 + remove manual fixes for VL tests and depo
@sakshimohan
Copy link
Collaborator Author

The cost of Oxygen has been changed back from the following to what's in the OHT which is a tenth of this price

<style> </style>
0.005445 Lin et al (2024) - This is the price per litre assuming 8 pressure swin absorption (PSA) plans as of 2023 in Malawi - "Existing PSA" scenario. This cost includes the total cost of production, shipping cylinders, HR, maintenance and operations at production plants (PSA, Trucks, Cylinders, Concentrators, Pulse oximeters, Ventilators, Monitors, Resuscitation, Suction)

@sakshimohan
Copy link
Collaborator Author

sakshimohan commented Dec 4, 2024

Current status of calibration (Areas that need addressing in //bold//)

Cost category Calibration category Actual Expenditure (RM) 2018 Maximum (Annual Projected Budget 2020-2022) TLO Cost Estimate ($) Expenditure as per RM minus TLO Cost estimate
Facility operating costs Facility utility bills 12,142,707.98 31,595,108.55 25,731,776.58  
Facility operating costs Infrastructure - Rehabilitation 4,117,616.05 11,684,723.49 5,570,953.60  
Facility operating costs Vehicles - Fuel and Maintenance 24,393,757.96 32,411,573.39 18,710,184.48  
Human resources for health Health Worker Salaries 114,418,952.79 133,228,884.25 107,230,088.91  
Human resources for health Health Worker Training - In-Service 12,897,136.55 17,743,710.12 12,086,818.36  
Human resources for health Health Worker Training - Pre-Service 1,277,697.67 2,665,199.15 2,852,164.56  
Human resources for health Mentorships & Supportive Supervision 55,553,332.80 66,652,165.02 52,062,955.21  
Medical consumables //Antimalarials// 681,848.59 8,094,056.65 25,609.00 656,239.59
Medical consumables Antiretrovirals 53,796,360.12 77,506,903.49 53,787,113.67  
Medical consumables //Bednets// 3,552,600.00 28,061,308.64 463,707.63 3,088,892.37
Medical consumables //Cervical Cancer// 534,872.32 1,581,977.74 101,750.65 433,121.67
Medical consumables Condoms and Lubricants 210,313.84 11,211,211.72 423,034.86  
Medical consumables //HIV Screening/Diagnostic Tests// 34,469,044.13 94,345,358.80 21,024,664.01 13,444,380.12
Medical consumables //Indoor Residual Spray// 7,272,001.18 13,194,497.82    
Medical consumables //Malaria RDTs// 1,719,000.00 5,643,435.92 538,367.86 1,180,632.14
Medical consumables //Other Drugs, medical supplies, and commodities// 39,437,013.14 80,801,692.06 32,532,025.40  
Medical consumables //Other family planning commodities// 12,323,143.36 21,052,691.19 1,981,220.53 10,341,922.83
Medical consumables Supply Chain 21,341,274.59 37,668,917.17 9,696,423.30  
Medical consumables //TB Tests (including RDTs) // 599,011.62 6,695,563.77 53,719.77 545,291.85
Medical consumables //TB Treatment// 2,338,536.34 4,685,956.00 1,664,427.22 674,109.12
Medical consumables //Undernutrition commodities// 913,214.58 1,721,063.60 23,268.04 889,946.54
Medical consumables Vaccines 4,200,418.52 13,209,399.57 9,319,174.55  
Medical consumables //Voluntary Male Medical Circumcision// 2,891,681.00 1,832,645.01 94,754.61 2,796,926.39
Medical equipment //Medical Equipment - Maintenance// 2,294,331.38 16,468,941.94 712,772.18  
Medical equipment //Medical Equipment - Purchase// 3,754,149.89 19,024,579.29 525,327.86  

sakshimohan added 21 commits December 9, 2024 12:16
- see commits 8d74279 to a814900 in the TLM-Study-Data repository
1. Drug costs recategorised as non-consumable costs removed from supply chain estimates; Supply chain costs from non-EHP costs removed from calibration

2. For 'Travel and Transport' under 'Program Management and Admin'', exclude 7.3% (for CHAM exp) and 12.9% of govt exp from calibration - treat this as higher level admin cost based on Ahmat et al (2022). Also exclude travel and transport for other financial sources.

3. For Infrastructure Rehab, exclude 12.9% as higher level admin cost from calibration.
@sakshimohan
Copy link
Collaborator Author

Pending changes:

  1. iptp in care_for_women_during_pregnancy uses 'Sulfamethoxazole + trimethropin, tablet 400 mg + 80 mg'. Should be changed to 'Fansidar (sulphadoxine / pyrimethamine tab)'
  2. Undernutrition commodities to be added - 'SAM theraputic foods'), 'SAM medicines'), 'Therapeutic spread, sachet 92g/CAR-150', 'F-100 therapeutic diet, sach., 114g/CAR-90'.
  3. Xpert is currently never available. Is it being called at the right level? Only available at levels 2 and 3.

+ update calculation of deviation of model estimate from RM data - take min of absolute deviation from expenditure and budget
+ Add cervical cancer consumables to 'Other drugs and commodities'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

5 participants