Critical Thinking Case-Based Questions Case 5-3 as He Prepares His

question 21

Multiple Choice

Critical Thinking Case-Based Questions Case 5-3 As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job. ​If Ted decides that he wants to work with nonnumeric data in his PivotTable, what function must he use to produce summaries?

• A)Sum
• B)Aggregate
• C)Total
• D)Count

---

Definitions:

Budget Variance

The difference between the budgeted or planned amounts and the actual amounts incurred.

Standard Cost

A predetermined cost of manufacturing a single unit or a number of product units during a specific period under normal conditions.

Variable Overhead

Costs that vary with production volume, such as utilities or materials, which do not remain fixed over time.

Cost Driver

A factor that causes the cost of an activity to increase or decrease, such as machine-hours, labor hours, or production volume.