Spreadsheet-based modelling for out of matrix cost in inbound logistics
by Mrinalini Shah; Mayank Kumar Daga
International Journal of Automation and Logistics (IJAL), Vol. 3, No. 1, 2017

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.

Online publication date: Mon, 22-May-2017

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
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 Automation and Logistics (IJAL):
Login with your Inderscience username and password:

    Username:        Password:         

Forgotten your 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