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?
|