Equipment Fleet Manager

Technical Implementation

import pandas as pd from datetime import date, timedelta from typing import Dict, Any, List, Optional from dataclasses import dataclass, field from enum import Enum

class EquipmentStatus(Enum): AVAILABLE = "available" IN_USE = "in_use" MAINTENANCE = "maintenance" REPAIR = "repair" RETIRED = "retired"

class EquipmentType(Enum): CRANE = "crane" EXCAVATOR = "excavator" LOADER = "loader" FORKLIFT = "forklift" GENERATOR = "generator" COMPRESSOR = "compressor" SCAFFOLDING = "scaffolding" OTHER = "other"

@dataclass class MaintenanceRecord: record_id: str equipment_id: str maintenance_type: str scheduled_date: date completed_date: Optional[date] cost: float notes: str = ""

@dataclass class Assignment: assignment_id: str equipment_id: str project: str location: str start_date: date end_date: Optional[date] operator: str = ""

@dataclass class Equipment: equipment_id: str name: str equipment_type: EquipmentType make: str model: str year: int status: EquipmentStatus hourly_rate: float daily_rate: float current_hours: float = 0 last_maintenance: Optional[date] = None next_maintenance_hours: float = 500 assignments: List[Assignment] = field(default_factory=list)

class EquipmentFleetManager: def init(self, company_name: str): self.company_name = company_name self.equipment: Dict[str, Equipment] = {} self.maintenance_records: List[MaintenanceRecord] = {} self._equip_counter = 0 self._assign_counter = 0

def add_equipment(self, name: str, equipment_type: EquipmentType,
                 make: str, model: str, year: int,
                 hourly_rate: float, daily_rate: float) -> Equipment:
    self._equip_counter += 1
    equip_id = f"EQ-{self._equip_counter:04d}"

    equip = Equipment(
        equipment_id=equip_id,
        name=name,
        equipment_type=equipment_type,
        make=make,
        model=model,
        year=year,
        status=EquipmentStatus.AVAILABLE,
        hourly_rate=hourly_rate,
        daily_rate=daily_rate
    )
    self.equipment[equip_id] = equip
    return equip

def assign_equipment(self, equip_id: str, project: str, location: str,
                    start_date: date, operator: str = "") -> Assignment:
    if equip_id not in self.equipment:
        return None

    self._assign_counter += 1
    assign_id = f"ASN-{self._assign_counter:04d}"

    assignment = Assignment(
        assignment_id=assign_id,
        equipment_id=equip_id,
        project=project,
        location=location,
        start_date=start_date,
        end_date=None,
        operator=operator
    )

    self.equipment[equip_id].assignments.append(assignment)
    self.equipment[equip_id].status = EquipmentStatus.IN_USE
    return assignment

def return_equipment(self, equip_id: str, hours_used: float):
    if equip_id in self.equipment:
        equip = self.equipment[equip_id]
        equip.status = EquipmentStatus.AVAILABLE
        equip.current_hours += hours_used
        if equip.assignments:
            equip.assignments[-1].end_date = date.today()

def schedule_maintenance(self, equip_id: str, maintenance_type: str,
                        scheduled_date: date, cost: float):
    if equip_id not in self.equipment:
        return
    record_id = f"MNT-{len(self.maintenance_records) + 1:04d}"
    record = MaintenanceRecord(record_id, equip_id, maintenance_type,
                              scheduled_date, None, cost)
    self.maintenance_records[record_id] = record

def get_available_equipment(self, equipment_type: EquipmentType = None) -> List[Equipment]:
    available = [e for e in self.equipment.values()
                if e.status == EquipmentStatus.AVAILABLE]
    if equipment_type:
        available = [e for e in available if e.equipment_type == equipment_type]
    return available

def get_utilization_report(self) -> Dict[str, Any]:
    in_use = sum(1 for e in self.equipment.values()
                if e.status == EquipmentStatus.IN_USE)
    total = len(self.equipment)
    return {
        'total_equipment': total,
        'in_use': in_use,
        'available': sum(1 for e in self.equipment.values()
                        if e.status == EquipmentStatus.AVAILABLE),
        'maintenance': sum(1 for e in self.equipment.values()
                          if e.status == EquipmentStatus.MAINTENANCE),
        'utilization_rate': round(in_use / total * 100, 1) if total > 0 else 0
    }

def export_fleet(self, output_path: str):
    data = [{
        'ID': e.equipment_id,
        'Name': e.name,
        'Type': e.equipment_type.value,
        'Make/Model': f"{e.make} {e.model}",
        'Year': e.year,
        'Status': e.status.value,
        'Hours': e.current_hours,
        'Daily Rate': e.daily_rate
    } for e in self.equipment.values()]
    pd.DataFrame(data).to_excel(output_path, index=False)

Quick Start

fleet = EquipmentFleetManager("ABC Construction")

crane = fleet.add_equipment("Tower Crane #1", EquipmentType.CRANE, "Liebherr", "280 EC-H", 2020, 150, 1200)

assignment = fleet.assign_equipment(crane.equipment_id, "Office Tower", "Site A", date.today(), "John Smith")

report = fleet.get_utilization_report() print(f"Utilization: {report['utilization_rate']}%")

Resources

• DDC Book: Chapter 3.2 - Resource Management