Recipe: Round up to the nearest pack size

You cannot order half a pallet, so let ABC Analyzer round up to the nearest possible pack- or pallet size for you.

WHAT:

“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:

• Ordering size (in pcs) (NUMBER)
• Pack size (NUMBER)

FORMULA:

MCeil([Order suggestion],[Pack size])

For example:
The system suggests that you buy 88 pcs, but the minimum purchase is 50 pcs.
MCeil(88,50) = 2

RELATED FORMULAS:

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.

• Round off to the nearest whole number: MRound([Number to order],[Pack size])
• Round down to the nearest whole number: MFloor([Number to order],[Pack size])