This is a common predicament which many production builders face...how to manage the exponential number of options. Although Pipeline can support a flat database structure to accommodate this, additional tools are available to simplify the process.
These options are called "Conditional Options" which automatically propagate based upon how they are defined.
For example...a kitchen has a hardwood flooring upgrade, but the kitchen is also affected by optional kitchen layouts, optional kitchen islands, optional bumps, optional stretches, optional bays, etc...all of which affect the SF of kitchen flooring.
In typical systems, if there were 5 hardwood options, and 6 options which adjust SF, 5x6=30 combinations would be required.
Pipeline understands this relationship between SF and optional covering and allows for the choice of which option SF should be associated w/ the single HW Opt.
The builder can then utilize the "worst case scenario" when performing a cost forecast, knowing that the Purchase orders will be accurate at the Job Start level.
When profitability analysis is performed on the hardwood option, it is greater for Buyer A who purchased the std. kitchen w/ the hardwood option, but less for Buyer B who purchased the bumped kitchen w/ the hardwood option.