Spreadsheet Modeling of Equipment Acquisition Plans

Excel spreadsheets have been used in many classrooms to teach modeling and analysis of real business problems. This can be done with relative ease but often the modeling approach may be inappropriate and the analysis results not easily implemented. In this article, we illustrate these difficulties with the modeling of the number of equipment required in future years, given demand (historical and projected) and the amount of equipment held. We show how the desired output can be, and needs to be related to the given input. For this purpose, we apply the TREND function to predict data into future years. The real learning of this article comes from deriving actionable implementation solutions from the modeling results. We discuss this in terms of converting future equipment numbers into an equipment acquisition plan