FIFO Calculation

[sreepathi]

Dear Members,

Please find the attachment of Stock Statement, where the same has been extracted from software, for the same I needed the following formulas for calculating

1​	Don't bother about heading highlighted in Yellow Color
2​	this one I have pulled out from monthly stock register by using pivot table
3​	meaning of alphabetics
	o	Opening
	p	purchase
	rp	reprocess
	s	sales
	c	closing stock
	u	Consumption
4​	Requirement
		Closing stock should get valued at FIFO BASIS
		Note: Physical Stock Verification will be done every month, and Closing Stock gets entered every month manually, so no the Closing stock should get calculated on fifo basis
5​	consumption should be on total
		opening
		+
		purchase
		+
		reprocess
		-
		sales	Rates will be calculated on purchase(FIFO) Basis
		-
		closing stock	Manual stock will be entered after ward it will be calculated on FIFO BASIS
		=
		consumption

 

[sreepathi]

Kindly help me with this, any doubt kindly post,

Thanks

 

[pecoflyer]

Patience, this is a free forum where volunteers help for free on their spare time.
You cannot expect our members to be sitting behind their screens waiting for your questions...
If urgent, pay sites are more than willing to help
On XLforum you were also reminded of this behaviour

 

[tboulden]

Kindly help me with this, any doubt kindly post,

Thanks

Haven't looked at your specific sheet, but there was a recent FIFO formula challenge on the Microsoft Excel discussion page, see if this helps:

FIFO Inventory Formula Challenge

To revel my second anniversary as a member of this EXCELlent Community, I hereby proffer this challenge to season your array manipulation skills...

techcommunity.microsoft.com

 

[sreepathi]

Patience, this is a free forum where volunteers help for free on their spare time.
You cannot expect our members to be sitting behind their screens waiting for your questions...
If urgent, pay sites are more than willing to help
On XLforum you were also reminded of this behaviour

For your kind information i have not mentioned anywhere i needed it urgently, no where i have used harsh words

 

[sreepathi]

Haven't looked at your specific sheet, but there was a recent FIFO formula challenge on the Microsoft Excel discussion page, see if this helps:

FIFO Inventory Formula Challenge

To revel my second anniversary as a member of this EXCELlent Community, I hereby proffer this challenge to season your array manipulation skills...

techcommunity.microsoft.com

Thanks

 

[pecoflyer]

For your kind information i have not mentioned anywhere i needed it urgently, no where i have used harsh words

You did not say it was urgent, but you bumped your thread the same day as the original post ...