Tugas Pengadaan Mega.xlsx

no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 NO 1 2 3 4 5 7 8 9

NAMA OBAT TABLET asetilsistein allupurinol 100 mg allupurinol 300 mg alprazolam 1 mg alpentin 100 alpentin 300 ambroxol aminophylin 200 mg amlodipine 5 mg amlodipine 10 mg amoxicillin asam mefenamat bledstop bisoprolol 5 mg candesartan 16 mg cefadroxil 500 mg domperidone doxyciklin 100 mg BAHAN HABIS PAKAI ALKOHOL 70% ALKOHOL SWAB (K.F) KERTAS EKG 210 X 30 CM COUTER LINE KABEL PLATE COUNTER GAMMAEX 7,5 GAMMEX 7 REMEDI GLOVE NON STERL M REMEDI GLOVE NON STERL S

masuk 0 0 0 0 6000 0 0 0 0 0 0 0 3000 0 2400 0

masuk 100 50 400 320

juni keluar 2000 500 0 5500 2000 1000 3700 100 4920 5430 300 7700 1100 1400 810 4500 3300 0 AGUSTUS keluar 85 3400 0 150 160 720 800 8800 21300

sisa 18700 2200 3200 6900 4550 350 5700 3400 26430 52170 6200 68700 2000 3600 1590 15600 14700 2500

sisa 100 3500 50 250 240 360 1120 42700 229000

masuk

juli keluar 4500 500 100 6600 2050 350 3700 300 3540 1920 400 7400 2000 1300 0 5700 4300 100

SEPTEMBER masuk keluar 100 3500 10 170 105 1200 360 2400 1120 5900 25100

juli sisa 14200 1700 3100 300 2500 0 2000 3100 22890 50250 5800 61300 0 2300 1590 9900 10400 2400

masuk

0

5000

SEPTEMBER sisa 0 0 40 80 135 1200 2400 36800 203900

masuk 150 10000 50 220

agustus keluar 4100 700 500 300 2500 0 2000 700 4830 3960 1000 9000 1900 500 1590 4500 3100 500 OKTOBER keluar 76 13 220 120 1200 280 7900 19000

sisa 10100 1000 2600 0 0 0 0 2400 18060 46290 4800 52300 3100 1800 0 5400 7300 1900

sisa 74 10000 77 80 15 0 2120 28900 184900

HNA Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp Rp

431 127 360 883 1,270 6,300 154 138 315 563 275 194 450 1,109 5,568 550 392 477

HARGA HNA + PPN 10% Rp 474.10 Rp 139.70 Rp 396.00 Rp 971.30 Rp 1,397.00 Rp 6,930.00 Rp 169.40 Rp 151.80 Rp 346.50 Rp 619.30 Rp 302.50 Rp 213.40 Rp 495.00 Rp 1,219.90 Rp 6,124.80 Rp 605.00 Rp 431.20 Rp 524.70

HNA + PPN 1848 1232

24200 24200

AU 3533 567 200 4133 2183 450 3133 367 4430 3770 567 8033 1667 1067 800 4900 3567 200

AU 87 3450 8 180 128 760 733 7533.3333333 21800

BS

LT

SS

SISA

RKO

353 57 20 413 218 45 313 37 443 377 57 803 167 107 80 490 357 20

883 142 50 1033 546 113 783 92 1108 943 142 2008 417 267 200 1225 892 50

707 113 40 827 437 90 627 73 886 754 113 1607 333 213 160 980 713 40

4063 652 230 4753 2511 518 3603 422 5095 4336 652 9238 1917 1227 920 5635 4102 230

1413 227 80 1653 873 180 1253 147 1772 1508 227 3213 667 427 320 1960 1427 80

BS LT SS SISA RKO 9 22 17 100 35 345 863 690 3968 1380 1 2 2 9 3 18 45 36 207 72 13 32 26 148 51 76 190 152 874 304 73 183 147 843 293 753.33333 1883.3333 1506.6667 8663.333333 3013.3333333 2180 5450 4360 25070 8720

RUMAH SAKIT UMUM DAERAH A.MAKKASAU Jalan Nurussamawati No. 9 Parepare Telp (0421) 21823, Faks (0421) 27643 Kode Pos 91122, Email : [email protected], RENCANA KEBUTUHAN A.1

ECATALOG GENERIK FORNAS

NO

NAMA OBAT 1 Allopurinol tab 100 mg

NAMA DAGANG n/a

SATUAN

VOL 3 BULAN

Tablet

HARGA SATUAN+PPN

227

140

2 Allopurinol tab 300 mg

Tablet

120

396

3 Alprazolam 1 mg

tablet

133,320

184

4 Amilodipin tab 10 mg

Tablet

1,508

619

5 Amilodipin tab 5 mg

Tablet

1,772

347

6 Amoksisillin kaps 500 mg

Tablet

227

303

7 Asam mefenamat kaps 500 mg

Tablet

3,213

213

1,413

474

427

1,220

8 Asetilsistein 200 mg

Tablet

9 Bisoprolol 5 mg

tablet

10 Doksisiklin 100 tab

Tablet

80

525

11 Domperidon tab 10 mg

Tablet

1,427

431

