| Author |
Topic |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2009-04-15 : 15:30:03
|
| Greetings,I am trying to find some good info on how to balance work orders for a certain week. This is the scenario. Within a week, that start on Saturday and ends on Friday, there could be all sorts of work orders . These could be scattered throughout the week. Sometimes the work orders could be stacked high at beginning of week or end of week. So when user selects a certain ship date from customer, I want to make sure that the work orders already in the books can be done first then if possible insert the called in work order. We have some quadratic equation that does all the possible variabilities on the shop floor that figures how long a certain order will take based on historical data.So my question is Do you know of any algorithm out there that can point me in the right direction so user can quote a best estimate ship date.Thank you!!!<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-15 : 15:40:21
|
Possible. I need to see some sample data and expected output.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-04-15 : 15:46:04
|
| how do you post images into this forum. maybe a graphical representation will help while I gather the data<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-15 : 15:54:26
|
You have to post the images on a hosting company, or publically available site.Then use the IMG icon to post the url to the image.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-04-15 : 16:55:46
|
Ok finally got picture uploaded. This is for April 2009. Notice Week 5, on the 29th. The WorkLoad is 380,000 Square Inches. Let us say a new order comes in for 85500 Square Inches. Customer requests 27th April as ship date. To do both the new order and the orders in the book for that week it takes 6.951 days with all the variables. The new order will take about 2.44 days to finish and ship. Now we cannot do it on the 27th because the huge backlog on the 29th has to be started and worked on from 25th onward. But we might be able to do it on the 30th but most definitely on the May 1st since we have already stated that this order and the new one combined can take 6.951 days, well within a week.I hope this is clear and detailed. If anythingis lacking please let me know. Right now I am doing this in the front end and let us say the only thing missing in my code is red wine and Pavarotti in the background, in other words code is getting to be spaghetti. Man I am hungry!<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-15 : 17:03:18
|
It seems you need some kind of GANTT algorithm to calculate your workload.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-04-15 : 17:13:53
|
| any idea where I might find such an algorithm ? Script Library is mute on that one :)<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-15 : 17:20:49
|
Those 6.951 days, are these based on some assumption that only 100% workforce is used?I admit I know too little about your tables to make more educated guesses.But I know this is not as hard to solve as it sounds.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-04-15 : 18:58:22
|
| Thanks sir!Well there is "workforce" which is not actual people but more capacity of the branch such as how many shift minutes , how many equipments, how many break minutes, how many planned and unplanned down times etc, what was the 3 month average throughput of the branch for a specific commodity, what was the STDEV etc, lots of variables. After collecting all this info for a few months/years you kind of get a idea of the trend as to how a branch or the shop floor performs: Factory Physics. So you get that 6.951 days after considering all these things. I am sure it involves some algorithm as follows:Read and respond to this message at:https://sourceforge.net/forum/message.php?msg_id=7184837By: dbarashev1. http://www.google.com/codesearch?hl=en&lr=&q=AlgorithmCollection+package%3A%22http%3A%2F%2Fganttproject.googlecode.com%2Fsvn%222. Do what XML loader does.http://www.google.com/codesearch?hl=en&lr=&q=ProxyDocument+package%3A%22http%3A%2F%2Fganttproject.googlecode.com%2Fsvn%22<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-16 : 00:38:35
|
So the number of total expected days, 6.951, can be distributed to any combination?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-04-17 : 11:46:44
|
| Peso sorry for the delay, got caught up in some other hairy stuff.the number of total expected days, 6.951 is not for any combination it is for the example I put up there. Here is some more data for you.6.951 is figured by the following quadratic equationT = m/Mu + [ (3.54) * sigma^2 (1 + Sqrt[4Mu*m/3.54*sigma^2 + 1]) ]m = For the week Saturday to Friday, workLoad. In our case : 380000.000 + the new order 85500.000Mu = last three month moving average = 113729sigma = last three month standard Deviation = 65516.000Here IS a simplified version OF it DECLARE @t DECIMAL(20,3), @m DECIMAL(20,3), @JITm DECIMAL(20,3), @Mu DECIMAL(20,3), @DefaultMu DECIMAL(20,3), @Sigma DECIMAL(20,3),@MaterialForm VARCHAR(MAX), @CutArea AS DECIMAL(20,3), @CutRate AS DECIMAL(20,3), @Throughput AS DECIMAL(20,3),@Date AS DATETIME, @a AS DECIMAL(20,3), @b AS DECIMAL(20,3), @c AS DECIMAL(20,3), @d AS DECIMAL(20,3),@e AS DECIMAL(20,3), @SQRT AS DECIMAL(20,3) , @Yikes AS BIGINT SELECT @a =(380000.000+ 85500.000)/113729 PRINT @a SELECT @b = 3.54* POWER(65516.000,2) PRINT @b SELECT @c = 4*113729*(380000.000+ 85500.000) PRINT @c SELECT @d = 2 * POWER(113729.000,2) PRINT @d SELECT @SQRT = SQRT( (@c/@b) + 1 ) SELECT @t = @a + ( @b * (1 + @SQRT ) / @d) PRINT @t PRINT POWER(65516,2)http://www.imagecabin.com/?view=239829140cbf4b87e8777bd76<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
Load balance Work Orders