In times of shortage, how do you allocate inventory to customer orders?
It is tempting to fall back on hard allocation. This could be a mistake.
Here’s why. With a download simulation to prove it.
Analytics for demand planning in Excel usually involves big tables of data.
To understand the demand for a product, you need to look into its history. An order history can easily have 100K+ records.
Here is a technique to perform fast analytical formulas on many thousand rows.