We were contracted to rebuild a large foods manufacturer's facility assessment program into a usable tool that would improve the safety, condition and operating efficiency of more than 30 facilities.
Our team met with the client's staff and analyzed the existing facility condition assessment program. We proposed adjustments that would allow the staff to more readily use the data to support the capital planning process. The new assessment program used a combination of mobile computing, GIS and database technologies to allow a multidisciplinary engineering team to audit a facility and efficiently catalog and report on any observed deficiencies.
The main data collection tool was a tablet PC that allowed auditors to write directly on the screen, similar to using a pad of paper. The tablet PC had a custom ArcGIS Mobile data collection solution that allowed auditors to note deficiencies or issues in the facility by quickly placing an observation at their exact location based on facility drawings within the application. Additionally, auditors used a custom designed data collection form to write directly on the tablet PC screen to capture details about the issue. The tablet PC contained a digital camera that allowed the auditors to attach photographic documentation.
The condition assessment application included a risk-based analysis that allowed auditors to assess the probability, severity and detection capabilities of an asset failure. The assessment of these risk categories was then used in a calculation that would rate the overall risk associated with the specific asset or group of assets and allow the client to prioritize the spending of capital funds and preventative maintenance dollars.
At the end of each audit day the team uploaded data from the tablet PC by connecting to the internet and clicking a button. All facility audit data was uploaded to an enterprise SQL Server database that supported the overall facility audit program. The audits generally lasted four to five days.
The final component of the assessment program was a secure website hosted by Burns & McDonnell that allowed the client to log in, query, sort or filter the audit data from all 34 facilities. The web-based tool provided a global view of the condition assessment and allowed management to determine capital budget priorities. It also included the ability to run reports that showed cost estimates to repair deficiencies noted during the facility audit.
- Multidisciplinary audit team
- ArcGIS mobile application development
- System integration
- Database design
- Data conversion
- Website development
- Website hosting