INSTITUTE OF ACCOUNTANCY ARUSHA (IAA)

(DIRECTORATE OF POST GRADUATE STUDIES)

STATISTICS AND DECISION MAKING

PROGRAMME: MASTER OF HUMAN RESOURCE MANAGEMENT

MODULE NAME: STATISTICS AND DECISION MAKING HRG09102
STUDENT NAME: GEORGE STEPHEN
REG. NO: MHRM-04-0177-2024
SUBMISSION DATE: 20th MAY 2025
WORK: INDIVIDUAL ASSIGNMENT
QUESTION 1: What is Monte-Carlo Simulation?
a) Give 4 Steps in Monte-Carlo Simulation
b) Give 5 Advantages of Monte-Carlo Simulation
c) Give 4 Limitations of Monte Carlo Simulation
QUESTION 2: How can Monte-Carlo simulation improve HR decision-making processes?
QUESTION 3: Consider a case study where you’re a the HRM in a Non-Governmental Organizations
(NGOs) and have been tasked with assessing the financial viability of launching a new wearable fitness
tracker. The market for such devices is competitive and consumer demand can be highly variable,
influenced by seasonal trends, marketing effectiveness, and competitor actions. Additionally, the costs
associated with manufacturing these devices are subject to fluctuations due to changes in material costs
and supply chain uncertainties. Use Monte Carlo simulation in Excel to address these challenges. You
believe this approach will help you estimate potential profitability under different scenarios, enabling
the company to make well-informed decisions about pricing strategies, production volumes, and
marketing investments. You have also analyzed past data from similar product launches and market
studies within the company. From this analysis, you have concluded certain metrics that will inform
your simulation. An average demand of 10,000 units for new devices within the first year of launch,
with a standard deviation of 2,000 units, reflecting the uncertainty in consumer uptake. Unit sale price
typically ranges between $50 and $70, depending on competitive pricing and market saturation. The
unit cost, influenced by volatile material prices and manufacturing efficiency, averages $30 per unit
with a standard deviation of $5. This historical data forms the underlying assumptions of your
simulation parameters, helping to create the simulation to reflect current market conditions more
accurately.
QUESTION 1: (A) WHAT IS MONTE-CARLO SIMULATION

Monte Carlo simulation is a mathematical technique that uses random sampling to model and
analyze systems with significant uncertainty, allowing for the estimation of outcomes when
exact solutions are difficult or impossible (Avlijaš, 2019). It works by running many
simulations with randomly generated inputs to produce a range of possible results and their
probabilities. The method is especially useful in fields like finance, engineering, physics, and
risk analysis. The Monte Carlo simulation was developed in 1946 by mathematician Stanislaw
Ulam and physicist John von Neumann while working on the Manhattan Project during World
War II (Summerscales, 2023). Ulam came up with the idea after contemplating the probability
of winning a game of solitaire during his recovery from illness. He realized that random
sampling could be applied to complex mathematical problems. Von Neumann helped formalize
the technique and implement it using early computers. The name “Monte Carlo” was suggested
by Ulam’s colleague Nicholas Metropolis, referencing the Monte Carlo Casino in Monaco to
reflect the element of chance. Since its inception, the method has become widely adopted
across disciplines (Summerscales, 2023).

QUESTION 1: (B) GIVE 4 STEPS IN THE MONTE-CARLO SIMULATION

The first step in a Monte Carlo Simulation is to clearly understand the problem you want
to solve. You need to describe what result you are trying to find and what factors affect it.
Then, you create a model to represent the system or process. This model includes all the
important parts and how they relate to each other. It can be a set of rules, formulas, or steps that
describe how the system works. The model should be detailed enough to give useful results,
but not so complex that it becomes hard to use. A well-made model allows you to test different
situations and see how they affect the outcome. This step is important because it sets the base
for everything that follows in the simulation. Without a clear model, the results won’t be
reliable (Lawler, 2025).

The second step is to identify input variables and probability distributions. Once the
model is ready, the next step is to figure out which values in the model are uncertain. These
uncertain values are called input variables. They are the parts of the system that can change and
are not always known in advance. For each of these variables, you assign a probability
distribution. A probability distribution is a way of showing which values are more or less likely
to happen. This is based on past data, expert knowledge, or patterns seen over time. By using
probability distributions, you include real-world uncertainty in the simulation. This makes the
simulation more accurate and meaningful. You don’t just use one number for each input; you
show a range of possible values. This step helps the simulation handle different situations and
test many outcomes, instead of relying on fixed guesses (Lawler, 2025).

