Dear Guys,
Can You help me to make this report with some queries...So i can predict day to day inventory turn over?
5 days in below.. according date that i execute the report. Thanks
Thanks
Month to Date Inventory Turn Over (Days)
05-Nov-08
Inventory
Beverage Grocery Fresh Product
130010 13011 130012
Cogs GL Account
Beverage 510010 25
Grocery 510011 21
Fresh Product 510012 _15 _
Inventory Turn Over = ( Inventory Avrg / COGS (Project to Month ) x 30 Days
with :
COGS (Project to Month) = (Total Accumulate COGS (510010) month to date till 5 Nov 2008 / 5 Day) * 30 Days
Inventory Avrg = Average Inventory Value per days 130010 ( Average untul 5 Nov 2008)