01 Draft Das Fiper 2019 Rsia Bj V.2.xlsx

  • Uploaded by: arie susanto
  • 0
  • 0
  • June 2020
  • PDF

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 01 Draft Das Fiper 2019 Rsia Bj V.2.xlsx as PDF for free.

More details

  • Words: 1,528
  • Pages: 26
RSIA BUNDA JAKARTA A. RAWAT JALAN A.1. POLIKLINIK A.1.1. POLIKLINIK (RP) A.1.1.1. POLI C a CASH b EDC c ASURANSI d PIUTANG KARY e BIAYA KARY f DISCOUNT PROMO

27/12/2018

28/12/2018

29/12/2018

30/12/2018

31/12/2018

1/1/2019

SUM A.1.1.1.

6,904,820 60,453,480 14,892,800 6,000 240,000 82,497,100

6,884,210 51,448,810 22,684,880 285,000 81,302,900

6,433,160 59,537,536 27,482,904 50,000 93,503,600

1,799,200 21,957,100 7,090,600 50,000 30,896,900

855,600 21,494,600 8,816,800 200,000 31,367,000

2,270,500 2,270,500

SUM A.1.1.2.

438,600 2,738,300 4,872,100 8,049,000

1,258,000 2,602,200 1,472,000 5,332,200

1,117,100 3,445,200 1,018,800 5,581,100

957,320 3,635,200 4,346,480 8,939,000

128,420 523,500 663,780 1,315,700

1,786,100 5,970,080 2,482,220 10,238,400

SUM A.1.1.3.

360,000 13,759,050 3,643,650 17,762,700

1,232,800 17,189,600 5,009,000 23,431,400

720,000 15,287,685 8,362,515 24,370,200

-

426,000 7,909,880 3,321,020 11,656,900

-

1,075,600 38,910,500 7,438,800

3,035,900 27,015,200 5,473,100

8,961,200 56,226,075 16,738,125

-

1,440,000 4,322,040 2,069,260

-

A.1.1.2. POLI C - UGD a CASH b EDC c ASURANSI d PIUTANG KARY e BIAYA KARY f DISCOUNT PROMO A.1.1.3. POLI D a CASH b EDC c ASURANSI d PIUTANG KARY e BIAYA KARY f DISCOUNT PROMO A.1.1.4. POLI ADVANCE a CASH b EDC c ASURANSI

d PIUTANG KARY e BIAYA KARY f DISCOUNT PROMO SUM A.1.1.4. SUM A.1.1.

531,200 47,956,100 156,264,900

35,524,200 145,590,700

50,000 81,975,400 205,430,300

39,835,900

7,831,300 52,170,900

12,508,900

SUM A.1.2.

145 17 23 44 229

133 16 33 48 230

170 12 38 86 306

44 25 69

51 6 30 21 108

2 30 32

SUM A.2.1.1.

3,488,250 44,798,800 18,028,950 285,800 201,200 66,803,000

5,421,459 43,464,920 14,939,460 781,840 64,607,679

7,376,340 36,351,040 17,667,180 1,489,700 62,884,260

1,797,900 14,175,060 7,951,000 931,500 24,855,460

2,231,000 13,480,300 4,837,000 1,842,423 22,390,723

1,951,700 7,755,100 4,191,900 557,200 14,455,900

SUM A.2.1.2.

501,200 1,466,500 276,800 2,244,500

635,500 3,715,900 2,042,600 6,394,000

274,400 2,145,900 2,574,300 4,994,600

A.1.2. POLIKLINIK (VOL) A.1.2.1. POLI C A.1.2.2. POLI C -UGD A.1.2.3. POLI D A.1.2.4. POLI ADVANCE A.2. FARMASI RAWAT JALAN A.2.1. FARMASI RAWAT JALAN (RP) A.2.1.1. APOTEK - C CASH EDC ASURANSI PIUTANG KARY BIAYA KARY DISCOUNT PROMO A.2.1.2. APOTEK - D CASH EDC ASURANSI PIUTANG KARY BIAYA KARY DISCOUNT PROMO A.2.1.3. APOTEK - ADVANCE

-

787,600 4,143,810 2,054,000 6,985,410

-

A.2.1.4. APOTEK - BIC LT.3 CASH EDC ASURANSI PIUTANG KARY BIAYA KARY DISCOUNT PROMO

4,457,400 41,380,700 2,085,000 47,923,100 116,970,600

9,048,200 63,817,600 3,329,000 76,194,800 147,196,479

