- 20 Marks
FM – May 2018 – L3 – SB – Q3 – Working Capital Management
Calculate the optimal re-order quantity, compare suppliers, and evaluate limitations in Kehinde's inventory management.
Question
Kehinde is a wholesaler who buys and sells a wide range of products, including electrical component TK. Kehinde sells 24,000 units of TK each year at a unit price of N2,000. Sales of TK normally follow an even pattern throughout the year. To prevent stock-outs, Kehinde keeps a minimum inventory of 1,000 units. Further supplies of TK are ordered whenever the inventory falls to this minimum level, and the time lag between ordering and delivery is small and can be ignored.
At present, Kehinde buys all his supplies of TK from Ajoke Limited and usually purchases them in batches of 5,000 units. His most recent invoice from Ajoke Limited was as follows:
Item | Amount (N’000) |
---|---|
Basic price: 5,000 units of TK at N1,500 per unit | 7,500 |
Delivery charges: | |
– Transport at N50 per unit | 250 |
– Fixed shipment charge per order | 100 |
Total | 7,850 |
Kehinde also estimates an ordering cost of N50,000 per order, comprising administrative costs and sample checks, which does not vary with the order size.
Kehinde stores TK in a warehouse rented at N500 per square metre per annum, with excess capacity sublet at N400 per square metre annually. Each unit of TK in inventory requires 2 square metres of space. Other holding costs are estimated at N1,000 per unit per annum.
Kehinde has recently learned that another supplier, Ema Limited, offers discounts for large orders. Ema Limited’s pricing structure is as follows:
Order Size | Price per unit (N) |
---|---|
1 – 2,999 | 1,525 |
3,000 – 4,999 | 1,450 |
5,000 and over | 1,425 |
In other respects (delivery charges and order lead time), Ema Limited’s terms match those of Ajoke Limited.
Required:
a. Calculate the relevant:
i. Cost per order
ii. Holding cost per unit per annum (4 Marks)
b. Irrespective of your answers in (a) above and assuming a cost per order of N150,000 and holding cost per unit per annum of N1,800, calculate the optimal re-order quantity for TK and the associated annual profit Kehinde can expect from the purchase and sale, assuming that he continues to buy from Ajoke Limited. (6 Marks)
c. Prepare calculations to determine if Kehinde should buy TK from Ema Limited instead of Ajoke Limited, and in what batch size. (7 Marks)
d. Discuss the key limitations of the method of analysis you used. (3 Marks)
Find Related Questions by Tags, levels, etc.