Project profitability
What each project will really earn: contract and approved variations, minus cost to date, open orders and the cost still to come.
Export
TS-26-017 Oasis Walk is heading for a 16.6% margin, not 22%.
That is AED 11,480 less profit than planned: the 9-day delay and the client's design change added cost that is not billed yet.
Forecast profit · 6 active
AED294,210411,910
Average margin 21.4% · target 22%Average margin 30.0% before own labour
Revised contract value
AED1,373,700
1,363,900 + VO-01 9,800 approved on TS-26-016
Cost to date + committed
AED495,250
349,150 spent · 146,100 ordered · of 1,079,490
Below the 22% target
3 of 6
017 · 16.6%019 and 020 just under
Profit by project
AED excl. VAT · forecast cost = spent + committed + estimate to completeShowing margins before own labour. Salaries of the site crew (allocated from timesheets) are left out, so every project looks 5–12 points better. Use this view only to compare how jobs were priced — the real profit is the default view.
| Project | Revised contract | Billed | Received | Cost to date | Committed | Forecast cost | Margin | vs 22% |
|---|---|---|---|---|---|---|---|---|
| Active · 6 projects | ||||||||
| TS-26-014 · Bay View Tower L12Gulf Horizon · 62% done · contract 386,000 + VO-02 18,600 | 404,600 | 230,900 | 137,030 | 168,450 | 61,200 | 313,200290,800 | 22.6%28.1% | +0.6 ptsn/a |
| TS-26-016 · Al Noor MedicalSnagging · contract 128,500 + VO-01 9,800 | 138,300 | 100,500 | 61,200 | 81,950 | 9,400 | 106,08092,180 | 23.3%33.3% | +1.3 ptsn/a |
| TS-26-017 · Oasis Walk G-24Urban Threads · 35% done · 9 days late · IPA-01 overdue | 214,000 | 42,800 | 21,400 | 81,300 | 48,900 | 178,480153,880 | 16.6%28.1% | −5.4 ptsn/a |
| TS-26-018 · Villa 23, Arabian Ranches 2Mr. Daniel Brooks · 20% done · glass from LHP M&G | 76,800 | 0 | 15,360 | 8,150 | 22,400 | 59,21050,610 | 22.9%34.1% | +0.9 ptsn/a |
| TS-26-019 · Barsha Pearl windowsCrescent FM · 8% done · 48 windows | 242,000 | 0 | 0 | 9,300 | 4,200 | 189,480167,680 | 21.7%30.7% | −0.3 ptsn/a |
| TS-26-020 · Spice Route KitchenStarts 12 Oct · advance 44,700 by PDC 15 Oct | 298,000 | 0 | 0 | 0 | 0 | 233,040206,640 | 21.8%30.7% | −0.2 ptsn/a |
| Completed · final figures | ||||||||
| TS-26-008 · Atlas Logistics, Jebel AliHanded over 15 Jun · retention 4,800 to invoice now | 96,000 | 96,000 | 91,200 | 73,900 | 0 | 73,90064,700 | 23.0%32.6% | +1.0 ptsn/a |
| TS-26-011 · Bean Theory CaféHanded over 21 Aug · cracked panel replaced free 25 Sep | 54,000 | 54,000 | 45,967 | 43,100 | 0 | 43,10037,300 | 20.2%30.9% | −1.8 ptsn/a |
| Active total | 1,373,700 | 374,200 | 234,990 | 349,150 | 146,100 | 1,079,490961,790 | 21.4%30.0% | |
Billed = work certified in IPAs and variations · advances (018, 020) are not income until recovered · received excludes VAT.
All projects
Forecast margin vs target
Scale 0–30% · black line = 22% targetBefore own labour · scale 0–40% · black line = 22%At or above targetWithin 2 pointsMore than 2 points belowCompleted
Own labour in project costs
Site crew salaries are allocated to projects from GPS timesheets (September: 87% of labour hours on projects). The rest stays in operational expenses. Switch to “Without” to compare pricing only.
Profit is not cash yet
Money spent on each active project vs money received from its client · AED excl. VATTS-26-014−31,420
Received 137,030 · spent 168,450 · IPA-02 104,680 due 30 Oct
TS-26-016−20,750
Received 61,200 · spent 81,950 · IPA-02 due 28 Oct
TS-26-017−59,900
Received 21,400 · spent 81,300 · IPA-01 overdue 7 days
Covered by client paymentsFunded by our own cash
TS-26-014, 016 and 017 tie up AED 112,070 of company cash until the next certificates are paid.