Page 23 - Oxford West Investor Quarterly Report 1.25.22
P. 23
Forecasted Income Statement Property:Oxford West
Aug 2021 Sep 2021 Oct 2021 Nov 2021 Dec 2021 Jan 2022 Feb 2022 Mar 2022 Apr 2022 May 2022 Jun 2022 Jul 2022 Total Annual
Account Account Name Actual Actual Actual Actual Actual Actual Budget Budget Budget Budget Budget Budget Forecast Budget $ Variance % Variance
6544 Plumbing Contract 605.00 475.00 0.00 0.00 415.00 0.00 300.00 0.00 0.00 300.00 0.00 0.00 2,095.00 1,400.00 (695.00) -49.64%
6548 Snow Removal 0.00 0.00 0.00 0.00 0.00 3,452.74 1,500.00 0.00 0.00 0.00 0.00 0.00 4,952.74 4,100.00 (852.74) -20.80%
Contract Services 12,173.58 14,201.91 5,378.58 6,980.96 6,570.73 9,332.59 7,419.00 5,619.00 5,619.00 5,919.00 7,419.00 5,619.00 92,252.35 91,478.00 (774.35) -0.85%
Turnover Expense
6581 Interior Paint - Contract Labor 50,750.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 50,750.00 50,925.00 175.00 0.34%
6582 Interior Paint - Supplies 8,022.61 81.27 80.85 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8,184.73 8,000.00 (184.73) -2.31%
6583 Floor-Cleaning Contract 6,129.08 63.90 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6,192.98 6,120.00 (72.98) -1.19%
6585 Blinds/Drapes 252.91 26.86 309.51 0.00 0.00 0.00 50.00 50.00 50.00 50.00 50.00 50.00 889.28 800.00 (89.28) -11.16%
6586 Turn Cleaning 35,470.00 0.00 0.00 0.00 590.00 2,090.00 0.00 0.00 0.00 0.00 0.00 0.00 38,150.00 35,520.00 (2,630.00) -7.40%
6588 Turn Labor 10,080.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,080.00 10,080.00 0.00 0.00%
Total Turnover Expense 110,704.60 172.03 390.36 0.00 590.00 2,090.00 50.00 50.00 50.00 50.00 50.00 50.00 114,246.99 111,445.00 (2,801.99) -2.51%
Repairs & Maintenance
6304 Vehicle Maintenance 114.15 166.15 0.00 0.00 37.96 0.00 40.00 40.00 90.00 40.00 40.00 90.00 658.26 760.00 101.74 13.39%
6515 Cleaning Supplies 393.51 156.93 0.00 276.32 0.00 0.00 50.00 50.00 50.00 50.00 50.00 50.00 1,126.76 1,000.00 (126.76) -12.68%
6516 Keys & Locks 82.48 161.23 0.00 89.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 332.91 100.00 (232.91) -232.91%
Interior Floor Repair/Cleaning (Non-
6519 0.00 0.00 0.00 649.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 649.66 0.00 (649.66) -100.00%
Turn)
6556 Other Maint Repairs & Supplies 510.86 354.42 365.18 159.50 243.79 114.04 300.00 300.00 300.00 300.00 300.00 300.00 3,547.79 3,800.00 252.21 6.64%
6557 Appliance Parts & Supplies 0.00 228.14 0.00 0.00 213.01 0.00 250.00 250.00 250.00 250.00 250.00 250.00 1,941.15 3,000.00 1,058.85 35.30%
6558 Electrical Parts & Supplies 126.46 255.09 64.27 135.46 26.61 36.16 200.00 0.00 200.00 0.00 200.00 0.00 1,244.05 1,200.00 (44.05) -3.67%
6559 Plumbing Parts & Supplies 1,248.27 726.87 707.56 825.31 268.30 695.76 500.00 500.00 500.00 500.00 500.00 500.00 7,472.07 7,300.00 (172.07) -2.36%
6560 HVAC Parts & Supplies 186.93 0.00 152.68 143.39 135.82 0.00 200.00 200.00 200.00 200.00 200.00 200.00 1,818.82 2,400.00 581.18 24.22%
6561 Pool Parts & Supplies 186.05 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 500.00 150.00 150.00 986.05 950.00 (36.05) -3.79%
6570 Equipment and Tools 27.99 253.31 54.29 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 335.59 0.00 (335.59) -100.00%
6571 Fitness Equipment Repair 0.00 0.00 0.00 372.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 372.75 0.00 (372.75) -100.00%
6574 Light Bulbs 423.28 467.06 0.00 0.00 0.00 60.65 100.00 100.00 100.00 100.00 100.00 100.00 1,550.99 1,850.00 299.01 16.16%
6576 Life Safety System R&M 286.18 1,903.42 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,189.60 1,900.00 (289.60) -15.24%
6578 Maintenance Uniforms 218.36 218.36 218.36 134.31 218.79 54.59 250.00 250.00 250.00 250.00 250.00 250.00 2,562.77 3,000.00 437.23 14.57%
Total Repairs & Maintenance 3,804.52 4,890.98 1,562.34 2,785.90 1,144.28 961.20 1,890.00 1,690.00 1,940.00 2,190.00 2,040.00 1,890.00 26,789.22 27,260.00 470.78 1.73%
Marketing & Leasing
6205 Advertising/Marketing 5,176.29 376.30 100.00 0.00 (805.05) 0.00 37.00 5,037.00 37.00 37.00 37.00 37.00 10,069.54 10,444.00 374.46 3.59%
6212 Internet Advertising 5,588.15 4,772.45 837.95 582.55 1,098.51 1,137.39 2,250.00 3,250.00 4,250.00 3,250.00 1,250.00 1,250.00 29,517.00 30,900.00 1,383.00 4.48%
6214 Brochures 0.00 0.00 (0.65) 0.00 176.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 175.49 0.00 (175.49) -100.00%
6215 Signage / Flags/ Banners 0.00 0.00 160.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 160.00 300.00 140.00 46.67%
6218 Leasing Promotional Activities 1,150.32 471.40 2,317.60 377.03 470.65 527.18 400.00 400.00 400.00 600.00 200.00 200.00 7,514.18 6,800.00 (714.18) -10.50%
6222 Model Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 150.00 0.00 0.00 150.00 300.00 600.00 300.00 50.00%
6261 Promotional Items 4,487.00 0.00 0.00 0.00 0.00 0.00 2,000.00 0.00 0.00 0.00 0.00 0.00 6,487.00 7,000.00 513.00 7.33%
6283 Gift Cards and Leasing Incentives 15,000.00 0.00 0.00 0.00 (5,000.00) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10,000.00 10,000.00 0.00 0.00%
Total Marketing & Leasing 31,401.76 5,620.15 3,414.90 959.58 (4,059.75) 1,664.57 4,687.00 8,687.00 4,837.00 3,887.00 1,487.00 1,637.00 64,223.21 66,044.00 1,820.79 2.76%
Common Area Utilities
6450 C/A Electricity 1,855.60 1,775.64 1,473.82 1,536.21 1,834.82 1,840.02 2,015.85 2,005.90 2,003.91 2,005.90 2,005.90 2,003.91 22,357.48 20,175.36 (2,182.12) -10.82%
6452 C/A Natural Gas 0.00 0.00 0.00 12.22 0.00 971.57 0.00 0.00 0.00 0.00 0.00 0.00 983.79 0.00 (983.79) -100.00%
Total Common Area Utilities 1,855.60 1,775.64 1,473.82 1,548.43 1,834.82 2,811.59 2,015.85 2,005.90 2,003.91 2,005.90 2,005.90 2,003.91 23,341.27 20,175.36 (3,165.91) -15.69%
Unit Utilities
6460 Electricity Vacant Units 3,180.21 2,644.99 5,377.03 1,888.75 2,628.55 6,218.59 2,677.50 2,601.00 1,530.00 2,754.00 1,530.00 1,530.00 34,560.62 30,504.80 (4,055.82) -13.30%
6461 Electricity Occupied Units 15,530.73 15,609.72 10,568.71 10,619.88 26,759.93 34,004.98 20,640.00 22,308.00 14,157.00 13,330.00 12,040.00 18,060.00 213,628.95 198,041.00 (15,587.95) -7.87%
6462 Cable 4,817.92 4,817.92 4,818.00 4,817.97 3,693.57 4,817.97 4,818.00 4,818.00 4,818.00 4,818.00 4,818.00 4,818.00 56,691.35 57,816.00 1,124.65 1.95%
6463 Water/Sewer Units 11,888.52 10,973.01 15,767.23 12,500.00 13,771.45 8,485.00 9,120.00 14,196.00 12,675.00 12,168.00 11,520.00 10,647.00 143,711.21 138,589.00 (5,122.21) -3.70%
6464 Natural Gas 1,382.23 1,702.34 530.59 1,874.57 7,822.35 6,760.78 6,100.00 4,500.00 3,000.00 3,000.00 1,000.00 1,500.00 39,172.86 40,550.00 1,377.14 3.40%
Forecasted Income Statement 1.6 generated 02/18/2022 03:23 PM EST and data as of 02/18/2022 03:23 PM EST Page 3 of 5