Cost Forecasting Model Redesign

Engineer•Fortune 100 Subsidiary in Server Manufacturing

🧰 Tech & Methods

Technologies

SQLPythonVisual BasicTime Study DataCustom Costing Tools (Dynamic Calculator Models)Custom DashboardsCustom ETL PipelinesJiraConfluenceERP

Methodologies

Program ManagementData EngineeringData ScienceCost AnalysisManufacturing Process OptimizationCost Optimization ModelingForecasting AccuracyExecutive ReportingCross-Functional CollaborationRemote Team CoordinationKPI ReportingMetrics-Driven Culture

🎯 Initiative

Improve accuracy of manufacturing cost forecasting to reduce under-absorption and strengthen quoting confidence

⚙️ Key Contributions

  • Conducted and managed time studies + data analysis to uncover costing gaps
  • Re-engineered legacy spreadsheet model using SQL + Excel + Visual Basic + Python
  • Delivered executive-ready calculator with dynamic inputs for quoting
  • Created supporting reports and tools to scale adoption across global teams
  • Trusted with full resource access to ensure project success and alignment with strategic priorities

📈 Results

Summary

  • 75% reduction in global cost forecasting error (i.e. under absorption reduction), saving several million dollars annually
  • Created final costing used by execs to produce quotes that were more accurate and profitable, including $1B+ bid-winning deals
  • Model adopted as standard for customer pricing, impacting 100+ products worldwide and supporting 1,000+ global contributors across manufacturing and quoting.

Key Metrics

Under Absorption Reduction75%
Annual SavingsSeveral $M
High-Value Deal Won$1B+ single bid
Products Impacted100+ globally
Collaboration30+ Stakeholders & 1,000+ Contributors

🧠 Soft Skill Highlight

Bridged floor-level realities, executive decisions, and finance expectations to align cost strategy with real operations across 30+ Stakeholders

Example Deliverables (Try me!)

Note: The artifacts above are illustrative examples using simulated data generated from public sources. They do not reflect any proprietary or confidential information.
alexis e.g. | Simplifying Chaos