Media Monitoring Excel Template - Download as Excel

Document Sample
Media Monitoring Excel Template - Download as Excel Powered By Docstoc
					1. NTP Budget 2005

FISCAL YEAR 2005
(your fiscal year starting during the calendar year 2005)



Beginning of your fiscal year 2005 (day,
month, year)
Expected number of new smear-positive                                             Expected number of new smear-negative/extra-pulmonary patients to
patients to be treated in 2005                                           1        be treated in 2004

Please give amounts for budget,
funding, and gap
  in US dollar equivalent
                                                 TOTAL BUDGET REQUIRED                                    EXPECTED Funding
                                                                                   Government          Loans      GFATM
TB drugs: first-line
TB drugs: second-line (for MDR-TB)
Staff working exclusively for TB control
(central unit staff and subnational TB
coordinators)
 Initiatives to increase case detection and
cure rates
TB/HIV collaborative activities
Buildings, vehicles, equipment (lab / office
equip. etc.)
All other budget lines for TB (training, fuel,
supervision, supplies)
TOTAL



Financial information - utilization of health services and expenditure data
                                              ss+
Typical number of visits to a health facility
                                                                                   Typical number of visits to a health facility required for a new smear
required for one new smear-positive
                                                                                        negative/extra-pulmonary patient after diagnosis is made
patient after diagnosis is made

Estimated percentage of new smear-                                                Estimated percentage of new smear negative/extra-pulmonary
                                                                              %
positive patients that are hospitalized                                           patients that are hospitalized

Estimated average duration of stay for new
                                                                                  Estimated average duration of stay for new smear negative/
smear-positive patients if hospitalized
                                                                                  extra-pulmonary patients if hospitalized (days)
(days)

                                                                                  Number of hospital beds used exclusively for TB
ew smear-negative/extra-pulmonary patients to
                                                               1




   EXPECTED Funding                                      GAP
                              Other Grants




                                                     ss-/EP

 its to a health facility required for a new smear
pulmonary patient after diagnosis is made


of new smear negative/extra-pulmonary
alized                                                             %


ation of stay for new smear negative/
ts if hospitalized (days)
1.1 Unit costs for outpatient visits, hospitalization, smear tests and x-rays
based on DCPP regional unit prices

             Cost per inpatient   Cost per health      Cost per        Cost per x-ray
             hospital bed day     centre visit         smear test      test
             best price' (2005)   best price' (2005)   prices 2005     prices 2005
EMR                         23.31                 3.49            2.10           12.43
1.2 Unit costs for treating one TB patient, as of 2005

                                           First-line          Programme Laboratory       X-rays          Outpatient       Hospitalizati
                                           drugs               management tests during                    visits to        on during
                                                               /supervision treatment                     health           treatment
                                                                                                          facilities for
                                                                                                          DOT and
                                                                                                          monitoring


                               per ss+                  0.00          0.00        12.61            0.00             0.00            0.00
           Country X
                               per ss-                  0.00          0.00         6.30            0.00             0.00            0.00
Buildings/eq Laboratory    Total cost
uipment      tests for     for treating
             screening     one TB
             TB suspects   patient




       0.00       174.86          187.46
       0.00 -                       6.30
2. Improving DOTS quality in addition to 2005 activities

The activities and costs included in this table should NOT be the same as in the budget of 2005 (table 1)

You can include as much items as need for TB contol over the next decade



                                                                                                           Total running
                                                               Year of                        Total cost
                                                                              Perioditcity,                cost per year,
          ITEMS                                                Starting the                   per year
                                                                              if needed                    if needed (US$
                                                               activities                     (US$ )
                                                                                                           )


          Refreshing course
          HR development
          Improving lab services of smear microscopy
          Improving supervision
          Drug management
          TB control information system improvement
          xxxxxx
          xxxxxx
          Others
          Total                                                                                     0            0

                                                       2006          0
                                                       2007          0
                                                       2008          0
                                                       2009          0
                                                       2010          0
                                                       2011          0
                                                       2012          0
                                                       2013          0
                                                       2014          0
                                                       2015          0
                                                       total         0
udget of 2005 (table 1)




                    Details of items included
