*Please show how to get answer in excel by using Lead time is Variable and Demand is Constant for ROP*

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 2022. The sale price/unit for each product is listed below: Product W Product X 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? 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 2022. But based on the historical data. The attached spreadsheet document includes the order information for 2021. 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? c) What are the reorder points for each of these 4 products for the first week of 2022?

Lad Time fu Variable and Demand Is Constant When the demand as constant and onty the fead fime is narizkle, thernt [1214] where t.s. Standand deviation of lead time in days \begin{tabular}{|r|r|r|r|r|r|} \hline & & & \multicolumn{2}{|c|}{ Date of Receiving Order } \\ \hline Week & Date of Placing Order & Product W & Product X & Product Y & Product Z \\ \hline 1 & 1/6/2021 & 1/9/2021 & 1/9/2021 & 1/8/2021 & 1/8/2021 \\ \hline 2 & 1/13/2021 & 1/19/2021 & 1/15/2021 & 1/15/2021 & 1/15/2021 \\ \hline 3 & 1/20/2021 & 1/21/2021 & 1/23/2021 & 1/20/2021 & 1/21/2021 \\ \hline 4 & 1/27/2021 & 1/29/2021 & 1/29/2021 & 1/28/2021 & 1/28/2021 \\ \hline 5 & 2/3/2021 & 2/9/2021 & 2/6/2021 & 2/3/2021 & 2/4/2021 \\ \hline 6 & 2/10/2021 & 2/15/2021 & 2/14/2021 & 2/12/2021 & 2/12/2021 \\ \hline 7 & 2/17/2021 & 2/21/2021 & 2/21/2021 & 2/17/2021 & 2/17/2021 \\ \hline 8 & 2/24/2021 & 2/28/2021 & 2/27/2021 & 2/27/2021 & 2/27/2021 \\ \hline 9 & 3/2/2021 & 3/6/2021 & 3/4/2021 & 3/3/2021 & 3/3/2021 \\ \hline 10 & 3/9/2021 & 3/14/2021 & 3/12/2021 & 3/11/2021 & 3/12/2021 \\ \hline 11 & 3/16/2021 & 3/19/2021 & 3/18/2021 & 3/18/2021 & 3/18/2021 \\ \hline 12 & 3/23/2021 & 3/29/2021 & 3/26/2021 & 3/24/2021 & 3/24/2021 \\ \hline 13 & 3/30/2021 & 4/5/2021 & 4/2/2021 & 3/31/2021 & 3/31/2021 \\ \hline 14 & 4/6/2021 & 4/11/2021 & 4/8/2021 & 4/7/2021 & 4/7/2021 \\ \hline 15 & 4/13/2021 & 4/18/2021 & 4/16/2021 & 4/14/2021 & 4/13/2021 \\ \hline 16 & 4/20/2021 & 4/25/2021 & 4/23/2021 & 4/20/2021 & 4/20/2021 \\ \hline 17 & 4/27/2021 & 4/30/2021 & 4/29/2021 & 4/28/2021 & 4/28/2021 \\ \hline 18 & 5/4/2021 & 5/8/2021 & 5/6/2021 & 5/6/2021 & 5/6/2021 \\ \hline 19 & 5/11/2021 & 5/14/2021 & 5/16/2021 & 5/11/2021 & 5/11/2021 \\ \hline 20 & 5/18/2021 & 5/22/2021 & 5/21/2021 & 5/18/2021 & 5/18/2021 \\ \hline 21 & 5/25/2021 & 5/31/2021 & 5/30/2021 & 5/27/2021 & 5/27/2021 \\ \hline 22 & 6/1/2021 & 6/4/2021 & 6/3/2021 & 6/4/2021 & 6/5/2021 \\ \hline 23 & 6/8/2021 & 6/14/2021 & 6/12/2021 & 6/9/2021 & 6/9/2021 \\ \hline \end{tabular} Sales infromation of each product of 2021 Week 2021 Product W Product X Product Y Product Z \begin{tabular}{|r|r|r|r|r|} \hline 1 & 35 & 55 & 252 & 205 \\ \hline 2 & 34 & 51 & 253 & 203 \\ \hline 3 & 35 & 55 & 250 & 208 \\ \hline 4 & 34 & 55 & 250 & 201 \\ \hline 5 & 36 & 54 & 248 & 202 \\ \hline 6 & 39 & 57 & 258 & 210 \\ \hline 7 & 36 & 56 & 248 & 202 \\ \hline 8 & 40 & 56 & 251 & 205 \\ \hline 9 & 41 & 53 & 249 & 207 \\ \hline 10 & 44 & 56 & 249 & 205 \\ \hline 11 & 43 & 57 & 242 & 207 \\ \hline 12 & 46 & 55 & 243 & 206 \\ \hline 13 & 48 & 62 & 247 & 202 \\ \hline 14 & 48 & 53 & 240 & 206 \\ \hline 15 & 47 & 56 & 242 & 207 \\ \hline 16 & 51 & 51 & 248 & 207 \\ \hline 17 & 48 & 64 & 241 & 205 \\ \hline 18 & 49 & 57 & 246 & 207 \\ \hline 19 & 52 & 62 & 242 & 206 \\ \hline 20 & 51 & 55 & 238 & 207 \\ \hline 21 & 50 & 58 & 246 & 208 \\ \hline 22 & 57 & 67 & 239 & 205 \\ \hline 23 & 54 & 69 & 241 & 207 \\ \hline 24 & 56 & 58 & 240 & 214 \\ \hline 25 & 57 & 68 & 239 & 206 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|r|r|r|} \hline A & & & & C & \multicolumn{1}{|l|}{ b } \\ \hline 26 & 59 & 64 & 232 & 214 \\ \hline 27 & 60 & 65 & 240 & 208 \\ \hline 28 & 63 & 65 & 237 & 209 \\ \hline 29 & 62 & 63 & 237 & 210 \\ \hline 30 & 61 & 64 & 234 & 207 \\ \hline 31 & 59 & 66 & 234 & 212 \\ \hline 32 & 67 & 62 & 232 & 205 \\ \hline 33 & 58 & 71 & 231 & 208 & \\ \hline 34 & 66 & 66 & 228 & 211 & \\ \hline 35 & 60 & 72 & 232 & 213 & \\ \hline 36 & 69 & 68 & 230 & 213 \\ \hline 37 & 71 & 71 & 231 & 207 \\ \hline 38 & 65 & 64 & 229 & 210 \\ \hline 39 & 71 & 69 & 231 & 208 \\ \hline 40 & 68 & 71 & 228 & 207 \\ \hline 41 & 75 & 67 & 227 & 213 \\ \hline 42 & 71 & 73 & 226 & 214 \\ \hline 43 & 78 & 68 & 227 & 208 \\ \hline 44 & 77 & 75 & 217 & 209 \\ \hline 45 & 81 & 75 & 227 & 211 \\ \hline 46 & 79 & 75 & 224 & 212 \\ \hline 47 & 77 & 72 & 225 & 214 \\ \hline 48 & 75 & 71 & 224 & 211 \\ \hline 49 & 79 & 77 & 224 & 213 \\ \hline 50 & 85 & 77 & 225 & 218 \\ \hline 51 & 87 & 82 & 224 & 215 \\ \hline 52 & 80 & 76 & 219 & 217 \\ \hline \end{tabular}