Budget & Resource Planning

TEIRAC provides a robust suite of tools for managing project financials and human capital. By integrating budget tracking, cost estimation, and resource allocation into a single interface, project managers can maintain a real-time view of project health and financial variance.

Financial Management

The financial suite is divided into two primary modules: Budget Items for tracking actual spend against targets, and Estimates for pre-construction or procurement planning.

Budget Tracking

The Budget module allows you to monitor expenditures across different categories. This data feeds directly into the Project Dashboard to calculate the overall budget utilization percentage.

Fields tracked:

• Category: The functional area (e.g., Labor, Materials, Logistics).
• Budget Amount: The total allocated funds for this category.
• Spent Amount: The actual expenditure recorded to date.
• Note: Contextual information regarding variances or specific vendors.

Estimates & Costing

Use the Estimates module to build bottom-up cost projections. This module is designed for granular tracking of unit-based costs.

Fields tracked:

• Item & Type: Description and classification of the resource.
• Quantity & Unit Cost: The basis of the financial calculation.
• Total Cost: Automatically calculated as qty * unit_cost.
• Variance %: Indicates the deviation from the baseline estimate.

// Example Estimate Row Structure
{
  item: "Reinforcement Steel",
  type: "Material",
  qty: 50,
  unit_cost: 1200,
  total_cost: 60000,
  variance_pct: "2%"
}

Resource Planning

The Resource Plan module ensures that the project is adequately staffed and that team members are not over-allocated. It provides a roadmap for human resource distribution across the project timeline.

Allocation and Availability

Project managers can define roles and assign specific individuals to project phases, ensuring that expertise is utilized efficiently.

• Role & Name: Identify the position and the assigned professional.
• Allocation %: The percentage of the individual's total working time dedicated to this specific project.
• Timeline: Defined via Start Month and End Month to track deployment duration.
• Availability: A status indicator (e.g., "Available", "Unavailable") to flag potential staffing bottlenecks.

Performance Metrics (KPIs)

Financial and resource data are synthesized into high-level KPIs visible on the Project Dashboard. These metrics provide an instant health check of the project's economic standing:

• Budget Utilization: A visual progress bar showing Budget Used vs. Total Budget.
• CPI (Cost Performance Index): A derived metric (accessible via dashboard analytics) that indicates the cost efficiency of the project.
• Financial Status Badges: Projects are automatically flagged as At Risk or Delayed if the budget variance exceeds predefined thresholds.

Bulk Data Management

For large-scale projects, TEIRAC supports bulk importing of financial and resource data via CSV. This is accessed through the Import action on the Project Page.

Supported Import Schemas

| Module | Required CSV Columns | | :--- | :--- | | Budget | category, budget_amount, spent_amount, note | | Estimate | item, type, qty, unit_cost, total_cost, variance_pct | | Resource Plan | role, name, allocation_pct, start_month, end_month, availability |

To import data, ensure your CSV headers match the internal keys listed above to facilitate seamless mapping to the Supabase database.