-
Excel workbook preview
Sourcing Strategy, Procurement Planning and Category Management
Demand Forecast and Requirement Aggregation Sheet
3 downloads per free account, no card needed.
Who this is for
A buyer downloads this when departments order the same items separately and finance asks for one annual requirement that can be bought at the volume price.
What is inside
- 12 sample department lines for 5 standard items, with 24 blank rows
- Item name and price fill in from the item code; unknown codes turn red
- Forecast quantity = base x (1 + buffer), rounded up to whole units
- Change against last year's actual, amber above 25%
- Confirm-by date turns red when passed and the line is not confirmed
- Aggregation by item and quarter with price break check and saving
How to use it: Keep the item list and price breaks current, send the Demand sheet to each department with a confirm-by date, and use the aggregated quarters as the delivery schedule in the RFQ.
Files & formats
- XLSXdemand-forecast-and-requirement-aggregation-sheet.xlsx17 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



