An Excel based approach to optimise trade-offs between freight expediting and safety stock inventory costs Online publication date: Mon, 06-Mar-2006
by Kal Namit, Fidelis Ikem, Moula Cherikh, Ephrem Eyob
International Journal of Management and Decision Making (IJMDM), Vol. 7, No. 2/3, 2006
Abstract: In this paper, we present an Excel based methodology for the computation of two optimal policy quantities, order size and reorder point of a (Q, r) inventory system under uncertainty when backorder costs are independent of the amount of the backorder and dependent on whether there is a shortage. It is shown that the total cost curve for the backorder model is a concave-convex function. Solving the problem using a spreadsheet solver would not necessarily yield the optimal solution. It is first necessary to identify the convex and concave domains prior to the application of Excel Solver to determine the optimal solution of the model. This approach is flexible and capable of handling different lead time demand distributions as well as the more realistic scenario when both the demand and lead times are randomly distributed. The methodology is illustrated with a simple problem.
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Management and Decision Making (IJMDM):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email subs@inderscience.com
Our Blog 
Follow us on Twitter 
Visit us on Facebook