+ Reply to Thread
Results 1 to 2 of 2

Formula to allocate stock to different stores based on the Minimums set by the business

  1. #1
    Registered User
    Join Date
    02-28-2020
    Location
    UAE
    MS-Off Ver
    2010
    Posts
    5

    Formula to allocate stock to different stores based on the Minimums set by the business

    Hi

    I am looking for a formula to do the below in Excel

    For Eg:

    I have 10 Apples in the business
    8 stores
    Each store minimum Qty is varies from 2 to 4
    so I want to allocate 10 apples to stores based on the ranking ( already arranged in such a way )
    if store A has min of 4 , B has 3 and C &D has 2 each and E , F G and H has 1 each - in total I need 15 pcs. but i have only 10.
    So of course store A will get 4 , B will get 3 and C will get 2 - I need to allocate balance 1 to D and rest all stores will be zero.

    attached the workbook.

    Column C5 - Total Available
    D5 to K 5 - Allcoation Qty needed here
    D3 to K3 - Min to allocate.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: Formula to allocate stock to different stores based on the Minimums set by the busines

    D15 =IF($C$5-SUM($C$3:D3)>=0,D$3,$C$5-SUM($C$15:C$15)) and drag to the right.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Reallocating Apparel Stock between Stores
    By DamianTaylor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-24-2016, 11:00 AM
  2. Replies: 1
    Last Post: 05-23-2016, 10:23 PM
  3. [SOLVED] What stock is not where for too many stores ?
    By makinmomb in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-10-2015, 04:37 AM
  4. [SOLVED] Stock Movement for too many stores ?
    By makinmomb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2015, 08:37 AM
  5. [SOLVED] need a value to react based on a range minimums
    By mdhancockga in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-20-2015, 01:54 PM
  6. Replies: 1
    Last Post: 02-17-2015, 12:12 AM
  7. Replies: 3
    Last Post: 02-23-2010, 03:47 PM

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