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