6,719,800 94,312,200 10,166,400 111,198,400 179,077,260

978,100 10,032,100 11,010,200 35,865,660

4,139,037 21,427,500 10,547,763 1,630,200 37,744,500 67,120,633

451,900 14,720,100 696,900 15,868,900 30,324,800

147 13

155 20

165 25

88 -

75 29

59 -

47 207

65 240

62 252

16 104

32 136

18 77

68,463,500

62,436,500

93,804,000

18,600,000

26,970,500

600,000

SUM A.3.1. A.3.2. DOKTER PRAKTEK RAWAT JALAN (VOL) A.3.2.1. SUM DOKTER PRAKTEK RJ

68,463,500

62,436,500

93,804,000

18,600,000

26,970,500

600,000

200

210

287

59

95

1

SUM A.3.2.

200

210

287

59

95

1

552,000 9,803,000 13,988,000

2,583,000 16,750,000 4,013,000

85,100 29,202,850 7,715,900

11,412,000 1,971,000

594,000 16,467,900 5,675,100

2,299,000 3,150,000 1,105,000

SUM A.2.1.4 SUM A.2.1 A.2.2. FARMASI RAWAT JALAN (VOL) A.2.2.1. APOTEK - C A.2.2.2. APOTEK - D A.2.2.3. APOTEK - ADVANCE A.2.2.4. APOTEK - BIC LT.3 SUM A.2.2. A.3. DOKTER PRAKTEK RAWAT JALAN A.3.1. DOKTER PRAKTEK RAWAT JALAN (RP) A.3.1.1. SUM DOKTER PRAKTEK RJ

A.4. LABORATORIUM RAWAT JALAN A.4.1. LABORATORIUM RAWAT JALAN (RP) A.4.1.1. SUM LAB RJ CASH EDC ASURANSI

PIUTANG KARY BIAYA KARY SUM A.4.1. A.4.2. LABORATORIUM RAWAT JALAN (VOL) A.4.2.1. SUM LAB RJ SUM A.4.2. A.5. PENUNJANG MEDIS RAWAT JALAN A.5.1. PENUNJANG MEDIS RJ (RP) A.5.1.1. USG A.5.1.2. USG Colur Dr.NRY A.5.1.3. USG E10 ADVANCE A.5.1.4. CTG A.5.1.5. INHALASI SUM A.5.1. A.5.2. PENUNJANG MEDIS RJ (VOL) A.5.1.1. USG A.5.1.2. USG Colur Dr.NRY A.5.1.3. USG E10 ADVANCE A.5.1.4. CTG A.5.1.5. INHALASI SUM A.5.2. A.6. BIAYA ADMINISTRASI A.6.1. JASA SARANA POLIKLINIK RJ A.6.1.1. JASA SARANA POLIKLINIK RJ SUM A.6.1. A.7. OUTSTANDING A.7.1. OUTSTANDING (RP)

344,250 24,687,250

23,346,000

106,250 37,110,100

13,383,000

22,737,000

6,554,000

22 22

28 28

35 35

9 9

17 17

8 8

-

-

-

-

-

-

70

-

-

-

-

-

-

-

-

-

-

-

58 10 2 -

A.7.1.1. OUTSTANDING SUM A.7.1.

-

-

-

-

-

-

SUM A.7.2.

14 14

-

-

-

-

-

A.7.2. OUTSTANDING (VOL) A.7.2.1. OUTSTANDING

B.1. TINDAKAN OPERASI B.1.1. TINDAKAN OPERASI (RP) B.1.1.1. LAPAROSCOPY B.1.1.2. ROBOTIC SURGERY B.1.1.3. PERSALINAN ABDOMINAL B.1.1.4. PERSALINAN NORMAL B.1.1.5. OPERASI KHUSUS B.1.1.6. OPERASI BESAR B.1.1.7. OPERASI SEDANG B.1.1.8. OPERASI KECIL B.1.1.9. ODC B.1.2.0. LAIN - LAIN SUM B.1.1. B.1.2. TINDAKAN OPERASI (VOL) B.1.2.1. LAPAROSCOPY B.1.2.2. ROBOTIC SURGERY B.1.2.3. PERSALINAN ABDOMINAL B.1.2.4. PERSALINAN NORMAL B.1.2.5. OPERASI KHUSUS B.1.2.6. OPERASI BESAR B.1.2.7. OPERASI SEDANG B.1.2.8. OPERASI KECIL B.1.2.9. ODC

