This term project aims to combine your knowledge on Queuing Theory together with your analysis and development skills. You will be working as a team and are asked to provide a decision support tool $($DST$)$ to perform various Queuing Theory $/$ Queuing Models analysis. Details and deliverible requirements are provided in the requirements section.

Requirements:

Input requirements: This part is explaining the items related to the user inputs of the DST$.$ List of inputs expected from the user are:

The queuing model $($QM$)$ to be analysed. This should be a drop down menu that the user can select from. It can be one of the following:

M$/$M$/1$:GD$/\backslash$infty $/\backslash$infty

M$/$M$/1$:GD$/$N$/\backslash$infty

M$/$M$/$c:GD$/\backslash$infty $/\backslash$infty

M$/$M$/$c:GD$/$N$/\backslash$infty

M$/$M$/\backslash$infty :GD$/\backslash$infty $/\backslash$infty $($self$-$service model$)$

M$/$M$/$R:GD$/$K$/$K $($repair$-$shop model$)$

M$/$G$/1$:GD$/\backslash$infty $/\backslash$infty $($P$-$K formula$)$

Parameters of the QM depending on the selected queuing model. The following matrix provides the necessary input for each QM:

Queuing Model Input Parameters Needed

M$/$M$/1$:GD$/\backslash$infty $/\backslash$infty $,$

M$/$M$/1$:GD$/$N$/\backslash$infty $,,$ N

M$/$M$/$c:GD$/\backslash$infty $/\backslash$infty $,,$ c

M$/$M$/$c:GD$/$N$/\backslash$infty $,,$ c$,$ N

M$/$M$/\backslash$infty :GD$/\backslash$infty $/\backslash$infty $($self$-$service model$),$

M$/$M$/$R:GD$/$K$/$K $($repair$-$shop model$),,$ R$,$ K

M$/$G$/1$:GD$/\backslash$infty $/\backslash$infty $($P$-$K formula$),$ E$\{$t$\},$ Var$\{$t$\}$

Functionality Requirements: This part of the project describes what kind of calculations and operations your DST must be providing:

Checking if the the user selected a QM from the drop down menu. If not warn the user.

Depending on the menu selected, display the required parameter input fields and check for the validity of all required parameters.

Calculate the following steady$-$state measures of performance:

p$0,$ pn $($for n upto $20),$

for limited N QMs: pN $,$eff$,$lost

Ls $,$ Lq $,$ Ws $,$ Wq $,$ c

Clearing all the inputs and outputs with a button$/$command

Output Requirements: This part of the project describes what outputs your DST should be delivering to users. You are supposed to provide the steady$-$state measures of performance described previously. Namely, you should display the results for:

p$0,$ pn $($for n upto $20),$

for limited N QMs: pN $,$eff$,$lost

Ls $,$ Lq $,$ Ws $,$ Wq $,$ c

Other Details:

Excel VB and macro usage is recommended but not mandatory.

Submission deadline: January $5$th$,$ Friday, $23$:$59$

All team members are expected to contribute

You will be delivering all of your source code, project files and related items

You will deliver a small report$/$manual on how your DST is used by providing screen shots on a sample data $($at most $5$ pages$).$

Each team will prepare a $3$ minute $(\backslash$pm $10$ seconds$)$ video explaining the following parts of their project:

Showing a demo of at least $2$ queuing models with some sample data and results obtained bye your DST $(1$ minutes$)$

Explaining where and how you enter the input and a small demo of error checking $($for example if you enter a negative value for $,$ it should give an error$)(1$ minute$)$

If you have developed your DST by using macros and user forms, a small overview of your VBA codes and forms. $(1$ minute$)$

If your team has $2$ members split the videos by $1\mathrm{.}5$ minutes for each team member, if your team has $3$ members each member should participate $1$ minute.