WEDNESDAY, OCTOBER 18, 2017
Font Size
Topic Looking for a Production Schedule Template

Looking for a Production Schedule Template

Home Forums General Forums Tools & Templates Looking for a Production Schedule Template

This topic contains 1 reply, has 2 voices, and was last updated by  Mike Chambers 2 days, 5 hours ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #699195 Reply

    CG
    Participant
    Reputation - 39
    Rank - Aluminum

    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

    #699266 Reply

    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

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

Register Now

  • Stop this in-your-face notice
  • Reserve your username
  • Follow people you like, learn from
  • Extend your profile
  • Gain reputation for your contributions
  • No annoying captchas across site
And much more! C'mon, register now.

Reply To: Looking for a Production Schedule Template
Your information:






5S and Lean eBooks
GAGEpack for Quality Assurance
Six Sigma Statistical and Graphical Analysis with SigmaXL
Six Sigma Online Certification: White, Yellow, Green and Black Belt
Lean and Six Sigma Project Examples
Six Sigma Online Certification: White, Yellow, Green and Black Belt

Find the Perfect Six Sigma Job

Login Form