I only write here very rarely because others know much more here, but this time I have to say something.
First of all, you have a decent budget. Why don’t you hire an architect?
For this really small plot, you have an extremely large number of wishes, question that. Why does the office have to be in the house? So that the woman can care for the children alongside her full-time job? Where does the club work now? Can’t it rent other rooms?
Then the whole thing is very unbalanced. Upstairs there is one room of 9 sqm, one 18 and the big one 35 sqm. And one child is supposed to get the 9, the other the 18 and you get the 35 sqm as a bedroom? Such a division makes no sense at all, as a child I would really hate being stuck in the tiny chamber. Am I supposed to play, study, chill with friends, sleep, have my clothes, books, school stuff etc, etc there? And the parents only get 35 sqm just to sleep? Seriously not. This has nothing to do with compromise or making the house flexible to use later; this is badly planned.
On the ground floor, the hallway is simply tight. It’s okay to want to have as little hallway as possible, but a little space to arrive, take off jackets and shoes and tidy up (times 4 people), put down bags and house keys, move around, is a must. The staircase is too short, that certainly won’t work. Where it leads into the living room, the hallway is no more than a meter wide. That’s not nice.
Then you have a sofa, which basically stands in front of the little living room corner because it doesn’t fit inside. You then look into this little corner at the TV. The window doesn’t open onto greenery but in front of it there is a hole, the light well. The same with the dining room window. And space for a few pieces of furniture basically isn’t there either.
The kitchen island doesn’t even have 60 cm in the plan. That’s a joke. That just won’t work.
The technical room will be about only 10 sqm so there will be more space for living areas. In the end you have to see if you can fit KNX, network cabinet, ventilation systems, battery storage, inverters etc into 10 sqm, or if significantly more space is needed.
And if it’s not enough? Then some room-tetris is played around – but then it won’t fit there anymore... This needs to be properly planned from the start.
These are just a few concrete things that are really bad. Others have already said a lot.
You can see from the floor plan that a layperson has stacked rooms onto and above each other who has no idea about spatial concepts and no spatial imagination either.
You want to spend a lot of money, get a professional involved!