Spreadsheet Error Detection and Debugging Approach for Dynamic Discrete Inventory Control Models

Authors

  • Lena Djordjevic Faculty of Organizational Sciences, University of Belgrade
  • Danica Lecic-Cvetkovic Faculty of Organizational Sciences, University of Belgrade
  • Dragana Makajic-Nikolic Faculty of Organizational Sciences, University of Belgrade
  • Sladjan Babarogic Faculty of Organizational Sciences, University of Belgrade
  • Jasmina Omerbegovic-Bijelovic Faculty of Organizational Sciences, University of Belgrade

DOI:

https://doi.org/10.23055/ijietap.2019.26.5.4727

Keywords:

spreadsheet modeling, error detection, error analysis, discrete-time systems, inventory control

Abstract

Spreadsheets have been widely used in many business and scientific areas for modeling and simulation. Nevertheless, a number of research surveys have shown that these applications are particularly prone to errors. Some of the reasons for this error-proneness can be attributed to the fact that spreadsheet models are usually developed by the end-users and that standard software quality assurance processes are typically not applied. In addition, end-users often don't have a "clear picture" about the model structure and elements represented in the spreadsheet. The paper presents error detection and debugging approach developed for dynamic discrete spreadsheet models of inventory control. Spreadsheet modeling of inventory dynamics is based on the utilization of the discrete-time system control concept. This concept provides additional rules (common and specific constraints) which can be used for error detection. Preliminary experiments show general applicability of the approach.

Author Biographies

Lena Djordjevic, Faculty of Organizational Sciences, University of Belgrade

Lena Đorđević, PhD
Assistant Professor
Department for Production and Services Management
Faculty of Organizational Sciences, University of Belgrade

Danica Lecic-Cvetkovic, Faculty of Organizational Sciences, University of Belgrade

Danica Lecic-Cvetkovic, PhD
Full Professor
Department for Production and Services Management
Faculty of Organizational Sciences, University of Belgrade

Dragana Makajic-Nikolic, Faculty of Organizational Sciences, University of Belgrade

Dragana Makajic-Nikolic, PhD
Associate Professor
Department of Operations Research and Statistics
Faculty of Organizational Sciences, University of Belgrade

Sladjan Babarogic, Faculty of Organizational Sciences, University of Belgrade

Sladjan Babarogic, PhD
Associate Professor
Department of Information Systems
Faculty of Organizational Sciences, University of Belgrade

Jasmina Omerbegovic-Bijelovic, Faculty of Organizational Sciences, University of Belgrade

Jasmina Omerbegovic-Bijelovic, PhD
Full Professor
Department for Production and Services Management
Faculty of Organizational Sciences, University of Belgrade

Published

2019-10-21

How to Cite

Djordjevic, L., Lecic-Cvetkovic, D., Makajic-Nikolic, D., Babarogic, S., & Omerbegovic-Bijelovic, J. (2019). Spreadsheet Error Detection and Debugging Approach for Dynamic Discrete Inventory Control Models. International Journal of Industrial Engineering: Theory, Applications and Practice, 26(5). https://doi.org/10.23055/ijietap.2019.26.5.4727

Issue

Section

Modelling and Simulation