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

Oxford West Properties I, LLLP

13 Month Trend Report
Managed by RISE Residential
As of December 31, 2021

Prior Year Rolling 12
12/31/2020 12/31/2021 11/30/2021 10/31/2021 09/30/2021 08/31/2021 07/31/2021 06/30/2021 05/31/2021 04/30/2021 03/31/2021 02/28/2021 01/31/2021 Month Total

CONTROLLABLE EXPENSES
PAYROLL OFFICE
6091 - Community Assistants 1,251 451 543 877 993 2,656 1,395 715 749 536 1,079 1,126 862 11,984
6093 - Leasing Manager Payroll 3,067 3,172 3,172 3,172 3,172 3,126 3,080 3,081 3,080 3,081 3,080 3,080 3,081 37,375
6330 - General Manager 5,465 5,633 5,633 5,633 5,633 5,552 5,471 5,470 5,471 5,470 5,471 5,471 5,470 66,378
6332 - Assistant General Manager 3,890 3,895 3,895 3,895 3,895 3,838 3,781 3,781 3,750 3,029 1,368 3,894 3,895 42,915
6335 - Leasing Salaries 1,970 0 0 0 1,432 3,162 3,067 4,200 4,781 4,430 1,970 1,869 2,132 27,042
6338 - Property Bonuses 0 0 0 0 0 0 2,775 0 0 2,112 0 0 3,250 8,138
6339 - Leasing Bonuses 925 0 637 3,191 0 2,950 5,177 0 0 2,908 0 0 3,325 18,187
TOTAL PAYROLL OFFICE 16,568 13,151 13,880 16,768 15,125 21,284 24,746 17,247 17,831 21,566 12,968 15,440 22,015 212,019

PAYROLL MAINTENANCE
6510 - Maintenance Salaries 4,641 4,686 4,644 4,174 4,696 6,518 2,833 2,826 3,030 2,551 0 106 3,504 39,569
6511 - Maintenance Supervisor 4,167 4,327 4,326 4,326 4,326 4,264 4,201 4,201 4,201 4,202 4,201 4,201 4,201 50,978
TOTAL PAYROLL MAINTENANCE 8,808 9,013 8,970 8,500 9,022 10,782 7,034 7,027 7,231 6,753 4,201 4,307 7,705 90,547
PAYROLL RELATED EXPENSES
6711 - State Unemployment Tax 87 30 163 168 283 359 184 494 744 813 432 1,375 1,423 6,466
6712 - Federal Unemployment 7 2 3 14 25 32 13 14 59 66 19 94 127 471
6713 - Employer Portion of FICA 1,834 1,590 1,886 1,577 1,967 2,109 2,313 1,759 1,782 2,050 1,183 1,868 1,626 21,708
6722 - Workers Compensation 259 240 239 229 243 287 199 202 269 130 131 184 223 2,577
6723 - Health Insurance Expense 1,890 1,579 2,182 1,781 1,579 1,983 2,032 1,983 1,660 2,307 2,152 2,322 2,479 24,037
6724 - Dental & Vision Insurance 124 142 142 127 201 231 231 182 83 201 187 0 172 1,899
6725 - Long/Short Term Disability 0 (1) (1) (11) 20 21 22 22 (32) 32 16 0 0 87
6726 - Life Insurance 75 72 72 71 73 82 81 81 24 83 63 63 72 839
6730 - 401k Contributions Expense 142 70 70 71 70 69 877 (205) (555) 154 85 172 142 1,021
6108 - Payroll Fees 174 142 132 196 270 270 197 114 115 115 174 174 174 2,070
TOTAL PAYROLL RELATED EXP. 4,592 3,866 4,888 4,223 4,731 5,443 6,149 4,646 4,149 5,951 4,442 6,252 6,438 61,175

TOTAL PAYROLL 29,968 26,030 27,738 29,491 28,878 37,509 37,929 28,920 29,211 34,270 21,611 25,999 36,158 363,741
GENERAL & ADMINISTRATIVE
6116 - Recruiting & Hiring 0 0 0 0 0 0 141 284 0 0 296 0 250 971
6228 - General Cleaning 600 1,000 1,000 600 106 1,189 1,935 1,850 1,660 2,000 1,125 600 600 13,666
6231 - Background Check Employee 0 0 0 0 0 75 135 0 0 156 0 0 0 365
6232 - Office Expense 218 450 712 207 397 1,114 611 370 88 399 430 92 1,022 5,894
6233 - Dues & Subscriptions 0 (1,066) 1,066 0 0 0 (250) 0 0 0 0 (10) 250 (10)
6235 - Postage 52 63 16 15 87 21 14 60 0 19 60 180 23 558
6237 - Computer & Software 2,302 2,471 2,135 2,247 3,223 2,230 3,199 2,001 2,004 1,939 1,902 2,593 1,877 27,823
6238 - Legal-Eviction / Property 0 0 0 0 0 0 870 0 0 0 0 0 0 870
6240 - Bank Charges 831 838 858 735 819 821 845 749 842 804 722 887 0 8,918
Page 29