Spreadsheet Modeling of Equipment Acquisition Plan
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.
Computer Sciences | Education | Management Information Systems
Intelligent Systems and Decision Analytics
Decision Sciences Journal of Innovative Education
LEONG, Thin Yin and CHEONG, Michelle Lee Fong.
Spreadsheet Modeling of Equipment Acquisition Plan. (2008). Decision Sciences Journal of Innovative Education. 6, (2), 365-373. Research Collection School Of Information Systems.
Available at: http://ink.library.smu.edu.sg/sis_research/776