Forum Discussion
Calculating equal batches
Hi Jessica231
So there's probably a more elegant formula way of doing this but I've approached it using a table
Let me know if it works for you
Could you attach a sample Excel file to help demonstrate what you want to achieve please,
Thanks
Wyn
Wyn Hopkins Thanks ! I hope this helps.
Basically my batches of red and blue always consist of 200 or 190 units so it quite easy to calculate.
On the other hand orange and purple batch size varies depending on my order. The important thing is for my batches to consist of between 100 and 200 units and be equal. I hope that makes sense.
As you probably guessed I m very new to this and not exactly well versed in excel terminology. I hope I provided the necessary info. Thanks again
So there's quite a few calculations going on here that I'll need some help to understand
Why does the Quantity represent. Quantity of what?
The yellow cell is taking the total Quantity and splitting it by 200 items to get the number of batches of Red items
The Green cell is splitting it by 210 items (you mention 190 in your post) to get the number of batches of Blues
I'm not clear on what you want the formula to do for Orange or Purple?
Wyn Hopkins So the quantity represents the amount of tubs ordered. I calculate the quantities in 142g tubs and 170g tubs as this is the unit of measurement for my batches.
My apologies you are right for the blue it is batches of 210 not 190.
The formula for the orange and purple are meant to calculate the minimum amounts of equal sized batches (each batch being between 100 and 200 tubs of 170g) depending on the order. If the order is lower than 100 than a batch of 100 wi still have to be made. Does that make sense?
Basically I want the system in the case of me having an order of 300 to make 2 batches of 150. Does that make sense?
- e.g if you have 75 units they won't fit in a 100 unit batch so what happens then?
- So some scenarios that may help me understand
if you have 360 units of orange you want to do 3 batches of 120
If you have 300 units of orange you want to do 2 batches of 150 or do you want 3 batches of 100
if you have 330 units of orange = 3 batches of 110 or 2 batch of 165?
If you have 450 units of orange want 3 batches of 150?