I'm trying to assist a dietitian in creating a formula for families that scales a mixture proportionately so that a 24-hr batch of this specialty infant formula maintains the correct ratio of infant formula to additives. The slightly tricky part is that it's not a direct multiplication, so it's not just multiplying each number by, for example, 8 feedings per day. The infant formula comes in a few specific bottle sizes and they want the family to simply pour in the entire larger bottle into the mixing pitcher and then this will calculate out how much of each supplement they need to add, maintaining the original ratio.
The picture below is my illustration. We will know the sample values shown in the image of 224 mls (main infant formula), 66 mls (supplement 1), and 56 mls (supplement 2), which we know gives us a 64.7: 19.1: 16.2 ratio. We will also know that the main formula comes in a 1,892 ml bottle so that's our starting point. The calculation I need is for the two yellow cells. Thanks for your help!
The picture below is my illustration. We will know the sample values shown in the image of 224 mls (main infant formula), 66 mls (supplement 1), and 56 mls (supplement 2), which we know gives us a 64.7: 19.1: 16.2 ratio. We will also know that the main formula comes in a 1,892 ml bottle so that's our starting point. The calculation I need is for the two yellow cells. Thanks for your help!
