Page 14 - Oxford West Investor Quarterly Report Academic Year 2021-2022 Quarter 2

Oxford West Properties I, LLLP

Budget Comparison Report
Managed by RISE Residential
As of December 31, 2021

Prior MTD Prior YTD Current
Month to Date 12/31/2021 12/31/2020 Year to Date 12/31/2021 12/31/2020 Fiscal Year
Actual Budget Variance Actual Variance Actual Budget Variance Actual Variance Budget

CONTROLLABLE EXPENSES
PAYROLL OFFICE
451 1,717 1,265 1,251 801 6091 - Community Assistants 5,521 9,583 4,062 9,837 4,315 21,600
3,172 3,433 262 3,067 (105) 6093 - Leasing Manager Payroll 15,814 17,167 1,353 15,190 (623) 41,200
5,633 5,579 (54) 5,465 (169) 6330 - General Manager 28,084 27,896 (188) 26,470 (1,614) 66,950
3,895 3,863 (32) 3,890 (4) 6332 - Assistant General Manager 19,416 19,312 (104) 19,269 (147) 46,350
0 0 0 1,970 1,970 6335 - Leasing Salaries 4,594 3,162 (1,432) 11,848 7,254 3,162
0 0 0 0 0 6338 - Property Bonuses 0 3,348 3,348 2,763 2,763 10,044
0 0 0 925 925 6339 - Leasing Bonuses 6,779 9,183 2,404 8,144 1,366 27,882
13,151 14,592 1,441 16,568 3,418 TOTAL PAYROLL OFFICE 80,208 89,651 9,443 93,521 13,312 217,188
PAYROLL MAINTENANCE
4,686 3,433 (1,253) 4,641 (46) 6510 - Maintenance Salaries 24,718 21,367 (3,351) 34,824 10,106 46,650
4,327 4,292 (35) 4,167 (160) 6511 - Maintenance Supervisor 21,569 21,458 (111) 12,933 (8,635) 51,500
9,013 7,725 (1,288) 8,808 (205) TOTAL PAYROLL MAINTENANCE 46,287 42,825 (3,462) 47,757 1,471 98,150

PAYROLL RELATED EXPENSES
30 87 57 87 58 6711 - State Unemployment Tax 1,002 3,926 2,924 1,426 423 5,816
2 10 8 7 4 6712 - Federal Unemployment 78 387 309 124 47 579
1,590 1,708 118 1,834 245 6713 - Employer Portion of FICA 9,129 10,134 1,005 10,227 1,098 24,123
240 248 8 259 19 6722 - Workers Compensation 1,238 1,303 64 1,338 100 3,119
1,579 1,956 377 1,890 312 6723 - Health Insurance Expense 9,102 9,777 676 9,721 619 23,466
142 142 0 124 (19) 6724 - Dental & Vision Insurance 844 711 (133) 499 (344) 1,706
(1) 181 182 0 1 6725 - Long/Short Term Disability 28 1,073 1,045 0 (28) 2,554
72 0 (72) 75 3 6726 - Life Insurance 370 0 (370) 348 (22) 0
70 152 81 142 72 6730 - 401k Contributions Expense 351 762 411 718 366 1,829
142 195 54 174 33 6108 - Payroll Fees 1,008 974 (33) 916 (91) 2,339
3,866 4,679 813 4,592 726 TOTAL PAYROLL RELATED EXP. 23,150 29,047 5,898 25,317 2,167 65,531

26,030 26,996 966 29,968 3,938 TOTAL PAYROLL 149,645 161,523 11,879 166,595 16,950 380,869

GENERAL & ADMINISTRATIVE
0 0 0 0 0 6116 - Recruiting & Hiring 0 0 0 1,240 1,240 240

Page 7