I have an assembly line that currently pulls (moves) every 30 minutes, which enables me to build 11 units in a shift. I need a report for the purpose of displaying the precise time of each line pull.
What I want to be able to do is this: input my goal of how many units I want to build, taking into account a 15 minute break and the start and end times of the shift… that it would return to me the time of each specific pull, automatically.
If the shift starts at 7:00am and ends at 12:45pm, minus a 15 minute break, I have 5 hours and 30 minutes of time available for work. That's a total of 330 mins. So, if I have a goal to build 11 units, I have 30 minutes to build each one.
Now, I want to hire more people so I can speed the line up and build more units in the same 330 minutes. The tables in the attachment display the differences.
Also, in the attachment, I am taking into account the "last pull", to allow time to do the work.
The current goal of 11 units, takes up 13 rows in the excel spreadsheet to display the time of each pull. If I change my goal from 11 to 22 units, more rows would be needed to display the times of each pull. Because of this, I don't think Excel is the right tool for this (but I'm not an Excel expert). Maybe Access? I'm thinking Access because of the way it queries data, generates reports and contains data.
I've thought about this and looked at it off and on for months. I've had no success with Excel. However, I'm not sure where to start to do something like this in Access.
Any feedback would be appreciated.