Projection based on 2 sets of data with percentages

I have 2 sets of data that have multiple rows with percentages and am trying to project what the second set of data will be based on row percentage. I would need each individual row's projection as well as total. The last row of the data that provides the percentages is a total. Below is an example.

Formula:

Please Login or Register  to view this content.

Based on the above percentages, how many cookies can I expect from each batch and total based on 2 rows of cookies as follows with percentages taken from above?

Formula:

Please Login or Register  to view this content.

So, using Chocolate as an example, 22% of 300 and 60% of 200 do not equal 41% of 500. To do this correctly, would I have to ignore the total row percentages and just use the sum of each individual row? Am I completely wrong? Is there a better way to do this I'm not thinking of?

Hi,

On the Total row I see that you have taken average of %s and these are incorrect (41% and 59%). They should be 37% & 63%

Try the following formula in B4:

=((B2*$A2)+(B3*$A3))/SUM($A2:$A3)

See the attached file.

Yes! I knew there was a problem with the percentages, I just couldn't figure out what it was. Thanks!