dialog background

How we used Power Apps to help Tracc Civil keep inventory on track.

Case Study
Quote

“The Bremmar solution has helped us to increase productivity across teams. It replaces paper spreadsheets with an app that can be used in the office, at the depot, in the delivery trucks, and on site.”

Carl - IT Systems Administrator

Tracc Civil is a civil engineering company that completes major earthworks, road construction, large scale walls and in-ground divisions. Much of their work is for State Government infrastructure projects and clients such as Alinta, Western Power, and Watercorp.

BUSINESS CHALLENGE

With multiple projects across Western Australia, Tracc Civil needed a more integrated system for the ordering, dispatch, delivery, tracking, and return of over 400 different types of equipment used on site.

Tracc Civil had previously relied on outdated InfoPath software to coordinate their large inventory of equipment and materials. For a typical job, it required sending spreadsheets from person to person. There was no simple central overview and there were high risks of duplication and double-handling.

THE SOLUTION

Carl from Tracc Civil knew there had to be a better way. He spoke to the Bremmar team about possible solutions. Carl commented, “Brenton and Paul from Bremmar worked closely with me to map out a plan to migrate the inventory of equipment from the outdated InfoPath system into a new Microsoft Power Apps solution.”

Power Apps was used to create custom apps that Tracc Civil could use to manage materials and equipment requests at every step of a project’s workflow.

The new system allows managers to quote and cost jobs with simple pull-down menus of inventory items. The approved equipment is then loaded at the right time to deliver to site and checked-off on arrival. Additional equipment can be requested, approved and accounted for, plus everyone is informed if items are unavailable or placed on back order. Carl explained “The Bremmar solution has helped us to increase productivity across teams. It replaces paper spreadsheets with an app that can be used in the office, at the depot, in the delivery trucks, and on site.”

Paul from Bremmar made sure he understood the needs of the Tracc Civil people involved in the equipment supply pipeline, and the parts they played in the process. These insights, combined with Carl’s succinct brief about what the new system should do, allowed Bremmar to tailor a very useful solution in Power Apps.

THE RESULTS

“I wanted a better way to manage ordering and delivery. Bremmar had the solutions,” states Carl.

The digital automation in the Power Apps streamlines many processes for Tracc Civil, reduces the risk of human error, and gives everyone total oversight of equipment and materials management. Users access data on site from their smart phones or tablet devices, plus it can be viewed in the office on desktop computers.

Staff who request materials have full visibility on the status of their order, so they know if it is pending review, parts allocated, delivery being made today, or delivery completed. The delivery drivers know what they are delivering. Project Managers can oversee the requests being made by the staff, and know what items are being costed to their jobs.

“I’m very happy with the process, service and solutions. The Bremmar team were fantastic and always on the ball”, said Carl.

HOW CAN WE HELP YOU?

We can help you create Power Apps that automate and simplify your workflow processes. Bremmar has extensive experience in the engineering, construction and mining services. As accredited Microsoft Gold Productivity Partners, we can help you and your team leverage the power of the Microsoft 365 Stack to work smarter.

We manage IT services for a number of organisations similar to yours and understand the unique needs of the sector. Why not set up an initial meeting to learn more? Call us on 1300 991 351 or email help@bremmar.com.au

Ready to get started? Let's talk.

Fill in your details & we'll be in touch
Or call on: 1300 991 351

  • This field is for validation purposes and should be left unchanged.
Fields marked are required
Bremmar staff image