allocated room area (Space Inventory)
How much space (both space-wise and time-wise) is allocated to a particular instance of use and is therefore billed to the corresponding department.
The Workspace Transaction table (the rmpct table) stores each instance of the percentages of space use and time use. Each instance is calculated as:
rmpct.area_rm = (the corresponding room’s area) * (pct_space / 100) * (pct_time / 100)
This data is summed to the room level in the Allocated Area field of the Rooms table:
rm.area_alloc = SUM(rmpct.area_rm)
For example, suppose the following:
- Room 101 is 100 square feet.
- Room 101 is shared so that Department A uses 60 percent of the space and Department B uses 40 percent of the space
- This situation occurs 100 percent of the time.
- The Cost per Area of Room 101 is $20 a square foot.
In this case, room 101 has the following properties:
- Room 101 will have two allocations of space: one for Department A with an allocated area of 60, and one for Department B with an allocated area of 40.
- Room 101 is 100 percent allocated.
- Department A will be billed $120 for its use of Room 101 (60 allocated area x $20 cost per area)
- Department B will be billed $80 for its use of Room 101 (40 allocated area x $20 cost per area)