Has anyone had this situation and how did you resolve it?
Customer sends us a forecast for the year, by item. They are going to buy $1,200,000 of product in the year 2025. The distribution is $100,000 per month estimated spend.
We also want to compare what they said they forecast to actual spend (invoices).
This becomes a rolling 12-month forecast so it can span multiple calendar years.
In late February they tell us they want to change the forecast and move the $50,000 for March to April. April now becomes $150,000.
