allocated room area

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. It is calculated as:

rmpct.area_rm = (the corresponding room’s area) * (pct_space / 100) * (pct_time / 100)

The Workspace Transaction table (the rmpct table) stores each instance of the percentages of space use and time use. This data is summed to the room level.

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)