Very open ended question so obviously interested in open ended approaches. Right now we create business forecasts from the bottoms up. We have 6 segments that have a number of SKUs, and we input a bunch of monthly P&L data (Sales, costs, etc) and those accumulate up to give us forecasts for that segment. A few problems right now:
1) It's in 6 different files. Getting answers for the whole business is painful.
2) Tough to put it in 1 file, its gets too large.
The thought was to put Master Data in Access for us in Finance but keep the Excel files going for each of the managers. Have them complete their Excel file (aggregating from the bottom up), roll it up into Access for analysis, and we have Access and the 6 files talk back and forth.
My broad question is: Has anyone ever done anything like this before-especially in a case where a line by line SKU data is concerned? Is there a better method?
Again one file with all of those managers having their hands on it would result in a lot of complaining on the slowness and potential security issues since someone could inadvertently change someone else's numbers. Better for each to have their own and we guys in Finance do the backend work of having Access talk back in forth. Plus we want to do stuff like storing history (i.e. we wouldn't ever "edit" over an old entry. We would add a new entry and "turn off" the old entry so we'd have a record of changes...but that's for later.)
Thanks and sorry for such an open ended question, just brainstorming here!!
Bookmarks