Length is measured on the longest side of the package. Girth is the measurement around the middle of the package, and is calculated as 2x width + 2x height. Package shipment limits are set by the carrier. I would be particularly interested in seeing your algorithm expressed in SQL, but solutions in a procedural language such as Java, PHP, or C will definitely be useful also.You can use the following package types to ship your products with Shopify Shipping labels. Your algorithm should not only compute the minimal cost but it should return the optimal arrangment of bottles among the different size boxes. Using the table of the arrangements above, find an algorithm for computing the optimal arrangement with respect to the shipping cost for shipping a set of x 200ml bottles, y 375 ml bottles, and z 750 ml bottles. SQL Table Configurationsįor example, the first row in the table says 5,0,0 and indicates that the medium box can hold 5 200 ml bottles, and no other bottles. Also, the large box costs $14.50 and the medium box costs $10.70 to ship ( ). The table below, which I will call the configurations table lists the possible arrangements of each bottle in each size of box. For example, a medium box can hold 3 200ml and 2 375ml bottles or it can hold 4 200 ml bottles and 1 375ml bottle, and there are many other possible arrangements depending on the number of each size bottle. Thus, there are different arrangements of the bottles in each box which can work. Moreover, due to the shape of the bottles only a certain number of bottles can fit in each box, and due to their shape the cost minimization cannot be detemined by computing using the volume of each box and the bottle volumes. Additionally, my client ships their fluids in the three bottle sizes: 200ml, 375ml, and 750ml. My client uses two box sizes: the medium flat rate boxes, and the large flat rate boxes. Anything that fits in the box, ships for one low price. If you are unfamiliar with USPS flat rate boxes, they are boxes of a certain volume that ship regardless of weight. I have a client who ships fluids in USPS flat rate boxes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |