Your 'Go To' for Custom Excel Solutions

Case Study – Job Scheduling

Job scheduling is a complex yet  important part of any manufacturing company.  A custom time and resource schedule can help you adapt with the ever changing conditions of your specific business environment. This case study is an example of a job scheduling resource we developed for a Kitchen Design business. 

Problem

The Problem

The main problem for this business was the standard job timeline was split between the back office, workshop and installation activities. This meant having to manually look for a suitable time slot for new jobs, and it was difficult to edit a job once it had been manually scheduled. This was time consuming and inefficient. There was also an issue with communication between the three departments, regarding resourcing and time allocations.

Solution

The Solution

The solution was to create an easy to read calendar that showed all activities across the three departments for staff to work from.

We developed an automated calculation of job activities based on existing jobs, upcoming holidays, and a set of specific rules for some activities that could only be scheduled for particular days of the week. If the date for an activity was changed the job was automatically rescheduled taking into account jobs already scheduled.

A series of reports were created to track jobs for completion, and the activities were transferred into the calendar, colour coded to show which activities were allocated to each department.

Benefit

The Benefit

  • Considerable time saved with the automation to calculate the next available time slot for a new job, and to quickly re calculate when time changes to activities take place.
  • The team worked better together as a whole with the ability for everyone to quickly and easily see what has to be done, when, and by who.
  • More efficient job tracking of jobs from start to completion dates.
  • Reduction of double booking slots for activities, leading to a higher rate of deadlines achieved for clients.

Customer Feedback

"The team at XLAutomation understood my very vague description and transferred it into the perfect result with ease and attention to detail. A great result, well done..!!"

Adam - T & T Kitchen Designs