Background and objectives
IT department of a branch of a major luxury goods group
Objective to deploy a tool for budget construction (open to IT project managers in charge of budgets) and monthly reporting to the various departments of the IT Department and its customers.
Complexity of the organization to be integrated: large volume of data and need for detail to be returned to ISD customers (70 customers, 1,500 Run lines and CAPEX / OPEX projects)
Our mission
Project milestones :
- Identification of the application’s functional requirements (organization of workshops with a few key operational and financial users + the development team)
- Iterative development and acceptance in evolution batches
- Writing of functional and user administration guides and training courses
- Support post Go Live
Main functionalities developed in the Budget phase :
- CAPEX / OPEX budgets entered by operational staff in man-days, value (CAPEX entered with a multi-year view)
- Depreciation calculated by the application on the basis of data entered for each project (Go Live date, depreciation period).
- Restitution of budgetary data (budget, revised, landing) according to analysis axes: IT organization (department, function), beneficiary customers, technology of tools developed, nature of expenditure (licenses, maintenance, Cloud consumption, cross-functional activities, etc.).
- Construction of Source Of Change reports (Impact scope, daily rate, man-days, ….)
- Main functions developed for the Real phase (monthly closing and reporting)
- Loading of actual data (man-days, CAPEX, OPEX, depreciation) via SAP (CAPEX, OPEX, depreciation) and Timesheet (man-days)
- Reporting of actual data and comparison vs. forecast using the same analysis axes as the budget
Results
Solution deployed in 6 months
Use of the solution by project teams and management controllers
Decommissioning of multiple reports and Excel files
Process standardization and easier review/validation reduce lead times
