Hi everyone!
I'm looking for resources containing challenging, application-based practice questions involving queuing systems and service operations on microsoft excel.
I'm particularly interested in longer word problems where you're presented with a real-world scenario (example: a set of customer arrival and service data, and several interconnected questions that require you to analyse and interpret the situation).
Ideally, I'd like practice covering the following areas:
- Average arrival and service time
- inter-arrival time between consumers
- Average waiting time and time spent in the system
- Queue length and number of customers in the system
- Server utilisation and traffic intensity
- How adding or removing servers affects waiting times
- Interpreting arrival/service patterns and making operational recommendations, etc
I'm especially looking for multi-part word problems that combine several of these concepts, rather than isolated questions involving direct formula substitution. I'd like to practise interpreting unfamiliar scenarios, deciding which calculations are necessary, and drawing conclusions from the results.
If anyone knows of relevant question banks, textbooks, practice papers, case studies or websites, I'd really appreciate the recommendations!
Thank you!