Draft Purchase Review.xls

  • Uploaded by: Cindy Chandra
  • 0
  • 0
  • May 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 Draft Purchase Review.xls as PDF for free.

More details

  • Words: 837
  • Pages: 14
No.

Divisi

Jan Rp

1 2 3 4

MGI Local PM Local IMPORT Total

79,236,334 277,242,100 356,478,434

Feb % 22% 78% 0% 100%

Rp

193,905,776 183,359,000 377,264,776

Mar % 51% 49% 0% 100%

Rp % 131,191,023 75% 42,705,000 25% 0% 173,896,023 100%

Apr Rp 182,931,770 106,253,400 289,185,170

Apr

Mei % 63% 37% 0% 100%

Rp % 55,678,901 13% 368,446,624 87% 0% 424,125,525 100%

Juni Rp

222,819,948 133,089,090 -

355,909,038

% 63% 37% 0% 100%

TOTAL 865,763,752 1,111,095,214 1,976,858,966

Agt

Sep

-

Okt

-

-

Nov

Des

-

450,000,000 400,000,000 350,000,000 300,000,000 250,000,000 200,000,000 150,000,000 100,000,000 50,000,000 Jan

No. 1 2 3 4 5 6

Desc MGI Pusat Marine Total % MGI % Pusat Marine % Total

Feb

Jan 79,236,334 277,242,100 356,478,434 22% 78% 100%

Mar

Apr

May

Feb 193,905,776 183,359,000 377,264,776 49% 51% 100%

Jun

Jul

Mar 131,191,023 42,705,000 173,896,023 75% 25% 100%

Aug

Sep

Oct

Apr 182,931,770 106,253,400 289,185,170 63% 37% 100%

Nov

Dec

MGI Pusat Marine Total

Sep

Oct

Nov

Dec

May 55,678,901 368,446,624 424,125,525 13% 87% 100%

Jun 222,819,948 133,089,090 355,909,038 63% 37% 100%

Jul Aug Sep Oct Nov Dec

-

-

-

-

-

-

0%

0%

0%

0%

0%

0%

Total 865,763,752 1,111,095,214 1,976,858,966 44% 56% 100%

1,400,000,000

MGI

1,200,000,000 1,000,000,000 800,000,000 600,000,000 400,000,000 200,000,000 Jan

No. 1 2

Desc

Mar

Jan

MGI % MGI

JAN FEB MAR APR MAY JUN JUL

Feb

715,575,000 20%

IDR IDR IDR IDR IDR IDR IDR

715,575,000.00 344,488,970.00 1,276,259,115.00 350,285,925.00 225,064,360.00 494,475,955.00 242,066,335.00

Apr

May

Jun

Feb 344,488,970 9%

Jul

Aug

Mar 1,276,259,115 35%

Sep

Oct

Nov

Apr 350,285,925 10%

Dec

MGI

Oct

Nov

Dec

May 225,064,360 6%

Jun 494,475,955 14%

Jul 242,066,335 7%

Aug Sep Oct Nov Dec 0%

0%

0%

0%

0%

Total 3,648,215,660 100%

Kontribusi 5 Supplier MGI terbesar No. 1 2 3 4 5 6 7 8

Nama

Jan Jml (Rp.)

Sumber Makmur

18,080,000.00

Master Motor

18,000,000.00

Lautan Mas

16,929,000.00

Supratechnic

15,342,362.19

Cash

7,188,790.00

Lain-Lain

3,696,182.00

Total MGI

79,236,334

Feb %

Nama

22% 22% 21% 19% 11% 5%

Jml (Rp.)

North Marine

184,571,957.00

Dunia Marine Internusa

3,750,000.00

PT Anugerah Lubricant

2,389,964.15

Godive

1,257,900.00

Mutiara Fibrindo

909,091.00

Lain-Lain

1,026,864.00

100%

193,905,776.00

% 95% 2% 1.50% 0.60% 0.40% 0.50% 100%

Kontribusi 5 Supplier PM terbesar No.

Nama

Jan Jml (Rp.)

1

Master Selam

2

Cash

80,661,000.00

PD Safety

13,000,000.00

Sumber Makmur

10,230,000.00

3 4 5

Godive

6

Lain-Lain

Total PM

7 8

153,197,000.00

4,634,650.00

Feb %

Nama

Jml (Rp.)

%

55%

PD Safety

84,000,000.00

46%

28%

Guna Logam

40,000,000.00

22%

Sumber Makmur

30,090,000.00

Sea Pearl

11,455,500.00

5% 4% 2%

Inti Marina Netting

15,519,450.00

6%

Lain-Lain

277,242,100

100%

16% 6%

7,081,500.00

4%

10,732,000.00

6%

183,359,000

