Supply chain management

profilePollypopolly
TermProjectData.xlsx
Home>Business & Finance homework help>Operations Management homework help>Supply chain management

Table of Content

Introduction
The data exhibits highlight 3 main areas relevant to manufacturing supply chain processes, which are: Raw Material Management, Asset Management and Factory Efficiency. The data sets in the exhibit are distinct and will provide different insights, which may or may not be codependent among each other, into the "current state" of the Juice-manufacturing company. SKU Nomenclature: Container Type (bottles/cans) + Liquid Capacity (oz) + Number of Containers per Pack + Type of Fruits + Form of fruits
Table of Content
Exhibit A: Yearly Performance Overview This exhibit provides the performance overview of the plants in Juice-Perfect's network. Column B: Plant locations Column C: Total Run Time (hr.) Column D: Annual Planned Downtime (hr.) Column E: Annual Unplanned Downtime (hr.) Column F: MTBF - Mean Time Before Failure (min) Column G: MTTR - Mean Time to Repair (min) Column H: Annual Planned Production
Exhibit B: Inventory Delays This data set provides information regarding the unmet production plan of ONE production line as a result of inventory issues. Column B: SKU ID Column C: Planned Amount Column D: Bottles available in storage Column E: Planned production date Column F: Unmet production reason Column G: Bottle shipment ID Column H: Total Amount Shipped Column I: Amount left in yard Column J: Arrival Date Column K: Reasons left in yard
Exhibit C: Maintenance Schedule This data set provides the information for work orders planned on each maintenance day for ONE production line. Details include planned/actual maintenance date, parts need and availability, reason for delay, and hours planned/actual for different worker category(Operator, Electrician, Mechanist). Please see below for the description of each column of the data set: Column B: Work order ID Column C: Schedule maintenance date to complete the work order Column D: Parts needed to perform maintenance for the work order Column E: Parts available in inventory Column F: Total labor hours planned to complete the work order Column G: Total actual labor hours spent to complete the work order Column H: Reason for delay in performing maintenance for the work order List contains: Insufficient Materials, Labor Shortage, Labor Expertise, Delays in bring the line down, N/A Column I: Hours planned for Electrician to work on the work order Column J: Hours planned for Operator to work on the work order Column K: Hours planned for Machinist to work on the work order Column L: Actual hours spent for Electrician to work on the work order Column M: Actual hours spent for Operator to work on the work order Column N: Actual hours spent for Mechanist to work on the work order
Exhibit D: Process Flow Chart Raw Material intake process flow chart
Exhibit E: Facility Layout Overall Facility layout including truck yard, Warehouse, staging area and production/packaging layout
Exhibit F: Maintenance Day Planning and Execution The exibits shows the planning, and execution process for a maintainance day at the facility

Exhibit A

Exhibit A Yearly Performance Overview
Mason Davoodi: Mason Davoodi: This exhibit provides the performance overview of the plants in Juice-Perfect's network.
Plant/Metrics Total Annual Run-time (hr.) Annual Planned Downtown (hr.) Annual Unplanned Downtime (hr.) MTBF (min) MTTR (min) Planned Annual Production
1 Illinois 4,380 100 219 1,421 52 28,000,000
2 North Carolina 6,570 130 361.35 1,206 55 30,000,000
3 Texas 8,760 240 525.6 981 54 46,000,000
4 California 7,665 192.5 536.55 789 56 50,000,000
5 Georgia 10,950 250 1095 949 55 65,000,000
6 Florida 4,380 120 657 300 55 36,000,000

Exhibit B

