blazy Member May 14, 2020 #1 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.
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.
H Hany ali Active Member May 14, 2020 #2 ok , Where's the File ?!!! Upload the file please with Explanation Can't guess !!!!!
blazy Member May 14, 2020 #3 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 Chadnoo_ordine.xlsx 33.2 KB · Views: 3
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.
blazy Member May 16, 2020 #4 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.
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.
