Calculation of re-order and maximum stock levels A retail company has been reviewing the adequacy of its stock control systems and has identified three products for investigation. Relevant details for the three products are set out below:

Outstanding order: Item code 14/243-order for 250000 units placed two trading days ago.
There are six trading days per week.
All orders are delivered by suppliers into the retailer’s central warehouse. The lead time is one week from placement of order. A further week is required by the retailer in order to transfer stock from central warehouse to stores. Both of these lead times can be relied upon.
Required:

(a) Calculate for each product:
(i) the minimum and maximum weekly sales units (ii) the stock re-order level (iii) the maximum stock control level.
(9 marks)

(b) Comment upon the adequacy of the existing stock control of the three products.

Transcribed Image Text:

Item code EOQ Stock (warehouse and stores) Weekly sales (000) Gross* margin (000 (000 units) units) (/unit at cost) mini- nor- maxi- (% of mum mal mum sales) 14/363 25 32.5 2.25 26 28 30 42 11/175 500 422.7 0.36 130 143 160 46 14/243 250 190 0.87 60 96 128 45 37 *Gross margin = sales - purchase cost of product.