Security Manpower Planning Model

The Security Manpower Planning Model is a flexible decision support tool created to enable transit security planners the ability to assess impacts of strategic decisions on resources and staffing. Based on the data inputted, the model identifies staffing levels and budgeting. The SMPM is can be used by any transit agency with existing or planned security resources, regardless of operating mode(s) or size. Further, the model can assist security planners in assessing impacts of various scenarios on resource and deployment strategies.

The SMPM is a macro-based application that runs within Microsoft Excel 2003.  The application may also run within other versions of Excel, with the following caveats:

download files