Multi factor Year over Year Comparison by Office
3/7/2023 7:14 PM
Run for Company "Your Company" for Office "Main Office" for all Regions for Year 2022 for Months range from 11 to 11 for Date range grouped by Company and Office using Calculated Data
  
Category
actual
budget
var +/-
%
 
last yr
YOY
YOY %
Your Company
 
Main Office
  
Statistics
actual
budget
var +/-
%
 
last yr
YOY
YOY %
  
No of Associate
21
26
(5)
-19.23 %
 
22
(1)
-4.55 %
  
Listings Taken
62
121
(59)
-48.76 %
 
65
(3)
-4.62 %
  
Contracts written
118
154
(37)
-23.70 %
 
148
(30)
-20.34 %
  
Closed Transaction sides
100
137
(38)
-27.37 %
 
113
(14)
-11.95 %
  
Per Person Productivity
13.29
15.85
-2.56
-16.15 %
 
14.80
-1.51
-10.20 %
  
Listings inventory
11
0
11
0.00 %
 
11
0
0.00 %
  
Listings inventory Volume
20,061,900
0
20,061,900
0.00 %
 
21,019,500
(957,600)
-4.56 %
  
Avg Days on market
180
0
180
0.00 %
 
252
(72)
-28.47 %
  
Pending inventory
13
0
13
0.00 %
 
20
(7)
-35.00 %
  
Pending Company $
76,369
0
76,369
0.00 %
 
79,742
(3,373)
-4.23 %
  
Pending CMOE Ratio
2.9
3.0
(0.1)
-2.33 %
 
3.2
(0.3)
-8.15 %
  
Average Home price
1,434,466
1,129,833
304,633
26.96 %
 
1,174,092
260,375
22.18 %
  
Avg Closed Trans Sides per Agent
4.7
5.3
(0.5)
-10.06 %
 
5.1
(0.4)
-7.78 %
  
Avg Contract Commission per side
3.1 %
2.8 %
0.3 %
9.02 %
 
2.9 %
0.2 %
7.07 %
  
Volume
142,729,401
155,112,918
(12,383,517)
-7.98 %
 
132,672,344
10,057,057
7.58 %
  
GCI
4,356,838
4,343,161
13,677
0.31 %
 
3,782,440
574,398
15.19 %
  
Num of Employees
1
1
0
0.00 %
 
1
0
0.00 %
  
Company Split
13.58 %
13.65 %
   
13.36 %
  
  
Agent Split
86.42 %
86.35 %
   
86.64 %
  
  
Capital Expenditures
3,201
0
3,201
0.00 %
 
4,201
(1,000)
-23.81 %
  
Overhead per Agent
13,646
13,443
203
1.51 %
 
12,494
1,152
9.22 %
  
Income
actual
budget
var +/-
%
 
last yr
YOY
YOY %
  
AGCI
4,220,802
4,182,233
38,569
0.92 %
 
3,623,027
597,775
16.50 %
  
Gross Profit
573,296
570,958
2,338
0.41 %
 
484,043
89,252
18.44 %
  
Operating Expenses
actual
budget
var +/-
%
 
last yr
YOY
YOY %
  
Salaries & Fringe Costs
65,483
62,489
2,994
4.79 %
 
81,941
(16,458)
-20.09 %
  
Office Expenses
14,006
10,780
3,226
29.93 %
 
8,300
5,707
68.76 %
  
Postage and Mail
114
66
48
71.97 %
 
64
50
77.82 %
  
Office Lease
37,866
40,700
(2,834)
-6.96 %
 
49,695
(11,829)
-23.80 %
  
Utilities
8,937
6,765
2,172
32.11 %
 
6,785
2,152
31.72 %
  
Repairs & Maintenance
18,868
4,631
14,237
307.44 %
 
4,631
14,238
307.47 %
  
Professional
325
0
325
0.00 %
 
0
325
0.00 %
  
Taxes, Fees & Licenses
97
132
(35)
-26.23 %
 
130
(33)
-25.23 %
  
Advertising Costs
70,207
154,703
(84,496)
-54.62 %
 
76,994
(6,787)
-8.81 %
  
Management Fee Expense
68,750
68,750
0
0.00 %
 
45,833
22,917
50.00 %
  
Total Operating Expense
215,904
280,266
(64,362)
-22.96 %
 
228,539
(12,635)
-5.53 %
  
Other Income
0
0
0
0.00 %
 
0
0
0.00 %
  
Other Expense
70,656
69,245
1,411
2.04 %
 
46,325
24,331
52.52 %
  
Net Profit
286,736
221,447
65,289
29.48 %
 
209,179
77,556
37.08 %
  
ROR
6.79 %
5.29 %
   
5.77 %
  
/AT2017_Reports/rpt_ABbyOffice
Page 1/1