Copy Of Jse- Asl Weekly Report As Of Nov.26- Dec 1, 2018 (1).xlsx

  • Uploaded by: Kenet Mun Dahunan Clarabal
  • 0
  • 0
  • November 2019
  • 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 Copy Of Jse- Asl Weekly Report As Of Nov.26- Dec 1, 2018 (1).xlsx as PDF for free.

More details

  • Words: 3,292
  • Pages: 52
DRY- SEASON 2018

Territory: MINDANAO 3 Week Until:

Nov. 26- Dec. 1, 2018

Prepared by:

Joven S. Eta

TL / TLT Rey Alisna Mark Neil Micabalo Japhet James Bernas TOTAL

DS 2018 %Planted Potential Season to (Packs) Date (Packs) 11,300 45% 8,735 40% 7,163 38% 27,198 42%

% Farmers with seeds 5% 6% 5% 5%

% Planted and Farmers with Seeds 50% 46% 43% 47%

Balance for the Season 5,650.00 4,717 4,083 14,450

MUNICIPALITY

TOTAL MINDANAO 3

Season to date Performance Indicator

ASL Jeffrey Cabrito Kenneth Rabilis Reo Oberio Rolando Bayot Carlos Cruz

VISMIN Total:

% Planted % and Farmers Liquidation with Seeds Ach % Placement 50% 43% 48% 46% 49% 55% 43% 0% 0% 0% 0% 47%

36% #DIV/0! #DIV/0! #DIV/0! #DIV/0! 42%

41% #DIV/0! #DIV/0! #DIV/0! #DIV/0! 48%

Liq Perf. Indicator 50% 46%

Liq Perf based on Placement 95% 120%

43% 0% 0% 0% 0% 47%

96% #DIV/0! #DIV/0! #DIV/0! #DIV/0! 102%

AREA

M3 TOTAL M3 AREA

LUZON VISMIN Zone 1 Total: AREA

LUZON VISMIN Zone 1 Total:

Liquidation Objectives: DRY-SEASON 2018

H101G 675 425 425 1,525

H102G

-

B9909G 575 625 675 1,875

B9541G

B9541R

-

B9698G

-

B9545G

-

B9540G

-

-

Liquidation Season to Date as of Previous Week

H101G

H102G

B9909G

B9541G

-

-

-

-

B9541R -

B9698G

-

B9545G

-

B9540G

-

-

2nd Layer Inventory in Metric Tons

H101G 0.7 0.7

H102G -

B9909G 0.9 0.9

B9541G

B9541R -

B9698G -

B9545G -

B9540G -

-

1st Layer Inventory in Metric Tons

H101G

H102G

1.5 1.5

B9909G -

B9541G

1.0 1.0

B9541R -

B9698G -

B9545G -

B9540G -

-

Total Trade Inventory in Metric Tons

H101G #REF! 2.2 #REF!

H102G #REF! #REF!

B9909G #REF! 1.9 #REF!

B9541G #REF!

B9541R #REF! -

#REF!

B9698G #REF! -

#REF!

B9545G #REF! -

#REF!

B9540G #REF! -

#REF!

#REF!

SEASON 2018

B9899G

B9909RR

-

-

BioCorn BioCorn1 108 18 375 375 375 1,125 -

TOTAL BioCorn BioCorn6 BioCorn CORN 453 50 Zarap 1,625 1,425 1,475 4,525 -

-

BioCorn BioCorn1 108 18 25 25 -

TOTAL BioCorn BioCorn6 BioCorn CORN 453 50 Zarap 25 25 -

H101RR

-

Previous Week

etric Tons

B9899G

B9909RR

-

-

H101RR

B9899G

H101RR

-

B9909RR -

H101RR

-

B9909RR -

B9909RR #REF! #REF!

H101RR #REF!

-

BioCorn BioCorn1 108 18 0.6 0.6 -

TOTAL BioCorn BioCorn6 BioCorn CORN 453 50 Zarap 2.2 3.7 7.3 13.8 2.2 3.7 7.3 13.8

