Chargeback Calculations for Standard Space Chargeback (Non-Transactional) and Space SaaS Module

The Perform Chargeback routine runs the group and room calculations listed below.

You can access the Perform Chargeback routine from the paths listed at the top of this topic.

This topic has two sections:

Group Chargeback Calculations
Room Chargeback Calculations

Group Chargeback Calculations

Name	Definition	Result Tables and Columns	Calc Tables and Columns	Filter Tables and Columns
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
Total Remaining Area	Interior gross area - Total Room Area - Total Group Area	area_remain	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
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
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	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
Chargeable Area	(Existing) Chargeable Area for rooms + Sum of Chargeable Area for groups	area_chargable	area_chargable + sum(gp.area_chargable)
Cost	(Existing) Sum of Cost for rooms + Sum of Cost for groups	cost	cost + sum(gp.cost)

Room Chargeback Calculations

Name	Definition	Result Tables and Columns	Calc Tables and Columns	Filter Tables and Columns
Floor
Total Room	Sum of room areas.	area_rm	sum(rm.area)	rmcat.used_in_calcs IN ('all_totals')
Total Occupiable Department	Sum of room areas assigned to departments with occupiable = 1 and calc IN ('all_totals')	area_ocup_dp	sum(rm.area)	rm.dp_id is not null AND rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals')
Total Non-Occupiable Common	Sum of room areas with prorate = FLOOR and occupiable = 0 and used_in_calcs IN ('all_totals')	area_fl_comn_nocup	sum(rm.area)	m.prorate = FLOOR AND rmcat.occupiable = 0 AND rmcat.used_in_calcs IN ('all_totals')
Total Occupiable Common	Sum of room areas 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_bl_comn_ocup	sum(rm.area) + sum(fl.area_remain) IF fl.prorate_remain = BUILDING	rm.prorate = BUILDING AND rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals')
Remaining Area	Internal Gross Area - Total Area	area_remain	area_gross_int - area_rm - area_gp
Building
Total Occupiable Dept	Sum of floor's Total Occupiable Dept	area_ocup_dp	sum(fl.area_ocup_dp)
Total Non-occupiable Common	Sum of room areas with prorate = BUILDING and occupiable = 0 and used_in_calcs IN ('all_totals')	area_bl_comn_nocup	sum(rm.area)	rm.prorate = BUILDING AND rmcat.occupiable = 0 AND rmcat.used_in_calcs IN ('all_totals')
Total Occupiable Common	Sum of room areas 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_gp	sum(gp.area) + sum(fl.area_remain) IF fl.prorate_remain = BUILDING	gp.prorate = BUILDING
Site
Total Occupiable Dept	Sum of building Total Occupiable Dept	area_ocup_dp	sum(bl.area_ocup_dp)
Total Non-occupiable Common	Sum of room areas with prorate = SITE and occupiable = 0 and used_in_calcs IN ('all_totals')	area_st_comn_nocup	sum(rm.area)	rm.prorate = SITE AND rmcat.occupiable = 0 AND rmcat.used_in_calcs IN ('all_totals')
Total Occupiable Common	Sum of room areas 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(rm.area) + sum(fl.area_remain) IF fl.prorate_remain = SITE	rm.prorate = SITE AND rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals')
Room Calcs	Only calculated on rooms where dp_id is not null AND where rmcat.used_in_calcs IN ('all_totals') AND rmcat.occupiable = 1
Occupiable Common Area	Pct Occupiable Floor Common + Pct Occupiable Building Common + Pct Occupiable Site Common	area_comn_ocup
Total Group Common Area	Pct Floor Common + Pct Building Common + Pct Site Common	area_comn_gp
Non-Occupiable Common Area	Pct Non-occupiable Floor Common + Pct Non-occupiable Building Common + Pct Non-occupiable Site Common		area_comn_nocup
Pct Occupiable Floor Common	Room Area / FL.Total Occupiable Dept * FL.Total Occupiable Common		rm.area / fl.area_ocup_dp * fl.area_fl_comn_ocup
Pct Occupiable Building Common	Room Area / BL.Total Occupiable Dept * BL.Total Occupiable Common		rm.area / site.area_ocup_dp * site.area_st_comn_ocup
Pct Non-occupiable Floor Common	Pct Serv Floor Common + Pct Serv Building Common + Pct Serv Site Common	area_comn_serv
Pct Non-occupiable Building Common	Room Area / FL.Total Occupiable Dept * FL.Total Non-occupiable Common		rm.area / bl.area_ocup_dp * bl.area_bl_comn_nocup
Pct Non-occupiable Site Common	Room Area / SITE.Total Occupiable Dept * SITE.Total Non-occupiable Common		m.area / site.area_ocup_dp * site.area_st_comn_nocup
Total Common Area	Occupiable Common Area + Non-occupiable Common Area	area_comn	area_comn_ocup + area_comn_nocup
Chargeable Area	Room Area + Total Common Area	area_chargable	m.area + rm.area_comn
Cost	Chargeable Area * Cost per Area, OR Chargeable Area * Room Category Cost per Area, OR Chargeable Area * Floor Cost per Area, OR Chargeable Area * Building Cost per Area	cost	rm.area_chargable * rm.cost_sqft OR rm.area_chargable * rmcat.cost_sqft OR rm.area_chargable * fl.cost_sqft OR rm.area_chargable * bl.cost_sqft
Department, Division Calcs	All per rm.dv_id or rm.dp_id			rmcat.used_in_calcs IN ('all_totals')
Total Room Area	Sum of Room Areas	area_rm	sum(rm.area)
Total Occupiable Common	Sum of Non-occupiable Common Area for rooms	area_comn_nocup	area_comn_nocup
Total Common Area	Sum of Total Common Areas for rooms	area_comn_serv	sum(gp.area_comn_serv)
Total Common Area	(Existing) Total Common Area + Group Common Area + Service Common Area	area_comn	sum(rm.area_comn)
Chargeable Area	Sum of Chargeable Area for rooms	area_chargable	sum(rm.area_chargable)
Cost	(Existing) Sum of Cost for rooms + Sum of Cost for groups	Sum of Cost for rooms	sum(rm.cost)

Archibus SaaS / Space / Space ChargebackSpace / Space Chargeback / Standard Space Chargeback (Non-Transactional)

Real Estate / Chargeback & Invoicing / Chargeback Administrator / Chargeback Cost WizardWorkspace Services / Hoteling /Management Reports / Hoteling Chargeable Costs by Division

Chargeback Calculations for Standard Space Chargeback (Non-Transactional) and Space SaaS Module

Group Chargeback Calculations

Room Chargeback Calculations

Archibus SaaS / Space / Space Chargeback
Space / Space Chargeback / Standard Space Chargeback (Non-Transactional)

Real Estate / Chargeback & Invoicing / Chargeback Administrator / Chargeback Cost Wizard
Workspace Services / Hoteling /Management Reports / Hoteling Chargeable Costs by Division