Exit this survey Littlefield Simulation Report (EMBALJ2014) 6. Littlefield Simulation Report Continued Question Title * Q5. Describe a methodology to calculate an appropriate value for your inventory reorder point at various stages of the product lifecycle. Make sure to include a detailed explanation of how to calculate every quantity associated with your method during the game. Economic order quantity = SQRT(2 * set-up cost * flow rate / holding cost) In this case: set-up cost: fixed cost per order = $1,000 flow rate: average demand = 40 orders/day holding cost: opportunity cost of capital employed in inventory = 10% * $600/order/year = $60/order/year = $0.164/order/day -> Econo This method comes up with a quantity th at is unrealistically high due to the fact that the case does not give any other cost to ho lding inventory than the opportunity cost (= lost interest form the cash that is tied into it). In more realistic case there would be other costs involved (company's cost of capital, physical warehousing, spoilage, obsolescence, etc), and the economic order quantity would be smaller.mic order quantity Q = SQRT(2 * $1,000 * 40 / $0.164) = 698.4 jobs (= 41,905 kits) Question Title * If average demand was flat at 40 orders per day throughout and the standard deviation of demand was 40 orders per day, what would be the reorder point value obtained from your method? Please note that the numbers in this question are slightly different than those provided in the Littlefield Simultation document. We used a 100% buffer on top of our forecasted demand during lead time to be safe with the variability and keep the calculation simple. However, one could set a service level target, say 95%, and calculate: Expected demand during lead time E[DDLT] = 4*40 = 160 Standard deviation of demand during lead time δ[DDLT] = SQRT(4)*40 =80 Service level 95% -> k = 1.64 Reorder point R = E[DDLT] + k* δ[DDLT] = 160 + 1.64*80 = 291.2 jobs (= 17,472 kits) Our method of using 100% buffer would in this case result in reorder point of 320, which would result in a service level little bit higher than 95%. Prev Next