Tugas Pengadaan Mega.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Tugas Pengadaan Mega.xlsx as PDF for free.
More details
- Words: 1,242
- Pages: 10
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
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
Related Documents
Tugas Pengadaan Mega.xlsx
November 2019 14
Pengadaan Material
October 2019 24
Dept. Pengadaan
June 2020 21
Pengadaan Bm.docx
June 2020 10
Pengadaan Eletronik.pdf
October 2019 20
More Documents from "Franky Sitorus"
Bab Iii Scabies Dan Kurap Perbaikan.docx
November 2019 7
Tugas Pengadaan Mega.xlsx
November 2019 14
Therapeutic Drug Monitoring Part 2.pdf
November 2019 10
Sutiah.pdf
November 2019 3
Prin 1.docx
November 2019 14