RCG-2487
Trailhead Coffee Roasters Fit-Out
FinishesBelow bid marginTrailhead Coffee Roasters · 118 Copper Lane, Unit B · North Metro · Retail Fit-Out
Projected margin vs bid
−16.03pts
−4.0% projected · 12.0% bid · (55,305)
Project manager
S. Okafor
Superintendent
A. Reyes
Project executive
R. Arden
Start
18 May 26
Substantial completion
15 Sep 26(was 11 Sep 26, +4d by CO)
Field schedule
21 days behind
Superintendent’s note · Twenty-one days behind. The mechanical rebuy cost four weeks and the hood inspection cannot be scheduled until the shaft enclosure is closed.
Revised contract
$360k
$340k contract + $20k in 3 approved COs
Projected final cost
$374k
revised budget $317k
Cost variance
−$57,900
projected final cost against revised budget
Cost to date
$301k
80% of projected final cost
Billed to date
$296k
82% of contract · overbilled $7k
Retention held
$30k
10% withheld by owner
Value at risk
$16k
1 change order built without approval
Progress
- Cost percent complete
- 80%
- Field percent complete
- 85%
- Schedule percent elapsed
- 95%
Cost is −15 points behind the calendar. 6 days remain to substantial completion and $73,650 of cost is still to spend.
Margin bridge
| Margin in the bid340,000 at 12.0% | 40,800 |
| +Margin on approved change orders3 approved · 19,895 sold against 17,300 of cost | 2,595 |
| +Cost variance against revised budgetoverruns and savings across 11 cost codes | (57,900) |
| = Projected margin−4.0% of 359,895 | (14,505) |
Largest movers
| 23 HVAC | (26,400) |
| 09 Finishes | (17,100) |
| 01 General Requirements | (9,400) |
| 22 Plumbing | (5,050) |
Open exposure
Cost code detail
Projected final cost = cost to date + remaining committed + uncommitted budget + unapproved change order exposure + PM forecast adjustment| Original budget | Approved COs | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 01 General Requirements | 26,900 | — | 26,900 | 8,950 | 24,350 | 11,950 | 36,300 | (9,400) | 67% | 88% |
| 02 Existing Conditions | 18,000 | — | 18,000 | 17,950 | 17,950 | 0 | 17,950 | 50 | 100% | 100% |
| 03 Concrete | 3,000 | — | 3,000 | 3,050 | 2,850 | 200 | 3,050 | (50) | 93% | 93% |
| 06 Wood & Plastics | 23,900 | — | 23,900 | 23,700 | 17,500 | 6,200 | 23,700 | 200 | 74% | 73% |
| 07 Thermal & Moisture | 3,000 | — | 3,000 | 3,050 | 2,650 | 400 | 3,050 | (50) | 87% | 86% |
| 08 Openings | 15,000 | 2,900 | 17,900 | 17,400 | 14,700 | 2,700 | 17,400 | 500 | 84% | 84% |
| 09 Finishes | 71,800 | — | 71,800 | 71,300 | 63,600 | 25,300 | 88,900 | (17,100) | 72% | 82% |
| 21 Fire Suppression | 9,000 | — | 9,000 | 9,000 | 8,150 | 850 | 9,000 | — | 91% | 87% |
| 22 Plumbing | 26,900 | 4,600 | 31,500 | 36,550 | 33,300 | 3,250 | 36,550 | (5,050) | 91% | 90% |
| 23 HVAC | 41,900 | — | 41,900 | 57,000 | 53,800 | 14,500 | 68,300 | (26,400) | 79% | 80% |
| 26 Electrical | 59,800 | 9,800 | 69,600 | 70,200 | 61,900 | 8,300 | 70,200 | (600) | 88% | 86% |
| Total — 11 cost codes | 299,200 | 17,300 | 316,500 | 318,150 | 300,750 | 73,650 | 374,400 | (57,900) | 80% | 85% |
Rows expand to the subcontracts, purchase orders and invoices behind the committed and actual figures. Committed on every line is the sum of the commitments listed inside it; actual is the sum of the invoices and direct costs booked against it.
Subcontractor insurance certificates on this job: 17 firms under contract, 0 with an expired or expiring certificate.