+ Reply to Thread
Results 1 to 3 of 3

Excel spreadsheet to track a product and its parts, and reorder the parts when needed

  1. #1
    Registered User
    Join Date
    06-03-2015
    Location
    Victoria, BC, Canada
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    2

    Excel spreadsheet to track a product and its parts, and reorder the parts when needed

    Hello,
    I work for a manufacturing company who make rowing and sail boats.

    I need to create an excel spreadsheet that allows us to enter all the inventory parts for a product, keep a count of those inventory parts, alert us when the inventory parts need to be reordered (we need to have enough in stock to fulfill orders) - also taking into account the time it takes for different inventory parts to arrive, and finally when a product is shipped we need to update the inventory count so that it's up to date.

    So for example, when one product is bought the excel sheet subtracts all the parts from the inventory that were used to make the product, and when the number of parts reaches a certain level it alerts you to order more, so that there are always parts in stock to make up a product.

    If anyone knows of a template or spreadsheet I can download which would do this for us I'd be very grateful. Thank you.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Excel spreadsheet to track a product and its parts, and reorder the parts when needed

    Have you done a Google search? You can find a lot of them there...
    http://www.bing.com/search?q=invento...IE10TR&pc=DCJB
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    06-03-2015
    Location
    Victoria, BC, Canada
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    2

    Red face Re: Excel spreadsheet to track product & its parts, reorder parts & update inventory

    Thank you Tom, I've trawled through a lot of internet sites and found some v useful inventory templates, but none that will update the entire inventory of parts (subtract all the parts used) each time one of the products is sold.

    So if you or anyone else knows of a template for a spreadsheet that will update the entire inventory of parts (subtract all the parts used) each time one of the products is sold, I'd be very pleased to know about it!
    Thanks
    Last edited by Nancy01; 06-04-2015 at 01:59 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need Excel to email parts of Spreadsheet
    By texag01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2013, 09:45 AM
  2. Replies: 5
    Last Post: 01-18-2013, 11:21 AM
  3. Scan parts OUT to Sheet1, parts IN to Sheet2 and list in Sheet3
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 11:40 AM
  4. Replies: 7
    Last Post: 07-01-2012, 05:43 PM
  5. Replies: 0
    Last Post: 02-09-2011, 07:13 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1