Carton box calculation for dress

Hi good evening...

We have mutiple styles / sizes of garment (dress) to calculate number of carton boxes to pack. Also we have multiple carton sizes, and each size carton having individual capacity.
Each style garment having individual weight and so it will occupy in different quantities, if the carton sizes are remains same.
We have input of size wise / style wise garment quantity and also we have carton capacity / style / size to calculate how much cartons we required to pack.
Here i have attached the chart and pls trigger your valuable formula to make this magic.

Hi Mr Shorty...
Thanks for your time to check my problem.
I believe excel functions to solve this problem. So i will wait for the right one, who knows to do this magic.

Looking at your uploaded file I think you only make 6 different styles of garments but the size of each style goes from S to 5XL. It also seems that you have a minimum and a maximum number of garments in a box. Looking at cells O4 and P4 I think you must have a minimum of 92 garments size small and a maximum of 111. Right or wrong?

How about box cost? Is this perhaps something that should be taken in account? Say 55 garments style 1 could be packaged in two boxes 60X40X10 or just one box 60X40X20. Probably the latter but it could be other constraint like packing, storing facilities and transportation that should be considered.

Alf

Hi Alf,
Pls note, don't limit the styles as 6. it may goes till 50.
The Sizes are totally 8 but not same as S to 5XL. This data required to edit based on garment sizes.
You are right on the concept of minimum and maximum quantity per carton.
To consider about the cost of carton box, we have to fill the pieces from bigger cartons to smaller carton.
i.e. we have 100pcs in 4xl size, first fill the catron 60x40x40 - 91 pcs
The balance 9pcs goes to carton size 60x40x10

Hope you understand and thanks for your interest.

Hi.. Anybody trying to work this problem? Its pleasure to wait with confidence..

A first attempt to see if this is something you could use. This is a solver based setup. Having min and max values for the different boxes made it a bit tricky for me
to set up. Hopefully bsalv or Hydraulic will take a look at this and suggest a better model.

For a number of garments one could use a VBa loop to get the different result. The macro is written for Excel 2019 should work in Excel 2023. But macros and solver will
not work in an Mac environment.

Alf

Hi Hydra...
Really its simple and working good. Thanks for your valuable formula.