Tukaş Gıda Sanayi ve Ticaret Monitors Value Creation Chain with Business Intelligence Platform, Shortens Sales Reporting by 20 Calendar Days Each Month
 
 

Tukaş Gıda Sanayi ve Ticaret Monitors Value Creation Chain with Business Intelligence Platform, Shortens Sales Reporting by 20 Calendar Days Each Month

Tukaş Gıda Sanayi ve Ticaret A.Ş., founded in 1962, produces and distributes vegetable and fruit products in Turkey and internationally. The company produces a wide range of dry, canned, and frozen foods for retail and catering markets. Its selections include tomato products, vegetables, fruits, sauces, jams, salads, pickles, appetizers, and ready-to-eat meals. Tukaş works with regional farmers to source ingredients for its food products. In 2011, the company procured more than 180,000 tons of raw materials from 2,500 farmers in the Turkish Aegean and Marmara regions, thus making an important contribution to the agricultural economy in Turkey. The company exports approximately 30% of its production.

 
 

 
 

Challenges

A word from Tukaş Gıda Sanayi ve Ticaret A.Ş.

  • “Thanks to Oracle Business Intelligence Foundation Suite, we substantially reduced our efforts to collect and prepare business information, such as sales analytics, and we can make informed and timely decisions based on current data. We’ve laid the groundwork for our exciting journey to bring Tukaş Food to the technological forefront, where we will soon be able to model any business scenario.” – Öznur Topuz, Business Intelligence Manager, Tukaş Gıda Sanayi ve Ticaret A.Ş.

  • Analyze value creation chain to drive sales and profitability, for example instant access to daily updated sales and stock levels per region and distributor from multiple data sources
  • Monitor stock levels for distributors  with more accurate sales data—a key issue because each food product has a specific expiration date, after which it has to be collected and destroyed at the company’s expense
  • Respond faster to sales managers’ and sales representatives’ demands by delivering accurate and timely analysis of sales data per distributor and sales target realization per employee

Solutions

  • Increased data availability and security by storing sales, products, and distributor information in a corporate data warehouse with Oracle Database while establishing the basis for analyzing data with Oracle business intelligence (BI) solutions
  • Enabled approximately 70 Oracle BI users to analyze distributors’ stock levels, sales trends, and sales target realization of food products per day, month, and year—involving hundreds of distributors and national accounts—with a reporting system that expands insight and visibility to support more informed decisions
  • Provided sales team members with daily information about sales regions and customers—instead of waiting several days for data collected by analysts from different departments, such as finance and sales—enabling them to better identify profitable distributors and products
  • Enabled analysts to spend more time analyzing key business performance indicators, such as rate of sales and stock levels per distributor, as opposed to collecting and assembling information manually from multiple systems, including customers’ systems
  • Improved ability to monitor consumer demand with much higher precision to minimize the need to collect and destroy unsold expired food products
  • Made monthly sales reports available to managers immediately after month close—eliminating all manual tasks involved in preparing reports and shortening the previous process by 20 calendar days to boost sales performance
  • Used Oracle Data Integrator and Application Adapter for Data Integration to collect information about distributors from Microsoft Dynamics AX and other third-party sales and distribution management systems, enabling fast creation of BI reports and dashboards
  • Enabled managers to access BI reports and dashboards anytime and anywhere on their smartphones and tablets with Oracle Business Intelligence Mobile
  • Delivered insight about distributors, national account chains, and products’ past performance by enabling the company to analyze historical sales data collected by its customers—such as sales per sales point and stock level per sales point

Why Oracle

“We rely on Oracle Database and Oracle Business Intelligence because they provide an outstanding price-performance ratio and enable us to drive operational excellence,” said Hülya Gürsözer, corporate strategy and brand management coordinator, Tukaş Gıda Sanayi ve Ticaret A.Ş.

Implementation Process

“We designed a multiphase project together with Oracle partner G Teknoloji. We established a data warehouse based on Oracle Database and collected data from different in-house and external applications to have a robust repository. Then, we created BI reports and dashboards that substantially optimized our decision-making,” Gürsözer said. “But, we will not stop there. Phases three and four include expanding BI to other areas, such as human resources, suppliers, production, and financials, as well as modeling business scenarios with Oracle Essbase. In phase five, we plan to develop a corporate score card system with Oracle solutions.”

Partner

“Oracle partner G Teknoloji provided tremendous expertise in Oracle BI technology that was instrumental in helping us to successfully complete the first three phases of our BI environment that is highly innovative in the Turkish food industry,” Gürsözer said.