4-page Case Study
Posted: 2/28/2012
1424
Rate This Evidence:

Robert Bosch India Ltd Manufacturing Giant Improves Collaboration and Communication, Enhances Business Intelligence Reporting

Bosch Limited has more than 18,000 automotive components, which it distributes across the country via 200 dealers. It uses SAP ERP at the head office in Bangalore. To drive further efficiencies in its distribution network, the management took the initiative to centralize and standardize the dealer management system. The company implemented Microsoft® Dynamics™ NAV 2009 with the help of Robert Bosch Engineering and Business Solutions (RBEI). This connects all dealers to the head-office. Real time data interchange between SAP and Dynamics NAV improves the organization’s efficiency significantly. It reduces time lag and makes order processing faster. A SharePoint based web portal offers information, up-to-date reports to further improve productivity and system effectiveness.

*
* Microsoft Dynamics NAV was found highly suitable to improve the efficiencies of the dealer network leading to better customer satisfaction and shorter lead times for making informed business decisions. *

Srinivasa S
General Manager - Marketing, Bosch Limited

*
Situation

Bosch is a leading supplier of technology and services in the areas of automotive and industrial technology, consumer goods and building technology. Bosch set up its manufacturing operations in 1953, which has grown over the years to include 13 manufacturing sites and 7 development and application centers. Its largest development center, outside Germany, for end-to-end engineering and technology solutions is also in India.

The Bosch Group operates in India through six companies, viz, Bosch Limited, Bosch Chassis Systems India Limited, Bosch Rexroth India Limited, Robert Bosch Engineering and Business Solutions Limited, Bosch Automotive Electronics India Private Limited, and Bosch Electrical Drives India Private Limited. It employs over 25,000 associates. The Group generated consolidated revenue of over U.S.$ 2,146 million (INR 11,300 crore) in 2011. In India, Bosch Limited is the flagship company of the Bosch Group. It earned revenue of over U.S.$ 1,519 million (INR 8000 crores) in 2011.

Bosch was using a homegrown solution, InDIS (Integrated Dealer Information System), to manage its distribution and dealer network developed approximately 12 years ago. It was built on Microsoft Visual Basic 6.0, COM+ technology, and Microsoft SQL Server 2000. Crystal Reports 10 was used for report generation from a wide range of data sources. InDIS was deployed at 120 dealer locations.

But, this decentralized solution had its own set of challenges and issues. Application installation, database backup and restore at each dealer location were manual processes using external physical media such as DVDs. Lack of a centralized, integrated IT infrastructure at dealers’ locations, and irregular process for backing up the data resulted in loss of data.

Besides, InDIS lacked latest functional requirements and modern features. With support to VB 6.0 ending in 2008 further upgrades were not possible. Moreover, it was operating system dependent and worked only on Windows 2000 Server only. And, reports were difficult to create or modify. It was also not user friendly and required intensive training for users.

Most importantly, it did not integrate with the company’s parent ERP system, SAP. The data interchange was a manual process where users had to upload specific files with order details to SAP using an interface developed on a web portal. Also, the goods receipt note was uploaded manually using the text file received through an email.

*
* Automated master data transfer saves approximately 160 person hours of efforts per month. *

Uday Kumar
PoDeputy General Manager - IT, Bosch Limited

*
Creating any new data in the master file was also difficult. Therefore, adding any new products, item codes, prices, schemes, discounts, targets, and awards took time and substantial effort to add.

At the same time, consolidated dealer information wasn’t available at head office resulting in manual work. “It took considerable time to consolidate information at the head office,” says Uday Kumar, Deputy General Manager - IT, Bosch Limited.

All these issues triggered the search of a new solution to meet the critical business requirements.

Solution

To upgrade to latest technology and implement new functional requirements, IT team at Bosch decided to replace home-grown InDIS with a standard ERP solution. It considered Microsoft Dynamics solutions because of rich functionalities and relatively quicker implementation cycle. Srinivasulu, Expert Architect, Microsoft Dynamics at Robert Bosch Engineering and Business Solutions (RBEI) says, “We wanted a solution that could integrate with Bosch SAP with ease, making manual transfer of data redundant.”

Finally, Microsoft Dynamics NAV 2009 was chosen because it was quick to deploy, integrated easily with SAP, and was scalable to meet Bosch’s growing business.

Robert Bosch Engineering and Business Solutions (RBEI), Bosch’s implementation partner and one of the group companies deployed Dynamics NAV.

With project timeline of six months, Microsoft Dynamics NAV implementation journey started in September 2010 with the help of a trained distributed team and a central coordination and support office. The solution went live in February 2011. The solution was centrally hosted and was deployed for 240 users across 150 dealers. The modules deployed include Sales, Purchase, Inventory, and Finance.

*
* After the rollout of NAV to the Bosch dealer network, we are convinced that the application is efficient to deliver the desired features and will help the business a great deal. We have therefore extended this application to other segments also. *

