Publication Type
Journal Article
Version
acceptedVersion
Publication Date
6-2021
Abstract
In this article, we introduce an Excel exercise on simulation that can be implemented in a management accounting class. Specifically, we introduce a three phase implementation process where instructors (i) give the class an introduction to simulation, (ii) introduce students to a four-step process used in conducting analysis using simulation in Excel, and (iii) introduce a simulation problem focused on a specific area of management accounting (revenue projection) and guide students in completing the simulation analysis in Excel. By highlighting how simulation models can be built using Excel and used to solve a management accounting problem, our article identifies an important data analytics skillset for accountants and provides guidance on how it can be implemented into the accounting curriculum.
Keywords
Excel, data analytics, simulation, management accounting, accounting curriculum
Discipline
Accounting | Educational Methods
Research Areas
Accounting Information System
Publication
Management Accounting Quarterly
Volume
22
Issue
4
ISSN
1528-5359
Publisher
Institute of Management Accountants
Citation
GOH, Clarence; SEOW, Poh Sun; and PAN, Gary.
Using Excel to teach simulation for management accounting. (2021). Management Accounting Quarterly. 22, (4),.
Available at: https://ink.library.smu.edu.sg/soa_research/1930
Copyright Owner and License
Authors
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.