CWICR Material Procurement

CWICR Material Procurement

Business Case

Problem Statement

Material procurement needs accurate quantity lists:

• What materials are needed?
• How much of each with waste allowance?
• When are they needed on site?
• How to group for suppliers?

Solution

Generate procurement lists from CWICR material data with waste factors, delivery scheduling, and supplier grouping.

Business Value

• Accurate quantities - Based on validated norms
• Waste included - Industry-standard waste factors
• Timely delivery - Aligned with schedule
• Cost optimization - Bulk ordering opportunities

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 MaterialCategory(Enum):
    """Material categories for procurement."""
    CONCRETE = "concrete"
    STEEL = "steel"
    TIMBER = "timber"
    MASONRY = "masonry"
    FINISHES = "finishes"
    MEP = "mep"