Spreadsheet Implementations for Linking Multi-Level Contribution Margin Accounting with Multi-Level Fixed-Charge Problems
Description
This site provides the data 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. 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. While the deterministic version of the data does not consider uncertainty, the stochastic/robust versions assume probability distributions and rank correlations for part of the data. Spreadsheets The data and the above-mentioned linkage are implemented in three spreadsheet files, including versions for deterministic optimization, stochastic optimization, and robust optimization: - MLFCP deterministic.xlsx - MLFCP stochastic.xlsx - MLFCP robust.xlsx For a detailed description of the spreadsheet implementations and information on the software required to use them, see the associated data article published in Data in Brief. For the conceptual framework, mathematical formulation of the optimization model (MLFCP), findings, and discussion, see the associated research article published in Heliyon. (The links to both articles can be found on this page). Big Picture Furthermore, an overview (“big picture”) of the data flows between the various worksheets is provided in three main versions which correspond to the deterministic, stochastic, and robust versions of the MLFCP: - Overview of data flows - deterministic - Overview of data flows - stochastic (with three sub-variants) - Overview of data flows - robust Within each version/sub-variant of the overview, two file formats (PDF and PNG) are available. These are oversize graphics; please scale up appropriately to see the details. (Remark on version numbers and dates: The version numbers reported within the files might be lower than the version number of the entire dataset in case particular files remain unchanged in an update. The same might analogously apply to the dates.)