Mr Vinny is a wholesaler who buys and sells a wide range of products, one of which
Question:
Mr Vinny is a wholesaler who buys and sells a wide range of products, one of which is Item D. Mr Vinny sells 24 000 units of Item D each year at a unit price of R20. Sales of Item D normally follow an even pattern throughout the year. Further supplies of Item D are ordered whenever the stock falls to this minimum level and the time lag between ordering and delivery is small enough to be ignored.
At present, Mr Vinny buys all his supplies of Item D’s from Marco Ltd, and usually purchases them in batches of 5000 units. His most recent invoice from Marco Ltd was as follows: R
Basic price: 5000 Item Ds at R15 per unit 75 000
Delivery charge: Transport at R0.50 per unit 2 500
Fixed shipment charge per order 1 000
78 500
In addition, Mr Vinny estimates that each order he places costs him R500, comprising administrative costs and the cost of sample checks. This cost does not vary with the size of the order.
Mr Vinny estimates that the holding costs amount to R18 per Item D per annum.
Mr Vinny has recently learnt that another supplier of Item Ds, Raymond Ltd, is willing, unlike Marco Ltd, to offer discounts on large orders. Raymond Ltd sells Item Ds at the following prices:
Order size Price per unit (R)
1–2999 15.25
3000–4999 14.50
5000 and over 14.25
In other respects (i.e. delivery charges and the time between ordering and delivery) Raymond Ltd’s terms are identical to those of Marco Ltd.
Required:
(a) calculate the optimal re-order quantity for Item Ds and the associated annual profit Mr Vinny can expect from their purchase and sale, assuming that he continues to buy from Marco Ltd; (10 marks)
(b) Prepare calculations to show whether Mr Vinny should buy Item Ds from Raymond Ltd rather than from Marco Ltd and, if so, in what batch sizes. (10 marks)
Ignore taxation.
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe