|
|
|
Business Modelling | |||
|
Any model that can be set up in Excel can be set up in
PowerOLAP and in fact will be easier because PowerOLAP will take care of all the
additions and subtractions.
PowerOLAP is a rules based modeling, budgeting and forecasting solution. Anyone who can create an Excel formula can create a powerful PowerOLAP formula to model anything. Models can be created at the detail level such a Product and Customers sales or summary level for senior management top down reviews.
Below is a typical PowerOLAP formula: Which simply states that Gross Sales in the Sales Budget = the Units in the Sales Budget multiplied by the Gross Sales Price in the Price Book. Imagine the benefits to the organisation if each sales person’s budget or forecast sales units can be enetered into a system which then becomes the basis of: · Marketing’s trade spend / Advertising &
Promotions allowance reviews Budget and forecast numbers from the sales department
should flow through to all sectors of the organisation to reduce the duplication
of work conducted by people down the line. Enhanced reporting is valuable to
determine what happened but modeling and Writeback gives the organisation the
ability to go forward. |
|||
|
