Assignment 6 (similar to Exercise 14-26) Summit Machinery Company uses aluminum to manufacture a product, XV-1....
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6658a7c90560e_1526658a7c8f0230.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6658a7c951143_1536658a7c94be6b.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6658a7c99e086_1536658a7c9994df.jpg)
Transcribed Image Text:
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: 1. 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. 2. Within the Sheet1 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. 3. 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. 4. 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. 5. 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. 6. 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. 7. 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. 8. Drag and drop Direct Materials Purchase-Price Variance from the data pane into the Rows shelf. 9. Drag and drop Direct Materials Usage Variance onto the Y-axis. 10. Drag and drop Direct Labor Rate Variance onto the Y-axis. 11. 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. 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: 1. 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. 2. Within the Sheet1 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. 3. 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. 4. 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. 5. 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. 6. 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. 7. 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. 8. Drag and drop Direct Materials Purchase-Price Variance from the data pane into the Rows shelf. 9. Drag and drop Direct Materials Usage Variance onto the Y-axis. 10. Drag and drop Direct Labor Rate Variance onto the Y-axis. 11. 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.
Expert Answer:
Related Book For
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr
Posted Date:
Students also viewed these accounting questions
-
An electron is accelerated through 2 400 V from rest and then enters a uniform 1.70-T magnetic field. What are? (a) The maximum and (b) The minimum values of the magnetic force this charge can...
-
Assessing the Choices in Declaring Personal Bankruptcy. What factors would you consider in assessing the choices in declaring personal bankruptcy? Why should personal bankruptcy be the choice of last...
-
Slopes Inc. manufactures and sells snowboards. Slopes manufacture a single model, the Pipex. In the summer of 2012, Slopess accountant gathered the following data to prepare budgets for 2013. These...
-
Flowers on Demand Co. has 200,000 shares outstanding and decides to buy back 3,000 shares at $10 each on February 20, 2020 Flowers then reissued 1,500 shares to the public on March 5, 2021 for 58...
-
1. What is the purpose of life insurance? Define the terms face amount, beneficiary, life insured, and policy owner. 2. Do you think that everyone needs health and/or life insurance? Explain. 3. With...
-
Moving Inc. wants to develop an activity flexible budget for the activity of moving materials. Moving Inc. uses forklifts to move materials from receiving to storeroom and then to production. The...
-
We are in the tail end of Quarter 3 earnings reporting season in the U.S. markets. Roughly 60 percent of companies that have reported their Q3 earnings so far have reported negative earnings relative...
-
Below is a running shock tube illustration. 0.1 0.0 | 0.0 4 4 Diaphragm 1 0.5 Image: Shock tube Initial setup 1 3 2 1 Expansion Head Expansion Tail Slip Shock Surface Image: Running Shock Tube...
-
As you may remember, Holiday Tree Services, Inc. (HTS) has recently entered into a contract with Delish Burger (Delish), whereby HTS is to supply and decorate a Christmas tree in each of Delish...
-
Understanding various types of leadership styles is important in order to determine personal leadership styles. Reflection: Answer both Compare and contrast 2 leadership styles. State the...
-
Hello! thank you so much for helping me, I really appreciate it. Below are the questions but I will also write them out: Statement: Crane Limited equipment on September 30,2018, for $41,120 cash. The...
-
Might this bizarre and dysfunctional situation have reasonably been anticipated?
-
Fan ownership is clearly viable in large clubs, as the German Bundesliga evidences. How might a Supporters Trust at a Premier League club, as for example in the cases of Manchester United and...
-
Investigate the ways that the IOC and/or FIFA are structured, and the ways in which they operate. Using the Grant and Koehne (2005) model of accountability mechanisms (see Table 2.6), evaluate their...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App