12 Kandesartan tab 16 mg

Tablet

320

6,125

- Tablet

1,960

605

13 Sefadroksil kaps 500 mg

A.2

ECATALOG NONGENERIK FORNAS

NO

NAMA OBAT

NAMA DAGANG

SATUAN

VOL 3 BULAN

HARGA SATUAN+PPN

1 Gabapentin 100 mg

Alpentin 100 mg

Tablet

180

6,930

2 Gabapentin 100 mg

Alpentin 100 mg

Tablet

873

1,397

Total B.1

NON ECATALOG FORNAS

NO

NAMA OBAT 1 Aminopyllin tab 200 mg 2 Metylergometrin tab 0,125 mg

NAMA DAGANG

SATUAN

VOL 3 BULAN

Tablet Tablet

n/a Bledstop

HARGA SATUAN+PPN

147 667

152 495

Total B.2

NON ECATALOG NON FORNAS

NO

NAMA OBAT

NAMA DAGANG

1 Ambroxol tablet

SATUAN Tablet

Total

HARGA

VOL

SATUAN+PPN 1,253

169

) 27643

31,906,171 TOTAL

PRODUSEN 31,712 PT. RAMA EMERALD 47,520 PT.BERNOFARM

24,530,880 PT. MERSI FARMA 933,904 PT. PHARMA LAB 613,998 PT. PROMEDRAHARJO 68,668 PT. PHARMA LAB 685,654 PT. ERRITA PHARMA 669,903 PT. ETERCON 520,897 PT. NOVELL 41,976 PT. INDOFARMA 615,322 PT.NOVAPHARIN 1,959,936 PT.DEXA MEDICA 1,185,800 PT.BERNOFARM 31,906,171

TOTAL

PRODUSEN

1,247,400 PT. ACTAVIS 1,219,581 PT. ACTAVIS 1,219,581

TOTAL

PRODUSEN

22,315

PT.ERELA

330,165

PT.SANBE

352,480

TOTAL 212,258 212,258

PRODUSEN

PT. NOVAPHARIN

RUMAH SAKIT UMUM DAERAH A.MAKKASAU Jalan Nurussamawati No. 9 Parepare Telp (0421) 21823, Faks (0421) 27643 Kode Pos 91122, Email : [email protected], RENCANA KEBUTUHAN

A.3 BAHAN MEDIS HABIS PAKAI e-katalog NO DAFTAR BHP VOLUME 3 BLN 1 Alkohol 70%

SATUAN

35 BTL-1 LTR

HARGA + PPN

Ongkir 15%

21,000

110,250

2 Alkohol Swab 2ply

1,380 box-100

11,000

2,277,000

3 Sarung tangan Dispo M

3,013 Box-100

47,600

21,512,820

4 Sarung tangan Dispo S

8,720 Box-100

47,600

62,260,800

TOTAL A.4 BAHAN MEDIS HABIS PAKAI NON e-katalog NO DAFTAR BHP VOLUME 3 BLN 1 Kertas EKG 210 x 30 cm 2 Sarung tangan steril/Gammex 7 3 Sarung tangan steril/Gammex7,5

SATUAN

3 roll 293 Pasang 304 Pasang

TOTAL

HARGA + PPN

180,000 9,000 9,000

Ongkir 15% 81,000 395,550 410,400

TOTAL 845,250 PT. IGM 17,457,000 PT. KIMIA FARMA 164,931,620 PT. AAM 477,332,800 PT. AAM

660,566,670

TOTAL 540,000 PT. SAMI 2,637,000 PT. SAMI 2,736,000 PT. SAMI

5,913,000

NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

NAMA OBAT aminophylin 200 mg allupurinol 100 mg doxyciklin 100 mg allupurinol 300 mg amoxicillin ambroxol bledstop bisoprolol 5 mg amlodipine 5 mg domperidone asetilsistein asam mefenamat amlodipine 10 mg cefadroxil 500 mg alpentin 100 alpentin 300 alprazolam 1 mg candesartan 16 mg

JUMLAH 147 227 80 120 227 1253 667 427 1772 1427 1413 3213 1508 1960 873 180 1653 320

HARGA 138 127 477 360 275 154 450 1109 315 392 431 194 563 550 1270 6,300 883 5568

BIAYA 20,286 28,829 38,160 43,200 62,425 192,962 300,150 473,543 558,180 559,384 609,003 623,322 849,004 1,078,000 1,108,710 1,134,000 1,459,599 1,781,760 10,920,517

KUMULATIF 20,286 49,115 87,275 130,475 192,900 385,862 686,012 1,159,555 1,717,735 2,277,119 609,003 1,232,325 2,081,329 3,159,329 4,268,039 5,402,039 6,861,638 8,643,398

% BIAYA 0.00 0.00 0.00 0.00 0.01 0.02 0.03 0.04 0.05 0.05 0.06 0.06 0.08 0.10 0.10 0.10 0.13 0.16

% KUMULATIF 0.00 0.06 0.06 0.07 0.07 0.09 0.12 0.16 0.21 0.26 0.06 0.12 0.19 0.29 0.40 0.50 0.63 0.80

KATEGORI A A A A A A A A A A A A A A A A A B

100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0%

KUMULATIF