Exhibit B Inventory Delays
Mason Davoodi: Mason Davoodi: This data set provides information regarding the unmet production plan of ONE production line as a result of inventory issues.
No SKU ID
Mason Davoodi: Mason Davoodi: 25 SKU		 Planned Amount Bottles Available in Storage Planned Production Date Unmet Production Reason Bottle Shipment ID Total Amount Shipped Amount Left in Yard Arrival Date Reason left in yard
1 B241STWS 13000 12000 26-Aug Not enough bottle in production line 1557455980 1000 750 25-Aug Not received in system (Yard)
2 B241STWS 29000 28000 22-Aug Not enough bottle in production line 1518107959 1000 650 21-Aug Misplaced in Warehouse
3 B76STWJ 12000 11000 20-Aug Not enough bottle in production line 1510204561 1000 380 19-Aug Warehouse is full
4 B124APPJ 23000 20000 15-Aug Not enough bottle in production line 1509722615 3000 1080 14-Aug Warehouse is full
5 B76ORGS 23000 19000 14-Aug Not enough bottle in production line 1509407174 4000 1200 13-Aug Not received in system (Yard)
6 B76WMLS 19000 18000 8-Aug Not enough bottle in production line 1508617750 1000 160 7-Aug Warehouse is full
7 B124GRPS 24000 20000 6-Aug Not enough bottle in production line 1444242099 4000 3600 5-Aug Not received in system (Yard)
8 B241GRPJ 27000 23000 31-Jul Not enough bottle in production line 1391612087 4000 150 30-Jul Not received in system (Yard)
9 B76KWIJ 18000 16000 28-Jul Not enough bottle in production line 1391282703 2000 1680 27-Jul Misplaced in Warehouse
10 B124STWS 22000 19000 26-Jul Not enough bottle in production line 1381085344 3000 770 25-Jul Delay in Staging
11 B76ORGJ 23000 22000 24-Jul Not enough bottle in production line 1375164782 1000 930 23-Jul Misplaced in Warehouse
12 B124KWIJ 25000 22000 15-Jul Not enough bottle in production line 1349719711 3000 1480 14-Jul Misplaced in Warehouse
13 B241WMLJ 30000 26000 12-Jul Not enough bottle in production line 1210704094 4000 900 11-Jul Not received in system (Yard)
14 B76KWIS 18000 16000 11-Jul Not enough bottle in production line 1169339254 2000 2000 10-Jul Not received in system (Yard)
15 B241WMLS 15000 13000 7-Jul Not enough bottle in production line 1092498837 2000 1290 6-Jul Others
16 B124APPJ 16000 14000 3-Jul Not enough bottle in production line 1081990792 2000 950 2-Jul Warehouse is full
17 B124ORGJ 12000 10000 27-Jun Not enough bottle in production line 1067660308 2000 300 26-Jun Delay in Staging
18 B124KWIJ 14000 11000 26-Jun Not enough bottle in production line 1040446071 3000 300 25-Jun Delay in Staging
19 B76ORGS 25000 23000 25-Jun Not enough bottle in production line 1008980093 2000 1060 24-Jun Warehouse is full
20 B76ORGJ 24000 23000 13-Jun Not enough bottle in production line 983749211 1000 440 12-Jun Others
21 B124KWIS 27000 23000 8-Jun Not enough bottle in production line 958295862 4000 3960 7-Jun Misplaced in Warehouse
22 B76WMLS 28000 26000 3-Jun Not enough bottle in production line 888544595 2000 25 2-Jun Others
23 B124APPS 16000 14000 30-May Not enough bottle in production line 853214184 2000 1040 29-May Misplaced in Warehouse
24 B241GRPJ 17000 16000 17-May Not enough bottle in production line 837545234 1000 450 16-May Misplaced in Warehouse
25 B76WMLJ 27000 24000 11-May Not enough bottle in production line 829968106 3000 2500 10-May Misplaced in Warehouse
26 B241APPJ 16000 13000 6-May Not enough bottle in production line 816375544 3000 1100 5-May Delay in Staging
27 B124ORGJ 10000 8000 2-May Not enough bottle in production line 789365699 2000 480 1-May Not received in system (Yard)
28 B124GRPJ 10000 6000 1-May Not enough bottle in production line 772429939 4000 1000 30-Apr Misplaced in Warehouse
29 B76KWIJ 16000 15000 29-Apr Not enough bottle in production line 769939888 1000 340 28-Apr Delay in Staging
30 B124WMLS 16000 14000 26-Apr Not enough bottle in production line 715158568 2000 90 25-Apr Warehouse is full
31 B76ORGJ 20000 18000 19-Apr Not enough bottle in production line 702929209 2000 1220 18-Apr Not received in system (Yard)
32 B124GRPJ 11000 10000 18-Apr Not enough bottle in production line 648775432 1000 280 17-Apr Others
33 B124APPS 12000 10000 12-Apr Not enough bottle in production line 636927028 2000 1770 11-Apr Misplaced in Warehouse
34 B76ORGJ 11000 8000 8-Apr Not enough bottle in production line 543016700 3000 2250 7-Apr Misplaced in Warehouse
35 B76ORGS 9000 8000 6-Apr Not enough bottle in production line 439547282 1000 630 5-Apr Delay in Staging
36 B124KWIS 19000 18000 27-Mar Not enough bottle in production line 371695588 1000 250 26-Mar Others
37 B241GRPS 30000 29000 25-Mar Not enough bottle in production line 371493752 1000 300 24-Mar Delay in Staging
38 B76KWIS 24000 22000 21-Mar Not enough bottle in production line 333415670 2000 1000 20-Mar Misplaced in Warehouse
39 B76GRPJ 26000 23000 19-Mar Not enough bottle in production line 330312002 3000 2000 18-Mar Not received in system (Yard)
40 B124ORGJ 11000 8000 15-Mar Not enough bottle in production line 276040414 3000 1100 14-Mar Warehouse is full
41 B124APPJ 14000 13000 14-Mar Not enough bottle in production line 270699959 1000 850 13-Mar Delay in Staging
42 B76STWS 17000 13000 13-Mar Not enough bottle in production line 255215557 4000 3980 12-Mar Warehouse is full
43 B241APPS 24000 21000 12-Mar Not enough bottle in production line 232555599 3000 290 11-Mar Others
44 B241APPS 21000 17000 5-Mar Not enough bottle in production line 166441474 4000 1570 4-Mar Misplaced in Warehouse
45 B124ORGJ 18000 17000 3-Mar Not enough bottle in production line 162847032 1000 160 2-Mar Misplaced in Warehouse
46 B124KWIJ 13000 10000 28-Feb Not enough bottle in production line 143233333 3000 1300 27-Feb Delay in Staging
47 B241STWS 15000 11000 13-Feb Not enough bottle in production line 91040117 4000 3500 12-Feb Misplaced in Warehouse
48 B76ORGJ 17000 16000 12-Feb Not enough bottle in production line 84661365 1000 850 11-Feb Not received in system (Yard)
49 B241APPJ 17000 13000 5-Feb Not enough bottle in production line 44000670 4000 3250 4-Feb Not received in system (Yard)

