Dataset Information

Data, data flows, and model specifications for linking multi-level contribution margin accounting with multi-level fixed-charge problems.

ABSTRACT: This article describes the data, data flows, and spreadsheet implementations for linking multi-level contribution margin accounting as a subsystem in cost accounting with several versions of a multi-level fixed-charge problem (MLFCP), the latter based on the optimization approach in operations research. This linkage can reveal previously hidden optimization potentials within the framework of multi-level contribution margin accounting, thus providing better information for decision making in companies and other organizations. For the data, plausible fictitious values have been assumed taking into consideration the calculation principles in cost accounting where applicable. They include resource-related data, market-related data, and data from cost accounting needed to analyze the profitability of a company´s products and organizational entities in the presence of hierarchically structured fixed costs. The data are processed and analyzed by means of mathematical optimization techniques and sensitivity analysis. The linkage between multi-level contribution margin accounting and MLFCP is implemented in three spreadsheet files, including versions for deterministic optimization, stochastic optimization, and robust optimization. This paper provides specifications for compatible solver add-ins and for executing sensitivity analysis. The data and spreadsheet implementations described in this article were used in a research article entitled "Making better decisions by applying mathematical optimization to cost accounting: An advanced approach to multi-level contribution margin accounting" [1]. The data sets and the spreadsheet implementations may be reused a) by researchers in management and cost accounting as well as in operations research and quantitative methods for verification and for further development of the linkage concept and of the underlying optimization models; b) by practitioners for gaining insight into the data requirements, methods, and benefits of the proposed linkage, thus supporting continuing education; and c) by instructors in academia who may find the data and spreadsheets valuable for classroom use in advanced courses. The complete spreadsheet implementations in the form of three ready-to-use Excel files (deterministic, stochastic, and robust version) are available for download at Mendeley Data. They may serve as customizable templates for various use cases in research, practice, and education.

SUBMITTER: Gutierrez M

PROVIDER: S-EPMC8010628 | biostudies-literature |

REPOSITORIES: biostudies-literature

ACCESS DATA

Similar Datasets

Project description:The purpose of multi-level contribution margin accounting in cost accounting is to analyze the profitability of products and organizational entities with appropriate allocation of fixed costs and to provide relevant information for short-term, medium- and longer-term decisions. However, the conventional framework of multi-level contribution margin accounting does not usually incorporate a mathematical optimization method that simultaneously integrates variable and fixed costs to determine the best possible product mix within hierarchically structured organizations. This may be surprising in that operations research provides an optimization model in the form of the fixed-charge problem (FCP) that takes into account not only variable costs but also fixed costs of the activities to be planned. This paper links the two approaches by expanding the FCP to a multi-level fixed-charge problem (MLFCP), which maps the hierarchical decomposition of fixed costs in accordance with multi-level contribution margin accounting. In this way, previously hidden optimization potentials can be made visible within the framework of multi-level contribution margin accounting. Applying the linkage to a case study illustrates that the original assessment of profitability gained on the sole basis of a multi-level contribution margin calculation might turn out to be inappropriate or even inverted as soon as mathematical optimization is utilized: products, divisions, and other reference objects for fixed cost allocation, which at first glance seem to be profitable (or unprofitable) might be revealed as actually unprofitable (or profitable), when the multi-level contribution margin calculation is linked to the MLFCP. Furthermore, the proposed concept facilitates assessment of the costs of an increasing variant diversity, which also demonstrates that common rules on how to interpret a multi-level contribution margin calculation may have to be revised in some cases from the viewpoint of optimization. Finally, the impact of changes in the fixed cost structure and other parameters is tested via sensitivity analyses and stochastic optimization.

Project description:BackgroundSelecting the proper parameter settings for bioinformatic software tools is challenging. Not only will each parameter have an individual effect on the outcome, but there are also potential interaction effects between parameters. Both of these effects may be difficult to predict. To make the situation even more complex, multiple tools may be run in a sequential pipeline where the final output depends on the parameter configuration for each tool in the pipeline. Because of the complexity and difficulty of predicting outcomes, in practice parameters are often left at default settings or set based on personal or peer experience obtained in a trial and error fashion. To allow for the reliable and efficient selection of parameters for bioinformatic pipelines, a systematic approach is needed.ResultsWe present doepipeline, a novel approach to optimizing bioinformatic software parameters, based on core concepts of the Design of Experiments methodology and recent advances in subset designs. Optimal parameter settings are first approximated in a screening phase using a subset design that efficiently spans the entire search space, then optimized in the subsequent phase using response surface designs and OLS modeling. Doepipeline was used to optimize parameters in four use cases; 1) de-novo assembly, 2) scaffolding of a fragmented genome assembly, 3) k-mer taxonomic classification of Oxford Nanopore Technologies MinION reads, and 4) genetic variant calling. In all four cases, doepipeline found parameter settings that produced a better outcome with respect to the characteristic measured when compared to using default values. Our approach is implemented and available in the Python package doepipeline.ConclusionsOur proposed methodology provides a systematic and robust framework for optimizing software parameter settings, in contrast to labor- and time-intensive manual parameter tweaking. Implementation in doepipeline makes our methodology accessible and user-friendly, and allows for automatic optimization of tools in a wide range of cases. The source code of doepipeline is available at https://github.com/clicumu/doepipeline and it can be installed through conda-forge.

Dataset Information

Data, data flows, and model specifications for linking multi-level contribution margin accounting with multi-level fixed-charge problems.

Similar Datasets

OmicsDI is part of the ELIXIR infrastructure