cwicr-equipment-planner

# CWICR Equipment Planner ## Business Case ### Problem Statement Equipment is a major cost driver: - What equipment is needed? - For how long? - Rent or buy? - How to optimize utilization? ### Solution Equipment planning using CWICR equipment norms to calculate requirements, schedule usage, and analyze rental vs purchase decisions. ### Business Value - **Accurate requirements** - Based on validated norms - **Optimized utilization** - Reduce idle time - **Cost analysis** - Rent vs buy decisions - **Scheduling** - Equipment availability planning ## Technical Implementation ```python import pandas as pd import numpy as np from typing import Dict, Any, List, Optional, Tuple from dataclasses import dataclass, field from datetime import datetime, timedelta from enum import Enum from collections import defaultdict class EquipmentCategory(Enum): """Equipment categories.""" EARTHMOVING = "earthmoving" LIFTING = "lifting" CONCRETE = "concrete" COMPACTION = "compaction" TRANSPORT = "transport" POWER_TOOLS = "power_tools" SCAFFOLDING = "scaffolding" PUMPING = "pumping" PILING = "piling" OTHER = "other" class OwnershipType(Enum): """Equipment ownership types.""" OWNED = "owned" RENTED = "rented" LEASED = "leased" @dataclass class EquipmentItem: """Equipment item requirement.""" equipment_code: str description: str category: EquipmentCategory required_hours: float required_days: int daily_ra...