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

Copyright Owner and License

Authors

Share

COinS