Srinivasa S
General Manager - Marketing, Bosch Limited

*
RBEI tailored the solution to reflect the business goals. It customized Microsoft Dynamics NAV to include an integration layer. Using XML Port Designer based web services it interfaces NAV with SAP via Bosch B2B integration platform.

Dynamics NAV web services were integrated with SAP to facilitate master data transfer. RBEI used Dynamics NAV web services with proxy web services deployed on Internet Information Services (IIS) by leveraging Basic Authentication concept to communicate with Bosch’s B2B platform.

In addition, some custom processes were also created in Dynamics NAV:
Customer Cash Discount and Penalty: Displays payment terms with multiple discount slabs and penalties. With this module, the actual business practice of manual calculations for payments and disbursements could be handled within Dynamics NAV system

Scheme Management: Configures free items awarded on purchase of regular items. The scheme is setup in SAP and flows into Dynamics NAV becoming available to dealers without any delay

Target Management: Helps dealers maintain and track sales targets along with incentive management

Microsoft SharePoint Server is deployed, making Microsoft Dynamics NAV available via Internet to reach maximum users. The portal offers email, message boards, and consolidated information. Bosch has plans to further refine the portal, enhance features and functions so that it becomes the central location used by its dealers and employees. This would improve efficiency and save time.

RBEI also designed a production system, quality control and disaster recovery (DR) site.

Lastly, Business Intelligence (BI) reporting is incorporated with Dynamics NAV. SQL 2008 Online Analytical Processing (OLAP) Cubes are designed to allow quick analysis and consolidate data from different Bosch companies in the country. With multiple client capacity, it is possible to build multiple business structures where each dealer is treated as a separate entity or company. SQL Server Reporting Services (SSRS) reports developed on these cubes are published via SharePoint Server. Real time consolidated reports are available to the management giving them complete visibility of the entire supply chain.


Benefits

With a comprehensive and integrated solution in place, the company has gained holistic insight of its business. “Real time data exchange between Microsoft Dynamics NAV and parent ERP system, SAP, improves business insight and strengthens business performance,” says Raghuram Joshi, Delivery and Practice Head - Microsoft Solutions, RBEI. “Concurrently, Dynamics NAV Business Intelligence expands the functional borders to meet overall demands within the organization. Horizon (this solution) is extremely flexible and can be applied to any distribution situation. We are already getting many more implementation requests within Bosch. Many external organizations have also shown interest and we are really keen to work with them.”

*
* Accelerated report creation abilities with data from multiple locations directly into a single report also simplify collaboration and management. The advanced reports create a holistic view of business, helping the top management to gain enterprise-wide insight. *

Girish Shankar
Senior Architect, Bosch Limited

*
Automates Manual Processes
Real time integration of Microsoft Dynamics NAV with SAP, automates data interchange between the two thus eliminating all manual activities and reducing time lag. “Automated master data transfer saves approximately 160 person hours of efforts per month,” explains Uday Kumar, Deputy General Manager - IT, Bosch Limited. “It eliminates manual work, reduces data errors, and reduces time for data updates.”

The company has also reduced time-consuming data entry by using data from SAP wherever possible. The order processing and goods inward process time has been reduced significantly. Uday continues, “Manual data entry of goods receipt note (GRN) is completely eliminated. This saves data entry time for 1000 + GRNs in a month per dealer.”

At the same time, he added that the basic product had to be customized by the implementation partner to include the batch management process of product sales used by the retail business.

Empowered with Business Intelligence Reporting
Microsoft Dynamics NAV BI allows users to create enhanced reports with new visualization and analysis tools. This improves management and thus performance. Girish Shankar, Senior Architect, Microsoft Business Intelligence, Bosch Limited expresses, “Accelerated report creation abilities with data from multiple locations directly into a single report also simplify collaboration and management. The advanced reports create a holistic view of business, helping the management to gain enterprise-wide insight.” Powerful, feature-rich and easy-to-use online analytical processing (OLAP) and data-mining capabilities remove burden from IT team to collate data from various locations and generate reports in desired formats.

Centralized System Improves Visibility
Bosch sells over 18,000 products. With a centrally hosted system, everyone has real time visibility and access to critical information throughout the enterprise. The management is equipped with the real time consolidated performance status of all the dealers all the time. Online information is available to dealers about pricing and discounts.

Jagabandhu Mukhopadhyay, Finance Functional expert at RBEI says, “Centralized deployment of tax and statutory updates for all dealers reduces the effort of manually sending the patches to 200 dealers. It in turn saves 400 person-hours per patch release.” Moreover, single database hosted centrally reduces the efforts and cost of maintenance.


