| TOWN OF READING, MASSACHUSETTS | ||||||
| MUNICIPAL LIGHT DEPARTMENT | ||||||
| SCHEDULE OF ACCOUNTS RECEIVABLE | ||||||
| 5/31/08 | ||||||
| SCHEDULE B | ||||||
| PREVIOUS YEAR | CURRENT YEAR | |||||
| SCHEDULE OF ACCOUNTS RECEIVABLE | ||||||
| RESIDENTIAL AND COMMERCIAL | 3,220,692.08 | 3,700,887.75 | ||||
| ACCOUNTS RECEIVABLE - OTHER | 249,527.53 | 188,738.08 | ||||
| ACCOUNTS RECEIVABLE - LIENS | 48,170.97 | 80,148.33 | ||||
| ACCOUNTS RECEIVABLE - EMPLOYEE ADVANCES | 1,067.16 | 1,067.16 | ||||
| SALES DISCOUNT LIABILITY | (241,802.14) | (194,649.71) | ||||
| RESERVE FOR UNCOLLECTIBLE ACCOUNTS | (196,100.63) | (179,005.66) | ||||
| TOTAL ACCOUNTS RECEIVABLE BILLED | 3,081,554.97 | 3,597,185.95 | ||||
| UNBILLED ACCOUNTS RECEIVABLE | 3,126,031.41 | 2,714,176.30 | ||||
| TOTAL ACCOUNTS RECEIVABLE, NET | 6,207,586.38 | 6,311,362.25 | ||||
| SCHEDULE OF PREPAYMENTS | ||||||
| PREPAID INSURANCE | 515,774.76 | 538,118.49 | ||||
| PREPAYMENT PURCHASED POWER | (182,828.65) | (316,701.14) | ||||
| PREPAYMENT PASNY | 193,297.11 | 194,170.65 | ||||
| TOTAL PREPAYMENT | 526,243.22 | 415,588.00 | ||||
| * ACCOUNTS RECEIVABLE AGING MAY 2008: | ||||||
| RESIDENTIAL AND COMMERCIAL | 3,700,887.75 | |||||
| LESS: SALES DISCOUNT LIABILITY | (194,649.71) | |||||
| GENERAL LEDGER BALANCE | 3,506,238.04 | |||||
| CURRENT | 2,830,466.95 | 80.72% | ||||
| 30 DAYS | 318,688.42 | 9.09% | ||||
| 60 DAYS | 154,499.33 | 4.41% | ||||
| 90 DAYS | 84,217.32 | 2.40% | ||||
| OVER 90 DAYS | 118,366.02 | 3.38% | ||||
| TOTAL | 3,506,238.04 | 100.00% | ||||