Excel Work Summary – BOP Cost Breakdown & Planning Model

Excel Work Summary – BOP Cost Breakdown & Planning Model

This Excel file presents a structured Bill of Project (BOP) and cost allocation model developed for Mini & Urban Village construction works. The model integrates construction, supervision (SD), materials, procurement, and testing & commissioning (T&C) into a single, traceable framework.

Key highlights of the work include:

Multi-disciplinary cost breakdown linking BOQ items to construction, material, procurement, and T&C activities.

Weighted cost allocation logic at both project and facility levels to ensure accurate budget distribution.

Cross-sheet validation using check and control summaries to verify totals and prevent inconsistencies.

Procurement and material mapping aligned with construction activities for clearer cost ownership.

Primavera P6–ready export sheet, enabling direct integration with scheduling and cost-loaded plans.

Overall, this file demonstrates strong capability in cost control, data structuring, planning integration, and engineering-based financial analysis, supporting informed decision-making and project performance tracking.