Start with an order quantity of 25 and go all the way to 500 units in steps of 25 units. For each of these quantities calculate the above columns. Show all formulas. Use absolute references where necessary. Have no more than 1 decimal place. Clearly provide answers to the following questions:
What is the best order quantity for this item?
If Rocky Mountain uses this order quantity,
What is the number of orders annually?
What is the time between orders?
What is the annual total cost?
What is the average inventory carried?