Improving efficiency in budgeting: An interventionist approach to spreadsheet accuracy testing

Publikation: Beiträge in ZeitschriftenZeitschriftenaufsätzeForschungbegutachtet

Authors

Over the past three decades, the reliance on sophisticated spreadsheets for budgeting has emerged as a standard in most organizations (Hesse and Hesse Scerno, 2009). Despite these technological advancements, rich empirical evidence documents that technologically induced 'spreadsheet errors' can substantially lower the accuracy of spreadsheets (Powell et al., 2009). These errors lead to suboptimal decision making and biased performance assessment. The aim of this paper is to examine how spreadsheet error can be detected and prevented in the budgeting process. The research design applies models of spreadsheet accuracy testing (SAT) from Kruck (2006) and Vessey (1985). The paper, thereby, illustrates the error reduction process in budgeting as well as future spreadsheet error prevention through the use of VBA. The authors base the analyses on a unique dataset (interviews, participating observations, technical artifacts) gathered through 'action research' at a Chinese-Danish government organization, which uses budgets for assessing applications on research funding. Our results confirm and extend existing theory in the field of budgeting and SAT and provide interesting findings. First, the paper shows that later spreadsheet error in budgeting is already rooted in a poor conceptualization of the budget template, in non-workflow-oriented imputation of data and poor documentation of data requirements. Second, it illustrates how the accuracy of spreadsheets substantially improves by introducing even simplistic VBA. Third, we present evidence that the flexibility of the budgeting template itself to changes in the organizational environment fosters spreadsheet accuracy in the long term.

OriginalspracheEnglisch
ZeitschriftProblems and Perspectives in Management (PPM)
Jahrgang10
Ausgabenummer1
Seiten (von - bis)32-41
Anzahl der Seiten10
ISSN1727-7051
PublikationsstatusErschienen - 2012
Extern publiziertJa

Zuletzt angesehen

Aktivitäten

  1. Spectral kinetic simulation of the Planar Multipole-Resonance-Probe
  2. IV. European Workshop on Clinical Reasoning and Decision Making - 2011
  3. Durs Grünbein: Unbekümmert, anderntags, Verse
  4. Mind the Gap: Dealing with the Unknowns in Provenance Data
  5. “Bodies Without Boundaries: Shape-Shifting Experiences in Native American Poetry”
  6. International Convention of Psychological Science 2017
  7. Including Justice in Institutional Analysis - How Do Frameworks for Institutional Analysis Consider Ideas of Justice?
  8. Digital Entrepreneurship & Society – Lunch-Talk 2021
  9. Successes and failures of farm diversification processes – some evidence from two Polish regions
  10. Foucault trifft Latour
  11. User Generated Content
  12. Cranfield University
  13. Dealing with racial stereotypes in German professional and elite football. What discourse analysis can contribute
  14. Optimizing water resources in Egypt: The case for sediment deduction at the High Aswan dam reservoir
  15. The Contract Governance Conference - 2010
  16. ProMath 2017
  17. An Aesthetics of the Earth. Reframing relational Aesthetics considering critical Ecologies.
  18. Provenance Language Processing: A Human-in-the-Loop Perspective
  19. Organizational Downsizing: An Institutional Perspective
  20. The struggle for an international regime on space resources
  21. Democracy and Intergenerational Justice: Overcoming Harmful Short-termism Through New Institutions?
  22. Risk preferences under multiple risk conditions – survey evidence from semi-arid rangelands
  23. Intraorganizational Tensions Around Being Good: Explaining (De-)coupling of Purchasing and CSR in Garment Brands and Retailers
  24. Computational study of Lagrangian transport in turbulent convection
  25. Professional School (Organisation)
  26. Research Workshop “Innovation & Value Creation"
  27. Urban Sound Research
  28. 11th EIASM Conference on Performance Measurement and Management Control