EOQ Reorder Point with Long Lead Time. The reorder point [see equation (10.6)] is defined as the lead-time demand for an item. In cases of long lead times, the lead-time demand and thus the reorder point may exceed the economic order quantity *. In such cases, the inventory position will not equal the inventory on hand when an order is placed, and the reorder point may be expressed in terms of either the inventory position or the inventory on hand. Consider the economic order quantity model with , , and 250 working days per year. Identify the reorder point in terms of the inventory position and in terms of the inventory on hand for each of the following lead times. LO 1

5 days

15 days

25 days

45 days

Can you please solve it on excel?