Cost Accounting

1. Open a new Tobleau Workbook from the File netha. Seloct the "Connect to Data' option in the Data tat on youl blank worksheet page, ot you can soloct Data Saube in the bottom lett thand comer. Nout, sethet Micionst Ecect in the list of cannection sources You wil then solect the Excel data filo you just downlooded in your flile explonor. 2. Within the Slieetl tab, create a caiculatod field by either right choking anywisere in the blask space of ure Data pane and oblecting Create Caleulated Ficld of click the Amalybis tab and select Creote Caiculated Ficid thom the dropdomb imenu. Thtie the new variable "Direct Materials Putchase. Price variance" in the space for fornulas, multoply the actial amount purchased by the difference between the standard cost and actual cost of materlais purchased 3. Cresbe a calculated fieid by eather right ctiching anywhere in the blakk space of the Data pane and soleching Create Calculated Fleld or click the Analyes tab and select Create Calculated Field from the dogdown menu Fite the new valable "Direct anount used ty the standard cost of the used materiahi 4. Create a cakculated fiels by esther right clicking anywhere in the blank space of the Data pane and beiecting Create Calculated of direct laber and the actusi cost of airect iator. 5. Cleate a caicutated fietid by either fight chickimg armwhere in the blank space of the Dati pane and selecteng Create Caiculated Etficiency Variance" in the space for formulas, multiply the dafrerence between the atindard omolint at ditoct iabor and the actual amount of cerect labor by the standard cost of diest lation. 6. Either click the diopdown artow tham appears on the Momith attibute of High cliek the Moritis atibute Honer owe the Cnange Dati Type Option and select Pase in the list of options that appear. 7. Drag and diop month onte the Coiumas shelf Eather cosk the dropdown airow or fight click the Month attioute mat is now on the Columns stheif Seloct the first Morith opton that appears in the list of options. 8. Dong and drop Direct Materiats Parchase.Price Warance from the data pane vito the flows sheit 9. Drag and drop Direct Materinis tsoge Vatiance onto the Yoxm 10. Drag and drop Direct tabor Rine Voringe onte the Yhuil. 11. Deag and drop Beect Labor. Elficiency Varance orta the Yiaxia. Sove your fice, then answer the questions telew using the Tableau dasthboards you havo crovied. 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 cllcked. 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 incorrectl Check My Work is not enabled for this question.) Direct Materials Putchase.Pice Variance Direct Matertals Usage Variance Dioct Labor Rote Varionce Direct Labor Efficiency Varionce 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.) 2 Direct Materials Purchose-Price Varionce Direct Materials Usoge Voriance ? Drect Labor Rate Varionce Direct Labor Efficiency Variance 1. Open a new Tobleau Workbook from the File netha. Seloct the "Connect to Data' option in the Data tat on youl blank worksheet page, ot you can soloct Data Saube in the bottom lett thand comer. Nout, sethet Micionst Ecect in the list of cannection sources You wil then solect the Excel data filo you just downlooded in your flile explonor. 2. Within the Slieetl tab, create a caiculatod field by either right choking anywisere in the blask space of ure Data pane and oblecting Create Caleulated Ficld of click the Amalybis tab and select Creote Caiculated Ficid thom the dropdomb imenu. Thtie the new variable "Direct Materials Putchase. Price variance" in the space for fornulas, multoply the actial amount purchased by the difference between the standard cost and actual cost of materlais purchased 3. Cresbe a calculated fieid by eather right ctiching anywhere in the blakk space of the Data pane and soleching Create Calculated Fleld or click the Analyes tab and select Create Calculated Field from the dogdown menu Fite the new valable "Direct anount used ty the standard cost of the used materiahi 4. Create a cakculated fiels by esther right clicking anywhere in the blank space of the Data pane and beiecting Create Calculated of direct laber and the actusi cost of airect iator. 5. Cleate a caicutated fietid by either fight chickimg armwhere in the blank space of the Dati pane and selecteng Create Caiculated Etficiency Variance" in the space for formulas, multiply the dafrerence between the atindard omolint at ditoct iabor and the actual amount of cerect labor by the standard cost of diest lation. 6. Either click the diopdown artow tham appears on the Momith attibute of High cliek the Moritis atibute Honer owe the Cnange Dati Type Option and select Pase in the list of options that appear. 7. Drag and diop month onte the Coiumas shelf Eather cosk the dropdown airow or fight click the Month attioute mat is now on the Columns stheif Seloct the first Morith opton that appears in the list of options. 8. Dong and drop Direct Materiats Parchase.Price Warance from the data pane vito the flows sheit 9. Drag and drop Direct Materinis tsoge Vatiance onto the Yoxm 10. Drag and drop Direct tabor Rine Voringe onte the Yhuil. 11. Deag and drop Beect Labor. Elficiency Varance orta the Yiaxia. Sove your fice, then answer the questions telew using the Tableau dasthboards you havo crovied. 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 cllcked. 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 incorrectl Check My Work is not enabled for this question.) Direct Materials Putchase.Pice Variance Direct Matertals Usage Variance Dioct Labor Rote Varionce Direct Labor Efficiency Varionce 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.) 2 Direct Materials Purchose-Price Varionce Direct Materials Usoge Voriance ? Drect Labor Rate Varionce Direct Labor Efficiency Variance