Regional Reporting

Regional Reporting

Client

Swiss Confectionery and Coffee Company

Application

Regional Stock Control and Sales Reporting with Production Planning tool.

Key Benefits
  • Single view of regional sales and stock operations.
  • Planning and Forecasting Tool for different countries and channels.
  • Ease and speed of reporting at the end of the month.
Download Casestudy

Company

Our client is a Swiss confectionery and coffee company well known for its various brands of coffee. The client team is responsible for the sale of coffee capsules and coffee machines.

Application

This is a reporting tool use by the Middle East regional office to consolidate sales and stock in the countries controlled by the region.
The web based application is used by client to capture monthly sales of coffee capsules and coffee making machines across different countries. The application is used for consumer as well as corporate sales and is integrated with multiple data sources from company’s enterprise system.

Agents across different countries plan inventory, confirm stock delivery and update sales figures in the system. The regional team reviews and updates plans for agents, and periodically update the Sell In figures from multiple sources, and create monthly reports for sharing with their head office.

The applications’ key features:

  • Integrates multiple data input from company’s enterprise system
  • Single point of sales reporting
  • Sophisticated hierarchical and drill down reports
  • Comprehensive tool for sales planning and forecasting

Technology

The application is deployed on IIS 7.0 web server with SQL Server 2005. Application is developed on ASP.NET with SQL 2008 database and third-party components from Telerik and Gembox.

Technology Stack

  • SQL2012
  • Gembox
  • net-project
  • Entity Framework
  • Excel
  • JQuery
  • CSS3
  • HTML5