Please solve it in Excel Vba Scope:

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 drondoum menu that the user can

select from. It can be one of the following:

$\frac{M}{M}\frac{?}{1}$:$G\frac{D}{}\frac{?}{}$

$\frac{M}{M}\frac{?}{1}$:$G\frac{D}{N}\frac{?}{}$

$\frac{M}{M}\frac{?}{CG}\frac{D}{}\frac{?}{}$

$\frac{M}{M}\frac{?}{cG}\frac{D}{N}\frac{?}{}$

$\frac{M}{M}\frac{?}{}$;$G\frac{D}{}\frac{?}{}($self$-$service model$)$

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

$\frac{M}{G}\frac{?}{1}$:$G\frac{D}{}\frac{?}{}($P$-$K formula$)$

Parameters of the QM depending on the selected queuing model. The following matrix provides

the necessary input for each QM:

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 dron drimmenu. 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_b{p}_n($for $n$ upte $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.