Date of Award

3-1995

Document Type

Thesis

Degree Name

Master of Science in Operations Research

Department

Department of Operational Sciences

First Advisor

Gregory S. Parnell, PhD

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.

AFIT Designator

AFIT-GOR-ENS-95M-01

DTIC Accession Number

ADA293831

Comments

The author's Vita page is omitted.

Download

Share

COinS