Sheet 4

Manually simulate the waiting line problem (given in book p.607) for 10 customers using the following modifications.

The first customer arrives at time zero.

The inter-arrival time and service time for the 10 customers are as follows:

Beside the modifications listed above, use all the assumptions indicated in the book.

Required:
a- Number of customers who had to wait
b- Probability of waiting
c- Average waiting time
d- Maximum waiting time
e- Minimum waiting time.
f- Utilization of server
g- Number of customers who had to wait more than 1 min.
h- Probability of waiting more than 1 min.
--

Each student must submit the answer of sheet 4.

The deadline is Friday 2nd of April 2010.

You send your answer as an attached pdf file to the following email:

sheet4@ymail.com

Recall to put your name and ID no. in the first page of the pdf file.

N.B. To convert any document into a pdf file you can use the following free SW:

http://www.cutepdf.com/download/CuteWriter.exe

Lect 24 March

Code: yaew4xu

This lect. is based on the book:

An Introduction to Management Science Quantitative Approaches to Decision Making 12th Edition International Edition 2008

Chapter 13 (pp. 607-614)

Sheet 3

Manually solve the inventory simulation problem (given in book) using the following modifications.

- Demand is represented by a uniform probability distribution ranging from 50 till 150 (units).

- Run the simulation 3 times, in order to try the following 3 values for Q:

50

100

150

The length of each simulation run is 5 months.

In each run, use the following 5 random numbers to generate random samples for Demand.

0.88 0.11 0.55 0.77 0.33

Beside the modifications listed above, use all the assumptions indicated in the book.

Required:

For each value of Q, compute the two output measures.

--

Each student must submit the answer of sheet 3.

The deadline is Friday 26th of March 2010.

You send your answer as an attached pdf file to the following email:

sheet_no3@ymail.com

Recall to put your name and ID no. in the first page of the pdf file.

N.B. To convert any document into a pdf file you can use the following free SW:

http://www.cutepdf.com/download/CuteWriter.exe

Research Skills for Finding Information in Digital Databases and the Internet

Code: yjqkyeq

Lect Wed 17 March + Associated Excel file

Code: y9z6nf3

This lect. is based on the book:

An Introduction to Management Science Quantitative Approaches to Decision Making 12th Edition International Edition 2008

Chapter 13 (pp. 601-606)

Lect Sun 14 March

Code: yghqcbx

This lect. is based on the book:

An Introduction to Management Science Quantitative Approaches to Decision Making 12th Edition International Edition 2008

Chapter 13 (pp. 601-603)

Sheet 2

Manually solve the following simulation problem

Profit = Revenue - Cost

Cost is a parameter (constant) .

Cost = 1,000,000 LE

Revenue = Price * Demand

Price is a probabilistic input that follows a continuous uniform distribution ranging from 8.5 LE to 9.5 LE.

Demand is also a probabilistic input that follows the discrete probability distribution given below

Demand Prob.

120,000 0.3

110,000 0.4

100,000 0.3

N.B. run 20 trials

To generate random samples of Price use the following random numbers

0.6557 0.0357 0.8491 0.9340 0.6787 0.7577 0.7431

0.3922 0.6555 0.1712 0.7060 0.0318 0.2769 0.0462

0.0971 0.8235 0.6948 0.3171 0.9502 0.0344

To generate random samples of Demand use the following random numbers

0.4387 0.3816 0.7655 0.7952 0.1869 0.4898 0.4456

0.6463 0.7094 0.7547 0.2760 0.6797 0.6551 0.1626

0.1190 0.4984 0.9597 0.3404 0.5853 0.2238

Required:

a- Compute the minimum value of Profit

b- Compute the maximum value of Profit

c- Compute the average value of Profit

d- Compute the standard deviation of Profit.

e- Compute the median of Profit.

f- Compute the 25th, 50th, 75th percentiles of Profit.

g- Determine the probability of loss.

h- Divide the range (based on your answers in a & b) into 10 equal intervals; then compute the frequency in each interval. Show your answer both as a table & a histogram.

--

Each student must submit the answer of sheet 2.

The deadline is Friday 19th of March 2010.

You send your answer as an attached pdf file to the following email:

sheet2@ymail.com

Recall to put your name and ID no. in the first page of the pdf file.

N.B. To convert any document into a pdf file you can use the following free SW:

http://www.cutepdf.com/download/CuteWriter.exe

Lect Sun 7 March + Associated Excel file

Code: yksvusp

N.B. the numbers in the profit sheet are demo numbers (not computed by the model).

All other numbers in the rest of the sheets are actual numbers computed by the model (or actual input data).

This lect. is based on the book:

An Introduction to Management Science Quantitative Approaches to Decision Making 12th Edition International Edition 2008

Chapter 13 (pp. 590-600)

My Office Hours

Sun 4:00 -> 5:30

Wed 4:00 -> 5:30

Lect. Wed 3 March 2010

Code: yldh9xx

This lect. is based on the book:

An Introduction to Management Science Quantitative Approaches to Decision Making 12th Edition International Edition 2008

Chapter 13 (pp. 590-593)