Question: ***Please pay attention, there is a second part I would like answered*** ***Please do not just answer this first part I know it has been

***Please pay attention, there is a second part I would like answered***

***Please do not just answer this first part I know it has been answered several times***

The Paymore Rental Car Agency rents cars in a small town. It wants to determine how many rental cars it should maintain. Based on market projections and historical data, the manager has determined probability distributions for the number of rentals per day and rental duration (in days only) as shown in the following tables:

Number of customers per day

Probability

0

.20

1

.20

2

.50

3

.10

Rental duration in days

Probability

1

.10

2

.30

3

.40

4

.10

5

.10

Design a simulation experiment for the car agency and simulate using a fleet of four rental cars for 10 days. Compute the probability that the agency will not have a car available upon demand. Should the agency expand its fleet? Explain how a simulation experiment could be designed to determine the optimal fleet size for the Paymore Agency.

***This is the second part I want answered, please read below***

Use the following random numbers in order (from left to right) for the simulation of number of customers per day:

0.62

0.48

0.96

0.86

0.86

0.29

0.79

0.22

0.08

0.62

Use the following random numbers in order (from left to right, first row first - as you need them) for the simulation of car rental duration in days.

0.19

0.66

0.27

0.43

0.20

0.92

0.22

0.91

0.46

0.49

0.66

0.09

0.81

0.05

0.91

0.97

0.24

0.01

0.27

0.69

0.18

0.06

0.53

0.97

0.13

0.21

0.97

0.09

0.26

0.47

0.62

0.89

0.76

0.24

0.10

0.90

Advice: Remember you are conducting the simulation manually and are not supposed to use Excel formulas but rather show the process (however you can Excel to display your work!). Also, a car rented in day 1 with a duration of 2 days becomes available for rent in day 3.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!