Harmonizing global management reporting and financial planning with IBM and Aviana
Company Size
1,000+
Region
- America
Country
- United States
Product
- IBM Cognos TM1
- IBM Cognos Business Intelligence
- SAP ERP
Tech Stack
- IBM Cognos
- SAP ERP
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Productivity Improvements
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
- Apparel
Applicable Functions
- Business Operation
- Discrete Manufacturing
Use Cases
- Predictive Maintenance
- Supply Chain Visibility
Services
- Software Design & Engineering Services
- System Integration
About The Customer
Columbia Sportswear Company is a leading innovator in the global outdoor apparel, footwear, accessories and equipment industry. Founded in 1938 in Portland, Oregon, Columbia products are sold in approximately 100 countries and have earned an international reputation for innovation, quality and performance. Columbia products feature innovative technologies and designs that protect outdoor enthusiasts from the elements, increase comfort, and make outdoor activities more enjoyable. The firm is listed on NASDAQ under COLM, and achieved net sales in 2013 of approximately USD1.68 billion.
The Challenge
Columbia Sportswear was undergoing a large-scale ERP systems implementation and substantial business process transformation, which threatened the viability of its existing finance reporting and planning processes. The company was at risk of losing its ability to execute core financial processes without a significant level of time-consuming manual intervention combining data sets from the disparate ERP systems. The company needed a solution that would not only maintain the flow of information to key decision makers but also enhance it. In addition to streamlining information delivery, Columbia Sportswear wanted to find a solution that would provide deeper insight into the performance of various parts of its business, helping to enable better corporate decision-making.
The Solution
Columbia Sportswear selected IBM Cognos TM1 and Aviana, an IBM Business Partner, to help design and implement the solution to support management of financial planning, reporting and analysis as well as the related master data. The company also integrated the Cognos TM1 solution with its existing IBM Cognos Business Intelligence software. In the short term, the new IBM solution acted as a bridge between the legacy ERP environment and the new SAP ERP landscape. The TM1 platform was integrated with the general ledgers of both systems, enabling the harmonization of data to support global management reporting and financial planning. Enhancements were also made to Columbia’s financial planning processes to enable driver-based planning, rolling forecasts and headcount planning.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Fire Alarm System and Remote Monitoring Sytem
Fire alarm systems are essential in providing an early warning in the event of fire. They help to save lives and protect property whilst also fulfilling the needs of insurance companies and government departments.Fire alarm systems typically consist of several inter-linked components, such as smoke detectors, heat detector, carbon monoxide, manual call points, sounders, alarm and buzzer. The fire alarm system should give immediate information in order to prevent the fire spread and protect live and property.To get maximum protection a shoe manufacturer in Indonesia opted for a new fire alarm system to monitor 13 production sites spread over 160 hectars. Although the company had an existing fire alarm system, it could not be monitored remotely.It was essential that the new system would be able to be monitored from a central control room. It needed to be able to connect to the existing smoke detector and manual call point. Information should be easily collected and passed on to the Supervisory Control and Data Acquisition (SCADA) system. Furthermore, the system should have several features such as alarm management, auto reporting, being connected to many client computers without additional cost, and run 24/7 without fails. The company also needed a system which could be implemented without changing the architecture of the existing fire alarm system.
Case Study
IoT Applications and Upgrades in Textile Plant
At any given time, the textile company’s manufacturing facility has up to 2,000 textile carts in use. These carts are pushed from room to room, carrying materials or semi-finished products. Previously, a paper with a hand-written description was attached to each cart. This traditional method of processing made product tracking extremely difficult. Additionally, making sure that every cart of materials or semi-finished products went to its correct processing work station was also a problem. Therefore, the company desired an intelligent solution for tracking assets at their factories. They also wanted a solution that would help them collect process data so they could improve their manufacturing efficiency.
Case Study
Retailer Uses RFID Scanner to Improve Efficiency
Patrizia Pepe wished to improve the logistics of their warehouse: accepting incoming goods from their production sites, movement of items throughout
the warehouse, and packaging of goods for distribution to the retail locations. They initially tried to use barcodes for this function. Because barcodes must be individually scanned within a line-of-sight, the acceptance of goods coming into the warehouse was too time consuming. Working with the University of Florence, Patrizia Pepe instituted a five-month pilot project beginning in August of 2009 to test the validity of an RFID solution. The pilot involved tagging of about 60,000 items for the second seasonal collection, and convinced the company to move forward with tagging all items.
Case Study
Monitoring and Controlling Automatic Mixing and Dispensing Machines
As technology advances, textile manufacturing has been transformed from a labor-intensive to a partially or fully automated industry. Automation is significant in all segments of textile production - from spinning to printing, and textile machinery manufacturers are constantly searching for new technologies and automation processes will increase the productivity of their machines. The color paste mixing and dispensing machine is an essential part of the printing and dyeing process. With the advantage of automatically computerized controls and database management, the system can significantly improve its dispensing precision, working efficiency and production quality as well as reducing material consumption.
