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