Date of Award


Document Type


Degree Name

Master of Science in Operations Research


Department of Operational Sciences

First Advisor

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.

AFIT Designator


DTIC Accession Number



The author's Vita page is omitted.