Development of Spreadsheet Models for Forecasting Manpower Stocks and Flows

Abstract

The computerized manpower planning models developed in this thesis were designed to be used by students taking the Manpower Personnel Models course, OS4701, in the Manpower Systems Analysis Curriculum at the Naval Postgraduate School. The purpose of the course is to introduce students to some of the basic manpower modeling concepts and these models are the prime instruments toward achieving that goal. The models constructed using Microsoft Excel (Trademark) include a Markov Chain Model, a One Grade Vacancy model, a Multigrade Vacancy model with Non-Instantaneous Filling of Vacancies, and a Vacancy model with Instantaneous Filling of Vacancies. The models are designed to be run on personal computers with a Microsoft Windows 95 (Trademark) operating system. User's manuals and example problems are included for each model in the appendices.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Mar 01, 1998
Accession Number
ADA344928

Entities

People

  • Michael G. Earl

Organizations

  • Naval Postgraduate School

Tags

DTIC Thesaurus Topics

  • Attrition
  • Computations
  • Computer Programming
  • Computer Programs
  • Computers
  • Delphi Method
  • Flow Rate
  • Instructors
  • Manpower
  • Markov Chains
  • Markov Models
  • Operating Systems
  • Operations Research
  • Personal Computers
  • Probability
  • Spreadsheet Software
  • United States Naval Academy

Readers

  • Computational Modeling and Simulation
  • Life Cycle Cost Analysis
  • Naval Personnel Management