www.impianti.dii.unipg.it

 

 

 

In the following a new performance in considered in the Safety Stock management: the waiting time of backordered clients.

In particular the percentage of client waiting more than a time limit (1 month) is limited. For the rest dimensioning Safety Stock following different policy is required

 Exercise

 Consider the following items:

item v € / piece LT months D piece / month sD

piece / month

1 80 4 950 200

2 200 6 60 15

3 20 8 500 100

item v [€/item] LT [month] D [items/month] σD [items/month]
1 80 4 950 200
2 200 6 60 15
3 20 8 500 100

 Where v is the cost of the item, D the average monthly demand, sD the standard deviation of demand, LT Lead Time of delivery.

Considering the following:

  • a setup fee cost A=100 €/order;
  • a carrying cost rate r=25% [€/€-year];
  •  stock out backordered;
  • distribution of demand is gaussian.

Answer the following questions:

a) safety stock should ensure that in the average no more than 10% of customers wait more than 1 month. Hint use formula ESPRC  considering  LT-1 Months, whereas 10% = ESPRC (LT-1) / Q) :

 

item SS [item] (only 10% of customers expect more than 1 month)
1  
2  
3  

Compile the table at the bottom answering the following:

b) It allocates a value of € 50,000 for safety stock so that all 3 items have the same safety coefficient k (k Same);

c) As in the previous but by imposing the same B1 [€ / stock-out incident] for all items (hint it starts from B1 around 1000) (Same B1);

d) As in previous but by imposing the same B2 [% / stock-out incident] for all items (hint we start from B2 = 0.08) (Same B2);

e) Same Cycle Service Level P1, percentage of cycles in which you go to stock out (Same P1);

f) Same Time Between Stock Out (Same TBS);

g) Same Fill Rate P2, percentage of satisfied customers, assuming back order (hint try P2 = 93%) (same P2);

 

Quantity  b) the same k  c) the same B1 d) the same B2 e) the same P1 f) the same TBS g) the same P2
Expected Total Stock Out Per Year            
Expected Total Shortage in Value  Per Year            
SS  item 1  in value €            
SS  item 2  in value €            
SS  item 3  in value €            
Global TBS