Based on the following question down below I would like to know if my calculations for lead time in weeks , stock out percentage and total cost are correct

I'll show my working via a google spread sheet and some photos first then i'll show you the question

https://docs.google.com/spreadsheets/d/1L8s7kjshd-Xl37lYXn2qz9w8SsJ2KtiX/edit?usp=sharing&ouid=100311700343754498653&rtpof=true&sd=true - this is the link to my calculations

Cost Data Uniform Distribution F(D)LL Demand Order Quantity 350.00 MIN 0 Initial Inventory 140 MAX 8 0.05 Reordering Inventory base 60 0.12 Stockouts Cost 100.00 0.24 Factory Order Cost 300.00 0.42 Holding Unit Cost 20.00 0.69 0.91 Number of Weeks RN Demand Lead time in week for uniform dist Re ordering base Total Order Total Holding UnitCost Sold Units Total Cost Profit 1 0. 16 =VLOOKUP(C15,$J$4:$K$11,2, TRUE) 99 $ 17.14 $ 3,500.00 60 $ 3,517 $ 0.88 35 99 $ 30.00 $ 3,500.00 20 $ 3,530 C N 0.24 20 74 17.14 3,500.00 35 $ 3,517 4 0.87 35 266 $ 30.00 3,500.00 30 $ 3,530 5 0.63 30 127 25.71 $ 3,500.00 35 $ 3,526 6 0.82 35 194 $ 30.00 3,500.00 25 $ 3,530 51 0.87 35 146 $ 30.00 3,500.00 35 $ 3,530 52 0.82 35 218 $ 30.00 3,500.00 60 3,530Cost Data Uniform Distribution F(D)LL Demand Order Quantity $ 350.00 MIN 0 Initial Inventory 140 MAX CO 0.05 Reordering Inventory base 60 0.12 Stockouts Cost 100.00 0.24 Factory Order Cost 300.00 0.42 Holding Unit Cost 20.00 0.69 0.91 Number of Weeks RN Demand Lead time in week for uniform dist Re ordering base Total Order Total Holding UnitCost Sold Units Total Cost Profit 1 0.43 30 =$G$5+($G$6-$G$5)*RAND() 82 $ 25.71 $ 3,500.00 60 $ 3,526 $ N 0.48 30 $ 25.71 3,500.00 20 $ 3,526 3 0.20 20 O - U 23 $ 17.14 3,500.00 10 $ 3,517 4 0.03 10 63 $ 8.57 $ 3,500.00 30 $ 3,509 5 0.44 30 30 $ 25.71 3,500.00 30 $ 3,526 6 0.43 30 207 $ 25.71 3,500.00 20 $ 3,526 51 0.17 20 90 $ 17.14 3,500.00 20 $ 3,517 52 0.16 20 58 $ 17.14 3,500.00 60 $ 3,517Cost Data Uniform Distribution F(D)LL Demand Order Quantity 350.00 MIN 0 Initial Inventory 140 MAX CO 0.05 Reordering Inventory base 60 0.12 Stockouts Cost 100.00 0.24 Factory Order Cost 300.00 0.42 Holding Unit Cost 20.00 0.69 0.91 Number of Weeks RN Demand Lead time in week for uniform dist Re ordering base Total Order Total Holding UnitCost Sold Units Total Cost Profit 0.88 35 77 $ 30.00 =($C$5/2)*$C$10 60 $ 3,530 $ 0.63 30 198 $ 25.71 $ 3,500.00 30 $ 3,526 $ 0.59 30 93 $ 25.71 3,500.00 35 $ 3,526 4 0.84 35 280 $ 30.00 3,500.00 35 $ 3,530 $ - JANOOWN 0.90 35 68 $ 30.00 3,500.00 15 $ 3,530 $ 0.10 15 63 $ 12.86 3,500.00 20 $ 3,513 $ 51 0.39 25 187 $ 21.43 3,500.00 35 $ 3,521 $ 52 0.85 35 44 $ 30.00 3,500.00 60 $ 3,530Uniform Distribution F(D)LL Demand P(D) $ 350.00 MIN 0 10 140 MAX 8 0.05 15 60 0.12 20 100.00 0.24 25 300.00 0.42 30 20.00 0.69 35 0.91 40 RN Demand Lead time in week for uniform dist Re ordering base Total Order Total Holding UnitCost Sold Units Total Cost Profit Stock Out Percentage 0.94 40 8 67 $ 34.29 3,500.00 60 $ 3,534 $ (14.29) =($C$8/D15)*100 0.28 25 IN 44 $ 21.43 3,500.00 35 $ 3,521 $ (1.43) 0.77 35 $ 30.00 3,500.00 40 $ 3,530 (10.00) 0.95 40 43 $ 34.29 3,500.00 35 $ 3,534 (14.29) 0.75 35 w - 90 $ 30.00 3,500.00 30 $ 3,530 (10.00) 0.43 30 131 $ 25.71 3,500.00 35 $ 3,526 (5.71) 0.88 35 130 $ 30.00 3,500.00 40 $ 3,530 (10.00) 0.92 40 6 241 $ 34.29 $ 3,500.00 60 $ 3,534 (14.29)Your group has been contracted to work on a project for a London-based company, operating in the Caribbean. The name of the company is Shoe Maniac. Shoe Maniac manages a chain of shoe stores. Your group met with the management team of Shoe Maniac and gathered the following information. 0 Shoe Maniac's most popular product is the volcano-inspired, Magma Strappy Heeled Sandal. e The weekly demand for the Magma Strappy Heeled Sandal is given be the probability distribution below. (In your model use integers for all demands.) Demand Probability 10 0.05 15 0.07 20 0. 12 25 0. 18 30 0.27 0 Shoe Maniac replenishes its inventory by ordering 350 units from the distributor whenever its current inventory reaches 60 units. The lead time (in weeks} to receive an order from the distributor follows a continuous uniform distribution and takes between 1 and 8 weeks. 0 The cost to hold 1 unit in inventory for 1 week is $20. The cost to place an order with the factor}r is $300. Stockout costs are estimated at $100 per unit. The initial inventory level is 140 units. a} Simulate 52 weeks of operation to calculate the total cost and the percentage of stockouts for the period. Replicate these calculations 1000' times each to calculate the average values for these measures. Determine the 90% condence interval of the average total cost and the average percentage of stockouts. (10 marks)