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 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.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Dec 01, 2005
Accession Number
ADA443348

Entities

People

  • James E. Krott
  • Scott M. O'hare

Organizations

  • Naval Postgraduate School

Tags

Communities of Interest

  • Biomedical
  • Human Systems
  • Weapons Technologies

DTIC Thesaurus Topics

  • Air Force
  • Application Software
  • Basic Programming Language
  • Boundaries
  • Business Administration
  • Case Studies
  • Civilian Personnel
  • Computer Programming
  • Financial Management
  • Investments
  • Language
  • Military Personnel
  • Personnel Management
  • Programming Languages
  • Software Development
  • Spreadsheet Software
  • United States

Readers

  • Computational Modeling and Simulation
  • Life Cycle Cost Analysis