• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Investigate whether or not my local petrol station would benefit, in the way of cutting waiting times, from having more fuel pumps open.

Extracts from this document...


Decision and Discreet Coursework Aim: To investigate whether or not my local petrol station would benefit, in the way of cutting waiting times, from having more fuel pumps open. By doing this I hope to be able to simulate opening enough pumps in order to create waiting times less than 1 minute, what I would be willing to wait at a petrol station for petrol. The way in which I will do this is by collecting sufficient data from my local garage that would enable me to simulate 20 cars using the petrol station. The data of which I will need to collect to complete a simple simulation is: Arrival Time of Each Car: This will allow me to calculate an inter arrival time of which is needed to simulate the time in between cars arriving at my garage. Arrival Time of Car n+1 - Arrival Time of Car n = Inter Arrival Time n = number of car in order of arrival This will be done for all of the cars of which I have collected data for. I will then group these figures in sensible ranges, of which I can refine later, to calculate the probability of each inter arrival event range occurring. Length of Service of Each Car: I have decided that the most accurate way of calculating length of service will be to record the time in between the customer exiting his/her vehicle and re-entering it. Time Customer Re-enters Car - Time Customer Exits Car = Length of Service This length of time will be the length of service. ...read more.


(N.B If the car has a petrol cap on the left side, it would go to the right side of the fuel station to fill, for convenience). I calculated probabilities of petrol cap side by collecting data showing during the passing of 40 consecutive cars 26 had caps on the left side and 14 had caps on the right. I then calculated the probabilities of each event, left/right, occurring using the formula: Number of Cars With m Side cap / Number of Cars * 100 m= side of car (left/right) In the same way as was done with inter arrival times and service lengths I created a lookup table that was to be used in my simulations. No ranges needed to be created, as there were only two outcomes possible, left or right. See data sheets for all lookups. Simulation 4 now takes into account what side of the car the pump is on and then assigns it to the pump that is earliest free out of the necessary side. As it can be seen from simulation 4, although there are more pumps than that of simulation 3, the average mean waiting time has increased. The mean waiting times range from 1.75 seconds to 102.73 seconds. The increase is due to the fact that I have failed to include an unless statement to shape the way in which 'although naturally the customer would go to its necessary pump side, coinciding with the side of which the petrol cap is on, if both these pumps are being used, to go to the next pump available or is without a customer, even if it is on the opposing side'. ...read more.


However, as money plays a major role in development, a 3 pump station would do the optimal job and therefore I can conclude, in order to decrease customer waiting times to less than 1 minute, my local petrol station would have o have 3 petrol pumps. Evaluation: My simulations worked very well in the fact that they 1,2, 3 and 4 produce results, which with little assumption would benefit customer satisfaction. Although I was unable to collect sufficient data to properly design simulation 4, the idea works. If I was able to generate a calculation that would outline its defaults then I am sure it would decrease waiting times from that of simulation 4's. If I had enough time, I would also refine each simulation as it could possibly bring the simulation of a 2 pumps stations mean waiting times under 1 minute. Each simulation is not bias as I have used random numbers using spreadsheet software which means to human tinkering could have changed these random numbers, this can be seen as each random number cell has the formula 'RAND()', showing the computer has done it itself. To make it more sensitive, I would have to measure times to decimal seconds in order to produce even further accurate results. The way in which I have kept all random numbers to 6 decimal places has also kept it fair. So from this evaluation I can say I have successfully created a simulation able to predict the optimal number of pumps needed to satisfy customers and staff at my local garage. Data Sheets: Raw Data Lookups Simulations 1,2,3,4 and 5 Simulations 1,2,3,4 and 5 Average Mean Wait Times Simulations 1,2,3/5 and 4 Annotated Formula ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. ICT car insurance quotation System Coursework

    I then highlighted the area A1 to E10 and went to 'Insert', 'Name' and then 'Define'. I called this area 'Groups'. I also highlighted from H1 to I12 and named it 'Costs'. Setting up the Multipliers worksheet The second sheet I set up was the multipliers sheet, which would hold all the factors and their multiplying figure.

  2. The impact of ICT on the Local Community in Southall.

    Our community need to know where is the nearest Leisure centre so they will need a website that provides information and costs. They also need to know what activities are taking place and how to book it. > Schools and Study Centres Community need to have schools to provide basic education to younger generation.

  1. ICT in the local community

    recently, he found a job in a club and has applied for the post. A social case study for ICT in the libraries is when Jay goes to the libraries to send emails, and chat to his relatives back at home.

  2. ICT Coursework (MarcoS)

    Using an account system with a computer is more efficient, because you certainly spend less time, you can make copies of your work, so if the system is down, you have all your files on a cd. The security of the data stored is another big problem, because now all

  1. Adam Property Maintenance - System analysis.

    given any specific tasks and which location the engineers will operating in each day. Then the job log list can be produced as shown below: Name: Peter Date: 09/10/02 TIME/COMP JOB ADDRESS JOB DESCRIPTION PHONE NUM 9-12 57 Hindhead Gardens, Middx UNF 5NF Toilet Handle is broken repair/replace +living room

  2. Develop a spreadsheet application for the Ibis Hotel.

    * There can also be backup facilities are not very advantageous. * It is also time consuming making files handwritten of an individual person. * The company used a typewriter to type important standard letters, to give a sophisticated look.

  1. The end user of my program is for the people applying for the insurance ...

    The employee enters all the customer information by hand entering all the information can be long process and can cause confusion if the hand writing makes it hard for the document to be verified. No mistakes can be made due to this higher or lowering the final price ten

  2. Database Coursework

    It allows the interviewer to talk directly to the interviewee, and means that there would be less chance of getting biased results. Although other methods such as a questionnaire would save much more time in comparison to individually interviewing every worker, it wouldn't get much information, because of the lack of communication.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work