Title
A Spreadsheet-Based Macro Manpower Model
Abbreviated Journal Title
Comput. Ind. Eng.
Keywords
Computer Science; Interdisciplinary Applications; Engineering; Industrial
Abstract
This paper describes the use of spreadsheets as a tool for macro-manpower modeling. The model defines drivers which are “output measures” for an organization. These drivers are quantified for a Base Case and for points in the future. Staffing for the various departments of the organization are defined for the Base Case. Next, estimates are made of the percent effort by department for each driver. The model also includes a number of damping factors which affect reaction of the model to changes in values of the Drivers. The model can also accommodate special features of a particular organization's manpower needs. The model is a menu-driven LOTUS 1-2-3 template which outputs estimated staffing by department, standards associated with each driver, and graphical output. The approach is presented in connection with a specific application at the Naval Training Systems Center in Orlando.
Journal Title
Computers & Industrial Engineering
Volume
11
Issue/Number
1-4
Publication Date
1-1-1986
Document Type
Article
Language
English
First Page
316
Last Page
320
WOS Identifier
ISSN
0360-8352
Recommended Citation
Whitehouse, G. E. and Hodak, G. W., "A Spreadsheet-Based Macro Manpower Model" (1986). Faculty Bibliography 1980s. 563.
https://stars.library.ucf.edu/facultybib1980/563
Comments
Authors: contact us about adding a copy of your work at STARS@ucf.edu