MDG-Consistent HIV/AIDS Costing Model for Asia and the Pacific
Contents
1. Minus condom double counting a cursor he 23 000 00 40 000 00 The amount of double counted costs for condom provision is subtracted 6 3 Unlocking the Worksheet All the Worksheets are protected or locked except for data entry cells in order to prevent accidental de letion of cells texts and other important information However users can unprotect or unlock the work sheet to make specific changes in default texts settings or formulas To unprotect a particular worksheet select Tool Protect Unprotect Sheet and then changes can be made in any place and any settings under that particular worksheet In case of Excel 2007 select Review Unprotect Sheet as shown below Review View Add l Hide Comment E All Comments Unprotect Ini Sheet M 6 4 Saving the work It is recommended that once data are entered the work be saved as a different file name to keep the original file intact Although the RESET function can restore certain cells to the original state keeping the original file is always a recommended practice 6 5 Customising the MDG Model As the MDG Model is an Excel based tool it offers the flexibility of customisation to best suit local circum stances However caution needs to be exercised particularly in adding deleting moving rows columns cells as there is a currency conversion macro an embedded formula that is aligned specifically with the default cell settings When chang2. Asia region Kumaranayake and Watts 2000 Kumaranayake and Watts 2000 Schwartlander Stover et al 2001 Futures Group Constella Stover et al 2004 Schwartlander Stover et al 2001 Futures Group Constella Stover et al 2004 Schwartlander Stover et al 2001 Futures Group Constella Stover et al 2004 Kumaranayake and Watts 2000 Schwartlander Stover et al 2001 Futures Group Constella Stover et al 2004 Regional HIV amp Development Programme for Asia amp the Pacific UNDP Regional Centre in Colombo 23 Independence Avenue Colombo 7 Sri Lanka Tel 94 11 4526400 Fax 94 11 4526410 Email asiapacific hiv undp org UNDP is the UN s global development network an organization advocating for change and connecting countries to knowledge experience and resources to help people build a better life As a trusted development partner and co sponsor of UNAIDS it helps countries put HIV AIDS at the centre of national development and poverty reduction strategies build national capacity to mobilize all levels of government and civil society for a coordinated and effective response to the epidemic and protect the right of people living with AIDS women and vulnerable population Because HIV AIDS is a world wide problem UNDP supports these national efforts by offering knowledge resources and best practices from around the world
3. 7 Hands on Exercise The best way to get accustomed to the model EXERCISE 1 Basic Moves EXERCISE 2 Enter General Data EXERCISE 3 Enter Intervention Data Annex 1 List of interventions included in the MDG HIV AIDS Costing Model Annex 2 Data needs for the MDG Model Annex 3 Reference unit costs 01 01 03 05 05 05 06 06 07 07 09 10 10 11 11 12 12 13 14 15 16 16 16 16 18 18 19 19 19 19 22 22 23 23 30 32 34 lt lt Contents USER MANUAL ESTIMATING Resource NEEDS Us nG TooLs Costing the Response What is In Scope The aim of costing the response is to determine the total cost This means all interventions and services have a cost even if they are provided free or even if it is envisage that individuals will bear that cost as an out of pocket expense Both capital and recurrent costs need to be included in total cost estimation UN Millennium Project 2005b The total cost needs to be considered when determining and calculating coun try specific unit costs Once the response is costed financing options can then be discussed The focus is on costing all cash flow components which then corresponds to projecting the cash flow re quired to fund the MDGs However opportunity costs associated with communities investing their time in an intervention is not included UN Millennium Project 2005b It is important to understand that total cost estimation is distinct from estimating th
4. Enter basic information into the yellow cells 1 country 2 currency unit 3 US exchange rate 4 Start Year 5 End Year 6 population in Start Year 7 annual population growth rate 8 number of PLHIV in Start Year and its annual growth rate Start amp End Years can be a maximum of 10 years apart from each other For example if the Start Year is 2008 the End Year has to be 2017 or earlier It is recommended that the 10 year interval be used As mentioned above figures in the orange cells can be changed manually For instance if the annual PLHIV growth rate is expected to grow from 6 in 2008 to 8 in 2010 amp onwards in the above example simply left single click the target cell shown in a red box above and type 8 and hit Enter The following years will be automatically changed to 896 e Note that there is a RESET button to clear all the cells in the section on st of PLHIV MDG Consistent HIV AIDS Costing Model for Asia and the Pacific 4 Working on the Enabling Environment Prevention ARV Treatment Care amp Support and Health Systems Worksheets These Worksheets share the common styles and procedures The following provides information that is ap plicable to all these Worksheets Issues specific to a particular worksheet or intervention will be addressed separately 4 1 Including excluding interventions in the total cost calculation As outlined in Part 3 of this user guide country t
5. TOP C19 Module Dim RangeArr 1 To 11 As String RangeArr 1 Enabling Environment C47 L55 Enabling Env Rangze rr 2 Enabling Environment C327 L335 Enabling E Range rr 3 Enabling Environment C633 L843 Enabling E Range rr 4 Prevention D54 M57 Prevention D106 M108 RangzeArr 5 Prevention D331 M332 Prevention D379 M38 RangeArr B Prevention D593 M593 Prevention DB46 MB4 RangeArr 7 ARV Treatment C54 L56 ARY Treatment C58 Range rr 8 Care amp Support C120 L134 Care amp Support Rangze rr 8 Dare amp Support C432 L435 Care amp Support ieee Health Systems C130 L144 Health Systems 1 Range rr 1 Health Systems C551 L585 For i 1 To 11 The red box above shows a place where ranges of cells to be calculated for currency conversion are defined and this is where adjustments need to be made following cell location changes USER MANUAL Each line of formula contains a cell range to be effected by the currency conversion function For example the following formula shows that the first cell range to be effected is between C47 to L55 in the Enabling Environment Worksheet RangeArr 1 Enabling Environment C47 L55 Enabling Environment C87 L95 ee a vn 45 US US US US US US Cell range C47 to L55 all the cells within this range are subject to currency
6. to reflect the impact of marginal costs over time and as coverage increases UN Millennium Project 2005b Note that the cell colour for unit costs are orange which means users can change values e Country teams need to develop and identify unit costs specific for their country and chosen interventions It is envisaged that available country specific resources and involvement of key stakeholders conducting interventions on the ground will facilitate the process of collecting country specific data e Identifying unit costs is vitally importance as they provide concrete criteria and key information e g operational efficiency amp effectiveness to help prioritise interventions within limited financial means as well as help project future costs of particular interventions e However when there are no local unit costs available users can refer to proxy indicators as a reference which can be found in Annex 3 Some proxy indicators are also available in the model where a prox button is located USER MANUAL 4 3 2 Entering costs that cannot be included anywhere or that are shared by multiple interventions Sometimes there are costs that are not specific to a particular intervention or are better to be calculated independently Examples include vehicles and other capital investments that are used for multiple inter ventions The MDG model provides a space to accommodate such cross cutting costs At the end of the Cost Sum mary secti
7. 5 Useful buttons The MDG model introduces useful functions to facilitate the data entry work You will see the following but tons located at certain places in the model Push Buttons RESET clear the cells and restore the original formulas values Pnox Proxy indicators are available Maan Reference information is available e RESET Button This allows the restoration of the original cell formulas values in certain sections This is helpful when formulas contained in certain cells are accidentally deleted or when users wish to perform sensitivity analyses by placing different sets of values to assess their impact on outputs such as the total cost or the level of coverage e PROX Button The MDG model or any costing model requires extensive sets of data in order to perform calculations However sometimes some data are simply not available in a country To help users deal with such a situation the model gives an onsite reference to proxy indicators based on established data e REF Button It gives onsite reference information on certain topics 2 Getting started Open an Excel file with a name MDG consistent HIV Costing Tool e You will be prompted with security warning e Select Enable Macros C Documents and Settings Kaz Local Settings Temp MDG Consistent HIY Costing Tool ver 3 October 2007 xls contains macros Macros may contain viruses It is usually safe to disable macros but if
8. COST SUMMARY worksheet to see the change C Adding miscellaneous expenses You can add expenses that cannot be included in any section Scroll down to the Cost Summary section in Enabling Environment Double click on Cell B929 and type 4x4 Vehicle Enter USD 30 000 in Cell C929 As this is a capital cost tick the box in Cell B929 Go to the COST SUMMARY worksheet to see how this expense is reflected MDG Consistent HIV AIDS Costing Model for Asia and the Pacific 3 2 PREVENTION Go to the PREVENTION worksheet Enter the data based on the information provided below 3 2 1 Prevention of HIV among sex workers 41 The default targets 1 and 2 are non negotiable targets for 2010 Universal Access suggested by UNAIDS Regional Support Team for Asia Pacific ITEM CELL VALUE Number of sex workers C28 23 000 Annual growth rate 96 C29 3 Number of commercial sex acts per sex worker per year C34 Get a proxy figure by pressing PROX Condom wastage 96 65 1 Number of sex workers contacted per counsellor per year C36 200 Target year 2010 96 sex workers contacted per counsellor per year C41 Start 10 D41 Target 80 96 using condoms among those reached by intervention C42 Start 25 D42 Target 60 96 using condoms among those not reached by intervention C43 Start 10 D43 Target 50 96 of all condoms that are female condoms C44 Start 0 D44 Target 5 Unit cost per counsellor per year D53 USD 1000 Unit cost p
9. Projected inflation can be easily accommodated 8 Synchronised with an MDG consistent HIV AIDS needs assessment user guide The MDG Model can be used in tandem with the MDG consistent HIV AIDS needs assessment user guide As needs assessment and prioritization have vital implications on the total cost of intervention synchronization between the needs assessment user guide and the MDG Model provides a principled approach to the needs assessment and costing exercises USER MANUAL 1 Overview of the MDG Model The MDG model is an Excel based tool with imbedded formulas The tool calculates costs per intervention sub totals costs at the level of the following five categories or Response Fields Enabling Environment Pre vention ARV Treatment Care and Support and Health Systems It also calculates an annual grand total for the HIV AIDS response It has a dynamic 10 year time period that users can specify start and end years for The following section describes the basic features and functions of the MDG Model 1 1 Worksheet The MDG model has 7 active worksheets working areas as shown below 1 TOP 2 Enabling Environ ment 3 Prevention 4 ARV Treatment 5 Care amp Support 6 Health Systems and 7 Cost Summary Each tab has a different colour for easy identification AN TOP Enabling Environment Prevention 4 ARV Treatment 4 Care amp Support A Health Systems 4 Cost Summary The worksheets with gray t
10. click the button to open the first intervention section Go to the unit cost section to check the currency unit is USS USER MANUAL EXERCISE 2 Enter General Data Open the Top worksheet Enter the required values on the Top worksheet based on the figures provided below e Press Tab after each data entry Before you enter the number of people living with HIV press RESET to clear the field You do not need to enter 96 when you enter the percentage figures Please note that all figures mentioned in the document are for exercise purposes only ITEM VALUE Country Gaikoku Local Currency Unit G US Exchange rate 75 Costing years Start 2008 End 2017 Population 25 000 000 Annual population growth rate 96 25 Estimated number of people living with HIV 25 000 Annual PLHIV growth rate 3 2008 11 5 201217 EXERCISE 3 Enter Intervention Data 3 1 ENABLING ENVIRONMENT A Open the Enabling Environment worksheet Open the intervention section 1 Review develop amend intellectual property laws to allow the application of TRIPS safeguards and flexibilities by pressing the button left to Cell 58 Let us assume your government has decided the following as in Table 3 a e Reflect the target year in the target cell by double clicking B19 and make the change Enterthe number of intervention based on the information above Add Media Campaign by double clicking on B26 and replacin
11. consistent HIV AIDS Costing Model or the MDG Model The MDG Model is principally built upon the widely used Resource Needs Model developed by the Futures Group and partially upon the Cape Town ARV Costing Model developed by the University of Cape Town It has been developed by UNDP Regional Centre in Colombo in partnership with UNAIDS Regional Support Team for Asia and the Pacific and UNDP MDG Support Team the former UN Millennium Project The MDG Model was primarily developed to assist the governments in Asia and the Pacific carrying out MDG needs assessment exercises based upon recommendations from experts from the region that the existing tools had not addressed some of the key issues that are critical to Asia and the Pacific region and some tools had been highly complex and unfriendly to users The MDG Model is making constant adjust ments and improvements based upon feedback from users in the region While inheriting strengths of the above widely accepted models the MDG still offers useful functions unique features and high utility The key features of the MDG Model are as follows 1 Flexible MDG consistent timeline Users can plan up to or beyond 2015 the MDG target year Users can define start and end years up to a range of 10 years which makes the single model useful for multiple planning horizons short mid and long terms 2 UNAIDS targets for the 2010 universal access goal incorporated All UNAIDS non negoti
12. efforts and to make adjustments midway depending on the progress The model assumes a linear increase in the coverage level Years after the target year maintain the target coverage level at default USER MANUAL 4 3 Data entry Data entry is straight forward in the MDG model in most cases Users simply enter required data in yellow cells Some sections require all yellow cells to be filled with data missing data will produce either no or incorrect calculations In an example below the user enters interventions that are considered necessary to achieve the target This is followed by the annual frequency of each intervention and its unit cost that are entered into appropriate yellow cells In some other cases interventions are pre determined such as HIV prevention among sex workers fol lowed by the coverage level and unit cost In the below example an intervention Commission baseline studies will take place once in 2007 at the cost of 3000 An intervention Dissemination workshops will take place 3 times in 2008 at the cost of 5000 per workshop Note that the unit cost is always entered into the 2007 or Target Year column In the case of Commission drafting of a bill the unit cost of 2000 is entered into the 2007 column despite the fact that the activity will take place only in 2008 However the 2000 in the 2007 column is shown faded indicating that it will not be calculated 1 Review develop am
13. of nutritional unit by type Percentage of people living with HIV and AIDS desiring home based care number of clients served per home based care provider number receiving training frequency of visit to clients number of transport items for purchase number of accompanied referrals number of HBC supervised by each supervisor training for supervisors number of supervisor visits per month number of transport items for purchase for supervisors unit costs per home based care provider salary training supplies unit costs per provider to client unit cost per supervisor per visit per transportation per training Number of orphans and vulnerable children of people living with HIV and AIDS cost of support per orphan and per vulnerable child Define programs to support PLWHAs their demand number of PLWHA per program number of new programs stated each year recurrent and capital cost of program HEALTH SYSTEMS Define health facilities types number of health facilities by type number to build number for rehabilitation construction and equipment costs operations and maintenance costs rehabilitating facilities costs then percentage attributable to HIV AIDS case loads of above of total costs Define human resources number of human resources by type training numbers numbers to receive special HIV related training training costs by type salary costs by type cost of standard in service and non standard training by type then percen
14. the macros are legitimate you might lose some functionality Disable Macros Enable Macros More Info If you do not see this Security Warning select Tools on the menu bar at the top Macro Security You will see the following window MDG Consistent HIV AIDS Costing Model for Asia and the Pacific Security NNNM TS t Security Level Trusted Publishers very High Only macros installed in trusted locations will be allowed to run All other signed and unsigned macros are disabled C High Only signed macros from trusted sources will be allowed to run Unsigned macros are automatically disabled Medium You can choose whether or not to run potentially unsafe macros E Low not recommended You are not protected from potentially unsafe macros Use this setting only if you have virus scanning software installed or you have checked the safety of all documents you open e Ensure Medium is selected e Once Medium is selected close and re open the file The Security Warning Prompt as shown above should appear this time e NOTE The MDG model will not function properly without Macros enabled In case of Excel 2007 Open an Excel file with a name MDG consistent HIV Costing Tool Press Options in the Security Warning bar located under the menu bar DI v a 157 Wiley WA d aa qv Arial i10 B i u 2 a fo 9 LAN I VY a VOX I e Security Warning Macros have been disable
15. Therapy MDG Consistent HIV AIDS Costing Model for Asia and the Pacific The default target is a non negotiable targets for 2010 Universal Access suggested by UNAIDS Regional Support Team for Asia Pacific ITEM VALUE Adults in need of ART as of total PLHIV Children in need of ART as of total PLHIV Target year Adults in need of ART receiving ART Children in need of ART receiving ART Adults on first line ARV medicines Adults on second line ARV medicines Adults failing therapy Children on first line ARV medicines Children on second line ARV medicines Children failing therapy Cost of adult first line ART per person per year Cost of adult second line ART per person per year Cost of adult failing therapy per person per year Cost of child first line ART per person per year Cost of child second line ART per person per year Cost of child failing therapy per person per year 10 0 1 2010 Start 7 Target 75 Start 5 Target 75 99 2008 12 95 2013 0 1 2008 12 2 2013 0 9 2008 12 3 2013 98 2008 12 90 2013 0 2 2008 12 5 2013 1 8 2008 12 5 2013 USD 138 2008 10 USD 100 2011 USD 1285 2008 10 USD 650 2011 USD 3000 USD 138 2008 10 USD 100 2011 USD 1500 2008 10 USD 800 2011 USD 4000 When done check the cost summary and graphs at the lower part of the worksheet to see if the figures are properly reflec
16. User MANUAL MDG Consistent HIV AIDS Costing Model for Asia and the Pacific UNDP HIV AIDS Practice Team Regional Centre Colombo User MANUAL MDG Consistent HIV AIDS Costing Model for Asia and the Pacific UNDP HIV AIDS Practice Team Regional Centre Colombo Costing the Response What is In Scope HIV Modelling and Costing Tools Using the MDG Consistent HIV AIDS Costing Model for Asia and the Pacific MDG Model 1 Overview of the MDG Model 1 1 Worksheet 1 2 Structure 1 3 Colour Scheme 1 4 US Dollar Local currency conversion 1 5 Useful buttons 2 Getting started 3 Working on the TOP Worksheet 4 Working on the Enabling Environment Prevention ARV Treatment Care amp Support and Health Systems Worksheets 4 1 Including excluding interventions in the total cost calculation 4 2 Entering data 4 2 1 Opening the data entry section 4 2 2 Closing the data entry section 4 2 3 Setting the target 4 3 Data entry 4 3 1 Unit costs 4 3 2 Entering costs that cannot be included anywhere or that are shared by multiple interventions 5 Reviewing the results a Total cost of a particular intervention b A total cost for a particular field of response c Aggregate total costs 6 Areas that need special attention 6 1 The Health Systems Worksheet 6 2 Condom provisions in the Prevention Worksheet 6 3 Unlocking the Worksheet 6 4 Saving the work 6 5 Customising the MDG Model
17. Year represents figures without annual inflation These graphs can be useful materials which can be used for a presentation to donors and stakeholders HIV AIDS Costs By Year 16 000 000 00 14 000 000 00 mHealth Systems 12 000 000 00 m Enabling 10 00 000 00 Environment 00 000 00 BCare amp Support 500 000 00 4 000 000 00 2 000 000 00 Prevention i Treatment 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Year Distribution of HIV AIDS Costs For All Years B ARV Treatment m Prevention m Care amp Support iB Enabling Environment Health Systems MDG Consistent HIV AIDS Costing Model for Asia and the Pacific 6 Areas that need special attention 6 1 The Health Systems Worksheet As a component of the cost of HIV AIDS medical interventions will include the cost of the health facilities and human resources associated with delivery of that intervention users need to decide on how to incor porate those costs There are two possible ways these costs can be incorporated 1 a component included in the unit cost of the medical intervention or 2 by entering health facility and human resource details and then specifying the HIV AIDS propor tion of those construction maintenance and human resource cost details on the Health Systems Worksheet If the latter is chosen users need to take the following steps a Check the boxes in the default intervention list to include the cost of Health S
18. able and other key targets for Asia amp Pacific for the 2010 universal access have been incorporated making the tool consistent with both the 2010 universal access and 2015 MDG 6 goals In 2007 the universal access became one of the HIV MDG targets 6B for Asia and the Pacific on which countries are required to report 3 Target result based costing All the interventions in the MDG Model have their own target s defined by each country and prominently listed at the top of respective data entry section The target enables result based costing and provides a good system of accountability and monitoring the progress towards the target 4 Expanded Scope New interventions which have been shown as important for an effective HIV AIDS response in Asia and the Pacific have been added under the heading Enabling Environment Particularly this section addresses human rights gender and governance dimensions of HIV responses e Flexible interventions have been included allowing users to define and add country specific interventions e g Other Programs to Support PLWHAs MDG Consistent HIV AIDS Costing Model for Asia and the Pacific e Human resources have been expanded to include more than only physicians in fact users can define multiple cadres of human resources as necessary including managerial and administrative staff e Facility capital and recurrent costs have been added 5 More detail and disaggregation e Major cost co
19. abs such as TP and EE as shown above are not for use and should not be altered or deleted See 6 4 for more details 1 2 Structure Each worksheet for specific intervention area Enabling Environment Prevention ARV Treatment Care amp Support and Health Systems is consisted of 4 sections LA c ARV Treatment Antiretroviral Therapy Convert Laboratory Tests Associated with Antiretroviral Therapy US Doller List of interventions o Data entry section e 1 Treatment Antiretroviral Therapy 23 250 000 25 833 333 28 416 667 Laboratory Tests Associated with Antiretroviral Therapy 5 500 000 1 555 556 10 611 111 Subtotal Treatment 28 750 000 27 388 888 39 027 778 Cost summary section e 292 Costs of Treatment by Year 293 284 50 000 000 238 40 000 000 287 x 30 000 000 208 S 20 000 000 288 40 000 000 300 301 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 302 Year 303 Graphical representations o of the costing results 306 Distribution of Prevention Costs Across All Years 5 311 B Antiretroviral Therapy EE m Laboratory Tests Associated wit Antiretroviral Therapy 314 315 BIB MDG Consistent HIV AIDS Costing Model for Asia and the Pacific 1 3 Colour Scheme The MDG model uses the following cell colour scheme to visually
20. conversion calculations Therefore changes in the location of cells that are subject to currency conversion need to be reflected in the cell range in the currency conversion macro If for example a new raw is inserted between rows 46 and 47 in the above example it will affect the location of all the cells after row 47 In this case the entire cell ranges for Enabling Environment in the macro need to be adjusted accordingly to capture the new cell range You can see that there are five blocks of formulas which correspond to the 5 Worksheets response fields of the model The adjustments such as above need to be made only within the block of a particular Worksheet where changes have occurred In the example above changes in the cell range need to be made only in the block of formulas for Enabling Environment After all the changes have been made the entire worksheet needs to be copied and pasted into its cor responding reserve worksheet Each Worksheet has its own reserve worksheet such as TP EE P T which stand for ToP Enabling Environment Prevention and Treatment respectively These reserve worksheets are used to restore the original state of specific cells when the RESET function is used Therefore when changes are made in the structure of a Worksheet they need to be reflected in its reserve sheet MDG Consistent HIV AIDS Costing Model for Asia and the Pacific 7 Hands on Exercise The best way to get accustomed t
21. d E26 c fa N26 You will be prompted with the Security Alert Macro window Select Enable this content and press OK Microsoft Office Security Options Q Security Alert Macro Macro Macros have been disabled Macros might contain viruses or other security hazards Do not enable this content unless you trust the source of this file Warning It is not possible to determine that this content came from a trustworthy source You should leave this content disabled unless the content provides critical functionality and you trust its source More information File Path C az MDG Model MDG Consistent HIV Costing Tool ver 21 June 2008 xls Help protect me from unknown content recommended USER MANUAL 3 Working on the TOP Worksheet The TOP Worksheet is where basic information such as currency start amp end years and demographic infor mation is entered The MDG consistent HIV AIDS costing model for Asia and the Pacific ver 3 Oct 07 The HIV AIDS Practice Team at UNDP Regional Centre in Colombo Enter relevant information in the yellow cells Push Buttons RESET ESESECISUDESSIEDDPECS OLR UCR LLL Count s Unit US Exch Rat ountry urrency Uni xchange Rate TOU EOS G Proxy indicators are available Start Year End Year Waal Reference information is available Annual Population Growth Rate RESET Year 2007 2008 2009 2010 2011 2012 Annual PLHIV Growth Rate
22. e cost effectiveness of interventions or projecting the impact of interventions on the future course of the epidemic such as modelling HIV Modelling and Costing Tools There are a number of tools available for measuring the impact of and costing the response to HIV AIDS These tools have different purposes as mapped out below MODEL TYPE MODEL NAME MODEL PURPOSE SOURCE Epidemiological Asia Epidemic Model Allows examination of http www eastwestcenter org modelling AEM the impacts of different prevention program choices on the course of the epidemic Estimation and Projection EPP is used to estimate http www constellafutures com Package EPP and project adult HIV prevalence from surveillance data in countries with generalised epidemics Funding and goals GOALS It is intended to http www constellafutures com assist planners in understanding the effects of funding levels and allocation patterns on program impact MODEL TYPE MODEL NAME INPUT Resource Needs Model RNM Cape Town ARV treatment model ASAP HIV AIDS Strategy Costing Model ASAP The MDG consistent HIV AIDS Costing model MDG Model for Asia and the Pacific MDG Consistent HIV AIDS Costing Model for Asia and the Pacific MODEL PURPOSE INPUT accompanies the Costing Guidelines for HIV AIDS Intervention Strategies UNAIDS and ADB 2004 INPUT calculates the unit costs for common HIV AIDS interventions using local cost informati
23. e such as enabling environment prevention and ARV treatment is shown in the Cost Summary section as below as well as in the Cost Summary Worksheet 1 Cost Summary 32 3 Treatment 4 1 Antiretroviral Therapy 2 844 000 00 4 381 650 5 2 Laboratory Tests Associated with Antiretroviral Therapy 308 375 00 1 119 289 Total annual cost for ARV treatment for 2008 c Aggregate total costs The Cost Summary Worksheet gives a comprehensive summary of all costs by response field intervention year and aggregate total It also provides information on annual capital cost as well as annual per capita cost These disaggregated figures can be useful particularly in budget negotiation resource mobilisation and donor reporting purposes Capital Costs 200 000 USER MANUAL Additionally users can adjust the total cost figures according to projected inflation rates to produce as re alistic figures as possible Inflation rates can be manually entered into the yellow cell as below Annual inflation rate Total All HIV AIDS Costs 3 246 946 25 5 720 977 44 As mentioned previously the currency unit can be changed at any time using the Currency Converter to review figures both in the US Dollars and the local currency of choice The model also produces graphs as a visual aid to understanding the projected trends up to the End Year and proportion of costs by response field Note that the graph HIV AIDS Costs By
24. eams need to identify interventions that are relevant for their epidemic which will allow them to achieve their HIV AIDS Millennium Development Goal and target The MDG model offers flexibility in including relevant interventions for each country s response to the epidemic Each worksheet has default interventions listed at the top See the list of default interventions in Annex 1 All the listed interventions are selected a tick in the box as below as default which means costs of these interventions will be included in the total cost However you can also exclude particular interventions as shown below by ticking off a box This function also allows users to assess the financial impact of particular interventions on the total cost by checking the box on and off If an intervention is not relevant simply leave the check box 1 2 3 4 5 6 R Also users can change the name of interventions To change the name right click on the cell containing the intervention you wish to change This will show the name of the intervention in the formula box see below in which you can enter a new name New name can be entered here iy Fe Zz U zz EuIzy 7 7 f 6 Other Vulnerable Population 2 defined by use p USER MANUAL 4 2 Entering data 4 2 1 Opening the data entry section At default all data entry sections are closed showing only the name of intervention and its target s This setting makes it easier to find a
25. ement programmes for prevention of parent to child transmission PPTCT Develop and implement programs for young people HIV prevention programmes for in school and out of school children By 2015 affordable HIV testing and appropriate counseling are offered at all clinics for STI TB and antenatal care 80 of pregnant women accessing services related to PPTCT 100 of young people having access to reliable information about the epidemic and how to protect themselves 96 primary students with teachers trained in HIV AIDS 96 secondary students with teachers trained in HIV AIDS 96 out of school youth reached USER MANUAL Develop and implement workplace HIV AIDS policies and programmes in partnership Presence of national workplace HIV AIDS policies with the business sector 96 of industries having workplace HIV AIDS policies 96 of workforce reached by prevention programmes workforce receiving peer education 96 workforce receiving STI treatment 96 workforce receiving condoms Develop and implement comprehensive HIV programmes for both brothel and no 80 96 of sex workers reached by intervention by 2015 brothel based sex workers and their clients 60 96 of sex workers reached by intervention using condoms 96 using condoms among those not reached by intervention 96 of all condoms that are female condoms Develop and implement comprehensive HIV programmes for IDUs 8096 of IDUs receive harm reduction interven
26. end intellectual property laws to Target Presence of intellectual property laws that will enable access CE CO Enter activities that are considered m necessary to achieve the target Dissemination workshops nm will happen 3 OREL AUS FAUTES DAL JE times in 2008 The unit cost must always be entered into yellow cells in this first Start Year column As mentioned previously the MDG model has a useful RESET button to clear a particular field and restore its original state This could be a very powerful function which allows an easy entry of different figures to assess their impact on the cost without manually erasing each cell for a different figure MDG Consistent HIV AIDS Costing Model for Asia and the Pacific 4 3 1 Unit costs Before entering unit costs users need to decide what currency to use The model uses the US Dollar as a default currency unit If a local currency as defined in the Top worksheet is preferred you need to change the working currency unit from USS to a local currency The working currency unit can be changed from USS to a local currency by selecting Currency Converter Convert as shown in 1 4 above Note the Currency Converter menu does not appear if macros are not enabled Some notes on the unit cost e The unit cost is the total financial value of the intervention Asa preference use unit cost data that is country specific only referencing globally defined figur
27. er male condom distributed D54 USD 0 3 Unit cost per female condom distributed D55 USD 1 au e Close the section by pressing the button or 1 USER MANUAL 3 2 2 Workplace Programme 49 ITEM Labour force participation rate Male 96 Labour force participation rate Female 96 Number of sex acts with regular partners per year Adult male population Adult female population Target year 96 workforce receiving peer education intervention 96 workforce receiving STI treatment 96 workforce receiving condoms Unit cost of person in employment reached peer education intervention Unit cost of STI treated in workplace Unit cost per male condom distributed CELL e35 C352 C355 D359 D360 C368 D368 C369 D369 C370 D370 D379 D380 D381 VALUE 80 40 60 12 000 000 11 000 000 2015 Start 5 Target 50 Start 50 Target 80 Start 10 Target 50 USD 0 5 USD 1 USD 0 1 When done check the cost summary and graphs to see if the figures are properly reflected Then tick off a box next to 9 Workplace Programme in the list of interventions at the upper left corner of the worksheet Scroll down to the cost summary section and check if the cost for Workplace Programme has now been removed 3 3 ARV TREATMENT Enter the data based on the information provided below Note the change in values in the midway for some items 3 3 1 Antiretroviral
28. es are made and original cell locations are shifted the currency conversion macro needs to be adjusted accordingly To do so first open the macro by selecting Tool Macro Macros MDG Consistent HIV AIDS Costing Model for Asia and the Pacific You will be prompted with a Macro window Macro 3x Macro name Button595 Click Button6D0 Click Click reateMenu DeleteMenu Creat Flow ES Flow2 Module10 P Delete Module5 P Module7 P Open Proxy 1 Macros in Jal Open Workbooks Y Description zl Options Select convert Edit to open an editor for a macro that calculates currency conversion iai Microsoft Visual Basic MDG Consistent HIY Costing Tool ver 1 September 2008 xls Module t Code l ini x 2i File Edit View Insert Format Debug Run Tools Add Ins Window Help 28 X iB R dd x 349 d 70 Co nu m B amp 57 Sy 2o 1n45 Col 38 j Project YBAProject General convert gt y 3 Sheet3 Care amp Supp Sheet38 Prevention Sheet39 P rl Dim prevRate curRate Currency conversion Sub convert Dim temp As Double Sheet MenuSheet Dim i As Integer P Sheet P34 Sheet8 T Dim cell As Range Sheet9 EE prevRate Range TOP E187 Properties Module1 xj curRate Range TOP D19 Module Module mi Ranze TOP E13 Range TOP D18 Alphabetic Categorized Range TOP F19 Range
29. es as a guideline The INPUT model is designed to estimate the unit cost of various HIV interventions Locally developed unit costs will be more accurate provide a better understanding of intervention costs and their associated implications and thus greater ownership of the costing outputs Alban and EASE International n d Ensure the unit cost equates to the intervention For example if the intervention is to provide harm reduction for injecting drug users including pharmacotherapy needle exchange programs condom provision shelter and life building skills ensure that the unit cost includes all of those elements not just pharmacotherapy and needle exchange e Capital and human resource costs The INPUT model and Costing Guidelines for HIV AIDS interventions strategies illustrates how to include these costs in the unit cost UNAIDS and ADB 2004 Alternatively the proportion of infrastructure and human resource unit costs attributable to HIV can be entered on the Health Systems worksheets as discussed below Ensure that the unit cost is reflective of the scope and coverage of the intervention Questions such as follows need to be examined when determining the appropriate unit cost Does the unit cost vary between rural and urban populations Does the unit cost vary for interventions targeting youths in school to those out of school The model assumes unit costs are constant across the time period However this can be changed
30. g Other 1 with Media Campaign MDG Consistent HIV AIDS Costing Model for Asia and the Pacific Table 3 a ITEM VALUE UNIT COST CELL Target year 2011 Activities to carry out 5 1 baseline study Conducted once in 2008 USD 1000 C47 2 Drafting a bill Conducted once in 2009 USD 2000 C48 3 Dissemination Conducted once in 2008 amp 2009 USD 3000 C49 workshops 4 National consultative Conducted twice a year in 2008 9 10 amp 11 USD 5000 C50 meetings Add 5 Media Campaign Conducted once in 2010 USD 10 000 C51 Enter the unit cost for the corresponding activity All the unit costs are to be entered in the yellow cells in the C column You should have the following cost figures 14 000 2008 15 000 2009 20 000 2010 10 000 2011 Now select Convert in the Currency Converter to translate the USD into the local currency GS as defined in the TOP Worksheet Select USD in the Currency Converter to return back to G Scroll down to the Cost Summary section to see if the cost of the newly entered intervention is reflected in the table as well as in the graphs uou e Close the section either by pressing the corner B Open the section 12 Conduct research and or strengthen surveillance system to collect epidemio logical data related to HIV and provide evidence for optimal decision making and resource prioriti sation by clicking the button next to Cell 660 button next
31. guide users for easy data entry and analysis 1 4 US Dollar Local Currency Conversion Users can work either with the US dollar or the local currency of choice The default setting is US dollar but it can be changed to the local currency at any time by selecting Currency Converter Convert located at the menu bar Note Currency Converter does not appear unless Macros are enabled See 2 Getting Started ndow amp Currency Converter J Help A This will translate all USD figures in the model into the local currency across all the worksheets as per the US exchange rate defined in the TOP worksheet If you want to go back to USD simply select Currency Converter US dollar The currency unit can be converted between the US and the local currency at any time When conversion is performed all the financial values across all the worksheets in the model will be converted into the cur rency of choice It is a useful function as it allows users to work with the local currency unit while the cost can be converted into the US for resource mobilisation purposes Additionally the conversion function allows only one cur rency unit to be displayed as opposed to two different currencies as seen in some other costing models which can sometimes be quite confusing In case of Excel 2007 e Click on the Add Inns tab in the menu bar see below and the Currency Converter will appear Wi Add Ins L USER MANUAL 1
32. ide support to families of people living with HIV 96 of families or positive people provided with counseling support including facilities and parents participation in MTCT plus MDG Consistent HIV AIDS Costing Model for Asia and the Pacific Annex 2 Data needs for the MDG Model Depending on which interventions your country decides to pursue the following indicates the data input needs for the HIV AIDS resource needs model ENABLING ENVIRONMENT Unit costs for studies commissioned on changing legislation monitoring human rights stigma and discrimination and advocacy programs Unit costs for consultation meetings on changing legislation monitoring human rights stigma and discrimination and advocacy programs Unit costs for staffing on changing legislation monitoring human rights and stigma discrimination and advocacy programs Numbers of people receiving training frequency of training number of people per training session and number of trainers needed Unit costs of training per session per trainee and per trainer Define and identify the number of programs for research and analysis and their respective unit recurrent and one off costs Define and identify the number of programs for epidemiological and BSS data collection and their respective unit recurrent and one off costs Define and identify the number of programs for empowerment and capacity building and their respective unit recurrent and one off costs Unit c
33. ique features of the MDG model is that each intervention is accompanied by its specific target s defined by users These targets are defined by each country and enables results based costing with a system of accountability and monitoring of the progress The default targets which include UNAIDS non negotiable targets for universal access to prevention treat ment and care by 2010 which were officially incorporated into MDG targets for Asia and the Pacific in 2007 can be easily redefined by double clicking on the cell that contains the target In some interventions these targets are then entered manually into the model as below 1 HIV Prevention among Sex Workers Target 1 28 of sex workers reached by intervention by 2010 Target 2 60 of sex workers reached by intervention using condoms by 2010 Target 3 of an candoms that are female condoms Start Year Target Year 2007 First you enter the Target Year 2010 in the above example followed by a coverage level of the current or Start Year 5096 and that of the Target Year 8096 The model then assumes a linear increase between the start and the end year and automatically generates a coverage level to be achieved in each year in order to achieve the target see below The coverage level after that target year will sustain the target level However the coverage levels can be changed manually as they are in orange cells allowing users to front load or backload
34. isation Monitor human rights violations against people living with HIV and their family members Implement programmes to reduce stigma and discrimination Support the empowerment and capacity building of HIV positive people s networks for their meaningful participation in the response Mobilise resources Presence of IP laws that will enable access to affordable generic HIV medicines by 20XX target year defined by each country Presence of legislations that protect women s rights to property and inheritance by 20XX Presence of legislations that de criminalise sex workers and MSM and that promote and protect the rights of women by 20XX Presence of legislations that enable harm reduction activities for IDUs by 20XX 96 of vulnerable population having access to affordable legal support Presence of reliable recent and longitudinal data related to the epidemic including behavior and knowledge for planning monitoring and evaluation Presence of monitoring and redress systems of human rights violations against PLHIV by 20XX Reduction in stigma and discrimination against the baseline Presence of positive people s networks organisationally and financially empowered to advocate for their rights and provide services by 20XX Resources domestic and international fully meet estimated needs by 2008 or increase resources by three times from the 2005 level PREVENTION Ensure HIV testing and counseling are available and affordable Impl
35. l 2001 under public Futures Group and commercial Constella Stover et sector Asia region al 2004 extrapolated Male condom Low 0 10 Per condom Kumaranayake and Med 0 34 economic cost full Watts 2000 High 0 50 sub Saharan Africa Condom distributed in the public sector USER MANUAL INTERVENTION ITEM UNIT COST USD SCOPE SOURCE Cost per campaign Cost of screening a unit of blood for HIV include cost of replacement of blood when discarded because of a positive test Cost of screening a unit of blood for HIV Cost of PEP kit Additional cost of AD syringes Cost per teacher training primary school Cost per teacher training secondary school Cost per teacher training primary and secondary school Low 490 000 Med 517 000 High 650 00 Low 5 30 Med 12 50 High 18 20 Low 3 76 Med 18 22 100 0 03 Low 75 Med 200 High 400 Low 120 Med 240 High 495 Low 35 27 Med 199 01 Sub Saharan data economic cost full cost Low cost includes salary and overheads costs in Gabon Medium costs relates to 3 month program excludes overheads and salaries High cost extrapolated Sub Saharan data based on national and hospital systems in Zimbabwe Zambia and Uganda Asia region Asia region Asia region Sub Saharan Africa financial cost incremental cost Tanzania data economic cost incremental from Cameroon
36. mponents of interventions are clearly defined e g costs of home based Care include salaries incentives to providers salaries of supervisors transportation equipment or reimbursements to each cadre etc e STIs and Ols are disaggregated and costed by individual infection as defined by users Where applicable capital and recurrent costs are differentiated 6 Increased transparency and simplicity All data and calculations for each major HIV AIDS category e g prevention treatment etc occur on a single worksheet that runs top to bottom e No hidden assumptions e The Model calculates total capital costs which are extremely important in expenditure analysis and resource mobilization 7 User friendly interface with high utility Color coding helps users easily differentiate between input and output cells Unit cost inputs have been reorganized for conceptual ease e g cost per outreach worker visit is disaggregated into its constituent inputs that may be more readily understood by users User provides population data directly so that that model can be used at sub or supra national levels as necessary Users can change unit costs and coverage scale up paths each year e It can explicitly include health infrastructure and human resource costs Users can restore the original formula and conditions with a push of a button RESET Userscan refer to proxy data and reference information to assist data entry
37. o the model Often the best way to get started and familiarised with the tool is by actually using it There is an introduc tory exercise below which walks you through all basic functions and features of the MDG model It is highly recommended that users wishing to use this model go through the exercise before actually working on the model EXERCISE 1 Basic Moves 1 1 Open a file MDG Consistent HIV AIDS Costing Tool ver exl on the Desktop Click Enable Macro If you do not see this please do the following 1 Tool 2 Option gt Security gt Macro Security gt Check Medium 2 Close and Re start Excel 1 2 Open the following worksheets by clicking a corresponding tab and scroll up and down to skim through the entire worksheet Enabling Environment e Prevention e ARV Treatment Care amp Support e Summary Cost 1 3 Open the Enabling Environment worksheet e Unfold all the intervention sections by clicking the 2 button located at the upper left corner of the worksheet Scroll down to see if all the sections are fully open e Fold all the intervention sections by clicking the 1 button e Unfold the first intervention Review develop amend intellectual property laws to allow the application of TRIPS safeguards and flexibilities by clicking the button at the left side of the target row 58 Fold the first intervention section by clicking the button row 58 e Again
38. on The RNM model costs a suite of interventions split into prevention treatment and care and orphan support The Cape Town model is a detailed treatment model designed to assist planners in estimating costs associated with antiretroviral treatment The ASAP model partially based on RNM creates linkages among costing national chart of accounts and national strategic priorities The MDG Model is built upon RNM and the Cape Town model It is consistent with the MDG time frame and incorporates HIV specific MDG targets and interventions for Asia and the Pacific SOURCE Jointly developed by UNAIDS and ADB http www constellafutures com Included as a module in the Health Care Costing Model from the UN Millennium Project Developed by ASAP AIDS Strategy amp Action Plan http www worldbank org asap Developed by UNDP Regional Centre in Colombo in partnership with UNAIDS Regional Support Team for Asia and the Pacific and UNDP MDG Support Team Some of these tools have objectives broader than costing interventions and may be employed by countries to provide epidemiological inputs to costing exercises to help prioritise interventions and to monitor the impact of interventions on country goals and targets USER MANUAL Using the MDG Consistent HIV AIDS Costing Model for Asia and the Pacific MDG Model This section focuses on estimating the total cost of HIV AIDS responses using the MDG
39. on in each Worksheet there are yellow cells that can accommodate such costs Double click on a cell Other and enter the name of the cost If it is a capital cost a small box needs to be ticked so that it will be properly reflected as such in the Cost Summary Worksheet Additionally this space also provides a flexibility of plugging in the total cost of a particular intervention or response field that is already available or generated using different tools For example if a country wishes to calculate the total cost of ARV medicines with a high level of details such as combination regimen specific estimates which is not available in the MDG model it can be performed by such a tool as the Cape Town Model Then the total amount calculated can simply be copied and pasted in this space while keeping all the other areas unused MDG Consistent HIV AIDS Costing Model for Asia and the Pacific 5 Reviewing the results After entering appropriate data costs can be viewed at 3 different levels a intervention b response field e g prevention and c aggregate total a Total cost of a particular intervention A total cost of a particular intervention is shown at the bottom of the data entry section of each interven tion in the Cost Summary section towards the end of the Worksheet as well as in the Cost Summary Work sheet b A total cost for a particular field of response Total annual costs for a particular field of respons
40. osts of legal support per person PREVENTION Sex workers population growth rate number of commercial sex acts per sex worker per year condom wastage number of sex workers contacted per counsellor per year unit cost of counsellor male and female condoms MSM population growth rate number of sex acts per man having sex with men per year condom wastage number of MSM contacted per counsellor per year unit cost of counsellor and male condoms IDU population growth rate number of IDUs researched per counsellor number of sex acts per IDU per year number of injecting acts per IDU per year unit cost of harm reduction or components of harm reduction programs Labour force participation rate male female percent of labour force in services and industry and in wage employment agriculture number of sex acts with regular partners per year unit costs per person in employment reached for STI treatment in workplace and male condom distributed Population details including percentage of males in partnerships in casual relationships number of sex acts for casual relationships and number of sex acts with partners per year condom wastage percentage of condoms distributed through social marketing and percentage of population living in urban areas and unit cost per male condom Number of people in need of VCT average number of VCT services needed per person per year number of VCT services provided per counsellor per year number of counsellor to
41. particular intervention among many and to keep the worksheet organised There are two ways to open the data entry section 1 Opening the data entry section for a particular intervention s You can open only a selected intervention s by clicking a plus sign located on the left side of the work sheet For example to open the data entry section for an intervention 1 in the example below clicking on the plus sign located at the left side of Row 155 opens the data entry section for the intervention 1 Data entry section for Data entry section for intervention 1 closed intervention 1 open 0e 9 0m ab nm amp GW Po 155 _ B You can open the only section s you are working on so that the worksheet stays organised less confusing and easier to navigate 2 Opening all the data entry section for all the interventions at one go You can open the data entry section for all the interventions at one go click on 2 located at the upper left corner of Excel J Ly um Arial 1 Close all the data entry sections 2 Open all the data entry sections MDG Consistent HIV AIDS Costing Model for Asia and the Pacific 4 2 2 Closing the data entry section The data entry section can be closed by either clicking a minus sign located on the left side of the row number or by clicking a 1 at the upper left corner of Excel 4 2 3 Setting the target One of the un
42. tage attributable to HIV AIDS case loads of above of total costs MDG Consistent HIV AIDS Costing Model for Asia and the Pacific Annex 3 Reference unit costs ITEM UNIT COST USD SCOPE SOURCE INTERVENTION Female condom Low 1 00 Per condom Schwartlander Med 2 00 distributed Stover et al 2001 under public and Futures Group commercial sector Constella Stover et Asia region al 2004 Female condom Low 1 00 Per condom Kumaranayake and Med 2 00 distributed as Watts 2000 High 3 00 part of sex work intervention Financial costing incremental Male condom Low 0 10 Per condom Kumaranayake and Med 0 14 economic cost full Watts 2000 High 0 17 cost sub Saharan Africa Male condom Low 0 10 Per condom Asia Schwartlander Med 0 14 region Stover et al 2001 Futures Group Constella Stover et al 2004 Cost per person Low 0 26 sub Saharan Kumaranayake and in employment Med 0 50 Africa data from Watts 2000 reached peer High 0 75 intervention in education Uganda Economic cost full cost med and high extrapolated Cost per STI treated Low 8 34 Asia region Schwartlander in workplace Med 27 85 Stover et al 2001 Futures Group Constella Stover et al 2004 Male condom Low 0 10 Per condom Asia Schwartlander Med 0 14 region Stover et al 2001 Futures Group Constella Stover et al 2004 Male condom Low 0 10 Per condom Schwartlander Med 0 34 distributed Stover et a
43. ted Also check the Cost Summary worksheet the Black tab to see if the figures from the ARV treatment section are properly reflected USER MANUAL 3 4 Cost Summary Select the Cost Summary worksheet Black tab at the bottom of the screen Check to see all the figures are reflected and graphed e See the graphs as to the proportion of the cost for each intervention area in light of the total cost Seethe per capita cost and capital cost across the years 3 5 Finish Go back to all the sections that you have entered data Clear all the cells by pressing the RESET button MDG Consistent HIV AIDS Costing Model for Asia and the Pacific Annex 1 List of interventions included in the MDG HIV AIDS Costing Model INTERVENTIONS TARGETS INDICATORS ENABLING ENVIRONMENT Review develop amend intellectual property laws to allow the application of TRIPS safeguards and flexibilities Review develop amend legislations that protect women s rights to property and inheritance Review develop amend legislations that discriminate against vulnerable populations including women sex workers and MSM Review develop amend legislations that enable harm reduction activities for IDUs including needle exchange and drug substitutions Provide affordable legal support for PLHIV and vulnerable groups Conduct research to collect epidemiological data related to HIV and provide evidence for optimal decision making and resource priorit
44. tions syringe and needle exchange and drug substitution and counseling and testing 6096 of IDU use condoms Provide VCT services 96 of VCT needs fulfilled Ensure blood safety 96 of transfusion blood screened for HIV Strengthen STI treatment At least 7596 of people with STIs are appropriately diagnosed counseled and treated by 2015 Decline of STI compared to the 2005 figure TREATMENT Provide antiretroviral therapy ART Equitable and sustainable access to ART for at least 8096 of those in need both children and adult Ensure treatment monitoring systems are in place 96 of those on ART receiving tests for CD4 count viral load and full blood count Treat Ols and other HIV related illnesses 96 of positive people with Ol are treated Provide nutritional information and support to people living with HIV Percentage of positive people given nutritional information and support 96 target to be set by each country Provide home based care 96 of PLHIV who desire home based care have access to it Provide palliative care 96 of PLHIV in need of palliative care have access to it Provide support to orphans and vulnerable children OVC 96 of OVC receiving a basic external support package e g school fees shelter and food Provide economic support to households headed by women living with HIV including 96 of households headed by women living with HIV receiving economic support cash transfer vocational training micro credit schemes Prov
45. to Cell 58 or by pressing 1 at the upper left Let us assume your government has decided the following as in Table 3 b Enter the figures based on the table 3 b below Note there are 2 types of unit costs Recurrent and Capital which has a separate section each e For the unit cost for Strengthen and maintain a surveillance system enter USD 10 000 in Cell D611 USD2 000 in Cell E611 and USD 20 000 in Cell D638 You should have the following cost figures for this intervention 152 000 2009 24 000 2010 14 000 2011 6 4000 2012 14 000 2013 amp 14 and 6000 2014 amp 15 Close all the sections by pressing the 1 button at the upper left corner Scroll down to the Cost Summary section to see if the cost of the newly entered intervention is reflected in the table as well as in the graphs USER MANUAL Table 3 b UNIT COST RECURRENT UNIT COST CAPITAL Conducted once in 2009 Conducted once in 2009 USD 50000 2009 only Cell D635 Conducted once in 2009 amp 10 Conducted twice a year from 2009 to 2015 Conducted once in 2009 and 2012 USD 20000 2009 only Cell D 638 Conducted every year from 2009 to 2015 Also press the COST SUMMARY worksheet to see how figures are listed in the table Go back to the ENABLING ENVIRONMENT worksheet Go to the list of interventions and deselect 12 pressing the box in Cell A13 Scroll down to the table and graph at the bottom as well as to the
46. train unit costs of HIV test salary per counsellor per year and training costs per counsellor per year USER MANUAL Average number of campaigns per year and cost per campaign Number of blood units required per 1 000 people cost of screening a blood unit for HIV PEP kits required per million population and cost per PEP kit Average number of immunisations per child 0 23 months per year number of adult injections per person per year 15 49 years percent of injections that are unsafe and additional cost for AD syringes Population details include primary and secondary school enrolments male and female pupil teach ratios frequency of teacher retraining unit costs of primary secondary teacher training on HIV and cost of training peer educator for out of school youth STI incidence per 1 000 by type and unit cost of treatment Number of pregnant women with HIV and unit cost of PMTCT TREATMENT Number of adults and children in need of antiretroviral therapy unit costs of antiretroviral therapy Number of people in need to lab test number of tests per year additional number of testing equipment and their unit costs cost per test by test type CARE AND SUPPORT Type and incidence of opportunistic infection among people living with HIV and AIDS per 1 000 unit cost of treatment for Ol by type Percentage of people living with HIV and AIDS needing nutritional support by type number of nutritional items per person cost
47. ystems in total cost calculations At default these boxes are NOT checked Health Systems Ensure that these boxes are checked before entering data b Specify e the number of health facilities e unit costs for construction equipment operations and maintenance and rehabilitation of facili ties e the number of health staff e Staffing costs and e attribution of these costs to HIV AIDS as shown in an example below Health Posts Health Centers District Hospitals Provincial Hospitals Central Hospitals VCT Centers District Health Management Office Users specify the percentage of operations and maintenance costs attributable to HIV AIDS USER MANUAL 6 2 Condom provisions in the Prevention Worksheet Caution needs to be exercised when estimating the total cost of condoms distributed As condom provi sion is found in multiple interventions there is a risk of double counting and overestimation To minimise this overestimation risk the model automatically adjusts the total costs of condom provision The model subtracts the sum of costs of condom provision male condom only in all relevant prevention interventions other than that of 10 Condom Provision from the total cost of prevention interventions In this way the total cost for Prevention can exclude double counting of condom provision costs This ad justment is performed at the Cost Summary section in the Prevention Worksheet r
Download Pdf Manuals
Related Search