Advanced Manufacturing Scheduler tracker in Excel -- 2
€1500-3000 EUR
In Progress
Posted 34 minutes ago
€1500-3000 EUR
Paid on delivery
EXCEL
Manufacturing Product scheduler/run time tracker
We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document.
The idea is to have a laptop at each station (listed above)
1a,1st step: Manual enter/copy paste-from engineering
Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER.
When running the selected items (check box) we track time to produce on laser (start / stop check box) capture the run time. once completed, Laser operator checks off the next function (based off part)
example: Bend function- once checked off from laser function(complete) it populates in the queue in another tab called Bending - it takes all the same data over to the new tab for BEND operation - and repeat through all functions above.
Aside from assisting with the schedule aspect this collects the data of how long it took to fabricate each piece by tracking the time to produce - back end data base/archive which we can sort part #'s to determine total time to run components.