To simulate inventory management for a particular product, assume...

Image transcription text

To simulate inventory management for a particular product, assume that the per period demand is an integer value quantity which follows the normal distribution with mean and standard deviation 50 and 15, respectively. If the demand exceeds the starting inventory, then the ending inventory would be zero, that is, the 'extra" demand is lost. Therefore, the ending inventory level is never negative. Ordering will take place at the end of the period, based on the ending inventory, and the order arrives at the beginning of the next period. The ordering policy is to order 80 units (order quantity is equal to 80 units) when the ending inventory is less than or equal to 30 units (reorder point is 30 units). The cost of placing each inventory order is fixed at $250, and this value does not depend on the quantity ordered. The cost of holding inventory for each period is $5 per unit (holding cost is $5/unit-period). The per period inventory holding cost is computed based on the end of period inventory level. The starting inventory for each period, after the first period, is the ending inventory plus any order quantity from the period before. N Inventory Problem Average of TC Average of TC SD of TC SD of TC Mean Demand So unit Total Inv Cost Demand Std Dev units Total Cost (TC) Sim # 40 60 80 100 120 Sim # Order Quantity units Order Cost $250 per order Reorder Point units Holding Cost per unit-period Period Starting Inv Demand Ending Inv Order Qty Order + Inv Cost 60 50 10 80 $300 90 30 $150 30 0 880 $250 $255 2 8 $180 Suppose all formulas are correctly entered. The simulation is run for 52 periods. To observe the long run behavior of this inventory system, we then capture the total cost value (cell F3) from each of 200 repetitions of this 52-period simulation in cells J6 to J205. To determine the best order quantity, we wish to check how the simulation performs with different order quantities. A two-way data table is set up in cells M5 through R205 with order quantity values set to 40, 60, 80, 100, and 120 as shown in the highlighted area above. Which of the following statements are true regarding the mean and standard deviations of the 200 repetitions when considering the different order sizes (cells N1 through R2)? O The order quantity of 40 units appears to be the least cost order policy on average. O The order quantity of 120 units is more costly than the order quantity of 80 units. The order quantity of 100 units has a lower standard deviation than the order quantity of 60 units. O The order quantity of 80 appears to have the lowest standard deviation. O Exactly two answers are correct.... Show more

To simulate inventory management for a particular product, assume that the per period demand is an integer value quantity which follows the normal distribution with mean and standard deviation 50 and 15, respectively. If the demand exceeds the starting inventory, then the ending inventory would be zero, that is, the 'extra" demand is lost. Therefore, the ending inventory level is never negative. Ordering will take place at the end of the period, based on the ending inventory, and the order arrives at the beginning of the next period. The ordering policy is to order 80 units (order quantity is equal to 80 units) when the ending inventory is less than or equal to 30 units (reorder point is 30 units). The cost of placing each inventory order is fixed at $250, and this value does not depend on the quantity ordered. The cost of holding inventory for each period is $5 per unit (holding cost is $5/unit-period). The per period inventory holding cost is computed based on the end of period inventory level. The starting inventory for each period, after the first period, is the ending inventory plus any order quantity from the period before. Suppose all formulas are correctly entered. The simulation is run for 52 periods. To observe the long run behavior of this inventory system, we then capture the total cost value (cell F3) from each of 200 repetitions of this 52-period simulation in cells J6 to J205. To determine the best order quantity, we wish to check how the simulation performs with different order quantities. A two-way data table is set up in cells M5 through R205 with order quantity values set to 40, 60, 80, 100, and 120 as shown in the highlighted area above. Which of the following statements are true regarding the mean and standard deviations of the 200 repetitions when considering the different order sizes (cells N1 through R2)?