Purchase Review Oktober 2018 Ppt.ppt

Monthly Purchase Review Periode: January 2018 s/d October 2018 Date: 5 Oktober 2018 Local Prepared By : Ruben Import Prepared By : Cindy

1. Local Purchase: MTD & YTD 400,000,000

1. Pembelian MTD MGI & PM : Rp. 1,480,204,793 YTD MGI & PM : Rp. 4,384,444,718 2. Informasi lain / kendala yang perlu diketahui

350,000,000 300,000,000 250,000,000 200,000,000

MGI Pusat Marine

150,000,000

Total

100,000,000 50,000,000 Jan No.

Desc

1

MGI

2

Pusat Marine

4

Feb

Jan

Mar

Apr

Feb

May

Jun

Mar

Jul

Aug

Apr

Sep

Oct May

Nov

Dec Jun

Jul

Aug

Sep

Oct

Nov

Dec

Total

79,236,334

193,905,776

131,191,023

182,931,770

55,678,901

222,819,948

74,110,904

32,864,558

106,427,501

609,517,143

1,688,683,854

277,242,100

183,359,000

42,705,000

106,253,400

368,446,624

133,089,090

302,682,900

183,996,500

227,298,600

870,687,650

2,695,760,864

% MGI

22%

51%

75%

63%

13%

63%

20%

15%

32%

41%

38%

5

% Pusat Marine

78%

49%

25%

37%

87%

37%

80%

85%

68%

59%

-

-

62%

6

% Total

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

0%

0%

100%

Import Purchase: MTD & YTD 1,400,000,000

MGI

1,200,000,000

1. Pembelian YTD: IDR 6,019,130,832.50

1,000,000,000 800,000,000

MGI

600,000,000 400,000,000 200,000,000 Jan

No.

Desc

1

MGI

2

% MGI

Feb

Mar

Jan

Apr

May

Jun

Feb

715,575,000 12%

Jul

Aug

Mar

344,488,970 6%

Sep

Oct

Nov

Apr

1,276,259,115 21%

Dec

May

350,285,925 6%

225,064,360 4%

Jun

Jul

Aug

Sep

Oct

494,475,955

242,066,335

1,333,211,873

378,978,565

658,724,735

8%

4%

22%

6%

Nov Dec

11%

0%

Total

6,019,130,833 0%

100%

Rekap Total No. Divisi

Jan Rp

Feb %

Rp

Mar %

Rp

Apr %

Rp

Mei %

Rp

Juni %

Rp

Jul %

2 PM Local

79,236,334 7% 193,905,776 27% 131,191,023 9% 182,931,770 29% 55,678,901 9% 222,819,948 26% 277,242,100 26% 183,359,000 25% 42,705,000 3% 106,253,400 17% 368,446,624 57% 133,089,090 16%

3 IMPORT

715,575,000 67% 344,488,970 48% 1,276,259,115 88% 350,285,925 55% 225,064,360 35%

1 MGI Local

4 Total

494,475,955 58%

1,072,053,434 100% 721,753,746 100% 1,450,155,138 100% 639,471,095 100% 649,189,885 100% 850,384,993 100%

Rp

Aug %

Rp

74,110,904 12% 32,864,559 302,682,900 49% 183,996,500

Sep %

Rp

Oct %

Rp

106,427,501 15% IDR 609,517,151.00 12% 227,298,600 32% IDR 870,687,650.00 242,066,335 39% 1,333,211,873 86% IDR 378,978,565.00 53% IDR 658,724,735.00 618,860,139 100% 1,550,072,931 100% IDR 712,704,666.00 IDR 2,138,929,536.00 2%

%

28% 41% 31%

2. Kontribusi 5 Supplier terbesar

PM :

MGI :

Note: Silakan gunakan data dari File “Purchase Review”

3. Data Import by Supplier 4. Data ETD & ETA import 5. Outstanding Invoice dan biaya freight, PIB, dll yang sehubungan • Note: Silakan gunakan data dari File “Purchase Review”

IMPORT DATA BY SUPPLIER (Invoice) No.

Supplier

Jan

Nama

Jml (Rp.)

Feb %

Jml (Rp.)

Mar %

Jml (Rp.)

Apr %

Jml (Rp.)

May %

Jml (Rp.)

Jun %

Jml (Rp.)

Jul %

Jml (Rp.)

Aug %

Jml (Rp.)

Sep %

Jml (Rp.)

Oct %

Jml (Rp.)

Nov %

Jml (Rp.)

1 Hydrodynamic 715,575,000 100% 2 Fischer Panda

38%

3 Polyform

123,316,265 446,159,200

212,947,000

35%

106,876,455 22%

IDR 458,992,860.00

62% 29%

6 Luxfer

464,828,675

36%

%

905,152,060 600,546,500

IDR 226,969,660

65%

8 Winner Kayak

94,665,860 42%

9 Mavimare

90,712,000 40%

10 Tan Ban Yau

39,686,500 18%

159,053,835

66%

83,012,500

34%

11 Amos 12 Seapro Tw 13 Exquis 14 Dicapac 715,575,000 100%

34.4%

387,599,500 78% 365,271,240

Total

Jml (Rp.)

361,734,690

35%

5 AAA 7 TMC

%

