Space / Space Chargeback
Real Property / Chargeback & Invoicing
Workspace Services / Hoteling
Chargeback Calculations
The Perform Chargeback routine runs the calculations outlined below.
You can access the Perform Chargeback routine from these locations:
- Space / Space Chargeback / Space Chargeback (Transactional)
- Space / Space Chargeback / Shared Workplace Chargeback (Non-Transactional)
- Real Property / Chargeback & Invoicing / Chargeback Administrator / Chargeback Cost Wizard
- Workplace Services / Hoteling / Management Reports / Hoteling Chargeable Costs by Division
Group Chargeback Calculations
Name | Definition | Result Tables and columns | Calc Tables and Columns | Filter Tables and Columns | Difference from pre-v18.1 |
---|---|---|---|---|---|
Floor |
|||||
Total Group Area |
Sum of group areas. |
area_gp |
sum(gp.area) |
|
|
Total Group Department Area |
Sum of group area assigned to divisions and departments |
area_gp_dp |
sum(gp.area) |
gp.dp_id is not null |
|
Total Group Common Area |
Sum of group areas with prorate = FLOOR, plus Floor Remaining Area if prorate field is set to FLOOR. |
area_fl_comn_gp |
sum(gp.area) + fl.area_remain IF fl.prorate_remain = FLOOR |
gp.prorate = FLOOR |
|
Serv Floor Common Area |
Sum of Service Areas with prorate set to FLOOR |
area_fl_comn_serv |
sum(rm.area) |
rmcat.supercat = SERV AND rm.prorate = FLOOR |
sum(rm.area); rmcat.supercat = SERV AND rm.prorate = FLOOR |
Total Remaining Area |
Interior gross area - Total Room Area - Total Group Area |
area_remain |
area_gross_int - area_rm - area_gp |
|
area_gross_int - area_rm - area_gp |
Building |
|||||
Total Group Area |
Sum of group areas. |
area_gp |
sum(gp.area) |
|
|
Total Group Department Area |
Sum of group area assigned to divisions and departments |
area_gp_dp |
sum(gp.area) |
gp.dp_id is not null |
|
Total Group Common Area |
Sum of group areas with prorate = BUILDING, plus sum of Floor Remaining Area if prorate field is set to BUILDING. |
area_bl_comn_gp |
sum(gp.area) + sum(fl.area_remain) IF fl.prorate_remain = BUILDING |
gp.prorate = BUILDING |
|
Serv Building Common Area |
Sum of Service Areas with prorate set to BUILDING |
area_bl_comn_serv |
sum(rm.area) |
rmcat.supercat = SERV AND rm.prorate = BUILDING |
sum(rm.area); rmcat.supercat = SERV AND rm.prorate = BUILDING |
Site |
|||||
Total Group Area |
Sum of group areas. |
area_gp |
sum(gp.area) |
|
|
Total Group Department Area |
Sum of group area assigned to divisions and departments |
area_gp_dp |
sum(gp.area) |
gp.dp_id is not null |
|
Total Group Common Area |
Sum of group areas with prorate = SITE, plus sum of Floor Remaining Area if prorate field is set to SITE. |
area_st_comn_gp |
sum(gp.area) + sum(fl.area_remain) IF fl.prorate_remain = SITE |
gp.prorate = SITE |
|
Serv Site Common Area |
Sum of Service Areas with prorate set to SITE |
area_st_comn_serv |
sum(rm.area) |
rmcat.supercat = SERV AND rm.prorate = SITE |
sum(rm.area); rmcat.supercat = SERV AND rm.prorate = SITE |
Group Calcs |
Only calculated on groups with dp_id not null |
|
|
|
|
Total Group Common Area |
Pct Floor Common + Pct Building Common + Pct Site Common |
area_comn_gp |
|
|
|
Pct Floor Common |
Group Area / FL.Total Group Dept * FL.Total Group Common |
|
gp.area / fl.area_gp_dp * fl.area_fl_comn_gp |
|
|
Pct Building Common |
Group Area / BL.Total Group Dept * BL.Total Group Common |
|
gp.area / bl.area_gp_dp * bl.area_bl_comn_gp |
|
|
Pct Site Common |
Group Area / SITE.Total Group Dept * SITE.Total Group Common |
|
gp.area / site.area_gp_dp * site.area_st_comn_gp |
|
|
Service Common Area |
Pct Serv Floor Common + Pct Serv Building Common + Pct Serv Site Common |
area_comn_serv |
|
|
|
Pct Serv Floor Common |
Group Area / FL.Total Group Dept * FL.Serv Floor Common Area |
|
gp.area / fl.area_gp_dp * fl.area_fl_comn_serv |
|
|
Pct Serv Building Common |
Group Area / BL.Total Group Dept * BL.Serv Building Common Area |
|
gp.area / bl.area_gp_dp * bl.area_bl_comn_serv |
|
|
Pct Serv Site Common |
Group Area / SITE.Total Group Dept * SITE.Serv Site Common Area |
|
gp.area / site.area_gp_dp * site.area_st_comn_serv |
|
|
Total Common Area |
Group Common Area + Service Common Area |
area_comn |
area_comn_gp + area_comn_serv |
|
|
Chargeable Area |
Group Area + Total Common Area |
area_chargable |
gp.area + area_comn |
|
|
Cost (Used for Space Chargeback only) |
Chargeable Area * Floor Cost per Area, OR Chargeable Area * Building Cost per Area if Floor Cost per Area is 0 |
cost |
gp.area_chargable * fl.cost_sqft OR gp.area_chargable * bl.cost_sqft |
|
|
Department, Division Calcs |
All per gp.dp_id |
|
|
|
|
Total Group Area |
Sum of Group Areas |
area_gp |
sum(gp.area) |
|
|
Total Group Common Area |
Sum of Total Common Area for groups |
area_comn_gp |
sum(gp.area_comn_gp) |
|
|
Total Service Common Area |
Sum of Service Common Areas |
area_comn_serv |
sum(gp.area_comn_serv) |
|
|
Total Common Area |
(Existing) Total Common Area + Group Common Area + Service Common Area |
area_comn |
area_comn + area_comn_gp + area_comn_serv |
|
Add to existing area_comn |
Chargeable Area |
(Existing) Chargeable Area for rooms + Sum of Chargeable Area for groups |
area_chargable |
area_chargable + sum(gp.area_chargable) |
|
Add to existing area_chargable |
Cost (Used for Space Chargeback only) |
(Existing) Sum of Cost for rooms + Sum of Cost for groups |
cost |
cost + sum(gp.cost) |
|
Add to existing cost |
Workspace Transactions Chargeback Calculations
Name | Definition | Result Tables and Columns | Calc Tables and Columns | Filter Tables and Columns |
---|---|---|---|---|
Floor |
||||
Total Room Area |
Sum of room areas. |
area_rm |
sum(rmpct.area_rm) |
rmcat.used_in_calcs IN ('all_totals') |
Total Occupiable Dept |
Sum of RMPCT Allocated Room Area, for Workspace Transaction records assigned to departments with occupiable = 1 and used_in_calcs IN ('all_totals') |
area_ocup_dp |
sum(rmpct.area_rm) |
rmpct.dp_id is not null AND rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals') |
Remaining Area |
See Remaining Area in Rollup section |
area_remain |
|
|
Total Non-occupiable Common |
Sum of RMPCT Allocated Room Area with prorate = FLOOR and occupiable = 0 and used_in_calcs IN ('all_totals') |
area_fl_comn_nocup |
sum(rmpct.area_rm) |
rmpct.prorate = FLOOR AND rmcat.occupiable = 0 AND rmcat.used_in_calcs IN ('all_totals') |
Total Occupiable Common |
Sum of RMPCT Allocated Room Area with prorate = FLOOR and occupiable = 1 and used_in_calcs IN ('all_totals'), plus Floor Remaining Area if prorate field is set to FLOOR. |
area_fl_comn_ocup |
sum(rmpct.area_rm) + fl.area_remain IF fl.prorate_remain = FLOOR |
rmpct.prorate = FLOOR AND rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals') |
Building |
||||
Total Occupiable Dept |
Sum of floor Total Occupiable Dept |
area_ocup_dp |
sum(fl.area_ocup_dp) |
|
Total Non-occupiable Common |
Sum of RMPCT Allocated Room Area with prorate = BUILDING and occupiable = 0 and used_in_calcs IN ('all_totals') |
area_bl_comn_nocup |
sum(rmpct.area_rm) |
rmpct.prorate = BUILDING AND rmcat.occupiable = 0 AND rmcat.used_in_calcs IN ('all_totals') |
Total Occupiable Common |
Sum of RMPCT Allocated Room Area with prorate = BUILDING and occupiable = 1 and used_in_calcs IN ('all_totals'), plus sum of Floor Remaining Area if prorate field is set to BUILDING. |
area_bl_comn_ocup |
sum(rmpct.area_rm) + sum(fl.area_remain) IF fl.prorate_remain = BUILDING |
rmpct.prorate = BUILDING AND rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals') |
Site |
||||
Total Occupiable Dept |
Sum of building Total Occupiable Dept |
area_ocup_dp |
bl.area_ocup_dp |
|
Total Non-occupiable Common |
Sum of RMPCT Allocated Room Area with prorate = SITE and occupiable = 0 and used_in_calcs IN ('all_totals') |
area_st_comn_nocup |
sum(rmpct.area_rm) |
rmpct.prorate = SITE AND rmcat.occupiable = 0 AND rmcat.used_in_calcs IN ('all_totals') |
Total Occupiable Common |
Sum of RMPCT Allocated Room Area with prorate = SITE and occupiable = 1 and used_in_calcs IN ('all_totals'), plus sum of Floor Remaining Area if prorate field is set to SITE. |
area_st_comn_ocup |
sum(rmpct.area_rm) + sum(fl.area_remain) IF fl.prorate_remain = SITE |
rmpct.prorate = SITE AND rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals') |
Workspace Transaction Calcs |
Only calculated on rmpct records with dp_id not null AND where rmcat.used_in_calcs IN ('all_totals') AND where rmcat.occupiable = 1 |
|
|
|
Occupiable Common Area |
Pct Occupiable Floor Common + Pct Occupiable Building Common + Pct Occupiable Site Common |
area_comn_ocup |
|
|
Pct Occupiable Floor Common |
RMPCT Allocated Room Area / FL.Total Occupiable Dept * FL.Total Occupiable Common |
|
rmpct.area_rm / fl.area_ocup_dp * fl.area_ocup_comn |
|
Pct Occupiable Building Common |
RMPCT Allocated Room Area / BL.Total Occupiable Dept * BL.Total Occupiable Common |
|
rmpct.area_rm / bl.area_ocup_dp * bl.area_ocup_comn |
|
Pct Occupiable Site Common |
RMPCT Allocated Room Area / SITE.Total Occupiable Dept * SITE.Total Occupiable Common |
|
rmpct.area_rm / site.area_ocup_dp * site.area_ocup_comn |
|
Non-Occupiable Common Area |
Pct Non-occupiable Floor Common + Pct Non-occupiable Building Common + Pct Non-occupiable Site Common |
area_comn_nocup |
|
|
Pct Non-occupiable Floor Common |
RMPCT Allocated Room Area / FL.Total Occupiable Dept * FL.Total Non-occupiable Common |
|
rmpct.area_rm / fl.area_ocup_dp * fl.area_nocup_comn |
|
Pct Non-occupiable Building Common |
RMPCT Allocated Room Area / BL.Total Occupiable Dept * BL.Total Non-occupiable Common |
|
rmpct.area_rm / bl.area_ocup_dp * bl.area_nocup_comn |
|
Pct Non-occupiable Site Common |
RMPCT Allocated Room Area / SITE.Total Occupiable Dept * SITE.Total Non-occupiable Common |
|
rmpct.area_rm / site.area_ocup_dp * site.area_nocup_comn |
|
Total Common Area |
Occupiable Common Area + Non-occupiable Common Area |
area_comn |
area_comn_ocup + area_comn_nocup |
|
Chargeable Area |
Allocated Room Area + Total Common Area |
area_chargable |
rmpct.area_rm + rmpct.area_comn |
|
Cost |
Chargeable Area * Floor Cost per Area, OR Chargeable Area * Building Cost per Area if Floor Cost per Area is 0 |
cost |
rmpct.area_chargable * rm.cost_sqft OR rmpct.area_chargable * rmcat.cost_sqft OR rmpct.area_chargable * fl.cost_sqft OR rmpct.area_chargable * bl.cost_sqft |
|
Department, Division Calcs |
All per rmpct.dv_id or rmpct.dp_id |
|
|
rmcat.used_in_calcs IN ('all_totals') |
Total Room Area |
Sum of RMPCT Allocated Room Areas |
area_rm |
sum(rmpct.area_rm) |
|
Total Occupiable Common |
Sum of Occupiable Common Area for RMPCT |
area_comn_ocup |
sum(rmpct.area_comn_ocup) |
|
Total Non-occupiable Common |
Sum of Non-occupiable Common Area for RMPCT |
area_comn_nocup |
sum(rmpct.area_comn_nocup) |
|
Total Common Area |
Sum of Total Common Area for RMPCT |
area_comn |
sum(rmpct.area_comn) |
|
Chargeable Area |
Sum of Chargeable Area for RMPCT |
area_chargable |
sum(rmpct.area_chargable) |
|
Cost |
Sum of Cost for RMPCT |
cost |
sum(rmpct.cost) |
|