Self-Servicing Improves Efficiency, Saves Time
Since data from SAP is instantly reflected in Dynamics NAV at all the dealer locations, time is saved over calls and emails for clarifications. Response time for any request is 30 seconds and reference number is generated immediately for future communication. “Due to simplified billing process, the invoice creation time has reduced from 3 minutes to less than a minute per invoice,” states Kanchi Ambalal, Senior Manager - IT, Bosch Limited. “And sales order reference to a dealer is generated under one minute after raising purchase order.”

Bosch’s portal is an excellent communication tool between Bosch and its dealers. Access to company’s portal over internet eliminates system dependency. Users can login and share the information or post messages.

Central, online service desk saves efforts of mailing or personal follow-ups for support topics for business and technical issues. At the same time, security of each dealer’s data is ensured.

The Bosch Automotive Aftermarket business in India generates U.S.$ 500 million from over 200 dealers selling 18,000 parts. Managing this is a challenge. “With Dynamics NAV and the seamlessly integration with SAP, we successfully handle 50,000 requests every month, and each is handled in under 30 seconds." says Prakash Shenoy, Practice Head, Business Solutions, RBEI. "That has been the real success story on the solution and technology front."

The employees benefit from improved planning and availability of reports required for business forecasting, seamless data interchange between dealers and Bosch. This cuts the lead-time for decision making which in turn helps achieve growth in aftermarket business.

“Microsoft Dynamics NAV has helped Bosch to improve dealer network efficiencies which lead to better customer satisfaction, that, allows the company to achieve the growth targets set by the Bosch management,” concludes Srinivasa S, General Manager - Marketing, Bosch Limited. “After the rollout of NAV to the Bosch dealer network, we are convinced that the application is efficient and delivers the desired features and results. We have therefore extended this application to other segments also”.

Microsoft Dynamics

Microsoft Dynamics is a line of integrated, adaptable business management solutions that enable you and your people to make business decisions with greater confidence. Microsoft Dynamics works like familiar Microsoft software such as Microsoft Office, which means less of a learning curve for your people, so they can get up and running quickly and focus on what’s most important. And because it is from Microsoft, it easily works with the systems that your company already has implemented. By automating and streamlining financial, customer relationship, and supply chain processes, Microsoft Dynamics brings together people, processes, and technologies, increasing the productivity and effectiveness of your business, and helping you drive business success. 

For more information about Microsoft Dynamics, go to:

www.microsoft.com/dynamics

About Robert Bosch Engineering and Business Solutions

Robert Bosch Engineering and Business Solutions Limited (RBEI) is one of the world’s leading global suppliers of technology and services, offering end to end engineering, IT and Business solutions. It is a 100 percent owned subsidiary of Robert Bosch GmbH. With global footprint, RBEI has presence in United States, Europe and the Asia Pacific region. In India, it owns two state-of-the-art facilities in Bangalore, and a development center in Coimbatore. It is ISO 9001:2008 certified (2009), appraised at CMMI-L5 (2006) and also ISO 27001 certified (2009). It provides solutions for automotive industry, industrial technology and consumer goods and building technology.

For More Information

For more information about Microsoft products and services, call the Microsoft Sales Information Center at (800) 426-9400. In Canada, call the Microsoft Canada Information Centre at (877) 568-2495. Customers who are deaf or hard-of-hearing can reach Microsoft text telephone (TTY/TDD) services at (800) 892-5234 in the United States or (905) 568-9641 in Canada. Outside the 50 United States and Canada, please contact your local Microsoft subsidiary. To access infonew linkrmation using the World Wide Web, go to: www.microsoft.com

For more information about Robert Bosch India Ltd, call (91) (80) (2299 2000) or visit the Web site at:www.boschindia.com

For more information about Robert Bosch Engineering and Business Solutions products and services, call (91) (80) (6657 5757) or mail usms.solutions@in.bosch.com or visit the Web site at:www.boschindia.com/rbei



This case study is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.
Solution Overview



Organization Size: 22500 employees

Organization Profile
Bosch is a global supplier of technology and services in the areas of automotive and industrial technology, consumer goods, and building technology.

Business Situation
Bosch was using in-house developed ERP solution, along with SAP, the parent ERP solution, to fulfill various business needs. The disintegrated solutions could not support its dealers across the country and this affected the business.

Solution
Robert Bosch Engineering and Business Solutions (RBEI) deployed Microsoft Dynamics NAV 2009 at Bosch India and integrated it with SAP. The unified technology infrastructure, called Horizon further integrates with SharePoint Server for business intelligence reports.

Benefits
  • Automates manual processes
  • Empowerd with business intelligence reporting
  • Centralized system improves visibility
  • Self-servicing improves efficiency saves time

Hardware
  • Dell R610 Servers hosting SharePoint, Windows RDS and NAV Services
  • Dell R710 Server hosting SQL Cluster

Software and Services
Microsoft Dynamics

Vertical Industries
Manufacturing & Resources

Country/Region
India

Languages
English

RSS