BYD Sales Forecast Portal

Built from a national dealer-planning workbook, this portal converts annual targets into dealer-by-model plans using seasonality, tracks actual sales against plan and produces dealer-level reporting.

From workbook to system

The workflow removes repeated filtering and manual report preparation. Dealers, models, targets and splits can be updated centrally, while actuals can be pasted in and reconciled against expected names.

Validation

The planning logic was checked back against the source workbook so the portal preserved the existing commercial method rather than inventing a new forecast model.