Looking for a Production Schedule Template
Six Sigma – iSixSigma › Forums › General Forums › Tools & Templates › Looking for a Production Schedule Template
- This topic has 1 reply, 2 voices, and was last updated 4 years, 8 months ago by
Mike Chambers.
-
AuthorPosts
-
October 13, 2017 at 2:19 am #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
0October 16, 2017 at 2:34 am #201894
Mike ChambersParticipant@MikeCInclude @MikeC in your post and this person will
be notified via email.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
0 -
AuthorPosts
You must be logged in to reply to this topic.