CNC Cost-Per-Part Breakdown Dashboard (Power BI)

This dashboard leverages Power BI’s data modeling and visualization capabilities to transform raw shop-floor data (e.g., CNC cycle times from MTConnect or MES systems, ERP bill-of-materials, labor rates, depreciation schedules) into actionable cost intelligence. At its core lies a granular cost allocation model: direct costs (material, cutting tools, coolant) are traced per part, while indirect costs (machine depreciation, facility overhead, supervision) are apportioned using activity-based costing (ABC) or time-driven ABC principles. The dashboard supports drill-down functionality—from program-level (e.g., G-code run) to feature-level (e.g., facing vs. drilling) costing—enabling root-cause identification of cost outliers. Furthermore, it incorporates scenario modeling (e.g., 'What if we switch to carbide inserts?' or 'How does batch size affect unit cost?') by parameterizing variables like tool life, feed rate, or labor utilization, thereby bridging engineering decisions with financial impact. Integration with live IoT telemetry (e.g., spindle load, tool wear sensors) allows predictive cost adjustments, making the dashboard not just retrospective but forward-looking for quoting accuracy and capacity planning.