Choosing a profitability measurement tool to replace our existing complex (Excel) approach

pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following