Reference no: EM131072364

A product inventory changes daily due to customer demand that withdraws from it and production that replenishes it on the days when it is operating. Customer demands and production are random variables. Production is subject to down times of random frequency and duration. Customers due not backorder. Thus, any customer demand that cannot be met results in a lost sale.

Periodically, an analyst can review the inventory and make adjustments by purchasing or selling product on the spot market. The time between these reviews is called the review period. At each review, the analyst can do the following:

a. If the current inventory is less than the safety stock, buy a quantity of product equal to (safety stock - current inventory) on the spot market.

b. If the current inventory is greater than the maximum inventory, sell a quantity of product equal to (current inventory - maximum inventory) on the spot market.

The safety stock level is an operating parameter of the inventory system set such that the probability of meeting all customer demand between periodic reviews is at least a specified value, typically 90%, 95%, or 99%. This probability is called the effective service level.

The maximum inventory level is less that the physical limit on inventory storage, called the capacity, to avoid having no place to store items.

Figure 13-6 summarizes the inventory control system. Note the following definitions and notation.

Target inventory - The desired inventory to avoid purchases and sales on the spot market, in the range [safety stock, maximum inventory].

Delta inventory - The change in inventory each day due to production (+) and demand (-).

Nominal service level - The probability that the inventory will be greater than the safety stock at the time of a review given that it was equal to the target at the time of the last review. As well, the probability that the inventory will be greater than zero at the time of a review given that it was equal to the safety stock at the time of the last review

d = number of days in the review period md = the mean of the delta inventory distribution for a review period of d days

µ₂ = the variance of the delta inventory distribution for a review period of d days mp = the mean of the conditional daily production distribution (given that production is greater than zero).

 σ_d²= the variance of the daily production distribution

mc = the mean of the daily customer demand distribution

σ²_c = the variance of the daily customer demand

A = the percent of days that production occurs (the availability of production)

 L = the nominal service level as a percent

L_eff = the effective service level

L_shut = the probability of exceeding the capacity during the next review period given that the inventory level is equal to the maximum inventory at the current review

z_L= The L% point of the standard normal distribution

The average demand is equal to the average production over a long period of time such as a year. This means that m_c = m_p * A. In other words, the expected production each day (including an allowance for down time) is equal to the expected daily demand.

Ignoring down times, the delta inventory can be viewed approximately normally distributed with parameters:

The problem is to determine the review period, safety stock, maximum inventory, and target inventory given an effective service level. Performance measures should include the service level as well as the number of purchases and sales made to the spot market by the analyst.

Consider the following specifications.

First, determine the required quantities assuming that there is no production downtime. Use analytic models to compute the safety stock, target inventory, and maximum inventory for each review period. Use simulation to validate the analytic computations. Make adjustments to the analytically computed quantities if necessary. Validate your final recommendation using simulation. Validate means to show that the required effective service level is met. Next, consider production downtime. Establish and validate quantities for the safety stock, target inventory, and maximum inventory using simulation. The average time between periods of no production is 30 days. The average length of each period of no production is 1.92 days. The distribution of the period of no production follows.

Distribution of the Length of Periods of No Production

Case Problem Issues

1. Identify the processes that are needed in the model.

2. Specify all of the combination of the values of the parameters that should be simulated.

3. Compute the safety stock, target inventory level, and maximum inventory level for each parameter value combination using a spreadsheet.

4. Specify the initial conditions for the simulation.

5. In addition to service level, define the performance measures.

6. Determine how production downtime should be modeled.

7. Discuss how verification and validation evidence will be obtained. The time period of interest is one year.