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

Authors: Kal Namit, Fidelis Ikem, Moula Cherikh, Ephrem Eyob

Addresses: School of Business and Economics, Winston-Salem State University, Winston-Salem, NC 27110, USA. ' College of Business, Kutztown University, Kutztown, PA 19530, USA. ' Department of Computer Information Systems, Virginia State University, Petersburg, VA 23806, USA. ' Department of Computer Information Systems, Virginia State University, Petersburg, VA 23806, USA

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.

DOI: 10.1504/IJMDM.2006.009143

International Journal of Management and Decision Making, 2006 Vol.7 No.2/3, pp.189 - 200

Published online: 06 Mar 2006 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article