|
|
Schedlyzer
Lite
There is a good demand for spreadsheet-based tools for job shop scheduling mainly due to the perceptions:
- They are simple, flexible, user friendly and transparent
- They are easily affordable to small job shops
- They exploit the power and elegance of MS Excel
- Input data can be easily updated and managed
- They can be easily configured
- They do not need much training.
Scheduling a variety of jobs with different due
dates, priorities and process requirements is known to be tough in
many job shops with high-mix, low-volume (HMLV) production
or project-based production. It requires rigorous, scientific
logic which is not available in many scheduling software. It is theoretically possible to develop an application in Excel for HMLV scheduling using sound
scheduling knowledge and strong skills in VBA language (Visual Basic for Applications). However, no
Excel application can provide powerful graphic user interface and strong drag-and-drop functionality. No
commercial Excel application is known to be versatile enough to schedule a variety of job shops without
laborious manual effort.
Finding a proven, commercial, user friendly scheduling tool fully in Excel is a real challenge for many HMLV job shops.
Since it is easy to export data to an Excel file and create and edit data in Excel, we developed an
executable software tool, Schedlyzer Lite that can take input data from Excel files, schedules production
satisfying all relevant constraints and presents schedule output in the most elegant form.
Schedlyzer Lite enables the users to take full advantage of Excel
power (for data preparation), rigorous scheduling logic and powerful and elegant graphic features. The main benefit is that while exploiting the full scheduling power of Schedlyzer Lite, the user has a lot of freedom to structure the Excel file that serves as an input file to the software.
Schedlyzer Lite is a simple, powerful and
low-cost tool for scheduling both HMLV production and project-based
production subject to resource capacities. Based on finite capacity scheduling logic, it automatically prevents resource overloading in the production schedule. See our approach to scheduling.
The advantages of Schedlyzer Lite include improvements in on-time delivery, throughput, effective resource
utilization, WIP and job lead times. Its functionality includes Its functionality includes:
- Finding a right start time for each new job based on the existing workload, resource capacities and the due date, priority and process requirements of the job
- Generation of an explicit, feasible schedule for each resource as part of the overall schedule
- Graphical display of job/project schedules and the daily utilization levels for each resource with desired resolution
- Realistic prediction of workflow, bottleneck formations and job/project completion times
- Quick resource-leveled rescheduling and support for fast and extensive what-if analysis of schedules and capacity planning
- Powerful drag-and-drop functionality on Gantt chart for manual improvements in schedule.
Schedlyzer Lite with Excel interface is affordable to almost all job shops.
A Free
30-day Trial Copy:
Contact us for a free, fully functional, 30-day trial copy of the software. Before giving the free trial copy, we would first present a live web demo of Schedlyzer Lite and
configure the trial copy as required for your system. We would also offer you free help during trial runs.
|
|