I've got a fairly easy question for Excel experts that im having some trouble wrapping my head around..
I have a 6 month production schedule (month by month) optimized to minimize total costs,
The current constraints include,
On_hand_after_production>= Demand
Ending_Inventory<=Storage_Capacity
Units_Produced<=Production_Capacity
I need to alter or add (im not sure what) a constraint so that except for month 6, demand does not need to be met on time. Meaning all demand must be eventually met by month 6...
Wut do ?
I have screenshots that can be posted in order to make it more visual if necessary
Thanks !
Bookmarks