-

BioCorn 108 1.6 1.6

BioCorn1 18 Err:509 Err:509 Err:509

TOTAL CORN Err:509 Err:509 Err:509

BioCorn BioCorn6 BioCorn 453 50 Zarap Err:509 Err:509 Err:509 8.3 Err:509 Err:509 8.3 Err:509

BioCorn BioCorn1 108 18 #REF! #REF! 2.2 Err:509 #REF! #REF!

TOTAL CORN #REF! Err:509 #REF!

BioCorn BioCorn6 BioCorn 453 50 Zarap #REF! #REF! #REF! Err:509 15.6 Err:509 #REF! #REF! #REF!

etric Tons

B9899G

etric Tons

B9899G #REF! #REF!

#REF!

Season to Date Deliveries to TOTAL TOTAL CORN&R BIORICE ICE 1,625 1,425 1,475 4,525

H101G 234 106 130 470

H102G

B9909G

B9541G 230 250 250 730 600

-

B9541R

-

B9698G

-

-

Liquidation for the We TOTAL TOTAL CORN&R BIORICE ICE 25 25

H101G 209 75 105 389

H102G -

B9909G

B9541G 205 200 227 632

B9541R -

B9698G -

-

c 1st Layer H101G RN Rice & Corn Mill Growers Land AGRI Mt Moriah Domas Vinissa Jay Total

B9909G 10 45

Bc108G

38 41 38

30 4 7 52 4 28

11 25 2 13 30 108

172

125

189

TOTAL CORN 24.8 24.8

52.3 52.3

TOTAL CORN Err:509 Err:509 Err:509

Err:509 Err:509 Err:509

TOTAL CORN #REF! Err:509 #REF!

Season to Date Deliveries to 2nd Layers

B9545G

B9540G

-

B9899G

-

B9909RR 10

61

10

61

BioCorn BioCorn1 108 18 58 250 128 230 230 186 710 550

H101RR

Total 772 785 610 2,167

Liquidation for the Week

B9545G

B9540G -

B9899G -

10 10

B9909RR 61 61

H101RR 58 128 186

BioCorn BioCorn1 108 18 TOTAL CORN 225 697 220 694 175 507 620 1,898

BioRice4 BioRice BioRice 53 650 Zarap -

BioCorn4 BioCorn BioCorn 53 650 Zarap -

-

-

-

-

-

Total -

Total Corn&Rice 772 785 610 2,167

TOTAL TOTAL CORN CORN&RICE 697 694 507 1,898

H101G

H102G 25 31 25 81

B9909G

-

25 50 23 98

B9541G

-

Inventory as on Date with 2nd Layers

B9541R

B9540G

B9698G

B9545G

B9899G

B9909RR

H101RR 0

-

-

-

-

-

-

BioCorn 108 25 0 10 30 65

BioCorn1 BioRice4 BioRice BioRice 18 TOTAL 53 650 Zarap 75 91 78 244 -

Total -

Total Corn&Rice 75 91 78 244

H101G

H102G

B9909G

-

-

-

-

-

-

Returns

B9541G

B9541R

B9540G

B9698G

B9545G

B9899G

-

-

-

-

-

-

B9909RR -

-

-

-

-

-

-

-

H101RR -

-

BioCorn BioCorn1 Total BioRice4 BioRice6 BioRice 108 18 Corn 53 50 Zarap -

Total Total Corn&R Rice ice -

H101G 209 75 105 389

H102G -

Liquidation Season to Date

B9909G 205 200 227 632

B9541G

B9541R -

B9698G -

B9545G -

B9540G -

B9899G -

10 10

B9909RR 61 61

on to Date

H101RR BioCorn108 BioCorn118 58 225 128 220 200 186 645 -

Total Corn 697 694 532 1,923

BioRice4 BioRice6 BioRice Total 53 50 Zarap Total BioRice Corn&Rice 697 694 532 1,923

Balance vs

H101G 466 350 320 1,136

H102G -

