Automated Budgeting and Forecasting Enables Higher Performance

Overview

This company focuses on manufacturing and distributing dental implant products, including prosthetics, surgical tools, and biomaterials, as well as offering educational and training services to dental professionals worldwide. 

Challenges

Overall, the company had difficulty obtaining a clear picture of its financial performance. 

The company heavily depended on Microsoft Excel spreadsheets for its processes, some of which contained over 150 tabs. This approach proved challenging to maintain and consolidate the spreadsheets, and to keep track of any updates or different versions. Moreover, comparisons could not be completed without manually compiling reports, which was time-consuming and error prone. 

dF Solution Statement/Results

deFacto Power Planning was used to develop finance, FX, and sales models of the customers’ business which are synchronized & fed data directly from the ERP (Enterprise Resource Planning) system. In addition, input schedules (sales, expense, HR, and capital expenditure) were implemented, allowing for the newly accessible data to be entered timely and accurately. As major overhauls took place, attention was paid to retaining aspects of the company’s older system that worked well; a flexible Excel-based UI was chief amongst them. 

The implementation of a more efficient system via deFacto Power Planning also had a profound impact on the company’s budgeting and forecasting processes. By automating these processes, the company was able to reduce cycle time by over 85%.