Calculating Prorate Storage Cost

[MAA022]

Hi all,

Kindly help me on this issue (or please refer another thread with similar case as mine if there is any).

The case is as follow:
I need to calculate the storage charge of my item (let's say SKU A) which need to be paid only once the item is out of storage, the movement type is FIFO, and if the outing SKU is sourced from multiple entry date, it will need to be paid accordingly based on the entry date.

Example : 150pcs is out in 09MAR which is sourced from Qty in from 05MAR 100pcs, and Qty in from 08MAR 50pcs


Thank you and God Bless you all

SIMPLIFICATION.xlsx
	A	B	C	D	E	F	G	H
1	table in				table out
2	date in	SKU	QTY		DATE OUT	SKU	QTY	INV COST
3	05-Mar	A	100		09-Mar	A	150	?
4	08-Mar	A	200		10-Mar	A	100
5	09-Mar	A	100		14-Mar	A	200
6	10-Mar	A	200		18-Mar	A	100
7	14-Mar	A	150
8	15-Mar	A	200
9
10
11	INV COST	500	/UNIT/DAY
Sheet2

 

[MAA022]

Oh and if possible not using VBA since we need to share to external parties, so if VBA is shared the system may detect as malicious