Praveen313
New Member
Hi
I am trying to create an Raw material mix optimisation table in excel .
But i m really stuck
Could anyone please help me ..
Let me explain what i m trying to do
1. I have multiple Raw materials for assembing a product
2. Each Raw material has different attributes (points )
3. I have a limit on cost ( i.e 38)
4. I have a limit on max number of raw materials to be used
5. I am trying to increase the total points howver each attributes need to have minimum points
I have attached the excel sheet
Please help ....
I am trying to create an Raw material mix optimisation table in excel .
But i m really stuck
Could anyone please help me ..
Let me explain what i m trying to do
1. I have multiple Raw materials for assembing a product
2. Each Raw material has different attributes (points )
3. I have a limit on cost ( i.e 38)
4. I have a limit on max number of raw materials to be used
5. I am trying to increase the total points howver each attributes need to have minimum points
I have attached the excel sheet
Please help ....