Load Planning: Cartons per Layer, Pallet Height & Weight Limits, Pallets per Truck & Container, Cube Utilisation & Cost per Unit

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Count how many cartons fit on one pallet layer with the carton as it is and turned by 90 degrees, keep the better pattern and see how much of the pallet surface it really covers.
• Work out how many layers each SKU can stack within the pallet height limit and within the weight limit, keep the lower number and turn it into cartons and units per pallet.
• Calculate the gross weight and final height of seven built pallets, flag every pallet that breaks a limit with IF and AND, and count how many are ready to load.
• Count pallet floor positions lengthwise and crosswise for four fictional vehicles, pick the best pattern, look up the chosen vehicle with XLOOKUP and check whether its payload or its floor is the limit.
• Measure how much of a trailer's volume and payload five full loads use, name the limit that binds first and see how much weight is left on a light load.
• Turn a multi-SKU order into whole pallets, keep a running pallet count, work out how many trucks the order needs by floor positions and by weight, and how many positions are left in the last truck.
• Compare the current carton with a slimmer carton and a bigger case pack: layers, units per pallet, freight per unit and the combined freight and packaging cost per unit, then pick the cheapest design.
• Compare four load scenarios on freight cost per unit, express each as a saving against today's load, put a yearly value on the best one and show the scenarios in a chart.