Data Visualization of Budgeting Assumptions: An Illustrative Case of Trans-disciplinary Applied Knowledge

Carol E. Cuthbert, Noel J. Pears, Karen Bradshaw

Trans-disciplinary research combines different fields into new conceptual and methodological frameworks. In this study, the SECI model of knowledge creation, which consists of Socialization, Externalization, Combination, and Internalization conversion modes, is used to analyze the implementation of a structured budgeting visualization system by a trans-disciplinary team. Through applied research in implementing a global budgeting system, budgeting assumptions are made explicit through visualization, transforming the approach to the budgeting process and its accuracy. This visualization, in turn, is enabled by assumptions underlying revenue planning, business services and employee compensation, and a visual process. The system displays a stepped approach, indicated by icons, representing the tasks involved in the budget process. For example, the system requires uploading the previous year’s information, setting the assumptions, calculating the suggested figures based on assumptions, and amending the proposed outcome. As adapted by Rice and Rice (2005), SECI is applied as the socialization of tacit-to-tacit budgeting assumption knowledge is solidified during the design phase of this transformation exercise. The externalization phase, in which budgeting assumptions are transformed from tacit to explicit, is evidenced during the configuration phase of the new system. The systemic collaboration results in the explicit assumptions being collectively leveraged across the regions during and after the “go-live” phase of system development. Finally, the internalization phase involves the explicit assumptions being transformed into new tacit knowledge as the experts evolve new assumptions derived from the transformation process. Semiotics provides variance information through hue, with, for example, darker colours indicating higher variances. This trans-disciplinary communication provides the means for increased efficiency and effectiveness. The resulting budget framework is visually validated through a heatmap by comparing the budgeting accuracy and assumption 1 Contact author 2 Peer-Editor: Prof D Sewry. Dean of Commerce, Rhodes University. complexity between the different regions where it was implemented. In summary, value is added in developing a new data visualization process, focusing on the role of budgeting assumptions and using planning process visualizations. This approach improves communication efficiency, effectiveness, and understanding of budgeting while enhancing accuracy.

Full Text