It will likely be a challenge finding a template that meets your needs. True scheduling tends to be specific, especially if you try to implement some form of load leveling. Most agree the money is in true scheduling (versus a to-do list of jobs that is often sequenced by just ship date) with firm expectations on changeover times, run speeds, quality, and uptime.
We use an internally developed Excel worksheet that sequences the jobs to minimize changeover downtime while still meeting ship dates. The programming is fairly straightforward with stacked If/Then statements. VBA macros are used to automate the process and sort optimally or by ship date, etc. Once the jobs are sequenced, expected performance (changeover, speed, uptime, and quality) are inserted. That will then give expected start and end-of-job times. Ultimately, the schedule is linked to current performance in the plant with monitors on the plant floor, conference rooms, smartphones, etc. If a production area is down, behind schedule, or over-producing there are color-coded visuals to drive corrective action. Depending on the complexity of the system and number of production areas, the programming and linking with real-time performance can be done in as little as 3 to 6 weeks.
Hope that helps …
Best regards,
Mike
Mike Chambers 1 year, 11 months ago.
