Begin typing your search above and press return to search.

Financial Planning & Analysis Solution

Posted by

Financial Planning & Analysis Solution

A Mining, Manufacturing, Industrial Machinery & Equipment Company

Revenue: USD 80 Million
PROBLEM
  • Manual and time-consuming process of Budgeting and Forecast preparation for multiple group entities
  • Difficulty in unifying actual data for financial closing and reporting
  • Broken linkages between Financial Reports due to data mismatch causing issues with Planning, Management reporting as well as statutory reporting
SOLUTION
  • Clear process of accumulating business segment wise and entity wise data in unified format
  • Data integration scripts to map all necessary data to appropriate reporting line items
  • Connecting Profit and Loss, Balance Sheet and Cash flow models for all versions across planning cycles.
  • Creating simulations for cost allocations
RESULTS
  • Higher data integrity and more trustworthy plan and reports
  • Efficient planning by teams
  • Reduced dependency on IT for data preparation for budgeting, planning, forecasting process
Read more
Posted by

Sales and Solicitation Cost Planning Solution

A Global Insurance Company

Revenue: USD 10 Million
PROBLEM
  • Highly manual and time-consuming Budgeting, Forecasting and Reporting process
  • Disconnected information between Sales, Operations and HR
  • Inaccurate reporting on Actuals
  • Assumptions driven and Driver based planning was difficult to model in Excel for complex products, partners and channels mix.
SOLUTION
  • Solution unifies Sales, Operational Costs and HR cost models
  • Enables planners to quickly input sales assumptions by product mix, channel and partner combination
  • Enables maintaining long range and short-term forecasts by quarter and by month, that is also updated monthly with Actual data
  • Accurate computation of cost allocation per deal considering different cost types and accrual accounting principles.
RESULTS
  • Simplified and unified planning, forecasting and reporting process
  • Fewer occurrence of manual error while assembling data from multiple Excel sheets from multiple sources.
  • Improved cost modelling and gross margin analysis
Read more
Posted by

Financial Consolidation Solution

A Manufacturing, Food & Beverage Company

Revenue: USD 160 Million
PROBLEM
  • Multiple entities within the holding group with different accounting systems, making the consolidation process and data collection very long
  • Different data storage system with various number treatment across the systems
  • Different accounting code across the entities, causing the matching process to be difficult and higher chance in error
  • Multiple currency data across different entities depending on their country operation
SOLUTION
  • Streamlining the Accounting Code that applied to all the entities without changing the original accounting code
  • Mapping the accounting code from each entity to the Group Accounting Code
  • Create different data load to cater for different data treatment and stored in cloud with the same accounting system
  • Using Exchange rate at the consolidation level to display consolidated data in the same holding level currency
RESULTS
  • Mapped Group accounting code with multiple entities accounting code which is easy to maintain
  • Data load become 1 click button from each entity regardless of their data source
  • Consolidation done at higher level with better accuracy and faster turnover rate>/li>
  • Separate book from each entity can be reviewed before and after the consolidation / adjustment
  • At the entity level, data can be seen in both local & group currency based on the exchange rate provided
Read more
Posted by

Asset Management & Depreciation Planning Solution

A Shipping/Logistic Company

Revenue: USD 100 Million
PROBLEM
  • Difficulty in creating consolidated forecast and plan for diverse product types and shipping regions
  • Pool management of various product types, including planning for repairs, losses, scrap, and new additions was manual and cumbersome.
  • Net asset value calculations, wastage calculation and gains and losses owing to exchange rates were difficult to perform and maintain manually
SOLUTION
  • Solution integrated the planning system with the Asset register for up-to-date asset information for all categories across shipping regions
  • Planners could update the pool assumptions based on historical data as well as judgement to create asset pool forecasts
  • Depreciation calculations using Written Down Value was performed and accumulated Net asset value was booked automatically based on inputs.
RESULTS
  • Better visibility to asset management and costs
  • Multi-region consolidated view of assets including movement of assets could be planned easily
Read more
Posted by

Financial Planning & Analysis Solution

A Leading Consumer Goods Supply Chain Services Company

Revenue: USD 11.5 Billion
PROBLEM
  • Multi-entity and multi-country data management
  • Limitation in creating multiple Scenario modelling to support decision making during complex situations
  • Inadequate collaboration between different groups of people to quickly and easily share information and make decisions.
  • Inadequate reporting platform that allows to track Business Performance against Plan.
SOLUTION
  • Easy to configure data connectors which allowed the customer pull & push data from external systems.
  • Multiple Scenario modelling to understand profitability in various user defined cases (Best & Worst Case etc).
  • Configurable cost allocation logics to spread cost assumptions based on appropriate drivers
  • Improved role-based data access & workflows that support user collaboration across regions and functions without compromising on data security.
  • Dynamic reporting to stay aligned with performance of the business versus the plan.
RESULTS
  • Improved decision-making using advanced scenario tools and business rules
  • Lower dependency on IT for data aggregation and preparation
  • Improved global collaboration between teams
Read more
Posted by

Financial Planning, Budgeting, Forecasting solution

A Leading Global Consumer Goods Company

Revenue: USD 1.2 Billion
PROBLEM
  • Need to restructure the entire planning system
  • The implementation of 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.
  • Because of the large number of SKUs in the organization, it is challenged with producing SKU-level margin analysis and forecasts.
  • The ultimate goal is the integration between Finance, Demand Review, Supply Review, and eventually S&OP
SOLUTION
  • Sales Forecasting – – Top-Down and Bottom-up planning by SBU, Brands, Region, and Channel.
  • Budgeting – Annual and Quarterly planning process including Volumes, Pricing, Discounts, Marketing Spends, Material Costing, and margin calculations, and respective scenarios
  • Reporting – Key KPI reporting based on Role and Business Hierarchy, Variance Analysis, and P&L, BS, and CF in standard formats
  • Data Integration – – Loading of business masters and transactional files in the Jedox EPM system from sources as required to support all functional scope.
RESULTS
  • Improved collaboration between the global and local verticals
  • Simplified and unified planning, forecasting, and reporting
  • Reduction of manual error while assembling data from multiple Excel sheets from multiple sources.
  • Improved cost modeling and gross margin analysis
  • Improved decision-making using advanced scenario tools and business rules
Read more
Posted by

Financial Planning, Budgeting, Forecasting solution

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
Read more

    LOCATION

    Singapore | Canada | India | Netherlands.

    EMAIL

    info[@]Keansa.Com
    srabani.bandyopadhyay[@]Keansa.Com

    ADDRESS

    Keansa Solutions Pte Ltd.

    9 Temasek Boulevard, #07-01 Suntec Tower 2,

    Singapore 038989

    CONNECT

    COPYRIGHT 2021. POWERED BY KEANSA