Breakdown table: Add Budget vs Actual financial columns

[BenGWeeks]

Summary

Add financial columns to the breakdown table that accurately reflect BC's billing model.

Current State

The breakdown table shows hours worked by task/team. Previously had Unit Price and Total Price columns, but these were removed because:

• Unit Price display was confusing (task-level vs resource-level rates)
• Fixed Price projects showed irrelevant hourly rates
• Didn't distinguish between Budget vs Actual

Proposed Columns

Column	Source	Description
Hours	Timesheets	All hours (pending + approved)
Posted	Job Ledger Entry	Hours posted to ledger
Budget	Job Planning Lines	Planned/budgeted hours
Unit Price	Resource/Planning Lines	T&M billing rate
Total Price	Calculated/Ledger	Revenue

Display Logic

T&M Projects

• Show Unit Price and Total Price
• If all resources on a task have same rate → show at task level
• If different rates → show at resource level, N/A at task level

Fixed Price Projects

• Hide Unit Price column (billing not based on hours)
• Show Budget Hours and Fixed Price from Item lines

Data Required

1. Budget hours per task (from Job Planning Lines)
2. Posted hours/price per task (from Job Ledger Entry)
3. Rate consistency detection (same rate for all resources on task?)

BC Setup for Block Hours

For "Fixed Price Variable Scope" (block hours):

1. Resource Billable lines - Define block (50hrs × £100 = £5,000)
2. Resource Budget lines - Allocate hours per task
3. Shows as T&M in Thyme with Unit Price visibility

Files to Modify

• src/services/bc/projectDetailsService.ts - Add budget/posted per task
• src/components/projects/ProjectTasksTable.tsx - Conditional columns