Hi

Please help me figure out how to do this on Excel, thank you!

1. (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 talk 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 210. 2. (20 points) Lionel's Life Jacket Rentals leases life jackets each day from a supplier and rents them to customers who use them when they raft down the Delaware River. Each day, Lionel leases 30 life jackets from his supplier, at a cost of $4 per life jacket. He rents them to his customers for $15 per day. Rental demand follows the normal distribution, with a mean of 30 life jackets and a standard deviation of 6 life jackets. (In your model use integers for all demands.) (a) Simulate this leasing policy for a month (30 days) of operation to calculate the total monthly profit. Replicate this calculation 200 times. What is the average monthly profit? (b) Lionel would like to evaluate the average monthly profit if he leases 25,30,35, and 40 life jackets. What is your recommendation? Why? To clarify, the model itself will have 30 rows, with each row calculating the profit for that day. The sum of those rows will represent the total profit for the month. That monthly profit is what goes into the Data Table and is replicated 200 times. 3. (4 points) On a new sheet, use Excel's Random Number Generator to generate two sets of daily customer arrivals for 30 days in a row according to a Poisson distribution with an average of 300 customers per day. Use a starting seed of 183. Put the demand data in the range A1:B30. QYER . 4. (6 points) a. Enter the set of profit values below into a new sheet. Using Excel's risk analysis formula to estimate the probably that profit will be greater than $4,500. b. Create a histogram chart of the profit values below. Use bins of $2,000,$4,000,$6,000, $8,000, and $10,000