B9909G 370 425 448 1,243

B9541G

B9541R -

B9698G -

B9545G -

B9540G -

-

Balance vs Objectives

9899G (10) (10)

B9909RR (61) (61)

H101RR BioCorn108 BioCorn118 (58) 150 (128) 155 175 (186) 480 -

Total Corn 928 731 943 2,602

BioRice4 BioRice6 53 50 -

BioRiceZ Total arap BioRice -

Total Corn&Rice 928 731 943 2,602

H101G 31% 18% 25% 26%

H102G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9909G 36% 32% 34% 34%

B9541G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9541R #DIV/0! #DIV/0! #DIV/0! #DIV/0!

% Liquidation Achievement

B9698G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9545G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9540G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9899G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9909RR #DIV/0! #DIV/0! #DIV/0! #DIV/0!

H101RR #DIV/0! #DIV/0! #DIV/0! #DIV/0!

BioCorn108 BioCorn118 60% #DIV/0! 59% #DIV/0! 53% #DIV/0! 57% #DIV/0!

Total Corn 43% 49% 36% 42%

BioRice4 53 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

BioRice6 50 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

BioRice Zarap #DIV/0! #DIV/0! #DIV/0! #DIV/0!

Total Rice #DIV/0! #DIV/0! #DIV/0! #DIV/0!

Total Corn&Rice 43% 49% 36% 42%

H101G 35% 25% 31% 31%

H102G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9909G 40% 40% 37% 39%

% Delivery / Placement Achievement

B9541G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9541R #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9698G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9545G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9540G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9899G #DIV/0! #DIV/0! #DIV/0! #DIV/0!

B9909RR #DIV/0! #DIV/0! #DIV/0! #DIV/0!

H101RR #DIV/0! #DIV/0! #DIV/0! #DIV/0!

BioCorn 108 67% 61% 61% 63%

BioCorn 118 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

Total Corn 48% 55% 41% 48%

BioRice4 53 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

BioRice 650 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

BioRiceZ arap #DIV/0! #DIV/0! #DIV/0! #DIV/0!

Total Total Rice Corn&Rice #DIV/0! 48% #DIV/0! 55% #DIV/0! 41% #DIV/0! 48%

SEASON: DRY 2018 Joven S. Eta Nov. 26- Dec. 1, 2018 Legend: FM - FFM - Farmers Field Meeting, FM - Farmers Meeting, M2MS - Man to man Selling, 2nd

TL/ TLT Rey Alisna Mark Neil Micabalo Japhet James Bernas

VISMIN Total:

FFM CORN RICE 20 20 20

60

-

Activity Plan: Dry-Season 2018 FM M2MS 2nd LC CORN RICE CORN RICE CORN RICE 50 40 24 50 60 30 50 60 50

150

-

160

-

Business Intelligence Company Pioneer Syngenta Monsanto Others: _______

104

-

FD CORN RICE 50 50 50

150

-

S - Man to man Selling, 2nd LC - 2nd Layer Connect, FD - Farm Demo

Activities done as of previous week FFM FM M2MS 2nd LC CORN RICE CORN RICE CORN RICE CORN RICE CORN 6 1 78 46 43 4 3 13 46 57 6 8 29 68 58 2

17

1

120

-

160

-

158

-

12

Activities Done for th FFM FM M2MS CORN RICE CORN RICE CORN 1 7 27 6 1 4 5

FD RICE

-

1

1

31

-

18

Activities Done for the Week M2MS 2nd LC RICE CORN RICE 5 7 5

-

17

-

FD CORN

RICE 2 3 3

8 FFM/FM Meeting Performance

Luzon VisMin BRPI CORN

FFM CORN RICE 6 2 3 9 18 2 #REF! 67.6% #REF!

Activities Done Season to Date FM M2MS 2nd LC CORN CORN RICE CORN RICE 78 53 48 13 52 64 33 73 63 124 178 175 FFM/FM Meeting Performance

Luzon #REF! VisMin #DIV/0! BRPI #REF! RICE

