| 2006 City of Brazil Budget Analysis | 100.00% | ||||||
| Water (601) | |||||||
| 12 | December | ||||||
| 2006 Council Approved Budget | 2006 Actual | Budget Balance | % | ||||
| Revenue | |||||||
| Interest Income | 600.00 | 725.72 | 125.72 | 120.95% | 125.72 | ||
| Non-Utility Income | 200.00 | (161.92) | (361.92) | -80.96% | (361.92) | ||
| Extraordinary Income | 9,640.00 | 9,640.00 | #DIV/0! | 9,640.00 | |||
| Unmetered-Residential | - | #DIV/0! | - | ||||
| Metered-Residential | 700,000.00 | 666,931.95 | (33,068.05) | 95.28% | (33,068.05) | ||
| Metered-Commercial | 125,000.00 | 126,414.55 | 1,414.55 | 101.13% | 1,414.55 | ||
| Sales for Resale-Center Point | 20,000.00 | 18,237.28 | (1,762.72) | 91.19% | (1,762.72) | ||
| Sales for Resale-Harmony | 20,000.00 | 19,033.82 | (966.18) | 95.17% | (966.18) | ||
| Sales for Resale-Carbon | 27,000.00 | 25,875.36 | (1,124.64) | 95.83% | (1,124.64) | ||
| Sales for Resale-Knightsville | 20,000.00 | 17,546.65 | (2,453.35) | 87.73% | (2,453.35) | ||
| Penalties | 23,000.00 | 20,918.77 | (2,081.23) | 90.95% | (2,081.23) | ||
| Miscellaneous Service | 1,500.00 | 1,965.00 | 465.00 | 131.00% | 465.00 | ||
| Reconnect Fees | 12,000.00 | 11,925.00 | (75.00) | 99.38% | (75.00) | ||
| Cleaning/Inspection | 1,500.00 | 1,460.00 | (40.00) | 97.33% | (40.00) | ||
| Tap Fees | 10,000.00 | 11,452.00 | 1,452.00 | 114.52% | 1,452.00 | ||
| Water & Lawn Meter | 3,000.00 | 4,958.00 | 1,958.00 | 165.27% | 1,958.00 | ||
| Rents from Water Pro | 1,090.00 | 1,090.00 | #DIV/0! | 1,090.00 | |||
| Other Water Revenues | 1,000.00 | 276.94 | (723.06) | 27.69% | (723.06) | ||
| Trash Collection Fee | 17,000.00 | 15,278.56 | (1,721.44) | 89.87% | (1,721.44) | ||
| Total Revenue: | 981,800.00 | 953,567.68 | (28,232.32) | 97.12% | (28,232.32) | ||
| Expenses | |||||||
| Source of Supply (Wells) | |||||||
| Personnel | - | - | - | #DIV/0! | - | ||
| Water Treatment | 1,000.00 | 1,963.14 | (963.14) | 196.31% | 963.14 | ||
| Materials & Supplies | 500.00 | 609.87 | (109.87) | 121.97% | 109.87 | ||
| Contract Services | 9,200.00 | 500.00 | 8,700.00 | 5.43% | (8,700.00) | ||
| Rental Expenses | - | - | - | #DIV/0! | - | ||
| Transportation/Insurance | - | - | - | #DIV/0! | - | ||
| Regulatory Fees | - | - | - | #DIV/0! | - | ||
| Miscellaneous | 500.00 | - | 500.00 | 0.00% | (500.00) | ||
| Total Source of Supply: | 11,200.00 | 3,073.01 | 8,126.99 | 27.44% | (8,126.99) | ||
| Water Treatment | |||||||
| Personnel | 123,700.00 | 118,901.81 | 4,798.19 | 96.12% | (4,798.19) | ||
| Water Treatment | 67,000.00 | 79,907.38 | (12,907.38) | 119.26% | 12,907.38 | ||
| Materials & Supplies | 3,500.00 | 12,509.19 | (9,009.19) | 357.41% | 9,009.19 | ||
| Contract Services | 1,000.00 | 9,393.45 | (8,393.45) | 939.35% | 8,393.45 | ||
| Rental Expenses | - | - | - | #DIV/0! | - | ||
| Transportation/Insurance | 500.00 | (1,136.38) | 1,636.38 | -227.28% | (1,636.38) | ||
| Regulatory Fees | - | - | - | #DIV/0! | - | ||
| Miscellaneous | 11,400.00 | 10,815.52 | 584.48 | 94.87% | &nb | ||