[email protected]        +1 855-335-6442

Production Scheduling Board

Bezlio - Shop Scheduling - Screenshot of the main screen of this data visualization with write-back capabilities
Bezlio - Shop Scheduling - Screenshot of the main screen of this data visualization with write-back capabilities

Production Scheduling Board

0.00

This Bezlio application allows a production scheduler to assign and prioritize jobs across shop resources in real-time.

Add To Cart

This Bezl is included for free with your paid Bezlio subscription!

The drag and drop interface works on any device. So you can put an iPad or mobile tablet in your scheduler's hands and let them schedule directly on the shop floor!


Installation Notes

When you install this Bezl it will by default point to production.xlsx which should already be present on your BRDB server. If you wish to point to a different data source, refer to our standard steps for changing data connections. This Bezl has two data subscriptions that can be edited. First is JobSchedule and this should represent a listing of each job that is currently active on the shop floor. The required columns are:
 

  • Location - Intended to represent some physical location where this job is located for filtering purposes. This could be a physical location or any other subclassification desired for jobs.
  • JobNumber - The job number. If you build assemblies you may wish to concatenate the assembly sequence into this column.
  • JobDesc - A text description for the given job. Typically you might consider putting the finished goods part description here.
  • JobNumber - The job number. If you build assemblies you may wish to concatenate the assembly sequence into this column.
  • CustomerName - The name of the customer this job is for.
  • DueDate - The due date for the given job operation. Since a job may have multiple operations, it may also have separate due dates for each.
  • WorkCenter - Similar to Location, this column allows you to categorize your job operations according to the work centers they belong.
  • ResourceID - If the operation is already scheduled to a resource, that ID should be presented here so it shows in the correct column on the dashboard. If no resource is assigned, leave this field blank.
  • ResourceSequence - If this operation has already been scheduled to a resource, this is the numeric ordering of priority the resource should process this operation in relation to others. Typical sequencing would be 10,20,30 but any integer values will do.
  • ReqQty - The quantity originally due for this operation.
  • CompleteQty - The quantity already completed at this operation.
  • DueToday - A helper column that gives us a true / falst to know if the operation is due today. This causes the due date field to show as yellow if true.
  • PastDue - Another helper column to let us know if the given operation is past due. If this column is true, we show the due date column as red.
  • UniqueID - Some sort of unique value to identify this job and operation row. In our Excel sample we make this simply the job number concatenated with the JobSequence.

The other table this Bezl uses provides the list of available shop resources for assignment to. The required columns are:

  • Location - Intended to represent some physical location where this resource is located for filtering purposes. This could be a physical location or any other subclassification desired for resources.
  • ResourceID - The ID for a given resource. This should have no spaces.
  • ResourceName - A descriptive name for the resource where spaces are allowed.
  • WorkCenter - Similar to Location, this column allows you to categorize your resources according to the work centers they belong.


Since this Bezl also saves data you will need to edit the saveChanges function in the custom designer to match up with your data source.