Good Afternoon,

I have a puzzle...

I have a sheet with part numbers - inventory per part. A part number consists of 3 components - cup 1, cup 2, and cup 3. I need all 3 to make one.

I have several part numbers which use the same parts but are different assemblies.

So - I have 3 different assemblies using the same components but ship at different days.

I have a 7 day window I look at which changes daily. It starts with "current" day - and continues for 6 more days.

How can I based on inventory determine which part ships first with the idea 2 parts ship on the same day.


A B C D
Assembly Component Inventory MIN
PART A cup 1 1500 800
cup 2 1200
shaft 800
PART B cup 1 1500 800
cup 2 1200
shaft 800

F G H I J K L
8/30/2016 8/31/2016 9/1/2016 9/2/2016 9/3/2016 9/4/2016 9/5/2016
500 0 0 0 0 0 0
500 0 0 500
500 0 0 0 0 500 0


Thanks