Calculate Inventory Catch up date

sasakawar

Hi

Is there any way or function to calculate inventory catch up date?

i want to calculate 1st date that recover the sales plan.

 

 

	Jul 01	Jul 02	Jul 03	Jul 04	Jul 05	Jul 06	Jul 07	Jul 08
Sales			20				10
Production					10			20
Inventory			-20	-20	-10	-10	-20	0
Catch Up Date			Jul 08				Jul 08

in this case,

sales of july 03 will be recovered by july 05 production 10pcs and july 08 production 10 of 20pcs

so the sales is recovered completery at july 08.  i want to calculate this date.

 

Sales of july 07 will be recovered by July 08 production 10 of 20pcs

so the sales is recovered completery at july 08.

 

please let me know the idea.

 

best regards

 

sasakawa

 

?.Szyma_ski

Hi sasakawar.

If you're using Anaplan build-in timescale you'll need to add additional line items and modify them as  as per file below.

A word of explaination
Boolean items serves as watchers to indicate if specified day is Catchup date and if to display it for previous dates. You may want to adjust formulas as needed.

Catchup_Date_19576.xls