General :: Optimization Of Resources Dependent On Sequence

Right now, I have an entire job with multiple piece parts. All of these different parts go through different processes (They are shown in the table "Piece Parts New"). I've created a query that the user puts in the EC (estimated completion) days per process of a given piece part, it automatically outputs a ESD (Estimated Start Date) and ECD (Estimated Completion Date) on all processes based on date the part was started.

So, now I want it to output a report that each piece part will:

1. Follow Sequence by Step #
2. Do longest part first (make number one priority at a given machine).
3. Only 1 part per machine at a time (The part that takes the longest to do will always be first, followed by the next longest, etc.)

Right now, the report labeled "Step Groupings" somewhat does this, however another part will have ESD a day later even though the part before still hasn't finished according to ECD.