using microsoft excel:

Application #2: Students Cafeteria Consider a Students Cafeteria system with the following characteristics: Students arrive at a self-service cafeteria according to a random process with time between arrivals that follows truncated exponential distribution with mean (1 minutes), minimum value of (2 minutes) and maximum value of 12 minutes) It is estimated that (40%) of students go to the sandwich bar, where every student prepares has own sandwich in a random time that follows a triangular distribution with minimum of (1 minute), mod value of (1.5 minutes) and maximum value of (3 minutes). The rest of the students go to the main counter, where one server spoons the prepared meal onto a plate in a random time that follows shifted Weibull distribution with parameters shift value of (1 minute), parameter (a = 5 and B = 4). It is estimated that 60% of the student who take sandwiches take their order for "To Go" the and 20% of the students who ordered main course take it for "To Go". The rest of the student will dine in the cafeteria and will spend a random amount of time that follows a shifted binomial with parameters (n = 10 and p = 0.45) and with shift of 2 minutes. After students finish eating, 10% of only the main course student students go back for dessert, and return to their table to spend an additional uniform discrete time 3+2 minutes in the cafeteria. The cafeteria work hours are from 8:00am to 3:00pm 1. Simulate the system for 20 days and store all simulation output for every day in separate table. 2. At each hour of every day, estimate the following from the simulation data: a. How many students are still in the cafeteria b. What is the average number of students per hour and the 95% confidence interval. c. What percentage of students at the sandwich bar. d. What is the average time that a "dine-in" student with sandwich spends in the cafeteria since the moment he enters, e. What is the average time that a "dine-in" student with main course meal spends in the cafeteria since the moment he enters and the 95% confidence interval f. What percentage of students take dessert