CWICR Rate Updater

CWICR Rate Updater

Business Case

Problem Statement

Resource rates become outdated:

• Material prices fluctuate with market
• Labor rates change annually
• Equipment costs vary by region
• Historical rates need adjustment

Solution

Systematic rate updates integrating market data, inflation indices, and regional factors while maintaining audit trail.

Business Value

• Accuracy - Current market pricing
• Flexibility - Update specific resources or categories
• Audit trail - Track rate changes over time
• Automation - Integrate with price APIs

Technical Implementation

import pandas as pd
import numpy as np
from typing import Dict, Any, List, Optional, Tuple, Callable
from dataclasses import dataclass, field
from datetime import datetime, date
from enum import Enum
import json


class RateType(Enum):
    """Types of rates."""
    LABOR = "labor"
    MATERIAL = "material"
    EQUIPMENT = "equipment"
    SUBCONTRACT = "subcontract"