Fermé

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

Compétences : Saisie de Données, Traitement de Données, Excel, MySQL, Architecture Logicielle

Voir plus : planning production access, production workshop planning, schedule alert message calendar plugin wordpress, 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, email rails schedule alert reminder notification, planning production excel

Concernant l'employeur :
( 0 commentaires ) Spain

N° du projet : #13075572

24 freelance ont fait une offre moyenne de 640 £ pour ce travail

esalem

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 Plus

1947 £ GBP en 35 jours
(25 Commentaires)
6.9
cugamelover

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, Plus

1000 £ GBP en 20 jours
(168 Commentaires)
6.9
SkyTechnovation

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 Plus

526 £ GBP en 10 jours
(20 Commentaires)
6.7
JinNg

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 Plus

833 £ GBP en 12 jours
(10 Commentaires)
5.8
ksriniravi

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 Plus

600 £ GBP en 25 jours
(44 Commentaires)
5.2
atulawasthi2

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 Plus

1500 £ GBP en 50 jours
(4 Commentaires)
4.4
250 £ GBP en 10 jours
(15 Commentaires)
3.6
Ashishpaliwall

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 Plus

250 £ GBP en 2 jours
(13 Commentaires)
3.7
telfordm

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 Plus

550 £ GBP en 14 jours
(6 Commentaires)
3.3
shukaibzafar

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 Plus

555 £ GBP en 15 jours
(11 Commentaires)
3.0
priyas171

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 Plus

833 £ GBP en 25 jours
(1 Commentaire)
3.0
Ayo25

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 Plus

250 £ GBP en 2 jours
(3 Commentaires)
3.3
500 £ GBP en 10 jours
(6 Commentaires)
2.3
hestarinter

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 en 6 jours
(0 Commentaires)
0.0
estevesdeveloper

Call me a Hacker, a Coding Guru whatever! The point is YOU'RE GOING TO GET A GREAT JOB DONE AND HAVE IT DELIVERED QUICKER THAN AS QUICK AS POSSIBLE! I have a long road behind me paved by code written in Swift, Objecti Plus

655 £ GBP en 10 jours
(0 Commentaires)
0.0
ReneMB

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 Plus

555 £ GBP en 10 jours
(0 Commentaires)
0.0
555 £ GBP en 10 jours
(0 Commentaires)
0.0
king18yat

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 Plus

555 £ GBP en 22 jours
(0 Commentaires)
0.0
support999

Hi , I am a fulltime freelancer with small team, able to work 40hr/week . I am having some queries for project . I like to chat on it , so that I can do work on same side . I am ready to work with you on least am Plus

250 £ GBP en 10 jours
(0 Commentaires)
0.0
adamcurrier

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 Plus

777 £ GBP en 30 jours
(0 Commentaires)
0.0