We are a sales company for media equipment for the TV industry. We'd like to do an ABC analysis of our customers in terms of sales volume and margin. I have a xls file with hundreds of single invoices data rows including customer no., date, revenue and margin. It is possible that a single customer is mentioned in many rows, if he bought several times.
What we want to get is an accumulation of the of sales volume and margin of each customer. The result should be like this example: [url removed, login to view] (sorry, German picture). Column A ist cutsomer no.; column B is customer revenue (the whole table is sorted by that column); column C is sales revenue in percentage of the overall revenue; column D is an accumulation in percentage and column E is the ABC classification segmented by class A does 75% of the revenue; class B does the next 20% and class C does the last 5% revenue. I hope thats understandable.
The job should be completed by the 8th of January.
Décerné à :
8 freelance ont fait une offre moyenne de 25 € pour ce travail
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India