Excel for inventory aging?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 disclosure: (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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Changing amounts from one sheet to another using specific item # 7
formula for adjusting price 1
average with 2 criteria 10
Excel Account Receivable Aging Report 1
Excel formula for inventory problem 2
Update formula automatically for inventory 1
create calculated field for age in pivot tables 4
Aging by netting negatives in other age buckets for the customer 3

Back
Top