Open a new Tableau Workbook from the File menu. Select the $$Connect to Data$$ option in the Data tab on your blank worksheet page, or you can select Data Source in the bottom left hand corner. Next, select Microsoft Excel in the list of connection sources. You will then select the Excel data file you just downloaded in your file explorer.

Within the Sheet$1$ tab, create a calculated field by either right clicking anywhere in the blank space of the Data pane and selecting Create Calculated Field or click the Analysis tab and select Create Calculated Field from the dropdown menu. Title the new variable $$Direct Materials Purchase$-$Price Variance$.$ In the space for formulas, multiply the actual amount purchased by the difference between the standard cost and actual cost of materials purchased.

Create a calculated field by either right clicking anywhere in the blank space of the Data pane and selecting Create Calculated Field or click the Analysis tab and select Create Calculated Field from the dropdown menu. Title the new variable $$Direct Materials Usage Variance$.$ In the space for formulas, multiply the difference between the standard amount and the actual amount used by the standard cost of the used materials.

Create a calculated field by either right clicking anywhere in the blank space of the Data pane and selecting Create Calculated Field or click the Analysis tab and select Create Calculated Field from the dropdown menu. Title the new variable $$Direct Labor Rate Variance$.$ In the space for formulas, multiply the actual amount of direct labor by the difference between the standard cost of direct labor and the actual cost of direct labor.

Create a calculated field by either right clicking anywhere in the blank space of the Data pane and selecting Create Calculated Field or click the Analysis tab and select Create Calculated Field from the dropdown menu. Title the new variable $$Direct Labor Efficiency Variance$.$ In the space for formulas, multiply the difference between the standard amount of direct labor and the actual amount of direct labor by the standard cost of direct labor.

Either click the dropdown arrow that appears on the Month attribute or right click the Month attribute. Hover over the Change Data Type Option and select Date in the list of options that appears.

Drag and drop month onto the Columns shelf. Either click the dropdown arrow or right click the Month attribute that is now on the Columns shelf. Select the first Month option that appears in the list of options.

Drag and drop Direct Materials Purchase$-$Price Variance from the data pane into the Rows shelf.

Drag and drop Direct Materials Usage Variance onto the Y$-$axis.

Drag and drop Direct Labor Rate Variance onto the Y$-$axis.

Drag and drop Direct Labor Efficiency Variance onto the Y$-$axis.

Save your file, then answer the questions below using the Tableau dashboards you have created.

$9.$ Which variances were abnormally favorable in June? $($Select all that apply. Every box must be clicked. Click the box with the question mark to produce a check mark to select an answer. Click again to deselect an answer. Any boxes with question marks will be considered unanswered and graded incorrect! Check My Work is not enabled for this question.$)$

check all that apply $1$

Direct Materials Purchase$-$Price Varianceunanswered

Direct Materials Usage Varianceunanswered

Direct Labor Rate Varianceunanswered

Direct Labor Efficiency Varianceunanswered

$10.$ Which variances were abnormally unfavorable in June? $($Select all that apply. Every box must be clicked. Click the box with the question mark to produce a check mark to select an answer. Click again to deselect an answer. Any boxes with question marks will be considered unanswered and graded incorrect! Check My Work is not enabled for this question.$)$

check all that apply $2$

Direct Materials Purchase$-$Price Varianceunanswered

Direct Materials Usage Varianceunanswered

Direct Labor Rate Varianceunanswered

Direct Labor Efficiency Varianceunanswered

PrevQuestion $1$ of $3$ Total$1$ of $3$Visit question mapNext