Treffer: Using Python in Management Accounting: Monte Carlo Simulation for Cost-Volume-Profit Analysis.

Cost-volume-profit (CVP) analysis is a fundamental management accounting tool. Traditional analysis uses point estimates for model parameters and scenario analysis to forecast best-case and worst-case outcomes. This case extends prior teaching cases in several ways. Students use historical sales data to forecast both the mean and standard deviation of volume and price for the next year. Students are provided the forecasted cost parameters, along with steps and instructions to perform a Monte Carlo simulation in Python. Using Python for the simulation introduces them to, or reinforces their use of, a programming language frequently used in data analytics. The simulation enables them to grasp the notion, and quantify the impact, of uncertainty. Students produce visualizations consisting of time series plots of sales and histograms of the many CVP model outcomes. For instructors who prefer not to use Python, the case can also be completed using Excel. [ABSTRACT FROM AUTHOR]

Copyright of Issues in Accounting Education is the property of American Accounting Association and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)

Volltext ist im Gastzugang nicht verfügbar. Login für vollen Zugriff.