Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to get a better forecast.
Currently I create a order curve by day based on the actual flow of orders for a model catalog that mailed the year previous. After the new catalog mails, I compare its daily actual order flow to what I had projected. Say a catalog is not performing the way I expected - early on (the first 10 days) it is difficult to determine why the catalog is not performing - either it is not a great catalog or it was delayed in the mail system and will catch up as the mail gets through. I do get seed reports telling me how the mail delivery is on the catalog. Say the model book had 50% delivery in the first 7 days. I know the new book has only 35% delivery in the first seven days. How can I reforecast based on this info? The life of a catalog is 80 days, so I need to spread the adjustments out over that time. Is there a formula I could use to reforecast with the new data? Thansks, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forecasting Sales using the Forecast Function | Excel Worksheet Functions | |||
Forecasting weekday occupancy between two years | Excel Worksheet Functions | |||
FORECASTING SALES (please let this be a worksheet function) | Excel Discussion (Misc queries) | |||
Forecasting By Date | Excel Discussion (Misc queries) | |||
Excel Solver background in forecasting modeling | Excel Worksheet Functions |