Hi,
I'm trying to come up with a formula that will help me determine the End times (Column Z) and Start times (Column Y) for Activities/Jobs (Column K).
The column Z should be populated such that
My attempt is formulated in Columns Z and Y. I am stumped and would appreciate any help.
Thanks
Zee
I'm trying to come up with a formula that will help me determine the End times (Column Z) and Start times (Column Y) for Activities/Jobs (Column K).
 Each activity is done in a certain section (Column I).
 Each section has a maximum No. of Operators/ Headcount (Column S). This determines the section's capacity.
 I have worked out the Headcount required to carry out each activity (Column T)
 The Activities are sorted in descending order of the Activity Order (Column L). I wanted to plan the last activity first as I want to make sure we will meet the delivery deadline) and work my way backward.
 The Products are listed in Column J
The column Z should be populated such that
 Each preceding activity (based on the Activity Order) should be completed before the next one would start. For example. Activity 24 needs to end before Activity 25 can start.
 The aim is to assign multiple Jobs to a section during the same timeslot (while respecting the Activity Order) as long as the section capacity is fully utilized (in terms of headcount or manhours remaining in that timeslot). If this is not possible assign it to the next available EARLIER timeslot.
My attempt is formulated in Columns Z and Y. I am stumped and would appreciate any help.
Thanks
Zee
Attachments

381.7 KB Views: 9
Last edited: