I am working on an excel file to help me schedule the people and machinery for a manufacturing facility.
Variables (all in their own separate columns) include the hours needed to produce the parts, hours available for each machine, and the times in which they available. So if a part takes 23 hours to make on a particular machine, the machine is only available for 12 hours a day, and only available between the hours of 3:00 pm and 3:00 am, the job will take almost 2 calendar days to finish and will finish at 2:00 am Make sense?
In addition, I want to take into account weekends and holidays so that nothing is scheduled on those days.
I have most of the above items working well in my spreadsheet, the problem occurs when I have multiple jobs running at the same time that need the same machine. The spreadsheet will allow double scheduling of the machine. How can I prevent this?
Thanks for your help