MS Excel budgeting tool for the Möckernkiez Cooperative

7Gen helped the social housing cooperative Möckernkiez e.G. in Berlin, Germany, with their maintenance budget planning.

The cooperative built a residential quarter consisting of 471 housing units in 14 buildings in 2018. They then faced the task of planning the budgets for cyclical maintenance works for these buildings and the communal areas for the coming decades, in a way which spreads costs as evenly as possible over the years.

This appears to be a simple task at first sight, but quickly gets very complicated, given that it involves 14 buildings, over 80 individiual maintenance measures with implementation cycles ranging from 5 to 50 years and a planning horizon of 75 years.

7Gen built a bespoke software tool, based on MS Excel, for the cooperative, which supports this task in a user-friendly, transparent and robust manner.

The Möckernkiez Cooperative for self-managed, social and ecological living, was founded in 2009 as an initiative by residents in Berlin. The aim of the cooperative was to develop a modern urban quarter in Berlin-Kreuzberg. This has resulted in a unique pilot project: a communal and inter-generational residential complex that is ecological, sustainable, fully accessible and socially integrated.