A Methodology to Generate Air Force Materiel Command Manpower Reduction Alternatives.
Abstract
The purpose of this study is to generate manpower authorization reduction alternatives for Air Force Materiel Command. The advent of low-cost personal computer software applications, such as Excel, has created an assessable tool with the ability to solve linear programming problems. This research examines the manpower resource reduction process of Air Force Materiel Command and models the Resources Allocation - Integrated Process Team (RA-IPT) decision process. A linear programming model is developed to assign these reduction through a weighted sum. The linear programming model is developed as a Microsoft Excel spreadsheet model, the Exercise Support Program (ESP), using Visual Basic macro language. ESP uses the input parameters to generate decision alternatives for the decision makers at the RA-IPT. Test cases are developed to validate the model using known scenarios, and sensitivity analysis is shown for the weight parameters and the constraints. The study reveals that ESP is a viable methodology to generate decision alternatives and to assign manpower reductions in each organization throughout the command.
Document Details
- Document Type
- Technical Report
- Publication Date
- Mar 07, 1995
- Accession Number
- ADA293831
Entities
People
- Steven T. Bishop
Organizations
- Air Force Institute of Technology