Article ID: | iaor19912152 |
Country: | United States |
Volume: | 31 |
Start Page Number: | 62 |
End Page Number: | 68 |
Publication Date: | Dec 1990 |
Journal: | Production and Inventory Management Journal |
Authors: | Penlesky Richard J., Armacost Robert L., Ross Steven C. |
Keywords: | spreadsheets |
Implementing a Monte Carlo simulation on a spreadsheet requires special attention in maintaining spreadsheet stability, generating random observations, ensuring repeatability of observations, and controlling the progress of the simulation. A Monte Carlo simulation of an aggregate planning model that includes a macro control program is used to illustrate these issues.