3. Total cost for new initiatives
                      Unit costs for new initiatives

                             Community TB care                                            PPM                                               PAL
                      Start-up cost   Running costs      PPM start-up      PPM running      PPM running      PPM capital       PAL cost at
                      for Community for Community        costs at          costs at         cost at sub-     investments at    sub-national
                      Care at sub-    Care costs at      national level,   national level, national level,   sub-national      level, per
                      national level, sub-national       per country       per country      per 500,000      level, per        500,000
                      per 500 000     level, per         covered (US$)     covered (US$) population          500,000           population
                      population      500,000                                               covered (US$)    population        covered (US$)
                      covered (US$) population                                                               covered (US$)
                                      covered (US$)


               2005
               2006            41286              1236           171310             20736             2074              173            41200
               2007            41286              1236           171310             20736             2074              173            41200
               2008            41286              1236           171310             20736             2074              173            41200
               2009            41286              1236           171310             20736             2074              173            41200
               2010            41286              1236           171310             20736             2074              173            41200
               2011            41286              1236           171310             20736             2074              173            41200
               2012            41286              1236           171310             20736             2074              173            41200
               2013            41286              1236           171310             20736             2074              173            41200
               2014            41286              1236           171310             20736             2074              173            41200
               2015            41286              1236           171310             20736             2074              173            41200

                                                                           Community         PPM             PAL               Culture and DST
Is the country initiating a new intervention? (1 for Yes, 0 for No)                      0               0                 0                0

                                                   additional population to be covered                                   Cost per new initiative (US$ millions)
                      Country          Community TB PPM              PAL              Culture and            Community TB
                      population       care                                           DST labs               care         PPM
               2005
               2006                                                                                                     0.00             0.00
               2007                                                                                                     0.00             0.00
               2008                                                                                                     0.00             0.00
               2009                                                                                                     0.00             0.00
               2010                                                                                                     0.00             0.00
               2011                                                                                                     0.00             0.00
               2012                                                                                                     0.00             0.00
               2013                                                                                                     0.00             0.00
               2014                                                                                                     0.00             0.00
               2015                                                                                                     0.00             0.00
                                  Introducing culture and DST
             PAL                  labs
               PAL costs at       Start up cost     Running costs
               national level     per new           per culture and
               per country        culture and       DST lab (US$)
               covered (US$)      DST lab
                                  established
                                  (US$)




                         37132            270375             76207
                         37132            270375             76207
                         37132            270375             76207
                         37132            270375             76207
                         37132            270375             76207
                         37132            270375             76207
                         37132            270375             76207
                         37132            270375             76207
                         37132            270375             76207
                         37132            270375             76207

Culture and DST



st per new initiative (US$ millions)
                                  Culture and        TOTAL new
                 PAL              DST                 initiatives

                           0.00              0.00             0.000
                           0.00              0.00             0.000
                           0.00              0.00             0.000
                           0.00              0.00             0.000
                           0.00              0.00             0.000
                           0.00              0.00             0.000
                           0.00              0.00             0.000
                           0.00              0.00             0.000
                           0.00              0.00             0.000
                           0.00              0.00             0.000
                                                              0.000
Summary table

                Estimated      Estimated          Cost of        Cost of        Total cost of Total cost of Total cost       Total cost
                number of      number of          treating one   treating one   treating ss+ treating ss- for                for new
                ss+ patients   ss- patients       new ss+        new ss-        patients      patients      improving        initiatives
                to treat       to treat           patient        patient                                    DOTS
                                                                                                            quality
         2005
         2006                                           193.1            6.5               0              0              0                 0
         2007                                           193.1            6.5               0              0              0                 0
         2008                                           193.1            6.5               0              0              0                 0
         2009                                           193.1            6.5               0              0              0                 0
         2010                                           193.1            6.5               0              0              0                 0
         2011                                           193.1            6.5               0              0              0                 0
         2012                                           193.1            6.5               0              0              0                 0
         2013                                           193.1            6.5               0              0              0                 0
         2014                                           193.1            6.5               0              0              0                 0
         2015                                           193.1            6.5               0              0              0                 0
total decade               0                  0     1930.8869     64.9193482               0              0              0                 0
Total cost to
control TB
per year




            0
            0
            0
            0
            0
            0
            0
            0
            0
            0

				
DOCUMENT INFO
Description: Media Monitoring Excel Template document sample