CUSTOM SPA The Following Questions Citing CUSTOM SPA Assume That a Single-Source

question 56

Multiple Choice

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created. The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE, shown below. In this database, each visit includes one patron, one spa employee, and one or more procedures. The price for each procedure varies from visit to visit.

CUSTOM SPA DAILY VISITS DATABASE



-Based on the data shown in the CUSTOM SPA DAILY VISITS DATABASE,the dimension CALENDAR in the CUSTOM SPA star schema has ________ record(s) .

• A)0 (the dimension CALENDAR does not exist)
• B)1
• C)4

---

Definitions:

Ending Inventory

The total value of all inventory a company has in stock at the end of an accounting period.

Variable Production Costs

Costs that vary in proportion to the level of production or business activity.

Variable Costing

An accounting method that only takes into account the variable production costs (direct materials, direct labor, and variable manufacturing overhead) when calculating product cost.

Period Cost

Expenses that are not directly tied to production and are expensed in the period they are incurred, such as selling, general, and administrative expenses.