to Date % Achievement: Season to Date 2nd LC FD FFM FM M2MS 2nd LC RICE CORN RICE CORN RICE CORN RICE CORN RICE CORN RICE 6 30% #DIV/0! 156% #DIV/0! 133% #DIV/0! 200% #DIV/0! 9 15% #DIV/0! 26% #DIV/0! 87% #DIV/0! 213% #DIV/0! 5 45% #DIV/0! 66% #DIV/0! 122% #DIV/0! 126% #DIV/0! - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 20 30% #DIV/0! 83% #DIV/0! 111% #DIV/0! 168% #DIV/0!

FD CORN 12% 18% 10% #DIV/0! #DIV/0! #DIV/0! 13%

RICE #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

AREA

BRPI

All volumes in Packs (9Kg) CROP/HYBRID

###

WS2017 DS2017 WS2018 NET NET SALES NET SALES SALES

Sales Plan DS2018

No of Packs Invoiced DS2018

WS2017 DS2017 WS2018 NET NET SALES NET SALES SALES

Sales Plan DS2018

No of Packs Invoiced DS2018

MINDANAO 3 CROP/HYBRID

###

Healer 101G Healer 102G

3,150

2,050

2,500

-

1,525

1,000

-

Bioseed 9909G

850

859

Bioseed 9541G

236

40

-

-

Bioseed 9541R

-

-

-

-

Bioseed 9540G

-

-

-

-

Bioseed 9698G Bioseed 9545G

-

540

1,362

250

300

-

-

-

-

-

-

-

-

30

Bioseed 9899G

1,875

Bioseed 9909RR

744

516

1,050

-

925

Healer 101RR

489

2,342

2,440

-

50

BIOCORN 108

1,125

100

4,525

3,437

BIOCORN 118

TOTAL (packs)

5,469

6,087

6,830

LIQUIDATION STATUS Season DRY 2018 Month 8/25/18 % invoice of % Contribution Sales plan

+/- vs WS2017 Invoiced

+/- vs DS2017 Invoiced

+/- vs WS2018 Invoiced

Placement at % Dealer or Placement Financer at retail

% invoice of % Contribution Sales plan

+/- vs WS2017 Invoiced

+/- vs DS2017 Invoiced

+/- vs WS2018 Invoiced

Placement at % Dealer or Placement Financer at retail

-68.3%

-51.2%

-60.0%

470

47%

#DIV/0!

#DIV/0!

#DIV/0!

-

#DIV/0!

60.2%

58.6%

152.2%

730

54%

-100.0%

-100.0%

#DIV/0!

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

#DIV/0!

#DIV/0!

-100.0%

-100.0%

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

#DIV/0!

#DIV/0!

-100.0%

#DIV/0!

10

#DIV/0!

24.3%

79.3%

-11.9%

61

7%

-89.8%

-97.9%

-98.0%

186

372%

#DIV/0!

#DIV/0!

#DIV/0!

710

710%

#DIV/0!

#DIV/0!

#DIV/0!

-37.2%

-43.5%

-49.7%

66% #DIV/0! 73% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 9% #DIV/0!

76%

29% 0% 40% 0% 0% 0% 0% 0% 0% 27% 1% 3% 0% 100%

#DIV/0!

2,167

63%

ATION STATUS Period/Reporting Week Note - Values to be entered in non coloured cells only Liquidation Liquidation Liquidation Liquidation Liquidation % liquidation % liquidation WS2017 DS2017 WS2018 For the week Season to vs.Invoiced vs. Target (Packs) (Packs) (Packs) (Packs) Date DS2018 (Packs)

Liquidation Liquidation Liquidation Liquidation Liquidation % liquidation % liquidation WS2017 DS2017 WS2018 For the week Season to vs.Invoiced vs. Target (Packs) (Packs) (Packs) (Packs) Date DS2018 (Packs) 2,100

2,828

2,618

333

973

899

107

84

5

389

389

39%

26%

-

-

#DIV/0!

#DIV/0!

