Beginning of analysis: Stephanie pulls all the data using essbase and transfers to an excel file. From here she does some preliminary analysis to determine skus that need to be forecasted. Time spent 2 days
List of skus needing forecast to Planning team: When she determines which skus need to be addressed by the planning team, she emails a spreadsheet with those skus to the Planning Manager.
Waiting on Planning: Stephanie waits for the planners to action the skus needing forecast. Th e planners are angry as their job has unexpectedly been changed to accomplish this task. Time 1 week
The home stretch of analysis: Stephanie can now analyze the report after the planners actions. She must do some additional filtering of skus. Time spent 2 days.
Final clean up of report: Stephanie can now deliver her analysis to Christina the Finance Manager for final analysis. There may be back and forth here. Time spent 2 days.
Good news: Christina the Finance Manager delivers the report to the street, the board and to the auditors.