Hi everyone,
I hope you’ll find the following riddle easy as I’m not a math genius I’d be working on it until the end of the days.
I have started a new role recently and at this place we’re making different mixtures that consist of various components with different bag sizes.
Each mixture has a certain recipe we have to follow.
I would like to work out a calculator in excel that make it possible to work out the consumption of each component by reducing with a constant weight, starting with a known pallet weight through numerous bags finally ending up with a number that is no more sufficient to create a new mixture without starting a new pallet.
I’ll try to write it down by numbers:
starting pallet size: 240 kg
bag size: 20kg
quantity needed for each mixture recipe: 33.2 kg
So, for creating the first mixture I’ll have to take 20kg + 13.2kg of an additional bag. I will have 12.8 kg leftover for the next recipe but for this I will need a full 20kg bag plus 0.4 kg from the 3rd one, and that results of having 19.6 leftover and so on, and so on…
My aim is to reduce the time wastage of my team spending on the calculations that takes ages in some cases as these mixtures are containing 20+ components sometimes.
I’m pretty sure it’s not something that was never done however I’m not that good at functions.
Hope it’ll make someone excited and helpful!
Thanks!
Bookmarks