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

question 7

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.) .
-Which of the following best defines a binary variable?

• A) It is a general integer variable that is restricted to being between -1 and 1.
• B) It is a general integer variable that is restricted to being a multiple of 2.
• C) It is a general integer variable that is restricted to being between 0 and 1.
• D) It is a general integer variable that is restricted to being greater than 2.

---

Definitions:

Revenue

The total amount of money received by a company for goods sold or services provided during a certain time period.

Type II Error

A statistical mistake of failing to reject a false null hypothesis; also known as a false negative.

Expected Decision Error Costs

The anticipated costs associated with making incorrect decisions, often used in risk assessment and decision-making processes.

Unsold Merchandise

Items that have not been sold during a specific period, often leading to overstock and potential losses for businesses.