FINANCIAL TEMPLATE
BUSINESS QUESTION
A large industrial company, with ambitious Recurring Cost reduction plans is willing to strengthen its controlling through advanced solutions. The objectives were to propose a bottom up projection of recurring costs accounting for job cards and RC reduction projects pipeline, and to allow deep diving in available data to identify gains delivery delays
DATA
- Detailed job cards, actuals and procurement databases representing millions of items with detailed labor time breakdown by cost center and material costs
- Information sourced directly from SaP source system
- Full processing in Python (open source)
APPROACH
- Interviews and deep dives to understand the existing methodology, combining an access database and multiple excel files with heavy manual checks processing
- Identification of improvement levers and additional functionalities (comparison of job cards to actuals, deep dive)
- Developments of a software in Python with a dedicated interface. Results files accessible either in excel or through a Power BI dashboard, allowing more interactivity
- Solution delivered to the client controlling team
RESULTS
- Financial template execution time reduced from several weeks to a few hours, including advanced deep dive functionalities for controlling teams
- Start with an agile executable installed on a laptop to iterate with key user’s in an agile mode. Plan migration to a fully integrated architecture once functionalities and data flows are stabilized