Baxter Customer Service Department Follows Up on Customer Complaints by Telephone

question 32

Multiple Choice

Baxter customer service department follows up on customer complaints by telephone inquiry. During a recent period, the department initiated 10,000 calls and incurred costs of $312,000. Of these calls, 3,800 were for the company's wholesale operation; the remainder was for the retail division. Costs allocated to the retail division are:

• A) $0.
• B) $31,200.
• C) $118,560.
• D) $193,440.
• E) $203,000.

---

Definitions:

Changing Cell

In spreadsheet applications, a cell whose value is altered based on changes in a formula or as part of a scenario analysis.

Objective Cell

In optimization and spreadsheet software, the cell that contains the formula that is to be maximized or minimized.

Goal Seek

A function in spreadsheet software that finds the input value needed to achieve a specific goal or result in a formula.

What-If Analysis

A process or feature in spreadsheet and analytical software that allows users to predict the outcome of a particular action or scenario by changing variables.