I changed jobs recently to a manufacturing firm. Job shop scheduling is made 100% manually and intuitively in Excel. Very time consuming and they have no idea if the schedule made is something close to best solution.
The production consists of multiple processes (in total 4). End product is made of 2 parts. Both parts are individually molded, then one of the parts are printed, part 1 and part 2 are assembled and then packed. Number of work centers available in each process is 23,15,15,5 respectively.
My question is that if I would be able to manage production scheduling in Excel solver by assigning orders to machines while maintaining a min OEE and limited tardiness and visualize it with a gantt chart. I have searched the web but did not find much so if you can point me to the right direction I would be very thankful.