• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Selecting parts / rows to get the most turnover in one column with least loss in second column

blazy

Member
Hello.

Easy one for you guys:

Column A: potential turnover for 1 part (row)
Column B: RVC (profit; can be + or -)

Question:

I want to select the parts (rows) to get the most turnover and most RVC possible.

If necessary I can post Excel file.

Thank you.
 

blazy

Member
Dear,

find attached Excel file with random numbers.

My goal is to select the parts (rows) to get to most possible turnover (column C), but with least possible loss / higher possible profit (Column D).

Which parts should I order ?

Thank you.
 

Attachments

blazy

Member
My constrains could be:

Units (B column) can variate up to +-10%
Turnover (C column) I am happy with anything up to 200.000€
Profit / loss (D column) I can afford to lose up to 15.000€

Thank you.
 
Top