Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Patrick
 
Posts: n/a
Default 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   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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 05:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"