The Production Schedule is an integral part of the Service Manager System. It is a Microsoft Works spreadsheet used to schedule mechanics and jobs. It works with any number of mechanics up to eleven, and has the capacity for up to 48 jobs per mechanic per day. Used in conjuction with the Productivity Log, the Production Schedule calculates production capacity for each mechanic, and the staff as a whole, based on the hours you enter for each mechanic. As individual repairs and assemblies are added into the Production Schedule, it automatically updates each mechanic’s remaining (available) capacity, and even calculates the time of day each job should be completed by!
* The example below shows the portion of the Production Schedule where you enter mechanics’ hours, and capacities are calculated. You enter your mechanics’ names, productivity rate (from the Productivity Log), minimum and maximum hours hours they each can be scheduled, and the actual hours they each will work (in the blue cells). The program automatically calculates the actual hours scheduled for each mechanic, each mechanic’s individual production capacity for the week, the combined capacity of all the mechanic’s for the week, and each mechanic’s starting production capactity for each day.
* The example below shows the portion of the Production Schedule where you enter jobs (green cells). The bright green cells are used to enter the dollar value of the labor for each job, and the pale green cells are used to enter the repair ticket number or inventory number for a bike assembly. As each job is entered, two things are automatically calculated. These are Remaining Capacity (the size of the biggest job you can still give the mechanic), and Est. Comp. (estimated completion time). You can see in the below example that with the jobs scheduled so far, Bob Smith only has room for a $3 job, but Jim Barnes can still do a job with up to a $99 labor estimate.The estimated completion information is primarily used as a guideline for the mechanic, but could be used to give the customer an idea of when in the day the job will be completed.
* The Production Schedule is designed to operate as an on-screen scheduling system. It is simple enough that anyone on your staff should be able to learn how to schedule jobs in a matter of minutes. Printouts for individual mechanics for each day can easily be generated so the mechanics don’t have to access the computer each time they need to check their schedules.