Spreadsheet: mary_fischer__25442__roi_version_2
Sheet: Workforce Mgmt Survey

 | Workforce Management | Response |  |  | Y
 |  |  |  |  | N
 | A) Please select the statement that best describes the customer's work management practices | 2 |  |  | 1
 | 1) Most work performed when equipment fails.  Problems are addressed as they are discovered.  Very little record keeping and data available is poor in quality.  Small % of maintenance time is devoted to prevetative measures. |  |  |  | 2
 | 2) Uses routine inspections, lubrications, adjustments, and minor service to improve equipment [NAME].  [NAME] keeping is sporadic and data quality is somewhat dependable.  Roughly 50% of work is devoted to preventative measures. |  |  |  | 3
 | 3) Utilizes techniques such as vibration analysis, thermography, sonics, etc. to monitor equipment condition to allow for proactive replacement and problem solving instead of failures.  [NAME] keeping is extensive with very high and reliable data quality.  80% of work is devoted to predictive or preventative activities. |  |  |  | 4
 | B) Please select the statement that best describes the customer's work order entry process | 1
 | 1) Verbal notification of work request
 | 2) Written work request centrally received in maintenance and entered by the maintenance supervisor in a work management database
 | 3) Work requests entered electronically by requestor directly into an enterprise level work management system
 | C) Please select the statement that best describes the customer's work order generation process | 1
 | 1) Manual ad-hoc generation of work orders
 | 2) Work orders generated on a largely ad-hoc basis by a local plant-level system
 | 3) Work orders generated electronically from enterprise level asset management solution based on ad-hoc requests and planned maintenance schedules.
 | D) Please select the statement that best describes the customer's job scheduling capability | 1 |  |  | 1
 | 1) All job scheduling is managed manually |  |  |  | 2
 | 2) Job scheduling is managed electronically and can track hours available and/or by trade. |  |  |  | 3
 | 3) Job scheduling is managed electronically and can track hours available, hours by trade, report on individual hours and costs, and handle employee substitution |  |  |  | 4
 | E) Please select the statement that best describes the customer's use of data collection/bar coding technologies | 2
 | 1) Minimal use of automated data collection technologies
 | 2) Spot use of data collection technologies in the some areas of the plant
 | 3) Extensive use of data collection and bar coding technologies to track assets, compile information, and conduct object audits and physical inventories
 | F) Please select the statement that best describes the customer's use of hand held or mobile technologies | 1
 | 1) Minimal use of mobile technologies
 | 2) Spot use of mobile technologies to perform data entry tasks and receive information
 | 3) Extensive use of mobile technologies to perform data entry tasks and receive information
 | G) What is the average fully loaded hourly rate (fully loaded = standard rate x 1.22 in general) for a maintenance employee? | 56
 | H) Total maintenance hours (exclude overtime) logged in the past 12 months? | 260000 | days
 | I) Total overtime hours logged in the past 12 months? | 17600 | days