Enterprise · Forecasting system
APP Projection
Quarterly cost forecasting
A step-by-step workflow for quarterly cost forecasting — from supplier files, through price checks, to a signed forecast.
The challenge
The quarterly cost forecast was built by hand from supplier files in different formats. Checking that every price made sense took days, and mistakes surfaced only after the forecast was signed.
What I built
- 01
Automatic file intake
Supplier and manufacturer files are read and normalized automatically, so the forecast starts from one consistent table.
- 02
Price audits
Every quoted price is compared to the RFQ price. Overcharges, under-prices, RFQ-only parts, and supplier mismatches each get their own filter.
- 03
Consistency review
Prices that jump between quarters or don't match across sources are surfaced for review before they reach the forecast.
- 04
Approvals and export
The forecast goes out for approval by email and is exported to Excel in the format the finance team already uses.
Let's build something together
Interested in learning more about this project or working together?
Get in touch