Problem Statement:
The procurement department manually compared order status reports, which took up to 3 hours per project. Additionally, the reports contained thousands of line items, making it difficult for project managers to quickly identify key differences, wasting time during meetings.

Solution:
An automated program was developed that compares the current and previous month’s order status reports, which the procurement department now generates and distributes themselves. The program highlights the key differences, making it easier for project managers to focus on what matters.

Savings of Time and Money:
This automation reduces comparison time from 3 hours per project to just 5 minutes, saving approximately 97% of the time spent on this task. With 8 projects, generating reports biweekly, the total time saved each year is around 607 hours, resulting in a savings of $91,000 in procurement alone.

Additionally, the time saved in procurement has led to significantly shorter meetings with high-level project holders, as the data is now more accessible and focused. It can be estimated that similar time savings can be achieved across other departments, further enhancing overall efficiency and productivity.