Exhibit C

Exhibit C: Maintenance Schedule

Mason Davoodi: Mason Davoodi: This data set provides the information for work orders planned on each maintenance day for ONE production line. Details include planned/actual maintenance date, parts need and availability, reason for delay, and hours planned/actual for different worker category(Operator, Electrician, Mechanist).		 Planned Maintenance Actual Maintenance
Work Order ID
Mason Davoodi: Mason Davoodi: 138 work order		 Schedule Maintenance Date
Zhao, Niki: Every Monday schedule for maintenance Picked 2 dates per month from Feb till Aug.		 Parts Needed Parts Available Labor Hours Planned Labor Hours Actual Delay Reason Electrical Work Hour Planned Operator Worked Hour Planned Mechanical Work Hour Planned Electrical Work Hour Actual Operator Hour Actual Mechanical Work Hour Actual
10001 4-Feb 39 98 1 1.7 N/A 0.6 0.2 0.2 0.1 0.7 0.9
10002 4-Feb 78 150 1.1 2.2 Labor Shortage (Absence) 0.4 0.5 0.2 0.5 0.8 0.9
10003 4-Feb 98 154 1.5 1.8 Others 0.6 0.1 0.8 0.1 0.8 0.9
10005 4-Feb 39 51 1.5 2.5 Delays in bringing the line down 0.5 0 1 0.8 0.7 1
10010 11-Feb 93 94 0.5 2.2 Labor Expertise 0.3 0.2 0 0.9 1 0.3
10011 11-Feb 22 129 1.6 1.2 N/A 0.7 0.2 0.7 0 0.5 0.7
10012 11-Feb 97 100 0.7 2.3 Labor Shortage (Absence) 0.2 0.3 0.2 0.6 0.9 0.8
10013 11-Feb 80 112 2.5 2 N/A 0.8 0.9 0.8 0.7 0.6 0.7
10014 18-Feb 68 141 1.6 2 Labor Expertise 0.7 0.8 0.1 1 0.5 0.5
10015 18-Feb 94 100 1 1.4 Labor Expertise 0 0.1 0.9 0.7 0.1 0.6
10016 18-Feb 4 180 2.3 1.9 N/A 0.8 1 0.5 0.9 0.3 0.7
10017 18-Feb 6 8 1.7 1.8 Others 0.9 0.6 0.2 0.9 0.4 0.5
10018 18-Feb 39 46 1.7 2.6 Delays in bringing the line down 0.9 0.4 0.4 0.9 0.7 1
10019 25-Feb 81 6 1.7 1.1 No Spares parts 0.1 1 0.6 0 0.3 0.8
10020 25-Feb 92 192 2 1.6 N/A 0.7 0.9 0.4 0.3 0.5 0.8
10021 25-Feb 10 100 1.2 2.3 Labor Expertise 0.6 0 0.6 1 1 0.3
10022 25-Feb 62 30 1.1 1 No Spares parts 0.3 0.1 0.7 0.6 0 0.4
10023 4-Mar 72 163 2.3 3.6 Labor Expertise 0.9 0.9 0.5 1.3 1.1 1.2
10024 4-Mar 31 20 1.9 0.3 No Spares parts 1 0.6 0.3 0.1 0.1 0.1
10025 4-Mar 35 128 0.9 1.1 Labor Shortage (Absence) 0.3 0.4 0.2 0.3 0 0.8
10026 4-Mar 34 19 1.8 1.7 No Spares parts 0.7 0.8 0.3 1 0.7 0
10027 11-Mar 53 50 1.1 2 No Spares parts 0.7 0.3 0.1 0.1 1 0.9
10028 11-Mar 91 16 1.6 1.8 No Spares parts 0.7 0.7 0.2 1 0.2 0.6
10029 11-Mar 12 40 0.5 2 Delays in bringing the line down 0.1 0.2 0.2 0.8 0.7 0.5
10030 11-Mar 23 60 0.6 1.2 Delays in bringing the line down 0.2 0.4 0 0.6 0.2 0.4
10031 11-Mar 71 79 2 1.5 N/A 0.5 0.7 0.8 0.7 0.3 0.5
10032 18-Mar 3 44 1.4 2.1 N/A 0.4 0.5 0.5 0.9 0.7 0.5
10033 18-Mar 89 109 0.9 1.9 Labor Expertise 0.3 0.6 0 0 1 0.9
10034 18-Mar 39 189 0.3 2.2 Labor Shortage (Absence) 0.3 0 0 0.2 1 1
10035 18-Mar 78 151 1.1 1.8 Delays in bringing the line down 0.5 0 0.6 1 0.4 0.4
10036 18-Mar 88 50 1.7 1 No Spares parts 0.7 0.5 0.5 0.8 0.2 0
10037 18-Mar 73 31 2.1 1.4 No Spares parts 0.1 1 1 0 1 0.4
10038 25-Mar 41 181 2 3.8 Labor Expertise 0.9 0.3 0.8 1.5 1.3 1
10039 25-Mar 91 119 2 2.5 Labor Expertise 0.6 0.7 0.7 0.4 1.1 1
10040 25-Mar 74 33 1.4 0.9 No Spares parts 1 0.4 0 0.2 0.3 0.4
10040 25-Mar 94 98 1.4 1.5 Labor Expertise 0.4 0.9 0.1 0.5 0.5 0.5
10041 1-Apr 51 188 1.8 1.9 Labor Expertise 0.6 0.7 0.5 0.9 0.6 0.4
10042 1-Apr 29 23 0.7 1.9 No Spares parts 0 0.2 0.5 0.2 0.9 0.8
10043 1-Apr 88 137 1.5 1.4 N/A 0.6 0.7 0.2 0.4 0.8 0.2
10044 1-Apr 86 144 1.9 2 N/A 0.8 0.6 0.5 1 0.3 0.7
10045 8-Apr 72 72 1.7 1.7 N/A 0.6 0.9 0.2 0 0.7 1
10046 8-Apr 20 113 1.6 1.3 N/A 0.2 1 0.4 0.6 0.6 0.1
10047 8-Apr 35 89 2.3 2.5 Labor Expertise 0.7 1 0.6 0.6 0.9 1
10048 8-Apr 40 161 0.6 1.6 Labor Expertise 0.1 0.3 0.2 0.3 0.3 1
10049 15-Apr 62 63 1.2 1.7 Labor Expertise 0.3 0.8 0.1 0 0.9 0.8
10050 15-Apr 41 97 2.4 2 Labor Expertise 1 1 0.4 0.8 0.2 1
10051 15-Apr 94 200 0.6 2.1 N/A 0.1 0 0.5 0.9 0.5 0.7
10052 15-Apr 76 192 0.5 1.9 N/A 0 0.5 0 0.8 1 0.1
10053 15-Apr 19 104 2.5 2 Labor Shortage (Absence) 0.5 1 1 1.1 0.5 0.4
10054 22-Apr 25 5 1.6 0.8 No Spares parts 0.9 0.7 0 0 0.1 0.7
10055 22-Apr 36 198 1.5 1 Others 0.5 0.3 0.7 0.3 0.1 0.6
10056 22-Apr 14 33 1 2 Labor Shortage (Absence) 0 0 1 0.3 1 0.7
10057 22-Apr 52 77 1.2 1.4 Labor Expertise 0.1 0.2 0.9 0.7 0.4 0.3
10058 29-Apr 90 135 1.3 1.6 Labor Expertise 0.2 0.1 1 1.3 0.3 0
10059 29-Apr 6 154 1.6 1.4 Labor Expertise 0.6 0.9 0.1 0.5 0.5 0.4
10060 29-Apr 20 38 2.8 2.3 N/A 1 1 0.8 0.9 1 0.4
10060 29-Apr 31 109 1.6 2 N/A 0.4 0.2 1 0.8 0.5 0.7
10061 6-May 90 157 1.7 1.8 N/A 0.1 0.8 0.8 0.9 0.2 0.7
10062 6-May 41 100 1 1.6 N/A 0.4 0.1 0.5 0.7 0.6 0.3
10063 6-May 67 151 1.6 2.6 Labor Shortage (Absence) 0.7 0.2 0.7 2 0.3 0.3
10064 6-May 90 88 2 1 No Spares parts 0.9 0.1 1 0.2 0 0.8
10065 13-May 82 90 0.9 1.6 Labor Expertise 0.1 0.4 0.4 0.6 0.1 0.9
10066 13-May 20 79 1.3 0.8 N/A 0.1 0.4 0.8 0.2 0.2 0.4
10067 13-May 44 143 2 1.7 N/A 1 0.1 0.9 0.3 1 0.4
10068 13-May 67 135 1.5 0.8 N/A 0.5 0.2 0.8 0.2 0.4 0.2
10069 13-May 10 7 1.6 1.5 No Spares parts 0 0.7 0.9 0.1 0.4 1
10070 13-May 73 177 2.5 2.3 Labor Expertise 0.5 1 1 1 1 0.3
10071 13-May 61 118 2.2 1.9 N/A 0.8 0.9 0.5 0.1 1 0.8
10072 13-May 95 186 1.2 1.5 N/A 0.5 0.7 0 0.4 0.2 0.9
10073 20-May 54 72 0.7 1.2 N/A 0.2 0.1 0.4 0.4 0 0.8
10074 20-May 24 119 1.5 0.9 N/A 0.8 0 0.7 0.3 0.6 0
10075 20-May 5 121 1.6 1.9 Labor Expertise 1 0.5 0.1 0.1 0.8 1
10076 27-May 82 89 1.2 1.7 Labor Shortage (Absence) 0.9 0.2 0.1 0.8 0.6 0.3
10077 27-May 89 41 1.8 0.7 No Spares parts 0.5 0.8 0.5 0.6 0.1 0
10078 27-May 40 8 2 1.9 No Spares parts 0.8 0.4 0.8 0.9 0.8 0.2
10079 27-May 57 46 1 1.5 No Spares parts 0 0.8 0.2 0.2 0.7 0.6
10080 27-May 92 63 1.1 0.5 No Spares parts 0.2 0.6 0.3 0.1 0.3 0.1
10081 3-Jun 40 121 2 3.8 Labor Expertise 0.2 0.9 0.9 1.6 0.9 1.3
10082 3-Jun 40 130 1.5 1 N/A 0.7 0.6 0.2 0.3 0.3 0.4
10083 3-Jun 57 23 1.9 0.2 No Spares parts 0.8 0.6 0.5 0.2 0 0
10084 3-Jun 80 82 0.9 2.6 Labor Expertise 0.5 0 0.4 1 0.6 1
10085 10-Jun 33 112 2.5 2.5 Labor Expertise 0.8 0.9 0.8 1 0.9 0.6
10086 10-Jun 72 142 1.9 1.9 N/A 0.9 0.5 0.5 0.8 1 0.1
10087 10-Jun 7 128 2.1 1.4 N/A 0.7 0.5 0.9 0.7 0.3 0.4
10088 10-Jun 16 2 2.1 1.9 No Spares parts 0.8 1 0.3 0.9 0.7 0.3
10089 17-Jun 13 179 0.7 2.1 Delays in bringing the line down 0 0.3 0.4 0.2 0.9 1
10090 17-Jun 32 125 1.9 2.1 Labor Expertise 0.6 0.3 1 0.5 0.8 0.8
10091 24-Jun 31 156 2 1.7 Labor Shortage (Absence) 0.2 0.9 0.9 1.2 0.1 0.4
10092 24-Jun 38 189 1.7 1.4 N/A 0.5 0.3 0.9 0.2 0.6 0.6
10093 24-Jun 2 135 0.9 1.7 Labor Expertise 0.8 0 0.1 0.9 0.1 0.7
10094 24-Jun 47 57 1.8 2.2 Labor Expertise 0.9 0.4 0.5 0.7 1 0.5
10095 24-Jun 21 31 0.3 2.7 Delays in bringing the line down 0.2 0 0.1 0.9 0.9 0.9
10096 1-Jul 93 56 1.9 1.4 No Spares parts 0.9 0.8 0.2 0.1 0.4 0.9
10097 1-Jul 43 10 2.1 1.3 No Spares parts 0.4 1 0.7 0.5 0.3 0.5
10098 1-Jul 45 56 1.5 1.5 N/A 0.1 0.8 0.6 0.5 0.1 0.9
10099 1-Jul 88 39 0.7 1.3 No Spares parts 0.1 0.2 0.4 0.1 0.9 0.3
10700 1-Jul 20 74 0.9 2 Labor Expertise 0.7 0.2 0 0.3 1 0.7
10800 8-Jul 98 182 1 1.9 N/A 0.1 0 0.9 0 1 0.9
10900 8-Jul 30 27 1.5 0.6 No Spares parts 0.1 0.5 0.9 0.2 0 0.4
10100 8-Jul 46 76 1 1.2 Labor Expertise 0.4 0.4 0.2 0.1 0.4 0.7
10101 15-Jul 43 102 1.2 2.2 Labor Expertise 0.3 0.1 0.8 0.8 0.6 0.8
10102 15-Jul 5 182 1.6 1.8 Others 0.7 0.6 0.3 0.3 0.5 1
10103 15-Jul 95 26 2.3 1.3 No Spares parts 0.7 0.6 1 0.1 0.5 0.7
10104 15-Jul 11 29 1.5 2.5 Labor Shortage (Absence) 0.3 0.9 0.3 0.8 0.9 0.8
10105 15-Jul 41 136 1 1.2 Others 0 0.7 0.3 0.4 0.2 0.6
10106 15-Jul 1 15 1.1 1.2 Labor Expertise 0.2 0.8 0.1 0 0.6 0.6
10107 15-Jul 75 63 2.9 0.7 No Spares parts 1 0.9 1 0.4 0.1 0.2
10108 22-Jul 62 197 1.8 2.1 Delays in bringing the line down 0.5 0.3 1 0.8 0.8 0.5
10109 22-Jul 81 19 2.2 2 No Spares parts 0.5 0.8 0.9 0.7 0.8 0.5
10110 22-Jul 23 195 1.3 1.8 Labor Shortage (Absence) 0.5 0.2 0.6 0.1 0.7 1
10111 22-Jul 42 17 2.4 1.9 No Spares parts 1 0.6 0.8 0.6 0.5 0.8
10112 22-Jul 76 76 1.6 2.4 Labor Expertise 0.2 0.9 0.5 1 0.5 0.9
10113 22-Jul 70 5 1.6 1.7 No Spares parts 0.9 0.5 0.2 0.2 0.5 1
10114 22-Jul 95 41 1.6 0.7 No Spares parts 0 0.6 1 0.7 0 0
10115 29-Jul 59 88 2 4 Labor Expertise 0.3 0.8 0.9 1.1 1.9 1
10116 29-Jul 97 50 1.8 1.1 No Spares parts 0.9 0.5 0.4 0.2 0.2 0.7
10117 29-Jul 69 14 0.6 1.2 No Spares parts 0.2 0.2 0.2 0.3 0.1 0.8
10118 5-Aug 21 51 0.8 1.1 N/A 0.6 0.2 0 0.2 0.7 0.2
10119 5-Aug 31 134 1.5 2.7 N/A 0.1 1 0.4 1 0.7 1
10120 5-Aug 64 190 0.4 2.2 Labor Shortage (Absence) 0.4 0 0 0.8 0.9 0.5
10121 5-Aug 87 135 1.7 2 Labor Expertise 0.6 0.7 0.4 0.5 0.5 1
10122 5-Aug 43 130 1 1.9 Labor Shortage (Absence) 0 0.6 0.4 0.8 0.2 0.9
10123 5-Aug 42 70 0.9 2.7 Labor Shortage (Absence) 0.2 0 0.7 0.8 1 0.9
10124 5-Aug 99 100 1.3 1.8 Labor Shortage (Absence) 0.3 0.9 0.1 0.6 1 0.2
10125 12-Aug 42 114 2 2.7 Labor Shortage (Absence) 0.7 1 0.3 1 0.7 1
10126 12-Aug 6 94 1.4 2.6 Delays in bringing the line down 0.3 0.4 0.7 0.9 0.8 0.9
10127 12-Aug 6 189 1.1 0.9 N/A 0 0.7 0.4 0.1 0.2 0.6
10128 12-Aug 38 150 1.5 1.7 Others 0.8 0.1 0.6 0.9 0.7 0.1
10129 12-Aug 67 169 2 1.2 N/A 0.1 1 0.9 0.4 0.3 0.5
10130 12-Aug 22 40 1.9 1.4 N/A 0.6 0.5 0.8 0.4 0.6 0.4
10131 12-Aug 43 49 1.1 1.6 Labor Expertise 0.7 0.4 0 0.5 0.6 0.5
10132 12-Aug 20 64 1.1 0.8 N/A 0.9 0.2 0 0 0.3 0.5
10133 19-Aug 80 174 1.1 2.1 Delays in bringing the line down 0.3 0.8 0 0.8 0.9 0.4
10134 19-Aug 34 36 1.3 1.3 N/A 1 0.2 0.1 0.7 0.6 0
10135 19-Aug 23 145 2 3 Labor Expertise 0.5 0.5 1 1 1.5 0.5
10136 19-Aug 70 70 1.3 1.6 Labor Expertise 0.7 0.4 0.2 0.9 0.2 0.5
10137 19-Aug 79 175 1.4 1.3 Labor Expertise 0.8 0.4 0.2 0.4 0.7 0.2
10138 19-Aug 24 75 1.2 1.5 Labor Expertise 1 0 0.2 0.3 1.1 0.1

