+ Reply to Thread
Results 1 to 7 of 7

Appropriate Box

  1. #1
    Registered User
    Join Date
    03-06-2021
    Location
    Nairobi, Kenya
    MS-Off Ver
    2013
    Posts
    3

    Talking Appropriate Box

    Hi, Kindly help

    I am trying to create a model that uses the measurements of a product's packing (length, width, and depth) to determine the appropriate size of the packaging box (length, width, depth). For example, if I have the first product measuring 2 by 3 by 5, another measuring 3 by 4 by 2, and another measuring 3 by 2 by 5, what is the suitable box measurement that can fit the 3 products.

    I have tried to create a model but am seeing a lot of mistakes and/or considerations such as what if products are arranged in multiple layers or a single layer in the box. EVen assuming it is one layer arrange, my model seems way off

    I am looking to generate a 6-sided box that can fit x number of small products (also 6 sided with known measurements: L, W, and H are known); while minimizing the unused spaces
    Attached Files Attached Files
    Last edited by bw17269; 03-06-2021 at 08:28 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Appropriate Box

    Do we not also need to see the available box sizes???


    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Appropriate Box

    Presumably the requirement is to minimise the surface area of the 6 sides to the box.

    A basic question is do you have pre-produced boxes into which you want to fit these smaller cartons whilst minimising the unused volume. In which case we'd need to know the sizes of the packing boxes.

    Or are you looking to create a 6 sided box that will minimise the surface area for any combination of cartons?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    03-06-2021
    Location
    Nairobi, Kenya
    MS-Off Ver
    2013
    Posts
    3

    Re: Appropriate Box

    I have attached. Thanks for the guide. I am new here

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Appropriate Box

    ...and what's the answer to the question in #3 please?

  6. #6
    Registered User
    Join Date
    03-06-2021
    Location
    Nairobi, Kenya
    MS-Off Ver
    2013
    Posts
    3

    Re: Appropriate Box

    I have edited. not sure if I have answered your question.

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: Appropriate Box

    It seems to me that if you were using a single layer where the products are layed out length wise you would need to sum the lengths and get the maximum of widths and depths as all of your products as they would be end to end.
    If you were using a single layer where the products are layed out width wise you would need to sum the widths and get the maximum of lengths and depths as all of your products as they would be side by side.
    If you were using multiple layers you would only need to get the maximum of the lengths and widths and the sum of the depths as the products are stacked.
    If you are making the six sided box and want to calculate the one that uses the least material then you would multiply the 2 x length x width for the top and bottom plus 2 x length x depth for the front and back plus 2 x width x depth for the left and right.
    In the scenario presented in the file the multiple layer box would use 686.2 square inches of material, the single layer length wise box would use 862 and the single layer width wise box would use 734.6
    In the attached file the calculations are in rows 9:11 so the formula for amount of material needed is: =SUM((L9*M9*2),(L9*N9*2),(M9*N9*2))
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1