Product vs. Parts used for product tally shet

Microsoft Excel 010 - complete package
May 20, 2011 at 14:40:07
Specs: Windows 7
I am working an inventory sheet for work. I have a product that uses multiple parts. I want to keep track of all the orders for my products. So lets say I have 5 thingamagig orders placed for varies customers. I need my database to subtract from my stock list so I know how many parts I have left and in turn letter me know how many thingamagis I can currently send out and how many of what parts I need to order to get my stock level up so I can ship.
For example
1 Thingamagig uses (1 part A, 4 Part B, 3 Part C, 1 Part D, 1 Part E, 1 Part D)

I have different products that use the same inventory.

Any help would be great.

See More: Product vs. Parts used for product tally shet

May 23, 2011 at 02:27:41
You are looking for a Bill of Materials (BOM) or Material Requirements program. It gets very complicated if a part can be used in different assemblies with differing lead times.

Report •

May 23, 2011 at 11:05:25
Is there no way to enter that into an excel formula. Ideally I would like to have an excel book that lists all the parts I use and a book that as I enter how many of what product we have on order it will suptract from my parts list page.

Report •

May 23, 2011 at 12:03:00
Most of the programs are complicated and based on databases. Variations are assembly time, value of product, which product has priority, lead time for a part in a product that is out of stock.

Report •
Related Solutions

Ask Question