Dungeons and Dragons and Logistics

I’ve again fallen into the trap of trying to make a dungeon that makes sense. Like, where do the denizens of this place sleep and eat? How does the fresh water get in and the waste get out?

I have the kitchens, bedrooms and latrines added to the map now. The next big question is: What do the inhabitants actually do all day? I guess they spend several hours farming and doing chores… and then what?

Now I need to put in some kind of entertainment. So what percentage of the denizens are employed just to entertain the others? There must be an auditorium and/or a library?

Yes, I could just throw in a few monsters and a treasure chest, but that would leave me with too many questions!

The players live in a castle, employed by a more senior adventuring party. That castle has a whole character sheet of its own. I included the income from the surrounding lands, and the industry of the castle workshops vs the expenses of paying castle staff and maintenance. I worked out the income of the castle owners over the last several years; and used that to finance a campaign against the knight up river.

The army also had a stat sheet tracking supplies and how to move them to the front.

I showed it all to my friend who also DMs games. He was horrified.