632

632

46%

34%

-

-

#DIV/0!

#DIV/0!

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

250

120

50

-

-

#DIV/0!

#DIV/0!

-

-

#DIV/0!

#DIV/0!

10

10

#DIV/0!

#DIV/0!

952

731

372

61

61

7%

#DIV/0!

599

2,740

2,841

186

186

372%

#DIV/0!

620

645

645%

57%

#DIV/0!

#DIV/0!

56%

42%

-

4,091

7,656

6,855

1,898

1,923

on coloured cells only +/- vs WS2017 Liquidation

+/- vs WS2017

+/- vs DS2017 Liquidation

+/- vs WS2018 Liquidation

+/- vs DS2017 +/- vs DS2017

-81.5%

-86.2%

-100.0%

#DIV/0!

#DIV/0!

#DIV/0!

89.8%

-35.0%

-99.9%

-100.0%

-100.0%

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-100.0%

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-80.0%

#DIV/0!

-93.6%

-91.7%

-100.0%

-68.9%

-93.2%

-99.9%

-53.0%

-74.9%

-100.0%

% Contribution

No of Packs Returned

Balance Carry-over Quantity Inventory with trade from DS 2017

% Contribution

No of Packs Returned

Balance Carry-over Quantity Inventory with trade from DS 2017

20% 0% 33% 0% 0%

-

611

-

-

-

730

-

841

-

402

-

-

-

-

-

-

-

701

-

-

(10)

-

419

864

-

662

(136)

Err:509

0% 0% 0% 1% 3% 10%

2,529

2,657

Err:509

(545)

-

Err:509

-

-

66%

Err:509

1,514

8,211

Total WS2018 Inventory Target MT with Carryover

Billings/MT

liquidation/ MT

Total WS2018 Inventory Target MT with Carryover

Billings/MT

liquidation/ MT

3,140 1,571

13.73 16.88

9.00

3.50

-

-

12.26

5.69

402

-

-

-

-

-

-

-

-

-

-

-

701

-

-

-

-

-

-

-

409

-

-

0.09

1,526

-

8.33

0.55

2,521

-

0.45

1.67

0.90

5.81

-

-

(545) -

9,725

10.13 -

30.60

30.03

11.50

DISTRIBUTOR SALES

Invoiced Sales Delivery, Free Good

DRY SEASON 2018 From Nov. 26- Dec. 1, 2018 AREA / REGION

