Distribute jobs evenly within constraints

Robn

New member
Joined
Dec 13, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2019
Best explained with the attached spreadsheet.
The task is to distribute jobs as evenly as possible between 6 machines within the following guidelines:
1. minimize machine cleaning by assigning same product to an applicable machine. Machine does not require cleaning as long as the same product is assigned to it.
2. some products can only be done by selected machines as per table
3. The first run starts at 4am, and each machine start time is staggered 30 minutes

Appreciate any help.
Thanks
Rob.
 

Attachments

  • Balanced Job Distribution.xlsm
    18.8 KB · Views: 16
Back
Top