Cartonization Logic

Closed

This project is to write the system logic for a cartonization function.

Cartonization is the process of evaluating the contents of an order to determine the number and size of each shipping carton required for the order.

This will be ported into our warehouse management system (WMS) by our own developers.

The solution can be written in SQL or Visual Basic, (or similar)

We will provide scenario examples and data

Functional Description.

The solution is required to enable a warehouse operation to pre-determine the size & number of cartons required.

Specifications

Data Available

• linear or cubic measurements

• weight

• data is internally relative – i.e. M3, M, cm,

• Some data may be missing. (I.e. the Item may have Cube (m3) data, but no Length, width or height).

SKU/ITEM dimensions

• Length, width and Height (LxWxH)

• CUBE (Note – in some cases ONLY Cube will be provided)

• Gross Weight

• Nesting Factor –expressed as an incremental increase in 1 dimension, when # units is greater than 1. (X,Y,Z direction and a factor)

Carton/Tote information – CALLED CARTON GROUP

• Carton Type – Grouping of Carton Sizes into a single type. Types will be assigned to Item Lines

• Preference ranking (1 to N) – e.g. – preference is to use MEDIUM – but as required, due to single DIM or MAX, other carton may be used.

• Length, width and Height (LxWxH)

• MAX CUBE

• MAX WEIGHT

• MAX UNITS

• CUBE FILL TOLERANCE e.g. MUST Achieve 85% cubic fill.

Other Data -:

• PICKING SEQUENCE is provided - this is based on the “LOCATION” from which the SKU/Item will be picked

o This will determine the sequence for the item/location records

• Setting: SPLIT ZONE CARTONIZATION – (set at the Owner Level ) - use the picking sequence to sort the initial pass of item/locations into Carton, if a carton falls below its fill tolerance, and there are still remaining picks inside or outside the current zone, then consider those items for placing into this carton.

o else use the picking sequence to sort the initial pass of item/locations into Carton, if there are NO remaining picks within the current zone, then finish the carton.

• Setting: MIXING RULES (based on flags at the SKU/Item Level, Set at owner Level.)

If Flag ‘Item Grouping Cartonization’ = 1 then check SUSR1-5 fields in Orderline, different values may not be mixed in a single carton, first product in carton will determine what other groups can be placed in there. If any of the fields are different, then put them into a new carton.

o ORDER TYPE: If Flag ‘Order type Grouping Cartonization’ = 1 then check TYPE field in Order, items with different Order Types may be mixed in same carton/tote.

o CARTON GROUP: if 2 different Orderlines are linked to different CARTON GROUP – then they cannot be mixed.

• Setting: CONSILIDATION RULES (Set at owner Level): Keep SKU Together’ = 1 then try to keep all SKU’s from the same location in one (or more) cartons

Cartonization Logic

It will process each of the item details sequenced by pick location sequence.

A sequential ID will be set for each item line

The selected Carton type and Size will be returned with ID.

• Do NOT exceed Max fill tolerance of Cube based on total cube plus current cube

• Do NOT exceed Max weight of carton based on total Weight plus current weight x Qty

• Do NOT exceed Carton Length when Length > 0

• Do NOT exceed Carton Width when Width > 0

• Do NOT exceed Carton Height when Height > 0

• Do NOT exceed Max Units of carton

• If Nesting flag is enabled at the SKU/Item level check nesting

If the system cannot find a carton for a specific item line, then carton size can be sent back as OVERSIZE, with a single ID for that item/line.

Skills: Logistics & Shipping, Mathematics, SQL, Technical Writing, Visual Basic

See more: cartonization logic, cartonization, cartonization flag, visual basic x, types of use cases, find developers for product, enabled plus, dimension data, developers of visual basic, data warehouse process, contents of product description, write some sql for a project, WMS, warehouse management, Pick basic, m3, logic x, incremental function, keep max height, system sku, data grouping, sql operation, find sequence, check assigned number, sort contents

Project ID: #4015077

14 freelancers are bidding on average $8768 for this job

technosystem

We have just finished one VB software and ready to accept another VB project for our team. Thanks

$5000 USD in 30 days
(2 Reviews)
6.5
WebDesignall

Hi We are experts in this topic, our team have the quality and experience to make this project outstanding, we have phd level in all our professionals, we are very serious please check our profile and reviews, thank More

$5000 USD in 45 days
(30 Reviews)
6.3
funnyfox

Please check Private Message Board for detail.

$5000 USD in 20 days
(7 Reviews)
5.6
mstechIN

Hi, We can complete this using .Net(vb) Please check PM. Thanks Rahul

$4500 USD in 30 days
(39 Reviews)
5.0
feninsoftech

Hi, This can be designed in C# windows application with database in SQL Server. I have 7 years experience in .NET development. Please check below URL for one of my client application for truss shop: www.tod More

$4000 USD in 60 days
(3 Reviews)
3.5
cpptula

I know the algorithm. See PM

$5000 USD in 60 days
(5 Reviews)
3.4
ProWebProgrammer

KINDLY PROVIDE A PROFESSIONAL PROJECT SPECIFICATION DOC // THE PROVIDE INFO ISNT USEFUL TO DETERMINE THE EXACT PROGRAMMATIC DESIGN FOR THE SYSTEM !/

$65000 USD in 90 days
(1 Review)
3.0
WJ6I3zLa1

We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. www.<b><i>Removed by Admin</i></b>

$4000 USD in 1 day
(0 Reviews)
0.0
PETRA

Ready to start.

$5000 USD in 60 days
(0 Reviews)
0.0
neel13191

We are a team of 4 VB experts, will deliver best quality fr a reasonable cost...

$3500 USD in 30 days
(0 Reviews)
1.0
jr593

I can do this job for you. Please check PM for more detail.

$4250 USD in 15 days
(0 Reviews)
0.0
Webwingtechology

Dear Sir, Kindly Check PMB, For further discussion of your Project In Details... Many Thanks, Nikhil Pawar Webwing Technologies PVT Limited Business Development Executive

$5000 USD in 55 days
(0 Reviews)
0.0
Appication79

Kindly check PMB for our skills in relevant technologies and projects. Thank you

$4500 USD in 60 days
(0 Reviews)
0.0
antfilfon

I'm interested in your project. I'm a software developer with very good math and statistics proficiency. You can check my work here.

$4000 USD in 30 days
(0 Reviews)
0.0
MuV0Q2L4t

We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. <b><i>Removed by Admin</i></b>

$4000 USD in 1 day
(0 Reviews)
0.0