The third step is to run the simulation many times. After setting up the model and assigning
probability distributions, the simulation is ready to run. In this step, the simulation uses random
numbers to pick values from each input variable’s distribution. The model is run using these
values, and the result is recorded. Then, the process is repeated many times, often thousands or
more. Each run gives a different possible result. These repeated runs build up a large set of
outcomes. By running the simulation this way, you get a better idea of all the possible results
that might happen in the real world. You don’t just look at one scenario, but many. The more
times you run the simulation, the more reliable the overall picture becomes. This step is what
makes the Monte Carlo Simulation powerful; it gives a full view of the risks and chances
involved (Menčík, 2016).

The last step is to analyse and interpret the results. Once all the simulation runs are
complete, the final step is to study the results. You organize and review the outcomes to
understand the range of possibilities. You can calculate averages, maximum and minimum
values, and how often each result occurs. This helps you understand the likelihood of different
outcomes and what they mean. The results can also be shown using charts and graphs to make
patterns easier to see. This step helps you make better decisions by showing how uncertain
factors affect the outcome. You can see the most likely result, as well as the best and worst
cases. This step turns raw simulation data into useful information. It gives you a clearer picture
of what to expect and helps guide planning, choices, and risk management based on the full
range of outcomes (Memon et al., 2020).

QUESTION 1: (C) GIVE 5 ADVANTAGES OF MONTE-CARLO SIMULATION

Firstly, Supports Better Risk Management and Planning. Monte Carlo Simulation helps
organizations identify and prepare for risks before they happen. By showing a full range of
possible outcomes and how likely each one is, it allows users to assess not just what might go
wrong, but also how serious the impact could be. This helps in building more realistic plans,
setting appropriate safety margins, and making contingency strategies. It also helps in
prioritizing resources by highlighting which risks are most critical. Rather than relying on
guesswork or overly optimistic assumptions, decision-makers get a clearer understanding of
potential problems. This leads to more cautious, informed, and resilient planning. Monte Carlo
doesn’t eliminate risk, but it makes it visible and manageable, giving users a stronger position
to respond effectively under uncertainty (Kwak & Ingall, 2009).

Secondly, Simulates Complex Situations Quickly and Accurately. Monte Carlo Simulation
is highly effective for modeling systems with many uncertain inputs and complicated
relationships. Traditional methods often struggle when problems involve a lot of variables or
non-linear behaviors. Monte Carlo, however, can manage these complexities by using random
sampling to explore many possible scenarios. It runs thousands of simulations quickly, giving a
full range of outcomes. Because of this, it can deliver accurate results even when the situation
is too complex for exact formulas or manual calculations. This speed and accuracy make it an
excellent tool for real-world decision-making, where time and reliability are both critical. It
gives users a practical way to test how different inputs affect outcomes without needing to
simplify or ignore important parts of the system (Zhu & Du, 2016).

Thirdly, Reveals Outcomes Under Uncertainty. One of the key benefits of Monte Carlo
Simulation is its ability to show how uncertainty in inputs leads to different possible outcomes.
Instead of giving just one predicted answer, it produces a full range of results by running the
model with randomly selected inputs many times. This helps users understand the likelihood of
various results happening. You don’t just see the average outcome; you also learn about best-
case, worst-case, and in-between scenarios. This broader view gives a clearer picture of risk
and helps prepare for unexpected situations. By showing how sensitive results are to certain
inputs, the simulation also reveals which factors matter most, allowing better focus and
planning. This approach makes decision-making more informed, especially when outcomes are
influenced by changing or unknown factors (Lawler, 2025).

Fourthly, Versatile Across Many Industries. Monte Carlo Simulation is widely used across
various fields because of its adaptability. It can be applied to almost any situation involving
uncertainty or risk. In finance, it can estimate investment returns; in engineering, it helps assess
system reliability; in healthcare, it models disease spread or treatment effects; and in project
management, it forecasts time and cost overruns. The method works with different types of
data and models, whether simple or complex. It doesn’t depend on one type of formula or
structure, which makes it useful in both technical and business environments. This versatility
means that many professionals, from analysts and engineers to managers and researchers, can
use Monte Carlo methods to improve planning, reduce uncertainty, and make more confident
decisions in their specific fields (Kwak & Ingall,2009).

