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.
Hello, I am proficient with Excel and VBA and I would love to help you with this project. Please contact me for more information.
8 freelance font 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
Hi.. I am a python developer and have done tasks involving excel files using python.. I have checked the description and what I got is that you need to accumulate the record by customer number and change the revenue an Plus
I am proficient in using MS Office tools having working in the banking industry for more than 10 years.
I am basically a typist/computer operator/office assistant and having 25+ years of experience of professional data entry of all kinds with Local and International Firms. I fully read the Terms and Conditions of your pr Plus