Modeling the value of micro solutions in Air Force Financial Management

Thumbnail Image
Files
05Dec%5FOHare%5FMBA.pdf (1.94 MB)
Authors
O'Hare, Scott M.
Krott, James E.
Subjects
Excel VBA
Excel programming
spreadsheet programming
Visual Basic
Visual Basic for Applications
automated solutions
short-term solutions
Micro Solutions
software development model
software development growth factor
Advisors
Brinkley, Douglas E.
Franck, Raymond E.
Date of Issue
2005-12
Date
December 2005
Publisher
Monterey, California. Naval Postgraduate School
Language
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.
Type
Description
MBA Professional Report
URI
https://hdl.handle.net/10945/9997
Series/Report No
Department
Graduate School of Business & Public Policy (GSBPP)
Organization
Identifiers
NPS Report Number
Sponsors
Funder
Format
51 p. : ill. (some col.)
28 cm.
Citation
Distribution Statement
Approved for public release; distribution is unlimited.
Rights
Collections
Theses