I have 10 customer that utilise all my capacity. My problem is constructing a model where I reduce the capacity and identify which customers to remove? I have attached a sample file.
Thanks in advance
I have 10 customer that utilise all my capacity. My problem is constructing a model where I reduce the capacity and identify which customers to remove? I have attached a sample file.
Thanks in advance
Is there a simple formula to do this or do I need VBA?
Hi Aland.
I saw your thread from the day before Yesterday but i am not able to understand...
Which is the result that you expect and why?
If capasity redused to 135? To 100? To 50?
What is your second attachment?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
The second attachment is not mine? If I reduce the capacity from 140 to 120, I have to remove capacity of 20 from existing customers. I want to remove the 20 customers with the lowest profit margin.
Thanks in advance
I hope to understand well....
Thanks very much for your effort. If I reduce the capacity by 1, it removes cust 5 & cust 8 which reduces the capacity by 10? It should only remove capacity of 1.
Thanks in advance
It's reduce one Cust eatch time, but reduce 2 if they have the same Margin.
In this case both Cust, have a Margin of 7%.
You could just use conditional formatting to highlight the customers that represent cumulative capacity (col F) beyond the allocated capcity (G2).
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Thank you. That is easy & works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks