Excel Solver help

%3CLINGO-SUB%20id%3D%22lingo-sub-2942738%22%20slang%3D%22en-US%22%3EExcel%20Solver%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2942738%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20excel%20sheet%20where%20I%20need%20a%20help%20in%20adding%20constraint%20to%20my%20model.%20I%20want%20my%20decision%20variables%20(C49%3AC63)%20to%20be%20in%20same%20or%20close%20proportion%20to%20the%20proportion%20of%20forecast%20which%20is%20given%20in%20cell%20B27%3AB41.%20How%20can%20I%20add%20the%20constraint%20in%20such%20a%20way%20that%20the%20proportion%20is%20maintained.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2942738%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

 

I have attached an excel sheet where I need a help in adding constraint to my model. I want my decision variables (C49:C63) to be in same or close proportion to the proportion of forecast which is given in cell B27:B41. How can I add the constraint in such a way that the proportion is maintained.

 

Thanks

0 Replies