An Excel based approach to optimise trade-offs between freight expediting and safety stock inventory costs

Kal Namit, Fidelis Ikem, Moula Cherikh and Ephrem Eyob

International Journal of Management and Decision Making, 2006, vol. 7, issue 2/3, 189-200

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.

Keywords: trade-offs; freight expediting; safety stock; inventory costs; spreadsheet programming; reorder point; order size; backorders; optimisation. (search for similar items in EconPapers)
Date: 2006
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=9143 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ids:ijmdma:v:7:y:2006:i:2/3:p:189-200

Access Statistics for this article

More articles in International Journal of Management and Decision Making from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().