Medical Devices · Data Analytics and Software Development

Capacity Modelling Application

An interactive scenario-planning application gives senior leaders a ten-year view of production, labour and regional demand across multiple sites.

ClientDePuy Synthes

LocationCork, Ireland

DisciplineData Analytics and Software Development

10 yrs

Forecast horizon

Multi-site

Production planning

Live

Scenario comparison

Connected technologies

Project profile

Outcome-led engineering

An interactive scenario-planning application gives senior leaders a ten-year view of production, labour and regional demand across multiple sites.

Discuss a project

Business challenge

Management needed to decide where products should be manufactured to maximise profit, understand the long-term effect of different strategies on output and labour, and identify the best time to enter each geographical market.

The existing process made it difficult to compare scenarios or see how production decisions would affect the next ten years.

The solution

Réalta built an interactive application that lets senior leaders upload scenario files and review ten-year production forecasts. A Python scenario model calculates annual production and regional sales requirements, while embedded Power BI reports show the implications at product and site level.

The application uses Power Apps for the interface, Python and FastAPI for the backend and scenario engine, embedded Power BI for reporting, and AWS for hosting.

Business impact

The application helps management compare planned and forecast production, plan long-term resource allocation and identify when production at specific sites should change or stop. Decisions can now be tested against a consistent model before they affect capacity, cost or revenue.

Project view