Company Background
Tiffany & Co. operates jewelry and specialty retail stores and manufactures products through its subsidiary corporations. The Company operates TIFFANY & CO. retail stores and boutiques in the Americas, Asia-Pacific and Europe and engages in direct selling through Internet, catalog, and business gift operations.
Project Goals & Objective
- Financial planning system utilizing Hyperion Essbase and Lotus 1-2-3
- Ability to track inventory by multiple variables and report on SKUs by style, department, class, and subcategories
- Provide analysts with calculated data by area, expense or profit center, and product line
Ranzal Role
- Developed an inventory control application to track inventory by many different variables
- Developed Hyperion Essbase database housing 60,000+ SKUs reported by style, department, class and subcategories
- Flexible data views developed with Wired for OLAP, including quadrant analysis and complex graphing
Business Benefits
- Shortened annual budget process by delivering worksheets for batch loading budget data into Hyperion Essbase
- Improved analysis with flexible data views including quadrant analysis and complex graphing, and calculated data by area, expense or profit center, and product line
- Much fewer over and under stocks on chain-wide level due to tighter inventory controls
