Due to a pedestrian traffic light, people arrive at an elevator in groups once every 3 minutes (like clockwork). The number of people in each arriving group is drawn from the table. The elevator can accommodate at most five people. If it does not go beyond the 8th floor, it takes the elevator an average of 2 minutes to load, depart, travel, and return to the ground floor. If it goes beyond the 8th floor it takes an average of 4 minutes. The elevator does not go beyond the 8th floor in 75% of the trips. If anyone is waiting for the elevator when it returns, those people load (up to five) and departs immediately without waiting for the next group to arrive.

Model for 10 arriving groups until all people are accommodated (have completed an elevator ride). The elevator is at the ground floor at the beginning of the simulation and must return to the ground floor to end the simulation. Replicate 1000 times and find: 1) the average number of people in an elevator ride

2) the average time a person had to wait for the elevator

3) the probability that a person will have to wait for the elevator

5) the utilization of the elevator

6) the average number of trips the elevator makes per hour

Must be in Excel and must show formulas.