Product capacity formula

I have a simple (i thought) spreadsheet. I have 12 products that need to run each week. Each product has a demand but is restricted by capacity. The products have to run under the capacity "and" according to the run percentage. So if

"Product line #1" has a higher "Production Mix %" then it has to run according to its percentage number while all lines being under capacity. I hope this makes since. I have attached a book to show what I mean.

Thank you

Cap Planning.xlsx

Yes!!! It is amazing how simple it becomes the moment someone else looks at the problem. My mind goes one way and the problem goes the other. Thank you!!