Loading...
March 2023 - Council Expenditure ReportAs of  4/14/2023 50.00 % Year Complete Executive Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 30,378.07                   145,551.09                 446,090.00                 32.63% 41,183.31                   208,266.81                 (10,805.24)                            (62,715.72)                  Benefits 4,750.20                      22,091.95                   73,359.00                   30.11% 5,999.66                      32,587.93                   (1,249.46)                               (10,495.98)                  Operations 16,971.83                   145,542.03                 266,498.00                 54.61% 11,928.41                   82,622.13                   5,043.42                                62,919.90                   Capital Outlay ‐                                 ‐                                49,500.00                   0.00% 3,814.53                      23,814.53                   (3,814.53)                               (23,814.53)                  Total 52,100.10                   313,185.07                 835,447.00                 37.49% 62,925.91                   347,291.40                 (10,825.81)                            (34,106.33)                  Legislative Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 8,958.70                      56,669.90                   125,000.00                 45.34% 10,417.04                   62,502.24                   (1,458.34)                               (5,832.34)                    Benefits 669.80                         4,282.31                      10,474.00                   40.89% 735.46                         4,680.65                      (65.66)                                    (398.34)                       Operations 28.00                           471.15                         30,100.00                   1.57% 750.00                         1,722.91                      (722.00)                                  (1,251.76)                    Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 9,656.50                      61,423.36                   165,574.00                 37.10% 11,902.50                   68,905.80                   (2,246.00)                               (7,482.44)                    Finance Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 35,094.39                   230,553.82                 460,940.00                 50.02% 33,373.93                   202,723.49                 1,720.46                                27,830.33                   Benefits 6,576.72                      45,331.32                   90,693.00                   49.98% 5,971.32                      40,099.41                   605.40                                   5,231.91                     Operations 37,994.36                   93,894.47                   238,055.00                 39.44% 47,778.53                   166,980.68                 (9,784.17)                               (73,086.21)                  Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 79,665.47                   369,779.61                 789,688.00                 46.83% 87,123.78                   409,803.58                 (7,458.31)                               (40,023.97)                  City Clerk Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 11,670.44                   75,576.38                   147,626.00                 51.19% 10,667.55                   64,046.86                   1,002.89                                11,529.52                   Benefits 2,178.61                      14,027.25                   28,627.00                   49.00% 1,892.45                      11,792.53                   286.16                                   2,234.72                     Operations 10,772.73                   57,748.92                   140,640.00                 41.06% 10,457.49                   52,358.20                   315.24                                   5,390.72                     Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 24,621.78                   147,352.55                 316,893.00                 46.50% 23,017.49                   128,197.59                 1,604.29                                19,154.96                   HR Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 28,028.87                   184,762.47                 362,688.00                 50.94% 25,355.64                   152,459.39                 2,673.23                                32,303.08                   Benefits 5,373.94                      35,907.08                   246,649.00                 14.56% 4,742.42                      29,878.00                   631.52                                   6,029.08                     Operations 24,863.67                   62,972.53                   197,600.00                 31.87% 9,235.11                      37,037.48                   15,628.56                              25,935.05                   Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 58,266.48                   283,642.08                 806,937.00                 35.15% 39,333.17                   219,374.87                 18,933.31                              64,267.21                   IT Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 17,652.71                   111,287.80                 232,474.00                 47.87% 17,952.79                   111,669.51                 (300.08)                                  (381.71)                       Benefits 3,187.94                      20,675.04                   43,377.00                   47.66% 3,085.05                      20,046.51                   102.89                                   628.53                         Operations 58,281.32                   861,725.18                 2,008,494.00              42.90% 149,479.84                 1,073,640.81              (91,198.52)                            (211,915.63)               Capital Outlay ‐                                50,863.00                   30,000.00                   0.00%‐                                61,973.00                    ‐                                          (11,110.00)                  Total 79,121.97                   1,044,551.02              2,314,345.00              45.13% 170,517.68                 1,267,329.83              (91,395.71)                            (222,778.81)               Vehicle Maint. Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 10,928.37                   87,824.01                   238,347.00                 36.85% 17,129.16                   108,500.45                 (6,200.79)                               (20,676.44)                  Benefits 2,058.36                      23,525.54                   53,131.00                   44.28% 2,993.12                      29,397.64                   (934.76)                                  (5,872.10)                    Operations 758.75                         31,535.96                   97,050.00                   32.49% 5,136.63                      21,971.88                   (4,377.88)                               9,564.08                     Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 13,745.48                   142,885.51                 388,528.00                 36.78% 25,258.91                   159,869.97                 (11,513.43)                            (16,984.46)                  City of Prattville March 2023 Unaudited Expenditures By Department Engineering Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 49,825.30                   327,481.27                 697,081.00                 46.98% 45,040.41                   269,971.80                 4,784.89                                57,509.47                   Benefits 9,644.12                      95,513.04                   184,712.00                 51.71% 9,425.95                      79,395.16                   218.17                                   16,117.88                   Operations 68,827.31                   436,266.00                 1,315,053.00              33.17% 61,408.27                   349,773.86                 7,419.04                                86,492.14                   Capital Outlay ‐                                587.95                         521,850.00                 0.11%‐                                 ‐                                 ‐                                          587.95                         Total 128,296.73                 859,848.26                 2,718,696.00              31.63% 115,874.63                 699,140.82                 12,422.10                              160,707.44                 Planning Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 27,936.64                   193,865.38                 450,630.00                 43.02% 33,099.68                   201,798.49                 (5,163.04)                               (7,933.11)                    Benefits 5,489.85                      36,660.63                   90,406.00                   40.55% 6,185.73                      39,816.34                   (695.88)                                  (3,155.71)                    Operations 13,473.51                   57,176.59                   249,000.00                 22.96% 7,779.13                      39,787.86                   5,694.38                                17,388.73                   Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 46,900.00                   287,702.60                 790,036.00                 36.42% 47,064.54                   281,402.69                 (164.54)                                  6,299.91                     Urban Management Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 84,077.89                   497,774.45                 1,151,880.00              43.21% 81,049.17                   510,399.23                 3,028.72                                (12,624.78)                  Benefits 15,680.47                   121,980.21                 257,288.00                 47.41% 16,433.45                   125,253.43                 (752.98)                                  (3,273.22)                    Operations 48,012.94                   302,754.98                 623,250.00                 48.58% 56,312.76                   248,406.18                 (8,299.82)                               54,348.80                   Capital Outlay ‐                                 ‐                                50,000.00                   0.00% 59,952.00                   70,330.25                   (59,952.00)                            (70,330.25)                  Total 147,771.30                 922,509.64                 2,082,418.00              44.30% 213,747.38                 954,389.09                 (65,976.08)                            (31,879.45)                  Facilities Maintenance Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 29,931.92                   194,242.82                 400,482.00                 48.50% 29,832.88                   183,621.20                 99.04                                      10,621.62                   Benefits 5,262.07                      48,034.34                   87,527.00                   54.88% 5,038.22                      46,768.69                   223.85                                   1,265.65                     Operations 39,668.16                   160,977.04                 261,500.00                 61.56% 7,440.14                      81,641.79                   32,228.02                              79,335.25                   Capital Outlay ‐                                 ‐                                670,000.00                 0.00%‐                                 ‐                                 ‐                                           ‐                               Total 74,862.15                   403,254.20                 1,419,509.00              28.41% 42,311.24                   312,031.68                 32,550.91                              91,222.52                   Public Works Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 25,349.78                   180,509.81                 375,779.00                 48.04% 27,287.24                   166,532.18                 (1,937.46)                               13,977.63                   Benefits 4,911.01                      40,673.09                   80,973.00                   50.23% 5,016.04                      38,603.23                   (105.03)                                  2,069.86                     Operations 9,572.54                      154,824.34                 255,968.00                 60.49% 14,766.60                   149,153.10                 (5,194.06)                               5,671.24                     Capital Outlay ‐                                50,993.65                   300,000.00                 17.00%‐                                 ‐                                 ‐                                          50,993.65                   Total 39,833.33                   427,000.89                 1,012,720.00              42.16% 47,069.88                   354,288.51                 (7,236.55)                               72,712.38                   Police Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 431,907.65                 2,917,136.68              6,654,061.00              43.84% 463,666.73                 2,878,156.37              (31,759.08)                            38,980.31                   Benefits 80,277.17                   708,904.70                 1,460,253.00              48.55% 82,569.76                   723,414.49                 (2,292.59)                               (14,509.79)                  Operations 99,899.94                   1,044,274.17              1,656,828.00              63.03% 105,976.63                 876,645.69                 (6,076.69)                               167,628.48                 Capital Outlay ‐                                 ‐                                549,367.00                 0.00% 66,527.92                   66,527.92                   (66,527.92)                            (66,527.92)                  Total 612,084.76                 4,670,315.55              10,320,509.00           45.25% 718,741.04                 4,544,744.47              (106,656.28)                          125,571.08                 Fire Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 445,645.02                 3,057,897.24              6,152,966.00              49.70% 416,381.74                 2,697,698.92              29,263.28                              360,198.32                 Benefits 85,266.74                   754,792.10                 1,387,748.00              54.39% 79,784.09                   716,002.17                 5,482.65                                38,789.93                   Operations 89,117.26                   565,007.81                 1,237,156.00              45.67% 85,785.82                   426,801.96                 3,331.44                                138,205.85                 Capital Outlay ‐                                1,505.00                      384,371.00                 0.39% 131,011.85                 198,915.37                 (131,011.85)                          (197,410.37)               Total 620,029.02                 4,379,202.15              9,162,241.00              47.80% 712,963.50                 4,039,418.42              (92,934.48)                            339,783.73                 Building Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 20,199.37                   120,098.81                 263,338.00                 45.61% 20,552.00                   127,934.58                 (352.63)                                  (7,835.77)                    Benefits 3,833.63                      29,938.20                   60,846.00                   49.20% 3,787.30                      31,386.87                   46.33                                      (1,448.67)                    Operations 3,410.64                      22,287.73                   62,450.00                   35.69% 1,829.23                      16,141.11                   1,581.41                                6,146.62                     Capital Outlay ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Total 27,443.64                   172,324.74                 386,634.00                 44.57% 26,168.53                   175,462.56                 1,275.11                                (3,137.82)                    Parks & Recreation Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 96,789.55                   615,116.27                 1,238,226.00              49.68% 91,974.86                   522,197.40                 4,814.69                                92,918.87                   Benefits 16,965.31                   137,211.23                 254,964.00                 53.82% 16,661.47                   121,581.84                 303.84                                   15,629.39                   Operations 127,155.93                 747,216.58                 1,487,050.50              50.25% 152,080.31                 503,427.84                 (24,924.38)                            243,788.74                 Capital Outlay/ Capital Projects 58,617.00                   83,614.50                   1,559,526.50              5.36%‐                                 ‐                                58,617.00                              83,614.50                   Total 299,527.79                 1,583,158.58              4,539,767.00              34.87% 260,716.64                 1,147,207.08              38,811.15                              435,951.50                 Performing Arts Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 13,057.19                   74,926.89                   185,634.00                 40.36% 12,376.85                   71,943.12                   680.34                                   2,983.77                     Benefits 2,400.17                      14,082.75                   31,359.00                   44.91% 2,164.29                      13,061.20                   235.88                                   1,021.55                     Operations 41,538.38                   138,056.53                 305,000.00                 45.26% 22,995.30                   110,727.58                 18,543.08                              27,328.95                   Capital Outlay ‐                                27,400.00                   27,400.00                   0.00%‐                                 ‐                                 ‐                                          27,400.00                   Total 56,995.74                   254,466.17                 549,393.00                 46.32% 37,536.44                   195,731.90                 19,459.30                              58,734.27                   Non‐Departmental Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference City ‐ County Svcs 7,916.67                      234,166.67                 472,000.00                 49.61% 19,083.34                   222,000.01                 (11,166.67)                            12,166.66                   Community Initiatives 11,792.00                   274,976.53                 778,643.00                 35.31% 31,753.89                   782,850.24                 (19,961.89)                            (507,873.71)               Unprocessed JP Morgan Payment ‐                                 ‐                                 ‐                                100.00%‐                                 ‐                                 ‐                                           ‐                               Drug Proceeds Expenditures ‐                                 ‐                                 ‐                                100.00% 36,232.00                   36,232.00                   (36,232.00)                            (36,232.00)                  Transfer to DSF ‐ One Cent ‐ Infras 410,374.97                 584,320.00                 70.23%‐                                307,680.32                  ‐                                          102,694.65                 Transfer to DSF ‐ One Cent ‐ P&R ‐                                232,907.03                 860,545.00                 27.07%‐                                 ‐                                 ‐                                          232,907.03                 Transfer to DSF ‐ Other ‐                                123,311.20                 123,311.00                 100.00%‐                                123,311.20                  ‐                                           ‐                               Transfer to DSF ‐ One Cent (old)‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Transfer to Group Health 280,000.00                 1,680,000.00              3,360,000.00              50.00% 274,750.00                 1,648,500.00              5,250.00                                31,500.00                   Transfer to Capital Project Fund 919,793.72                 1,954,833.64              2,204,000.00              88.69% 811,280.00                 2,213,922.00              108,513.72                           (259,088.36)               Transfer to Wasewater Fund ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Transfer to Sanitation Fund ‐                                 ‐                                 ‐                                0.00%‐                                 ‐                                 ‐                                           ‐                               Transfer to Gas Tax Fund ‐                                1,500,000.00              98,605.00                   1521.22%‐                                 ‐                                 ‐                                          1,500,000.00             Transfer to Judicial ‐                                354,556.85                 354,557.00                 100.00%‐                                 ‐                                 ‐                                          354,556.85                 Total 1,219,502.39              6,765,126.89              8,835,981.00              76.56% 1,173,099.23              5,334,495.77              46,403.16                              1,430,631.12             Debt Service Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Debt Service 227,043.57                 1,133,112.60              2,187,125.00              51.81% 239,221.30                 936,436.25                 (12,177.73)                            196,676.35                 Total 227,043.57                 1,133,112.60              2,187,125.00              51.81% 239,221.30                 936,436.25                 (12,177.73)                            196,676.35                 Total Mar‐23 YTD Budget % of Budget Mar‐22 YTD March Difference YTD Difference Salary 1,367,431.86              9,071,275.09              19,583,242.00           46.32% 1,377,340.98              8,540,422.04              (9,909.12)                               530,853.05                 Benefits 534,526.11                 3,833,630.78              7,802,386.00              49.13% 527,235.78                 3,752,266.09              7,290.33                                81,364.69                   Operations 1,629,849.66              9,201,265.70              14,339,497.50           64.17% 1,649,489.43              7,493,845.31              (19,639.77)                            1,707,420.39             Capital Outlay 58,617.00                   214,964.10                 4,142,014.50              5.19% 261,306.30                 421,561.07                 (202,689.30)                          (206,596.97)               Debt Service 227,043.57                 1,899,705.80              3,755,301.00              50.59% 239,221.30                 1,367,427.77              (12,177.73)                            532,278.03                 Total 3,817,468.20              24,220,841.47           49,622,441.00           48.81% 4,054,593.79              21,575,522.28           (237,125.59)                          2,645,319.19             % of Budget Expenditures 48.81% Prepared by     Carlee Sims