National Steel and Agro Industries Ltd Halves Time for Monthly Financial Reports, Cuts Inventory Costs by 5%
 
 

National Steel and Agro Industries Ltd Halves Time for Monthly Financial Reports, Cuts Inventory Costs by 5%

National Steel and Agro Industries Ltd (NSAIL) is an Indian manufacturer and exporter of flat steel products, such as cold rolled coil, galvanized corrugated sheets, color coil, and color profile sheets. The company is also involved in power generation and agriculture. NSAIL has 22 branches and warehouses throughout India and exports its products to the United States, Europe, United Arab Emirates, and Africa. The company is part of India’s Ruchi Group.

Between 2006 and 2010, NSAIL used a internally and heavily customized enterprise resource planning (ERP) application that made it difficult for the branch offices to create and share financial and steel manufacturing data. This hampered the company’s ability to produce monthly financial reports on time.

“We hoped to remove some of the customization to improve the system’s capabilities, but we quickly realized that the time and effort required to do this would be prohibitive,” said Pankaj Verma, vice president, IT, National Steel and Agro Industries Ltd.

“We needed to deploy a system that would enable our branches to share financial and sales data seamlessly and improve business processes to react more quickly to price fluctuations in the steel market.”

In June 2010, NSAIL engaged Oracle Partner Dakshah ebiz Consulting to deploy Oracle E-Business Suite Release 12 modules Oracle Financials, Oracle Manufacturing, Oracle Order Management, and Oracle Procurement. The company also used My Oracle Support to track service requests and gain access to Oracle experts for implementation issues. The company upgraded from Oracle E-Business Suite 11, which was deployed in 2006.

“Oracle E-Business Suite Release 12 enables us to create and distribute financial reports efficiently, respond better to steel market price fluctuations to protect revenue and profitability, and provide improved service to our customers,” said Verma.

 
Consolidated Financial Reports Completed Twice As Fast

A word from National Steel and Agro Industries Ltd

  • “Oracle E-Business Suite Release 12 enables us to create and distribute financial reports efficiently, respond more quickly to steel market price fluctuations to protect revenue and profitability, and to provide better service to customers.” – Pankaj Verma, Vice President, IT, National Steel and Agro Industries Ltd

Oracle Financials has streamlined NSAIL’s monthly financial reporting processes. The centralized system enables the company to quickly compile consolidated monthly financial reports, which provide details about the value of warehouse inventory, such as steel; the status of customer orders; and the revenue and profitability of each order.

“The system enables our accounts staff to create and distribute these monthly reports for the entire business during the first week of the month,” said Verma. “Previously, it took until the second week to complete these consolidated reports, and a large part of the task was manual.”

NSAIL sources steel and other metals from domestic suppliers and sellers in China, Africa, and Europe. According to Verma, faster access to financial data and more precise raw materials information enables the company to better react to price variations in the marketplace.

“We can identify what steel we need as raw material and where to get the best price and delivery,” said Verma. “We then use Oracle Procurement to place an order with suppliers overseas, and it is delivered within the stipulated time, depending on extraneous factors.

“Previously, if we wanted the lowest possible price for steel, we potentially had to wait up to three months to receive our order. Now, we have information that enables us to make better resourcing choices and protect our profitability.”

The Web-based system also provides XML reporting, which enables NSAIL’s accounting staff to instantly load financial data into Microsoft Excel spreadsheets. This allows users to view the information they need in their own unique reports.

 
Internal Audits Completed Faster

 
Inventory and Manufacturing Costs Cut, Waste Reduced

 
Support Tools Overcome Implementation Challenges

 
 

 
 

Challenges

  • Upgrade a highly customized ERP system with an integrated suite that automates financial reporting and streamlines steel manufacturing and procurement processes
  • React more quickly to price fluctuations in the steel market
  • Cut inventory costs and improve profitability
  • Streamline manufacturing processes to shorten the steel production cycle

Solutions

  • Engaged Oracle Partner Dakshah ebiz Consulting to deploy Oracle E-Business Suite Release 12 to streamline financial reporting, manufacturing, and inventory management processes
  • Created and distributed consolidated monthly financial reports for the entire business during the first week of the month, compared to taking until the second week of the month to complete the task
  • Reduced the time it took to complete internal account audits by 50%, as the system provides improved support for Indian taxation rules related to imports and exports, eliminating the need to keep abreast of these regulations for compliance purposes
  • Reduced travel requirements by removing the need for auditors to spend up to six days travelling to 20 branch offices across India to complete the audits
  • Improved visibility of inventory data and eliminated three to four days of manual work to get the right inventory information
  • Provided faster access to financial data and more exact information about the raw materials required to manufacture steel products, enabling the company to easily react to fluctuations in steel prices and protect revenue
  • Protected profitability by enabling staff to more easily identify type of steel required and where to purchase it at the best price
  • Improved customer service by allowing staff to easily view information about which products were selling best across each region to plan which products to ship to various locations
  • Cut inventory levels by 8% and inventory costs by 5% by determining near-exact stock requirements and reducing waste
  • Completed implementation within six months by using My Oracle Support to access Oracle support tools and experts
  • Created system service requests and resolved problems almost twice as fast using My Oracle Support

Why Oracle

NSAIL considered Oracle E-Business Suite Release 12 and competing solutions from SAP. According to Verma, the cost of software licenses and hardware required to support an SAP ERP system was prohibitive  for the company. Much of NSAIL’s IT staff also had extensive experience working with Oracle technologies.

Implementation Process

Oracle Partner Dakshah ebiz Consulting was engaged in mid-2010 to set up servers to support the system. The company helped NSAIL load data and ensure it flowed correctly between each module. NSAIL was able to complete implementation within six months by using My Oracle Support to access Oracle support tools and experts.

In March 2011, NSAIL also engaged Oracle Partner Filix Consulting to help improve workflow invoice reconciliation processes. Filix Consulting was able to help NSAIL quickly resolve several problems related to reconciliation, and, in certain cases, intricate setups that caused problems.

Partner