Opening and Closing Inventory

PrevContributor
PrevContributor
in Modeling

Hi, A quite usual topic easy to solve with Anaplan is the Opening / closing inventory formula. Here is my proposal. Feel free to share yours.

 
Line item Formula
Initial Value  
Opening Inventory PREVIOUS(Closing Inventory) + Initial Value
Input  
Output  
Closing Inventory Opening Inventory + Input - Output 
Alternative solution  
Opening Inventory with POST POST(Closing Inventory, 1) + Initial Value.
I  

Kind regards. Michel.

Tagged:

Best Answer

  • bhavik_vashi
    bhavik_vashi
    Answer ✓
    Great set-up Michel.  Very simple and very clean.  This is how I would set it up as well.

Categories