+ Reply to Thread
Results 1 to 6 of 6

trying to do a running inventory sheet

  1. #1
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    trying to do a running inventory sheet

    i am trying to get an inventory sheet done. i have a generic workbook that i can let you see. i need it to be able to give me the results for the leftover inventory that is in stock as well as any new inventory coming in. i need it for "First-in First-out", "Last-in First-out", "Weighted Average", and "Specific Identification". this is for an accounting class. i am doing this on my own.

    Inventory worksheet form.xls this is with formulas shown

    Inventory worksheet.xls this is the regular one.
    Last edited by eaglewolf573; 10-12-2013 at 07:17 PM.

  2. #2
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: trying to do a running inventory sheet

    hello anybody out there that can help.

  3. #3
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: trying to do a running inventory sheet

    wiL25583_0604.pngwiL25583_0605.pngwiL25583_0606.pngwiL25583_0607.png

    the above pictures is what i am trying to be able to do in a spreadsheet.

  4. #4
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: trying to do a running inventory sheet

    can anybody help me here. i have looked at the other threads about this and none look like they would work.

  5. #5
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: trying to do a running inventory sheet

    am i able to get any help here.

  6. #6
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: trying to do a running inventory sheet

    hello. any help is appreciated, getting frustrated with lack of reply. thank you.

+ 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. Barcode Inventory System - Running Inventory
    By b.dennis.79 in forum Excel General
    Replies: 2
    Last Post: 01-10-2013, 03:16 PM
  2. [SOLVED] creating a running inventory
    By Robert C. in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2012, 07:16 AM
  3. inventory running count
    By joesport5 in forum Excel General
    Replies: 6
    Last Post: 02-21-2011, 11:08 AM
  4. Inventory Running Balance
    By walkinfaith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-14-2008, 10:13 AM
  5. Creating A Running Inventory
    By Caspers in forum Excel General
    Replies: 3
    Last Post: 05-08-2007, 02:15 AM

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