Lastly, Provides a Visual Representation of Results. Monte Carlo Simulation not only
produces numerical data but also presents it visually, making results easier to understand. Tools
like histograms, line graphs, and probability curves help users see how outcomes are spread out
and how likely certain results are. These visuals make complex data more accessible, especially
for people who may not be experts in statistics. By turning thousands of results into clear
images, users can quickly spot trends, outliers, and risks. This helps teams and decision-makers
grasp the full range of possibilities immediately. Visual output also makes it easier to
communicate results to others, including stakeholders or clients, and supports better discussions
and decisions. In short, the visual aspect of Monte Carlo enhances both understanding and
communication (Lawler, 2025).

QUESTION 1: (D) GIVE 4 LIMITATIONS OF MONTE-CARLO SIMULATION

High Computational Cost and Time. Monte Carlo simulations require thousands or even
millions of iterations to produce reliable results. Each iteration simulates a possible outcome
based on random sampling, which consumes significant processing power. For simple models,
this may not be an issue, but for complex systems with many variables, the computational
demand increases sharply. This makes it time-consuming and costly, especially if real-time
decisions are needed or if the model must be run frequently. Additionally, if simulations are used
in industries where quick decisions are critical, like finance or manufacturing, this delay can be a
major drawback. Using powerful hardware or parallel computing can help, but it adds to the cost
and complexity of implementation (Avlijaš, 2019).

Randomness Can Mask Problems. Because Monte Carlo simulations rely on random sampling,
there's always a chance that rare but important events may not be captured, or that outliers skew
the overall results. This randomness can hide structural problems in the model or make outcomes
appear more uncertain than they are. Additionally, repeated runs might yield slightly different
results, leading to inconsistency or confusion in interpretation. This makes it difficult to detect
underlying issues unless proper statistical controls, like confidence intervals or sensitivity
analysis, are used. Without these safeguards, decision-makers may rely on flawed or incomplete
insights, undermining the very purpose of using simulations to inform strategy or risk
management (Raychaudhuri, 2008).

Requires Statistical Expertise and Technology. Setting up and interpreting Monte Carlo
simulations isn’t straightforward. It demands a solid understanding of probability, distributions,
and statistical concepts. Users must be able to define accurate input distributions, build logical
models, and interpret outputs correctly. Mistakes in any of these steps can lead to misleading
results. Additionally, the software and tools used for Monte Carlo simulation, like MATLAB, R,
Python, or specialized platforms, often require programming skills and familiarity with statistical
libraries. This technical barrier can be a limitation for organizations without in-house expertise or
access to training, making implementation more difficult and increasing reliance on external
consultants or data scientists (Avlijaš, 2019).

Hard to Validate. Unlike deterministic models, where the same inputs always yield the same
outputs, Monte Carlo simulations generate a range of outcomes based on random inputs. This
variability makes it hard to validate whether the model is producing accurate or reliable results.
There's no single “correct” answer to compare against, which complicates efforts to confirm that
the simulation is working properly. Moreover, if the assumptions or input distributions are
flawed, the outputs will still look mathematically correct but may be practically useless.
Validation often requires comparing results with historical data or expert judgment, both of
which can introduce further uncertainty. This lack of transparency can reduce trust in the
simulation's recommendations (Raychaudhuri, 2008).
QUESTION 2: How can Monte-Carlo simulation improve HR decision-making
processes?

Monte Carlo simulation is a powerful tool that can significantly enhance decision-making
processes in Human Resources (HR). At its core, Monte Carlo simulation uses random sampling
and statistical modeling to predict a range of possible outcomes based on varying inputs. This
approach allows HR professionals to move beyond simple guesswork or fixed assumptions when
making decisions, providing a more nuanced and data-driven understanding of potential
scenarios. The following points explain how Monte Carlo simulation can strengthen HR
practices across workforce planning, compensation, hiring, budgeting, and policy development.

