Business Commons^™

Using Excel To Teach Simulation For Management Accounting, Clarence Goh, Poh Sun Seow, Gary Pan

Research Collection School Of Accountancy

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 …