Actual Deliveries as per Invoicing Season to Date (WET 201 NAME H101G

M4 (SAMBAS)

DOMAS RICH FIELD MT MORIAH LAND AGRI SUPPLY PEOPLES AGRI RN Rice & Corn Mill Vinissa Jay Grower Agro FMN (Aglayan,Carmen, Osmena) ADAJAR ENTERPRISES - Cagayan RJR Agro (Government) TOTAL

TOTAL VISMIN TOTAL PHILIPPINES

H102G

30 50 90

170 2,979 2,979

B9909G

B9541G

B9541R

B9698G

B9545G

B9540G

B9899G

-

-

-

-

-

-

120 50 70

150 150

240 2,462 2,462

very, Free Goods and Returns Data to be supplied by Eliza, Only Weekly ending invent

nvoicing Season to Date (WET 2018) Stocks from BRPI WAREHOUSE B9909R

H101RR

BioCorn1 BioCorn 08 118

50

30 50

900 900

-

130 1,910 1,910

-

TOTAL Corn 50 180 150 160 540 8,401 8,401

Bio453

Bio650

-

-

BioZarap

TOTAL Rice

G-TOTAL

-

-

50 180 150 160 540 8,401 8,401

H101G

500 500

H102G

B9909G

-

-

eekly ending inventory by Distributor in yellow cells shall be encoded by ASL IDT (INTER-DISTRIBUTOR TRANSFER) B9541G

-

B9541R

-

B9698G

-

B9545G

-

B9540G

-

B9899G

-

B9909R

25 25

H101RR

50 50

BioCorn10 BioCorn11 8 8

-

-

TOTAL Corn 575 575

Bio453

Bio650

-

-

oded by ASL SALES RETURNS BioZarap TOTAL Rice

-

G-TOTAL -

575 575

H101G

H102G

-

B9909G

-

B9541G

-

B9541R

-

B9698G

-

B9545G

-

B9540G

-

B9899G

-

B9909R

-

-

SALES RETURNS BioCorn BioCorn 108 118

H101RR

-

-

-

TOTAL Corn

Bio453 -

Bio650

-

-

TOTAL Rice G-TOTAL -

H101G

BioZarap

-

H102G

30 50 90 170 3,479 3,479

B9909G 150 150

120 50 70 240 2,462 2,462

CORN UPDAT AREA Luzon-GT Luzon-GOVT VisMin-GT VisMin-GOVT BRPI-GT BRPI-GOVT

H101G

H102G

B9909G

-

-

-

-

3,479 3,479

* Actual Sales DS2018 as of August 25, 2018 in packs.

150

1,200

-

1,262

150

1,200

-

1,262

NET SALES B9698G

B9899G -

B9909R -

BioCorn1 BioCorn 08 118

H101RR

925 925

50 50

50 30 50 130 1,910 1,910

-

TOTAL Corn

Bio453

50 180 150 160 540 8,976 8,976

Bio650 -

BioZarap -

-

TOTAL Rice

G-TOTAL

-

CORN UPDATES B9698G

B9899G

B9909R

H101RR

-

-

-

-

-

-

-

-

-

-

-

50

-

-

925

-

-

-

-

50

-

-

925

-

BioCorn1 BioCorn 08 118 -

-

-

-

1,910 1,910 -

TOTAL Corn

CORN

DS2018 TARGET

% Perf

Err:509

Err:509

-

-

6,789

-

2,187

-

6,789

-

2,187

8,976 8,976

4,525 Err:509

RICE UPDATES

198.4% Err:509

AREA Luzon-GT Luzon-GOVT VisMin-GT VisMin-GOVT BRPI-GT BRPI-GOVT

50 180 150 160 540 8,976 8,976

TO BE FILLED UP BY ASL PERIOD: DISTRIBUTORS INVENTORY (PREVIOUS WEEK) H101G

H102G

B9909G

BioCorn B9545G B9540G B9899G B9909R H101RR BioCorn 108 118

B9541G B9541R B9698G

41

4

30

31 -

50 5

11

10 38 45

28 25 1

11 105 25

165 165 165

-

113 113 113

-

-

-

RICE

DS2018 TARGET

% Perf

-

Err:509

Err:509

-

-

#DIV/0!

-

Err:509

Err:509

BIORICE UPDATES Bio453

Bio650

BioZarap

Total RICE

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

182 182 182

-

TOTAL Corn 75 92 5 49 168 71 460 460 460

Bio453

-

Bio650

-

BioZarap

-

TOTAL Rice -

TOTAL 150 184 10 98 336 142 920 920 920

Bioseed Research Phils., Inc. Actual Collection 4/4/2019

Au Area

Distributor

M3

GOOD FARMS TRADING CORPORATION

M3

D.A. MABELIN'S STORE

M3

NITZ GEN. MDSE

M3

LORNA PABLICO ENTERPRISES

M3

PANTUA AGRI

M3

GAO JONES MARKETING

M3

N-J POLON AGRIVET SUPPLIES

M3

ADAJAR GENERAL MDSE. GARINGO

8/1-4/2018

8/5-11/2018

-

-

August 2018 8/12-18/2018

8/18-25/2018

8/26-31/2018

TOTAL -

1,773,600.00

1,773,600.00 -

1,754,050.00

1,754,050.00 -

-

1,754,050.00

1,773,600.00

3,527,650.00

SOA and Actual Weekly Collection shall be supplied by Chariz, onl week to be supplied by ASL

pplied by Chariz, only Collection Plan, Comments & Reason for Deviation on Previous

tion on Previous

AREA: BRPI-PHILIPPINES All volumes in Packs (9Kg) WS2017 NET DS2017 Sales Plan No of Packs SALES NET SALES (Wet 2018) Invoiced (Wet 2018) % Planting Area Sales Lead 50% Jeffrey Cabrito

5078

5,154

1,625

928

46% Kenneth Rabilis

6478

11,109

1,425

4,630

43% Reo Oberio

4948

8,137

1,475

3,840

0% Rolando Bayot

4965

6,407

-

6,874

0% Carlos Cruz

2374

5,732

-

1,080

23,843

36,539

4,525

17,352

52,641

68,298

Err:509

17,352

47% VISMIN Total: Err:509

BRPI Total note: Vis(govt/model) M1 (govt/RJR) M4 (govt/RJR)

Mindanao Performance

464 464 2,900

16,424

LIQUIDATION STATUS PER PERSONNEL Season Month % invoice of Sales plan

+/WS2017

+/DS2017

WET 2018 7/28/18

Placement at Dealer or Financer

% Placement % Placement at retail vs. Target

WS2017 Liquidation Actual

57% 325% 260% #DIV/0! #DIV/0!

-81.7%

-82.0%

772

83%

-28.5%

-58.3%

785

17%

-22.4%

-52.8%

610

16%

38.4%

7.3%

-

0%

-54.5%

-81.2%

-

0%

48% 55% 41% #DIV/0! #DIV/0!

383%

-27.2%

-52.5%

2,167

12%

48%

24,253

Err:509

-67.0%

-74.6%

Err:509

Err:509

Err:509

47,889

4321 5347 6074 4091 4420

not included 464 464 566%

1,395

8%

19,932

NNEL Period/Reporting Week

DS2017 Liquidation Actual

Note - Values to be entered in non coloured cells only Liquidation For Liquidation +/- WS2017 +/- DS2017 % liquidation the week Season to Date Liquidation Liquidation vs. Invoiced WS2018 WS2018

3,842

697

697

-83.9%

-81.9%

75%

7,542

694

694

-87.0%

-90.8%

15%

7,496

507

532

-91.2%

-92.9%

14%

6,168

-

-

-100.0%

-100.0%

0%

4,139

-

-

-100.0%

-100.0%

0%

29,187

1,898

1,923

-92.1%

-93.4%

11%

55,290

Err:509

Err:509

Err:509

Err:509

Err:509

-94%

-95%

not included 464 464 25,345

1,201

1,226

7%

No of % liquidation Packs vs. Target Returned

-

% Share

Liquidation % Forecast liquidatio Ending n vs. WS2018 Target

Market Potential WS2018

43% 49% 36% #DIV/0! #DIV/0!

36%

697

43%

27,000

36%

7,721

542%

28%

532

45,255

36%

43,870

42% Err:509

100%

0% 0%

6,850 #DIV/0! 5,240 #DIV/0!

21,040 465%

Err:509

35,600

191,780 636,887

not included 42%

40,055

Actual Sales WS2018

Actual Liquidation WS2018

Market Share WS2018 Sales

Market Share Market Share Market Share WS2017 Sales DS2017 Sales WS2018 Liquidation

928

697

3%

19%

19%

3%

4,630

694

10%

14%

25%

17%

3,840

532

9%

11%

19%

1%

6,874

-

17%

12%

16%

17%

1,080

-

3%

7%

16%

15%

9%

12%

19%

11%

3%

8%

11%

Err:509

17,352 17,352

1,923 Err:509

Market Share Market Share WS2017 DS2017 Liquidation Liquidation 16%

14%

12%

17%

14%

17%

10%

15%

12%

12%

13%

15%

8%

9%

latest forecast 697 7,721 532

7,027 -

43% 542% 36%

6,850

6,850

#DIV/0!

5,240

5,240

#DIV/0!

21,040

19,117

465%

21,040

Err:509

Err:509

Err:509

51,640

test forecast

465% Err:509

Related Documents


More Documents from "Donnette Davis"