Operations Report from Excel to Power Point to PDF
ASP Manufacturing June Review vs. Sales Plan
ACTUAL
SALES June
3,146
3,786
SALES PLAN June
2018
4,839
PRODUCTION
CAPACITY
ASP Manufacturing June General Information
Product Family
Sales Plan -June
2018
Actual Sales June
2018 (MT)
Production
Capacity
Actual June 2018
Production
Wastage
(MT)
Wastage %
% Utilization - Actual
% Utilization
Manufacturer
100%
90%
Bags
FFS
Film
80%
Stretch Film
Containers
83.00
139.00
255.83
161.47
0.84
0.52%
32.44%
29.49%
Drums
423.00
121.00
241.77
95.34
2.59
2.72%
174.96%
159.05%
Accessories/Others
7.00
11.00
39.77
13.49
0.05
0.34%
17.60%
16.00%
Containers/Crates
177.00
166.00
576.83
123.84
1.65
1.33%
30.68%
27.90%
Cutleries
14.00
0.00
92.35
8.36
0.01
0.08%
15.16%
13.78%
IML
21.00
0.00
31.75
0.16
0.00
0.63%
66.14%
60.13%
Pallets/Trolley
163.00
159.00
143.49
140.49
1.29
0.92%
113.60%
103.27%
Tubes
16.00
0.00
26.31
1.13
0.015
1.33%
60.81%
55.28%
904.00
596.00
1,408.10
544.28
6.439
1.18%
64.20%
58.36%
TOTAL>>>
70%
60%
64%
50%
40%
30%
20%
Production Capacity 2018
Sales Plan June 2018
UTILIZATION:
UTILIZATION
1,408
904
10%
64%
0%
ASP SUMMARY F3 by Section
COMPARISON BY SALES PLAN AND PRODUCTION CAPACITY
Product for
Injection Moulding
Blow Moulding
JUNE 2018
June 2018
Production
Sales Plan - June Actual Sales Actual
Capacity/Month
Wastage (MT) Wastage %
2018 (MT) June 2018 (MT)
Production
(MT)
(MT)
-
Total 904.00
-
-,408.10
-
-
1.0%
1.3%
1.2%
Utilization % - Utilization % Actual
Manufacturer
31.6%
51.6%
38.7%
28.7%
46.9%
35.1%
ASP SUMMARY F3
F3 COMPARISON BY SALES PLAN AND PRODUCTION CAPACITY JUNE 2018
Product Family
Containers
Drums
Accessories/Others
Containers/Crates
Cutleries
IML
Pallets/Trolley
Tubes
TOTAL>>>
June 2018
Sales Plan Actual Sales Prod'n Capacity
Prod'n Capacity Utilization
Actual
Utilization 2018 June 2018 June 2018
Wastage (MT) Wastage % 2018 (MT) 2018 (MT) 2018 Production
Actual
(MT)
(MT)
Actual
Manufacturer Manufacturer
(MT)
-
-
-
-
0.5%
2.6%
0.3%
1.3%
0.1%
0.6%
0.9%
1.3%
1.2%
-,408
63%
39%
34%
21%
9%
1%
98%
4%
39%
-,549
57.4%
35.8%
30.8%
19.5%
8.2%
0.5%
89.0%
3.9%
35.1%
ASP F4 & F6 SUMMARY
COMPARISON BY SALES PLAN AND PRODUCTION CAPACITY JUNE 2018
Actual Sales
Sales Plan JUNE
Product Family
JUNE- (MT)
(MT)
JUNE 2018
Actual
Production
(MT)
Prod'n
Utilization Prod'n Capacity
Wastage
Capacity 2018 Wastage (MT- (MT) %
(MT) - Actual
Actual
Manufacturer
Bags
FFS
Film
Stretch Film
TOTAL
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0.00
0.00
0.00
0
0.00
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0! #DIV/0!
#DIV/0!
F4 & F6 FILM CAPACITY
Product
Family
Sales Plan
JUNE 2018
(MT)
Actual Sales
JUNE 2018
(MT)
JUNE 2018
Actual
Production
(MT)
Bags
0.00
0.00
0.00
Prod'n
Prod'n Capacity
Utilization
Utilization 2018 Capacity 2018 Wastage (MT) Wastage %
2018 (MT) 2018 - Actual
Manufacturer
(MT) - Actual
Manufacturer
0
0
0
0
LD Garbage Bag
HD & T-Shirt Bag
Bakery Bag
Poultry Bag
Grip Hole Bag
LD& Valve Bag
Jumbo Shrnk Bags
Ice&Salt&Egg
FFS
Film
0
0.00
0.00
0.00
0
0
-
Shrink Rolls
0
0
0
0
0
F6
0
LD Roll Printed+POPP
Insulation Film
LD/HD Roll Plain
Shrink Beverage
TOTAL>>>
0.00
0.00
0.00
0.00
0.00
0
QC - No of Customer Complaints
Site
Y 2017
Target
Y 2018
Variance
Variance % Y 2018 vs Target
%
F3
F4
F6
ASP
60
53
48
-
23
28
25
20
15
KPI EQUATION
15
10
10
6
5
5
Y 2017
Y 2018
F3
F4
F6
Target
ASP
QC - Customer Rejection to FG %
Site
Y 2017
Target
Y 2018
Variance
Variance %
Y 2018 vs
Target %
F3
F4
F6
ASP
0.35
0.32
0.30
0.30
0.25
0.20
0.18
0.20
0.20
KPI EQUATION
0.15
0.11
0.10
0.10
0.07
0.05
-
0.02
0.02
-
Y 2017
Y 2018
F3
F4
F6
Target
ASP
QC - Customer Losses - SR
Site
Y 2017
Target
Y 2018
Variance
Variance %
Y 2018 vs Target %
F3
F4
F6
ASP
300,000
270,000
250,000
200,000
175,500
137,501
136,207
150,000
KPI EQUATION
100,000
61,838
68,264
67,500
50,000
27,000
-
6,426
1,294
-
Y 2017
Y 2018
F3
F4
F6
ASP
Target
Appendixes
INJECTION MOULDING - F3
PLAN JUNE 2018
Machine
BATT 3000
BATT 35
BATT 400
BATT 550
BMB 250 A
BMB 250 B
ENGEL 125 A
ENGEL 125 B
ENGEL 150
ENGEL 250
ENGEL 350
ENGEL 500
HUSKY 1350
HUSKY 300
HUSKY 750
MAGNA 350 A
MAGNA 350 B
NETSTAL 140 A
NETSTAL 140 B
NETSTAL 200
OMEGA 775 A
OMEGA 775 B
REMU 750 A
TRI 1200
TRI 130 A
TRI 130 B
TRI 580
TRI 750 B
OMEGA 775 C
MAGNA 275
MILACRON 1300 -A
MILACRON 1300 -B
Family
Pallets/Trolleys
Others
Others
Crates /Containers
IML
IML
Others
Others
Others
Others
Others
Others
Crates /Containers
Cutleries
Crates /Containers
Tubes
Cutleries
Others
Others
Cutleries
Crates /Containers
Crates /Containers
Crates /Containers
Crates /Containers
Others
Others
Crates /Containers
Crates /Containers
Crates /Containers
Cutleries
Crates /Containers
Crates /Containers
TOTAL>>>
Machine
Machine Capacity
Capacity (MT)
(MT) - Actual
Manufacturer-
-
910.48
1,001.53
JUNE 2018
Actual
Production
(MT-
287.43
Utilization (%) - Utilization (%) Actual
Manufacturer
98%
0%
8%
0%
0%
1%
18%
21%
20%
66%
2%
29%
59%
27%
26%
4%
0%
0%
16%
2%
12%
9%
31%
0%
486%
0%
0%
39%
5%
14%
43%
0%
89%
0%
8%
0%
0%
1%
16%
19%
19%
60%
2%
26%
53%
24%
23%
4%
0%
0%
15%
2%
11%
8%
28%
0%
442%
0%
0%
35%
5%
12%
39%
0%
32%
29%
Machine
Efficiency (%)PACs
63%
0%
51%
0%
0%
46%
47%
52%
50%
60%
24%
61%
91%
38%
68%
71%
0%
0%
77%
50%
57%
71%
78%
0%
22%
0%
0%
63%
57%
37%
72%
0%
71%
BLOW MOULDING - F3
PLAN JUNE 2018
Machine
BBM 250
BEKB 25
BFB 230
KBS 6160
KBS 750
MAGIC 14
MAGIC 15
MAGIC 16
MAGIC 17
VK 1.5 A
VK 1.5 B
VK 130
VK 3200
AKEI
Family
Machine
Cap. (MT) Actual
Machine Cap.
JUNE 2018
Utilization
(MT) Actual
(%) - Actual
Manufacturer Production (MT)
Machine
Utilization (%) Efficiency (%)Manufacturer
PACs
Drums
Containers
Containers
Drums
Containers
Containers
Containers
Containers
Containers
Containers
Containers
Containers
Drums
Containers
-
-
-
20%
55%
0%
34%
33%
107%
213%
127%
133%
11%
0%
43%
70%
19%
19%
50%
0%
31%
30%
97%
193%
116%
121%
10%
0%
39%
63%
17%
74%
49%
0%
53%
36%
45%
76%
84%
75%
43%
23%
53%
49%
37%
Total>>>
497.85
547.64
256.76
52%
47%
66%
CUTTING & SEALING - F4
Plan June 2018
Plant Item Code
Product
-
-
LD bags
Valve Bags
Poultry bags
LD bags
Garbage bags
T-shirt bags
T-shirt bags
LD bags
LD bags
LD bags
-
Poultry bags
-
Poultry bags
Others / LD /HD bags
Garbage and LD bags
T-shirt bags
LD bags
LD bags
LDBags /shopping bag
LD/HD BAGS
Poultry bags
-
-
TOTAL>>>
Machine
Machine Capacity
June 2018
Capacity (MT) (MT) Sales Plan (MT)
Actual
Actual
Manufacturer
Production (MT)
0
0
0
0.00
Utilization (%) Actual
Utilization (%) Machine Eff %- Manufacturer
PACs
#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!
#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!
SLITTING & REWINDING - F4
Plan June 2018
Plant Item
Code
Product
June 2018
Machine
Machine Capacity
Actual
Capacity (MT) (MT) Sales Plan (MT)
Production
Actual
Manufacturer
(MT)
Utilization
(%) - Actual
Utilization (%) - Machine Eff
Manufacturer
%-PACs
- LD Printed and Plain Roll
Insulation Film and Plain-
roll
LD Printed and Plain Roll,-
Insulation Film, Others-
LD Printed and Plain Roll,
Insulation Film, Others
TOTAL>>>
0
0
0
0
#DIV/0!
FILM PRINTING - F4
Plan June 2018
PRINTING Section
Plant Item
Code
Carraro 03
-
CMF 007
-
MAF 008
-
LEMO 009
LEMO 010
FISCHER &
KRECKE 012
-
VALMET 023
-
VALMET 024
-
FISHCER &
KRECKE 13
-
MIRAFLEX 14
-
-
Machine
Machine Capacity
Capacity (MT) (MT) - Manufacturer
Actual
Product
Sales Plan
(MT)
June 2018 Actual
Production (MT)
LD bags, garbage bags, and
printed roll
Garbage bags and Insulation Film
Insulation Film, Garbage bags,
Jumbo Printed Roll/Bag, LD Bags
T-shirt bags
Utilization (%) Actual
Utilization (%) Manufacturer
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
T-shirt bags
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Poultry bags, LD bags, LD printed
roll, bakery bags, Ice bags
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Poultry bags, LD bags, LD printed roll,
bakery bags, Ice bags
Poultry bags, LD bags, LD printed roll,
bakery bags, Ice bags
LD roll, Poultry bags, LD bags, Bakery
bags, Ice bags, Wicketted bags and
Diaper bags
LD roll, Poultry bags, LD bags, Bakery
bags, Ice bags, Wicketted bags and
Diaper bags
TOTAL>>>
0
0
0
0