Workshop Production Planning

I run an engineering factory with approx 15 machines in it. We are always late on delivery and I need to do something to properly plan jobs into the workshop so we tighten up on our delivery dates.

Initially I want to start off with something very simple and ideally graphically represented for ease of use. Later on I will want to integrate the times for each job that come from my current works order system (Microsoft Access based), but that is not part of this project for now.

As an explanation.......... We have orders come in to us that will have from 1 task to no more than 10 tasks to complete the job. A Job sheet is generated that travels around the factory showing the process type and the time allowed (e.g Milling = 10hours / Turning = 6.5 hours etc). The process itself can be made on more than one machine in most cases. For example a milling process can be completed on most of the milling machines in the workshop as can turning processes be completed on most of the lathes in the workshop. Most of the time repeatable jobs will go on the same machine each time, but not always!!! We also may have some sub contract work on jobs as part of the route through the work shop which can take from days to weeks to complete!

Each machine has "x" amount of hours a week it is able to run jobs on it. Some machines CAN run lights out and unmanned and some cannot. The ones that do, obviously run 24 hours a day.

I need to load each machines with jobs so I can accurately quote delivery dates to customers and stick to them!. Be aware that some jobs will need work doing on them on multiple machines and possibly outside sub contract processes too before they are complete.

Ideally I would like this system to be web based, as then I can allow the workshop staff to access it from there laptops so they can see what jobs are coming up next. It may require the machine operator to key on or click a button to advise the scheduler of the start and stop time of the jobs, then the schedule can alert any backlogs or spare capacity. The scheduler would also need to be able to "reshedule" if required. For example if a machine were to breakdown for a week everything in that week needs to either be moved to other machines or rescheduled on the current machine when it is fixed. We would in that case need to see what effect this has had on other jobs so we can tell customers in plenty of time that there work could be late due to a machine breakdown. Alternatively if the scheduler tells us how many hours we are out, we could possibly put on overtime to make up the time lost in the breakdown.

Id also like to add a "what if" function, so that when a customer phones and asks what date we can do a job for, we enter the times in and the scheduler advises me a delivery date. Also if we push jobs in (which sadly often happens in our game), we need to show what effect this has on other work already planned in......(what overtime do we need to add to bring the schedfule back into line, or which jobs will be late because of it etc)

Once we have some sort of scheduling system working, I will eventually want to integrate our log on/log off of jobs we use (by way of barcodes for each task on our job travellers) with our current MS access driven order system.

Hope I have explained this in enough detail. Any questions, please do not hesitate to contact me.

Many thanks

Neil Fearnley

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, MySQL, tietojärjestelmäarkkitehtuuri

Näytä lisää: planning production access, production workshop planning, schedule alert message calendar plugin wordpress, php, mysql, website design, software architecture, excel, javascript, d3.js, planning production vba, planning production excel vba, vba planning production, excel planning production, planning production, excel planning production bakery, planning production workshop, ema stop loss alert, stop mt4 alert window, stop metatrader alert

Tietoa työnantajasta:
( 0 arvostelua ) Spain

Projektin tunnus: #13075572

23 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello There, This is Hiren Bhuva from Sky Technovation (IT development & Cyber Security Company). From last 5 years we are working on Software & Website development. We had developed too many Software & websites in Lisää

£526 GBP 10 päivässä
(50 arvostelua)

I can do exactly what you need using Excel dashboards and a (possibly) a webpage integrated with Excel. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, Lisää

£1000 GBP 20 päivässä
(201 arvostelua)

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and Lisää

£1947 GBP 35 päivässä
(28 arvostelua)

Greetings! I am an Engineer with 17+ years of experience having direct exposure to Electronic Manufacturing processes. As part of my professional career, I have been part of a Six Sigma Black Belt Project and lead a Lisää

£600 GBP 25 päivässä
(112 arvostelua)

Hi Neil, My name is Jin. I have over 20 years of experience working in IT. Over 10 years in Australia as a contract programmer for companies like NAB, Bosch, etc. I am now based in Malaysia. 1. You run an eng Lisää

£833 GBP 12 päivässä
(17 arvostelua)

Dear Project Owner, Greetings for the day! Thank you for reviewing my bid. I have gone through the details and will get it done quite comfortably. We have huge experience of developing Softwares. We Lisää

£833 GBP 25 päivässä
(12 arvostelua)

Hello Hiring Manager, well you have explained your requirements very clearly, and i undertand what you are looking for , i can deliver this project. plz send me message and lets discuss it in more details. I have don Lisää

£555 GBP 15 päivässä
(28 arvostelua)

Hello Neil. Checked your requirement and as per your need will make a web based application where you can manage the order intake to product out ... the application you are needed is to manage all of your factory st Lisää

£1500 GBP 50 päivässä
(4 arvostelua)

You can release the payment in the end or as per your milestones. In the bid amount , I can provide the website version , android application , ios application . I am available on all days and can start at the earliest Lisää

£555 GBP 22 päivässä
(3 arvostelua)
£250 GBP 10 päivässä
(26 arvostelua)

Hi Neil, I am a native English speaking Finance professional with over 15 years experience using Excel to build models and complete reporting. I can help with your project. I would propose to complete your project b Lisää

£550 GBP 14 päivässä
(11 arvostelua)
£500 GBP 10 päivässä
(9 arvostelua)

I am a civil engineer with advanced knowledge of microsoft excel. I have experience with data entry and statistical calculations.I work fast and deliver my projects on time. Looking forward to working with you. Thank Lisää

£250 GBP 2 päivässä
(6 arvostelua)

Greetings of the day! I would love to assist you on the project.I have been working as a forecasting analyst for last 3 years now. Forecast of an incoming work and schedule people according to the forecast is my everyd Lisää

£250 GBP 2 päivässä
(13 arvostelua)

Please take a look at our portfolio on our website We have a team of professionals who are the best in the business. We have many years experience in corporate America. We understand deadlines an Lisää

£555 GBP 10 päivässä
(1 arvostelu)

I have wide experience working on manufacturing environment CNC Machining, Molding, Die Casting, Stamping. In addition to that, I have experience working on multiple areas of the manufacturing. In other words how a Dat Lisää

£555 GBP 10 päivässä
(0 arvostelua)

hi sir I do planning for some factories here in Libya so I can help you well in this task so let's start now best regards

£250 GBP 6 päivässä
(0 arvostelua)
£555 GBP 10 päivässä
(0 arvostelua)

I am a mechanical engineer working for a workshop. Although our process mostly involves welding we were having a similar scheduling problems. We have mainly solved the issue by a software that runs on our intranet and Lisää

£777 GBP 30 päivässä
(0 arvostelua)
£511 GBP 20 päivässä
(0 arvostelua)