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

question 67

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



-The detailed fact table in the CUSTOM SPA star schema has ________ records.

• A)0
• B)5
• C)8
• D)50

---

Definitions:

Work in Process

Refers to the cost of unfinished goods in the manufacturing process including labor, raw materials, and overhead costs.

Total Conversion Costs

Total conversion costs are the sum of labor and overhead expenses incurred to convert raw materials into finished goods.

Ending Work in Process

The balance of goods that are still in the production process at the end of an accounting period and have not yet been completed.

Units Started

The quantity of units that began production over a particular period in the manufacturing process.