Assignment $6($similar to Exercise $14-26)$

Summit Machinery Company uses aluminum to manufacture a product, XV$-1.$ Aluminum has historically been a large input to the product and one of the biggest costs to the process. In order to decrease these input costs, Summit recently signed a deal to begin obtaining its aluminum from a new supplier starting on May $1.$ Using the following manufacturing data, analyze the effects of the new aluminum on Summit$$s production variances.

Click here to access the Assignment $6$ Excel File of Manufacturing Data.

Assignment $6$ Steps:

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.$\backslash$table$[[$Month$,$Purchase $-$ Actual Amount,Cost,al Cost,Amount,moun,Cost,Amount,Amount,Cost,al Cost$],[$January$,3,600,25,25\mathrm{.}25,3,500,3,495,22,3,900,3,880,40,40\mathrm{.}15],[$February$,3,620,25,25\mathrm{.}15,3,500,3,480,23,3,900,3,910,40,39\mathrm{.}9],[$March$,3,640,25,24\mathrm{.}8,3,500,3,535,24,3,900,3,905,40,39\mathrm{.}85],[$April$,3,610,25,24\mathrm{.}95,3,500,3,490,25,3,900,3,890,40,39\mathrm{.}95],[$May$,3,650,22,21\mathrm{.}55,3,500,3,800,22,3,900,4,100,40,40\mathrm{.}1],[$June$,3,660,22,21\mathrm{.}1,3,500,3,850,22,3,900,4,050,40,39\mathrm{.}9]]$