Looking for a Production Schedule Template

Six Sigma – iSixSigma Forums General Forums Tools & Templates Looking for a Production Schedule Template

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #55844


    Hello everyone,

    I was wondering if anybody can recommend me a good production scheduling excel template. I have downloaded a few, but they don’t seem to include much information (I am aware that they each vary on the type of business).

    Any suggestions are gladly appreciated.

    Thank you


    Mike Chambers

    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,


Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.