Skip to Content
0
Former Member
Dec 02, 2008 at 03:16 AM

Inventory Turn Over Projection

17 Views

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)