Choosing a profitability measurement tool to replace our existing complex (Excel) approach
Budgeting, Business/IT alignment, CRM, Data warehousing applications, Project management, ROI & cost justification, Sales force automation applications, SAP, Updates from SearchCRM.com staff
Our current approach relies on data from over 20 different business usnits round the world, which operate on different GL platforms. Our core business is car leasing to major corporate clients where some costs and results are estimated till the car is sold after, say, 3 years.
I am wondering whether instead of an Activity Based Costing Tool we should simply look at using a Budgeting Tool bearing in mind the time span and the resulting need for dynamic updates. All the Budget Tool needs to do in addition to budgeting is to allow for detailed allocation of overhead costs in such a way as the cost of services (per customer and product) can be estimated.
Has anyone done this with success or failure?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 11, 2005 3:48 AM
UPDATED:
August 12, 2005 7:38 AM
Answer Wiki:
A second thought after re-reading your question.
It confirms the approach of using an OLAP DB (that will ease the drill down-not only technically but also conceptually).
First you upload info from GL into OLAP DB, after you query that info through an Excel based (yes Excel, but without the complex links that you have to use in Excel to link multiple worksheets)that reads from OLAP and once the calculation required is done, sends back to the OLAP DB the info for further processing or reporting.
In this way and using different scenarios to store the actual-precalculated-data and the calculated data, you can store this two sets of data, even allowing for a third or more scenarios to let different users feed adjustemts (either from the country units or product lines/account managers) distinguishing and registering who has done what
Regards
Patricio
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
