Where are the Profits?
Outline
A Cosmetics distributor has a wide-ranging change in the Business organisation model. Now it needs a change in reporting to support this. Please do this very quickly and cheaply
Status – on going
Project
Find a way to report from sales to Profit before Tax on a business unit basis and in a way understood by management.
Issues
Likely change in the Accounting and stock control package made it desirable to find a quick fix low cost solution
Actions
Using the existing Excel based Management reporting I developed a revised version using the same layout that reported on the new business lines by careful matching of coding between reports
.
Current position
Client uses this monthly and will replace it in its next financial year when the new accounting package is bedded down.