51,363,375 128,630,075 24,473,800 36,944,125 53,837,225 295,248,600

251,664,750 40,735,425 36,284,625 33,726,175 2,926,700 365,337,675

65,470,875 96,966,675 133,597,875 32,984,600 9,172,825 12,851,975 351,044,825

29,680,425 53,296,625 11,202,675 2,237,700 7,340,000 103,757,425

108,176,375 40,463,025 2,513,600 151,153,000

220,764,125 17,019,075 257,500 238,040,700

1 3 2 1 -

6 1 2 4 4

1 1 3 2 1 5

1 1 1 2

3 1 -

5 1 -

B.1.3.0. LAIN - LAIN

8 15

17

13

2 7

34,584,900

11,477,200

7,607,400

10,006,500

B.2.1.2. RI PERAWATAN ANAK

25,126,600

83,355,300

10,781,400

16,578,300

B.2.1.3. RI PERAWATAN NICU/PICU

38,927,550

129,921,750

34,799,400

160,164,550

B.2.1.4. RI PERAWATAN BAYI

18,642,900

33,094,900

17,263,050

3,710,800

13,540,750

28,570,850

117,281,950 412,530,550

257,849,150 623,186,825

70,451,250 421,496,075

190,460,150 294,217,575

61,086,050 212,239,050

135,284,000 373,324,700

3

2

1

1

-

2

B.2.1.2. RI PERAWATAN ANAK

2

6

2

2

5

4

B.2.1.3. RI PERAWATAN NICU/PICU

1

1

1

1

-

-

B.2.1.4. RI PERAWATAN BAYI

4

6

4

1

3

5

10 25

15 32

8 21

5 12

8 13

11 18

80,080,000 80,080,000

146,113,500 146,113,500

81,303,000 81,303,000

40,910,500 40,910,500

41,983,500 41,983,500

78,625,500 78,625,500

SUM B.1.2. B.2. RAWAT INAP NON TINDAKAN B.2.1. RAWAT INAP NON TINDAKAN (RP) B.2.1.1. RI PERAWATAN DEWASA

SUM B.2.1. SUM B.1.1 + B.2.1. B.2.2. RAWAT INAP NON TINDAKAN (VOL) B.2.1.1. RI PERAWATAN DEWASA

SUM B.2.2. SUM B.1.2 + B.2.2. B.3. DOKTER RAWAT INAP B.3.1. DOKTER RAWAT INAP (RP) B.3.1.1. SUM DOKTER RAWAT INAP SUM B.3.1. B.3.2. DOKTER RAWAT INAP (VOL)

1 5

47,545,300 -

1 7

76,607,400 30,105,750 -

B.4. B.4.1.

B.4.2.

B.5. B.5.1.

B.5.2.

B.6. B.6.1.

B.3.2.1. SUM DOKTER RAWAT INAP SUM B.3.2. LABORATORIUM RAWAT INAP LABORATORIUM RAWAT INAP (RP) B.4.1.1. SUM LAB RI SUM B.4.1. LABORATORIUM RAWAT INAP (VOL) B.4.2.1. SUM LAB RI SUM B.4.2. PENUNJANG MEDIS RAWAT INAP PENUNJANG MEDIS RI (RP) A.5.1.1. ALAT LAPAROSCOPY A.5.1.2. ALAT ROBOTIC SURGERY A.5.1.3. ALAT STERIL A.5.1.4. ALAT CPAP A.5.1.5. ALAT VENTILATOR SUM B.5.1. PENUNJANG MEDIS RI (VOL) A.5.1.1. ALAT LAPAROSCOPY A.5.1.2. ALAT ROBOTIC SURGERY A.5.1.3. ALAT STERIL A.5.1.4. ALAT C PAP A.5.1.5. ALAT VENTILATOR SUM B.5.2. BIAYA ADMINISTRASI BURS RI B.6.1.1. BURS RI SUM B.6.1.

114 114

133 133

84 84

71 71

65 65

105 105

16,097,700 16,097,700

31,981,000 31,981,000

12,893,800 12,893,800

11,437,400 11,437,400

10,859,200 10,859,200

18,872,300 18,872,300

22 22

26 26

16 16

9 9

11 11

14 14

5,000,000 11,879,000 2,600,000 19,479,000

13,503,000 13,503,000

5,000,000 7,100,000 9,800,000 1,000,000 22,900,000

3,500,000 7,000,000 10,500,000

