Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel for inventory aging?
I am looking for an EXCEL template or formulas to calculate inventory shelf
life by days. Something like an accounts receivable aging report. Is this possible? If so, how? |
#2
|
|||
|
|||
Entirely possible, depending on what you have available to hand off to
Excel. I know of no appropriate templates, but have a look, on Amazon perhaps, at Business Analysis with Excel. It has about 30 pages on using Excel for inventory valuation. In the interest of full disclosu (1) I wrote it, and (2) using the techniques it describes, I reduced a Baby Bell's inventory from $24 million to under $10 million in two years, without writeoffs. This stuff works. C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 -- "Patrick" wrote in message ... I am looking for an EXCEL template or formulas to calculate inventory shelf life by days. Something like an accounts receivable aging report. Is this possible? If so, how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |