The Perform Chargeback routine runs the following calculations.
You can access the Perform Chargeback routine from these locations on the Process Navigator:
|
Name |
Definition |
Result Tables and Columns |
Calc Tables and Columns |
Filter Tables and Columns |
Difference from pre-v18.1 |
|
Chargeback - Group |
|||||
|
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 |
(Existing) Sum of Cost for rooms + Sum of Cost for groups |
cost |
cost + sum(gp.cost) |
|
Add to existing cost |