Loading...
HomeMy WebLinkAbout- - Attachment 3 - 4/3/2012ATTACHMENT 3 CITY OF COSTA MESA BUDGET TO ACTUAL ANALYSIS - GENERAL FUND EXPENDITURES BY DEPARTMENT/DIVISION AS OF DECEMBER 31, 2011 GENERALFUND Remaining Adopted Encumbered Expended Balance Percent Department/Division FY 11-12 12-31-11 12-31-11 12-31-11 Remaining City Council Salaries & Benefits $ 199,920 $ - $ 106,062 $ 93,858 46.95% Maintenance & Operations 9,725 1,316 4,294 4,115 42.31% Fixed Assets - - - - - Tota City Council $ 209,645 $ 1,316 $ 110,356 $ 97,973 46.73% CEO's Office Salaries & Benefits $ 1,026,426 $ - $ 528,852 $ 497,574 48.48% Maintenance & Operations 191,986 56,311 157,146 (21,471) -11.18% Fixed Assets 7,250 - - 7,250 100.00% Total City Manager $ 1,225,662 $ 56,311 $ 685,998 $ 483,353 39.44% City Clerk Salaries & Benefits $ 295,345 $ - $ 184,314 $ 111,031 37.59% Maintenance & Operations 24,100 335 8,823 14,942 62.00% Fixed Assets - - - - - Total City Clerk $ 319,445 $ 335 $ 193,137 $ 125,973 39.43% City Attorney Salaries & Benefits $ - $ - $ - $ - - Maintenance & Operations 803,000 - 404,981 398,019 49.57% Fixed Assets - - - - - Total City Attorney $ 803,000 $ - $ 404,981 $ 398,019 49.57% Finance Administration Salaries & Benefits $ 319,407 $ - $ 146,546 $ 172,861 54.12% Maintenance & Operations 56,674 906 25,463 30,305 53.47% Fixed Assets - - - - - Total Finance Admin. $ 376,081 $ 906 $ 172,009 $ 203,166 54.02% Financial Operations Salaries & Benefits $ 1,199,232 $ - $ 548,011 $ 651,221 54.30% Maintenance & Operations 168,150 35,362 57,237 75,551 44.93% Fixed Assets - - - - - Total Financial Operations $ 1,367,382 $ 35,362 $ 605,248 $ 726,772 53.15% Financial Planning Salaries & Benefits $ 548,114 $ - $ 134,151 $ 413,963 75.52% Maintenance & Operations 25,853 - 59,386 (33,533) -129.71% Fixed Assets - - - - - Total Financial Planning $ 573,967 $ - $ 193,537 $ 380,430 66.28% Admin. Services Admin. Salaries & Benefits $ 448,951 $ - $ 111,040 $ 337,911 75.27% Maintenance & Operations 167,333 33,883 142,823 (9,373) -5.60% Fixed Assets - - - - - Total Admin. Serv. Admin. $ 616,284 $ 33,883 $ 253,863 $ 328,538 53.31% Page 1 of 4 ATTACHMENT 3 CITY OF COSTA MESA BUDGET TO ACTUAL ANALYSIS - GENERAL FUND EXPENDITURES BY DEPARTMENT/DIVISION AS OF DECEMBER 31, 2011 GENERALFUND Remaining Adopted Encumbered Expended Balance Percent Department/Division FY 11-12 12-31-11 12-31-11 12-31-11 Remaining Human Resources Salaries & Benefits $ 472,511 $ - $ 232,476 $ 240,035 50.80% Maintenance & Operations 270,827 39 114,223 156,565 57.81% Fixed Assets - - - - - Total Personnel Division $ 743,338 $ 39 $ 346,699 $ 396,600 53.35% Central Services Salaries & Benefits $ 366,954 $ - $ 172,176 $ 194,778 53.08% Maintenance & Operations 80,647 6,242 36,627 37,778 46.84% Fixed Assets - - - - - Total Central Services $ 447,601 $ 6,242 $ 208,803 $ 232,556 51.96% Recreation Division Salaries & Benefits $ 1,886,031 $ - $ 776,093 $ 1,109,938 58.85% Maintenance & Operations 1,552,784 217,994 681,967 652,823 42.04% Fixed Assets - - - - - Total Recreation Div. $ 3,438,815 $ 217,994 $ 1,458,060 $ 1,762,761 51.26% Risk Management Salaries & Benefits $ 2,182,204 $ - $ 688,012 $ 1,494,192 68.47% Maintenance & Operations 408,081 25,883 307,619 74,579 18.28% Fixed Assets - - - - - Total Risk Management $ 2,590,285 $ 25,883 $ 995,631 $ 1,568,771 60.56% Telecommunications Div. Salaries & Benefits $ 3,112,405 $ - $ 1,243,595 $ 1,868,810 60.04% Maintenance & Operations 564,259 1,497 174,866 387,896 68.74% Fixed Assets 255,556 25,364 228,272 1,920 0.75% Total Telecommunications $ 3,932,220 $ 26,861 $ 1,646,733 $ 2,258,626 57.44% Management Info. Systems Salaries & Benefits $ 1,446,318 $ - $ 653,518 $ 792,800 54.82% Maintenance & Operations 874,203 296,575 286,044 291,584 33.35% Fixed Assets 24,880 3,932 4,356 16,592 66.69% Total Management Info. $ 2,345,401 $ 300,507 $ 943,918 $ 1,100,976 46.94% Police Administration Salaries & Benefits $ 1,752,938 $ - $ 820,541 $ 932,397 53.19% Maintenance & Operations 463,273 12,822 197,117 253,334 54.68% Fixed Assets - - - - - Total Police Admin. $ 2,216,211 $ 12,822 $ 1,017,658 $ 1,185,731 53.50% Police Technical Services Salaries & Benefits $ 5,059,023 $ - $ 2,310,375 $ 2,748,648 54.33% Maintenance & Operations 773,359 36,968 175,573 560,818 72.52% Fixed Assets - - - - - Total Police Technical $ 5,832,382 $ 36,968 $ 2,485,948 $ 3,309,466 56.74% Page 2 of 4 ATTACHMENT 3 CITY OF COSTA MESA BUDGET TO ACTUAL ANALYSIS - GENERAL FUND EXPENDITURES BY DEPARTMENT/DIVISION AS OF DECEMBER 31, 2011 GENERALFUND Remaining Adopted Encumbered Expended Balance Percent Department/Division FY 11-12 12-31-11 12-31-11 12-31-11 Remaining Police Field Operations Salaries & Benefits Maintenance & Operations Fixed Assets Total Police Field Oper. Police Support Services Salaries & Benefits Maintenance & Operations Fixed Assets Total Police Support Fire Administration Salaries & Benefits Maintenance & Operations Fixed Assets Total Fire Admin. Fire Suppression Salaries & Benefits Maintenance & Operations Fixed Assets Total Fire Suppression Fire Prevention Salaries & Benefits Maintenance & Operations Fixed Assets Total Fire Prevention Development Serv. Admin. Salaries & Benefits Maintenance & Operations Fixed Assets Total Development Serv. Planning Salaries & Benefits Maintenance & Operations Fixed Assets Total Planning Bulding Safety Salaries & Benefits Maintenance & Operations Fixed Assets Total Building Safety $ 16,815,200 $ - $ 7,713,434 $ 9,101,766 54.13% 1,161,497 3,183 442,672 715,642 61.61% 23,715 - 16,150 7,565 31.90% $ 17,976,697 $ 3,183 $ 8,156,106 $ 9,817,408 54.61% $ 7,380,358 $ - $ 3,280,392 $ 4,099,966 55.55% 1,111,911 4,008 428,255 679,648 61.12% 23,715 - 16,150 7,565 31.90% $ 8,492,269 $ 4,008 $ 3,708,647 $ 4,779,614 56.28% $ 1,243,860 $ - $ 595,185 $ 648,675 52.15% 100,792 325 37,534 62,933 62.44% $ 1,344,652 $ 325 $ 632,719 $ 711,608 52.92% $ 16,633,211 $ - $ 7,692,257 $ 8,940,954 53.75% 1,294,354 27,683 591,090 675,581 52.19% 23,715 - 16,150 7,565 31.90% $ 17,951,280 $ 27,683 $ 8,299,497 $ 9,624,100 53.61% $ 243,094 $ - $ 107,063 $ 136,031 55.96% 206,440 66,595 54,728 85,117 41.23% 58.54% 69,216 54,415 (3,631) -3.03% $ 449,534 $ 66,595 $ 161,791 $ 221,148 49.19% $ 396,411 $ - $ 182,232 $ 214,179 54.03% 353,687 53,100 210 21,803 31,087 58.54% 69,216 54,415 (3,631) -3.03% $ 1,685,921 $ 238,617 $ 736,124 $ 711,180 $ 449,511 $ 210 $ 204,035 $ 245,266 54.56% $ 803,975 $ - $ 370,623 $ 433,352 53.90% 337,800 - 16,722 321,078 95.05% $ 1,141,775 $ - $ 387,345 $ 754,430 66.08% $ 1,212,234 $ - $ 430,886 $ 781,348 64.46% 353,687 169,401 250,823 (66,537) -18.81% 120,000 69,216 54,415 (3,631) -3.03% $ 1,685,921 $ 238,617 $ 736,124 $ 711,180 42.18% Page 3 of 4 ATTACHMENT 3 CITY OF COSTA MESA BUDGET TO ACTUAL ANALYSIS - GENERAL FUND EXPENDITURES BY DEPARTMENT/DIVISION AS OF DECEMBER 31, 2011 GENERALFUND Remaining Adopted Encumbered Expended Balance Percent Department/Division FY 11-12 12-31-11 12-31-11 12-31-11 Remaining Public Services Admin. Salaries & Benefits Maintenance & Operations Fixed Assets Total Public Serv. Adm. Engineering Salaries & Benefits Maintenance & Operations Fixed Assets Total Engineering Transportation Services Salaries & Benefits Maintenance & Operations Fixed Assets Total Transportation Maintenance Services Salaries & Benefits Maintenance & Operations Fixed Assets Total Maintenance Serv. Non -Departmental Salaries & Benefits Maintenance & Operations Transfers Out Total Non -Departmental RECAP: Salaries & Benefits Maintenance & Operations Fixed Assets Transfers Out Grand Total $ 608,111 $ - $ 290,051 $ 318,060 52.30% 529,050 26,934 262,663 239,453 45.26% 431,401 98,512 303,193 29,696 6.88% $ 1,137,161 $ 26,934 $ 552,714 $ 557,513 49.03% $ 1,069,321 $ - $ 577,063 $ 492,258 46.03% 330,936 9,606 73,299 248,031 74.95% 431,401 98,512 303,193 29,696 6.88% $ 1,400,257 $ 9,606 $ 650,362 $ 740,289 52.87% $ 576,385 $ - $ 296,049 $ 280,336 48.64% 1,764,290 198,913 605,719 959,658 54.39% $ 2,340,675 $ 198,913 $ 901,768 $ 1,239,994 52.98% $ 4,138,115 $ - $ 1,710,538 $ 2,427,577 58.66% 5,250,333 633,033 1,976,576 2,640,724 50.30% $ 9,388,448 $ 633,033 $ 3,687,114 $ 5,068,301 53.98% $ (2,550,000) $ - $ - $ (2,550,000) - 6,559,831 - 4,627,173 1,932,658 29.46% 100,000 - - 100,000 100.00% $ 4,109,831 $ - $ 4,627,173 $ (517,342) -12.59% $ 68,886,054 $ - $ 31,901,535 $ 36,984,519 53.69% 25,488,275 1,866,024 12,223,246 11,399,005 44.72% 431,401 98,512 303,193 29,696 6.88% 100,000 - - 100,000 100.00% $ 94,905,730 $ 1,964,536 $ 44,427,974 $ 48,513,220 51.12% (255,556) BA 12-003 County Grant for Bi Directional 235,488 Rollovers from prior year 94,885,662 Page 4 of 4