Queuing problem
Each student team will collect real (citation necessary) data for a queuing problem, including costs. Teams will simulate both single queue and multiple queue models. Results will be compared to the prescriptive analysis of the queuing system and students will contrast the mathematical solution and the simulated results. A written report (5-7 pages) will be submitted.
Each student will evaluate from a score from 1-5 for the following:
The student needs to back up their respective evaluations with reasons for their respective assessments.
The first score is based on the quality of the data collected (M2O1)
The second score is based on the ability to appropriately model the system and derive measures of effectiveness and/or optimal solutions using technology, including sensitivity analysis (M2O2)
The third score is based on the use of the appropriate formulas to derive the measures of effectiveness and/or solutions (M1O2)
The fourth score is based on an understanding of the implication of the solutions, and the proposed system solution as part of a management planning process that considers the tradeoffs between cost minimization and service quality objectives (M4O1).
Student must also identify a community or non-profit organization that would benefit from the model developed and specify in what manner the organization would benefit. Although not specifically modeled as a service-learning course, this project may be utilized by interested faculty in that capacity.
5. The fifth score is based on evaluating the applicability of this model to other regions or countries (G3O2).
provide the spreadsheet as an embedded worksheet (excel)