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:

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)