Date of Award
Master of Science in Operations Research
Department of Operational Sciences
Gregory S. Parnell, PhD
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.
DTIC Accession Number
Bishop, Steven T., "A Methodology to Generate Air Force Materiel Command Manpower Reduction Alternatives" (1995). Theses and Dissertations. 6453.