Loading...
HomeMy WebLinkAboutOverhead calculation FY 27GENERAL OVERHEAD CALCULATION Matt final draft pass 6/12/26 2027 Personnel Costs-All Funds 21,376,200$ character code 10 Operations Cost-All Funds 21,156,900$ character code 11 Total OPERATING Budgets for all operating departments funds 42,533,100 CHARACTER CODE 10 11 Less Overhead Departments Operating Budgets personnel oper Operating Percent OH Ratio Mayor & Council-01411 339,000 71,800 410,800 9%1.10% Economic Development-01412 296,700 51,900 348,600 7%0.93% Customer Services-01413 433,800 37,100 470,900 10%1.26% IT-01414 842,300 121,300 963,600 21%2.58% Building Maint-01408 50,500 17,400 67,900 1%0.18% Financial Management-01415 934,200 327,600 1,261,800 27%3.37% Human Resource Management-01410 277,900 30,100 308,000 7%0.82% Legal Services-01416 244,800 83,300 328,100 7%0.88% Planning & Zoning-01417 446,700 92,000 538,700 11%1.44% Total 3,865,900 832,500 4,698,400 100%12.56% Remainder 37,834,700 Overhead Operating Budgets 4,698,400 Overhead Capital- search org 01408:01417 and object 5000:5999 55,000 x Net Overhead Cost 4,753,400 Non-Overhead Operating Budgets 37,834,700 Ratio on Operating Budgets Only 0.1256 12.56% OVERHEAD CALCULATION Revenue Billing/Collection a 0.0700 7.00%36% Accounts Payable/Budgeting b 60%0.0754 7.54%39% Payroll/Human Resources c 40%0.0503 5.03%26% TOTAL 0.1956 19.56%100% Operating Budgets 2027 2027 2027 2027 2027 2027 Character Code 10:11 Less Object 4677/ 4890 Net %Calc Total %Budget Streets abc 2,982,100 -513,300 2,468,800 0.19564 483,000 17.48%483,000 Sanitation abc 3,633,600 -780,900 2,852,700 0.19564 558,100 20.19%558,100 Water abc 4,351,700 -1,469,500 2,882,200 0.19564 563,900 20.40%563,900 Sewer-Treatment abc 3,770,400 -1,427,700 2,342,700 0.19564 458,300 16.58%458,300 Sewer-Collection abc 1,894,500 -893,500 1,001,000 0.19564 195,800 7.08%195,800 Shop bc 597,700 -70,800 526,900 0.12564 66,200 2.40%66,200 Engineering bc 788,200 -93,200 695,000 0.12564 87,300 3.16%ACTUAL 87,300 Golf Teton Lakes bc 1,299,200 -51,500 1,247,700 0.12564 52,000 1.88%163,226 52,000 Golf Legacy bc 277,800 -10,500 267,300 0.12564 11,000 0.40%34,902 11,000 City Fire Only 0 0 0 0.00%0 0 Airport (less Mayor & Council and contingency)abc 58,400 -4,700 53,700 0.11478 5,000 0.18%6,703 5,000 GIS-start to charge 50% of calculated rate in FY 27 bc 651,700 -20,000 631,700 0.12564 41,000 1.48%81,877 41,000 Building Department a-partial/bc 1,506,300 -238,000 1,268,300 0.16064 242,000 8.76%242,000 OVERHEAD CHARGE 21,811,600 -5,573,600 16,238,000 0 2,763,600 100.00% 2,763,600 Matt Final Draft Pass 6/12/26 do this first, with the dept operating budgets updated GIS/SURVEYOR ALLOCATION 2027 @@4@@9229419-3830 credit GIS Budget (HALF) After Reducing Gen OH Rate in FY27 only City Share of GIS Overhead 356,500 10 11 object 4830 Operating Budgets not including Capital and OH Personnel Operations object 4677 Total Factor Annual Monthly P&Z 446,700 92,000 (43,000) 495,700 335%1,660,595 12%41,500 3,458$ Building Safety 987,300 416,300 (41,000) 1,362,600 150%2,043,900 14%51,300 4,275$ Streets 1,448,400 1,532,000 (79,500) 2,900,900 125%3,626,125 26%91,000 7,583$ Sanitation 619,300 2,965,500 (230,000) 3,354,800 40%1,341,920 9%33,700 2,808$ Water 1,546,000 2,688,600 (954,000) 3,280,600 100%3,280,600 23%82,300 6,858$ Sewer -Treatment 1,085,400 2,582,400 (943,200) 2,724,600 40%1,089,840 8%27,300 2,275$ Sewer -Collection 688,500 1,146,600 (664,700) 1,170,400 100%1,170,400 8%29,400 2,450$ 6,821,600 11,423,400 -2,955,400 15,289,600 14,213,380 100%356,500 29,708 0 MUST BE ZERO or close w/rounding Matt final draft pass 6/12/26 Matt Decided we should include these amounts in FY24. These are costs that need to be covered and these assets are used for operating purposes.mkn revenue acct 01411--3870 credit DR CR Monthly accounts Tyler Accounts notes 1420 1010 217508.33 40,250 0243199 02431-4890 02431 1010 ####### 46,508 2543399 25433-4890 25433 1010 ####### 46,992 2643499 26434-4890 26434 1010 ####### 38,192 2743599 27435-4890 27435 1010 ####### 16,317 2747599 27475-4890 27475 1010 ####### 5,517 0143299 01432-4890 7,275 0142899 01428-4890 4,333 5043@42 50437-4890 44,311 85.2%50437 1010 4,333.33 917 50436-4890 7,689 14.8%50436 1010 916.67 - 1742399 17480-4890 Fire 17480 1010 - 417 4744799 47447-4890 47447 1010 416.67 3,417 29419-4890 29419 3,416.67 20,167 2842499 28418-4890 28418 1010 #######- 230,300 GIS Total %1.5% Tyler Account 1420 01417-4830 xxx 28418-4830 xxx 28418 02431-4830 xxx 02431 25433-4830 xxx 25433 26434-4830 xxx 26434 27435-4830 xxx 27435 27475-4830 xxx 27475 MUST BE ZERO or close w/rounding DR CR 1010 26,250$ 1010 4,275$ 1010 7,583$ 1010 2,808$ 1010 6,858$ 1010 2,275$ 1010 2,450$