Month-end production costing, automated
C# · WPF · SQL Server
Problem. Costing for the paper and corrugated lines took about a month of manual work at each month-end, so finance was working months behind.
Built. A costing module that combines activity cost balances with production process data already in the ERP to compute the cost per product. It flags raw materials with abnormal costs and shows each product's list price next to its cost, so thin margins stand out.
Result. Runs in seconds instead of taking a month of manual work, so costing is now finished by the 15th of the following month. It surfaced manual costing errors across several past months, which finance corrected, and identified products that were being sold at very thin margins. Additionally, a companion sales analysis program I built also made thin margins visible, and caught a negative margin on stock bought at a high price during the pandemic.
- Production process dataWhich products ran through which activities
- Activity cost balancesMonth-end balances per activity
- Cost per productAllocated across the lines
- Compare with list priceMargin per product
- FlagAbnormal raw-material costs and thin margins
Part of a .NET 9 / WPF inventory application modernized from the legacy ERP, with management-summary and data-integrity modules.


















