You cannot order half a pallet, so let ABC Analyzer round up to the nearest possible pack- or pallet size for you.
“Rounding up to the nearest pack size” is a mathematic function that helps you round up to the nearest possible pack size using the generated order suggestion.
WHY ROUNDING UP TO THE NEAREST PACK SIZE?
Avoid calculating the nearest pack size by hand by letting ABC Analyzer calculate how many packs/pallets you need to buy to meet the demand. This recipe always round up making sure that you have bought enough.
COLUMNS NEEDED IN THE CALCULATION:
MCeil([Order suggestion],[Pack size])
You can choose to use two other formulas: MRound and MFloor, and enter them in the normal formula window. MRound rounds off to nearest whole number, while MFloor always rounds down.