Dashboard Tracking System – A Mechanical Construction Firm

Nationwide Mechanical Contractor logo

NMC has over 30 years of experience as a nationwide mechanical contractor serving industries such as Plastics,  Industrial Laundries, Food Processing, and Material Handling. They possess expertise in mechanical design and specialize in the installation of process mechanical systems. As a division of a major construction company, NMC needed a system to track progress and provide overviews of projects underway.

Challenge Challenge - Mountain without Flag

NMC’s current system, Viewpoint, and use of spreadsheets alone did not provide sufficient insight regarding  the progress of a job. NMC employees had to manually input data about each job from their system into a  spreadsheet and pass it along through the organization for planning purposes. Throughout the project, the  team questioned whether or not they were on budget and on schedule.

NMC needed a way to track projects with summary-level visibility of the project as a whole. This transparency  would allow them to know if they are ahead or behind on a job so they can re-estimate hours and material for  the next week.

Solution Solution - Mountain with Flag

The application we built for our client fixed issues around lack of insight on project progress, allowing them to  plan labor and materials more precisely and accurately.

     dashboard tracking system UI

The system  implemented a hierarchy of rules and permissions so different levels within the organization can only see information they need to about a job. Designated users in the Foreman, Superintendent and Project Manager  roles are able to update the details for all projects to which they are assigned. This includes their best current estimate for remaining hours (for each CSI code), and also the ability to add their estimated projected end date of the overall project.

The application integrates with the Viewpoint application to retrieve all project-related information, including  all CSI codes, original project estimates and actual hour and cost values for current weekly and project-to-date  information, as entered on the weekly Viewpoint time-cards. Other user roles see a dashboard corresponding to only their position. All users have the ability to filter and narrow down projects displayed based on things  like status, geography, supervisor etc.

Project information and key metrics would be summarized on one screen. The existing system possesses  general project information and a time sheet which we integrated with the new system to generate project  overviews. The overviews are useful for project managers and other key members within the organization.

latest news

01

Start With a Plan: 3 Reasons To Begin Any Development Project With a Discovery Session

Ninety percent of alligatortek clients that begin development with a discovery session will continue to the second part of the process. Want to know why? Here are three reasons why a planning stage will produce better results for you

02

File-Snapshot Backups to Microsoft Azure Blob Storage

Azure’s SQL Server data files allow us to create a database in an on-premises SQL Server or an available server in the Azure Virtual Machine. This database is tied to our application using a specific location in Azure blob storage. The File-Snapshot backup, introduced in SQL Server 2016, is capable of quickly performing a backup and restore.

03

How to create an Azure subscription

Anyone can harness the power of Microsoft Azure with a free trial account. The trial comes with a $200 credit, valid for 30 days.

Copyright© 2018 alligatortek. All rights reserved.