Case-Based Critical Thinking Questions Case 1 - MaidToOrder

question 24

Multiple Choice

Case-Based Critical Thinking Questions Case 1 - MaidToOrder
The database for a cleaning service company contains the following table, named tblCustomer, that includes customer invoice data. The InvoiceNum, CustomerNum, and InvoicePaid fields contain text. The InvoiceDate field contains dates. The InvoiceAmt field contains numbers.
Which of the following statements will calculate a total for all of the unpaid invoices?

• A) Dim decTotalUnpaid = Aggregate customer In CustomerDataSet.tblCustomer Select customer.InvoicePaid Into Sum()
• B) Dim decTotalUnpaid = Aggregate customer In CustomerDataSet.tblCustomer Select customer.InvoiceAmt Into Sum()
• C) Dim decTotalUnpaid = Aggregate customer In CustomerDataSet.tblCustomer Where customer.InvoicePaid.ToUpper = "N" Select customer.InvoiceAmt Into Average()
• D) Dim decTotalUnpaid = Aggregate customer In CustomerDataSet.tblCustomer Where customer.InvoicePaid.ToUpper = "N" Select customer.InvoiceAmt Into Sum()

---

Definitions:

Total Contribution Margin

The difference between total sales revenue and total variable costs, measuring how much revenue covers fixed costs and profits.

CVP Graph

A visual representation of the Cost-Volume-Profit analysis that illustrates the relationships between costs, volume, and profit.

Total Fixed Expenses

Total fixed expenses refer to the sum of all costs that do not change with the level of production or sales over a certain period.

Total Variable Expenses

The sum of all costs that vary directly with the level of production or sales volume over a specific period.