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 ```python 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" class AdjustmentMethod(Enum): """Methods for rate adjustment.""" FIXED_AMOUNT = "fixed_amount" PERCENTAGE = "percentage" MULTIPLIER = "multiplier" REPLACEMENT = "replacement" @dataclass class RateChange: """Record of rate change.""" resource_code: str rate_type: RateType old_rate: float new_rate: float change_percent: float change_date: datetime reason: str source: str @dataclass class RateUpdateResult: """Result of rate update operation.""" ...