future variability, and so this is what we have been
reporting.
12 PRACTICAL
CONSIDERATIONS
In practice, one of the most time consuming tasks in
the application of the presented method has been the
identification of historical exceptions that must be
ignored in deriving the values of
,
,
and
,
. In
the past, many events have taken place that should be
excluded in equilibrium staffing analyses. For
example, in the DND, entire units have been
transferred to other government departments, and
some occupations have been restructured, or split
from others, resulting in spikes in observed attrition
or transfers. However, there has been no centralized
record keeping of such changes. Careful outlier
detection of the historical record has been necessary
to identify the anomalies in the data record.
Another practical consideration has to do with the
many very small occupation-levels in the Department
of National Defence. It is unreasonable to model
staffing actions in very small occupations where the
historical record is insufficient to accurately describe
typical flow rates. Also, in very small occupations,
future events will not be averaged out over enough
individuals to be predictable. Ignoring the small
occupation-levels is not necessarily the best option.
First, Human Resources Planners might prefer a poor
estimate to none at all, but also, modelling the larger
occupation-levels still requires consideration of their
interactions with the smaller ones. The solution is to
aggregate select occupation-levels, such as
combining adjacent levels of an occupation. This is a
delicate task, as the small occupation-levels should
only be aggregated with similarly-behaving ones.
In order to determine when smaller occupation-
levels should be aggregated, an understanding of the
relationship between headcount and the width of
prediction intervals around occupation-level
estimates will be helpful. We would then keep
aggregating until the confidence intervals become
sufficiently narrow. So far, we have used 10 years of
historical data, and groupings of no less than 10
employees – giving a minimum of 100 employee-
years per segment. This is certainly on the low end
of statistical relevance. Until a characterization of
model confidence can be completed, we believe that
reporting the historical ranges in staffing flows will
provide sufficient context.
13 CONCLUSION
This paper presented a method that takes historical
staffing data as input, and derives expected
equilibrium staffing flows that have been valuable to
Human Resource Strategic Planning in Canada’s
DND. The expected flows can inform the allocation
of Human Resource capacity to process staffing
actions, and can also contribute to assessments of
occupational health by flagging occupation-levels
with unusually high or low flows.
REFERENCES
Bartholomew D.J., Forbes A.F. and McClean S.I., 1991.
Statistical techniques for manpower planning, John
Wiley and Sons. Chichester, United Kingdom, pp. 7-8.
Bartholomew D.J., 1969. A Mathematical Analysis of
Structural Control in a Graded Manpower System,
California University, Berkley, Ford Foundation
Program for Research in University Administration.
Available at:
https://files.eric.ed.gov/fulltext/ED080084.pdf
Calitoiu, D. and Vincent, E., 2017. Logistic Regression
Model for Attrition in DND Civilian Employees
(Director General Military Personnel Research and
Analysis Scientific Report DRDC-RDDC-2017-R177).
Defence Research and Development Canada, Ottawa,
ON.
Doumic, M., Perthame, B., Ribes, E., Salort, D. and
Toubiana, N., 2016. Toward an Integrated Workforce
Planning Framework using Structured Equations,
European Journal of Operational Research, 262(1), pp.
217-230. Elsevier. Available at: https://hal.inria.fr/hal-
01343368/document
Georgiou, A.C., 1999. Aspirations and Priorities in a Three
Phase Approach of a Nonhomogeneous Markov
System, European Journal of Operational Research,
116(3), pp. 565-583. Elsevier.
Fang, M. and Bender, P., 2011. Analyzing Changes in
Attrition of the Canadian Forces, In: MS 2011,
Modelling and Simulation Symposium, Calgary,
Canada.
Fang, M. and Bender, P., 2008. Canadian Forces Attrition
Forecasts – What One Should Know, (Centre for
Operational Research and Analysis Technical
Memorandum DRDC CORA TM 2008-60). Defence
Research and Development Canada, Ottawa, ON.
Available at:
http://cradpdf.drdc.gc.ca/PDFS/unc85/p531551.pdf
Filinkov, A., Richmond, M., Nicholson, R., Alshansky, M.
and Stewien, J., 2011. Modelling Personnel
Sustainability: A tool for Military Force Structure
Analysis, Journal of the Operational Research Society,
62(8), pp. 1485-1497. Springer.
Marquez, W. and Nelson, A., 1996. Total Army Personnel
Life Cycle Model: Development of a General Algebraic