100%

Mar Nama

Apr Jml (Rp.)

PT Profesional Machinery

74,727,272.72

Supratechnic

47,780,876.78

GT Motor

2,600,000.00

Dunia Marine Internusa

2,537,425.00

Sumber Marine

1,300,000.00

Lain-Lain

2,245,450.00

131,191,023

%

Nama

57% 36% 2.00% 2.00% 1.00% 2.00%

135,704,280.94

Master Selam

15,886,800.00

Hongyi Distributor

7,040,000.00

Pusat Marine

5,736,273.47

North Marine

4,780,618.48

Lain-Lain

13,783,799.00

100%

182,931,770

Mar Nama

Jml (Rp.)

Supratechnic

% 74% 9% 4% 3% 2% 8% 100%

Apr Jml (Rp.)

PD Safety

19,000,000.00

Bpk Diky

9,000,000.00

Master Motor

5,000,000.00

Lautan Mas

2,700,000.00

Baokers

1,900,000.00

Lain-Lain

%

Nama

Jml (Rp.)

%

45%

PD Safety

23,000,000.00

22%

22%

PD Jaya Glass

14,175,000.00

13%

Sumber Makmur

14,050,000.00

Bima Indo Watersport

13,900,000.00

12% 7% 5%

Dunia Marine Internusa

5,105,000.00

2%

Lain-Lain

42,705,000

100%

13% 13%

7,320,000.00

7%

33,808,400.00

32%

106,253,400

100%

May Nama

Jun Jml (Rp.)

North Marine

25,345,454.55

Dunia Marine Internusa

11,916,272.90

Bapak Salman

10,000,000.00

PT Profesional Machniery

2,620,909.16

Mutiara Fibrindo

1,403,319.00

Lain-Lain

4,392,947.00

55,678,901

% 45% 21% 19% 4% 2% 9%

Nama

New Alex Marine

Jml (Rp.) 202,500,000.00 81,000,000.00

PD Safety

41,500,000.00

Sumber Makmur

24,185,000.00

Lain-Lain

163,710,000.00

Supratechnic

30,767,274.93

Loncin Indonesia

6,600,000.00

Daya Pioner International

6,354,909.10

Dunia Marine Internusa

4,123,400.00

Lain-Lain

11,263,987.00

100%

%

Nama

73% 13% 3% 3% 2% 6%

222,819,948 100%

Jun

Umum

Bima Indo Watersport

Jml (Rp.)

PT Anugerah Sukses Marine

May Nama

Jul

3,700,000.00 15,561,624.00

368,446,624

%

Nama

Jul Jml (Rp.)

%

55%

Dunia Marine Internusa

59,014,540.00

44%

22%

Godive

23,964,550.00

18%

Seapearl

13,800,000.00

11%

10%

Nusantara Prima

7,975,000.00

9%

Suka Jaya

5,925,000.00

5%

4%

Lain-Lain

22,410,000.00

17%

6%

100%

6%

133,071,640 100%

Nama

Jul Jml (Rp.)

Jul Jml (Rp.)

%

%

Nama

Aug Jml (Rp.)

Nama

Aug Jml (Rp.)

Sep

Oct

Nov

Dec

Total

Sep

Oct

Nov

Dec

Total

%

%

Import by Supplier No. 1 2 3 4 5 6 7 8 9 10

Supplier Nama Hydrodynamic Fischer Panda Polyform Luxon AAA Luxfer TMC Winner Kayak Mavimare Tan Ban Yau Total

Jan Jml (Rp.) % 715,575,000 100%

Feb Jml (Rp.)

%

131,541,970

38%

212,947,000

Mar Jml (Rp.)

%

Apr Jml (Rp.) 123,316,265

446,159,200

35%

365,271,240 464,828,675

29% 36%

62%

226,969,660

715,575,000 100%

344,488,970

100%

1,276,259,115

100%

350,285,925

Apr %

May Jml (Rp.)

35%

%

Jun Jml (Rp.)

%

106,876,455

22%

387,599,500

78%

65% 94,665,860 90,712,000 39,686,500 100% 225,064,360

42% 40% 18% 100% 494,475,955 100%

Jul Jml (Rp.)

Total %

159,053,835 83,012,500

66% 34%

242,066,335

34%

715,575,000 361,734,690 446,159,200 600,546,500 365,271,240 464,828,675 386,023,495 177,678,360 90,712,000 39,686,500 3,648,215,660

Skedul Shipment Import (ETD-ETA)

Related Documents

Purchase
October 2019 28
Purchase Order.docx
October 2019 40
Purchase Order
May 2020 14
Purchase Order
May 2020 14
Purchase-order.xlsx
April 2020 11

More Documents from "Muhammad Imran"