Immunization and Vaccine Development (IVD) Programme: 'Reaching Every Child' Planning Tool for Estimating Budget and Logistics

The tool aims to facilitate program managers in having more realistic bottom-up planning, leading to estimates of budget and logistical requirements. The tool is an MS Excel-based application with hyperlinked worksheets and logical formulas to avoid manual calculations and repeat entries on different formats. It has four different input templates to facilitate planning of different components of the immunization program. Output sheets are generated automatically on the basis of information entered in the input sheets and include service delivery plans for health facilities and summary plans for council and health facility levels. The tool features a navigation catalogue, known as the INDEX page, which serves as a navigation catalogue and can be used to access different formats and templates of the tool. The INDEX page links to three types of worksheets: input sheets, output sheets, and standard planning templates. The input sheets are to be compiled and filled electronically at the CHMT level and include setting up variables, compilation sheet for health facility plans, and cold chain maintenance plan. The compilation sheet for health facility plans is used at the CHMT level for compilation of the health facility plans for immunization service delivery. Each row of the sheet captures information about one village or sub-village in the catchment area of the health facility. The names of region and council and the planning year will appear as per the names entered in the worksheet for "Setting up variables." The tool requires users to set up input variables for the template, including standard norms with respect to budgetary requirements and immunization schedule. Users can only make entries in the blue-colored cells, and the best size for viewing is 85 percent. The entries to be made in this sheet include names of region and council and the year for which the plan is being prepared, norms to be used for estimation of budgetary requirements, and details related to immunization schedule. The tool also features drop-down lists in some columns to ensure uniform entries without any spelling mistakes or unrequired characters. Users can select from the list, and the tool will automatically calculate totals or subtotals as per the information entered by the user. The tool highlights cells that do not require entry, and users are advised to ensure that nothing is written in the black-colored cells, as this will result in incorrect estimates. The tool is designed to facilitate program managers in having more realistic bottom-up planning, leading to estimates of budget and logistical requirements. It aims to provide standard templates for manual use at health facility level and electronically at CHMT level, and it features a navigation catalogue, input sheets, output sheets, and standard planning templates. The tool requires users to set up input variables, and it features drop-down lists to ensure uniform entries.