Laserfiche WebLink
CITY OF EVERETT-WPCF TFI BAR SCREEN UPGRADES(UP 3770) Date: 18-Nov-21 <br /> PROJECT HOURS,EXPENSES AND FEE ESTIMATE EXHIBIT B <br /> HOURS FOR EACH TASK(Whole Hours Only) <br /> Direct Salary Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Cost <br /> Labor Category Hourly Rates, Total <br /> ($$.CC) Engineering Additional Services Hours <br /> Project Pre-Design Services During as Requested by <br /> Management Analysis Design Bid Assistance Construction the Owner <br /> 1 Principal in Charge/Contract Manager(J.Gross) $ 90.00 2 0 0 2 $ 180 <br /> 2 Project Manager(J.Gillespie) $ 83.00 56 38 18 112 $ 9,296 <br /> 3 QA(C.Ochiltree) $ 85.00 12 0 0 12 $ 1,020 <br /> 4 Project Engineer(T.Giese) $ 85.00 12 205 28 245 $ 20,825 <br /> 5 Staff Engineer(S.Krishnamurthy) $ 46.00 0 221 14 235 $ 10,810 <br /> 6 Electrical Engineer(J.Gibson) $ 85.00 0 48 0 48 $ 4,060 <br /> 7 Structural Engineer(G.Franco) $ 79.50 0 100 4 104 $ 8,268 <br /> 8 Sr.Structural Engineer(K.Dahl) $ 85.00 0 4 0 4 $ 340 <br /> 9 CADD Manager(P.Simon) $ 61.50 0 13 0 13 $ 800 <br /> 10 CADD Tech $ 45.00 0 256 2 258 $ 11,610 <br /> , <br /> 11 Clerical(S.Sifferman) $ 41.00 10 35 2 47 $ 1,927 <br /> 12 Project Administrator(U.Pierson) $ 49.00 10 0 0 10 $ 490 <br /> - $ <br /> Total Task Hours 102 0 920 68 0 1,090 <br /> Subtotal Direct Salary Cost(DSC),$ 7,768 0 56,870 5,008 0 2,000 $ 71,646 <br /> Overhead on DSC(Indirect cost)@,% I 152.27% 11,828 0 86,596 7,626 0 3,045 $ 109,095 <br /> Total Labor Cost,$ 19,596 0 143,466 12,634 0 5,045 R' $ 180,741 <br /> Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 uT <br /> Expenses,$ Expenses <br /> Management Analysis Design Bid Assistance Services During as Requested by <br /> 1 Reimbursable Expenses 100 400 200 "�. S 700 <br /> 2 Communication Charge(3%of labor) $ <br /> 3 Expense $ <br /> 4 Per Labor Hr.Tech.Charge I 0 0 0 0 0 0 $ - <br /> Total Expenses,$ 100 0 400 200 0 0 e:. $ 700 <br /> TOTAL LABOR AND EXPENSES 19,696 0 143,866 12,834 0 5,045 r $ 181,441 <br /> Subconsultant Expenses,$ Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Sub Expenses <br /> 100 t <br /> 1 Subconsultant(ADS Utility Locates) T; SO <br /> 2 Subconsultant(Surveyor) SO <br /> Subconsultant(Geotechnical Engineering) 5,000 $5,000 <br /> 3 Subconsultant(Mechanical-HVAC) , <br /> $0 <br /> TOTAL SUBCONSULTANTS 0 0 5,000 0 0 0 _ $5,000 <br /> Subconsultant Admin Mark-up,% I 5.00% 0 0 250 0 0 0 $250 <br /> Subtotal Cost by Task 19,696 0 149,116 12,834 0 5,045 , ^' $ 186,691 <br /> Fee/Profit(as%of Total DSC&Overhead) 12.00% 2,352 0 17,216 1,516 0 605 _'. $ 21,689 <br /> Next Year's Labor Escalation` 4.00% 878 0 6,427 566 0 226 $ 8,097 <br /> Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 <br /> TOTAL ESTIMATED COST AND FEE,$ Management Analysis Design Bid Assistance Services During as Requested by Total <br /> 22,926 0 172,759 14,916 0 5,876 syhnhr/. $ 216,477 <br /> •Next year's labor escalation was calculated assuming I 100.00%lof the work would be completed next year. <br /> Enter data in yellow&green shaded I (cells only. Other formula cells are locked to prevent accidental changes. There is no password protection. <br /> ( Overall Project Multiplier I 2.83( <br /> 1 Fee/Profit as a%of DSC Only ( 3027%1 <br /> S:\1Common\PLANT&FAC ENGR\Projects\WPCF\UP 3770-WPCF TFI Bar Screen\BHC\Design\BHC Everett WP.O FI Bar Screen Design Bid Svcs Budget 071422.xlsx 11/20/2014 <br />