Reference no: EM13110055
You are to simulate arrivals and departures from a fictional airport with a single runway which has a capacity of handling a total 6 aircraft at once (any mix of takeoffs and landings). The purpose of the simulation is to determine how long aircraft will wait to access the runway. Of particular interest is how long airplanes need to wait (queue) in the air before landing since that will require burning fuel.
Assumptions and Constraints:
Airplanes arrive and depart with a single Poisson distribution at an average rate of 5 aircraft per time interval. Assume 50% are arrivals and 50% departures. Thus use one inter-arrival CPG which is exponential and 1/lambda is 1/5 (.2). Use If statement to make half arrivals (landing) and half departures (takeoff).
The single runway can accommodate a maximum of 6 aircraft (any mix of takeoff and landing aircraft) per time interval.
Assume it take one unit of time, exponentially distributed, for the plane to either takeoff or land once it can access the runway. Hence the %u201Cservice%u201D time is exponentially distributed with an average of 1 time interval.
Initial Conditions:
There are no airplanes in the landing queue.
There are no flights awaiting departure.
Your queues have no effective limit since there is plenty of space and tarmac.
Operating Conditions:
Assume arriving and departing flights are given the same priority for accessing the runway.
Since arriving aircraft have limited fuel we want to determine how many time intervals they wait before having access to the strip.
Run the simulation for at least 200 aircraft using Excel. Use Crystal Ball to run the Excel Simulation at least 100 times.
From the spreadsheet (a single run of at least 200 aircraft):
a. What is the average time an aircraft spends waiting to access the runway? .
b. What is the average number of aircraft on the queue (average queue length after entry).
c. What percent of aircraft have zero wait time to access the strip.
d. Develop a histogram of the number of aircraft on the queue. How many times is it 0, 1, 2, 3, etc.
e. Develop a histogram of the number of intervals the aircraft had to wait before they accessed the strip. The histogram should include the number of aircraft that do not wait, wait 1 interval, wait 2 intervals, 3 intervals, etc.
f. What is the maximum queue length? What is the maximum wait time?
|
Estimating the proportion of ptc
: PTC is a substance that has a strong bitter taste for some people and is tasteless for others. The ability to taste PTC is inherited. About 75% of Italians can taste PTC
|
|
Determine the level of reliability
: An engine system consists of three main components in a series, all having the same reliability. Determine the level of reliability required for each of the components if the engine is to have a reliability of 0.998.
|
|
Technology and organizational behavior
: Select an industry with which you are familiar. Predict how future technology will inform, support, and potentially hinder productivity, culture, and work satisfaction within an organization in the industry.
|
|
Create frequency distribution for ages strokes due to stress
: Medical research team studied the ages of patient who had strokes caused by stress. Ages of 34 patients who suffered stress strokes. Create frequency distribution for these ages.
|
|
Determine the maximum queue lengt
: You are to simulate arrivals and departures from a fictional airport with a single runway which has a capacity of handling a total 6 aircraft at once (any mix of takeoffs and landings).
|
|
Hypothesis testing of mean-sleep per night
: According to a recent survey, Americans get a mean of 7 hours of sleep per night. A random sample of 50 students at West Virginia University revealed the mean number of hours slept last night was 6 hours and 48 minutes
|
|
Business plan that highlights financial, marketing aspects
: Imagine that you are beginning the very first social networking site, fast-food restaurant, or pizzeria, and develop a brief business plan that highlights the financial, marketing, and organizational aspects.
|
|
Hypothesis testing of varaiance-cereal box filling weight
: The filling weight for boxes of cereal is designed to have a variance .02 ounces or less. A sample of 41 boxes of cereal shows a sample standard deviation of .16 ounces.
|
|
Mean rating of caseworker for males and female
: You are conducting an evaluation of services at a social service agency. One of the evaluation issues is finding out whether male clients rate the quality of casework services as highly as do female clients.
|