One keyway Monte Carlo simulation improves HR decisions is by enabling risk assessment.
Traditional HR forecasting often relies on averages or single-point estimates, which can overlook
the variability inherent in human behavior. Monte Carlo simulations generate thousands of
possible outcomes, reflecting a spectrum of uncertainties. This helps HR managers identify not
just the most likely scenario but also worst-case and best-case scenarios. With this insight, HR
can design more robust policies, such as adjusting hiring targets or developing retention
strategies that account for potential fluctuations in workforce dynamics (Xu, 2024).

Monte Carlo simulation also aids in workforce planning by allowing HR teams to model
complex scenarios involving multiple variables simultaneously. For example, an organization
can simulate the impact of different hiring rates, promotion speeds, and retirement trends on its
future talent pool. This multi-variable approach provides a comprehensive picture of how
different factors interact, enabling HR leaders to optimize staffing levels, anticipate skill
shortages, and plan training programs more effectively. It moves HR from reactive to proactive
management, improving overall organizational agility (Raychaudhuri, 2008).

Another benefit is in recruitment strategy optimization. Monte Carlo simulations can help
evaluate the probability of meeting hiring goals under various conditions, such as changes in the
job market or candidate availability. By testing different recruitment tactics within the
simulation, HR can determine which methods offer the highest likelihood of success. This
reduces wasted effort and resources on ineffective recruiting channels and supports data-driven
decision-making that aligns with business objectives (Kanade, 2023).

Performance management can also benefit from Monte Carlo simulation. By modeling
employee performance variability, HR can better predict how changes in training, incentives, or
management styles might influence overall productivity. Simulations can estimate the range of
possible outcomes from implementing a new performance review system or bonus structure,
helping HR to choose approaches that maximize employee engagement and effectiveness while
minimizing unintended consequences (Lark Editorial Team, 2024).

Monte Carlo simulation is useful in succession planning as well. Organizations can simulate
the impact of losing key personnel and assess the readiness of internal candidates to fill critical
roles. This helps HR to identify gaps in leadership pipelines and develop targeted development
plans for potential successors. By understanding the range of possible outcomes related to
leadership changes, companies can reduce the risks associated with sudden departures and ensure
continuity in strategic roles (Lark Editorial Team, 2024).

Compensation planning is another area where Monte Carlo simulation adds value. HR can
model the financial impact of different pay structures, bonus schemes, or benefit changes on
overall payroll costs and employee satisfaction. Simulating these scenarios allows for balancing
competitiveness in the labor market with budget constraints, leading to more sustainable
compensation strategies. This quantitative approach helps justify compensation decisions and
align them with organizational goals (Lark Editorial Team, 2024).

In conclusion, Monte Carlo simulation offers HR a sophisticated yet practical tool to improve
decision-making across various processes. By embracing the uncertainty and complexity
inherent in managing people, simulations provide richer insights than traditional methods.
Whether in workforce planning, recruitment, performance management, succession, or
compensation, Monte Carlo simulation equips HR leaders with data-driven foresight. This results
in more informed, flexible, and strategic decisions that better support organizational success in
an ever-changing environment.
QUESTION 3
Consider a case study where you’re a the HRM in a Non-Governmental Organizations (NGOs)
and have been tasked with assessing the financial viability of launching a new wearable fitness
tracker. The market for such devices is competitive and consumer demand can be highly
variable, influenced by seasonal trends, marketing effectiveness, and competitor actions.
Additionally, the costs associated with manufacturing these devices are subject to fluctuations
due to changes in material costs and supply chain uncertainties. Use Monte Carlo simulation in
Excel to address these challenges. You believe this approach will help you estimate potential
profitability under different scenarios, enabling the company to make well-informed decisions
about pricing strategies, production volumes, and marketing investments. You have also analyzed
past data from similar product launches and market studies within the company. From this
analysis, you have concluded certain metrics that will inform your simulation. An average
demand of 10,000 units for new devices within the first year of launch, with a standard deviation
of 2,000 units, reflecting the uncertainty in consumer uptake. Unit sale price typically ranges
between $50 and $70, depending on competitive pricing and market saturation. The unit cost,
influenced by volatile material prices and manufacturing efficiency, averages $30 per unit with a
standard deviation of $5. This historical data forms the underlying assumptions of your
simulation parameters, helping to create the simulation to reflect current market conditions more
accurately

