In Chapter 16, the formula for the optimal order quantity of an item, Q, given its demand, D, ordering cost, Co, and the cost of holding, or carrying, an item in inventory, Cc, is as follows:

The total inventory cost formula is

Ordering cost, Co, and carrying cost, Cc, are generally values that the company is often able to determine with certainty because they are internal costs, whereas demand, D, is usually not known with certainty because it is external to the company. However, in the order quantity formula given here, demand is treated as if it were certain. To consider the uncertainty of demand, it must be simulated.
Using Crystal Ball, simulate the preceding formulas for Q and TC to determine their average values for an item, with Co = +150, Cc = +0.75, and demand, D, that is normally distributed with a mean of 10,000 and a standard deviation of 4,000.

Transcribed Image Text:

Q= 2C D Ce