CWICR Labor Scheduler

CWICR Labor Scheduler

Business Case

Problem Statement

Project managers need to plan labor allocation:

• How many workers per day?
• What skills are needed when?
• How to balance workload across project phases?
• How to avoid resource conflicts?

Solution

Data-driven labor scheduling using CWICR labor norms to generate crew schedules, loading curves, and skill requirement timelines.

Business Value

• Accurate planning - Based on validated labor norms
• Resource leveling - Smooth workload distribution
• Skill matching - Right workers at right time
• Cost control - Optimize labor costs

Technical Implementation

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 ShiftType(Enum):
    """Work shift types."""
    SINGLE = "single"      # 8 hours
    DOUBLE = "double"      # 16 hours (2 shifts)
    TRIPLE = "triple"      # 24 hours (3 shifts)
    EXTENDED = "extended"  # 10 hours