Message-ID: <199706081438.TAA25161@isb.compol.com> Date: Sun, 8 Jun 1997 19:30:31 +0500 From: Riaz Khan <mailto:rkhan@ISB.COMPOL.COM> Subject: PLANNING FOR PRIMARY HEALTH AND POPULATION To: mailto:DEVEL-L@AMERICAN.EDU
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 1.00 10.00 10.00 11.50 115.00 445 MEASLES 1.00 10.00 10.00 11.50 115.00 446 POLIO 1, POLIO 2, POLIO 3 1.00 10.00 10.00 11.50 115.00 447 BCG 1.00 10.00 10.00 11.50 115.00 448 DT 1.00 10.00 10.00 11.50 115.00 449 TT 1.00 10.00 10.00 11.50 115.00 450 1 0.00 0.00 0.00 451 2 0.00 0.00 0.00 452 TOTAL 60.00 690.00 453 EXISTING TARGET 454 COST ESCALATION EPI ITEMS % 15.00 455 COST OF EPI COVERAGE PER PATIENT 60.00 456 COST RECOVERY RS./ PATIENT 2.00 2.00 457 COST RECOVERY PERCENTAGE 3.33 458 EXISTING EXISTING TARGET TARGET 459 CONTRACEPTIVE QTY/USER/YEAR QTY RATE COST RATE COST 460 IUD 1.00 25.00 25.00 28.25 28.25 461 PILLS 200.00 0.25 50.00 0.28 56.50 462 INJECTIBLES 12.00 5.00 60.00 5.65 67.80 463 LIGATION 1.00 500.00 500.00 565.00 565.00 464 CONDOMS 120.00 0.25 30.00 0.28 33.90 465 OTHER 0.00 0.00 0.00 0.00 0.00 466 TOTAL 665.00 751.45 467 EXISTING TARGET 468 COST ESCALATION CONTRACEPTIVE- % 13.00 469 COST POP. COVERAGE/ PATIENT/YEAR 133.00 150.29 470 COST RECOVERY RS./PATIENT 2.00 2.00 471 COST RECOVERY PERCENTAGE 1.50 1.33 472 473 OVERHEAD COST DHO AND ABOVE 474 EXISTING AS A PERCENTAGE 50.00 30.00 475 476 OVERHEAD COST EPI AND ABOVE 477 EXISTING AS A PERCENTAGE 50.00 30.00 478 479 OVERHEAD COST POPULATION 480 EXISTING AS A PERCENTAGE 50.00 30.00 481 482 DEPRECIATION # YEARS 483 CIVIL 20.00 484 EQUIPMENT 5.00 485 FURNITURE 5.00 486 TRANSPORT 12.00 487 OTHERS 10.00 488 489 DEVELOPMENT COST/BHU 490 CIVIL ************ 491 EQUIPMENT 200,000.00 492 FURNITURE 100,000.00 493 TRANSPORT 400,000.00 494 OTHERS 20,000.00 495 TOTAL ************ 496 497 -----------------% WITH----------------- 498 AMOUNT EXISTING TARGET 499 COST OF ELECTRICITY PROVISION 30,000.00 80.00 95.00 500 COST OF MAJOR REPAIRS 100,000.00 80.00 95.00 501 COST OF WATER PROVISION 30,000.00 80.00 95.00 502 COST OF TELEPHONE PROVISION 6,000.00 80.00 95.00 503 COST OF ROAD ACCESS 500,000.00 80.00 95.00 504 COST OF GAS PROVISION 20,000.00 80.00 95.00 505 COST OF TRANSPORT PROVISION 400,000.00 80.00 95.00 506 507 COST ESCALATION DEVELOPMENT % 13.00 508 509 MAX TRAININGS/YEAR EXISTING TARGET 510 LHV 500.00 500.00 511 LHW 2,000.00 2,000.00 512 AVE. COST (RS.)/TRAINING 1,000.00 1,000.00 513 NOS. REFRESHER COURSES /STAFF 2.00 2.00 514 515 NOS. 516 MAX CONSTRUCTION BHU/YEAR 50.00 50.00 517 518 PATIENTS/DAY/BHU 519 SICKNESS PER PATIENT/YEAR 2.00 2.00 520 PATIENTS/DAY % OF OPTIMUM 50.00 85.00 521 522 523 PATIENTS/DAY/BHU OPTIMUM EXISTING TARGET 524 MALE 7.00 3.50 5.95 525 FEMALE 18.00 9.00 15.30 526 SUBTOTAL 25.00 12.50 21.25 527 PERCENTAGE OF PATIENTS CHILDREN 40.00 40.00 40.00 528 PERCENTAGE OF PATIENT REFFERED 15.00 15.00 15.00 529 CHILDREN PATIENTS 10.00 5.00 8.50 530 REFERRAL PATIENTS 3.75 1.88 3.19 531 532 NOS. WORKING DAYS/YEAR 200.00 250.00 533 534 AREA AND POPULATION DATA 535 536 TOTAL AREA (SQ. KM) 908.00 537 PERCENT RURAL AREA 60.00 538 RURAL AREA (SQ. KM) 544.80 539 URBAN AREA (SQ. KM) 363.20 540 POPULATION TOTAL 669,092.00 541 PERCENT RURAL POPULATION 37.47 542 POPULATION RURAL 250,700.01 543 POPULATION URBAN 418,391.99 544 POPULATION DENSITY (RURAL) 460.2 /SQ. KM 545 POPULATION DENSITY (URBAN) 1152.0 /SQ. KM 546 POPULATION DENSITY (TOTAL) 736.9 /SQ. KM 547 # PERSONS/HOUSEHOLD 17.00 548 549 LADY HEALTH WORKER'S DETAILS EXISTING TARGET 550 AREA COVERED/BHU (SQ. KM) 48.00 48.00 551 AREA BY LHW SQ. KM/LHW 4.00 4.00 552 #LHW REQ. /BHU BASED ON AREA 12.00 12.00 553 # PERSONS/LWH 1840.7 1840.7 554 # HOUSEHOLDS/LHW 108.3 108.3 555 556 STANDARD POPULATION EXISTING TARGET 557 EXPECTED PREGNANCIES % 4.50 3.50 HMIS 558 EXPECTED BIRTHS % 4.00 3.50 HMIS 559 CHILD BEARING AGE (15-49) % 21.00 21.00 HMIS 560 INFANT MORTALITY/1000 BIRTH-RURAL 108.00 100.00 PIHS 561 IMMUNIZATION RATES 54.00 64.00 PIHS 562 MATERNAL MORTALITY/100,000 BIRTHS 650.00 600.00 PIHS 563 % PREG. WOMEN RECD. (T. TOXOID) 24.00 30.00 PIHS 564 MEAN NOS. OF CHILDREN BORN (15-4 3.00 3.00 PIHS 565 TOTAL FERTILITY RATE (15-49) 6.20 6.20 PIHS 566 567 EXISTING TARGET 568 CONTRACEPTIVE PREVAL. RATE 10.00 15.00 PIHS 569 PERCENTAGE OF USERS 570 IUD USERS 18.00 18.00 PIHS 571 PILLS 10.00 10.00 PIHS 572 INJECTIBLES 14.00 14.00 PIHS 573 LIGATION 37.00 37.00 PIHS 574 CONDOMS 9.00 9.00 PIHS 575 OTHER 12.00 12.00 PIHS 576 TOTAL 100.00 100.00 577 578 579 580 FACILITIES CHARACTERISTICS EXISTING TARGET 581 582 BHUS CHARGING FEE - MEDICINES % 66.00 75.00 PIHS 583 NO. OF HOURS DR. AVAILABLE/WEEK 32.00 32.00 PIHS 584 STANDARD WORKING HOURS/ WEEK 34.00 34.00 PIHS 585 586 TYPE OF ILLNESS SUFFERED PERCENT PERCENT 587 ASTHMA 2.50 2.50 PIHS 588 COLD 3.50 3.50 PIHS 589 COUGH 3.60 3.60 PIHS 590 DIABETICS 1.90 1.90 PIHS 591 FEVER 30.50 30.50 PIHS 592 HEART DISEASE 3.20 3.20 PIHS 593 INFLUENZA 2.60 2.60 PIHS 594 MALARIA 4.70 4.70 PIHS 595 RHEUMATISM 7.40 7.40 PIHS 596 STOMACH ACHE 4.10 4.10 PIHS 597 OTHERS 36.00 36.00 PIHS 598 TOTAL 100.00 100.00