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

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
                                    6340                Legal Fees                               0.00          0.00         0.00         0.00%          30.50          0.00          (30.50)      -100.00%          0.00
                                                                     Total Professional Fees     0.00          0.00         0.00         0.00%          30.50          0.00          (30.50)      -100.00%          0.00
                                  Contract Services
                                    6522                Exterminating Contract                 568.72        459.00      (109.72)       -23.90%       5,242.58      4,254.00        (988.58)       -23.24%       7,008.00
                                    6525                Garbage                               2,551.00      2,400.00     (151.00)        -6.29%      18,288.75     18,800.00         511.25          2.72%      35,000.00
                                    6537                Landscaping Contract                  2,760.13      2,760.00       (0.13)        0.00%       26,039.28     27,410.00       1,370.72          5.00%      43,970.00
                                    6540                Electrical Contract                      0.00          0.00         0.00         0.00%         120.00          0.00         (120.00)      -100.00%          0.00
                                    6544                Plumbing Contract                        0.00          0.00         0.00         0.00%        1,495.00       800.00         (695.00)       -86.88%       1,400.00
                                    6548                Snow Removal                          3,452.74       800.00     (2,652.74)     -331.59%       3,452.74      2,600.00        (852.74)       -32.80%       4,100.00
                                                                         Contract Services    9,332.59      6,419.00    (2,913.59)      -45.39%      54,638.35     53,864.00        (774.35)        -1.44%      91,478.00
                                  Turnover Expense
                                    6581                Interior Paint - Contract Labor          0.00          0.00         0.00         0.00%       50,750.00     50,925.00         175.00          0.34%      50,925.00
                                    6582                Interior Paint - Supplies                0.00          0.00         0.00         0.00%        8,184.73      8,000.00        (184.73)        -2.31%       8,000.00
                                    6583                Floor-Cleaning Contract                  0.00          0.00         0.00         0.00%        6,192.98      6,120.00         (72.98)        -1.19%       6,120.00
                                    6585                Blinds/Drapes                            0.00         50.00        50.00        100.00%        589.28        500.00          (89.28)       -17.86%        800.00
                                    6586                Turn Cleaning                         2,090.00         0.00     (2,090.00)     -100.00%      38,150.00     35,520.00       (2,630.00)       -7.40%      35,520.00
                                    6588                Turn Labor                               0.00          0.00         0.00         0.00%       10,080.00     10,080.00          0.00           0.00%      10,080.00
                                                                     Total Turnover Expense   2,090.00        50.00     (2,040.00)    -4,080.00%    113,946.99    111,145.00       (2,801.99)       -2.52%     111,445.00
                                  Repairs & Maintenance
                                    6304                Vehicle Maintenance                      0.00         90.00        90.00        100.00%        318.26        420.00          101.74         24.22%        760.00
                                    6515                Cleaning Supplies                        0.00         50.00        50.00        100.00%        826.76        700.00         (126.76)       -18.11%       1,000.00
                                    6516                Keys & Locks                             0.00          0.00         0.00         0.00%         332.91        100.00         (232.91)      -232.91%        100.00
                                    6519                Interior Floor Repair/Cleaning (Non-Turn)  0.00        0.00         0.00         0.00%         649.66          0.00         (649.66)      -100.00%          0.00
                                    6556                Other Maint Repairs & Supplies         114.04        300.00       185.96         61.99%       1,747.79      2,000.00         252.21         12.61%       3,800.00
                                    6557                Appliance Parts & Supplies               0.00        250.00       250.00        100.00%        441.15       1,500.00       1,058.85         70.59%       3,000.00
                                    6558                Electrical Parts & Supplies             36.16          0.00       (36.16)      -100.00%        644.05        600.00          (44.05)        -7.34%       1,200.00
                                    6559                Plumbing Parts & Supplies              695.76        500.00      (195.76)       -39.15%       4,472.07      4,300.00        (172.07)        -4.00%       7,300.00
                                    6560                HVAC Parts & Supplies                    0.00        200.00       200.00        100.00%        618.82       1,200.00         581.18         48.43%       2,400.00
                                    6561                Pool Parts & Supplies                    0.00          0.00         0.00         0.00%         186.05        150.00          (36.05)       -24.03%        950.00
                                    6570                Equipment and Tools                      0.00          0.00         0.00         0.00%         335.59          0.00         (335.59)      -100.00%          0.00
                                    6571                Fitness Equipment Repair                 0.00          0.00         0.00         0.00%         372.75          0.00         (372.75)      -100.00%          0.00
                                    6574                Light Bulbs                             60.65        100.00        39.35         39.35%        950.99       1,250.00         299.01         23.92%       1,850.00
                                    6576                Life Safety System R&M                   0.00          0.00         0.00         0.00%        2,189.60      1,900.00        (289.60)       -15.24%       1,900.00
                                    6578                Maintenance Uniforms                    54.59        250.00       195.41         78.16%       1,062.77      1,500.00         437.23         29.15%       3,000.00
                                                                 Total Repairs & Maintenance   961.20       1,740.00      778.80         44.76%      15,149.22     15,620.00         470.78          3.01%      27,260.00
                                  Marketing & Leasing
                                    6205                Advertising/Marketing                    0.00         37.00        37.00        100.00%       4,847.54      5,222.00         374.46          7.17%      10,444.00
                                    6212                Internet Advertising                  1,137.39      1,250.00      112.61         9.01%       14,017.00     15,400.00       1,383.00          8.98%      30,900.00
                                    6214                Brochures                                0.00          0.00         0.00         0.00%         175.49          0.00         (175.49)      -100.00%          0.00
                                    6215                Signage / Flags/ Banners                 0.00          0.00         0.00         0.00%         160.00        300.00          140.00         46.67%        300.00
                                    6218                Leasing Promotional Activities         527.18        200.00      (327.18)      -163.59%       5,314.18      4,600.00        (714.18)       -15.53%       6,800.00
                                    6222                Model Expense                            0.00        150.00       150.00        100.00%          0.00        300.00          300.00        100.00%        600.00
                                    6261                Promotional Items                        0.00          0.00         0.00         0.00%        4,487.00      5,000.00         513.00         10.26%       7,000.00







                              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 3 of 5
   7   8   9   10   11   12   13   14   15   16   17