Exhibit D

Exhibit D:Process Flow Chart

Mason Davoodi: Mason Davoodi: Raw Material intake process flow chart		 Procurement Stored Production

Exhibit E

Exhibit E: Facility Layout

Mason Davoodi: Mason Davoodi: Overall Facility layout including truck yard, Warehouse, staging area and production/packaging layout

Exhibit F

Exhibit F: Maintenance Day Planning and Execution

Mason Davoodi: Mason Davoodi: The exibits shows the planning, and execution process for a maintainance day at the facility		 2 weeks planning 1-2 days execution

Current State Process

Currently the plant executes an 8 hour maintenance day (MD) twice a month. The planning starts 2 weeks before the MD and maintenance activities are selected from the preventive maintenance schedule. Backlog or pending maintenance activities are prioritized. Each maintenance activity has details on time and skill set required (electrician, operator, etc) for completion. Based on that, the total labor hours activities are planned. Average time from order to receipt of spares is 2 weeks. Based on the MD activities, spares are staged in the storeroom 2 days before execution. On the morning of the MD, the spares are staged next to the packaging line. The MD activities are assigned to the staff based on availability on the day and activities are executed. At the end of the MD, progress is noted and activities not completed are noted.

S1-Material Management

S2-Asset Care

S3-Factory Effeciency

S4-Creative Solution