Background
Modern Niagara is one of Canada’s largest and most reputable construction companies. It has locations across the country and specializes in mechanical, electrical, and building services. Modern Niagara is involved in many prominent projects, such as the West Park Healthcare Centre in Toronto and the New St. Paul’s Hospital in Vancouver.
Challenge
At any given time, companies like Modern Niagara have hundreds of jobs in their bid pipeline. These include active jobs as well as outstanding bids. It is often challenging to get a holistic view of operations across the entire pipeline, especially when teams are spread out geographically and jobs are in various stages of their life cycle. This often translates to a lack of visibility and missed opportunities.
To this end, Modern Niagara reached out to Alphabyte to create a centralized view of its construction bids pipeline.
Fix This for Us!
Modern Niagara struggled with the following questions with regard to its bid management:
- What is the total dollar value of jobs in the pipeline?
- What is the expected dollar value of outstanding bids should they convert?
- How does the combined value of Won jobs and Outstanding bids compare to the yearly Target?
- How does the total bid value break down by Trade and Location?
Enterprise Solution
To Address Modern Niagara’s challenges, we developed a bid performance dashboard that gives Executives and Estimators a holistic view of jobs in the bid pipeline. The dashboard captures all projects in the pipeline and shows how revenue breaks down by Trade, Location, and status (Won, Bid, Future). The dashboard provides insights into how the company is performing versus Target and highlights future opportunities.
Note the following KPIs in the dashboard:
-
- Revenue Target: The revenue goal for the specific period
- Revenue Won: The accumulated revenue from awarded jobs
- Remaining Target: The outstanding revenue required to achieve the revenue target (Revenue Target – Revenue Won)
- Won Bids vs Target: Revenue Won as a percentage of Target
- All Bids vs Target: The value of all Bids (Won + Outstanding) as a percentage of Target
A Success Story
As a result of this collaboration, Modern Niagara now has full visibility into its bids pipeline. Hundreds of estimators, analysts, and managers across the company now rely on this dashboard to gain insights, identify trends, and capture opportunities.