Accession Number : ADA293831

Title :   A Methodology to Generate Air Force Materiel Command Manpower Reduction Alternatives.

Descriptive Note : Master's thesis,

Corporate Author : AIR FORCE INST OF TECH WRIGHT-PATTERSON AFB OH SCHOOL OF ENGINEERING

Personal Author(s) : Bishop, Steven T.

PDF Url : ADA293831

Report Date : 07 MAR 1995

Pagination or Media Count : 87

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.

Descriptors :   *DECISION MAKING, *PERSONNEL MANAGEMENT, *REDUCTION, *DECISION AIDS, *AIR FORCE PLANNING, MATHEMATICAL MODELS, COMPUTERIZED SIMULATION, INPUT, METHODOLOGY, MATERIEL, INTEGRATED SYSTEMS, PARAMETERS, LINEAR PROGRAMMING, TEAMS(PERSONNEL), THESES, PROBLEM SOLVING, AIR FORCE PERSONNEL, MANPOWER, ALLOCATIONS, OPERATIONS RESEARCH, RESOURCE MANAGEMENT.

Subject Categories : Personnel Management and Labor Relations
      Logistics, Military Facilities and Supplies

Distribution Statement : APPROVED FOR PUBLIC RELEASE