Opening and Closing Inventory

Highlighted
Previous Contributor

Opening and Closing Inventory

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.

1 REPLY 1
Highlighted
Group Leader - Employee

RE: Opening and Closing Inventory

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