Flobotics is a small company with an enormous scope of automation services - and even greater ambitions. However, a few months ago, the company’s processes were held back by Excel spreadsheets and tools that failed to meet its needs. That had to change, and it did (with some help from Primetric).
Delivery Leader
In this case study, you will learn:Â
Flobotics is an RPA development agency based in Warsaw, Poland. It specializes in consulting, analyzing, improving, and automating all types of processes across different industries, such as healthcare, fintech, insurance, manufacturing, telecom, and more.Â
Regardless of the field their customers work in, they can be confident that Flobotics’ work will help them speed up their processes, enhance efficiency, and unlock scalability - all while ensuring the legal compliance of the entire system.Â
Thanks to its extensive scope of work, Flobotics has already completed over 100 successful implementations, including projects for Paramount Residential Group, Docplanner, and T Bank. Importantly, each project resulted in an average ROI increase of over 350%, powering their customers to grow even more.
Due to the characteristics of its projects, Flobotics primarily focuses on Time and Material services, billing the customers for the actual amount of work done in a given operation. They account for over 80% of all the contracts in Flobotics.Â
However, some of the company’s projects have fixed prices, while others are sold as demos, with an option of becoming Time and Material operations when the implementation starts. As a result, Flobotics’ processes need to facilitate such financial models.
The flexible teams posed another set of challenges in Flobotics. With numerous part-time allocations and constantly changing projects, the company needed precise allocation of resources to deliver its projects on time.Â
Chris Szwed is a Delivery Leader in Flobotics. As such, he oversees all the operations, focusing on robotic process automation and everything that comes with it.Â
As a result, he focuses on not only project management but also:Â
To be successful in all of these operations, Chris needed to have an overview of all the critical aspects of the company’s operation in a single source of truth - and he intended to find it outside the exponentially growing number of Excel spreadsheets.Â
Being a small company, Flobotics started with spreadsheets like many other businesses. However, even with some external tools for time tracking, the system struggled to efficiently respond to all the cases that Chris needed to supervise to make the right decisions.Â
"We were missing out on many opportunities in project management, as we mainly used Excel for that purpose."
As a result, the company found many processes challenging or requiring significant improvements. These processes included:
As the company had flexible teams, it needed to have excellent visibility of the availability of its employees in both the short- and long-term. However, this was difficult to achieve in Excel spreadsheets or basic tools.Â
"We had very little idea of how our allocations would look like, for example, next month. Our tools did not provide us with such information."
The tools used in Flobotics then could only show simple assignments for a specified number of hours per day. They also couldn’t be used to reserve resources, see the workload from different points of view, or test out different scenarios the managers could use to make the best decisions possible. As a result, a long-term perspective for resource management was often unclear.Â
At the time, Flobotics was already providing its services to companies worldwide, including Europe and the USA. Still, delivering solutions to entities in so many markets was challenging due to the many currencies needed to complete such processes successfully.
This required the managers to create separate spreadsheets for each currency, later used for more advanced calculations. However, due to their nature, they required lots of manual updates that were not always completed promptly.Â
"The Excel spreadsheets were used once in a while. While they were pretty straightforward, there was no guarantee that they contained the latest information. That was their greatest flaw: we never knew whether or not we were looking at the correct data."
Notably, the existing systems could also not reflect different billing models used by Flobotics. This posed yet another challenge for the company, requiring even more tailored spreadsheets and updates and forcing the company to create a network of scripts and automations that could handle such scenarios.Â
While Flobotics was fully aware of the importance of time tracking, it struggled to convert the information into finances, as it required numerous separate spreadsheets. The problem was affecting both monitoring project progress and the invoicing itself.Â
At the time, the invoices were based on the information from the time tracking system and, later on, combined with work costs to give the managers a general idea of the actual spending. However, the system was far from perfect, as it was complicated and required many manual changes that were not always made on time.
As a result, preparing the necessary documents became a very burdensome process. The accountants needed to double-check every invoice, affecting the efficiency of the entire process.Â
After careful consideration and extensive market research, Flobotics has decided not to create yet another automation independently due to the costs and effort required by such an undertaking. Instead, it decided to look for a ready-to-implement solution that could cover all of its use cases - and that’s how it stumbled upon Primetric.Â
Soon enough, it turned out that Primetric was a perfect solution for an IT company such as Flobotics, providing it with benefits such as:Â
After the implementation of Primetric, finding the right and available people for the job was difficult, as the visibility and validity of such information were limited. Fortunately, that has changed.
"As far as the allocations are concerned, my work is much more comfortable now. Before, we had significant problems with data updates. Now, I am confident that everything I find in Primetric is the truth."
As a result, Chris and other managers can simply turn on Primetric and see which team - if any - can be assigned to a project. They can also reserve the time of specialists with specific skills, test out different plans, or inform the sales team that sufficient resources are not available. Regardless of the scenario, there are no more surprises in resource planning.Â
"Draft or reserved allocations also provide enormous value for me. Thanks to them, I can test out different scenarios and choose the best one depending on our successes in sales."
As Primetric offers a variety of financial features, Flobotics decided to use them to improve the quality of all of its processes focused on income and spending.Â
First and foremost, with Primetric a huge chunk of these operations was automated. The data is now imported straight from the integrated time tracking tool and combined with particular employees' wages and hourly rates. As a result, the managers have a complete overview of every penny spent in the company.
"We plan, create invoices, and forecast our finances with Primetric. Thanks to the tool, we are aware of all the financial scenarios we might face, and we know the exact work costs. It drastically improved the quality of our planning. "
Significantly, such an automated approach not only reduced the workload and amount of spreadsheets in the company but it also contributed to the accuracy of the information. Why? It is simple:Â
Additionally, the data can quickly be aggregated to show the managers different views of the same operations.Â
"In Primetric, the data is much more precise. Thanks to them, I can quickly analyze and convey them, raising people's awareness in the company."
As a result of these improvements, the accountants no longer need additional confirmations from all the managers to issue customer invoices. Having a single source of truth allows all parties to see such information immediately.Â
Having all the data in one place is undoubtedly an excellent benefit for any manager - but what if you could process the data even further with the same tool?Â
That is also the case for Flobotics. Using the pre-defined and custom reports, Chris can quickly gather the information from the entire system and sort it as he sees fit, creating extensive summaries of all the critical information.Â
"Having the ready-to-use tool for project financial management, my work is much more natural than in Excel. It is much easier to understand and use the data. [...] I can also quickly switch between different perspectives to assess the situation from different points of view."
Gathering all the information above in one tool also allowed Chris to oversee all the operations on a more general level. Using one of our reports, he can easily see the progress in each project and show its advancements to the rest of the executives - and he doesn’t need any additional documentation to do that.Â
"During our weekly meetings, I can simply look at the report showing the planned and worked hours and determine whether or not we are on the right track. "
While Flobotics might be a small RPA development company, now it has everything a business needs on its way to greatness: scalable processes that grow with the business while responding to all its needs.Â
As a result, we are certain that - with some help from Primetric - this company will soon cater to the needs of even more companies worldwide, generating more and more profits.Â
We prepared all of our case studies in PDF version to allow you to share them on meetings with your teammates.
Don’t limit your business with time-consuming spreadsheets. Be smart, work smarter.