View Single Post
  #2   Report Post  
Conrad Carlberg
 
Posts: n/a
Default

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?