Title: Spreadsheet-based modelling for out of matrix cost in inbound logistics

Authors: Mrinalini Shah; Mayank Kumar Daga

Addresses: Operations Management, Institute of Management Technology, PIN 201 001 Ghaziabad, India ' Infosys Ltd. Mayank, Ghaziabad, India

Abstract: The purpose of the study was to estimate non-budgeted cost incurred by an FMCG company in its inbound logistics operations for a selected product category. We conducted the study through action research approach, and collected primary data for all its shipment made from all the manufacturing units of the company to its distributors across PAN India. A quantitative model was developed to estimate the logistics cost for six-month period and a spreadsheet-based model was designed to generate reports to provide ease of use to decision makers/managers. The study identified the lack of coherence in logistics planning and implementation stage, resulting in excess than the budgeted expenditure. The present research indicated that the out-of-matrix cost constituted an average 25% of the total transportation cost for the study period. We identified the potential causes for such inefficiencies and recommended to use developed model in getting a more realistic scenario through the developed model.

Keywords: out-of-matrix cost; logistics performance; inbound logistics; supply chain planning; distance minimisation; supplier contract.

DOI: 10.1504/IJAL.2017.084298

International Journal of Automation and Logistics, 2017 Vol.3 No.1, pp.1 - 16

Received: 15 Apr 2016
Accepted: 23 Jan 2017

Published online: 22 May 2017 *

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