By using the above Graph:

Answer the following

1. The demand in the above case is distributed:

1. Normally
2. Uniformly
3. Discreetly
4. None of the above

2. The following formula is used to calculate the mean closing stock

1. SUMIF(H8:H17,
2. AVERAGEIF(H8:H17,>0)
3. SUM(H8:H17)
4. AVERAGE(H8:H17)

3. Example of extension for logic model is

1. RANDBETWEEN(F3:F4)
2. NORMINV(RAND(), F3, F4)
3. Reorder unit, reorder level, and lead time
4. None of the above

4. When approximating cost with a cubic function, we will need to use the Excel solver. What is/are the changing cell/s?
   1. The squared deviations
   2. All coefficients
   3. Sum of square deviation
   4. Mean of the square deviation

B H A1 fx Stock simulation example D E F 1 Stock simulation example 2 3 Reorder le 200 lower demand limit 150 4 reorder qu: 300 upper demand level 250 5 Lead time o 6 Opening Quantity Quantity stock Day 7 Demand stock ordered delivered available 8 1 427 0 0 427 227 9 2 200 0 0 200 161 10 3 39 300 300 339 162 11 4 177 300 300 477 164 12 5 313 0 0 313 169 13 6 144 300 300 444 230 14 7 215 0 0 215 206 15 8 9 300 300 309 191 16 9 118 300 300 418 159 17 10 259 0 0 259 185 18 19 20 Number of days 0 21 Mean closing stock 155 22 Number of orders 5 23 Number of back 0 24 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Closing stock 200 39 177 313 144 215 9 118 259 74