Page 34 - Preserve at Tech Investor Quarterly Report Academic Year 2021-2022 Quarter 2
P. 34
Ruston Properties I, LLC
The Preserve at Tech
Financial Analysis Report
Managed by RISE Residential
As of January 31, 2022
08/31/2021 09/30/2021 10/31/2021 11/30/2021 12/31/2021 01/31/2022 02/28/2022 03/31/2022 04/30/2022 05/31/2022 06/30/2022 07/31/2022 Total Original
Actual Actual Actual Actual Actual Actual Budget Budget Budget Budget Budget Budget Act/Bud Budget Variance
CONTROLLABLE EXPENSES
PAYROLL OFFICE
6091 - Community Assistants 1,518 1,520 1,260 1,090 960 780 2,160 2,160 2,160 2,160 2,160 2,160 20,088 25,278 (5,190)
6093 - Leasing Manager Payroll 3,949 3,949 3,949 4,008 4,067 4,066 4,034 4,034 4,034 4,034 4,034 4,034 48,194 47,984 210
6330 - General Manager 5,018 5,018 5,018 5,018 5,018 5,019 4,978 4,978 4,978 4,978 4,978 4,978 59,980 59,939 42
6335 - Leasing Salaries 2,712 2,489 1,906 1,638 1,257 1,137 1,700 1,700 1,700 1,700 2,200 2,200 22,338 23,424 (1,087)
6338 - Property Bonuses 0 0 0 1,616 (2) 0 5,200 0 0 5,200 0 0 12,014 20,800 (8,785)
6339 - Leasing Bonuses 0 0 0 0 0 200 500 500 500 500 500 500 3,200 4,700 (1,500)
TOTAL PAYROLL OFFICE 13,197 12,976 12,133 13,370 11,300 11,202 18,572 13,372 13,372 18,572 13,872 13,872 165,814 182,125 (16,310)
PAYROLL MAINTENANCE
6510 - Maintenance Salaries 0 2,601 3,376 2,891 2,986 1,649 3,034 3,034 3,034 3,034 3,534 3,534 32,704 34,366 (1,663)
6511 - Maintenance Supervisor 611 4,628 4,609 4,434 4,663 5,273 4,506 4,506 4,506 4,506 4,506 4,506 51,257 50,184 1,073
6514 - Temporary Salaries 0 0 0 0 0 0 3,467 3,467 3,467 3,467 3,467 3,467 20,800 34,667 (13,867)
TOTAL PAYROLL MAINTENANCE 611 7,229 7,985 7,325 7,649 6,922 11,007 11,007 11,007 11,007 11,507 11,507 104,761 119,217 (14,457)
PAYROLL RELATED EXPENSES
6711 - State Unemployment Tax 76 161 130 52 17 309 105 9 9 105 28 28 1,029 1,498 (469)
6712 - Federal Unemployment 20 53 39 13 6 98 34 3 3 34 9 9 320 459 (138)
6713 - Employer Portion of FICA 937 1,426 1,420 1,314 1,440 1,258 2,263 1,865 1,865 2,263 1,941 1,941 19,935 23,052 (3,119)
6722 - Workers Compensation 270 612 629 595 604 558 1,194 1,042 1,042 1,194 1,071 1,071 9,883 12,461 (2,577)
6723 - Health Insurance Expense 1,411 1,411 1,411 1,750 1,345 418 1,356 1,356 1,356 1,356 1,356 1,356 15,880 16,268 (388)
6724 - Dental & Vision Insurance 124 124 124 154 174 109 167 167 167 167 167 167 1,812 2,006 (194)
6725 - Long/Short Term Disability 12 12 12 95 105 15 240 197 197 240 206 206 1,536 2,441 (905)
6726 - Life Insurance 27 27 27 45 45 32 0 0 0 0 0 0 203 0 203
6730 - 401k Contributions Expense 25 25 25 25 36 25 103 104 104 103 103 103 782 1,243 (460)
6108 - Payroll Fees 56 56 82 116 124 122 91 90 90 91 91 91 1,098 1,084 13
TOTAL PAYROLL RELATED EXP. 2,958 3,907 3,899 4,159 3,896 2,944 5,553 4,833 4,833 5,553 4,972 4,972 52,478 60,512 (8,034)
TOTAL PAYROLL 16,766 24,112 24,017 24,854 22,845 21,068 35,132 29,212 29,212 35,132 30,351 30,351 323,053 361,854 (38,801)
GENERAL & ADMINISTRATIVE
6116 - Recruiting & Hiring 0 203 0 500 0 693 0 0 0 0 0 0 1,396 224 1,172
6228 - General Cleaning 400 400 400 400 450 450 485 485 485 485 485 485 5,410 5,820 (410)
6229 - Other General and Admin 297 297 297 297 297 297 315 315 315 315 315 315 3,672 3,780 (108)
6231 - Background Check Employee 100 371 0 0 0 0 0 0 0 0 0 0 470 190 280
6232 - Office Expense 40 0 501 33 86 310 450 100 300 250 300 250 2,622 3,535 (913)
6233 - Dues & Subscriptions 0 827 0 368 0 0 0 0 0 0 0 0 1,195 1,446 (251)
6234 - Office Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0 500 (500)
6235 - Postage 53 68 10 25 32 75 50 50 50 50 50 50 563 600 (38)
6237 - Computer & Software 700 143 1,243 1,184 3,207 1,275 1,396 1,396 1,396 1,396 1,395 1,395 16,126 16,750 (624)
Page 16