| 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% | (584.48) | ||
| Total Water Treatment: | 207,100.00 | 230,390.97 | (23,290.97) | 111.25% | 23,290.97 | ||
| Transpotation & Distribution | |||||||
| Personnel | 187,280.00 | 164,339.29 | 22,940.71 | 87.75% | (22,940.71) | ||
| Water Treatment | - | - | - | #DIV/0! | - | ||
| Materials & Supplies | 40,000.00 | 62,621.03 | (22,621.03) | 156.55% | 22,621.03 | ||
| Contract Services | 9,000.00 | 96.13 | 8,903.87 | 1.07% | (8,903.87) | ||
| Rental Expenses | - | - | - | #DIV/0! | - | ||
| Transportation/Insurance | 2,500.00 | 2,041.28 | 458.72 | 81.65% | (458.72) | ||
| Regulatory Fees | - | - | - | #DIV/0! | - | ||
| Miscellaneous | 1,500.00 | 1,477.87 | 22.13 | 98.52% | (22.13) | ||
| Total Trans & Distribution: | 240,280.00 | 230,575.60 | 9,704.40 | 95.96% | (9,704.40) | ||
| Water Customer Accounts | |||||||
| Personnel | 79,530.00 | 77,217.41 | 2,312.59 | 97.09% | (2,312.59) | ||
| Water Treatment | - | - | - | #DIV/0! | - | ||
| Materials & Supplies | 3,000.00 | 3,214.20 | (214.20) | 107.14% | 214.20 | ||
| Contract Services | 14,900.00 | 12,742.52 | 2,157.48 | 85.52% | (2,157.48) | ||
| Rental Expenses | - | - | - | #DIV/0! | - | ||
| Transportation/Insurance | - | 559.58 | (559.58) | #DIV/0! | 559.58 | ||
| Regulatory Fees | - | - | - | #DIV/0! | - | ||
| Miscellaneous | 500.00 | 526.63 | (26.63) | 105.33% | 26.63 | ||
| Total Water Customer Accounts: | 97,930.00 | 94,260.34 | 3,669.66 | 96.25% | (3,669.66) | ||
| Water Administrative | |||||||
| Personnel | 159,250.00 | 114,408.92 | 44,841.08 | 71.84% | (44,841.08) | ||
| Water Treatment | - | - | - | #DIV/0! | - | ||
| Materials & Supplies | - | (237.76) | 237.76 | #DIV/0! | (237.76) | ||
| Contract Services | 25,000.00 | 25,668.43 | (668.43) | 102.67% | 668.43 | ||
| Rental Expenses | - | - | - | #DIV/0! | - | ||
| Transportation/Insurance | 84,000.00 | 68,889.25 | 15,110.75 | 82.01% | (15,110.75) | ||
| Regulatory Fees | - | 4,418.45 | (4,418.45) | #DIV/0! | 4,418.45 | ||
| Miscellaneous | 500.00 | 12,137.92 | (11,637.92) | 2427.58% | 11,637.92 | ||
| Total Water Administrative: | 268,750.00 | 225,285.21 | 43,464.79 | 83.83% | (43,464.79) | ||
| Bond & Interest | |||||||
| Trustee Fee | |||||||
| Bond Payable | 95,000.00 | 86,471.88 | 8,528.12 | 91.02% | (8,528.12) | ||
| Truck Payment | 10,100.00 | 10,062.48 | 37.52 | 99.63% | (37.52) | ||
| Water Tower Payment | - | - | - | #DIV/0! | - | ||
| Valve Turning Machine Pay | 10,000.00 | - | 10,000.00 | 0.00% | (10,000.00) | ||
| Total Bond & Interest: | 115,100.00 | 96,534.36 | 18,565.64 | 83.87% | (18,565.64) | ||
| Capital Fund | |||||||
| Capital Fund | 40,000.00 | 26,291.70 | 13,708.30 | 65.73% | (13,708.30) | ||
| Total Capital Fund: | 40,000.00 | 26,291.70 | 13,708.30 | 65.73% | (13,708.30) | ||
| Total Expenses: | 980,360.00 | 906,411.19 | 73,948.81 | 92.46% | (73,948.81) | ||
| Income/(Loss): | 1,440.00 | 47,156.49 | 45,716.49 | 3274.76% | |||