Yard
Well-known Member
- Joined
- Nov 5, 2008
- Messages
- 1,929
Looking for some inspiration today...
I have a set of data which details the weekly sales forecasts we have received for the last 10 weeks. Each of these forecasts shows the weekly demand for the following 4 weeks for 6 products.
Example:
The forecast from Week 15 shows the weekly demand for Products A to F for weeks 15,16,17 and 18
The forecast from Week 16 shows the weekly demand for Products A to F for weeks 16,17,18 and 19
etc.
The objective is to create a view of that data which illustrates / highlights the products with the greatest forecast fluctuations.
I have normalized the data into the following format:
Product WeekOfForecast WeekOfDemand Qty
ProductA 15 15 100
ProductA 15 16 100
ProductA 15 17 100
ProductA 15 18 100
ProductA 16 16 100
ProductA 16 17 150
ProductA 16 18 50
ProductA 16 19 100
ProductB 15 15 25
ProductB 15 16 25
ProductB 15 17 25
ProductB 15 18 25
ProductB 16 16 30
ProductB 16 17 30
ProductB 16 18 30
ProductB 16 19 30
A quick visual would show that Product A's demand for Week 17 increased from 100 to 150 between receiving the forecast in Week 15 and receiving the forecast in Week 16. At the same time, the demand for that product in Week 18 fell by the same amount.
I have a few options already for tabulating and charting this, but am not happy with any of them and would appreciate any input from you guys!
Thanks
Yard
I have a set of data which details the weekly sales forecasts we have received for the last 10 weeks. Each of these forecasts shows the weekly demand for the following 4 weeks for 6 products.
Example:
The forecast from Week 15 shows the weekly demand for Products A to F for weeks 15,16,17 and 18
The forecast from Week 16 shows the weekly demand for Products A to F for weeks 16,17,18 and 19
etc.
The objective is to create a view of that data which illustrates / highlights the products with the greatest forecast fluctuations.
I have normalized the data into the following format:
Product WeekOfForecast WeekOfDemand Qty
ProductA 15 15 100
ProductA 15 16 100
ProductA 15 17 100
ProductA 15 18 100
ProductA 16 16 100
ProductA 16 17 150
ProductA 16 18 50
ProductA 16 19 100
ProductB 15 15 25
ProductB 15 16 25
ProductB 15 17 25
ProductB 15 18 25
ProductB 16 16 30
ProductB 16 17 30
ProductB 16 18 30
ProductB 16 19 30
A quick visual would show that Product A's demand for Week 17 increased from 100 to 150 between receiving the forecast in Week 15 and receiving the forecast in Week 16. At the same time, the demand for that product in Week 18 fell by the same amount.
I have a few options already for tabulating and charting this, but am not happy with any of them and would appreciate any input from you guys!
Thanks
Yard