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).
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:
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.
An extract of the obtained results is in the table below:
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
This helps in generation of the intervals amidst successive breaks. Part output is revealed in the table below:
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:
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.
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:
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.
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.