|
2011 BUDGET VS. ACTUAL EXPENDITURE SUMMARY WORKSHEET
<br />PUBLIC WORKS DEPARTMENT
<br />CITY OF MOUNDS VIEW
<br />As of September 30, 2011 % of year completed:75.0%
<br />Budget % YTD Budget
<br />Department/Expenditure Amount July August September Q3 YTD Budget Balance
<br />Parks (100-4360)363,464$ 37,859$ 24,740$ 25,275$ 87,874$ 224,857$ 61.9%138,607$
<br />Personnel Services (0000-0999) 201,951$ 19,331$ 18,874$ 15,458$ 53,663$ 149,215$ 73.9% 52,736$
<br />Materials & Supplies (1000-2999) 36,265$ 6,103$ 1,963$ 4,165$ 12,231$ 27,936$ 77.0% 8,329$
<br />Contractual Services (3000-5999) 59,248$ 11,785$ 3,903$ 5,651$ 21,339$ 47,064$ 79.4% 12,184$
<br />Capital Outlay (7000-7999)66,000$ 641$ -$ -$ 641$ 641$ 1.0%65,359$
<br />Forestry (100-4380)55,000$ 5,078$ 6,252$ 6,144$ 17,473$ 32,451$ 59.0%22,549$
<br />Personnel Services (0000-0999) -$ -$ -$ -$ -$ -$ -$
<br />Materials & Supplies (1000-2999) 3,000$ 53$ -$ -$ 53$ 796$ 26.5% 2,204$
<br />Contractual Services (3000-5999) 52,000$ 5,025$ 6,252$ 6,144$ 17,420$ 31,655$ 60.9% 20,345$
<br />Capital Outlay (7000-7999)-$ -$ -$ -$ -$ -$ -$
<br />Public Works Administration (100-4410)123,715$ 9,194$ 9,188$ 9,531$ 27,912$ 85,795$ 69.3%37,920$
<br />Personnel Services (0000-0999) 120,652$ 9,194$ 9,188$ 9,432$ 27,813$ 85,031$ 70.5% 35,621$
<br />Materials & Supplies (1000-2999) 600$ -$ -$ -$ -$ 81$ 13.6% 519$
<br />Contractual Services (3000-5999) 2,463$ -$ -$ 99$ 99$ 683$ 27.7% 1,780$
<br />Capital Outlay (7000-7999)-$ -$ -$ -$ -$ -$ -$
<br />Buildings & Grounds Maintenance (100-4460)133,854$ 8,606$ 6,494$ 11,482$ 26,582$ 95,729$ 71.5%38,125$
<br />Personnel Services (0000-0999) 17,390$ 1,229$ 1,242$ 1,338$ 3,810$ 11,862$ 68.2% 5,528$
<br />Materials & Supplies (1000-2999) 7,710$ 1,089$ 370$ 1,461$ 2,920$ 3,880$ 50.3% 3,830$
<br />Contractual Services (3000-5999) 108,754$ 6,288$ 4,882$ 8,682$ 19,851$ 78,636$ 72.3% 30,118$
<br />Capital Outlay (7000-7999)-$ -$ -$ -$ -$ 1,352$ (1,352)$
<br />Vehicle & Equipment Maintenance (100-4465)86,259$ 6,751$ 6,591$ 6,206$ 19,549$ 65,134$ 75.5%21,125$
<br />Personnel Services (0000-0999) 41,029$ 3,006$ 3,006$ 3,124$ 9,135$ 28,805$ 70.2% 12,224$
<br />Materials & Supplies (1000-2999) 26,410$ 2,090$ 2,723$ 2,982$ 7,794$ 21,593$ 81.8% 4,817$
<br />Contractual Services (3000-5999) 18,820$ 1,656$ 863$ 101$ 2,620$ 14,735$ 78.3% 4,085$
<br />Capital Outlay (7000-7999)-$ -$ -$ -$ -$ -$ -$
<br />Street Pavement Management (100-4470)380,501$ 16,060$ 27,034$ 14,464$ 57,558$ 146,742$ 38.6%233,759$
<br />Personnel Services (0000-0999) 133,108$ 11,297$ 10,750$ 10,728$ 32,776$ 96,766$ 72.7% 36,342$
<br />Materials & Supplies (1000-2999) 36,750$ 3,837$ 12,882$ 2,410$ 19,129$ 33,708$ 91.7% 3,042$
<br />Contractual Services (3000-5999) 19,643$ 926$ 3,402$ 1,325$ 5,653$ 11,993$ 61.1% 7,650$
<br />Capital Outlay (7000-7999)191,000$ -$ -$ -$ -$ 4,275$ 2.2%186,725$
<br />Street Snow & Ice Control (100-4472)122,712$ 6,176$ 5,481$ 6,264$ 17,921$ 78,187$ 63.7%44,525$
<br />Personnel Services (0000-0999) 82,729$ 6,044$ 5,395$ 6,204$ 17,643$ 60,180$ 72.7% 22,549$
<br />Materials & Supplies (1000-2999) 37,830$ 131$ 86$ 61$ 278$ 16,876$ 44.6% 20,954$
<br />Contractual Services (3000-5999) 2,153$ -$ -$ -$ -$ 1,132$ 52.6% 1,021$
<br />Capital Outlay (7000-7999)-$ -$ -$ -$ -$ -$ -$
<br />Street Sign Maintenance (100-4475)36,594$ 2,648$ 2,419$ 2,777$ 7,843$ 23,201$ 63.4%13,393$
<br />Personnel Services (0000-0999) 28,630$ 2,219$ 2,220$ 2,540$ 6,980$ 21,249$ 74.2% 7,381$
<br />Materials & Supplies (1000-2999) 5,214$ 255$ 31$ 71$ 357$ 661$ 12.7% 4,553$
<br />Contractual Services (3000-5999) 2,750$ 174$ 167$ 165$ 507$ 1,291$ 46.9% 1,459$
<br />Capital Outlay (7000-7999)-$ -$ -$ -$ -$ -$ -$
<br />Drinking Water - Billing Services (700-4820)410,150$ 11,567$ 3,324$ 3,563$ 18,455$ 273,032$ 66.6%137,118$
<br />Personnel Services (0000-0999) 42,592$ 3,170$ 3,170$ 3,183$ 9,523$ 29,458$ 69.2% 13,134$
<br />Materials & Supplies (1000-2999) 50$ 717$ -$ 57$ 774$ 3,509$ 7018.0% (3,459)$
<br />Contractual Services (3000-5999) 15,553$ -$ 155$ 323$ 478$ 9,826$ 63.2% 5,727$
<br />Capital Outlay (7000-7999) -$ 7,680$ -$ -$ 7,680$ 7,680$ (7,680)$
<br />Debt Service (8000-8999) 231,450$ -$ -$ -$ -$ 222,559$ 96.2% 8,891$
<br />Other (9000-9999)120,505$ -$ -$ -$ -$ -$ 0.0%120,505$
<br />Drinking Water - Infra. & Equip. Maint. (700-4823)1,888,996$ 37,316$ 30,818$ 41,843$ 109,978$ 325,299$ 17.2%1,563,697$
<br />Personnel Services (0000-0999) 259,485$ 19,941$ 20,556$ 20,967$ 61,464$ 180,900$ 69.7% 78,585$
<br />Materials & Supplies (1000-2999) 35,148$ 1,624$ 1,176$ 4,473$ 7,273$ 17,792$ 50.6% 17,356$
<br />Contractual Services (3000-5999) 128,163$ 6,033$ 8,816$ 16,231$ 31,079$ 91,529$ 71.4% 36,634$
<br />Capital Outlay (7000-7999) 1,466,200$ 9,718$ 270$ 173$ 10,161$ 35,077$ 2.4% 1,431,123$
<br />Actual Amounts
<br /> 2011 BUDGET VS. ACTUAL EXPENDITURE SUMMARY REPORT 1/3
|