9.2 Job Cost Accounting, CSI Cost Codes & Variance Reporting

Job Cost Accounting, CSI Cost Codes & Variance Reporting

Core Concept: In construction financial management, general ledger accounting records historical transactions for legal, financial, and tax reporting, but job cost accounting provides real-time operational control. An integrated job cost system connects field labor timecards, material purchase orders, subcontractor payment applications, and equipment logs directly to standard cost codes, enabling project managers to detect cost and schedule deviations long before they manifest on monthly profit-and-loss statements.

---

Job Cost Ledger Architecture and General Ledger Integration

A successful construction accounting system operates on a dual-ledger architecture:

1. The General Ledger (GL): Maintains summary-level financial balance sheet and income statement accounts according to standard Chart of Accounts rules (Assets, Liabilities, Equity, Revenue, Expense).
2. The Job Cost Subledger (JCS): Maintains granular, project-level, phase-level, and task-level cost accounting for every active project.

Every financial transaction posted to a project must simultaneously update the general ledger control accounts and the specific job cost subledger line item:

• Control Account Reconciliation: Direct project costs are posted to the GL asset account Construction Work in Progress (WIP) or the expense account Cost of Construction. At the close of every accounting period, the total costs recorded across all active project files in the job cost subledger must tie out perfectly to the GL control account balance.
• Committed Costs vs. Incurred Costs: A primary pitfall in construction accounting is tracking only incurred costs (invoices entered into accounts payable). A robust job cost ledger integrates committed costs—legally binding purchase orders issued to suppliers and executed subcontracts with trade contractors. If a contractor has a $100,000 structural framing budget and has paid $20,000 in labor but executed an $85,000 subcontract, tracking only incurred costs falsely suggests an $80,000 budget surplus when the project is actually committed to a $5,000 cost overrun.

---

CSI MasterFormat and Company Cost-Type Conventions

Standardized cost coding supports estimating, field reporting, and historical analysis. CSI MasterFormat supplies widely used six-digit work-result section numbers. It does not prescribe one universal set of single-digit resource suffixes.

A contractor may layer its own documented cost-type convention onto the CSI phase:

Project Number – CSI Section – Company Cost Type

For example, one firm might define 1-Labor, 2-Material, 3-Subcontract, 4-Equipment, and 5-Other/Job Overhead. Another firm may use different numbers or more detailed subcategories. The accounting system, estimate, purchase orders, timecards, and field reports must use the same company chart consistently.

Company-convention example: If the firm’s written chart defines cost type 3 as subcontract, code 26-085-033100-3 can identify Project 26-085, CSI Section 03 31 00 (Structural Concrete), and subcontract cost. The suffix meaning comes from the company chart, not from CSI MasterFormat itself.

---

Daily Field Labor Tracking and Burdened Labor Accounting

Field labor is the most volatile and risk-laden cost element in contracting. Material prices and subcontract bids are typically fixed through purchase orders and subcontracts, but labor profitability depends entirely on daily field productivity.

Daily Timecard Reporting

Superintendents and foremen must submit daily time records that allocate each employee's working hours to specific CSI phase codes and cost categories. Timecards must record two critical parameters:

1. Labor Hours Expended: Separated by standard time and overtime for each employee.
2. Physical Quantity of Work Installed: Daily units placed (e.g., linear feet of underground conduit, square feet of drywall hung, cubic yards of concrete placed).

Fully Burdened Labor Rate

Contractors must never evaluate labor costs based solely on raw hourly wage rates. A carpenter earning $28.00 per hour incurs substantial statutory and mandatory employer overhead:

• Employer FICA / Medicare: 7.65%
• Federal Unemployment Tax (FUTA): 0.60% (on statutory wage base)
• Florida State Unemployment Tax (SUTA): Variable based on employer experience rating
• Workers' Compensation Insurance: Based on Florida NCCI class codes (e.g., roofing or structural steel rates can exceed 20% to 30% of gross payroll)
• General Liability Allocation: Variable based on gross payroll volume
• Fringe Benefits: Employer-paid health insurance, retirement match, paid time off

A $28.00 base hourly wage frequently results in a fully burdened labor rate of $39.00 to $44.00 per hour. If the job cost ledger posts only raw wages, labor costs are severely understated until year-end payroll reconciliations wipe out projected profits.

---

Earned Value Management (EVM) and Budget vs. Actual Variance Reporting

Earned Value Management (EVM) integrates project scope, schedule, and cost performance into objective, quantifiable metrics.

The Three Foundational EVM Parameters:

