A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each

question 7

Multiple Choice

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After entering the data below, the modeler would like to enter a formula in cell C5 that can then be copied to cells C6 through C9 without further modification. What formula should be entered in cell C5 to make this possible?

• A) =B2*B5
• B) =B2*$B$5
• C) =$B$2*B5
• D) =$B$2*$B$5
• E) =B2+B5

---

Definitions:

Actual Costs

Actual costs are the real or true costs incurred for materials, labor, and overhead in the production of goods or provision of services, as opposed to estimated or standard costs.

Direct Labor Rate Variance

The difference between the actual cost of direct labor and the expected (or standard) cost, used to analyze labor cost efficiencies or inefficiencies during production.

Standard Costs

Predetermined or budgeted costs serving as benchmarks for measuring performance, commonly used for budgeting and variance analysis.

Actual Costs

The real costs incurred in the production of goods or in the provision of services.