Modeling the Value of Micro Solutions in Air Force Financial Management
MBA professional rept.
NAVAL POSTGRADUATE SCHOOL MONTEREY CA
Pagination or Media Count:
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 Task 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 short-term 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.
- Economics and Cost Analysis