Please Help!

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 Product Y 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) 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) 2. 3 5 57 8 9 10 Week 2019 Product W Product X Product Y Product Z 1 33 55 251 201 33 52 251 201 34 56 248 206 4 33 56 248 199 35 55 246 200 6 58 256 208 7 35 246 200 39 57 249 203 40 54 247 205 43 57 247 203 11 42 58 240 205 12 45 56 241 204 13 47 63 245 200 14 54 238 204 15 46 57 240 205 16 50 52 246 205 17 47 65 239 203 18 48 58 244 205 51 63 240 204 20 50 56 236 205 21 49 59 244 206 22 56 68 237 203 23 53 70 239 205 24 55 59 238 212 47 19 25 26 69 65 27 66 288 56 58 59 62 61 60 58 66 57 65 59 68 70 66 64 65 67 63 72 67 73 69 237 230 238 235 235 232 232 230 229 226 230 228 229 227 229 226 225 224 225 215 225 222 223 72 64 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 204 212 206 207 208 205 210 203 206 209 211 211 205 208 206 205 211 212 206 207 209 210 212 209 211 216 65 70 70 67 74 70 77 76 80 78 76 74 78 84 72 68 74 69 76 76 76 73 72 78 78 49 222 222 223 50 50 84 51 52 83 77 2976 78 80 75 3375 223 222 215 12,212 216 210 213 10,734 Total Week Order Receiving Date Date of Placing Order Product W 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 5 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 8 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 4/17/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 25 6/19/19 6/23/19 6/21/19 6/21/19 6/21/19 26 6/26/19 7/1/19 6/30/19 6/27/19 6/27/19 27 7/3/19 7/10/19 7/5/19 7/3/19 7/3/19 28 7/10/19 7/13/19 7/11/19 7/12/19 7/12/19 29 7/17/19 7/19/19 7/19/19 7/18/19 7/18/19 30 7/24/19 7/27/19 7/26/19 7/25/19 7/24/19 31 7/31/19 8/8/19 8/2/19 8/2/19 8/2/19 32 8/7/19 8/13/19 8/10/19 8/9/19 8/9/19 33 8/14/19 8/17/19 8/16/19 8/15/19 8/15/19 34 8/21/19 8/26/19 8/23/19 8/23/19 8/23/19 35 8/28/19 9/4/19 9/1/19 8/30/19 8/30/19 36 9/4/19 9/9/19 9/8/19 9/5/19 9/5/19 37 9/11/19 9/18/19 9/14/19 9/12/19 9/12/19 38 9/18/19 9/23/19 9/20/19 9/19/19 9/19/19 39 9/25/19 9/28/19 9/29/19 9/26/19 9/26/19 40 10/2/19 10/8/19 10/5/19 10/2/19 10/2/19 41 10/9/19 10/12/19 10/13/19 10/11/19 10/11/19 Salor into10 40 41 42 43 44 45 46 47 48 49 50 51 52 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 12/18/19 12/25/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 12/23/19 12/28/19 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 12/21/19 12/29/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 12/19/19 12/27/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 12/19/19 12/27/19