A Global Dermo Cosmetic Company
Revenue: USD 300 Million
PROBLEM
- Client wanted to implement a financial planning and budgeting solution that can help the financial team’s ineffective planning and analysis
- This system is to increase financial efficiency, improve planning accuracy, and speed-up decision-making on any arising issues based on different simulated quantifiable data.
- This implementation is a bottom-up, top-down enterprise planning and performance management system.
- The system should be capable to deliver optimal service quality to the customers at the lowest possible supply chain costs.
SOLUTION
- Sales Forecasting – Sell out and Sell in Value to calculate the SKU level by month, brand, range, and country using Quantity and Volume as drivers.
- Budgeting – Annual and Quarterly planning process including Volumes, Pricing, Discounts, Marketing Spends, Material Costing, margin calculations, and respective scenarios
- Reporting – Automate Monthly, Quarterly, Year to Date, and Annual Reports in user-friendly formats. Dashboard, Charts for real-time analysis, and Variance Analysis.
- Data Integration – Source data from the files shall be imported to Jedox to support all functional scope.
RESULTS
- Improved decision-making using advanced scenario tools and business rules
- Lower dependency on IT for data aggregation and preparation
- Simplified and unified planning, forecasting and reporting process
- Fewer occurrences of manual error while assembling data from multiple Excel sheets from multiple sources.
- Improved cost modelling and gross margin analysis
Leave a Reply