Housing Exhibits June 2020
Extracted text (via pymupdf)
8520 characters
(Exhibit 1)
Rent charged for January through March 2020 = $107,751
Average Rent per month = $35,917
OCTOBER - DECEMBER 2019
Regular Rent Charges
Rent Collections
Collection
Regular Rent Charges
Rent Collections
Collection
107,751.00
$
108,513.80
$
101%
JANUARY - MARCH 2020
101,577.00
$
102,086.56
$
101%
RENT COLLECTION SUMMARY 1st QRTR
Rent charged for July through September 2019 = $101,577
Average Rent per month = $33,859
JULY - SEPTEMBER 2019
Regular Rent Charges
Rent Collections
Collection
RENT COLLECTION SUMMARY 2nd QRTR
Rent charged for October through December 2019 = $105,093
Average Rent per month = $35,031
105,092.57
$
108,934.75
$
104%
RENT COLLECTION SUMMARY 3rd QRTR
Sep-19
(Exhibit 1)
Development
Rent Charged
Rent Collected
% of rent
collection
Lamar Homes
35,434.00
$
36,201.09
$
102.16%
Glendale Homes
47,076.00
$
46,634.00
$
99.06%
Cholla Vista
19,067.00
$
19,251.47
$
100.97%
Totals
101,577.00
$
102,086.56
$
100.50%
Dec-19
(Exhibit 1)
Development
Rent Charged
Rent Collected
% of rent
collection
Lamar Homes
35,004.57
$
36,973.94
$
105.63%
Glendale Homes
48,597.00
$
50,167.26
$
103.23%
Cholla Vista
21,491.00
$
21,793.55
$
101.41%
Totals
105,092.57
$
108,934.75
$
103.66%
Mar-20
(Exhibit 1)
Development
Rent Charged
Rent Collected
% of rent
collection
Lamar Homes
35,537.00
$
35,956.80
$
101.18%
Glendale Homes
49,322.00
$
49,580.00
$
100.52%
Cholla Vista
22,892.00
$
22,977.00
$
100.37%
Totals
107,751.00
$
108,513.80
$
100.71%
(Exhibit 2)
# of Units
July 2019
Aug 2019
Sept 2019
Oct 2019
Nov 2019
Dec 2019
Jan 2020
Feb 2020
Mar 2020
Apr 2020
May 2020
Jun 2020
Average
Lamar Homes
51
49
50
50
51
51
51
48
50
51
0
0
0
50.1
Glendale Homes
70
68
68
69
69
70
70
70
70
69
0
0
0
69.2
Cholla Vista
34
30
34
34
34
34
34
34
32
31
0
0
0
33.0
Total
155
147
152
153
154
155
155
152
152
151
0
0
0
152.3
% of Leased
95%
98%
99%
99%
100%
100%
98%
98%
97%
0%
0%
0%
98.3%
Units In Modernization
1
1
2
1
0
0
0
0
0
0
0
0
Funding Utilization
148
153
155
155
155
155
152
152
151
0
0
0
95.5%
98.7%
100.0%
100.0%
100%
100.0%
98.1%
98.1%
97.4%
0.0%
0.0%
0.0%
98.6%
Notes:
The first half of Fiscal Year 19.20 is reporting the average leased up rate for the three public housing sites to be at an average of 99.0%
To get full operating funding from HUD, the lease-up rate on the total fiscal year must average at least 97% and allows you to count the units offline for modernization.
Units Leased
(Exhibit 3)
Open Work Orders
19
Work Orders that have been open for 29 days or greater
0
Open emergency work orders ( included in the above numbers)
0
Open EH&S work orders (included in the above numbers)
0
UPCS Emergency & Regular Emergency Work orders
46
Exigent Health and Safety (EH&S) Work Orders
0
Work Order Summary
UPCS and EHS Regular Emergency Work Orders created January - March 2020
(Exhibit 3)
Received
Processed
Remaining % Processed
Jul-19
213
191
22
89.7%
Aug-19
217
196
21
90.3%
Sep-19
116
92
24
79.3%
Oct-19
149
127
22
85.2%
Nov-19
176
94
82
53.4%
Dec-19
172
157
15
91.3%
Jan-20
235
224
11
95.3%
Feb-20
134
119
15
88.8%
Mar-20
142
123
19
86.6%
Apr-20
0
0
0
#DIV/0!
May-20
0
0
0
#DIV/0!
Jun-20
0
0
0
#DIV/0!
1554
1323
231
85.1%
Work Order Detail
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
40
41
42
A
B
C
D
E
F
G
H
I
J
K
(Exhibit 4)
Section 8 - Calendar 2020
ABA
Jan-20
Feb-20
Mar-20
1st Qrtr Total
Apr-20
May-20
Jun-20
2nd Qrtr Total
QRTR
Estimated
Grand Total
Total ABA Budget Authority from HUD Two Year Tool
8,578,759
$
$702,758
$706,964
$748,457
$2,158,179
$0
$0
$0
$0
$2,158,179
Total HAP Expenses
(a)
$717,224
$724,438
$727,288
$2,168,950
$0
$0
$0
$0
$2,168,950
Total FSS Escrow
(b)
$1,539
$2,055
$1,539
$5,133
$0
$0
$0
$0
$5,133
Surplus/(Deficit) HAP
($16,005)
($19,529)
$19,630
($15,904)
$0
$0
$0
$0
($15,904)
0
0
Port - In HAP Payments
(c)
$188,276
$201,412
$195,646
$585,334
$0
$0
$0
$0
$585,334
Total amount paid to City of Glendale Landlords
a + b + c
$905,500
$925,850
$922,934
$2,754,284
$0
$0
$0
$0
$2,754,284
Units Authorized
12,648
1054
1054
1054
3162
0
0
0
0
3162
Units Leased (use VMS #)
1024
1012
1010
3046
0
0
0
0
3046
97.15%
96.02%
95.83%
96.33%
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
96.33%
MONTHLY AVG HAP
$722,983.25
PER UNIT HAP AVG
$712.06
(Exhibit 5)
Total # of
Vouchers on
the first of
the month
HUD
Allocated
Lease-Up %
New Leases
Terms/Move-
outs
Porting to
another
Housing
Authority
Applicant
Searching
Vouchers to
Expire
2020
January
1,024
1,054
97.15%
8
13
12
11
0
February
1,012
1,054
96.02%
2
14
12
9
0
March
1,010
1,054
95.83%
8
15
12
6
0
Total
3,046
3,162
96.33%
18
42
36
26
0
Average
1,015
1,054
2
4
3
2
0
(Exhibit 6)
GL Account #
Bank Acct #
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Dec-19
Jan-20
Feb-20
Mar-20
7-01-1111.11-0 Section 8 Voucher
501374
$1,515,814
$1,565,637 $1,598,159
$1,548,765
$1,615,875
$1,599,735 $1,168,717
$996,344
$1,022,071
7-01-1111.15-0 Section 8 FSS
26282771
$36,067
$37,884
$39,664
$41,507
$43,207
$47,688
$49,191
$37,972
$51,259
Bank Balance Total
$1,551,881
$1,603,521 $1,637,823
$1,590,272
$1,659,082
$1,647,423
$1,217,908
$1,034,316
$1,073,329
FSS Escrow Liability
($36,067)
($37,884)
($39,664)
($41,507)
($43,207)
($47,688)
($49,191)
($37,972)
($51,259)
Deposit received for next month Port In
$0
$0
$0
$0
$0
$0
$0
$0
$0
Current Liabilities
($288,234)
($290,116)
($290,116)
($241,651)
($105,613)
($111,805)
($44,699)
($46,904)
($44,699)
Outstanding Checks
($5,625)
($5,112)
($3,753)
($13,652)
($11,831)
($10,763)
($7,520)
($7,427)
($8,856)
- Liabilities
($329,926)
($333,112)
($333,533)
($296,811)
($160,651)
($170,256)
($101,410)
($92,302)
($104,814)
HCV Subtotal
$1,221,954
$1,270,409 $1,304,290
$1,293,461
$1,498,431
$1,477,167 $1,116,498
$942,013
$968,515
1-01-1111.11 - PIH Operating
492383
$1,213,733
$1,263,169 $1,406,081
$1,426,202
$1,488,082
$1,657,036 $1,350,729
$1,244,747
$1,361,925
1-01-1111.11 Capital Fund Program
488624
$30,727
$47,157
$48,457
$37,542
$30,819
$48,503
$42,534
$45,440
$44,215
Bank Balance Total
$1,244,460
$1,310,326 $1,454,538
$1,463,744
$1,518,901
$1,705,539
$1,393,263
$1,290,186
$1,406,139
Tenant Security Deposit Liability
($48,840)
($50,168)
($50,168)
($51,429)
($51,985)
($51,985)
($51,485)
($51,442)
($50,163)
Current Liabilities
($179,469)
($229,637)
($229,637)
($159,158)
($76,131)
($83,960)
($59,799)
($8,314)
($8,314)
Outstanding Checks
($1,340)
($15,961)
($8,553)
($16,776)
($6,590)
($9,327)
($22,994)
($9,980)
($23,810)
- Liabilities
($229,649)
($295,766)
($288,358)
($227,363)
($134,706)
($145,272)
($134,277)
($69,736)
($82,287)
PH Subtotal
$1,014,810
$1,014,560 $1,166,180
$1,236,381
$1,384,195
$1,560,267 $1,258,986
$1,220,451
$1,323,852
Actual Bank Balances
Grand Total
$2,236,765
$2,284,969 $2,470,471
$2,529,842
$2,882,627
$3,037,434 $2,375,483
$2,162,464
$2,292,367
Liabilities include the following:
Current Liabilities equals accrued short term and long term compensated absences along with deferred pension
Outstanding Checks
FSS Escrow Liability
Outstanding Checks
FSS Escrow Liability
ADMINISTRATIVE
( Exhibit 7)
Accumulative 7/2019 -03/2020
PHA
HCV
CFP
Total
Receipts
Hud Income (Admin)
$326,895
$326,895
City Income
$289,922
$289,922
Interest Income
$4,935
$4,428
$290
$9,652
Portability Income
$71,127
$71,127
Capital Fund Draws
$119,172
$119,172
Operating Subsidy
$437,100
$437,100
Rental Income
$310,501
$310,501
Fraud Recovery
$750
$640
$1,390
Lazy J Income
$14,862
$14,862
Other
$9,154
$11,125
$20,279
Total Receipts
$1,067,225
$414,214
$119,462
$1,600,901
Total Operating Expenses
$858,205
$446,229
$90,403
$1,394,837
Net Cash Flow Surplus/(Deficit)
$209,020
($32,015)
$29,059
$206,064
Notes:
The City provides the housing Division with General Funds. The annual amount is $386,563. The funding is disbursed on a
quarterly basis. The first disbursement will be transferred to the Public Housing bank account at the end of September.
Operating Expenses include Salaries, Benefits, Office Supplies, Utilities, Maintenance Materials and Contract Expenses.
The funding can't be co-mingled amongst programs. Each program must be sustainable by its own funding.