OK, this is starting to look a little like my previous
class-based needs suggestion. But anyway, I think you're really bringing up the right points, because you're asking what makes people actually demand things.
If you have towns start actually demanding things based upon some sort of abstracted uses they have for it, you can start working out how the demand should actually work, instead of just assuming that demand is based upon always wanting something. This does raise the next question, though, which is, "How many stone mugs does one town go through in a year?" Currently, we have no really good answer to this - although dwarves from 40d will tend to buy mugs whenever they have free time and money if they love mugs, and will happily toss them on the floor of their room or some random spot on the fort's floor instead of putting them away. I guess their mugs never breaking or being used never stops them from collecting more. Still, you need to answer the "how many mugs per person who is in the class range to buy a mug go through in a year?" Theoretically, there should be a rate of breakage or some such.
This only sets up the baseline of demand, though. You see, demand is not about, "how many mugs are they willing to buy?" it's about, "how much are they willing to pay?" And there are two major points to answering this question, but they both relate to one major aspect of supply and demand, "elasticity of demand". The first of which is how much they really need it or are desperate for it. If we're talking about having the stone to build a wall around your city before the next wave of attacks comes, they probably need it. If we're talking about a lute or something, they probably can wait for the prices to come down a little.
The more major complication on elasticity of demand is "substitutables". In real life, beef is the most heavily demanded and pricey meat. Pork is a substitute for beef - it's cheaper, but people want beef more, so they are willing to pay more for beef. Cereal is an even cheaper substiute than either of them.
Let's say there's an outbreak of mad cow disease or something, and beef supply goes down, prices go up. When prices for beef are a certain point above pork, then people will say "screw it, I don't like beef
that much more than pork", and just buy pork, instead. Unless supply of pork goes up to compensate (slaughter more pigs), then the price of pork may also go up (and the lower demand will cause beef prices to come back down a little), causing the price difference between pork and beef to come back closer together, and people will start migrating back towards beef.
Let's say the economy tanks, plenty of people need to cut back on their spending, and as such, they can't afford the "luxury" of beef. Beef demand goes down. Pork demand, as a cheaper substitute, goes up. If prices of pork go high enough, and people are desperate enough for a cheaper food, maybe they'll just go buy cereal, instead.
This is why, after the big recession, there was only one Fortune 500 company to actually turn a bigger profit than before - Campbell's Soup. Soup is cheap. It's a cheaper substitute than many other forms of food (Hell, you pretty much have to go for Ramen-level food to get cheaper), so its sales only really take off when people can't afford more luxurious foods.
Now then, here's where this can intersect with DF - not only are there plenty of substitues for dog leather or quarry bush leaf roasts, but if we are just talking about mugs and mugs alone, then there's still room for substitutes. Which would you rather have to go drinking with your friends - a microcline mug that was baby's first craft project, or a masterwork obsidian mug with an image of a dwarf chopping a forgotten beast in half with an axe in green glass on it and menaces with spikes of iron? One's cheap, but the other is a
kickass drinking mug.
How much more are you willing to pay for a kickass mug?
Now then, the thing is, Supply is actually really simple, especially in a world without economies of scale to make it more interesting. Demand's the hard part. Supply is just a measure of how fast the world will produce that given type of good. Demand is the passing fads and trends and desires of the entire world's population.
To find where supply and demand intersect, you just need to start a "bidding war" for the goods. You need to find what everyone is willing to pay for a given good, and then how many are on the market at that piont in time. If you have 5 mugs of a certain type, then the person who is willing to pay the fifth-highest price is the one who sets the price of those goods. Nobody else below the fifth-highest bidder is willing to pay the price, but that's OK, you only need to sell 5.
Now, this means you can really perform some neat tricks by creating some illusions of quality, like with the image in green glass - there's only ONE of those, so the guy willing to pay the most outrageous prices just to have the most kickass mug in town will be the only one to get one. The guys willing to settle for more microcline mugs will be marketed the bulk-made cheap crap.
There is also the potential here for a dependency on a certain kind of good. Someone may want to make a contract with you if you produce a large quantity of a certain kind of good to supply certain amounts of that good every year. For example, the cities are dependant upon the villages to supply them with food, and their continued existence is based upon the expectation that food will be traded to them from the villages every year.
If you flood the market with cheap microcline mugs, maybe all the other mug craftsmen decide that it's not worth their time to compete with you on price, anymore, and local woodcrafters might decide to just start making bolts or something, instead. You get contracts to supply the local economies with pretty much all their mug demands. It would still be cheap, but since you're driving your competition into other markets, you would still be able to at least offload your goods somewhere. (You could also suddenly inject a shock to the system by not renewing your contract for one year, driving prices up on remaining mugs for the next year, but that would re-introduce competition trying to take up the slack.)