Introduction

The Unit Cost Reduction Tracker is a financial planning and analytical project designed to track and forecast unit costs across various industries, with a strong focus on aerospace finance. It integrates analytics, forecasting, and dashboard visualization to help decision-makers:

• Monitor actual vs. target costs

• Identify favorable vs unfavorable budget variances

• Forecast future cost trajectories using historical data and simulations

• Present KPI dashboards for executives and operational teams

Insights

Budget Variance Performance

• roughly 55% of material-month data points were favorable, meaning they stayed under or on budget

• approximately 45% were unfavorable, highlighting persistent cost overruns

Material Cost Trends

• Costs rose steadily from 2006 to 2022, peaking around $9,200 (late 2022), and have been slowly declining into early 2025. This suggests stabilization in global commodity markets

Overhead Costs

• Overhead rates remained relatively flat and stable

Budget Alignment

• As costs normalized post-2022, budget variances narrowed, showing improved financial predictability

Ways to Improve the Project