Assignment Overview:

Read the $$Case Study $-$ Staffing a Call Center$$ provided in the attached PDF$.$

Based on the information in the case study, answer the following questions:

Question $1$

How many Spanish$-$speaking and English$-$speaking operators do the hospital need to staff the call center during each $2-$hour shift of the day so that the total labor cost is minimum? Provide an integer number since half a human operator makes no sense. $(15$ marks$)$

Question $2$

Suppose the average number of calls per hour increases to $50($from $35)$ for the shift $5$:$00-7$:$00$ p$.$m$.$ What is the new optimal staffing plan? How many Spanish$-$speaking and English$-$speaking operators are required during each $2-$hour shift of the day? $(5$ marks$)$

Note: Solve both questions using Excel Solver and interpret the solution obtained.

The data and solution for each of the two questions are to be depicted in two different sheets of an MS Excel workbook. Based on the question, each of the two sheets should include the following:

$$ Data and input parameters, as applicable

$$ Mathematical program of the problem including objective function and constraints variables

$$ Derivation of decision variable, using relevant formulae

$$ Formula to derive the objective function

$$ Solution of the problem using Excel Solver

Assignment Deliverables:

As the deliverable of the assignment, you need to submit an MS Excel Workbook, which includes the following three worksheets:

$1.$ Worksheet $1$ Name of the Team Members

$2.$ Worksheet $2$ Data and solution based on Question $1$

$3.$ Worksheet $3$ Data and solution based on Question $2$

Summary of Review Criteria

The data and solution for each of the two questions are to be depicted in two different sheets of an MS Excel workbook. Your submission will be graded based on the following criteria.

$$ Relevance and correctness of data and input parameters, as applicable.

$$ Correct depiction of Mathematical Model, including objective function and constraints.

$$ Definition and derivation of decision variable, using relevant formulae.

$$ Correct formula to derive the objective function.

$$ Solution of the problem using Excel Solver.

$$ Correct settings of the parameters in the Solver Parameters dialog box.

$$ Correct derivation of the solution.

Overview of grades

Total number of points $20$

Question $1-15$ points

Question $25$ points