+ Reply to Thread
Results 1 to 2 of 2

Stock Control Formula

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry Stock Control Formula

    Hi all,

    Looking for a Formula to help with stock control.

    5 Small Parts are required to make 1 Unit.

    Looking for a formula to keep track of the small part quantities


    So if 3Units go out, it will take 3 off the smaller parts or 5 units then 5 parts etc......

    Think that makes sense lol

    Thanks,

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Stock Control Formula

    5 Small Parts are required to make 1 Unit.
    So if 3Units go out, it will take 3 off the smaller parts or 5 units then 5 parts etc......
    These two statements seem contradictory. Isnt' the small parts to Unit ratio 5:1?
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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