FOOD PRODUCT MANUFACTURING

About The Customer :

Our Consultants has worked for the Biggest Chocolate manufacturing company of North America founded in 1894, its headquarters are in Hershey, Pennsylvania, US. Its Chocolates are sold in 60 countries worldwide. It is one of the oldest chocolate companies in the United States, and an American icon for its chocolate bar.

  • Planning Budgeting was done on Excel
  • Reporting was much difficult and time consuming
  • Data accuracy was always a question

Implemented IBM Cognos 10.1 for creating Planning Budgeting Model

  • Create Financial Report on Cognos EP as per current process
  • Faster completion of budget cycle
  • Data need to be accurately reported
  • Detail analysis of report
  • Created Plan and other Financial statement
  • Automated the budgeting process as per current process
  • Enable users to maintain several versions of data
  • Faster and accurate budgeting process
  • Define allocation Logic to build BOM
  • Timely delivery of reports to Stakeholders
  • It takes 1/3 amount of time to complete the monthly planning as compare to earlier process
  • Data is reported in more standardise format
  • Data accuracy increased with integration of data within different Library
  • Users can maintain different versions of data
Ready to start a project?

About The Customer :

Our Consultants has worked for a restaurant industry  based in Noida, Uttar Pradesh which holds the master franchise for a famous Pizza brand in India, Nepal, Sri Lanka and Bangladesh, and also for Dunkin’ Donuts in India. The company was incorporated on in 1995 and began operations in 1996.

  • Manual Budgeting process through spreadsheets
  • Time consuming activity to collect data from all departments
  • Manual intervention during budgeting process
  • Dependency on team members to consolidate data for budget and prepare reports manually
  • Manual approval process
  • Implementation on IBM Cognos Enterprise Planning version 10.1.
  • Training Finance users on Cognos Enterprise Planning.
  • Admin and End user training.
  • Automation of Budgeting process
  • Direct data entry into the Cognos System
  • Data Uploads using customised .csv files (Structured .csv files)
  • Extrapolation logic for generating budget
  • Faster and accurate reporting process
  • Iterative methods in budget process can follow top down /bottom up approaches as per business requirements
  • Mail alerts, exception reports are available
  • Integration with JO database and making data available through SFTP servers
  • Common platform for better data analysis
  • Implemented multiple business logics
  • All Manual process converted to single click automated process for budgeting
  • Created Structured .csv files to get data available from all team
  • Built multiple scenarios extrapolation logic for generating budget
  • Complete secured data without manual intervention
  • Built Manager screen which helped user to get data available and perform admin task in single click
  • Secured access to specific department users based on role defined by the Finance users