Total 715,575,000

131,541,970

4 Luxon

Dec

344,488,970 100% 1,276,259,115 100% 350,285,925 100% 225,064,360 100% 494,475,955 100% 242,066,335

7,929,905.00

0.6% IDR 378,978,565.00 100%

752,179,710

IDR 114,824,000.00 IDR 156,568,910.00

17%

579,652,675

24%

542,592,405 177,678,360

IDR 290,299,965.00

44%

381,011,965 39,686,500

IDR IDR IDR IDR 34% IDR

1,878,257.50 550,380,850.00 129,890,000.00 184,140,000.00 1,333,211,872.50

0.1% 41.3%

IDR 4,689,060.00 IDR 92,342,800.00

1%

6,567,318

14%

642,723,650

9.7%

129,890,000

13.8%

184,140,000

100%

100% IDR 658,724,735.00

100%

6,019,130,833

IMPORT DATA BY DATE (PRICE ARE LANDED COST) Supplier

No.

Nama

Jan Jml (Rp.)

Feb %

Jml (Rp.)

Mar %

Jml (Rp.)

Apr %

Jml (Rp.)

1

Hydrodynamic

IDR 696,733,660.00

61%

2

Fischer Panda

IDR 142,396,723.20

13%

3 4 5

AAA

6

Luxfer

7

TMC

8

Winner Kayak IDR 436,653,261.40

9

Mavimare

May %

Jml (Rp.)

Jun %

Jml (Rp.)

IDR 138,285,720.00

17%

Polyform

IDR 478,148,159.80

58%

Luxon

IDR 214,402,125.00

26%

IDR 619,125,653.11

37%

IDR

IDR 203,019,018.84 IDR 991,076,516.62 11%

0%

12 IST

IDR 452,278,256.00

27%

0%

13 Supratechnic

IDR 828,506,042.41

14 Dicapac 100% IDR 1,819,582,559.03

%

Jml (Rp.)

Sep %

Jml (Rp.)

Oct %

Jml (Rp.)

9% 0%

IDR 491,426,802.00

82%

IDR 108,964,591.00

18%

100%

IDR 385,380,687.29

30%

IDR 256,554,732.66

20%

IDR

IDR 181,623,726.20 IDR 93,954,710.00

IDR 84,189,456.10

7%

IDR

4%

52,258,587.00

5,283,279.10

3% IDR 175,029,202.30 97%

100%

IDR

2,255,606.63

46% IDR 196,465,685.00

IDR 1,686,253,757.51

Aug

384,483,025.00

0% IDR 178,196,587.00

Jml (Rp.) IDR 120,650,694.00

54%

11 Amos

%

9%

26%

10 Tan Ban Yau

Total

98,334,350.95

Jul

100% IDR 1,133,930,419.15

17% 100% IDR 203,019,018.84

100% IDR 830,836,004.80

100% IDR 600,391,393.00

100% IDR 1,283,517,182.05

100% IDR 93,954,710.00

IDR 186,907,005.30

100% IDR 177,284,808.93

%

Total

IDR 696,733,660.00 IDR 401,333,137.20 IDR 478,148,159.80 IDR 598,885,150.00 99% IDR 1,283,153,172.75 IDR 491,426,802.00 IDR 641,197,477.70 IDR 639,572,562.40 IDR 1,075,265,972.72 IDR 52,258,587.00 1% IDR 180,452,193.63 IDR 452,278,256.00 IDR 828,506,042.41 IDR 196,465,685.00 100% IDR 8,015,676,858.61

8.7% 5.0% 6.0% 7.5% 16.0% 6.1% 8.0% 8.0% 13.4% 0.7% 2.3% 5.6% 10.3% 2.5%

DATA ETA & ETD Skedul Shipment Import (ETD-ETA) POLYFORM ETD 13-Oct ETA 19-Nov IST / AAA ETD 5-Nov ETA 13-Nov DICAPAC ETD 10-Nov ETA 19-Nov

Planning Pembayaran Import November No.

Supplier (Inv Number)

Nominal

Rupiah

Est. Payment Time

1 TMC (TY-180724I)

$

10,101.22

Rp

151,518,300.00

End of November

2 Mavimare

€

16,519.92

Rp

280,838,640.00

ASAP

3 LUXFER

SGD 10,214.60

Rp

112,360,600.00

ASAP

4 AAA

$

12,535.31

Rp

188,029,650.00

ASAP

5 Exquis

$

5,866.00

Rp

87,990,000.00

Early December

$

3,000.00

Rp

45,000,000.00

Early December

Rp

865,737,190.00

6 IST Balance

6. Stock Plan Import • TBY (Rule / Ritchie) • Simrad

7. Summary - KPI • Insert latest KPI’s result • Update KPI terakhir berdasarkan hasil terkini • Note: gunakan file KPI

Review KPI 1. Penambahan Supplier baru ( Buat database supplier) 2. Kendala yang dihadapi dalam penyediaan barang apabila tidak /kurang bisa memenuhi didalam KPI 3. Kendala pemberian info harga dan stock sesuai permintaan sales

8. Others • Masukkan aktivitas kompetitor bila ada • Perkembangan produk/pasar • Dsb.

NEXT REVIEW: Tuesday, 11 December 2018