HomeMy WebLinkAbout10d BW3 attachment 4 OverheadsTDPUD Budget FY2022 and FY2023 (Draft 10/20/2021)
APPENDIX 3
LABOR BENEFIT COSTS % LABOR OVERHEAD
Current Year
BUDGET
2022 Budget
(year 1) Draft
10/20/2021
2023 Budget
(year 2) Draft
10/20/2021
FY21 Amount Pctg FY22 Amount Pctg FY23
VALUE OF BENEFITS
Medical/Dental insurance 2,719,708$49,361 2%2,769,069$110,763 4%2,879,832$
Self-funded vision benefit 67,531 7,463 11%74,994 00%74,994
Long term disability insurance 39,399 12,261 31%51,660 3,204 6%54,864
Life insurance 64,392 2,063 3%66,455 4,122 6%70,577
Longevity 19,570 2,790 14%22,360 894 4%23,254
FICA 575,917 40,601 7%616,518 34,462 6%650,980
Fed Med 134,690 19,560 15%154,250 3,267 2%157,517
Worker's compensation 308,441 (67,163) -22%241,278 14,965 6%256,243
Pension 2,525,170 325,231 13%2,850,401 205,905 7%3,056,306
Other Post Employment Benefits 113,300 1,700 2%115,000 5,000 4%120,000
Value of non-productive labor (vacation,
admin leave,sick leave, holiday)1,256,225 225,118 18%1,481,343 31,443 2%1,512,786
TOTAL VALUE OF BENEFITS 7,824,343$618,984 8%8,443,327$414,026 5%8,857,353$
PRODUCTIVE LABOR
Recommended labor (Appendix II) (excludes BoD)9,264,983$1,369,697 15%10,634,680$225,734 2%10,860,414$
Less value of non-productive labor (above)(1,256,225)(225,118) 18%(1,481,343)(31,443) 2%(1,512,786)
TOTAL PRODUCTIVE LABOR 8,008,758$1,144,579 14%9,153,337$194,291 2%9,347,628$
% of Recommended Labor 86.4%86.1%86.1%
PAYROLL OVERHEAD
Value of Benefits / Productive Labor 97.70%(0.0545) -5.6%92.24%0.0251 2.7%94.76%
OTHER METRICS
15,833,101$1,763,563 11%17,596,664$608,317 3%18,204,981$
49.42%(0.0144) -2.9%47.98%0.0067 1.4%48.65%
70.89%(0.0543) -7.7%65.46%0.0216 3.3%67.63%
Benefits excluding non-productive, % of
Recommended Labor
Y2Y Change Y2Y Change
Total Labor and Benefits
Benefits as a percent of Total Labor and
Benefits
10/14/2021 11:39 AM I:\BUDGET\CYB\Central\Employee Benefit Calcs Value of Benefits
Attachment D/4 - Overhead - Page 1 of 4
This appendix assumes that the cost of operating, maintaining and replacing District vehicles and equipment
will be recognized as an overhead charged against direct labor that uses the vehicles.
FY21 FY22 FY23
TRANSPORTATION & EQUIPMENT EXPENSE
Vehicle operation, repair, fuels & misc expenses $578,545 $801,859 780,591
Insurance 28,995 25,000 25,750
Replacement (depreciation expense)380,812 429,929 442,827
TOTAL TRANSPORTATION EXPENSE $988,352 27%$1,256,788 -1%$1,249,168
DIRECT LABOR HOURS
General Manager 5,445 8,466 8,456
Administrative Services 185 130 130
Conservation 334 330 330
Electric Operations 44,255 43,414 40,436
Water Operations 34,595 36,303 35,367
Power Supply (IT)2,320 2,320 1,475
TOTAL DIRECT LABOR HOURS 87,134 4%90,963 -5%86,194
TRANSPORTATION/EQUIPMENT OVERHEAD PER HOUR COST
$11.34 22%$13.82 5%$14.49
FY21 FY22 FY23
APPENDIX 4
TRANSPORTATION OVERHEAD
10/14/2021 11:39 AM I:\BUDGET\CYB\Central\Appendices APPENDIX 4
TDPUD Budget FY2022 and FY2023 (Draft 10/20/2021)
APPENDIX 5
ADMINISTRATIVE OVERHEAD
FY21 FY22 FY23
COMMON SUPPLY COSTS:
Purchasing/Warehousing of Common Supplies
Labor $140,577 $148,616 $153,065
Accounts Payable 45,106 45,400 46,762
Overhead:
Labor 127,518 137,088 145,037
Administrative 6,902 6,500 6,700
320,103 337,604 351,564
Warehousing Operating Costs
Utilities & Building Maintenance 25,760 29,836 31,029
Miscellaneous (insurance)6,695 6,000 6,180
Subtotal 32,455 35,836 37,209
TOTAL PURCHASING/WAREHOUSING/COMMON SUPPLIES $352,558 $373,440 $388,773
TOTAL PRODUCTIVE LABOR $8,008,758 $9,153,337 $9,347,628
ADMINISTRATIVE OVERHEAD 4.40%4.08%4.16%
FY21 FY22 FY23
10/14/2021 11:39 AM I:\BUDGET\CYB\Central\Appendices APPENDIX 5
FY22 FY23
Step 1 General direction and general construction costs from budget:
Electric Operations 109,056$115,226$
Water Operations 128,429 135,682
Total 237,485$250,908$
Step 2 Determine capitalized labor as a percent of total labor:
Capitalized
Labor 1,632,263$1,544,197$
Total Electric & Water Labor 5,916,217$5,893,106$
Step 3 Determine construction overhead to be capitalized:
Total General direction & construction costs 237,485$250,908$
% of labor to be capitalized 27.59%26.20%
General direction & construction costs to capitalize 65,521$65,747$
Construction accounting costs to capitalize 207,337 216,367
272,858$282,114$
Step 4 Calculate construction overhead to be applied to capital improvements:
Capital FY 2021 Budget
Overhead $258,630 $272,858 $282,114
Capital Labor $1,526,321 $1,632,263 $1,544,197
CONSTRUCTION OVERHEAD =16.94%16.72%18.27%
FY21 FY22 FY23
27.59%26.20%
18.27%16.72%
TDPUD Budget FY2022 and FY2023 (Draft 10/20/2021)
APPENDIX 6
CONSTRUCTION OVERHEAD
16.94%
10/14/2021 11:39 AM I:\BUDGET\CYB\Central\Appendices APPENDIX 6