TY  - JOUR
AB  - Reviews the literature on capacity planning at strategic, tactical and operational levels but points out that, in practice, many enterprise resource planning systems make unrealistic assumptions for production planning; and the advanced production software packages which can deal with uncertainty are both complex and expensive. Uses a theoretical company to demonstrate how a normal Excel spreadsheet can be used in conjunction with a common add‐on package (@RISK) to improve analysis and run Monte Carlo simulations as a basis for decision making. Compares the results produced with standard spreadsheet analysis and discusses the additional financial and operational insights they provide into the implications of different capacity levels under conditions of uncertainty. Warns that the validity of the simulation depends on the quality of the data and model; and that human judgement is still required to actually make a decision.
VL  - 27
IS  - 5
SN  - 0307-4358
DO  - 10.1108/03074350110767187
UR  - https://doi.org/10.1108/03074350110767187
AU  - Helio Yang Y.
AU  - Haddad Kamal
AU  - Chow Chee W.
PY  - 2001
Y1  - 2001/01/01
TI  - Capacity planning using Monte Carlo simulation: an illustrative application of commonly available PC software
T2  - Managerial Finance
PB  - MCB UP Ltd
SP  - 33
EP  - 54
Y2  - 2024/04/25
ER  -