Dashboard
DG
Active Sites
12
3 critical · 2 delayed
↑ 2 this month
Open Tenders
4
Potential: $2.4M
Win rate: 62%
Monthly Revenue
$840K
vs $780K last month
↑ 7.7%
Cash Position
$312K
Forecast: -$45K in 30d
⚠ Review needed
Critical Alerts
🔴
Site A7 – Oran Highway: Budget overrun by 18%. Immediate review required.
🟠
Tender TND-2024-09: Submission deadline in 3 days. DQE not finalized.
🟠
Stock Alert: Ready-mix cement below safety threshold (14t remaining).
🟢
Site B3 – Algiers Ring: Milestone reached on schedule. Invoice issued.
Monthly Expenses by Site
Last 6 months
JanFebMarAprMayJun
Recent Activity
Purchase Order #BC-447 approved
Today 09:14 · Procurement
Daily report submitted – Site C5
Today 08:30 · Chef de chantier
New tender registered: Tizi-Ouzou Bridge
Yesterday 15:45 · AO Team
Maintenance alert: Crane #ENG-12
Yesterday 11:00 · Equipment
Invoice $38,000 received from Fournisseur SARL
2 days ago · Finance
Active Construction Sites
Live status overview
SiteClientContract ValueProgressStatusAction
A7 – Oran HighwayMinistry of Works$1.2M
72%
At Risk
B3 – Algiers RingWilaya d'Alger$890K
55%
On Track
C5 – Sétif BridgeAPC Sétif$640K
38%
Delayed
D1 – ConstantineOPGI Constantine$2.1M
88%
On Track
Open Tenders
4
Total potential: $4.1M
Win Rate
62%
Last 12 months
Deadline This Week
2
Urgent action needed
Won YTD
7
Value: $8.7M
Tender Register
RefProject NameClientSubmissionValueDQEStatusActions
TND-2024-09Tizi-Ouzou BridgeDTP Tizi3 days$1.4MIn ProgressOpen
TND-2024-08Annaba Port RoadPort Auth.12 days$2.2MReadyOpen
TND-2024-07Batna BypassMinistry—$900KDoneWon ✓
TND-2024-06Ghardaïa Solar RoadAPC Ghardaïa—$540KN/ALost—
DQE Editor — TND-2024-09 Tizi-Ouzou Bridge
Price schedule · Preliminary margin: 18.4%
#DescriptionUnitQtyUnit Price ($)Total ($)Margin %
1Earthworks – Type Am³$54,00022%
2Concrete B25 – Pilesm³$71,40015%
3Steel Reinforcementton$119,00019%
4Asphalt Surfacingm²$117,60021%
Subtotal: $362,000 Margin: 18.4% Grand Total: $428,408
Total Sites
12
8 active · 2 pending · 2 done
Total Contract Value
$14.8M
Ongoing projects
Delayed Sites
3
Requires attention
Avg. Progress
61%
Physical completion
Site: A7 – Oran Highway
At Risk
Client
Ministry of Public Works
Contract Value
$1,200,000
Start Date
03 Mar 2024
Deadline
30 Sep 2024
Physical Progress
72%
Site: D1 – Constantine
On Track
Client
OPGI Constantine
Contract Value
$2,100,000
Start Date
15 Jan 2024
Deadline
31 Dec 2024
Physical Progress
88%
Site Planning — A7 Oran Highway
Gantt View
Week 1Week 2Week 3Week 4Week 5Week 6Week 7Week 8
Site Preparation
Done
Earthworks
75%
Foundation
50%
Concrete Works
30%
Road Surface
Pending
Final Inspection
—
Task Details
TaskAssigned ToPlanned StartPlanned EndActualStatus
Site PreparationTeam Alpha03 Mar10 MarOn timeComplete
EarthworksTeam Beta11 Mar05 Apr2d delayIn Progress
FoundationTeam Gamma01 Apr20 Apr5d delayIn Progress
Concrete WorksTeam Beta15 Apr15 May—Upcoming
Road SurfaceTBD01 Jun20 Jun—Planned
Daily Reports
Report — 14 Jun 2024
Submitted
Site
A7 – Oran Highway
Weather
☀️ Sunny, 34°C
Workforce Present
24 workers
Activity
Earthworks Zone B – 120m³ excavated
Incidents
None
Field Needs
Gravel delivery needed (20t)
Submit New Report
Total Equipment
34
Operational
28
In Maintenance
4
Fuel This Month
12,400L
Equipment Fleet
IDTypeModelAssigned SiteFuel (L/month)StatusNext Service
ENG-01ExcavatorCAT 336A7 – Oran1,840Operational30 Jul
ENG-02BulldozerKomatsu D65B3 – Algiers2,200Operational15 Aug
ENG-12CraneLiebherr LTMD1 – Constantine900Maintenance⚠️ Now
ENG-18Concrete PumpPutzmeister M36C5 – Sétif640Available10 Sep
SKUs in Stock
142
Below Threshold
7
Stock Value
$284K
Movements (30d)
63
Inventory
ItemCategoryLocationQtyUnitMin ThresholdAlert
Ready-Mix CementMaterialMain Warehouse14ton50⚠ Low
Steel Bars (12mm)MaterialSite A7340ton100OK
Diesel FuelConsumableDepot8,200L2,000OK
Aggregate 20mmMaterialMain Warehouse80m³120Monitor
Open POs
11
Pending Approval
4
Month Spend
$192K
Suppliers
28
Purchase Orders
PO #SupplierItemsAmountSiteStatusAction
BC-447Ciments d'AlgérieCement 200t$38,000A7 OranApproved
BC-446Sider Steel SARLSteel Bars 50t$72,000D1 ConstantinePending
BC-445Naftal FuelDiesel 10,000L$12,400All SitesDelivered
Total Employees
184
On Site Today
142
On Leave
18
Monthly Payroll
$246K
Employee Directory
NameRoleSiteContractStatusAction
Karim BenaissaChef de ChantierA7 – OranCDIActive
Sonia MezianeEngineerD1 – ConstantineCDIActive
Omar ZianiMachine OperatorB3 – AlgiersCDDOn Leave
Nadia HamidiAccountantHQCDIActive
This Month
$412K
vs $380K budget
Overbudget
+$32K
8.4% over
Pending Approval
6
YTD Expenses
$2.8M
Expense Register
DateDescriptionSiteCategoryAmountApproved ByStatus
14 JunCement deliveryA7 OranMaterials$38,000Dir. TechniqueApproved
13 JunCrane rental JuneD1 ConstantineEquipment$14,500PendingAwaiting
12 JunLabor overtimeB3 AlgiersHR$8,200RHApproved
10 JunFuel top-upAll SitesFuel$12,400DGApproved
Current Balance
$312K
Expected Receipts (30d)
$480K
Planned Payments (30d)
$525K
Forecast Gap
-$45K
⚠ Financing needed
Incoming Payments
ClientAmountExpectedStatus
Ministry of Works$180,00020 JunPending
Wilaya d'Alger$120,00025 JunInvoiced
OPGI Constantine$180,00005 JulForecast
Outgoing Payments
Supplier / TypeAmountDueStatus
Ciments d'Algérie$38,00018 JunDue
Payroll June$246,00030 JunScheduled
Equipment Rental$48,00001 JulForecast
Site Profitability Analysis
SiteInitial BudgetActual SpendVarianceGross MarginEst. Final MarginStatus
A7 – Oran$1,020,000$784,000-$164K over12.4%9.8%At Risk
B3 – Algiers$756,000$398,000+$42K under21.2%19.6%Healthy
D1 – Constantine$1,785,000$1,620,000+$28K under18.9%17.4%Healthy
C5 – Sétif$544,000$218,000On track—16.0%In Progress
Total Files
1,284
Added This Month
47
Expiring Bonds
2
Categories
12
Document Library
DocumentCategoryRelated ToDateFormatActions
Contract A7 Oran SignedContractSite A702 Mar 2024PDF
DQE TND-2024-09 v2DQETender TND-0911 Jun 2024XLSX
Caution Provisoire BC-44BondTender TND-0801 Jun 2024PDF
Plan B3 Rev3 AlgiersPlansSite B320 May 2024DWG