4. According to the picture below, answer the following questions. Schedule start from 5/22/2017 9:00 Work hours 12 per day: 8 8 8 8 Work 23/5 24/5 25/5 Qty. Centre A01 Shortage 1 15.5 Order No. Product 170001 AB009 170002 AB010 170003 AB009 170004 AB007 A02 0 198.0 A03 0 1 A04 A05 1 216.1 377.0 374.4 170005 170006 170007 46.0 A06 0 AB009 AB012 AB012 AB013 AB 001 A07 1 170008 A08 1 429.2 395.4 255.0 289.2 251.2 341.5 309.2 190.0 21.6 B01 0 170009 170010 170011 B02 1 Order Due SN Loading BTP Date M (Hour) Ref. 4800 365 23/5/2017 24 146.00 1 4800 420 24/5/2017 40 280.00 2 4800 300 25/5/2017 24 120.00 3 4000 500 23/5/2017 31 258.33 4 4000 800 24/5/2017 24 320.00 5 4000 1000 25/5/2017 25 416.67 6 2000 1200 23/5/2017 25 500.00 7 2000 1100 24/5/2017 20 366.67 8 2000 700 25/5/2017 30 350.00 9 900 600 23/5/2017 30 300.00 10 2000 1000 24/5/2017 25 416.67 11 3200 1100 25/5/2017 20 366.67 12 2000 1100 23/5/2017 22 403.33 13 2000 900 24/5/2017 32 480.00 14 1000 700 25/5/2017 36 420.00 15 1200 700 23/5/2017 36 420.00 16 1200 700 24/5/2017 20 233.33 17 1200 1100 25/5/2017 22 403.33 18 4000 700 23/5/2017 32 373.33 19 3000 700 23/5/2017 34 396.67 20 1000 1000 5/30/2017 31 1 1000 1000 5/30/2017 25 1 1200 1200 5/30/2017 24 1 B03 Work Accum. Accum. Hours OEE WS Capacity Loading Surplus 8 69.9% 25 139.80 146.00 6.20 16 77.1% 24 296.06 280.00 16.06 24 75.9% 26 473.62 120.00 353.62 8 76.4% 24 146.69 258.33 111.65 16 75.4% 25 301.60 320.00 18.40 24 78.0% 25 468.00 416.67 51.33 8 82.8% 27 178.85 500.00 321.15 16 65.9% 25 263.60 366.67 103.07 24 66.4% 24 382.46 350.00 32.46 8 72.3% 25 144.60 300.00 155.40 16 72.6% 25 290.40 416.67 126.27 24 72.3% 25 433.80 366.67 67.13 8 75.1% 25 150.20 403.33 253.13 16 78.9% 26 328.22 480.00 151.78 24 77.4% 464.40 420.00 44.40 8 78.3% 24 150.34 420.00 269.66 16 63.4% 26 263.74 233.33 30.41 24 70.4% 24 405.50 403.33 2.17 8 62.8% 25 125.60 373.33 247.73 8 62.1% 25 124.20 396.67 272.47 56 69.9% 25 978.60 146.00 832.60 56 69.9% 25 978.60 146.00 832.60 56 69.9% 25 978.60 146.00 832.60 1 348.5 303.0 22/5 Start Date Finish Date 5/22/2017 9:00 5/23/2017 9:15 349.5 5/22/2017 9:00 5/23/2017 12:17 222.0 5/22/2017 9:00 5/22/2017 14:00 300.0 5/22/2017 9:00 5/23/2017 12:36 283.9 5/22/2017 9:00 5/24/2017 9:46 377.0 5/22/2017 9:00 5/24/2017 13:11 374.4 5/22/2017 9:00 5/24/2017 14:41 429.2 5/22/2017 9:00 5/24/2017 14:09 395.4 5/22/2017 9:00 5/24/2017 12:10 255.0 5/22/2017 9:00 5/24/2017 9:21 289.2 5/22/2017 9:00 5/24/2017 14:03 348.5 5/22/2017 9:00 5/24/2017 12:52 433.8 5/22/2017 9:00 5/24/2017 13:40 409.6 5/22/2017 9:00 5/24/2017 13:44 307.7 5/22/2017 9.00 5/24/2017 12:04 258.0 5/22/2017 9:00 5/24/2017 12:18 250.6 5/22/2017 9:00 5/23/2017 14:04 395.6 5/22/2017 9:00 5/24/2017 15:02 368.6 5/22/2017 9:00 5/24/2017 12:49 235.5 5/22/2017 9:00 5/25/2017 9:42 219.2 5/22/2017 9:00 5/25/2017 12:08 270.6 5/25/2017 12:08 5/27/2017 14:34 5/27/2017 14:34 6/1/2017 11:41 B04 0 433.8 409.6 232.4 280.7 B05 1 1 307.7 284.6 170012 170013 170014 170015 170016 170017 170018 B06 B07 25 0 258.0 184.0 B08 AB001 AB002 AB003 AB004 AB005 AB020 AB020 AB023 AB024 AB025 AB026 AB027 AB028 AB029 1 250.6 198.9 C01 0 304.4 CO2 0 362.7 1 368.6 235.5 219.2 229.0 C04 1 219.2 42.5 170019 170020 170021 170022 170023 A01 0 270.6 270.6 188.3 A01 0 330.0 A01 0 4.1 What is an MRP-II? 4.2 If there is a shortage in the given table, how can we manage planning in order to minimize the shortage condition? ( 3 points) 4.3 There are 2 major concept of scheduling: Forward and Backward. Compare the major advantages of these scheduling concepts. (3 points) Forward Scheduling Backward Scheduling BE B E Today Due Date Today Due Date 4. According to the picture below, answer the following questions. Schedule start from 5/22/2017 9:00 Work hours 12 per day: 8 8 8 8 Work 23/5 24/5 25/5 Qty. Centre A01 Shortage 1 15.5 Order No. Product 170001 AB009 170002 AB010 170003 AB009 170004 AB007 A02 0 198.0 A03 0 1 A04 A05 1 216.1 377.0 374.4 170005 170006 170007 46.0 A06 0 AB009 AB012 AB012 AB013 AB 001 A07 1 170008 A08 1 429.2 395.4 255.0 289.2 251.2 341.5 309.2 190.0 21.6 B01 0 170009 170010 170011 B02 1 Order Due SN Loading BTP Date M (Hour) Ref. 4800 365 23/5/2017 24 146.00 1 4800 420 24/5/2017 40 280.00 2 4800 300 25/5/2017 24 120.00 3 4000 500 23/5/2017 31 258.33 4 4000 800 24/5/2017 24 320.00 5 4000 1000 25/5/2017 25 416.67 6 2000 1200 23/5/2017 25 500.00 7 2000 1100 24/5/2017 20 366.67 8 2000 700 25/5/2017 30 350.00 9 900 600 23/5/2017 30 300.00 10 2000 1000 24/5/2017 25 416.67 11 3200 1100 25/5/2017 20 366.67 12 2000 1100 23/5/2017 22 403.33 13 2000 900 24/5/2017 32 480.00 14 1000 700 25/5/2017 36 420.00 15 1200 700 23/5/2017 36 420.00 16 1200 700 24/5/2017 20 233.33 17 1200 1100 25/5/2017 22 403.33 18 4000 700 23/5/2017 32 373.33 19 3000 700 23/5/2017 34 396.67 20 1000 1000 5/30/2017 31 1 1000 1000 5/30/2017 25 1 1200 1200 5/30/2017 24 1 B03 Work Accum. Accum. Hours OEE WS Capacity Loading Surplus 8 69.9% 25 139.80 146.00 6.20 16 77.1% 24 296.06 280.00 16.06 24 75.9% 26 473.62 120.00 353.62 8 76.4% 24 146.69 258.33 111.65 16 75.4% 25 301.60 320.00 18.40 24 78.0% 25 468.00 416.67 51.33 8 82.8% 27 178.85 500.00 321.15 16 65.9% 25 263.60 366.67 103.07 24 66.4% 24 382.46 350.00 32.46 8 72.3% 25 144.60 300.00 155.40 16 72.6% 25 290.40 416.67 126.27 24 72.3% 25 433.80 366.67 67.13 8 75.1% 25 150.20 403.33 253.13 16 78.9% 26 328.22 480.00 151.78 24 77.4% 464.40 420.00 44.40 8 78.3% 24 150.34 420.00 269.66 16 63.4% 26 263.74 233.33 30.41 24 70.4% 24 405.50 403.33 2.17 8 62.8% 25 125.60 373.33 247.73 8 62.1% 25 124.20 396.67 272.47 56 69.9% 25 978.60 146.00 832.60 56 69.9% 25 978.60 146.00 832.60 56 69.9% 25 978.60 146.00 832.60 1 348.5 303.0 22/5 Start Date Finish Date 5/22/2017 9:00 5/23/2017 9:15 349.5 5/22/2017 9:00 5/23/2017 12:17 222.0 5/22/2017 9:00 5/22/2017 14:00 300.0 5/22/2017 9:00 5/23/2017 12:36 283.9 5/22/2017 9:00 5/24/2017 9:46 377.0 5/22/2017 9:00 5/24/2017 13:11 374.4 5/22/2017 9:00 5/24/2017 14:41 429.2 5/22/2017 9:00 5/24/2017 14:09 395.4 5/22/2017 9:00 5/24/2017 12:10 255.0 5/22/2017 9:00 5/24/2017 9:21 289.2 5/22/2017 9:00 5/24/2017 14:03 348.5 5/22/2017 9:00 5/24/2017 12:52 433.8 5/22/2017 9:00 5/24/2017 13:40 409.6 5/22/2017 9:00 5/24/2017 13:44 307.7 5/22/2017 9.00 5/24/2017 12:04 258.0 5/22/2017 9:00 5/24/2017 12:18 250.6 5/22/2017 9:00 5/23/2017 14:04 395.6 5/22/2017 9:00 5/24/2017 15:02 368.6 5/22/2017 9:00 5/24/2017 12:49 235.5 5/22/2017 9:00 5/25/2017 9:42 219.2 5/22/2017 9:00 5/25/2017 12:08 270.6 5/25/2017 12:08 5/27/2017 14:34 5/27/2017 14:34 6/1/2017 11:41 B04 0 433.8 409.6 232.4 280.7 B05 1 1 307.7 284.6 170012 170013 170014 170015 170016 170017 170018 B06 B07 25 0 258.0 184.0 B08 AB001 AB002 AB003 AB004 AB005 AB020 AB020 AB023 AB024 AB025 AB026 AB027 AB028 AB029 1 250.6 198.9 C01 0 304.4 CO2 0 362.7 1 368.6 235.5 219.2 229.0 C04 1 219.2 42.5 170019 170020 170021 170022 170023 A01 0 270.6 270.6 188.3 A01 0 330.0 A01 0 4.1 What is an MRP-II? 4.2 If there is a shortage in the given table, how can we manage planning in order to minimize the shortage condition? ( 3 points) 4.3 There are 2 major concept of scheduling: Forward and Backward. Compare the major advantages of these scheduling concepts. (3 points) Forward Scheduling Backward Scheduling BE B E Today Due Date Today Due Date