Question
(20 points) A high school guidance counselor has scheduled one-on-one meetings today with 10 seniors to discuss their college plans. Each meeting is scheduled for
(20 points) A high school guidance counselor has scheduled one-on-one meetings today with 10 seniors to discuss their college plans. Each meeting is scheduled for 20 minutes, with the first meeting set to start at 9:00 a.m. Due to their hectic class and extra-curricular schedules, not every student arrives on time, and not every meeting lasts exactly 20 minutes. The counselor knows the following from past experience: A student will be 10 minutes early 5% of the time, 5 minutes early 20% of the time, exactly on time 35% of the time, 5 minutes late 30% of the time, and 10 minutes late 10% of the time. The counselor further estimates that there is a 15% chance that a meeting will take only 15 minutes, 50% chance it will take exactly the planned time, 25% chance it will take 25 minutes, and 10% chance it will take 30 minutes. Students are seen in the order in which they have been scheduled, regardless of when they arrive. However, a student arriving early can see the counselor as soon as the previous meeting ends. Use 250 replications to determine when the counselor will complete the last meeting. Hints: Calculate a start time and finish time for each student. Use the MAX function to determine the start time of students 2–10.
Please answer and show in excel. thank you.
Step by Step Solution
3.28 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
1 Attend BacktoSchool Night and ParentTeacher Conferences Teens do better in school when parents sup...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started