| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Urgent! Somebody Pleez help!! Inventory Valuation
I need to prepare a report on a periodical basis of inventory on hand Qty, value & age ( 0-30,31-60, 61-90 days etc.) In the database I will have few cost components of each purchase ( FOB, Duty, Freight etc.) by style #. Second table will be Sales(Date, Inv #, Cust, Style, Qty, Selling Px). I need to run the report usually on a month end but sometimes on any given date. Which functions/formulas I should use? I am bit confused. Some one please help with some sample codes/Functions/formulas. Thanks a bunch in advance!!  -- aromaveda ------------------------------------------------------------------------ aromaveda's Profile: http://www.excelforum.com/member.php...o&userid=29449 View this thread: http://www.excelforum.com/showthread...hreadid=494868 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Associating data across worksheets from an inventory that's sorted | Excel Discussion (Misc queries) | |||
| Inventory List Question | Excel Discussion (Misc queries) | |||
| Inventory sheet to track, order & reduce quantity from master. | New Users to Excel | |||
| Make inventory sheet to track, order & reduce quantity from master | Excel Worksheet Functions | |||
| Urgent Urgent Urgent!!! | Excel Discussion (Misc queries) | |||
Threaded Mode