5,600,000 5,600,000

7,700,000 7,700,000

1 12 1 14

12 12

1 1 9 2 13

3 14 17

4 4

6 6

23,371,400 23,371,400

35,163,800 35,163,800

23,839,000 23,839,000

16,653,700 16,653,700

11,986,900 11,986,900

21,158,000 21,158,000

2/1/2019

3/1/2019

2,770,900 57,555,850 7,758,250 250,000 68,335,000

8,435,900 97,493,394 25,030,506 135,000 131,094,800

601,500 3,219,400 807,400 4,628,300

1,406,450 1,270,350 2,676,800

1,150,000 15,326,480 8,437,220 24,913,700

1,195,850 23,585,600 5,541,450 50,000 30,372,900

2,728,100 26,823,740 9,606,660

3,322,600 25,368,105 2,725,595

39,158,500 137,035,500

50,000 31,466,300 195,610,800

125 13 44 55 237

194 7 51 42 294

5,546,000 34,846,170 5,927,500 391,300 773,100 47,484,070

5,048,800 40,381,950 9,604,050 92,700 55,127,500

1,786,700 2,542,500 3,722,892 8,052,092

1,137,200 3,709,300 3,100,920 7,947,420

7,015,500 47,097,100 3,543,000 1,917,400 59,573,000 115,109,162

6,763,900 58,506,000 254,000 65,523,900 128,598,820

141 36

148 37

60 237

185

69,595,500 69,595,500

-

219 219

1,507,800 11,861,000 3,244,000

-

1,452,650 18,065,450

-

22 22

-

9,625,000 3,300,000 560,000 1,340,500 14,825,500

-

38 11 4 7 60

-

8,280,000 8,280,000

-

-

-

11 11

18 18

26,785,600 9,822,800 2,671,200 3,137,700 42,417,300 1 2 3

-

1 7

-

29,450,300 7,158,800 4,910,500 41,519,600 83,936,900

-

3 1 1 5 12

-

55,272,000 55,272,000

-

65 65

-

2,685,100 2,685,100

-

5 5

-

1,106,000 1,106,000

-

1 1

-

4,751,200 4,751,200

L

SUMMARY REPORT CASH OUT OPERATING

DESEMBER CASH IN OPERATIONAL

01/12/2018

02/12/2018

03/12/2018

1. CASH - Cash Tunai - EDC 2. ACCOUNT RECEIVABLE - Account Receivable 3. Total Cash Out

0

0

0

04/12/2018

05/12/2018

0

06/12/2018

0

07/12/2018

0

08/12/2018

0

09/12/2018

0

0

10/12/2018

11/12/2018

0

12/12/2018

0

13/12/2018

0

14/12/2018

0

15/12/2018

0

0

16/12/2018

17/12/2018

0

18/12/2018

0

19/12/2018

0

20/12/2018

0

21/12/2018

0

0

22/12/2018

23/12/2018

0

24/12/2018

0

25/12/2018

0

26/12/2018

0

27/12/2018

0

0

28/12/2018

29/12/2018

0

30/12/2018

0

31/12/2018

0

0

SUMMARY REPORT CASH OUT OPERATING

DESEMBER CASH OUT OPERATIONAL 1. Fixed Operational Cost - Biaya Kepegawaian - Biaya Umum & Rutin Kantor - Biaya Pemeliharaan & Perbaikan - Biaya Rumah Tangga

01/12/2018

02/12/2018

2. Variable Cost - Beban Dokter - Beban Pajak - Beban Obat & Alkes - Beban Marketing - Beban Laboratorium - Lain-Lain 3. Total Cash Out

0

0

03/12/2018

04/12/2018

0

05/12/2018

0

06/12/2018

0

07/12/2018

0

08/12/2018

0

0

09/12/2018

10/12/2018

0

11/12/2018

0

12/12/2018

0

13/12/2018

0

14/12/2018

0

0

15/12/2018

16/12/2018

0

17/12/2018

0

18/12/2018

0

19/12/2018

0

20/12/2018

0

0

21/12/2018

22/12/2018

0

23/12/2018

0

24/12/2018

0

25/12/2018

0

26/12/2018

0

0

27/12/2018

28/12/2018

0

29/12/2018

0

30/12/2018

0

31/12/2018

0

0

Related Documents

Bj
May 2020 19
Bj +data.docx
April 2020 24
Delfarno Final Draft 2019
October 2019 18
Bj Plan
October 2019 22

More Documents from ""