+ Reply to Thread
Results 1 to 8 of 8

Solver? to determine sequencing in inventory management problem

Hybrid View

  1. #1
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Solver? to determine sequencing in inventory management problem

    Batch 1 quantity to 4000 or change 10000 to 9000 I was wondering why solver says "could not find a feasible solution".
    You've changed the production from 5000 to 4000 but I assume the customer demand stays the same i.e. 32962.

    So with only 4000 in production the only orders that can be filled is A, D, F, G and H this adds up to 2949

    As you've now used batch1 completely as you can't use balance 4000-2949 to partly fill another order you only have batch2, batch3 and batch4 left i.e. 30000 units and your customer demand is B, C, E, I and J and the total of these orders are 30013 units so as you can see solver can't fulfill a demand like this.

    But only changing one of the 10000 batches to 9000 and keeping 5000 batch unchanged will let solver find a solution.

    Alf

    Ps Thanks for feedback and rep
    Last edited by Alf; 11-19-2016 at 04:57 AM.

+ 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. Inventory management problem, capping values
    By Rusty315 in forum Excel General
    Replies: 8
    Last Post: 03-23-2014, 09:42 PM
  2. SUMPRODUCT or complex VLOOKUP? Inventory management problem
    By Rusty315 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-13-2014, 01:14 AM
  3. help with excel solver operations management problem
    By cduval04 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2013, 04:58 PM
  4. [SOLVED] Inventory Management
    By espavan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-30-2013, 02:58 AM
  5. Replies: 0
    Last Post: 08-16-2012, 10:54 PM
  6. Inventory management
    By eshell189 in forum Excel General
    Replies: 8
    Last Post: 04-20-2012, 06:24 PM
  7. Inventory management
    By shanky365 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2011, 02:24 AM

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