# how to work out a garage

harps1h 18:51 13 Mar 2008
Locked

queuing system? if i were aetting up a table to look at queuing systems, how would I manage to work out waiting times per customer.

for example if customer 1 comes in minute 1 and takes 5 mins for service and customer 2 comes in minute 3 would it be correct to say his waiting time would be 3 mins

VoG II 19:17 13 Mar 2008

I think you are going to have to explain a bit more.

Are you doing this in Excel?

harps1h 19:27 13 Mar 2008

no I am doing this in a manual sheet and i really cant figure the best way to calculate wait times for cars arriving say 5 mins later

for example, min 1: 2 cars each takes 3 mins
min 2: 1 car 5 mins
min 3: 4 cars 2 take 2 mins 2 take 5mins
what i would like to know how to calculate each cars waiting time

thanks

harpur

Graham. 19:56 13 Mar 2008

You will need to draw a line graph with zero minutes on the left, and vertical lines at one minute intervals. Then you can draw in each car as it arrives and extend its line for the time taken.

But I suspect there is only one mechanic, so regardless of its arrival time, he can only start on a car when he's finished the one before. So a car can only be given a position in the queue. Instead of its actual arrival time, put the next car after the one before is finished.

harps1h 20:01 13 Mar 2008

but would you minus time elapsed from the wait time?
as above min 1 first car takes 3 mins therfore second car waits 3 mins
minute 2 car 1 then waits 2mins (3 less time lapsed for the first minute car 2 has waited already)

If the time taken to do the work is exactly the same then you might be able to work this out but when different faults take vastly different amounts of time I do not see how you can effectively do this. Unless I'm misreading what you want to do.

My friends have a garage and the repairs in some cases can take a day and in others maybe 10 minutes as it depends whats wrong. The best they can do is look at the car, see whats wrong and estimate how long it will take (based on experience) and then fit the repair in as best they can bearing in mind the number of mechanics available. And of course assuming no one is off in which case all timetables are out the window as they are short handed.

harps1h 20:08 13 Mar 2008

this is for a petrol pump and we need to work out the wiat times on a single pump

2bathred 20:14 13 Mar 2008

You are going to be hardpressed to come up with anything definitive as the number of variables are so great. Time taken by user to operate the pump, how much fuel is pumped, how long they take to pay etc. I wish you luck.

GANDALF <|:-)> 20:16 13 Mar 2008

'But I suspect there is only one mechanic'...I have had the misfortune to use garages where it would appear that the mechanics took that amount of time to do their lousy service.

G

harps1h 20:17 13 Mar 2008

we are using random number to generate a model that is how we are getting service times as this is a model only

2bathred 20:33 13 Mar 2008

Draw a Horizontal line and divide into 60 units.
i.e 1 min intervals. Draw vertical line and divide into any number to represent cars arriving.Put mark next to minute 1st car arrives and again when first car leaves join the marks. This will be his service time. Mark minute when 2nd car arrives and again when he leaves. This will be his service time. Where the two lines overlap will be the waiting time. e.g car 1 arrives at minute 1 and leaves at minute 4. Car 2 arrives at minute 3 and leaves at minute 6 overlap is from minute 3 till minute 4 therefor waiting time is 1 minute.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Is this the future of VR and AR?