The Following Shows the Salesmen Name, the Cell Where Their

question 30

Multiple Choice

The following shows the salesmen name, the cell where their quarterly total sales are stored in Excel, and the amount of quarterly sales. Which is the formula that can be used to find the percent of total sales for Marco Sartoro? Brent Dumont, E7: $135,000
Candice McAfferty E8: $210,500
Marco Santoro, E9: $195,000
Total Sales, E10: $540,500

• A) =(E7 + E8 + E9)/3
• B) =E9/E10*100
• C) =E10/E9*100
• D) =E9/(E7 + E8)

---

Definitions:

Activity Cost Pools

Aggregations of all the overhead costs associated with specific activities, used in activity-based costing.

Customer Margin

The profit generated from a particular customer, calculated by subtracting the costs associated with serving that customer from the revenue they generate.

Serving Customers

The activities involved in providing products or services to customers effectively.

Activity Cost Pools

Accumulations of costs grouped by similar or related activities, used in activity-based costing to allocate costs more accurately.