
JEDOX SUCCESS STORY · FOOD & BEVERAGE
McDonald’s Switzerland simplifies planning across 173 restaurants
McDonald’s Switzerland needed a clear view across its 173 restaurants to compare operations and identify the most profitable operating model. Having used Jedox for planning and budgeting since 2014, it extended the platform to automate franchisee reporting, with operations managers viewing results in the field through Jedox Cloud.
173
restaurants covered by reporting
2 months
to build the ETL and data cube in-house
~15
report users across the business

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

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
- AgReliant Genetics: AgReliant Genetics increased scenario planning frequency 3x within months
- Agrogen: Agrogen achieves 50% faster budget cycles with secure, integrated planning
- Andros: Fresh food sales planning on a day-to-day basis for Andros
- Bell Food Group: Bell Food Group streamlines sustainability indicator monitoring with Jedox
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.
