DATA ANALYSIS
Monthly
Business
Review
NOVEMBER 2016
SALES OBJECTIVE:
1. QUOTA – Zero Inventory
2. PRICE – Increase Average Egg Price
3. PAPER TRAY – Decrease Tray Expenses
4. DELIVERY EXPENSES – Decrease Delivery
Expenses
5. ON TIME REPORTS
6. CUSTOMER RELATION-Maintain &
develop loyal customers.
NOVEMBER 2016
BMA 1 –MONTHLY AEP
Egg Size
Jumbo
Jan
5.87
Feb
5.89
Mar
5.95
Apr
5.81
May
5.79
Jun
5.94
Jul
6.20
Aug
6.25
Sep
6.33
Oct
Nov
6.28
6.32
XL
5.13
4.99
4.98
4.93
4.94
5.01
5.10
5.22
5.19
5.23
5.18
Large
4.73
4.69
4.69
4.67
4.67
4.79
4.81
4.94
4.93
4.91
4.90
Medium
4.31
4.31
4.34
4.08
4.05
4.27
4.50
4.76
4.79
4.77
4.75
Small
4.02
4.05
4.05
3.72
3.55
3.84
4.20
4.56
4.64
4.60
4.59
XS
3.81
3.81
3.85
3.37
3.21
3.49
3.93
4.39
4.45
4.37
4.34
Peewee
3.51
3.52
3.50
3.03
2.62
3.14
3.80
4.25
4.45
4.23
4.21
NV
3.20
3.24
2.89
2.79
2.27
2.58
3.54
4.01
3.93
Cracked
2.01
2.15
2.15
2.17
2.02
1.66
2.25
2.28
2.30
2.29
2.42
Dirty
3.82
3.87
3.88
3.82
3.54
3.66
3.66
3.68
3.67
3.67
3.67
Pamalit
3.33
3.33
3.33
3.33
3.33
3.33
Soft Egg
Promo
Total
1.49
1.45
1.48
1.51
1.43
1.16
1.62
1.62
1.63
1.67
1.73
4.14
4.10
3.81
4.28
4.56
4.56
4.48
4.48
4.09
3.69
3.90
Dec
BMA 2 –MONTHLY AEP
Egg Size
Jumbo
Jan
5.67
Feb
5.66
Mar
5.71
Apr
5.70
May
5.67
Jun
5.82
Jul
6.04
Aug
6.06
Sep
6.33
Oct
6.33
XL
4.96
4.89
4.94
4.86
4.80
4.95
5.07
5.20
5.26
5.29
5.28
Large
4.57
4.55
4.62
4.58
4.54
4.69
4.76
4.86
4.95
4.94
4.96
Medium
4.20
4.17
4.24
4.10
3.97
4.24
4.43
4.71
4.82
4.81
4.82
Small
3.92
3.86
3.95
3.76
3.52
3.91
4.11
4.42
4.61
4.61
4.60
XS
3.70
3.64
3.73
3.49
3.27
3.57
3.86
4.23
4.42
4.41
4.44
Peewee
3.42
3.46
3.46
3.19
2.95
3.17
3.60
4.03
4.33
4.24
4.12
NV
3.33
2.08
2.15
2.22
3.35
3.70
Cracked
2.03
2.15
2.26
2.18
2.05
2.18
2.11
2.13
2.18
2.23
2.26
Dirty
3.61
3.67
3.61
3.67
3.67
3.50
3.67
3.67
3.68
3.67
3.68
Pamalit
Soft Egg
Promo
Total
1.67
Nov
6.33
3.47
3.33
1.55
1.53
1.57
1.56
1.55
1.66
1.46
1.45
1.46
1.44
1.43
4.01
3.99
4.08
3.93
3.66
4.02
4.10
4.40
4.54
4.55
4.54
Dec
EBON FARM –MONTHLY AEP
Egg Size
Jumbo
Jan
5.88
Feb
5.87
Mar
5.78
Apr
5.83
May
5.75
Jun
6.02
Jul
6.16
Aug
6.35
XL
4.93
4.93
4.93
4.92
4.93
4.98
5.12
Large
4.74
4.72
4.76
4.72
4.70
4.69
Medium
4.26
4.22
4.31
4.18
4.04
Small
3.96
3.94
4.02
3.69
XS
3.71
3.69
3.75
Peewee
3.52
3.42
NV
3.10
Cracked
Dirty
Pamalit
Oct
Nov
6.42
6.49
6.40
5.28
5.30
5.28
5.30
4.92
5.12
5.12
5.08
5.09
4.22
4.57
4.85
4.91
4.87
4.89
3.41
3.86
4.27
4.56
4.67
4.66
4.65
3.36
3.02
3.58
3.96
4.30
4.40
4.81
4.40
3.50
3.09
2.58
3.21
3.79
4.07
4.25
4.26
4.23
2.91
2.91
2.58
1.99
2.64
3.52
3.77
3.88
3.90
3.78
1.65
1.65
1.68
1.52
1.49
2.08
1.65
1.74
1.72
1.71
1.74
3.67
3.69
3.60
3.67
3.55
3.67
3.69
3.94
3.99
4.01
4.03
3.33
3.33
1.32
1.34
1.35
1.40
4.64
4.57
4.58
-
-
Soft Egg
Promo
0.98
1.00
Total
4.05
4.03
1.05
4.04
1.01
3.74
1.08
1.45
1.20
3.43
3.88
4.24
4.56
Sep
Dec
Average Egg Price Summary
Egg Size
BMA1
BMA 2
EBON
AEP
Jumbo
6.32
6.33
6.40
6.35
XL
5.18
5.28
5.30
Large
4.90
4.96
5.09
4.98
Medium
4.75
4.82
4.89
4.82
Small
4.59
4.60
4.65
4.61
XS
4.34
4.44
4.40
4.39
Peewee
4.21
4.12
4.23
4.19
NV
3.93
3.47
3.78
3.73
Cracked
2.42
2.26
1.74
2.14
Dirty
3.67
3.68
4.03
3.79
1.73
1.43
1.40
1.52
4.48
4.54
4.58
4.53
5.25
Pamalit
Soft Egg
Promo
Total
AEP COMPARISON
Egg Size
OCT
2016
NOV
2016
Peso Change vs
Last Month
NOV
2015
Peso Change vs
Last Year
BMA1
4.48
4.48
0
4.13
+0.35
BMA2
4.55
4.54
-0.01
4.09
0.45
EBON
4.57
4.58
+0.01
4.02
+0.56
OVERALL
4.53
4.53
0
4.08
+0.45
NOVEMBER 2016
EBON FARM PRICE CHART
BMA1 FARM PRICE CHART
BMA 2 FARM PRICE CHART
NOVEMBER 2016
DELIVERY PERFORMANCE
RLH/RFB-VERNEL
QTY
AEP
DEL.EXP.
RFB/RJW-SALES OFFICE
COST/PC
QTY AEP
DEL.EXP.
RMP-JOEL
COST/PC
QTY
AEP
DEL.EXP.
COST/PC
JANUARY
2,473 4.11
124,743.13
0.14
3,173 4.18
177,723.90
0.15
FEBRUARY
2,630 4.08
111,686.23
0.11
2,751 4.17
123,219.00
0.12
MARCH
2,496 4.16
110,416.98
0.12
2,846 4.14
125,037.17
0.12
APRIL
2,205 3.74
119,639.05
0.15
2,760 3.89
160,657.71
0.16
MAY
-
102,028.49
0.09
-
154,460.02
0.15
JUNE
971
3.99
37,949.73
0.11
-
127,933.04
0.10
-
153,960.02
0.12
JULY
1737
4.39
60,670.57
0.10
2675
4.26
138,430.09
0.14
-
116,785.52
0.14
AUGUST
1799
4.62
63,155.21
0.10
-
101,983.15
0.11
2495
4.65
115,335.69
0.13
SEPTEMBER
1759
4.77
68,950.30
0.11
-
107,052.61
0.12
2326
4.75
106,376.39
0.12
OCTOBER
1,853
4.68
83,334.08
0.12
2,376 4.68
126,320.41
0.15
2,667 4.67
148,639.39
0.15
NOVEMBER
2,117
4.67
80,977.31
0.11
2,089 4.68
80,230.92
0.11
2,636 4.65
117,778.10
0.12
DECEMBER
DELIVERY PERFORMANCE
RFB-SALESOFFICE
Allowance
Basic Pay
Communication Charges
Depreciation
Food Allowance
Gas, Fuel, & Oil
GPS Device
Holiday Pay
Loss on Eggs
Loss on Paper Trays
Parking Fee
Promo
Incentive
Repair & Maintenance
Toll Fee
Transportation
Travel Allowance
Wages
TOTAL EXPENSES
Sold Cases
COST PER PC
RLH-VERNEL
850.00
9,-,200.00
RMP-JOEL-,484.62
2,799.22
5,083.33
2,-,-,-,688.00
2,-,556.00
9,-,-,792.00
80,230.92
117,778.10
80,977.31
2,089
0.11
2,636
0.12
13,-,236.24
2,-,-,702.00
9,-,740.00
8,-,824.15
1,780.00
9,-,-,-,032.50
5,-,780.00
1,230.76
4,874.00
2,117
0.11
TOTAL-,528.62
3,-,-,539.46
2,700.00
1,-,-,646.40
3,-,-,-,575.00
9,792.00
4,480.76
1,-,866.00
278,986.33
6,842
0.11
OBJECTIVES
QUOTA
– zero inventory
PRICE
– Increase Ave. Price
TRAYS
– Decrease Tray
losses
DELIVERY EXP. – Decrease Del. Exp.
OCTOBER 2016
NOVEMBER 2016
0
WITH RETURNS
4.53
4.53
SAME
97,254.40
50,646.00
DECREASE
278,986.33
DECREASE
358,293.88
RESULT
THANK YOU!