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

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
   6   7   8   9   10   11   12   13   14   15   16