Enter once, display many – ideas wanted

Looking for ideas. I manage a resort website for which I need to find a way to handle lodging rates for condos. They have summer rates and winter rates. There are pages for a rate table for each. In addition, there are 6 different floor plans. There is a page for each floor plan. They would like me to include individual rates for each floor plan on the floor plan pages. This makes 8 different places to manage and update rates. Keeping them current and accurate would be an effort and chances for errors are greater than I’d like. I don’t think Widgets are the answer because, in order to display different info on different pages, I’d still need 2 pages and 6 different widgets to assign to the floor plan pages.

It would be nice to have one place to manage all rates and selectively display individual rates or the entire rate table as needed. Appreciate any thoughts about a solution (technique, tool, plugin).