Modeling the value of micro solutions in Air Force Financial Management

Abstract

The purpose of this MBA Project was to develop a model that would estimate the value of applying available spreadsheet programming tools to automation opportunities in Air Force Financial Management (FM). Model inputs include Labor Estimates, Labor Rates, and T ask Characteristics, while outputs are represented in terms of Return on Investment, Payback Period, and Annual Savings. The boundaries of the model are limited to the Microsoft Excel Visual Basic for Applications (VBA) development environment for the development of shortterm (<1 year) automation opportunities of low to moderate complexity (Micro Solutions). First, the project model will be outlined and discussed; including the methodology, assumptions, and the specific mapping of input variables to model outputs. Then the model will be used to analyze six actual field-developed case solutions and project potential value for two currently unrealized solutions. Finally, the project will present recommendations drawn from practical application of the model.