CWICR Escalation Calculator

CWICR Escalation Calculator

Business Case

Problem Statement

Construction costs change over time:

• Inflation affects all costs
• Material prices fluctuate
• Labor rates increase annually
• Long projects need escalation

Solution

Time-based cost escalation using historical indices, projected rates, and category-specific escalation factors.

Business Value

• Future pricing - Estimate costs at construction time
• Budget planning - Account for inflation
• Contract pricing - Escalation clauses
• Historical analysis - Adjust past costs to current

Technical Implementation

import pandas as pd
import numpy as np
from typing import Dict, Any, List, Optional, Tuple
from dataclasses import dataclass
from datetime import datetime, date
from dateutil.relativedelta import relativedelta
from enum import Enum


class EscalationType(Enum):
    """Types of escalation."""
    LABOR = "labor"
    MATERIAL = "material"
    EQUIPMENT = "equipment"
    GENERAL = "general"