Page 35 - Preserve at Tech Investor Quarterly Report Academic Year 2021-2022 Quarter 2
P. 35

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
   30   31   32   33   34   35   36   37   38   39   40