Results 1 to 5 of 5

Working out replenishing levels from customer demand using a Maximum Stock level

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    480

    Working out replenishing levels from customer demand using a Maximum Stock level

    Hello All

    C6 – G6 is Customer demand
    C7 –G6 is how man boxes are needed to cover the customer demand
    H6 – Maximum Stock holding

    Is there a formula that will look at the customer demand in blue and work out what day the maximum stock will need topping up?

    Tuesday to Friday uses the maximum stock of 600, so Monday is short of 200 hence the – 10 in G6

    Paul
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-22-2014, 08:10 AM
  2. Identify the earliest expiry date on stock based on current stock levels
    By julie86xx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2013, 01:08 AM
  3. [SOLVED] Stock Control - Alert user to low stock levels.
    By Kaies in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-29-2013, 08:56 AM
  4. Replies: 0
    Last Post: 10-25-2012, 09:52 AM
  5. Replies: 11
    Last Post: 10-25-2012, 12:26 AM
  6. Working out stock levels and circular reference issues.
    By maxcherry in forum Excel General
    Replies: 1
    Last Post: 07-01-2012, 04:26 PM
  7. Replies: 2
    Last Post: 10-28-2011, 11:58 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