Mayuga Construction Job Costing

The challenge

Before

Mayuga Construction was running 14 active design-build projects across Cavite and Laguna, with each project tracked across three separate Excel workbooks — one for procurement, one for labor, one for billing. Reconciling actual cost against project estimate took a 2-person finance team four full days at month-end, and by the time variances surfaced, the cost overruns were already baked in. Project managers had no way to see live cost-to-date on their sites without calling head office.

• Three separate Excel workbooks tracking procurement, labor, and billing per project
• Month-end variance analysis taking finance team four working days
• No live cost-to-date visibility for site project managers
• Subcontractor billings reconciled manually against signed work orders
• Material requests sent over Viber with no audit trail back to purchase order
• Labor logs captured on paper time cards and entered weekly with delays
• Change orders tracked in a shared folder with no link to revised budget
• No role-based access — every workbook was edited by every team member

The solution

What we built

We built a job costing platform with 19 integrated modules tailored to Filipino design-build economics. Project budgets are captured at the BOQ line level, then linked downstream to every purchase order, delivery receipt, subcontract, and time card raised against that project. Site managers log labor and material consumption from their phones; finance sees cost-to-date refresh inside 60 seconds. The procurement module handles purchase requests, supplier quote comparison, PO issuance, and partial deliveries with automatic three-way matching against invoice and receiving report. Subcontract management tracks signed scope, progress billings, retention, and final closeout. A change-order workflow keeps the originally-approved budget intact while overlaying approved and pending revisions. Reporting includes a project P&L dashboard, AR aging by project, supplier cycle-time analysis, and a cost-variance heatmap that flags any line item drifting beyond a configurable threshold. We also built a small mobile-first portal so site engineers can request materials and approve deliveries without opening a laptop.

How the system flows

1. BOQ Import→Project Budget→Cost Code Mapping→Live P&L
2. Material Request→Quote Comparison→PO→Receiving→Three-way Match
3. Subcontract Award→Progress Billing→Retention Held→Final Closeout
4. Time Card Entry→Daily Labor Cost→Project Costing→Crew Productivity Report
5. Change Order→Approval Routing→Revised Budget Overlay→Audit Trail
6. AR Invoice→Collection Schedule→Project Cash Position

• Supplier Cycle Time Analysis with on-time delivery scoring
• Cost-variance heatmap flagging any line drifting beyond threshold
• Mobile material request and delivery approval for site engineers
• Role-based access scoped per project, per role, per cost-code group