please help! Steps please so I can understand!

2. After building a scientific way for demand forecasting, Mary hoped Jason can propose the optimal inventory/ordering policies for these 4 products for the first week of 2020. The sale price/unit for each product is listed below: Product W Product X Product Product Z $220 $50 $5 $3 Jason decided to use ABC rule to classify these 4 products. 'A' category product(s) will have the target service level of 95%. 'B' product(s) will have the target service level 90% and 'C' products(s) will have the target service level 85%. After setting the appropriate service level, Jason will use the service level information to calculate the safety stock level for each product. a) How should Jason classify the ABC products? (10 points) b) After classifying these 4 products, Jason wanted to use the ROP model for inventory/ordering management. He believed he would get an accurate demand forecasting for the first week of 2019. But based on the historical data. The attached spreadsheet document includes the order information for 2019. The company places the order of all products on each Wednesday, Jason found the lead time of orders has variations for all these 4 products. Which ROP model should Jason implement? (5 points) c) What are the reorder points for each of these 4 products for the first week of 2020? (30 points) 1 Sales infromation of each product of 2019 2 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 3 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 4 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 5 Week 2019 Week 2020 Week 2021 week 2022 Week 2023 6 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 7 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 8 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 9 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 10 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 11 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 12 Week 2019 Week 2020 Week 2021 week 2022 Week 2023 13 Week 2019 Week 2020 Week 2021 week 2022 Week 2023 14 Week 2019 Week 2020 Week 2021 week 2022 Week 2023 15 Week 2019 Week 2020 Week 2021 week 2022 Week 2023 16 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 17 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 18 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 19 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 20 Week 2019 Week 2020 Week 2021 142k 2022 Week 2023 21 Week 2019 Week 2020 Week 2021 week 2022 Week 2023 22 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 23 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 24 Week 2019 Week 2020 Week 2021 week 2022 Week 2023 25 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 26 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 27 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 28 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 29 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 30 Week 2019 Week 2020 Week 2021 week 2022 Week 2023 31 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 32 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 33 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 34 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 35 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 36 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 37 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 38 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 39 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 40 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 41 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 42 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 43 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 44 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 45 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 46 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 47 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 MAN .. AA 47 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 48 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 49 Week 2019 Week 2020 Week 2021 week 2022 Week 2023 50 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 51 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 52 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 53 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 54 Week 2019 Week 2020 Week 2021 Week 2022 Week 2023 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 2 Week 3 4 5 6 7 7 5 00 8 9 10 11 12 13 14 12 Order Receiving Date Date of Placing Order Product Product X Product Y Product z 1 1/2/19 1/5/19 1/5/19 1/4/19 1/4/19 2 1/9/19 1/15/19 1/11/19 1/11/19 1/11/19 3 1/16/19 1/17/19 1/19/19 1/16/19 1/17/19 4 1/23/19 1/25/19 1/25/19 1/24/19 1/24/19 1/30/19 2/5/19 2/2/19 1/30/19 1/29/19 6 2/6/19 2/11/19 2/10/19 2/8/19 2/8/19 7 2/13/19 2/17/19 2/17/19 2/13/19 2/13/19 2/20/19 2/25/19 2/23/19 2/23/19 2/23/19 9 2/27/19 3/3/19 3/1/19 2/28/19 2/28/19 10 3/6/19 3/11/19 3/9/19 3/8/19 3/9/19 11 3/13/19 3/16/19 3/15/19 3/15/19 3/15/19 12 3/20/19 3/26/19 3/23/19 3/21/19 3/21/19 13 3/27/19 4/2/19 3/30/19 3/28/19 3/28/19 14 4/3/19 4/8/19 4/5/19 4/4/19 4/4/19 15 4/10/19 4/15/19 4/13/19 4/11/19 4/10/19 16 4/17/19 4/22/19 4/20/19 +27/19 4/17/19 17 4/24/19 4/27/19 4/26/19 4/25/19 4/25/19 18 5/1/19 5/5/19 5/3/19 5/3/19 5/3/19 19 5/8/19 5/11/19 5/13/19 5/8/19 5/8/19 20 5/15/19 5/19/19 5/18/19 5/15/19 5/15/19 21 5/22/19 5/28/19 5/27/19 5/24/19 5/24/19 22 5/29/19 6/1/19 5/31/19 6/1/19 6/2/19 23 6/5/19 6/11/19 6/9/19 6/6/19 6/6/19 24 6/12/19 6/17/19 6/16/19 6/13/19 6/13/19 15 16 17 18 19 20 21 22 23 24 25 26 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 6/19/19 6/26/19 7/3/19 7/10/19 7/17/19 7/24/19 7/31/19 8/7/19 8/14/19 8/21/19 8/28/19 9/4/19 9/11/19 9/18/19 9/25/19 10/2/19 10/9/19 10/16/19 10/23/19 10/30/19 11/6/19 11/13/19 11/20/19 11/27/19 12/4/19 12/11/19 6/23/19 7/1/19 7/10/19 7/13/19 7/19/19 7/27/19 8/8/19 8/13/19 8/17/19 8/26/19 9/4/19 9/9/19 9/18/19 9/23/19 9/28/19 10/8/19 10/12/19 10/22/19 10/25/19 11/4/19 11/7/19 11/19/19 11/20/19 12/1/19 12/9/19 12/13/19 6/21/19 6/30/19 7/5/19 7/11/19 7/19/19 7/26/19 8/2/19 8/10/19 8/16/19 8/23/19 9/1/19 9/8/19 9/14/19 9/20/19 6/21/19 6/27/19 7/3/19 7/12/19 7/18/19 7/25/19 8/2/19 8/9/19 8/15/19 8/23/19 8/30/19 9/5/19 9/12/19 9/19/19 9/26/19 10/2/19 10/11/19 10/18/19 10/23/19 10/30/19 11/6/19 11/15/19 11/21/19 11/29/19 12/5/19 12/12/19 6/21/19 6/27/19 7/3/19 7/12/19 7/18/19 7/24/19 8/2/19 8/9/19 8/15/19 8/23/19 8/30/19 9/5/19 9/12/19 9/19/19 9/26/19 10/2/19 10/11/19 10/18/19 10/23/19 10/30/19 11/6/19 11/15/19 11/21/19 11/29/19 12/5/19 12/12/19 9/29/19 40 41 42 43 44 45 46 47 48 49 10/5/19 10/13/19 10/17/19 10/25/19 11/2/19 11/8/19 11/15/19 11/23/19 11/29/19 12/7/19 12/13/19 50 46 47 48 9 50 51 52 11/13/19 11/20/19 11/27/19 12/4/19 12/11/19 12/18/19 12/25/19 11/19/19 11/20/19 12/1/19 12/9/19 12/13/19 12/23/19 12/28/19 11/15/19 11/23/19 11/29/19 12/7/19 12/13/19 12/21/19 12/29/19 11/15/19 11/21/19 11/29/19 | 12/5/19 12/12/19 12/19/19 12/27/19 11/15/19 11/21/19 11/29/19 12/5/19 12/12/19 12/19/19 12/27/19 ON 10 43 16 2 Week 2019 3 1 4 2 5 3 6 4 7 5 8 9 7 10 8 11 9 12 13 11 14 12 15 13 16 14 17 15 18 19 17 20 18 21 19 22 20 23 21 24 22 25 23 26 24 27 25 28 26 29 27 30 28 31 29 32 30 33 31 34 32 35 33 36 34 37 35 38 36 39 40 38 41 39 40 Product W Product X Product Y Product Z 33 55 251 201 33 52 251 201 34 56 248 206 33 56 248 199 35 55 246 200 38 58 256 208 35 57 246 200 39 57 249 203 40 54 247 205 57 247 203 42 58 240 205 45 56 241 204 47 63 245 200 47 54 238 204 46 57 240 205 50 52 246 205 47 65 239 203 48 58 244 205 51 63 240 204 50 56 236 205 49 59 244 206 56 68 237 203 53 70 239 205 59 238 212 56 69 237 204 58 65 230 212 59 66 238 206 62 66 235 207 61 64 235 208 60 65 232 205 58 67 232 210 66 63 230 203 57 72 229 206 65 67 226 209 59 73 230 211 68 69 228 211 70 72 229 205 64 65 227 208 70 70 229 206 67 72 226 205 55 37 42 A B C D E F 64 65 208 38 39 70 70 227 229 226 206 67 72 68 74 70 77 40 41 42 43 44 45 46 47 205 211 212 206 207 74 69 76 76 80 76 209 76 225 224 225 215 225 222 223 222 222 223 222 78 76 210 73 72 48 49 50 51 52 74 78 84 83 77 78 78 80 75 212 209 211 216 210 213 215 1