Personally, I think it sucks to have to lug massive pieces of rough lumber and 4′ x 8′ plywood sheets all the way across a shop. Much respect to basement dwellers who have little choice in the matter. But for those with garage shops, you should think about storing your sheetgoods and solid stock near an entrance. This way when you come home from the lumber dealer, you can back up your vehicle and quickly load the stock into the shop.
Let’s be clear about one thing: No workshop is perfect for everyone. If there were, I could simply give you a precise plan to follow with clear dimensions. Every person who comes to the hobby, avocation, or profession of woodworking has his own particular collection of tools and his own peculiar work style, skills, and desires for the kind of woodworking he wants to do that gives him a unique approach as to how he will lay out a shop: where the tools should go, where lumber and supplies are stored, and how much bench area he needs.