In a factory producing metal parts, various machining processes, such as turning and milling, lapping, grinding along with laser marking, quality check and packing takes place. Workers are assigned to corresponding machine to carry out these operations for work orders on various metal parts. The company wants to monitor the assignment of workers along with machine allocations.
Data
Production data on 10 work orders. Important columns are:
Activity: process occurred
Resource: machine used
Start timestamp: begining time of the process
Complete timestamp: end time of the process
Span: the duration of the process
Work Order: # of work order
Part Desc. : The type of the part produced
Worker ID: Identifier of the worker assigned to the machine for the process