Forum Discussion
Number of Cartons in a Pallet
Hi,
Can anyone help in calculating number of pallets from the cartons.
https://agraga-my.sharepoint.com/:x:/p/anshul_marele/EQKvNC6sBVpPn98fmLZeSh0B-qOVuXUiVdJWg-54BjHvDQ?e=MkwKLZ
Problem Statement: How many cartons can be accommodated into a Pallet?
Case#1: When cartons are of single dimension (Length, Width, Height) in a consignment
Case#2: When cartons are of multiple dimensions (Length, Width, Height) in a consignment
Note#1: Length & Width can be flipped for optimum utilization of the pallet
Note#2: Height can't be flipped
Note#3: There is maximum cap of L,W, H & Weight in a pallet
Output Required: Pallet-wise output required
Thanks
1 Reply
Before looking at your file, I thought this sounded very much like a school assignment,
After looking at your file, I'm pretty much convinced that it is a school assignment.
Most of us who try to help people out with their Excel problems have agreed that we're not here to do homework for students. We generally would be willing to help if said student showed any effort in trying to get to the solution and simply ran into a roadblock, and was unable to get through that. So offering a suggestion under that kind of circumstance is OK.
If indeed you are a student--as I'm speculating--then I'm sending you back to take a decent stab at solving this on your own. That, my friend, is how you'll learn; not through having somebody solve it for you. If after devoting an hour or more to it (and showing what you've tried) you still are up against a roadblock, then come back, show us what you've tried, how you've scoped it out, what steps you've taken......
And if, per chance, you are not a student, then come back and give a plausible explanation for how such a neatly laid out spreadsheet appeared in your Excel window without your having some idea of how to approach it.
