From Excel silos to integrated planning for 4,000+ stores

Spanish jewelry brand transforms from fragmented Excel silos to integrated planning excellence—enabling collaborative decision-making across 4,000+ global stores.

This iconic Spanish jewelry brand has built an impressive legacy over more than 100 years. Recognized as a top 3 premium jewelry brand globally with €80M+ in revenue, over 4 million social media followers, and 4,000+ stores worldwide, they've mastered the art of connecting with customers.

But their internal planning processes hadn't kept pace with their external success.

The challenge: Silos hindering global scale

Despite their market leadership, the company's traditional financial planning had become a bottleneck that couldn't support their global ambitions:

• Departmental isolation: Commercial teams worked separately from Product and Finance departments, creating silos that hindered strategic decision-making
• Excel limitations: Time-consuming, error-prone budgeting processes that couldn't handle their operational complexity
• Manual consolidation pain: P&L and cash flow consolidation made it nearly impossible to respond quickly to market changes
• Misplaced focus: Inability to concentrate forecasting efforts on areas of highest uncertainty and business impact

Their Director of FP&A explained the core issue: "We realized we needed to shift our focus from the past to the future. Sales and Cost of Goods Sold represent our highest uncertainty variables, yet our traditional processes didn't allow us to model these dynamic elements effectively."

The business requirements were clear: "We needed to have a daily budget for each of our business units - our stores, whether physical or online. We needed product-level planning, and for that to feed into the profit and loss account for the current and following fiscal year."

‍

The solution: Comprehensive platform evaluation and partnership

The company approached their transformation systematically, evaluating three different planning tools and four consulting partners before making their selection.

They chose Anaplan based on several critical factors:

Business Requirements Alignment

• Flexibility for complex, multi-dimensional planning scenarios
• Team autonomy with superior visualization capabilities
• Advanced predictive analytics for uncertain variables
• User-friendly interface appealing to existing Excel users

Technical Advantages

• Agnostic architecture with robust integration options
• Various data connectivity options for seamless data flow
• Faster calculations and improved data transfer capabilities
• Adaptable integration framework supporting future expansion

Keyrus was selected as the implementation partner based on their deep understanding of both functional requirements and technical complexities involved in enterprise financial planning transformations.

‍

The implementation: From fragmented to integrated

The Keyrus-led implementation transformed the company's approach from fragmented, siloed planning to integrated, collaborative processes:

Commercial Team Integration

• Comprehensive store-level budgets with detailed monthly distribution
• Advanced analysis of new versus existing store performance
• Real-time tracking across 300+ locations globally
• Dynamic benchmarking capabilities for market-specific insights

Product Team Empowerment

• Forecast vs historical product mix analysis (shifting jewelry from 66% to 60%, accessories from 30% to 35%)
• Material-level cost tracking for gold, silver, leather, and key components
• Real-time margin impact analysis for product mix decisions
• Enhanced collaboration with Commercial teams on pricing strategies

Finance Team Transformation

• Gross margin optimization with integrated Commercial & Product data
• Transportation cost tracking split by retail and e-commerce
• Personnel cost control with CPI-based salary calculations by store
• CapEx planning using €/m² benchmarks by country for store openings
• Working capital management with DSO and DIO tracking

‍