Critical Decision-Making: Developing Simulation Model Report

Exclusively available on IvyPanda Available only on IvyPanda

Making business decisions is never easy, especially when it involves some complicated scenarios, which require critical decision-making (Taylor, 2010). Simulations are useful tools in accomplishing such a task as they provide a value, which often forms the basis for decision-making (Buglear, 2005).

We will write a custom essay on your topic a custom Report on Critical Decision-Making: Developing Simulation Model
808 writers online

Various computer applications support this function, including Excel. In this paper, excel simulation used to come up with convincing decisions regarding whether or not the business should purchase a back-up copier.

The number of days required for copier repair whenever it is out of service is generated based on a discrete distribution model, with the help of Excel. The discrete distribution is assumed is as follows:

Repair time (Days taken)Probability
10.2
20.45
30.25
40.1

The number of days required to repair the copier are generated from excel. The simulation model developed is based on the functions described below:

The Rand function is used to generate random probabilities, which are subjected to test in order to simulate the possible situation. To generate the number of repairs likely to be performed over the duration, the function is used. It simulates the number of times (days) that the copier will be subjected to repair.

The Rand function.

An extract of the obtained results is in the table below:

Repair times (days)
11
22
33
42
52
62
72
82
92
101
112
123
131
143
151

A continuous distribution model is used to simulate the interval between successive breakdowns (in weeks) is developed using Excel functions. The model assumes a straight-line function. Randomly selected probability values are selected using the RAND () function. The y function is therefore solved using the function

1 hour!
The minimum time our certified writers need to deliver a 100% original paper
The model assumes a straight-line function.

This helps in generation of the intervals amidst successive breaks. Part output is revealed in the table below:

Repair times/days (1st15 simulations)Random probabilityBreak intervals
10.44.72314135
20.72.002696731
30.75.255727961
20.54.292089408
20.12.457429285
20.65.081012821
20.23.356681152
20.83.235287261
20.54.470013043
10.52.380419757
20.12.00572022
30.11.722544679
10.54.66851108
30.34.97296724

Daily revenues lost when the copier is not in service is generated based on the difference between the copies produced every day. Additionally, the cost of each copy is factored in, that is $0.1 each. Using the information, downtime value will be calculated and compared against the set threshold revenue loss of $12,000 to decide whether to purchase the copier or not. The daily revenue loss generated is given by the expression below:

The daily revenue loss generated.

Whereby the RAND () function represents the generated random probability value. The simulation returns a cumulated downtime loss less than the 12,000 set as threshold for purchasing a new copier, implying that they will not need to buy a backup copier (see excel sheet attached). The simulation of the last 15 variables shown below illustrates this.

Repair times/daysRandom probabilityBreak intervalCost of revenueRevenue lost when copier waiting for repairTotal time in daysCumulative downtime loss (daily)
30.92.43548722.4702167.4123020.04839010722.59519
20.95.16072729.9821459.9657338.12504810760.72023
10.15.81797289.455289.45578141.72582510802.44606
20.34.48262374.037748.07583033.37840910835.82447
20.15.82270240.754481.50957842.75895110878.58342
20.75.21720639.8261279.6528238.52041310917.10383
20.44.47012448.656897.31239133.29087210950.39471
10.15.43246275.254275.25472239.02724510989.42195
20.15.42346247.304494.60890839.96428911029.38624
20.43.82001414.358828.71711728.74007011058.12631

The ability of the generated model to use the prevailing conditions to simulate the conditions likely to prevail and hence aid planning in terms of resources.

It is presumed that if the model is able to generate good values based on the functions Rand () in Excel, then equal amounts of random values should be generated in the long run. This helps in developing a test for the model efficiency, using excel. The obtained excel results are illustrated in the figure below:

Random probability valuecumulative frequencyFrequencyExpected percentageObtained percentageDifference
0.1353510%9.590.41
0.2754010%10.96-0.96
0.31103510%9.590.41
0.41554510%12.33-2.33
0.51923710%10.14-0.14
0.62233110%8.491.51
0.72603710%10.14-0.14
0.83024210%11.51-1.51
0.93272510%6.853.15
13653810%10.41-0.41

The obtained deviations in relation to the expected value of 10 are small, and hence, this forms the basis for confirming that the model is well suited to predict the future scenarios and hence can be used to decide whether investment should be directed towards acquiring a new copier.

Limitations of study

Despite the fact that the simulation offers a good basis for making decisions, like any other tool, it is not without limitations. Computational efficiency may not well reflected the immediate situations to be witnessed during the initial stages of the business.

Remember! This is just a sample
You can get your custom paper by one of our expert writers

The study does not factor in other factors that might influence the businesses performance during the initial study. This is taking into consideration the fact that initial businesses often suffer various performance challenges.

Conclusion

In conclusion, it is important to mention that excel provides a good avenue for development of simulation models in decision-making. From the developed model, a minimum threshold revenue loss value is set and a simulation run to establish if a new back up should be purchased.

It generally attests to the fact that buying a back-up copier will not add to the groups revenues. The model provides minimal variations in terms of probability distribution indicating that it is an effective tool for making decisions.

References

Buglear, J. (2005). Quantitative methods for business: the A to Z. Oxford, U.K.: Elsevier Butterworth-Heinemann.

Taylor, B. M. (2010). Introduction to management science (10th ed.). Upper Saddle River, NJ: Pearson/Prentice Hall.

Print
Need an custom research paper on Critical Decision-Making: Developing Simulation Model written from scratch by a professional specifically for you?
808 writers online
Cite This paper
Select a referencing style:

Reference

IvyPanda. (2022, June 23). Critical Decision-Making: Developing Simulation Model. https://ivypanda.com/essays/jet-copiers-case-study-report/

Work Cited

"Critical Decision-Making: Developing Simulation Model." IvyPanda, 23 June 2022, ivypanda.com/essays/jet-copiers-case-study-report/.

References

IvyPanda. (2022) 'Critical Decision-Making: Developing Simulation Model'. 23 June.

References

IvyPanda. 2022. "Critical Decision-Making: Developing Simulation Model." June 23, 2022. https://ivypanda.com/essays/jet-copiers-case-study-report/.

1. IvyPanda. "Critical Decision-Making: Developing Simulation Model." June 23, 2022. https://ivypanda.com/essays/jet-copiers-case-study-report/.


Bibliography


IvyPanda. "Critical Decision-Making: Developing Simulation Model." June 23, 2022. https://ivypanda.com/essays/jet-copiers-case-study-report/.

Powered by CiteTotal, essay referencing tool
If you are the copyright owner of this paper and no longer wish to have your work published on IvyPanda. Request the removal
More related papers
Cite
Print
1 / 1