Problem

Our company was facing a challenge with maintaining positive relationships with our vendors due to delayed payments. We needed to ensure that all payments were approved within 7 days of work completion, but we lacked previous reporting on this specific process. This made it essential for us to conduct a thorough analysis and reporting to gain insights into our payment performance.

To address this issue, we utilized PowerBi to explore the data, identify patterns, and extract meaningful insights. Our aim was not only to present the findings but also guide the audience on how to enhance the overall payment process.

Approach

Handled invoices labeled as 'blanket'
Assisted in conducting the analysis using PowerBi
Handled all other payments
Assisted in conducting the analysis using PowerBi

Solution

We divided payment assignment between Project Specialists and Project Coordinators, which helped streamline the process. We also set a goal of ensuring that all payments, regardless of their type, were approved within 7 days of work completion. To achieve this goal, we conducted a thorough analysis using PowerBi.

In our presentation, we addressed any assumptions made during the analysis and highlighted any data issues encountered. We provided actionable recommendations for process improvement based on the insights gained from the analysis. By leveraging these insights and utilizing the right tools, we could drive improvements in our vendor payment processes and strengthen our relationships with our valued vendors.

Impact

Improved timeliness of vendor payments by 25%
Strengthened relationships with vendors resulting in increased trust and loyalty

Use Case Study for Crown Castle- Vendor Payment Details