|
1
<br />2
<br />3
<br />4
<br />5
<br />6
<br />7
<br />8
<br />9
<br />11
<br />12
<br />13
<br />14
<br />15
<br />16
<br />17
<br />18
<br />19
<br />20
<br />21
<br />22
<br />23
<br />24
<br />25
<br />26
<br />27
<br />28
<br />29
<br />30
<br />31
<br />32
<br />33
<br />34
<br />35
<br />36
<br />37
<br />38
<br />39
<br />40
<br />41
<br />42
<br />43
<br />44
<br />45
<br />46
<br />47
<br />48
<br />49
<br />5051
<br />52
<br />53
<br />54
<br />55
<br />56
<br />57
<br />58
<br />59
<br />60
<br />61
<br />62
<br />63
<br />64
<br />65
<br />66
<br />67
<br />68
<br />69
<br />70
<br />71
<br />72
<br />73
<br />74
<br />75
<br />76
<br />A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB
<br />CONSTRUCTION
<br />320 hrs 160 hrs 184 hrs 176 hrs 168 hrs 176 hrs 176 hrs 176 hrs 176 hrs 168 hrs 176 hrs
<br />PHASE-1
<br />Proposal Actual
<br />Hrs Cost Hrs Cost Hrs Cost Hrs Cost Hrs Cost Hrs Cost Hrs Cost Hrs Cost Hrs Cost Hrs Cost Hrs Cost
<br />PM / RE Dave Smith 230.23$ 192 44,204.16$ 171.25 10.25 $2,359.86 46 $10,590.58 44 $10,130.12 44 $10,130.12 42 $9,669.66 44 $10,130.12 44 $10,130.12 44 $10,130.12 42 $9,669.66 44 $10,130.12
<br />Contract Administrator Brenda Ramirez 130.30$ 160 20,848.00$ 192.75 9.5 $1,237.85 92 $11,987.60 88 $11,466.40 88 $11,466.40 80 $10,424.00 88 $11,466.40 88 $11,466.40 88 $11,466.40 84 $10,945.20 88 $11,466.40
<br />Lead CM/Observer Mike Masengale 134.09$ 40 5,363.60$ 4 $0.00 16 $2,145.44 80 $10,727.20 168 $22,527.12 154 $20,649.86 176 $23,599.84 62 $8,313.58 0 $0.00 0 $0.00 0 $0.00
<br />CWA Inspector Various 134.09$ -$ 8 $1,072.72 24 $3,218.16 112 $15,018.08 168 $22,527.12 168 $22,527.12 176 $23,599.84
<br />Utility Coordinator Dominic Costello 160.15$ 40 6,406.00$ 38 6 $960.90 18 $2,882.70 $0.00 $0.00 16 $2,562.40 $0.00 $0.00 $0.00 $0.00 $0.00
<br />Peak Inspector Various 0 -$ 0
<br />ODC Vehicle Inspector 5.50$ 0 $0.00 16 $88.00 80 $440.00 176 $968.00 178 $979.00 176 $968.00 174 $957.00 168 $924.00 168 $924.00 176 $968.00
<br />ODC Consumables All Staff $150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $150.00 $150.00
<br />TOTALS
<br />Monthly Planned Labor Hours & CM Cost 432 406 26 $4,708.61 172 $27,844.32 212 $32,913.72 308 $46,314.36 316 $47,653.08 308 $46,314.36 306 $46,035.18 300 $45,197.64 294 $44,215.98 308 $46,314.36
<br />TOTAL TO DATE PLANNED 76,820.92$ $4,708.61 $32,552.93 $65,466.65 $111,781.01 $159,434.09 $205,748.45 $251,783.63 $296,981.27 $341,197.25 $387,511.61
<br />AMENDMENTS/UNPLANNED COSTS
<br />Submittal Reviews Specialty Reviews ONSITE Various 4,130.00$ 4,130.00$
<br />Amendment 01 Specialty Inspection ONSITE Various 19,566.57$ 19,566.57$ 5,737.50$ 388.50$ 777.00$ 4,337.25$
<br />Amendment 01 Specialty Inspection RMA Group Various 20,974.78$ 960.00$
<br />Amendment 01 Scheduling - OCTA Constraints/COSA Charlie Fornelli 191.19$ 30,208.02$ 765.33$ 695.75$ 278.23$ 4,540.76$
<br />Amendment 01 CWA Rate Difference Various 31.09$ 51,018.69$ 3,482.08$ 5,223.12$ 5,471.84$ 4,476.96$
<br />Amendment 01 Jr Office Engineer Eric Vandenberg 93.61$ 4,377.79$
<br />Amendment 02 Jr . Office Engineer Sierra Smith 93.61$ 9,839.44$
<br />Amendment 02 Scheduler - COSA Contractor Reviews Charlie Fornelli 191.19$ 30,750.40$
<br />Amendment 02 Specialty Inspection RMA Group Various 25,021.70$
<br />Amendment 02 Peak Inspection Various 134.09$ 402.27$
<br />Amendment 02 Sr. Office Engineer at 60% (Mar-End)Carlos Quiroz 153.07$ 61,636.96$
<br />Amendment 02 PM/RE at 40% (Dec-Mar)Dave Smith 230.23$ 78,936.66$
<br />Amendment 02 CWA Rate Difference Various 31.09$ 53,474.80$
<br />Amendment 02 Inspector Overtime Various 191.68$ 51,466.08$
<br />Amendment 02 Inspector Double Time Various 218.18$ 218.18$
<br />SUM OF AMENDMENT/UNPLANNED COSTS $0.00 $4,895.33 $695.75 $0.00 $278.23 $0.00 $9,219.58 $5,611.62 $6,248.84 $14,314.97
<br />ACTUAL/FORECASTED MONTHLY $4,616.17 $41,030.23 $37,819.90 $59,551.31 $58,200.45 $46,527.20 $76,149.76 $69,516.13 $72,835.14 $78,504.69
<br />MONTHLY DIFFERENCE $92.44 ($13,185.91) ($4,906.18) ($13,236.95) ($10,547.37) ($212.84) ($30,114.58) ($24,318.49) ($28,619.16) ($32,190.33)
<br />ACTUAL TO DATE/FORECASTED ACTUAL 71,141.27$ $4,616.17 $45,646.40 $83,466.30 $143,017.61 $201,218.06 $247,745.26 $323,895.02 $393,411.15 $466,246.29 $544,750.98
<br />% of 'TOTAL TO DATE PLANNED' by Stage (neg number is over budget)7%2.0%-40.2%-27.5%-27.9%-26.2%-20.4%-28.6%-32.5%-36.7%-40.6%
<br />Difference Cummulative Planned vs Actual To Date ( ($xx) is amt over To Date budget)5,679.65$ $92.44 ($13,093.47)($17,999.65)($31,236.60)($41,783.97)($41,996.81)($72,111.39)($96,429.88)($125,049.04)($157,239.37)
<br />Total Authorized Amount Planned To Date Total Authorized Amount Planned To Date $236,255.01 $282,569.37 $328,604.55 $373,802.19 $418,018.17 $464,332.53
<br />Total Amount Expended/Projected To Date Total Authorized Amount Expended To Date $272,359.33 $318,886.53 $395,036.29 $464,552.42 $537,387.56 $615,892.25
<br />Difference ($36,104.32)($36,317.16)($66,431.74)($90,750.23)($119,369.39)($151,559.72)
<br />% of Total Contract used 44.3%52.1%60.2%61.6%
<br />% over/under of Planned Total to Date -15.3%-12.9%-20.2%-24.3%-28.6%-32.6%
<br />Construction Period Planned To Date $159,434.09 $205,748.45 $251,783.63 $296,981.27 $341,197.25 $387,511.61
<br />Construction Period Actual To Date $201,218.06 $247,745.26 $323,895.02 $393,411.15 $466,246.29 $544,750.98
<br />Difference ($41,783.97)($41,996.81)($72,111.39)($96,429.88)($125,049.04)($157,239.37)
<br />% over/under Construction Period Planned -26.2%-20.4%-28.6%-32.5%-36.7%-40.6%
<br />Construction Period Planned To End $1,099,114.05 $1,099,114.05 $1,099,114.05 $1,099,114.05 $1,099,114.05 $1,099,114.05
<br />Construction Period Actual To Date $201,218.06 $247,745.26 $323,895.02 $393,411.15 $466,246.29 $544,750.98
<br />% of Construction Period used 18.3%22.5%29.5%35.8%42.4%49.6%
<br />Total Authorized Amount To End Planned $892,275.92 $892,275.92 $892,275.92 $999,882.29
<br />Total Authorized Amount To Date Used $395,036.29 $464,552.42 $537,387.56 $615,892.25
<br />Total Authorized Amount Remaining $383,990.04
<br />% of Authorized Amount used 44.3%52.1%60.2%61.6%
<br />Recent 3 months used $192,193.09 $218,501.03 $220,855.96
<br />Average over 3 months $64,064.36 $72,833.68 $73,618.65
<br />Remaing time for Construction Period Budget (months)11.0 mo 8.7 mo 7.5
<br />Remaing time for Total Authorized Budget (months)6.7 mo 4.9 mo 5.2
<br />Mar-22
<br />WD Hrs
<br />PRE-CON CONSTRUCTION CONSTRUCTION
<br />Apr-22 May-22 Jun-22 Jul-22Scope Labor Category Name Rate
<br />Feb-22 Aug-22 Sep-22 Oct-22 Nov-22
<br />Construction Management & Inspection
<br />Services
<br />CURRENT
<br />MONTH
|