JEDOX SUCCESS STORY · FOOD & BEVERAGE

McDonald’s Switzerland simplifies planning across 173 restaurants

Kybos - The Jedox Professionals. Financial planning and analysis solutions.

173

restaurants covered by reporting

2 months

to build the ETL and data cube in-house

~15

report users across the business

McDonald's Switzerland logo

About McDonald’s Switzerland

McDonald’s Switzerland is headquartered in Crissier and employs 7,200 people. It runs 173 restaurants, 152 of them franchised, and serves around 300,000 guests a day. The first Swiss McDonald’s opened in Geneva in November 1976 with 25 staff and eight products. The company has used Jedox for planning, budgeting and reporting since 2014.

Challenge

Slow franchisee data consolidation

The first Swiss McDonald’s opened in Geneva in November 1976 with 25 staff and 8 products. Today the company is headquartered in Crissier, employs 7,200 people, runs 173 restaurants (152 of them franchised) and serves around 300,000 guests a day.

CFO Thomas Mosimann describes the business as a community: comparing franchisees helps define the best operating standard, but gathering and consolidating their performance data in Excel took far too long. He chose not to outsource the work, preferring to model assumptions in-house from the company’s own data.

McDonald’s had used Jedox since 2014 for planning, budgeting and reporting on the roughly 12% of restaurants it manages directly. In 2019, once internal projects had matured, it extended Jedox to franchisee reporting.

Solution

In-house reporting in two months

Franchisees send performance data as CSV files, which an ETL process loads into a Jedox data cube from which reports are generated. Three team members with no IT specialism built the ETL and cube in two months, and Jedox partner Linalis helped build the final reports, cutting one planned ten-formula calculation down to three.

Reports show regional and restaurant-level KPIs such as service speed and customers served per hour, presented as charts and tables with drill-down to granular detail. Refreshes are semi-automatic: reports update with one click when the team is ready for a new period.

Operations managers spread across Switzerland access reports through Jedox Cloud during site visits, without returning to headquarters.

“Being able to model assumptions ourselves based on our performance data is the quickest way to implement internal ideas.”

Thomas Mosimann
CFO
McDonald’s Switzerland

McDonald's Switzerland – Jedox customer success story

Outcome

A clear view of 173 restaurants

The reports are now used well beyond the original need. Each member of the management team can check their budget, expenses and remaining funds for the year at any time, raw material costs are visible, and all cash flow planning now runs in Jedox. About 15 people use the reports.

Manual Excel data entry and formatting have been eliminated, saving significant time and resources that staff now spend analysing data. Managers can click into a dashboard deviation to find its cause.

With the business growing, McDonald’s Switzerland plans to add a sales forecasting module for franchisees.

We no longer need to manually enter data in Excel, assign colors, etc.

Thomas Mosimann, CFO, McDonald’s Switzerland

Jedox in use at McDonald’s Switzerland

  • Planning and budgeting
  • Management reporting
  • Cash flow planning
  • ETL integration (CSV)
  • Jedox Cloud

Read more Jedox success stories, or find out about Jedox implementation in the UK & Ireland.

More food & beverage success stories

Want results like McDonald’s Switzerland?

Kybos is the UK & Ireland’s only dedicated Jedox partner. Our accountancy-qualified consultants will show you what Jedox could do for your finance team.