*** NEED HELP WITH MATH PROBLEM - NOT BENGALS RELATED ***

[-GoBengals-]

OK at work im trying to fix a batch thats fucked up.

 

Here is what the batch currently is, and then what i want it to be.

 

problem is an ingredient was missing from the original.

 

 

these are all Milliliters. the first number column is per 100ML bottle. the second is whats currently in the 20L batches.

 

no PG is in the top batch, and its mixture was an old recipe.

 

whats the final batch size need to be to make the percentages and recipe from the top batch equal to the percentages in the bottom one.

 

 

[KA14_HOF]

Are you still working on this, or have you resolved it?

[-GoBengals-]

perhaps both.

 

here is what i came up with. Always happy to have more eyes on it. it has me wnding up increasing the 20L batch to a 34.565 liter batch, im able to get the flavoring percentages to 4.69(instead of 4.7) the sweetener to .91(instead of.92) and the PG to 15.04(instead of 15) and VG to 69.99 (instead of 70) which is all perfectly acceptable. 

 

if it can be done more efficiently than the 34+ liter batch or if ive miscalculated, im open to a better resolution.

 

Tossing the batches made is about a $3500 loss in ingredients. so if it can be avoided, thatd be great.

 

[-GoBengals-]

BATCH FIX BREAKDOWN.xlsx

 

attached spreadsheet in case anyone wants to see what formulas i have in there.

[Cricket]

No need to add some of EVERY ingredient, just determine which one limits you.  

 

Hold your 1586, 1586, 1586, 240 as is. (1586.3??)

 

PG to 5000

VG to 23,333

 

Total of 33,333 (depending upon how #s round off)

 

I’m a bit loopy on pain meds (kidney stone laser removal), but I think I’ve nailed this.  

[Cricket]

Note: I assumed the ratios within the flavors/sweetener group was okay…but that maybe isn’t the case.  

[Cricket]

8 minutes ago, Cricket said:

Note: I assumed the ratios within the flavors/sweetener group was okay…but that maybe isn’t the case.  

keep the 1586s as they are.  Bump up Sweetener to 310.5.  
 

PG to 5068.5

VG to 23,652.7

 

 

 

Not a whole lot less than where you ended up, but this requires no additional Flavors.

[AmishBengalFan]

The steps are:

 

1 - Add the missing ingredient to bring the proportions up to the proper ratios, then

2 - Add ALL ingredients, proportionally, until the total size is correct.

 

Think of it this way, you've got a pie with each slice corresponding to an ingredient.  Only it's the wrong size and an entire slice was left out.  So, you first fill in the missing slice so you've got a complete pie, then you shrink/grow the entire pie to get it to the proper size.

 

If the proportions in the original pie are all fucked up AND you're missing a slice.  Then find the one (or many) ingredient(s) that exceed their desired proportion by the largest amount.  You lock-inTHAT slice and add to the other slices to match proportionally, then fill in the missing ingredient(s) to bring the entire pie up to the desired proportions.... THEN shrink/grow the pie to the proper size.

 

The rest is just math.

[-GoBengals-]

Ah thanks. I’ll give this a shot and report back. Without the new ingredient it was very simple. With it made it not just a “least common denominator” 8th grade math problem. 
 

I’ll be in the office in 90 minutes to see where it lands. Then I’ll go piss off the production team with it. lol

[-GoBengals-]

8 hours ago, Cricket said:

keep the 1586s as they are.  Bump up Sweetener to 310.5.  
 

PG to 5068.5

VG to 23,652.7

 

 

 

Not a whole lot less than where you ended up, but this requires no additional Flavors.

 

this worked out and lowered the batch by a liter or so. thanks!

 

4 hours ago, AmishBengalFan said:

The steps are:

 

1 - Add the missing ingredient to bring the proportions up to the proper ratios, then

2 - Add ALL ingredients, proportionally, until the total size is correct.

 

Think of it this way, you've got a pie with each slice corresponding to an ingredient.  Only it's the wrong size and an entire slice was left out.  So, you first fill in the missing slice so you've got a complete pie, then you shrink/grow the entire pie to get it to the proper size.

 

If the proportions in the original pie are all fucked up AND you're missing a slice.  Then find the one (or many) ingredient(s) that exceed their desired proportion by the largest amount.  You lock-inTHAT slice and add to the other slices to match proportionally, then fill in the missing ingredient(s) to bring the entire pie up to the desired proportions.... THEN shrink/grow the pie to the proper size.

 

The rest is just math.

 

thats the jumps i kept having issues with, mind you after an hour or so of breakdown down the recipes one by one trying to figure out what percentages was in each bottle we made then trying to figure out what we WANTED to be in each bottle..

 

I havent had to do any real math in many years... had to knock the rust off.

 

Thanks everyone!

[Cricket]

3 hours ago, GoBengals said:

 

this worked out and lowered the batch by a liter or so. thanks!

 

Glad to help.  I rather enjoy solving problems like this…and in high school and in college, I often had to explain how I got the right answer.  I didn’t do it “the normal way” and they couldn’t figure out how I did it.  Just wired a bit differently.  🤪

 

i’m pretty much retired right now, so enjoyed your problem.