please if you will solve this question, please do not copy it from a similar question chegg I have seen it and it is not the answer I want. If you solved it with excel please provide excel

formulation

Appendix B SKU ID - B241APPJ B76ORGJ B241STWS 1ST we B124KWIJ B124ORGJ B241APPS B241APPS B24TAPPS B76STWS B124APPJ B124ORGJ B76GRPJ B76KWIS DYOKWIS B241GRPS DEFTONES B124KWIS DIZHNWIS B76ORGS DIGOROS B/GORGJ B76ORGI B124APPS BI2-APPS B124GRPJ B76ORGJ B124WMLS DI24WALLS B76KWIJ B124GRPJ B124ORGJ B241APPJ B76WALI B76WMLJ B241GRPJ B124APPS B76WMLS wwwasse B124KWIS pewa B76ORGJ B76ORGS B B124KWIJ B124ORGI Pres B124APPJ B241WMLS B76KWIS B241WMLJ B124KWIJ B76ORGJ B124STWS Planned Amount 17000 17000 15000 www 13000 ***** 18000 21000 24000 17000 14000 11000 20000 26000 24000 24000 30000 19:000 19000 9000 11000 11000 12000 12000 11000 11000 20000 16000 10000 16000 10000 10000 10000 16000 16000 27000 17000 16000 www 28000 wwwww 27000 24000 www 25000 23000 14000 www 12000 10000 16000 wwwww 15000 www 18000 ***** 30000 25000 23000 22000 Bottles Available in Storage 13000 16000 11000 www 10000 ***** 17000 ***** 17000 21000 21000 13000 13000 13000 13000 8000 0000 23000 23000 22000 22000 29000 29000 20000 18000 8000 0000 0000 8000 10000 10000 10000 10000 18000 10000 14000 *1000 15000 25000 0000 6000 8000 13000 24000 24000 16000 14000 26000 wwwww 23000 www 23000 ***** 23000 20000 11000 wwwww 10000 www 14000 www 13000 www 16000 wwwww 26000 22000 22000 19000 + Planned Production Date 05-Feb Us-reb 12-Feb 12-reb 13-Feb TU-TED 28-Feb 03-Mar www OP-ALAL 05-Mar 12-Mar 12-Mar 13-Mar 14-Mar 15-Mar 15-Mar 19-Mar 19-wat 21-Mar 21-Mar 25-Mar 27-Mar 06-Apr 08-Apr 12-Apr 18-Apr 19-Apr 26-Apr 26-Apr 29-Apr 01-May 02-May 06-May 11-Mar 17-May 30-May 03-Jun 08-Jun 13-Jun 25-Jun 26-Jun 27-Jun 03-Jul 07-Jul 11-Jul 12-Jul 15-Jul 24-Jul 26-Jul Unmet Production Reason Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line |Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line |Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Bottle Shipment ID 44000670 84661365 91040117 143233333 ETOBOOOOO 162847032 wwwwwwww 166441474 concom 232555599 255215557 270699959 276040414 330312002 330012002 333415670 300+13070 371493752 371695588 439547282 43954/262 543016700 543010/00 636927028 090921020 648775432 646715400 702929209 102929209 715158568 1131509:00 769939888 772429939 12429999 789365699 816375544 829968106 837545234 853214184 888544595 958295862 www2/2002 983749211 wwwmast 1008980093 1000900090 1040446071 TUTOTHOUSE 1067660308 1081990792 www.vive 1092498837 w 1169339254 *** 1210704094 1349719711 1375164782 1381085344 Total Amount Shipped 4000 1000 4000 3000 1000 **** 4000 3000 4000 4000 1000 1000 3000 3000 3000 3000 2000 2000 1000 1000 1000 1000 1000 1000 3000 3000 2000 2000 1000 1000 2000 2000 2000 1000 1000 4000 1000 2000 2000 3000 3000 3000 1000 2000 2000 www 4000 www 1000 2000 2000 w 3000 www 2000 w 2000 www 2000 w 2000 w 4000 3000 1000 3000 Amount Left in Yard 3250 850 3500 9500 1300 2000 160 200 1570 2010 290 290 3960 3980 850 630 1100 2000 2000 1000 1000 300 300 230 250 630 www 2230 2250 1770 200 280 1220 www 90 30 340 340 1000 480 400 1100 2500 450 1040 25 3960 440 www. 1060 300 300 950 1290 2000 900 1480 930 770 Arrival Date 04-Feb 11-Feb 12-Feb sveo 27-Feb 02-Mar 04-Mar www 11-Mar 12-Mar 13-Mar 13-Mar 14-Mar -ALAL 18-Mar 16-Mar 20-Mar 24-Mar 24-Mar 26-Mar 26-Mar 05-Apr 05-Apr 07-Apr 11.Apr 11-Apr 17-Apr 18-Apr 25-Apr 28-Apr 28-Apr 30-Apr 30-Apr 01-May 05-May 10-May 16-May 29-May 02-Jun www. 07-Jun 12-Jun 24-Jun 25-Jun 26-Jun 02-Jul 06-Jul 10-Jul Bay 11-Jul 14-Jul 23-Jul 25-Jul + Reason left in yard Not received in system (Yard) Not received in system (Yard) Misplaced in Warehouse Delay in Staging Misplaced in Warehouse Misplaced in Warehouse Others Others Warehouse is full Delay in Staging Warehouse is full Not received in system (Yard) Misplaced in Warehouse Delay in Staging Others Delay in Staging Misplaced in Warehouse Misplaced in Warehouse Others Others Not received in system (Yard) Warehouse is full Delay in Staging Misplaced in Warehouse Not received in system (Yard) Delay in Staging Misplaced in Warehouse Misplaced in Warehouse Misplaced in Warehouse Others Misplaced in Warehouse OL Others Warehouse is full Delay in Staging Delay in Staging Warehouse is full Others Law by www Not received in system (Yard) Not received in system (Yard) Misplaced in Warehouse Misplaced in Warehouse Delay in Staging B124STWS B76KWIJ B241GRPJ B124GRPS B76WMLS MODDA B76ORGS B124APPJ B76STWJ B241STWS B241STWS 22000 18000 27000 24000 19000 23000 23000 12000 29000 13000 19000 16000 23000 20000 18000 ***** 19000 00000 20000 11000 28000 12000 26-Jul 28-Jul 31-Jul 06-Aug 08-Aug 14-Aug 15-Aug 20-Aug 22-Aug 26-Aug Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line 1381085344 1391282703 1391612087 1444242099 1508617750 ********* 1509407174 1509722615 1510204561 1518107959 1557455980 3000 2000 4000 4000 www. 1000 4000 4000 2000 3000 1000 1000 1000 770 1680 150 3600 160 1200 1080 380 650 750 25-Jul 27-Jul 30-Jul 05-Aug 07-Aug 13-Aug 14-Aug 19-Aug 21-Aug 25-Aug Delay in Staging Misplaced in Warehouse Not received in system (Yard) Not received in system (Yard) Warehouse is full Not received in system (Yard) Warehouse is full Warehouse is full Misplaced in Warehouse Not received in system (Yard) Company Background Juice-Perfect, a California-based juice manufacturing company, has 6 manufacturing plants around the US that produce various sizes and flavor of juices and smoothies. In recent years, management noticed that Juice-Perfect's market share has been decreasing due to its inability to sustain the level of expectations and market demands. A group of internal analysts conducted a thorough investigation of the root causes of the performance decline and published a report that identified problems in the production planning of Juice-Perfect's manufacturing operations as the critical factors. In response, leadership at the company decided to contract a team to help identify improvement areas in the production planning and propose a plan to reform the manufacturing processes across all plants. Management has decided to pilot the changes on the packaging lines only at one of the plants (that is the worst performing plant). Using internal performance metrics (Appendix A), Juice-Perfect want to identify the worst performing plant in their network. Hence, analyse this data and identify the worst performing plant. With an aim to boost the day-to-day operations of this plant, analyse the data in Appendix B to enable Juice-Perfect to uncover specific problems faced within the plant's filling/packaging line and recommend improvement strategies that they would be able to implement nationwide. APPENDIX: A. Yearly Performance Overview B. Inventory Delays Appendix A Illinois North Carolina Texas California Georgia Florida Plant/Metrics Total Annual Run-time (hr.) 4,380 6,570 8,760 7,665 10,950 4,380 Annual Planned Downtown (hr.) 100 130 240 192.5 250 120 Annual Unplanned Downtime (hr.) 219 361.35 525.6 536.55 1095 657 MTBF (min) 1,421 1,206 981 789 949 300 MTTR (min) 52 55 54 56 55 55 Planned Annual Production 28,000,000 30,000,000 46,000,000 50,000,000 65,000,000 36,000,000 Appendix B SKU ID - B241APPJ B76ORGJ B241STWS 1ST we B124KWIJ B124ORGJ B241APPS B241APPS B24TAPPS B76STWS B124APPJ B124ORGJ B76GRPJ B76KWIS DYOKWIS B241GRPS DEFTONES B124KWIS DIZHNWIS B76ORGS DIGOROS B/GORGJ B76ORGI B124APPS BI2-APPS B124GRPJ B76ORGJ B124WMLS DI24WALLS B76KWIJ B124GRPJ B124ORGJ B241APPJ B76WALI B76WMLJ B241GRPJ B124APPS B76WMLS wwwasse B124KWIS pewa B76ORGJ B76ORGS B B124KWIJ B124ORGI Pres B124APPJ B241WMLS B76KWIS B241WMLJ B124KWIJ B76ORGJ B124STWS Planned Amount 17000 17000 15000 www 13000 ***** 18000 21000 24000 17000 14000 11000 20000 26000 24000 24000 30000 19:000 19000 9000 11000 11000 12000 12000 11000 11000 20000 16000 10000 16000 10000 10000 10000 16000 16000 27000 17000 16000 www 28000 wwwww 27000 24000 www 25000 23000 14000 www 12000 10000 16000 wwwww 15000 www 18000 ***** 30000 25000 23000 22000 Bottles Available in Storage 13000 16000 11000 www 10000 ***** 17000 ***** 17000 21000 21000 13000 13000 13000 13000 8000 0000 23000 23000 22000 22000 29000 29000 20000 18000 8000 0000 0000 8000 10000 10000 10000 10000 18000 10000 14000 *1000 15000 25000 0000 6000 8000 13000 24000 24000 16000 14000 26000 wwwww 23000 www 23000 ***** 23000 20000 11000 wwwww 10000 www 14000 www 13000 www 16000 wwwww 26000 22000 22000 19000 + Planned Production Date 05-Feb Us-reb 12-Feb 12-reb 13-Feb TU-TED 28-Feb 03-Mar www OP-ALAL 05-Mar 12-Mar 12-Mar 13-Mar 14-Mar 15-Mar 15-Mar 19-Mar 19-wat 21-Mar 21-Mar 25-Mar 27-Mar 06-Apr 08-Apr 12-Apr 18-Apr 19-Apr 26-Apr 26-Apr 29-Apr 01-May 02-May 06-May 11-Mar 17-May 30-May 03-Jun 08-Jun 13-Jun 25-Jun 26-Jun 27-Jun 03-Jul 07-Jul 11-Jul 12-Jul 15-Jul 24-Jul 26-Jul Unmet Production Reason Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line |Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line |Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Bottle Shipment ID 44000670 84661365 91040117 143233333 ETOBOOOOO 162847032 wwwwwwww 166441474 concom 232555599 255215557 270699959 276040414 330312002 330012002 333415670 300+13070 371493752 371695588 439547282 43954/262 543016700 543010/00 636927028 090921020 648775432 646715400 702929209 102929209 715158568 1131509:00 769939888 772429939 12429999 789365699 816375544 829968106 837545234 853214184 888544595 958295862 www2/2002 983749211 wwwmast 1008980093 1000900090 1040446071 TUTOTHOUSE 1067660308 1081990792 www.vive 1092498837 w 1169339254 *** 1210704094 1349719711 1375164782 1381085344 Total Amount Shipped 4000 1000 4000 3000 1000 **** 4000 3000 4000 4000 1000 1000 3000 3000 3000 3000 2000 2000 1000 1000 1000 1000 1000 1000 3000 3000 2000 2000 1000 1000 2000 2000 2000 1000 1000 4000 1000 2000 2000 3000 3000 3000 1000 2000 2000 www 4000 www 1000 2000 2000 w 3000 www 2000 w 2000 www 2000 w 2000 w 4000 3000 1000 3000 Amount Left in Yard 3250 850 3500 9500 1300 2000 160 200 1570 2010 290 290 3960 3980 850 630 1100 2000 2000 1000 1000 300 300 230 250 630 www 2230 2250 1770 200 280 1220 www 90 30 340 340 1000 480 400 1100 2500 450 1040 25 3960 440 www. 1060 300 300 950 1290 2000 900 1480 930 770 Arrival Date 04-Feb 11-Feb 12-Feb sveo 27-Feb 02-Mar 04-Mar www 11-Mar 12-Mar 13-Mar 13-Mar 14-Mar -ALAL 18-Mar 16-Mar 20-Mar 24-Mar 24-Mar 26-Mar 26-Mar 05-Apr 05-Apr 07-Apr 11.Apr 11-Apr 17-Apr 18-Apr 25-Apr 28-Apr 28-Apr 30-Apr 30-Apr 01-May 05-May 10-May 16-May 29-May 02-Jun www. 07-Jun 12-Jun 24-Jun 25-Jun 26-Jun 02-Jul 06-Jul 10-Jul Bay 11-Jul 14-Jul 23-Jul 25-Jul + Reason left in yard Not received in system (Yard) Not received in system (Yard) Misplaced in Warehouse Delay in Staging Misplaced in Warehouse Misplaced in Warehouse Others Others Warehouse is full Delay in Staging Warehouse is full Not received in system (Yard) Misplaced in Warehouse Delay in Staging Others Delay in Staging Misplaced in Warehouse Misplaced in Warehouse Others Others Not received in system (Yard) Warehouse is full Delay in Staging Misplaced in Warehouse Not received in system (Yard) Delay in Staging Misplaced in Warehouse Misplaced in Warehouse Misplaced in Warehouse Others Misplaced in Warehouse OL Others Warehouse is full Delay in Staging Delay in Staging Warehouse is full Others Law by www Not received in system (Yard) Not received in system (Yard) Misplaced in Warehouse Misplaced in Warehouse Delay in Staging B124STWS B76KWIJ B241GRPJ B124GRPS B76WMLS MODDA B76ORGS B124APPJ B76STWJ B241STWS B241STWS 22000 18000 27000 24000 19000 23000 23000 12000 29000 13000 19000 16000 23000 20000 18000 ***** 19000 00000 20000 11000 28000 12000 26-Jul 28-Jul 31-Jul 06-Aug 08-Aug 14-Aug 15-Aug 20-Aug 22-Aug 26-Aug Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line Not enough bottle in production line 1381085344 1391282703 1391612087 1444242099 1508617750 ********* 1509407174 1509722615 1510204561 1518107959 1557455980 3000 2000 4000 4000 www. 1000 4000 4000 2000 3000 1000 1000 1000 770 1680 150 3600 160 1200 1080 380 650 750 25-Jul 27-Jul 30-Jul 05-Aug 07-Aug 13-Aug 14-Aug 19-Aug 21-Aug 25-Aug Delay in Staging Misplaced in Warehouse Not received in system (Yard) Not received in system (Yard) Warehouse is full Not received in system (Yard) Warehouse is full Warehouse is full Misplaced in Warehouse Not received in system (Yard) Company Background Juice-Perfect, a California-based juice manufacturing company, has 6 manufacturing plants around the US that produce various sizes and flavor of juices and smoothies. In recent years, management noticed that Juice-Perfect's market share has been decreasing due to its inability to sustain the level of expectations and market demands. A group of internal analysts conducted a thorough investigation of the root causes of the performance decline and published a report that identified problems in the production planning of Juice-Perfect's manufacturing operations as the critical factors. In response, leadership at the company decided to contract a team to help identify improvement areas in the production planning and propose a plan to reform the manufacturing processes across all plants. Management has decided to pilot the changes on the packaging lines only at one of the plants (that is the worst performing plant). Using internal performance metrics (Appendix A), Juice-Perfect want to identify the worst performing plant in their network. Hence, analyse this data and identify the worst performing plant. With an aim to boost the day-to-day operations of this plant, analyse the data in Appendix B to enable Juice-Perfect to uncover specific problems faced within the plant's filling/packaging line and recommend improvement strategies that they would be able to implement nationwide. APPENDIX: A. Yearly Performance Overview B. Inventory Delays Appendix A Illinois North Carolina Texas California Georgia Florida Plant/Metrics Total Annual Run-time (hr.) 4,380 6,570 8,760 7,665 10,950 4,380 Annual Planned Downtown (hr.) 100 130 240 192.5 250 120 Annual Unplanned Downtime (hr.) 219 361.35 525.6 536.55 1095 657 MTBF (min) 1,421 1,206 981 789 949 300 MTTR (min) 52 55 54 56 55 55 Planned Annual Production 28,000,000 30,000,000 46,000,000 50,000,000 65,000,000 36,000,000