Small and/or Sick Newborn Care Costing Tool Tool Version: Version 2.2 Date of release: October 2024 Commissioned by the Global Financing Facility to support country planning & budgeting for the scale-up of Level-2 in Disclaimers This is an open-source tool. Any changes in the structure or formulas may result in errors. The GFF is not responsible for the use of the tool or the results produced. These are entirely the res Contact for questions & feedback: Alison Morgan (GFF) amorgan3@wo General Information and tips The primary objective of the tool is to support planning & budgeting for scaling-up good quality of care at Level II district f The tool covers all the components of the model of care proposed by the WHO-UNICEF Expert and Country Consultation an much it costs to implement country standards for each component. Similar to a planning guide, the tool has been organised step-by-step. Users should go through worksheets and their steps seq A user manual with troubleshooting tips as well as additional information to support the use of the tool are available from th The tool operates step-by-step, so users should start with the first tab and go through each step, before moving to the follow It is optimized for Excel 365. Using older versions may result in reduced functionality or errors Before using the tool as a Microsoft Excel file make sure that all Macros are enabled. To enable macros, go to the Excel menu and select the following: File -- Options -- Trust Center -- Trust center settings -- Macro Settings -- Enable all macros. Or select “Enable content� at the prompt when first opening the file. Some office versions block by default all macros from files downloaded from the web If this happens, close the file and before opening the file select: Properties -- General -- Unblock Due to compatibility issues, please do not use Google Drive to store or share this Excel file. Doing so may corrupt the file or disable essential VBA functions, causing errors in calculations and overall functionality WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Pleas Many cells are formatted with special styles and this will occasionally cause Excel to display a "Slow Workbook" message, wh Cells with formulae and worksheets have been protected. However users are able to transfer data to other workbooks for fu This workbook contains many named cells. When transferring data with the copy/paste commands, use "Paste special: Value Graphs can be edited and copy/paste to other workbooks TOOL STRUCTURE & NAVIGATION MENU General Inputs for Planning & Budgeting In this module the user: * enters general information on the scale-up; * selects typologies for costings; * enters basic unit costs for infrastructure, equipment, human resources & referrals Planning & Budgeting These modules are the core of the tool and provide step-by-step guidance to: * set country standards applicable to the scale-up components; * review the standards and associated costs by typology; * identify & cost supporting system strategies. Financing These modules provide financing analytics to support strategic decision-making: * Using facility typologies to explore cost analytics * Scale-up scenario & funding implications are Costing Tool for the scale-up of Level-2 inpatient care for small and sick newborns ay result in errors. d. These are entirely the responsibility of the user. n (GFF) amorgan3@worldbank.org and tips of care at Level II district facilities for small and sick newborns. nd Country Consultation and helps users to unpack ‘what it takes’ and how orksheets and their steps sequentially. e tool are available from the GFF before moving to the following tab. d overall functionality and remove validation. Please enter data manually w Workbook" message, which should be ignored. a to other workbooks for further analysis. ds, use "Paste special: Values and numbers format" ATION MENU General Inputs General Inputs THE 10 COMPONENTS OF SCALING-UP THE MODEL OF CARE FOR SMALL AND/OR SICK NEWBORNS Infrastructure Equipment & Commodities (1) - Standards Equipment & Commodities (2) - Other Human_Resources Functional Referral Other Components (Facility-Level) Data Systems Linkage Maternal & Newborn Care Family & Community Support Post-discharge Follow-up National & Regional Level Leadership, Political Vision & Other Financing (1) - Facility Typology Analytics Financing (2) - Scale Up Scenario GENERAL INPUTS WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validati menu where available to ensure proper functionality MODULE OVERVIEW * Enter general information on the costing exercise * Select facility typologies for costing * Enter basic information on system parameters * Enter data on unit costs for infrastructure, equipment, HR & referrals Light blue cells are user inputs. STEP 1 - PROVIDE GENERAL INFORMATION ON THE COSTING EXERCISE 1.1 - Name of the Costing Scenario Name: 1.2 - Select currency used for cost inputs & document exchange rate used for any conversions. Remember that all costs should be measured using the same currency. Currency to be used for all cost inputs: Exchange Rate of local currency for conversions of final estimates: 1 USD = 1.3- Select base year for costings and financing Remember all costs should be measured for the same base year If different types of costs are collected for different years, the costing results will be incorrect All the tool costings and financing inputs are for base year: STEP 2 - SELECT FACILITY TYPOLOGIES FOR COSTING Select facility typologies for costing. Need to select at least one option for each typology Please make sure you select from the drop down menu ("Yes", "No"). Do not copy/paste, cut/paste into these cells SIZE To be included ? Small Yes Medium Yes Large Yes COST/LOCATION Mid Cost Yes High Cost Yes Very High Cost Yes CONSTRUCTION TYPE New Construction Yes Rehabilitation Yes EQUIPMENT NEEDS Major Yes Partial Yes Limited Yes RECRUITMENT CHALLENGES Standard Yes Hard-to-Recruit Yes Most Challenging Yes STEP 3 -ENTER BASIC INFRASTRUCTURE STANDARDS & UNIT COSTS FOR CONSTRUCTION 3.1 Infrastructure Standards - Enter type of inpatient beds for the Small and Sick Newborn Care Unit Enter only inpatient beds. Beds for family members not staying with the newborn should not be included here. User Notes Type of Inpatient Beds 3.2. Infrastructure Standards - Enter the other facility areas, such as outpatient care, ancillary and support services Remember to account for space requirements of all components of the model of care, including post-discharge follow-up and fami This also includes office space requirements for management, data systemts & liaision with with other facilities regarding linkages Any areas for accommodation of family members not staying with the newborn should be included here. User Notes Type of Facility Service Areas 3.3. Enter average construction costs per Sq mt for a Small and Sick Newborn Care Unit as per standards If no data on rehabilitation costs, note that based on the GFF case study rehabilitation costs are approximately 50% to 60% of new constructio Average Cost per Square Meter of Construction (by Typology) Type of Construction Costing Typology New Construction Mid Cost High Cost Very High Cost 3.4. Enter estimated annual cost of building maintenance (as % of the cost of building a new unit) If country data are not available, a standard rule of thumb such as 1% can be used. As % of new Building Maintenance building value Annual building maintenance costs STEP 4. ENTER LIST OF ESSENTIAL EQUIPMENT (as per standards) & UNIT COSTS 4.1. Enter list of essential equipment and unit price (inclusive of warranty) for each device Equipment list to be sourced from country standards & guidelines. The list should include all essential devicesto deliver quality of care inc. those required for mothers and referral transport If standards are not available, as a starting point for discussions, the list can be sourced from international guidelines or relevant G Do not enter office furniture or equipment here Unit price inc. LIST OF ESSENTIAL EQUIPMENT warranty 4.2. Provide a brief description of warranty, including number of years Brief Warranty Description: STEP 5. ENTER HUMAN RESOURCES -CLINICAL & SUPPORT- (As per standards) AND UNIT COSTS 5.1 Enter categories of facility staff and annual cost per FTE for facility typologies included Categories should include clinical & support staff needed. To be sourced from country standards & guidelines. Make sure the list includes human resources required for all components, such as drivers for ambulance referrals, data officers for If not available, the list can be sourced from international guidelines or relevant GFF reports, as a starting point for discussions in c Column headings will be blank if a typology was not included List of Human Resources Required & Annual Costs per FTE STAFF RECRUITMENT FACILITY TYPOLOGIES Standard area Annual costs inc. Staff Category (Clinical & Support) salaries, allowances, etc. 5.2 Enter average costs of supervision/mentoring visits from regions to facilities delivering small and sick newborn care, includin Supervision/Mentoring/Coaching Visits - Unit Costs $ Average cost per supervision, mentoring and coaching visits: STEP 6. ENTER & VALIDATE COST LOADINGS OR MARK-UPS TO CAPTURE VARIATIONS ACROSS LOCATION/COST TYPOLOGIES 6.1. Enter % of cost loadings/mark-ups to be applied to supervision/mentoring visits and other strategies at facility level. Enter 0 If for example, costs entered in step 5.2. reflect a mid-cost location and are likely to be 10% higher in high cost locations and 20% h locations: Enter 0 for mid cost, 10% for high cost and 20% for very high cost Only cost/location typologies included in the exercise are shown here. Cost loadings/mark-ups by typology % Mid Cost High Cost Very High Cost 6.2. Review costs of supervision/mentoring visits after applying cost loadings This table shows unit costs in step 5.2. by facility/cost location typology, after applying cost loadings/mark-ups in Step 6.1. Here you have the opportunity to review how cost loadings are applied to ensure that percentages entered in Step 6.1. are accurat If you think there is a mistake in these calculations, go back to Step 6.1. and change the cost loadings entered. Remember that these loadings are used to estimate costs under each planning & budgeting module. Unit costs of Supervision visits after applying cost $ loadings Mid Cost $0 High Cost $0 Very High Cost $0 STEP 7. ENTER COSTS OF REFERAL VEHICLE/AMBULANCE 7.1. Enter ambulance vehicle acquisition costs, including any GPS requirements Do not include newborn transport equipment costs, only the costs of the vehicle & the GPS Unit COST Ambulance vehicle cost inclusive of GPS: 7.2. Enter fuel and maintenance costs per kilometer for ambulance vehicles Remember that ambulance annual costs by facility typologies are estimated using these inputs. Under the Referrals Plan & Budget tab, adjustments by cost loadings and other factors are made and you can review/modify facilit Note: For a traditional ambulance vehicle, a litre of fuel might last between 12-15 kmts. In the absence of data, maintenance costs Average cost of vehicle fuel & maintenance Cost per kilometer Fuel Maintenance ook. Doing so may insert conflicting code and remove validation. Please enter data manually & choose from dropdown nge rate used for any conversions. User Notes e costing results will be incorrect User Notes one option for each typology ", "No"). Do not copy/paste, cut/paste into these cells User Notes T COSTS FOR CONSTRUCTION or the Small and Sick Newborn Care Unit ng with the newborn should not be included here. User Notes such as outpatient care, ancillary and support services ents of the model of care, including post-discharge follow-up and family and community involvement and support , data systemts & liaision with with other facilities regarding linkages and referrals with the newborn should be included here. User Notes and Sick Newborn Care Unit as per standards study rehabilitation costs are approximately 50% to 60% of new construction costs er of Construction (by Typology) Type of Construction User Notes Rehabilitation s % of the cost of building a new unit) ch as 1% can be used. User Notes dards) & UNIT COSTS e of warranty) for each device f care inc. those required for mothers and referral transport ns, the list can be sourced from international guidelines or relevant GFF reports User Notes List of Human Resources Required & Annual Costs per FTE STAFF RECRUITMENT FACILITY TYPOLOGIES Hard-to-Recruit Most Challenging Annual costs inc. salaries, User Notes Annual costs inc. salaries, allowances, allowances, & recruitment recruitment area incentives area incentives m regions to facilities delivering small and sick newborn care, including allowances, perdiems, transport User Notes TO CAPTURE VARIATIONS ACROSS LOCATION/COST TYPOLOGIES ervision/mentoring visits and other strategies at facility level. Enter 0 or leave blank if none cation and are likely to be 10% higher in high cost locations and 20% higher in very high cost very high cost User Notes on typology, after applying cost loadings/mark-ups in Step 6.1. re applied to ensure that percentages entered in Step 6.1. are accurate o Step 6.1. and change the cost loadings entered. der each planning & budgeting module. y GPS requirements costs of the vehicle & the GPS User Notes are estimated using these inputs. oadings and other factors are made and you can review/modify facility estimates as required t last between 12-15 kmts. In the absence of data, maintenance costs can be set as a percentage of fuel cost (i.e. 40 or 50%) User Notes y & choose from dropdown User Notes INFRASTRUCTURE - PLANNING & BUDGETING WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validati functionality MODULE OVERVIEW Enter country infrastructure standards, including: *The required parameters to estimate the number of beds needed to adequately meet the demand for services at each facility si * Minimum floor space per bed * Minimum floor space per facility area & facility circulation areas If detailed country standards are not available, to initiate discussions in country, they can be sourced from international guidelines Review required floor space & associated costings for each type of facility, including building maintenance. Remember: Light blue cells are user inputs. Yellow cells are tool calculations not to be manually changed STEP 1 - ESTIMATE & VALIDATE THE NUMBER OF BEDS REQUIRED TO MEET THE DEMAND FOR SERVICES The tool calculates the expected number of facility admissions by typology based on: number of live births in catchment area and % The number of beds is estimated based on expected admissions, ALoS and target occupancy bed rate 1.1. Enter the expected average number of live births in the catchment area for what would be a typical small, medium and larg Leave cells blank if facility typology is not being costed Facility Size Typology Small Average number of live births in catchment area 1.2. Enter formula parameters to estimate number of required beds based on population need: Based on WHO and UNICEF guidelines & the GFF case study, approx. 13.46% of live births require special care & 6.4 days of ALoS QoC strategies, inc. protocols and criteria for admission & discharge should be in place to ensure bed strength is adequate ~ 80% to 85% occupancy bed rates might be advisable Leave target occupancy bed rate blank if 100% % of live births requiring special care Target average length of stay (days) Target occupancy bed rate 1.3. Review expected number of admissions and newborn beds required by typology, These figures are estimated based on expected live births entered in Step 1.1. and other parameters entered in Step 1.2 Service Delivery Parameters Small Expected annual number of admissions (#) - Number of beds required (#) - STEP 2 - IDENTIFY NUMBERS FOR EACH TYPE OF INPATIENT BED Enter here the number of beds for each type of inpatient bed listed under general inputs. Total Number of Beds should equal number of beds required in Step 1.3 above. Otherwise a warning sign would appear. If there are errors, infrastructure totals will be 0 & equipment costs might also be affected. Number of beds Inpatient Areas (Type of Beds) Small 0 0 0 0 Total Number of Beds to Check 0 STEP 3 - SET FLOOR SPACE STANDARDS 3.1 - Set minimum floor space (square meters) per each type of inpatient bed Floor space standards for inpatient beds should take into consideration zero-separation policies Sq. Mt. per Type of Bed Inpatient Areas (Type of Beds) Sq. Mt per Bed 0 0 0 0 3.2. Review minimum floor space for inpatient care areas by facility size typology If Total inpatient care area = 0 the typology has not been costed or there is a mistake in the number of beds entered in Step 2. Total inpatient care area (Sq. Mt.) by Facility Size Small Type of inpatient care area Sq. Mts per facility 0 0 0 0 0 0 0 0 Total inpatient care area (Sq. Mt.) 0 3.3. Set minimum floor space (square meters) for outpatient care, ancillary and support services as applicable Remember that minimum space standards for the relevant facility areas should take into account any requirements of the 10 comp Floor standards for other areas by facility size Facility Service Area Small Sq. Mts per facility 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 3.4. Set floor space standards for circulation areas (i.e. corridors, entrance) Minimum floor space for circulation as % of the total area STEP 4 - REVIEW & VALIDATE TOTAL FACILITY FLOOR SPACE REQUIREMENTS & INFRASTRUCTURE COSTINGS 4.1. Review total floor space required to deliver good quality of care by facility size typology Total floor space = 0 if typology not costed or errors in number of beds Square Meters of Floor Space by Facility Size Service Areas - Floor Space Small Inpatient care areas (Sq. Mts.) 0 Other facility areas (Sq. Mts.) 0 Circulation space (Sq. Mts.) 0 Total floor space (Sq. Mts.) 0 4.2. Review infrastructure costs for facilities requiring new construction by size and location/cost typologies Estimates are based on facility floor space and construction costs per square meter. NEW CONSTRUCTION - Total Costs Facility Costs by Typology Small Mid Cost $0 High Cost $0 Very High Cost $0 4.3. Review infrastructure costs for facilities requiring rehabilitation by size and location/cost typologies Estimates are based on facility floor space and construction costs per square meter. REHABILITATION - Total Costs Facility Costs by Typology Small Mid Cost $0 High Cost $0 Very High Cost $0 STEP 5 - REVIEW ANNUAL COST OF BUILDING MAINTENANCE BASED ON INPUTS AND NEW BUILDING VALUES These costs are estimated as a percentage of new building values Costs will be 0 if the new construction typology has not been included in costings or if no % of building maintenance was entered in Annual building maintenance costs by typology Small Mid Cost $0 High Cost $0 Very High Cost $0 k. Doing so may insert conflicting code and remove validation. Please enter data manually to ensure proper ded to adequately meet the demand for services at each facility size ons in country, they can be sourced from international guidelines or relevant GFF reports e of facility, including building maintenance. ED TO MEET THE DEMAND FOR SERVICES y typology based on: number of live births in catchment area and % of live births requiring special care. ALoS and target occupancy bed rate chment area for what would be a typical small, medium and large facility Facility Size Typology User Notes Medium Large beds based on population need: rox. 13.46% of live births require special care & 6.4 days of ALoS rge should be in place to ensure bed strength is adequate User Notes required by typology, d in Step 1.1. and other parameters entered in Step 1.2 Medium Large - - - - ed under general inputs. tep 1.3 above. Otherwise a warning sign would appear. sts might also be affected. Number of beds User Notes Medium Large 0 0 ration zero-separation policies User Notes or there is a mistake in the number of beds entered in Step 2. rea (Sq. Mt.) by Facility Size Medium Large Sq. Mts per facility Sq. Mts per facility 0 0 0 0 0 0 0 0 0 0 re, ancillary and support services as applicable y areas should take into account any requirements of the 10 components of the small and sick newborn care model other areas by facility size Medium Large User Notes Sq. Mts per facility Sq. Mts per facility 0 0 User Notes QUIREMENTS & INFRASTRUCTURE COSTINGS care by facility size typology loor Space by Facility Size Medium Large 0 0 0 0 0 0 0 0 truction by size and location/cost typologies per square meter. NEW CONSTRUCTION - Total Costs Medium Large $0 $0 $0 $0 $0 $0 ation by size and location/cost typologies per square meter. REHABILITATION - Total Costs Medium Large $0 $0 $0 $0 $0 $0 ASED ON INPUTS AND NEW BUILDING VALUES uded in costings or if no % of building maintenance was entered in inputs Medium Large $0 $0 $0 $0 $0 $0 TIP: Remember if copy/paste data into other Workbook, always use Paste Special: Values & Number Formatting EQUIPMENT & COMMODITIES (1) -PLANNING & BUDGETING WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove va MODULE OVERVIEW Enter the number of essential facility equipment required at each facility size typology, following the instructions below Some column headings will be blank if not all facility typologies have been included or if the user has specified fewer than five type Note that panes have been frozen to facilitate data-entry Light blue cells are user inputs. Yellow cells are tool calculations not to be manually changed If required, cells in dark blue can be used for overriding modelled estimates STEP 1 - SET THE NUMBER OF ESSENTIAL DEVICES & VALIDATE ESTIMATES TO BE USED IN COST CALCULATIONS First enter the number of essential devices required per type of inpatient bed. Decimals are allowed. So if one piece of equipment Second, enter total number of devices required for providing safe transport to newborns as part of the referral system Third, enter any additional essential devices required at a facility. This is done by each facility size included and should take into co Fourth, review total facility requirements calculated for each typology (number of devices required per type of bed x numbers of e Fifth, if required override modelled estimates in dark-blue cells. Sixth, review final estimates to be used in cost calculations. These numbers will be the same as those calculated by the tool, unless First, enter required items per type of inpatient bed 0 0 Equipment Name 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 so may insert conflicting code and remove validation. Please enter data manually to ensure proper functionality. If pasting is absolute typology, following the instructions below ded or if the user has specified fewer than five types of inpatient beds. Do not enter data in those columns. BE USED IN COST CALCULATIONS Decimals are allowed. So if one piece of equipment is required per three beds, enter 0.33 newborns as part of the referral system y each facility size included and should take into consideration equipment requirements for facility areas such as triage. of devices required per type of bed x numbers of each type of bed, plus additional devices required at each facility). Note that the tool rounds up estim be the same as those calculated by the tool, unless you have used the dark blue cells to override them. Second, enter requirements Third, enter additional required items @ Fourth, review estimated facility nter required items per type of inpatient bed for referrals facility requirements Newborn Additional Additional Additional 0 0 Transport items items items Small Equipment @Small @Medium @Large 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 proper functionality. If pasting is absolutely necessary use "Paste Values" only. each facility). Note that the tool rounds up estimates. Fourth, review estimated facility Fifth, enter user-defined numbers here. Note they requirements override modelled estimates User Notes Medium Large Small Medium Large 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Sixth, review essential equipment numbers to be used in final calculations User Notes Small Medium Large 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 EQUIPMENT & COMMODITIES (2)- PLANNING & BUDGETING WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove vali MODULE OVERVIEW Review facility equipment cost calculations for each facility size typology, including: * Total facility equipment cost & devices accounting for the largest cost share This review step will help users understand what drives facility equipment costs Consider, estimate and review other equipment related costs *Equipment acquisition DOES NOT account for the vast majority of all equipment related costs. * Equipment related costs to be considered and included in these calculations are: ** Transport and distribution to facilities as well as installation ** Annual costs of consumables, medical supplies and renewables ** One-Off buffer stocks required as part of maintenance strategies ** Annual cost of spare parts required as part of maintenance strategies ** Other preventive and corrective maintenance strategies Consider, estimate and review costs of fully furnishing a facility and providing adequate office & communications equipme Estimate needs of new equipment and furniture by equipment typology Estimate annual costs of medicines and supplies not included elsewhere Light blue cells are user inputs. Yellow cells are tool calculations not to be manually changed If required, cells in dark blue can be used for overriding modelled estimates STEP 1. REVIEW TOTAL FACILITY EQUIPMENT COSTS AND IDENTIFY THE TYPE OF EQUIPMENT ACCOUNTING FOR THE LARG To examine key costing drivers information on the required number of items and unit prices is also included in this table. Dev Note that calculations will be 0 if that facility typology was not costed or the equipment was not included. Equipment Name 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Facility Equipment Costs STEP 2 - ESTIMATE & VALIDATE COSTS OF EQUIPMENT TRANSPORT, DISTRIBUTION AND INSTALLATION If equipment prices DO NOT include transport, distribution and installation costs, estimate those costs for each facility typo Transport, distribution and installation costs can be significant, so if they are not included in equipment acquisition value, the Note: Leave cells blank if transport, distribution and installation cost sare included in equipment acquisition value 2.1. Estimate costs as a percentage of equipment acquisition value for each typology and revise/modify estimates if requir Enter % of equipment value or user-defined costs. Note that user-defined costs will override any modelled estimates In Zambia, 20%, 30% & 40% estimates were used based on Unicef experience in country Equipment Transport, Distribution and Installation Costs as a % of Equipment Acquisition Value, by Location Typology Mid Cost High Cost Very High Cost 2.2. Review costs that will be used for final results Final transport, distribution & installation costs by typology Mid Cost High Cost Very High Cost STEP 3. ESTIMATE & VALIDATE ANNUAL COSTS OF EQUIPMENT CONSUMABLES AND RENEWABLES 3.1. Estimate costs as a percentage of equipment acquisition value for each typology and revise/modify estimates if requir Enter % of equipment value or user-defined costs. Note that user-defined costs will override any modelled estimates Note UNICEF experience in India & Zambia suggests 30% to 40% might be reasonable estimates. A similar range was provided Annual Costs Consumables and Renewables as % of Equipment Value Mid Cost High Cost Very High Cost 3.2. Review costs that will be used for final results. Final annual costs of consumables and renewables by typology Mid Cost High Cost Very High Cost STEP 4. ESTIMATE & VALIDATE ANNUAL COSTS OF SPARE PARTS 4.1. Estimate costs as a percentage of equipment acquisition value for each typology and revise/modify estimates if requir Enter % of equipment value or user-defined costs. Note that user-defined costs will override any modelled estimates Leave cells blank if spare parts costed in Step 5 below (maintenance strategies) Annual Cost of Spare Parts as % of Equipment Value Mid Cost High Cost Very High Cost 4.2. Verify costs that will be used for final results. Final Annual Cost of Spare Parts by Typology Mid Cost High Cost Very High Cost STEP 5. ESTIMATE & VALIDATE ANNUAL COSTS OF MAINTENANCE STRATEGIES (PREVENTIVE & CORRECTIVE) Note that costs related to human resources, such as specialised staff (i.e. engineers) or mandatory training for health staff sh Remember to include spare parts if not costed separately 5.1. Estimate costs as a percentage of equipment acquisition value for each typology and revise/modify estimates if requir Enter % of equipment value or user-defined costs. Note that user-defined costs will override any modelled estimates Note that these costs are likely to vary across countries. For example, in Zambia, UNICEF experts suggested 10 to 15% might b Maintenance strategies as % of equipment acquisition value Mid Cost High Cost Very High Cost 5.2. Review costs that will be used for final results. Final Annual Costs of Preventive and Corrective Maintenance Strategies Mid Cost High Cost Very High Cost STEP 6. REVIEW TOTAL ANNUAL COSTS OF SPARE PARTS + MAINTENANCE STRATEGIES Review that estimated annual maintenance costs, including spare parts, are adequate Review of Total Annual Maintenance Costs (Spare Parts + Preventive & Corrective) by Typology Mid Cost High Cost Very High Cost STEP 7. ESTIMATE & VALIDATE EQUIPMENT BUFFER STOCKS REQUIRED Note that although buffer stocks are most likely to be managed at regional levey, they are costed as a % of facility equipment 7.1. Estimate the expected one-off costs of buffer stocks (inclusive of transport/distribution) as a % of equipment replacem Enter the expected cost (as a percentage of equipment value) of any buffer stocks required. The tool calculations assume this is a percentage of new equipment value (excluding distribution costs) In some instances, UNICEF recommends 10% of buffer stocks to be managed at regional level. Once-Off Equipment Buffer Stock Costs as % of equipment value Mid Cost High Cost Very High Cost 7.2. Review Once-Off Equipment Buffer Stock Costs by Facility Typology Once-Off Equipment Buffer Stock Costs Mid Cost High Cost Very High Cost STEP 8. ESTIMATE & VALIDATE COSTS OF ADDITIONAL FACILITY FURNITURE & EQUIPMENT, INCLUDING OFFICE EQUIPMEN 8.1. Enter acquisition costs of office & communitations equipment required for other model of care components such as da Include items such as laptops,printers, mobile/landline phones required to support referrals, data systems and general admin Enter total amount, not percentages. In User Notes enter what is included (i.e. number of items) and their main purpose (i.e. Major equipment, inc. Office & Communications equipment for other components of care (inc. referral & data systems) and unit management Acquisition Costs of Office & Communications Equipment 8.2. Enter acquisition costs of other facility and office furniture & equipment not included elsewhere. Facility level costs should be entered here to ensure these expenses are properly accounted for. Can include costs for furniture items, such as staff office chairs and desks, wardrobes and mothers' beds, as well as TVs or oth Remember to include here any personal protective equipment for infection prevention and control if it has not been account Enter total amount, not percentages. Additional facility furniture and equipment Acquisition Costs of Furniture & Other Equipment 8.3. Enter distribution costs for location typologies as a percentage of furniture & other equipment acquisition value. Leave Note: These costs are expected to be lower than for medical equipment due to issues such as installation. Distribution costs by location typology Mid Cost High Cost Very High Cost 8.4. Review Costs of Furniture, Office Equipment & Other (Acquisition value + distribution) by typology and revise/modify Costs of Furniture, Office Equipment & Other (including distribution) by Typology Mid Cost High Cost Very High Cost 8.5. Review costs that will be used for final results. Final Costs of Furniture, Office Equipment & Other Mid Cost High Cost Very High Cost STEP 9. ESTIMATE DIFFERENTIAL NEEDS OF EQUIPMENT AND FURNITURE BY TYPOLOGY Enter % of equipment and furniture investments needed by typology Adjusts investments needed at each typology, based on current availability The higher the percentage, the higher the investment need To estimate the cost of fully equipping and furnishing a facility enter 100% under major need Facilities in need of essential equipment: Major need Partial need Limited need STEP 10. ESTIMATE COSTS OF MEDICINES & SUPPLIES NOT COSTED AS PART OF EQUIPMENT CONSUMABLES 10.1. Enter estimated costs of medicines & supplies per newborn admission Note that equipment consumables including reagents that have been costed above should not be included here Annual costs of medicines & supplies per newborn admission ($): 10.2. Review costs of medicines & supplies by typology after applying cost loadings from inputs and enter revised estimate Costs are estimated based on the number of admissions at each facility and adjusted by cost loadings/mark-ups for facility loc If required, use the dark-blue cells to override modelled estimates. Annual costs of medicines & supplies by Facility Typology Mid Cost High Cost Very High Cost 10.3. Review costs that will be used for final results. Check annual facility costs of medicines & supplies to be used Mid Cost High Cost Very High Cost code and remove validation. Please enter data manually to ensure proper functionality mmunications equipment, including equipment required to support other components such as referrals & data systems UNTING FOR THE LARGEST SHARE OF COSTS luded in this table. Devices accounting for the largest share of costs are highlighted. Facility Equipment Costs ($) Facility Equipment Costs as % of total Small Medium Large Small Medium Large $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0.0% 0.0% 0.0% $0 $0 $0 0% 0% 0% sts for each facility typology. nt acquisition value, they can be calculated here dify estimates if required elled estimates Enter user-defined costs here. Note they Estimated model costs override modelled estimates % of equipment value Small Medium Large Small Medium $0 $0 $0 $0 $0 $0 $0 $0 $0 Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 dify estimates if required elled estimates ilar range was provided by government officials in Ghana. Enter user-defined costs here. Note they Estimated model costs override modelled estimates % of Equipment Value Small Medium Large Small Medium $0 $0 $0 $0 $0 $0 $0 $0 $0 Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 dify estimates if required elled estimates Enter user-defined costs here. Note they Estimated model costs override modelled estimates % Small Medium Large Small Medium $0 $0 $0 $0 $0 $0 $0 $0 $0 Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 ning for health staff should be costed under human resources dify estimates if required elled estimates ested 10 to 15% might be reasonable for annual expenditure on maintenance. In Ghana government officials estimated annual maintenan Enter user-defined costs here. Note they Estimated model costs override modelled estimates % Small Medium Large Small Medium $0 $0 $0 $0 $0 $0 $0 $0 $0 Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 by Typology Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 % of facility equipment acquisition value of equipment replacement value. Leave blank if none. % User Notes Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 NG OFFICE EQUIPMENT components such as data systems & referrals and general management of the unit ems and general administration of the small and sick newborn care unit. Also include here other devices you want individually itemized (e heir main purpose (i.e. to support referrals) Small Medium Large User Notes ($) ($) ($) $0 $0 $0 ds, as well as TVs or other equipment such as medicine trolleys not costed elsewhere. t has not been accounted for earlier. Small Medium Large User Notes ($) ($) ($) acquisition value. Leave blank if distribution costs included in acquisition costs % of furniture & equipment value User Notes ogy and revise/modify estimates if required Enter user-defined costs here. Note they override modelled estimates Small Medium Large Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 As % of acquisition value User Notes User Notes enter revised estimates if required mark-ups for facility location/cost typologies Estimated model costs Enter user-defined costs here. Note they Small Medium Large Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 data systems Facility Equipment Numbers (as calculated in Unit price ($) worksheet "3.Equipment_Numbers") from 1.General Small Medium Large Inputs 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 ed costs here. Note they odelled estimates User Notes Large ed costs here. Note they odelled estimates User Notes Large ed costs here. Note they odelled estimates User Notes Large estimated annual maintenance costs to range from 8% to 12% ed costs here. Note they odelled estimates User Notes Large User Notes r Notes User Notes HUMAN RESOURCES - PLANNING & BUDGETING WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validati MODULE OVERVIEW Set country standards for Human Resources at each facility size typology & estimate associated costs * Enter numbers of FTE facility staff required, as per country standards * Review annual cosst of staff salaries by typology Set country standards for Human Resource Development Strategies & estimate facility costs * Supervision/Mentoring/Coaching Visits * Mandatory in-service training for all staff (clinical and ancillary) Note that higher education courses to upskill workforce are costed at national level in the QoC National and Regional Strategies * Other Human Resource Development Strategies Identify and cost recruitment and retention strategies for hard-to-recruit and most challenging recruitment areas * Identify strategies and estimate capital costs, such as those related to housing infrastructure or purchasing of motorbikes or othe * Identify strategies and estimate recurrent annual costs, such as those related to additional opportunities for professional collabo Note that strategies applicable to all areas, inlcuding standard, should be identified and costed in the previous steps or as part of Q Remember: Light blue cells are user inputs. Yellow cells are tool calculations not to be manually changed If required, cells in dark blue can be used for overriding modelled estimates STEP 1 - ENTER & VALIDATE REQUIRED NUMBERS OF CLINICAL AND SUPPORT STAFF & REVIEW COSTS BY FACILITY TYPOLOGY 1.1. Enter required FTE staff numbers for each facility size typology Required FTE numbers should be sourced from country standards and guidelines. * Staff requirements should account for expected workload, including clinical & administrative tasks related to all components of c If country guidelines are not available, as a starting point for discussions in country, staff ratios can be sourced from international g If typology is not costed or staff not required, enter 0 or leave blank Required FTE per facility Staff Category (Clinical & Support) Small Medium 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.2 Review facility staff costs by staff category for standard recruiting areas STANDARD RECRUITING AREAS - ESSENTIAL STAFF Annual Cost ($) Small Medium Staff Category (Clinical & Support) 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 Annual Staff Costs $0 $0 1.3 Review facility staff costs by staff category for Hard-to-Recruit areas. HARD-TO-RECRUIT AREAS - ESSENTIAL STAFF Annual Cost ($) Small Medium Staff Category (Clinical & Support) 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 Annual Staff Costs $0 $0 1.4 Review facility staff costs by staff category for Most Challenging to Recruit areas. MOST CHALLENGING TO RECRUIT AREAS - ESSENTIAL STAFF Annual Cost ($) Small Medium Staff Category (Clinical & Support) 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 Annual Staff Costs $0 $0 1.5. Review total facility staff salaries by typology. Results will be 0 if typology not included Annual Cost of Facility Staff Salaries Small Medium Standard area $0 $0 Hard-to-Recruit $0 $0 Most Challenging $0 $0 STEP 2 - COST MENTORING/SUPERVISION/COACHING VISITS Estimate the costs of mentoring/supervision/coaching visits based on unit costs entered under General Inputs 2.1. Enter number of mentoring/supervision/coaching visits to each facility required in a year: Small Medium Number of annual mentoring/supervision visits by regional staff to each facility = 2.2. Review estimated annual costs of mentoring and supervision by facility size and cost/location typology after applying cost l Mentoring/Supervision/Coaching Small Medium Mid Cost $0 $0 High Cost $0 $0 Very High Cost $0 $0 STEP 3 - IDENTIFY & COST MANDATORY IN-SERVICE TRAININGS FOR ALL FACILITY STAFF 3.1. Enter service parameters for mandatory in-service training. Include trainings for all components of small and sick newborn c As appropriate in the local context, you can include here any trainings related to task-shifting i.e. to improve the capacity of nurses If trainings will take place at a facility only once a year enter 1, if every 2 years, enter 0.5 The final columns (yellow cells) show total in-service training by facilty size Second: enter number of staff trained @ each facility First: Enter Name of Mandatory in-service training package Small Medium 3.2. Review Total Annual In-Service Training Costs by Facility Size and Location Typology after applying cost loadings/mark-ups f Annual In-Service Training Costs Small Medium Mid Cost $0 $0 High Cost $0 $0 Very High Cost $0 $0 3.3. Review In-Service Training Costs to be used in the final calculations Small Medium Mid Cost $0 $0 High Cost $0 $0 Very High Cost $0 $0 STEP 4 - IDENTIFY AND COST OTHER HUMAN RESOURCE DEVELOPMENT STRATEGIES 4.1. Enter the name of other human resource development strategies and expected costs at facility level For example, you can include here costs related to performance-based rewards or peer mentoring programs Enter expected costs by facility size typology. Leave blank if not applicable or if that facility typology is not costed Costs by Facility size typology Name of Other Human Resource Strategy Small Medium Total Annual - Other Human Resource Strategies $0 $0 4.2. Review estimated total for other strategies by Facility Size and Location Typology after applying cost loadings/mark-ups fro Other Human Resource Strategies (Annual Costs) Small Medium Mid Cost $0 $0 High Cost $0 $0 Very High Cost $0 $0 4.3. Review Costs of Other Huma Resource Strategies to be used in the final calculations Small Medium Mid Cost $0 $0 High Cost $0 $0 Very High Cost $0 $0 STEP 5 - REVIEW TOTAL HUMAN RESOURCE DEVELOPMENT COSTS Review Total Human Resource Development Costs as estimated above. These are the sum of Supervision/Mentoring PLUS in-service training PLUS Other Human Resource Development Strategies Annual Human Resource Development Costs (Supervision + In-service Training + Other) Small Medium Mid Cost $0 $0 High Cost $0 $0 Very High Cost $0 $0 STEP 6 - IDENTIFY AND COST ADDITIONAL STRATEGIES TO RECRUIT AND RETAIN STAFF IN HARD-TO-RECRUIT AND MOST CHALLE In this step you can include the cost of additional strategies specifically targeting the recruitment and retention of human resource Make sure you do not include strategies already costed above, such as financial incentives included in salaries and allowances for s Some of these new strategies might involve capital investments, such as providing housing or vehicles (i.e. motobikes) for transpor Other strategies might involve recurrent costs, such as strategies for increased opportunities for training, mentoring or collaboratio Step 6.1. Identify recruitment and retainment strategies applicable and enter the amount of CAPITAL investments required. For example, if new houses needs to be built for nurses and doctors, enter total costs per facility size typology Leave blank if typology not included or if there are no additional strategies applicable Amount of CAPITAL costs re Hard-to-Recruit Name of Recruitment/Retetion strategy Small Medium Strategy 1 Strategy 2 Strategy 3 Strategy 4 Strategy 5 Total CAPITAL costs per facility $0 $0 Step 6.2. Identify recruitment and retainment strategies and enter the amount of RECURRENT costs required. Leave blank if typ For example, if additional staff mentoring or collaboration opportunities are required, enter total costs per facility size typology Note: Total will be 0 if facility typology not included Amount of RECURRENT co Hard-to-Recruit Name of Recruitment/Retetion strategy Small Medium Strategy 1 Strategy 2 Strategy 3 Strategy 4 Strategy 5 Total RECURRENT costs per facility $0 $0 y insert conflicting code and remove validation. Please enter data manually to ensure proper functionality evel in the QoC National and Regional Strategies Module ost challenging recruitment areas nfrastructure or purchasing of motorbikes or other transport vehicles additional opportunities for professional collaboration and development d and costed in the previous steps or as part of Quality of Care Facility strategies TAFF & REVIEW COSTS BY FACILITY TYPOLOGY dministrative tasks related to all components of care y, staff ratios can be sourced from international guidelines or relevant GFF reports equired FTE per facility User Notes Large Annual Cost ($) Percentage (%) Large Small Medium Large $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% Annual Cost ($) Percentage (%) Large Small Medium Large $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% Annual Cost ($) Percentage (%) Large Small Medium Large $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% $0 0% 0% 0% Large $0 $0 $0 ntered under General Inputs Large User Notes and cost/location typology after applying cost loadings from inputs Unit costs - See General Inputs Step Large 6.2 $0 $0 $0 $0 $0 $0 s for all components of small and sick newborn care and any associated quality standards ask-shifting i.e. to improve the capacity of nurses and midwives to deliver small and sick newborn care umber of staff trained @ each facility Fourth, enter Costs Fifth, enter number Third, enter # of per Person per Day of training sessions days ($) in a year Large ypology after applying cost loadings/mark-ups from inputs. If required revise estimates in dark-blue cells Enter user-defined costs here. Note they override modelled estimates Large Small Medium Large $0 $0 $0 Large $0 $0 $0 ted costs at facility level r peer mentoring programs at facility typology is not costed s by Facility size typology Large User Notes $0 ology after applying cost loadings/mark-ups from inputs. If required revise estimates in dark-blue cells Enter user-defined costs here. Note they override modelled estimates Large Small Medium Large $0 $0 $0 Large $0 $0 $0 Human Resource Development Strategies Large $0 $0 $0 STAFF IN HARD-TO-RECRUIT AND MOST CHALLENGING RECRUITMENT AREAS. LEAVE BLANK IF TYPOLOGY NOT INCLUDED. he recruitment and retention of human resources in hard-to-recruit & most challenging recruit areas. centives included in salaries and allowances for staff working in these areas g housing or vehicles (i.e. motobikes) for transport in remote areas. These costs are entered in Step 3.1. portunities for training, mentoring or collaboration. These costs are entered in Step 3.2. e amount of CAPITAL investments required. osts per facility size typology Amount of CAPITAL costs required by facility Hard-to-Recruit Most Challenging Large Small Medium Large $0 $0 $0 $0 of RECURRENT costs required. Leave blank if typology not included or if there are no additional strategies applicable red, enter total costs per facility size typology Amount of RECURRENT costs per facility Hard-to-Recruit Most Challenging Large Small Medium Large $0 $0 $0 $0 to ensure proper functionality Notes Unit costs from inputs Annual costs inc. salaries, allowances, etc. $0 TIP: Remember if copy/paste data into other Workbook, always $0 use Paste Special: Values & Number Formatting $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Unit costs from inputs Annual costs inc. salaries, allowances, recruitment area incentives $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Unit costs from inputs Annual costs inc. salaries, allowances, & recruitment area incentives $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Seventh, Review In-Service Training Costs by Facility Size Sixth, Enter User Notes Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Total In-Service Training Costs $0 $0 $0 mates in dark-blue cells User Notes tes in dark-blue cells User Notes VE BLANK IF TYPOLOGY NOT INCLUDED. User Notes no additional strategies applicable User Notes aste data into other Workbook, always : Values & Number Formatting FUNCTIONAL REFERRAL SYSTEM - PLANNING & BUDGETING WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validati MODULE OVERVIEW Identify key service parameters to estimate the expected number of referrals which will be used to estimate the associated tran Estimate and review costs for: Transport (Ambulance & Alternative Means of Transport) *Care coordination & communication systems Consider and review whether equipment and human resource costs in the previous modules have accounted for the referral sys Remember: Light blue cells are user inputs. Yellow cells are tool calculations not to be manually changed If required, cells in dark blue can be used for overriding modelled estimates. They can also be used to enter costs directly STEP 1. IDENTIFY KEY SERVICE PARAMETERS FOR FACILITY REFERRALS TO ESTIMATE TRANSPORT COSTS In this step the user will enter service parameters to estimate the transport costs of referrals Note that costs will be estimated separately for ambulance referrals and for referrals using other means of transport 1.1. Enter service parameters for referrals using the Facility Ambulance Transport Note: Leave blank or enter 0 if no referrals require funding for that type of transport Service Parameters - Facility Ambulance Referrals % of admissions expected to require referral by Facility Ambulance Number of Vehicles Required per Facility Average number of kilometers per ambulance referral round trip 1.2. Enter Service Paramaters for referrals using Alternative Modes of Transport Note: Leave blank or enter 0 if no referrals require funding for that type of transport % of admissions expected to require alternative means of referral transport 1.3. Review number of admissions requiring referral transport (Facility Ambulance + Alternative Means of Transport) This is estimated based on the number of expected admissions for each facility size (displayed here) and the % requiring referrals e # of admissions requiring referrals using Facility Ambulance # of admissions requiring referrals using Alternative Means of Transport Total facility admissions All admissions requiring referral (Facility Ambulance + Other) as % of total STEP 2 - ESTIMATE AND REVIEW COSTS OF REFERRALS USING FACILITY AMBULANCE TRANSPORT In this step the user will estimate and review costs of ambulance referrals, including acquiring ambulance vehicles, fuel and mainte Remember that: * Annual salaries of facility staff such as trained drivers should be costed under human resources. * Neonatal transport equipment should be included under the facility equipment standards Leave blank if facility referrals are not transported by facility ambulance or if those costs are covered by other programs, such as n 2.1. Review Cost of Ambulance Vehicles, based on unit prices from inputs and required numbers. Make sure ambulance prices in Note: costs will be 0 if facility typology not costed or there are no referrals by facility ambulance These costs are estimated based on the ambulance vehicle costs (from inputs) and the facility requirements set above. Included as Ambulance Vehicle Acquisition Costs Acquisition costs of ambulance vehicle Ambulance vehicle (unit prices) # of ambulance vehicles required by facility 2.2. Review if the ambulance neonatal equipment was included under the facility equipment requirements? Click Go to The Equ Did you include the equipment required for safe transport of newborns under the facility equipment standards? 2.3. Review cost inputs of fuel and maintenance for ambulance referrals transport Note: These were entered under Step 7.2 under the General Inputs Tab and are shown here as a reminder Ambulance fuel cost per kilometer Ambulance maintenance cost per kilometer 2.4. Identify strategies to support ambulance transport referrals and enter other costs per referral trip Include costs such as fees for community workers to accompany the baby and the mother & remember these are unit costs per ref Total Other Ambulance Referral Costs 2.5. Review recurrent Facility Ambulance costs (fuel & maintenance + Other) by facility typology and enter user-defined estimat Review total recurrent costs of ambulance referrals (after applying cost loadings from inputs) and override modelled estimates if re To facilitate this review, intermediate calculations for fuel & maintenance and other annual costs by typology are included in light g * Fuel & maintenance costs are estimated based on number of referrals, kilometers per referral and fuel and maintenance costs re * Other annual ambulance referral costs are estimated based on the expected number of referrals & costs per referral trip entered Recurrent Annual Facility Ambulance Transport Costs Mid Cost High Cost Very High Cost Annual Ambulance Fuel & Maintenance Costs Mid Cost High Cost Very High Cost Other Annual Ambulance Referral Costs Mid Cost High Cost Very High Cost 2.6 Review Recurrent Annual Facility Ambulance Costs to be used in final estimates Recurrent Annual Facility Ambulance Transport Costs Mid Cost High Cost Very High Cost STEP 3 - ESTIMATE AND REVIEW COSTS OF REFERRALS USING ALTERNATIVE MEANS OF TRANSPORT 3.1. Enter cost parameters for referrals requiring alternative means of transport Remember to enter costs per referral First enter unit costs per referral requiring Alternative Means of Transport Total 3.2.Review annual costs of referrals using alternative means of transport by facility size and locatioon typology. Use dark blue c Note that these costs are estimated based on the unit costs per referral adjusted by loadings/mark-ups and the expected number o Mid Cost High Cost Very High Cost 3.3. Review Recurrent Costs for alternative means of transport to be used in the final calculations Mid Cost High Cost Very High Cost STEP 4. IDENTIFY, COST & REVIEW COMMUNICATIONS & COORDINATION SYSTEM REQUIREMENTS FOR REFERRALS (Excluding h 4.1. Identify Equipment Requirements Review if the equipment requirements such as phones & computers were included under the equipment & commodities module. C If equipment is funded separately as part of the Emergency Services budget, select Not Applicable Did you include equipment requirements, such as computers and phones, under 'office and communication equipment' standards in the previous module? 4.2. Identify and include additional recurrent costs associated with communications and coordination requirements for referrals For example, you can include here expenses related to internet, mobile or landphone for communication exchanges with other fac You can also include here other costs such as those associated with supporting in-referrals from lower-level facilities & the commu Recurrent costs - Coordination & Communications Systems for Referrals Total Communication & Coordination Recurrent Costs 4.3. Review additional recurrent costs for referrals by size and location typologies and override modelled estimates as required Mid Cost High Cost Very High Cost 4.4. Review additional recurrent referral costs to be used in Step 4 to estimate recurrent referrals costs Mid Cost High Cost Very High Cost STEP 5 - REVIEW FACILITY RECURRENT COSTS FOR TRANSPORT, COORDINATION AND COMMUNICATIONS (All Referrrals) Review recurrent costs for facility referrals, excluding human resources. They include transport costs (ambulance & other) as well a Referral Recurrent Costs (Transport, Communication & Coordination)* Mid Cost High Cost Very High Cost * Excludes facility staff salaries STEP 6. REVIEW THAT HUMAN RESOURCES REQUIREMENTS FOR REFERRAL SYSTEMS, INCLUDING FOR TRANSPORT, COMMUNIC 6.1. Identify if staff ratios have taken into consideration workloads related to referrals, such as liaising with other facilities, fillin Did you account for the time needed by facility health staff to support referrals when setting facility staff standards under Human Resources? Select Yes/No 6.2. Identify if additional human resources for referrals such as drivers or call center staff have been included as part of facility h In instances where those human resources are not required, the answer should be "No, but other arrangements in place". First, review human resource standards for transport Did you include transport staff, such as trained ambulance drivers when setting facility staff standards under Human Resources? ? Second, review human resource standards for communications and care coordination. Click Go to The HR Tab if required Did you include coordination/communications staff, such as call centre officers, when setting facility staff standards under Human Resources? 6.3. Identify if referral training for facility, transport and communications staff has been included as part of human developmen Did you include under mandatory in-service trainings any requirements related to referrals, communications and care coordination? so may insert conflicting code and remove validation. Please enter data manually to ensure proper functionality errals which will be used to estimate the associated transport costs he previous modules have accounted for the referral system requirements, such as ambulance equipment & trained drivers ates. They can also be used to enter costs directly O ESTIMATE TRANSPORT COSTS or referrals using other means of transport Transport f transport Small Medium Large User Notes f transport Small Medium Large User Notes Ambulance + Alternative Means of Transport) acility size (displayed here) and the % requiring referrals entered above. Included as reminders in light gray Small Medium Large 0 0 0 0 0 0 0 0 0 0% 0% 0% AMBULANCE TRANSPORT , including acquiring ambulance vehicles, fuel and maintenance and other recurrent costs under human resources. r if those costs are covered by other programs, such as national/regional/provincial emergency transportation services ts and required numbers. Make sure ambulance prices include GPS s by facility ambulance puts) and the facility requirements set above. Included as reminders in light gray Small Medium Large $0 $0 $0 $0 $0 $0 0 0 0 he facility equipment requirements? Click Go to The Equipment Tab if required User Notes No & Should be included ERROR. GO BACK TO EQUIPMENT nd are shown here as a reminder $0.000 $0.000 ter other costs per referral trip and the mother & remember these are unit costs per referral trip Unit Cost per Referral Trip User Notes $0 ther) by facility typology and enter user-defined estimates if required adings from inputs) and override modelled estimates if required and other annual costs by typology are included in light gray cells. kilometers per referral and fuel and maintenance costs reviewed above . cted number of referrals & costs per referral trip entered above. Enter user-defined numbers here. Note they override modelled estimates Small Medium Large Small Medium $0 $0 $0 $0 $0 $0 $0 $0 $0 Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 IVE MEANS OF TRANSPORT ansport Unit Costs per Referral User Notes $0 t by facility size and locatioon typology. Use dark blue cellss to override modelled estimates as required djusted by loadings/mark-ups and the expected number of referrals using other means of transport Annual Cost of Alternative Means of Referral Transport by Facility Enter user-defined numbers here. Note Typology they override modelled estimates Small Medium Large Small Medium $0 $0 $0 $0 $0 $0 $0 $0 $0 ed in the final calculations Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 ON SYSTEM REQUIREMENTS FOR REFERRALS (Excluding human resources costed elsewhere) included under the equipment & commodities module. Click Go to The Equipment Tab if required et, select Not Applicable User Notes No & Should be included ERROR. GO BACK TO EQUIPMENT munications and coordination requirements for referrals, not costed elsewhere r landphone for communication exchanges with other facilities orting in-referrals from lower-level facilities & the community, such as mentoring to facility staff and community health workers Other Referral Annual Recurrent Costs User Notes Small Medium Large $0 $0 $0 ypologies and override modelled estimates as required Enter user-defined numbers here. Note Other Referral Annual Recurrent Costs they override modelled estimates Small Medium Large Small Medium $0 $0 $0 $0 $0 $0 $0 $0 $0 timate recurrent referrals costs Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 NATION AND COMMUNICATIONS (All Referrrals) hey include transport costs (ambulance & other) as well as communications and coordination costs estimated in the previous steps Small Medium Large $0 $0 $0 $0 $0 $0 $0 $0 $0 RAL SYSTEMS, INCLUDING FOR TRANSPORT, COMMUNICATIONS AND COORDINATION HAVE BEEN INCLUDED IN FACILITY STANDARDS ed to referrals, such as liaising with other facilities, filling out referral forms and accompanying newborns and mothers during transport as required User Notes No ERROR. GO BACK TO HUMAN RESOURCES r call center staff have been included as part of facility human resource standards. Click Go to The HR Tab if required hould be "No, but other arrangements in place". User Notes No & Should be included ERROR. GO BACK TO HUMAN RESOURCES coordination. Click Go to The HR Tab if required User Notes No & Should be included ERROR. GO BACK TO HUMAN RESOURCES ns staff has been included as part of human development strategies. Click Go to The HR Tab (training) if required User Notes No & Should be included ERROR. GO BACK TO HUMAN RESOURCES e proper functionality pment & trained drivers User Notes User Notes GO TO THE EQUIPMENT TAB TO r Notes REVIEW THE INCLUSION OF TRANSPORT EQUIPMENT er-defined numbers here. Note override modelled estimates User Notes Large er-defined numbers here. Note override modelled estimates User Notes Large GO TO THE EQUIPMENT TAB TO GO TO THE EQUIPMENT TAB TO REVIEW THE INCLUSION OF THE REQUIRED EQUIPMENT ommunity health workers User Notes er-defined numbers here. Note override modelled estimates User Notes Large stimated in the previous steps TIP: Remember i use Past NCLUDED IN FACILITY STANDARDS wborns and mothers during transport as required. Click Go to The HR Tab if required r Notes GO TO THE HR TAB TO REVIEW r Notes FACILITY STANDARDS r Notes GO TO THE HR TAB TO REVIEW MANDATORY IN-SERVICE r Notes TRAINING TIP: Remember if copy/paste data into other Workbook, always use Paste Special: Values & Number Formatting R TAB TO REVIEW HR TAB TO REVIEW SERVICE OTHER COMPONENTS OF SCALING-UP THE MODEL OF CARE (FACILITY LEVEL) - PLANNING & BUDGET WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validati proper functionality MODULE OVERVIEW In this module you will review and identify costs for other components of scaling-up the model of care @ facility level: Robust Data Systems Linkage of Maternal & Newborn Care Family & Community Involvement and Support Post-Discharge Follow-Up You will also have the opportunity to include additional facility-level costs for strategies related to infection prevention and con Note this module should only be used to estimate annual recurrent costs, excluding human resources which as noted below are co Any capital investments needed should be also be costed as part of equipment or infrastructure. Reminder menus are included to provide some initial pointers for consideration. Light blue cells are user inputs. Yellow cells are tool calculations or contain reminder menus for strategies. They cannot be manually changed by the user If required, cells in dark blue (at the end) can be used for overriding modelled estimates. STEP 1 - REVIEW IF FACILITY STANDARDS FOR EQUIPMENT INCLUDE ASSOCIATED REQUIEMENTS FOR OTHER MODEL OF CARE CO Review if you included any additional equipment requirements for other facility components of small and sick newborn care. Click This will help you ensure that additional equipment requirements, such as computers for robust data systems are included and cos Note that we have also included infection prevention & control here to ensure any equipment requirements such as personal prote Select answer for each component listed below and add any relevant notes Did you include additional equipment requirements Other Facility-Level Components of Small and Sick Newborn Care related to this component? Robust data systems Linkage of maternal and newborn care Family & community involvement and support Post-discharge follow-up at facility and at home Infection Prevention & Control STEP 2 - REVIEW IF FACILITY STANDARDS FOR HUMAN RESOURCES INCLUDE ASSOCIATED REQUIEMENTS FOR OTHER MODEL OF 2.1. Review if you included any staff requirements associated with other facility components of small and sick newborn care. Click This will help you ensure that: a) additional staff, such as data clerks for robust data systems are included & costed b) facility staff ratios are adequate for the expected workload, which should include additional tasks related to all of these compon Note that we have also included infection prevention & control here to ensure users consider any staff requirements, such as hous Select answer for each component listed below and add any relevant notes. Did you include staff requirements related to this Other Facility-Level Components of Small and Sick Newborn Care component? Robust data systems Linkage of maternal and newborn care Family & community involvement and support Post-discharge follow-up at facility and at home Infection Prevention & Control 2.2. Review if you included any additional training requirements for other facility components of small and sick newborn care. Clic Select answer for each component listed below and add any relevant notes Did you include training requirements related to this Other Facility-Level Components of Small and Sick Newborn Care component? Robust data systems Linkage of maternal and newborn care Family & community involvement and support Post-discharge follow-up at facility and at home Infection Prevention & Control STEP 3 - IDENTIFY ADDITIONAL STRATEGIES & COSTS ASSOCIATED WITH OTHER COMPONENTS OF THE MODEL OF CARE NOT INC This is to account for any additional recurrent expenditure that was not costed under the previous modules. Remember that a) as in the previous two steps, additional facility equipment and staff requirements should be costed under the equipment and hu b) additional infrastructure such as adequate space for mothers and families should be costed under infrastructure Enter any additional costs in the blue cells. Grey cells are locked. You can enter sub-categories in dark blue cells. Yellow cells include a reminding menu of potential strategies to consider. 3.1. Identify Robust Data Systems strategies & estimate any additional costs at facility level Additional annual facility costs required Robust Data Systems Small Medium Consumables & other office-related costs Printing of case record sheets & registries Office equipment consumables such as paper & print toner Perinatal death reviews Team Reviews of the unit's data Regional meetings with other facilities Supporting a QoC champion in each facility Developing and implementation of facility protocols Family's feedback on services Annual Additional Costs $0 $0 3.2. Identify Linkage of Maternal & Newborn Care strategies & estimate any additional costs at facility level Additional annual facility costs required Linkage of Maternal & Newborn Care Small Medium Facility space inc. requirements for zero separation of mother and baby Mother's education to ensure zero separation policy Annual Additional Costs $0 $0 3.3. Identify Family & Community Involvement and Support strategies & estimate any additional costs at facility level Additional annual facility costs required Family & Community Involvement and Support Small Medium Producing information, education and communications material in the local language Developing and implementing facility protocols and SoP Linking families with community health workers Annual Additional Costs $0 $0 3.4. Identify Post-Discharge Follow-Up strategies & estimate any additional costs at facility level Additional annual facility costs required Post-Discharge Follow-Up Small Medium Social and behavioral change interventions, inc. patient education Transport vouchers for families to visit health facility for follow-up Developing and disseminating protocols for discharge & post- discharge plans Home visits by trained community health workers SMS/Phone reminder system Annual Additional Costs $0 $0 3.5. Identify Infection prevention & control inc. WASH strategies & estimate any additional costs at facility level Additional annual facility costs required Infection prevention & control inc. WASH Small Medium Cleaning & linen management protocols inc. daily, weekly and monthly routines Availability of cleaning & linen management consumables Waste management protocols Microbiological surveillance Annual Additional Costs $0 $0 3.6. Identify Other strategies applicable in country with costs not already included in other modules & estimate any additional c Additional annual facility costs required Other Small Medium Utilities? Annual Additional Costs $0 $0 STEP 4 - REVIEW & VALIDATE ANNUAL ADDITIONAL COSTS FOR OTHER COMPONENTS OF THE MODEL OF CARE (BY TYPOLOGY) 4.1. Review Additional Facility Annual Costs to deliver Small and Sick Newborn Care not included elsewhere Other Components - Annual Costs Small Medium Robust Data Systems $0 $0 Linkage of Maternal & Newborn Care $0 $0 Family & Community Involvement and Support $0 $0 Post-Discharge Follow-Up $0 $0 Infection prevention & control inc. WASH $0 $0 Other $0 $0 Total Other Model of Care Components $0 $0 4.2. Review Other Components - Annual Costs by Facility Size and Location Typology (after applying cost loadings from inputs) This table uses cost loadings to estimate costs by facility location/cost typology As required, estimates can be modified in the dark blue cells. Other Components - Annual Costs Small Medium Mid Cost $0 $0 High Cost $0 $0 Very High Cost $0 $0 4.3. Review costs that will be used for final results. This table shows the costs to be used in the final estimates. Other Components - Annual Costs Small Medium Mid Cost $0 $0 High Cost $0 $0 Very High Cost $0 $0 TY LEVEL) - PLANNING & BUDGETING rt conflicting code and remove validation. Please enter data manually & choose from dropdown menu where available to ensure he model of care @ facility level: es related to infection prevention and control & other recurrent costs (e.g. utilities) not costed elsewhere man resources which as noted below are costed elsewhere ot be manually changed by the user UIEMENTS FOR OTHER MODEL OF CARE COMPONENTS nents of small and sick newborn care. Click Go to The Equipment Tab if required or robust data systems are included and costed under facility equipment. pment requirements such as personal protective equipment have been duly considered. e additional equipment requirements lated to this component? User Notes TED REQUIEMENTS FOR OTHER MODEL OF CARE COMPONENTS nents of small and sick newborn care. Click Go to The HR Tab if required itional tasks related to all of these components nsider any staff requirements, such as housekeepers/cleaners & training needs de staff requirements related to this component? User Notes onents of small and sick newborn care. Click Go to The HR Tab if required e training requirements related to this component? User Notes PONENTS OF THE MODEL OF CARE NOT INCLUDED ELSEWHERE the previous modules. uld be costed under the equipment and human resources modules. costed under infrastructure f potential strategies to consider. nal annual facility costs required Large User Notes Reminder Notes Consider strategies and costs related to: *Ensuring sufficient numbers of printed case record sheets & registries * Providing an adequate supply of office consumables such as paper & print toner *Regular audits & quality assurance *Perinatal death reviews * Regional meetings to improve data collection, analysis and use of data * Developing and implementing facility protocols and standard operating procedures *Community engagement and feedback. $0 l costs at facility level nal annual facility costs required Reminder Notes Large User Notes Included under infrastructure requirements Consider any additional costs for Level II facilities related to: * Zero separation policy and *Mechanisms to foster collaboration among health care profesionals, including obstetricians, midwives, neonatologists and neonatal nurses. related to: * Zero separation policy and *Mechanisms to foster collaboration among health care profesionals, including obstetricians, midwives, neonatologists and neonatal nurses. $0 additional costs at facility level nal annual facility costs required Large User Notes Reminder Notes Consider strategies related to: *Compassionate and respectful care *Mother/family participation in decision making and care provision Additional costs might include those associated with: *Information, education & communication campaigns provided in the local language and tailored to each community *Behavioural change interventions *Developing and implementing facility protocols & standard operating procedures. $0 nal annual facility costs required Large User Notes Reminder Notes Consider strategies and costs related to: *Deploying community health workers to conduct post-discharge follow-up visits *Appointment scheduling and reminders systems *Patient education about the importance of post-discharge follow-up *Addressing transport barriers, including financial support for transport to attend post-discharge follow-up appointments $0 ional costs at facility level nal annual facility costs required Large User Notes Reminder Notes Consider strategies & costs related to: *Use of personal protective equipment *Cleaning & linen management protocols (e.g. availability of consumables) * Waste management *Microbiological surveillance *Fire safety *WASH. $0 other modules & estimate any additional costs at facility level nal annual facility costs required Large User Notes $0 OF THE MODEL OF CARE (BY TYPOLOGY) TIP: Remember if copy/paste data int use Paste Special: Values & N ot included elsewhere Large $0 $0 $0 $0 $0 $0 $0 after applying cost loadings from inputs) Enter user-defined costs here. Note they override modelled estimates Large Small Medium Large $0 $0 $0 Large $0 $0 $0 opdown menu where available to ensure GO TO THE EQUIPMENT TAB TO REVIEW THE INCLUSION OF THE GO TO THE HR TAB TO REVIEW FACILITY STANDARDS GO TO THE HR TAB TO REVIEW MANDATORY IN- SERVICE TRAINING Reminder Notes er strategies and costs related to: *Ensuring ent numbers of printed case record sheets & ries * Providing an adequate supply of office mables such as paper & print toner *Regular & quality assurance *Perinatal death reviews gional meetings to improve data collection, nalysis and use of data * Developing and plementing facility protocols and standard ng procedures *Community engagement and feedback. Reminder Notes der any additional costs for Level II facilities elated to: * Zero separation policy and hanisms to foster collaboration among health rofesionals, including obstetricians, midwives, neonatologists and neonatal nurses. elated to: * Zero separation policy and hanisms to foster collaboration among health rofesionals, including obstetricians, midwives, neonatologists and neonatal nurses. Reminder Notes er strategies related to: *Compassionate and ectful care *Mother/family participation in decision making and care provision tional costs might include those associated *Information, education & communication gns provided in the local language and tailored o each community *Behavioural change ntions *Developing and implementing facility otocols & standard operating procedures. Reminder Notes er strategies and costs related to: *Deploying unity health workers to conduct post-discharge ow-up visits *Appointment scheduling and nders systems *Patient education about the ance of post-discharge follow-up *Addressing port barriers, including financial support for nsport to attend post-discharge follow-up appointments Reminder Notes sider strategies & costs related to: *Use of onal protective equipment *Cleaning & linen management protocols (e.g. availability of consumables) * Waste management obiological surveillance *Fire safety *WASH. TIP: Remember if copy/paste data into other Workbook, always use Paste Special: Values & Number Formatting User Notes LEADERSHIP AND NATIONAL & REGIONAL LEVEL STRATEGIES - PLANNING & BUDGETING WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validati MODULE OVERVIEW Identify and cost higher level education courses to upskill human resources * Estimate number of people that would receive a scholarship to attend identified courses * Estimate tuition and living allowances expenses Identify national and regional level strategies and associated annual costs to support the scale-up Note that cross-cutting issues corresponding to the Vision & Leadership component, such as high-level oversight and managemet & Review summary table and chart with total costs Remember: Light blue cells are user inputs. Yellow cells are tool calculations or contain reminder notes about potential strategies. They cannot be manually changed by the u Step 1. Identify and cost the delivery of higher education courses to upskill human resources Include here any higher education courses to be funded against the scale-up budget First, enter the number of trainees funded per year Second, enter the tuition fees per person per year Third, enter other costs such as scholrship living allowances. Higher Education Courses Annual Costs of Higher Education Courses Step 2 Identify & cost national and regional level strategies for leading and supporting the scale-up First, enter national and regional level strategies required to support the scale-up and facilities delivering good quality of care, inc Second, enter start up costs including any capital investments that need to be incurred in year one of the scale-up Third, enter annual costs for subsequent years Remember that for regional/provincial strategies, country-wide costs should be entered, taking into consideration the number of National Plan & high level oversight and management National Plan development and dissemination Design & implementation of financing mechanisms to ensure timely funding to facilities Additional auditing, financial oversight? National Plan & high level oversight and management costs Templates for guidelines, protocols and SoP Infrastructure Equipment, including for maintenance Human Resources Referral systems, including admission & discharge criteria and protocols Robust data systems, including setting up national minimum dataset Linkages of maternal & Neonatal care Family and Communty Involvement and Support Post-discharge Follow-Up Evidence-base practice (clinical) Infection and prevention control Other Templates for guidelines, protocols and SoP costs Infrastructure Commissioning Processes Infrastructure costs Equipment & Commodities Commissioning processes for equipment Asset management system Drugs and medical supplies managemet systems Equipment & Commodities costs Human Resources Review training curriculum Human Resources costs Referral Systems Referral Systems costs Robust Data Systems Annual Implementation Reviews, inc. dissemination meetings for regions & facilities Three year evaluation, inc. annual implementation reviews. Robust Data Systems costs Other Components & Strategies Other Components & Strategies costs Step 3. Review cost of national and regional level strategies, including higher education courses This table shows total national and regional level costs to support the scale-up and so are not included in facility typology cost anal All financial figures are in - Base Year () National & Regional Level Costs National Plan & high level oversight and management Templates for guidelines, protocols and SoP Infrastructure Equipment & Commodities Human Resources Referral Systems Robust Data Systems Other Components & Strategies National and Regional Strategies Higher Education Courses Total Annual National and Regional Costs National and Regional Level Costs $1 $1 $1 $1 $1 $1 $0 $0 $0 $0 $0 $0 Start up Costs (Year One) Annual Costs in Subsequent Years National and Regional Strategies Higher Education Courses - PLANNING & BUDGETING ay insert conflicting code and remove validation. Please enter data manually to ensure proper functionality ified courses upport the scale-up nent, such as high-level oversight and managemet & development of templates for guidelines are listed first rategies. They cannot be manually changed by the user Costs per trainee per year funded against the scale-up Number of funded Tuition Fees per Scholarship Living Allowances & Additional trainees per year person per year Costs per person per year al Costs of Higher Education Courses pporting the scale-up -up and facilities delivering good quality of care, including any costs for finalising and disseminating the national plan. incurred in year one of the scale-up be entered, taking into consideration the number of regions/provinces included in scale-up plans & budgets Start up Costs (Year Annual Costs in User Notes One) Subsequent Years $0 $0 Start up Costs (Year Annual Costs in User Notes One) Subsequent Years $0 $0 Start up Costs (Year Annual Costs in User Notes One) Subsequent Years $0 $0 Start up Costs (Year Annual Costs in User Notes One) Subsequent Years $0 $0 Start up Costs (Year Annual Costs in User Notes One) Subsequent Years $0 $0 Start up Costs (Year Annual Costs in User Notes One) Subsequent Years $0 $0 Start up Costs (Year Annual Costs in User Notes One) Subsequent Years $0 $0 Start up Costs (Year Annual Costs in User Notes One) Subsequent Years $0 $0 and so are not included in facility typology cost analytics Start up Costs (Year Annual Costs in One) Subsequent Years $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 egional Level Costs $0 Annual Costs in Subsequent Years Higher Education Courses nsure proper functionality Estimated Annual Cost - User Notes All Trainees $0 $0 $0 $0 $0 $0 $0 minating the national plan. Reminder notes In addition to the costs of developing and disseminating the national plan, consider for example, the need of additional staff for management & oversight of the scale-up, as well as costs associated with financing mechanisms to ensure timely funding to facilities. Reminder notes Consider the development of templates as required for each component as well as those Consider the development of templates as required for each component as well as those included in the standards for improving the quality of care for small and sick newbor, such as guidelines, protocols and SoP for evidence- based practices for routine care and management of complications. Reminder notes Consider for example, commissioning strategies for building and rehabilitating facilities, including the development of additional specifications required for tenders. Reminder notes Consider for example, commissioning strategies for purchasing equipment and ensuring adequate supply of spare parts and consumables. Also consider any additional costs at regional or national level related to maintenance,decommissioning, and asset management not already covered by existing programs. Costs related to management systems for facility assets and drugs and medical supplies that are not already covered by existing programs should also be included. Reminder notes Consider for example, strategies related to review of pre-service training curricula or to build the capacity of regional staff to supervise, mentor and coach facility teams Consider for example, strategies related to review of pre-service training curricula or to build the capacity of regional staff to supervise, mentor and coach facility teams Reminder notes Consider strategies to improve coordination and communication systems between various levels of faciities, including regional investments in technology Reminder notes Consider for example strategies needed to support data management such as developing the national minimum dataset, as well as annual implementation reviews and a 3 or 5 year evaluation of the scale-up. Also consider any strategies required to support implementation of perinatal death reviews as Reminder notes TIP: Remember if copy/paste data into other W use Paste Special: Values & Number Fo Consider strategies for the remaining components, not included elsewhere. r if copy/paste data into other Workbook, always aste Special: Values & Number Formatting FINANCING (1) - FACILITY TYPOLOGY ANALYTICS WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validation. Please e MODULE OVERVIEW This is the first financing module, which provides cost analytics by facility typology to support strategic decision-making Select facility typologies for calculating key system parameters and costs Select facility typologies from the dropdown menu Review system parameters and costs by typology STEP 1. SELECT FACILITY TYPOLOGIES FOR DISPLAYING TOTAL COSTS 1.1. Select a costed typology by clicking on each cell & choose from the dropdown menu. Remember do not copy/paste cut/paste into these cells. Only choose from the dropdown menu Facility Typology Facility Type 1 SIZE Small COST/LOCATION Mid Cost CONSTRUCTION TYPE New Construction EQUIPMENT NEEDS Major need RECRUITMENT CHALLENGES Standard area 1.2. Enter a short name for the 'typical' facility. This name will be used for displaying charts, so try to keep it short Facility Type 1 Typical Facility Name/Description: Type1 STEP 2. REVIEW FACILITY COST ANALYTICS Note: If column values are 0, the items or the typology has not been costed. Go back to the previous step and make sure you choose a typology from the dropdown menu FACILITY COSTS (1) All financial figures are in - Base Year () Service Parameter/Cost Type1 Expected annual number of admissions (#) 0 Number of beds required (#) 0 Total floor space (Sq. Mts.) 0 FACILITY CAPITAL COSTS $0 Infrastructure $0 Equipment $0 Main Equipment - Acquisition $0 Main Equipment - Distribution $0 Main Equipment - Buffer Stocks $0 Furniture & other equipment $0 Other Capital $0 Ambulance $0 Other (2) $0 FACILITY RECURRENT COSTS $0 Human Resources $0 Salaries $0 Development & Incentives (3) $0 Equipment $0 Regular Maintenance (4) $0 Consumables & Renewables $0 Other Recurrent $0 Drugs & Medical Supplies $0 Referral Systems $0 Other Model of Care Components (5) $0 FACILITY CAPITAL COSTS ANALYSIS Capital Cost per Bed $0 % Share 0% Infrastructure 0% Equipment 0% Other Capital 0% FACILITY RECURRENT COSTS ANALYSIS Annual Cost per Bed $0 Annual Cost per Newborn Admission $0 % Share 0% Human Resources 0% Equipment 0% Other Recurrent 0% Notes: (1) Table does not include costs of national & regional strategies (2) Other include capital costs (i.e. housing) to recruit and retain staff in hard-to-recruit and most-challenging recruitment typologies (3) Development & Incentives includes human development strategies such as supervision/coaching & mandatory in-service training and addit recruitment incentives not costed as part of staff salaries and allowances (4) Equipment regular maintenance includes spare parts and maintenance strategies, except buffer stocks (5) Recurrent costs for infrastructure maintenance and model of care components other than human resources, equipment & commodities an Note: Use caution when copy/paste charts. Do not use cut to paste into other workbook All financial figures are in - Base Year () Facility Costs by Typology (Capital & Recurrent ) What are the capital and annual recurrent costs involved? How do costs vary by typology What about costs per bed? $0 $0 Type1 FACILITY CAPITAL COSTS Facility Capital Costs by Typology Facility Capital Costs by Typology What accounts for the largest share of capital costs? How does the distribution vary by typology? $0 Type1 Infrastructure Facility Recurrent Costs by Typology What accounts for the largest share of annual costs? How does the distribution vary by typology? $0 Type1 Human Resources Facility Recurrent Costs per Admitted Newb How do annual recurrent costs per bed vary by typology? $0 Type1 Annual Cost per Newborn Admission may insert conflicting code and remove validation. Please enter data manually & choose from dropdown menu where available to ensure proper fun y facility typology to support strategic decision-making e dropdown menu. from the dropdown menu Facility Type 2 Facility Type 3 User Notes Small Small Mid Cost Mid Cost New Construction New Construction Major need Major need Standard area Standard area Facility Type 2 Facility Type 3 Type2 Type3 m the dropdown menu Y COSTS (1) Type2 Type3 0 0 0 0 0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0% 0% 0% 0% 0% 0% 0% 0% $0 $0 $0 $0 0% 0% 0% 0% 0% 0% 0% 0% o-recruit and most-challenging recruitment typologies s supervision/coaching & mandatory in-service training and additional tegies, except buffer stocks ents other than human resources, equipment & commodities and referrals) ncial figures are in - Base Year () Facility Costs by Typology Facility Costs per Bed by Typol (Capital & Recurrent ) $0 $0 $0 $0 $0 $0 Type2 Type3 Type1 FACILITY CAPITAL COSTS FACILITY RECURRENT COSTS Facility Capital Costs by Typology Facility Capital Costs by Typolo Facility Capital Costs by Typology Facility Capital Costs by Typolo $0 $0 0% Type2 Type3 Type1 Infrastructure Equipment Other Capital Facility Recurrent Costs by Typology Facility Recurrent Costs by Typo $0 $0 0% Type2 Type3 Type1 Human Resources Equipment Other Recurrent Human Resources Facility Recurrent Costs per Admitted Newborn by Typology $0 $0 Type2 Type3 Annual Cost per Newborn Admission om dropdown menu where available to ensure proper functionality User Notes TIP: Remember if copy/paste data into other Workbook, always use Paste Special: Values & Number Formatting Facility Costs per Bed by Typology (Capital & Recurrent ) $0 $0 $0 $0 $0 Type2 Type3 Capital Cost per Bed Annual Cost per Bed Facility Capital Costs by Typology (% Share) Facility Capital Costs by Typology (% Share) 0% 0% Type2 Type3 Infrastructure Equipment Other Capital Facility Recurrent Costs by Typology (% Share) 0% 0% Type2 Type3 Human Resources Equipment Other Recurrent FINANCING (2) - SCALE-UP SCENARIO WARNING: Do not copy and paste data into this workbook. Doing so may insert conflicting code and remove validati functionality MODULE OVERVIEW Complements the facilty typology analytics module by allowing the user to model the costs of a basic scale-up scenario It can be used in planning & budgeting discussions to examine the impact of recurrent expenditure vs. capital investments The analysis can also help users gauge how many facilities can be funded within a limited resource envelope Note that five year estimates are shown here and do not include the cost of replacing capital assets after a certain period of time The module steps include: Review the characteristics of the 'typical' facilities that will be used for the scale-up scenario calculations They represent the typologies used in the previous module (9.Financing_Typology_Analytics) Select the start year of the scale-up scenario Scale-up scenario projections shown for five years. If the start year is 2025, the end year of the scenario will be 2029 Enter the percentage of recurrent costs to be funded in each scenario year It is unlikely that facilities will be fully operational the year they are funded, so this percentage adjusts the recurrent expenditure in Enter the number of facilities that will be set up each year To estimate scale-up costs, enter here the number of each 'typical' facility included in the scale-up Review & validate the number of facilities and associated scale-up costs Here the user can examine the impact of recurrent vs. captial costs Review total scale-up costs (facility & national and regional levels) Here the user can review all scale-up costs, including those incurred at national & regional levels Review summary charts Light blue cells are user inputs. Yellow cells cannot be manually changed by the user STEP 1. REVIEW THE CHARACTERISTICS OF THE 'TYPICAL FACILITIES' THAT WILL BE USED FOR THE SCALE-UP SCENARIO CALCULA This table shows the current typologies modelled in Facility Typology Analytics (Module 9) Costs for these typologies will be used for the scale-up scenario calculations Make sure they represent the 'typical' facilities to be included in the scale-up If you want to change any of the typologies, go back to the previous sheet (9.Facility_Typology_Analytics) and make the correspon Typical Facility Name/Description: Type1 Type2 SIZE Small Small COST/LOCATION Mid Cost Mid Cost CONSTRUCTION TYPE New Construction New Construction EQUIPMENT NEEDS Major need Major need RECRUITMENT CHALLENGES Standard area Standard area STEP 2. SELECT THE START YEAR FOR THE SCALE-UP SCENARIO The start year of the scale-up scenario is the year when the first group of facilities will be financed to commence construction. Select a start year for the scale-up after 2023 Note that scale-up projections are shown for five years, that is if the scale-up scenario starts in 2024, it will show expenditure proje Start year of the scale-up scenario: 2025 STEP 3. ENTER THE PERCENTAGE OF RECURRENT COSTS TO BE FUNDED THE YEAR THE FACILITY IS SET UP/FUNDED The model assumes that all capital costs for a facility are disbursed/funded in the year that facility is set up. However, it is reasonable to assume that in the setup year, while the facility is under construction, recurrent costs such as equipme The % entered here will account for this reduced expenditure in that first year. Leave blank or enter 0% if you think no recurrent ex % facility recurrent costs funded in the set up year: STEP 4. FOR EACH YEAR OF THE SCALE-UP ENTER THE NUMBER OF 'TYPICAL' FACILITIES SET UP These 'typical' facilities represent the typologies selected by the user in Facility Typology_Cost_Charts If there are no facilities set up in a particular year, leave blank o enter 0 Enter number of new facilities included in the scale-up 'Typical' Facilities in Country 2025 2026 Type1 Type2 Type3 STEP 5. REVIEW & VALIDATE SCALE-UP SCENARIO COSTS (CAPITAL & RECURRENT) In this table you can review the total number of new facilities funded each year as well as the associated scale-up costs This table shows capital expenditure for facilities funded in a year. Annual recurrent costs are estimated separately for new facilities and for those set up in previous years Remember that all costs in this table are presented in constant prices. The same base year and currency indicated in inputs. Scale-up Year 2025 2026 New facilities 0 0 Annual facility costs $0 $0 Capital (%) 0% 0% Recurrent (%) 0% 0% Capital Costs ($) $0 $0 Recurrent Costs ($) $0 $0 Recurrent new facilities ($) $0 $0 Recurrent facilities set up in previous years $0 $0 Note: All financial figures are in - Base Year () $1 $1 $1 $1 $1 $1 $0 How many new facilities are funded every year? $0 What are the expected levels of facility expenditure? $0 $0 $0 Annual facility costs New facilities New facilities 100% 90% 80% 70% 60% 50% 40% 30% What about facility capital vs. recurrent costs? 20% How does the split change by year? 10% 0% Recurrent Costs ($) Capital Costs ($) STEP 6. REVIEW TOTAL SCALE-UP COSTS BY YEAR (FACILITY, NATIONAL AND REGIONAL LEVELS) Review total scale-up costs, including national & regional level strategies, by year 2025 2026 Facility Scale-up Costs $0 $0 National & Regional Costs $0 $0 TOTAL SCALE-UP COSTS $0 $0 Note: All financial figures are in - Base Year () How does the expected expenditure at national and regional levels compare with expenditure at facility level? How does the expected expenditure at national and regional levels compare with expenditure at facility level? insert conflicting code and remove validation. Please enter data manually to ensure proper he costs of a basic scale-up scenario ent expenditure vs. capital investments imited resource envelope ng capital assets after a certain period of time up scenario calculations d year of the scenario will be 2029 percentage adjusts the recurrent expenditure in that year. E USED FOR THE SCALE-UP SCENARIO CALCULATIONS y_Typology_Analytics) and make the corresponding changes Type3 Small Mid Cost New Construction Major need Standard area will be financed to commence construction. ario starts in 2024, it will show expenditure projections up to 2030 THE FACILITY IS SET UP/FUNDED e year that facility is set up. er construction, recurrent costs such as equipment maintenance expenditure will not be incurred. ve blank or enter 0% if you think no recurrent expenditure will be incurred in the set-up year number of new facilities included in the scale-up each year 2027 2028 2029 Total 0 0 0 well as the associated scale-up costs up in previous years ase year and currency indicated in inputs. 2027 2028 2029 Total 0 0 0 0 $0 $0 $0 $0 0% 0% 0% 0% 0% 0% 0% 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Number of New Facilities & Expenditure by Year $1 1 $1 0.9 $1 0.8 $1 0.7 $1 0.6 $1 0.5 $0 0.4 $0 0.3 $0 0.2 $0 0.1 $0 0 2025 2026 2027 2028 2029 Annual facility costs $0 $0 $0 $0 $0 0 0 0 0 0 0 0 0 0 0 Annual facility costs New facilities Note: All financial figures are in - Base Year () Recurrent vs. Capital Facility Costs by Year 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% 2025 2026 2027 2028 2029 Total Recurrent Costs ($) $0 $0 $0 $0 $0 $0 Capital Costs ($) $0 $0 $0 $0 $0 $0 Capital Costs ($) Recurrent Costs ($) Note: All financial figures are in - Base Year () 2027 2028 2029 Total $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Facility vs National & Regional Levels Total Expected Expenditure - All Years $0, 0% Facility Scale-up Costs Facility Scale-up Costs National & Regional Costs Note: All financial figures are in - Base Year () TIP: Remember if copy/paste data into other Workbook, always use Paste Special: Values & Number Formatting ther Workbook, always ber Formatting