The goal of simulating different scenario is to estimate profitability under uncertainty using three
sample scenarios.

Given Data
 Average demand is 10,000 units
 Demand standard deviation is 2,000 units
 Unit sale price is random between $50 and $70
 Unit cost is mean of $30 with the standard deviation of $5
The scenarios that will be simulated are:
Scenario 1 – Average;
Scenario 2 – Pessimistic; and
Scenario 3 – Optimistic.

Scenario 1: Average scenario

 Average demand for new devices is 10,000 units
 Unit sale price is $60 (midpoint of $50–$70)
 The average unit Cost is $30

To find revenue is by multiplying demand with unit sale price (10,000 × $60 = $600,000)
To find the value of producing the units is by multiplying demand with unit cost (10,000 × $30 =
$300,000)
There for the expected profit will by by subtracting the total revenue with the production cost
($600,000 − $300,000 = $300,000)
Thus, the profit for an average scenario is $300,000

Scenario 2: Pessimistic Case

 Average demand for new devices is 8,000 units (1 standard deviation below average)
 Unit sale price is $52 (closer to lower bound of $50–$70)
 The average unit Cost is $35 (1 standard deviation above average)

To find revenue is by multiplying demand with unit sale price (8,000 × $52 = $416,000)
To find the value of producing the units is by multiplying demand with unit cost (8,000 × $35 =
$280,000)
Therefore, the expected profit will by subtracting the total revenue with the production cost
($416,000 − $280,000 = $136,000)
Thus, the profit for an average scenario is $136,000

Scenario 3: Optimistic Case

 Average demand for new devices is 12,000 units (1 standard deviation above average)
 Unit sale price is $68 (closer to upper bound of $50–$70)
 The average unit Cost is $28 (1 standard deviation below average)
To find revenue is by multiplying demand with unit sale price (12,000 × $68 = $816,000)
To find the value of producing the units is by multiplying demand with unit cost (12,000 × $28 =
$336,000)
Therefore, the expected profit will by subtracting the total revenue with the production cost
($816,000 − $336,000 = $480,000)
Thus, the profit for an average scenario is $480,000

SUMMARY TABLE
Scenario Unit Unit Unit Revenue Total Cost Profit
Demand Price production
cost
Average 10,000 units $60 $30 $600,000 $300,000 $300,000

Pessimistic 8,000 units $52 $35 $416,000 $280,000 $136,000

Optimistic 12,000 units $68 $28 $816,000 $336,000 $480,000

The summary table which is derived from three different simulation shows that all simulations
expect profit which differs depending on demand, unit cost and pricing.
 References
Avlijaš, G. (2019). Examining the value of Monte Carlo simulation for project time management.
Management: Journal of Sustainable Business and Management Solutions in
Emerging Economies, 24(1), 11–23.

Kanade, V. (2023, September 12). What is a Monte Carlo simulation? Working, applications,
pros, and cons.

Kwak, Y. H., & Ingall, L. (2009). Exploring Monte Carlo simulation applications for project
management. IEEE Engineering Management Review, 37(2), 83.

Lark Editorial Team. (2024, January 13). Monte Carlo simulation for human resources teams.

Lawler, J. (2025, May 15). What is Monte Carlo simulation? Applications in finance and beyond.
Investing 101.

Memon et al. (2020). Sample size for survey research: Review and recommendations. Journal of
Applied Structural Equation Modeling, 4(2), i–xx.

Menčík, J. (2016). Monte Carlo simulation method. In Concise reliability for engineers

Raychaudhuri, S. (2008). Introduction to Monte Carlo simulation. In Proceedings of the 2008

Winter Simulation Conference, Global Gateway to Discovery (pp. 122–130). IEEE.

Summerscales, O. (2023, November 1). Hitting the jackpot: The birth of the Monte Carlo
method.

Xu, T. (2024). The application of Monte Carlo simulation for risk and behavior analysis in
financial markets. Highlights in Business Economics and Management, 45, 19–24.

Zhu, Z., & Du, X. (2016). Reliability analysis with Monte Carlo simulation and dependent
Kriging predictions. Journal of Mechanical Design, 138(12).