C
chappers1972
Hello
I have built a forecasting spreadheet with 20 tabs in Excel but am
convincved a database would be a better vehicle, the data included and
required is as follows
I have Production volumes split by Product number (There are over 400) split
by market (There are 17 markets) and by file type (New account, replacement
and renewal) I have at hand actual volumes going back to January 2004
What I need is to be able to forecast product usage over a 12 month period
in advance EG at this time I am forecasting Nov 07 to Oct 08 and this would
increase one month every month.
The rules I am using for a forecast is split into New, reps and renewals
New accounts average of last three months (then average of two months and
one forecast, then 1 actual month and 2 forecast etc , etc)
Replacements the same
renewals, three year renewal cycle New accounts + renewals from three years
ago for Consumer products and two year cycle for Corporate
Once I have a forcast by product type I would then want to be able to
analyse the data and put in any adjustments by file type, this is required
because the actual volumes are derived from dispatch date so if production is
running behind there will be an off kilter volume.
That's pretty much it, to be honest I have a working model which encompasses
20 odd tabs and is sized at 17MB at the moment which is far too big
I am quite up on Access and have designed at least 4 databases which are
being used by our department, my weakness is in the report design and any
VBA, I can use basic VBA but am working on higher level stuff.
Any advice for this project would be appreciated and worth a beer or two
(Promise)
My enthusiasm is endless and I am extremely open for any suggestions on this
matter
Thanks very much to any answers to this
PS if you want any more detailed info please email me direct
Paul Chapman
I have built a forecasting spreadheet with 20 tabs in Excel but am
convincved a database would be a better vehicle, the data included and
required is as follows
I have Production volumes split by Product number (There are over 400) split
by market (There are 17 markets) and by file type (New account, replacement
and renewal) I have at hand actual volumes going back to January 2004
What I need is to be able to forecast product usage over a 12 month period
in advance EG at this time I am forecasting Nov 07 to Oct 08 and this would
increase one month every month.
The rules I am using for a forecast is split into New, reps and renewals
New accounts average of last three months (then average of two months and
one forecast, then 1 actual month and 2 forecast etc , etc)
Replacements the same
renewals, three year renewal cycle New accounts + renewals from three years
ago for Consumer products and two year cycle for Corporate
Once I have a forcast by product type I would then want to be able to
analyse the data and put in any adjustments by file type, this is required
because the actual volumes are derived from dispatch date so if production is
running behind there will be an off kilter volume.
That's pretty much it, to be honest I have a working model which encompasses
20 odd tabs and is sized at 17MB at the moment which is far too big
I am quite up on Access and have designed at least 4 databases which are
being used by our department, my weakness is in the report design and any
VBA, I can use basic VBA but am working on higher level stuff.
Any advice for this project would be appreciated and worth a beer or two
(Promise)
My enthusiasm is endless and I am extremely open for any suggestions on this
matter
Thanks very much to any answers to this
PS if you want any more detailed info please email me direct
Paul Chapman