1. Budgeted Cost of Work Scheduled (BCWS) / Planned Value (PV): The baseline dollar value of work scheduled to be completed up to the reporting date according to the original project schedule.
2. Budgeted Cost of Work Performed (BCWP) / Earned Value (EV): The budgeted value of work physically completed on site to date: $\text{Percentage of Physical Completion} \times \text{Budget at Completion (BAC)}$.
3. Actual Cost of Work Performed (ACWP) / Actual Cost (AC): The total direct costs incurred and posted in the job cost ledger for the work completed to date.

Calculating Key Variances and Indices:

• Cost Variance (CV): $\text{CV} = \text{BCWP} - \text{ACWP}$. A positive value indicates performance under budget; a negative value reveals a cost overrun.
• Schedule Variance (SV): $\text{SV} = \text{BCWP} - \text{BCWS}$. A positive value indicates progress ahead of schedule; a negative value denotes project delay.
• Cost Performance Index (CPI): $\text{CPI} = \frac{\text{BCWP}}{\text{ACWP}}$. A value $> 1.00$ reflects favorable cost efficiency; $< 1.00$ reflects cost inefficiency.
• Schedule Performance Index (SPI): $\text{SPI} = \frac{\text{BCWP}}{\text{BCWS}}$. A value $> 1.00$ indicates schedule acceleration; $< 1.00$ indicates project slippage.
• Estimate at Completion (EAC): Forecasts total project cost based on current performance: $\text{EAC} = \frac{\text{BAC}}{\text{CPI}}$.

---

Labor Productivity Tracking: Unit Man-Hours

To manage craft labor before financial statements are published, project managers monitor Unit Man-Hours:

$\text{Unit Man-Hours} = \frac{\text{Actual Man-Hours Expended}}{\text{Actual Installed Physical Quantity}}$

For example, if an electrical contractor estimates 0.05 man-hours per linear foot to install 20,000 linear feet of EMT conduit (1,000 budgeted labor hours), the field crew must average at least 20 linear feet installed per man-hour. If field tracking reveals the crew is expending 0.08 man-hours per linear foot (12.5 feet per hour), the project is operating at a severe labor deficit.

---

Early Project Trends as Warning Indicators

Cost and schedule trends identified during the early portion of a project deserve immediate investigation because fewer options remain as procurement and installation progress. A low CPI or deteriorating unit productivity at 15%–25% completion can be a serious warning, but no universal research rule makes the trend mathematically permanent or assigns a fixed probability of recovery. Managers should validate quantities, coding, committed costs, estimate-to-complete assumptions, scope changes, and schedule constraints before revising the forecast.

Immediate Corrective Interventions:

1. Crew Restructuring: Rebalance craft labor ratios (e.g., pairing skilled journeymen with productive apprentices).
2. Means and Methods Modification: Shift from field fabrication to off-site prefabrication or specialized mechanical equipment.
3. Unapproved Scope Capture: Verify that field crews are not performing extra work demanded by owner representatives without written Change Order Requests (COR).
4. Notice of Delay/Dispute: Issue timely written notice of site condition delays under contract notice provisions (e.g., AIA Document A201 Section 15.1.3).

---

Summary Table: EVM Formulas, Metrics, and Interpretations

---

Real-World Variance Scenario: Commercial Framing Package

A Florida drywall and framing contractor is executing a hotel interior partition package:

• Budget at Completion (BAC): $500,000 (comprising $200,000 Labor, $250,000 Material, $50,000 Equipment)
• Baseline Schedule Target at Week 8: 30% of total work scheduled ($\text{BCWS} = \text{\textdollar}150{,}000$)
• Week 8 Field Audit: 24% physical completion confirmed ($\text{BCWP} = 24\% \times \text{\textdollar}500{,}000 = \text{\textdollar}120{,}000$)
• Job Cost Subledger at Week 8: $160,000 direct costs posted ($\text{ACWP} = \text{\textdollar}160{,}000$)

Performance Calculations:

1. Cost Variance (CV): $120,000 - $160,000 = -$40,000 (Cost overrun of $40,000).
2. Schedule Variance (SV): $120,000 - $150,000 = -$30,000 (Schedule deficit of $30,000).
3. Cost Performance Index (CPI): $120,000 / $160,000 = 0.75 (The contractor receives $0.75 of value for every dollar expended).
4. Schedule Performance Index (SPI): $120,000 / $150,000 = 0.80 (Progressing at 80% of scheduled velocity).
5. Estimate at Completion (EAC): $500,000 / 0.75 = $666,667 (Projected $166,667 loss at completion).

Actionable Outcome: Because this variance was flagged at the 24% milestone, management audited field logs and discovered the drywall crew was framing non-standard curved soffits not shown on structural drawings. The contractor immediately submitted an unapproved change order claim for $140,000 and restructured the crew, halting uncompensated work before financial collapse.