ALLOCATION OF SECONDARY COSTS BY USING THE MATRIX FUNCTIONS OF SPREADSHEET PROGRAMS

Abstract

The paper describes and applies the method of linear equations, by using the matrixfunctions of spreadsheet programs, for the secondary cost allocation of fullyconditionedauxiliary cost centers. The aim of the paper is to demonstrate the possibilityof using matrix functions for cost allocation. A model has been formed based on thedata from a specific company, that has auxiliary, main and non-productive cost centers.The linear equations method is used to solve the problem of secondary cost allocation,by applying the corresponding matrix functions of a spreadsheet program.The goal of cost allocation of auxiliary cost centers to main cost centers, and later to thecost holders, is to calculate the exact cost, that is, the cost of products and services.The method of linear equations was chosen because a new model can be formed basedon the starting model, by changing the number of cost centers.This cost allocation model should encourage accountants and company management touse the more exact method of cost allocation instead of the simple direct method orcomplex step method. Matrix functions facilitate the method of linear equations,because they are quite simple to apply in models that can be easily adapted and appliedin practice later on.It has been concluded that this method can be easily described and applied, and theobtained results, with the correct data input and use of matrix functions, givecompletely accurate results, unlike other cost allocation methods.