For a product satisfying EOQ assumptions, annual demand is 5400 units, holding cost per unit per year is $5 and the ordering cost is $110. (a) For the lot sizes (order quantities) 200, 400, 600 and 800 calculate annual inventory cost using a table similar to the one in Example 1.1. What is the best lot size out of these four lot sizes? (b) Draw the graphs of annual cost for holding, ordering and annual inventory cost vs. lot size (for lot sizes between 100 and 1000). Use EXCEL to prepare the graph. Label the graph appropriately. Use original information in the first two lines to answer the following (c) Calculate the optimal lot size, based on the information above (round off optimal Q, to the closest multiple of 100). 1. What are the corresponding annual inventory costs? 2. What is the best policy if the lead-time (LT) is 2 months? 3. Suppose there is a minimum order quantity and LT = 2 months, what would be the "optimal" ordering policy if you have to order at least 600?

For a product satisfying EOQ assumptions, annual demand is 5400 units, holding cost per unit per year is $5 and the ordering cost is $110. (a) For the lot sizes (order quantities) 200, 400, 600 and 800 calculate annual inventory cost using a table similar to the one in Example 1.1. What is the best lot size out of these four lot sizes? (b) Draw the graphs of annual cost for holding, ordering and annual inventory cost vs. lot size (for lot sizes between 100 and 1000). Use EXCEL to prepare the graph. Label the graph appropriately. Use original information in the first two lines to answer the following (c) Calculate the optimal lot size, based on the information above (round off optimal Q0 to the closest multiple of 100). 1. What are the corresponding annual inventory costs? 2. What is the best policy if the lead-time (LT) is 2 months? 3. Suppose there is a minimum order quantity and LT =2 months, what would be the "optimal" ordering policy if you have to order at least 600