Riaz Khan wrote:
>
> DEAR LIST MEMBERS,
> I have prepared a Financial and operational model for Primary Health care
> and Population Services. You feed the assumptions and it calculates all
> the outputs. Below is a sample output of the Spreadsheet in text form.
> The alignment of the numbers are off. It is just to show the output. It
> can help in planning for Primary Health care services. It covers almost
> all the operational and financial outputs that are generally required.
> It can provide answers to questions like how many Basic Health units are
> needed? What are the cost implications? How much staff is needed? What
> would be the outputs? What supplies and medicines have to be purchased? In
> fact the number of combinations and scenarios can be endless.
>
> I hope to receive some feedback on the model so that it can be further
> improved. Also I would like to get in touch with people who are doing
> similar work.
>
> Regards
>
> Riaz KHAN.
>
> OUTPUT REPORT
> ==============
>
> 1 GEOGRAPHIC LOCATION ISLAMABAD RURAL
> 2
> 3 GOAL/OBJECTIVE
> 4
> 5 TOTAL RURAL AREA SQ KM. 544.80 PERCENT
> 6 TOTAL RURAL POPULATION NOS. 250,700.01 COVERAGE
> 7 ENTER TARGET COVERAGE AREA 545.00 100
> 8
> 9 ESTIMATED OUTPUTS EXISTING CHANGE TARGET
> 10 CAPACITY
> CAPACITY
> 11
> 12 BHUS 15.00 -4
> 11.35
> 13
> 14 AREA COVERAGE 720.00 -175
> 545.00
> 15 PERCENT OF AREA COVERED 132.16 -32 100.04
> 16 POPULATION COVERAGE 331322 -80530 250792
> 17 PERCENT OF POPULATION COVERED 132.16 -32 100.04
> 18 MAX. VISITS-SICKNESS/YEAR 662,643.19 -161059 501,584.08
> 19
> 20 PATIENTS/YEAR (EXPECTED )
> PERCENT
> 21 MALES 10,500.00 6389 16,889.32
> 28.00
> 22 FEMALES 27,000.00 16430 43,429.69
> 72.00
> 23 TOTAL 37,500.00 22819 60319
> 100.00
> 24 PERCENTAGE OF TOTAL PATIENTS
> 25 CHILDREN 15,000.00 9128 24,127.60
> 40.00
> 26 REFERRALS 5,625.00 3423 9,047.85
> 15.00 LOAD ON NEXT LEVEL FACILITY
> 27 BHU UTILIZATION % OF OPTIMUM 50.00 35 85
> 28 % OF TOTAL PATIENTS SEEN BY BHU 5.66 6 12.03
> SHOWS LOAD COVERED BY BHUS
> 29
> 30 TYPE OF ILLNESS SUFFERED
> PERCENT
> 31 ASTHMA 937.50 570 1,507.98
> 2.50
> 32 COLD 1,312.50 799 2,111.17
> 3.50
> 33 COUGH 1,350.00 821 2,171.48
> 3.60
> 34 DIABETICS 712.50 434 1,146.06
> 1.90
> 35 FEVER 11,437.50 6960 18,397.30
> 30.50
> 36 HEART DISEASE 1,200.00 730 1,930.21 3.20
> 37 INFLUENZA 975.00 593 1,568.29
> 2.60
> 38 MALARIA 1,762.50 1072 2,834.99
> 4.70
> 39 RHEUMATISM 2,775.00 1689 4,463.61
> 7.40
> 40 STOMACH ACHE 1,537.50 936 2,473.08 4.10
> 41 OTHERS 13,500.00 8215 21,714.84
> 36.00
> 42 TOTAL 37,500.00 22819 60,319.01
> 100.00
> 43
> 44 LHW COVERAGE
> 45 NO. HOUSEHOLDS 19490 -4737 14752
> 46 NO. OF PERSONS COVERED 331322 -80530 250792
> 47 AREA COVERAGE 720.00 -175 545.00
> 48
> 49 POPULATION SERVICES & EPI
> 50
> 51 EXISTING
> CHANGE TARGET
> 52 NOS. OF BIRTHS 13253 -4475
> 8778
> 53
> 54 NOS. OF INFANTS DEATH 1,431.31 -554
> 877.77
> 55 INFANT MORTALITY/1000 BIRTH-RURAL 108.00 -8 100
> 56 NO. OF MATERNAL DEATHS 86.14 -33
> 52.67
> 57 MATERNAL MORTALITY/100,000 BIRTHS 650.00 -50 600.00
> 58 NOS. OF CHILDREN FOR EPI 11,821.55 -3922
> 7,899.95
> 59 CHILDREN WITH EPI COVERAGE 6,383.64 -1328
> 5,055.97
> 60 % OF CHILDREN WITH EPI 54 10
> 64
> 61 CHILDREN WITHOUT EPI COVER 5438 -2594
> 2844
> 62 % CHILDREN WITH OUT EPI 46 -10
> 36
> 63
> 64
> 65 NO. OF PREGNANCIES 14,909.47 -6132 8,777.72
> 66
> 67 NO. RECEIVIED TETANUS TOXOID 3,578.27 -945 2,633.32
> 68 % RECEIVIED TETANUS TOXOID 24.00 6 30.00
> 69 # NOT RECEIVIED TET. TOXOID 11,331.20 -5187 6,144.41
> 70 % WITH OUT TETANUS TOXOID 76.00 -6
> 70.00
> 71
> 72
> 73 WOMEN OF CHILD BEARING AGE 69,577.54 -16911 52,666.33
> 74
> 75 NOS. OF CONTRACEPTIVE USERS
> 76 IUD 1,252.40 170 1,421.99
> 77 PILLS 695.78 94 789.99
> 78 INJECTIBLES 974.09 132 1,105.99
> 79 LIGATION 2,574.37 349 2,922.98
> 80 CONDOMS 626.20 85 711.00
> 81 OTHER 834.93 113 947.99
> 82 TOTAL 6,957.75 942 7,899.95
> 83
> 84 CONTRACEPTIVE PREVALANCE RATE 10.00 5 15.00
> 85
> 86 EXISTING CHANGE TARGET
> 87
> EXISTING PERCENT OF
> 88 STAFFING
> VACANCY APPROVED
> 89 DOCTOR 15.00 -4
> 11.35 0.00 0.0
> 90 MEDICAL ASSISTANT 15.00 -4 11.35
> 0.00 0.0
> 91 LHV 10.00 1
> 11.35 5.00 33.3
> 92 LHW 180.00 -44
> 136.25 0.00 0.0
> 93 DISPENSER 15.00 -4 11.35
> 0.00 0.0
> 94 CLEANER 15.00 -4 11.35
> 0.00 0.0
> 95 GUARD 15.00 -4 11.35
> 0.00 0.0
> 96 OTHER 0.00 0
> 0.00 0.00 ERR
> 97 TOTAL 265.00 (60.63) 204.38
> 5.00 1.9
> 98
> 99 BUDGET AND COSTS
> 100 NON-SALARY BUDGET % PROVIDED 50.00 35 85.00
> PERCENT
> 101 SALARIES
> 102 DOCTOR ************ -210875 1,049,125.00
> 5
> 103 MEDICAL ASSISTANT 720,000.00 -120500 599,500.00
> 3
> 104 LHV 480,000.00 119500 599,500.00
> 3
> 105 LHW ************ -433800 2,158,200.00
> 11
> 106 DISPENSER 450,000.00 -75313 374,687.50
> 2
> 107 CLEANER 270,000.00 -45188 224,812.50
> 1
> 108 GUARD 360,000.00 -60250 299,750.00
> 1
> 109 OTHER 0.00 0 0.00
> 110 TOTAL ************ -826425 5,305,575.00
> 26
> 111
> 112 REPAIRS AND MAINTENANCE
> 113 CIVIL 180,000.00 -26038 153,962.50
> 1
> 114 EQUIPMENT 540,000.00 -78113 461,887.50
> 2
> 115 FURNITURE 180,000.00 -26038 153,962.50
> 1
> 116 TRANSPORT 216,000.00 3397 219,396.56
> 1
> 117 OTHER 45,000.00 -6509 38,490.63
> 118 SUB-TOTAL ***********************1,027,699.69
> 4.93
> 119
> 120 TA/DA 9,000.00 -1302 7,698.13
> 0
> 121
> 122 UTILITIES
> 123 ELECTRICITY 18,000.00 283 18,283.05
> 0
> 124 HOT/COLD 0.00 0 0.00
> 0
> 125 GAS 14,400.00 226 14,626.44
> 0
> 126 WATER 3,600.00 57 3,656.61
> 0
> 127 TELEPHONE 36,000.00 566 36,566.09
> 0
> 128 SUB-TOTAL 72,000.00 1132 73,132.19
> 0.36
> 129
> 130 POL 180,000.00 -26038 153,962.50
> 1
> 131
> 132 MISCELLANEOUS
> 133 STATIONERY 9,000.00 -1302 7,698.13
> 0
> 134 POSTAGE 4,500.00 -651 3,849.06
> 0
> 135 PRINTING 27,000.00 -3906 23,094.38
> 0
> 136 PUBLICATIONS 0.00 0 0.00
> 0
> 137 NEWSPAPERS 0.00 0 0.00
> 0
> 138 OTHER 9,000.00 -1302 7,698.13
> 0
> 139 SUB-TOTAL 49,500.00 -7160 42,339.69
> 0.21
> 140
> 141 UNIFORMS & LIVERIES 9,000.00 -1302 7,698.13
> 0
> 142
> 143 RENT 0.00 0 0.00
> 0
> 144
> 145 MEDICINES COSTS 4,950.00 11215 16165
> 0
> 146
> 147 EPI COVERAGE COST 383018 -34157 348862
> 2
> 148
> 149 POPULATION COVERAGE COSTS ************ 185967 1616481
> 8
> 150
> 151 DEPRECIATION
> 152 CIVIL 900000 -130188 769813
> 4
> 153 EQUIP 600000 -86792 513208
> 3
> 154 FURNITURE 300000 -43396 256604
> 1
> 155 TRANSPORT 500000 -72326 427674
> 2
> 156 OTHER 30000 -4340 25660
> 0
> 157 TOTAL 2300000 -332701 1967299
> 10
> 158
> 159 TOTAL NON-SALARY COMPONENT 5598982 -337646 5261337
> 160 NON-SALARY AS PERCENT OF TOTAL 47.73 29.01 49.79
> 161
> 162 TOTAL RECURRING COST 11730982 -1164071 10566912
> 53
> 163
> 164 EXISITING CHANGE TARGET
> 165
> 166 OVERHEAD HEALTH
> 167 PERCENT 50.00 -20 30.00
> 168 AMOUNT 5865491 -2695418 3170074
> 16
> 169
> 170 OVERHEAD EPI
> 171 PERCENT 50 -20 30
> 172 AMOUNT 5865491 -2695418 3170074
> 16
> 173
> 174 OVERHEAD POPULATION
> 175 PERCENT 50 -20 30
> 176 AMOUNT 5865491 -2695418 3170074
> 16
> 177
> 178 TOTAL OVERHEAD COSTS 17596474 -8086253 9510221
> 47
> 179
> 180 TOTAL RECURRING + OHD COSTS 29327456 -9250324 20077133
> 100
> 181
> 182 RECOVERY
> 183 MEDICINES 49,500.00 40979 90,478.52
> 0
> 184 EPI 75,000.00 45638 120,638.02
> 1
> 185 POPULATION 0.00 13 13.33
> 0
> 186 TOTAL 124,500.00 86630 211,129.87
> 1
> 187
> 188 NET COST ************************************
> 99
> 189
> 190
> 191 COST/PATIENT HEALTH
> 192 MEDICINES 0.13 0 0.27
> 193 OVERHEADS 156.4 -104 52.6
> 194 TOTAL 156.5 -104 52.8
> 195 RECOVERY PER PATIENT 1.3 0 1.5
> 196 NET COST/PATIENT 155.2 -104 51.3
> 197
> 198 COST/PATIENT EPI
> 199 EPI 60.0 9 69.0
> 200 OVERHEADS 918.8 -292 627.0
> 201 TOTAL 978.8 -283 696.0
> 202 RECOVERY PER PATIENT 11.75 12 23.86
> 203 NET COST/PATIENT 967.1 -295 672.1
> 204
> 205 COST/PATIENT POPULATION
> 206 POPULATION 205.6 -1 204.6
> 207 OVERHEADS 843 -442 401
> 208 TOTAL 1048.6 -443 605.9
> 209 RECOVERY/PATIENT 0.0 0 0.0
> 210 NET COST/PATIENT 1048.6 -443 605.9
> 211
> 212 DEVELOPMENT COST
> 213
> 214 COST OF BHUS CHANGE
> 215 CIVIL 18000000 -2603750 15396250
> 216 EQUIPMENT 3000000 -433958 2566042
> 217 FURNITURE 1500000 -216979 1283021
> 218 TRANSPORT 6000000 -867917 5132083
> 219 OTHERS 300000 -43396 256604
> 220 TOTAL 28800000 -4166000 24634000
> 221
> 222 UPGRADATION OF EXISTING BHUS
> 223
> 224 BHU'S WITHOUT ELECTRICITY 90000 -70755 19245
> 225 BHUS NEEDING MAJOR REPAIRS 300000 -235849 64151
> 226 COST OF WATER PROVISION 90000 -70755 19245
> 227 COST OF TELEPHONE PROVISION 18000 -14151 3849
> 228 COST OF ROAD ACCESS 1500000 -1179245 320755
> 229 COST OF GAS PROVISION 60000 -47170 12830
> 230 COST OF TRANSPORT PROVISION 1200000 -943396 256604
> 231 SUB-TOTAL UPGRADATION 3258000 -2561320 696680
> 232
> 233 TOTAL DEVELOPMENT COSTS 32058000 -6727320 25330680
> 234
> 235 PROCUREMENT DETAILS
> 236 EXISTING CHANGE TARGET
> 237 EPI COVERAGE QUANTITIES
> 238 DPT1, DPT2, DPT3 6,383.64 -1328 5,055.97
> 239 MEASLES 6,383.64 -1328 5,055.97
> 240 POLIO 1, POLIO 2, POLIO 3 6,383.64 -1328 5,055.97
> 241 BCG 6,383.64 -1328 5,055.97
> 242 DT 6,383.64 -1328 5,055.97
> 243 TT 6,383.64 -1328 5,055.97
> 244 1 0.00 0 0.00
> 245 OTHER 0.00 0 0.00
> 246
> 247
> 248 EPI COVERAGE COSTS
> 249 DPT1, DPT2, DPT3 63,836.39 -5693 58,143.63
> 250 MEASLES 63,836.39 -5693 58,143.63
> 251 POLIO 1, POLIO 2, POLIO 3 63,836.39 -5693 58,143.63
> 252 BCG 63,836.39 -5693 58,143.63
> 253 DT 63,836.39 -5693 58,143.63
> 254 TT 63,836.39 -5693 58,143.63
> 255 1 0.00 0 0.00
> 256 OTHER 0.00 0 0.00
> 257 TOTAL 383,018.37 (34,156.61) 348,861.76
> 258
> 259 MEDICINES DETAILS QUANTITIES
> UNITS
> 260 ORS 225.00 425 650.25
> PACKETS
> 261 COTRIMAXAZOLE 225.00 425 650.25
> TABLETS
> 262 COTRIMAXAZOLE SYRUP 225.00 425 650.25
> BOTTLE
> 263 CHLOROQUINE 225.00 425 650.25
> TABLETS
> 264 PRIMAQUINE 225.00 425 650.25
> TABLETS
> 265 IRON 225.00 425 650.25
> TABLETS
> 266 FOLATE 225.00 425 650.25
> TABLETS
> 267 STREPTOMYCIN 225.00 425 650.25
> VIAL
> 268 ISONIAZID (INH) 225.00 425 650.25
> TABLET
> 269 INH+TB1 225.00 425 650.25
> TABLET
> 270 ZIEHL-NIELSEN 225.00 425 650.25
> BOTTLE
> 271 12.00 0.00 0 0.00
> 272 13.00 0.00 0 0.00
> 273 14.00 0.00 0 0.00
> 274 15.00 0.00 0 0.00
> 275 16.00 0.00 0 0.00
> 276 17.00 0.00 0 0.00
> 277 18.00 0.00 0 0.00
> 278 19.00 0.00 0 0.00
> 279 20.00 0.00 0 0.00
> 280 21.00 0.00 0 0.00
> 281 22.00 0.00 0 0.00
> 282 23.00 0.00 0 0.00
> 283 24.00 0.00 0 0.00
> 284 25.00 0.00 0 0.00
> 285 26.00 0.00 0 0.00
> 286 27.00 0.00 0 0.00
> 287 28.00 0.00 0 0.00
> 288 29.00 0.00 0 0.00
> 289 30.00 0.00 0 0.00
> 290 MEDICINE COVERAGE % OF REQUIRED 50.00 35 85.00
> 291
> 292 EXISTING CHANGE TARGET
> 293 MEDICINES DETAILS COSTS
> 294 ORS 450.00 1020 1,469.57
> 295 COTRIMAXAZOLE 450.00 1020 1,469.57
> 296 COTRIMAXAZOLE SYRUP 450.00 1020 1,469.57
> 297 CHLOROQUINE 450.00 1020 1,469.57
> 298 PRIMAQUINE 450.00 1020 1,469.57
> 299 IRON 450.00 1020 1,469.57
> 300 FOLATE 450.00 1020 1,469.57
> 301 STREPTOMYCIN 450.00 1020 1,469.57
> 302 ISONIAZID (INH) 450.00 1020 1,469.57
> 303 INH+TB1 450.00 1020 1,469.57
> 304 ZIEHL-NIELSEN 450.00 1020 1,469.57
> 305 12.00 0.00 0 0.00
> 306 13.00 0.00 0 0.00
> 307 14.00 0.00 0 0.00
> 308 15.00 0.00 0 0.00
> 309 16.00 0.00 0 0.00
> 310 17.00 0.00 0 0.00
> 311 18.00 0.00 0 0.00
> 312 19.00 0.00 0 0.00
> 313 20.00 0.00 0 0.00
> 314 21.00 0.00 0 0.00
> 315 22.00 0.00 0 0.00
> 316 23.00 0.00 0 0.00
> 317 24.00 0.00 0 0.00
> 318 25.00 0.00 0 0.00
> 319 26.00 0.00 0 0.00
> 320 27.00 0.00 0 0.00
> 321 28.00 0.00 0 0.00
> 322 29.00 0.00 0 0.00
> 323 30.00 0.00 0 0.00
> 324 TOTAL 4,950.00 11,215.22 16,165.22
> 325
> 326 CONTRACEPTIVE QUANTITIES
> 327 IUD 1,252.40 170 1,421.99
> 328 PILLS 139,155.07 18844 157,998.99
> 329 INJECTIBLES 11,689.03 1583 13,271.91
> 330 LIGATION 2,574.37 349 2,922.98
> 331 CONDOMS 75,143.74 10176 85,319.45
> 332 OTHER 0.00 0 0.00
> 333
> 334
> 335
> 336 CONTRACEPTIVE COSTS
> 337 IUD 31,309.89 4070 35,380.18
> 338 PILLS 34,788.77 4523 39,311.31
> 339 INJECTIBLES 58,445.13 7598 66,043.00
> 340 LIGATION ************ 167334 1,454,518.37
> 341 CONDOMS 18,785.93 2442 21,228.11
> 342 OTHER 0.00 0 0.00
> 343 TOTAL ************185,966.84 1,616,480.96
> 344
>
> ==========================================================
> 345 ASSUMPTIONS
> ===============
>
> 346
> 347 NOS. OF EXISITNG BHUS 15.00
> 348
> -------- APPROVED #--------------- EXISTING #---
> 349 STAFF SALARY /MONTH/BHU PAY ALLOWANCES TOTAL
> M F TOTAL M F TOTAL
> 350 DOCTOR 5,000.00 2,000.00 7,000.00
> 1.00 1.00 15.00 15.00
> 351 MEDICAL ASSISTANT 2,500.00 1,500.00 4,000.00
> 1.00 1.00 15.00 15.00
> 352 LHV 2,500.00 1,500.00 4,000.00
> 1.00 1.00 10.00 10.00
> 353 LHW 1,200.00 1,200.00
> 12.00 12.00 180.00 180.00
> 354 DISPENSER 2,500.00 2,500.00
> 1.00 1.00 15.00 15.00
> 355 CLEANER 1,500.00 1,500.00
> 1.00 1.00 15.00 15.00
> 356 GUARD 2,000.00 2,000.00
> 1.00 1.00 15.00 15.00
> 357 OTHER 0.00
> 0.00 0.00
> 358 TOTAL 17,200.00 5,000.00 22,200.00
> 5.00 13.00 18.00 75.00 190.00 265.00
> 359
> 360 SALARY ESCALATION PERCENTAGE 10.00
> 361
> 362 BUDGET/MONTH/BHU AMOUNT
> 363
> 364 NON-SALARY BUDGET % OF REQUIRED 50.00 EXISTING
> 365 NON-SALARY BUDGET% OF REQUIRED 85.00 TARGET
> 366 COSTS ESCALATION BUDGET ITEMS % 13.00
> 367
> 368 REQUIREMENT
> 369 REPAIRS AND MAINTENANCE
> 370 CIVIL 2,000.00
> 371 EQUIPMENT 6,000.00
> 372 FURNITURE 2,000.00
> 373 TRANSPORT 3,000.00
> 374 OTHER 500.00
> 375 SUB-TOTAL 13,500.00
> 376
> 377 TA/DA 100.00
> 378
> 379 UTILITIES
> 380 ELECTRICITY 250.00
> 381 HOT/COLD 0.00
> 382 GAS 200.00
> 383 WATER 50.00
> 384 TELEPHONE 500.00
> 385 SUB-TOTAL 1,000.00
> 386
> 387 POL 2,000.00
> 388
> 389 STATIONERY 100.00
> 390 POSTAGE 50.00
> 391 PRINTING 300.00
> 392 PUBLICATIONS 0.00
> 393 NEWSPAPERS 0.00
> 394 OTHER 100.00
> 395
> 396 UNIFORMS & LIVERIES 100.00
> 397
> 398 RENT 0.00
> 399
> 400 NOS. OF PATIENTS PER/DAY/BHU ON WHICH MEDICINES ARE BASE 25.00
> 401 EXISTING TARGET
> 402 MEDICINES PROVIDED % OF REQUIRED 50.00 85.00
> 403 COST ESCALATION MEDICINES % 13.00
> 404
> 405 OPTIMUM
> -----------------------EXISTING----------------TARGET----------------
> 406 MEDICINES QTY/MONTH QTY QTY RATE
> COST QTY RATE COST UNITS
> 407 ORS 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 PACKETS
> 408 COTRIMAXAZOLE 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 TABLETS
> 409 COTRIMAXAZOLE SYRUP 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 BOTTLE
> 410 CHLOROQUINE 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 TABLETS
> 411 PRIMAQUINE 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 TABLETS
> 412 IRON 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 TABLETS
> 413 FOLATE 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 TABLETS
> 414 STREPTOMYCIN 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 VIAL
> 415 ISONIAZID (INH) 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 TABLET
> 416 INH+TB1 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 TABLET
> 417 ZIEHL-NIELSEN 5.00 2.50 2.00
> 5.00 4.25 2.26 9.61 BOTTLE
> 418 12.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 419 13.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 420 14.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 421 15.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 422 16.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 423 17.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 424 18.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 425 19.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 426 20.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 427 21.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 428 22.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 429 23.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 430 24.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 431 25.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 432 26.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 433 27.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 434 28.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 435 29.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 436 30.00 0.00 0.00 2.00
> 0.00 0.00 2.26 0.00
> 437 TOTAL
> 55.00 ******
> 438
> 439 COST OF MEDICINES PER PATIENT
> 2.20 4.23
> 440 COST RECOVERY RS. PER PATIENT
> 2.00 2.00
> 441 COST RECOVERY PERCENTAGE
> 90.91 47.32
> 442 EXISTING EXISTING
> TARGET TARGET
> 443 EPI QUANTITIES/CHILD QTY RATE COST
> RATE COST
> 444 DPT1, DPT2, DPT3
|
