Hey everyone - I’m trying to build a tool that will help me schedule manufacturing tasks. Basically it’d be a project that will repeat over and over.
Say we have serialized bikes. Each one goes through these steps:
- Add Brakes
- Add seat
Each should take 1 day to complete.
Serial number 101 starts on 6/1. Serial number 102 starts on 6/2. Serial number 103 starts on 6/3.
I want to track serial number 101 through these steps, but then also look ahead at 6/3 and see the following schedule:
Paint - 103
Brakes - 102
Seat - 101
Then also to be able to look at all of the serial numbers one stage has during a day. Say Brakes’ assignment on 6/3 - which would be SN102.
Obviously this would be way more complex but I’m trying to build up the back bone of this thing, and see if this is even possible. I’m experimenting with the Gantt block - which I THINK is the answer. But I get bogged down because each record needs a start and end date. In this example if Paint was a record, it might have a start date - day 1 of the company. But never really end.
Serial Numbers have a similar issue. SN 101 starts on 5/31, but this doesn’t give me the ability to see what a given station’s assignment is on 6/1.
Thank you for any help!