My Question: For product E, what is the combined standard deviation of lead time and demand? (rounded to the nearest int

[answerhappygod]

My Question: For product E, what is the combined standard deviation of lead time and demand? (rounded to the nearest integer, e.g xx.xx-->xx)
______________________________________________________________________________________________________
The following information was provided to find the answer:
D = Demand
V = Value of item
O = Order Cost
C = inventory carrying cost

My Question For Product E What Is The Combined Standard Deviation Of Lead Time And Demand Rounded To The Nearest Int 1 (148.07 KiB) Viewed 32 times

Better photo of values from safety stock assignment:

My Question For Product E What Is The Combined Standard Deviation Of Lead Time And Demand Rounded To The Nearest Int 2 (118.05 KiB) Viewed 32 times

My Question For Product E What Is The Combined Standard Deviation Of Lead Time And Demand Rounded To The Nearest Int 3 (111.64 KiB) Viewed 32 times

1 2 3 4 Inventory Quiz To complete the inventory Quiz, you must follow the directions below: Step 1: Use the values below to calculate the EOQ, Order Cost, Holding Cost, and Total Cost (hint: your quantity to calculate the costs should be the EQQ): 6780 D 9 10 11 V 12 13 14 15 16 17 18 19 20 21 22 O 23 24 25 26 27 28 29 30 31 32 с с Product A 75000 $20 $30 22.5% 96 98 103 97 104 96 103 103 103 103 99 103 100 105 96 97 103 100 102 100 97 99 95 99 102 105 100 96 101 98 Safety Stock Assignment.csv Step 2: Use the values below to calculate safety stock: 3 3 Product B 2 10000 2 $50 2 $80 107 94 98 100 95 106 102 104 95 90 107 103 90 104 103 103 92 94 108 104 100 94 93 106 102 102 94 93 93 97 20% Step 3: Use the values above (from the Safety Stock Assignment) to calculate lead-time-demand: 4 Step 4: Once you have made all those calculations, save your answers in a convenient place and you have all the answers to the quiz questions. 4 4 5 Product C 4 20000 Product Al Product B Product C Product D Product E Demand Order Lea Demand Order Lea Demand Order Lea Demand Order Lea Demand Order Lead Time 3 4 7 8 11 164 156 161 155 152 155 153 150 151 158 159 154 159 155 154 162 $8000 158 164 158 154 162 159 152 163 150 153 154 153 152 150 $300 15% 7 7 Product D 8 45000 6 $4 6 $40 22.5% 168 200 194 177 172 195 193 191 182 181 161 189 171 174 163 195 190 178 198 166 187 166 186 167 172 182 176 169 166 187 co 10 Product E 9 100000 00 $62.50 $200 25% 10 217 190 184 196 185 208 196 199 219 204 215 182 212 196 181 200 210 213 209 208 191 216 199 188 183 219 217 205 219 202 11 11 13 10 13
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Product A Demand Order Lead Time 96 98 103 97 104 96 103 103 103 103 99 103 100 105 96 97 103 100 102 100 97 99 95 99 102 105 100 96 101 98 3 3 3 2 2 2 Product B Demand 107 94 98 100 95 106 102 104 95 90 107 103 90 104 103 103 92 94 108 104 100 94 93 106 102 102 94 93 93 97 Order Lead Time 4 4 4 4 5 4 Product C Demand 164 156 161 155 152 155 153 150 151 158 159 154 159 155 154 162 158 164 158 154 162 159 152 163 150 153 154 153 152 150 Order Lead Time 7 0 7 7 8 6 6 Product D Demand 168 200 194 177 172 195 193 191 182 181 161 189 171 174 163 195 190 178 198 166 187 166 186 167 172 182 176 169 166 187 Order Lead Time 8 8 10 9 8 10 Product E Demand 217 190 184 196 185 208 196 199 219 204 215 182 212 196 181 200 210 213 209 208 191 216 199 188 183 219 217 205 219 202 Order Lead Time 11 11 11 0 13. 10 13 0
Economic Order Quantity Terms and Notation The Economic Order Quantity Calculation Please remember the following notation of the formulas: TC = Total Cost of Ordering and Holding Inventory Q = Order Quantity (how much we order each time) D = Demand (how much we sell in a given period - usually one year) V = Value of the item (purchase cost or production cost) O = Order Cost (on-time cost of placing and receiving an order) C = Inventory Carrying Cost (expressed as a percentage of the value of the item)
The Safety Stock Calculation Please review the following notation: SS = safety stock k= service factor Note: number of standard deviations to cover for a given service level Sc combined standard deviation of lead time and demand t = average replenishment lead time Sd standard deviation of daily sales d = average daily sales St= standard deviation of replenishment cycle Step 1: Calculate the Combined Standard Deviation of Lead Time and Demand S = √√txS² + d²×S₁² Sc 2 x Step 2: Pick your desired Service Level
Step 3: Calculate the Safety Stock SS = kxSc C Average Demand (d) Standard Deviation of Demand (Sd) Average Lead Time (t) Standard Deviation of Lead Time (St) Service Level (Percentage) Service Level (k) Combined Standard Deviation (Sc) Safety Stock (SS) 19.73 2.78 5.67 1.51 95% 1.64 30.43 50.06
Step 2: Pick your desired Service Level This step depends on how much inventory you can carry to prevent a stockout. The higher the service level the more inventory you need to carry. Most companies pick a service level between 90% and 99%. Service Level (Percentage) 120.00 90.00 60.00 30.00 0.00 Service Level (Percentage) 90% 93% 95% Step 3: Calculate the Safety Stock 98% 100% Safety Stock