Laserfiche WebLink
APE Water Sewer Replacement <br />Exhibit B - Rev 1 Estimate 2 months remaining for closeout. <br />Estimated Hours to Complete Project <br />1- Admin/QC <br />Hours to complete <br />Raw Rate (Payroll Rate) I Raw Total ! Billing Rate <br />Loaded Total <br />Employee <br />2 hours <br />9 hours <br />10.25 hours <br />5 hours <br />51:hours $ <br />4 hours <br />100.51 $ 201.02 $ 270.51 bill rate <br />86.20 $ 775.80 $ 232.00 bill rate <br />29.64 $ 303.81 $ 79.77 bill rate <br />34.06 $ 170.30 $ 91.67 bill rate <br />30.52 ' $ 152.59 $ 82.14 , bill rate <br />88.79 : $ 355.14 $ 238.96 bill rate <br />$ 541.03 <br />2,087.99 <br />817.67 <br />458.35 <br />$ 410.69 <br />$ 955.83 <br />Fillis - Expended <br />Bardwell - Expended <br />Coughlin - Expended <br />Epperson - Expended <br />Coughlin <br />Bardwell <br />35.25ITotal Hours <br />2- Doc Control <br />Hours to complete <br />$ 1,958.67 Total Loaded (revenue) <br />Raw Rate (Payroll Rate) Raw Total <br />Billing Rate <br />$ 5,271.56 <br />lLoaded Total <br />Employee <br />99.5 hours <br />151 <br />40' hours <br />33.66 $ <br />31.96 $ <br />36.00 ! $ <br />3,349.17 $ <br />4,825.96 $ <br />1,440.00 $ <br />82.37 bill rate <br />86.02 bill rate <br />96.89 !bill rate <br />8,195.42 <br />12,988.59 <br />3,875.62 <br />Juan - Expended <br />Shinsato - Expended <br />Shinsato <br />290.5ITotal Hours <br />3 - Inspection <br />Hours to complete <br />$ 9,615.13 Total Loaded (revenue) ' I $ 25,059.62 <br />Raw Rate (Payroll Rate) Raw Total ! Billing Rate <br />Loaded Total <br />Employee <br />189 hours <br />12.5 hours <br />16 hours $ <br />58.09 $ 10,979.01 $ <br />33.66 <br />58.67 $ 938.72 $ <br />142.15 bill rate <br />82.37 <br />143.57 bill rate <br />$ <br />26,865.64 <br />1,029.58 <br />2,297.05 <br />Vaughn - Expended <br />Juan - Expended <br />Vaughn <br />217.SL-iota' Hours <br />4 - Construction Management <br />$ 11,917.73 Total Loaded (revenue) <br />$ 30,192.26 <br />nours to complete <br />new nate wayroli nate; <br />Raw iota' , <br />'lining Rate <br />Loaaea iota; tmployee <br />30.5 <br />hours <br />$ <br />86.20 <br />$ 2,629.10 1 <br />$ 232.00 <br />bill rate <br />58.67 <br />7,075.96 <br />Bardwell - Expended <br />16 <br />hours <br />$ 1,363.87 <br />$ <br />88.79 <br />$ 1,420.58 1 <br />$ 238.96 <br />bill rate <br />$ 71.74 <br />$ 3,823.34 <br />Bardwell <br />30.5 <br />Total Hours <br />Bergeson - Expended <br />$ 2,629.10 <br />Total loaded (revenue) <br />I $ 7,075.96 <br />$ 33.66 <br />7 - Arch Monitoring <br />Hours to complete <br />Raw Rate (Payroll Rate) Raw Total Billing Rate <br />:Loaded Total <br />Em lo ee <br />6 <br />hours <br />44.34 <br />$ 266.05 <br />$ 119.34 <br />bill rate <br />716.04 <br />Butler - Expended <br />9.5 <br />hours <br />58.67 <br />$ 557.37 <br />$ 143.57 <br />bill rate <br />$ 1,363.87 <br />Becker - Expended <br />2.5 <br />hours <br />$ 28.70 <br />$ 71.74 <br />$ 77.23 <br />bill rate <br />$ 193.08 <br />Bergeson - Expended <br />7 <br />hours <br />$ 33.66 <br />$ 235.62 <br />$ 82.37 <br />bill rate <br />$ 576.56 <br />Kline - Expended <br />1 <br />hours <br />$ 63.40 <br />$ 63.40 <br />$ 170.63 <br />bill rate <br />170.63 <br />McDaniel - Expended <br />8 <br />hours <br />$ 28.70 <br />$ 229.57 <br />$ 77,23 <br />bill rate <br />617.86 <br />Mclandrich - Expended <br />CDI Labor Costs <br />34 Total Hours <br />1,423.74 Total Loaded (revenue) <br />8- Change Order Resolution <br />Hours to complete Raw Rate (Payroll Rate) Raw Total <br />Billing Rate <br />$ 626.00 Expended Monitoring Laboi <br />4,264.05 <br />Loaded Total <br />Employee <br />32:hours $ <br />40!hours 1 $ <br />88.79 $ <br />36.00 $ <br />2,841.15 $ <br />1,440.00 $ <br />238.96 :bill rate <br />96.89 bill rate <br />7,646.68 <br />3,875.62 <br />Bardwell <br />Shinsato <br />72ITota1 Hours $ 4,281.15 Total Loaded (revenue) 1 <br />$ 11,522.29 <br />64 <br />