Use a Modern Software Tool to Perform Statistical Calculations Mr Coppell Hires 6 Permanent Employees and Wants to Staff

question 44

Multiple Choice

Use a modern software tool to perform statistical calculations.
Use the table below to answer the following question(s) using the standard Solver.
Coppell Services contracts with outsourcing partners to handle various customer service functions. Based on a study of call volumes provided by one of the firm's partners, the minimum number of staff needed for each hour of the day is as follows: $$\begin{array} { | l | l | } \hline \text { Hour } & \text { Minimum Staff Required } \\\hline 8 - 9 & 6 \\\hline 9 - 10 & 10 \\\hline 10 - 11 & 12 \\\hline 11 \text {-noon } & 10 \\\hline \text { noon-1 } & 8 \\\hline 1 - 2 & 16 \\\hline 2 - 3 & 15 \\\hline 3 - 4 & 20 \\\hline 4 - 5 & 15 \\\hline\end{array}$$ Mr. Coppell hires 6 permanent employees and wants to staff the remaining requirements using part-time employees who work 4-hour shifts (four consecutive hours starting as early as 8 A.M. or as late as 1 P.M.) .
-How many excess employees are present in the noon-1 time slot?

• A) 2
• B) 4
• C) 5
• D) 6

---

Definitions:

Highest-Ranking IS Manager

The senior-most executive in an organization responsible for overseeing the information systems strategy and ensuring alignment with overall business objectives.

Strategic Planning

A structured approach to creating a vision of the desired future, then outlining general goals or aims and planning a series of actions to realize this vision.

Digital Initiative

A project or endeavor that leverages digital technology to achieve business goals, improve processes, or enhance customer experiences.

New York Times Beta Group

A division of The New York Times that focuses on developing new digital products and experimental projects to enhance the news experience.