Office Space Inventory / Scheduling Solution ?

[Steven Cappiello]

My boss asked me to start thinking about 2 solutions for her.

1. We work in an office building in which the office space is broken up into modules. Some people get 1 module, some people get 2, 3 or even 4.

At any time my boss would like to see a report of all the office space inventory. However, my boss would also like to look at the office space inventory breakdown at points in time. So, she can say, Mr. Smith's office is leaving in March 2007, that will bring the total empty modules on the 6th floor to 21 at that time and on the 4th floor there will be 12 empty modules.

Have any of you seen any sort of solution that does something like this ?

thanks.