Page 10 - Oxford West Investor Quarterly Report 1.25.22
P. 10

Income Statement - Budget vs Actual                                                                                                                                     Property:Oxford West


                                                                                                                Jan 2022                                          YTD ( Aug 2021 - Jan 2022 )
                               Account                  Account Name                            Actual       Budget     $ Variance    % Variance        Actual       Budget       $ Variance     % Variance  Annual Budget
                                        6093            Leasing Manager Payroll               3,173.34      3,433.33      259.99         7.57%       18,986.75     20,599.98       1,613.23          7.83%      41,199.96
                                        6330            General Manager                       5,636.12      5,579.17      (56.95)        -1.02%      33,720.47     33,475.02        (245.45)        -0.73%      66,950.04
                                        6332            Assistant General Manager             3,894.56      3,862.50      (32.06)        -0.83%      23,310.64     23,175.00        (135.64)        -0.59%      46,350.00
                                        6335            Leasing Salaries                         0.00          0.00         0.00         0.00%        4,594.32      3,162.00       (1,432.32)      -45.30%       3,162.00
                                        6338            Property Bonuses                         0.00          0.00         0.00         0.00%           0.00       3,348.00       3,348.00        100.00%      10,044.00
                                        6339            Leasing Bonuses                       7,859.23      6,233.00    (1,626.23)      -26.09%      14,637.71     15,416.00         778.29          5.05%      27,882.00
                                                                         Total Payroll Office  21,365.38   20,824.67     (540.71)        -2.60%     101,573.61    110,476.02       8,902.41          8.06%     217,188.04
                                      Payroll Maintenance
                                        6510            Maintenance Salaries                  4,862.14      3,683.33    (1,178.81)      -32.00%      29,580.23     25,049.98       (4,530.25)      -18.08%      46,649.96
                                        6511            Maintenance Supervisor                4,326.25      4,291.67      (34.58)        -0.81%      25,894.95     25,750.02        (144.93)        -0.56%      51,500.04
                                                                   Total Payroll Maintenance  9,188.39      7,975.00    (1,213.39)      -15.21%      55,475.18     50,800.00       (4,675.18)       -9.20%      98,150.00
                                      Payroll Related Expenses
                                        6108            Payroll Fees                           138.90        194.92        56.02         28.74%       1,146.40      1,169.52         23.12           1.98%       2,339.04
                                        6711            State Unemployment Tax                1,309.25       418.18      (891.07)      -213.08%       2,311.70      4,343.98       2,032.28         46.78%       5,815.94
                                        6712            Federal Unemployment                   167.49         49.20      (118.29)      -240.43%        245.27        436.06          190.79         43.75%        579.24
                                        6713            Employer Portion of FICA              2,210.44      2,203.17       (7.27)        -0.33%      11,339.34     12,337.62         998.28          8.09%      24,123.38
                                        6722            Workers Compensation                   242.85        267.20        24.35         9.11%        1,481.33      1,569.80         88.47           5.64%       3,118.68
                                        6723            Health Insurance Expense              2,011.60      1,955.54      (56.06)        -2.87%      11,113.77     11,733.24         619.47          5.28%      23,466.48
                                        6724            Dental & Vision Insurance              125.08        142.16        17.08         12.01%        968.86        852.96         (115.90)       -13.59%       1,705.92
                                        6725            Long/Short Term Disability               7.17        233.28       226.11         96.93%         35.28       1,306.34       1,271.06         97.30%       2,554.24
                                        6726            Life Insurance                          74.50          0.00       (74.50)      -100.00%        444.24          0.00         (444.24)      -100.00%          0.00
                                        6730            401k Contributions Expense             108.10        152.35        44.25         29.04%        459.18        914.10          454.92         49.77%       1,828.20
                                                                Total Payroll Related Expenses  6,395.38    5,616.00     (779.38)       -13.88%      29,545.37     34,663.62       5,118.25         14.77%      65,531.12
                                                                             Total Payroll   36,949.15     34,415.67    (2,533.48)       -7.36%     186,594.16    195,939.64       9,345.48          4.77%     380,869.16
                                  General & Administrative

                                    6116                Recruiting & Hiring                    272.65        240.00       (32.65)       -13.60%        272.65        240.00          (32.65)       -13.60%        240.00
                                    6228                General Cleaning                        26.49       1,160.00     1,133.51        97.72%       3,922.78      6,960.00       3,037.22         43.64%      13,920.00
                                    6231                Background Check Employee                0.00          0.00         0.00         0.00%          74.25        300.00          225.75         75.25%        600.00
                                    6232                Office Expense                         765.51         50.00      (715.51)     -1,431.02%      3,645.94      1,650.00       (1,995.94)     -120.97%       2,550.00
                                    6233                Dues & Subscriptions                   250.00        250.00         0.00         0.00%         250.00       1,316.00       1,066.00         81.00%       1,316.00
                                    6235                Postage                                  0.00         50.00        50.00        100.00%        203.63        300.00          96.37          32.12%        600.00
                                    6237                Computer & Software                   2,175.98      3,154.00      978.02         31.01%      14,482.42     15,719.00       1,236.58          7.87%      27,983.00
                                    6238                Legal-Eviction / Property                0.00        500.00       500.00        100.00%          0.00        500.00          500.00        100.00%        500.00
                                    6240                Bank Charges                           741.90        300.00      (441.90)      -147.30%       4,810.47      2,300.00       (2,510.47)     -109.15%       4,100.00
                                    6241                License & Permits                       27.08          0.00       (27.08)      -100.00%       9,198.32      9,100.00         (98.32)        -1.08%       9,875.00
                                    6242                Telephone/Answering Service            450.43        425.00       (25.43)        -5.98%       2,708.63      2,550.00        (158.63)        -6.22%       5,100.00
                                    6244                Mobile Phones                          117.86         70.00       (47.86)       -68.37%        436.50        420.00          (16.50)        -3.93%        840.00
                                    6245                Professional Development               103.26        220.00       116.74         53.06%        726.08       1,320.00         593.92         44.99%       4,640.00
                                    6257                Credit Reports                           0.00        100.00       100.00        100.00%       2,508.43      2,750.00         241.57          8.78%       5,050.00
                                    6258                Uniforms                                 0.00          0.00         0.00         0.00%           0.00       1,000.00       1,000.00        100.00%       1,000.00
                                    6532                Fire and Safety Monitoring Contract      0.00         56.00        56.00        100.00%       1,081.19      1,766.00         684.81         38.78%       3,532.00
                                                                Total General & Administrative  4,931.16    6,575.00     1,643.84        25.00%      44,321.29     48,191.00       3,869.71          8.03%      81,846.00
                                  Professional Fees







                              Income Statement - Budget vs Actual 2.5 generated 02/18/2022 02:58 PM EST and data as of 02/18/2022 02:58 PM EST                                                                 Page 2 of 5
   5   6   7   8   9   10   11   12   13   14   15