Analysing changes in weekly sales forecast

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
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,224,537
Messages
6,179,405
Members
452,911
Latest member
a_barila

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top