Describe How to Create an OLAP Report for a Microsoft

question 14

Essay

Describe how to create an OLAP report for a Microsoft Access 2013 database in Microsoft Excel 2013.

---

Definitions:

Standard Costs

Predetermined costs for materials, labor, and overhead used as targets for controlling production costs.

Direct Materials Price Variance

The difference between the actual cost and the standard cost of direct materials used in production.

Standard Materials Quantity

The estimated amount of materials expected to be used in the production of a product under normal operating conditions.

Board Feet

A unit of measure for lumber, representing a volume of 144 cubic inches, equivalent to a board that is one foot long, one foot wide, and one inch thick.