Loading...
HomeMy Public PortalAboutExhibit MSD 31C - Basis for Stormwater Input Values in Exhibit MSD 18Please see yellow highlighted numbers on the  following 3 tabs for the basis of the values  input into the model, as described in question  8 of the Second Discovery Request dated  March 19, 2018. ENGINEERING DEPARTMENT REGULATORY STORMWATER STAFF POSITIONS FULL TIME EQUIVALENT (FTE) COSTS Stormwater Fund 5110 5120 OMCI and 5120 DIVISION UNIT 2 cent  Regulatory  FTE 10 cent O&M   FTE Capital FTE Title  Midpoint  Salary  Storm Salary Cost   Regulatory ‐  5110   Non‐ Regulatory ‐  5120   Capital‐ Spread   Capital  Project cost  account?‐5120  DEC Stormwater 1 0 0 Environmental Specialist 82,550     82,550$                      82,550$          ‐$                  ‐$                 1 0 0 Division Inspector 76,750     76,750$                      76,750$          ‐$                  ‐$                 2 1 0 Industrial Waste Investigator 58,500     175,500$                    117,000$       58,500$           ‐$                 1 0 0 Office Associate 42,213     42,213$                      42,213$          ‐$                  ‐$                 Regulatory Affairs 1 0 0 Civil Engineer 82,550     82,550$                      82,550$          ‐$                  ‐$                 Emergency Response 0.5 0 0 Industrial Waste Investigator 58,500     29,250$                      29,250$          ‐$                  ‐$                 Lab 0.5 0 0 Chemist 76,750     38,375$                      38,375$          ‐$                  ‐$                 0.5 0 0 Lab Tech 54,450     27,225$                      27,225$          ‐$                  ‐$                 Pretreatment 0.5 0 0 Industrial Waste Tech 45,783     22,892$                      22,892$          ‐$                  ‐$                 Subtotal 8 1 0 9 FTE 577,305$                    518,805$       58,500$           ‐$                Total Planning Planning 0.1 0.2 0.3 Principal Engineer 103,450   31,035$                      10,345$         20,690$          31,035$           0 0.5 0.5 Assistant Engineer 71,500     35,750$                       ‐$                35,750$          35,750$           0 0 0.5 Civil Engineer 82,550      ‐$                             ‐$                 ‐$                 41,275$           0.4 0.6 1 Senior Civil Engineer 95,750     95,750$                      38,300$         57,450$          95,750$           GIS 3.75 0.5 1 Cartographic/CADD Tech Sr 54,610     232,093$                    204,788$       27,305$          54,610$          No Dev Rev 1 0 0 Principal Engineer 103,450   103,450$                    103,450$        ‐$                  ‐$                 2 0 0 Senior Civil Engineer 95,750     191,500$                    191,500$        ‐$                  ‐$                 4.5 0 0 Civil Engineer 82,550     371,475$                    371,475$        ‐$                  ‐$                 Permits 0.25 0 0 Permit Supervisor 66,700     16,675$                      16,675$          ‐$                  ‐$                 2 0 0.5 Office Associate 42,213     84,426$                      84,426$          ‐$                 21,107$          No 1.5 0 0 Office Assistant 39,076     58,614$                      58,614$          ‐$                  ‐$                No CIP 0 0 0.4 Senior Civil Engineer 95,750      ‐$                             ‐$                 ‐$                 38,300$          No 0 0 0 Division Inspector 76,750      ‐$                             ‐$                 ‐$                  ‐$                 0 0 0.6 Graphic Asst./Office Associate 42,213      ‐$                             ‐$                 ‐$                 25,328$          No Subtotal 15.5 1.8 4.8 22.1 FTE 1,220,768$                1,079,573$    141,195$        343,154$        Total Design Capital Projects 0 0 0.5 Principal Engineer 103,450    ‐$                             ‐$                 ‐$                 51,725$           0 0 1.5 Senior Civil Engineer 95,750      ‐$                             ‐$                 ‐$                 143,625$         Project Design 0 0.5 0.1 Principal Engineer 103,450   51,725$                       ‐$                51,725$          10,345$           0 2.6 0.4 Civil Engineer 82,550     214,630$                     ‐$                214,630$        33,020$           0 0.5 0 Resident Inspector 62,500     31,250$                       ‐$                31,250$           ‐$                 0 3.5 0 Construction Inspector Sr 54,610     191,135$                     ‐$                191,135$         ‐$                 0 1.3 0.3 Cartographic/CADD Tech Sr 54,610     70,993$                       ‐$                70,993$          16,383$           0 0.3 0.2 Specifications Associate 45,783     13,735$                       ‐$                13,735$          9,157$             No 0 0.7 0 Office Associate 42,213     29,549$                       ‐$                29,549$           ‐$                No ROW/Survey 0 0.2 1.8 ROW Agent 66,700     13,340$                       ‐$                13,340$          120,060$         0 0.5 0 Engineering Specialist 82,550     41,275$                       ‐$                41,275$           ‐$                 0 0.5 0.8 Surveyor 66,700     33,350$                       ‐$                33,350$          53,360$           0 0.5 0.8 Surveyor Assistant 45,783     22,892$                       ‐$                22,892$          36,626$           0 0.5 0.8 Cartographic/CADD Tech Sr 54,610     27,305$                       ‐$                27,305$          43,688$           0 0.5 0.8 Section Head 54,450     27,225$                       ‐$                27,225$          43,560$           Subtotal 0 12.1 8 20.1 FTE 768,404$                     ‐$                768,404$        561,549$        Total CM Capital 0 0 0 Principal Engineer 103,450    ‐$                             ‐$                 ‐$                  ‐$                 0 0 0.5 Senior Civil Engineer 95,750      ‐$                             ‐$                 ‐$                 47,875$           0 0 0.9 Civil Engineer 82,550      ‐$                             ‐$                 ‐$                 74,295$           0 0 1.8 Division Inspector 76,750      ‐$                             ‐$                 ‐$                 138,150$         0 0 2.7 Resident Inspector 62,500      ‐$                             ‐$                 ‐$                 168,750$         0 0 0.5 Cartographic/CADD Tech Sr 54,610      ‐$                             ‐$                 ‐$                 27,305$           0 2 7.2 Construction Inspector Sr 54,610     109,220$                     ‐$                109,220$        393,192$         Admin 0 0 0.3 Admin Support Supv 58,500      ‐$                             ‐$                 ‐$                 17,550$          No 0 0 1.4 Office Associate 42,213      ‐$                             ‐$                 ‐$                 59,098$          No 0 0 0 Office Assistant 39,076      ‐$                             ‐$                 ‐$                  ‐$                No Development 0.66 0 0 Construction Supv 88,500     58,410$                      58,410$          ‐$                  ‐$                 0.75 0 0 Assistant Engineer 71,500     53,625$                      53,625$          ‐$                  ‐$                 0.66 0 0 Division Inspector 76,750     50,655$                      50,655$          ‐$                  ‐$                 1.36 0 0 Resident Inspector 62,500     85,000$                      85,000$          ‐$                  ‐$                 0.66 0 0 Construction Inspector Sr 54,610     36,043$                      36,043$          ‐$                  ‐$                 10 0 1 Const Inspector 49,888     498,880$                    498,880$        ‐$                 49,888$           Subtotal: 14.09 2 16.3 32.39 FTE 891,833$                    782,613$       109,220$        976,103$        Total Grand Total: 37.59 16.9 29.1 83.59 FTE 3,458,308$                 45% 20% 35% Direct Labor 2,380,990$    1,077,319$     1,880,807$      Overhead 2,946,713$    1,333,289$     2,555,076$      Labor + Overhead 5,327,702$    2,410,608$     4,435,882$      Interfund Labor 3,904,868$     Charged to Proj Interfund Labor 531,014$        Manual Entry ch Overhead Rate from 2018 Rate Proposal 123.76% Engineering Unsegmented OH Rate 135.85% N:\ACCTBUDGET\Rate Model\FY18 Impervious Rate Proposal\Discovery Requests\March 19 2018\Q8 Analysis supporting inputs 3/29/2018 at 7:53 AM ENGINEERING DEPARTMENT REGULATORY STORMWATER STAFF POSITIONS FULL TIME EQUIVALENT (FTE) COSTS O&M w/IR NEW CIP  $30M  Revenue,  $15M  Construction DIVISION UNIT Regulatory FTE Non‐Reg FTE Capital FTE Title  Midpoint  Salary  Storm Salary Cost  Regulatory   Non‐ Regulatory  Capital*  Project TC cost account?  DEC Stormwater 1 0 0 Environmental Specialist 81,550   81,550$                     81,550$          ‐$                  ‐$                 1 0 0 Division Inspector 75,850   75,850$                     75,850$          ‐$                  ‐$                 2 1 0 Industrial Waste Investigator 57,800   173,400$                   115,600$       57,800$           ‐$                 1 0 0 Office Associate 41,711   41,711$                     41,711$          ‐$                  ‐$                 Regulatory Affairs 1 0 0 Civil Engineer 81,550   81,550$                     81,550$          ‐$                  ‐$                 Emergency Response 0.5 0 0 Industrial Waste Investigator 57,800   28,900$                     28,900$          ‐$                  ‐$                 Lab 0.5 0 0 Chemist 75,850   37,925$                     37,925$          ‐$                  ‐$                 0.5 0 0 Lab Tech 53,800   26,900$                     26,900$          ‐$                  ‐$                 Pretreatment 0.5 0 0 Industrial Waste Tech 45,239   22,620$                     22,620$          ‐$                  ‐$                 Subtotal 8 1 0 9 FTE 570,406$                   512,606$       57,800$           ‐$                Total Add GSA equal 1 FTE to CIP Planning Planning 0.1 0.2 0.3 Principal Engineer 102,200 30,660$                     10,220$         20,440$          30,660$           0 0.5 1 Assistant Engineer 70,650   35,325$                      ‐$                35,325$          70,650$           0.4 0.6 2 Civil Engineer 81,550   81,550$                     32,620$         48,930$          163,100$         GIS 3.75 0.5 1 Cartographic/CADD Tech Sr 53,961   229,334$                   202,354$       26,981$          53,961$          No Dev Rev 1 0 0 Principal Engineer 102,200 102,200$                   102,200$        ‐$                  ‐$                 2 0 0 Senior Civil Engineer 94,600   189,200$                   189,200$        ‐$                  ‐$                 4.5 0 0 Civil Engineer 81,550   366,975$                   366,975$        ‐$                  ‐$                 Permits 0.25 0 0 Permit Supervisor 65,900   16,475$                     16,475$          ‐$                  ‐$                 2 0 0.5 Office Associate 41,711   83,422$                     83,422$          ‐$                 20,856$          No 1.5 0 0 Office Assistant 38,618   57,927$                     57,927$          ‐$                  ‐$                 CIP 0 0 0.4 Senior Civil Engineer 94,600    ‐$                             ‐$                 ‐$                 37,840$          No 0 0 0 Division Inspector 75,850    ‐$                             ‐$                 ‐$                  ‐$                 0 0 0.6 Graphic Asst./Office Associate 41,711    ‐$                             ‐$                 ‐$                 25,027$          No Subtotal 15.5 1.8 5.8 23.1 FTE 1,193,068$                1,061,393$    131,676$        402,093$        Total Design Capital Projects 0 0 1 Principal Engineer 102,200 ‐$                             ‐$                 ‐$                 102,200$         0 0 4 Civil Engineer 81,550    ‐$                             ‐$                 ‐$                 326,200$         Project Design 0 0.5 0.4 Principal Engineer 102,200 51,100$                      ‐$                51,100$          40,880$           0 2.6 1.8 Civil Engineer 81,550   212,030$                    ‐$                212,030$        146,790$         0 0.5 0 Resident Inspector 61,750   30,875$                      ‐$                30,875$           ‐$                 0 3.5 0 Construction Inspector Sr 53,961   188,864$                    ‐$                188,864$         ‐$                 0 1.3 1.1 Cartographic/CADD Tech Sr 53,961   70,149$                      ‐$                70,149$          59,357$           0 0.3 0.6 Specifications Associate 45,239   13,572$                      ‐$                13,572$          27,143$          no 0 0.7 0 Office Associate 41,711   29,198$                      ‐$                29,198$           ‐$                no ROW/Survey 0 0.2 4 ROW Agent 65,900   13,180$                      ‐$                13,180$          263,600$         0 0.5 0.6 Engineering Specialist 70,650   35,325$                      ‐$                35,325$          42,390$           0 0.5 0.3 Surveyor 65,900   32,950$                      ‐$                32,950$          19,770$           0 0.5 1.1 Surveyor Assistant 45,239   22,620$                      ‐$                22,620$          49,763$           0 0.5 0.3 Cartographic/CADD Tech Sr 53,961   26,981$                      ‐$                26,981$          16,188$           0 0.5 0.3 Section Head 53,800   26,900$                      ‐$                26,900$          16,140$           Subtotal 0 12.1 15.5 27.6 FTE 753,742$                    ‐$                753,742$        1,110,422$     Total add 1 Program Manager (overhead) CM Capital 0 0 0 Principal Engineer 102,200 ‐$                             ‐$                 ‐$                  ‐$                 0 0 0 Senior Civil Engineer 94,600    ‐$                             ‐$                 ‐$                  ‐$                 0 0 1 Civil Engineer 81,550    ‐$                             ‐$                 ‐$                 81,550$           0 0 3 Division Inspector 75,850    ‐$                             ‐$                 ‐$                 227,550$         0 0 3 Resident Inspector 61,750    ‐$                             ‐$                 ‐$                 185,250$         0 0 0.5 Cartographic/CADD Tech Sr 53,961    ‐$                             ‐$                 ‐$                 26,981$           0 2 11 Const Inspector Sr 53,961   107,922$                    ‐$                107,922$        593,571$         Admin 0 0 2 Admin Support Supv 57,800    ‐$                             ‐$                 ‐$                 115,600$        no 0 0 1.5 Office Associate 41,711    ‐$                             ‐$                 ‐$                 62,567$          no 0 0 0 Office Assistant 38,618    ‐$                             ‐$                 ‐$                  ‐$                no Development 0.66 0 0 Construction Supv 87,750   57,915$                     57,915$          ‐$                  ‐$                 0.75 0 0 Assistant Engineer 70,650   52,988$                     52,988$          ‐$                  ‐$                 0.66 0 0 Division Inspector 75,850   50,061$                     50,061$          ‐$                  ‐$                 1.36 0 0 Resident Inspector 61,750   83,980$                     83,980$          ‐$                  ‐$                 0.66 0 0 Const Inspector Sr 53,961   35,614$                     35,614$          ‐$                  ‐$                 10 0 1 Const Inspector 49,295   492,950$                   492,950$        ‐$                 49,295$           Subtotal: 14.09 2 23 39.09 FTE 881,430$                   773,508$       107,922$        1,342,363$     Total Grand Total: 37.59 16.9 44.3 98.79 FTE 3,398,646$                 38% 17% 45% Direct Labor 2,347,506$    1,051,140$     2,854,878$      Overhead 2,905,273$    1,300,890$     3,878,351$      Labor + Overhead 5,252,779$    2,352,030$     6,733,229$      Interfund Labor 5,924,280$     Charged to Projects Interfund Labor 808,949$        Manual Entry charged to 5120 Overhead Rate from 2018 Rate Proposal 123.76% Engineering Unsegmented OH Rate 135.85% Uses Overhead Rate of 177.79%Row Labels Count of FTESum of SalarySum of Overhead Sum of Total ExpenseGrand Glaize Yard 16 1,009,164 1,794,226 2,803,390Collections System Technician 11 639,038 1,136,168 1,775,206Engineer2 165,100 293,537 458,637Heavy Equipment Operator1 71,989 127,991 199,980Team Lead I 2 133,037 236,531 369,567Mintert Yard 17 1,072,729 1,907,240 2,979,969Bricklayer 1 71,989 127,991 199,980Collections System Technician 12 697,133 1,239,456 1,936,589Engineer2 165,100 293,537 458,637Heavy Equipment Operator1 71,989 127,991 199,980Team Lead I 1 66,518 118,265 184,784Sulphur Yard 28 1,704,160 3,029,882 4,734,042Bricklayer 1 71,989 127,991 199,980Collections System Technician 22 1,278,077 2,272,336 3,550,412Engineer1 82,550 146,768 229,318Heavy Equipment Operator1 71,989 127,991 199,980Team Lead I 3 199,555 354,796 554,351FY19 SW Opertations Labor Budget 3,786,052 6,731,349 10,517,402FY18 SW Operations Labor Budget‐3,882,028‐4,187,156‐8,069,184Variance‐95,976 2,544,193 2,448,2185120 5130 Total 5120 51301,436,153.25$      4,187,415.39$              Labor 3,786,052$           1,345,492$       2,440,561$       36% 64% Overhead 6,731,349$           2,392,194$       4,339,155$       Equipment 1,916,917$           681,236$          1,235,681$       Supplies 1,131,356$           402,062$          729,293$          FY20 FY21Salaries 3.07% 2.99%Overhead 3.07% 2.99%Equipment 2.00% 2.00%Supplies 2.00% 2.00%Dec FY18 YTD WO Split FY19 Ops SW Budget (using Dec FY18 WO Split)Future Year Inflation %