Solver - Adding Constraint to maintain the proportion of variables

Hello Experts,

I have attached an excel sheet with objectives, variable and constraint defined. My Variable are from Cell C49 to C63. I want to add an constraint to make sure that the proportion of variables to the sum of variables in close to proportion of given forecast qty ( cell B27:B41). How can I add this constraint

Thanks,